1 |
0.00494 sec |
INSERT IGNORE fs_9500_logger SET system_id='202505021301089631', log_date=CURDATE(), agent_ip='3.135.223.175', 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)', referrer='http://www.jobgorilla.co.kr/', is_mobile='N', where_is='jobgorilla.co.kr', regidate=NOW() |
2 |
0.00056 sec |
INSERT IGNORE fs_9510_log_visitors SET log_datetime=NOW(), agent_ip='3.135.223.175', system_id='202505021301089631', 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)', referrer='http://www.jobgorilla.co.kr/', path_info='/', query_string='' |
3 |
0.00024 sec |
SELECT database_name, table_name, alias_name, protected_uids
FROM fs_0000_database_table
WHERE state = 'Y' |
4 |
0.00037 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.00010 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.00011 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.00529 sec |
SELECT * FROM gorilla.fs_10130_category_list WHERE uid='1' |
10 |
0.00538 sec |
SELECT *
FROM gorilla.fs_10130_category_list
WHERE state = 'Y'
AND state = 'Y'
AND lft >= '1'
AND rgt <= '380'
ORDER BY lft ASC |
11 |
0.00019 sec |
SELECT *
FROM gorilla.fs_2010_banners
WHERE state = 'Y'
ORDER BY seq ASC |
12 |
0.00011 sec |
SELECT *
FROM gorilla.fs_2030_items
WHERE is_view = 'Y'
AND state = 'Y'
ORDER BY item_seq ASC |
13 |
0.00069 sec |
SELECT uid, item_name
FROM gorilla.fs_2050_option_items
WHERE group = 'SKILL'
ORDER BY seq ASC |
14 |
0.00039 sec |
SELECT uid, item_name
FROM gorilla.fs_2050_option_items
WHERE group = 'TAG'
ORDER BY seq ASC |
15 |
0.00245 sec |
SELECT T1.uid AS goods_uid, T1.pid, T1.seq, T3.item_seq, T2.*
FROM gorilla.fs_2031_items_goods T1
LEFT JOIN gorilla.fs_30100_recruit_list T2 ON T1.item_uid=T2.uid
LEFT JOIN gorilla.fs_2030_items T3 ON T3.uid=T1.pid
WHERE T3.item_type = 'RECRUIT'
AND T1.pid = 2
AND T1.state = 'Y'
AND T2.state = 'Y'
AND T2.recruit_state = 'HIRING'
ORDER BY T1.seq ASC
LIMIT 12 |
16 |
0.00063 sec |
SELECT uid, item_name
FROM gorilla.fs_2050_option_items
WHERE group = 'SKILL'
ORDER BY seq ASC |
17 |
0.00037 sec |
SELECT uid, item_name
FROM gorilla.fs_2050_option_items
WHERE group = 'TAG'
ORDER BY seq ASC |
18 |
0.00044 sec |
SELECT T1.uid AS goods_uid, T1.pid, T1.seq, T3.item_seq, T2.*
FROM gorilla.fs_2031_items_goods T1
LEFT JOIN gorilla.fs_30500_gorilla_list T2 ON T1.item_uid=T2.uid
LEFT JOIN gorilla.fs_2030_items T3 ON T3.uid=T1.pid
WHERE T3.item_type = 'GORILLA'
AND T1.pid = 3
AND T1.state = 'Y'
AND T2.is_blind = 'N'
ORDER BY T1.seq ASC
LIMIT 12 |
19 |
0.00061 sec |
SELECT uid, item_name
FROM gorilla.fs_2050_option_items
WHERE group = 'SKILL'
ORDER BY seq ASC |
20 |
0.00036 sec |
SELECT uid, item_name
FROM gorilla.fs_2050_option_items
WHERE group = 'TAG'
ORDER BY seq ASC |
21 |
0.00082 sec |
SELECT T1.uid AS goods_uid, T1.pid, T1.seq, T3.item_seq, T2.*
FROM gorilla.fs_2031_items_goods T1
LEFT JOIN gorilla.fs_40100_hub_list T2 ON T1.item_uid=T2.uid
LEFT JOIN gorilla.fs_2030_items T3 ON T3.uid=T1.pid
WHERE T3.item_type = 'HUB'
AND T1.pid = 4
AND T1.state = 'Y'
ORDER BY T1.seq ASC
LIMIT 12 |
22 |
0.00011 sec |
SELECT *
FROM gorilla.fs_1150_main_count
WHERE uid = '1'
AND state = 'Y' |