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

Estadísticas

ASISTENCIAS
Luuk De Jong14
J. Veerman13
Malik Tillman10
Jordan Teze9
J. Bakayoko9
Sergiño Dest6
Guus Til5
Ismael Saibari4
O. Boscagli3
H. Lozano3
Tygo Land1
Y. Vertessen1
I. Sangaré1
Ricardo Pepi1
Noa Lang1
P. Van Aanholt1
André Ramalho1
ENTRA
Ricardo Pepi23
Y. Vertessen14
Isaac Babadi13
P. Van Aanholt12
Malik Tillman11
J. Van Duiven10
S. Sambo9
Ismael Saibari8
A. Obispo8
Mauro Júnior7
Guus Til7
H. Lozano5
André Ramalho4
J. Bakayoko3
Noa Lang3
Tygo Land3
A. Bella-Kotchap2
J. Schouten1
A. El-Ghazi1
O. Boscagli1
Jesper Uneken1
Jordan Teze1
SALE
Luuk De Jong21
J. Bakayoko13
Guus Til12
J. Veerman11
André Ramalho11
H. Lozano10
Noa Lang8
Sergiño Dest8
O. Boscagli7
Malik Tillman7
Ismael Saibari6
J. Schouten6
Jordan Teze5
Mauro Júnior4
Y. Vertessen3
Isaac Babadi2
A. Bella-Kotchap2
J. Van Duiven1
P. Van Aanholt1

  USO DE MEMORIA  
6,084,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2791
Total Execution Time  0.2804
  CADENA URL  
/estadisticas/Psv
  GET DATOS  
$_GET['/estadisticas/Psv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0173  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 = 'Psv' 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.0107  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0114  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=2023 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0199  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 = '2023' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0234  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 = 72048 WHERE rp.league_id = 72048 AND rp.teamId = 2023 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174  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 = 72048 WHERE rp.league_id = 72048 AND rp.teamId = 2023 AND (e.action = 19) 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 = 72048 WHERE rp.league_id = 72048 AND rp.teamId = 2023 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30