| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `TourOption`.`id`, `TourOption`.`code`, `TourOption`.`name`, `Tour`.`id`, `Tour`.`code`, `Tour`.`name`, `TourGroup`.`id` FROM `cubesys_trs2019`.`tour_options` AS `TourOption` LEFT JOIN `cubesys_trs2019`.`tours` AS `Tour` ON (`TourOption`.`tour_id` = `Tour`.`id`) LEFT JOIN `cubesys_trs2019`.`tour_groups` AS `TourGroup` ON (`TourOption`.`tour_group_id` = `TourGroup`.`id`) WHERE `TourOption`.`code` = 'GW730_ENG' LIMIT 1 | 1 | 1 | 1 | |
|
SELECT
DATE_FORMAT(date, '%Y-%m-%d') as date,
DATE_FORMAT(date, '%d') as day,
SUM(adult_num) +
SUM(child_num) +
SUM(foc_num) +
SUM(spare1_num) +
SUM(spare2_num) as count_num,
SUM(adult_num) +
SUM(child_num) +
SUM(foc_num) +
SUM(infant_num) +
SUM(spare1_num) +
SUM(spare2_num) as count_all_num
FROM
bookings
WHERE
tour_option_id = 6 AND
booking_status_id IN (1, 4, 5) AND
date
BETWEEN
'2019-06-01' AND '2019-12-31'
GROUP BY
date
ORDER BY
date | 31 | 31 | 47 | maybe slow |
| SELECT `TourOption`.`id` FROM `cubesys_trs2019`.`tour_options` AS `TourOption` WHERE `TourOption`.`tour_group_id` = 3 | 6 | 6 | 1 | maybe slow |
|
SELECT
DATE_FORMAT(date, '%Y-%m-%d') as date,
DATE_FORMAT(date, '%d') as day,
SUM(adult_num) +
SUM(child_num) +
SUM(foc_num) +
SUM(spare1_num) +
SUM(spare2_num) as count_num,
SUM(adult_num) +
SUM(child_num) +
SUM(foc_num) +
SUM(infant_num) +
SUM(spare1_num) +
SUM(spare2_num) as count_all_num
FROM
bookings
WHERE
tour_option_id IN (6,8,89,90,91,97) AND
booking_status_id IN (1, 4, 5) AND
date
BETWEEN
'2019-06-01' AND '2019-12-31'
GROUP BY
date
ORDER BY
date | 103 | 103 | 54 | maybe slow |
| SELECT `TourOption`.`id` FROM `cubesys_trs2019`.`tour_options` AS `TourOption` WHERE `TourOption`.`tour_id` = 1 | 25 | 25 | 1 | |
|
SELECT
DATE_FORMAT(date, '%Y-%m-%d') as date,
DATE_FORMAT(date, '%d') as day,
SUM(adult_num) +
SUM(child_num) +
SUM(foc_num) +
SUM(spare1_num) +
SUM(spare2_num) as count_num,
SUM(adult_num) +
SUM(child_num) +
SUM(foc_num) +
SUM(infant_num) +
SUM(spare1_num) +
SUM(spare2_num) as count_all_num
FROM
bookings
WHERE
tour_option_id IN (1,2,3,4,5,6,7,8,9,10,11,29,31,32,89,90,91,92,93,94,96,97,98,100,103) AND
booking_status_id IN (1, 4, 5) AND
date
BETWEEN
'2019-06-01' AND '2019-12-31'
GROUP BY
date
ORDER BY
date | 130 | 130 | 37 | maybe slow |
| SELECT `Year`.`id`, `Year`.`year` FROM `cubesys_trs2019`.`years` AS `Year` WHERE `Year`.`year` = 2019 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TourAnnual`.`id`, `TourAnnual`.`year_id`, `TourAnnual`.`max_num`, `TourAnnual`.`tour_id`, `Tour`.`id`, `Tour`.`code`, `Tour`.`name`, `Tour`.`item_order`, `Tour`.`visible` FROM `cubesys_trs2019`.`tour_annuals` AS `TourAnnual` LEFT JOIN `cubesys_trs2019`.`tours` AS `Tour` ON (`TourAnnual`.`tour_id` = `Tour`.`id`) WHERE `TourAnnual`.`tour_id` = 1 AND `TourAnnual`.`year_id` = 7 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `TourOptionAvailable`.`id`, `TourOptionAvailable`.`num`, `TourOptionAvailable`.`date`, RIGHT(TourOptionAvailable.date, 2) AS TourOptionAvailable__day_only FROM `cubesys_trs2019`.`tour_option_availables` AS `TourOptionAvailable` WHERE `TourOptionAvailable`.`tour_option_id` = 6 AND `TourOptionAvailable`.`date` BETWEEN '2019-06-01' AND '2019-12-31' ORDER BY `TourOptionAvailable`.`date` ASC | 214 | 214 | 11 | maybe slow |
| SELECT `TourGroupAvailable`.`id`, `TourGroupAvailable`.`num`, `TourGroupAvailable`.`date`, RIGHT(TourGroupAvailable.date, 2) AS TourGroupAvailable__day_only FROM `cubesys_trs2019`.`tour_group_availables` AS `TourGroupAvailable` WHERE `TourGroupAvailable`.`tour_group_id` = 3 AND `TourGroupAvailable`.`date` BETWEEN '2019-06-01' AND '2019-12-31' ORDER BY `TourGroupAvailable`.`date` ASC | 214 | 214 | 2 | |
