4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de Bengaluru

Xisco

Jugador del Bengaluru
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Xisco
Nacionalidad
España
Nombre
Francisco Hernández Marcos
Edad
34 Años (31-07-1989)
Altura
177
Dorsal
7
Peso
80 kilogramos
Equipo
Bengaluru
Posición
Delantero
Liga
India Super League 2021
Twitter
@xiscohm31
Compañeros de equipo
Fotos
4
  • Foto principal de Xisco | At. Baleares
  • Foto principal de Xisco | At. Baleares
  • Xisco
  • Xisco
  • helio
    Hace 14 años helio dice: este jugador es de los mejores jugadores que tiene el mallorca b y la 2 b es mas no solo es uno de los mejores jugadores de 2 b sino que es una gran persona es mas es un entusiasmado del futbol lo se por esperiencia de haber conocido a este chico dentro y fuera del terreno de juego he salido de fiesta con el y lo que mas me sorprendio es que es un tipo normal no bebe,se cuida,sabe estar no es mu este jugador es de los mejores jugadores que tiene el mallorca b y la 2 b es mas no solo es uno de los mejores jugadores de 2 b sino que es una gran persona es mas es un entusiasmado del futbol lo se por esperiencia de haber conocido a este chico dentro y fuera del terreno de juego he salido de fiesta con el y lo que mas me sorprendio es que es un tipo normal no bebe,se cuida,sabe estar no es mu

  USO DE MEMORIA  
9,719,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Player / Index )  0.5608
Total Execution Time  0.5621
  CADENA URL  
/jugador/xisco-29333
  GET DATOS  
