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

Cruce de partidos Primera Federación - Todos los partidos de la temporada

IdaVuelta
 RC Deportivo CE Sabadell Real Unión Club Gimnàstic Tarragona Cultural Leonesa Ponferradina CD Lugo Barça Atlètic CD Teruel Real Sociedad B Celta Fortuna Osasuna Promesas Fuenlabrada Rayo Majadahonda UE Cornellà Sestao River SD Tarazona Arenteiro SD Logroñés Unionistas CF
RC Deportivo RC Deportivo
CE Sabadell CE Sabadell
Real Unión Club Real Unión Club
Gimnàstic Tarragona Gimnàstic Tarragona
Cultural Leonesa Cultural Leonesa
Ponferradina Ponferradina
CD Lugo CD Lugo
Barça Atlètic Barça Atlètic
CD Teruel CD Teruel
Real Sociedad B Real Sociedad B
Celta Fortuna Celta Fortuna
Osasuna Promesas Osasuna Promesas
Fuenlabrada Fuenlabrada
Rayo Majadahonda Rayo Majadahonda
UE Cornellà UE Cornellà
Sestao River Sestao River
SD Tarazona SD Tarazona
Arenteiro Arenteiro
SD Logroñés SD Logroñés
Unionistas CF Unionistas CF

  USO DE MEMORIA  
7,042,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.2728
Total Execution Time  0.2759
  CADENA URL  
/primera_division_rfef2024/grupo1/cruces
  GET DATOS  
$_GET['/primera_division_rfef2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2468 AND type_rel = 3
0.0241  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='72358' ORDER BY c.id ASC
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:35:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 06:35:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:35:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:35:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0242  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72358 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72358 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0335  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72358 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72358 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0122  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72358 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72358 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10