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

Clasificación

Equipo PJ GF GC Puntos
1 Rumanía Rumanía 10 18 9 21
2 Francia Francia 10 22 2 20
3 Eslovaquia Eslovaquia 10 14 18 14
4 Polonia Polonia 10 14 12 13
5 Israel Israel 10 13 13 12
6 Azerbaiyán Azerbaiyán 10 2 29 1
7 España España 10 25 4 26
8 Dinamarca Dinamarca 10 19 9 21
9 Bélgica Bélgica 10 17 13 15
10 Macedonia del Norte Macedonia 10 9 18 7
11 Chipre Chipre 10 6 20 7
12 Armenia Armenia 10 5 17 5
13 Suiza Suiza 8 15 7 17
14 Turquía Turquía 8 16 8 15
15 Suecia Suecia 8 9 10 9
16 Hungría Hungría 8 7 13 8
17 Islandia Islandia 8 3 12 5
18 Croacia Croacia 10 22 5 23
19 Italia Italia 10 20 6 23
20 Lituania Lituania 10 13 12 16
21 Ucrania Ucrania 10 11 15 13
22 Eslovenia Eslovenia 10 13 13 11
23 Estonia Estonia 10 3 31 0
24 República Checa República 10 21 6 21
25 Países Bajos Países 10 23 5 20
26 Noruega Noruega 10 17 7 20
27 Bielorrusia Bielorrusia 10 8 13 11
28 Luxemburgo Luxemburgo 10 3 21 10
29 Malta Malta 10 2 22 2
30 Portugal Portugal 10 29 7 23
31 Irlanda Irlanda 10 17 11 17
32 Irlanda del Norte Irlanda 10 20 15 17
33 Austria Austria 10 29 14 16
34 Letonia Letonia 10 11 20 12
35 Liechtenstein Liechtenstei 10 1 40 1
36 Alemania Alemania 10 27 10 25
37 Bulgaria Bulgaria 10 24 10 22
38 Georgia Georgia 10 14 13 15
39 Moldavia Moldavia 10 11 27 9
40 Albania Albania 10 10 16 8
41 Gales Gales 10 9 19 8
42 Rusia Rusia 10 34 5 26
43 Escocia Escocia 10 19 3 23
44 Grecia Grecia 10 23 9 18
45 Finlandia Finlandia 10 18 18 15
46 Islas Feroe Islas Feroe 10 10 35 6
47 San Marino San Marino 10 2 36 0

  USO DE MEMORIA  
6,387,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4729
Total Execution Time  0.4748
  CADENA URL  
/clasificacion_eurocopa1994/grupo1/resumen/23
  GET DATOS  
$_GET['/clasificacion_eurocopa1994/grupo1/resumen/23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0147  SELECT type FROM routes WHERE alias = 'clasificacion_eurocopa1994'
0.0302  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_eurocopa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1994 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0167  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 = 37822 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0163  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 FROM `calendars1994` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 37822 AND c.`round` = 23 ORDER BY shedule ASC LIMIT 200
0.0199  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1994` e INNER JOIN calendars1994 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 23 AND e.real_date IS NOT NULL AND e.league_id = 37822 ORDER BY total DESC LIMIT 100
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 16:41:26' 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=2 AND last_update > '2024-05-08 16:41:26' 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-08 16:41:26' 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-05-08 16:41:26' 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 = 'clasificacion_eurocopa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1994 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 1994
0.0212  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (37822,37823) 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.0149  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 (37822,37823) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258363,252215,258493,265147,258810,264570,264813,266475,394355,287) ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 1994
0.0177  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (37822,37823) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0151  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 (37822,37823) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (257942,258323,258943,265173,265353,266170,353862,354366,354545,398493) ORDER BY rp.in_squad = 1 DESC
0.0147  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 142 AND l.year = 1994
0.0173  SELECT e.action, count(e.action) as total, e.player_id FROM events1994 e WHERE e.league_id IN (37822,37823) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0151  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 (37822,37823) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (734,5779,53905,252473,258218,258245,265965,266657,267429,329631) ORDER BY rp.in_squad = 1 DESC
0.0368  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1994` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 37822 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC