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

Estadísticas

ASISTENCIAS
Cote7
H. Hassan5
Rober Pier3
Fran Villalba3
Nacho Martín2
Guille Rosas2
Juan Otero2
Djuka2
Christian Rivera1
V. Campuzano1
Gaspar Campos1
Pablo Insua1
A. Pașcanu1
Pablo García1
Roque Mesa1
ENTRA
Dani Queipo19
J. Varane16
Fran Villalba14
Guille Rosas14
Roque Mesa12
Djuka12
H. Hassan10
Christian Rivera10
Mario González9
Esteban Lozano8
Cote6
Pablo García6
V. Campuzano6
C. Izquierdoz5
Álex Lozano5
Nacho Méndez4
Rober Pier3
Gaspar Campos3
I. Jeraldino3
Nacho Martín3
Diego Sánchez2
Juan Otero2
Enol Coto1
Christian Joel1
Jordan Carrillo1
A. Pașcanu1
G. Zarfino1
SALE
Gaspar Campos26
H. Hassan21
Nacho Méndez16
A. Pașcanu13
Djuka12
Christian Rivera11
Juan Otero11
V. Campuzano10
Roque Mesa10
Nacho Martín9
Pablo García8
Fran Villalba8
J. Varane4
Cote4
Pablo Insua3
Guille Rosas3
Rober Pier2
Mario González2
Dani Queipo2
Diego Sánchez1
Rubén Yáñez1

  USO DE MEMORIA  
5,565,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3578
Total Execution Time  0.3589
  CADENA URL  
/estadisticas/sporting-gijon
  GET DATOS  
$_GET['/estadisticas/sporting-gijon']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0207  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'sporting-gijon' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0157  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2125 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2125 AND type_rel = 2
0.0377  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2125 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0157  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 (38760,212526,497020,602673,753903) ORDER BY n.cover_points DESC, update_date DESC
0.0218  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 = '2125' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0247  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 2125 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0261  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 2125 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0256  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 = 72177 WHERE rp.league_id = 72177 AND rp.teamId = 2125 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30