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

Estadísticas

ASISTENCIAS
Yan Couto8
Savinho8
Aleix García6
Miguel Gutiérrez6
Artem Dovbyk5
V. Tsygankov4
Portu4
Iván Martín2
Pablo Torre2
Daley Blind2
Arnau Martínez2
C. Stuani2
ENTRA
C. Stuani24
Portu22
Valery21
Pablo Torre20
Jhon Solis16
Juanpe9
Yan Couto7
Arnau Martínez6
V. Tsygankov4
Artem Dovbyk4
Iván Martín3
Jastin García2
Eric García2
Bernardo2
I. Kébé2
Y. Herrera2
Daley Blind1
Toni Villa1
Savinho1
Antal1
Silvi Clua1
SALE
Artem Dovbyk21
Iván Martín20
V. Tsygankov17
Savinho17
Y. Herrera15
Yan Couto9
David López8
Portu8
Arnau Martínez8
Pablo Torre5
C. Stuani5
Eric García3
Valery2
Miguel Gutiérrez2
Aleix García2
Jhon Solis2
Daley Blind1
Juanpe1

  USO DE MEMORIA  
5,459,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0586
Total Execution Time  0.0600
  CADENA URL  
/estadisticas/Girona-Fc
  GET DATOS  
$_GET['/estadisticas/Girona-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1236 AND type_rel = 2
0.0072  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1236 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1312794,1312785,1312574,198,245) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '1236' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0034  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 72116 WHERE rp.league_id = 72116 AND rp.teamId = 1236 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30