4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Deportivo Alavés - Barcelona
FINALIZADO
20
30
1962 Pts. Elo
17º

3750 Pts. Elo

0-2
Sábado, 26 Agosto 2017, 18:15
0 - 1
55' L. Messi
0 - 2
66' L. Messi

Eventos del partido

Goles

minuto 55'L. MessiGol de L. Messi
minuto 66'L. MessiGol de L. Messi

Tarjetas

minuto 32'Samuel UmtitiT. Amarilla Samuel Umtiti
M. WakasoT. Amarilla
M. Wakaso
minuto 36'
Rodrigo ElyT. Amarilla
Rodrigo Ely
minuto 38'
minuto 41'Sergi RobertoT. Amarilla Sergi Roberto
minuto 45'G. PiquéT. Amarilla G. Piqué

Ocasiones

minuto 39'L. MessiPenalti fallado L. Messi
F. PachecoPenalti parado
F. Pacheco
minuto 39'
minuto 74'L. MessiTiro al palo L. Messi

Cambios

minuto 57'P. AlcácerEntra en el partido P. Alcácer
minuto 57'Aleix VidalSale del partido Aleix Vidal
BurguiEntra en el partido
Burgui
minuto 67'
Ibai GómezSale del partido
Ibai Gómez
minuto 67'
minuto 71'Denis SuárezEntra en el partido Denis Suárez
minuto 71'G. DeulofeuSale del partido G. Deulofeu
Enzo ZidaneEntra en el partido
Enzo Zidane
minuto 77'
M. WakasoSale del partido
M. Wakaso
minuto 77'
C. SantosEntra en el partido
C. Santos
minuto 78'
Rubén SobrinoSale del partido
Rubén Sobrino
minuto 78'
minuto 88'PaulinhoEntra en el partido Paulinho
minuto 88'Andres IniestaSale del partido Andres Iniesta

Otros

