0.0020 | SELECT type FROM routes WHERE alias = 'Everton-Fc' |
0.0151 | SELECT dt.*, t.id AS team_id, ct.id AS competition_id, ct.name AS competition_name, ct.alias AS competition_alias, ct.class, ct.alias, ct.type_style FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON l.categoryId=ct.id WHERE dt.basealias='Everton-Fc' AND ct.troncal=1 ORDER BY l.year DESC LIMIT 1 |
0.0090 |
SELECT t.id AS team_id, l.id AS league_id, ct.id as competition_id, ct.name AS competition_name
FROM teams AS t INNER JOIN leagues AS l ON t.league_id=l.id
INNER JOIN categories AS ct ON l.categoryId=ct.id
WHERE t.teamId='1017' AND l.year='2024' AND (ct.competition_type='11'
or ct.id=672) |
0.0059 | SELECT ct.id, ct.name, ct.alias, l.id AS league_id, l.year FROM leagues AS l INNER JOIN categories AS ct ON l.categoryId=ct.id AND ct.active_year=l.year WHERE ct.competition_type=11 or ct.id=672 |
0.0026 | SELECT c.id, c.r1, c.r2, c.comments, c.shedule, c.extra, c.league_id, c.datateam1, c.datateam2, c.team1, c.team2 FROM calendars2024 AS c WHERE c.league_id IN (71432,70632,49360,75120,58837,75045,75697,74447,75096,75095,75079,75097,75055,75080,73659,73904,70875,65830,75099,66144,75158,65670,66585,75665,75100,71331,71585,72591,75946) AND (c.datateam1 IN (1017) OR c.datateam2 IN (1017)) ORDER BY c.shedule ASC |
0.0079 | SELECT dt.id, dt.nameShow, dt.basealias, s.name as stadium, s.address
FROM datateams AS dt
LEFT JOIN rel_stadiums rs ON rs.teamId = dt.id AND rs.active = 1
LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id
WHERE dt.id IN (12838,1017,2753,526,2429,4098) |
0.0018 | SELECT active_year as year from categories where id=10 order by active_year desc limit 1 |
0.0024 | SELECT t.id, dt.id AS dtid, dt.nameShow AS name, dt.basealias
FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId
INNER JOIN teams AS t ON l.id=t.league_id
INNER JOIN datateams AS dt ON t.teamId=dt.id
WHERE ct.id=10 AND l.year=2024 AND ct.troncal=1 AND dt.id='1017'
GROUP BY dt.id
ORDER BY dt.nameShow ASC |
0.0051 |
SELECT
rb.origin_team_id AS otid, rb.destination_team_id AS dtid, rb.official_budget, rb.new_id, rb.valor, rb.budget_type,
dp.id, dp.nick AS name, dp.role,
dt1.id AS odtid, dt1.nameShow AS odtname, dt2.id AS ddtid, dt2.nameShow AS ddtname,
n.alias
FROM rel_budgets AS rb
INNER JOIN news AS n ON n.id=rb.new_id
INNER JOIN dataplayers AS dp ON rb.player_id=dp.id
LEFT JOIN datateams AS dt1 ON rb.origin_team_id=dt1.id
LEFT JOIN datateams AS dt2 ON rb.destination_team_id=dt2.id
WHERE rb.year=2024 AND (rb.origin_team_id IN (1017)
OR rb.destination_team_id IN (1017)) AND rb.budget_date >= '2016-03-01'
order by rb.budget_type!=5 desc,rb.pub_date desc
|
0.0056 | SELECT p.*,rp.*, TIMESTAMPDIFF(YEAR,p.birthdate,CURDATE()) AS age FROM `rel_players` rp INNER JOIN `dataplayers` p ON rp.player_id = p.id WHERE rp.in_squad=1 AND rp.team_id = '6578408' ORDER BY p.role>0 DESC, p.role ASC |
0.0097 | SELECT c.*, l.*, NOW() as difference_time FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId)
WHERE l.status = 1 LIMIT 30 |
0.0021 |
SELECT dt.id, dt.nameShow, dt.basealias, l.id AS league_id, l.categoryId AS competition_id
FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId
INNER JOIN leagues AS l ON t.league_id=l.id
WHERE l.categoryId=10 AND l.year=2024 AND l.group_code='1'
ORDER BY dt.nameShow ASC
|