| 0.0005 |
SELECT
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` = '83563'
|
| 0.0158 | 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 = 'Pelayo-Torre-83563' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0186 | 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 = 'Pelayo-Torre-83563' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0138 | 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.0140 | 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.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 = 3912 |
| 0.0164 | 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.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 = 3674 |
| 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 = 1399 |
| 0.0126 | 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 = '83563'
|
| 0.0130 | 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 = 83563 ORDER BY rp.year DESC |
| 0.0127 | 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 = '83563' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0127 | 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 = '83563' and rp.type = 3 |
| 0.0128 | SELECT e.* FROM `events2020` e WHERE e.player_id = 83563 AND league_id = 50270 ORDER BY e.date ASC |
| 0.0134 | 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=83563 |
| 0.0129 | SELECT action,minute FROM events2020 WHERE player_id = 83563 AND league_id = 50270 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2020 WHERE player_id = 83563 AND league_id = 50270 AND action = 19 |
| 0.0128 | SELECT e.* FROM `events2018` e WHERE e.player_id = 83563 AND league_id = 39026 ORDER BY e.date ASC |
| 0.0134 | 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=83563 |
| 0.0131 | SELECT action,minute FROM events2018 WHERE player_id = 83563 AND league_id = 39026 AND action = 18 |
| 0.0132 | SELECT action,minute FROM events2018 WHERE player_id = 83563 AND league_id = 39026 AND action = 19 |
| 0.0159 | SELECT e.* FROM `events2016` e WHERE e.player_id = 83563 AND league_id = 15443 ORDER BY e.date ASC |
| 0.0135 | 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=83563 |
| 0.0127 | SELECT action,minute FROM events2016 WHERE player_id = 83563 AND league_id = 15443 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2016 WHERE player_id = 83563 AND league_id = 15443 AND action = 19 |
| 0.0134 | 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=83563 |
| 0.0127 | SELECT action,minute FROM events2016 WHERE player_id = 83563 AND league_id = 15443 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2016 WHERE player_id = 83563 AND league_id = 15443 AND action = 19 |
| 0.0127 | SELECT e.* FROM `events2015` e WHERE e.player_id = 83563 AND league_id = 3912 ORDER BY e.date ASC |
| 0.0136 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3912 AND rel.player_id=83563 |
| 0.0126 | SELECT action,minute FROM events2015 WHERE player_id = 83563 AND league_id = 3912 AND action = 18 |
| 0.0128 | SELECT action,minute FROM events2015 WHERE player_id = 83563 AND league_id = 3912 AND action = 19 |
| 0.0129 | SELECT e.* FROM `events2014` e WHERE e.player_id = 83563 AND league_id = 2552 ORDER BY e.date ASC |
| 0.0132 | 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=83563 |
| 0.0126 | SELECT action,minute FROM events2014 WHERE player_id = 83563 AND league_id = 2552 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2014 WHERE player_id = 83563 AND league_id = 2552 AND action = 19 |
| 0.0125 | SELECT e.* FROM `events2014` e WHERE e.player_id = 83563 AND league_id = 3674 ORDER BY e.date ASC |
| 0.0133 | 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=83563 |
| 0.0126 | SELECT action,minute FROM events2014 WHERE player_id = 83563 AND league_id = 3674 AND action = 18 |
| 0.0126 | SELECT action,minute FROM events2014 WHERE player_id = 83563 AND league_id = 3674 AND action = 19 |
| 0.0132 | SELECT e.* FROM `events2012` e WHERE e.player_id = 83563 AND league_id = 1399 ORDER BY e.date ASC |
| 0.0139 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1399 AND rel.player_id=83563 |
| 0.0128 | SELECT action,minute FROM events2012 WHERE player_id = 83563 AND league_id = 1399 AND action = 18 |
| 0.0129 | SELECT action,minute FROM events2012 WHERE player_id = 83563 AND league_id = 1399 AND action = 19 |
| 0.0126 | SELECT e.* FROM `events2011` e WHERE e.player_id = 83563 AND league_id = 1113 ORDER BY e.date ASC |
| 0.0127 | 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=83563 |
| 0.0126 | SELECT action,minute FROM events2011 WHERE player_id = 83563 AND league_id = 1113 AND action = 18 |
| 0.0127 | SELECT action,minute FROM events2011 WHERE player_id = 83563 AND league_id = 1113 AND action = 19 |
Jano
A. García
P. Otia
Gabancho
D. Alvarez
Mati
Hugo Sánchez
Daniel Muñoz
Juan Steven
Luismi
Dani Pevida
Lele
Molina
Mario Buelga
M. Tobon
Otia
F. Ofon
Fredo
H. Kang
Monasterio
I. Coto