| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `KenzaiFirstCategory`.`id`, `KenzaiFirstCategory`.`kenzai_top_category_id`, `KenzaiFirstCategory`.`name`, `KenzaiFirstCategory`.`sort_order`, `KenzaiFirstCategory`.`status`, `KenzaiFirstCategory`.`created`, `KenzaiFirstCategory`.`modified`, `KenzaiTopCategory`.`id`, `KenzaiTopCategory`.`name`, `KenzaiTopCategory`.`sort_order`, `KenzaiTopCategory`.`status`, `KenzaiTopCategory`.`created`, `KenzaiTopCategory`.`modified` FROM `LAA0559170-flab`.`kenzai_first_categories` AS `KenzaiFirstCategory` LEFT JOIN `LAA0559170-flab`.`kenzai_top_categories` AS `KenzaiTopCategory` ON (`KenzaiFirstCategory`.`kenzai_top_category_id` = `KenzaiTopCategory`.`id`) WHERE `KenzaiFirstCategory`.`id` = 4 LIMIT 1 | 1 | 1 | 10 | maybe slow |
| SELECT `KenzaiSecondCategory`.`id`, `KenzaiSecondCategory`.`kenzai_first_category_id`, `KenzaiSecondCategory`.`name`, `KenzaiSecondCategory`.`sort_order`, `KenzaiSecondCategory`.`status`, `KenzaiSecondCategory`.`created`, `KenzaiSecondCategory`.`modified` FROM `LAA0559170-flab`.`kenzai_second_categories` AS `KenzaiSecondCategory` WHERE `KenzaiSecondCategory`.`kenzai_first_category_id` = (4) | 10 | 10 | 10 | |
| SELECT `Color`.`id`, `Color`.`name`, `Color`.`sort_order`, `Color`.`status`, `Color`.`created`, `Color`.`modified` FROM `LAA0559170-flab`.`colors` AS `Color` WHERE `Color`.`id` = 3 LIMIT 1 | 1 | 1 | 11 | maybe slow |
| SELECT `KenzaiColor`.`id`, `KenzaiColor`.`kenzai_id`, `KenzaiColor`.`color_id`, `KenzaiColor`.`created`, `KenzaiColor`.`modified`, `Kenzai`.`id`, `Kenzai`.`name`, `Kenzai`.`maker_id`, `Kenzai`.`kenzai_top_category_id`, `Kenzai`.`kenzai_first_category_id`, `Kenzai`.`kenzai_second_category_id`, `Kenzai`.`zaishitsu_id`, `Kenzai`.`price_type_id`, `Kenzai`.`formal_price`, `Kenzai`.`real_price`, `Kenzai`.`unit`, `Kenzai`.`price_from_flag`, `Kenzai`.`image1_file_name`, `Kenzai`.`image2_file_name`, `Kenzai`.`image3_file_name`, `Kenzai`.`image4_file_name`, `Kenzai`.`image5_file_name`, `Kenzai`.`description`, `Kenzai`.`keyword1`, `Kenzai`.`keyword2`, `Kenzai`.`keyword3`, `Kenzai`.`keyword4`, `Kenzai`.`keyword5`, `Kenzai`.`keyword6`, `Kenzai`.`rfa_file_name`, `Kenzai`.`rvt_file_name`, `Kenzai`.`ifc_file_name`, `Kenzai`.`maker_page_url`, `Kenzai`.`sekou_image1_file_name`, `Kenzai`.`sekou_image2_file_name`, `Kenzai`.`sekou_image3_file_name`, `Kenzai`.`sekou_image4_file_name`, `Kenzai`.`sekou_image5_file_name`, `Kenzai`.`sekou_image6_file_name`, `Kenzai`.`sekou_image7_file_name`, `Kenzai`.`sekou_image8_file_name`, `Kenzai`.`sekou_image9_file_name`, `Kenzai`.`sekou_image10_file_name`, `Kenzai`.`often_used_flg`, `Kenzai`.`status`, `Kenzai`.`view_count`, `Kenzai`.`download_count`, `Kenzai`.`favorite_count`, `Kenzai`.`kuchikomi_count`, `Kenzai`.`appearance_point`, `Kenzai`.`practicability_point`, `Kenzai`.`cost_performance_point`, `Kenzai`.`memo`, `Kenzai`.`created`, `Kenzai`.`modified`, `Color`.`id`, `Color`.`name`, `Color`.`sort_order`, `Color`.`status`, `Color`.`created`, `Color`.`modified` FROM `LAA0559170-flab`.`kenzai_colors` AS `KenzaiColor` LEFT JOIN `LAA0559170-flab`.`kenzais` AS `Kenzai` ON (`KenzaiColor`.`kenzai_id` = `Kenzai`.`id`) LEFT JOIN `LAA0559170-flab`.`colors` AS `Color` ON (`KenzaiColor`.`color_id` = `Color`.`id`) WHERE `Kenzai`.`kenzai_first_category_id` = 4 AND `Kenzai`.`status` = 1 AND `KenzaiColor`.`color_id` = 3 ORDER BY ( `Kenzai`.`appearance_point` + `Kenzai`.`practicability_point` + `Kenzai`.`cost_performance_point`) desc, `Kenzai`.`created` desc LIMIT 10 | 0 | 0 | 12 | maybe slow |
| SELECT `Detail`.`id`, `Detail`.`name`, `Detail`.`user_id`, `Detail`.`top_category_id`, `Detail`.`first_category_id`, `Detail`.`second_category_id`, `Detail`.`detail_image_file_name`, `Detail`.`detail_photo_file_name`, `Detail`.`description`, `Detail`.`keyword1`, `Detail`.`keyword2`, `Detail`.`keyword3`, `Detail`.`keyword4`, `Detail`.`keyword5`, `Detail`.`dxf_file_name`, `Detail`.`mcd_file_name`, `Detail`.`jww_file_name`, `Detail`.`dwg_file_name`, `Detail`.`mpx_file_name`, `Detail`.`pdf_file_name`, `Detail`.`rfa_file_name`, `Detail`.`rvt_file_name`, `Detail`.`ifc_file_name`, `Detail`.`architect_id`, `Detail`.`completed_image_file_name`, `Detail`.`architect_category_id`, `Detail`.`sekou_image1_file_name`, `Detail`.`sekou_text1`, `Detail`.`sekou_image2_file_name`, `Detail`.`sekou_text2`, `Detail`.`sekou_image3_file_name`, `Detail`.`sekou_text3`, `Detail`.`sekou_image4_file_name`, `Detail`.`sekou_text4`, `Detail`.`sekou_image5_file_name`, `Detail`.`sekou_text5`, `Detail`.`sekou_image6_file_name`, `Detail`.`sekou_text6`, `Detail`.`sekou_image7_file_name`, `Detail`.`sekou_image8_file_name`, `Detail`.`sekou_image9_file_name`, `Detail`.`sekou_image10_file_name`, `Detail`.`kanabakari_position_id`, `Detail`.`display_priority`, `Detail`.`status`, `Detail`.`view_count`, `Detail`.`download_count`, `Detail`.`favorite_count`, `Detail`.`kuchikomi_count`, `Detail`.`appearance_point`, `Detail`.`practicability_point`, `Detail`.`cost_performance_point`, `Detail`.`memo`, `Detail`.`created`, `Detail`.`modified`, `Architect`.`id`, `Architect`.`name`, `Architect`.`user_id`, `Architect`.`detail_count`, `Architect`.`status`, `Architect`.`created`, `Architect`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`user_image_file_name`, `User`.`profile`, `User`.`company_id`, `User`.`company_status`, `User`.`role`, `User`.`business_accept`, `User`.`business_type_sekkei`, `User`.`business_type_kouzou`, `User`.`business_type_koumu`, `User`.`work_type_shinki`, `User`.`work_type_sakuzu`, `User`.`work_type_kanri`, `User`.`work_type_shuusei`, `User`.`work_type_sonota`, `User`.`work_type_sonota_text`, `User`.`structure_jikugumi`, `User`.`structure_se`, `User`.`structure_rc`, `User`.`structure_s`, `User`.`structure_kongou`, `User`.`structure_sonota`, `User`.`structure_sonota_text`, `User`.`house_kodate`, `User`.`house_heiyou`, `User`.`house_kyoudou`, `User`.`house_shougyou`, `User`.`house_office`, `User`.`house_renovation`, `User`.`house_sonota`, `User`.`house_sonota_text`, `User`.`skill`, `User`.`business_profile`, `User`.`paying_status`, `User`.`status`, `User`.`memo`, `User`.`created`, `User`.`modified`, `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified`, `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified`, `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified`, `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`details` AS `Detail` LEFT JOIN `LAA0559170-flab`.`architects` AS `Architect` ON (`Detail`.`architect_id` = `Architect`.`id`) LEFT JOIN `LAA0559170-flab`.`users` AS `User` ON (`Detail`.`user_id` = `User`.`id`) LEFT JOIN `LAA0559170-flab`.`top_categories` AS `TopCategory` ON (`Detail`.`top_category_id` = `TopCategory`.`id`) LEFT JOIN `LAA0559170-flab`.`first_categories` AS `FirstCategory` ON (`Detail`.`first_category_id` = `FirstCategory`.`id`) LEFT JOIN `LAA0559170-flab`.`second_categories` AS `SecondCategory` ON (`Detail`.`second_category_id` = `SecondCategory`.`id`) LEFT JOIN `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` ON (`Detail`.`architect_category_id` = `ArchitectCategory`.`id`) WHERE `Detail`.`status` = 1 ORDER BY (appearance_point + practicability_point + cost_performance_point) desc LIMIT 5 | 5 | 5 | 27 | maybe slow |
| SELECT `DetailKuchikomi`.`id`, `DetailKuchikomi`.`detail_id`, `DetailKuchikomi`.`user_id`, `DetailKuchikomi`.`context`, `DetailKuchikomi`.`appearance_point`, `DetailKuchikomi`.`practicability_point`, `DetailKuchikomi`.`cost_performance_point`, `DetailKuchikomi`.`status`, `DetailKuchikomi`.`created`, `DetailKuchikomi`.`modified` FROM `LAA0559170-flab`.`detail_kuchikomis` AS `DetailKuchikomi` WHERE `DetailKuchikomi`.`detail_id` IN (173, 314, 8, 12, 13) | 10 | 10 | 3 | maybe slow |
| SELECT `Detail`.`id`, `Detail`.`name`, `Detail`.`user_id`, `Detail`.`top_category_id`, `Detail`.`first_category_id`, `Detail`.`second_category_id`, `Detail`.`detail_image_file_name`, `Detail`.`detail_photo_file_name`, `Detail`.`description`, `Detail`.`keyword1`, `Detail`.`keyword2`, `Detail`.`keyword3`, `Detail`.`keyword4`, `Detail`.`keyword5`, `Detail`.`dxf_file_name`, `Detail`.`mcd_file_name`, `Detail`.`jww_file_name`, `Detail`.`dwg_file_name`, `Detail`.`mpx_file_name`, `Detail`.`pdf_file_name`, `Detail`.`rfa_file_name`, `Detail`.`rvt_file_name`, `Detail`.`ifc_file_name`, `Detail`.`architect_id`, `Detail`.`completed_image_file_name`, `Detail`.`architect_category_id`, `Detail`.`sekou_image1_file_name`, `Detail`.`sekou_text1`, `Detail`.`sekou_image2_file_name`, `Detail`.`sekou_text2`, `Detail`.`sekou_image3_file_name`, `Detail`.`sekou_text3`, `Detail`.`sekou_image4_file_name`, `Detail`.`sekou_text4`, `Detail`.`sekou_image5_file_name`, `Detail`.`sekou_text5`, `Detail`.`sekou_image6_file_name`, `Detail`.`sekou_text6`, `Detail`.`sekou_image7_file_name`, `Detail`.`sekou_image8_file_name`, `Detail`.`sekou_image9_file_name`, `Detail`.`sekou_image10_file_name`, `Detail`.`kanabakari_position_id`, `Detail`.`display_priority`, `Detail`.`status`, `Detail`.`view_count`, `Detail`.`download_count`, `Detail`.`favorite_count`, `Detail`.`kuchikomi_count`, `Detail`.`appearance_point`, `Detail`.`practicability_point`, `Detail`.`cost_performance_point`, `Detail`.`memo`, `Detail`.`created`, `Detail`.`modified`, `Architect`.`id`, `Architect`.`name`, `Architect`.`user_id`, `Architect`.`detail_count`, `Architect`.`status`, `Architect`.`created`, `Architect`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`user_image_file_name`, `User`.`profile`, `User`.`company_id`, `User`.`company_status`, `User`.`role`, `User`.`business_accept`, `User`.`business_type_sekkei`, `User`.`business_type_kouzou`, `User`.`business_type_koumu`, `User`.`work_type_shinki`, `User`.`work_type_sakuzu`, `User`.`work_type_kanri`, `User`.`work_type_shuusei`, `User`.`work_type_sonota`, `User`.`work_type_sonota_text`, `User`.`structure_jikugumi`, `User`.`structure_se`, `User`.`structure_rc`, `User`.`structure_s`, `User`.`structure_kongou`, `User`.`structure_sonota`, `User`.`structure_sonota_text`, `User`.`house_kodate`, `User`.`house_heiyou`, `User`.`house_kyoudou`, `User`.`house_shougyou`, `User`.`house_office`, `User`.`house_renovation`, `User`.`house_sonota`, `User`.`house_sonota_text`, `User`.`skill`, `User`.`business_profile`, `User`.`paying_status`, `User`.`status`, `User`.`memo`, `User`.`created`, `User`.`modified`, `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified`, `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified`, `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified`, `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`details` AS `Detail` LEFT JOIN `LAA0559170-flab`.`architects` AS `Architect` ON (`Detail`.`architect_id` = `Architect`.`id`) LEFT JOIN `LAA0559170-flab`.`users` AS `User` ON (`Detail`.`user_id` = `User`.`id`) LEFT JOIN `LAA0559170-flab`.`top_categories` AS `TopCategory` ON (`Detail`.`top_category_id` = `TopCategory`.`id`) LEFT JOIN `LAA0559170-flab`.`first_categories` AS `FirstCategory` ON (`Detail`.`first_category_id` = `FirstCategory`.`id`) LEFT JOIN `LAA0559170-flab`.`second_categories` AS `SecondCategory` ON (`Detail`.`second_category_id` = `SecondCategory`.`id`) LEFT JOIN `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` ON (`Detail`.`architect_category_id` = `ArchitectCategory`.`id`) WHERE `Detail`.`status` = 1 ORDER BY `Detail`.`created` desc LIMIT 5 | 5 | 5 | 9 | maybe slow |
| SELECT `DetailKuchikomi`.`id`, `DetailKuchikomi`.`detail_id`, `DetailKuchikomi`.`user_id`, `DetailKuchikomi`.`context`, `DetailKuchikomi`.`appearance_point`, `DetailKuchikomi`.`practicability_point`, `DetailKuchikomi`.`cost_performance_point`, `DetailKuchikomi`.`status`, `DetailKuchikomi`.`created`, `DetailKuchikomi`.`modified` FROM `LAA0559170-flab`.`detail_kuchikomis` AS `DetailKuchikomi` WHERE `DetailKuchikomi`.`detail_id` IN (336, 335, 334, 332, 331) | 0 | 0 | 1 | maybe slow |