minuto 55'Jordi AlbaAsistencia Jordi Alba
minuto 66'P. AlcácerAsistencia P. Alcácer
12 Comentarios + 107 respuestas
  • patatero
    Hace 6 años patatero dice: por cierto, el penalti no era. y ya van dos errores graves en nuestra contra en dos jornadas.
  • patatero
    Actualizado hace 6 años (Creado hace 6 años ) patatero dice: , que la defensa si no es por Alexis no estuvo mal, con las ganas y criterio que intentaron poner Pina-Romero-Sobrino y luego Enzo y Santos. Wakaso bien pero vaya cabezita....la patada de la primera parte a sergi Roberto sin venir a cuenta era de naranja colorado. Alexis mal, esperemos que maripán se conjunte rápido. Vigaray voluntarioso pero algo desacertado. Y desaparecidos Manu e Ibai, pero yo confío en ellos (en el primero sobre todo, es nuestro capitán y nos necesita, no se merece que a las primeras de cambio lo que hace unos meses eran halagos ahora se convierta en desprecio). Urge eso s
  • patatero
    Hace 6 años patatero dice: jugar y que hasta el primer gol no consiguieron sacudirse ese acoso. Cierto es que la salida del balón fue mala en la primera parte (Alexis sobre todo) y que si no metemos las que tenemos ante estos pues ya se sabe...el año pasado en el Camp Nou tuvimos dos y las metimos. Ayer tuvimos dos clarísimas con el 0-0 (sobrino y manu) y no las metimos, mala suerte. Toda esa seriedad defensiva de la primera parte la perdimos en la segunda siendo muy dóciles en el primer gol y bastante absurdo lo que hace Alexis en el segundo gol la verdad. Personalmente me quedo con que Pache sigue siendo una bestia, q
  • patatero
    Hace 6 años patatero dice: Para nada comparto que un partido contra el Barcelona, que por muy mal que esté es el Barcelona, pueda servir para anunciar una catástrofe en la jornada 2. Si empezamos con tanto pesimismo en agosto se va a crear un clima que lo único que va a hacer va a ser perjudicar al equipo. seamos conscientes de ello.

    Para mi planteamiento y el equipo consiguieron frenarlos durante 45 minutos. Creo que conseguimos estar muy juntos sin meternos demasiado en el área y que esa fue una buena táctica mientras no encajamos gol. El propio Valverde reconoció que nosotros no les dejamos espacios para j
  • glorioso1990
    Hace 6 años glorioso1990 dice: Un Barça con mucho balon pero pocas ocasiones claras de gol, Messi aprovecha los regalos y el primer gol con fortuna, grande Pacheco parando el penalti al enano jaja, a seguir mejorando y el apron nos vendra bien, AUPA ALAVES!
  • alavesitoj
    Hace 6 años alavesitoj dice: NAVIDAD en agosto ha llegado Olentzero,ademas de no marcar hacemos regalos,muy mal partido ,el equipo esta muy verde, a ver si con el paron madura, nos han dominado de cabo a rabo, somos incapaces de sacar el balon jugado y no logramos ni una recuperacion cosa que no ocurria la anterior temporada con Llorente.Exceptuando Pacheco todo el equipo de pena,yo creo que el planteamiento ha dejado mucho que desear, el señor Santos es completamente nulo, no se si lo querra alguien regalado.O se ficha a alguien con garantias o estamos perdidos si no se mejora mucho GORA GLORIOSO
  • alphaaleman
    Hace 6 años alphaaleman dice: 1-1
  • glorioso1990
    Hace 6 años glorioso1990 dice: A por ellos!!! sin miedo que no estan bien, nosotros tampoco y nos queda cerrar la plantilla y hay que hacerlo cuanto antes, AUPA ALAVES!!
  • alavesitoj
    Hace 6 años alavesitoj dice: No se si habra pasta para fichajes a pesar del dinero de las tv o si tambien sirve para financiar el baloncesto pues el tio Josean como dice el refran "no da puntada sin hilo" creo ya sabemos lo que significa
  • betty03
    Hace 6 años betty03 dice: Gana barcelona.
  • deportivodecoru
    Hace 6 años deportivodecoru dice: seguro que gana el alaves sin que le roben el partido como de costumbre mas ahora que tienen 222 kilos para comprar arbitros
  • alavesitoj
    Hace 6 años alavesitoj dice: Mal se nos presenta este partido con un grupo todavia sin ensamblar y con muchas carencias con posibles cesiones fustradas y plantilla todavia sin cerrar, no se a que espera la secretaria tecnica, con un equipo que ha demostrado que no tiene alma, espero que por lo menos demos la cara con decision e intensidad y se luche como se hacia la pasada temporada,habra que buscar la forma de parar a Messi o nos hara un roto. Siendo optimista voy a por 0.0 GORA GLORIOSO

Partido televisado en...
Canal Medio Idioma País
beIN LaLiga TV Castellano
ESPN 2 TV Latino
ESPN 2 TV Latino
ESPN 2 TV Latino
ESPN 2 TV Latino

  USO DE MEMORIA  
6,918,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.6402
Total Execution Time  0.6411
  CADENA URL  
/partido/Alaves/Barcelona/2018
  GET DATOS  
