リフォーム店名 | リフォーム・太陽光発電のエキスパート株式会社エコテックス 【詳細情報へ】
施工事例数 260件 【施工事例一覧へ】
|
---|---|
住所 | 〒8140175 福岡県 福岡市早良区田村2丁目11-4 |
電話番号 | 050-1709-1244 (営業時間:9:00~20:00 定休日:毎週月曜日・夏季休業・年末年始) |
FAX | 092-874-4171 |
得意工事 |
|
対応可能エリア |
朝倉市、糸島市、小郡市、大野城市、春日市、久留米市、古賀市、太宰府市、筑紫野市、福岡市、福津市、宗像市、那珂川市 |
リフォーム店名 | 全国400社が加盟するLIXILリフォームチェーンのCSコンテストで全国第一位に選ばれました!!LIXILリフォームショップ山﨑建材 【詳細情報へ】
施工事例数 142件 【施工事例一覧へ】
|
---|---|
住所 | 〒8060023 福岡県 北九州市八幡西区八千代町11−11 |
電話番号 | 050-1709-1219 (営業時間:8:00~17:00 定休日:日曜日・祝日) |
FAX | 093-642-5530 |
得意工事 |
|
対応可能エリア |
北九州市 |
リフォーム店名 | 住まいの「困った」をご相談ください。ホームクリエイト悠 【詳細情報へ】
施工事例数 100件 【施工事例一覧へ】
|
---|---|
住所 | 〒8111302 福岡県 福岡市南区井尻4丁目7-19 |
電話番号 | 050-1709-1247 (営業時間:9:00〜18:00 定休日:日・祝日) |
FAX | 092-586-5204 |
得意工事 |
|
対応可能エリア |
糸島市、小郡市、大野城市、春日市、北九州市、久留米市、古賀市、太宰府市、筑紫野市、福岡市、宗像市、那珂川市 |
リフォーム店名 | 福岡本店、三苫・塩浜通り店、宗像店/モデルハウス、福津店、志免店の5店舗展開!パワーハウス株式会社 【詳細情報へ】
施工事例数 90件 【施工事例一覧へ】
|
---|---|
住所 | 〒8130031 福岡県 福岡市東区八田 2丁目21番28号 |
電話番号 | 050-1709-1233 (営業時間:8:00 ~ 19:00 定休日:なし) |
FAX | 092-691-8810 |
得意工事 |
|
対応可能エリア |
遠賀郡、古賀市、糟屋郡、福岡市、福津市、宗像市 |
リフォーム店名 | 「しあわせづくりを住まいから」 真心込めてお手伝いします。株式会社ハウジングプラザ 本店 【詳細情報へ】
施工事例数 87件 【施工事例一覧へ】
|
---|---|
住所 | 〒8010851 福岡県 北九州市門司区東本町2丁目1-2 |
電話番号 | 050-2019-4562 (営業時間:9:00〜17:00 定休日:毎週火・水曜日) |
FAX | 093-332-6677 |
得意工事 |
|
対応可能エリア |
下関市、北九州市、京都郡、行橋市 |
リフォーム店名 | 住まいプランナー中田ホームズ有限会社(本社) 【詳細情報へ】
施工事例数 87件 【施工事例一覧へ】
|
---|---|
住所 | 〒8230003 福岡県 宮若市本城1090-5 |
電話番号 | 050-1709-1227 (営業時間:8:00~17:00 定休日:日曜・祭日・夏季・年末年始) |
FAX | 0949-32-3919 |
得意工事 |
|
対応可能エリア |
飯塚市、嘉麻市、北九州市、鞍手郡、直方市、宮若市、宗像市 |
リフォーム店名 | 住まいのことなら株式会社シモセ(LIXILリフォームショップ シモセ) 【詳細情報へ】
施工事例数 79件 【施工事例一覧へ】
|
---|---|
住所 | 〒8710111 大分県 中津市三光佐知1032番地イオンモール三光 |
電話番号 | 050-2019-7686 (営業時間:10:00~21:00 定休日:年中無休) |
FAX | 0979-27-7686 |
得意工事 |
|
対応可能エリア |
豊前市、築上郡、中津市、宇佐市 |
リフォーム店名 | 水廻りリフォーム専門店株式会社大信住器 【詳細情報へ】
施工事例数 79件 【施工事例一覧へ】
|
---|---|
住所 | 〒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件 【施工事例一覧へ】
|
---|---|
住所 | 〒8030836 福岡県 北九州市小倉北区中井4丁目9−10(小倉店) 北九州市八幡西区萩原1丁目3-31(八幡西店) |
電話番号 | 050-1709-1288 (営業時間:9:00~17:00 定休日:水曜日・第1日曜日) |
FAX | 093-562-0405 |
得意工事 |
|
対応可能エリア |
遠賀郡、北九州市、中間市 |
リフォーム店名 | ワタルコウボウ 住まいのリフォーム専門店航工房 【詳細情報へ】
施工事例数 62件 【施工事例一覧へ】
|
---|---|
住所 | 〒8150075 福岡県 福岡市南区長丘3−20−5−403 |
電話番号 | 050-1709-1251 (営業時間:8:00〜17:30 定休日:日曜日) |
FAX | 092-873-6180 |
得意工事 |
|
対応可能エリア |
飯塚市、糸島市、大野城市、春日市、古賀市、太宰府市、筑紫野市、福岡市、福津市、宗像市、那珂川市 |
リフォーム店名 | 一生涯付き合えるパートナーショップTOTO水彩プラザ傳株式会社(北九州小倉店) 【詳細情報へ】
施工事例数 49件 【施工事例一覧へ】
|
---|---|
住所 | 〒8060049 福岡県 北九州市小倉北区吉野町11-27 |
電話番号 | 050-1709-1241 (営業時間:10:00〜18:00 定休日:日曜 祝日 夏季 年末年始) |
FAX | 093-952-1150 |
得意工事 |
|
対応可能エリア |
北九州市、古賀市、中間市、直方市、福岡市、宮若市、宗像市、行橋市 |
1~12件(全107件)
No post data.
No querystring data.
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.
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 |
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 |
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' |
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/' |
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 |