| 1 |
0.00499 sec |
INSERT IGNORE fs_9500_logger SET system_id='202407271629482465', log_date=CURDATE(), agent_ip='18.223.210.20', browser='Mozilla', agent_version='5.0', platform='Unknown Platform', header='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', is_mobile='N', regidate=NOW() |
| 2 |
0.00058 sec |
INSERT IGNORE fs_9510_log_visitors SET log_datetime=NOW(), agent_ip='18.223.210.20', system_id='202407271629482465', access_host='www', request_method='GET', platform='Unknown Platform', browser='Mozilla', agent_version='5.0', is_mobile='N', header='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', path_info='/job/recruit/view', query_string='uid=60' |
| 3 |
0.00024 sec |
SELECT database_name, table_name, alias_name, protected_uids
FROM fs_0000_database_table
WHERE state = 'Y' |
| 4 |
0.00047 sec |
SELECT group_code, code_key, code_name, code_alias, code_seq, code_param, state
FROM gorilla.fs_0002_comcode
WHERE state != 'D'
ORDER BY code_seq |
| 5 |
0.00011 sec |
SELECT env_group, env_name, env_value, env_desc
FROM gorilla.fs_0010_environments
WHERE state = 'Y'
ORDER BY env_group, env_name |
| 6 |
0.00008 sec |
SELECT uid AS group_uid, group_name, group_alias, state
FROM gorilla.fs_1020_member_group |
| 7 |
0.00016 sec |
SELECT uid, corporate_name, cp_save_path, cp_save_name, is_pick
FROM gorilla.fs_1100_corporate
WHERE is_access = 'Y' |
| 8 |
0.00009 sec |
SELECT ceo_name, business_no, jpar_no, phone, address, company
FROM gorilla.fs_0050_company_info
WHERE uid = '1' |
| 9 |
0.00535 sec |
SELECT * FROM gorilla.fs_10130_category_list WHERE uid='1' |
| 10 |
0.00540 sec |
SELECT *
FROM gorilla.fs_10130_category_list
WHERE state = 'Y'
AND state = 'Y'
AND lft >= '1'
AND rgt <= '374'
ORDER BY lft ASC |
| 11 |
0.00510 sec |
SELECT * FROM gorilla.fs_10130_category_list WHERE uid='1' |
| 12 |
0.00524 sec |
SELECT *
FROM gorilla.fs_10130_category_list
WHERE lft >= '1'
AND rgt <= '374'
ORDER BY lft ASC |
| 13 |
0.00076 sec |
INSERT IGNORE INTO gorilla.fs_3015_recruit_hits SET recruit_uid='60', log_date=CURDATE(), log_ip='18.223.210.20', regidate=NOW() |
| 14 |
0.00100 sec |
SELECT uid, group, item_name
FROM gorilla.fs_2050_option_items
WHERE group IN('SKILL', 'WELFARE')
ORDER BY seq ASC |
| 15 |
0.00032 sec |
SELECT *
FROM gorilla.fs_3010_recruit
WHERE uid = '60'
AND recruit_state = 'HIRING'
AND state = 'Y' |
| 16 |
0.00021 sec |
SELECT *
FROM gorilla.fs_1101_corporate_banner
WHERE corporate_uid = '38'
ORDER BY seq ASC |
| 17 |
0.00013 sec |
SELECT *
FROM gorilla.fs_3013_recruit_banner
WHERE state = 'Y'
ORDER BY seq ASC |
| 18 |
0.00242 sec |
SELECT *
FROM gorilla.fs_30100_recruit_list
WHERE cate = '79'
AND uid <> '60'
AND state = 'Y'
AND recruit_state = 'HIRING'
ORDER BY hits DESC, regidate DESC
LIMIT 9 |
| 19 |
0.00026 sec |
SELECT COUNT(*) AS TOTAL
FROM gorilla.fs_30300_apply_list
WHERE user_uid = 0
AND recruit_uid = '60'
AND corporate_uid = '38'
LIMIT 1 |
