Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop4`.`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_testshop4`.`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_testshop4`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc | 14 | 14 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop4`.`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_testshop4`.`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_testshop4`.`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_testshop4`.`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_testshop4`.`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_testshop4`.`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_testshop4`.`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_testshop4`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop4`.`options` AS `Option` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop4`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 24 | 24 | 0 | |
SELECT `Type`.`id`, `Type`.`background_color` FROM `kir060294_testshop4`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 24 | 24 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_testshop4`.`casts` AS `Cast` WHERE `Cast`.`id` = 700 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_testshop4`.`casts` AS `Cast` LEFT JOIN `kir060294_testshop4`.`schedules` AS `Schedule` ON (`Schedule`.`cast_id` = `Cast`.`id` AND `Schedule`.`start` >= '2025-04-07 10:00:00' AND `Schedule`.`end` <= '2025-04-08 02:00:00') LEFT JOIN `kir060294_testshop4`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-04-07 10:00:00' AND `Reserve`.`end` <= '2025-04-08 02:00:00') WHERE `Cast`.`id` = 700 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop4`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (700) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop4`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (700) | 8 | 8 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop4`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (700) | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop4`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop4`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `Type`.`number` asc | 24 | 24 | 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_testshop4`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` < 55 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_testshop4`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (697) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop4`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (697) | 5 | 5 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop4`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (697) | 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_testshop4`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` > 55 ORDER BY `number` asc LIMIT 1 | 1 | 1 | 0 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop4`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (741) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop4`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (741) | 9 | 9 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop4`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (741) | 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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-07 10:00:00' AND `Schedule`.`end` <= '2025-04-08 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-08 10:00:00' AND `Schedule`.`end` <= '2025-04-09 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-09 10:00:00' AND `Schedule`.`end` <= '2025-04-10 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-10 10:00:00' AND `Schedule`.`end` <= '2025-04-11 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-11 10:00:00' AND `Schedule`.`end` <= '2025-04-12 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-12 10:00:00' AND `Schedule`.`end` <= '2025-04-13 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-13 10:00:00' AND `Schedule`.`end` <= '2025-04-14 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-14 10:00:00' AND `Schedule`.`end` <= '2025-04-15 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-15 10:00:00' AND `Schedule`.`end` <= '2025-04-16 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-16 10:00:00' AND `Schedule`.`end` <= '2025-04-17 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-17 10:00:00' AND `Schedule`.`end` <= '2025-04-18 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-18 10:00:00' AND `Schedule`.`end` <= '2025-04-19 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-19 10:00:00' AND `Schedule`.`end` <= '2025-04-20 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-20 10:00:00' AND `Schedule`.`end` <= '2025-04-21 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-21 10:00:00' AND `Schedule`.`end` <= '2025-04-22 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-22 10:00:00' AND `Schedule`.`end` <= '2025-04-23 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-23 10:00:00' AND `Schedule`.`end` <= '2025-04-24 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-24 10:00:00' AND `Schedule`.`end` <= '2025-04-25 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-25 10:00:00' AND `Schedule`.`end` <= '2025-04-26 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-26 10:00:00' AND `Schedule`.`end` <= '2025-04-27 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-27 10:00:00' AND `Schedule`.`end` <= '2025-04-28 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-28 10:00:00' AND `Schedule`.`end` <= '2025-04-29 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-29 10:00:00' AND `Schedule`.`end` <= '2025-04-30 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-04-30 10:00:00' AND `Schedule`.`end` <= '2025-05-01 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-05-01 10:00:00' AND `Schedule`.`end` <= '2025-05-02 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-05-02 10:00:00' AND `Schedule`.`end` <= '2025-05-03 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-05-03 10:00:00' AND `Schedule`.`end` <= '2025-05-04 02: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_testshop4`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 700 AND `Schedule`.`start` >= '2025-05-04 10:00:00' AND `Schedule`.`end` <= '2025-05-05 02:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `HasType`.`id`, `HasType`.`cast_id` FROM `kir060294_testshop4`.`has_types` AS `HasType` WHERE `HasType`.`type_id` IS NULL | 0 | 0 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id` FROM `kir060294_testshop4`.`has_options` AS `HasOption` WHERE `HasOption`.`option_id` IN (4, 2, 1, 9, 8, 6, 7, 5) | 995 | 995 | 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_testshop4`.`casts` AS `Cast` WHERE `Cast`.`display_flag` = '1' AND `Cast`.`id` IN (441, 502, 701, 789, 789, 796, 749, 749, 749, 812, 796, 796, 544, 743, 585, 653, 742, 540, 721, 540, 540, 800, 721, 641, 641, 641, 641, 813, 809, 809, 809, 762, 799, 799, 799, 799, 799, 721, 799, 799, 523, 753, 527, 441, 441, 721, 441, 441, 721, 534, 753, 753, 730, 720, 794, 743, 743, 743, 690, 779, 779, 779, 523, 778, 749, 742, 811, 731, 511, 511, 521, 523, 703, 703, 705, 700, 700, 700, 699, 699, 713, 786, 730, 523, 523, 523, 800, 502, 541, 794, 794, 800, 454, 812, 454, 547, 547, 762, 657, 741, 804, 699, 792, 778, 788, 506, 807, 752, 807, 807, 218, 573, 573, 573, 573, 573, 751, 573, 460, 743, 521, 506, 506, 506, 693, 506, 506, 753, 547, 547, 547, 454, 693, 218, 218, 218, 502, 720, 680, 742, 804, 804, 766, 766, 517, 794, 794, 454, 709, 709, 523, 720, 690, 690, 678, 687, 687, 517, 527, 521, 521, 521, 663, 531, 709, 709, 709, 701, 788, 653, 585, 562, 726, 197, 197, 197, 197, 197, 197, 197, 704, 704, 562, 553, 661, 661, 661, 599, 599, 562, 599, 527, 701, 460, 596, 583, 807, 792, 789, 812, 812, 812, 807, 750, 707, 750, 730, 753, 301, 807, 631, 665, 502, 794, 731, 731, 583, 583, 506, 583, 583, 657, 657, 502, 348, 348, 301, 527, 527, 502, 753, 753, 737, 700, 10, 10, 502, 10, 10, 10, 10, 10, 10, 678, 678, 502, 678, 594, 731, 348, 806, 743, 741, 741, 594, 594, 707, 748, 762, 663, 663, 596, 596, 596, 596, 11, 11, 762, 11, 11, 11, 11, 11, 11, 594, 594, 762, 751, 747, 703, 747, 747, 746, 705, 705, 788, 788, 804, 693, 693, 693, 693, 720, 542, 804, 542, 542, 542, 690, 690, 810, 810, 441, 596, 741, 804, 804, 14, 14, 441, 14, 14, 14, 14, 802, 802, 709, 709, 657, 705, 704, 562, 562, 521, 790, 790, 425, 425, 425, 425, 749, 521, 517, 517, 517, 517, 517, 18, 18, 541, 18, 18, 19, 19, 766, 19, 19, 19, 20, 20, 744, 20, 20, 20, 20, 20, 23, 23, 511, 23, 23, 680, 23, 680, 511, 629, 672, 672, 25, 25, 583, 25, 25, 25, 25, 25, 803, 255, 803, 803, 27, 27, 255, 27, 27, 27, 27, 27, 27, 28, 28, 255, 28, 28, 28, 28, 28, 707, 706, 255, 706, 706, 706, 687, 687, 730, 687, 687, 802, 802, 802, 31, 31, 583, 31, 31, 31, 31, 31, 706, 706, 460, 706, 661, 661, 661, 661, 786, 786, 460, 786, 786, 786, 786, 653, 653, 460, 657, 629, 629, 680, 680, 84, 84, 704, 84, 84, 84, 84, 84, 730, 730, 704, 707, 707, 806, 629, 629, 680, 87, 87, 720, 87, 87, 87, 87, 87, 87, 811, 811, 562, 811, 811, 811, 700, 700, 596, 366, 425, 366, 366, 366, 366, 366, 790, 582, 751, 752, 751, 301, 265, 265, 265, 541, 724, 218, 724, 724, 724, 724, 803, 690, 737, 218, 737, 553, 757, 38, 38, 218, 38, 38, 218, 582, 720, 750, 301, 301, 301, 720, 757, 709, 678, 702, 730, 702, 352, 352, 553, 663, 631, 631, 730, 631, 631, 629, 629, 629, 582, 582, 547, 582, 460, 700, 700, 547, 316, 683, 165, 165, 316, 316, 316, 316, 547, 527, 678, 751, 697, 683, 697, 676, 737, 737, 748, 731, 748, 805, 748, 713, 553, 553, 553, 751, 810, 532, 348, 348, 713, 313, 313, 313, 313, 454, 523, 750, 752, 750, 752, 713, 789, 699, 699, 699, 585, 741, 741, 741, 532, 531, 531, 531, 762, 704, 676, 752, 657, 657, 657, 755, 72, 72, 748, 72, 72, 72, 72, 72, 72, 672, 672, 757, 672, 672, 672, 789, 789, 703, 703, 748, 702, 702, 702, 573, 755, 702, 702, 701, 757, 701, 701, 165, 810, 757, 265, 683, 683, 683, 683, 539, 517, 539, 750, 665, 665, 665, 707, 599, 707, 810, 778, 425, 805, 425, 425, 531, 531, 757, 535, 801, 801, 532, 532, 532, 676, 766, 766, 255, 539, 539, 751, 753, 806, 806, 806, 511, 511, 255, 348, 540, 540, 539, 539, 720, 454, 746, 746, 746, 746, 582, 741, 539, 812, 812, 766, 766, 755, 755, 806, 800, 800, 800, 743, 750, 810, 794, 511, 511, 366, 726, 726, 726, 726, 441, 553, 810, 706, 352, 352, 352, 352, 352, 731, 663, 535, 535, 535, 534, 534, 534, 746, 676, 676, 676, 676, 731, 778, 678, 599, 599, 744, 724, 724, 682, 682, 748, 748, 742, 800, 755, 755, 755, 752, 752, 676, 641, 641, 582, 541, 541, 540, 540, 812, 702, 553, 752, 678, 682, 682, 726, 726, 726, 663, 582, 585, 585, 585, 585, 585, 663, 697, 749, 665, 541, 541, 541, 690, 803, 803, 790, 665, 665, 746, 710, 710, 710, 710, 710, 710, 710, 710, 744, 704, 544, 544, 544, 544, 544, 527, 744, 744, 744, 744, 539, 713, 713, 713, 701, 742, 742, 742, 653, 653, 653, 654, 654, 654, 654, 654, 654, 654, 697, 697, 788, 788, 663, 703, 703, 683, 747, 747, 747, 747, 747, 809, 809, 809, 809, 809, 764, 764, 764, 764, 764, 764, 764, 764, 805, 805, 805, 805, 805, 805, 766, 792, 792, 780, 780, 780, 780, 780, 780, 780, 770, 770, 770, 770, 770, 770, 770, 778, 808, 808, 808, 808, 808, 808, 808, 808, 772, 772, 772, 772, 772, 772, 772, 772, 773, 773, 773, 773, 773, 773, 773, 773, 774, 774, 774, 774, 774, 774, 806, 791, 791, 791, 791, 791, 791, 791, 791, 779, 779, 779, 779, 779, 792, 792, 792, 789, 789, 782, 782, 782, 783, 783, 783, 783, 801, 801, 801, 801, 801, 801, 800, 785, 785, 785, 785, 785, 785, 788, 788, 793, 793, 793, 793, 793, 793, 793, 793, 796, 796, 796, 796, 797, 797, 797, 797, 797, 797, 797, 797, 814, 813, 813, 813, 813, 813, 813, 814, 814, 814, 814, 814, 814) AND NOT (`Cast`.`id` = 700) ORDER BY `Cast`.`number` asc | 116 | 116 | 3 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop4`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` IN (814, 10, 11, 721, 743, 746, 521, 752, 772, 751, 720, 791, 348, 774, 802, 783, 680, 786, 762, 780, 770, 726, 583, 794, 773, 653, 511, 599, 14, 547, 778, 425, 19, 631, 527, 665, 596, 748, 316, 682, 585, 313, 629, 683, 594, 523, 265, 573, 502, 20, 460, 301, 693, 18, 697, 741, 706, 737, 800, 799, 764, 789, 790, 806, 730, 701, 702, 757, 690, 704, 707, 699, 703, 705, 38, 813, 812, 809, 810, 797, 804, 805, 796, 803, 792, 793, 788, 782, 807, 811, 750, 663, 654, 352, 657, 562, 366, 255, 72, 31, 28, 25, 197, 23, 218, 87, 84, 531, 532, 539, 534, 535, 544, 540, 542, 541) ORDER BY `CastImage`.`number` asc | 496 | 496 | 2 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop4`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` IN (814, 10, 11, 721, 743, 746, 521, 752, 772, 751, 720, 791, 348, 774, 802, 783, 680, 786, 762, 780, 770, 726, 583, 794, 773, 653, 511, 599, 14, 547, 778, 425, 19, 631, 527, 665, 596, 748, 316, 682, 585, 313, 629, 683, 594, 523, 265, 573, 502, 20, 460, 301, 693, 18, 697, 741, 706, 737, 800, 799, 764, 789, 790, 806, 730, 701, 702, 757, 690, 704, 707, 699, 703, 705, 38, 813, 812, 809, 810, 797, 804, 805, 796, 803, 792, 793, 788, 782, 807, 811, 750, 663, 654, 352, 657, 562, 366, 255, 72, 31, 28, 25, 197, 23, 218, 87, 84, 531, 532, 539, 534, 535, 544, 540, 542, 541) | 796 | 796 | 1 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop4`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` IN (814, 10, 11, 721, 743, 746, 521, 752, 772, 751, 720, 791, 348, 774, 802, 783, 680, 786, 762, 780, 770, 726, 583, 794, 773, 653, 511, 599, 14, 547, 778, 425, 19, 631, 527, 665, 596, 748, 316, 682, 585, 313, 629, 683, 594, 523, 265, 573, 502, 20, 460, 301, 693, 18, 697, 741, 706, 737, 800, 799, 764, 789, 790, 806, 730, 701, 702, 757, 690, 704, 707, 699, 703, 705, 38, 813, 812, 809, 810, 797, 804, 805, 796, 803, 792, 793, 788, 782, 807, 811, 750, 663, 654, 352, 657, 562, 366, 255, 72, 31, 28, 25, 197, 23, 218, 87, 84, 531, 532, 539, 534, 535, 544, 540, 542, 541) | 0 | 0 | 0 | |
SELECT `TopBanner`.`id`, `TopBanner`.`display_flag`, `TopBanner`.`src`, `TopBanner`.`alt`, `TopBanner`.`link`, `TopBanner`.`number`, `TopBanner`.`modified` FROM `kir060294_testshop4`.`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_testshop4`.`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_testshop4`.`footer_banners` AS `FooterBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |