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

Watford

Entrenador: Tom Cleverley

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Yáser Asprilla6
G. Chakvetadze4
Ken Sema4
Imrân Louza3
Vakoun Bayo3
R. Porteous3
Edo Kayembe2
Tom Ince2
Wesley Hoedt2
Ryan Andrews2
Jamal Lewis2
Ismaël Koné2
A. Dele-Bashiru2
Matheus Martins2
Jeremy Ngakia1
Jake Livermore1
Rhys Healey1
F. Sierralta1
ENTRA
Mileta Rajovic23
G. Chakvetadze20
Tom Ince19
Matheus Martins17
Rhys Healey16
Yáser Asprilla16
Ismaël Koné14
Ryan Andrews13
Vakoun Bayo12
Mattie Pollock8
A. Dele-Bashiru7
Edo Kayembe7
E. Dennis6
Ken Sema5
Jake Livermore4
Imrân Louza4
F. Sierralta4
R. Porteous4
Jamal Lewis3
Jeremy Ngakia3
J. Morris1
SALE
Vakoun Bayo18
Yáser Asprilla18
Matheus Martins17
Ismaël Koné17
A. Dele-Bashiru14
Jake Livermore13
G. Chakvetadze12
Jamal Lewis12
Ken Sema11
Mileta Rajovic10
Edo Kayembe9
Tom Ince8
Imrân Louza8
E. Dennis8
Ryan Andrews6
F. Sierralta5
Jeremy Ngakia5
J. Morris5
Mattie Pollock2
Rhys Healey2
R. Porteous1

  USO DE MEMORIA  
5,595,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0690
Total Execution Time  0.0702
  CADENA URL  
/estadisticas/Watford-Fc
  GET DATOS  
$_GET['/estadisticas/Watford-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0040  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 = 72258
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2743 AND type_rel = 2
0.0039  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2743 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (492,1161,1202,1491,1493) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '2743' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0068  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 = 2743 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0065  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 = 2743 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054  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 = 2743 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30