| 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` = '340799'
|
| 0.0111 | 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 = 'E-Fernandes-340799' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0264 | 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 = 'E-Fernandes-340799' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0113 | 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 = 66120 |
| 0.0113 | 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 = 61677 |
| 0.0113 | 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 = 61189 |
| 0.0110 | 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 = 48467 |
| 0.0111 | 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 = 42647 |
| 0.0111 | 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 = 41736 |
| 0.0110 | 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 = 42853 |
| 0.0111 | 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 = 37695 |
| 0.0111 | 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 = 38833 |
| 0.0124 | 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 = 37489 |
| 0.0110 | 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 = 37626 |
| 0.0113 | 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 = 38272 |
| 0.0110 | 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 = 20238 |
| 0.0110 | 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 = 19980 |
| 0.0113 | 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 = 23985 |
| 0.0110 | 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 = 42662 |
| 0.0105 | 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 = '340799'
|
| 0.0107 | 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 = 340799 ORDER BY rp.year DESC |
| 0.0106 | 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 = '340799' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0106 | 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 = '340799' and rp.type = 3 |
| 0.0106 | SELECT e.* FROM `events2022` e WHERE e.player_id = 340799 AND league_id = 66120 ORDER BY e.date ASC |
| 0.0107 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66120 AND rel.player_id=340799 |
| 0.0110 | SELECT action,minute FROM events2022 WHERE player_id = 340799 AND league_id = 66120 AND action = 18 |
| 0.0106 | SELECT action,minute FROM events2022 WHERE player_id = 340799 AND league_id = 66120 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2022` e WHERE e.player_id = 340799 AND league_id = 66972 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 66972 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2022 WHERE player_id = 340799 AND league_id = 66972 AND action = 18 |
| 0.0106 | SELECT action,minute FROM events2022 WHERE player_id = 340799 AND league_id = 66972 AND action = 19 |
| 0.0105 | SELECT e.* FROM `events2021` e WHERE e.player_id = 340799 AND league_id = 61677 ORDER BY e.date ASC |
| 0.0107 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61677 AND rel.player_id=340799 |
| 0.0105 | SELECT action,minute FROM events2021 WHERE player_id = 340799 AND league_id = 61677 AND action = 18 |
| 0.0106 | SELECT action,minute FROM events2021 WHERE player_id = 340799 AND league_id = 61677 AND action = 19 |
| 0.0107 | SELECT e.* FROM `events2020` e WHERE e.player_id = 340799 AND league_id = 53602 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53602 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2020 WHERE player_id = 340799 AND league_id = 53602 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2020 WHERE player_id = 340799 AND league_id = 53602 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2020` e WHERE e.player_id = 340799 AND league_id = 53801 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 53801 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2020 WHERE player_id = 340799 AND league_id = 53801 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2020 WHERE player_id = 340799 AND league_id = 53801 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2020` e WHERE e.player_id = 340799 AND league_id = 61189 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61189 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2020 WHERE player_id = 340799 AND league_id = 61189 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2020 WHERE player_id = 340799 AND league_id = 61189 AND action = 19 |
| 0.0105 | SELECT e.* FROM `events2019` e WHERE e.player_id = 340799 AND league_id = 48467 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 48467 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2019 WHERE player_id = 340799 AND league_id = 48467 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2019 WHERE player_id = 340799 AND league_id = 48467 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2018` e WHERE e.player_id = 340799 AND league_id = 42647 ORDER BY e.date ASC |
| 0.0107 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42647 AND rel.player_id=340799 |
| 0.0105 | SELECT action,minute FROM events2018 WHERE player_id = 340799 AND league_id = 42647 AND action = 18 |
| 0.0108 | SELECT action,minute FROM events2018 WHERE player_id = 340799 AND league_id = 42647 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2018` e WHERE e.player_id = 340799 AND league_id = 41736 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41736 AND rel.player_id=340799 |
| 0.0105 | SELECT action,minute FROM events2018 WHERE player_id = 340799 AND league_id = 41736 AND action = 18 |
| 0.0106 | SELECT action,minute FROM events2018 WHERE player_id = 340799 AND league_id = 41736 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2018` e WHERE e.player_id = 340799 AND league_id = 42853 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42853 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2018 WHERE player_id = 340799 AND league_id = 42853 AND action = 18 |
| 0.0106 | SELECT action,minute FROM events2018 WHERE player_id = 340799 AND league_id = 42853 AND action = 19 |
| 0.0107 | SELECT e.* FROM `events2017` e WHERE e.player_id = 340799 AND league_id = 37695 ORDER BY e.date ASC |
| 0.0107 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37695 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 37695 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 37695 AND action = 19 |
| 0.0108 | SELECT e.* FROM `events2017` e WHERE e.player_id = 340799 AND league_id = 38063 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38063 AND rel.player_id=340799 |
| 0.0105 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 38063 AND action = 18 |
| 0.0107 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 38063 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2017` e WHERE e.player_id = 340799 AND league_id = 38833 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38833 AND rel.player_id=340799 |
| 0.0107 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 38833 AND action = 18 |
| 0.0107 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 38833 AND action = 19 |
| 0.0107 | SELECT e.* FROM `events2017` e WHERE e.player_id = 340799 AND league_id = 37489 ORDER BY e.date ASC |
| 0.0107 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37489 AND rel.player_id=340799 |
| 0.0107 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 37489 AND action = 18 |
| 0.0108 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 37489 AND action = 19 |
| 0.0109 | SELECT e.* FROM `events2017` e WHERE e.player_id = 340799 AND league_id = 37626 ORDER BY e.date ASC |
| 0.0129 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37626 AND rel.player_id=340799 |
| 0.0109 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 37626 AND action = 18 |
| 0.0107 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 37626 AND action = 19 |
| 0.0107 | SELECT e.* FROM `events2017` e WHERE e.player_id = 340799 AND league_id = 38272 ORDER BY e.date ASC |
| 0.0108 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38272 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 38272 AND action = 18 |
| 0.0107 | SELECT action,minute FROM events2017 WHERE player_id = 340799 AND league_id = 38272 AND action = 19 |
| 0.0107 | SELECT e.* FROM `events2016` e WHERE e.player_id = 340799 AND league_id = 20238 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20238 AND rel.player_id=340799 |
| 0.0105 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 20238 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 20238 AND action = 19 |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20238 AND rel.player_id=340799 |
| 0.0106 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 20238 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 20238 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2016` e WHERE e.player_id = 340799 AND league_id = 19980 ORDER BY e.date ASC |
| 0.0109 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 19980 AND rel.player_id=340799 |
| 0.0107 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 19980 AND action = 18 |
| 0.0110 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 19980 AND action = 19 |
| 0.0110 | SELECT e.* FROM `events2016` e WHERE e.player_id = 340799 AND league_id = 23985 ORDER BY e.date ASC |
| 0.0109 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 23985 AND rel.player_id=340799 |
| 0.0109 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 23985 AND action = 18 |
| 0.0106 | SELECT action,minute FROM events2016 WHERE player_id = 340799 AND league_id = 23985 AND action = 19 |
| 0.0106 | SELECT e.* FROM `events2015` e WHERE e.player_id = 340799 AND league_id = 42662 ORDER BY e.date ASC |
| 0.0106 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42662 AND rel.player_id=340799 |
| 0.0105 | SELECT action,minute FROM events2015 WHERE player_id = 340799 AND league_id = 42662 AND action = 18 |
| 0.0105 | SELECT action,minute FROM events2015 WHERE player_id = 340799 AND league_id = 42662 AND action = 19 |
Tallison
Luan
Ricardo Vilar
Waldson
Marcelo Xavier
Rafael Cruz
Lucas Newiton
Anderson Sobral
Murilo Rusalen
Iran
Rafael Franco
Wiliam Kozlowski
Joao Luis
Leomir
L. Medina
Leomir
Dionatan
Kallyl
Steylor
Wendew
Nunes