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

LIVESCORE / Partidos de Rusia del Viernes, 19 Abril 2024

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 19 ABR
Portugal Italia Irlanda Bielorusia Hungría Malta Azerbaiyán

  USO DE MEMORIA  
4,295,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.0344
Total Execution Time  0.0353
  CADENA URL  
/livescore/pais/rusia/dia/19042024
  GET DATOS  
$_GET['/livescore/pais/rusia/dia/19042024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (4)  
0.0019  SELECT z.name,z.alias,c.CountryCode,c.location,c.continent,c.top,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN zones z ON z.location = c.CountryCode WHERE z.alias = 'rusia' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0048  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE dt.main_image = 1 AND c.troncal = 1 AND l.year=c.active_year AND c.CountryCode = 'ru' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30
0.0020  SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches_history lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-29 18:24:00' ORDER BY lm.creation_date DESC LIMIT 8
0.0021  SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches_history lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.location != 'es' AND c.continent = 'eu' AND lm.creation_date > '2024-04-23 18:24:00' ORDER BY lm.creation_date DESC LIMIT 15