| 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` = '913569'
|
| 0.0072 | 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 = 'Wendel-Lessa-913569' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC |
| 0.0027 | 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 = 74996 |
| 0.0027 | 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 = 74862 |
| 0.0027 | 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 = 75206 |
| 0.0026 | 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 = 75484 |
| 0.0027 | 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 = 75735 |
| 0.0018 | 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 = '913569'
|
| 0.0052 | 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 = 74996 AND rp.teamId = 1780 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC |
| 0.0025 | 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 = 913569 ORDER BY rp.year DESC |
| 0.0022 | 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 = '913569' and rp.type = 3 ORDER BY p.id DESC LIMIT 0, 24 |
| 0.0020 | 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 = '913569' and rp.type = 3 |
| 0.0021 | SELECT e.* FROM `events2024` e WHERE e.player_id = 913569 AND league_id = 74996 ORDER BY e.date ASC |
| 0.0047 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 74996 AND rel.player_id=913569 |
| 0.0020 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 74996 AND action = 18 |
| 0.0020 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 74996 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2024` e WHERE e.player_id = 913569 AND league_id = 74862 ORDER BY e.date ASC |
| 0.0038 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 74862 AND rel.player_id=913569 |
| 0.0020 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 74862 AND action = 18 |
| 0.0019 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 74862 AND action = 19 |
| 0.0020 | SELECT e.* FROM `events2024` e WHERE e.player_id = 913569 AND league_id = 75206 ORDER BY e.date ASC |
| 0.0036 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 75206 AND rel.player_id=913569 |
| 0.0019 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 75206 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 75206 AND action = 19 |
| 0.0019 | SELECT e.* FROM `events2024` e WHERE e.player_id = 913569 AND league_id = 75484 ORDER BY e.date ASC |
| 0.0030 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 75484 AND rel.player_id=913569 |
| 0.0018 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 75484 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 75484 AND action = 19 |
| 0.0018 | SELECT e.* FROM `events2024` e WHERE e.player_id = 913569 AND league_id = 75735 ORDER BY e.date ASC |
| 0.0053 | SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 75735 AND rel.player_id=913569 |
| 0.0019 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 75735 AND action = 18 |
| 0.0018 | SELECT action,minute FROM events2024 WHERE player_id = 913569 AND league_id = 75735 AND action = 19 |
Bruno Lopes
Vagner
Jeferson
Robson Reis
Odivan
Arnaldo
Joecio
Rafael Vaz
Luiz Paulo
Danilo Belão
Diego Matos
Guilherme Matos
Jean Mangabeira
Patrick Allan
Thiago Lopes
Van Basty
L. Rangel
Marcos Junior
Reinaldo Kauan
Júlio César
R. Vanegas
Paulo Sérgio
Evandro
Gustavo Maia
Cleo Silva
L. Barcia