4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Ibiza

UD Ibiza

Entrenador: Guillermo Fernández

Estadísticas

ENTRA
Suleiman23
Cedric21
Roberto Olabe20
R. Arroyo17
Arturo Molina14
Abde Damar13
Rubén Díez13
Alain García11
Jesús Álvarez7
Fausto7
Álex Gallar5
N. Obolskii5
Joseda5
D. Argüelles3
Patrick Soko2
Álex Neskes2
Unai Medina1
Eric Monjonell1
A. Escassi1

  USO DE MEMORIA  
5,216,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2154
Total Execution Time  0.2166
  CADENA URL  
/estadisticas/Ibiza-Eivissa
  GET DATOS  
$_GET['/estadisticas/Ibiza-Eivissa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1352 AND type_rel = 2
0.0151  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1352 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1289449,279976,413915,427710,428153) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '1352' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 1352 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 1352 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 72359 WHERE rp.league_id = 72359 AND rp.teamId = 1352 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30