Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Hacken Sub 21 Hacken 12 36 10 33
2 Varbergs BoIS Sub 21 Varbergs 12 27 15 25
3 Elfsborg Sub 21 Elfsborg 12 29 17 22
4 Norrby Sub 21 Norrby 12 22 28 16
5 Falkenberg Sub 21 Falkenberg 12 16 28 11
6 Örgryte Sub 21 Örgryte 12 17 28 10
7 GAIS Sub 21 GAIS Sub 21 12 17 38 6
8 IFK Göteborg Sub 21 Göteborg 0 0 0 0
9 Jönköpings Sub 21 Jönköpings 0 0 0 0
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Elfsborg Sub 21 Elfsborg 1 3 0 3
2 Hacken Sub 21 Hacken 1 3 1 3
3 Örgryte Sub 21 Örgryte 0 0 0 0
4 Osters IF Sub 21 Osters 0 0 0 0
5 IFK Göteborg Sub 21 Göteborg 1 1 3 0
6 GAIS Sub 21 GAIS Sub 21 1 0 3 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Halmstad Sub 21 Halmstad 7 13 4 15
2 Malmö FF Sub 21 Malmö 7 13 8 13
3 Hacken Sub 21 Hacken 7 12 6 12
4 Falkenberg Sub 21 Falkenberg 7 7 12 9
5 Kalmar Sub 21 Kalmar 7 9 9 8
6 IFK Göteborg Sub 21 Göteborg 7 8 8 8
7 Elfsborg Sub 21 Elfsborg 7 7 11 6
8 Helsingborgs Sub 21 Helsingborgs 7 10 21 6
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 IFK Norrköping Sub 21 Norrköping 6 15 4 16
2 AFC Eskilstuna Sub 21 Eskilstuna 6 10 9 11
3 Hammarby Sub 21 Hammarby 6 16 8 10
4 Brommapojkarna Sub 21 Brommapojkar 6 9 7 8
5 IK Sirius Sub 21 Sirius 6 12 13 7
6 Djurgården Sub 21 Djurgården 6 8 16 5
7 Örebro Sub 21 Örebro 6 7 20 1
8 Hacken Sub 21 Hacken 7 21 6 16
9 Malmö FF Sub 21 Malmö 7 14 10 13
10 Elfsborg Sub 21 Elfsborg 7 12 8 13
11 IFK Göteborg Sub 21 Göteborg 7 11 10 11
12 Kalmar Sub 21 Kalmar 7 12 15 9
13 Halmstad Sub 21 Halmstad 7 14 18 7
14 Trelleborgs Sub 21 Trelleborgs 7 4 10 5
15 Helsingborgs Sub 21 Helsingborgs 7 6 17 5
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Djurgården Sub 21 Djurgården 14 41 15 34
2 Brommapojkarna Sub 21 Brommapojkar 14 46 13 31
3 IFK Norrköping Sub 21 Norrköping 14 26 19 25
4 Hammarby Sub 21 Hammarby 14 28 23 18
5 IK Sirius Sub 21 Sirius 14 15 28 17
6 GIF Sundsvall Sub 21 Sundsvall 14 15 41 16
7 AFC Eskilstuna Sub 21 Eskilstuna 14 21 28 14
8 Örebro Sub 21 Örebro 14 9 34 7
9 Elfsborg Sub 21 Elfsborg 14 19 9 26
10 Hacken Sub 21 Hacken 14 30 14 25
11 Halmstad Sub 21 Halmstad 14 28 14 25
12 Malmö FF Sub 21 Malmö 14 30 20 24
13 IFK Göteborg Sub 21 Göteborg 14 18 24 21
14 Kalmar Sub 21 Kalmar 14 18 26 15
15 Helsingborgs Sub 21 Helsingborgs 14 13 22 11
16 Jönköpings Sub 21 Jönköpings 14 8 35 8
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 IFK Norrköping Sub 21 Norrköping 14 53 13 36
2 Djurgården Sub 21 Djurgården 14 27 14 30
3 Hammarby Sub 21 Hammarby 14 25 22 24
4 IK Sirius Sub 21 Sirius 14 21 33 17
5 AIK Sub 21 AIK Sub 21 14 31 43 15
6 GIF Sundsvall Sub 21 Sundsvall 14 26 28 14
7 Gefle Sub 21 Gefle 14 17 25 12
8 Örebro Sub 21 Örebro 14 11 33 10
9 Kalmar Sub 21 Kalmar 14 41 15 32
10 Elfsborg Sub 21 Elfsborg 14 39 19 28
11 Malmö FF Sub 21 Malmö 14 43 16 27
12 Hacken Sub 21 Hacken 14 27 31 22
13 IFK Göteborg Sub 21 Göteborg 14 25 26 21
14 Helsingborgs Sub 21 Helsingborgs 14 19 28 15
15 Falkenberg Sub 21 Falkenberg 14 12 31 9
16 Jönköpin Sub 21 Jönköpin 14 8 48 8
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Djurgården Sub 21 Djurgården 14 39 14 35
2 IFK Norrköping Sub 21 Norrköping 14 34 17 25
3 Hammarby Sub 21 Hammarby 14 29 31 24
4 Åtvidaberg Sub 21 Åtvidaberg 14 28 31 19
5 GIF Sundsvall Sub 21 Sundsvall 14 21 28 15
6 Örebro Sub 21 Örebro 14 25 29 14
7 Gefle Sub 21 Gefle 14 18 26 14
8 AIK Sub 21 AIK Sub 21 14 23 41 14

  USO DE MEMORIA  
5,157,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0770
Total Execution Time  0.0790
  CADENA URL  
/liga_suecia_sub_212021/grupo1/historico
  GET DATOS  
$_GET['/liga_suecia_sub_212021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_suecia_sub_212021'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suecia_sub_21' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1711 AND type_rel = 3
0.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1711 ORDER BY order_id ASC
0.0020  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 = 61391 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1711 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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 = 61391 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 55479 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 51539 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 44022 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 38228 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 20425 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 10868 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 09:22:26' 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=2 AND last_update > '2024-04-20 09:22:26' 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=4 AND last_update > '2024-04-20 09:22:26' 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-04-20 09:22:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suecia_sub_21' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2021 e ON e.player_id = p.id AND e.league_id = 61391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61391 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.0019  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 events2021 e ON e.player_id = p.id AND e.league_id = 61391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61391 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2021 e ON e.player_id = p.id AND e.league_id = 61391 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 61391 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT *,(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 = 61391 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC