リフォーム店検索 | リフォームならRiho（リホ）|福岡・北九州・山口・佐賀・大分で展開中

気になるリフォーム店をチェック！
リフォーム店検索

対応可能エリア	下関・山口エリア福岡エリア北九州エリア筑豊エリア筑後エリア佐賀エリア中津・大分エリア
対応可能エリア
リフォーム店	※対応可能エリアを指定してからお選び下さい。
リフォーム店名		リフォーム店名（ふりがな）
得意工事	キッチンバストイレ・洗面内装リノベーション断熱外壁オール電化太陽光省エネ空調工事ガス工事電気工事バリアフリーインテリア耐震補強エクステリアガーデン屋根工事古民家再生宮大工
5年保障		瑕疵保証

1～12件(全107件)

トレンドワード

中古住宅が得意

不動産事業がある

新築が建てられる

ショールームがある

来店予約ができる

太陽光発電が得意

オール電化が得意

〇〇専門店

建築士がいる

リフォーム店名	リフォーム・太陽光発電のエキスパート株式会社エコテックス【詳細情報へ】施工事例数 260件【施工事例一覧へ】瑕疵保険対応店 5年保障対応店
住所	〒8140175　福岡県福岡市早良区田村２丁目１１-４
電話番号	050-1709-1244 （営業時間：9：00～20：00　定休日：毎週月曜日・夏季休業・年末年始）
FAX	092-874-4171
得意工事	太陽光省エネ空調工事オール電化キッチンバストイレ・洗面エクステリア屋根工事断熱外壁
対応可能エリア	朝倉市、糸島市、小郡市、大野城市、春日市、久留米市、古賀市、太宰府市、筑紫野市、福岡市、福津市、宗像市、那珂川市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	全国400社が加盟するLIXILリフォームチェーンのCSコンテストで全国第一位に選ばれました！！ LIXILリフォームショップ山﨑建材【詳細情報へ】施工事例数 142件【施工事例一覧へ】 5年保障対応店
住所	〒8060023　福岡県北九州市八幡西区八千代町11−11
電話番号	050-1709-1219 （営業時間：8:00～17:00　定休日：日曜日・祝日）
FAX	093-642-5530
得意工事	バリアフリーオール電化キッチンバストイレ・洗面エクステリア
対応可能エリア	北九州市

お問い合わせ

リフォーム店詳細情報

リフォーム店名	住まいの「困った」をご相談ください。ホームクリエイト悠【詳細情報へ】施工事例数 100件【施工事例一覧へ】 5年保障対応店
住所	〒8111302　福岡県福岡市南区井尻４丁目７-１９
電話番号	050-1709-1247 （営業時間：9：00〜18：00　定休日：日・祝日）
FAX	092-586-5204
得意工事	電気工事太陽光ガス工事省エネリノベーションバリアフリー空調工事耐震補強キッチンバストイレ・洗面屋根工事断熱外壁
対応可能エリア	糸島市、小郡市、大野城市、春日市、北九州市、久留米市、古賀市、太宰府市、筑紫野市、福岡市、宗像市、那珂川市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	福岡本店、三苫・塩浜通り店、宗像店／モデルハウス、福津店、志免店の５店舗展開！パワーハウス株式会社【詳細情報へ】施工事例数 90件【施工事例一覧へ】瑕疵保険対応店 5年保障対応店
住所	〒8130031　福岡県福岡市東区八田 2丁目21番28号
電話番号	050-1709-1233 （営業時間：8：00　～　19：00　定休日：なし）
FAX	092-691-8810
得意工事	リノベーション耐震補強キッチンバストイレ・洗面エクステリア内装
対応可能エリア	遠賀郡、古賀市、糟屋郡、福岡市、福津市、宗像市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	「しあわせづくりを住まいから」真心込めてお手伝いします。株式会社ハウジングプラザ本店【詳細情報へ】施工事例数 87件【施工事例一覧へ】瑕疵保険対応店
住所	〒8010851　福岡県北九州市門司区東本町２丁目１-２
電話番号	050-2019-4562 （営業時間：9：00〜17：00　定休日：毎週火・水曜日）
FAX	093-332-6677
得意工事	キッチンバストイレ・洗面内装リノベーション断熱外壁オール電化省エネガス工事電気工事バリアフリー耐震補強エクステリア屋根工事
対応可能エリア	下関市、北九州市、京都郡、行橋市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	住まいプランナー中田ホームズ有限会社(本社) 【詳細情報へ】施工事例数 87件【施工事例一覧へ】 5年保障対応店
住所	〒8230003　福岡県宮若市本城1090-5
電話番号	050-1709-1227 （営業時間：8:00～17:00　定休日：日曜・祭日・夏季・年末年始）
FAX	0949-32-3919
得意工事	電気工事太陽光ガス工事ガーデンインテリア省エネリノベーション空調工事古民家再生オール電化耐震補強キッチンバストイレ・洗面エクステリア屋根工事断熱外壁
対応可能エリア	飯塚市、嘉麻市、北九州市、鞍手郡、直方市、宮若市、宗像市

お問い合わせ

リフォーム店詳細情報

リフォーム店名	住まいのことなら株式会社シモセ（LIXILリフォームショップシモセ）【詳細情報へ】施工事例数 79件【施工事例一覧へ】 5年保障対応店
住所	〒8710111　大分県中津市三光佐知1032番地イオンモール三光
電話番号	050-2019-7686 （営業時間：10：00～21：00　定休日：年中無休）
FAX	0979-27-7686
得意工事	キッチンバストイレ・洗面内装リノベーションオール電化太陽光省エネインテリアエクステリアガーデン屋根工事
対応可能エリア	豊前市、築上郡、中津市、宇佐市

お問い合わせ

リフォーム店詳細情報

リフォーム店名	水廻りリフォーム専門店株式会社大信住器【詳細情報へ】施工事例数 79件【施工事例一覧へ】瑕疵保険対応店 5年保障対応店
住所	〒8020816　福岡県北九州市小倉南区若園4丁目3-25
電話番号	050-1709-1238 （営業時間：8:30〜18:00　定休日：日曜　祝日）
FAX	093-964-2222
得意工事	ガス工事インテリア省エネオール電化キッチンバストイレ・洗面
対応可能エリア	北九州市、中間市、直方市、豊前市、宗像市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	「しあわせづくりを住まいから」真心込めてお手伝いします。株式会社ハウジングプラザ八幡店【詳細情報へ】施工事例数 71件【施工事例一覧へ】瑕疵保険対応店
住所	〒8060068　福岡県北九州市八幡西区別所町2-27
電話番号	050-2019-4562 （営業時間：9：00〜17：00　定休日：毎週火・水曜日）
FAX	093-641-5577
得意工事	キッチンバストイレ・洗面内装リノベーション断熱外壁オール電化省エネガス工事電気工事バリアフリー耐震補強エクステリア屋根工事
対応可能エリア	飯塚市、遠賀郡、北九州市、鞍手郡、田川市、中間市、直方市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	安心、満足の創業昭和40年の地場工務店。株式会社山内工務店【詳細情報へ】施工事例数 64件【施工事例一覧へ】瑕疵保険対応店 5年保障対応店
住所	〒8030836　福岡県北九州市小倉北区中井４丁目９−１０(小倉店) 北九州市八幡西区萩原１丁目３－３１(八幡西店)
電話番号	050-1709-1288 （営業時間：9:00～17:00　定休日：水曜日・第１日曜日）
FAX	093-562-0405
得意工事	キッチンバストイレ・洗面エクステリア屋根工事
対応可能エリア	遠賀郡、北九州市、中間市

お問い合わせ

リフォーム店詳細情報

リフォーム店名	ワタルコウボウ　　　住まいのリフォーム専門店航工房【詳細情報へ】施工事例数 62件【施工事例一覧へ】 5年保障対応店
住所	〒8150075　福岡県福岡市南区長丘3−20−5−403
電話番号	050-1709-1251 （営業時間：8:00〜17:30　定休日：日曜日）
FAX	092-873-6180
得意工事	電気工事ガス工事ガーデン省エネリノベーション空調工事古民家再生オール電化耐震補強キッチンバストイレ・洗面エクステリア屋根工事断熱外壁
対応可能エリア	飯塚市、糸島市、大野城市、春日市、古賀市、太宰府市、筑紫野市、福岡市、福津市、宗像市、那珂川市

お問い合わせ

来店予約

リフォーム店詳細情報

リフォーム店名	一生涯付き合えるパートナーショップ TOTO水彩プラザ傳株式会社(北九州小倉店) 【詳細情報へ】施工事例数 49件【施工事例一覧へ】瑕疵保険対応店 5年保障対応店
住所	〒8060049　福岡県北九州市小倉北区吉野町11-27
電話番号	050-1709-1241 （営業時間：10：00〜18：00　定休日：日曜　祝日　夏季　年末年始）
FAX	093-952-1150
得意工事	太陽光ガーデンバリアフリーオール電化耐震補強キッチンバストイレ・洗面エクステリア屋根工事断熱外壁
対応可能エリア	北九州市、古賀市、中間市、直方市、福岡市、宮若市、宗像市、行橋市

お問い合わせ

リフォーム店詳細情報

1～12件(全107件)

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

全面リフォーム

家全体リフォーム

水回りリフォーム

外回りリフォーム

居室リフォーム

その他リフォーム

リフォームのプロに会いに行こう。
イベント.Riho
（イベント・セミナー情報）

開催期間：2021/03/13〜2021/03/13

クリナップ北九州ショールーム　【３月１３日（土）】キッチン・バス大商談会

北九州エリア

開催期間：2021/03/13〜2021/03/14

ニューホームヒラシマ　春の住まいるフェア

福岡エリア

開催期間：2021/03/13〜2021/03/14

TOTO水彩プラザ小倉店　住まいのリフォーム大商談会

北九州エリア