$_GET['/partido/Alaves/Barcelona/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.2074   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '38645' AND c.`match_id` = '494846' AND c.comment_id IN (16689447,16689116,16689110,16689106,16687690,16680293,16670803,16627666,16621571,16634797,16625859,16611721) GROUP BY c.comment_id
0.0065   SELECT c.*, c.stadium as real_stadium, 2018 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2018 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Alaves' AND dt2.basealias = 'Barcelona'
0.0027  SELECT c.*, 2018 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2018 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Alaves' AND dt2.basealias = 'Barcelona'
0.0038  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 = 38645
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2018 AS ev WHERE ev.match_id=494846 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0024   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=38645 WHERE dp.id IN (23569,127121,61592,149491,81723,23560,78512,39979,39947,139075,30960,77230,81436,119069,145275,78301,133581,22806,28113) AND (rp.team_id=783055 OR rp.team_id=783058)
0.0018   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2018 AS ev WHERE ev.match_id=494846 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0022   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=38645 WHERE dp.id IN (127121,61592,149491,23569,78512,81723,23560,28113,39979,39947,139075,30960,77230,81436,119069,145275,78301,133581,22806) AND (rp.team_id=783055 OR rp.team_id=783058)
0.0018  SELECT data1 FROM stats2018 t WHERE league_id = 38645 AND teamId = 783055 and type = 33
0.0018  SELECT data1 FROM stats2018 t WHERE league_id = 38645 AND teamId = 783058 and type = 33
0.0020  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 38645 AND id_match = 494846
0.0023  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='38645' AND relp.team_id = drea.team_id WHERE rel.team_number=374723 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0025  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='38645' AND relp.team_id = drea.team_id WHERE rel.team_number=374724 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0031  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='38645' AND relp.team_id=783055 WHERE mp.`match_id` = '494846' AND mp.year='2018' AND p.id NOT IN (78512,23379,149491,246997,144261,28993,48124,156737,61592,30960,78301,67849,127121,23560,28113,39947,81723,27059,22806,2139,81436,23569) ORDER BY mp.`team` ASC, p.`role` ASC
0.0025  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='38645' AND relp.team_id=783058 WHERE mp.`match_id` = '494846' AND mp.year='2018' AND p.id NOT IN (78512,23379,149491,246997,144261,28993,48124,156737,61592,30960,78301,67849,127121,23560,28113,39947,81723,27059,22806,2139,81436,23569) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT kit FROM kit_data_real WHERE league_id = 38645 AND id_match = 494846
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '494846' and rp.type = 2018 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '494846' and rp.type = 2018 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 38645 AND rel.team1 = 783055 AND rel.team2 = 783058 ORDER BY FIELD(m.location,'es','en') DESC
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 494846 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 494846 AND year = 2018 AND channel = 'Footters' LIMIT 1
0.0023  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 38645 AND rel.team1 = 783055 AND rel.team2 = 783058 ORDER BY FIELD(m.location,'es','en') DESC
0.0031  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2018` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 38645 AND c.`round` = 2 ORDER BY shedule ASC LIMIT 12
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 38645 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2018` WHERE league_id = 38645 AND round >= 38 AND round <= 38 AND team = 783055 ORDER BY round ASC
0.0089   SELECT c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template, NOW() AS difference_time, fau.changeA AS changeA FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id=0 AND c.lang = '1' AND c.language = 'es' AND c.`league_id` = '38645' AND c.`match_id` = '494846' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0021   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16689447' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16689116' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0024   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16689110' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16689106' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16687690' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16680293' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16670803' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16627666' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16621571' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16634797' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0026   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16625859' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '16611721' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2018 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2018 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2018 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 783055 AND c.team2 = 783058 AND c.league_id = 38645
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='494846' AND `active` = 1 AND year = 2018
0.0018  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='494846' AND `active` = 1 AND year = 2018
0.0037  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='38645' AND relp.team_id=783055 WHERE relp.in_squad=1 and mp.`match_id` = '494846' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0030  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='38645' AND relp.team_id=783058 WHERE relp.in_squad=1 and mp.`match_id` = '494846' AND mp.year='2018' ORDER BY mp.`team` ASC, p.`role` ASC
0.0020  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '38645' AND id_match = '494846'
0.0020   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '374723' ORDER BY rating DESC LIMIT 1
0.0021   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '374724' ORDER BY rating DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=494846 AND extraId = 38645 AND type_rel = 4
0.0018  SELECT year FROM leagues WHERE id=38645
0.0018  SELECT shedule FROM calendars2018 WHERE id=494846
0.0038  SELECT /*115 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' INNER JOIN bs_news_rel rel ON rel.newId = n.id AND rel.type_rel = 4 AND rel.typeId = 494846 AND rel.extraId = 38645 WHERE n.status = 1 AND n.ln='es' AND n.creation_date>'2017-06-27 18:15:00' AND n.creation_date<'2017-10-25 18:15:00' GROUP BY n.id ORDER BY n.cover_points DESC,n.creation_date DESC LIMIT 5
0.0020  SELECT rating1, rating2 FROM calendars_elo WHERE id=494846 AND league_id=38645 AND year=2018
0.0018  SELECT position FROM tables2018 WHERE team=783055 AND league_id=38645 AND round=2
0.0018  SELECT position FROM tables2018 WHERE team=783058 AND league_id=38645 AND round=2
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 494846 AND league_id = 38645 AND year = 2018