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 | 0 | |
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 | 0 | |
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 COUNT(*) AS `count` FROM `kir060294_testshop7`.`events` AS `Event` WHERE `Event`.`id` = 5 AND `Event`.`display_flag` = '1' | 1 | 1 | 0 | |
SELECT `Event`.`id`, `Event`.`display_flag`, `Event`.`title`, `Event`.`body`, `Event`.`banner`, `Event`.`image_kind`, `Event`.`cast_thumb`, `Event`.`start`, `Event`.`end`, `Event`.`number`, `Event`.`created`, `Event`.`modified` FROM `kir060294_testshop7`.`events` AS `Event` WHERE `Event`.`id` = 5 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Event`.`id`, `Event`.`display_flag`, `Event`.`title`, `Event`.`body`, `Event`.`banner`, `Event`.`image_kind`, `Event`.`cast_thumb`, `Event`.`start`, `Event`.`end`, `Event`.`number`, `Event`.`created`, `Event`.`modified` FROM `kir060294_testshop7`.`events` AS `Event` WHERE `Event`.`display_flag` = '1' AND `Event`.`id` < 5 ORDER BY `Event`.`start` desc, `Event`.`modified` desc LIMIT 1 | 0 | 0 | 0 | |
SELECT `Event`.`id`, `Event`.`display_flag`, `Event`.`title`, `Event`.`body`, `Event`.`banner`, `Event`.`image_kind`, `Event`.`cast_thumb`, `Event`.`start`, `Event`.`end`, `Event`.`number`, `Event`.`created`, `Event`.`modified` FROM `kir060294_testshop7`.`events` AS `Event` WHERE `Event`.`display_flag` = '1' AND `Event`.`id` > 5 ORDER BY `Event`.`start` desc, `Event`.`modified` desc LIMIT 1 | 1 | 1 | 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 | |