| 0.0007 |
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` = '73401'
AND c.comment_id IN (909438,588852)
GROUP BY c.comment_id
|
| 0.0151 | 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 = 'Luis-73401' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0331 | 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 = 'Luis-73401' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 63704 |
| 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 = 50270 |
| 0.0163 | 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 = 39026 |
| 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 = 33352 |
| 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 = 15443 |
| 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 = 2552 |
| 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 = 3674 |
| 0.0171 | 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 = 1943 |
| 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 = 1113 |
| 0.0147 | 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 = '73401'
|
| 0.0161 | 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 = 73401 ORDER BY rp.year DESC |
| 0.0154 | SELECT p.title,p.totalcomments,p.downloads,p.views,p.id,p.author_id FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '73401' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0149 | SELECT COUNT(DISTINCT(p.id)) as total FROM `pictures` p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '73401' and rp.type = 3 |
| 0.0148 | SELECT e.* FROM `events2022` e WHERE e.player_id = 73401 AND league_id = 62386 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 = 62386 AND rel.player_id=73401 |
| 0.0150 | SELECT action,minute FROM events2022 WHERE player_id = 73401 AND league_id = 62386 AND action = 18 |
| 0.0150 | SELECT action,minute FROM events2022 WHERE player_id = 73401 AND league_id = 62386 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2022` e WHERE e.player_id = 73401 AND league_id = 63704 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 = 63704 AND rel.player_id=73401 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 73401 AND league_id = 63704 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2022 WHERE player_id = 73401 AND league_id = 63704 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2021` e WHERE e.player_id = 73401 AND league_id = 58580 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 = 58580 AND rel.player_id=73401 |
| 0.0148 | SELECT action,minute FROM events2021 WHERE player_id = 73401 AND league_id = 58580 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2021 WHERE player_id = 73401 AND league_id = 58580 AND action = 19 |
| 0.0145 | SELECT e.* FROM `events2021` e WHERE e.player_id = 73401 AND league_id = 61787 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 = 61787 AND rel.player_id=73401 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 73401 AND league_id = 61787 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2021 WHERE player_id = 73401 AND league_id = 61787 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2020` e WHERE e.player_id = 73401 AND league_id = 50270 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 = 50270 AND rel.player_id=73401 |
| 0.0148 | SELECT action,minute FROM events2020 WHERE player_id = 73401 AND league_id = 50270 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2020 WHERE player_id = 73401 AND league_id = 50270 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2018` e WHERE e.player_id = 73401 AND league_id = 39026 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 = 39026 AND rel.player_id=73401 |
| 0.0149 | SELECT action,minute FROM events2018 WHERE player_id = 73401 AND league_id = 39026 AND action = 18 |
| 0.0172 | SELECT action,minute FROM events2018 WHERE player_id = 73401 AND league_id = 39026 AND action = 19 |
| 0.0155 | SELECT e.* FROM `events2017` e WHERE e.player_id = 73401 AND league_id = 33352 ORDER BY e.date ASC |
| 0.0178 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33352 AND rel.player_id=73401 |
| 0.0164 | SELECT action,minute FROM events2017 WHERE player_id = 73401 AND league_id = 33352 AND action = 18 |
| 0.0154 | SELECT action,minute FROM events2017 WHERE player_id = 73401 AND league_id = 33352 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2016` e WHERE e.player_id = 73401 AND league_id = 15443 ORDER BY e.date ASC |
| 0.0170 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15443 AND rel.player_id=73401 |
| 0.0147 | SELECT action,minute FROM events2016 WHERE player_id = 73401 AND league_id = 15443 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2016 WHERE player_id = 73401 AND league_id = 15443 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2014` e WHERE e.player_id = 73401 AND league_id = 2552 ORDER BY e.date ASC |
| 0.0162 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2552 AND rel.player_id=73401 |
| 0.0153 | SELECT action,minute FROM events2014 WHERE player_id = 73401 AND league_id = 2552 AND action = 18 |
| 0.0155 | SELECT action,minute FROM events2014 WHERE player_id = 73401 AND league_id = 2552 AND action = 19 |
| 0.0154 | SELECT e.* FROM `events2014` e WHERE e.player_id = 73401 AND league_id = 2399 ORDER BY e.date ASC |
| 0.0185 | 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=73401 |
| 0.0155 | SELECT action,minute FROM events2014 WHERE player_id = 73401 AND league_id = 2399 AND action = 18 |
| 0.0153 | SELECT action,minute FROM events2014 WHERE player_id = 73401 AND league_id = 2399 AND action = 19 |
| 0.0152 | SELECT e.* FROM `events2014` e WHERE e.player_id = 73401 AND league_id = 3674 ORDER BY e.date ASC |
| 0.0184 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3674 AND rel.player_id=73401 |
| 0.0150 | SELECT action,minute FROM events2014 WHERE player_id = 73401 AND league_id = 3674 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2014 WHERE player_id = 73401 AND league_id = 3674 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2013` e WHERE e.player_id = 73401 AND league_id = 1943 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 = 1943 AND rel.player_id=73401 |
| 0.0146 | SELECT action,minute FROM events2013 WHERE player_id = 73401 AND league_id = 1943 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2013 WHERE player_id = 73401 AND league_id = 1943 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2013` e WHERE e.player_id = 73401 AND league_id = 1953 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 = 1953 AND rel.player_id=73401 |
| 0.0150 | SELECT action,minute FROM events2013 WHERE player_id = 73401 AND league_id = 1953 AND action = 18 |
| 0.0148 | SELECT action,minute FROM events2013 WHERE player_id = 73401 AND league_id = 1953 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2013` e WHERE e.player_id = 73401 AND league_id = 2340 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 = 2340 AND rel.player_id=73401 |
| 0.0145 | SELECT action,minute FROM events2013 WHERE player_id = 73401 AND league_id = 2340 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2013 WHERE player_id = 73401 AND league_id = 2340 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2011` e WHERE e.player_id = 73401 AND league_id = 1113 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 = 1113 AND rel.player_id=73401 |
| 0.0146 | SELECT action,minute FROM events2011 WHERE player_id = 73401 AND league_id = 1113 AND action = 18 |
| 0.0146 | SELECT action,minute FROM events2011 WHERE player_id = 73401 AND league_id = 1113 AND action = 19 |
| 0.0150 |
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` = '73401'
ORDER BY c.last_update DESC, c.creation_date DESC
LIMIT 0,15
|
| 0.0149 |
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 = '909438'
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 = '588852'
AND c.lang = '1'
ORDER BY creation_date DESC
LIMIT 20
|
Aitor Rodríguez
D. Vázquez
Nacho Quintín
Hugo Martinez
Pablo Prendes
Beni
Pablo Rodriguez
D. Gulin
Santi
Jandro
Nico Arce
Cris Alonso
Jaime Álvarez
G. Acosta
Novoa
Cris Acerete
Nacho Velardi
Alex Arce
Marco Antonio