4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Fichajes

RB Leipzig

Mallorca

Atlético

Arsenal

Argentinos Juniors Inter Miami

Inter Miami ficha a F. Redondo procedente del Argentinos Juniors por 7.5 millones

Traspaso
Atl. Mineiro

Atl. Mineiro Grêmio

Grêmio ficha a Cristian Pavón procedente del Atl. Mineiro por 3.5 millones

Traspaso
Atalanta Orlando City

Orlando City ficha a Luis Muriel procedente del Atalanta por 1 millones

Traspaso
Agente libre Grêmio

Diego Costa llega libre al Grêmio

Agente libre


  USO DE MEMORIA  
9,794,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Budget / Index )  0.2425
Total Execution Time  0.2437
  CADENA URL  
/fichajes/muro
  GET DATOS  
$_GET['/fichajes/muro']  
$_GET['league']  
$_GET['limit']  
$_GET['id']  
$_GET['competitions']  
$_GET['category']  
$_GET['teams']  
$_GET['v']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (3)  
0.0025   SELECT dt.id as teamId, t.id as id, dt.nameShow as name, dt.basealias as alias, c.name as category_name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.`id`=t.`teamId` INNER JOIN `leagues` as l ON l.id=t.`league_id` INNER JOIN `categories` as c ON l.`categoryId`=c.`id` WHERE c.`alias` LIKE 'primera' AND l.`year`='2024'
0.0024   SELECT dt.id as teamId, t.id as id, dt.nameShow as name, dt.basealias as alias, c.name as category_name FROM `teams` as t INNER JOIN `datateams` as dt ON dt.`id`=t.`teamId` INNER JOIN `leagues` as l ON l.id=t.`league_id` INNER JOIN `categories` as c ON l.`categoryId`=c.`id` WHERE c.`alias` LIKE 'segunda' AND l.`year`='2024'
0.1035  SELECT c.id, c.name, l.group_code, l.total_group, c.CountryCode, c.alias , c.transfer_market FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId WHERE l.year=c.active_year AND c.troncal=1 GROUP BY c.id ORDER BY c.coefficient DESC, c.name ASC