| 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 | 1 | |
| SELECT `Member`.`id`, `Member`.`name`, `Member`.`name_kana`, `Member`.`mail`, `Member`.`password`, `Member`.`gender`, `Member`.`birthday`, `Member`.`zipcode`, `Member`.`member_country_id`, `Member`.`location_id`, `Member`.`sub_location_id`, `Member`.`address`, `Member`.`tel`, `Member`.`mobilephone`, `Member`.`finaleducation`, `Member`.`license`, `Member`.`english_skill`, `Member`.`other_languages`, `Member`.`detail`, `Member`.`salary`, `Member`.`scoutmail_flg`, `Member`.`picture`, `Member`.`created`, `Member`.`modified`, `Member`.`mail_confirm`, `Member`.`del_flg`, `Member`.`activation_key`, `Member`.`activation_key_expired`, `Member`.`activation_forgot`, `Member`.`activation_forgot_expired`, `Member`.`is_new`, `Member`.`enable_flg`, `Member`.`job_experience`, `Member`.`interest`, `Member`.`education`, `Member`.`default_comment`, `Member`.`country_id`, `Member`.`foreign_address`, `CountriesMember`.`id`, `CountriesMember`.`member_id`, `CountriesMember`.`country_id`, `CountriesMember`.`created`, `CountriesMember`.`modified` FROM `jobbee`.`members` AS `Member` JOIN `jobbee`.`countries_members` AS `CountriesMember` ON (`CountriesMember`.`country_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17) AND `CountriesMember`.`member_id` = `Member`.`id`) | 10 | 10 | 1 | maybe slow |