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 | 1 | maybe slow |
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` = 790 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-05-12 09:30:00' AND `Schedule`.`end` <= '2025-05-13 02:00:00') LEFT JOIN `kir060294_testshop3`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-05-12 09:30:00' AND `Reserve`.`end` <= '2025-05-13 02:00:00') WHERE `Cast`.`id` = 790 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` = (790) ORDER BY `CastImage`.`number` asc | 1 | 1 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (790) | 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` = (790) | 1 | 1 | 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` < 52 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` = (753) ORDER BY `CastImage`.`number` asc | 1 | 1 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (753) | 6 | 6 | 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` = (753) | 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` > 52 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` = (788) ORDER BY `CastImage`.`number` asc | 1 | 1 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (788) | 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` = (788) | 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` = 790 AND `Schedule`.`start` >= '2025-05-12 09:30:00' AND `Schedule`.`end` <= '2025-05-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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 790 AND `Schedule`.`start` >= '2025-05-13 09:30:00' AND `Schedule`.`end` <= '2025-05-14 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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 790 AND `Schedule`.`start` >= '2025-05-14 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-15 09:30:00' AND `Schedule`.`end` <= '2025-05-16 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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 790 AND `Schedule`.`start` >= '2025-05-16 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-17 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-18 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-19 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-20 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-21 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-22 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-23 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-24 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-25 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-26 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-27 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-28 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-29 09:30:00' AND `Schedule`.`end` <= '2025-05-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` = 790 AND `Schedule`.`start` >= '2025-05-30 09:30:00' AND `Schedule`.`end` <= '2025-05-31 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` = 790 AND `Schedule`.`start` >= '2025-05-31 09:30:00' AND `Schedule`.`end` <= '2025-06-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` = 790 AND `Schedule`.`start` >= '2025-06-01 09:30:00' AND `Schedule`.`end` <= '2025-06-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` = 790 AND `Schedule`.`start` >= '2025-06-02 09:30:00' AND `Schedule`.`end` <= '2025-06-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` = 790 AND `Schedule`.`start` >= '2025-06-03 09:30:00' AND `Schedule`.`end` <= '2025-06-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_testshop3`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 790 AND `Schedule`.`start` >= '2025-06-04 09:30:00' AND `Schedule`.`end` <= '2025-06-05 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` = 790 AND `Schedule`.`start` >= '2025-06-05 09:30:00' AND `Schedule`.`end` <= '2025-06-06 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` = 790 AND `Schedule`.`start` >= '2025-06-06 09:30:00' AND `Schedule`.`end` <= '2025-06-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` = 790 AND `Schedule`.`start` >= '2025-06-07 09:30:00' AND `Schedule`.`end` <= '2025-06-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` = 790 AND `Schedule`.`start` >= '2025-06-08 09:30:00' AND `Schedule`.`end` <= '2025-06-09 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` = 790 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` = (1) | 18 | 18 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id` FROM `kir060294_testshop3`.`has_options` AS `HasOption` WHERE `HasOption`.`option_id` IN (4, 12, 9, 7, 5, 2, 1) | 632 | 632 | 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 (704, 9, 291, 134, 793, 307, 481, 733, 66, 549, 619, 24, 341, 670, 784, 747, 651, 790, 670, 670, 670, 670, 530, 530, 753, 754, 572, 572, 801, 801, 759, 759, 570, 476, 5, 5, 5, 5, 619, 683, 759, 551, 551, 794, 672, 9, 9, 9, 9, 9, 9, 10, 10, 10, 10, 10, 11, 11, 11, 11, 530, 770, 770, 762, 451, 384, 384, 480, 332, 332, 332, 332, 332, 572, 581, 773, 759, 759, 606, 614, 614, 341, 459, 459, 782, 790, 787, 787, 787, 787, 787, 24, 24, 24, 26, 26, 26, 704, 704, 440, 29, 29, 29, 29, 29, 29, 559, 559, 606, 739, 555, 555, 555, 555, 555, 555, 619, 619, 619, 619, 786, 786, 759, 762, 770, 770, 581, 682, 291, 291, 291, 291, 310, 606, 40, 40, 40, 40, 735, 735, 735, 735, 651, 683, 790, 790, 711, 614, 296, 296, 296, 296, 748, 253, 253, 253, 253, 651, 737, 735, 735, 735, 682, 480, 480, 479, 476, 476, 476, 481, 481, 481, 459, 459, 739, 729, 704, 796, 796, 796, 532, 776, 788, 788, 796, 796, 774, 774, 426, 786, 711, 711, 737, 664, 572, 572, 572, 572, 701, 754, 753, 790, 790, 426, 778, 791, 592, 592, 763, 763, 791, 763, 763, 66, 66, 791, 66, 66, 66, 791, 243, 243, 785, 788, 782, 560, 592, 631, 782, 631, 631, 683, 711, 711, 786, 700, 73, 73, 782, 73, 73, 73, 73, 73, 220, 782, 220, 220, 770, 782, 739, 682, 704, 676, 550, 790, 721, 664, 676, 773, 773, 773, 773, 619, 619, 798, 700, 243, 243, 243, 700, 728, 790, 769, 672, 672, 672, 550, 549, 769, 789, 532, 532, 670, 670, 341, 341, 789, 341, 778, 736, 682, 676, 532, 532, 614, 614, 773, 700, 769, 789, 722, 722, 763, 693, 761, 704, 704, 507, 507, 507, 507, 792, 792, 307, 693, 307, 307, 693, 310, 693, 560, 762, 762, 762, 693, 778, 769, 769, 682, 693, 778, 549, 549, 549, 476, 476, 476, 651, 693, 479, 310, 481, 481, 551, 501, 721, 534, 651, 721, 550, 550, 481, 481, 253, 762, 793, 570, 721, 570, 570, 180, 180, 721, 180, 180, 791, 728, 727, 727, 560, 739, 664, 664, 664, 595, 534, 534, 727, 534, 534, 682, 737, 426, 426, 180, 728, 739, 739, 778, 113, 113, 727, 113, 784, 784, 784, 754, 784, 754, 621, 621, 761, 621, 761, 791, 791, 776, 559, 785, 761, 672, 788, 672, 801, 801, 652, 683, 683, 727, 501, 501, 501, 748, 747, 793, 788, 704, 761, 722, 722, 722, 686, 686, 788, 686, 686, 686, 670, 728, 786, 786, 737, 722, 722, 614, 761, 559, 748, 631, 631, 631, 786, 728, 614, 332, 787, 789, 426, 794, 794, 794, 559, 559, 683, 134, 134, 668, 134, 134, 134, 426, 459, 754, 801, 734, 291, 291, 479, 785, 778, 668, 794, 794, 728, 440, 668, 788, 592, 796, 796, 559, 801, 668, 652, 652, 668, 737, 737, 560, 668, 560, 729, 801, 451, 451, 776, 800, 800, 800, 800, 754, 754, 581, 581, 651, 651, 776, 507, 507, 747, 595, 595, 776, 595, 595, 776, 783, 792, 792, 747, 792, 794, 711, 792, 792, 798, 798, 784, 784, 631, 26, 26, 26, 683, 747, 747, 728, 501, 747, 501, 557, 557, 557, 747, 557, 557, 451, 451, 664, 769, 440, 440, 440, 793, 440, 700, 700, 700, 793, 773, 793, 307, 793, 778, 676, 729, 729, 727, 736, 736, 785, 776, 774, 774, 384, 384, 384, 384, 721, 721, 733, 734, 676, 560, 549, 549, 785, 785, 774, 783, 783, 733, 733, 733, 551, 480, 774, 651, 581, 753, 581, 581, 621, 793, 676, 606, 606, 606, 787, 784, 753, 592, 592, 753, 701, 701, 752, 701, 701, 701, 701, 752, 737, 736, 736, 752, 736, 736, 798, 798, 752, 798, 798, 783, 783, 752, 783, 782, 752) AND NOT (`Cast`.`id` = 790) ORDER BY `Cast`.`number` asc | 107 | 107 | 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, 774, 787, 672, 180, 778, 10, 614, 581, 682, 721, 534, 668, 762, 451, 341, 11, 754, 736, 307, 789, 773, 763, 776, 700, 701, 739, 686, 507, 291, 606, 729, 759, 595, 670, 711, 621, 676, 570, 310, 29, 559, 800, 722, 753, 788, 796, 793, 785, 784, 798, 761, 748, 737, 794, 801, 782, 747, 24, 9, 26, 40, 733, 704, 735, 66, 549, 592, 253, 134, 791, 783, 501, 786, 752, 727, 73, 770, 631, 426, 440, 693, 481, 384, 459, 555, 551, 557, 476, 550, 479, 480, 332, 734, 220, 652, 530, 113, 5, 769) ORDER BY `CastImage`.`number` asc | 373 | 373 | 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, 774, 787, 672, 180, 778, 10, 614, 581, 682, 721, 534, 668, 762, 451, 341, 11, 754, 736, 307, 789, 773, 763, 776, 700, 701, 739, 686, 507, 291, 606, 729, 759, 595, 670, 711, 621, 676, 570, 310, 29, 559, 800, 722, 753, 788, 796, 793, 785, 784, 798, 761, 748, 737, 794, 801, 782, 747, 24, 9, 26, 40, 733, 704, 735, 66, 549, 592, 253, 134, 791, 783, 501, 786, 752, 727, 73, 770, 631, 426, 440, 693, 481, 384, 459, 555, 551, 557, 476, 550, 479, 480, 332, 734, 220, 652, 530, 113, 5, 769) | 684 | 684 | 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, 774, 787, 672, 180, 778, 10, 614, 581, 682, 721, 534, 668, 762, 451, 341, 11, 754, 736, 307, 789, 773, 763, 776, 700, 701, 739, 686, 507, 291, 606, 729, 759, 595, 670, 711, 621, 676, 570, 310, 29, 559, 800, 722, 753, 788, 796, 793, 785, 784, 798, 761, 748, 737, 794, 801, 782, 747, 24, 9, 26, 40, 733, 704, 735, 66, 549, 592, 253, 134, 791, 783, 501, 786, 752, 727, 73, 770, 631, 426, 440, 693, 481, 384, 459, 555, 551, 557, 476, 550, 479, 480, 332, 734, 220, 652, 530, 113, 5, 769) | 62 | 62 | 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 | |