Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Farul Constanţa Sub 19 Farul 11 43 5 31
2 Dinamo Bucureşti Sub 19 Dinamo 11 39 21 24
3 FCSB Sub 19 FCSB Sub 19 11 30 17 22
4 CSA Steaua Bucuresti Sub 19 Steaua 11 28 18 21
5 Botosani Sub 19 Botosani 11 27 19 21
6 Concordia Chiajna Sub 19 Concordia 11 18 16 17
7 Sepsi Sub 19 Sepsi 11 21 23 13
8 Academica Clinceni Sub 19 Academica 11 23 28 13
9 LPS Buzau Sub 19 Buzau 11 12 29 13
10 FC Politehnica Iasi Sub 19 Politehnica 11 19 20 10
11 Voluntari Sub 19 Voluntari 11 14 38 4
12 Sport Team Sub 19 Sport Team 11 8 48 3
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Viitorul Sub 19 Viitorul 22 105 9 63
2 FCSB Sub 19 FCSB Sub 19 22 77 30 48
3 Concordia Chiajna Sub 19 Concordia 22 47 34 44
4 Voluntari Sub 19 Voluntari 22 43 35 41
5 Academica Clinceni Sub 19 Academica 22 47 34 38
6 Botosani Sub 19 Botosani 22 44 44 32
7 Dinamo Bucureşti Sub 19 Dinamo 22 43 36 28
8 Sport Team Sub 19 Sport Team 22 29 44 24
9 Sepsi Sub 19 Sepsi 22 25 53 24
10 Petrolul Ploiesti Sub 19 Petrolul 22 37 56 20
11 Kids Tâmpa Braşov Sub 19 Kids Tâmpa 22 20 74 13
12 LPS Buzau Sub 19 Buzau 22 24 92 5
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Viitorul Sub 19 Viitorul 21 103 11 58
2 Dinamo Bucureşti Sub 19 Dinamo 21 87 21 52
3 FCSB Sub 19 FCSB Sub 19 21 71 25 52
4 Csikszereda Sub 19 Csikszereda 21 61 35 37
5 Voluntari Sub 19 Voluntari 21 66 30 36
6 Concordia Chiajna Sub 19 Concordia 21 46 28 35
7 Sport Team Sub 19 Sport Team 21 51 42 31
8 FC Politehnica Iasi Sub 19 Politehnica 21 43 53 24
9 Gloria Buzău Sub 19 Gloria 21 17 57 17
10 CSA Steaua Bucuresti Sub 19 Steaua 21 21 66 14
11 Botosani Sub 19 Botosani 21 11 93 5
12 LPS Buzau Sub 19 Buzau 21 16 132 3
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Viitorul Sub 19 Viitorul 18 93 12 45
2 Dinamo Bucureşti Sub 19 Dinamo 18 76 19 45
3 FC Vaslui Sub 19 Vaslui 18 57 15 43
4 FCSB Sub 19 FCSB Sub 19 18 55 27 33
5 Petrolul Ploiesti Sub 19 Petrolul 18 41 42 27
6 CSA Steaua Bucuresti Sub 19 Steaua 18 29 36 22
7 Sport Team Sub 19 Sport Team 18 19 63 16
8 FC Ceahlaul Piatra Neamt Su Ceahlaul 18 21 53 13
9 Csikszereda Sub 19 Csikszereda 18 15 39 11
10 LPS Galati Sub 19 Galati 18 14 114 4

  USO DE MEMORIA  
5,002,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0658
Total Execution Time  0.0677
  CADENA URL  
/liga_rumana_sub192022/grupo1/historico
  GET DATOS  
$_GET['/liga_rumana_sub192022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_rumana_sub192022'
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_rumana_sub19' 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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2384 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2384 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 = 63916 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2384 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 = 63916 AND t.round = 11 ORDER BY team.conference ASC,t.position 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 `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 = 59183 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 `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 = 59207 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 = 59248 AND t.round = 18 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 11:10:22' 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 11:10:22' 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 11:10:22' 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 11:10:22' 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_rumana_sub19' 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 = 63916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63916 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 events2022 e ON e.player_id = p.id AND e.league_id = 63916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63916 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events2022 e ON e.player_id = p.id AND e.league_id = 63916 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63916 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0031  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 = 63916 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC