Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 24 93 30 62
2 Club Brugge Sub 18 Club Brugge 24 74 31 58
3 Anderlecht Sub 18 Anderlecht 24 58 40 45
4 Standard Lieja Sub 18 Standard 24 55 37 43
5 KAA Gent Sub 18 Gent 24 51 42 37
6 Zulte-Waregem Sub 18 Zulte-Warege 24 34 40 34
7 Sporting Charleroi Sub 18 Sporting 24 32 42 32
8 Sint-Truiden Sub 18 Sint-Truiden 24 28 34 30
9 KV Mechelen Sub 18 Mechelen 24 45 52 27
10 Antwerp Sub 18 Antwerp 24 29 46 25
11 Leuven Sub 18 Leuven 24 39 56 24
12 Cercle Brugge Sub 18 Cercle 24 44 80 20
13 KVC Westerlo Sub 18 Westerlo 24 21 73 2
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 22 59 21 45
2 Standard Lieja Sub 18 Standard 22 63 28 45
3 Sporting Charleroi Sub 18 Sporting 22 55 39 42
4 KV Mechelen Sub 18 Mechelen 22 45 27 37
5 KAA Gent Sub 18 Gent 22 54 43 33
6 Club Brugge Sub 18 Club Brugge 22 55 35 32
7 Zulte-Waregem Sub 18 Zulte-Warege 22 39 47 31
8 Leuven Sub 18 Leuven 22 37 48 30
9 Anderlecht Sub 18 Anderlecht 22 38 35 25
10 AS Eupen Sub 18 Eupen 22 39 67 21
11 Lokeren Sub 18 Lokeren 22 21 71 15
12 Sint-Truiden Sub 18 Sint-Truiden 22 26 70 13
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Genk Sub 18 Genk Sub 18 22 68 25 53
2 Club Brugge Sub 18 Club Brugge 22 52 23 50
3 KAA Gent Sub 18 Gent 22 60 32 45
4 Standard Lieja Sub 18 Standard 22 47 27 41
5 Anderlecht Sub 18 Anderlecht 22 42 29 38
6 Sporting Charleroi Sub 18 Sporting 22 37 32 33
7 Leuven Sub 18 Leuven 22 42 31 32
8 Sint-Truiden Sub 18 Sint-Truiden 22 37 47 30
9 KV Mechelen Sub 18 Mechelen 22 26 33 26
10 Lokeren Sub 18 Lokeren 22 22 57 17
11 Cercle Brugge Sub 18 Cercle 22 19 76 10
12 Zulte-Waregem Sub 18 Zulte-Warege 22 21 61 5

  USO DE MEMORIA  
5,114,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0774
Total Execution Time  0.0793
  CADENA URL  
/liga_belga_sub182022/grupo1/historico
  GET DATOS  
$_GET['/liga_belga_sub182022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0017  SELECT type FROM routes WHERE alias = 'liga_belga_sub182022'
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_belga_sub18' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 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=2330 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2330 ORDER BY order_id ASC
0.0019  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 = 63931 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2330 AND group_code = 1 and tables = 1 AND year <= 2022 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 `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 = 63931 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 59156 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 56399 AND t.round = 22 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 = 59258 AND t.round = 22 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-19 13:50:05' 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-19 13:50:05' 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-19 13:50:05' 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-19 13:50:05' 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_belga_sub18' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 events2022 e ON e.player_id = p.id AND e.league_id = 63931 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63931 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.0094  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 events2022 e ON e.player_id = p.id AND e.league_id = 63931 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63931 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 events2022 e ON e.player_id = p.id AND e.league_id = 63931 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63931 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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 = 63931 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC