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

Bruno

Jugador del Villarreal
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Bruno
Nacionalidad
España
Nombre
Bruno Soriano Llido
Edad
39 Años (12-06-1984)
Altura
184
Dorsal
21
Peso
70 kilogramos
Equipo
Villarreal
Posición
Centrocampista
Liga
Primera División 2020
Compañeros de equipo
Fotos
11
  • Foto principal de Bruno | Villarreal
  • Foto principal de Bruno | Villarreal
  • Foto principal de Bruno | Villarreal
  • Foto principal de Bruno | Villarreal
  • Foto principal de Bruno | España
  • Foto principal de Bruno | Villarreal
  • Foto principal de Bruno | Villarreal
  • Bruno
  • Bruno
  • Bruno
  • Bruno
5 Comentarios
  • eloito
    Hace 11 años eloito dice: Yo lo conozco es un gran jugador y una muy buena persona
  • joseherranzl
    Hace 11 años joseherranzl dice: medio gran jugador
  • bosh
    Hace 11 años bosh dice: Como no ascienda el villareal se va
  • vivalamaria
    Hace 11 años vivalamaria dice: Bruno a la roja hombre
  • Hace 13 años manuel2009 dice: Es el novio de la prima de un amigo mío Es el novio de la prima de un amigo mío

  USO DE MEMORIA  
14,236,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  5.7260
Total Execution Time  5.7271
  CADENA URL  
/jugador/b-soriano-27041
  GET DATOS  
