Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop2`.`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_testshop2`.`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_testshop2`.`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_testshop2`.`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_testshop2`.`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_testshop2`.`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_testshop2`.`prices` AS `Price` WHERE `parent_id` = 44 AND `display_flag` = '1' ORDER BY `number` asc | 2 | 2 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop2`.`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_testshop2`.`prices` AS `Price` WHERE `parent_id` = 46 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_testshop2`.`rankings` AS `Ranking` WHERE `display_flag` = '1' ORDER BY `number` asc LIMIT 1 | 1 | 1 | 0 | |
SELECT `Ranker`.`cast_id`, `Ranker`.`rank`, `Ranker`.`ranking_id` FROM `kir060294_testshop2`.`rankers` AS `Ranker` WHERE `Ranker`.`ranking_id` = (33) ORDER BY `Ranker`.`rank` asc | 10 | 10 | 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_testshop2`.`footer_vendor_banners` AS `FooterVendorBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop2`.`options` AS `Option` WHERE 1 = 1 | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop2`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 7 | 7 | 0 | |
SELECT `Type`.`id`, `Type`.`background_color` FROM `kir060294_testshop2`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `number` asc | 7 | 7 | 0 | |
SELECT COUNT(*) AS `count` FROM `kir060294_testshop2`.`casts` AS `Cast` WHERE `Cast`.`id` = 90 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`.`undecided`, `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_testshop2`.`casts` AS `Cast` LEFT JOIN `kir060294_testshop2`.`schedules` AS `Schedule` ON (`Schedule`.`cast_id` = `Cast`.`id` AND `Schedule`.`start` >= '2025-04-06 09:00:00' AND `Schedule`.`end` <= '2025-04-07 02:00:00') LEFT JOIN `kir060294_testshop2`.`reserves` AS `Reserve` ON (`Reserve`.`cast_id` = `Cast`.`id` AND `Reserve`.`start` >= '2025-04-06 09:00:00' AND `Reserve`.`end` <= '2025-04-07 02:00:00') WHERE `Cast`.`id` = 90 LIMIT 1 | 1 | 1 | 1 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop2`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (90) ORDER BY `CastImage`.`number` asc | 10 | 10 | 1 | maybe slow |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop2`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (90) | 7 | 7 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop2`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (90) | 1 | 1 | 0 | |
SELECT `Option`.`id`, `Option`.`name` FROM `kir060294_testshop2`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
SELECT `Type`.`id`, `Type`.`name` FROM `kir060294_testshop2`.`types` AS `Type` WHERE `Type`.`display_flag` = '1' ORDER BY `Type`.`number` asc | 7 | 7 | 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_testshop2`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` < 30 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_testshop2`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (32) ORDER BY `CastImage`.`number` asc | 10 | 10 | 1 | maybe slow |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop2`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (32) | 6 | 6 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop2`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (32) | 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` FROM `kir060294_testshop2`.`casts` AS `Cast` WHERE `display_flag` = '1' AND `number` > 30 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_testshop2`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` = (421) ORDER BY `CastImage`.`number` asc | 5 | 5 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop2`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` = (421) | 7 | 7 | 0 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop2`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` = (421) | 0 | 0 | 0 | |
SELECT `Schedule`.`id`, `Schedule`.`cast_id`, `Schedule`.`start`, `Schedule`.`end`, `Schedule`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-06 09:00: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-07 09:00: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-08 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-09 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-10 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-11 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-12 09:00: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-13 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-14 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-15 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-16 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-17 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-18 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-19 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-20 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-21 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-22 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-23 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-24 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-25 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-26 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-27 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-28 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-29 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-04-30 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-05-01 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-05-02 09: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`.`undecided`, `Schedule`.`absence`, `Schedule`.`sold_out`, `Schedule`.`status`, `Schedule`.`created`, `Schedule`.`modified` FROM `kir060294_testshop2`.`schedules` AS `Schedule` WHERE `Schedule`.`cast_id` = 90 AND `Schedule`.`start` >= '2025-05-03 09:00:00' AND `Schedule`.`end` <= '2025-05-04 02:00:00' LIMIT 1 | 0 | 0 | 0 | |
SELECT `HasType`.`id`, `HasType`.`cast_id` FROM `kir060294_testshop2`.`has_types` AS `HasType` WHERE `HasType`.`type_id` = (51) | 20 | 20 | 0 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id` FROM `kir060294_testshop2`.`has_options` AS `HasOption` WHERE `HasOption`.`option_id` IN (1, 4, 5, 6, 9, 10, 2) | 610 | 610 | 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_testshop2`.`casts` AS `Cast` WHERE `Cast`.`display_flag` = '1' AND `Cast`.`id` IN (375, 223, 38, 90, 438, 262, 40, 128, 279, 28, 226, 31, 37, 32, 62, 348, 41, 433, 85, 245, 1, 1, 1, 444, 1, 18, 444, 444, 9, 11, 476, 13, 444, 14, 18, 19, 19, 19, 20, 20, 21, 390, 390, 390, 390, 389, 443, 389, 389, 25, 25, 25, 25, 25, 316, 26, 26, 443, 26, 26, 476, 28, 28, 443, 28, 28, 28, 476, 29, 29, 443, 29, 29, 29, 30, 30, 443, 30, 30, 30, 476, 31, 31, 443, 31, 31, 31, 476, 31, 31, 32, 32, 32, 32, 479, 476, 32, 383, 269, 456, 479, 456, 456, 226, 255, 255, 254, 362, 148, 148, 148, 37, 37, 442, 37, 37, 37, 479, 38, 38, 38, 38, 38, 474, 38, 40, 40, 442, 40, 40, 474, 40, 41, 41, 442, 41, 41, 474, 42, 42, 442, 42, 42, 256, 256, 442, 256, 256, 44, 44, 442, 44, 44, 44, 474, 44, 481, 481, 481, 187, 187, 187, 441, 187, 187, 481, 437, 473, 362, 362, 362, 437, 462, 462, 462, 381, 381, 381, 381, 348, 383, 383, 379, 375, 461, 375, 375, 337, 337, 359, 437, 462, 437, 381, 247, 247, 456, 437, 456, 374, 374, 374, 437, 441, 428, 381, 401, 376, 58, 58, 58, 58, 477, 477, 406, 375, 436, 375, 375, 374, 461, 429, 468, 481, 481, 461, 339, 339, 187, 461, 62, 62, 436, 62, 62, 62, 461, 374, 380, 380, 339, 409, 270, 270, 269, 461, 269, 436, 462, 317, 470, 316, 179, 179, 436, 179, 228, 228, 436, 179, 470, 179, 358, 358, 250, 470, 470, 479, 470, 340, 340, 383, 383, 262, 428, 436, 428, 428, 470, 339, 364, 477, 477, 469, 162, 162, 456, 469, 439, 480, 480, 480, 260, 260, 379, 260, 260, 316, 316, 316, 478, 148, 148, 228, 228, 128, 128, 128, 409, 455, 406, 85, 85, 85, 85, 223, 223, 434, 223, 223, 459, 459, 434, 410, 410, 409, 455, 409, 89, 89, 434, 89, 89, 89, 455, 89, 90, 90, 90, 90, 455, 90, 90, 427, 427, 260, 455, 260, 220, 374, 379, 434, 434, 340, 401, 340, 406, 434, 406, 406, 330, 330, 330, 330, 337, 337, 256, 90, 433, 242, 449, 242, 242, 242, 255, 255, 255, 433, 427, 433, 348, 446, 348, 450, 433, 254, 254, 179, 480, 480, 439, 468, 162, 433, 162, 162, 250, 250, 220, 220, 433, 348, 348, 269, 269, 429, 380, 380, 250, 468, 471, 421, 245, 245, 262, 421, 262, 471, 471, 471, 421, 427, 421, 427, 427, 410, 421, 242, 242, 471, 439, 358, 358, 480, 478, 426, 478, 477, 477, 362, 450, 439, 450, 450, 408, 439, 408, 408, 444, 446, 446, 446, 479, 479, 439, 478, 449, 245, 449, 410, 410, 410, 235, 235, 235, 429, 235, 235, 429, 250, 250, 450, 450, 449, 247, 247, 316, 456, 429, 449, 317, 317, 317, 429, 317, 317, 324, 324, 324, 426, 426, 226, 428, 226, 226, 478, 472, 473, 473, 473, 473, 473, 428, 270, 270, 270, 312, 448, 312, 312, 312, 416, 312, 459, 416, 458, 458, 458, 448, 458, 339, 441, 448, 482, 482, 416, 482, 482, 279, 279, 416, 279, 279, 279, 448, 279, 279, 376, 376, 376, 416, 376, 376, 312, 284, 284, 416, 284, 284, 284, 460, 284, 402, 402, 402, 402, 402, 337, 430, 430, 430, 430, 474, 409, 409, 408, 460, 408, 408, 289, 289, 289, 289, 289, 460, 289, 324, 364, 364, 364, 364, 337, 460, 298, 460, 298, 298, 298, 463, 298, 298, 463, 438, 438, 438, 383, 383, 460, 468, 463, 468, 468, 459, 459, 459, 415, 441, 441, 441, 441, 415, 474, 305, 305, 415, 305, 305, 359, 415, 359, 415, 379, 415, 379, 379, 401, 401, 426, 401, 401) AND NOT (`Cast`.`id` = 90) ORDER BY `Cast`.`number` asc | 103 | 103 | 3 | |
SELECT `CastImage`.`id`, `CastImage`.`cast_id`, `CastImage`.`display_flag`, `CastImage`.`file_name`, `CastImage`.`number` FROM `kir060294_testshop2`.`cast_images` AS `CastImage` WHERE `CastImage`.`display_flag` = '1' AND `CastImage`.`cast_id` IN (348, 433, 279, 28, 37, 223, 362, 284, 316, 324, 450, 427, 256, 426, 436, 402, 473, 474, 441, 429, 460, 38, 29, 434, 401, 364, 128, 390, 179, 32, 421, 430, 458, 289, 359, 41, 148, 42, 30, 408, 409, 410, 25, 26, 337, 187, 31, 312, 89, 228, 85, 226, 40, 44, 478, 62, 416, 443, 459, 374, 482, 470, 461, 442, 444, 476, 220, 439, 463, 415, 255, 449, 247, 389, 379, 472, 438, 455, 339, 330, 383, 462, 477, 481, 479, 471, 446, 437, 469, 428, 468, 375, 381, 317, 456, 270, 480, 245, 162, 254, 269, 305, 380) ORDER BY `CastImage`.`number` asc | 453 | 453 | 3 | |
SELECT `HasOption`.`id`, `HasOption`.`cast_id`, `HasOption`.`option_id`, `HasOption`.`created` FROM `kir060294_testshop2`.`has_options` AS `HasOption` WHERE `HasOption`.`cast_id` IN (348, 433, 279, 28, 37, 223, 362, 284, 316, 324, 450, 427, 256, 426, 436, 402, 473, 474, 441, 429, 460, 38, 29, 434, 401, 364, 128, 390, 179, 32, 421, 430, 458, 289, 359, 41, 148, 42, 30, 408, 409, 410, 25, 26, 337, 187, 31, 312, 89, 228, 85, 226, 40, 44, 478, 62, 416, 443, 459, 374, 482, 470, 461, 442, 444, 476, 220, 439, 463, 415, 255, 449, 247, 389, 379, 472, 438, 455, 339, 330, 383, 462, 477, 481, 479, 471, 446, 437, 469, 428, 468, 375, 381, 317, 456, 270, 480, 245, 162, 254, 269, 305, 380) | 628 | 628 | 1 | |
SELECT `HasType`.`id`, `HasType`.`type_id`, `HasType`.`cast_id`, `HasType`.`created`, `HasType`.`modified` FROM `kir060294_testshop2`.`has_types` AS `HasType` WHERE `HasType`.`cast_id` IN (348, 433, 279, 28, 37, 223, 362, 284, 316, 324, 450, 427, 256, 426, 436, 402, 473, 474, 441, 429, 460, 38, 29, 434, 401, 364, 128, 390, 179, 32, 421, 430, 458, 289, 359, 41, 148, 42, 30, 408, 409, 410, 25, 26, 337, 187, 31, 312, 89, 228, 85, 226, 40, 44, 478, 62, 416, 443, 459, 374, 482, 470, 461, 442, 444, 476, 220, 439, 463, 415, 255, 449, 247, 389, 379, 472, 438, 455, 339, 330, 383, 462, 477, 481, 479, 471, 446, 437, 469, 428, 468, 375, 381, 317, 456, 270, 480, 245, 162, 254, 269, 305, 380) | 72 | 72 | 0 | |
SELECT `TopBanner`.`id`, `TopBanner`.`display_flag`, `TopBanner`.`src`, `TopBanner`.`alt`, `TopBanner`.`link`, `TopBanner`.`number`, `TopBanner`.`modified` FROM `kir060294_testshop2`.`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_testshop2`.`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_testshop2`.`footer_banners` AS `FooterBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |