Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Shop`.`id`, `Shop`.`brand_name`, `Shop`.`mail_shop_name` FROM `sc_app_elleseine_uat`.`shops` AS `Shop` WHERE `Shop`.`show_entry_site` = 1 AND `Shop`.`active` = 1 ORDER BY `Shop`.`sort_order_key` ASC | 46 | 46 | 4 | maybe slow |
SELECT `Shop`.`id`, `Shop`.`brand_name`, `Shop`.`mail_shop_name`, `Shop`.`shop_introduction` FROM `sc_app_elleseine_uat`.`shops` AS `Shop` WHERE `Shop`.`id` IN (9, 10, 12, 13, 1, 3, 16, 8, 52, 18, 17, 20, 23, 22, 5, 24, 25, 26, 27, 28, 7, 41, 14, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 19, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29) | 46 | 46 | 4 | maybe slow |
SELECT `S3Attachment`.`id`, `S3Attachment`.`media_no`, `S3Attachment`.`parent_id` FROM `sc_app_elleseine_uat`.`s3_attachments` AS `S3Attachment` WHERE `parent_model` = 'shop' AND `S3Attachment`.`parent_id` IN (1, 3, 5, 7, 8, 9, 10, 12, 13, 14, 16, 17, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52) ORDER BY `media_no` ASC | 3 | 3 | 3 | |
SELECT `Item`.`id`, `Item`.`name` FROM `sc_app_elleseine_uat`.`items` AS `Item` WHERE `Item`.`item_type` = 1 AND `Item`.`service_target_type` IN (1, 3) AND `Item`.`sales_chanel_type` = 2 AND `Item`.`active` = 1 AND `Item`.`fc_id` IS NULL ORDER BY `Item`.`sort_order_key` desc | 16 | 16 | 124 | maybe slow |
SELECT `SettingOption`.`group_name`, `SettingOption`.`opt_val`, `SettingOption`.`print_name` FROM `sc_app_elleseine_uat`.`setting_options` AS `SettingOption` WHERE group_name = ('consumption_tax_calc_rate') ORDER BY `SettingOption`.`group_name` asc, `SettingOption`.`sort_order_key` asc, `SettingOption`.`opt_val` asc | 3 | 3 | 3 | |
SELECT `CustomSettingOption`.`id`, `CustomSettingOption`.`custom_setting_option_group_id`, `CustomSettingOption`.`opt_val`, `CustomSettingOption`.`print_name`, `CustomSettingOption`.`print_name_short`, `CustomSettingOption`.`param_value`, `CustomSettingOption`.`use_type`, `CustomSettingOption`.`start_date`, `CustomSettingOption`.`end_date`, `CustomSettingOption`.`active`, `CustomSettingOption`.`sort_order_key`, `CustomSettingOption`.`internal_memo`, `CustomSettingOption`.`created`, `CustomSettingOption`.`modified`, `CustomSettingOptionGroup`.`id`, `CustomSettingOptionGroup`.`key_name` FROM `sc_app_elleseine_uat`.`custom_setting_options` AS `CustomSettingOption` LEFT JOIN `sc_app_elleseine_uat`.`custom_setting_option_groups` AS `CustomSettingOptionGroup` ON (`CustomSettingOption`.`custom_setting_option_group_id` = `CustomSettingOptionGroup`.`id`) WHERE `key_name` IN ('entry_time_zone', 'entry_enq_2_opt', 'entry_enq_2_name', 'service_name', 'homepage_url', 'entry_url', 'entry_url_validation_params') AND `active` = 1 ORDER BY `CustomSettingOption`.`custom_setting_option_group_id` asc, `CustomSettingOption`.`sort_order_key` desc, `CustomSettingOption`.`opt_val` asc | 12 | 12 | 3 | maybe slow |
SELECT `DynamicContent`.`key_name`, `DynamicContent`.`option_value` FROM `sc_app_elleseine_uat`.`dynamic_contents` AS `DynamicContent` WHERE 1 = 1 | 96 | 96 | 3 | |
SELECT `ShopRegion`.`id`, `ShopRegion`.`shop_region_id`, `ShopRegion`.`region_name`, `ShopRegion`.`active`, `ShopRegion`.`note`, `ShopRegion`.`sort_order_key`, `ShopRegion`.`created`, `ShopRegion`.`modified` FROM `sc_app_elleseine_uat`.`shop_regions` AS `ShopRegion` WHERE `active` = 1 ORDER BY `sort_order_key` desc | 6 | 6 | 2 | maybe slow |
SELECT `Shop`.`id`, `Shop`.`brand_name`, `Shop`.`mail_shop_name`, `Shop`.`active`, `Shop`.`sort_order_key`, `Shop`.`shop_region_id` FROM `sc_app_elleseine_uat`.`shops` AS `Shop` WHERE `active` = 1 AND `show_entry_site` = 1 AND `id` IN (9, 10, 12, 13, 1, 3, 16, 8, 52, 18, 17, 20, 23, 22, 5, 24, 25, 26, 27, 28, 7, 41, 14, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 19, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29) AND `Shop`.`shop_region_id` IN (1, 5, 2, 8, 7, 9) ORDER BY `sort_order_key` ASC | 20 | 20 | 2 | maybe slow |
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `sc_app_elleseine_uat`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'bih1bfqa9vu5qcf6jl8j9vrgqhnd2mp7' LIMIT 1 | 0 | 0 | 2 | maybe slow |
SELECT `Shop`.`id`, `Shop`.`max_entry` FROM `sc_app_elleseine_uat`.`shops` AS `Shop` WHERE `show_entry_site` = 1 AND `active` = 1 ORDER BY `sort_order_key` ASC | 46 | 46 | 2 | |
SELECT `S3Attachment`.`id`, `S3Attachment`.`media_no`, `S3Attachment`.`parent_id` FROM `sc_app_elleseine_uat`.`s3_attachments` AS `S3Attachment` WHERE `parent_model` = 'shop' AND `S3Attachment`.`parent_id` IN (9, 10, 12, 13, 1, 3, 16, 8, 52, 18, 17, 20, 23, 22, 5, 24, 25, 26, 27, 28, 7, 41, 14, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 19, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29) ORDER BY `media_no` ASC | 3 | 3 | 2 | maybe slow |
SELECT `Holiday`.`target_date`, `Holiday`.`shop_id`, `Holiday`.`id`, `Holiday`.`max_entry_capacity`, `Holiday`.`regular_holiday_type` FROM `sc_app_elleseine_uat`.`holidays` AS `Holiday` WHERE `active` = 1 AND `target_date` >= '2025-08-02' AND `target_date` <= '2025-11-01' ORDER BY `target_date` ASC | 13 | 13 | 3 | maybe slow |
SELECT `Reservation`.`shop_id`, `Reservation`.`reservation_date`, COUNT(`Reservation`.`id`) AS total FROM `sc_app_elleseine_uat`.`reservations` AS `Reservation` LEFT JOIN `sc_app_elleseine_uat`.`shops` AS `Shop` ON (`Reservation`.`shop_id` = `Shop`.`id`) WHERE `Reservation`.`reservation_status` IN (1, 2, 7) AND `Reservation`.`reservation_date` IN ('2025-08-03', '2025-08-04', '2025-08-05', '2025-08-06', '2025-08-07', '2025-08-08', '2025-08-09', '2025-08-10', '2025-08-11', '2025-08-12', '2025-08-13', '2025-08-14', '2025-08-15', '2025-08-16') AND `Reservation`.`shop_id` IN (9, 10, 12, 13, 1, 3, 16, 8, 52, 18, 17, 20, 23, 22, 5, 24, 25, 26, 27, 28, 7, 41, 14, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 19, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29) AND ((`Shop`.`entry_limitation_count_type` = 1) OR (((`Shop`.`entry_limitation_count_type` = 2) AND (`Reservation`.`reservation_type` = 1)))) GROUP BY `Reservation`.`shop_id`, `Reservation`.`reservation_date` ORDER BY `Reservation`.`reservation_date` ASC | 1 | 1 | 3 | maybe slow |