0.0021 | SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'roma?section=legal' ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC |
0.0032 |
SELECT
dt.id as teamId,
t.id as id,
dt.nameShow as name,
dt.basealias as alias,
c.name as category_name
FROM `teams` as t INNER JOIN `datateams` as dt
ON dt.`id`=t.`teamId`
INNER JOIN `leagues` as l
ON l.id=t.`league_id`
INNER JOIN `categories` as c
ON l.`categoryId`=c.`id`
WHERE c.`alias` LIKE 'primera'
AND l.`year`='2024'
|
0.0027 |
SELECT
dt.id as teamId,
t.id as id,
dt.nameShow as name,
dt.basealias as alias,
c.name as category_name
FROM `teams` as t INNER JOIN `datateams` as dt
ON dt.`id`=t.`teamId`
INNER JOIN `leagues` as l
ON l.id=t.`league_id`
INNER JOIN `categories` as c
ON l.`categoryId`=c.`id`
WHERE c.`alias` LIKE 'segunda'
AND l.`year`='2024'
|
0.1221 | SELECT c.id, c.name, l.group_code, l.total_group, c.CountryCode, c.alias , c.transfer_market FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId WHERE l.year=c.active_year AND c.troncal=1 GROUP BY c.id ORDER BY c.coefficient DESC, c.name ASC |
0.0100 | SELECT ABS(TIMESTAMPDIFF(DAY, c.shedule,NOW())) as day, c.datateam1, c.datateam2, c.id,c.year, c.shedule, c.league_id, ct.name, ct.alias, dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.short_name as short_name1,dt2.short_name as short_name2,dt1.basealias as basealias1,dt2.basealias as basealias2, (dt1.pod+dt2.pod) as sum FROM calendars_matchsday c INNER JOIN leagues l On l.id = c.league_id INNER JOIN categories ct ON ct.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ct.coefficient > 30 AND c.shedule > NOW()-INTERVAL 105 MINUTE AND c.shedule < NOW()+INTERVAL 5 DAY ORDER BY day ASC,sum DESC LIMIT 5 |
0.0018 | SELECT id,betId,betId_sportium,betId_marca,betId_bwin, betId_888, betId_marathon,comments,extra FROM calendars2024 WHERE id IN (736309,726233,734522,734520,691923) |