4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Suwon Bluewings Suwon 8 15 7 18
2 FC Anyang FC Anyang 7 14 8 16
3 Busan I Park Busan Park 9 17 14 15
4 Chungbuk Cheongju Chungbuk 8 8 9 12
5 Seoul E-Land FC Seoul E-Land 8 15 9 11
6 Jeonnam Dragons Jeonnam 7 9 8 11
7 Gimpo FC Gimpo FC 8 8 11 11
8 Chungnam Asan FC Chungnam 9 12 15 10
9 Gyeongnam FC Gyeongnam 7 9 13 8
10 Bucheon FC 1995 Bucheon 1995 7 7 11 8
11 Ansan Greeners Ansan 8 8 10 7
12 Seongnam FC Seongnam FC 8 8 12 7
13 Cheonan City Cheonan City 8 11 14 6
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Gimcheon Sangmu FC Gimcheon 36 71 37 71
2 Busan I Park Busan Park 36 50 29 70
3 Gimpo FC Gimpo FC 36 40 25 60
4 Gyeongnam FC Gyeongnam 36 54 42 57
5 Bucheon FC 1995 Bucheon 1995 36 45 35 57
6 FC Anyang FC Anyang 36 58 51 54
7 Jeonnam Dragons Jeonnam 36 55 56 53
8 Chungbuk Cheongju Chungbuk 36 37 42 52
9 Seongnam FC Seongnam FC 36 43 50 44
10 Chungnam Asan FC Chungnam 36 39 46 42
11 Seoul E-Land FC Seoul E-Land 36 36 54 35
12 Ansan Greeners Ansan 36 40 72 25
13 Cheonan City Cheonan City 36 33 62 25
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Gwangju FC Gwangju FC 40 68 32 86
2 Daejeon Citizen Daejeon 40 70 45 74
3 FC Anyang FC Anyang 40 52 41 69
4 Bucheon FC 1995 Bucheon 1995 40 52 44 61
5 Gyeongnam FC Gyeongnam 40 60 61 56
6 Chungnam Asan FC Chungnam 40 39 44 52
7 Seoul E-Land FC Seoul E-Land 40 46 47 48
8 Gimpo FC Gimpo FC 40 39 65 41
9 Ansan Greeners Ansan 40 49 67 37
10 Busan I Park Busan Park 40 34 52 36
11 Jeonnam Dragons Jeonnam 40 47 58 35
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Gimcheon Sangmu FC Gimcheon 36 60 34 71
2 FC Anyang FC Anyang 36 51 37 62
3 Daejeon Citizen Daejeon 36 53 48 58
4 Jeonnam Dragons Jeonnam 36 38 33 52
5 Busan I Park Busan Park 36 46 56 45
6 Gyeongnam FC Gyeongnam 36 40 45 43
7 Ansan Greeners Ansan 36 37 49 43
8 Chungnam Asan FC Chungnam 36 38 41 41
9 Seoul E-Land FC Seoul E-Land 36 40 39 37
10 Bucheon FC 1995 Bucheon 1995 36 32 53 37
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Jeju United Jeju United 27 50 23 60
2 Suwon FC Suwon FC 27 52 28 54
3 Gyeongnam FC Gyeongnam 27 40 37 39
4 Daejeon Citizen Daejeon 27 36 35 39
5 Seoul E-Land FC Seoul E-Land 27 33 30 39
6 Jeonnam Dragons Jeonnam 27 31 25 38
7 Ansan Greeners Ansan 27 18 34 28
8 Bucheon FC 1995 Bucheon 1995 27 19 36 26
9 FC Anyang FC Anyang 27 27 38 25
10 Chungnam Asan FC Chungnam 27 20 40 22
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Gwangju FC Gwangju FC 36 59 31 73
2 Busan I Park Busan Park 36 72 47 67
3 FC Anyang FC Anyang 36 63 50 55
4 Bucheon FC 1995 Bucheon 1995 36 49 51 51
5 Ansan Greeners Ansan 36 46 42 50
6 Jeonnam Dragons Jeonnam 36 43 47 48
7 Chungnam Asan FC Chungnam 36 42 56 44
8 Suwon FC Suwon FC 36 49 55 43
9 Daejeon Citizen Daejeon 36 31 47 35
10 Seoul E-Land FC Seoul E-Land 36 43 71 25
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Chungnam Asan FC Chungnam 36 54 27 72
2 Seongnam FC Seongnam FC 36 49 36 65
3 Busan I Park Busan Park 36 53 35 56
4 Daejeon Citizen Daejeon 36 47 44 53
5 Gwangju FC Gwangju FC 36 51 41 48
6 FC Anyang FC Anyang 36 44 50 44
7 Suwon FC Suwon FC 36 29 46 42
8 Ansan Greeners Ansan 36 32 45 39
9 Bucheon FC 1995 Bucheon 1995 36 37 50 39
10 Seoul E-Land FC Seoul E-Land 36 30 52 37
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Gyeongnam FC Gyeongnam 36 69 36 79
2 Busan I Park Busan Park 36 52 30 68
3 Chungnam Asan FC Chungnam 36 44 37 54
4 Seongnam FC Seongnam FC 36 38 30 53
5 Bucheon FC 1995 Bucheon 1995 36 50 46 52
6 Suwon FC Suwon FC 36 42 48 45
7 FC Anyang FC Anyang 36 40 58 39
8 Seoul E-Land FC Seoul E-Land 36 42 55 35
9 Ansan Greeners Ansan 36 36 54 33
10 Daejeon Citizen Daejeon 36 41 60 29
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Daegu FC Daegu FC 40 53 36 70
2 Chungnam Asan FC Chungnam 40 57 55 70
3 Bucheon FC 1995 Bucheon 1995 40 49 33 67
4 Gangwon FC Gangwon FC 40 50 33 66
5 Busan I Park Busan Park 40 52 39 64
6 Seoul E-Land FC Seoul E-Land 40 47 35 64
7 Daejeon Citizen Daejeon 40 56 52 55
8 Gyeongnam FC Gyeongnam 40 61 58 50
9 FC Anyang FC Anyang 40 40 53 46
10 Chungju Hummel Chungju 40 42 62 29
11 Goyang Hi FC Goyang 40 21 72 16
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Gimcheon Sangmu FC Gimcheon 40 77 57 67
2 Daegu FC Daegu FC 40 67 47 67
3 Suwon FC Suwon FC 40 64 54 65
4 Seoul E-Land FC Seoul E-Land 40 69 58 61
5 Bucheon FC 1995 Bucheon 1995 40 43 45 55
6 FC Anyang FC Anyang 40 53 52 54
7 Gangwon FC Gangwon FC 40 64 56 51
8 Goyang Hi FC Goyang 40 46 68 49
9 Gyeongnam FC Gyeongnam 40 30 43 43
10 Chungnam Asan FC Chungnam 40 31 48 42
11 Chungju Hummel Chungju 40 49 65 41
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Daejeon Citizen Daejeon 36 64 36 70
2 Chungnam Asan FC Chungnam 36 58 48 59
3 Gangwon FC Gangwon FC 36 48 50 54
4 Gwangju FC Gwangju FC 36 40 35 51
5 FC Anyang FC Anyang 36 49 52 51
6 Suwon FC Suwon FC 36 52 49 48
7 Daegu FC Daegu FC 36 50 47 47
8 Goyang Hi FC Goyang 36 36 41 47
9 Chungju Hummel Chungju 36 37 57 34
10 Bucheon FC 1995 Bucheon 1995 36 33 52 27
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Gimcheon Sangmu FC Gimcheon 35 65 31 77
2 Chungnam Asan FC Chungnam 35 60 47 64
3 Gwangju FC Gwangju FC 35 55 54 53
4 Suwon FC Suwon FC 35 53 51 47
5 FC Anyang FC Anyang 35 50 51 45
6 Goyang Hi FC Goyang 35 43 50 41
7 Bucheon FC 1995 Bucheon 1995 35 45 61 33
8 Chungju Hummel Chungju 35 33 59 29

  USO DE MEMORIA  
5,897,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.4749
Total Execution Time  0.4781
  CADENA URL  
/k_league_corea2024/grupo1/historico
  GET DATOS  
$_GET['/k_league_corea2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0128  SELECT type FROM routes WHERE alias = 'k_league_corea2024'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'k_league_corea' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=392 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 392 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1133624,1127543,990803,864496,837621) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=392 ORDER BY order_id ASC
0.0126  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 392 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 71002 AND t.round = 39 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66798 AND t.round = 44 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` 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 = 61200 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 55314 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 48803 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 42586 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 37871 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20316 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 10004 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 4832 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` 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 = 2877 AND t.round = 35 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:26:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:26:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:26:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:26:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'k_league_corea' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0176  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 events2024 e ON e.player_id = p.id AND e.league_id = 75070 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75070 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.0172  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 events2024 e ON e.player_id = p.id AND e.league_id = 75070 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75070 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0131  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 events2024 e ON e.player_id = p.id AND e.league_id = 75070 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75070 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 75070 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC