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 Kluczbork Kluczbork 34 44 30 59
2 Zagłębie Sosnowiec Zagłębie 34 53 37 58
3 Rozwoj Katowice Rozwoj 34 54 40 57
4 Raków Częstochowa Raków 34 43 34 57
5 Energetyk ROW Rybnik Energetyk 34 52 37 56
6 Stargard Szczeciński Stargard 34 46 42 55
7 Stal Stalowa Wola Stal Stalowa 34 54 41 54
8 Stal Mielec Stal Mielec 34 49 42 52
9 Znicz Pruszkow Znicz 34 40 35 46
10 Nadwiślan Góra Nadwiślan 34 49 52 45
11 KS Legionovia Legionowo Legionovia 34 48 48 42
12 Siarka Tarnobrzeg Siarka 34 41 51 41
13 Wisla Pulawy Wisla Pulawy 34 45 54 39
14 Brzesko Brzesko 34 32 43 39
15 Puszcza Niepolomice Puszcza 34 37 43 36
16 Kotwica Kołobrzeg Kotwica 34 45 51 35
17 Górnik Wałbrzych Górnik 34 30 57 30
18 Limanovia Limanowa Limanovia 34 30 55 27

  USO DE MEMORIA  
5,298,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1213
Total Execution Time  0.1232
  CADENA URL  
/2_league_polonia2015/grupo1/resumen/34
  GET DATOS  
$_GET['/2_league_polonia2015/grupo1/resumen/34']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0022  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 380 GROUP BY l.categoryId
0.0021  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=380 GROUP BY l.year ORDER BY l.year DESC
0.0030  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 `calendars2015` 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` = 4480 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0098  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 `events2015` e INNER JOIN calendars2015 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 4480 ORDER BY total DESC LIMIT 100
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 00:37:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 00:37:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 00:37:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 00:37:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0334  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 events2015 e ON e.player_id = p.id AND e.league_id = 4480 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4480 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.0215  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 events2015 e ON e.player_id = p.id AND e.league_id = 4480 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4480 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0035  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 events2015 e ON e.player_id = p.id AND e.league_id = 4480 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 4480 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 4480 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC