test
132
売り店舗・売り事務所のお役立ち情報USEFUL COLUMNS
メールマガジンに登録して最新お役立ち情報をチェックしよう。
お問い合わせCONTACT
売り店舗・売り事務所物件検索サイト ショップオフ
メールマガジンに登録して最新お役立ち情報をチェックしよう。
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `SystemValue`.`id`, `SystemValue`.`name`, `SystemValue`.`value`, `SystemValue`.`type`, `SystemValue`.`valid`, `SystemValue`.`tag`, `SystemValue`.`class`, `SystemValue`.`comment`, `SystemValue`.`explain`, `SystemValue`.`is_view`, `SystemValue`.`is_required`, `SystemValue`.`memo`, `SystemValue`.`modified` FROM `urisouko_shopoff`.`system_values` AS `SystemValue` WHERE 1 = 1 | 23 | 23 | 1 | |
| 2 | SELECT `Blog`.`id`, `Blog`.`is_blog_category`, `Blog`.`title`, `Blog`.`capture`, `Blog`.`body`, `Blog`.`memo`, `Blog`.`is_delete`, `Blog`.`modified`, `Blog`.`created` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 1 ORDER BY `created` desc LIMIT 3 | 1 | 1 | 1 | |
| 3 | SELECT `Blog`.`id`, `Blog`.`is_blog_category`, `Blog`.`title`, `Blog`.`capture`, `Blog`.`body`, `Blog`.`memo`, `Blog`.`is_delete`, `Blog`.`modified`, `Blog`.`created` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 2 ORDER BY `created` desc LIMIT 3 | 3 | 3 | 1 | |
| 4 | SELECT `Blog`.`id`, `Blog`.`is_blog_category`, `Blog`.`title`, `Blog`.`capture`, `Blog`.`body`, `Blog`.`memo`, `Blog`.`is_delete`, `Blog`.`modified`, `Blog`.`created` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 3 ORDER BY `created` desc LIMIT 3 | 2 | 2 | 1 | |
| 5 | SELECT `News`.`id`, `News`.`title`, `News`.`body`, `News`.`memo`, `News`.`is_publish`, `News`.`is_delete`, `News`.`modified`, `News`.`created` FROM `urisouko_shopoff`.`news` AS `News` WHERE `is_delete` = 0 AND `is_publish` = 1 ORDER BY `modified` desc LIMIT 3 | 3 | 3 | 1 | |
| 6 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`properties` AS `Property` LEFT JOIN `urisouko_shopoff`.`get_sites` AS `GetSite` ON (`Property`.`id` = `GetSite`.`id`) WHERE `is_publish` = 1 AND `is_delete` = 0 | 1 | 1 | 12 | |
| 7 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`properties` AS `Property` LEFT JOIN `urisouko_shopoff`.`get_sites` AS `GetSite` ON (`Property`.`id` = `GetSite`.`id`) WHERE `is_publish` IN (2, 3) AND `is_delete` = 0 | 1 | 1 | 26 | |
| 8 | SELECT `Property`.`id`, `Property`.`is_site`, `Property`.`is_publish`, `Property`.`property_name`, `Property`.`price`, `Property`.`before_price`, `Property`.`is_price_change`, `Property`.`unit_price`, `Property`.`pref`, `Property`.`city`, `Property`.`map`, `Property`.`traffic`, `Property`.`traffic_walk_time`, `Property`.`right`, `Property`.`construction`, `Property`.`usage_area`, `Property`.`land_area`, `Property`.`land_area_tsubo`, `Property`.`building_area`, `Property`.`building_area_tsubo`, `Property`.`connection`, `Property`.`private_road`, `Property`.`city_planning`, `Property`.`story`, `Property`.`facility`, `Property`.`parking`, `Property`.`construction_date`, `Property`.`_age`, `Property`.`type`, `Property`.`src_type`, `Property`.`building_coverage`, `Property`.`floor_area_ratio`, `Property`.`geography`, `Property`.`land_use_planning_act`, `Property`.`current_situation`, `Property`.`delivery_time`, `Property`.`person_name`, `Property`.`post_corporation`, `Property`.`post_corporation_tel`, `Property`.`post_corporation_fax`, `Property`.`memo1`, `Property`.`memo2`, `Property`.`special_mention`, `Property`.`recommended_point`, `Property`.`lat`, `Property`.`lng`, `Property`.`is_crane`, `Property`.`is_bungalow`, `Property`.`is_recommend`, `Property`.`is_delete`, `Property`.`price_changed`, `Property`.`stock_confirm`, `Property`.`modified`, `Property`.`created`, `GetSite`.`id`, `GetSite`.`site_name`, `GetSite`.`url` FROM `urisouko_shopoff`.`properties` AS `Property` LEFT JOIN `urisouko_shopoff`.`get_sites` AS `GetSite` ON (`Property`.`id` = `GetSite`.`id`) WHERE `is_recommend` = 1 AND `is_publish` = 1 AND `is_delete` = 0 | 5 | 5 | 11 | |
| 9 | SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey`, `PropertyImage`.`is_delete`, `PropertyImage`.`created` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` IN (14923, 14954, 16572, 17012, 17558) | 12 | 12 | 1 | |
| 10 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 14923 AND `PropertyImage`.`is_delete` = 0 | 3 | 3 | 1 | |
| 11 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 14954 AND `PropertyImage`.`is_delete` = 0 | 2 | 2 | 0 | |
| 12 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 16572 AND `PropertyImage`.`is_delete` = 0 | 1 | 1 | 0 | |
| 13 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 17012 AND `PropertyImage`.`is_delete` = 0 | 3 | 3 | 0 | |
| 14 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 17558 AND `PropertyImage`.`is_delete` = 0 | 2 | 2 | 0 |