4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Clasificación

Equipo PJ GF GC Puntos
1 UD Logroñés Sub 19 B Logroñés 28 82 40 63
2 Valvanera CD Sub 19 Valvanera 28 65 28 59
3 CD Villegas Sub 19 Villegas 28 67 37 56
4 CD Alfaro Sub 19 Alfaro 28 44 33 49
5 CD Berceo Sub 19 B Berceo 27 52 36 48
6 La Calzada Sub 19 Calzada 27 49 39 47
7 CD Calahorra Sub 19 Calahorra 27 52 40 43
8 EF Mareo Sub 19 Mareo 27 38 34 41
9 SD Logroñés Sub 19 Logroñés 27 67 55 40
10 CD Pradejón Sub 19 Pradejón 28 49 51 38
11 SD Oyonesa Sub 19 Oyonesa 27 52 49 34
12 CA River Ebro Sub 19 River Ebro 28 38 47 27
13 Comillas Sub 19 Comillas 27 37 53 25
14 Varea Sub 19 Varea 28 33 64 23
15 Autol Sub 19 Autol 28 31 90 14
16 Arnedo Sub 19 Arnedo 27 18 78 11

  USO DE MEMORIA  
7,040,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.1072
Total Execution Time  0.1105
  CADENA URL  
/nacional_juvenil2024/grupo5/jugadores
  GET DATOS  
$_GET['/nacional_juvenil2024/grupo5/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=112 ORDER BY order_id ASC
0.0020  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73382 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0189  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 73382 AND dt.id IN (3330,67394,3331,3325,6242,3324,10960,3320,3326,6238,29623,3819,19334,3318,139274,132771) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 03:41:48' 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=2 AND last_update > '2024-04-28 03:41:48' 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-04-28 03:41:48' 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-04-28 03:41:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0193  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 events2024 e ON e.player_id = p.id AND e.league_id = 73382 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73382 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.0204  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 events2024 e ON e.player_id = p.id AND e.league_id = 73382 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73382 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  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 events2024 e ON e.player_id = p.id AND e.league_id = 73382 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73382 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10