4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Cádiz CF Mirandilla Cádiz 38 83 28 82
2 Salerm Puente Genil Salerm 38 72 36 73
3 Xerez CD Xerez CD 38 74 37 72
4 Ciudad de Lucena Ciudad 38 60 39 71
5 Estrella San Agustín Estrella 38 59 46 68
6 Xerez Deportivo Xerez 38 65 43 63
7 Conil Conil 38 65 47 60
8 CD Pozoblanco Pozoblanco 38 39 36 58
9 La Palma CF La Palma CF 38 73 58 57
10 Viso UP Viso UP 38 47 38 54
11 AD Cartaya AD Cartaya 38 49 48 54
12 AD San José José 38 57 45 53
13 Ol. Valverdeña Valverdeña 38 55 74 45
14 CD Rota CD Rota 38 58 85 44
15 Chiclana CF Chiclana CF 38 46 62 42
16 Roteña Roteña 38 48 66 41
17 Lora CF Lora CF 38 48 71 39
18 San Juan San Juan 38 58 78 38
19 Pinzón CD Pinzón CD 38 45 71 28
20 Almodóvar del Río Almodóvar 38 25 118 13

  USO DE MEMORIA  
5,110,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0700
Total Execution Time  0.0719
  CADENA URL  
/division_honor_senior_andalucia2017/grupo1/historico
  GET DATOS  
$_GET['/division_honor_senior_andalucia2017/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT type FROM routes WHERE alias = 'division_honor_senior_andalucia2017'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'division_honor_senior_andalucia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1896 ORDER BY order_id ASC
0.0024  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 = 34070 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1896 AND group_code = 1 and tables = 1 AND year <= 2017 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 34070 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 16:23:46' 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-01 16:23:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 16:23:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 16:23:46' 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 = 'division_honor_senior_andalucia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 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 events2017 e ON e.player_id = p.id AND e.league_id = 34070 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34070 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.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 events2017 e ON e.player_id = p.id AND e.league_id = 34070 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34070 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events2017 e ON e.player_id = p.id AND e.league_id = 34070 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 34070 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(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 = 34070 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC