| 1 | SELECT date_format(created, '%Y-%m') as ym FROM blogs WHERE is_delete = 0 GROUP BY date_format(created, '%Y-%m') | | 9 | 9 | 1 |
| 2 | 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 |
| 3 | 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` = 16972 | | 1 | 1 | 1 |
| 4 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 16972 LIMIT 1 | | 1 | 1 | 0 |
| 5 | 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` = 16595 | | 1 | 1 | 0 |
| 6 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 16595 LIMIT 1 | | 1 | 1 | 1 |
| 7 | 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` = 4959 | | 1 | 1 | 1 |
| 8 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 4959 LIMIT 1 | | 0 | 0 | 1 |
| 9 | 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` = 6161 | | 1 | 1 | 1 |
| 10 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 6161 LIMIT 1 | | 0 | 0 | 1 |
| 11 | 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` = 6565 | | 1 | 1 | 1 |
| 12 | SELECT `PropertyImage`.`property_id`, `PropertyImage`.`uniquekey` FROM `urisouko_shopoff`.`property_images` AS `PropertyImage` WHERE `is_delete` = 0 AND `property_id` = 6565 LIMIT 1 | | 1 | 1 | 1 |
| 13 | 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 `Blog`.`is_delete` = 0 AND `Blog`.`id` = 1 | | 1 | 1 | 1 |
| 14 | SELECT `BlogCategory`.`id`, `BlogCategory`.`category_name` FROM `urisouko_shopoff`.`blog_categories` AS `BlogCategory` WHERE 1 = 1 | | 6 | 6 | 1 |
| 15 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 1 | | 1 | 1 | 1 |
| 16 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 2 | | 1 | 1 | 1 |
| 17 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 3 | | 1 | 1 | 1 |
| 18 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 4 | | 1 | 1 | 1 |
| 19 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 5 | | 1 | 1 | 1 |
| 20 | SELECT COUNT(*) AS `count` FROM `urisouko_shopoff`.`blogs` AS `Blog` WHERE `is_delete` = 0 AND `is_blog_category` = 6 | | 1 | 1 | 3 |
| 21 | 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 ORDER BY `created` desc LIMIT 5 | | 5 | 5 | 1 |
