Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_lam_dev`.`settings` AS `Setting` WHERE 1 = 1 | 39 | 39 | 0 | |
SHOW TABLE STATUS | 42 | 42 | 7 | maybe slow |
SELECT `AsideBanner`.`id`, `AsideBanner`.`display_flag`, `AsideBanner`.`file_name`, `AsideBanner`.`alt`, `AsideBanner`.`link`, `AsideBanner`.`number`, `AsideBanner`.`created`, `AsideBanner`.`modified` FROM `kir060294_lam_dev`.`aside_banners` AS `AsideBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Option`.`id`, `Option`.`price` FROM `kir060294_lam_dev`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 11 | 11 | 0 | |
SELECT `Option`.`id`, `Option`.`price` FROM `kir060294_lam_dev`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 11 | 11 | 0 | |
SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`options` AS `Option` WHERE `Option`.`price` = '4000' ORDER BY `Option`.`number` asc | 1 | 1 | 0 | |
SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_lam_dev`.`options` AS `Option` WHERE `Option`.`price` = '5000' ORDER BY `Option`.`number` asc | 1 | 1 | 0 | |
SELECT `Rank`.`id`, `Rank`.`display_flag`, `Rank`.`name`, `Rank`.`price`, `Rank`.`number`, `Rank`.`created`, `Rank`.`modified` FROM `kir060294_lam_dev`.`ranks` AS `Rank` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `ServiceArea`.`id`, `ServiceArea`.`prefecture` FROM `kir060294_lam_dev`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `city` IS NULL AND `ward` IS NULL AND `town` IS NULL AND `village` IS NULL AND NOT (`prefecture` IS NULL) ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Place`.`id`, `Place`.`display_flag`, `Place`.`station`, `Place`.`name`, `Place`.`information`, `Place`.`location`, `Place`.`compass_direction`, `Place`.`number`, (X(location)) AS `Place__lat`, (Y(location)) AS `Place__lng` FROM `kir060294_lam_dev`.`meeting_places` AS `Place` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_lam_dev`.`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_lam_dev`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc | 10 | 10 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_lam_dev`.`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_lam_dev`.`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_lam_dev`.`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_lam_dev`.`prices` AS `Price` WHERE `parent_id` = 3 AND `display_flag` = '1' ORDER BY `number` asc | 1 | 1 | 0 | |
SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_lam_dev`.`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_lam_dev`.`prices` AS `Price` WHERE `parent_id` = 29 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `ServiceArea`.`id`, `ServiceArea`.`prefecture` FROM `kir060294_lam_dev`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND NOT (`prefecture` IS NULL) AND `city` IS NULL AND `ward` IS NULL AND `town` IS NULL AND `village` IS NULL ORDER BY `number` asc | 0 | 0 | 0 | |
SELECT `ServiceArea`.`id`, `ServiceArea`.`display_flag`, `ServiceArea`.`prefecture`, `ServiceArea`.`city`, `ServiceArea`.`ward`, `ServiceArea`.`town`, `ServiceArea`.`village`, `ServiceArea`.`lat`, `ServiceArea`.`lng`, `ServiceArea`.`designated_flag`, `ServiceArea`.`price`, `ServiceArea`.`number`, `ServiceArea`.`created`, `ServiceArea`.`modified` FROM `kir060294_lam_dev`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
8 duplicate queries run.