Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop7`.`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_testshop7`.`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_testshop7`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc | 11 | 11 | 1 | maybe slow |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop7`.`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_testshop7`.`prices` AS `Price` WHERE `parent_id` = 2 AND `display_flag` = '1' ORDER BY `number` asc | 10 | 10 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop7`.`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_testshop7`.`prices` AS `Price` WHERE `parent_id` = 3 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop7`.`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_testshop7`.`prices` AS `Price` WHERE `parent_id` = 29 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_testshop7`.`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_testshop7`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop7`.`options` AS `Option` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop7`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 20 | 20 | 0 | |
SELECT `Type`.`id`, `Type`.`background_color` FROM `kir060294_testshop7`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 20 | 20 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_testshop7`.`casts` AS `Cast` WHERE `Cast`.`id` = 381 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_testshop7`.`casts` AS `Cast` LEFT JOIN `kir060294_testshop7`.`schedules` AS `Schedule` ON (`Schedule`.`cast_id` = `Cast`.`id` AND `Schedule`.`start` >= '2025-04-09 09:00:00' AND `Schedule`.`end` <= '2025-04-10 05:00:00') LEFT JOIN `kir060294_testshop7`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-04-09 09:00:00' AND `Reserve`.`end` <= '2025-04-10 05:00:00') WHERE `Cast`.`id` = 381 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop7`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (381) ORDER BY `CastImage`.`number` asc | 2 | 2 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop7`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (381) | 8 | 8 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop7`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (381) | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop7`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop7`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `Type`.`number` asc | 20 | 20 | 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_testshop7`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` < 44 ORDER BY `number` desc LIMIT 1 | 1 | 1 | 0 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop7`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (384) ORDER BY `CastImage`.`number` asc | 1 | 1 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop7`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (384) | 2 | 2 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop7`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (384) | 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_testshop7`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` > 44 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_testshop7`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (375) ORDER BY `CastImage`.`number` asc | 2 | 2 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop7`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (375) | 8 | 8 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop7`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (375) | 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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-09 09:00:00' AND `Schedule`.`end` <= '2025-04-10 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-10 09:00:00' AND `Schedule`.`end` <= '2025-04-11 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-11 09:00:00' AND `Schedule`.`end` <= '2025-04-12 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-12 09:00:00' AND `Schedule`.`end` <= '2025-04-13 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-13 09:00:00' AND `Schedule`.`end` <= '2025-04-14 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-14 09:00:00' AND `Schedule`.`end` <= '2025-04-15 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-15 09:00:00' AND `Schedule`.`end` <= '2025-04-16 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-16 09:00:00' AND `Schedule`.`end` <= '2025-04-17 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-17 09:00:00' AND `Schedule`.`end` <= '2025-04-18 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-18 09:00:00' AND `Schedule`.`end` <= '2025-04-19 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-19 09:00:00' AND `Schedule`.`end` <= '2025-04-20 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-20 09:00:00' AND `Schedule`.`end` <= '2025-04-21 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-21 09:00:00' AND `Schedule`.`end` <= '2025-04-22 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-22 09:00:00' AND `Schedule`.`end` <= '2025-04-23 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-23 09:00:00' AND `Schedule`.`end` <= '2025-04-24 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-24 09:00:00' AND `Schedule`.`end` <= '2025-04-25 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-25 09:00:00' AND `Schedule`.`end` <= '2025-04-26 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-26 09:00:00' AND `Schedule`.`end` <= '2025-04-27 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-27 09:00:00' AND `Schedule`.`end` <= '2025-04-28 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-28 09:00:00' AND `Schedule`.`end` <= '2025-04-29 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-29 09:00:00' AND `Schedule`.`end` <= '2025-04-30 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-04-30 09:00:00' AND `Schedule`.`end` <= '2025-05-01 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-05-01 09:00:00' AND `Schedule`.`end` <= '2025-05-02 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-05-02 09:00:00' AND `Schedule`.`end` <= '2025-05-03 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-05-03 09:00:00' AND `Schedule`.`end` <= '2025-05-04 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-05-04 09:00:00' AND `Schedule`.`end` <= '2025-05-05 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-05-05 09:00:00' AND `Schedule`.`end` <= '2025-05-06 05: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_testshop7`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 381 AND `Schedule`.`start` >= '2025-05-06 09:00:00' AND `Schedule`.`end` <= '2025-05-07 05:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `HasType`.`id`, `HasType`.`cast_id` FROM `kir060294_testshop7`.`has_types` AS `HasType` WHERE `HasType`.`type_id` IS NULL | 0 | 0 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id` FROM `kir060294_testshop7`.`has_options` AS `HasOption` WHERE `HasOption`.`option_id` IN (11, 12, 9, 6, 5, 4, 2, 16) | 432 | 432 | 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_testshop7`.`casts` AS `Cast` WHERE `Cast`.`display_flag` = '1' AND `Cast`.`id` IN (387, 118, 390, 387, 359, 359, 118, 319, 316, 316, 316, 316, 170, 170, 248, 338, 376, 376, 376, 376, 376, 375, 77, 338, 338, 335, 77, 77, 77, 77, 7, 7, 7, 370, 359, 335, 377, 335, 335, 302, 361, 369, 170, 359, 261, 10, 10, 10, 10, 10, 10, 11, 11, 11, 11, 11, 11, 11, 12, 12, 12, 12, 12, 12, 119, 119, 119, 119, 119, 360, 316, 377, 377, 202, 202, 339, 381, 381, 381, 302, 341, 370, 170, 170, 335, 335, 368, 368, 368, 368, 142, 142, 142, 142, 142, 142, 369, 341, 341, 341, 341, 341, 341, 304, 361, 361, 361, 361, 361, 361, 22, 22, 22, 22, 23, 23, 23, 23, 23, 23, 77, 377, 71, 25, 25, 25, 25, 25, 25, 26, 26, 26, 26, 26, 26, 27, 27, 27, 27, 27, 28, 28, 28, 28, 28, 28, 181, 202, 202, 304, 339, 339, 119, 254, 387, 339, 306, 175, 118, 175, 77, 7, 359, 62, 62, 62, 62, 297, 377, 330, 297, 297, 181, 363, 297, 357, 357, 357, 357, 175, 175, 381, 381, 71, 357, 357, 316, 304, 304, 62, 62, 370, 370, 370, 370, 370, 304, 62, 297, 383, 325, 381, 381, 381, 377, 377, 175, 175, 71, 71, 304, 339, 325, 325, 306, 306, 390, 390, 363, 330, 339, 339, 143, 143, 333, 333, 333, 264, 249, 363, 363, 333, 261, 261, 261, 261, 202, 202, 363, 367, 367, 330, 165, 165, 165, 181, 181, 181, 181, 330, 330, 387, 165, 165, 102, 102, 102, 102, 144, 144, 330, 144, 144, 144, 144, 119, 118, 118, 118, 118, 175, 377, 170, 170, 376, 258, 286, 286, 286, 286, 286, 286, 306, 384, 368, 143, 143, 143, 358, 360, 360, 360, 360, 383, 383, 383, 367, 358, 358, 390, 390, 390, 367, 368, 384, 386, 386, 386, 386, 386, 387, 387, 387, 261, 358, 358, 223, 223, 189, 189, 189, 189, 189, 189, 188, 188, 188, 188, 188, 188, 367, 286, 338, 258, 258, 325, 306, 383, 382, 195, 195, 195, 195, 195, 195, 330, 248, 248, 333, 264, 264, 264, 264, 264, 264, 333, 142, 379, 379, 319, 319, 319, 379, 359, 359, 254, 254, 254, 254, 254, 367, 367, 360, 325, 325, 319, 390, 310, 310, 310, 310, 310, 355, 376, 379, 258, 258, 310, 310, 248, 369, 369, 369, 369, 249, 249, 249, 249, 249, 249, 302, 302, 302, 302, 278, 278, 278, 278, 278, 278, 278, 369, 346, 346, 346, 346, 346, 346, 346, 375, 375, 375, 375, 375, 375, 355, 355, 355, 355, 355, 358, 358) AND NOT (`Cast`.`id` = 381) ORDER BY `Cast`.`number` asc | 66 | 66 | 2 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop7`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` IN (102, 254, 7, 278, 286, 390, 383, 319, 346, 358, 195, 376, 369, 189, 316, 330, 261, 175, 248, 360, 181, 249, 165, 338, 357, 325, 339, 310, 297, 264, 202, 188, 223, 62, 71, 142, 170, 11, 258, 387, 386, 382, 384, 375, 368, 363, 359, 361, 355, 341, 144, 143, 119, 25, 23, 22, 26, 10, 118, 27, 28, 12, 377, 335, 333, 77) ORDER BY `CastImage`.`number` asc | 257 | 257 | 2 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop7`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` IN (102, 254, 7, 278, 286, 390, 383, 319, 346, 358, 195, 376, 369, 189, 316, 330, 261, 175, 248, 360, 181, 249, 165, 338, 357, 325, 339, 310, 297, 264, 202, 188, 223, 62, 71, 142, 170, 11, 258, 387, 386, 382, 384, 375, 368, 363, 359, 361, 355, 341, 144, 143, 119, 25, 23, 22, 26, 10, 118, 27, 28, 12, 377, 335, 333, 77) | 432 | 432 | 1 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop7`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` IN (102, 254, 7, 278, 286, 390, 383, 319, 346, 358, 195, 376, 369, 189, 316, 330, 261, 175, 248, 360, 181, 249, 165, 338, 357, 325, 339, 310, 297, 264, 202, 188, 223, 62, 71, 142, 170, 11, 258, 387, 386, 382, 384, 375, 368, 363, 359, 361, 355, 341, 144, 143, 119, 25, 23, 22, 26, 10, 118, 27, 28, 12, 377, 335, 333, 77) | 0 | 0 | 0 | |
SELECT `TopBanner`.`id`, `TopBanner`.`display_flag`, `TopBanner`.`src`, `TopBanner`.`alt`, `TopBanner`.`link`, `TopBanner`.`number`, `TopBanner`.`modified` FROM `kir060294_testshop7`.`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_testshop7`.`phone_banners` AS `PhoneBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 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_testshop7`.`footer_banners` AS `FooterBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |