Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop3`.`settings` AS `Setting` WHERE 1 = 1 | 31 | 31 | 1 | |
SHOW TABLE STATUS | 33 | 33 | 4 | maybe slow |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop3`.`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_testshop3`.`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_testshop3`.`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_testshop3`.`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_testshop3`.`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_testshop3`.`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_testshop3`.`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_testshop3`.`prices` AS `Price` WHERE `parent_id` = 45 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Ranking`.`id`, `Ranking`.`display_flag`, `Ranking`.`title`, `Ranking`.`number`, `Ranking`.`created`, `Ranking`.`modified` FROM `kir060294_testshop3`.`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_testshop3`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop3`.`options` AS `Option` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop3`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 6 | 6 | 0 | |
SELECT `Type`.`id`, `Type`.`background_color` FROM `kir060294_testshop3`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 6 | 6 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_testshop3`.`casts` AS `Cast` WHERE `Cast`.`id` = 686 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`.`dummy_flag`, `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_testshop3`.`casts` AS `Cast` LEFT JOIN `kir060294_testshop3`.`schedules` AS `Schedule` ON (`Schedule`.`cast_id` = `Cast`.`id` AND `Schedule`.`start` >= '2025-04-06 09:30:00' AND `Schedule`.`end` <= '2025-04-07 02:00:00') LEFT JOIN `kir060294_testshop3`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-04-06 09:30:00' AND `Reserve`.`end` <= '2025-04-07 02:00:00') WHERE `Cast`.`id` = 686 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop3`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (686) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (686) | 5 | 5 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop3`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (686) | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop3`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop3`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `Type`.`number` asc | 6 | 6 | 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`.`dummy_flag`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified` FROM `kir060294_testshop3`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` < 32 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_testshop3`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (739) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (739) | 8 | 8 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop3`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (739) | 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`.`dummy_flag`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified` FROM `kir060294_testshop3`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` > 32 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_testshop3`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (507) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (507) | 7 | 7 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop3`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (507) | 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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-06 09:30:00' AND `Schedule`.`end` <= '2025-04-07 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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-07 09:30:00' AND `Schedule`.`end` <= '2025-04-08 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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-08 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-09 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-10 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-11 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-12 09:30:00' AND `Schedule`.`end` <= '2025-04-13 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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-13 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-14 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-15 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-16 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-17 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-18 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-19 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-20 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-21 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-22 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-23 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-24 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-25 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-26 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-27 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-28 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-29 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-04-30 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-05-01 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-05-02 09:30: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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 686 AND `Schedule`.`start` >= '2025-05-03 09:30:00' AND `Schedule`.`end` <= '2025-05-04 02:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Gravure`.`id`, `Gravure`.`cast_id`, `Gravure`.`display_flag`, `Gravure`.`number`, `Gravure`.`file_name`, `Gravure`.`created`, `Gravure`.`modified` FROM `kir060294_testshop3`.`gravures` AS `Gravure` WHERE `cast_id` = 686 AND `display_flag` = '1' ORDER BY `number` asc LIMIT 5 | 0 | 0 | 0 | |
SELECT `HasType`.`id`, `HasType`.`cast_id` FROM `kir060294_testshop3`.`has_types` AS `HasType` WHERE `HasType`.`type_id` IS NULL | 0 | 0 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`option_id` IN (12, 5, 4, 2, 1) | 518 | 518 | 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`.`dummy_flag`, `Cast`.`number`, `Cast`.`created`, `Cast`.`modified` FROM `kir060294_testshop3`.`casts` AS `Cast` WHERE `Cast`.`display_flag` = '1' AND `Cast`.`id` IN (670, 670, 530, 530, 753, 754, 572, 572, 601, 601, 759, 759, 768, 570, 476, 5, 5, 5, 5, 683, 759, 551, 551, 672, 9, 9, 9, 9, 10, 10, 10, 10, 11, 11, 11, 11, 530, 770, 770, 762, 451, 384, 384, 480, 332, 332, 332, 332, 572, 773, 759, 717, 606, 614, 702, 341, 459, 782, 741, 741, 741, 741, 24, 24, 24, 740, 26, 26, 26, 758, 758, 758, 440, 29, 29, 29, 29, 559, 559, 606, 739, 768, 768, 768, 555, 555, 555, 555, 555, 619, 619, 619, 619, 766, 780, 759, 770, 770, 581, 291, 291, 291, 291, 310, 606, 779, 40, 40, 40, 40, 735, 735, 735, 735, 717, 711, 596, 596, 296, 296, 296, 296, 748, 253, 253, 253, 253, 651, 737, 735, 682, 480, 480, 479, 476, 476, 476, 481, 481, 481, 459, 459, 739, 779, 780, 780, 729, 704, 591, 532, 776, 688, 688, 591, 591, 591, 774, 774, 426, 711, 572, 572, 701, 754, 753, 426, 778, 758, 592, 763, 763, 763, 66, 66, 66, 66, 243, 243, 688, 688, 782, 592, 631, 631, 631, 702, 711, 711, 700, 73, 73, 73, 73, 73, 220, 782, 220, 220, 770, 782, 739, 682, 704, 676, 550, 721, 664, 676, 773, 717, 773, 619, 243, 243, 728, 672, 672, 550, 769, 743, 532, 532, 670, 670, 341, 341, 743, 341, 682, 676, 532, 614, 614, 773, 700, 769, 85, 85, 743, 85, 85, 722, 722, 763, 693, 761, 704, 704, 507, 507, 307, 307, 307, 758, 310, 14, 14, 693, 14, 14, 560, 762, 762, 762, 693, 769, 769, 693, 778, 549, 549, 476, 693, 479, 310, 481, 551, 501, 721, 596, 651, 550, 550, 481, 762, 703, 570, 570, 570, 180, 180, 721, 180, 180, 727, 560, 664, 664, 664, 534, 534, 727, 534, 534, 682, 717, 739, 739, 778, 113, 113, 727, 113, 754, 621, 621, 621, 761, 559, 764, 761, 740, 740, 672, 688, 672, 156, 156, 596, 652, 683, 683, 727, 501, 501, 779, 779, 748, 747, 704, 761, 722, 686, 686, 686, 686, 686, 670, 728, 737, 766, 722, 722, 766, 614, 761, 559, 748, 631, 728, 614, 332, 741, 717, 766, 743, 426, 766, 559, 683, 134, 134, 134, 134, 426, 459, 734, 291, 479, 778, 728, 668, 601, 743, 592, 591, 601, 668, 652, 652, 668, 737, 737, 560, 668, 560, 729, 781, 601, 781, 451, 156, 156, 754, 754, 581, 651, 651, 776, 507, 507, 595, 595, 776, 595, 595, 776, 711, 631, 26, 26, 683, 747, 747, 728, 501, 747, 501, 557, 557, 557, 747, 557, 557, 596, 451, 451, 664, 440, 440, 703, 440, 700, 700, 700, 703, 781, 781, 780, 773, 703, 307, 703, 778, 702, 729, 729, 727, 736, 764, 776, 774, 384, 384, 721, 721, 733, 734, 676, 780, 740, 740, 549, 549, 764, 764, 774, 733, 733, 733, 551, 480, 774, 651, 581, 753, 581, 581, 621, 702, 702, 676, 606, 753, 592, 592, 753, 752, 701, 701, 701, 701, 737, 736, 736, 752, 736, 736, 545, 545, 752, 545, 545, 752, 782, 781, 779, 752) AND NOT (`Cast`.`id` = 686) ORDER BY `Cast`.`number` asc | 112 | 112 | 3 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop3`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` IN (651, 296, 664, 532, 243, 560, 572, 683, 332, 729, 672, 180, 534, 10, 614, 581, 682, 721, 668, 762, 451, 11, 754, 736, 307, 773, 763, 341, 776, 700, 701, 739, 507, 291, 606, 764, 759, 596, 595, 670, 711, 621, 676, 570, 310, 29, 559, 722, 753, 768, 761, 774, 766, 688, 748, 740, 737, 781, 780, 782, 747, 601, 741, 24, 9, 26, 40, 733, 704, 703, 735, 717, 66, 156, 545, 549, 592, 591, 253, 14, 134, 85, 501, 752, 727, 73, 770, 758, 631, 426, 440, 693, 481, 384, 459, 555, 551, 557, 476, 550, 479, 480, 734, 779, 778, 220, 652, 530, 702, 113, 5, 769) ORDER BY `CastImage`.`number` asc | 388 | 388 | 2 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` IN (651, 296, 664, 532, 243, 560, 572, 683, 332, 729, 672, 180, 534, 10, 614, 581, 682, 721, 668, 762, 451, 11, 754, 736, 307, 773, 763, 341, 776, 700, 701, 739, 507, 291, 606, 764, 759, 596, 595, 670, 711, 621, 676, 570, 310, 29, 559, 722, 753, 768, 761, 774, 766, 688, 748, 740, 737, 781, 780, 782, 747, 601, 741, 24, 9, 26, 40, 733, 704, 703, 735, 717, 66, 156, 545, 549, 592, 591, 253, 14, 134, 85, 501, 752, 727, 73, 770, 758, 631, 426, 440, 693, 481, 384, 459, 555, 551, 557, 476, 550, 479, 480, 734, 779, 778, 220, 652, 530, 702, 113, 5, 769) | 723 | 723 | 1 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop3`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` IN (651, 296, 664, 532, 243, 560, 572, 683, 332, 729, 672, 180, 534, 10, 614, 581, 682, 721, 668, 762, 451, 11, 754, 736, 307, 773, 763, 341, 776, 700, 701, 739, 507, 291, 606, 764, 759, 596, 595, 670, 711, 621, 676, 570, 310, 29, 559, 722, 753, 768, 761, 774, 766, 688, 748, 740, 737, 781, 780, 782, 747, 601, 741, 24, 9, 26, 40, 733, 704, 703, 735, 717, 66, 156, 545, 549, 592, 591, 253, 14, 134, 85, 501, 752, 727, 73, 770, 758, 631, 426, 440, 693, 481, 384, 459, 555, 551, 557, 476, 550, 479, 480, 734, 779, 778, 220, 652, 530, 702, 113, 5, 769) | 61 | 61 | 0 | |
SELECT `TopBanner`.`id`, `TopBanner`.`display_flag`, `TopBanner`.`src`, `TopBanner`.`alt`, `TopBanner`.`link`, `TopBanner`.`number`, `TopBanner`.`modified` FROM `kir060294_testshop3`.`top_banners` AS `TopBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 3 | 3 | 0 | |
SELECT `PhoneBanner`.`id`, `PhoneBanner`.`display_flag`, `PhoneBanner`.`image_kind`, `PhoneBanner`.`img`, `PhoneBanner`.`alt`, `PhoneBanner`.`link`, `PhoneBanner`.`blank`, `PhoneBanner`.`created`, `PhoneBanner`.`modified` FROM `kir060294_testshop3`.`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_testshop3`.`footer_banners` AS `FooterBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |