リフォームお役立ちコンテンツ
部位別でリフォーム記事を検索

全面リフォーム

• 家全体リフォーム

水回りリフォーム

• 浴室リフォーム
• トイレリフォーム
• 洗面リフォーム
• キッチンリフォーム

外回りリフォーム

• 屋根・外壁リフォーム
• ベランダ・バルコニーリフォーム
• 外構・ガーデンスペースリフォーム
• 太陽光リフォーム

居室リフォーム

• リビング・ダイニングリフォーム
• 和室･洋室リフォーム

その他リフォーム

• 窓・サッシリフォーム
• 玄関･廊下リフォーム
• 階段リフォーム
• その他リフォーム

• 
• Session
  +

  Session

  • 0(null)

  ====
• Request
  +

  Request

  Cake Params

  • plugin(null)
  • controllerportfolios
  • actionindex
  • named(array)
    • builder_id11
    • wide_area_id2
    • area_id12
  • pass(empty)
  • isAjax(false)
  • paging(array)
    • Portfolio(array)
      • page1
      • current24
      • count142
      • prevPage(false)
      • nextPage(true)
      • pageCount6
      • order(array)
        • Portfolio.createdDESC
      • limit24
      • options(empty)
      • paramTypenamed
      • queryScope(null)

  Post data

  • Portfolio(array)
    • wide_area_id(array)
      • 02
    • area_id12
    • builder_id11

  Query string

  No querystring data.

  Cookie

  • 0(empty)

  Current Route

  • keys(array)
    • 0controller
    • 1action
  • options(array)
    • defaultRoute(true)
  • defaults(array)
    • plugin(null)
  • template/:controller/:action/*

  ====
• Sql Log
  +

  Sql Logs

  default

  Total Time: 373 ms
  Total Queries: 422 queries

  Query	Affected	Num. rows	Took (ms)	Actions
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1236 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1236 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1236 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1236)	1	1	0
  SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8080000' LIMIT 1	1	1	32	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	1
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1235 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1235 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1235 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	10	10	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1235)	1	1	0
  SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8000000' LIMIT 1	1	1	32	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	1
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1227 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1227 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1227 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	10	10	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1227)	1	1	0
  SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8060000' LIMIT 1	1	1	33	maybe slow
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1102 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1102 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1102 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	7	7	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1102)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1101 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1101 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1101 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	7	7	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1101)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1052 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1052 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1052 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1052)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1046 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1046 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1046 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	3	3	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1046)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	2
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1045 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1045 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1045 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	2	2	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1045)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 743 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 743 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 743 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	7	7	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (743)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 742 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 742 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 742 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (742)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 741 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 741 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 741 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	3	3	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (741)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 740 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 740 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 740 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	2	2	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (740)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 739 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 739 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 739 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	2	2	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (739)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 738 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 738 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 738 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	2	2	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (738)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 737 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 737 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 737 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (737)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 736 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 736 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 736 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (736)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 649 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 649 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 649 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (649)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 549 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 549 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 549 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (549)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 547 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 547 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 547 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (547)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 546 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 546 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 546 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	2	2	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (546)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 545 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 545 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 545 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	4	4	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (545)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 543 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 543 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 543 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (543)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 538 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 538 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 538 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	6	6	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (538)	1	1	0
  SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	168	168	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14)	185	185	2
  SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC	109	109	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9)	217	217	1
  SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 534 ORDER BY `Portfolio`.`created` DESC LIMIT 1	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 534 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`)	1	1	0
  SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 534 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC	5	5	0
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (534)	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 1 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC	1	1	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 2 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC	4	4	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 3 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC	4	4	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 4 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC	2	2	0
  SELECT `ReformCategory`.`id`, `ReformCategory`.`name` FROM `riho`.`reform_categories` AS `ReformCategory` WHERE `ReformCategory`.`valid_flg` = '1' AND `ReformCategory`.`type` = 5 ORDER BY `ReformCategory`.`type` ASC, `ReformCategory`.`sort` ASC	4	4	0
  SELECT `RihoCounter`.`id`, `RihoCounter`.`begind`, `RihoCounter`.`endd`, `RihoCounter`.`subject`, `RihoCounter`.`direct_url`, `RihoCounterArea`.`id`, `RihoCounterArea`.`name`, `RihoCounterArea`.`color` FROM `riho`.`riho_counters` AS `RihoCounter` LEFT JOIN `riho`.`riho_counter_areas` AS `RihoCounterArea` ON (`RihoCounter`.`riho_counter_area_id` = `RihoCounterArea`.`id`) WHERE `RihoCounter`.`valid_flg` = '1' AND ((((`RihoCounter`.`opend` IS NULL) OR (`RihoCounter`.`opend` <= '2021-04-19'))) AND (((`RihoCounter`.`endd` IS NULL) OR (`RihoCounter`.`endd` >= '2021-04-19')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6	6	6	9	maybe slow
  SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'RihoCounter' AND `model_id` IN (886, 889, 884, 881, 872, 873)	6	6	1	maybe slow

  90 duplicate queries run.

  Query Explain:

  Click an "Explain" link above, to see the query explanation.

  ====
• Timer
  +

  Memory

  Peak Memory Use 6.01 MB

  Message	Memory use
  Component initialization	1.32 MB
  Controller action start	2.13 MB
  Controller render start	2.91 MB
  View render complete	4.56 MB

  Timers

  Total Request Time: 955 (ms)

  Message	Time in ms	Graph
  Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.98
  Event: Controller.initialize	8.15
  Event: Controller.startup	0.15
  Controller action	43.22
  Event: Controller.beforeRender	1.28
  » Processing toolbar data	1.20
  Rendering View	850.38
  » Event: View.beforeRender	0.74
  » Rendering APP/View/Portfolios/index.ctp	831.50
  » » Rendering APP/View/Elements/Web/breadcrumb.ctp	0.06
  » » Rendering APP/View/Portfolios/_popular.ctp	2.82
  » » Rendering APP/View/Elements/Web/portfolio_search.ctp	207.07
  » » » Rendering APP/View/Elements/Web/builder_search_js.ctp	0.38
  » » » Rendering APP/View/Elements/Web/counter.ctp	0.33
  » » » Rendering APP/View/Elements/Web/pagination.ctp	0.66
  » » Rendering APP/View/Elements/Web/portfolios.ctp	411.63
  » » Rendering APP/View/Elements/Web/counter.ctp #2	0.05
  » » Rendering APP/View/Elements/Web/pagination.ctp #2	0.57
  » Event: View.afterRender	0.01
  » Event: View.beforeLayout	0.01
  » Rendering APP/View/Layouts/default.ctp	17.86
  » » Rendering APP/View/Elements/Web/meta.ctp	0.04
  » » Rendering APP/View/Elements/Web/gdn_code.ctp	0.02
  » » Rendering APP/View/Elements/Web/header.ctp	0.27
  » » » Rendering APP/View/Elements/Web/link.ctp	0.17
  » » » Rendering APP/View/Elements/Web/phone.ctp	0.02
  » » Rendering APP/View/Elements/Web/nav_pc.ctp	0.23
  » » Rendering APP/View/Elements/Web/nav_sp.ctp	0.23
  » » Rendering APP/View/Elements/Web/article_link.ctp	3.66
  » » Rendering APP/View/Elements/Web/events.ctp	12.47
  » » Rendering APP/View/Elements/Web/footer.ctp	0.31
  » » » Rendering APP/View/Elements/Web/link.ctp #2	0.18
  » » » Rendering APP/View/Elements/Web/phone2.ctp	0.02
  » » Rendering APP/View/Elements/Web/ydn_code.ctp	0.02
  Event: View.afterLayout	0.00

  ====
• Log
  +

  Logs

  There were no log entries made this request

  ====
• Variables
  +

  View Variables

  • builders(array)
    • 162株式会社はぴりの
    • 161トシ企画インテリア株式会社
    • 157株式会社セイコー・トータル・ホーム
    • 154株式会社ファンタジスタ
    • 146株式会社ハウジングプラザ 八幡店
    • 145株式会社ハウジングプラザ 本店
    • 144株式会社　小林組
    • 141リフレ福岡株式会社
    • 135有限会社ライフ
    • 134株式会社ホームケア
    • 132株式会社いろは建築技巧
    • 131くりえいとダイイチ
    • 129株式会社エフォート
    • 128株式会社ムサシ
    • 126株式会社スペースデザイン モブ
    • 115株式会社ピュアスマイル
    • 113株式会社青柳工務店
    • 112昭栄物産株式会社
    • 108株式会社リビングデザイン
    • 104株式会社須原建材
    • 97クラフト リノベーションスタジオ
    • 95リフォーム北九州　㈱福喜
    • 86有限会社松本住宅設備
    • 79株式会社リフォームたつみ
    • 75㈱原工務店
    • 71有限会社松永建設
    • 67ＮＡＲＡインテリア
    • 59有限会社丸の内建設
    • 56有限会社住栄ホーム
    • 51ワークショップｋ＆ｆ 株式会社
    • 42有限会社翔鷹技建
    • 39ホームクリエイト悠
    • 37株式会社テクノス
    • 36リフォームのいずみたに
    • 34東洋テクニカ株式会社（ミセスリフォームスタイル）
    • 33株式会社新田中
    • 32TOTO水彩プラザ傳株式会社(北九州小倉店)
    • 31中田ホームズ有限会社(直方営業所)
    • 30中田ホームズ有限会社(飯塚支店)
    • 29株式会社大信住器
    • 25株式会社尾山建設
    • 21株式会社ホーム機器いのくち
    • 20株式会社リューズ
    • 18有限会社横溝工務店
    • 17株式会社福田工務店
    • 16グットリノベーション
    • 15中田ホームズ有限会社(本社)
    • 13有限会社カネタケ
    • 12有限会社アポロ燃機工業
    • 11LIXILリフォームショップ山﨑建材
    • 9株式会社山内工務店
  • advisers(array)
    • 308後藤　洋
    • 307岡根　修平
    • 304吉原　正幸
    • 302近藤　優
    • 289恒宮　和明
    • 288瀬川　里詩
    • 287五嶋　三千代
    • 286坪見　憲人
    • 266田中 隆二
    • 263植山　拓也
    • 258cozy
    • 257安坂　晃一
    • 256安坂　文一
    • 253久木田　弘毅
    • 251岡 祐次
    • 239野中　大志
    • 227江口　礼奈
    • 222青柳　徹也
    • 221藤原　孝彦
    • 220中村　康志
    • 219中山　和大
    • 218光富　誠
    • 217衛藤　雅樹
    • 216永井　康祐
    • 212森　美朗
    • 209須原　聡彦
    • 200江口　雅敏
    • 181松本　龍彦
    • 167鍵本　実
    • 166鍵本　達実
    • 165原　義浩
    • 164嶋田　由美子
    • 163原　和人
    • 148松永　揚治
    • 141楢崎　弘子
    • 140楢崎　晋介
    • 137楢崎　四郎
    • 122内藤　秀典
    • 117檜垣　欣一郎
    • 110木下　和大
    • 109木下　文夫
    • 105石堂　直子
    • 104楠田　るみ子
    • 103谷倉　秀治
    • 98羽矢　文人
    • 97江口　新二
    • 94栗野　紘明
    • 93古賀　哲夫
    • 92泉谷　勇吾
    • 89田中　邦和
    • 83吉田　勝実
    • 80元吉　敏文
    • 76尾山　幸男
    • 68重村　英臣
    • 62朝　巧
    • 61吉田　伸一郎
    • 60福田　秀典
    • 56鎌田　親人
    • 55鬼武　昂輔
    • 54小田　圭介
    • 52中田　進
    • 45濱島　節子
    • 44兼竹　義彦
    • 43和田 剛志
    • 42山﨑　星児
    • 31本田 照子
    • 25中原　竜一
    • 21岩崎　誠
    • 20山﨑　祥子
    • 19本田　浩二
    • 18大崎　勝也
  • areas(array)
    • 33遠賀郡
    • 12北九州市
    • 19中間市
    • 23豊前市
    • 32京都郡
    • 31行橋市
    • 76築上郡
  • crumbs(array)
    • 0(array)
      • title施工事例検索
  • smartphoneTopPortfolios(array)
    • 0(array)
      • SmartphoneTopPortfolio(array)
        • id264
        • portfolio_id2407
        • sort1
        • created2021-04-16 15:50:33
        • modified2021-04-16 15:50:33
      • Portfolio(array)
        • id2407
        • subject北欧風リフォーム　～　キャットウォークのある吹き抜け　～
        • budget約８００万円
        • construction_period４５日間
        • postcode8140100
        • areaname福岡市城南区
        • main_image(array)
          • id26708
          • modelPortfolio
          • model_id2407
          • field_namemain_image
          • file_nametop画像.jpg
          • file_content_typeimage/jpeg
          • file_size133342
          • created2020-09-02 10:11:59
          • modified2020-09-02 10:11:59
          • file_path/var/www/riho2/app/tmp/file/Portfolio/2407/main_image/top画像.jpg
          • bindedModelAttachment
        • tagsペット,デザイン,アンティーク,アクセント,防犯,省エネ
      • Tag(array)
        • 0(array)
          • id14
          • nameペット
          • PortfoliosTag(array)
            • id2700
            • portfolio_id2407
            • tag_id14
        • 1(array)
          • id42
          • nameデザイン
          • PortfoliosTag(array)
            • id2701
            • portfolio_id2407
            • tag_id42
        • 2(array)
          • id25
          • nameアンティーク
          • PortfoliosTag(array)
            • id2702
            • portfolio_id2407
            • tag_id25
        • 3(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id2703
            • portfolio_id2407
            • tag_id36
        • 4(array)
          • id39
          • name防犯
          • PortfoliosTag(array)
            • id4814
            • portfolio_id2407
            • tag_id39
        • 5(array)
          • id1
          • name省エネ
          • PortfoliosTag(array)
            • id5018
            • portfolio_id2407
            • tag_id1
    • 1(array)
      • SmartphoneTopPortfolio(array)
        • id263
        • portfolio_id549
        • sort2
        • created2021-04-13 13:14:17
        • modified2021-04-13 13:14:17
      • Portfolio(array)
        • id549
        • subject家族が自然に集まるキッチン
        • budget150万円
        • construction_period４日間
        • postcode
        • areaname
        • main_image(array)
          • id3504
          • modelPortfolio
          • model_id549
          • field_namemain_image
          • file_nameK様　後1.JPG
          • file_content_typeimage/jpeg
          • file_size3184841
          • created2014-08-04 19:48:21
          • modified2014-08-04 19:48:21
          • file_path/var/www/riho2/app/tmp/file/Portfolio/549/main_image/K様　後1.JPG
          • bindedModelAttachment
        • tags収納,デザイン,お掃除,照明,アクセント,壁紙
      • Tag(array)
        • 0(array)
          • id33
          • name収納
          • PortfoliosTag(array)
            • id9415
            • portfolio_id549
            • tag_id33
        • 1(array)
          • id42
          • nameデザイン
          • PortfoliosTag(array)
            • id9416
            • portfolio_id549
            • tag_id42
        • 2(array)
          • id40
          • nameお掃除
          • PortfoliosTag(array)
            • id9417
            • portfolio_id549
            • tag_id40
        • 3(array)
          • id23
          • name照明
          • PortfoliosTag(array)
            • id9418
            • portfolio_id549
            • tag_id23
        • 4(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id9419
            • portfolio_id549
            • tag_id36
        • 5(array)
          • id38
          • name壁紙
          • PortfoliosTag(array)
            • id9420
            • portfolio_id549
            • tag_id38
    • 2(array)
      • SmartphoneTopPortfolio(array)
        • id262
        • portfolio_id77
        • sort3
        • created2021-04-09 11:01:37
        • modified2021-04-09 11:01:37
      • Portfolio(array)
        • id77
        • subject寝室とキッチンを作り変え
        • budget1470万円
        • construction_period2ヶ月
        • postcode8140000
        • areaname
        • main_image(array)
          • id1163
          • modelPortfolio
          • model_id77
          • field_namemain_image
          • file_namet-tei_after_4.jpg
          • file_content_typeimage/jpeg
          • file_size147411
          • created2014-03-17 17:26:28
          • modified2014-03-17 17:26:28
          • file_path/var/www/riho2/app/tmp/file/Portfolio/77/main_image/t-tei_after_4.jpg
          • bindedModelAttachment
        • tagsデザイン,収納,壁紙,お掃除,断熱,安全
      • Tag(array)
        • 0(array)
          • id42
          • nameデザイン
          • PortfoliosTag(array)
            • id4617
            • portfolio_id77
            • tag_id42
        • 1(array)
          • id33
          • name収納
          • PortfoliosTag(array)
            • id4618
            • portfolio_id77
            • tag_id33
        • 2(array)
          • id38
          • name壁紙
          • PortfoliosTag(array)
            • id4619
            • portfolio_id77
            • tag_id38
        • 3(array)
          • id40
          • nameお掃除
          • PortfoliosTag(array)
            • id4620
            • portfolio_id77
            • tag_id40
        • 4(array)
          • id6
          • name断熱
          • PortfoliosTag(array)
            • id4621
            • portfolio_id77
            • tag_id6
        • 5(array)
          • id41
          • name安全
          • PortfoliosTag(array)
            • id4622
            • portfolio_id77
            • tag_id41
    • 3(array)
      • SmartphoneTopPortfolio(array)
        • id261
        • portfolio_id2125
        • sort4
        • created2021-04-06 10:35:19
        • modified2021-04-06 10:35:19
      • Portfolio(array)
        • id2125
        • subject人生設計～退職『前』に全面改装！
        • budget800万円
        • construction_period60日間
        • postcode8150000
        • areaname
        • main_image(array)
          • id23469
          • modelPortfolio
          • model_id2125
          • field_namemain_image
          • file_nameTOP.jpg
          • file_content_typeimage/jpeg
          • file_size193146
          • created2020-02-18 13:53:44
          • modified2020-02-18 13:53:44
          • file_path/var/www/riho2/app/tmp/file/Portfolio/2125/main_image/TOP.jpg
          • bindedModelAttachment
        • tags間取り,壁紙,お掃除,省エネ,収納,アクセント,テレビ
      • Tag(array)
        • 0(array)
          • id15
          • name間取り
          • PortfoliosTag(array)
            • id8906
            • portfolio_id2125
            • tag_id15
        • 1(array)
          • id38
          • name壁紙
          • PortfoliosTag(array)
            • id8907
            • portfolio_id2125
            • tag_id38
        • 2(array)
          • id40
          • nameお掃除
          • PortfoliosTag(array)
            • id8908
            • portfolio_id2125
            • tag_id40
        • 3(array)
          • id1
          • name省エネ
          • PortfoliosTag(array)
            • id8909
            • portfolio_id2125
            • tag_id1
        • 4(array)
          • id33
          • name収納
          • PortfoliosTag(array)
            • id8910
            • portfolio_id2125
            • tag_id33
        • 5(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id8911
            • portfolio_id2125
            • tag_id36
        • 6(array)
          • id20
          • nameテレビ
          • PortfoliosTag(array)
            • id8912
            • portfolio_id2125
            • tag_id20
    • 4(array)
      • SmartphoneTopPortfolio(array)
        • id260
        • portfolio_id1103
        • sort5
        • created2021-04-02 11:05:02
        • modified2021-04-02 11:05:02
      • Portfolio(array)
        • id1103
        • subject出来るだけ自然素材をとりいれたい！
        • budget1500万円
        • construction_period３ヶ月間
        • postcode
        • areaname
        • main_image(array)
          • id7995
          • modelPortfolio
          • model_id1103
          • field_namemain_image
          • file_nametopアフター内部k邸.JPG
          • file_content_typeimage/jpeg
          • file_size3740600
          • created2014-12-22 16:39:14
          • modified2014-12-22 16:39:15
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1103/main_image/topアフター内部k邸.JPG
          • bindedModelAttachment
        • tags間取り,自然素材,省エネ,アクセント
      • Tag(array)
        • 0(array)
          • id15
          • name間取り
          • PortfoliosTag(array)
            • id8179
            • portfolio_id1103
            • tag_id15
        • 1(array)
          • id30
          • name自然素材
          • PortfoliosTag(array)
            • id8180
            • portfolio_id1103
            • tag_id30
        • 2(array)
          • id1
          • name省エネ
          • PortfoliosTag(array)
            • id8181
            • portfolio_id1103
            • tag_id1
        • 3(array)
          • id36
          • nameアクセント
          • PortfoliosTag(array)
            • id8182
            • portfolio_id1103
            • tag_id36
  • portfolios(array)
    • 0(array)
      • Portfolio(array)
        • id1236
        • builder_id11
        • adviser_id21
        • subject暖かな出迎えが嬉しい　南欧風エントランス
        • headlineお施主様ご希望の〝南欧風〟イメージをベースに仕上げました。照明やオーナメントもアンティーク調で揃えました。
        • postcode8080000
        • areaname
        • cost300
        • adviser_commentお施主様ご希望の〝南欧風〟イメージをベースに仕上げました。照明やオーナメントもアンティーク調で揃えました。
        • modified2020-11-19 08:57:34
        • created2015-07-17 13:24:07
        • main_image(array)
          • id10010
          • modelPortfolio
          • model_id1236
          • field_namemain_image
          • file_namemain.jpg
          • file_content_typeimage/jpeg
          • file_size787298
          • created2015-07-17 13:24:32
          • modified2015-07-17 13:24:32
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1236/main_image/main.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 1(array)
      • Portfolio(array)
        • id1235
        • builder_id11
        • adviser_id18
        • subject二人仕様の広さに、スペースも「断捨離」　第二の人生を送る和モダン住空間
        • headlineご主人様の現役引退やご実家が空家になることなどが重なり、これからどうするかを考えていた矢先、昨今のリフォーム技術の高さを知ったのが始まり。 築６１年のお宅、２階建てのうち１階を全面リフォーム。８畳の和室を減築し、縁側をリビングに、使いやすい空間を確保しました。
        • postcode8000000
        • areaname
        • cost1400
        • adviser_commentお施主様の将来のことを考えながら、コンパクトな家づくりを行いました。構造上、残さなくてはならない柱を活かして部屋の配置を考えました。
        • modified2020-11-19 09:26:12
        • created2015-07-17 08:50:52
        • main_image(array)
          • id9989
          • modelPortfolio
          • model_id1235
          • field_namemain_image
          • file_namemain.jpg
          • file_content_typeimage/jpeg
          • file_size744190
          • created2015-07-17 08:50:52
          • modified2015-07-17 08:50:52
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1235/main_image/main.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 2(array)
      • Portfolio(array)
        • id1227
        • builder_id11
        • adviser_id19
        • subject部屋数減らし、全体をバリアフリー化
        • headline30年以上、雨漏りに悩まされていたＳ様邸。２年前に防水工事を依頼した縁で、今回の家全体のリフォームのご依頼を頂きました。 １階に３室あった和室を１室にし、それぞれリビングや浴室を拡充。部屋数が減り空間を広く使ったことで、１階全体が非常に広く感じられ、奥様も「とにかく明るくなって、開放感が全然ちがいます」と大満足です。
        • postcode8060000
        • areaname
        • cost1800
        • adviser_comment30年以上、雨漏りに悩まされていたＳ様邸。２年前に防水工事を依頼した縁で、今回の家全体リフォームのご依頼頂きました。
        • modified2020-11-19 09:24:02
        • created2015-06-10 15:31:31
        • main_image(array)
          • id9758
          • modelPortfolio
          • model_id1227
          • field_namemain_image
          • file_names-02.jpg
          • file_content_typeimage/jpeg
          • file_size219847
          • created2015-06-10 15:31:31
          • modified2015-06-10 15:31:31
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1227/main_image/s-02.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 3(array)
      • Portfolio(array)
        • id1102
        • builder_id11
        • adviser_id18
        • subject憩の場へと一新　間取り変更によって実現した寛ぎのＬＤＫ
        • headline築３４年のマンションは、部屋が細かく仕切られ、太陽光が入りにくいスペースが多くありました。また、キッチンや浴室の老朽化などの理由から、改装を決断しました。
        • postcode
        • areaname
        • cost620
        • adviser_comment築年数の古いマンションを、現在のご夫婦の生活スタイルに合わせたカタチで改装。機能面とデザイン面を良質したお住まいです。
        • modified2020-11-19 09:27:08
        • created2014-12-19 12:27:56
        • main_image(array)
          • id7976
          • modelPortfolio
          • model_id1102
          • field_namemain_image
          • file_name1.jpg
          • file_content_typeimage/jpeg
          • file_size1441742
          • created2014-12-19 12:29:06
          • modified2014-12-19 12:29:06
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1102/main_image/1.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 4(array)
      • Portfolio(array)
        • id1101
        • builder_id11
        • adviser_id21
        • subjectRC特有の冷たさと結露を緩和することで快適な住まいへと変貌
        • headlineご主人のご両親が建てられた築４５年、RC構造の２階建て住宅を全面改修。 RC構造特有の冷たさと、それに伴う結露の対策がポイントでした。
        • postcode
        • areaname
        • cost1700
        • adviser_comment断熱材や特殊塗料の使用など、目に見えない部分に注力しました。
        • modified2020-11-19 09:25:21
        • created2014-12-18 18:08:57
        • main_image(array)
          • id7962
          • modelPortfolio
          • model_id1101
          • field_namemain_image
          • file_name1-1.jpg
          • file_content_typeimage/jpeg
          • file_size1403895
          • created2014-12-19 10:49:46
          • modified2014-12-19 10:49:46
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1101/main_image/1-1.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 5(array)
      • Portfolio(array)
        • id1052
        • builder_id11
        • adviser_id19
        • subjectまさにトイレリフォームの申し子!!
        • headline排水の方向や位置をお選びすることが出来ますので、今お使いのトイレに対応してお付けすることが出来ます。タンクを隠し、収納スペースを確保したキャビネットで、空間がスッキリになりました!!
        • postcode
        • areaname
        • cost30
        • adviser_commentリフォーム前もキレイなトイレでしたが、全く収納がなく、お掃除道具が丸見え。見た目がスッキリしませんでした。今回「リフォレ」に取替え、収納もバッチリ!!　タンクを隠した収納スペースなので、空間もスッキリです。
        • modified2020-11-19 09:25:41
        • created2014-10-24 16:49:06
        • main_image(array)
          • id7235
          • modelPortfolio
          • model_id1052
          • field_namemain_image
          • file_name新しい画像 (2).jpg
          • file_content_typeimage/jpeg
          • file_size246559
          • created2014-10-24 16:49:06
          • modified2014-10-24 16:49:06
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1052/main_image/新しい画像 (2).jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 6(array)
      • Portfolio(array)
        • id1046
        • builder_id11
        • adviser_id19
        • subjectキレイなお風呂
        • headline名前とキャッチフレーズの通り、バスルームのキレイを追及したお風呂です。
        • postcode
        • areaname
        • cost116
        • adviser_commentこれから寒くなるにつれて、キレイなお風呂にゆ～っくりと浸かりたくなりますね・・・
        • modified2020-11-19 09:27:26
        • created2014-10-08 16:06:41
        • main_image(array)
          • id7185
          • modelPortfolio
          • model_id1046
          • field_namemain_image
          • file_nameo0800120013085249732.jpg
          • file_content_typeimage/jpeg
          • file_size217101
          • created2014-10-08 16:08:41
          • modified2014-10-08 16:08:41
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1046/main_image/o0800120013085249732.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 7(array)
      • Portfolio(array)
        • id1045
        • builder_id11
        • adviser_id19
        • subjectおもてなし玄関
        • headline「娘から父に贈る　玄関ドア」のリフォームをご紹介します。
        • postcode
        • areaname
        • cost56
        • adviser_comment玄関はお家の顔になるので、いつまでもキレイにしておきたいですね
        • modified2020-11-19 09:27:42
        • created2014-10-08 16:02:05
        • main_image(array)
          • id7184
          • modelPortfolio
          • model_id1045
          • field_namemain_image
          • file_nameo0427064013091227894.jpg
          • file_content_typeimage/jpeg
          • file_size85585
          • created2014-10-08 16:02:05
          • modified2014-10-08 16:02:05
          • file_path/var/www/riho2/app/tmp/file/Portfolio/1045/main_image/o0427064013091227894.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 8(array)
      • Portfolio(array)
        • id743
        • builder_id11
        • adviser_id21
        • subject二世帯住宅リフォーム
        • headline1階はご家族皆様の生活動線に配慮した水廻りに取替えを、2階はS様親子のプライベート空間として新しくデザインしました。
        • postcode
        • areaname
        • cost(null)
        • adviser_comment3世代が同居する一戸建て全面リフォームです。 「おたくは建材屋さんやけ大きなリフォームはせんよね？」なんてご意見をいただくこともしばしば。…ですが！意外と大きな物件もたくさん手掛けていますので、気になった方は是非弊社までお問い合わせください。
        • modified2020-11-19 09:28:30
        • created2014-08-29 19:21:54
        • main_image(array)
          • id5020
          • modelPortfolio
          • model_id743
          • field_namemain_image
          • file_nameinterior16after01.jpg
          • file_content_typeimage/jpeg
          • file_size299070
          • created2014-08-29 19:21:54
          • modified2014-08-29 19:21:54
          • file_path/var/www/riho2/app/tmp/file/Portfolio/743/main_image/interior16after01.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 9(array)
      • Portfolio(array)
        • id742
        • builder_id11
        • adviser_id18
        • subject店舗リフォーム～ドックサロン☆～
        • headlineビルの通路と２階一室を改装し、ドッグサロンをオープン!! 大きな窓ガラス取り付け、室内を明るく、また外から中の様子も伺えるつくりにしました。
        • postcode
        • areaname
        • cost400
        • adviser_comment小倉北区のオフィスビルの通路だった場所と２階の一室を、新店舗オープンに伴い店舗工事をさせていただきました。
        • modified2020-11-19 09:28:57
        • created2014-08-29 18:57:46
        • main_image(array)
          • id5013
          • modelPortfolio
          • model_id742
          • field_namemain_image
          • file_name無題.png
          • file_content_typeimage/png
          • file_size503352
          • created2014-08-29 19:02:49
          • modified2014-08-29 19:02:49
          • file_path/var/www/riho2/app/tmp/file/Portfolio/742/main_image/無題.png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 10(array)
      • Portfolio(array)
        • id741
        • builder_id11
        • adviser_id42
        • subject介護保険を利用した住宅改修
        • headline今回は介護保険認定を受けられたお母様のために、バリアフリーリフォームをご依頼頂きました。段差解消１箇所と手すり１１箇所を工事させていただきました。
        • postcode
        • areaname(null)
        • cost23
        • adviser_comment介護保険を利用した住宅改修は、事前の審査、事後の書類提出等が必要ですが、ライファ八幡中央ではすべて代行して行なえます。
        • modified2014-08-30 13:48:35
        • created2014-08-29 18:18:47
        • main_image(array)
          • id5007
          • modelPortfolio
          • model_id741
          • field_namemain_image
          • file_name新しい画像 (11).jpg
          • file_content_typeimage/jpeg
          • file_size303286
          • created2014-08-29 18:18:47
          • modified2014-08-29 18:18:47
          • file_path/var/www/riho2/app/tmp/file/Portfolio/741/main_image/新しい画像 (11).jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id42
        • name山﨑　星児
    • 11(array)
      • Portfolio(array)
        • id740
        • builder_id11
        • adviser_id19
        • subject階段昇降機で２階にも上がれます!!
        • headline
        • postcode
        • areaname
        • cost91
        • adviser_comment階段昇降機（ステップリフト）は、座ったまま階段を移動できる昇降機です。今回は直線の階段に取り付けとなりましたが、曲がり階段用などもございます。
        • modified2020-11-19 09:31:07
        • created2014-08-29 17:57:41
        • main_image(array)
          • id5001
          • modelPortfolio
          • model_id740
          • field_namemain_image
          • file_name新しい画像 (10).jpg
          • file_content_typeimage/jpeg
          • file_size243036
          • created2014-08-29 17:57:41
          • modified2014-08-29 17:57:41
          • file_path/var/www/riho2/app/tmp/file/Portfolio/740/main_image/新しい画像 (10).jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 12(array)
      • Portfolio(array)
        • id739
        • builder_id11
        • adviser_id19
        • subject毎日の生活をしっかり支えます
        • headline浴室・トイレ・階段に手すりを取り付けました。階段の手すりは、手を添えているときに手すりが途切れてしまわないように連続して取り付けました。
        • postcode
        • areaname
        • cost20
        • adviser_comment手すりがあるだけで、体を支えることができ、日々の動作での体への負担も軽減されます。
        • modified2020-11-19 09:31:36
        • created2014-08-29 17:38:18
        • main_image(array)
          • id4995
          • modelPortfolio
          • model_id739
          • field_namemain_image
          • file_name新しい画像 (7).jpg
          • file_content_typeimage/jpeg
          • file_size95850
          • created2014-08-29 17:38:18
          • modified2014-08-29 17:38:18
          • file_path/var/www/riho2/app/tmp/file/Portfolio/739/main_image/新しい画像 (7).jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 13(array)
      • Portfolio(array)
        • id738
        • builder_id11
        • adviser_id19
        • subject生活の仕方や動きも取付け時のポイントです
        • headline勝手口の段差が高く、足を上げるのが困難になってきたＨ様。緩やかな階段にし、手すりを取り付け。上り下りも軽減されました。
        • postcode
        • areaname
        • cost15
        • adviser_commentお住まいになる方の生活の仕方や行動を考えながら、ご相談の上、必要と思われる箇所に手すりを取り付けました。
        • modified2020-11-19 09:31:58
        • created2014-08-29 16:54:29
        • main_image(array)
          • id4994
          • modelPortfolio
          • model_id738
          • field_namemain_image
          • file_name新しい画像 (6).jpg
          • file_content_typeimage/jpeg
          • file_size374562
          • created2014-08-29 17:19:38
          • modified2014-08-29 17:19:38
          • file_path/var/www/riho2/app/tmp/file/Portfolio/738/main_image/新しい画像 (6).jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 14(array)
      • Portfolio(array)
        • id737
        • builder_id11
        • adviser_id19
        • subject「立つ」「座る」動作を補助します
        • headlineトイレも和式から洋式へ取り替え、室内には手すりも設置。入口扉も開き戸から引き戸にし、動作がラクになるようリフォームしました。
        • postcode
        • areaname
        • cost48
        • adviser_comment介護を必要とする方にとって、「かがむ」という動作はとても大変な動作です。 和式から洋式のトイレに変え、「立つ」「座る」動作の補助となる位置に手すりを取り付けました。
        • modified2020-11-19 09:39:11
        • created2014-08-29 16:17:32
        • main_image(array)
          • id4989
          • modelPortfolio
          • model_id737
          • field_namemain_image
          • file_name新しい画像 (5).jpg
          • file_content_typeimage/jpeg
          • file_size338559
          • created2014-08-29 16:39:25
          • modified2014-08-29 16:39:25
          • file_path/var/www/riho2/app/tmp/file/Portfolio/737/main_image/新しい画像 (5).jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 15(array)
      • Portfolio(array)
        • id736
        • builder_id11
        • adviser_id19
        • subjectお風呂のバリアフリーリフォーム
        • headlineリフォーム前は在来浴室。タイル貼りで滑る危険性があり、また入口には段差がありました。新しくお風呂をリフォーム!!バリアフリーで、手すりも付き、安心してお風呂に入れるようになりました。
        • postcode
        • areaname
        • cost120
        • adviser_comment在来浴室からシステムバスへ。手すりも設置したバリアフリーリフォームです。今回のリフォームには助成金を活用しました。
        • modified2020-11-19 09:33:36
        • created2014-08-29 15:19:41
        • main_image(array)
          • id4983
          • modelPortfolio
          • model_id736
          • field_namemain_image
          • file_namecare02after01-1jpg.jpg
          • file_content_typeimage/jpeg
          • file_size57674
          • created2014-08-29 15:34:19
          • modified2014-08-29 15:34:19
          • file_path/var/www/riho2/app/tmp/file/Portfolio/736/main_image/care02after01-1jpg.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id19
        • name本田　浩二
    • 16(array)
      • Portfolio(array)
        • id649
        • builder_id11
        • adviser_id21
        • subject実家を２世帯住宅へ ひ孫たちも遊べる家
        • headline土壁の古きよき２階建ての日本家屋。 ここに一人で暮らすお母様と同居し新たなスタートを切るため、 入居するお施主様ご夫婦が２世帯住宅へのリフォームを行いました。
        • postcode
        • areaname
        • cost560
        • adviser_comment二世帯なので、まずは行き来があるような住まいつくりを考え、急な階段を解消して動線を確保しました。お客様のご希望である、キッチンの出窓を生かしつつ使いやすい収納を実現すること、リビングのテレビデッキや床材の色、ドアの色も、キッチンの色、全てマッチするように選び抜きました。プランニングの際、与えられたスペースをどう使うか、どう可変性を持たせるか、熟考しました。
        • modified2020-11-19 09:34:30
        • created2014-08-13 16:02:07
        • main_image(array)
          • id4186
          • modelPortfolio
          • model_id649
          • field_namemain_image
          • file_names-2014-07-31_yamasakikenzai_tv.jpg
          • file_content_typeimage/jpeg
          • file_size334437
          • created2014-08-13 16:06:36
          • modified2014-08-13 16:06:36
          • file_path/var/www/riho2/app/tmp/file/Portfolio/649/main_image/s-2014-07-31_yamasakikenzai_tv.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 17(array)
      • Portfolio(array)
        • id549
        • builder_id11
        • adviser_id18
        • subject家族が自然に集まるキッチン
        • headline小さなお子様が２人いらっしゃるＫ様のために、いつもリビングに目が行き届く対面型キッチンをご提案しました。ＬＩＸＩＬのシステムキッチン『サンヴァリエ リシェル』は、フォルムのデザイン性はもちろん、充実した収納設備や節水型の水栓など、"便利＆エコ"の機能が満載です。
        • postcode
        • areaname
        • cost150
        • adviser_comment工事着工前に奥様からお部屋全体のクロスの汚れが目立つとご相談をお受けしました。 調べた結果、クロスの糊がきちんと拭けてなかったのでゴミが付着し汚れが目立っていました。工事最終日に美装業者の方に落としていただきました。この結果、お部屋全体がより明るくなりました。
        • modified2020-11-19 09:35:30
        • created2014-08-04 19:48:21
        • main_image(array)
          • id3504
          • modelPortfolio
          • model_id549
          • field_namemain_image
          • file_nameK様　後1.JPG
          • file_content_typeimage/jpeg
          • file_size3184841
          • created2014-08-04 19:48:21
          • modified2014-08-04 19:48:21
          • file_path/var/www/riho2/app/tmp/file/Portfolio/549/main_image/K様　後1.JPG
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 18(array)
      • Portfolio(array)
        • id547
        • builder_id11
        • adviser_id21
        • subjectトイレとキッチンを一新！【トイレ・浴室編】
        • headline浴室のサボンアクアという水玉模様の壁材を気に入っていただき、この水玉模様をベースに、洗面室やトイレの床材、壁紙を決めていきました。明るく華やかな水まわりになりました!!
        • postcode
        • areaname
        • cost135
        • adviser_commentトイレは、手洗カウンターとトイレの給排水が共通利用できるTOTOの「レストパル」に取替えました。見た目がスッキリとしたトイレですが、実は便器の背面のスペースにトイレットペーパー１２個がそのまま収納出来る広さ！その他にも手の届く場所に収納スペースがたくさん隠されています。
        • modified2020-11-19 09:36:11
        • created2014-08-04 19:37:46
        • main_image(array)
          • id3497
          • modelPortfolio
          • model_id547
          • field_namemain_image
          • file_name新しい画像.png
          • file_content_typeimage/png
          • file_size838544
          • created2014-08-04 19:37:46
          • modified2014-08-04 19:37:46
          • file_path/var/www/riho2/app/tmp/file/Portfolio/547/main_image/新しい画像.png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 19(array)
      • Portfolio(array)
        • id546
        • builder_id11
        • adviser_id21
        • subjectトイレとキッチンを一新！【キッチン編】
        • headline"スイスイ"収納・お手入れが出来るTOTO「クラッソ」を採用しました。
        • postcode
        • areaname
        • cost80
        • adviser_comment従来はＬＩＸＩＬのフランチャイズ店として頑張っておりますが、他のメーカー製品も多数取り揃えておりますので、商品でお悩みの際は遠慮なくお問合せください。
        • modified2020-11-19 09:36:33
        • created2014-08-04 19:08:19
        • main_image(array)
          • id3496
          • modelPortfolio
          • model_id546
          • field_namemain_image
          • file_nameN様　後1.JPG
          • file_content_typeimage/jpeg
          • file_size2346281
          • created2014-08-04 19:16:38
          • modified2014-08-04 19:16:39
          • file_path/var/www/riho2/app/tmp/file/Portfolio/546/main_image/N様　後1.JPG
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 20(array)
      • Portfolio(array)
        • id545
        • builder_id11
        • adviser_id18
        • subjectフロアタイル使用で強い床に
        • headlineトイレのクロスと床の張替え、洗面化粧台のリフォームです。 床はＣＦシート（クッションフロアシート）を貼りました。クッション性が高く、水がこぼれても大丈夫なので、洗面・脱衣室やトイレなどに適しています。しかもトイレはテラコッタ風のＣＦシートに。お気に入りの床にリフォームできました。
        • postcode
        • areaname
        • cost25
        • adviser_commentテラコッタ風の床がいい雰囲気ですね。壁も真っ白に張替え清潔感のあるトイレになりました。
        • modified2020-11-19 09:37:03
        • created2014-08-04 18:40:30
        • main_image(array)
          • id3478
          • modelPortfolio
          • model_id545
          • field_namemain_image
          • file_name新しい画像 (9).png
          • file_content_typeimage/png
          • file_size1135820
          • created2014-08-04 18:40:30
          • modified2014-08-04 18:40:30
          • file_path/var/www/riho2/app/tmp/file/Portfolio/545/main_image/新しい画像 (9).png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 21(array)
      • Portfolio(array)
        • id543
        • builder_id11
        • adviser_id21
        • subject段差解消で介護保険対象に
        • headlineトイレの入口には高さのある段差がありました。トイレの床を上げ、廊下と同じ高さにしたことでバリアフリーに。より安全面に考慮し、手すりも設置しました。
        • postcode
        • areaname
        • cost48
        • adviser_comment今回は北九州の介護保険助成金も利用しています。
        • modified2020-11-19 09:37:29
        • created2014-08-04 18:11:14
        • main_image(array)
          • id3471
          • modelPortfolio
          • model_id543
          • field_namemain_image
          • file_nameＷ様　後2-1.jpg
          • file_content_typeimage/jpeg
          • file_size890825
          • created2014-08-04 18:15:06
          • modified2014-08-04 18:15:06
          • file_path/var/www/riho2/app/tmp/file/Portfolio/543/main_image/Ｗ様　後2-1.jpg
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id21
        • name岩崎　誠
    • 22(array)
      • Portfolio(array)
        • id538
        • builder_id11
        • adviser_id18
        • subject天窓塞ぎ　ユニットバスを導入
        • headline天窓やジャグジー窓の為、冬が寒いとお困りだったN様。 天窓をなくし、上げ下げ窓に変更したことで、冬場もゆっくりお風呂に入れるようになりました。 浴槽は、「キレイ浴槽」でお掃除もしやすくなりました。 浴室入口の段差もなくなり、バリアフリーで安心です。
        • postcode
        • areaname
        • cost160
        • adviser_comment換気乾燥暖房機を取り付けたことにより換気機能はもちろん、浴室空間を快適に調節できるようになりました。
        • modified2020-11-19 09:38:03
        • created2014-08-04 17:41:42
        • main_image(array)
          • id3461
          • modelPortfolio
          • model_id538
          • field_namemain_image
          • file_name新しい画像 (1).png
          • file_content_typeimage/png
          • file_size897880
          • created2014-08-04 17:46:03
          • modified2014-08-04 17:46:03
          • file_path/var/www/riho2/app/tmp/file/Portfolio/538/main_image/新しい画像 (1).png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
    • 23(array)
      • Portfolio(array)
        • id534
        • builder_id11
        • adviser_id18
        • subject明るく柔らかな玄関で迎える
        • headlineリフォーム前は道路から丸見えだったお庭。防犯面での心配もありましたので、今回しっかりと外壁を設けました。
        • postcode
        • areaname
        • cost(null)
        • adviser_commentすべて壁にしてしまうのではなく、枕木やガラスブロックをアクセントに解放感とプライバシーを確保しました。
        • modified2020-11-19 09:38:28
        • created2014-08-04 17:03:41
        • main_image(array)
          • id3450
          • modelPortfolio
          • model_id534
          • field_namemain_image
          • file_name新しい画像.png
          • file_content_typeimage/png
          • file_size848333
          • created2014-08-04 17:05:36
          • modified2014-08-04 17:05:36
          • file_path/var/www/riho2/app/tmp/file/Portfolio/534/main_image/新しい画像.png
          • bindedModelAttachment
      • Builder(array)
        • id11
        • nameLIXILリフォームショップ山﨑建材
      • Adviser(array)
        • id18
        • name大崎　勝也
  • isSearch(true)
  • familyStructures(array)
    • 1単身（一人暮らし）
    • 2単身（親と同居）
    • 3夫婦のみ
    • 4夫婦（子供あり）
    • 5夫婦（親・子供・3世代）
  • tastes(array)
    • 67モダン
    • 68和モダン
    • 69シンプル
    • 70南欧風
    • 71北欧風
    • 72アジア風
    • 73ナチュラル
    • 74レトロモダン
    • 75古民家風
    • 76職人/デザイナー
    • 77眺望を活かす
    • 78隠れ家的
    • 79倉庫風
    • 102自分好み
    • 103使い勝手良く
  • residenceStatuses(array)
    • 30一戸建て
    • 33マンション
    • 93店舗
    • 100その他
  • populatedPlaces(array)
    • 19都市部
    • 20郊外
    • 21新興住宅地
    • 22旧来の住宅地
    • 23リゾート
    • 24平地
    • 25高台
    • 26傾斜地
    • 27海沿い
    • 28川沿い
    • 29山沿い
  • lifestages(array)
    • 12結婚
    • 13出産
    • 14兄弟が増える
    • 15子供独立
    • 16二世帯
    • 17老後
    • 18子供へ
  • wideAreas(array)
    • 5下関・山口エリア
    • 1福岡エリア
    • 2北九州エリア
    • 3筑豊エリア
    • 4筑後エリア
    • 6佐賀エリア
    • 7中津・大分エリア
  • tags(array)
    • 44書斎
    • 43リノベーション
    • 42デザイン
    • 34趣味
    • 41安全
    • 38壁紙
    • 28造作
    • 33収納
    • 39防犯
  • is_smartphone(false)
  • baseUrl/
  • $request->data(array)
    • Portfolio(array)
      • wide_area_id(array)
        • 02
      • area_id12
      • builder_id11
  • $this->validationErrors(array)
    • WideArea(empty)
    • Category(empty)
    • Portfolio(empty)
    • Attachment(empty)
    • Tag(empty)
    • Area(empty)
    • Builder(empty)
    • BuildersArea(empty)
    • Adviser(empty)
    • SmartphoneTopPortfolio(empty)
    • PortfoliosTag(empty)
  • Loaded Helpers(array)
    • 0Session
    • 1Form
    • 2Html
    • 3Paginator
    • 4ImageLabel
    • 5Escape
    • 6Number
    • 7SimpleGraph
    • 8DebugTimer
    • 9Toolbar
    • 10Format
    • 11Time
    • 12HtmlToolbar

  ====
• Environment
  +

  App Constants

  Constant	Value
  CONFIG	'/var/www/riho2/app/Config/'
  USE_DEBUGLIB	true
  FILE_STORAGE_STORE_PATH	'/var/www/riho2/app/tmp/FileStorage/'
  AJAX_FILE_UPLOAD_WRAPPER_SUFFIX	'_wrapper'
  AJAX_FILE_UPLOAD_FILE_FIELD_SUFFIX	'_ajax'
  AJAX_FILE_UPLOAD_HIDDEN_FIELD_SUFFIX	'_cash'
  AJAX_FILE_UPLOAD_CASH_MODEL_ID	'cash'
  AJAX_FILE_UPLOAD_FILE_PATH	'/var/www/riho2/app/tmp/files/'
  AJAX_FILE_UPLOAD_TMP_PATH	'/var/www/riho2/app/tmp/files/cache/'
  BLOCK_CONTENTS_PLUGIN_NAME	'BlockContents'
  EXPORT_PATH	'/tmp/'
  DEFAULT_CONFIG	'default'
  BACKUP_ROTATE	(int) 3
  FILE_STORAGE_TEMPORARY	'/var/www/riho2/app/tmp/FileStorageTmp/'
  FILE_STORAGE_STRAGETYPE_LOCAL	'local'
  FILE_STORAGE_STRAGETYPE_S3	's3'
  SECURIMAGE_PATH	'/var/www/riho2/app/Plugin/Securimage/'
  TINYMCE_PLUGIN_NAME	'TinyMce'
  SITE_TITLE	'リフォームならRiho（リホ）|福岡・北九州・山口・佐賀・大分で展開中'
  ADMIN_SITE_TITLE	'Riho管理サイト'
  SENDER_ADDRESS	'sender@ri-ho.jp'
  SENDER_NAME	'RIHO'
  CATEGORY_TYPE_FAMILY_STRUCTURE	(int) 1
  CATEGORY_TYPE_AGE	(int) 2
  CATEGORY_TYPE_LIFESTAGE	(int) 3
  CATEGORY_TYPE_POPULATED_PLACE	(int) 4
  CATEGORY_TYPE_RESIDENCE_STATUS	(int) 5
  CATEGORY_TYPE_LIFESTYLE	(int) 6
  CATEGORY_TYPE_REPAIR	(int) 7
  CATEGORY_TYPE_REFRESH	(int) 8
  CATEGORY_TYPE_REFORM	(int) 9
  CATEGORY_TYPE_TASTE	(int) 10
  CATEGORY_TYPE_FACULTY	(int) 11
  CATEGORY_TYPE_MEISTER_WORK	(int) 12
  EVENT_TYPE_OPENHOUSE	(int) 1
  EVENT_TYPE_EVENT	(int) 2
  BUILDER_TYPE_AREA	(int) 1
  BUILDER_TYPE_LARGE	(int) 2
  BUILDER_TYPE_PERSONAL	(int) 3
  BUILDER_TYPE_SPEED	(int) 4
  ADVISER_NEW_CREATED	'-14 day'
  ADVISER_NEW_LABEL	'登録2週間以内！'
  ADVISER_HOT_PORTFOLIO_COUNT	(int) 20
  FILEBINDER_FILE_PATH	'/var/www/riho2/app/tmp/file/'
  FILEBINDER_TMP_PATH	'/var/www/riho2/app/tmp/file/cache/'
  FILEBINDER_FILE_FIELD_SUFFIX	'_buffer'
  FILEBINDER_FILE_FIELD_DELETE	'delete_'
  REFORM_CATEGORY_TYPE_ALL	(int) 1
  REFORM_CATEGORY_TYPE_WATER	(int) 2
  REFORM_CATEGORY_TYPE_OUTER	(int) 3
  REFORM_CATEGORY_TYPE_ROOM	(int) 4
  REFORM_CATEGORY_TYPE_OTHER	(int) 5
  MAIN_AREA_COOKIE_NAME	'main_area_id'
  MAIN_AREA_COOKIE_LIFETIME	'+1 month'
  REFORM_PACK_COOKIE_NAME	'REFORM_PACK'
  INQUIRY_SUMMARY_SESSION_NAME	'Inquiry.summary'
  CONTACT_TYPE_KITAKYUSHU	(int) 1
  RIHO_COUNTER_URL	'http://riho2.ri-ho.jp/riho_counter'
  RIHO_EVENT_URL	'http://event.ri-ho.jp/'
  CONTENT_IMAGE_BASE_URL	'/images/upload/articles'
  CONTENT_IMAGE_BASE_PATH	'/var/www/riho2/app/webroot/images/upload/articles'
  REFORM_PACK_URL	'pdf/De-Repa_2017-03-27.pdf'
  RIHO_COUNTER_COUNT	(int) 6
  GOOGLE_MAP_API_KEY	'AIzaSyAoakoSB5NvntNjtfnjBmgNr4v8vqa9wkI'
  GOOD_VALUE_KIND_MAKER_CAMPAIGN	(int) 1
  GOOD_VALUE_KIND_EVENT	(int) 2
  GOOD_VALUE_KIND_PACK	(int) 3
  INSTAGRAM_URL	'https://www.instagram.com/reformpotal/'
  USE_TRUE	(int) 1
  USE_FALSE	(int) 2
  DENHITI_REQUEST_KIND_1	(int) 1
  DENHITI_REQUEST_KIND_2	(int) 2
  DENHITI_REQUEST_KIND_3	(int) 3
  DENHITI_REQUEST_OPTION_1	(int) 1
  DENHITI_REQUEST_OPTION_2	(int) 2
  DENHITI_REQUEST_OPTION_3	(int) 3
  DENHITI_REQUEST_OPTION_4	(int) 4
  DENHITI_REQUEST_OPTION_5	(int) 5
  DENHITI_REQUEST_OPTION_6	(int) 6
  DENHITI_REQUEST_OPTION_7	(int) 7
  PORTFOLIOS_COUNT	'2,000'
  FOUNDING_YEARS	'139'

  CakePHP Constants

  Constant	Value
  APP	'/var/www/riho2/app/'
  APP_DIR	'app'
  APPLIBS	'/var/www/riho2/app/Lib/'
  CACHE	'/var/www/riho2/app/tmp/cache/'
  CAKE	'/var/www/riho2/Vendor/cakephp/cakephp/lib/Cake/'
  CAKE_CORE_INCLUDE_PATH	'/var/www/riho2/Vendor/cakephp/cakephp/lib'
  CORE_PATH	'/var/www/riho2/Vendor/cakephp/cakephp/lib/'
  CAKE_VERSION	'2.10.20'
  CSS	'/var/www/riho2/app/webroot/css/'
  CSS_URL	'css/'
  DS	'/'
  FULL_BASE_URL	'http://riho2.ri-ho.jp'
  IMAGES	'/var/www/riho2/app/webroot/img/'
  IMAGES_URL	'img/'
  JS	'/var/www/riho2/app/webroot/js/'
  JS_URL	'js/'
  LOGS	'/var/www/riho2/app/tmp/logs/'
  ROOT	'/var/www/riho2'
  TESTS	'/var/www/riho2/app/Test/'
  TMP	'/var/www/riho2/app/tmp/'
  VENDORS	'/var/www/riho2/vendors/'
  WEBROOT_DIR	'webroot'
  WWW_ROOT	'/var/www/riho2/app/webroot/'

  PHP Environment

  Environment Variable	Value
  Php Version	'7.3.17'
  Redirect Redirect Unique Id	'YHye9akBM0gkpdd7ZbysewAAAAw'
  Redirect Redirect Cake Env Mode	'riho2'
  Redirect Redirect Status	'200'
  Redirect Unique Id	'YHye9akBM0gkpdd7ZbysewAAAAw'
  Redirect Cake Env Mode	'riho2'
  Redirect Status	'200'
  Unique Id	'YHye9akBM0gkpdd7ZbysewAAAAw'
  Cake Env Mode	'riho2'
  Http User Agent	'CCBot/2.0 (https://commoncrawl.org/faq/)'
  Http Accept	'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
  Http Accept Language	'en-US,en;q=0.5'
  Http Accept Encoding	'br,gzip'
  Http Host	'riho2.ri-ho.jp'
  Http Connection	'Keep-Alive'
  Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
  Server Signature	''
  Server Software	'Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.3.17'
  Server Name	'riho2.ri-ho.jp'
  Server Addr	'153.127.48.136'
  Server Port	'80'
  Remote Addr	'3.227.208.0'
  Document Root	'/var/www/riho2'
  Request Scheme	'http'
  Context Prefix	''
  Context Document Root	'/var/www/riho2'
  Server Admin	'root@localhost'
  Script Filename	'/var/www/riho2/app/webroot/index.php'
  Remote Port	'57928'
  Redirect Url	'/app/webroot/portfolios/index/builder_id:11/wide_area_id:2/area_id:12'
  Gateway Interface	'CGI/1.1'
  Server Protocol	'HTTP/1.1'
  Request Method	'GET'
  Query String	''
  Request Uri	'/portfolios/index/builder_id:11/wide_area_id:2/area_id:12'
  Script Name	'/app/webroot/index.php'
  Php Self	'/app/webroot/index.php'
  Request Time Float	(float) 1618779893.46
  Request Time	(int) 1618779893

  ====
• Include
  +

  Included Files

  Include Paths

  • 1/usr/share/pear
  • 2/usr/share/php
  • 3-> /var/www/riho2/Vendor/cakephp/cakephp/lib/Cake/

  Included Files

  • core(array)
    • Behavior(array)
      • 0CORE/Model/Behavior/ContainableBehavior.php
    • Cache(array)
      • 0CORE/Cache/Cache.php
      • 1CORE/Cache/Engine/FileEngine.php
      • 2CORE/Cache/CacheEngine.php
    • Component(array)
      • 0CORE/Controller/Component/SessionComponent.php
      • 1CORE/Controller/Component/FlashComponent.php
      • 2CORE/Controller/Component/CookieComponent.php
      • 3CORE/Controller/Component/RequestHandlerComponent.php
      • 4CORE/Controller/Component/PaginatorComponent.php
    • Config(array)
      • 0CORE/Config/routes.php
      • 1CORE/Config/config.php
    • Controller(array)
      • 0CORE/Controller/Controller.php
      • 1CORE/Controller/ComponentCollection.php
      • 2CORE/Controller/Component.php
    • Datasource(array)
      • 0CORE/Model/Datasource/CakeSession.php
      • 1CORE/Model/Datasource/Database/Mysql.php
      • 2CORE/Model/Datasource/DboSource.php
      • 3CORE/Model/Datasource/DataSource.php
    • Error(array)
      • 0CORE/Error/exceptions.php
      • 1CORE/Error/ErrorHandler.php
    • I18n(array)
      • 0CORE/I18n/I18n.php
      • 1CORE/I18n/L10n.php
    • Log(array)
      • 0CORE/Log/CakeLog.php
      • 1CORE/Log/LogEngineCollection.php
      • 2CORE/Log/Engine/FileLog.php
      • 3CORE/Log/Engine/BaseLog.php
      • 4CORE/Log/CakeLogInterface.php
    • Model(array)
      • 0CORE/Model/Model.php
      • 1CORE/Model/BehaviorCollection.php
      • 2CORE/Model/ModelBehavior.php
      • 3CORE/Model/ConnectionManager.php
    • Network(array)
      • 0CORE/Network/CakeRequest.php
      • 1CORE/Network/CakeResponse.php
    • Other(array)
      • 0CORE/bootstrap.php
      • 1CORE/basics.php
      • 2CORE/Core/App.php
      • 3CORE/Core/Configure.php
      • 4CORE/Core/CakePlugin.php
      • 5CORE/Event/CakeEventListener.php
      • 6CORE/Event/CakeEvent.php
      • 7CORE/Event/CakeEventManager.php
      • 8CORE/Core/CakeObject.php
    • Routing(array)
      • 0CORE/Routing/Router.php
      • 1CORE/Routing/Route/CakeRoute.php
      • 2CORE/Routing/Route/PluginShortRoute.php
      • 3CORE/Routing/Dispatcher.php
      • 4CORE/Routing/Filter/AssetDispatcher.php
      • 5CORE/Routing/DispatcherFilter.php
      • 6CORE/Routing/Filter/CacheDispatcher.php
    • Utility(array)
      • 0CORE/Utility/Hash.php
      • 1CORE/Utility/Inflector.php
      • 2CORE/Utility/Folder.php
      • 3CORE/Utility/ObjectCollection.php
      • 4CORE/Utility/Debugger.php
      • 5CORE/Utility/CakeText.php
      • 6CORE/Utility/Set.php
      • 7CORE/Utility/ClassRegistry.php
    • View(array)
      • 0CORE/View/Helper.php
      • 1CORE/View/HelperCollection.php
  • app(array)
    • Behavior(array)
      • 0APP/Model/Behavior/AssociationValidationBehavior.php
      • 1APP/Model/Behavior/RihoBehavior.php
      • 2APP/Model/Behavior/TagUtilityBehavior.php
      • 3APP/Model/Behavior/HabtmValidateBehavior.php
    • Config(array)
      • 0APP/Config/core.php
      • 1APP/Config/bootstrap.php
      • 2APP/Config/maintenance.php
      • 3APP/Config/riho_counter.php
      • 4APP/Config/Bootstraps/staging.php
      • 5APP/Config/routes.php
      • 6APP/Config/meta.php
      • 7APP/Config/meta_static.php
      • 8APP/Config/database.php
    • Controller(array)
      • 0APP/Controller/PortfoliosController.php
      • 1APP/Lib/Controller/WebAppController.php
      • 2APP/Lib/Controller/AppController.php
    • Model(array)
      • 0APP/Model/WideArea.php
      • 1APP/Lib/Model/AppModel.php
      • 2APP/Model/Category.php
      • 3APP/Model/Portfolio.php
      • 4APP/Model/Tag.php
      • 5APP/Model/Area.php
      • 6APP/Model/Builder.php
      • 7APP/Model/BuildersArea.php
      • 8APP/Model/Adviser.php
      • 9APP/Model/SmartphoneTopPortfolio.php
    • Other(array)
      • 0APP/webroot/index.php
      • 1APP/Vendor/debuglib.php
    • View(array)
      • 0APP/View/Helper/AppHelper.php
  • plugins(array)
    • AjaxFileUpload(array)
      • Config(array)
        • 0AjaxFileUpload/Config/bootstrap.php
    • BlockContents(array)
      • Config(array)
        • 0BlockContents/Config/bootstrap.php
    • Cakeplus(array)
      • Behavior(array)
        • 0Cakeplus/Model/Behavior/ValidationPatternsBehavior.php
        • 1Cakeplus/Model/Behavior/ValidationErrorI18nBehavior.php
        • 2Cakeplus/Model/Behavior/AddValidationRuleBehavior.php
    • ControllerPrefix(array)
      • Plugin(array)
        • 0ControllerPrefix/Lib/Routing/Route/ControllerPrefixRoute.php
    • DbBackup(array)
      • Config(array)
        • 0DbBackup/Config/bootstrap.php
    • DebugKit(array)
      • Component(array)
        • 0DebugKit/Controller/Component/ToolbarComponent.php
      • Plugin(array)
        • 0DebugKit/Lib/DebugMemory.php
        • 1DebugKit/Lib/Panel/SessionPanel.php
        • 2DebugKit/Lib/DebugPanel.php
        • 3DebugKit/Lib/Panel/RequestPanel.php
        • 4DebugKit/Lib/Panel/SqlLogPanel.php
        • 5DebugKit/Lib/Panel/TimerPanel.php
        • 6DebugKit/Lib/Panel/LogPanel.php
        • 7DebugKit/Lib/Log/Engine/DebugKitLog.php
        • 8DebugKit/Lib/Panel/VariablesPanel.php
        • 9DebugKit/Lib/Panel/EnvironmentPanel.php
        • 10DebugKit/Lib/Panel/IncludePanel.php
        • 11DebugKit/Lib/DebugTimer.php
    • Escape(array)
      • Component(array)
        • 0Escape/Controller/Component/EscapeComponent.php
    • FileStorage(array)
      • Config(array)
        • 0FileStorage/Config/bootstrap.php
    • Filebinder(array)
      • Plugin(array)
        • 0Filebinder/View/Helper/LabelHelper.php
      • Behavior(array)
        • 0Filebinder/Model/Behavior/BindableBehavior.php
    • Imagebinder(array)
      • Plugin(array)
        • 0Imagebinder/View/Helper/ImageLabelHelper.php
    • Maintenance(array)
      • Component(array)
        • 0Maintenance/Controller/Component/MaintenanceComponent.php
    • Multivalidatable(array)
      • Behavior(array)
        • 0Multivalidatable/Model/Behavior/MultivalidatableBehavior.php
    • Search(array)
      • Component(array)
        • 0Search/Controller/Component/PrgComponent.php
      • Behavior(array)
        • 0Search/Model/Behavior/SearchableBehavior.php
    • Securimage(array)
      • Config(array)
        • 0Securimage/Config/bootstrap.php
    • TinyMce(array)
      • Config(array)
        • 0TinyMce/Config/bootstrap.php

  ====