| 0.0006 |
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` = '196861'
|
| 0.0157 | 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 = 'Fran-Ponce-196861' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0329 | 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 = 'Fran-Ponce-196861' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 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 = 44398 |
| 0.0160 | 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 = 16712 |
| 0.0157 | 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 = 3919 |
| 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 = 2559 |
| 0.0145 | 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 = '196861'
|
| 0.0153 | 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 = 58589 AND rp.teamId = 825 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0147 | 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 = 196861 ORDER BY rp.year DESC |
| 0.0145 | 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 = '196861' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0146 | 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 = '196861' and rp.type = 3 |
| 0.0148 | SELECT e.* FROM `events2021` e WHERE e.player_id = 196861 AND league_id = 58589 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 = 58589 AND rel.player_id=196861 |
| 0.0153 | SELECT action,minute FROM events2021 WHERE player_id = 196861 AND league_id = 58589 AND action = 18 |
| 0.0164 | SELECT action,minute FROM events2021 WHERE player_id = 196861 AND league_id = 58589 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2021` e WHERE e.player_id = 196861 AND league_id = 61813 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 = 61813 AND rel.player_id=196861 |
| 0.0150 | SELECT action,minute FROM events2021 WHERE player_id = 196861 AND league_id = 61813 AND action = 18 |
| 0.0150 | SELECT action,minute FROM events2021 WHERE player_id = 196861 AND league_id = 61813 AND action = 19 |
| 0.0151 | SELECT e.* FROM `events2020` e WHERE e.player_id = 196861 AND league_id = 50278 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 = 50278 AND rel.player_id=196861 |
| 0.0155 | SELECT action,minute FROM events2020 WHERE player_id = 196861 AND league_id = 50278 AND action = 18 |
| 0.0152 | SELECT action,minute FROM events2020 WHERE player_id = 196861 AND league_id = 50278 AND action = 19 |
| 0.0148 | SELECT e.* FROM `events2019` e WHERE e.player_id = 196861 AND league_id = 44398 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 = 44398 AND rel.player_id=196861 |
| 0.0152 | SELECT action,minute FROM events2019 WHERE player_id = 196861 AND league_id = 44398 AND action = 18 |
| 0.0152 | SELECT action,minute FROM events2019 WHERE player_id = 196861 AND league_id = 44398 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2019` e WHERE e.player_id = 196861 AND league_id = 43475 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 = 43475 AND rel.player_id=196861 |
| 0.0151 | SELECT action,minute FROM events2019 WHERE player_id = 196861 AND league_id = 43475 AND action = 18 |
| 0.0149 | SELECT action,minute FROM events2019 WHERE player_id = 196861 AND league_id = 43475 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2017` e WHERE e.player_id = 196861 AND league_id = 30386 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 = 30386 AND rel.player_id=196861 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 196861 AND league_id = 30386 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2017 WHERE player_id = 196861 AND league_id = 30386 AND action = 19 |
| 0.0146 | SELECT e.* FROM `events2016` e WHERE e.player_id = 196861 AND league_id = 15451 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 = 15451 AND rel.player_id=196861 |
| 0.0146 | SELECT action,minute FROM events2016 WHERE player_id = 196861 AND league_id = 15451 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2016 WHERE player_id = 196861 AND league_id = 15451 AND action = 19 |
| 0.0147 | SELECT e.* FROM `events2016` e WHERE e.player_id = 196861 AND league_id = 16712 ORDER BY e.date ASC |
| 0.0145 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 16712 AND rel.player_id=196861 |
| 0.0146 | SELECT action,minute FROM events2016 WHERE player_id = 196861 AND league_id = 16712 AND action = 18 |
| 0.0147 | SELECT action,minute FROM events2016 WHERE player_id = 196861 AND league_id = 16712 AND action = 19 |
| 0.0150 | SELECT e.* FROM `events2015` e WHERE e.player_id = 196861 AND league_id = 3919 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 = 3919 AND rel.player_id=196861 |
| 0.0146 | SELECT action,minute FROM events2015 WHERE player_id = 196861 AND league_id = 3919 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2015 WHERE player_id = 196861 AND league_id = 3919 AND action = 19 |
| 0.0161 | SELECT e.* FROM `events2014` e WHERE e.player_id = 196861 AND league_id = 2559 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 = 2559 AND rel.player_id=196861 |
| 0.0145 | SELECT action,minute FROM events2014 WHERE player_id = 196861 AND league_id = 2559 AND action = 18 |
| 0.0145 | SELECT action,minute FROM events2014 WHERE player_id = 196861 AND league_id = 2559 AND action = 19 |
Fran
A. Navas
Mario Sanchez
Javi Paul
Pablo Ureba
A. Narváez
Manolete
Molina
Lebrón
J. León
L. Gonzalez
Manzano
Fran Mejías
A. Legupin
Javi Gómez
F. Rodriguez
J. Vidal
J. Ureba
Javi Tamayo
Cuenca
Legupin
Luque
S. Jiménez
Alvarito