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

Estadísticas

ASISTENCIAS
Jaden Philogene6
Tyler Morton5
J. Seri4
J. Greaves4
R. Longman3
Alfie Jones3
S. Twine3
Fábio Carvalho2
C. Christie2
A. Ömür2
Liam Delap2
O. Tufan2
G. Docherty1
R. Slater1
L. Coyle1
Noss Traoré1
Ryan Giles1
S. McLoughlin1
ENTRA
R. Longman16
A. Connolly15
C. Christie15
G. Docherty14
O. Tufan12
J. Lokilo11
Noss Traoré10
S. McLoughlin10
Billy Sharp8
R. Slater7
H. Vaughan7
Noah Ohio6
M. Jacob6
S. Twine6
A. Sayyadmanesh6
Liam Delap5
Ryan Giles5
O. Estupiñán4
Tyler Morton4
Rúben Vinagre4
A. Ömür4
L. Coyle4
A. Zaroury3
Xavier Simons2
T. Sellars-Fleming2
Andy Smith1
D. Sinik1
M. Ingram1
SALE
O. Tufan18
J. Seri18
S. Twine16
R. Longman16
Liam Delap16
Noss Traoré13
Tyler Morton10
A. Connolly10
Fábio Carvalho9
A. Zaroury8
A. Ömür8
R. Slater8
L. Coyle8
C. Christie6
J. Lokilo6
S. McLoughlin5
Rúben Vinagre5
Jaden Philogene5
Billy Sharp2
Ryan Giles2
M. Jacob2
H. Vaughan1
Ryan Allsop1
Noah Ohio1

  USO DE MEMORIA  
5,629,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.3289
Total Execution Time  0.3304
  CADENA URL  
/estadisticas/Hull-City
  GET DATOS  
$_GET['/estadisticas/Hull-City']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0254  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72728
0.0173  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 = '1341' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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=1341 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (72728,72258,72033,71432) 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.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 72033 AND teamId = 1341
0.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 1341
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 1341
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1341
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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1341 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.0147  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1341 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1341 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0195  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1341 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0190  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1341 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0218  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 = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1341 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30