| 0.0064 | SELECT min(l.year) as min_year,max(l.year) as max_year,c.main,cou.Name,c.top,c.status,c.cat,c.ctype,c.CountryCode, c.class, c.main,c.coefficient, l.year,c.logo, l.id , c.name, c.alias,lp.c_playing,lp.c_recent,lp.c_played,lp.c_pending,lp.c_past,lp.c_future FROM (leagues l INNER JOIN categories c ON l.categoryId = c.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode LEFT JOIN leagues_play lp ON lp.categoryId = c.id AND lp.ini_date = '2024-04-23 10:30:00') WHERE l.group_code = 1 AND l.end_date > NOW() - INTERVAL 2 MONTH AND l.status = 1 group by l.categoryId ORDER BY c.coefficient DESC, c.name DESC LIMIT 200 |
| 0.0018 | SELECT * FROM totals order by id ASC |
| 0.0019 | SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2009 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 < 95 AND c.r2 < 95 AND c.shedule > '2024/04/23 07:26' AND c.shedule < '2024/04/23 10:46' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 21 |
| 0.1090 | SELECT l.id,cat.alias,cat.name,l.total_group,l.group_code FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId WHERE l.status = 1 AND l.group_code = 1 ORDER BY l.year DESC,cat.coefficient DESC,l.group_code ASC LIMIT 21 |
| 0.0020 | SELECT * FROM quiniela_r WHERE status = 'enb' AND rewards IS NOT NULL ORDER BY year DESC, round DESC LIMIT 1 |
| 0.0037 | SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2024 AND q.round=53 ORDER BY idq ASC |
| 0.0019 | SELECT * FROM quiniela_r WHERE round = 5 ORDER BY year DESC |
| 0.0036 | SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2024 AND q.round=5 ORDER BY idq ASC |
| 0.0020 | SELECT * FROM quiniela_r WHERE status = 'enb' AND ((NOW()>=init_date AND NOW()<=end_date) OR init_date>NOW()) ORDER BY init_date ASC LIMIT 1 |
| 0.0036 | SELECT t1.nameShow AS team1_name, t2.nameShow AS team2_name, c.r1, c.r2, c.shedule, c.extra, c.league_id, q.`year`,t1.basealias AS basealias1, t2.basealias AS basealias2 FROM quiniela AS q INNER JOIN calendars_all AS c ON q.id_match=c.id AND c.league_id = q.league_id LEFT JOIN datateams AS t1 ON t1.id=c.datateam1 LEFT JOIN datateams AS t2 ON t2.id=c.datateam2 WHERE q.`year`=2024 AND q.round=54 ORDER BY idq ASC |
| 0.0050 | SELECT MAX(round) AS max_round FROM quiniela_r WHERE status='enb' AND year=2024 |
| 0.0036 | SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2024 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '5' AND q.year=2024 ORDER BY q.idq ASC |
| 0.0036 | SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2024 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '5' AND q.year=2024 ORDER BY q.idq ASC |
| 0.0035 | SELECT q.*,c.r1,c.r2,c.league_id,c.id as match_id,c.team1,c.team2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,c.round as rleague FROM quiniela q INNER JOIN calendars2024 c ON c.id = q.id_match INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE q.round = '5' AND q.year=2024 ORDER BY q.idq ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588800 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588809 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588795 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588806 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588796 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588807 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588774 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588788 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588770 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588786 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588761 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588783 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588794 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588802 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588763 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588776 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588766 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588792 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588775 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588778 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588799 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588804 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588797 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588803 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588762 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588790 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588798 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588808 AND r1<99 ORDER BY shedule ASC |
| 0.0018 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team1 = 6588757 AND r1<99 ORDER BY shedule ASC |
| 0.0019 | SELECT r1,r2 FROM calendars2024 WHERE league_id = 72465 AND team2 = 6588793 AND r1<99 ORDER BY shedule ASC |
