4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
05 Sep 20 Tranmere RoversTranmere 1 - 1 Harrogate TownHarrogate 1
05 Sep 20 Crewe AlexandraCrewe 1 - 2 Lincoln CityLincoln 3
05 Sep 20 WalsallWalsall 0 - 0 Sheffield WednesdaySheffield 7
29 Ago 20 Preston North EndPreston 4 - 0 Mansfield TownMansfield 6
05 Sep 20 Bolton WanderersBolton 1 - 2 Bradford CityBradford 2
29 Ago 20 Blackburn RoversBlackburn 3 - 2 Doncaster RoversDoncaster 6
29 Ago 20 Stoke CityStoke City 0 - 0 BlackpoolBlackpool 24
05 Sep 20 Fleetwood TownFleetwood 3 - 2 Wigan AthleticWigan 31
05 Sep 20 Grimsby TownGrimsby 1 - 1 MorecambeMorecambe 9
04 Sep 20 MiddlesbroughMiddlesbrou 4 - 3 Shrewsbury TownShrewsbury 39
05 Sep 20 Derby CountyDerby 0 - 0 BarrowBarrow 39
05 Sep 20 Scunthorpe UnitedScunthorpe 1 - 2 Port ValePort Vale 2
05 Sep 20 SunderlandSunderland 0 - 0 Hull CityHull City 10
04 Sep 20 Burton AlbionBurton 1 - 1 Accrington StanleyAccrington 12
05 Sep 20 Salford CitySalford 1 - 1 Rotherham UnitedRotherham ...
05 Sep 20 BarnsleyBarnsley 1 - 0 Nottingham ForestNottingham 9
05 Sep 20 Oldham Athletic AFCOldham 3 - 0 Carlisle UnitedCarlisle 1
05 Sep 20 Bristol CityBristol 2 - 0 Exeter CityExeter City 4
05 Sep 20 Plymouth ArgylePlymouth 3 - 2 Queens Park RangersQueens Park 3
05 Sep 20 Swindon TownSwindon 1 - 3 Charlton AthleticCharlton 1
05 Sep 20 Forest Green RoversForest 1 - 2 Leyton OrientLeyton ...
05 Sep 20 Milton Keynes DonsMilton 0 - 1 Coventry CityCoventry ...
05 Sep 20 Crawley TownCrawley 1 - 3 MillwallMillwall 1
29 Ago 20 StevenageStevenage 3 - 3 PortsmouthPortsmouth 26
05 Sep 20 Peterborough UnitedPeterboroug 0 - 1 Cheltenham TownCheltenham 6
06 Sep 20 BrentfordBrentford 1 - 1 Wycombe WanderersWycombe 13
05 Sep 20 NorthamptonNorthampton 3 - 0 Cardiff CityCardiff 2
05 Sep 20 Luton TownLuton Town 3 - 1 Norwich CityNorwich 14
05 Sep 20 Birmingham CityBirmingham 0 - 1 Cambridge UnitedCambridge 5
05 Sep 20 Newport CountyNewport 2 - 0 Swansea CitySwansea 12
05 Sep 20 Oxford UnitedOxford 1 - 1 AFC WimbledonWimbledon ...
05 Sep 20 ReadingReading 3 - 1 Colchester UnitedColchester 7
05 Sep 20 GillinghamGillingham 1 - 0 Southend UnitedSouthend 3
05 Sep 20 Ipswich TownIpswich 3 - 0 Bristol RoversBristol ...
05 Sep 20 Huddersfield TownHuddersfiel 0 - 1 RochdaleRochdale ...
Ver jornada
Jornada 2
17 Sep 20 BurnleyBurnley 1 - 1 Sheffield UnitedSheffield 31
15 Sep 20 Burton AlbionBurton 1 - 3 Aston VillaAston Villa 48
15 Sep 20 Bradford CityBradford 0 - 5 Lincoln CityLincoln 8
16 Sep 20 Leeds UnitedLeeds 1 - 1 Hull CityHull City 143
16 Sep 20 EvertonEverton 3 - 0 Salford CitySalford 46
17 Sep 20 WolvesWolves 0 - 1 Stoke CityStoke City 170
15 Sep 20 RochdaleRochdale 0 - 2 Sheffield WednesdaySheffield 18
16 Sep 20 West Bromwich AlbionWest 3 - 0 Harrogate TownHarrogate 14
15 Sep 20 MiddlesbroughMiddlesbrou 0 - 2 BarnsleyBarnsley 31
15 Sep 20 Derby CountyDerby 1 - 2 Preston North EndPreston 28
15 Sep 20 NewcastleNewcastle 1 - 0 Blackburn RoversBlackburn 34
15 Sep 20 MorecambeMorecambe 1 - 0 Oldham Athletic AFCOldham 10
15 Sep 20 Fleetwood TownFleetwood 2 - 1 Port ValePort Vale 2
15 Sep 20 West HamWest Ham 3 - 0 Charlton AthleticCharlton 13
16 Sep 20 Ipswich TownIpswich 0 - 1 FulhamFulham 36
15 Sep 20 Oxford UnitedOxford 1 - 1 WatfordWatford 43
15 Sep 20 AFC BournemouthBournemouth 0 - 0 Crystal PalaceCrystal 42
15 Sep 20 Leyton OrientLeyton 3 - 2 Plymouth ArgylePlymouth 8
16 Sep 20 SouthamptonSouthampton 0 - 2 BrentfordBrentford 42
16 Sep 20 Bristol CityBristol 4 - 0 NorthamptonNorthampton 10
15 Sep 20 ReadingReading 0 - 1 Luton TownLuton Town 48
15 Sep 20 MillwallMillwall 3 - 1 Cheltenham TownCheltenham 16
17 Sep 20 Brighton & Hove AlbionBrighton 4 - 0 PortsmouthPortsmouth 17
15 Sep 20 Newport CountyNewport 1 - 0 Cambridge UnitedCambridge 4
15 Sep 20 GillinghamGillingham 1 - 1 Coventry CityCoventry 11
Ver jornada
Jornada 3
23 Sep 20 LeicesterLeicester 0 - 2 ArsenalArsenal 270
22 Sep 20 Leyton OrientLeyton 0 - 3 Tottenham HotspurTottenham 35
22 Sep 20 West Bromwich AlbionWest 2 - 2 BrentfordBrentford 69
22 Sep 20 Newport CountyNewport 3 - 1 WatfordWatford 117
22 Sep 20 West HamWest Ham 5 - 1 Hull CityHull City 46
22 Sep 20 Luton TownLuton Town 0 - 3 Manchester UnitedManchester 125
23 Sep 20 Preston North EndPreston 0 - 2 Brighton & Hove AlbionBrighton 59
23 Sep 20 MillwallMillwall 0 - 2 BurnleyBurnley 64
23 Sep 20 Stoke CityStoke City 1 - 0 GillinghamGillingham 30
23 Sep 20 MorecambeMorecambe 0 - 7 NewcastleNewcastle 62
23 Sep 20 FulhamFulham 2 - 0 Sheffield WednesdaySheffield 50
23 Sep 20 Fleetwood TownFleetwood 2 - 5 EvertonEverton 61
23 Sep 20 ChelseaChelsea 6 - 0 BarnsleyBarnsley 59
24 Sep 20 Bristol CityBristol 0 - 3 Aston VillaAston Villa 42
24 Sep 20 Lincoln CityLincoln 2 - 7 LiverpoolLiverpool 61
24 Sep 20 Manchester CityManchester 2 - 1 AFC BournemouthBournemouth 149
Ver jornada
Jornada 4
01 Oct 20 LiverpoolLiverpool 0 - 0 ArsenalArsenal 170
01 Oct 20 Aston VillaAston Villa 0 - 1 Stoke CityStoke City 85
01 Oct 20 BrentfordBrentford 3 - 0 FulhamFulham 68
30 Sep 20 Brighton & Hove AlbionBrighton 0 - 3 Manchester UnitedManchester 77
30 Sep 20 BurnleyBurnley 0 - 3 Manchester CityManchester 57
30 Sep 20 EvertonEverton 4 - 1 West HamWest Ham 114
30 Sep 20 Newport CountyNewport 1 - 1 NewcastleNewcastle 147
29 Sep 20 Tottenham HotspurTottenham 1 - 1 ChelseaChelsea 262
Ver jornada
Jornada 5
23 Dic 20 Stoke CityStoke City 1 - 3 Tottenham HotspurTottenham 83
22 Dic 20 BrentfordBrentford 1 - 0 NewcastleNewcastle 63
22 Dic 20 ArsenalArsenal 1 - 4 Manchester CityManchester 99
23 Dic 20 EvertonEverton 0 - 2 Manchester UnitedManchester 151
Ver jornada
Jornada 6
06 Ene 21 Manchester UnitedManchester 0 - 2 Manchester CityManchester 348
05 Ene 21 Tottenham HotspurTottenham 2 - 0 BrentfordBrentford 169
Ver jornada
Jornada 7
25 Abr 21 Manchester CityManchester 1 - 0 Tottenham HotspurTottenham 248

  USO DE MEMORIA  
4,926,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3651
Total Execution Time  0.3670
  CADENA URL  
/capital_one_cup2021/grupo0/calendario
  GET DATOS  
$_GET['/capital_one_cup2021/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0128  SELECT type FROM routes WHERE alias = 'capital_one_cup2021'
0.0264  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'capital_one_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=10 ORDER BY order_id ASC
0.0148  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58495 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2021 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 58495 ORDER BY round ASC
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 12:28:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 12:28:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 12:28:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 12:28:00' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2021
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (58495) 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, e.player_id ASC LIMIT 10
0.0130  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (58495) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (140352,366112,186575,231392,251613,279897,320354,699071,595,2900) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2021
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (58495) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0131  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (58495) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (205024,157,24042,86324,100581,125416,136588,143590,163527,205559) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2021
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events2021 e WHERE e.league_id IN (58495) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (58495) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (69885,89123,200600,205024,245858,284644,373985) ORDER BY rp.in_squad = 1 DESC