4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
10 Ago 22 Blackburn RoversBlackburn 4 - 0 Hartlepool UnitedHartlepool 44
09 Ago 22 Harrogate TownHarrogate 0 - 1 Stockport CountyStockport 9
09 Ago 22 Bolton WanderersBolton 5 - 1 Salford CitySalford 9
09 Ago 22 MorecambeMorecambe 0 - 0 Stoke CityStoke City 46
09 Ago 22 BlackpoolBlackpool 0 - 0 BarrowBarrow 12
11 Ago 22 West Bromwich AlbionWest 1 - 0 Sheffield UnitedSheffield 146
10 Ago 22 Sheffield WednesdaySheffield 2 - 0 SunderlandSunderland 67
09 Ago 22 Grimsby TownGrimsby 4 - 0 Crewe AlexandraCrewe 1
09 Ago 22 Mansfield TownMansfield 1 - 2 Derby CountyDerby 3
09 Ago 22 Accrington StanleyAccrington 2 - 2 Tranmere RoversTranmere 3
10 Ago 22 MiddlesbroughMiddlesbrou 0 - 1 BarnsleyBarnsley 152
09 Ago 22 Bradford CityBradford 2 - 1 Hull CityHull City 14
09 Ago 22 RochdaleRochdale 2 - 0 Burton AlbionBurton 2
09 Ago 22 Doncaster RoversDoncaster 0 - 3 Lincoln CityLincoln 1
09 Ago 22 Huddersfield TownHuddersfiel 1 - 4 Preston North EndPreston 7
09 Ago 22 Shrewsbury TownShrewsbury 3 - 2 Carlisle UnitedCarlisle 10
10 Ago 22 Port ValePort Vale 1 - 2 Rotherham UnitedRotherham 14
09 Ago 22 Fleetwood TownFleetwood 1 - 0 Wigan AthleticWigan 3
09 Ago 22 Norwich CityNorwich 2 - 2 Birmingham CityBirmingham 7
10 Ago 22 Coventry CityCoventry 1 - 4 Bristol CityBristol 47
09 Ago 22 NorthamptonNorthampton 1 - 2 Wycombe WanderersWycombe 5
09 Ago 22 Cardiff CityCardiff 0 - 3 PortsmouthPortsmouth 11
09 Ago 22 Charlton AthleticCharlton 1 - 1 Queens Park RangersQueens Park 4
09 Ago 22 Crawley TownCrawley 1 - 0 Bristol RoversBristol ...
09 Ago 22 WalsallWalsall 2 - 0 Swindon TownSwindon ...
09 Ago 22 Ipswich TownIpswich 0 - 1 Colchester UnitedColchester 14
09 Ago 22 Luton TownLuton Town 2 - 3 Newport CountyNewport ...
09 Ago 22 ReadingReading 1 - 2 StevenageStevenage 18
10 Ago 22 Plymouth ArgylePlymouth 0 - 2 Peterborough UnitedPeterboroug 44
09 Ago 22 AFC WimbledonWimbledon 0 - 2 GillinghamGillingham 11
09 Ago 22 Cheltenham TownCheltenham 0 - 7 Exeter CityExeter City 9
09 Ago 22 Milton Keynes DonsMilton 1 - 0 Sutton UnitedSutton ...
09 Ago 22 Forest Green RoversForest 2 - 0 Leyton OrientLeyton 1
02 Ago 22 Cambridge UnitedCambridge 1 - 0 MillwallMillwall 98
09 Ago 22 Oxford UnitedOxford 2 - 2 Swansea CitySwansea 4
Ver jornada
Jornada 2
23 Ago 22 Bolton WanderersBolton 1 - 4 Aston VillaAston Villa 67
23 Ago 22 WolvesWolves 2 - 1 Preston North EndPreston 42
24 Ago 22 Leeds UnitedLeeds 3 - 1 BarnsleyBarnsley 120
23 Ago 22 Fleetwood TownFleetwood 0 - 1 EvertonEverton 40
23 Ago 22 Sheffield WednesdaySheffield 3 - 0 RochdaleRochdale 25
24 Ago 22 Tranmere RoversTranmere 1 - 2 NewcastleNewcastle 241
23 Ago 22 Rotherham UnitedRotherham 0 - 1 MorecambeMorecambe 27
23 Ago 22 BarrowBarrow 2 - 2 Lincoln CityLincoln 13
23 Ago 22 Stockport CountyStockport 0 - 0 LeicesterLeicester 290
23 Ago 22 Bradford CityBradford 1 - 2 Blackburn RoversBlackburn 10
23 Ago 22 Grimsby TownGrimsby 0 - 3 Nottingham ForestNottingham 9
23 Ago 22 Shrewsbury TownShrewsbury 0 - 1 BurnleyBurnley 45
23 Ago 22 StevenageStevenage 1 - 0 Peterborough UnitedPeterboroug 5
23 Ago 22 Norwich CityNorwich 2 - 2 AFC BournemouthBournemouth 46
23 Ago 22 Newport CountyNewport 3 - 2 PortsmouthPortsmouth 13
23 Ago 22 Oxford UnitedOxford 0 - 2 Crystal PalaceCrystal 93
23 Ago 22 WatfordWatford 0 - 2 Milton Keynes DonsMilton 74
23 Ago 22 Colchester UnitedColchester 0 - 2 BrentfordBrentford 40
24 Ago 22 Wycombe WanderersWycombe 1 - 3 Bristol CityBristol 77
23 Ago 22 WalsallWalsall 0 - 1 Charlton AthleticCharlton 111
23 Ago 22 Crawley TownCrawley 2 - 0 FulhamFulham 164
23 Ago 22 Cambridge UnitedCambridge 0 - 3 SouthamptonSouthampton 25
23 Ago 22 GillinghamGillingham 0 - 0 Exeter CityExeter City 5
24 Ago 22 Forest Green RoversForest 0 - 3 Brighton & Hove AlbionBrighton 136
23 Ago 22 Derby CountyDerby 1 - 0 West Bromwich AlbionWest 34
Ver jornada
Jornada 3
08 Nov 22 LeicesterLeicester 3 - 0 Newport CountyNewport 135
09 Nov 22 West HamWest Ham 2 - 2 Blackburn RoversBlackburn 270
09 Nov 22 WolvesWolves 1 - 0 Leeds UnitedLeeds 85
09 Nov 22 Nottingham ForestNottingham 2 - 0 Tottenham HotspurTottenham 211
10 Nov 22 Manchester UnitedManchester 4 - 2 Aston VillaAston Villa 535
08 Nov 22 AFC BournemouthBournemouth 4 - 1 EvertonEverton 103
09 Nov 22 LiverpoolLiverpool 0 - 0 Derby CountyDerby 540
08 Nov 22 BurnleyBurnley 3 - 1 Crawley TownCrawley 76
08 Nov 22 Bristol CityBristol 1 - 3 Lincoln CityLincoln 36
09 Nov 22 Manchester CityManchester 2 - 0 ChelseaChelsea 181
08 Nov 22 StevenageStevenage 1 - 1 Charlton AthleticCharlton 34
08 Nov 22 Milton Keynes DonsMilton 2 - 0 MorecambeMorecambe 20
09 Nov 22 NewcastleNewcastle 0 - 0 Crystal PalaceCrystal 219
09 Nov 22 SouthamptonSouthampton 1 - 1 Sheffield WednesdaySheffield 48
09 Nov 22 ArsenalArsenal 1 - 3 Brighton & Hove AlbionBrighton 335
08 Nov 22 BrentfordBrentford 1 - 1 GillinghamGillingham 102
Ver jornada
Jornada 4
20 Dic 22 WolvesWolves 2 - 0 GillinghamGillingham 274
20 Dic 22 SouthamptonSouthampton 2 - 1 Lincoln CityLincoln 116
21 Dic 22 Blackburn RoversBlackburn 1 - 4 Nottingham ForestNottingham 51
20 Dic 22 NewcastleNewcastle 1 - 0 AFC BournemouthBournemouth 280
22 Dic 22 Manchester CityManchester 3 - 2 LiverpoolLiverpool 814
21 Dic 22 Manchester UnitedManchester 2 - 0 BurnleyBurnley 217
20 Dic 22 Milton Keynes DonsMilton 0 - 3 LeicesterLeicester 48
21 Dic 22 Charlton AthleticCharlton 0 - 0 Brighton & Hove AlbionBrighton 147
Ver jornada
Jornada 5
10 Ene 23 Manchester UnitedManchester 3 - 0 Charlton AthleticCharlton 403
11 Ene 23 SouthamptonSouthampton 2 - 0 Manchester CityManchester 542
11 Ene 23 Nottingham ForestNottingham 1 - 1 WolvesWolves 199
10 Ene 23 NewcastleNewcastle 2 - 0 LeicesterLeicester 351
Ver jornada
Jornada 6
24 Ene 23 SouthamptonSouthampton 0 - 1 NewcastleNewcastle 550
31 Ene 23 NewcastleNewcastle 2 - 1 SouthamptonSouthampton 321
25 Ene 23 Nottingham ForestNottingham 0 - 3 Manchester UnitedManchester 422
01 Feb 23 Manchester UnitedManchester 2 - 0 Nottingham ForestNottingham 517
Ver jornada
Jornada 7
26 Feb 23 Manchester UnitedManchester 2 - 0 NewcastleNewcastle 432

  USO DE MEMORIA  
4,952,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4375
Total Execution Time  0.4394
  CADENA URL  
/capital_one_cup2023/grupo0/calendario
  GET DATOS  
$_GET['/capital_one_cup2023/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0144  SELECT type FROM routes WHERE alias = 'capital_one_cup2023'
0.0292  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 = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=523 AND type_rel = 3
0.0157  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.0147  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.0149  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 = 68038 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 calendars2023 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 68038 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 14:16:17' 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-05-09 14:16:17' 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-05-09 14:16:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 14:16:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2023
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (68038) 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.0148  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 (68038) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (284437,243396,131276,141992,208772,279940,839323,107197,149354,178191) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2023
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (68038) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0150  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 (68038) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (65830,92909,139415,158855,193339,194462,197936,203856,205021,250806) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 2023
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2023 e WHERE e.league_id IN (68038) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0148  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 (68038) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (56480,197936,250806,274939,364271,427775,726304,915147,1026504) ORDER BY rp.in_squad = 1 DESC