| 1 |
0.00029 sec |
SELECT database_name, table_name, alias_name
FROM fs_0000_database_table
WHERE state = 'Y' |
| 2 |
0.00030 sec |
SELECT T1.error_code, IF(T3.uid, T3.error_msg, T1.error_msg) AS error_msg FROM ledome.fs_0005_error_code T1 LEFT JOIN ( SELECT * FROM ledome.fs_0005_error_code T2 WHERE T2.locale='korean' ) T3 ON ( T1.error_code=T3.error_code ) WHERE T1.locale='korean' |
| 3 |
0.00077 sec |
SELECT T1.lang_group, T1.lang_code, IF(T3.uid, T3.lang_line, T1.lang_line) AS lang_line FROM ledome.fs_0008_languages T1 LEFT JOIN ( SELECT * FROM ledome.fs_0008_languages T2 WHERE T2.locale='korean' ) T3 ON ( T1.lang_group=T3.lang_group AND T1.lang_code=T3.lang_code )WHERE T1.locale='korean' |
| 4 |
0.00029 sec |
SELECT group_code, code_key, IF(T2.uid && T2.locale='korean', T2.lang_line, T1.code_name) as code_name, code_alias, code_seq, code_param, state
FROM ledome.fs_0002_comcode T1
LEFT JOIN ledome.fs_0009_covenant T2 ON T1.uid=T2.refer_uid AND T2.refer_table='comcode' AND T2.locale='korean'
WHERE T1.state != 'D'
ORDER BY T1.code_seq |
| 5 |
0.00013 sec |
SELECT env_group, env_name, env_value, env_desc
FROM ledome.fs_0010_environments
WHERE state = 'Y'
ORDER BY env_group, env_name |
| 6 |
0.00011 sec |
SELECT uid as group_uid, group_name, group_alias, group_type, state
FROM ledome.fs_1020_member_group
WHERE state != 'D'
ORDER BY uid ASC |
| 7 |
0.00078 sec |
INSERT IGNORE ledome.fs_9500_logger SET system_id='202411211527051500', log_date=CURDATE(), agent_ip='3.135.184.136', 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() |
| 8 |
0.00179 sec |
INSERT IGNORE ledome.fs_9510_log_visitors SET log_datetime=NOW(), agent_ip='3.135.184.136', system_id='202411211527051500', 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='/archive/lookbook', query_string='' |
| 9 |
0.00067 sec |
SELECT uid, lft, rgt
FROM ledome.fs_10201_category_list
WHERE state = 'Y'
AND uid = 1 |
| 10 |
0.00076 sec |
SELECT uid, lft, rgt, depth, category_name, category_desc, uri
FROM ledome.fs_10201_category_list
WHERE lft >= '1'
AND rgt <= '56'
AND state = 'Y'
ORDER BY lft ASC |
| 11 |
0.00069 sec |
SELECT uid, category_name, category_desc, keywords, uri
FROM ledome.fs_10201_category_list
WHERE uri IN('/archive', '/archive/lookbook')
ORDER BY LENGTH(uri) DESC
LIMIT 1 |
| 12 |
0.00017 sec |
SELECT parent.uid, parent.category_name FROM ledome.fs_2001_category AS node, ledome.fs_2001_category AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.uid = '86' ORDER BY parent.lft |
| 13 |
0.00011 sec |
SELECT *
FROM ledome.fs_2010_brands
WHERE uid IS NULL |
| 14 |
0.00009 sec |
SELECT *
FROM ledome.fs_2012_brand_profile
WHERE brand_uid IS NULL
ORDER BY career_year DESC |
| 15 |
0.00008 sec |
SELECT *
FROM ledome.fs_2013_brand_link
WHERE brand_uid IS NULL |
| 16 |
0.00007 sec |
SELECT *
FROM ledome.fs_2014_brand_shop
WHERE brand_uid IS NULL |
| 17 |
0.00007 sec |
SELECT *
FROM ledome.fs_2020_lookbook
WHERE brand_uid IS NULL
ORDER BY file_seq |