| 1 |
0.00047 sec |
SELECT database_name, table_name, alias_name
FROM fs_0000_database_table
WHERE state = 'Y' |
| 2 |
0.00037 sec |
SELECT error_code, error_msg
FROM smartwiz.fs_0005_errer_code
WHERE locale = 'english' |
| 3 |
0.00031 sec |
SELECT lang_group, lang_code, lang_line
FROM smartwiz.fs_0008_languages
WHERE locale = 'english' |
| 4 |
0.00044 sec |
SELECT group_code, code_key, code_name, code_alias, code_seq, code_param, state
FROM smartwiz.fs_0002_comcode
WHERE state != 'D'
ORDER BY code_seq |
| 5 |
0.00038 sec |
SELECT env_group, env_name, env_value, env_desc
FROM smartwiz.fs_0010_environments
WHERE state = 'Y'
ORDER BY env_group, env_name |
| 6 |
0.00038 sec |
SELECT uid as group_uid, group_name, group_alias, group_type, state
FROM smartwiz.fs_1020_member_group
WHERE state != 'D'
ORDER BY uid ASC |
| 7 |
0.00102 sec |
SELECT uid, lft, rgt
FROM smartwiz.fs_10201_category_list
WHERE state = 'Y'
AND uid = 1 |
| 8 |
0.00084 sec |
SELECT uid, lft, rgt, depth, category_name, category_desc, uri
FROM smartwiz.fs_10201_category_list
WHERE lft >= '1'
AND rgt <= '46'
AND state = 'Y'
ORDER BY lft ASC |
| 9 |
0.00078 sec |
SELECT uid, category_name, category_desc, keywords, uri
FROM smartwiz.fs_10201_category_list
WHERE uri IN('/docs', '/docs/components', '/docs/components/fscore')
ORDER BY LENGTH(uri) DESC
LIMIT 1 |
| 10 |
0.00038 sec |
SELECT parent.uid, parent.category_name FROM smartwiz.fs_2001_category AS node, smartwiz.fs_2001_category AS parent WHERE node.lft BETWEEN parent.lft AND parent.rgt AND node.uid = '59' ORDER BY parent.lft |