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 | 1 | |
SHOW TABLE STATUS | 42 | 42 | 5 | maybe slow |
SELECT `PageSetting`.`id`, `PageSetting`.`name`, `PageSetting`.`value`, `PageSetting`.`flag`, `PageSetting`.`modified` FROM `kir060294_lam_dev`.`page_index_index_settings` AS `PageSetting` WHERE 1 = 1 | 0 | 0 | 0 | |
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 `EnterPageBackgroundImage`.`id`, `EnterPageBackgroundImage`.`display_flag`, `EnterPageBackgroundImage`.`device`, `EnterPageBackgroundImage`.`kind`, `EnterPageBackgroundImage`.`dir`, `EnterPageBackgroundImage`.`file_name`, `EnterPageBackgroundImage`.`created`, `EnterPageBackgroundImage`.`modified` FROM `kir060294_lam_dev`.`enter_page_background_images` AS `EnterPageBackgroundImage` WHERE `display_flag` = '1' | 3 | 3 | 0 | |
SELECT `EnterPageBanner`.`id`, `EnterPageBanner`.`display_flag`, `EnterPageBanner`.`type`, `EnterPageBanner`.`file_name`, `EnterPageBanner`.`source`, `EnterPageBanner`.`link`, `EnterPageBanner`.`alt`, `EnterPageBanner`.`new_tab`, `EnterPageBanner`.`number`, `EnterPageBanner`.`created`, `EnterPageBanner`.`modifield` FROM `kir060294_lam_dev`.`enter_page_top_banners` AS `EnterPageBanner` WHERE `display_flag` = '1' ORDER BY `number` asc | 6 | 6 | 0 | |
SELECT `EnterPageBanner`.`id`, `EnterPageBanner`.`display_flag`, `EnterPageBanner`.`type`, `EnterPageBanner`.`file_name`, `EnterPageBanner`.`source`, `EnterPageBanner`.`link`, `EnterPageBanner`.`alt`, `EnterPageBanner`.`new_tab`, `EnterPageBanner`.`number`, `EnterPageBanner`.`created`, `EnterPageBanner`.`modifield` FROM `kir060294_lam_dev`.`enter_page_bottom_banners` AS `EnterPageBanner` 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 | |