| 1 |
0.00118 sec |
INSERT IGNORE fs_9510_log_visitors SET log_datetime=NOW(), agent_ip='216.73.216.94', system_id='202609110236527731', 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='/product/items', query_string='cate=fabric&page=18' |
| 2 |
0.00098 sec |
SELECT database_name, table_name, alias_name
FROM fs_0000_database_table
WHERE state = 'Y' |
| 3 |
0.00065 sec |
SELECT error_code, error_msg
FROM onedango.fs_0005_errer_code
WHERE locale = 'korean' |
| 4 |
0.00059 sec |
SELECT lang_group, lang_code, lang_line
FROM onedango.fs_0008_languages
WHERE locale = 'korean' |
| 5 |
0.00235 sec |
SELECT group_code, code_key, code_name, code_alias, code_seq, code_param, state
FROM onedango.fs_0002_comcode
WHERE state != 'D'
ORDER BY code_seq |
| 6 |
0.00055 sec |
SELECT env_group, env_name, env_value, env_desc
FROM onedango.fs_0010_environments
WHERE state = 'Y'
ORDER BY env_group, env_name |
| 7 |
0.00059 sec |
SELECT uid as group_uid, group_name, group_alias, group_type, state
FROM onedango.fs_1020_member_group
WHERE state != 'D'
ORDER BY uid ASC |
| 8 |
0.00095 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.00164 sec |
SELECT uid, vendor_code, vendor_name
FROM onedango.fs_3020_vendors
WHERE state = 'Y'
ORDER BY regidate DESC |
| 10 |
0.00247 sec |
SELECT uid, lft, rgt
FROM onedango.fs_10201_category_list
WHERE state = 'Y'
AND uid = 1 |
| 11 |
0.00427 sec |
SELECT uid, lft, rgt, depth, category_name, category_desc, uri
FROM onedango.fs_10201_category_list
WHERE lft >= '1'
AND rgt <= '74'
AND state = 'Y'
ORDER BY lft ASC |
| 12 |
0.00105 sec |
SELECT *
FROM onedango.fs_2020_product_filters
WHERE state = 'Y'
AND filter_div = 'FABRIC'
ORDER BY filter_seq ASC |
| 13 |
0.03527 sec |
SELECT COUNT(*) AS numrows
FROM onedango.fs_20100_product_list
WHERE sale_status = 'SALE'
AND state = 'Y' |
| 14 |
0.03670 sec |
SELECT *
FROM onedango.fs_20100_product_list
WHERE sale_status = 'SALE'
AND state = 'Y'
ORDER BY regidate DESC
LIMIT 340, 20 |
| 15 |
0.00153 sec |
SELECT *
FROM onedango.fs_2060_product_images
WHERE product_uid IN('2000953', '2000952', '2000951', '2000950', '2000949', '2000948', '2000947', '2000946', '2000945', '2000944', '2000943', '2000942', '2000941', '2000939', '2000936', '2000935', '2000934', '2000933', '2000932', '2000931')
GROUP BY product_uid
ORDER BY file_seq ASC |
| 16 |
0.00250 sec |
SELECT *
FROM onedango.fs_2090_product_option
WHERE product_uid IN('2000953', '2000952', '2000951', '2000950', '2000949', '2000948', '2000947', '2000946', '2000945', '2000944', '2000943', '2000942', '2000941', '2000939', '2000936', '2000935', '2000934', '2000933', '2000932', '2000931')
ORDER BY option_seq ASC |