| 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`.`type`, `Builder`.`name`, `Builder`.`name_kana`, `Builder`.`branch_name`, `Builder`.`peculiarity`, `Builder`.`message`, `Builder`.`sales_point`, `Builder`.`main_area_id`, `Builder`.`postcode`, `Builder`.`pref_id`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Builder`.`tel`, `Builder`.`tel_original`, `Builder`.`fax`, `Builder`.`email`, `Builder`.`working_hour`, `Builder`.`holiday`, `Builder`.`reserve_flg`, `Builder`.`reserve_start`, `Builder`.`reserve_end`, `Builder`.`reserve_holiday`, `Builder`.`5year_guaranty`, `Builder`.`defect_insurance`, `Builder`.`credit_card`, `Builder`.`building_license_no`, `Builder`.`organization`, `Builder`.`url`, `Builder`.`winning_prize`, `Builder`.`organization_year`, `Builder`.`president_post`, `Builder`.`president_name`, `Builder`.`employees`, `Builder`.`capital_stock`, `Builder`.`corporate_philosophy`, `Builder`.`latitude`, `Builder`.`longitude`, `Builder`.`valid_flg`, `Builder`.`created`, `Builder`.`modified`, `Pref`.`id`, `Pref`.`name`, `MainArea`.`id`, `MainArea`.`pref_id`, `MainArea`.`wide_area_id`, `MainArea`.`name` FROM `riho`.`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` = 11 ORDER BY `Builder`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `Adviser`.`id`, `Adviser`.`builder_id`, `Adviser`.`name` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' AND `Adviser`.`builder_id` = (11) ORDER BY `Adviser`.`modified` DESC | 5 | 5 | 0 | |
| SELECT `Meister`.`id`, `Meister`.`builder_id`, `Meister`.`name` FROM `riho`.`meisters` AS `Meister` WHERE `Meister`.`builder_id` = (11) | 0 | 0 | 0 | |
| SELECT `Package`.`id`, `Package`.`builder_id`, `Package`.`price`, `Package`.`subject` FROM `riho`.`packages` AS `Package` WHERE `Package`.`valid_flg` = '1' AND `Package`.`builder_id` = (11) ORDER BY `Package`.`id` ASC | 0 | 0 | 0 | |
| 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` = 11 AND `BuildersWork`.`work_id` = `Work`.`id`) | 6 | 6 | 1 | maybe slow |
| SELECT `ServicePref`.`id`, `ServicePref`.`name`, `BuildersPref`.`id`, `BuildersPref`.`builder_id`, `BuildersPref`.`pref_id` FROM `riho`.`prefs` AS `ServicePref` JOIN `riho`.`builders_prefs` AS `BuildersPref` ON (`BuildersPref`.`builder_id` = 11 AND `BuildersPref`.`pref_id` = `ServicePref`.`id`) ORDER BY `ServicePref`.`id` ASC | 1 | 1 | 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` = 11 AND `BuildersArea`.`area_id` = `ServiceArea`.`id`) ORDER BY `ServiceArea`.`pref_id` ASC, `ServiceArea`.`sort` ASC | 1 | 1 | 0 | |
| 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` = 11 AND `BuildersTag`.`tag_id` = `Tag`.`id`) ORDER BY `BuildersTag`.`id` ASC | 6 | 6 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND model_id = (11) | 2 | 2 | 1 | maybe slow |
| SELECT `Meister`.`id`, `Meister`.`builder_id`, `Meister`.`work`, `Meister`.`name`, `Meister`.`name_kana`, `Meister`.`title`, `Meister`.`school_career`, `Meister`.`birthday`, `Meister`.`subject`, `Meister`.`comment`, `Meister`.`hometown`, `Meister`.`smoking_flg`, `Meister`.`career`, `Meister`.`motto`, `Meister`.`family`, `Meister`.`specialty`, `Meister`.`hobby`, `Meister`.`comment2`, `Meister`.`valid_flg`, `Meister`.`created`, `Meister`.`modified` FROM `riho`.`meisters` AS `Meister` WHERE `Meister`.`valid_flg` = '1' AND `Meister`.`id` IS NULL ORDER BY `Meister`.`id` ASC | 0 | 0 | 0 | |
| SELECT `Meister`.`id`, `Meister`.`builder_id`, `Meister`.`work`, `Meister`.`name`, `Meister`.`name_kana`, `Meister`.`title`, `Meister`.`school_career`, `Meister`.`birthday`, `Meister`.`subject`, `Meister`.`comment`, `Meister`.`hometown`, `Meister`.`smoking_flg`, `Meister`.`career`, `Meister`.`motto`, `Meister`.`family`, `Meister`.`specialty`, `Meister`.`hobby`, `Meister`.`comment2`, `Meister`.`valid_flg`, `Meister`.`created`, `Meister`.`modified` FROM `riho`.`meisters` AS `Meister` WHERE `Meister`.`valid_flg` = '1' AND `Meister`.`id` IS NULL ORDER BY rand() ASC LIMIT 1 | 0 | 0 | 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` IN (42, 21, 20, 19, 18) ORDER BY rand() ASC LIMIT 1 | 1 | 1 | 2 | maybe slow |
| SELECT `License`.`id`, `License`.`name`, `AdvisersLicense`.`id`, `AdvisersLicense`.`adviser_id`, `AdvisersLicense`.`license_id` FROM `riho`.`licenses` AS `License` JOIN `riho`.`advisers_licenses` AS `AdvisersLicense` ON (`AdvisersLicense`.`adviser_id` = 42 AND `AdvisersLicense`.`license_id` = `License`.`id`) | 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 = (42) | 1 | 1 | 1 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 1 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 8 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 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 (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 4 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` = 11 AND `Portfolio`.`valid_flg` = '1' ORDER BY `Portfolio`.`created` DESC LIMIT 15 | 15 | 15 | 2 | 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` = 'Portfolio' AND `model_id` IN (1236, 1235, 1227, 1102, 1101, 1052, 1046, 1045, 743, 742, 741, 740, 739, 738, 737) | 15 | 15 | 1 | maybe slow |
| SELECT `Event`.`id`, `Event`.`builder_id`, `Event`.`type`, `Event`.`eventd`, `Event`.`opend`, `Event`.`closed`, `Event`.`subject`, `Event`.`comment`, `Event`.`postcode`, `Event`.`pref_id`, `Event`.`address1`, `Event`.`address2`, `Event`.`address3`, `Event`.`adviser_id`, `Event`.`adviser_comment`, `Event`.`valid_flg`, `Event`.`created`, `Event`.`modified` FROM `riho`.`events` AS `Event` WHERE `Event`.`valid_flg` = '1' AND ((((`Event`.`opend` IS NULL) OR (`Event`.`opend` <= '2021-04-19'))) AND (((`Event`.`closed` IS NULL) OR (`Event`.`closed` >= '2021-04-19')))) AND `Event`.`builder_id` = 11 ORDER BY `Event`.`eventd` DESC LIMIT 3 | 0 | 0 | 1 | maybe slow |
| SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8060023' LIMIT 1 | 1 | 1 | 33 | 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` = 42 LIMIT 1 | 1 | 1 | 1 | |
| SELECT `License`.`id`, `License`.`name`, `AdvisersLicense`.`id`, `AdvisersLicense`.`adviser_id`, `AdvisersLicense`.`license_id` FROM `riho`.`licenses` AS `License` JOIN `riho`.`advisers_licenses` AS `AdvisersLicense` ON (`AdvisersLicense`.`adviser_id` = 42 AND `AdvisersLicense`.`license_id` = `License`.`id`) | 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 = (42) | 1 | 1 | 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`.`id` = 21 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `License`.`id`, `License`.`name`, `AdvisersLicense`.`id`, `AdvisersLicense`.`adviser_id`, `AdvisersLicense`.`license_id` FROM `riho`.`licenses` AS `License` JOIN `riho`.`advisers_licenses` AS `AdvisersLicense` ON (`AdvisersLicense`.`adviser_id` = 21 AND `AdvisersLicense`.`license_id` = `License`.`id`) | 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` = 'Adviser' AND model_id = (21) | 1 | 1 | 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`.`id` = 20 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `License`.`id`, `License`.`name`, `AdvisersLicense`.`id`, `AdvisersLicense`.`adviser_id`, `AdvisersLicense`.`license_id` FROM `riho`.`licenses` AS `License` JOIN `riho`.`advisers_licenses` AS `AdvisersLicense` ON (`AdvisersLicense`.`adviser_id` = 20 AND `AdvisersLicense`.`license_id` = `License`.`id`) | 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 = (20) | 1 | 1 | 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`.`id` = 19 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `License`.`id`, `License`.`name`, `AdvisersLicense`.`id`, `AdvisersLicense`.`adviser_id`, `AdvisersLicense`.`license_id` FROM `riho`.`licenses` AS `License` JOIN `riho`.`advisers_licenses` AS `AdvisersLicense` ON (`AdvisersLicense`.`adviser_id` = 19 AND `AdvisersLicense`.`license_id` = `License`.`id`) | 4 | 4 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND model_id = (19) | 1 | 1 | 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`.`id` = 18 LIMIT 1 | 1 | 1 | 0 | |
| SELECT `License`.`id`, `License`.`name`, `AdvisersLicense`.`id`, `AdvisersLicense`.`adviser_id`, `AdvisersLicense`.`license_id` FROM `riho`.`licenses` AS `License` JOIN `riho`.`advisers_licenses` AS `AdvisersLicense` ON (`AdvisersLicense`.`adviser_id` = 18 AND `AdvisersLicense`.`license_id` = `License`.`id`) | 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 = (18) | 4 | 4 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1236 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1236 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1236 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 4 | 4 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1236) | 1 | 1 | 0 | |
| SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8080000' LIMIT 1 | 1 | 1 | 32 | maybe slow |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 1 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1235 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1235 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1235 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 10 | 10 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1235) | 1 | 1 | 0 | |
| SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8000000' LIMIT 1 | 1 | 1 | 32 | maybe slow |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 1 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1227 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1227 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1227 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 10 | 10 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1227) | 1 | 1 | 0 | |
| SELECT `Zipcode`.`id`, `Zipcode`.`pref_id`, `Zipcode`.`zip`, `Zipcode`.`jis`, `Zipcode`.`addr1`, `Zipcode`.`addr2`, `Zipcode`.`addr3` FROM `riho`.`zipcodes` AS `Zipcode` WHERE `Zipcode`.`zip` = '8060000' LIMIT 1 | 1 | 1 | 33 | maybe slow |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 1 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1102 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1102 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1102 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 7 | 7 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1102) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1101 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1101 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1101 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 7 | 7 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1101) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1052 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1052 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1052 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 4 | 4 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1052) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1046 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1046 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1046 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 3 | 3 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1046) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 1045 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 1045 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 1045 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 2 | 2 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (1045) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 743 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 743 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 743 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 7 | 7 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (743) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 742 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 742 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 742 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 6 | 6 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (742) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 741 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 741 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 741 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 3 | 3 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (741) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 740 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` = 740 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 740 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 2 | 2 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (740) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 739 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 739 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 739 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 2 | 2 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (739) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 738 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` = 738 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 738 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 2 | 2 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (738) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT `Portfolio`.`id`, `Portfolio`.`builder_id`, `Portfolio`.`adviser_id`, `Portfolio`.`subject`, `Portfolio`.`headline_subject`, `Portfolio`.`headline`, `Portfolio`.`family_structure`, `Portfolio`.`residence_status`, `Portfolio`.`populated_place`, `Portfolio`.`construction_area`, `Portfolio`.`building_age`, `Portfolio`.`construction_period`, `Portfolio`.`budget`, `Portfolio`.`renovation_part`, `Portfolio`.`cost`, `Portfolio`.`postcode`, `Portfolio`.`areaname`, `Portfolio`.`adviser_comment`, `Portfolio`.`discrimination`, `Portfolio`.`top_view_flg`, `Portfolio`.`valid_flg`, `Portfolio`.`created`, `Portfolio`.`modified` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 737 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
| SELECT `ReformCategory`.`id`, `ReformCategory`.`name`, `PortfoliosReformCategory`.`id`, `PortfoliosReformCategory`.`portfolio_id`, `PortfoliosReformCategory`.`reform_category_id` FROM `riho`.`reform_categories` AS `ReformCategory` JOIN `riho`.`portfolios_reform_categories` AS `PortfoliosReformCategory` ON (`PortfoliosReformCategory`.`portfolio_id` = 737 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
| SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 737 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 4 | 4 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (737) | 1 | 1 | 0 | |
| SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 168 | 168 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND `model_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) | 185 | 185 | 2 | |
| SELECT `Builder`.`id` FROM `riho`.`builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`created` DESC | 109 | 109 | 0 | |
| SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) | 217 | 217 | 2 | |
| SELECT COUNT(*) AS `count` FROM `riho`.`portfolios` AS `Portfolio` WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` = 11 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-04-19'))) AND (((`RihoCounter`.`endd` IS NULL) OR (`RihoCounter`.`endd` >= '2021-04-19')))) AND `RihoCounter`.`event_permanent_flg` = '0' ORDER BY `RihoCounter`.`endd` ASC LIMIT 6 | 6 | 6 | 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 (886, 889, 884, 881, 872, 873) | 6 | 6 | 1 | maybe slow |
66 duplicate queries run.
お問い合わせ
リフォームアドバイザー
最新の施工事例
