2019-12-09 13:29:37
| 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 `Property`.`id`, `Property`.`property_name`, `Property`.`type`, `Property`.`price`, `Property`.`pref`, `Property`.`city`, `Property`.`land_area`, `Property`.`land_area_tsubo`, `Property`.`building_area`, `Property`.`building_area_tsubo`, `Property`.`traffic`, `Property`.`story`, `Property`.`construction_date`, `Property`.`construction` FROM `urisouko_shopoff`.`properties` AS `Property` WHERE `is_delete` = 0 AND `id` = 14961 | 1 | 1 | 0 | |
| 3 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 14961 LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `Property`.`id`, `Property`.`property_name`, `Property`.`type`, `Property`.`price`, `Property`.`pref`, `Property`.`city`, `Property`.`land_area`, `Property`.`land_area_tsubo`, `Property`.`building_area`, `Property`.`building_area_tsubo`, `Property`.`traffic`, `Property`.`story`, `Property`.`construction_date`, `Property`.`construction` FROM `urisouko_shopoff`.`properties` AS `Property` WHERE `is_delete` = 0 AND `id` = 16960 | 1 | 1 | 1 | |
| 5 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 16960 LIMIT 1 | 1 | 1 | 1 | |
| 6 | SELECT `Property`.`id`, `Property`.`property_name`, `Property`.`type`, `Property`.`price`, `Property`.`pref`, `Property`.`city`, `Property`.`land_area`, `Property`.`land_area_tsubo`, `Property`.`building_area`, `Property`.`building_area_tsubo`, `Property`.`traffic`, `Property`.`story`, `Property`.`construction_date`, `Property`.`construction` FROM `urisouko_shopoff`.`properties` AS `Property` WHERE `is_delete` = 0 AND `id` = 15891 | 1 | 1 | 1 | |
| 7 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 15891 LIMIT 1 | 1 | 1 | 1 | |
| 8 | 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 `News`.`is_delete` = 0 AND `News`.`id` = 15 AND `News`.`is_publish` = 1 | 1 | 1 | 1 |
