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

Estadísticas

ASISTENCIAS
Raúl Blanco8
Hugo Álvarez5
Javi Rueda5
Alfon González5
Miguel Román4
Pablo Durán4
Fer López3
Damián2
Dela2
Bruno Iglesias1
Yoel Lago1
Dani González1
Tincho1
L. Antañón1
ENTRA
Bruno Iglesias21
Fer López17
Dani González14
Tincho12
L. Antañón11
Manu Fernández10
Pablo Durán10
J. Domínguez9
Raúl Blanco8
Manu Garrido7
Dela7
Joel López6
Miguel Román6
Iván López4
Pablo Meixús3
V. San Bartolomé3
Javi Rueda3
Yoel Lago2
Javier Piay2
Alfon González2
Damián1
Hugo Álvarez1
Mario Fuente1
Javi Rodríguez1
Miguel Conde1
Mario Cantero1
SALE
Pablo Durán22
Raúl Blanco21
Alfon González20
Miguel Román15
Hugo Álvarez11
Javi Rodríguez9
Fer López8
Yoel Lago8
Tincho8
Damián6
Dani González6
Dela6
Joel López6
Manu Fernández4
Javi Rueda4
J. Domínguez4
Bruno Iglesias1
Pablo Meixús1
Gael Alonso1
L. Antañón1
Iván López1

  USO DE MEMORIA  
5,226,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0454
Total Execution Time  0.0466
  CADENA URL  
/estadisticas/celta-b
  GET DATOS  
$_GET['/estadisticas/celta-b']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (5)  
0.0029  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '713' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0041  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 72358 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0033  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 713 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 713 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 713 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30