開催期間：2021/02/15〜2021/03/15

LIXIL×いろは建築技巧　第二弾！！おうちdeリフォーム展示会

中津・大分エリア

開催期間：2021/03/21〜2021/03/21

いろは建築技巧　完成前見楽会

中津・大分エリア

開催期間：2021/02/08〜2021/03/31

クリナップ北九州ショールーム　【平日限定】ご予約　ご来場deプレゼントキャンペーン

北九州エリア

イベント・セミナー情報一覧へ

【Riho公式SNS】

おすすめリフォーム事例を毎週2件Instagramに投稿！

リフォームのお得な最新情報をLINEで随時配信。

住まいのイベント最新情報を毎週Twitterで配信！

Rihoの最新ニュースやトピックを随時紹介。

Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerbuilders
- actionindex
- named(empty)
- pass(empty)
- isAjax(false)
- paging(array)
  Builder(array)
  page1
  current12
  count107
  prevPage(false)
  nextPage(true)
  pageCount9
  order(array)
  Builder.portfolio_countDESC
  Builder.createdDESC
  limit12
  options(empty)
  paramTypenamed
  queryScope(null)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(array)
  0controller
- options(array)
  defaultRoute(true)
- defaults(array)
  actionindex
  plugin(null)
- template/:controller
====

Sql Log

Sql Logs

default

Total Time: 154 ms
Total Queries: 83 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `WideArea`.`id`, `WideArea`.`name` FROM `riho`.`wide_areas` AS `WideArea` WHERE `WideArea`.`valid_flg` = '1' ORDER BY `WideArea`.`pref_id` ASC, `WideArea`.`sort` ASC	7	7	0
SELECT `Work`.`id`, `Work`.`name` FROM `riho`.`works` AS `Work` WHERE `Work`.`valid_flg` = '1' ORDER BY `Work`.`sort` ASC	20	20	0
SELECT `Tag`.`id`, `Tag`.`name` FROM `riho`.`tags` AS `Tag` WHERE `Tag`.`valid_flg` = '1' AND `Tag`.`type` = 2 ORDER BY `Tag`.`type` ASC, `Tag`.`sort` ASC LIMIT 9	9	9	0
SELECT `Builder`.`id`, `Builder`.`peculiarity`, `Builder`.`name`, `Builder`.`name_kana`, `Builder`.`branch_name`, `Builder`.`main_area_id`, `Builder`.`pref_id`, `Builder`.`postcode`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Builder`.`tel`, `Builder`.`fax`, `Builder`.`working_hour`, `Builder`.`holiday`, `Builder`.`url`, `Builder`.`defect_insurance`, `Builder`.`5year_guaranty`, `Builder`.`portfolio_count`, `Builder`.`reserve_flg`, `Pref`.`id`, `Pref`.`name`, `MainArea`.`id`, `MainArea`.`pref_id`, `MainArea`.`wide_area_id`, `MainArea`.`name` FROM `riho`.`v_builders` AS `Builder` LEFT JOIN `riho`.`prefs` AS `Pref` ON (`Builder`.`pref_id` = `Pref`.`id`) LEFT JOIN `riho`.`areas` AS `MainArea` ON (`Builder`.`main_area_id` = `MainArea`.`id`) WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC LIMIT 12	12	12	10	maybe slow
SELECT `Work`.`id`, `Work`.`name`, `BuildersWork`.`id`, `BuildersWork`.`builder_id`, `BuildersWork`.`work_id` FROM `riho`.`works` AS `Work` JOIN `riho`.`builders_works` AS `BuildersWork` ON (`BuildersWork`.`builder_id` IN (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32) AND `BuildersWork`.`work_id` = `Work`.`id`)	131	131	1
SELECT `ServiceArea`.`id`, `ServiceArea`.`name`, `BuildersArea`.`id`, `BuildersArea`.`builder_id`, `BuildersArea`.`area_id` FROM `riho`.`areas` AS `ServiceArea` JOIN `riho`.`builders_areas` AS `BuildersArea` ON (`BuildersArea`.`builder_id` IN (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32) AND `BuildersArea`.`area_id` = `ServiceArea`.`id`) ORDER BY `ServiceArea`.`pref_id` ASC, `ServiceArea`.`sort` ASC	81	81	1
SELECT `Tag`.`id`, `Tag`.`name`, `BuildersTag`.`id`, `BuildersTag`.`builder_id`, `BuildersTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`builders_tags` AS `BuildersTag` ON (`BuildersTag`.`builder_id` IN (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32) AND `BuildersTag`.`tag_id` = `Tag`.`id`) ORDER BY `BuildersTag`.`id` ASC	92	92	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` = 'Builder' AND `model_id` IN (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32)	23	23	3	maybe slow
SELECT COUNT(*) AS `count` FROM `riho`.`v_builders` AS `Builder` LEFT JOIN `riho`.`prefs` AS `Pref` ON (`Builder`.`pref_id` = `Pref`.`id`) LEFT JOIN `riho`.`areas` AS `MainArea` ON (`Builder`.`main_area_id` = `MainArea`.`id`) WHERE `Builder`.`valid_flg` = '1'	1	1	4	maybe slow
SELECT `PickupBuilder`.`id`, `PickupBuilder`.`builder_id`, `PickupBuilder`.`sort`, `PickupBuilder`.`created`, `PickupBuilder`.`modified` FROM `riho`.`pickup_builders` AS `PickupBuilder` WHERE 1 = 1 ORDER BY `PickupBuilder`.`sort` ASC LIMIT 3	3	3	0
SELECT `Builder`.`id`, `Builder`.`name`, `Builder`.`peculiarity`, `Builder`.`pref_id`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Pref`.`id`, `Pref`.`name` FROM `riho`.`v_builders` AS `Builder` LEFT JOIN `riho`.`prefs` AS `Pref` ON (`Builder`.`pref_id` = `Pref`.`id`) WHERE `Builder`.`id` = 97 LIMIT 1	1	1	4	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` = 'Builder' AND model_id = (97)	2	2	0
SELECT `Builder`.`id`, `Builder`.`name`, `Builder`.`peculiarity`, `Builder`.`pref_id`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Pref`.`id`, `Pref`.`name` FROM `riho`.`v_builders` AS `Builder` LEFT JOIN `riho`.`prefs` AS `Pref` ON (`Builder`.`pref_id` = `Pref`.`id`) WHERE `Builder`.`id` = 108 LIMIT 1	1	1	4	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` = 'Builder' AND model_id = (108)	2	2	1	maybe slow
SELECT `Builder`.`id`, `Builder`.`name`, `Builder`.`peculiarity`, `Builder`.`pref_id`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Pref`.`id`, `Pref`.`name` FROM `riho`.`v_builders` AS `Builder` LEFT JOIN `riho`.`prefs` AS `Pref` ON (`Builder`.`pref_id` = `Pref`.`id`) WHERE `Builder`.`id` = 130 LIMIT 1	1	1	4	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` = 'Builder' AND model_id = (130)	2	2	0
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	7
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	4
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 35 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 11 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 39 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	1
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 22 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 145 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 15 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 156 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	1
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 29 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	1
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 146 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 9 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	2
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 43 AND `Portfolio`.`valid_flg` = '1'	1	1	1
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC	166	166	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 (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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)	183	183	2
SELECT `Builder`.`id` FROM `riho`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC	107	107	4
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 (35, 11, 39, 22, 145, 15, 156, 29, 146, 9, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 162, 154, 133, 131, 87, 71, 68, 18, 161, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20)	213	213	1
SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (308, 307, 306, 304, 303, 302, 301, 300, 299, 298, 297, 296, 295, 294, 293, 292, 291, 290, 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` = 32 AND `Portfolio`.`valid_flg` = '1'	1	1	1
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-03-08'))) AND (((`RihoCounter`.`endd` IS NULL) OR (`RihoCounter`.`endd` >= '2021-03-08')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6	6	6	8	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 (832, 849, 850, 837, 851, 846)	6	6	1	maybe slow

44 duplicate queries run.

Query Explain:

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

====

Timer

Memory

Peak Memory Use 5.71 MB

Message	Memory use
Component initialization	1.27 MB
Controller action start	2.10 MB
Controller render start	2.89 MB
View render complete	5.09 MB

Timers

Total Request Time: 316 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	5.26
Event: Controller.initialize	10.03
Event: Controller.startup	0.16
Controller action	45.33
Event: Controller.beforeRender	1.20
» Processing toolbar data	1.09
Rendering View	233.86
» Event: View.beforeRender	1.84
» Rendering APP/View/Builders/index.ctp	212.54
» » Rendering APP/View/Elements/Web/breadcrumb.ctp	0.08
» » Rendering APP/View/Builders/_search.ctp	3.62
» » » Rendering APP/View/Elements/Web/builder_search_js.ctp	0.35
» » » Rendering APP/View/Elements/Web/counter.ctp	0.24
» » » Rendering APP/View/Elements/Web/pagination.ctp	0.81
» » Rendering APP/View/Elements/Web/builder_info.ctp	27.49
» » Rendering APP/View/Elements/Web/builder_info.ctp #2	16.35
» » Rendering APP/View/Elements/Web/builder_info.ctp #3	16.04
» » Rendering APP/View/Elements/Web/builder_info.ctp #4	15.98
» » Rendering APP/View/Elements/Web/builder_info.ctp #5	16.03
» » Rendering APP/View/Elements/Web/builder_info.ctp #6	15.87
» » Rendering APP/View/Elements/Web/builder_info.ctp #7	15.99
» » Rendering APP/View/Elements/Web/builder_info.ctp #8	15.98
» » Rendering APP/View/Elements/Web/builder_info.ctp #9	16.23
» » Rendering APP/View/Elements/Web/builder_info.ctp #10	16.11
» » Rendering APP/View/Elements/Web/builder_info.ctp #11	16.52
» » Rendering APP/View/Elements/Web/builder_info.ctp #12	15.82
» » Rendering APP/View/Elements/Web/counter.ctp #2	0.05
» » Rendering APP/View/Elements/Web/pagination.ctp #2	0.77
» Event: View.afterRender	0.01
» Event: View.beforeLayout	0.01
» Rendering APP/View/Layouts/default.ctp	19.15
» » Rendering APP/View/Elements/Web/gdn_code.ctp	0.02
» » Rendering APP/View/Elements/Web/header.ctp	0.28
» » » Rendering APP/View/Elements/Web/link.ctp	0.17
» » » Rendering APP/View/Elements/Web/phone.ctp	0.03
» » Rendering APP/View/Elements/Web/nav_pc.ctp	0.25
» » Rendering APP/View/Elements/Web/nav_sp.ctp	0.22
» » Rendering APP/View/Elements/Web/article_link.ctp	4.79
» » Rendering APP/View/Elements/Web/events.ctp	12.70
» » Rendering APP/View/Elements/Web/footer.ctp	0.30
» » » Rendering APP/View/Elements/Web/link.ctp #2	0.16
» » » 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
- crumbs(array)
  0(array)
  titleリフォーム店検索
