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 Espanyol Espanyol 42 71 28 82
2 Mallorca Mallorca 42 54 28 82
3 Leganés Leganés 42 51 32 73
4 Almería Almería 42 61 40 73
5 Girona Girona 42 47 36 71
6 Rayo Vallecano Rayo 42 52 40 67
7 Real Sporting Real 42 37 28 65
8 Ponferradina Ponferradina 42 45 50 57
9 Las Palmas Las Palmas 42 46 53 56
10 Mirandés Mirandés 42 38 41 54
11 Fuenlabrada Fuenlabrada 42 45 46 54
12 Málaga Málaga 42 37 47 53
13 Real Oviedo Real Oviedo 42 45 46 52
14 Tenerife Tenerife 42 36 36 52
15 Real Zaragoza Real 42 37 43 50
16 FC Cartagena Cartagena 42 44 52 49
17 Alcorcón Alcorcón 42 32 42 48
18 CD Lugo CD Lugo 42 38 53 47
19 CE Sabadell CE Sabadell 42 40 48 46
20 UD Logroñés Logroñés 42 28 53 44
21 CD Castellón Castellón 42 35 54 41
22 Albacete Albacete 42 30 53 38

  USO DE MEMORIA  
5,546,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1444
Total Execution Time  0.1465
  CADENA URL  
/segunda2021/grupo1/resumen/4
  GET DATOS  
$_GET['/segunda2021/grupo1/resumen/4']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0295  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2 FROM `calendars2021` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 57314 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 200
0.0362  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,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 `events2021` e INNER JOIN calendars2021 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.main_action = 1 AND c.round = 42 AND e.real_date IS NOT NULL AND e.league_id = 57314 ORDER BY total DESC LIMIT 100
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 12:54:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 12:54:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 12:54:27' 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-27 12:54:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0253  SELECT *,(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 = 57314 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC