| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `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`, `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified`, `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`users` AS `User` LEFT JOIN `LAA0559170-flab`.`companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `LAA0559170-flab`.`partners` AS `Partner` ON (`Partner`.`user_id` = `User`.`id`) WHERE `username` = 'さいとう1' AND `User`.`status` = 1 LIMIT 1 | 1 | 1 | 1 | |
| SELECT COUNT(*) AS `count` FROM `LAA0559170-flab`.`details` AS `Detail` WHERE `Detail`.`user_id` = 1 AND `Detail`.`status` = 1 | 1 | 1 | 0 | |
| 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` FROM `LAA0559170-flab`.`details` AS `Detail` WHERE `Detail`.`user_id` = 1 AND `Detail`.`status` = 1 | 18 | 18 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `LAA0559170-flab`.`detail_kuchikomis` AS `DetailKuchikomi` LEFT JOIN `LAA0559170-flab`.`details` AS `Detail` ON (`DetailKuchikomi`.`detail_id` = `Detail`.`id`) LEFT JOIN `LAA0559170-flab`.`users` AS `User` ON (`DetailKuchikomi`.`user_id` = `User`.`id`) WHERE `DetailKuchikomi`.`user_id` = 1 AND `Detail`.`status` = 1 | 1 | 1 | 0 | |
| 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`, `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`, `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` FROM `LAA0559170-flab`.`detail_kuchikomis` AS `DetailKuchikomi` LEFT JOIN `LAA0559170-flab`.`details` AS `Detail` ON (`DetailKuchikomi`.`detail_id` = `Detail`.`id`) LEFT JOIN `LAA0559170-flab`.`users` AS `User` ON (`DetailKuchikomi`.`user_id` = `User`.`id`) WHERE `DetailKuchikomi`.`user_id` = 1 AND `Detail`.`status` = 1 | 2 | 2 | 1 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `LAA0559170-flab`.`favorite_histories` AS `FavoriteHistory` LEFT JOIN `LAA0559170-flab`.`details` AS `Detail` ON (`FavoriteHistory`.`detail_id` = `Detail`.`id`) LEFT JOIN `LAA0559170-flab`.`users` AS `User` ON (`FavoriteHistory`.`user_id` = `User`.`id`) WHERE `FavoriteHistory`.`user_id` = 1 AND `Detail`.`status` = 1 | 1 | 1 | 0 | |
| SELECT `FavoriteHistory`.`id`, `FavoriteHistory`.`detail_id`, `FavoriteHistory`.`user_id`, `FavoriteHistory`.`created`, `FavoriteHistory`.`modified`, `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`, `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` FROM `LAA0559170-flab`.`favorite_histories` AS `FavoriteHistory` LEFT JOIN `LAA0559170-flab`.`details` AS `Detail` ON (`FavoriteHistory`.`detail_id` = `Detail`.`id`) LEFT JOIN `LAA0559170-flab`.`users` AS `User` ON (`FavoriteHistory`.`user_id` = `User`.`id`) WHERE `FavoriteHistory`.`user_id` = 1 AND `Detail`.`status` = 1 | 5 | 5 | 1 | maybe slow |
| SELECT `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` FROM `LAA0559170-flab`.`users` AS `User` WHERE `User`.`id` = 8 | 1 | 1 | 0 | |
| SELECT `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified` FROM `LAA0559170-flab`.`top_categories` AS `TopCategory` WHERE `TopCategory`.`id` = 2 | 1 | 1 | 0 | |
| SELECT `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified` FROM `LAA0559170-flab`.`first_categories` AS `FirstCategory` WHERE `FirstCategory`.`id` = 2 | 1 | 1 | 0 | |
| SELECT `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified` FROM `LAA0559170-flab`.`second_categories` AS `SecondCategory` WHERE `SecondCategory`.`id` = 6 | 1 | 1 | 0 | |
| SELECT `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` WHERE `ArchitectCategory`.`id` = 3 | 1 | 1 | 0 | |
| 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` = (171) | 0 | 0 | 0 | |
| SELECT `Architect`.`id`, `Architect`.`name`, `Architect`.`user_id`, `Architect`.`detail_count`, `Architect`.`status`, `Architect`.`created`, `Architect`.`modified` FROM `LAA0559170-flab`.`architects` AS `Architect` WHERE `Architect`.`id` = 4 | 1 | 1 | 0 | |
| SELECT `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` FROM `LAA0559170-flab`.`users` AS `User` WHERE `User`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified` FROM `LAA0559170-flab`.`top_categories` AS `TopCategory` WHERE `TopCategory`.`id` = 4 | 1 | 1 | 0 | |
| SELECT `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified` FROM `LAA0559170-flab`.`first_categories` AS `FirstCategory` WHERE `FirstCategory`.`id` = 14 | 1 | 1 | 0 | |
| SELECT `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified` FROM `LAA0559170-flab`.`second_categories` AS `SecondCategory` WHERE `SecondCategory`.`id` = 86 | 1 | 1 | 0 | |
| SELECT `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` WHERE `ArchitectCategory`.`id` = 6 | 1 | 1 | 0 | |
| 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` = (17) | 0 | 0 | 0 | |
| SELECT `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` FROM `LAA0559170-flab`.`users` AS `User` WHERE `User`.`id` = 8 | 1 | 1 | 1 | |
| SELECT `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified` FROM `LAA0559170-flab`.`top_categories` AS `TopCategory` WHERE `TopCategory`.`id` = 3 | 1 | 1 | 0 | |
| SELECT `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified` FROM `LAA0559170-flab`.`first_categories` AS `FirstCategory` WHERE `FirstCategory`.`id` = 5 | 1 | 1 | 0 | |
| SELECT `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified` FROM `LAA0559170-flab`.`second_categories` AS `SecondCategory` WHERE `SecondCategory`.`id` = 29 | 1 | 1 | 0 | |
| SELECT `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` WHERE `ArchitectCategory`.`id` = 3 | 1 | 1 | 0 | |
| 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` = (172) | 0 | 0 | 0 | |
| SELECT `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` FROM `LAA0559170-flab`.`users` AS `User` WHERE `User`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified` FROM `LAA0559170-flab`.`top_categories` AS `TopCategory` WHERE `TopCategory`.`id` = 2 | 1 | 1 | 0 | |
| SELECT `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified` FROM `LAA0559170-flab`.`first_categories` AS `FirstCategory` WHERE `FirstCategory`.`id` = 2 | 1 | 1 | 0 | |
| SELECT `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified` FROM `LAA0559170-flab`.`second_categories` AS `SecondCategory` WHERE `SecondCategory`.`id` = 3 | 1 | 1 | 0 | |
| SELECT `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` WHERE `ArchitectCategory`.`id` = 1 | 1 | 1 | 0 | |
| 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` = (335) | 0 | 0 | 0 | |
| SELECT `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` FROM `LAA0559170-flab`.`users` AS `User` WHERE `User`.`id` = 1 | 1 | 1 | 1 | |
| SELECT `TopCategory`.`id`, `TopCategory`.`name`, `TopCategory`.`sort_order`, `TopCategory`.`status`, `TopCategory`.`created`, `TopCategory`.`modified` FROM `LAA0559170-flab`.`top_categories` AS `TopCategory` WHERE `TopCategory`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `FirstCategory`.`id`, `FirstCategory`.`top_category_id`, `FirstCategory`.`name`, `FirstCategory`.`sort_order`, `FirstCategory`.`status`, `FirstCategory`.`created`, `FirstCategory`.`modified` FROM `LAA0559170-flab`.`first_categories` AS `FirstCategory` WHERE `FirstCategory`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `SecondCategory`.`id`, `SecondCategory`.`first_category_id`, `SecondCategory`.`name`, `SecondCategory`.`sort_order`, `SecondCategory`.`status`, `SecondCategory`.`created`, `SecondCategory`.`modified` FROM `LAA0559170-flab`.`second_categories` AS `SecondCategory` WHERE `SecondCategory`.`id` = 1 | 1 | 1 | 0 | |
| SELECT `ArchitectCategory`.`id`, `ArchitectCategory`.`name`, `ArchitectCategory`.`sort_order`, `ArchitectCategory`.`status`, `ArchitectCategory`.`created`, `ArchitectCategory`.`modified` FROM `LAA0559170-flab`.`architect_categories` AS `ArchitectCategory` WHERE `ArchitectCategory`.`id` = 1 | 1 | 1 | 0 | |
| 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` = (334) | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified` FROM `LAA0559170-flab`.`companies` AS `Company` WHERE `Company`.`id` = 3 | 1 | 1 | 1 | |
| SELECT `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`partners` AS `Partner` WHERE `Partner`.`user_id` = 1 | 1 | 1 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified` FROM `LAA0559170-flab`.`companies` AS `Company` WHERE `Company`.`id` = 3 | 1 | 1 | 1 | |
| SELECT `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`partners` AS `Partner` WHERE `Partner`.`user_id` = 1 | 1 | 1 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified` FROM `LAA0559170-flab`.`companies` AS `Company` WHERE `Company`.`id` = 3 | 1 | 1 | 0 | |
| SELECT `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`partners` AS `Partner` WHERE `Partner`.`user_id` = 1 | 1 | 1 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified` FROM `LAA0559170-flab`.`companies` AS `Company` WHERE `Company`.`id` = 3 | 1 | 1 | 1 | |
| SELECT `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`partners` AS `Partner` WHERE `Partner`.`user_id` = 1 | 1 | 1 | 1 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified` FROM `LAA0559170-flab`.`companies` AS `Company` WHERE `Company`.`id` = 3 | 1 | 1 | 1 | |
| SELECT `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`partners` AS `Partner` WHERE `Partner`.`user_id` = 1 | 1 | 1 | 0 | |
| SELECT `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`, `Company`.`id`, `Company`.`name`, `Company`.`name_kana`, `Company`.`url`, `Company`.`email`, `Company`.`tel`, `Company`.`fax`, `Company`.`zipcode`, `Company`.`prefecture`, `Company`.`city`, `Company`.`address`, `Company`.`building`, `Company`.`president`, `Company`.`company_image_file_name`, `Company`.`profile`, `Company`.`works_image1_file_name`, `Company`.`works_image2_file_name`, `Company`.`works_image3_file_name`, `Company`.`works_image4_file_name`, `Company`.`works_image5_file_name`, `Company`.`works_image6_file_name`, `Company`.`works_image7_file_name`, `Company`.`works_image8_file_name`, `Company`.`works_image9_file_name`, `Company`.`works_image10_file_name`, `Company`.`company_type_id`, `Company`.`status`, `Company`.`memo`, `Company`.`created`, `Company`.`modified`, `Partner`.`id`, `Partner`.`user_id`, `Partner`.`status`, `Partner`.`memo`, `Partner`.`created`, `Partner`.`modified` FROM `LAA0559170-flab`.`users` AS `User` LEFT JOIN `LAA0559170-flab`.`companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `LAA0559170-flab`.`partners` AS `Partner` ON (`Partner`.`user_id` = `User`.`id`) WHERE NOT (`company_id` IS NULL) AND `company_id` = 3 AND `User`.`status` = 1 ORDER BY `User`.`created` desc | 3 | 3 | 1 | 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 | 5 | |
| 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 | 0 | |
| 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 | 5 | |
| 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 | 0 | |