| 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 | 1 | |
| 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 `UsingProcess`.`id`, `UsingProcess`.`display_flag`, `UsingProcess`.`category`, `UsingProcess`.`title`, `UsingProcess`.`body`, `UsingProcess`.`background_image`, `UsingProcess`.`number`, `UsingProcess`.`modified`, `UsingProcess`.`created` FROM `kir060294_delirealtest`.`using_processes` AS `UsingProcess` WHERE 1 = 1 ORDER BY `UsingProcess`.`number` asc | 15 | 15 | 0 | |
| SELECT `UsingProcess`.`id`, `UsingProcess`.`display_flag`, `UsingProcess`.`category`, `UsingProcess`.`title`, `UsingProcess`.`body`, `UsingProcess`.`background_image`, `UsingProcess`.`number`, `UsingProcess`.`modified`, `UsingProcess`.`created` FROM `kir060294_delirealtest`.`using_processes` AS `UsingProcess` WHERE `category` = 'delivery' ORDER BY `UsingProcess`.`number` asc | 8 | 8 | 0 | |
| SELECT `UsingProcess`.`id`, `UsingProcess`.`display_flag`, `UsingProcess`.`category`, `UsingProcess`.`title`, `UsingProcess`.`body`, `UsingProcess`.`background_image`, `UsingProcess`.`number`, `UsingProcess`.`modified`, `UsingProcess`.`created` FROM `kir060294_delirealtest`.`using_processes` AS `UsingProcess` WHERE `category` = 'meeting' ORDER BY `UsingProcess`.`number` asc | 7 | 7 | 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 | |