0.0466 | SELECT c.id,c.ctype,c.alias as alias,l.current_round,l.group_code,l.total_group,c.name,l.total_rounds,l.year,lp.c_pending,lp.c_playing,lp.c_recent,lp.c_played,lp.c_future,lp.c_past,c.location,c.active_year, c.parentId, l.categoryId, l.start_date, l.end_date, c.logo, c.location FROM categories c INNER JOIN leagues l ON l.categoryId = c.id LEFT JOIN leagues_play AS lp ON l.categoryId=lp.categoryId AND lp.ini_date='2021-01-24 19:00:00' WHERE c.alias = 'japon' AND c.active_year = l.year ORDER BY l.group_code ASC |
0.0024 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=58 AND type_rel = 3 |
0.0384 | SELECT type,categoryId,year FROM historical_resume WHERE (categoryId = 58 and (year = 2021 OR year = 0)) |
0.0021 | SELECT id, betId , betId_bwin, betId_marca, betId_888, betId_sportium, betId_marathon FROM calendars2021 WHERE id IN (239856,239857,239858,239859,239860,239861,239862,239863,239864,239865) AND (betId != 0 OR betId_bwin != 0 OR betId_marca != 0 OR betId_888 != 0 OR betId_sportium != 0 OR betId_marathon != 0) |