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

Cruce de partidos Premier League 2 Division One - Todos los partidos de la temporada

IdaVuelta
 Chelsea Sub 21 Everton Sub 21 Arsenal Sub 21 Wolves Sub 21 Fulham Sub 21 West Ham Sub 21 Aston Villa Sub 21 Brighton & Hove Sub 21 Man. City Sub 21 Newcastle Sub 21 Liverpool Sub 21 Man. Utd Sub 21 Leicester Sub 21 Southampton Sub 21 Blackburn Rovers Sub 21 Sunderland Sub 21 Tottenham Hotspur Sub 21 Stoke City Sub 21 Norwich City Sub 21 West Bromwich Sub 21 Crystal Palace Sub 21 Middlesbrough Sub 21 Reading Sub 21 Nottingham Forest Sub 21 Derby County Sub 21 Leeds United Sub 21
Chelsea Sub 21 Chelsea Sub 21
Everton Sub 21 Everton Sub 21
Arsenal Sub 21 Arsenal Sub 21
Wolves Sub 21 Wolves Sub 21
Fulham Sub 21 Fulham Sub 21
West Ham Sub 21 West Ham Sub 21
Aston Villa Sub 21 Aston Villa Sub 21
Brighton & Hove Sub 21 Brighton & Hove Sub 21
Man. City Sub 21 Man. City Sub 21
Newcastle Sub 21 Newcastle Sub 21
Liverpool Sub 21 Liverpool Sub 21
Man. Utd Sub 21 Man. Utd Sub 21
Leicester Sub 21 Leicester Sub 21
Southampton Sub 21 Southampton Sub 21
Blackburn Rovers Sub 21 Blackburn Rovers Sub 21
Sunderland Sub 21 Sunderland Sub 21
Tottenham Hotspur Sub 21 Tottenham Hotspur Sub 21
Stoke City Sub 21 Stoke City Sub 21
Norwich City Sub 21 Norwich City Sub 21
West Bromwich Sub 21 West Bromwich Sub 21
Crystal Palace Sub 21 Crystal Palace Sub 21
Middlesbrough Sub 21 Middlesbrough Sub 21
Reading Sub 21 Reading Sub 21
Nottingham Forest Sub 21 Nottingham Forest Sub 21
Derby County Sub 21 Derby County Sub 21
Leeds United Sub 21 Leeds United Sub 21

  USO DE MEMORIA  
6,804,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.3644
Total Execution Time  0.3678
  CADENA URL  
/premier_league_2_division_one2024/grupo1/cruces
  GET DATOS  
$_GET['/premier_league_2_division_one2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0144  SELECT type FROM routes WHERE alias = 'premier_league_2_division_one2024'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_one' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1977 ORDER BY order_id ASC
0.0153  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='73415' ORDER BY c.id ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 14:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 14:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 14:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 14:39:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_one' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0261  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 = 73415 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73415 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.0279  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 = 73415 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73415 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0153  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 = 73415 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73415 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10