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

Estadísticas

ENTRA
Alessio Canessa12
Matteo Pallecchi12
Jean Evan's9
F. Castellano7
F. Nunziatini7
S. Braken5
N. Bresciani5
Hamza Haoudi5
G. Piccoli4
Davide Buglio4
M. Bueno4
Federico Caia4
Lorenzo Pecchia4
Alain Fremura4
Y. Bobb4
Marcelo Deverlan3
E. Blondett3
A. Bussaglia3
A. Gemignani3
F. Di Giovanni3
D. Marsura2
F. Mazzeo2
T. Parisi2
A. Marie-Sainte2
G. Morelli2
Tiziano Irace1
C. Sosa1
Murilo Mendes1
M. Di Gennaro1
E. Dubickas1
SALE
A. Bussaglia12
G. Piccoli9
F. Castellano9
A. Mazzarani8
Hamza Haoudi8
A. Gemignani7
Matteo Pallecchi7
S. Braken6
C. Cauz6
Davide Buglio5
D. Marsura5
T. Parisi5
F. Mazzeo5
A. Porcino4
A. Marie-Sainte4
E. Blondett3
C. Sosa3
Jean Evan's3
Marcelo Deverlan3
G. Morelli3
Alessio Canessa2
Alain Fremura2
N. Bresciani2
M. Bueno1
Murilo Mendes1
E. Dubickas1
Y. Bobb1
F. Di Giovanni1

  USO DE MEMORIA  
5,363,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3862
Total Execution Time  0.3874
  CADENA URL  
/estadisticas/Livorno/2021
  GET DATOS  
$_GET['/estadisticas/Livorno/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1566 AND type_rel = 2
0.0143  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1566 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0153  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 (37350,44924,53346,88441,97615) ORDER BY n.cover_points DESC, update_date DESC
0.0193  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 = '1566' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58760 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1566 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0126  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (58760,58676,49921,49506) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 49921 AND teamId = 1566
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 58760 AND teamId = 1566
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 58676 AND teamId = 1566
0.0272  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 1566
0.0154  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 events2021 e ON e.player_id = p.id AND e.league_id = 58760 WHERE rp.league_id = 58760 AND rp.teamId = 1566 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 events2021 e ON e.player_id = p.id AND e.league_id = 58760 WHERE rp.league_id = 58760 AND rp.teamId = 1566 AND (e.action = 4 or e.action = 5) 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 events2021 e ON e.player_id = p.id AND e.league_id = 58760 WHERE rp.league_id = 58760 AND rp.teamId = 1566 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2021 e ON e.player_id = p.id AND e.league_id = 58760 WHERE rp.league_id = 58760 AND rp.teamId = 1566 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0232  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 events2021 e ON e.player_id = p.id AND e.league_id = 58760 WHERE rp.league_id = 58760 AND rp.teamId = 1566 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0213  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 events2021 e ON e.player_id = p.id AND e.league_id = 58760 WHERE rp.league_id = 58760 AND rp.teamId = 1566 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 58760 ORDER BY nameShow LIMIT 100