4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Sporting Ciudad AC y D Sporting 34 88 35 77
2 Imperator OAR Imperator 33 73 52 72
3 Vizoño Vizoño 33 76 36 65
4 Club do Mar de Caion Club Caion 34 68 41 63
5 Torre SD Torre SD 33 67 47 62
6 Visantoña Visantoña 34 53 43 51
7 Sporting Meicende Sporting 34 49 56 47
8 Marino CF Marino CF 34 61 48 45
9 Sporting Coruñés Sporting 34 67 66 45
10 Relámpago S.D. Relámpago 33 46 45 45
11 Santa Cruz C.F. Santa Cruz. 33 76 78 45
12 C.D. Larín C.D. Larín 33 59 60 42
13 Carnoedo Carnoedo 34 57 63 42
14 Culleredo Culleredo 33 50 60 42
15 Mesia CD Mesia CD 33 52 74 35
16 Tambre FC Tambre FC 26 36 56 28
17 Sin Querer Sin Querer 34 33 83 22
18 SCD Ciudad Jardín Ciudad 34 37 105 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Orillamar SD Orillamar 34 105 29 81
2 Atletico San Pedro Atletico 34 79 34 76
3 Sporting Cambre Sporting 34 67 27 70
4 Vizoño Vizoño 34 80 54 60
5 Torre SD Torre SD 34 59 54 52
6 Santa Cruz C.F. Santa Cruz. 34 66 62 52
7 Carnoedo Carnoedo 34 56 54 50
8 Sporting Coruñés Sporting 34 56 69 50
9 SCD Ciudad Jardín Ciudad 34 62 49 49
10 Visantoña Visantoña 34 64 55 47
11 Imperator OAR Imperator 34 52 50 44
12 Mesia CD Mesia CD 34 47 56 41
13 Sin Querer Sin Querer 34 48 64 41
14 Sporting Burgo Sporting 34 50 78 37
15 San Martiño Martiño 34 38 51 35
16 Xuventude Dorneda Xuventude 34 50 83 33
17 Maravillas S.D. Maravillas 34 41 83 26
18 Vioño CF Vioño CF 34 47 115 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Universidade Universidade 33 99 15 87
2 Torre SD Torre SD 32 95 36 71
3 Sporting Coruñés Sporting 33 87 43 67
4 SCD Ciudad Jardín Ciudad 33 77 40 67
5 Sin Querer Sin Querer 32 58 43 65
6 CD Ciudad CD Ciudad 33 80 43 62
7 Español SDC Español 33 62 33 61
8 Galicia Gaiteira Galicia 33 73 63 58
9 Relámpago S.D. Relámpago 33 77 56 53
10 Oza Juvenil S.D. Juvenil S.D. 33 55 48 50
11 Atlético dos Castros Atlético 33 68 85 32
12 C.D. Sarsfield C.D. 33 50 97 29
13 Cd Calasanz Cd Calasanz 32 45 79 26
14 Marte CD Marte CD 33 49 90 26
15 Orzán Sd Orzán Sd 32 36 73 25
16 Marola CF Marola CF 33 37 88 22
17 A Cocteleira C.F. Cocteleira 17 24 43 16
18 Liceo de Monelos Liceo 33 20 117 3
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Maravillas S.D. Maravillas 33 85 33 81
2 Sporting Coruñés Sporting 33 86 25 80
3 Español SDC Español 34 96 26 79
4 Cd Calasanz Cd Calasanz 34 88 46 67
5 SCD Ciudad Jardín Ciudad 34 75 44 57
6 San Cristóbal Viñas Cristóbal 34 74 48 54
7 Torre SD Torre SD 34 73 52 54
8 Universidade Universidade 34 58 44 50
9 Galicia Gaiteira Galicia 34 77 65 49
10 Orzán Sd Orzán Sd 34 49 49 44
11 A Cocteleira C.F. Cocteleira 33 77 68 43
12 Relámpago S.D. Relámpago 33 46 60 42
13 Oza Juvenil S.D. Juvenil S.D. 34 49 53 41
14 Atlético dos Castros Atlético 34 47 64 38
15 C.D. Sarsfield C.D. 34 61 95 36
16 Liceo de Monelos Liceo 34 54 92 28
17 Unión Sportiva Unión 33 29 176 8
18 S.D. Santa Margarita S.D. Santa. 33 35 119 7

  USO DE MEMORIA  
5,412,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0898
Total Execution Time  0.0919
  CADENA URL  
/segunda_galicia2018/grupo1/historico
  GET DATOS  
$_GET['/segunda_galicia2018/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0018  SELECT type FROM routes WHERE alias = 'segunda_galicia2018'
0.0042  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_galicia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 714 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (369188,189167,170033,122664) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=714 ORDER BY order_id ASC
0.0022  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 = 39821 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 714 AND group_code = 1 and tables = 1 AND year <= 2018 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0027  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 = 39821 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 34932 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 16816 AND t.round = 34 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 `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 = 4343 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 00:03:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 00:03:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 00:03:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 00:03:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0030  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segunda_galicia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2018 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0031  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 events2018 e ON e.player_id = p.id AND e.league_id = 39821 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39821 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.0029  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 events2018 e ON e.player_id = p.id AND e.league_id = 39821 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39821 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 events2018 e ON e.player_id = p.id AND e.league_id = 39821 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39821 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0102  SELECT *,(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 = 39821 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC