Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Area`.`id`, `Area`.`url_key` FROM `far1_schedulechat`.`areas` AS `Area` WHERE 1 = 1 GROUP BY `Area`.`url_key` | 63 | 63 | 1 | |
SELECT `Category`.`id`, `Category`.`category_key` FROM `far1_schedulechat`.`categories` AS `Category` WHERE 1 = 1 GROUP BY category_key | 44 | 44 | 1 | |
SELECT `Area`.`id`, `Area`.`large_url_key`, `Area`.`large_label`, `Area`.`url_key`, `Area`.`label`, `Area`.`copy`, `Area`.`sub_copy`, `Area`.`title`, `Area`.`keywords`, `Area`.`description`, `Area`.`h1`, `Area`.`sort_order`, `Area`.`disable`, `Area`.`omikare_area` FROM `far1_schedulechat`.`areas` AS `Area` WHERE `large_url_key` = 'tokyo' AND `url_key` = 'yokohama' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Area`.`id`, `Area`.`large_url_key`, `Area`.`large_label`, `Area`.`url_key`, `Area`.`label`, `Area`.`copy`, `Area`.`sub_copy`, `Area`.`title`, `Area`.`keywords`, `Area`.`description`, `Area`.`h1`, `Area`.`sort_order`, `Area`.`disable`, `Area`.`omikare_area` FROM `far1_schedulechat`.`areas` AS `Area` WHERE `Area`.`id` IN (SELECT area_id FROM party WHERE end_at > now() AND pparty=1) AND `disable` = 0 AND `large_url_key` = 'tokyo' AND `url_key` != '' ORDER BY `sort_order` ASC | 1 | 1 | 17 | maybe slow |
SELECT `Party`.*, `Place`.*, `Area`.`large_url_key`, `Area`.`url_key`, `Area`.`id`, `Party`.`party_id`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` IN (0,1) AND `Reservation`.`sex` = "m") AS `Party__male_reserver_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` IN (0,1) AND `Reservation`.`sex` = "f") AS `Party__female_reserver_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` = 6 AND `Reservation`.`sex` = "m") AS `Party__male_reviewing_count`, (SELECT COUNT(*) FROM reservation Reservation WHERE `Reservation`.`party_id` = `Party`.`party_id` AND `Reservation`.`cancel_flag` = 0 AND `Reservation`.`status` = 6 AND `Reservation`.`sex` = "f") AS `Party__female_reviewing_count` FROM `far1_schedulechat`.`party` AS `Party` LEFT JOIN `far1_schedulechat`.`areas` AS `Area` ON (`Party`.`area_id` = `Area`.`id`) LEFT JOIN `far1_schedulechat`.`kaijo` AS `Place` ON (`Party`.`kaijo_id` = `Place`.`kaijo_id`) WHERE `Party`.`flag` = '1' AND `Party`.`end_at` >= '2025-06-08 07:28:29' AND `Party`.`pparty` = '1' AND ((((((`Area`.`large_url_key` = 'tokyo') AND (`Area`.`url_key` = 'yokohama'))) OR (`Party`.`is_show_all_area` = '1'))) AND (`Party`.`is_show_all_area` != '1')) ORDER BY `Party`.`open_at` ASC LIMIT 20 | 0 | 0 | 29 | maybe slow |
SELECT `Area`.`url_key`, `Area`.`label` FROM `far1_schedulechat`.`areas` AS `Area` WHERE `disable` = 0 ORDER BY `sort_order` ASC | 69 | 69 | 0 | |
SELECT `Area`.`url_key`, `Area`.`large_url_key` FROM `far1_schedulechat`.`areas` AS `Area` WHERE `disable` = 0 ORDER BY `sort_order` ASC | 69 | 69 | 0 | |
SELECT `Category`.`category_key`, `Category`.`name` FROM `far1_schedulechat`.`categories` AS `Category` WHERE `is_open` = '1' ORDER BY `sort_order` ASC | 28 | 28 | 0 | |
SELECT DISTINCT `Category`.`id`, `Category`.`name`, `Category`.`category_key` FROM `far1_schedulechat`.`categories` AS `Category` LEFT JOIN `far1_schedulechat`.`parties_categories` AS `PartiesCategory` ON (`Category`.`id` = `PartiesCategory`.`category_id`) LEFT JOIN `far1_schedulechat`.`party` AS `Party` ON (`PartiesCategory`.`party_id` = `Party`.`party_id`) WHERE `Category`.`is_open` = '1' AND `Party`.`end_at` > now() AND `Party`.`flag` = 1 AND `Party`.`pparty` = '1' ORDER BY `Category`.`sort_order` ASC | 2 | 2 | 18 | maybe slow |