- pickupBuilders(array)
  0(array)
  PickupBuilder(array)
  id17
  builder_id97
  sort1
  created2018-08-23 17:04:27
  modified2021-03-03 14:05:24
  Builder(array)
  id97
  nameクラフトリノベーションスタジオ
  peculiarityCLAFT　renovation.studio
  pref_id40
  address1福津市津屋崎4丁目4-1
  address2ビーチエクセル102号
  address3
  image_exterior(array)
  id16007
  modelBuilder
  model_id97
  field_nameimage_exterior
  file_nameクラフト様ＴＯＰ.jpg
  file_content_typeimage/jpeg
  file_size767008
  created2018-03-23 08:00:14
  modified2018-03-23 08:00:14
  file_path/var/www/riho2/app/tmp/file/Builder/97/image_exterior/クラフト様ＴＯＰ.jpg
  bindedModelAttachment
  image_staff(array)
  id16003
  modelBuilder
  model_id97
  field_nameimage_staff
  file_nameトップ-3.jpg
  file_content_typeimage/jpeg
  file_size541322
  created2018-03-22 12:16:14
  modified2018-03-22 12:16:14
  file_path/var/www/riho2/app/tmp/file/Builder/97/image_staff/トップ-3.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  Pref(array)
  id40
  name福岡県
  1(array)
  PickupBuilder(array)
  id12
  builder_id108
  sort2
  created2017-05-25 09:22:30
  modified2021-03-03 14:05:24
  Builder(array)
  id108
  name株式会社リビングデザイン
  peculiarityリノベーションはおまかせください
  pref_id40
  address1飯塚市楽市１３９－１
  address2
  address3
  image_exterior(array)
  id15891
  modelBuilder
  model_id108
  field_nameimage_exterior
  file_namelogo.jpg
  file_content_typeimage/jpeg
  file_size5680
  created2018-03-05 08:53:40
  modified2018-03-05 08:53:40
  file_path/var/www/riho2/app/tmp/file/Builder/108/image_exterior/logo.jpg
  bindedModelAttachment
  image_staff(array)
  id15892
  modelBuilder
  model_id108
  field_nameimage_staff
  file_nameimage.jpg
  file_content_typeimage/jpeg
  file_size82184
  created2018-03-05 08:53:40
  modified2018-03-05 08:53:40
  file_path/var/www/riho2/app/tmp/file/Builder/108/image_staff/image.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  Pref(array)
  id40
  name福岡県
  2(array)
  PickupBuilder(array)
  id20
  builder_id130
  sort3
  created2019-07-23 10:07:53
  modified2021-03-03 14:05:24
  Builder(array)
  id130
  name金剛住機株式会社
  peculiarity♭ Renovation Studio
  pref_id40
  address1福岡市東区二又瀬18-11
  address2
  address3
  image_exterior(array)
  id18567
  modelBuilder
  model_id130
  field_nameimage_exterior
  file_name1.jpg
  file_content_typeimage/jpeg
  file_size200758
  created2019-02-28 15:48:01
  modified2019-02-28 15:48:01
  file_path/var/www/riho2/app/tmp/file/Builder/130/image_exterior/1.jpg
  bindedModelAttachment
  image_staff(array)
  id18569
  modelBuilder
  model_id130
  field_nameimage_staff
  file_name003 (1).jpg
  file_content_typeimage/jpeg
  file_size90182
  created2019-02-28 15:59:50
  modified2019-02-28 15:59:50
  file_path/var/www/riho2/app/tmp/file/Builder/130/image_staff/003 (1).jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  Pref(array)
  id40
  name福岡県
