SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'ems_article' [ RunTime:0.001019s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc,[cat_id] asc) AS ROW_NUMBER FROM (SELECT * FROM [ems_article] WHERE [is_open] = 1 AND [pid] = 0) AS thinkphp) AS T1 [ RunTime:0.000985s ]
SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'ems_category' [ RunTime:0.000867s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [cat_id] = 31) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000638s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 31) AS thinkphp) AS T1 [ RunTime:0.000613s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 0 AND [is_open] = 1 AND [is_nav] = 0) AS thinkphp) AS T1 [ RunTime:0.000727s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 1 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000790s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 8 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000697s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 9 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000612s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 7 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000697s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 2 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.002183s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 3 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000753s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 16 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000775s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 17 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000649s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 18 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000906s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 19 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000682s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 20 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000704s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 35 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000567s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 11 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001048s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 26 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001070s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 27 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000830s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 28 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000874s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 29 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000725s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 39 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000691s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 40 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000603s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 10 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.002425s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 21 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000761s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 22 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000878s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 23 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000860s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 24 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000869s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 25 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001014s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 37 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000766s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 15 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000733s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 30 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000664s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 31 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000765s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 32 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000593s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 33 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000521s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 34 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000587s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 38 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000524s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 4 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000562s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 5 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000668s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 12 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000676s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 13 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000936s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 14 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000913s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 6 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000665s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 0 AND [is_open] = 1 AND [is_nav] = 0) AS thinkphp) AS T1 [ RunTime:0.000656s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 1 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000641s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 8 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000774s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 9 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000644s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 7 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000733s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 2 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000820s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 3 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000889s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 16 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000753s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 17 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000677s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 18 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000977s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 19 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000887s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 20 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001108s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 35 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000639s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 11 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000935s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 26 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000560s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 27 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000647s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 28 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000597s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 29 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000818s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 39 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000732s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 40 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000649s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 10 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000687s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 21 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000728s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 22 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000923s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 23 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001041s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 24 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000719s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 25 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000579s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 37 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001031s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 15 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000836s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 30 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000758s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 31 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000707s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 32 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000721s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 33 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000631s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 34 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000606s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 38 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000501s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 4 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000845s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 5 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001065s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 12 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.000686s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 13 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001332s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 14 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001389s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [sorting] desc) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 6 AND [is_open] = 1 AND [is_nav] = ) AS thinkphp) AS T1 [ RunTime:0.001646s ]
