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

Chaves

Entrenador: Moreno Teixeira

Temporada 2023/2024

Estadísticas

ASISTENCIAS
K. Nwakali4
L. Sanca3
Issah Abass2
Jô Batista2
Héctor Hernández1
Guima1
João Correia1
Paulo Victor1
Benny1
R. Lameiras1
Rúben Ribeiro1
Sandro Cruz1
ENTRA
L. Sanca18
Jô Batista16
Benny15
Paulo Victor14
Hélder Morim12
R. Lameiras10
Pedro Pinho9
João Pedro9
Carraça8
K. Nwakali7
Guima5
Dario Essugo5
João Correia5
Rúben Ribeiro4
S. Vitoria4
Issah Abass4
João Queirós3
Bruno Langa3
Habib Sylla3
Cafú Phete2
Sandro Cruz2
R. Guzzo1
Y. Nogueira1
Rodrigo Melro1
SALE
K. Nwakali14
Héctor Hernández12
João Correia12
R. Guzzo11
Guima10
Benny9
L. Sanca9
R. Lameiras8
Rúben Ribeiro8
Sandro Cruz8
Jô Batista7
Cafú Phete5
Dario Essugo4
Carraça4
João Pedro4
J. Pius4
Paulo Victor4
S. Vitoria3
Bruno Rodrigues3
Hélder Morim3
Bruno Langa2
Habib Sylla2
Issah Abass2
Y. Nogueira1
Pedro Pinho1
V. Fernandes1
João Queirós1

  USO DE MEMORIA  
5,451,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2516
Total Execution Time  0.2536
  CADENA URL  
/estadisticas/Chaves
  GET DATOS  
$_GET['/estadisticas/Chaves']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0293  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 = 72505
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7018 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7018 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (35533,67995,68503,69261,73231) ORDER BY n.cover_points DESC, update_date DESC
0.0152  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 = '7018' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0165  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 7018 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 7018 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 72053 WHERE rp.league_id = 72053 AND rp.teamId = 7018 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30