1 |
0.00508 sec |
INSERT IGNORE fs_9510_log_visitors SET log_datetime=NOW(), agent_ip='18.97.14.84', system_id='202506191125455367', 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='' |
2 |
0.00029 sec |
SELECT database_name, table_name, alias_name
FROM fs_0000_database_table
WHERE state = 'Y' |
3 |
0.00017 sec |
SELECT error_code, error_msg
FROM jinju.fs_0005_errer_code
WHERE locale = 'english' |
4 |
0.00010 sec |
SELECT lang_group, lang_code, lang_line
FROM jinju.fs_0008_languages
WHERE locale = 'english' |
5 |
0.00051 sec |
SELECT group_code, code_key, code_name, code_alias, code_seq, code_param, state
FROM jinju.fs_0002_comcode
WHERE state != 'D'
ORDER BY code_seq |
6 |
0.00012 sec |
SELECT env_group, env_name, env_value, env_desc
FROM jinju.fs_0010_environments
WHERE state = 'Y'
ORDER BY env_group, env_name |
7 |
0.00010 sec |
SELECT uid as group_uid, group_name, group_alias, group_type, state
FROM jinju.fs_1020_member_group
WHERE state != 'D'
ORDER BY uid ASC |
8 |
0.00019 sec |
SELECT T1.uid as user_uid, T1.user_name, T1.user_id, T1.user_gid, T1.state, T2.group_name, T2.group_alias, T2.group_type FROM fs_1010_member T1 LEFT JOIN fs_1020_member_group T2 ON T1.user_gid=T2.uid WHERE T2.group_type != 'USER' ORDER BY T1.user_gid, T1.user_name |
9 |
0.00010 sec |
SELECT uid, vendor_code, vendor_name
FROM jinju.fs_3020_vendors
WHERE state = 'Y'
ORDER BY regidate DESC |
10 |
0.00102 sec |
SELECT uid, lft, rgt
FROM jinju.fs_10201_category_list
WHERE state = 'Y'
AND uid = 1 |
11 |
0.00096 sec |
SELECT uid, lft, rgt, depth, category_name, category_desc, uri
FROM jinju.fs_10201_category_list
WHERE lft >= '1'
AND rgt <= '64'
AND state = 'Y'
ORDER BY lft ASC |
12 |
0.00081 sec |
SELECT T1.*
FROM jinju.fs_4020_meta T1
JOIN (SELECT cate, MIN(seq) AS min_seq
FROM jinju.fs_4020_meta
WHERE state = 'Y' AND item = 'FABRIC' GROUP BY cate order by seq ASC) AS T2 ON T1.cate = T2.cate AND T1.seq = T2.min_seq
WHERE T1.state = 'Y'
AND T1.item = 'FABRIC'
GROUP BY T1.cate
ORDER BY T1.seq ASC |
13 |
0.00012 sec |
SELECT *
FROM jinju.fs_3010_partners
WHERE state = 'Y'
ORDER BY regidate DESC
LIMIT 6 |
14 |
0.00549 sec |
SELECT *
FROM jinju.fs_20100_product_list
WHERE sale_status = 'SALE'
AND state = 'Y'
ORDER BY regidate DESC
LIMIT 12 |
15 |
0.00023 sec |
SELECT *
FROM jinju.fs_2060_product_images
WHERE product_uid IN('2000413', '2000412', '2000411', '2000410', '2000409', '2000408', '2000407', '2000406', '2000405', '2000404', '2000403', '2000402')
GROUP BY product_uid
ORDER BY file_seq ASC |
16 |
0.00020 sec |
SELECT *
FROM jinju.fs_2090_product_option
WHERE product_uid IN('2000413', '2000412', '2000411', '2000410', '2000409', '2000408', '2000407', '2000406', '2000405', '2000404', '2000403', '2000402')
ORDER BY option_seq ASC |
17 |
0.00012 sec |
SELECT *
FROM jinju.fs_7010_popups
WHERE date_s <= CURDATE() AND date_e >= CURDATE()
AND popup_active = 'Y'
AND state = 'Y'
ORDER BY regidate DESC
LIMIT 1 |