| 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 | 0 | |
| SELECT `Category`.`id`, `Category`.`category_key` FROM `far1_schedulechat`.`categories` AS `Category` WHERE 1 = 1 GROUP BY category_key | 44 | 44 | 0 | |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`category_key`, `Category`.`label_class`, `Category`.`copy`, `Category`.`sub_copy`, `Category`.`title`, `Category`.`keywords`, `Category`.`description`, `Category`.`h1`, `Category`.`sort_order`, `Category`.`is_open` FROM `far1_schedulechat`.`categories` AS `Category` WHERE `Category`.`category_key` = 'thirty_male_l' LIMIT 1 | 1 | 1 | 0 | |
| 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`) LEFT JOIN `far1_schedulechat`.`parties_categories` AS `PartiesCategory` ON (`Party`.`party_id` = `PartiesCategory`.`party_id`) LEFT JOIN `far1_schedulechat`.`categories` AS `Category` ON (`PartiesCategory`.`category_id` = `Category`.`id`) WHERE `Party`.`end_at` >= '2026-10-02 15:52:19' AND ((`Party`.`flag` = '1') AND (`Party`.`pparty` = '1') AND (((`Party`.`assign_team_id` IS NULL) OR (`Party`.`assign_team_id` <> 6)))) AND `Category`.`category_key` = 'thirty_male_l' ORDER BY `Party`.`open_at` ASC LIMIT 20 | 3 | 3 | 9 | maybe slow |
| SELECT `Category`.`id`, `Category`.`name`, `Category`.`category_key`, `Category`.`label_class`, `Category`.`copy`, `Category`.`sub_copy`, `Category`.`title`, `Category`.`keywords`, `Category`.`description`, `Category`.`h1`, `Category`.`sort_order`, `Category`.`is_open`, `PartiesCategory`.`id`, `PartiesCategory`.`party_id`, `PartiesCategory`.`category_id`, `PartiesCategory`.`modified`, `PartiesCategory`.`created` FROM `far1_schedulechat`.`categories` AS `Category` JOIN `far1_schedulechat`.`parties_categories` AS `PartiesCategory` ON (`PartiesCategory`.`party_id` IN (14400, 14402, 14404) AND `PartiesCategory`.`category_id` = `Category`.`id`) | 9 | 9 | 0 | |
| 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') AND (((`Party`.`assign_team_id` IS NULL) OR (`Party`.`assign_team_id` <> 6)))) ORDER BY `Category`.`sort_order` ASC | 2 | 2 | 45 | maybe slow |
| SELECT `ServiceAdvertisementCategory`.`id`, `ServiceAdvertisementCategory`.`service_advertisement_id`, `ServiceAdvertisementCategory`.`category_name`, `ServiceAdvertisementCategory`.`modified`, `ServiceAdvertisementCategory`.`created`, `ServiceAdvertisement`.`id`, `ServiceAdvertisement`.`label`, `ServiceAdvertisement`.`image_file_name`, `ServiceAdvertisement`.`is_separated_sex`, `ServiceAdvertisement`.`modal_type`, `ServiceAdvertisement`.`url`, `ServiceAdvertisement`.`url_male`, `ServiceAdvertisement`.`url_female`, `ServiceAdvertisement`.`is_active`, `ServiceAdvertisement`.`modified`, `ServiceAdvertisement`.`created` FROM `far1_schedulechat`.`service_advertisement_categories` AS `ServiceAdvertisementCategory` LEFT JOIN `far1_schedulechat`.`service_advertisements` AS `ServiceAdvertisement` ON (`ServiceAdvertisementCategory`.`service_advertisement_id` = `ServiceAdvertisement`.`id`) WHERE `category_name` = 'thirty_male_l' | 0 | 0 | 0 | |
| SELECT `PartyCapacity`.`id`, `PartyCapacity`.`party_id`, `PartyCapacity`.`sex_id`, `PartyCapacity`.`sex_char`, `PartyCapacity`.`name`, `PartyCapacity`.`lower_age`, `PartyCapacity`.`upper_age`, `PartyCapacity`.`capacity`, `PartyCapacity`.`is_close`, `PartyCapacity`.`modified`, `PartyCapacity`.`created`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 0
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__reserved_number`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 1
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__joined_number`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 6
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__reviewing_number` FROM `far1_schedulechat`.`party_capacities` AS `PartyCapacity` WHERE `PartyCapacity`.`party_id` = 14400 | 2 | 2 | 1 | maybe slow |
| SELECT `PartyCapacity`.`id`, `PartyCapacity`.`party_id`, `PartyCapacity`.`sex_id`, `PartyCapacity`.`sex_char`, `PartyCapacity`.`name`, `PartyCapacity`.`lower_age`, `PartyCapacity`.`upper_age`, `PartyCapacity`.`capacity`, `PartyCapacity`.`is_close`, `PartyCapacity`.`modified`, `PartyCapacity`.`created`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 0
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__reserved_number`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 1
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__joined_number`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 6
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__reviewing_number` FROM `far1_schedulechat`.`party_capacities` AS `PartyCapacity` WHERE `PartyCapacity`.`party_id` = 14402 | 2 | 2 | 0 | |
| SELECT `PartyCapacity`.`id`, `PartyCapacity`.`party_id`, `PartyCapacity`.`sex_id`, `PartyCapacity`.`sex_char`, `PartyCapacity`.`name`, `PartyCapacity`.`lower_age`, `PartyCapacity`.`upper_age`, `PartyCapacity`.`capacity`, `PartyCapacity`.`is_close`, `PartyCapacity`.`modified`, `PartyCapacity`.`created`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 0
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__reserved_number`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 1
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__joined_number`, (
SELECT count(`reservation`.`reservation_id`)
FROM reservation
WHERE `reservation`.`party_id` = `PartyCapacity`.`party_id`
AND `reservation`.`age` >= `PartyCapacity`.`lower_age`
AND `reservation`.`age` <= `PartyCapacity`.`upper_age`
AND `reservation`.`sex` = `PartyCapacity`.`sex_char`
AND `reservation`.`status` = 6
AND `reservation`.`cancel_flag` = 0) AS `PartyCapacity__reviewing_number` FROM `far1_schedulechat`.`party_capacities` AS `PartyCapacity` WHERE `PartyCapacity`.`party_id` = 14404 | 2 | 2 | 0 | |