Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Item`.`id`, `Item`.`name` FROM `sc_app_elleseine_uat`.`items` AS `Item` WHERE `item_type` = 1 AND `service_target_type` IN (1, 3) AND `sales_chanel_type` = 2 AND `active` = 1 ORDER BY `sort_order_key` desc | 15 | 15 | 72 | 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 | 2 | maybe slow |
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') ORDER BY `CustomSettingOption`.`custom_setting_option_group_id` asc, `CustomSettingOption`.`sort_order_key` desc, `CustomSettingOption`.`opt_val` asc | 14 | 14 | 2 | maybe slow |
SELECT `DynamicContent`.`key_name`, `DynamicContent`.`option_value` FROM `sc_app_elleseine_uat`.`dynamic_contents` AS `DynamicContent` WHERE 1 = 1 | 46 | 46 | 2 | |
SELECT `ShopRegion`.`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 `Shop`.`shop_region_id` IN (1, 5, 2, 8, 7, 9) ORDER BY `sort_order_key` ASC | 20 | 20 | 2 | maybe slow |
SELECT `Shop`.`id`, `Shop`.`brand_name`, `Shop`.`mail_shop_name` 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 `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `sc_app_elleseine_uat`.`cake_sessions` AS `Session` WHERE `Session`.`id` = '51ukuc4f5mrnqvmdjf92a4hfc9rkqe9p' 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 `Holiday`.`target_date`, `Holiday`.`shop_id`, `Holiday`.`id` FROM `sc_app_elleseine_uat`.`holidays` AS `Holiday` WHERE `target_date` >= '2025-04-26' AND `target_date` <= '2025-07-26' ORDER BY `target_date` ASC | 15 | 15 | 2 | maybe slow |
SELECT `Reservation`.`shop_id`, `Reservation`.`reservation_date`, COUNT(`Reservation`.`id`) AS total FROM `sc_app_elleseine_uat`.`reservations` AS `Reservation` WHERE `Reservation`.`reservation_status` IN (1, 2, 7) AND `Reservation`.`reservation_date` IN ('2025-04-27', '2025-04-28', '2025-04-29', '2025-04-30', '2025-05-01', '2025-05-02', '2025-05-03', '2025-05-04', '2025-05-05', '2025-05-06', '2025-05-07', '2025-05-08', '2025-05-09', '2025-05-10') 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) GROUP BY `Reservation`.`shop_id`, `Reservation`.`reservation_date` ORDER BY `Reservation`.`reservation_date` ASC | 0 | 0 | 2 | maybe slow |