Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `WideArea`.`id`, `WideArea`.`name` FROM `riho`.`wide_areas` AS `WideArea` WHERE `WideArea`.`valid_flg` = '1' ORDER BY `WideArea`.`pref_id` ASC, `WideArea`.`sort` ASC | 7 | 7 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 1 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 5 | 5 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 10 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 15 | 15 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 5 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 4 | 4 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 4 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 11 | 11 | 0 | |
SELECT `Category`.`id`, `Category`.`name` FROM `riho`.`categories` AS `Category` WHERE `Category`.`valid_flg` = '1' AND `Category`.`type` = 3 ORDER BY `Category`.`type` ASC, `Category`.`sort` ASC | 7 | 7 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name` FROM `riho`.`tags` AS `Tag` WHERE `Tag`.`valid_flg` = '1' AND `Tag`.`type` = 1 ORDER BY `Tag`.`type` ASC, `Tag`.`sort` ASC LIMIT 9 | 9 | 9 | 0 | |
SELECT `Adviser`.`id` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' ORDER BY `Adviser`.`created` DESC | 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 | 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 | 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`, `Builder`.`id`, `Builder`.`name`, `Adviser`.`id`, `Adviser`.`name`, `FamilyStructure`.`id`, `FamilyStructure`.`name`, `ResidenceStatus`.`id`, `ResidenceStatus`.`name` FROM `riho`.`portfolios` AS `Portfolio` LEFT JOIN `riho`.`builders` AS `Builder` ON (`Portfolio`.`builder_id` = `Builder`.`id`) LEFT JOIN `riho`.`advisers` AS `Adviser` ON (`Portfolio`.`adviser_id` = `Adviser`.`id`) LEFT JOIN `riho`.`categories` AS `FamilyStructure` ON (`Portfolio`.`family_structure` = `FamilyStructure`.`id`) LEFT JOIN `riho`.`categories` AS `ResidenceStatus` ON (`Portfolio`.`residence_status` = `ResidenceStatus`.`id`) WHERE `Portfolio`.`adviser_id` IN (312, 311, 310, 309, 308, 307, 306, 305, 304, 303, 302, 301, 300, 299, 298, 296, 295, 294, 293, 291, 289, 288, 287, 286, 283, 282, 281, 279, 278, 277, 276, 275, 272, 271, 266, 264, 263, 261, 260, 259, 258, 257, 256, 255, 253, 252, 251, 249, 248, 247, 246, 243, 242, 240, 239, 238, 237, 236, 235, 234, 233, 232, 230, 227, 222, 221, 220, 219, 218, 217, 216, 214, 213, 212, 209, 207, 206, 203, 200, 186, 185, 182, 181, 173, 170, 169, 168, 167, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 151, 150, 148, 143, 142, 141, 140, 138, 137, 136, 135, 134, 131, 126, 125, 122, 120, 119, 118, 117, 115, 113, 112, 110, 109, 108, 107, 106, 105, 104, 103, 101, 100, 99, 98, 97, 96, 94, 93, 92, 91, 89, 83, 82, 80, 78, 77, 76, 68, 62, 61, 60, 56, 55, 54, 52, 45, 44, 43, 42, 31, 25, 21, 20, 19, 18, 16, 14) AND `Portfolio`.`builder_id` IN (164, 162, 161, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 148, 147, 146, 145, 144, 143, 141, 139, 137, 136, 135, 134, 133, 132, 131, 130, 129, 128, 127, 126, 125, 123, 122, 119, 117, 115, 113, 112, 111, 108, 106, 105, 104, 101, 98, 97, 95, 89, 87, 86, 81, 80, 79, 78, 77, 75, 74, 73, 72, 71, 68, 67, 65, 63, 62, 59, 58, 56, 55, 54, 51, 49, 48, 47, 46, 44, 43, 42, 41, 40, 39, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 26, 25, 22, 21, 20, 18, 17, 16, 15, 13, 12, 11, 10, 9) AND `Portfolio`.`valid_flg` = '1' AND `Portfolio`.`id` = 538 ORDER BY `Portfolio`.`created` DESC LIMIT 1 | 1 | 1 | 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` = 538 AND `PortfoliosReformCategory`.`reform_category_id` = `ReformCategory`.`id`) | 1 | 1 | 0 | |
SELECT `Taste`.`id`, `Taste`.`name`, `PortfoliosTaste`.`id`, `PortfoliosTaste`.`portfolio_id`, `PortfoliosTaste`.`category_id` FROM `riho`.`categories` AS `Taste` JOIN `riho`.`portfolios_tastes` AS `PortfoliosTaste` ON (`PortfoliosTaste`.`portfolio_id` = 538 AND `PortfoliosTaste`.`category_id` = `Taste`.`id`) | 1 | 1 | 0 | |
SELECT `Lifestage`.`id`, `Lifestage`.`name`, `PortfoliosLifestage`.`id`, `PortfoliosLifestage`.`portfolio_id`, `PortfoliosLifestage`.`category_id` FROM `riho`.`categories` AS `Lifestage` JOIN `riho`.`portfolios_lifestages` AS `PortfoliosLifestage` ON (`PortfoliosLifestage`.`portfolio_id` = 538 AND `PortfoliosLifestage`.`category_id` = `Lifestage`.`id`) | 0 | 0 | 0 | |
SELECT `Tag`.`id`, `Tag`.`name`, `PortfoliosTag`.`id`, `PortfoliosTag`.`portfolio_id`, `PortfoliosTag`.`tag_id` FROM `riho`.`tags` AS `Tag` JOIN `riho`.`portfolios_tags` AS `PortfoliosTag` ON (`PortfoliosTag`.`portfolio_id` = 538 AND `PortfoliosTag`.`tag_id` = `Tag`.`id`) ORDER BY `PortfoliosTag`.`id` ASC | 6 | 6 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Portfolio' AND model_id = (538) | 1 | 1 | 1 | |
SELECT `PortfolioBlock`.`id`, `PortfolioBlock`.`portfolio_id`, `PortfolioBlock`.`type`, `PortfolioBlock`.`sort`, `PortfolioBlock`.`data`, `PortfolioBlock`.`view_flg`, `PortfolioBlock`.`created`, `PortfolioBlock`.`modified` FROM `riho`.`portfolio_blocks` AS `PortfolioBlock` WHERE `PortfolioBlock`.`view_flg` = '1' AND `PortfolioBlock`.`portfolio_id` = 538 ORDER BY `PortfolioBlock`.`portfolio_id` ASC, `PortfolioBlock`.`sort` ASC | 5 | 5 | 1 | maybe slow |
SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 2204 AND `PortfolioBlockImage`.`portfolio_id` = 538 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'PortfolioBlockImage' AND model_id = (2204) | 1 | 1 | 0 | |
SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 2200 AND `PortfolioBlockImage`.`portfolio_id` = 538 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'PortfolioBlockImage' AND model_id = (2200) | 1 | 1 | 0 | |
SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 2205 AND `PortfolioBlockImage`.`portfolio_id` = 538 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'PortfolioBlockImage' AND model_id = (2205) | 1 | 1 | 0 | |
SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 2201 AND `PortfolioBlockImage`.`portfolio_id` = 538 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'PortfolioBlockImage' AND model_id = (2201) | 1 | 1 | 0 | |
SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 2206 AND `PortfolioBlockImage`.`portfolio_id` = 538 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'PortfolioBlockImage' AND model_id = (2206) | 1 | 1 | 0 | |
SELECT `PortfolioBlockImage`.`id`, `PortfolioBlockImage`.`portfolio_id`, `PortfolioBlockImage`.`created`, `PortfolioBlockImage`.`modified` FROM `riho`.`portfolio_block_images` AS `PortfolioBlockImage` WHERE `PortfolioBlockImage`.`id` = 2202 AND `PortfolioBlockImage`.`portfolio_id` = 538 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'PortfolioBlockImage' AND model_id = (2202) | 1 | 1 | 0 | |
SELECT `Builder`.`id`, `Builder`.`peculiarity`, `Builder`.`name`, `Builder`.`name_kana`, `Builder`.`branch_name`, `Builder`.`main_area_id`, `Builder`.`pref_id`, `Builder`.`postcode`, `Builder`.`address1`, `Builder`.`address2`, `Builder`.`address3`, `Builder`.`tel`, `Builder`.`fax`, `Builder`.`working_hour`, `Builder`.`holiday`, `Builder`.`url`, `Builder`.`defect_insurance`, `Builder`.`5year_guaranty`, `Builder`.`portfolio_count`, `Builder`.`reserve_flg`, `Pref`.`id`, `Pref`.`name`, `MainArea`.`id`, `MainArea`.`pref_id`, `MainArea`.`wide_area_id`, `MainArea`.`name` FROM `riho`.`v_builders` AS `Builder` LEFT JOIN `riho`.`prefs` AS `Pref` ON (`Builder`.`pref_id` = `Pref`.`id`) LEFT JOIN `riho`.`areas` AS `MainArea` ON (`Builder`.`main_area_id` = `MainArea`.`id`) WHERE `Builder`.`valid_flg` = '1' AND `Builder`.`id` = 11 ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC LIMIT 1 | 1 | 1 | 8 | maybe slow |
SELECT `Work`.`id`, `Work`.`name`, `BuildersWork`.`id`, `BuildersWork`.`builder_id`, `BuildersWork`.`work_id` FROM `riho`.`works` AS `Work` JOIN `riho`.`builders_works` AS `BuildersWork` ON (`BuildersWork`.`builder_id` = 11 AND `BuildersWork`.`work_id` = `Work`.`id`) | 6 | 6 | 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 | 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 = (11) | 2 | 2 | 0 | |
SELECT `Adviser`.`id`, `Adviser`.`builder_id`, `Adviser`.`name`, `Adviser`.`name_kana`, `Adviser`.`title`, `Adviser`.`subject1`, `Adviser`.`comment1`, `Adviser`.`subject2`, `Adviser`.`comment2`, `Adviser`.`hometown`, `Adviser`.`school_career`, `Adviser`.`case`, `Adviser`.`hobby`, `Adviser`.`birthday`, `Adviser`.`fb_page`, `Adviser`.`smoking_flg`, `Adviser`.`valid_flg`, `Adviser`.`created`, `Adviser`.`modified`, (SELECT COUNT(*) FROM portfolios as Portfolio WHERE (`Portfolio`.`adviser_id` = `Adviser`.`id`) AND (`Portfolio`.`valid_flg` = true)) AS `Adviser__portfolio_count` FROM `riho`.`advisers` AS `Adviser` WHERE `Adviser`.`valid_flg` = '1' AND `Adviser`.`id` = 18 ORDER BY `Adviser`.`created` DESC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Adviser' AND model_id = (18) | 4 | 4 | 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 `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`.`v_builders` AS `Builder` WHERE `Builder`.`valid_flg` = '1' ORDER BY `Builder`.`portfolio_count` DESC, `Builder`.`created` DESC | 109 | 109 | 5 | |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'Builder' AND `model_id` IN (35, 11, 39, 22, 145, 15, 156, 29, 9, 146, 43, 32, 16, 147, 104, 34, 125, 97, 77, 122, 72, 152, 148, 143, 59, 79, 149, 10, 98, 78, 25, 106, 63, 74, 67, 46, 117, 36, 135, 56, 13, 130, 108, 49, 44, 159, 151, 51, 33, 150, 137, 41, 40, 157, 132, 126, 48, 47, 111, 81, 75, 37, 12, 141, 62, 42, 136, 115, 73, 55, 17, 164, 162, 154, 133, 131, 87, 71, 68, 18, 161, 158, 155, 153, 144, 139, 134, 129, 128, 127, 123, 119, 113, 112, 105, 101, 95, 89, 86, 80, 65, 58, 54, 31, 30, 28, 26, 21, 20) | 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 | 9 | maybe slow |
SELECT `Attachment`.`id`, `Attachment`.`model`, `Attachment`.`model_id`, `Attachment`.`field_name`, `Attachment`.`file_name`, `Attachment`.`file_content_type`, `Attachment`.`file_size`, `Attachment`.`created`, `Attachment`.`modified` FROM `riho`.`attachments` AS `Attachment` WHERE `model` = 'RihoCounter' AND `model_id` IN (886, 889, 884, 881, 872, 873) | 6 | 6 | 1 | maybe slow |
3 duplicate queries run.