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

Estadísticas

ASISTENCIAS
Luciano Valente7
Leandro Bacuna6
Johan Hove6
M. Peersman6
T. Van Bergen5
R. Postema4
Laros Duarte4
Isak Määttä3
R. Mendes3
M. Rente3
Jorg Schreuders2
D. Irandust2
Noam Emeran1
Paulos Abraham1
Wouter Prins1
H. Jurjus1
ENTRA
R. Mendes21
T. Blokzijl15
Fofin Turay13
Kristian Lien13
Isak Määttä12
Noam Emeran9
Tika De Jonge8
T. Van Bergen8
Laros Duarte7
D. Irandust6
J. Pelupessy5
Kian Slor4
Leandro Bacuna4
K. Van Veen4
L. Van Gelderen4
Luciano Valente3
Johan Hove2
Jorg Schreuders2
N. Bakker2
N. Musampa1
R. Oratmangoen1
Nils Eggens1
Paulos Abraham1
Wouter Prins1
Dirk Baron1
R. Postema1
SALE
Luciano Valente25
T. Van Bergen17
J. Pelupessy11
R. Postema11
Isak Määttä10
Laros Duarte10
Wouter Prins10
Jorg Schreuders9
R. Mendes7
M. Rente5
M. Peersman5
Paulos Abraham5
Leandro Bacuna4
K. Van Veen4
Noam Emeran3
Tomáš Suslov2
Kristian Lien2
R. Balker2
D. Irandust2
L. Van Gelderen2
Fofin Turay1
Johan Hove1
T. Blokzijl1

  USO DE MEMORIA  
5,379,080 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.3126
Total Execution Time  0.3141
  CADENA URL  
/estadisticas/Fc-Groningen/2024
  GET DATOS  
$_GET['/estadisticas/Fc-Groningen/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0255  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 = 72062
0.0135  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 = '1068' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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=1068 AND l.year in (2023,2024,2025) 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 (72637,72062,71432,67723) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 67723 AND teamId = 1068
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72062 AND teamId = 1068
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 1068
0.0218  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1068
0.0144  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 1068 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.0140  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 1068 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 1068 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 1068 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 1068 AND (e.action = 19) 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 events2024 e ON e.player_id = p.id AND e.league_id = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 1068 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30