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

Estadísticas

ASISTENCIAS
L. Menjívar4
L. Vásquez4
J. Perez2
N. Ascensio2
B. Landaverde2
E. Moscoso2
Dany Cetré1
Fernando Estrada1
ENTRA
S. Guerra16
L. Martinez10
Diego Fuentes7
C. Rosa6
M. Garcia5
K. Calderón5
Diego Guevara4
J. González4
André Hurtado4
Josué Dubon3
A. Henríquez3
N. Ascensio3
Dany Cetré3
Fernando Estrada3
L. Vásquez3
B. Landaverde3
J. Arboleda3
L. Menjívar2
E. Moscoso2
G. Henríquez1
R. Guevara1
J. Ortega1
J. Perez1
SALE
L. Vásquez14
Dany Cetré9
L. Menjívar8
A. Henríquez7
B. Landaverde6
S. Guerra5
G. Henríquez4
J. González4
J. Perez4
Fernando Estrada4
M. Garcia3
Diego Guevara3
André Hurtado3
J. Ortega3
L. Martinez3
E. Moscoso3
N. Ascensio2
J. Arboleda2
C. Rosa2
Josué Dubon1
Diego Fuentes1
K. Calderón1
W. Menjívar1

  USO DE MEMORIA  
4,923,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0674
Total Execution Time  0.0687
  CADENA URL  
/estadisticas/Chalatenango
  GET DATOS  
$_GET['/estadisticas/Chalatenango']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64903 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 64903 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0030  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 (20319,22563,67864,116959,133075) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '64903' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = '64903' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 events2023 e ON e.player_id = p.id AND e.league_id = 70943 WHERE rp.league_id = 70943 AND rp.teamId = 64903 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 events2023 e ON e.player_id = p.id AND e.league_id = 70943 WHERE rp.league_id = 70943 AND rp.teamId = 64903 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0051  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 events2023 e ON e.player_id = p.id AND e.league_id = 70943 WHERE rp.league_id = 70943 AND rp.teamId = 64903 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30