$_GET['/jugador/xisco-29333']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (168)  
0.0005   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.`playerId` = '29333' AND c.comment_id IN (280165) GROUP BY c.comment_id
0.0025  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'xisco-29333' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0126  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'xisco-29333' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0024  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 = 60036
0.0024  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 = 61160
0.0022  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 = 49917
0.0023  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 = 49173
0.0024  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.0023  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 = 39175
0.0024  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 = 43400
0.0022  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 = 37067
0.0023  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 = 38453
0.0024  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 = 15374
0.0024  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 = 19524
0.0023  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 = 30488
0.0025  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 = 3864
0.0024  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 = 14186
0.0024  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 = 2468
0.0022  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 = 1903
0.0022  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 = 1969
0.0022  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 = 1348
0.0022  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 = 1437
0.0023  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 = 1103
0.0022  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 = 1115
0.0025  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 = 828
0.0019  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '29333'
0.0027  SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 60036 AND rp.teamId = 15462 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0021  SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 29333 ORDER BY rp.year DESC
0.0025  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 = '29333' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29333' and rp.type = 3
0.0019  SELECT e.* FROM `events2021` e WHERE e.player_id = 29333 AND league_id = 60036 ORDER BY e.date ASC
0.0040  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 60036 AND rel.player_id=29333
0.0020  SELECT action,minute FROM events2021 WHERE player_id = 29333 AND league_id = 60036 AND action = 18
0.0020  SELECT action,minute FROM events2021 WHERE player_id = 29333 AND league_id = 60036 AND action = 19
0.0018  SELECT e.* FROM `events2021` e WHERE e.player_id = 29333 AND league_id = 61160 ORDER BY e.date ASC
0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61160 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 29333 AND league_id = 61160 AND action = 18
0.0018  SELECT action,minute FROM events2021 WHERE player_id = 29333 AND league_id = 61160 AND action = 19
0.0019  SELECT e.* FROM `events2020` e WHERE e.player_id = 29333 AND league_id = 49917 ORDER BY e.date ASC
0.0064  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49917 AND rel.player_id=29333
0.0021  SELECT action,minute FROM events2020 WHERE player_id = 29333 AND league_id = 49917 AND action = 18
0.0019  SELECT action,minute FROM events2020 WHERE player_id = 29333 AND league_id = 49917 AND action = 19
0.0019  SELECT e.* FROM `events2019` e WHERE e.player_id = 29333 AND league_id = 43697 ORDER BY e.date ASC
0.0047  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43697 AND rel.player_id=29333
0.0020  SELECT action,minute FROM events2019 WHERE player_id = 29333 AND league_id = 43697 AND action = 18
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 29333 AND league_id = 43697 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 29333 AND league_id = 49173 ORDER BY e.date ASC
0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49173 AND rel.player_id=29333
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 29333 AND league_id = 49173 AND action = 18
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 29333 AND league_id = 49173 AND action = 19
0.0018  SELECT e.* FROM `events2019` e WHERE e.player_id = 29333 AND league_id = 43475 ORDER BY e.date ASC
0.0040  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43475 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2019 WHERE player_id = 29333 AND league_id = 43475 AND action = 18
0.0019  SELECT action,minute FROM events2019 WHERE player_id = 29333 AND league_id = 43475 AND action = 19
0.0027  SELECT e.* FROM `events2018` e WHERE e.player_id = 29333 AND league_id = 38808 ORDER BY e.date ASC
0.0045  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38808 AND rel.player_id=29333
0.0026  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 38808 AND action = 18
0.0026  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 38808 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 29333 AND league_id = 38427 ORDER BY e.date ASC
0.0036  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38427 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 38427 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 38427 AND action = 19
0.0019  SELECT e.* FROM `events2018` e WHERE e.player_id = 29333 AND league_id = 39175 ORDER BY e.date ASC
0.0078  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39175 AND rel.player_id=29333
0.0039  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 39175 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 39175 AND action = 19
0.0018  SELECT e.* FROM `events2018` e WHERE e.player_id = 29333 AND league_id = 43400 ORDER BY e.date ASC
0.0052  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43400 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 43400 AND action = 18
0.0018  SELECT action,minute FROM events2018 WHERE player_id = 29333 AND league_id = 43400 AND action = 19
0.0020  SELECT e.* FROM `events2017` e WHERE e.player_id = 29333 AND league_id = 33380 ORDER BY e.date ASC
0.0045  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33380 AND rel.player_id=29333
0.0022  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 33380 AND action = 18
0.0022  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 33380 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 29333 AND league_id = 30386 ORDER BY e.date ASC
0.0064  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 30386 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 30386 AND action = 19
0.0018  SELECT e.* FROM `events2017` e WHERE e.player_id = 29333 AND league_id = 37067 ORDER BY e.date ASC
0.0069  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37067 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 37067 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 37067 AND action = 19
0.0019  SELECT e.* FROM `events2017` e WHERE e.player_id = 29333 AND league_id = 38453 ORDER BY e.date ASC
0.0076  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38453 AND rel.player_id=29333
0.0019  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 38453 AND action = 18
0.0018  SELECT action,minute FROM events2017 WHERE player_id = 29333 AND league_id = 38453 AND action = 19
0.0030  SELECT e.* FROM `events2016` e WHERE e.player_id = 29333 AND league_id = 15374 ORDER BY e.date ASC
0.0076  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15374 AND rel.player_id=29333
0.0026  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 15374 AND action = 18
0.0023  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 15374 AND action = 19
0.0023  SELECT e.* FROM `events2016` e WHERE e.player_id = 29333 AND league_id = 15377 ORDER BY e.date ASC
0.0313  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15377 AND rel.player_id=29333
0.0031  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 15377 AND action = 18
0.0028  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 15377 AND action = 19
0.0024  SELECT e.* FROM `events2016` e WHERE e.player_id = 29333 AND league_id = 16245 ORDER BY e.date ASC
0.0083  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16245 AND rel.player_id=29333
0.0024  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 16245 AND action = 18
0.0024  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 16245 AND action = 19
0.0026  SELECT e.* FROM `events2016` e WHERE e.player_id = 29333 AND league_id = 16597 ORDER BY e.date ASC
0.0077  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16597 AND rel.player_id=29333
0.0023  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 16597 AND action = 18
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 16597 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 29333 AND league_id = 19524 ORDER BY e.date ASC
0.0064  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 19524 AND rel.player_id=29333
0.0021  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 19524 AND action = 18
0.0022  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 19524 AND action = 19
0.0020  SELECT e.* FROM `events2016` e WHERE e.player_id = 29333 AND league_id = 30488 ORDER BY e.date ASC
0.0022  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30488 AND rel.player_id=29333
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 30488 AND action = 18
0.0020  SELECT action,minute FROM events2016 WHERE player_id = 29333 AND league_id = 30488 AND action = 19
0.0024  SELECT e.* FROM `events2015` e WHERE e.player_id = 29333 AND league_id = 3864 ORDER BY e.date ASC
0.0059  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3864 AND rel.player_id=29333
0.0022  SELECT action,minute FROM events2015 WHERE player_id = 29333 AND league_id = 3864 AND action = 18
0.0021  SELECT action,minute FROM events2015 WHERE player_id = 29333 AND league_id = 3864 AND action = 19
0.0020  SELECT e.* FROM `events2015` e WHERE e.player_id = 29333 AND league_id = 3992 ORDER BY e.date ASC
0.0043  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3992 AND rel.player_id=29333
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 29333 AND league_id = 3992 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 29333 AND league_id = 3992 AND action = 19
0.0018  SELECT e.* FROM `events2015` e WHERE e.player_id = 29333 AND league_id = 14186 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 14186 AND rel.player_id=29333
0.0019  SELECT action,minute FROM events2015 WHERE player_id = 29333 AND league_id = 14186 AND action = 18
0.0018  SELECT action,minute FROM events2015 WHERE player_id = 29333 AND league_id = 14186 AND action = 19
0.0021  SELECT e.* FROM `events2014` e WHERE e.player_id = 29333 AND league_id = 2468 ORDER BY e.date ASC
0.0019  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2468 AND rel.player_id=29333
0.0019  SELECT action,minute FROM events2014 WHERE player_id = 29333 AND league_id = 2468 AND action = 18
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 29333 AND league_id = 2468 AND action = 19
0.0029  SELECT e.* FROM `events2014` e WHERE e.player_id = 29333 AND league_id = 2399 ORDER BY e.date ASC
0.0044  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2399 AND rel.player_id=29333
0.0018  SELECT action,minute FROM events2014 WHERE player_id = 29333 AND league_id = 2399 AND action = 18
0.0036  SELECT action,minute FROM events2014 WHERE player_id = 29333 AND league_id = 2399 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 29333 AND league_id = 1903 ORDER BY e.date ASC
0.0018  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1903 AND rel.player_id=29333
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 29333 AND league_id = 1903 AND action = 18
0.0020  SELECT action,minute FROM events2013 WHERE player_id = 29333 AND league_id = 1903 AND action = 19
0.0020  SELECT e.* FROM `events2013` e WHERE e.player_id = 29333 AND league_id = 1969 ORDER BY e.date ASC
0.0074  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1969 AND rel.player_id=29333
0.0021  SELECT action,minute FROM events2013 WHERE player_id = 29333 AND league_id = 1969 AND action = 18
0.0028  SELECT action,minute FROM events2013 WHERE player_id = 29333 AND league_id = 1969 AND action = 19
0.0021  SELECT e.* FROM `events2013` e WHERE e.player_id = 29333 AND league_id = 2339 ORDER BY e.date ASC
0.0059  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2339 AND rel.player_id=29333
0.0024  SELECT action,minute FROM events2013 WHERE player_id = 29333 AND league_id = 2339 AND action = 18
0.0023  SELECT action,minute FROM events2013 WHERE player_id = 29333 AND league_id = 2339 AND action = 19
0.0023  SELECT e.* FROM `events2012` e WHERE e.player_id = 29333 AND league_id = 1334 ORDER BY e.date ASC
0.0083  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1334 AND rel.player_id=29333
0.0022  SELECT action,minute FROM events2012 WHERE player_id = 29333 AND league_id = 1334 AND action = 18
0.0024  SELECT action,minute FROM events2012 WHERE player_id = 29333 AND league_id = 1334 AND action = 19
0.0023  SELECT e.* FROM `events2012` e WHERE e.player_id = 29333 AND league_id = 1348 ORDER BY e.date ASC
0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1348 AND rel.player_id=29333
0.0020  SELECT action,minute FROM events2012 WHERE player_id = 29333 AND league_id = 1348 AND action = 18
0.0027  SELECT action,minute FROM events2012 WHERE player_id = 29333 AND league_id = 1348 AND action = 19
0.0021  SELECT e.* FROM `events2012` e WHERE e.player_id = 29333 AND league_id = 1437 ORDER BY e.date ASC
0.0087  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1437 AND rel.player_id=29333
0.0022  SELECT action,minute FROM events2012 WHERE player_id = 29333 AND league_id = 1437 AND action = 18
0.0021  SELECT action,minute FROM events2012 WHERE player_id = 29333 AND league_id = 1437 AND action = 19
0.0023  SELECT e.* FROM `events2011` e WHERE e.player_id = 29333 AND league_id = 1103 ORDER BY e.date ASC
0.0053  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1103 AND rel.player_id=29333
0.0020  SELECT action,minute FROM events2011 WHERE player_id = 29333 AND league_id = 1103 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 29333 AND league_id = 1103 AND action = 19
0.0019  SELECT e.* FROM `events2011` e WHERE e.player_id = 29333 AND league_id = 1115 ORDER BY e.date ASC
0.0046  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1115 AND rel.player_id=29333
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 29333 AND league_id = 1115 AND action = 18
0.0019  SELECT action,minute FROM events2011 WHERE player_id = 29333 AND league_id = 1115 AND action = 19
0.0020  SELECT e.* FROM `events2010` e WHERE e.player_id = 29333 AND league_id = 828 ORDER BY e.date ASC
0.0049  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 828 AND rel.player_id=29333
0.0020  SELECT action,minute FROM events2010 WHERE player_id = 29333 AND league_id = 828 AND action = 18
0.0022  SELECT action,minute FROM events2010 WHERE player_id = 29333 AND league_id = 828 AND action = 19
0.0023   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.`playerId` = '29333' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
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 = '280165' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20