Ver jornada
Jornada 1
01 Ago 21 Sheffield WednesdaySheffield 0 - 0 Huddersfield TownHuddersfiel 21
10 Ago 21 Derby CountyDerby 3 - 3 Salford CitySalford 17
10 Ago 21 Hartlepool UnitedHartlepool 0 - 1 Crewe AlexandraCrewe 11
10 Ago 21 Shrewsbury TownShrewsbury 2 - 2 Lincoln CityLincoln 2
10 Ago 21 Mansfield TownMansfield 0 - 3 Preston North EndPreston 7
10 Ago 21 Port ValePort Vale 1 - 2 SunderlandSunderland 5
10 Ago 21 Sheffield UnitedSheffield 1 - 0 Carlisle UnitedCarlisle 9
11 Ago 21 BlackpoolBlackpool 3 - 0 MiddlesbroughMiddlesbrou 46
10 Ago 21 Harrogate TownHarrogate Apl RochdaleRochdale 3
10 Ago 21 Stoke CityStoke City 2 - 1 Fleetwood TownFleetwood 11
10 Ago 21 WalsallWalsall 0 - 0 Doncaster RoversDoncaster 2
10 Ago 21 Oldham Athletic AFCOldham 2 - 2 Tranmere RoversTranmere ...
10 Ago 21 Rotherham UnitedRotherham 1 - 2 Accrington StanleyAccrington ...
10 Ago 21 BarrowBarrow 1 - 0 Scunthorpe UnitedScunthorpe ...
10 Ago 21 Hull CityHull City 1 - 1 Wigan AthleticWigan 31
10 Ago 21 Bolton WanderersBolton 0 - 0 BarnsleyBarnsley 11
11 Ago 21 Nottingham ForestNottingham 2 - 1 Bradford CityBradford 37
10 Ago 21 Blackburn RoversBlackburn 1 - 2 MorecambeMorecambe 33
10 Ago 21 Cambridge UnitedCambridge 0 - 0 Swindon TownSwindon ...
10 Ago 21 Exeter CityExeter City 0 - 0 Wycombe WanderersWycombe 6
10 Ago 21 Crawley TownCrawley 2 - 2 GillinghamGillingham 2
11 Ago 21 Burton AlbionBurton 1 - 1 Oxford UnitedOxford 43
11 Ago 21 Coventry CityCoventry 1 - 2 NorthamptonNorthampton 17
10 Ago 21 Ipswich TownIpswich 0 - 1 Newport CountyNewport ...
10 Ago 21 Forest Green RoversForest 2 - 2 Bristol CityBristol ...
10 Ago 21 ReadingReading 0 - 3 Swansea CitySwansea 4
10 Ago 21 Cardiff CityCardiff 3 - 2 Sutton UnitedSutton 19
31 Jul 21 AFC BournemouthBournemouth 5 - 0 Milton Keynes DonsMilton 20
10 Ago 21 Bristol RoversBristol 0 - 2 Cheltenham TownCheltenham 1
10 Ago 21 Peterborough UnitedPeterboroug 0 - 4 Plymouth ArgylePlymouth 2
11 Ago 21 Leyton OrientLeyton 1 - 1 Queens Park RangersQueens Park 31
10 Ago 21 StevenageStevenage 2 - 2 Luton TownLuton Town 3
10 Ago 21 MillwallMillwall 2 - 1 PortsmouthPortsmouth 2
10 Ago 21 Birmingham CityBirmingham 1 - 0 Colchester UnitedColchester 9
10 Ago 21 Charlton AthleticCharlton 0 - 1 AFC WimbledonWimbledon 3
Ver jornada
Jornada 2
24 Ago 21 Oldham Athletic AFCOldham 0 - 0 Accrington StanleyAccrington 44
25 Ago 21 NewcastleNewcastle 0 - 0 BurnleyBurnley 314
24 Ago 21 Wigan AthleticWigan 0 - 0 Bolton WanderersBolton 15
24 Ago 21 Huddersfield TownHuddersfiel 1 - 2 EvertonEverton 136
24 Ago 21 Sheffield UnitedSheffield 2 - 1 Derby CountyDerby 29
24 Ago 21 Stoke CityStoke City 2 - 0 Doncaster RoversDoncaster 8
24 Ago 21 Shrewsbury TownShrewsbury 0 - 2 RochdaleRochdale 3
24 Ago 21 Nottingham ForestNottingham 0 - 4 WolvesWolves 33
24 Ago 21 MorecambeMorecambe 2 - 4 Preston North EndPreston 8
24 Ago 21 BlackpoolBlackpool 2 - 3 SunderlandSunderland 12
24 Ago 21 Leeds UnitedLeeds 3 - 0 Crewe AlexandraCrewe 109
24 Ago 21 BarrowBarrow 0 - 6 Aston VillaAston Villa 13
24 Ago 21 BrentfordBrentford 3 - 1 Forest Green RoversForest 74
24 Ago 21 MillwallMillwall 3 - 1 Cambridge UnitedCambridge 6
25 Ago 21 West Bromwich AlbionWest 0 - 6 ArsenalArsenal 113
24 Ago 21 Norwich CityNorwich 6 - 0 AFC BournemouthBournemouth 132
24 Ago 21 Cardiff CityCardiff 0 - 2 Brighton & Hove AlbionBrighton 25
24 Ago 21 Birmingham CityBirmingham 0 - 2 FulhamFulham 63
24 Ago 21 GillinghamGillingham 1 - 1 Cheltenham TownCheltenham 7
24 Ago 21 Queens Park RangersQueens Park 2 - 0 Oxford UnitedOxford 8
24 Ago 21 Swansea CitySwansea 4 - 1 Plymouth ArgylePlymouth 75
24 Ago 21 StevenageStevenage 2 - 2 Wycombe WanderersWycombe 17
25 Ago 21 Newport CountyNewport 0 - 8 SouthamptonSouthampton 49
24 Ago 21 NorthamptonNorthampton 0 - 1 AFC WimbledonWimbledon 16
24 Ago 21 WatfordWatford 1 - 0 Crystal PalaceCrystal 77
Ver jornada
Jornada 3
21 Sep 21 Queens Park RangersQueens Park 2 - 2 EvertonEverton 253
21 Sep 21 Preston North EndPreston 4 - 1 Cheltenham TownCheltenham 9
22 Sep 21 Manchester UnitedManchester 0 - 1 West HamWest Ham 489
21 Sep 21 FulhamFulham 0 - 0 Leeds UnitedLeeds 142
21 Sep 21 BrentfordBrentford 7 - 0 Oldham Athletic AFCOldham 11
21 Sep 21 WatfordWatford 1 - 3 Stoke CityStoke City 106
22 Sep 21 ChelseaChelsea 1 - 1 Aston VillaAston Villa 169
21 Sep 21 Wigan AthleticWigan 0 - 2 SunderlandSunderland 21
21 Sep 21 Norwich CityNorwich 0 - 3 LiverpoolLiverpool 76
21 Sep 21 BurnleyBurnley 4 - 1 RochdaleRochdale 78
22 Sep 21 ArsenalArsenal 3 - 0 AFC WimbledonWimbledon 38
21 Sep 21 Sheffield UnitedSheffield 2 - 2 SouthamptonSouthampton 42
21 Sep 21 Manchester CityManchester 6 - 1 Wycombe WanderersWycombe 85
22 Sep 21 MillwallMillwall 0 - 2 LeicesterLeicester 86
22 Sep 21 WolvesWolves 2 - 2 Tottenham HotspurTottenham 64
22 Sep 21 Brighton & Hove AlbionBrighton 2 - 0 Swansea CitySwansea 41
Ver jornada
Jornada 4
27 Oct 21 Preston North EndPreston 0 - 2 LiverpoolLiverpool 121
26 Oct 21 ChelseaChelsea 1 - 1 SouthamptonSouthampton 641
26 Oct 21 Queens Park RangersQueens Park 0 - 0 SunderlandSunderland 88
26 Oct 21 ArsenalArsenal 2 - 0 Leeds UnitedLeeds 194
27 Oct 21 BurnleyBurnley 0 - 1 Tottenham HotspurTottenham 48
27 Oct 21 LeicesterLeicester 2 - 2 Brighton & Hove AlbionBrighton 99
27 Oct 21 Stoke CityStoke City 1 - 2 BrentfordBrentford 16
27 Oct 21 West HamWest Ham 0 - 0 Manchester CityManchester 224
Ver jornada
Jornada 5
22 Dic 21 Tottenham HotspurTottenham 2 - 1 West HamWest Ham 89
22 Dic 21 BrentfordBrentford 0 - 2 ChelseaChelsea 231
21 Dic 21 ArsenalArsenal 5 - 1 SunderlandSunderland 120
22 Dic 21 LiverpoolLiverpool 3 - 3 LeicesterLeicester 627
Ver jornada
Jornada 6
05 Ene 22 ChelseaChelsea 2 - 0 Tottenham HotspurTottenham 470
20 Ene 22 ArsenalArsenal 0 - 2 LiverpoolLiverpool 473
12 Ene 22 Tottenham HotspurTottenham 0 - 1 ChelseaChelsea 447
13 Ene 22 LiverpoolLiverpool 0 - 0 ArsenalArsenal 639
Ver jornada
Jornada 7
27 Feb 22 ChelseaChelsea 0 - 0 LiverpoolLiverpool 673

  USO DE MEMORIA  
4,973,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3310
Total Execution Time  0.3329
  CADENA URL  
/capital_one_cup2022/grupo0/calendario
  GET DATOS  
$_GET['/capital_one_cup2022/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0106  SELECT type FROM routes WHERE alias = 'capital_one_cup2022'
0.0213  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=523 AND type_rel = 3
0.0121  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 523 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0109  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1303703,1303683,1303702,1303025,1299029) ORDER BY n.cover_points DESC, update_date DESC
0.0115  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 = 63189 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0121  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63189 ORDER BY round ASC
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-19 09:06:45' 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=2 AND last_update > '2024-04-19 09:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-19 09:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-19 09:06:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2022
0.0108  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63189) 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.0109  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 (63189) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (341389,426863,13214,191712,206668,362786,427872,101801,213948,227208) ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2022
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63189) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  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 (63189) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (47065,139111,216486,247629,321025,427571,427862,978557,415,490) ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2022
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (63189) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0114  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 (63189) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (67187,139111,203963,290250,307752,309153,391760,798324) ORDER BY rp.in_squad = 1 DESC