「さっき見た求人、所在地はどのあたりだったかな?」「この求人は気になるけど、
まだ十分に他も検討したい」といった場合に、「お気に入り一覧」に登録しておくと、
あとからゆっくり確認することができます。もちろん、複数の求人がどれも気になった
場合は、各求人ごとの詳細を、エージェントが詳しくご説明させていただきます。
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `Prefecture`.`id`, `Prefecture`.`name` FROM `aa127a1w3g`.`develop-dajp_prefectures` AS `Prefecture` WHERE 1 = 1 ORDER BY `Prefecture`.`id` asc | 47 | 47 | 23 | |
2 | SELECT `Agent`.`id`, `Agent`.`name` FROM `aa127a1w3g`.`develop-dajp_agents` AS `Agent` WHERE `Agent`.`delflg` = 0 ORDER BY `Agent`.`branch` asc, `Agent`.`id` asc | 8 | 8 | 47 | |
3 | SELECT `Department`.`id`, `Department`.`name` FROM `aa127a1w3g`.`develop-dajp_departments` AS `Department` WHERE 1 = 1 ORDER BY `Department`.`odrno` asc | 33 | 33 | 0 | |
4 | SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241128' AND delflg=0 GROUP BY agent_id) AS TBL LEFT JOIN `develop-dajp_agents` ON `develop-dajp_agents`.id = TBL.agent_id WHERE delflg=0 and branch=0) AS Agent ORDER BY ymd desc | 4 | 4 | 1 | |
5 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 5 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
6 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 4 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
7 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 2 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 1 | |
8 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
9 | SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241128' AND delflg=0 GROUP BY agent_id) AS TBL LEFT JOIN `develop-dajp_agents` ON `develop-dajp_agents`.id = TBL.agent_id WHERE delflg=0 and branch=1) AS Agent ORDER BY ymd desc | 1 | 1 | 0 | |
10 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 6 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
11 | SELECT * FROM (SELECT agent_id as id,name,TBL.ymd FROM (SELECT agent_id,max(ymd) as ymd FROM `develop-dajp_recommends` WHERE ymd<='20241128' AND delflg=0 GROUP BY agent_id) AS TBL LEFT JOIN `develop-dajp_agents` ON `develop-dajp_agents`.id = TBL.agent_id WHERE delflg=0) AS Agent ORDER BY ymd desc | 5 | 5 | 1 | |
12 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 6 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
13 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 5 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
14 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 4 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
15 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 2 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
16 | SELECT `Recommend`.`id`, `Recommend`.`recomid`, `Recommend`.`job_id`, `Recommend`.`ymd`, `Recommend`.`agent_id`, `Recommend`.`title`, `Recommend`.`body`, `Recommend`.`delflg`, `Recommend`.`created`, `Recommend`.`modified`, `Agent`.`id`, `Agent`.`branch`, `Agent`.`name`, `Agent`.`name2`, `Agent`.`email`, `Agent`.`imgurl`, `Agent`.`odrno`, `Agent`.`delflg`, `Agent`.`created`, `Agent`.`modified` FROM `aa127a1w3g`.`develop-dajp_recommends` AS `Recommend` LEFT JOIN `aa127a1w3g`.`develop-dajp_agents` AS `Agent` ON (`Recommend`.`agent_id` = `Agent`.`id`) WHERE `Recommend`.`delflg` = 0 AND `Recommend`.`ymd` <= '2024/11/28' AND `Recommend`.`agent_id` = 3 ORDER BY `Recommend`.`ymd` desc, `Recommend`.`modified` desc LIMIT 1 | 1 | 1 | 0 | |
17 | SELECT `News`.`id`, `News`.`ymd`, `News`.`title`, `News`.`body`, `News`.`delflg`, `News`.`created`, `News`.`modified` FROM `aa127a1w3g`.`develop-dajp_news` AS `News` WHERE `News`.`delflg` = 0 AND `News`.`ymd` <= '2024/11/28' ORDER BY `News`.`ymd` desc, `News`.`modified` desc LIMIT 10 | 0 | 0 | 0 |