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 Almería Almería 42 68 35 81
2 Real Valladolid Real 42 71 43 81
3 Eibar Eibar 42 61 45 80
4 Las Palmas Las Palmas 42 57 47 70
5 Tenerife Tenerife 42 53 37 69
6 Girona Girona 42 57 42 68
7 Real Oviedo Real Oviedo 42 57 41 68
8 Ponferradina Ponferradina 42 57 55 63
9 FC Cartagena Cartagena 42 63 57 60
10 Real Zaragoza Real 42 39 46 56
11 Burgos Burgos 42 41 41 55
12 Leganés Leganés 42 50 51 54
13 Huesca Huesca 42 49 44 54
14 Mirandés Mirandés 42 58 62 52
15 UD Ibiza UD Ibiza 42 53 59 52
16 CD Lugo CD Lugo 42 46 52 50
17 Real Sporting Real 42 43 48 46
18 Málaga Málaga 42 36 57 45
19 SD Amorebieta Amorebieta 42 44 63 43
20 Real Sociedad B Real 42 43 61 40
21 Fuenlabrada Fuenlabrada 42 39 65 33
22 Alcorcón Alcorcón 42 37 71 29

  USO DE MEMORIA  
5,273,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1895
Total Execution Time  0.1915
  CADENA URL  
/segunda2022/grupo1/minutoaminuto
  GET DATOS  
$_GET['/segunda2022/grupo1/minutoaminuto']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0035  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2022` e INNER JOIN calendars2022 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 62832 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 100
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 06:05:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 06:05:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 06:05:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 06:05:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0802  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 = 62832 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62832 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.0649  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 = 62832 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62832 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  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 = 62832 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62832 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10