玄関まわりの統一感が出て庇（ひさし）で濡れなくなりました！
＊ＢＥＦＯＲＥ＊
＊ＡＦＴＥＲ＊
お施主様からの一言
サッシと同色になり統一感が出ました。
雨が降っても濡れなくなり助かりました！
アドバイザーからの一言ご要望通りに仕事ができ、お客様に喜んでもらえました。
リフォーム店情報| リフォーム店名 | 地域密着型で頼れるホームアドバイザー株式会社髙岡 【詳細情報へ】
施工事例数 13件 【施工事例一覧へ】
|
|---|---|
| 住所 | 〒8111122 福岡県 福岡市早良区早良6丁目14-14 |
| 電話番号 | 050-1709-1295 |
| FAX | 092-804-6467 |
| 得意工事 |
|
| 対応可能エリア |
糸島市、春日市、福岡市、那珂川市 |
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 `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 1 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 5 | 5 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 10 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 15 | 15 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 5 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 4 | 4 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 4 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 11 | 11 | 0 | |
| SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 3 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 7 | 7 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name` FROM `riho`.`tags` AS `Tag` WHERE `Tag`.`valid_flg` = '1' AND `Tag`.`type` = 1 ORDER BY `Tag`.`type` ASC, `Tag`.`sort` ASC LIMIT 9 | 9 | 9 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 165 | 165 | 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 (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, 250, 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, 133, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 111, 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) | 182 | 182 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 107 | 107 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 64, 63, 62, 59, 58, 56, 55, 54, 52, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 212 | 212 | 1 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified`, `Builder`.`id`, `Builder`.`name`, `Adviser`.`id`, `Adviser`.`name`, `FamilyStructure`.`id`, `FamilyStructure`.`name`, `ResidenceStatus`.`id`, `ResidenceStatus`.`name` FROM `riho`.`portfolios` AS `Portfolio` LEFT JOIN `riho`.`builders` AS `Builder` ON (`Portfolio`.`builder_id` = `Builder`.`id`) LEFT JOIN `riho`.`advisers` AS `Adviser` ON (`Portfolio`.`adviser_id` = `Adviser`.`id`) LEFT JOIN `riho`.`categories` AS `FamilyStructure` ON (`Portfolio`.`family_structure` = `FamilyStructure`.`id`) LEFT JOIN `riho`.`categories` AS `ResidenceStatus` ON (`Portfolio`.`residence_status` = `ResidenceStatus`.`id`) WHERE `Portfolio`.`adviser_id` IN (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, 250, 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, 133, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 111, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 64, 63, 62, 59, 58, 56, 55, 54, 52, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 2298 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 1 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 2298 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 1 | |
| SELECT `Taste`.`id`, `Taste`.`name`, `PortfoliosTaste`.`id`, `PortfoliosTaste`.`portfolio_id`, `PortfoliosTaste`.`category_id` FROM `riho`.`categories` AS `Taste` JOIN `riho`.`portfolios_tastes` AS `PortfoliosTaste` ON (`PortfoliosTaste`.`portfolio_id` = 2298 AND `PortfoliosTaste`.`category_id` = `Taste`.`id`) | 0 | 0 | 0 | |
| SELECT `Lifestage`.`id`, `Lifestage`.`name`, `PortfoliosLifestage`.`id`, `PortfoliosLifestage`.`portfolio_id`, `PortfoliosLifestage`.`category_id` FROM `riho`.`categories` AS `Lifestage` JOIN `riho`.`portfolios_lifestages` AS `PortfoliosLifestage` ON (`PortfoliosLifestage`.`portfolio_id` = 2298 AND `PortfoliosLifestage`.`category_id` = `Lifestage`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 2298 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (2298) | 1 | 1 | 0 | |
| SELECT `PortfolioBlock`.`id`, `PortfolioBlock`.`portfolio_id`, `PortfolioBlock`.`type`, `PortfolioBlock`.`sort`, `PortfolioBlock`.`data`, `PortfolioBlock`.`view_flg`, `PortfolioBlock`.`created`, `PortfolioBlock`.`modified` FROM `riho`.`portfolio_blocks` AS `PortfolioBlock` WHERE `PortfolioBlock`.`view_flg` = '1' AND `PortfolioBlock`.`portfolio_id` = 2298 ORDER BY `PortfolioBlock`.`portfolio_id` ASC, `PortfolioBlock`.`sort` ASC | 9 | 9 | 1 | maybe slow |
| SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 16998 AND `PortfolioBlockImage`.`portfolio_id` = 2298 LIMIT 1 | 1 | 1 | 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` = 'PortfolioBlockImage' AND model_id = (16998) | 1 | 1 | 0 | |
| SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 16999 AND `PortfolioBlockImage`.`portfolio_id` = 2298 LIMIT 1 | 1 | 1 | 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` = 'PortfolioBlockImage' AND model_id = (16999) | 1 | 1 | 0 | |
| SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 17000 AND `PortfolioBlockImage`.`portfolio_id` = 2298 LIMIT 1 | 1 | 1 | 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` = 'PortfolioBlockImage' AND model_id = (17000) | 1 | 1 | 0 | |
| SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 17001 AND `PortfolioBlockImage`.`portfolio_id` = 2298 LIMIT 1 | 1 | 1 | 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` = 'PortfolioBlockImage' AND model_id = (17001) | 1 | 1 | 0 | |
| SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 17002 AND `PortfolioBlockImage`.`portfolio_id` = 2298 LIMIT 1 | 1 | 1 | 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` = 'PortfolioBlockImage' AND model_id = (17002) | 1 | 1 | 0 | |
| SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 17003 AND `PortfolioBlockImage`.`portfolio_id` = 2298 LIMIT 1 | 1 | 1 | 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` = 'PortfolioBlockImage' AND model_id = (17003) | 1 | 1 | 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' AND `Builder`.`id` = 98 ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC LIMIT 1 | 1 | 1 | 7 | 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` = 98 AND `BuildersWork`.`work_id` = `Work`.`id`) | 18 | 18 | 0 | |
| 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` = 98 AND `BuildersArea`.`area_id` = `ServiceArea`.`id`) ORDER BY `ServiceArea`.`pref_id` ASC, `ServiceArea`.`sort` ASC | 4 | 4 | 1 | 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 = (98) | 2 | 2 | 0 | |
| SELECT `Adviser`.`id`, `Adviser`.`builder_id`, `Adviser`.`name`, `Adviser`.`name_kana`, `Adviser`.`title`, `Adviser`.`subject1`, `Adviser`.`comment1`, `Adviser`.`subject2`, `Adviser`.`comment2`, `Adviser`.`hometown`, `Adviser`.`school_career`, `Adviser`.`case`, `Adviser`.`hobby`, `Adviser`.`birthday`, `Adviser`.`fb_page`, `Adviser`.`smoking_flg`, `Adviser`.`valid_flg`, `Adviser`.`created`, `Adviser`.`modified`, (SELECT COUNT(*) FROM portfolios as Portfolio WHERE (`Portfolio`.`adviser_id` = `Adviser`.`id`) AND (`Portfolio`.`valid_flg` = true)) AS `Adviser__portfolio_count` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' AND `Adviser`.`id` = 275 ORDER BY `Adviser`.`created` DESC LIMIT 1 | 1 | 1 | 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 = (275) | 1 | 1 | 0 | |
| SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8111122' LIMIT 1 | 1 | 1 | 32 | maybe slow |
| SELECT `Adviser`.`id`, `Adviser`.`builder_id`, `Adviser`.`name`, `Adviser`.`name_kana`, `Adviser`.`title`, `Adviser`.`subject1`, `Adviser`.`comment1`, `Adviser`.`subject2`, `Adviser`.`comment2`, `Adviser`.`hometown`, `Adviser`.`school_career`, `Adviser`.`case`, `Adviser`.`hobby`, `Adviser`.`birthday`, `Adviser`.`fb_page`, `Adviser`.`smoking_flg`, `Adviser`.`valid_flg`, `Adviser`.`created`, `Adviser`.`modified`, (SELECT COUNT(*) FROM portfolios as Portfolio WHERE (`Portfolio`.`adviser_id` = `Adviser`.`id`) AND (`Portfolio`.`valid_flg` = true)) AS `Adviser__portfolio_count` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`id` = 275 LIMIT 1 | 1 | 1 | 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 = (275) | 1 | 1 | 4 | maybe slow |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 165 | 165 | 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 (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, 250, 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, 133, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 111, 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) | 182 | 182 | 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, 29, 146, 156, 64, 9, 32, 16, 147, 43, 104, 34, 97, 77, 122, 72, 152, 148, 143, 125, 59, 79, 149, 10, 78, 106, 63, 52, 25, 67, 98, 74, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 151, 51, 33, 150, 137, 41, 40, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 124, 115, 73, 55, 17, 154, 133, 131, 87, 71, 68, 18, 157, 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) | 212 | 212 | 1 | |
| SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (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, 250, 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, 133, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 111, 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` = 98 AND `Portfolio`.`valid_flg` = '1' | 1 | 1 | 1 | |
| SELECT `RihoCounter`.`id`, `RihoCounter`.`begind`, `RihoCounter`.`endd`, `RihoCounter`.`subject`, `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` <= '2020-05-31'))) AND (((`RihoCounter`.`closed` IS NULL) OR (`RihoCounter`.`closed` >= '2020-05-31')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6 | 3 | 3 | 7 | 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 (687, 684, 686) | 3 | 3 | 1 | maybe slow |
3 duplicate queries run.
Peak Memory Use 4.54 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.27 MB |
| Controller action start | 2.01 MB |
| Controller render start | 3.11 MB |
| View render complete | 3.93 MB |
Total Request Time: 126 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 3.44 | |
| Event: Controller.initialize | 7.25 | |
| Event: Controller.startup | 0.13 | |
| Controller action | 34.23 | |
| Event: Controller.beforeRender | 1.17 | |
| » Processing toolbar data | 1.07 | |
| Rendering View | 68.41 | |
| » Event: View.beforeRender | 0.47 | |
| » Rendering APP/View/Portfolios/view.ctp | 57.07 | |
| » » Rendering APP/View/Elements/Web/breadcrumb.ctp | 0.18 | |
| » » Rendering APP/View/Portfolios/parts/_type_07.ctp | 0.05 | |
| » » Rendering APP/View/Portfolios/parts/_type_07.ctp #2 | 0.02 | |
| » » Rendering APP/View/Portfolios/parts/_type_07.ctp #3 | 0.02 | |
| » » Rendering APP/View/Portfolios/parts/_type_03.ctp | 0.46 | |
| » » Rendering APP/View/Portfolios/parts/_type_07.ctp #4 | 0.02 | |
| » » Rendering APP/View/Portfolios/parts/_type_02.ctp | 0.22 | |
| » » Rendering APP/View/Portfolios/parts/_type_04.ctp | 0.13 | |
| » » Rendering APP/View/Portfolios/parts/_type_09.ctp | 0.02 | |
| » » Rendering APP/View/Portfolios/parts/_type_12.ctp | 4.94 | |
| » » Rendering APP/View/Elements/Web/builder_info.ctp | 16.60 | |
| » » Rendering APP/View/Portfolios/_sidebar.ctp | 0.54 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/View/Layouts/default.ctp | 10.56 | |
| » » Rendering APP/View/Elements/Web/gdn_code.ctp | 0.02 | |
| » » Rendering APP/View/Elements/Web/header.ctp | 0.24 | |
| » » » Rendering APP/View/Elements/Web/link.ctp | 0.17 | |
| » » » Rendering APP/View/Elements/Web/phone.ctp | 0.01 | |
| » » Rendering APP/View/Elements/Web/nav_pc.ctp | 0.23 | |
| » » Rendering APP/View/Elements/Web/nav_sp.ctp | 0.23 | |
| » » Rendering APP/View/Elements/Web/events.ctp | 9.08 | |
| » » Rendering APP/View/Elements/Web/footer.ctp | 0.32 | |
| » » » Rendering APP/View/Elements/Web/link.ctp #2 | 0.19 | |
| » » » Rendering APP/View/Elements/Web/phone2.ctp | 0.02 | |
| » » Rendering APP/View/Elements/Web/ydn_code.ctp | 0.01 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | '/var/www/html/app/Config/' |
| USE_DEBUGLIB | true |
| FILE_STORAGE_STORE_PATH | '/var/www/html/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/html/app/tmp/files/' |
| AJAX_FILE_UPLOAD_TMP_PATH | '/var/www/html/app/tmp/files/cache/' |
| BLOCK_CONTENTS_PLUGIN_NAME | 'BlockContents' |
| EXPORT_PATH | '/tmp/' |
| DEFAULT_CONFIG | 'default' |
| BACKUP_ROTATE | (int) 5 |
| FILE_STORAGE_TEMPORARY | '/var/www/html/app/tmp/FileStorageTmp/' |
| FILE_STORAGE_STRAGETYPE_LOCAL | 'local' |
| FILE_STORAGE_STRAGETYPE_S3 | 's3' |
| SECURIMAGE_PATH | '/var/www/html/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/html/app/tmp/file/' |
| FILEBINDER_TMP_PATH | '/var/www/html/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://ri-ho.jp/counter' |
| RIHO_EVENT_URL | 'http://event.ri-ho.jp' |
| CONTENT_IMAGE_BASE_URL | '/images/upload/articles' |
| CONTENT_IMAGE_BASE_PATH | '/var/www/html/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 |
| Constant | Value |
|---|---|
| APP | '/var/www/html/app/' |
| APP_DIR | 'app' |
| APPLIBS | '/var/www/html/app/Lib/' |
| CACHE | '/var/www/html/app/tmp/cache/' |
| CAKE | '/var/www/html/Vendor/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/var/www/html/Vendor/cakephp/cakephp/lib' |
| CORE_PATH | '/var/www/html/Vendor/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.20' |
| CSS | '/var/www/html/app/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://ri-ho.jp' |
| IMAGES | '/var/www/html/app/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/var/www/html/app/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/var/www/html/app/tmp/logs/' |
| ROOT | '/var/www/html' |
| TESTS | '/var/www/html/app/Test/' |
| TMP | '/var/www/html/app/tmp/' |
| VENDORS | '/var/www/html/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/var/www/html/app/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.3.17' |
| Redirect Redirect Unique Id | 'XtLWaXI5VC0-IdHrsFqn8AAAAAk' |
| Redirect Redirect Cake Env Mode | 'production' |
| Redirect Redirect Https | 'on' |
| Redirect Redirect Ssl Tls Sni | 'ri-ho.jp' |
| Redirect Redirect Status | '200' |
| Redirect Unique Id | 'XtLWaXI5VC0-IdHrsFqn8AAAAAk' |
| Redirect Cake Env Mode | 'production' |
| Redirect Https | 'on' |
| Redirect Ssl Tls Sni | 'ri-ho.jp' |
| Redirect Status | '200' |
| Unique Id | 'XtLWaXI5VC0-IdHrsFqn8AAAAAk' |
| Cake Env Mode | 'production' |
| Https | 'on' |
| Ssl Tls Sni | 'ri-ho.jp' |
| Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
| Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
| Http Accept Language | 'en-US,en;q=0.5' |
| Http Accept Encoding | 'br,gzip' |
| Http Host | '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 | 'ri-ho.jp' |
| Server Addr | '153.127.48.136' |
| Server Port | '443' |
| Remote Addr | '18.206.187.81' |
| Document Root | '/var/www/html' |
| Request Scheme | 'https' |
| Context Prefix | '' |
| Context Document Root | '/var/www/html' |
| Server Admin | 'root@localhost' |
| Script Filename | '/var/www/html/app/webroot/index.php' |
| Remote Port | '53496' |
| Redirect Url | '/app/webroot/portfolios/view/2298' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/portfolios/view/2298' |
| Script Name | '/app/webroot/index.php' |
| Php Self | '/app/webroot/index.php' |
| Request Time Float | (float) 1590875753.754 |
| Request Time | (int) 1590875753 |
