| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_testshop11`.`settings` AS `Setting` WHERE 1 = 1 | 31 | 31 | 0 | |
| SHOW TABLE STATUS | 31 | 31 | 4 | maybe slow |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop11`.`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_testshop11`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc | 9 | 9 | 0 | |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop11`.`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_testshop11`.`prices` AS `Price` WHERE `parent_id` = 2 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop11`.`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_testshop11`.`prices` AS `Price` WHERE `parent_id` = 44 AND `display_flag` = '1' ORDER BY `number` asc | 3 | 3 | 0 | |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_testshop11`.`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_testshop11`.`prices` AS `Price` WHERE `parent_id` = 45 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_testshop11`.`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_testshop11`.`rankers` AS `Ranker` WHERE `Ranker`.`ranking_id` = (1) ORDER BY `Ranker`.`rank` asc | 0 | 0 | 0 | |
| SELECT `AsideBanner`.`id`, `AsideBanner`.`display_flag`, `AsideBanner`.`src`, `AsideBanner`.`file_name`, `AsideBanner`.`alt`, `AsideBanner`.`link`, `AsideBanner`.`number`, `AsideBanner`.`created`, `AsideBanner`.`modified` FROM `kir060294_testshop11`.`aside_banners` AS `AsideBanner` WHERE `AsideBanner`.`display_flag` = '1' ORDER BY `AsideBanner`.`number` asc | 0 | 0 | 0 | |
| SELECT count(station) AS count, `MeetingPlace`.`station` FROM `kir060294_testshop11`.`meeting_places` AS `MeetingPlace` WHERE `display_flag` = '1' GROUP BY station ORDER BY `number` asc LIMIT 5 | 3 | 3 | 0 | |
| SELECT `Option`.`id`, `Option`.`price` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 13 | 13 | 0 | |
| SELECT `Option`.`id`, `Option`.`price` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 13 | 13 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '2000' ORDER BY `Option`.`number` asc | 5 | 5 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '2000' ORDER BY `Option`.`number` asc | 5 | 5 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '2000' ORDER BY `Option`.`number` asc | 5 | 5 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '2000' ORDER BY `Option`.`number` asc | 5 | 5 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '2000' ORDER BY `Option`.`number` asc | 5 | 5 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '3000' ORDER BY `Option`.`number` asc | 4 | 4 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '3000' ORDER BY `Option`.`number` asc | 4 | 4 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '3000' ORDER BY `Option`.`number` asc | 4 | 4 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '4000' ORDER BY `Option`.`number` asc | 3 | 3 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '4000' ORDER BY `Option`.`number` asc | 3 | 3 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '4000' ORDER BY `Option`.`number` asc | 3 | 3 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '3000' ORDER BY `Option`.`number` asc | 4 | 4 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_testshop11`.`options` AS `Option` WHERE `Option`.`price` = '' ORDER BY `Option`.`number` asc | 1 | 1 | 0 | |
| SELECT `TopBanner`.`id`, `TopBanner`.`display_flag`, `TopBanner`.`src`, `TopBanner`.`alt`, `TopBanner`.`link`, `TopBanner`.`number`, `TopBanner`.`modified` FROM `kir060294_testshop11`.`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_testshop11`.`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_testshop11`.`footer_banners` AS `FooterBanner` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
10 duplicate queries run.