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

UD Paiosaco

Entrenador: Diego Armando

Temporada 2023/2024

Estadísticas

ENTRA
Iván Amor15
Willian13
C. Quintas12
Josiño8
Laye7
Popi7
Pablo7
A. Pérez6
Toni Vilar6
Dani Carnota5
Bilal4
Eiroa4
Beto3
Moure3
J. Sande3
F. Gordo2
J. Raña2
Parafita2
Ventola2
Juanma1
SALE
Josiño12
Dani Carnota11
Willian10
F. Gordo10
C. Quintas8
Bilal8
Beto7
Juanma6
Moure6
A. Pérez4
Laye4
Popi4
Parafita4
Pablo4
J. Sande3
Iván Amor3
Toni Vilar2
Eiroa2
J. Raña2
Iván Dopico2

  USO DE MEMORIA  
4,950,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1947
Total Execution Time  0.1966
  CADENA URL  
/estadisticas/Ud-Paiosaco-Hierros
  GET DATOS  
$_GET['/estadisticas/Ud-Paiosaco-Hierros']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18892 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18892 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (528523,822157,831531,886617,1223270) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '18892' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18892 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18892 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18892 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30