| 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_jpalt`.`system_values` AS `SystemValue` WHERE 1 = 1 | | 23 | 23 | 1 |
| 2 | SELECT * FROM cities WHERE prefectures = '奈良県' ORDER BY id ASC | | 39 | 39 | 1 |
| 3 | SELECT `Sorting`.`controller`, `Sorting`.`column`, `Sorting`.`sort`, `Sorting`.`limit` FROM `urisouko_jpalt`.`sortings` AS `Sorting` WHERE `controller` = 'properties' LIMIT 1 | | 1 | 1 | 1 |
| 4 | 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` FROM `urisouko_jpalt`.`properties` AS `Property` WHERE `Property`.`is_publish` = 1 AND `is_delete` = 0 AND `Property`.`pref` = '奈良県' AND `Property`.`is_delete` = 0 ORDER BY `Property`.`building_area` desc LIMIT 20 | | 20 | 20 | 17 |
| 5 | SELECT COUNT(*) AS `count` FROM `urisouko_jpalt`.`properties` AS `Property` WHERE `Property`.`is_publish` = 1 AND `is_delete` = 0 AND `Property`.`pref` = '奈良県' AND `Property`.`is_delete` = 0 | | 1 | 1 | 13 |
| 6 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 17489 AND `PropertyImage`.`is_delete` = 0 | | 2 | 2 | 1 |
| 7 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13357 AND `PropertyImage`.`is_delete` = 0 | | 0 | 0 | 1 |
| 8 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 6742 AND `PropertyImage`.`is_delete` = 0 | | 1 | 1 | 1 |
| 9 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13358 AND `PropertyImage`.`is_delete` = 0 | | 0 | 0 | 1 |
| 10 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13351 AND `PropertyImage`.`is_delete` = 0 | | 1 | 1 | 1 |
| 11 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13312 AND `PropertyImage`.`is_delete` = 0 | | 5 | 5 | 1 |
| 12 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13313 AND `PropertyImage`.`is_delete` = 0 | | 7 | 7 | 1 |
| 13 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13314 AND `PropertyImage`.`is_delete` = 0 | | 3 | 3 | 2 |
| 14 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13315 AND `PropertyImage`.`is_delete` = 0 | | 3 | 3 | 1 |
| 15 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13316 AND `PropertyImage`.`is_delete` = 0 | | 4 | 4 | 1 |
| 16 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13317 AND `PropertyImage`.`is_delete` = 0 | | 3 | 3 | 1 |
| 17 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13319 AND `PropertyImage`.`is_delete` = 0 | | 6 | 6 | 1 |
| 18 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13326 AND `PropertyImage`.`is_delete` = 0 | | 3 | 3 | 1 |
| 19 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13327 AND `PropertyImage`.`is_delete` = 0 | | 8 | 8 | 1 |
| 20 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13328 AND `PropertyImage`.`is_delete` = 0 | | 0 | 0 | 1 |
| 21 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 17988 AND `PropertyImage`.`is_delete` = 0 | | 0 | 0 | 0 |
| 22 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 6733 AND `PropertyImage`.`is_delete` = 0 | | 1 | 1 | 0 |
| 23 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 6743 AND `PropertyImage`.`is_delete` = 0 | | 4 | 4 | 0 |
| 24 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13406 AND `PropertyImage`.`is_delete` = 0 | | 4 | 4 | 0 |
| 25 | SELECT `PropertyImage`.`uniquekey` FROM `urisouko_jpalt`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = 13408 AND `PropertyImage`.`is_delete` = 0 | | 2 | 2 | 0 |
| 26 | SELECT `PrefectureDescription`.`id`, `PrefectureDescription`.`pref_name`, `PrefectureDescription`.`description`, `PrefectureDescription`.`icon`, `PrefectureDescription`.`modified`, `PrefectureDescription`.`created` FROM `urisouko_jpalt`.`prefecture_descriptions` AS `PrefectureDescription` WHERE `pref_name` = '奈良県' LIMIT 1 | | 1 | 1 | 0 |
| 27 | SELECT `Selection`.`keys`, `Selection`.`values` FROM `urisouko_jpalt`.`selections` AS `Selection` WHERE `Selection`.`name` = 'prefs' LIMIT 1 | | 1 | 1 | 1 |
| 28 | SELECT pref,COUNT(id) FROM properties WHERE is_publish = 1 AND is_delete = 0 GROUP BY pref | | 46 | 46 | 20 |
