Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop5`.`settings` AS `Setting` WHERE 1 = 1 | 31 | 31 | 1 | |
SHOW TABLE STATUS | 32 | 32 | 4 | maybe slow |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `name` = 'normal_prices' AND `display_flag` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc | 14 | 14 | 1 | maybe slow |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `name` = 'delivery_prices' AND `display_flag` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `parent_id` = 2 AND `display_flag` = '1' ORDER BY `number` asc | 13 | 13 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `name` = 'annotation' AND `parent_id` IS NULL AND `display_flag` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `parent_id` = 44 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `name` = 'information' AND `parent_id` IS NULL AND `display_flag` = '1' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Price`.`id`, `Price`.`display_flag`, `Price`.`parent_id`, `Price`.`name`, `Price`.`type`, `Price`.`value`, `Price`.`top_value`, `Price`.`bottom_flag`, `Price`.`number`, `Price`.`created`, `Price`.`modified` FROM `kir060294_testshop5`.`prices` AS `Price` WHERE `parent_id` = 46 AND `display_flag` = '1' ORDER BY `number` asc | 1 | 1 | 0 | |
SELECT `Ranking`.`id`, `Ranking`.`display_flag`, `Ranking`.`title`, `Ranking`.`number`, `Ranking`.`created`, `Ranking`.`modified` FROM `kir060294_testshop5`.`rankings` AS `Ranking` WHERE `display_flag` = '1' ORDER BY `number` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT `FooterVendorBanner`.`id`, `FooterVendorBanner`.`display_flag`, `FooterVendorBanner`.`type`, `FooterVendorBanner`.`file_name`, `FooterVendorBanner`.`source`, `FooterVendorBanner`.`link`, `FooterVendorBanner`.`alt`, `FooterVendorBanner`.`new_tab`, `FooterVendorBanner`.`number`, `FooterVendorBanner`.`created`, `FooterVendorBanner`.`modifield` FROM `kir060294_testshop5`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop5`.`options` AS `Option` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop5`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 26 | 26 | 0 | |
SELECT `Type`.`id`, `Type`.`background_color` FROM `kir060294_testshop5`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 26 | 26 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_testshop5`.`casts` AS `Cast` WHERE `Cast`.`id` = 702 AND `Cast`.`display_flag` = '1' | 1 | 1 | 0 | |
SELECT `Cast`.`id`, `Cast`.`group_id`, `Cast`.`display_flag`, `Cast`.`name`, `Cast`.`age`, `Cast`.`height`, `Cast`.`bust`, `Cast`.`cup`, `Cast`.`waist`, `Cast`.`hip`, `Cast`.`image_kind`, `Cast`.`real_time_information_flag`, `Cast`.`real_time_information_title`, `Cast`.`real_time_information_comment`, `Cast`.`real_time_information_number`, `Cast`.`delivery_flag`, `Cast`.`meet_up_flag`, `Cast`.`comment`, `Cast`.`heaven_id`, `Cast`.`heaven_password`, `Cast`.`extra_charge`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified`, `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified`, `Reserve`.`id`, `Reserve`.`schedule_id`, `Reserve`.`cast_id`, `Reserve`.`start`, `Reserve`.`end`, `Reserve`.`created`, `Reserve`.`modified` FROM `kir060294_testshop5`.`casts` AS `Cast` LEFT JOIN `kir060294_testshop5`.`schedules` AS `Schedule` ON (`Schedule`.`cast_id` = `Cast`.`id` AND `Schedule`.`start` >= '2025-04-06 12:30:00' AND `Schedule`.`end` <= '2025-04-07 01:00:00') LEFT JOIN `kir060294_testshop5`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-04-06 12:30:00' AND `Reserve`.`end` <= '2025-04-07 01:00:00') WHERE `Cast`.`id` = 702 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop5`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (702) ORDER BY `CastImage`.`number` asc | 5 | 5 | 1 | maybe slow |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop5`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (702) | 7 | 7 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop5`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (702) | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop5`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop5`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `Type`.`number` asc | 26 | 26 | 0 | |
SELECT `Cast`.`id`, `Cast`.`group_id`, `Cast`.`display_flag`, `Cast`.`name`, `Cast`.`age`, `Cast`.`height`, `Cast`.`bust`, `Cast`.`cup`, `Cast`.`waist`, `Cast`.`hip`, `Cast`.`image_kind`, `Cast`.`real_time_information_flag`, `Cast`.`real_time_information_title`, `Cast`.`real_time_information_comment`, `Cast`.`real_time_information_number`, `Cast`.`delivery_flag`, `Cast`.`meet_up_flag`, `Cast`.`comment`, `Cast`.`heaven_id`, `Cast`.`heaven_password`, `Cast`.`extra_charge`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified` FROM `kir060294_testshop5`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` < 21 ORDER BY `number` desc LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop5`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (299) ORDER BY `CastImage`.`number` asc | 5 | 5 | 1 | maybe slow |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop5`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (299) | 5 | 5 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop5`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (299) | 0 | 0 | 0 | |
SELECT `Cast`.`id`, `Cast`.`group_id`, `Cast`.`display_flag`, `Cast`.`name`, `Cast`.`age`, `Cast`.`height`, `Cast`.`bust`, `Cast`.`cup`, `Cast`.`waist`, `Cast`.`hip`, `Cast`.`image_kind`, `Cast`.`real_time_information_flag`, `Cast`.`real_time_information_title`, `Cast`.`real_time_information_comment`, `Cast`.`real_time_information_number`, `Cast`.`delivery_flag`, `Cast`.`meet_up_flag`, `Cast`.`comment`, `Cast`.`heaven_id`, `Cast`.`heaven_password`, `Cast`.`extra_charge`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified` FROM `kir060294_testshop5`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` > 21 ORDER BY `number` asc LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop5`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (737) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop5`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (737) | 7 | 7 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop5`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (737) | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-06 12:30:00' AND `Schedule`.`end` <= '2025-04-07 01:00:00' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-07 12:30:00' AND `Schedule`.`end` <= '2025-04-08 01:00:00' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-08 12:30:00' AND `Schedule`.`end` <= '2025-04-09 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-09 12:30:00' AND `Schedule`.`end` <= '2025-04-10 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-10 12:30:00' AND `Schedule`.`end` <= '2025-04-11 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-11 12:30:00' AND `Schedule`.`end` <= '2025-04-12 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-12 12:30:00' AND `Schedule`.`end` <= '2025-04-13 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-13 12:30:00' AND `Schedule`.`end` <= '2025-04-14 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-14 12:30:00' AND `Schedule`.`end` <= '2025-04-15 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-15 12:30:00' AND `Schedule`.`end` <= '2025-04-16 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-16 12:30:00' AND `Schedule`.`end` <= '2025-04-17 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-17 12:30:00' AND `Schedule`.`end` <= '2025-04-18 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-18 12:30:00' AND `Schedule`.`end` <= '2025-04-19 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-19 12:30:00' AND `Schedule`.`end` <= '2025-04-20 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-20 12:30:00' AND `Schedule`.`end` <= '2025-04-21 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-21 12:30:00' AND `Schedule`.`end` <= '2025-04-22 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-22 12:30:00' AND `Schedule`.`end` <= '2025-04-23 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-23 12:30:00' AND `Schedule`.`end` <= '2025-04-24 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-24 12:30:00' AND `Schedule`.`end` <= '2025-04-25 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-25 12:30:00' AND `Schedule`.`end` <= '2025-04-26 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-26 12:30:00' AND `Schedule`.`end` <= '2025-04-27 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-27 12:30:00' AND `Schedule`.`end` <= '2025-04-28 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-28 12:30:00' AND `Schedule`.`end` <= '2025-04-29 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-29 12:30:00' AND `Schedule`.`end` <= '2025-04-30 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-04-30 12:30:00' AND `Schedule`.`end` <= '2025-05-01 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-05-01 12:30:00' AND `Schedule`.`end` <= '2025-05-02 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-05-02 12:30:00' AND `Schedule`.`end` <= '2025-05-03 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop5`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 702 AND `Schedule`.`start` >= '2025-05-03 12:30:00' AND `Schedule`.`end` <= '2025-05-04 01:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `HasType`.`id`, `HasType`.`cast_id` FROM `kir060294_testshop5`.`has_types` AS `HasType` WHERE `HasType`.`type_id` IS NULL | 0 | 0 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id` FROM `kir060294_testshop5`.`has_options` AS `HasOption` WHERE `HasOption`.`option_id` IN (9, 8, 6, 5, 4, 2, 1) | 956 | 956 | 1 | |
SELECT `Cast`.`id`, `Cast`.`group_id`, `Cast`.`display_flag`, `Cast`.`name`, `Cast`.`age`, `Cast`.`height`, `Cast`.`bust`, `Cast`.`cup`, `Cast`.`waist`, `Cast`.`hip`, `Cast`.`image_kind`, `Cast`.`real_time_information_flag`, `Cast`.`real_time_information_title`, `Cast`.`real_time_information_comment`, `Cast`.`real_time_information_number`, `Cast`.`delivery_flag`, `Cast`.`meet_up_flag`, `Cast`.`comment`, `Cast`.`heaven_id`, `Cast`.`heaven_password`, `Cast`.`extra_charge`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified` FROM `kir060294_testshop5`.`casts` AS `Cast` WHERE `Cast`.`display_flag` = '1' AND `Cast`.`id` IN (732, 732, 613, 732, 732, 732, 656, 718, 656, 703, 729, 729, 725, 725, 725, 724, 514, 724, 514, 514, 514, 327, 538, 654, 538, 538, 614, 314, 314, 83, 83, 653, 83, 83, 83, 83, 83, 680, 670, 680, 680, 680, 680, 655, 655, 702, 652, 670, 652, 627, 627, 627, 78, 78, 492, 78, 78, 78, 78, 736, 736, 734, 734, 734, 656, 670, 705, 705, 705, 297, 297, 659, 297, 297, 297, 297, 75, 75, 659, 75, 75, 75, 75, 74, 74, 658, 74, 74, 74, 688, 688, 544, 697, 697, 324, 324, 497, 614, 70, 70, 751, 70, 70, 70, 70, 69, 69, 69, 69, 69, 669, 669, 492, 702, 741, 656, 497, 492, 678, 678, 678, 678, 669, 328, 328, 491, 328, 328, 328, 328, 709, 669, 491, 751, 661, 675, 689, 64, 64, 64, 64, 64, 64, 63, 63, 689, 63, 63, 63, 63, 63, 614, 614, 693, 717, 440, 717, 666, 666, 666, 327, 327, 440, 327, 327, 327, 327, 521, 521, 440, 521, 658, 58, 58, 693, 58, 58, 57, 57, 705, 57, 57, 57, 57, 646, 646, 646, 646, 507, 507, 655, 507, 506, 506, 506, 506, 652, 652, 654, 680, 679, 679, 679, 649, 647, 727, 647, 647, 647, 646, 646, 646, 686, 670, 689, 299, 299, 299, 735, 735, 615, 704, 684, 684, 684, 684, 666, 591, 615, 666, 666, 666, 509, 508, 508, 740, 740, 637, 740, 739, 739, 509, 637, 509, 509, 741, 531, 531, 531, 648, 648, 648, 697, 648, 648, 648, 658, 491, 704, 704, 703, 697, 703, 528, 209, 528, 528, 528, 528, 491, 209, 704, 492, 492, 274, 274, 686, 209, 544, 568, 603, 602, 473, 473, 473, 473, 558, 715, 499, 709, 709, 497, 728, 499, 728, 324, 654, 654, 692, 655, 531, 503, 499, 558, 697, 568, 692, 568, 739, 739, 739, 738, 692, 183, 183, 510, 510, 510, 510, 709, 531, 733, 733, 733, 733, 733, 603, 704, 531, 686, 684, 684, 684, 686, 738, 738, 688, 688, 314, 314, 314, 670, 670, 670, 721, 721, 721, 721, 660, 314, 314, 312, 503, 503, 750, 723, 602, 615, 733, 312, 497, 603, 603, 603, 689, 492, 711, 509, 509, 509, 627, 653, 662, 274, 274, 274, 274, 558, 508, 653, 508, 507, 505, 505, 514, 689, 544, 320, 693, 693, 653, 709, 709, 705, 706, 752, 752, 642, 752, 752, 752, 752, 729, 729, 728, 729, 75, 685, 731, 731, 558, 614, 706, 503, 682, 682, 682, 295, 295, 295, 295, 685, 602, 602, 703, 613, 655, 627, 627, 652, 652, 655, 652, 13, 13, 538, 13, 13, 661, 661, 430, 711, 711, 671, 671, 669, 10, 10, 430, 10, 10, 738, 738, 430, 738, 675, 675, 675, 727, 295, 295, 295, 183, 183, 290, 492, 491, 497, 731, 731, 731, 731, 430, 729, 729, 430, 725, 724, 430, 724, 614, 544, 544, 430, 544, 558, 690, 508, 690, 324, 324, 614, 703, 499, 499, 726, 726, 726, 688, 726, 726, 703, 662, 756, 743, 743, 756, 743, 743, 743, 746, 510, 510, 685, 685, 703, 466, 466, 746, 746, 756, 740, 740, 740, 740, 723, 498, 755, 498, 693, 675, 715, 675, 612, 3, 693, 747, 591, 591, 324, 183, 183, 183, 3, 747, 735, 734, 715, 732, 632, 612, 473, 473, 632, 706, 686, 686, 741, 711, 711, 682, 735, 735, 613, 735, 734, 514, 613, 612, 612, 702, 680, 665, 665, 665, 557, 613, 737, 737, 662, 662, 737, 737, 588, 685, 499, 588, 588, 588, 738, 665, 665, 665, 722, 690, 690, 299, 299, 710, 717, 720, 720, 320, 710, 709, 701, 701, 701, 701, 671, 320, 671, 671, 741, 744, 320, 744, 744, 744, 744, 743, 743, 720, 719, 736, 736, 320, 736, 735, 3, 3, 736, 736, 514, 660, 505, 531, 753, 568, 568, 568, 297, 712, 712, 753, 712, 712, 712, 724, 724, 724, 722, 722, 737, 737, 632, 715, 715, 568, 711, 603, 497, 671, 741, 701, 701, 701, 658, 658, 632, 656, 656, 275, 275, 632, 275, 275, 275, 275, 658, 658, 753, 637, 637, 491, 602, 685, 685, 496, 637, 637, 320, 320, 588, 588, 496, 588, 750, 750, 496, 499, 312, 312, 312, 702, 741, 538, 557, 557, 144, 144, 538, 144, 144, 612, 688, 722, 591, 591, 591, 591, 747, 612, 693, 692, 692, 722, 692, 747, 722, 747, 747, 637, 659, 659, 659, 557, 717, 557, 557, 662, 662, 661, 661, 690, 690, 440, 753, 753, 753, 755, 755, 497, 715, 715, 496, 714, 496, 495, 495, 495, 495, 495, 714, 507, 665, 679, 508, 234, 234, 234, 234, 234, 234, 440, 498, 498, 498, 721, 721, 539, 539, 539, 539, 539, 671, 548, 548, 548, 613, 642, 642, 528, 275, 662, 570, 570, 570, 750, 750, 498, 498, 654, 654, 714, 661, 660, 660, 714, 717, 698, 698, 705, 704, 459, 459, 459, 459, 702, 459, 473, 712, 712, 710, 710, 710, 710, 689, 689, 632, 642, 466, 466, 711, 678, 679, 679, 679, 649, 649, 649, 649, 649, 698, 698, 698, 698, 698, 548, 642, 290, 290, 290, 290, 495, 495, 654, 521, 521, 521, 714, 714, 714, 726, 440, 539, 440, 602, 548, 548, 288, 288, 288, 288, 688, 723, 723, 544, 259, 259, 259, 259, 259, 259, 259, 678, 678, 507, 507, 503, 503, 719, 728, 728, 727, 653, 727, 727, 727, 653, 706, 706, 706, 538, 723, 615, 615, 615, 615, 659, 702, 702, 521, 660, 704, 682, 682, 719, 718, 718, 718, 718, 697, 753, 744, 744, 755, 755, 755, 755, 754, 754, 754, 754, 754, 754, 746, 746, 746, 746, 749, 749, 749, 749, 749, 749, 749, 751, 751, 751, 751, 751, 756, 756, 756, 756) AND NOT (`Cast`.`id` = 702) ORDER BY `Cast`.`number` asc | 113 | 113 | 4 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop5`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` IN (591, 466, 660, 652, 473, 692, 732, 735, 615, 320, 706, 734, 715, 750, 83, 656, 274, 746, 528, 440, 299, 737, 747, 666, 665, 693, 658, 728, 491, 312, 698, 682, 144, 70, 646, 557, 669, 514, 64, 314, 492, 430, 647, 718, 288, 649, 544, 558, 183, 275, 538, 290, 548, 74, 57, 755, 756, 753, 754, 751, 749, 744, 743, 741, 733, 740, 739, 736, 727, 725, 724, 723, 719, 720, 722, 714, 711, 709, 705, 297, 234, 684, 680, 670, 685, 661, 632, 614, 613, 603, 602, 324, 69, 209, 78, 63, 13, 75, 58, 10, 495, 496, 497, 498, 503, 499, 506, 507, 508, 509, 510, 752, 729) ORDER BY `CastImage`.`number` asc | 419 | 419 | 3 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop5`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` IN (591, 466, 660, 652, 473, 692, 732, 735, 615, 320, 706, 734, 715, 750, 83, 656, 274, 746, 528, 440, 299, 737, 747, 666, 665, 693, 658, 728, 491, 312, 698, 682, 144, 70, 646, 557, 669, 514, 64, 314, 492, 430, 647, 718, 288, 649, 544, 558, 183, 275, 538, 290, 548, 74, 57, 755, 756, 753, 754, 751, 749, 744, 743, 741, 733, 740, 739, 736, 727, 725, 724, 723, 719, 720, 722, 714, 711, 709, 705, 297, 234, 684, 680, 670, 685, 661, 632, 614, 613, 603, 602, 324, 69, 209, 78, 63, 13, 75, 58, 10, 495, 496, 497, 498, 503, 499, 506, 507, 508, 509, 510, 752, 729) | 782 | 782 | 1 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop5`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` IN (591, 466, 660, 652, 473, 692, 732, 735, 615, 320, 706, 734, 715, 750, 83, 656, 274, 746, 528, 440, 299, 737, 747, 666, 665, 693, 658, 728, 491, 312, 698, 682, 144, 70, 646, 557, 669, 514, 64, 314, 492, 430, 647, 718, 288, 649, 544, 558, 183, 275, 538, 290, 548, 74, 57, 755, 756, 753, 754, 751, 749, 744, 743, 741, 733, 740, 739, 736, 727, 725, 724, 723, 719, 720, 722, 714, 711, 709, 705, 297, 234, 684, 680, 670, 685, 661, 632, 614, 613, 603, 602, 324, 69, 209, 78, 63, 13, 75, 58, 10, 495, 496, 497, 498, 503, 499, 506, 507, 508, 509, 510, 752, 729) | 0 | 0 | 0 | |
SELECT `TopBanner`.`id`, `TopBanner`.`display_flag`, `TopBanner`.`src`, `TopBanner`.`alt`, `TopBanner`.`link`, `TopBanner`.`number`, `TopBanner`.`modified` FROM `kir060294_testshop5`.`top_banners` AS `TopBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 4 | 4 | 0 | |
SELECT `PhoneBanner`.`id`, `PhoneBanner`.`display_flag`, `PhoneBanner`.`image_kind`, `PhoneBanner`.`img`, `PhoneBanner`.`alt`, `PhoneBanner`.`link`, `PhoneBanner`.`blank`, `PhoneBanner`.`created`, `PhoneBanner`.`modified` FROM `kir060294_testshop5`.`phone_banners` AS `PhoneBanner` WHERE 1 = 1 LIMIT 1 | 0 | 0 | 0 | |
SELECT `FooterBanner`.`id`, `FooterBanner`.`display_flag_pc`, `FooterBanner`.`display_flag_mobile`, `FooterBanner`.`src_pc`, `FooterBanner`.`src_mobile`, `FooterBanner`.`alt`, `FooterBanner`.`link`, `FooterBanner`.`modified` FROM `kir060294_testshop5`.`footer_banners` AS `FooterBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |