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

Elche

Entrenador: Sebastián Beccacece

Presidente: Joaquín Buitrago

Temporada 2017/2018

Estadísticas

ENTRA
Benja2
S. Kaba2
Provencio2
Collantes2
Adrián1
Iván Sánchez1
Javi Flores1
Tekio1
Lavsamba1
José Juan1
Lolo Plá1
SALE
Benja2
Lolo Plá2
G. Corozo2
Javi Flores2
Adrián1
Iván Sánchez1
Diego Benito1
Peris1
Lavsamba1
Guille Vallejo1
Manolin Sánchez1

  USO DE MEMORIA  
5,488,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.4880
Total Execution Time  0.4891
  CADENA URL  
/estadisticas/Elche/2018
  GET DATOS  
$_GET['/estadisticas/Elche/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0255  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 = 38808
0.0134  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 = 43436
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=975 AND type_rel = 2
0.0257  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 975 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131  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 (1312875,1312694,1311805,1310966,1309597) ORDER BY n.cover_points DESC, update_date DESC
0.0143  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 = '975' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 43436 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=975 AND l.year in (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0137  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (44594,43686,43475,43436,38808) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 43686 AND teamId = 975
0.0165  SELECT count(id) as num_players from rel_players WHERE league_id = 38808 AND teamId = 975
0.0181  SELECT count(id) as num_players from rel_players WHERE league_id = 44594 AND teamId = 975
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 43436 AND teamId = 975
0.0264  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 975
0.0134  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '975' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '975' and rp.type = 4
0.0133  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '975' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '975' and rp.type = 4
0.0145  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 events2018 e ON e.player_id = p.id AND e.league_id = 39175 WHERE rp.league_id = 39175 AND rp.teamId = 975 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 events2018 e ON e.player_id = p.id AND e.league_id = 39175 WHERE rp.league_id = 39175 AND rp.teamId = 975 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 events2018 e ON e.player_id = p.id AND e.league_id = 39175 WHERE rp.league_id = 39175 AND rp.teamId = 975 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0161  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 events2018 e ON e.player_id = p.id AND e.league_id = 39175 WHERE rp.league_id = 39175 AND rp.teamId = 975 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0201  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 events2018 e ON e.player_id = p.id AND e.league_id = 39175 WHERE rp.league_id = 39175 AND rp.teamId = 975 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0225  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 events2018 e ON e.player_id = p.id AND e.league_id = 39175 WHERE rp.league_id = 39175 AND rp.teamId = 975 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30