- builders(array)
  0(array)
  Builder(array)
  id35
  peculiarityリフォーム・太陽光発電のエキスパート
  name株式会社エコテックス
  name_kanaえこてっくす
  branch_name
  main_area_id21
  pref_id40
  postcode8140175
  address1福岡市早良区田村２丁目１１-４
  address2
  address3
  tel050-1709-1244
  fax092-874-4171
  working_hour9：00～20：00
  holiday毎週月曜日・夏季休業・年末年始
  urlhttp://www.ecotex.jp/
  defect_insurance(true)
  5year_guaranty(true)
  portfolio_count260
  reserve_flg1
  image_exterior(array)
  id1107
  modelBuilder
  model_id35
  field_nameimage_exterior
  file_nametennpo-gaikan.JPG
  file_content_typeimage/jpeg
  file_size191198
  created2014-03-07 10:27:05
  modified2014-03-07 10:27:05
  file_path/var/www/riho2/app/tmp/file/Builder/35/image_exterior/tennpo-gaikan.JPG
  bindedModelAttachment
  image_staff(array)
  id1108
  modelBuilder
  model_id35
  field_nameimage_staff
  file_nametennpo-gaikan.JPG
  file_content_typeimage/jpeg
  file_size191198
  created2014-03-07 10:27:05
  modified2014-03-07 10:27:05
  file_path/var/www/riho2/app/tmp/file/Builder/35/image_staff/tennpo-gaikan.JPG
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tags太陽光発電が得意,来店予約ができる,オール電化が得意,〇〇専門店,トレンド感のある事例がある,機能性重視の事例がある,シンプルなテイストの事例が多い,おしゃれな事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id21
  pref_id40
  wide_area_id1
  name福岡市
  Work(array)
  0(array)
  id2
  name太陽光
  BuildersWork(array)
  id288
  builder_id35
  work_id2
  1(array)
  id6
  name省エネ
  BuildersWork(array)
  id289
  builder_id35
  work_id6
  2(array)
  id9
  name空調工事
  BuildersWork(array)
  id290
  builder_id35
  work_id9
  3(array)
  id12
  nameオール電化
  BuildersWork(array)
  id291
  builder_id35
  work_id12
  4(array)
  id14
  nameキッチン
  BuildersWork(array)
  id292
  builder_id35
  work_id14
  5(array)
  id15
  nameバス
  BuildersWork(array)
  id293
  builder_id35
  work_id15
  6(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id294
  builder_id35
  work_id16
  7(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id295
  builder_id35
  work_id17
  8(array)
  id18
  name屋根工事
  BuildersWork(array)
  id296
  builder_id35
  work_id18
  9(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id297
  builder_id35
  work_id19
  ServiceArea(array)
  0(array)
  id1
  name朝倉市
  BuildersArea(array)
  id326
  builder_id35
  area_id1
  1(array)
  id4
  name糸島市
  BuildersArea(array)
  id327
  builder_id35
  area_id4
  2(array)
  id9
  name小郡市
  BuildersArea(array)
  id325
  builder_id35
  area_id9
  3(array)
  id7
  name大野城市
  BuildersArea(array)
  id321
  builder_id35
  area_id7
  4(array)
  id10
  name春日市
  BuildersArea(array)
  id320
  builder_id35
  area_id10
  5(array)
  id13
  name久留米市
  BuildersArea(array)
  id319
  builder_id35
  area_id13
  6(array)
  id14
  name古賀市
  BuildersArea(array)
  id328
  builder_id35
  area_id14
  7(array)
  id16
  name太宰府市
  BuildersArea(array)
  id322
  builder_id35
  area_id16
  8(array)
  id18
  name筑紫野市
  BuildersArea(array)
  id323
  builder_id35
  area_id18
  9(array)
  id21
  name福岡市
  BuildersArea(array)
  id318
  builder_id35
  area_id21
  10(array)
  id22
  name福津市
  BuildersArea(array)
  id329
  builder_id35
  area_id22
  11(array)
  id26
  name宗像市
  BuildersArea(array)
  id324
  builder_id35
  area_id26
  12(array)
  id79
  name那珂川市
  BuildersArea(array)
  id1103
  builder_id35
  area_id79
  Tag(array)
  0(array)
  id4
  name太陽光発電が得意
  BuildersTag(array)
  id3512
  builder_id35
  tag_id4
  1(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id3513
  builder_id35
  tag_id17
  2(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id3514
  builder_id35
  tag_id16
  3(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3515
  builder_id35
  tag_id19
  4(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id3516
  builder_id35
  tag_id46
  5(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3517
  builder_id35
  tag_id47
  6(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3518
  builder_id35
  tag_id48
  7(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3519
  builder_id35
  tag_id49
  1(array)
  Builder(array)
  id11
  peculiarity全国400社が加盟するLIXILリフォームチェーンのCSコンテストで全国第一位に選ばれました！！
  nameLIXILリフォームショップ山﨑建材
  name_kanaすまいこんしぇるらいふぁやはたちゅうおう（やまさきけんざい）
  branch_name
  main_area_id12
  pref_id40
  postcode8060023
  address1北九州市八幡西区八千代町11−11
  address2
  address3
  tel050-1709-1219
  fax093-642-5530
  working_hour8:00～17:00
  holiday日曜日・祝日
  urlhttp://lifa-yahatachuo.com
  defect_insurance(false)
  5year_guaranty(true)
  portfolio_count142
  reserve_flg0
  image_exterior(array)
  id10182
  modelBuilder
  model_id11
  field_nameimage_exterior
  file_name11013403_824811400959015_5650179461624441504_n.jpg
  file_content_typeimage/jpeg
  file_size205868
  created2015-08-11 15:03:51
  modified2015-08-11 15:03:52
  file_path/var/www/riho2/app/tmp/file/Builder/11/image_exterior/11013403_824811400959015_5650179461624441504_n.jpg
  bindedModelAttachment
  image_staff(array)
  id10183
  modelBuilder
  model_id11
  field_nameimage_staff
  file_name11013403_824811400959015_5650179461624441504_n.jpg
  file_content_typeimage/jpeg
  file_size205868
  created2015-08-11 15:03:51
  modified2015-08-11 15:03:52
  file_path/var/www/riho2/app/tmp/file/Builder/11/image_staff/11013403_824811400959015_5650179461624441504_n.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tagsショールームがある,建築士がいる,機能性重視の事例がある,シンプルなテイストの事例が多い,おしゃれな事例がある,〇〇専門店
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id12
  pref_id40
  wide_area_id2
  name北九州市
  Work(array)
  0(array)
  id8
  nameバリアフリー
  BuildersWork(array)
  id27
  builder_id11
  work_id8
  1(array)
  id12
  nameオール電化
  BuildersWork(array)
  id28
  builder_id11
  work_id12
  2(array)
  id14
  nameキッチン
  BuildersWork(array)
  id29
  builder_id11
  work_id14
  3(array)
  id15
  nameバス
  BuildersWork(array)
  id30
  builder_id11
  work_id15
  4(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id31
  builder_id11
  work_id16
  5(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id32
  builder_id11
  work_id17
  ServiceArea(array)
  0(array)
  id12
  name北九州市
  BuildersArea(array)
  id68
  builder_id11
  area_id12
  Tag(array)
  0(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3222
  builder_id11
  tag_id11
  1(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3223
  builder_id11
  tag_id18
  2(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3224
  builder_id11
  tag_id47
  3(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3225
  builder_id11
  tag_id48
  4(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3226
  builder_id11
  tag_id49
  5(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3227
  builder_id11
  tag_id19
  2(array)
  Builder(array)
  id39
  peculiarity住まいの「困った」をご相談ください。
  nameホームクリエイト悠
  name_kanaほーむくりえいと　ゆう
  branch_name
  main_area_id21
  pref_id40
  postcode8111302
  address1福岡市南区井尻４丁目７-１９
  address2
  address3
  tel050-1709-1247
  fax092-586-5204
  working_hour9：00〜18：00
  holiday日・祝日
  urlhttp://homecreate-you.com/
  defect_insurance(false)
  5year_guaranty(true)
  portfolio_count100
  reserve_flg1
  image_exterior(array)
  id10840
  modelBuilder
  model_id39
  field_nameimage_exterior
  file_namehomecreate_yu_2.jpg
  file_content_typeimage/jpeg
  file_size250937
  created2016-01-27 13:08:13
  modified2016-01-27 13:08:13
  file_path/var/www/riho2/app/tmp/file/Builder/39/image_exterior/homecreate_yu_2.jpg
  bindedModelAttachment
  image_staff(array)
  id9216
  modelBuilder
  model_id39
  field_nameimage_staff
  file_namehomecreate_yu-1.JPG
  file_content_typeimage/jpeg
  file_size65742
  created2015-02-26 17:56:28
  modified2015-02-26 17:56:28
  file_path/var/www/riho2/app/tmp/file/Builder/39/image_staff/homecreate_yu-1.JPG
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tags来店予約ができる,太陽光発電が得意,オール電化が得意,シンプルなテイストの事例が多い,機能性重視の事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id21
  pref_id40
  wide_area_id1
  name福岡市
  Work(array)
  0(array)
  id1
  name電気工事
  BuildersWork(array)
  id259
  builder_id39
  work_id1
  1(array)
  id2
  name太陽光
  BuildersWork(array)
  id260
  builder_id39
  work_id2
  2(array)
  id3
  nameガス工事
  BuildersWork(array)
  id261
  builder_id39
  work_id3
  3(array)
  id6
  name省エネ
  BuildersWork(array)
  id262
  builder_id39
  work_id6
  4(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id263
  builder_id39
  work_id7
  5(array)
  id8
  nameバリアフリー
  BuildersWork(array)
  id264
  builder_id39
  work_id8
  6(array)
  id9
  name空調工事
  BuildersWork(array)
  id265
  builder_id39
  work_id9
  7(array)
  id13
  name耐震補強
  BuildersWork(array)
  id266
  builder_id39
  work_id13
  8(array)
  id14
  nameキッチン
  BuildersWork(array)
  id267
  builder_id39
  work_id14
  9(array)
  id15
  nameバス
  BuildersWork(array)
  id268
  builder_id39
  work_id15
  10(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id269
  builder_id39
  work_id16
  11(array)
  id18
  name屋根工事
  BuildersWork(array)
  id270
  builder_id39
  work_id18
  12(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id271
  builder_id39
  work_id19
  ServiceArea(array)
  0(array)
  id4
  name糸島市
  BuildersArea(array)
  id359
  builder_id39
  area_id4
  1(array)
  id9
  name小郡市
  BuildersArea(array)
  id358
  builder_id39
  area_id9
  2(array)
  id7
  name大野城市
  BuildersArea(array)
  id401
  builder_id39
  area_id7
  3(array)
  id10
  name春日市
  BuildersArea(array)
  id353
  builder_id39
  area_id10
  4(array)
  id12
  name北九州市
  BuildersArea(array)
  id351
  builder_id39
  area_id12
  5(array)
  id13
  name久留米市
  BuildersArea(array)
  id352
  builder_id39
  area_id13
  6(array)
  id14
  name古賀市
  BuildersArea(array)
  id360
  builder_id39
  area_id14
  7(array)
  id16
  name太宰府市
  BuildersArea(array)
  id355
  builder_id39
  area_id16
  8(array)
  id18
  name筑紫野市
  BuildersArea(array)
  id356
  builder_id39
  area_id18
  9(array)
  id21
  name福岡市
  BuildersArea(array)
  id350
  builder_id39
  area_id21
  10(array)
  id26
  name宗像市
  BuildersArea(array)
  id357
  builder_id39
  area_id26
  11(array)
  id79
  name那珂川市
  BuildersArea(array)
  id1091
  builder_id39
  area_id79
  Tag(array)
  0(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id3520
  builder_id39
  tag_id17
  1(array)
  id4
  name太陽光発電が得意
  BuildersTag(array)
  id3521
  builder_id39
  tag_id4
  2(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id3522
  builder_id39
  tag_id16
  3(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3523
  builder_id39
  tag_id48
  4(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3524
  builder_id39
  tag_id47
  3(array)
  Builder(array)
  id22
  peculiarity福岡本店、三苫・塩浜通り店、宗像店／モデルハウス、福津店、志免店の５店舗展開！
  nameパワーハウス株式会社
  name_kanaぱわーはうすかぶしきがいしゃ
  branch_name
  main_area_id21
  pref_id40
  postcode8130031
  address1福岡市東区八田
  address22丁目21番28号
  address3
  tel050-1709-1233
  fax092-691-8810
  working_hour8：00　～　19：00
  holidayなし
  urlhttp://www.pw-r.jp/
  defect_insurance(true)
  5year_guaranty(true)
  portfolio_count90
  reserve_flg1
  image_exterior(array)
  id14071
  modelBuilder
  model_id22
  field_nameimage_exterior
  file_nameパワーハウス様ロゴデータ.jpg
  file_content_typeimage/jpeg
  file_size375009
  created2017-09-11 18:35:14
  modified2017-09-11 18:35:14
  file_path/var/www/riho2/app/tmp/file/Builder/22/image_exterior/パワーハウス様ロゴデータ.jpg
  bindedModelAttachment
  image_staff(null)
  image_other1(null)
  image_other2(null)
  tags中古住宅が得意,不動産事業がある,ショールームがある,来店予約ができる,〇〇専門店,建築士がいる,トレンド感のある事例がある,機能性重視の事例がある,おしゃれな事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id21
  pref_id40
  wide_area_id1
  name福岡市
  Work(array)
  0(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id179
  builder_id22
  work_id7
  1(array)
  id13
  name耐震補強
  BuildersWork(array)
  id182
  builder_id22
  work_id13
  2(array)
  id14
  nameキッチン
  BuildersWork(array)
  id183
  builder_id22
  work_id14
  3(array)
  id15
  nameバス
  BuildersWork(array)
  id184
  builder_id22
  work_id15
  4(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id185
  builder_id22
  work_id16
  5(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id186
  builder_id22
  work_id17
  6(array)
  id20
  name内装
  BuildersWork(array)
  id1100
  builder_id22
  work_id20
  ServiceArea(array)
  0(array)
  id33
  name遠賀郡
  BuildersArea(array)
  id241
  builder_id22
  area_id33
  1(array)
  id14
  name古賀市
  BuildersArea(array)
  id239
  builder_id22
  area_id14
  2(array)
  id41
  name糟屋郡
  BuildersArea(array)
  id989
  builder_id22
  area_id41
  3(array)
  id21
  name福岡市
  BuildersArea(array)
  id163
  builder_id22
  area_id21
  4(array)
  id22
  name福津市
  BuildersArea(array)
  id240
  builder_id22
  area_id22
  5(array)
  id26
  name宗像市
  BuildersArea(array)
  id238
  builder_id22
  area_id26
  Tag(array)
  0(array)
  id12
  name中古住宅が得意
  BuildersTag(array)
  id3168
  builder_id22
  tag_id12
  1(array)
  id5
  name不動産事業がある
  BuildersTag(array)
  id3169
  builder_id22
  tag_id5
  2(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3170
  builder_id22
  tag_id11
  3(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id3171
  builder_id22
  tag_id17
  4(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3172
  builder_id22
  tag_id19
  5(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3173
  builder_id22
  tag_id18
  6(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id3174
  builder_id22
  tag_id46
  7(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3175
  builder_id22
  tag_id47
  8(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3176
  builder_id22
  tag_id49
  4(array)
  Builder(array)
  id145
  peculiarity「しあわせづくりを住まいから」真心込めてお手伝いします。
  name株式会社ハウジングプラザ本店
  name_kanaハウジングプラザ
  branch_name
  main_area_id12
  pref_id40
  postcode8010851
  address1北九州市門司区東本町２丁目１-２
  address2
  address3
  tel050-2019-4562
  fax093-332-6677
  working_hour9：00〜17：00
  holiday毎週火・水曜日
  urlhttps://www.housingplaza-net.co.jp/
  defect_insurance(true)
  5year_guaranty(false)
  portfolio_count87
  reserve_flg1
  image_exterior(array)
  id21423
  modelBuilder
  model_id145
  field_nameimage_exterior
  file_name本店.png
  file_content_typeimage/png
  file_size824795
  created2020-01-06 09:40:13
  modified2020-01-06 09:40:13
  file_path/var/www/riho2/app/tmp/file/Builder/145/image_exterior/本店.png
  bindedModelAttachment
  image_staff(array)
  id21424
  modelBuilder
  model_id145
  field_nameimage_staff
  file_name本店.jpg
  file_content_typeimage/jpeg
  file_size2117902
  created2020-01-06 09:40:13
  modified2020-01-06 09:40:13
  file_path/var/www/riho2/app/tmp/file/Builder/145/image_staff/本店.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tags中古住宅が得意,不動産事業がある,新築が建てられる,ショールームがある,来店予約ができる,オール電化が得意,建築士がいる,トレンド感のある事例がある,機能性重視の事例がある,おしゃれな事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id12
  pref_id40
  wide_area_id2
  name北九州市
  Work(array)
  0(array)
  id14
  nameキッチン
  BuildersWork(array)
  id1501
  builder_id145
  work_id14
  1(array)
  id15
  nameバス
  BuildersWork(array)
  id1502
  builder_id145
  work_id15
  2(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id1503
  builder_id145
  work_id16
  3(array)
  id20
  name内装
  BuildersWork(array)
  id1504
  builder_id145
  work_id20
  4(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id1505
  builder_id145
  work_id7
  5(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id1506
  builder_id145
  work_id19
  6(array)
  id12
  nameオール電化
  BuildersWork(array)
  id1507
  builder_id145
  work_id12
  7(array)
  id6
  name省エネ
  BuildersWork(array)
  id1508
  builder_id145
  work_id6
  8(array)
  id3
  nameガス工事
  BuildersWork(array)
  id1509
  builder_id145
  work_id3
  9(array)
  id1
  name電気工事
  BuildersWork(array)
  id1510
  builder_id145
  work_id1
  10(array)
  id8
  nameバリアフリー
  BuildersWork(array)
  id1511
  builder_id145
  work_id8
  11(array)
  id13
  name耐震補強
  BuildersWork(array)
  id1512
  builder_id145
  work_id13
  12(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id1513
  builder_id145
  work_id17
  13(array)
  id18
  name屋根工事
  BuildersWork(array)
  id1514
  builder_id145
  work_id18
  ServiceArea(array)
  0(array)
  id54
  name下関市
  BuildersArea(array)
  id1367
  builder_id145
  area_id54
  1(array)
  id12
  name北九州市
  BuildersArea(array)
  id1322
  builder_id145
  area_id12
  2(array)
  id32
  name京都郡
  BuildersArea(array)
  id1368
  builder_id145
  area_id32
  3(array)
  id31
  name行橋市
  BuildersArea(array)
  id1369
  builder_id145
  area_id31
  Tag(array)
  0(array)
  id12
  name中古住宅が得意
  BuildersTag(array)
  id3440
  builder_id145
  tag_id12
  1(array)
  id5
  name不動産事業がある
  BuildersTag(array)
  id3441
  builder_id145
  tag_id5
  2(array)
  id3
  name新築が建てられる
  BuildersTag(array)
  id3442
  builder_id145
  tag_id3
  3(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3443
  builder_id145
  tag_id11
  4(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id3444
  builder_id145
  tag_id17
  5(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id3445
  builder_id145
  tag_id16
  6(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3446
  builder_id145
  tag_id18
  7(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id3447
  builder_id145
  tag_id46
  8(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3448
  builder_id145
  tag_id47
  9(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3449
  builder_id145
  tag_id49
  5(array)
  Builder(array)
  id15
  peculiarity住まいプランナー
  name中田ホームズ有限会社(本社)
  name_kanaなかたほーむずゆうげんがいしゃ
  branch_name
  main_area_id25
  pref_id40
  postcode8230003
  address1宮若市本城1090-5
  address2
  address3
  tel050-1709-1227
  fax0949-32-3919
  working_hour8:00～17:00
  holiday日曜・祭日・夏季・年末年始
  urlhttp://www.nakata-homes.com
  defect_insurance(false)
  5year_guaranty(true)
  portfolio_count87
  reserve_flg0
  image_exterior(array)
  id238
  modelBuilder
  model_id15
  field_nameimage_exterior
  file_namehonsya.jpg
  file_content_typeimage/jpeg
  file_size630568
  created2013-12-11 10:49:00
  modified2013-12-11 10:49:00
  file_path/var/www/riho2/app/tmp/file/Builder/15/image_exterior/honsya.jpg
  bindedModelAttachment
  image_staff(array)
  id239
  modelBuilder
  model_id15
  field_nameimage_staff
  file_namehonsya.jpg
  file_content_typeimage/jpeg
  file_size630568
  created2013-12-11 10:49:00
  modified2013-12-11 10:49:00
  file_path/var/www/riho2/app/tmp/file/Builder/15/image_staff/honsya.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tagsショールームがある,建築士がいる,太陽光発電が得意,オール電化が得意,〇〇専門店,おしゃれな事例がある,機能性重視の事例がある,シンプルなテイストの事例が多い,トレンド感のある事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id25
  pref_id40
  wide_area_id3
  name宮若市
  Work(array)
  0(array)
  id1
  name電気工事
  BuildersWork(array)
  id81
  builder_id15
  work_id1
  1(array)
  id2
  name太陽光
  BuildersWork(array)
  id82
  builder_id15
  work_id2
  2(array)
  id3
  nameガス工事
  BuildersWork(array)
  id83
  builder_id15
  work_id3
  3(array)
  id4
  nameガーデン
  BuildersWork(array)
  id84
  builder_id15
  work_id4
  4(array)
  id5
  nameインテリア
  BuildersWork(array)
  id85
  builder_id15
  work_id5
  5(array)
  id6
  name省エネ
  BuildersWork(array)
  id86
  builder_id15
  work_id6
  6(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id87
  builder_id15
  work_id7
  7(array)
  id9
  name空調工事
  BuildersWork(array)
  id88
  builder_id15
  work_id9
  8(array)
  id11
  name古民家再生
  BuildersWork(array)
  id89
  builder_id15
  work_id11
  9(array)
  id12
  nameオール電化
  BuildersWork(array)
  id90
  builder_id15
  work_id12
  10(array)
  id13
  name耐震補強
  BuildersWork(array)
  id91
  builder_id15
  work_id13
  11(array)
  id14
  nameキッチン
  BuildersWork(array)
  id92
  builder_id15
  work_id14
  12(array)
  id15
  nameバス
  BuildersWork(array)
  id93
  builder_id15
  work_id15
  13(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id94
  builder_id15
  work_id16
  14(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id95
  builder_id15
  work_id17
  15(array)
  id18
  name屋根工事
  BuildersWork(array)
  id96
  builder_id15
  work_id18
  16(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id97
  builder_id15
  work_id19
  ServiceArea(array)
  0(array)
  id3
  name飯塚市
  BuildersArea(array)
  id107
  builder_id15
  area_id3
  1(array)
  id11
  name嘉麻市
  BuildersArea(array)
  id702
  builder_id15
  area_id11
  2(array)
  id12
  name北九州市
  BuildersArea(array)
  id109
  builder_id15
  area_id12
  3(array)
  id45
  name鞍手郡
  BuildersArea(array)
  id703
  builder_id15
  area_id45
  4(array)
  id20
  name直方市
  BuildersArea(array)
  id110
  builder_id15
  area_id20
  5(array)
  id25
  name宮若市
  BuildersArea(array)
  id111
  builder_id15
  area_id25
  6(array)
  id26
  name宗像市
  BuildersArea(array)
  id112
  builder_id15
  area_id26
  Tag(array)
  0(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3202
  builder_id15
  tag_id11
  1(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3203
  builder_id15
  tag_id18
  2(array)
  id4
  name太陽光発電が得意
  BuildersTag(array)
  id3204
  builder_id15
  tag_id4
  3(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id3205
  builder_id15
  tag_id16
  4(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3206
  builder_id15
  tag_id19
  5(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3207
  builder_id15
  tag_id49
  6(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3208
  builder_id15
  tag_id47
  7(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3209
  builder_id15
  tag_id48
  8(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id3210
  builder_id15
  tag_id46
  6(array)
  Builder(array)
  id156
  peculiarity住まいのことなら
  name株式会社シモセ
  name_kanaかぶしきがいしゃしもせ
  branch_nameLIXILリフォームショップシモセ
  main_area_id73
  pref_id44
  postcode8710111
  address1中津市三光佐知1032番地イオンモール三光
  address2
  address3
  tel050-2019-7686
  fax0979-27-7686
  working_hour10：00～21：00
  holiday年中無休
  url
  defect_insurance(false)
  5year_guaranty(true)
  portfolio_count79
  reserve_flg0
  image_exterior(array)
  id25882
  modelBuilder
  model_id156
  field_nameimage_exterior
  file_nameイオン店.jpg
  file_content_typeimage/jpeg
  file_size104243
  created2020-04-17 13:12:18
  modified2020-04-17 13:12:18
  file_path/var/www/riho2/app/tmp/file/Builder/156/image_exterior/イオン店.jpg
  bindedModelAttachment
  image_staff(array)
  id25881
  modelBuilder
  model_id156
  field_nameimage_staff
  file_nameイオン店.jpg
  file_content_typeimage/jpeg
  file_size104243
  created2020-04-17 13:11:22
  modified2020-04-17 13:11:22
  file_path/var/www/riho2/app/tmp/file/Builder/156/image_staff/イオン店.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tags不動産事業がある,新築が建てられる,ショールームがある,太陽光発電が得意,オール電化が得意,〇〇専門店,建築士がいる
  Pref(array)
  id44
  name大分県
  MainArea(array)
  id73
  pref_id44
  wide_area_id7
  name中津市
  Work(array)
  0(array)
  id14
  nameキッチン
  BuildersWork(array)
  id1637
  builder_id156
  work_id14
  1(array)
  id15
  nameバス
  BuildersWork(array)
  id1638
  builder_id156
  work_id15
  2(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id1639
  builder_id156
  work_id16
  3(array)
  id20
  name内装
  BuildersWork(array)
  id1640
  builder_id156
  work_id20
  4(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id1641
  builder_id156
  work_id7
  5(array)
  id12
  nameオール電化
  BuildersWork(array)
  id1642
  builder_id156
  work_id12
  6(array)
  id2
  name太陽光
  BuildersWork(array)
  id1643
  builder_id156
  work_id2
  7(array)
  id6
  name省エネ
  BuildersWork(array)
  id1644
  builder_id156
  work_id6
  8(array)
  id5
  nameインテリア
  BuildersWork(array)
  id1645
  builder_id156
  work_id5
  9(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id1646
  builder_id156
  work_id17
  10(array)
  id4
  nameガーデン
  BuildersWork(array)
  id1647
  builder_id156
  work_id4
  11(array)
  id18
  name屋根工事
  BuildersWork(array)
  id1648
  builder_id156
  work_id18
  ServiceArea(array)
  0(array)
  id23
  name豊前市
  BuildersArea(array)
  id1397
  builder_id156
  area_id23
  1(array)
  id76
  name築上郡
  BuildersArea(array)
  id1400
  builder_id156
  area_id76
  2(array)
  id73
  name中津市
  BuildersArea(array)
  id1398
  builder_id156
  area_id73
  3(array)
  id75
  name宇佐市
  BuildersArea(array)
  id1399
  builder_id156
  area_id75
  Tag(array)
  0(array)
  id5
  name不動産事業がある
  BuildersTag(array)
  id2597
  builder_id156
  tag_id5
  1(array)
  id3
  name新築が建てられる
  BuildersTag(array)
  id2598
  builder_id156
  tag_id3
  2(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id2599
  builder_id156
  tag_id11
  3(array)
  id4
  name太陽光発電が得意
  BuildersTag(array)
  id2600
  builder_id156
  tag_id4
  4(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id2601
  builder_id156
  tag_id16
  5(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id2602
  builder_id156
  tag_id19
  6(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id2603
  builder_id156
  tag_id18
  7(array)
  Builder(array)
  id29
  peculiarity水廻りリフォーム専門店
  name株式会社大信住器
  name_kanaかぶしきがいしゃ　だいしんじゅうき
  branch_name
  main_area_id12
  pref_id40
  postcode8020816
  address1北九州市小倉南区若園4丁目3-25
  address2
  address3
  tel050-1709-1238
  fax093-964-2222
  working_hour8:30〜18:00
  holiday日曜　祝日
  urlhttp://www.daishin-ju.com
  defect_insurance(true)
  5year_guaranty(true)
  portfolio_count79
  reserve_flg1
  image_exterior(array)
  id10837
  modelBuilder
  model_id29
  field_nameimage_exterior
  file_namedaishin_2.jpg
  file_content_typeimage/jpeg
  file_size772720
  created2016-01-27 12:55:59
  modified2016-01-27 12:55:59
  file_path/var/www/riho2/app/tmp/file/Builder/29/image_exterior/daishin_2.jpg
  bindedModelAttachment
  image_staff(array)
  id8794
  modelBuilder
  model_id29
  field_nameimage_staff
  file_nametop1.JPG
  file_content_typeimage/jpeg
  file_size2898844
  created2015-02-06 17:50:35
  modified2015-02-06 17:50:35
  file_path/var/www/riho2/app/tmp/file/Builder/29/image_staff/top1.JPG
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tagsショールームがある,来店予約ができる,オール電化が得意,〇〇専門店,トレンド感のある事例がある,機能性重視の事例がある,シンプルなテイストの事例が多い,おしゃれな事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id12
  pref_id40
  wide_area_id2
  name北九州市
  Work(array)
  0(array)
  id3
  nameガス工事
  BuildersWork(array)
  id203
  builder_id29
  work_id3
  1(array)
  id5
  nameインテリア
  BuildersWork(array)
  id204
  builder_id29
  work_id5
  2(array)
  id6
  name省エネ
  BuildersWork(array)
  id205
  builder_id29
  work_id6
  3(array)
  id12
  nameオール電化
  BuildersWork(array)
  id207
  builder_id29
  work_id12
  4(array)
  id14
  nameキッチン
  BuildersWork(array)
  id208
  builder_id29
  work_id14
  5(array)
  id15
  nameバス
  BuildersWork(array)
  id209
  builder_id29
  work_id15
  6(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id210
  builder_id29
  work_id16
  ServiceArea(array)
  0(array)
  id12
  name北九州市
  BuildersArea(array)
  id255
  builder_id29
  area_id12
  1(array)
  id19
  name中間市
  BuildersArea(array)
  id257
  builder_id29
  area_id19
  2(array)
  id20
  name直方市
  BuildersArea(array)
  id258
  builder_id29
  area_id20
  3(array)
  id23
  name豊前市
  BuildersArea(array)
  id259
  builder_id29
  area_id23
  4(array)
  id26
  name宗像市
  BuildersArea(array)
  id256
  builder_id29
  area_id26
  Tag(array)
  0(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3144
  builder_id29
  tag_id11
  1(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id3145
  builder_id29
  tag_id17
  2(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id3146
  builder_id29
  tag_id16
  3(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3147
  builder_id29
  tag_id19
  4(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id3148
  builder_id29
  tag_id46
  5(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3149
  builder_id29
  tag_id47
  6(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3150
  builder_id29
  tag_id48
  7(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3151
  builder_id29
  tag_id49
  8(array)
  Builder(array)
  id146
  peculiarity「しあわせづくりを住まいから」真心込めてお手伝いします。
  name株式会社ハウジングプラザ八幡店
  name_kanaハウジングプラザ
  branch_name
  main_area_id12
  pref_id40
  postcode8060068
  address1北九州市八幡西区別所町2-27
  address2
  address3
  tel050-2019-4562
  fax093-641-5577
  working_hour9：00〜17：00
  holiday毎週火・水曜日
  urlhttps://www.housingplaza-net.co.jp/
  defect_insurance(true)
  5year_guaranty(false)
  portfolio_count71
  reserve_flg1
  image_exterior(array)
  id21421
  modelBuilder
  model_id146
  field_nameimage_exterior
  file_name八幡店.png
  file_content_typeimage/png
  file_size811099
  created2020-01-06 09:39:56
  modified2020-01-06 09:39:56
  file_path/var/www/riho2/app/tmp/file/Builder/146/image_exterior/八幡店.png
  bindedModelAttachment
  image_staff(array)
  id21422
  modelBuilder
  model_id146
  field_nameimage_staff
  file_name八幡店.jpg
  file_content_typeimage/jpeg
  file_size1871106
  created2020-01-06 09:39:56
  modified2020-01-06 09:39:56
  file_path/var/www/riho2/app/tmp/file/Builder/146/image_staff/八幡店.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tags中古住宅が得意,不動産事業がある,新築が建てられる,ショールームがある,来店予約ができる,オール電化が得意,建築士がいる,トレンド感のある事例がある,機能性重視の事例がある,おしゃれな事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id12
  pref_id40
  wide_area_id2
  name北九州市
  Work(array)
  0(array)
  id14
  nameキッチン
  BuildersWork(array)
  id1515
  builder_id146
  work_id14
  1(array)
  id15
  nameバス
  BuildersWork(array)
  id1516
  builder_id146
  work_id15
  2(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id1517
  builder_id146
  work_id16
  3(array)
  id20
  name内装
  BuildersWork(array)
  id1518
  builder_id146
  work_id20
  4(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id1519
  builder_id146
  work_id7
  5(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id1520
  builder_id146
  work_id19
  6(array)
  id12
  nameオール電化
  BuildersWork(array)
  id1521
  builder_id146
  work_id12
  7(array)
  id6
  name省エネ
  BuildersWork(array)
  id1522
  builder_id146
  work_id6
  8(array)
  id3
  nameガス工事
  BuildersWork(array)
  id1523
  builder_id146
  work_id3
  9(array)
  id1
  name電気工事
  BuildersWork(array)
  id1524
  builder_id146
  work_id1
  10(array)
  id8
  nameバリアフリー
  BuildersWork(array)
  id1525
  builder_id146
  work_id8
  11(array)
  id13
  name耐震補強
  BuildersWork(array)
  id1526
  builder_id146
  work_id13
  12(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id1527
  builder_id146
  work_id17
  13(array)
  id18
  name屋根工事
  BuildersWork(array)
  id1528
  builder_id146
  work_id18
  ServiceArea(array)
  0(array)
  id3
  name飯塚市
  BuildersArea(array)
  id1327
  builder_id146
  area_id3
  1(array)
  id33
  name遠賀郡
  BuildersArea(array)
  id1328
  builder_id146
  area_id33
  2(array)
  id12
  name北九州市
  BuildersArea(array)
  id1329
  builder_id146
  area_id12
  3(array)
  id45
  name鞍手郡
  BuildersArea(array)
  id1330
  builder_id146
  area_id45
  4(array)
  id15
  name田川市
  BuildersArea(array)
  id1331
  builder_id146
  area_id15
  5(array)
  id19
  name中間市
  BuildersArea(array)
  id1332
  builder_id146
  area_id19
  6(array)
  id20
  name直方市
  BuildersArea(array)
  id1333
  builder_id146
  area_id20
  Tag(array)
  0(array)
  id12
  name中古住宅が得意
  BuildersTag(array)
  id2675
  builder_id146
  tag_id12
  1(array)
  id5
  name不動産事業がある
  BuildersTag(array)
  id2676
  builder_id146
  tag_id5
  2(array)
  id3
  name新築が建てられる
  BuildersTag(array)
  id2677
  builder_id146
  tag_id3
  3(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id2678
  builder_id146
  tag_id11
  4(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id2679
  builder_id146
  tag_id17
  5(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id2680
  builder_id146
  tag_id16
  6(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id2681
  builder_id146
  tag_id18
  7(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id2682
  builder_id146
  tag_id46
  8(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id2683
  builder_id146
  tag_id47
  9(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id2684
  builder_id146
  tag_id49
  9(array)
  Builder(array)
  id9
  peculiarity安心、満足の創業昭和40年の地場工務店。
  name株式会社山内工務店
  name_kanaやまうちこうむてん
  branch_name
  main_area_id12
  pref_id40
  postcode8030836
  address1北九州市小倉北区中井４丁目９−１０(小倉店)
  address2北九州市八幡西区萩原１丁目３－３１(八幡西店)
  address3
  tel050-1709-1288
  fax093-562-0405
  working_hour9:00～17:00
  holiday水曜日・第１日曜日
  urlhttp://y-home.jp
  defect_insurance(true)
  5year_guaranty(true)
  portfolio_count64
  reserve_flg0
  image_exterior(array)
  id26866
  modelBuilder
  model_id9
  field_nameimage_exterior
  file_name小倉店様-全体写真.jpg
  file_content_typeimage/jpeg
  file_size137199
  created2020-09-14 13:52:12
  modified2020-09-14 13:52:12
  file_path/var/www/riho2/app/tmp/file/Builder/9/image_exterior/小倉店様-全体写真.jpg
  bindedModelAttachment
  image_staff(array)
  id27636
  modelBuilder
  model_id9
  field_nameimage_staff
  file_name山内工務店様.png
  file_content_typeimage/png
  file_size1545525
  created2021-02-19 13:49:47
  modified2021-02-19 13:49:47
  file_path/var/www/riho2/app/tmp/file/Builder/9/image_staff/山内工務店様.png
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tagsショールームがある,建築士がいる,おしゃれな事例がある,トレンド感のある事例がある,機能性重視の事例がある,シンプルなテイストの事例が多い,〇〇専門店
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id12
  pref_id40
  wide_area_id2
  name北九州市
  Work(array)
  0(array)
  id14
  nameキッチン
  BuildersWork(array)
  id20
  builder_id9
  work_id14
  1(array)
  id15
  nameバス
  BuildersWork(array)
  id21
  builder_id9
  work_id15
  2(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id22
  builder_id9
  work_id16
  3(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id336
  builder_id9
  work_id17
  4(array)
  id18
  name屋根工事
  BuildersWork(array)
  id337
  builder_id9
  work_id18
  ServiceArea(array)
  0(array)
  id33
  name遠賀郡
  BuildersArea(array)
  id780
  builder_id9
  area_id33
  1(array)
  id12
  name北九州市
  BuildersArea(array)
  id62
  builder_id9
  area_id12
  2(array)
  id19
  name中間市
  BuildersArea(array)
  id781
  builder_id9
  area_id19
  Tag(array)
  0(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3676
  builder_id9
  tag_id11
  1(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3677
  builder_id9
  tag_id18
  2(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3678
  builder_id9
  tag_id49
  3(array)
  id46
  nameトレンド感のある事例がある
  BuildersTag(array)
  id3679
  builder_id9
  tag_id46
  4(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3680
  builder_id9
  tag_id47
  5(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3681
  builder_id9
  tag_id48
  6(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3682
  builder_id9
  tag_id19
  10(array)
  Builder(array)
  id43
  peculiarityワタルコウボウ　　　住まいのリフォーム専門店
  name航工房
  name_kanaわたるこうぼう
  branch_name
  main_area_id21
  pref_id40
  postcode8150075
  address1福岡市南区長丘3−20−5−403
  address2
  address3
  tel050-1709-1251
  fax092-873-6180
  working_hour8:00〜17:30
  holiday日曜日
  urlhttp://www.watarukoubou.com/
  defect_insurance(false)
  5year_guaranty(true)
  portfolio_count62
  reserve_flg1
  image_exterior(array)
  id26472
  modelBuilder
  model_id43
  field_nameimage_exterior
  file_name航工房様 top画像1×1用.jpg
  file_content_typeimage/jpeg
  file_size164340
  created2020-08-11 15:02:27
  modified2020-08-11 15:02:27
  file_path/var/www/riho2/app/tmp/file/Builder/43/image_exterior/航工房様 top画像1×1用.jpg
  bindedModelAttachment
  image_staff(array)
  id26473
  modelBuilder
  model_id43
  field_nameimage_staff
  file_name航工房様top画像用.JPG
  file_content_typeimage/jpeg
  file_size181518
  created2020-08-11 15:02:27
  modified2020-08-11 15:02:27
  file_path/var/www/riho2/app/tmp/file/Builder/43/image_staff/航工房様top画像用.JPG
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tags建築士がいる,太陽光発電が得意,オール電化が得意,〇〇専門店,来店予約ができる,シンプルなテイストの事例が多い,機能性重視の事例がある,おしゃれな事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id21
  pref_id40
  wide_area_id1
  name福岡市
  Work(array)
  0(array)
  id1
  name電気工事
  BuildersWork(array)
  id306
  builder_id43
  work_id1
  1(array)
  id3
  nameガス工事
  BuildersWork(array)
  id308
  builder_id43
  work_id3
  2(array)
  id4
  nameガーデン
  BuildersWork(array)
  id309
  builder_id43
  work_id4
  3(array)
  id6
  name省エネ
  BuildersWork(array)
  id310
  builder_id43
  work_id6
  4(array)
  id7
  nameリノベーション
  BuildersWork(array)
  id311
  builder_id43
  work_id7
  5(array)
  id9
  name空調工事
  BuildersWork(array)
  id312
  builder_id43
  work_id9
  6(array)
  id11
  name古民家再生
  BuildersWork(array)
  id313
  builder_id43
  work_id11
  7(array)
  id12
  nameオール電化
  BuildersWork(array)
  id314
  builder_id43
  work_id12
  8(array)
  id13
  name耐震補強
  BuildersWork(array)
  id315
  builder_id43
  work_id13
  9(array)
  id14
  nameキッチン
  BuildersWork(array)
  id316
  builder_id43
  work_id14
  10(array)
  id15
  nameバス
  BuildersWork(array)
  id317
  builder_id43
  work_id15
  11(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id318
  builder_id43
  work_id16
  12(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id319
  builder_id43
  work_id17
  13(array)
  id18
  name屋根工事
  BuildersWork(array)
  id320
  builder_id43
  work_id18
  14(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id321
  builder_id43
  work_id19
  ServiceArea(array)
  0(array)
  id3
  name飯塚市
  BuildersArea(array)
  id410
  builder_id43
  area_id3
  1(array)
  id4
  name糸島市
  BuildersArea(array)
  id412
  builder_id43
  area_id4
  2(array)
  id7
  name大野城市
  BuildersArea(array)
  id407
  builder_id43
  area_id7
  3(array)
  id10
  name春日市
  BuildersArea(array)
  id406
  builder_id43
  area_id10
  4(array)
  id14
  name古賀市
  BuildersArea(array)
  id413
  builder_id43
  area_id14
  5(array)
  id16
  name太宰府市
  BuildersArea(array)
  id408
  builder_id43
  area_id16
  6(array)
  id18
  name筑紫野市
  BuildersArea(array)
  id409
  builder_id43
  area_id18
  7(array)
  id21
  name福岡市
  BuildersArea(array)
  id405
  builder_id43
  area_id21
  8(array)
  id22
  name福津市
  BuildersArea(array)
  id414
  builder_id43
  area_id22
  9(array)
  id26
  name宗像市
  BuildersArea(array)
  id411
  builder_id43
  area_id26
  10(array)
  id79
  name那珂川市
  BuildersArea(array)
  id1096
  builder_id43
  area_id79
  Tag(array)
  0(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3074
  builder_id43
  tag_id18
  1(array)
  id4
  name太陽光発電が得意
  BuildersTag(array)
  id3075
  builder_id43
  tag_id4
  2(array)
  id16
  nameオール電化が得意
  BuildersTag(array)
  id3076
  builder_id43
  tag_id16
  3(array)
  id19
  name〇〇専門店
  BuildersTag(array)
  id3077
  builder_id43
  tag_id19
  4(array)
  id17
  name来店予約ができる
  BuildersTag(array)
  id3078
  builder_id43
  tag_id17
  5(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3079
  builder_id43
  tag_id48
  6(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3080
  builder_id43
  tag_id47
  7(array)
  id49
  nameおしゃれな事例がある
  BuildersTag(array)
  id3081
  builder_id43
  tag_id49
  11(array)
  Builder(array)
  id32
  peculiarity一生涯付き合えるパートナーショップ
  nameTOTO水彩プラザ傳株式会社(北九州小倉店)
  name_kanaとーとーすいさいぷらざ　でん　かぶしきがいしゃ　
  branch_name
  main_area_id12
  pref_id40
  postcode8060049
  address1北九州市小倉北区吉野町11-27
  address2
  address3
  tel050-1709-1241
  fax093-952-1150
  working_hour10：00〜18：00
  holiday日曜　祝日　夏季　年末年始
  urlhttp://www.suisai-den.jp/
  defect_insurance(true)
  5year_guaranty(true)
  portfolio_count49
  reserve_flg0
  image_exterior(array)
  id18351
  modelBuilder
  model_id32
  field_nameimage_exterior
  file_name店舗.jpg
  file_content_typeimage/jpeg
  file_size420828
  created2019-02-05 08:12:48
  modified2019-02-05 08:12:48
  file_path/var/www/riho2/app/tmp/file/Builder/32/image_exterior/店舗.jpg
  bindedModelAttachment
  image_staff(array)
  id18352
  modelBuilder
  model_id32
  field_nameimage_staff
  file_name店舗.jpg
  file_content_typeimage/jpeg
  file_size420828
  created2019-02-05 08:12:48
  modified2019-02-05 08:12:48
  file_path/var/www/riho2/app/tmp/file/Builder/32/image_staff/店舗.jpg
  bindedModelAttachment
  image_other1(null)
  image_other2(null)
  tagsショールームがある,建築士がいる,太陽光発電が得意,シンプルなテイストの事例が多い,機能性重視の事例がある
  Pref(array)
  id40
  name福岡県
  MainArea(array)
  id12
  pref_id40
  wide_area_id2
  name北九州市
  Work(array)
  0(array)
  id2
  name太陽光
  BuildersWork(array)
  id350
  builder_id32
  work_id2
  1(array)
  id4
  nameガーデン
  BuildersWork(array)
  id351
  builder_id32
  work_id4
  2(array)
  id8
  nameバリアフリー
  BuildersWork(array)
  id352
  builder_id32
  work_id8
  3(array)
  id12
  nameオール電化
  BuildersWork(array)
  id353
  builder_id32
  work_id12
  4(array)
  id13
  name耐震補強
  BuildersWork(array)
  id354
  builder_id32
  work_id13
  5(array)
  id14
  nameキッチン
  BuildersWork(array)
  id355
  builder_id32
  work_id14
  6(array)
  id15
  nameバス
  BuildersWork(array)
  id356
  builder_id32
  work_id15
  7(array)
  id16
  nameトイレ・洗面
  BuildersWork(array)
  id357
  builder_id32
  work_id16
  8(array)
  id17
  nameエクステリア
  BuildersWork(array)
  id358
  builder_id32
  work_id17
  9(array)
  id18
  name屋根工事
  BuildersWork(array)
  id359
  builder_id32
  work_id18
  10(array)
  id19
  name断熱外壁
  BuildersWork(array)
  id360
  builder_id32
  work_id19
  ServiceArea(array)
  0(array)
  id12
  name北九州市
  BuildersArea(array)
  id276
  builder_id32
  area_id12
  1(array)
  id14
  name古賀市
  BuildersArea(array)
  id278
  builder_id32
  area_id14
  2(array)
  id19
  name中間市
  BuildersArea(array)
  id279
  builder_id32
  area_id19
  3(array)
  id20
  name直方市
  BuildersArea(array)
  id281
  builder_id32
  area_id20
  4(array)
  id21
  name福岡市
  BuildersArea(array)
  id275
  builder_id32
  area_id21
  5(array)
  id25
  name宮若市
  BuildersArea(array)
  id282
  builder_id32
  area_id25
  6(array)
  id26
  name宗像市
  BuildersArea(array)
  id277
  builder_id32
  area_id26
  7(array)
  id31
  name行橋市
  BuildersArea(array)
  id280
  builder_id32
  area_id31
  Tag(array)
  0(array)
  id11
  nameショールームがある
  BuildersTag(array)
  id3689
  builder_id32
  tag_id11
  1(array)
  id18
  name建築士がいる
  BuildersTag(array)
  id3690
  builder_id32
  tag_id18
  2(array)
  id4
  name太陽光発電が得意
  BuildersTag(array)
  id3691
  builder_id32
  tag_id4
  3(array)
  id48
  nameシンプルなテイストの事例が多い
  BuildersTag(array)
  id3692
  builder_id32
  tag_id48
  4(array)
  id47
  name機能性重視の事例がある
  BuildersTag(array)
  id3693
  builder_id32
  tag_id47
- areas(empty)
- searchBuilders(empty)
- works(array)
  14キッチン
  15バス
  16トイレ・洗面
  20内装
  7リノベーション
  19断熱外壁
  12オール電化
  2太陽光
  6省エネ
  9空調工事
  3ガス工事
  1電気工事
  8バリアフリー
  5インテリア
  13耐震補強
  17エクステリア
  4ガーデン
  18屋根工事
  11古民家再生
  10宮大工
- wideAreas(array)
  5下関・山口エリア
  1福岡エリア
  2北九州エリア
  3筑豊エリア
  4筑後エリア
  6佐賀エリア
  7中津・大分エリア
- tags(array)
  12中古住宅が得意
  5不動産事業がある
  3新築が建てられる
  11ショールームがある
  17来店予約ができる
  4太陽光発電が得意
  16オール電化が得意
  19〇〇専門店
  18建築士がいる
- is_smartphone(false)
- baseUrl/
- $request->data(empty)
- $this->validationErrors(array)
  WideArea(empty)
  Builder(empty)
  Attachment(empty)
  Tag(empty)
  Work(empty)
  Portfolio(empty)
  Pref(empty)
  ServiceArea(empty)
  MainArea(empty)
  BuildersWork(empty)
  BuildersArea(empty)
  BuildersTag(empty)
  PickupBuilder(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	'YEXHbvQAT5q4@c72HfyOmwAAABE'
Redirect Redirect Cake Env Mode	'riho2'
Redirect Redirect Status	'200'
Redirect Unique Id	'YEXHbvQAT5q4@c72HfyOmwAAABE'
Redirect Cake Env Mode	'riho2'
Redirect Status	'200'
Unique Id	'YEXHbvQAT5q4@c72HfyOmwAAABE'
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 If Modified Since	'Tue, 01 Dec 2020 12:04:10 GMT'
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.235.11.178'
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	'50036'
Redirect Url	'/app/webroot/builders'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/builders'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1615185774.577
Request Time	(int) 1615185774

====

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/HelperCollection.php
- app(array)
  Behavior(array)
  0APP/Model/Behavior/AssociationValidationBehavior.php
  1APP/Model/Behavior/RihoBehavior.php
  2APP/Model/Behavior/HabtmValidateBehavior.php
  3APP/Model/Behavior/TagUtilityBehavior.php
  4APP/Model/Behavior/AutoIncrementBehavior.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/database.php
  Controller(array)
  0APP/Controller/BuildersController.php
  1APP/Lib/Controller/WebAppController.php
  2APP/Lib/Controller/AppController.php
  Model(array)
  0APP/Model/WideArea.php
  1APP/Lib/Model/AppModel.php
  2APP/Model/Builder.php
  3APP/Model/Tag.php
  4APP/Model/Work.php
  5APP/Model/Portfolio.php
  6APP/Model/Pref.php
  7APP/Model/Area.php
  8APP/Model/PickupBuilder.php
  Other(array)
  0APP/webroot/index.php
  1APP/Vendor/debuglib.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)
  Behavior(array)
  0Filebinder/Model/Behavior/BindableBehavior.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
====

お住まいのエリアから理想のリフォーム店を探そう！
お電話や来店予約で
お気軽に相談

エリアから検索
現在地からリフォーム店を探す

店舗を絞り込む

得意工事で絞り込む

気になるリフォーム店をチェック！
リフォーム店検索

トレンドワード

株式会社エコテックス【詳細情報へ】

LIXILリフォームショップ山﨑建材【詳細情報へ】

ホームクリエイト悠【詳細情報へ】

パワーハウス株式会社【詳細情報へ】

株式会社ハウジングプラザ本店【詳細情報へ】

中田ホームズ有限会社(本社) 【詳細情報へ】

株式会社シモセ（LIXILリフォームショップシモセ）【詳細情報へ】

株式会社大信住器【詳細情報へ】

株式会社ハウジングプラザ八幡店【詳細情報へ】

株式会社山内工務店【詳細情報へ】

航工房【詳細情報へ】

TOTO水彩プラザ傳株式会社(北九州小倉店) 【詳細情報へ】

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

全面リフォーム

水回りリフォーム

外回りリフォーム

居室リフォーム

その他リフォーム

リフォームのプロに会いに行こう。
イベント.Riho
（イベント・セミナー情報）

default

Total Time: 154 ms
Total Queries: 83 queries

Query Explain:

Memory

Timers

お住まいのエリアから理想のリフォーム店を探そう！ お電話や来店予約でお気軽に相談

エリアから検索現在地からリフォーム店を探す

店舗を絞り込む

得意工事で絞り込む

気になるリフォーム店をチェック！リフォーム店検索

トレンドワード

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

リフォームのプロに会いに行こう。イベント.Riho（イベント・セミナー情報）

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 154 ms Total Queries: 83 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

お住まいのエリアから理想のリフォーム店を探そう！
お電話や来店予約で
お気軽に相談

エリアから検索
現在地からリフォーム店を探す

気になるリフォーム店をチェック！
リフォーム店検索

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

リフォームのプロに会いに行こう。
イベント.Riho
（イベント・セミナー情報）

Total Time: 154 ms
Total Queries: 83 queries