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

LIVESCORE / Partidos de España

TODO ESPAÑA TOP EUROPA AMERICA ASIA Y OCEANIA AFRICA AYER HOY MAÑANA 6 MAY

Partidos Sábado, 04 Mayo 2024

España

LIGAS / COMPETICIONES

Nombre Datos
LIGAS
Primera División es Primera División 34/38 Hoy
COMPETICIONES
Copa de la Reina es Copa de la Reina 7/7 En 13 días
Publicidad 600x120.gif

PRENSA DEL DÍA

Ver toda la prensa de hoy

  USO DE MEMORIA  
6,281,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Livescore / Index )  0.0748
Total Execution Time  0.0758
  CADENA URL  
/livescore/pais/espana
  GET DATOS  
$_GET['/livescore/pais/espana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (3)  
0.0029  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 = 'espana' AND c.troncal = 1 GROUP BY c.CountryCode ORDER BY cuenta DESC
0.0019  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 lm.creation_date > '2024-05-03 07:11:58' ORDER BY lm.creation_date DESC LIMIT 8
0.0019  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 lm.creation_date > '2024-04-27 07:11:58' ORDER BY lm.creation_date DESC LIMIT 15