$_GET['/jugador/b-soriano-27041']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (363)  
0.0006   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` = '27041' AND c.comment_id IN (2036717,1891281,1858571,1722510,654237) GROUP BY c.comment_id
0.0152  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 = 'b-soriano-27041' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0582  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 = 'b-soriano-27041' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0150  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 = 49844
0.0150  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 = 43542
0.0150  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 = 44594
0.0155  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 = 44996
0.0150  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.0150  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.0152  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 = 39624
0.0151  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 = 41795
0.0150  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 = 44617
0.0153  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 = 30386
0.0152  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 = 33904
0.0153  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 = 34117
0.0152  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 = 34915
0.0151  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 = 37544
0.0152  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 = 16586
0.0152  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 = 16740
0.0152  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 = 19985
0.0151  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 = 20032
0.0152  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 = 33337
0.0150  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 = 3775
0.0149  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 = 3992
0.0151  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 = 4017
0.0151  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 = 4249
0.0151  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 = 4250
0.0152  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 = 15539
0.0151  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 = 73288
0.0152  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 = 4262
0.0151  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 = 2399
0.0150  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 = 2735
0.0151  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 = 3595
0.0150  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.0150  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 = 1334
0.0150  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.0151  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 = 1443
0.0151  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 = 25249
0.0152  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 = 42844
0.0155  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.0156  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 = 1253
0.0155  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 = 894
0.0154  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 = 961
0.0172  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 = 967
0.0172  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 = 996
0.0174  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 = 39416
0.0172  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 = 42906
0.0152  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 = 730
0.0151  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 = 72577
0.0152  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 = 2
0.0156  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 = 11015
0.0156  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 = 11018
0.0154  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 = 20575
0.0151  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 = 11986
0.0151  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 = 20576
0.0150  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 = 72579
0.0144  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 = '27041'
0.0156  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 = 49844 AND rp.teamId = 2716 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0150  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 = 27041 ORDER BY rp.year DESC
0.0150  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 = '27041' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '27041' and rp.type = 3
0.0146  SELECT e.* FROM `events2020` e WHERE e.player_id = 27041 AND league_id = 49844 ORDER BY e.date ASC
0.0169  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49844 AND rel.player_id=27041
0.0150  SELECT action,minute FROM events2020 WHERE player_id = 27041 AND league_id = 49844 AND action = 18
0.0150  SELECT action,minute FROM events2020 WHERE player_id = 27041 AND league_id = 49844 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 27041 AND league_id = 49506 ORDER BY e.date ASC
0.0168  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49506 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 27041 AND league_id = 49506 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 27041 AND league_id = 49506 AND action = 19
0.0145  SELECT e.* FROM `events2020` e WHERE e.player_id = 27041 AND league_id = 51355 ORDER BY e.date ASC
0.0160  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 51355 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 27041 AND league_id = 51355 AND action = 18
0.0145  SELECT action,minute FROM events2020 WHERE player_id = 27041 AND league_id = 51355 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 27041 AND league_id = 43542 ORDER BY e.date ASC
0.0166  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43542 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 43542 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 43542 AND action = 19
0.0146  SELECT e.* FROM `events2019` e WHERE e.player_id = 27041 AND league_id = 43475 ORDER BY e.date ASC
0.0200  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=27041
0.0149  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 43475 AND action = 18
0.0151  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 43475 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 27041 AND league_id = 44594 ORDER BY e.date ASC
0.0160  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44594 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 44594 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 44594 AND action = 19
0.0146  SELECT e.* FROM `events2019` e WHERE e.player_id = 27041 AND league_id = 44996 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44996 AND rel.player_id=27041
0.0150  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 44996 AND action = 18
0.0144  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 44996 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 27041 AND league_id = 48458 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48458 AND rel.player_id=27041
0.0148  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 48458 AND action = 18
0.0149  SELECT action,minute FROM events2019 WHERE player_id = 27041 AND league_id = 48458 AND action = 19
0.0148  SELECT e.* FROM `events2018` e WHERE e.player_id = 27041 AND league_id = 38645 ORDER BY e.date ASC
0.0204  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38645 AND rel.player_id=27041
0.0150  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 38645 AND action = 18
0.0153  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 38645 AND action = 19
0.0151  SELECT e.* FROM `events2018` e WHERE e.player_id = 27041 AND league_id = 38427 ORDER BY e.date ASC
0.0197  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=27041
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 38427 AND action = 18
0.0146  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 38427 AND action = 19
0.0148  SELECT e.* FROM `events2018` e WHERE e.player_id = 27041 AND league_id = 39175 ORDER BY e.date ASC
0.0177  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=27041
0.0149  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 39175 AND action = 18
0.0147  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 39175 AND action = 19
0.0151  SELECT e.* FROM `events2018` e WHERE e.player_id = 27041 AND league_id = 39624 ORDER BY e.date ASC
0.0156  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39624 AND rel.player_id=27041
0.0150  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 39624 AND action = 18
0.0150  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 39624 AND action = 19
0.0145  SELECT e.* FROM `events2018` e WHERE e.player_id = 27041 AND league_id = 41795 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41795 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 41795 AND action = 18
0.0152  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 41795 AND action = 19
0.0150  SELECT e.* FROM `events2018` e WHERE e.player_id = 27041 AND league_id = 44617 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44617 AND rel.player_id=27041
0.0149  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 44617 AND action = 18
0.0146  SELECT action,minute FROM events2018 WHERE player_id = 27041 AND league_id = 44617 AND action = 19
0.0146  SELECT e.* FROM `events2017` e WHERE e.player_id = 27041 AND league_id = 30626 ORDER BY e.date ASC
0.0166  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30626 AND rel.player_id=27041
0.0149  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 30626 AND action = 18
0.0149  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 30626 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 27041 AND league_id = 30386 ORDER BY e.date ASC
0.0186  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=27041
0.0146  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 30386 AND action = 18
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 30386 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 27041 AND league_id = 33904 ORDER BY e.date ASC
0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33904 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 33904 AND action = 18
0.0148  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 33904 AND action = 19
0.0149  SELECT e.* FROM `events2017` e WHERE e.player_id = 27041 AND league_id = 34117 ORDER BY e.date ASC
0.0161  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 34117 AND rel.player_id=27041
0.0153  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 34117 AND action = 18
0.0151  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 34117 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 27041 AND league_id = 34915 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 34915 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 34915 AND action = 18
0.0152  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 34915 AND action = 19
0.0149  SELECT e.* FROM `events2017` e WHERE e.player_id = 27041 AND league_id = 37544 ORDER BY e.date ASC
0.0180  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37544 AND rel.player_id=27041
0.0150  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 37544 AND action = 18
0.0150  SELECT action,minute FROM events2017 WHERE player_id = 27041 AND league_id = 37544 AND action = 19
0.0157  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 15373 ORDER BY e.date ASC
0.0318  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15373 AND rel.player_id=27041
0.0147  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 15373 AND action = 18
0.0148  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 15373 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 16245 ORDER BY e.date ASC
0.0147  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=27041
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16245 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16245 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 16586 ORDER BY e.date ASC
0.0176  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16586 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16586 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16586 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 16597 ORDER BY e.date ASC
0.0154  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=27041
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16597 AND action = 18
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16597 AND action = 19
0.0145  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 16740 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16740 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16740 AND action = 18
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 16740 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 19985 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 19985 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 19985 AND action = 18
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 19985 AND action = 19
0.0147  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 20032 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20032 AND rel.player_id=27041
0.0147  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 20032 AND action = 18
0.0153  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 20032 AND action = 19
0.0152  SELECT e.* FROM `events2016` e WHERE e.player_id = 27041 AND league_id = 33337 ORDER BY e.date ASC
0.0166  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33337 AND rel.player_id=27041
0.0158  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 33337 AND action = 18
0.0149  SELECT action,minute FROM events2016 WHERE player_id = 27041 AND league_id = 33337 AND action = 19
0.0148  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 3775 ORDER BY e.date ASC
0.0172  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3775 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 3775 AND action = 18
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 3775 AND action = 19
0.0146  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 3804 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3804 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 3804 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 3804 AND action = 19
0.0146  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 3992 ORDER BY e.date ASC
0.0154  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=27041
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 3992 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 3992 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 4017 ORDER BY e.date ASC
0.0155  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4017 AND rel.player_id=27041
0.0147  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4017 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4017 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 4249 ORDER BY e.date ASC
0.0149  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4249 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4249 AND action = 18
0.0146  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4249 AND action = 19
0.0145  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 4250 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4250 AND rel.player_id=27041
0.0149  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4250 AND action = 18
0.0148  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4250 AND action = 19
0.0147  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 15539 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15539 AND rel.player_id=27041
0.0155  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 15539 AND action = 18
0.0154  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 15539 AND action = 19
0.0147  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 73288 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73288 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 73288 AND action = 18
0.0149  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 73288 AND action = 19
0.0151  SELECT e.* FROM `events2015` e WHERE e.player_id = 27041 AND league_id = 4262 ORDER BY e.date ASC
0.0192  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 4262 AND rel.player_id=27041
0.0152  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4262 AND action = 18
0.0145  SELECT action,minute FROM events2015 WHERE player_id = 27041 AND league_id = 4262 AND action = 19
0.0150  SELECT e.* FROM `events2014` e WHERE e.player_id = 27041 AND league_id = 2401 ORDER BY e.date ASC
0.0188  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2401 AND rel.player_id=27041
0.0148  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 2401 AND action = 18
0.0146  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 2401 AND action = 19
0.0148  SELECT e.* FROM `events2014` e WHERE e.player_id = 27041 AND league_id = 2399 ORDER BY e.date ASC
0.0164  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=27041
0.0146  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 2399 AND action = 18
0.0147  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 2399 AND action = 19
0.0145  SELECT e.* FROM `events2014` e WHERE e.player_id = 27041 AND league_id = 2735 ORDER BY e.date ASC
0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2735 AND rel.player_id=27041
0.0147  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 2735 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 2735 AND action = 19
0.0146  SELECT e.* FROM `events2014` e WHERE e.player_id = 27041 AND league_id = 3595 ORDER BY e.date ASC
0.0147  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3595 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 3595 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 27041 AND league_id = 3595 AND action = 19
0.0147  SELECT e.* FROM `events2013` e WHERE e.player_id = 27041 AND league_id = 1901 ORDER BY e.date ASC
0.0190  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1901 AND rel.player_id=27041
0.0152  SELECT action,minute FROM events2013 WHERE player_id = 27041 AND league_id = 1901 AND action = 18
0.0152  SELECT action,minute FROM events2013 WHERE player_id = 27041 AND league_id = 1901 AND action = 19
0.0151  SELECT e.* FROM `events2013` e WHERE e.player_id = 27041 AND league_id = 1969 ORDER BY e.date ASC
0.0193  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=27041
0.0152  SELECT action,minute FROM events2013 WHERE player_id = 27041 AND league_id = 1969 AND action = 18
0.0152  SELECT action,minute FROM events2013 WHERE player_id = 27041 AND league_id = 1969 AND action = 19
0.0154  SELECT e.* FROM `events2012` e WHERE e.player_id = 27041 AND league_id = 1334 ORDER BY e.date ASC
0.0243  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=27041
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 1334 AND action = 18
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 1334 AND action = 19
0.0145  SELECT e.* FROM `events2012` e WHERE e.player_id = 27041 AND league_id = 1437 ORDER BY e.date ASC
0.0157  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=27041
0.0146  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 1437 AND action = 18
0.0151  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 1437 AND action = 19
0.0149  SELECT e.* FROM `events2012` e WHERE e.player_id = 27041 AND league_id = 1443 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1443 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 1443 AND action = 18
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 1443 AND action = 19
0.0149  SELECT e.* FROM `events2012` e WHERE e.player_id = 27041 AND league_id = 25249 ORDER BY e.date ASC
0.0194  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 25249 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 25249 AND action = 18
0.0149  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 25249 AND action = 19
0.0153  SELECT e.* FROM `events2012` e WHERE e.player_id = 27041 AND league_id = 42844 ORDER BY e.date ASC
0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42844 AND rel.player_id=27041
0.0149  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 42844 AND action = 18
0.0153  SELECT action,minute FROM events2012 WHERE player_id = 27041 AND league_id = 42844 AND action = 19
0.0146  SELECT e.* FROM `events2011` e WHERE e.player_id = 27041 AND league_id = 1099 ORDER BY e.date ASC
0.0172  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1099 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1099 AND action = 18
0.0147  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1099 AND action = 19
0.0153  SELECT e.* FROM `events2011` e WHERE e.player_id = 27041 AND league_id = 1115 ORDER BY e.date ASC
0.0197  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=27041
0.0152  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1115 AND action = 18
0.0151  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1115 AND action = 19
0.0151  SELECT e.* FROM `events2011` e WHERE e.player_id = 27041 AND league_id = 1235 ORDER BY e.date ASC
0.0165  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1235 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1235 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1235 AND action = 19
0.0145  SELECT e.* FROM `events2011` e WHERE e.player_id = 27041 AND league_id = 1253 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1253 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1253 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 1253 AND action = 19
0.0145  SELECT e.* FROM `events2011` e WHERE e.player_id = 27041 AND league_id = 24786 ORDER BY e.date ASC
0.0167  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 24786 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 24786 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 24786 AND action = 19
0.0146  SELECT e.* FROM `events2011` e WHERE e.player_id = 27041 AND league_id = 42898 ORDER BY e.date ASC
0.0153  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42898 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 42898 AND action = 18
0.0145  SELECT action,minute FROM events2011 WHERE player_id = 27041 AND league_id = 42898 AND action = 19
0.0147  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 811 ORDER BY e.date ASC
0.0166  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 811 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 811 AND action = 18
0.0146  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 811 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 894 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 894 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 894 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 894 AND action = 19
0.0146  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 961 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 961 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 961 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 961 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 967 ORDER BY e.date ASC
0.0151  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 967 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 967 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 967 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 996 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 996 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 996 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 996 AND action = 19
0.0146  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 39416 ORDER BY e.date ASC
0.0169  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39416 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 39416 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 39416 AND action = 19
0.0145  SELECT e.* FROM `events2010` e WHERE e.player_id = 27041 AND league_id = 42906 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42906 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 42906 AND action = 18
0.0145  SELECT action,minute FROM events2010 WHERE player_id = 27041 AND league_id = 42906 AND action = 19
0.0146  SELECT e.* FROM `events2009` e WHERE e.player_id = 27041 AND league_id = 104 ORDER BY e.date ASC
0.0171  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 104 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 104 AND action = 18
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 104 AND action = 19
0.0145  SELECT e.* FROM `events2009` e WHERE e.player_id = 27041 AND league_id = 730 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 730 AND rel.player_id=27041
0.0144  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 730 AND action = 18
0.0144  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 730 AND action = 19
0.0145  SELECT e.* FROM `events2009` e WHERE e.player_id = 27041 AND league_id = 777 ORDER BY e.date ASC
0.0147  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 777 AND rel.player_id=27041
0.0144  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 777 AND action = 18
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 777 AND action = 19
0.0145  SELECT e.* FROM `events2009` e WHERE e.player_id = 27041 AND league_id = 805 ORDER BY e.date ASC
0.0153  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 805 AND rel.player_id=27041
0.0148  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 805 AND action = 18
0.0145  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 805 AND action = 19
0.0145  SELECT e.* FROM `events2009` e WHERE e.player_id = 27041 AND league_id = 72577 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72577 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 72577 AND action = 18
0.0146  SELECT action,minute FROM events2009 WHERE player_id = 27041 AND league_id = 72577 AND action = 19
0.0150  SELECT e.* FROM `events2008` e WHERE e.player_id = 27041 AND league_id = 2 ORDER BY e.date ASC
0.0200  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 2 AND action = 18
0.0145  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 2 AND action = 19
0.0145  SELECT e.* FROM `events2008` e WHERE e.player_id = 27041 AND league_id = 11015 ORDER BY e.date ASC
0.0182  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 11015 AND rel.player_id=27041
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 11015 AND action = 18
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 11015 AND action = 19
0.0145  SELECT e.* FROM `events2008` e WHERE e.player_id = 27041 AND league_id = 11018 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 11018 AND rel.player_id=27041
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 11018 AND action = 18
0.0144  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 11018 AND action = 19
0.0145  SELECT e.* FROM `events2008` e WHERE e.player_id = 27041 AND league_id = 20575 ORDER BY e.date ASC
0.0176  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20575 AND rel.player_id=27041
0.0146  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 20575 AND action = 18
0.0147  SELECT action,minute FROM events2008 WHERE player_id = 27041 AND league_id = 20575 AND action = 19
0.0150  SELECT e.* FROM `events2007` e WHERE e.player_id = 27041 AND league_id = 42 ORDER BY e.date ASC
0.0209  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42 AND rel.player_id=27041
0.0145  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 42 AND action = 18
0.0145  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 42 AND action = 19
0.0146  SELECT e.* FROM `events2007` e WHERE e.player_id = 27041 AND league_id = 11986 ORDER BY e.date ASC
0.0166  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 11986 AND rel.player_id=27041
0.0149  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 11986 AND action = 18
0.0145  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 11986 AND action = 19
0.0146  SELECT e.* FROM `events2007` e WHERE e.player_id = 27041 AND league_id = 20576 ORDER BY e.date ASC
0.0190  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20576 AND rel.player_id=27041
0.0147  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 20576 AND action = 18
0.0148  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 20576 AND action = 19
0.0150  SELECT e.* FROM `events2007` e WHERE e.player_id = 27041 AND league_id = 72579 ORDER BY e.date ASC
0.0152  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72579 AND rel.player_id=27041
0.0148  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 72579 AND action = 18
0.0148  SELECT action,minute FROM events2007 WHERE player_id = 27041 AND league_id = 72579 AND action = 19
0.0166   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` = '27041' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0155   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 = '2036717' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0150   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 = '1891281' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0146   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 = '1858571' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '1722510' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0148   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 = '654237' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20