| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `SubLocation`.`id`, `SubLocation`.`location_id`, `SubLocation`.`name`, `SubLocation`.`created`, `SubLocation`.`modified`, `SubLocation`.`is_active`, `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`sub_locations` AS `SubLocation` LEFT JOIN `jobbee`.`locations` AS `Location` ON (`SubLocation`.`location_id` = `Location`.`id`) WHERE 1 = 1 | 94 | 94 | 69 | maybe slow |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE 1 = 1 | 6 | 6 | 0 | |
| SELECT `Post`.`id`, `Post`.`company_id`, `Post`.`sub_location_id`, `Post`.`jobtype_id`, `Post`.`type_of_staff`, `Post`.`grade_of_staff`, `Post`.`salary_level`, `Post`.`salary`, `Post`.`title`, `Post`.`subtitle`, `Post`.`difficulty`, `Post`.`work_description`, `Post`.`requirement_skills`, `Post`.`conditions`, `Post`.`worktime`, `Post`.`holiday`, `Post`.`final_education`, `Post`.`open_from`, `Post`.`open_to`, `Post`.`created`, `Post`.`modified`, `Post`.`available_flg`, `Post`.`del_flg`, `Post`.`expired_flg`, `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`posts` AS `Post` LEFT JOIN `jobbee`.`locations` AS `Location` ON (`Post`.`sub_location_id` = `Location`.`id`) LEFT JOIN `jobbee`.`companies` AS `Company` ON (`Post`.`company_id` = `Company`.`id`) WHERE `Post`.`del_flg` = 0 AND `Post`.`available_flg` = 1 AND `Company`.`enable_flg` = 1 AND `Company`.`genre` = 1 ORDER BY `Post`.`modified` desc LIMIT 10 | 10 | 10 | 16 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `jobbee`.`posts` AS `Post` LEFT JOIN `jobbee`.`locations` AS `Location` ON (`Post`.`sub_location_id` = `Location`.`id`) LEFT JOIN `jobbee`.`companies` AS `Company` ON (`Post`.`company_id` = `Company`.`id`) WHERE `Post`.`del_flg` = 0 AND `Post`.`available_flg` = 1 AND `Company`.`enable_flg` = 1 AND `Company`.`genre` = 1 | 1 | 1 | 31 | maybe slow |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 3 AND `CompanyGallery`.`is_main` = '1' | 0 | 0 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 7 AND `CompanyGallery`.`is_main` = '1' | 1 | 1 | 0 | |
| SELECT `Post`.`id`, `Post`.`company_id`, `Post`.`sub_location_id`, `Post`.`jobtype_id`, `Post`.`type_of_staff`, `Post`.`grade_of_staff`, `Post`.`salary_level`, `Post`.`salary`, `Post`.`title`, `Post`.`subtitle`, `Post`.`difficulty`, `Post`.`work_description`, `Post`.`requirement_skills`, `Post`.`conditions`, `Post`.`worktime`, `Post`.`holiday`, `Post`.`final_education`, `Post`.`open_from`, `Post`.`open_to`, `Post`.`created`, `Post`.`modified`, `Post`.`available_flg`, `Post`.`del_flg`, `Post`.`expired_flg`, `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`posts` AS `Post` LEFT JOIN `jobbee`.`locations` AS `Location` ON (`Post`.`sub_location_id` = `Location`.`id`) LEFT JOIN `jobbee`.`companies` AS `Company` ON (`Post`.`company_id` = `Company`.`id`) WHERE `Post`.`del_flg` = 0 AND `Post`.`available_flg` = 1 AND `Company`.`enable_flg` = 1 AND `Company`.`genre` = 2 ORDER BY `Post`.`modified` desc LIMIT 10 | 1 | 1 | 8 | maybe slow |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main`, `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`company_galleries` AS `CompanyGallery` LEFT JOIN `jobbee`.`companies` AS `Company` ON (`CompanyGallery`.`company_id` = `Company`.`id`) WHERE `CompanyGallery`.`del_flg` = 0 AND `CompanyGallery`.`company_id` = 9 AND `CompanyGallery`.`is_main` = '1' | 0 | 0 | 0 | |
| SELECT `PostAd`.*, `Post`.* FROM `jobbee`.`post_ads` AS `PostAd` LEFT JOIN `jobbee`.`posts` AS `Post` ON (`PostAd`.`post_id` = `Post`.`id`) WHERE `PostAd`.`del_flg` = 0 AND `PostAd`.`genre` = 1 ORDER BY `PostAd`.`vieworder` ASC | 8 | 8 | 9 | maybe slow |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 22 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (7) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 22 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (7) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 21 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (7) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 21 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (7) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 21 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (7) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 22 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 7 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (7) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 17 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 6 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (6) | 1 | 1 | 0 | |
| SELECT `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Location`.`is_active` FROM `jobbee`.`locations` AS `Location` WHERE `Location`.`id` = 22 | 0 | 0 | 0 | |
| SELECT `Company`.`id`, `Company`.`name`, `Company`.`genre`, `Company`.`business_description`, `Company`.`location`, `Company`.`place`, `Company`.`tel`, `Company`.`number_of_employee`, `Company`.`person_in_charge`, `Company`.`point`, `Company`.`mail`, `Company`.`password`, `Company`.`created`, `Company`.`modified`, `Company`.`lastlogin`, `Company`.`activation_key`, `Company`.`activation_key_expired`, `Company`.`activation_forgot`, `Company`.`activation_forgot_expired`, `Company`.`enable_flg`, `Company`.`is_paid`, `Company`.`del_flg` FROM `jobbee`.`companies` AS `Company` WHERE `Company`.`id` = 3 | 1 | 1 | 0 | |
| SELECT `CompanyGallery`.`id`, `CompanyGallery`.`company_id`, `CompanyGallery`.`name`, `CompanyGallery`.`sort_order`, `CompanyGallery`.`comment`, `CompanyGallery`.`created`, `CompanyGallery`.`modified`, `CompanyGallery`.`del_flg`, `CompanyGallery`.`is_main` FROM `jobbee`.`company_galleries` AS `CompanyGallery` WHERE `CompanyGallery`.`company_id` = (3) | 0 | 0 | 0 | |
| SELECT `PostAd`.`id`, `PostAd`.`post_id`, `PostAd`.`vieworder`, `PostAd`.`genre`, `PostAd`.`del_flg`, `PostAd`.`created`, `PostAd`.`modified`, `Post`.`id`, `Post`.`company_id`, `Post`.`sub_location_id`, `Post`.`jobtype_id`, `Post`.`type_of_staff`, `Post`.`grade_of_staff`, `Post`.`salary_level`, `Post`.`salary`, `Post`.`title`, `Post`.`subtitle`, `Post`.`difficulty`, `Post`.`work_description`, `Post`.`requirement_skills`, `Post`.`conditions`, `Post`.`worktime`, `Post`.`holiday`, `Post`.`final_education`, `Post`.`open_from`, `Post`.`open_to`, `Post`.`created`, `Post`.`modified`, `Post`.`available_flg`, `Post`.`del_flg`, `Post`.`expired_flg` FROM `jobbee`.`post_ads` AS `PostAd` LEFT JOIN `jobbee`.`posts` AS `Post` ON (`PostAd`.`post_id` = `Post`.`id`) WHERE `PostAd`.`del_flg` = 0 AND `PostAd`.`genre` = 2 ORDER BY `PostAd`.`vieworder` ASC | 0 | 0 | 0 | |
| SELECT `Favorite`.`post_id` FROM `jobbee`.`favorites` AS `Favorite` WHERE `member_id` IS NULL AND `del_flg` IS NULL | 0 | 0 | 0 | |
23 duplicate queries run.