1 |
0.00028 sec |
SELECT database_name, table_name, alias_name
FROM fs_0000_database_table
WHERE state = 'Y' |
2 |
0.00028 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='english' ) T3 ON ( T1.error_code=T3.error_code ) WHERE T1.locale='korean' |
3 |
0.00034 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='english' ) T3 ON ( T1.lang_group=T3.lang_group AND T1.lang_code=T3.lang_code )WHERE T1.locale='korean' |
4 |
0.00037 sec |
SELECT group_code, code_key, IF(T2.uid && T2.locale='english', 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='english'
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.00103 sec |
INSERT IGNORE ledome.fs_9510_log_visitors SET log_datetime=NOW(), agent_ip='18.97.14.84', system_id='202412062200052409', access_host='www', request_method='GET', platform='Unknown Platform', browser='', agent_version='', is_mobile='N', header='CCBot/2.0 (https://commoncrawl.org/faq/)', path_info='/', query_string='' |
8 |
0.00050 sec |
SELECT uid, lft, rgt
FROM ledome.fs_10201_category_list
WHERE state = 'Y'
AND uid = 1 |
9 |
0.00067 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 |
10 |
0.00245 sec |
SELECT *
FROM ledome.fs_2010_brands |
11 |
0.00040 sec |
SELECT uid, brand_name_eng FROM ledome.fs_2010_brands WHERE category_uid='121' AND state='Y' ORDER BY RAND() LIMIT 16 |
12 |
0.00033 sec |
SELECT uid, brand_name_eng FROM ledome.fs_2010_brands WHERE category_uid='122' AND state='Y' ORDER BY RAND() LIMIT 16 |
13 |
0.00029 sec |
SELECT uid, brand_name_eng FROM ledome.fs_2010_brands WHERE category_uid='123' AND state='Y' ORDER BY RAND() LIMIT 16 |
14 |
0.00027 sec |
SELECT uid, brand_name_eng FROM ledome.fs_2010_brands WHERE category_uid='126' AND state='Y' ORDER BY RAND() LIMIT 16 |
15 |
0.00026 sec |
SELECT uid, brand_name_eng FROM ledome.fs_2010_brands WHERE category_uid='127' AND state='Y' ORDER BY RAND() LIMIT 16 |
16 |
0.00026 sec |
SELECT uid, brand_name_eng FROM ledome.fs_2010_brands WHERE category_uid='128' AND state='Y' ORDER BY RAND() LIMIT 16 |
17 |
0.00023 sec |
SELECT T2.uid FROM ledome.fs_20300_extems T1 LEFT JOIN ledome.fs_2010_brands T2 ON T1.brand_uid=T2.uid WHERE T1.exp_code='main_items' AND T2.state='Y' ORDER BY RAND() LIMIT 5 |
18 |
0.00039 sec |
SELECT *
FROM ledome.fs_20200_lookbooks
WHERE brand_uid IN('1000238', '1000327', '1000375', '1000274', '1000198')
AND brand_state = 'Y'
AND file_seq = '0'
LIMIT 15 |
19 |
0.00021 sec |
SELECT *
FROM ledome.fs_2030_items
WHERE brand_uid IN('1000238', '1000327', '1000375', '1000274', '1000198')
ORDER BY file_seq |
20 |
0.00021 sec |
SELECT *
FROM ledome.fs_2210_instagram
WHERE image is NOT NULL
ORDER BY seq DESC
LIMIT 10 |
21 |
0.00024 sec |
SELECT T2.uid FROM ledome.fs_20300_extems T1 LEFT JOIN ledome.fs_2010_brands T2 ON T1.brand_uid=T2.uid WHERE T1.exp_code='main_swipe_rolls' AND T2.state='Y' ORDER BY RAND() LIMIT 15 |
22 |
0.00041 sec |
SELECT *
FROM ledome.fs_20200_lookbooks
WHERE brand_uid IN('1000049', '1000168', '1000224', '1000005', '1000198', '1000113')
AND brand_state = 'Y'
AND file_seq = '0'
LIMIT 10 |