| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`flag`, `Setting`.`number`, `Setting`.`modified` FROM `kir060294_delirealtest`.`settings` AS `Setting` WHERE 1 = 1 | 37 | 37 | 0 | |
| SHOW TABLE STATUS | 41 | 41 | 2 | |
| SELECT `AsideBanner`.`id`, `AsideBanner`.`display_flag`, `AsideBanner`.`file_name`, `AsideBanner`.`alt`, `AsideBanner`.`link`, `AsideBanner`.`number`, `AsideBanner`.`created`, `AsideBanner`.`modified` FROM `kir060294_delirealtest`.`aside_banners` AS `AsideBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`prefecture` FROM `kir060294_delirealtest`.`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 | 6 | 6 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' ORDER BY `number` asc | 61 | 61 | 1 | |
| SELECT `Option`.`id`, `Option`.`price` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
| SELECT `Option`.`id`, `Option`.`price` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`display_flag` = '1' ORDER BY `Option`.`number` asc | 10 | 10 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '2000' 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_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '2000' 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_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '2000' 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_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '2000' 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_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '3000' ORDER BY `Option`.`number` asc | 2 | 2 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '3000' ORDER BY `Option`.`number` asc | 2 | 2 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '4000' ORDER BY `Option`.`number` asc | 2 | 2 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '4000' ORDER BY `Option`.`number` asc | 2 | 2 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '5000' ORDER BY `Option`.`number` asc | 2 | 2 | 0 | |
| SELECT `Option`.`id`, `Option`.`display_flag`, `Option`.`name`, `Option`.`price`, `Option`.`number`, `Option`.`created`, `Option`.`modified` FROM `kir060294_delirealtest`.`options` AS `Option` WHERE `Option`.`price` = '5000' ORDER BY `Option`.`number` asc | 2 | 2 | 0 | |
| SELECT `Rank`.`id`, `Rank`.`display_flag`, `Rank`.`name`, `Rank`.`price`, `Rank`.`number`, `Rank`.`created`, `Rank`.`modified` FROM `kir060294_delirealtest`.`ranks` AS `Rank` WHERE `display_flag` = '1' ORDER BY `number` asc | 3 | 3 | 0 | |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`prefecture` FROM `kir060294_delirealtest`.`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 | 6 | 6 | 0 | |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`price` FROM `kir060294_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND NOT (`price` = 0) ORDER BY `price` asc | 44 | 44 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 1100 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 3 | 3 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 2200 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 3 | 3 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 3300 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 12 | 12 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 4400 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 9 | 9 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 5500 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 10 | 10 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 6600 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 5 | 5 | 1 | maybe slow |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`price` FROM `kir060294_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND NOT (`price` = 0) ORDER BY `price` asc | 44 | 44 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 1100 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 3 | 3 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 2200 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 3 | 3 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 3300 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 12 | 12 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 4400 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 9 | 9 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 5500 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 10 | 10 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 6600 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 5 | 5 | 1 | maybe slow |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`price` FROM `kir060294_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '兵庫県' AND NOT (`price` = 0) ORDER BY `price` asc | 8 | 8 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '兵庫県' AND `price` = 3300 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 1 | 1 | 1 | |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '兵庫県' AND `price` = 4400 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 1 | 1 | 1 | |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '兵庫県' AND `price` = 5500 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 1 | 1 | 1 | |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '兵庫県' AND `price` = 6600 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 5 | 5 | 1 | maybe slow |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`price` FROM `kir060294_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '京都府' AND NOT (`price` = 0) ORDER BY `price` asc | 1 | 1 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '京都府' AND `price` = 11000 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 1 | 1 | 1 | |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`price` FROM `kir060294_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '奈良県' AND NOT (`price` = 0) ORDER BY `price` asc | 4 | 4 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '奈良県' AND `price` = 6600 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 1 | 1 | 1 | |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '奈良県' AND `price` = 9900 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 2 | 2 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '奈良県' AND `price` = 11000 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 1 | 1 | 1 | |
| SELECT `ServiceArea`.`id`, `ServiceArea`.`price` FROM `kir060294_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND NOT (`price` = 0) ORDER BY `price` asc | 44 | 44 | 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 1100 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 3 | 3 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 2200 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 3 | 3 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 3300 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 12 | 12 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 4400 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 9 | 9 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 5500 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 10 | 10 | 1 | maybe slow |
| 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_delirealtest`.`service_areas` AS `ServiceArea` WHERE `display_flag` = '1' AND `prefecture` = '大阪府' AND `price` = 6600 AND NOT (`id` IN (1, 25, 71, 72, 154, 5)) ORDER BY `number` asc | 5 | 5 | 1 | maybe slow |
| 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_delirealtest`.`meeting_places` AS `Place` WHERE `display_flag` = '1' ORDER BY `number` asc | 2 | 2 | 0 | |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_delirealtest`.`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_delirealtest`.`prices` AS `Price` WHERE `parent_id` = 1 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_delirealtest`.`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_delirealtest`.`prices` AS `Price` WHERE `parent_id` = 2 AND `display_flag` = '1' ORDER BY `number` asc | 17 | 17 | 0 | |
| SELECT `Price`.`id`, `Price`.`value`, `Price`.`number` FROM `kir060294_delirealtest`.`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_delirealtest`.`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_delirealtest`.`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_delirealtest`.`prices` AS `Price` WHERE `parent_id` = 29 AND `display_flag` = '1' ORDER BY `number` asc | 0 | 0 | 0 | |
21 duplicate queries run.