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

Villanovense

Entrenador: Gus

Temporada 2023/2024

Estadísticas

ASISTENCIAS
Isra Cano4
Benji3
David Agudo2
Hurtado1
Bermúdez1
Ángel Gómez1
M. Ortiz1
Relu1
Guille Campos1
Alberto Fuentes1
ENTRA
Pajuelo19
David Agudo14
Benji12
Javi Sánchez11
Bermúdez11
Facu10
Julián Martínez9
Sillero9
Aday Alcalde8
Mario González6
Isra Cano6
Óscar Cantarero6
Guille Campos5
Yimi5
L. Morcillo4
Adighibe3
Alberto Páez3
Alberto Fuentes3
M. Ortiz2
Hurtado2
Relu1
Viti1
Ángel Gómez1
Carlos Cano1
SALE
Isra Cano15
Alberto Fuentes15
Bermúdez14
Hurtado13
Mario González12
M. Ortiz8
Guille Campos8
Adighibe8
Sillero8
David Agudo7
Javi Sánchez6
Benji5
Relu4
Julián Martínez4
Yimi4
Facu4
Pajuelo4
Ángel Gómez3
Aday Alcalde3
L. Morcillo3
Joshua Farrell1

  USO DE MEMORIA  
5,428,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0504
Total Execution Time  0.0518
  CADENA URL  
/estadisticas/Cf-Villanovense
  GET DATOS  
$_GET['/estadisticas/Cf-Villanovense']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=739 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 739 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (609,1903,2601,2835,3254) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '739' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0032  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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 739 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 739 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 72366 WHERE rp.league_id = 72366 AND rp.teamId = 739 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30