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.001534s ]
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.001167s ]
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.001405s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [cat_id] = 22) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000965s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 22) AS thinkphp) AS T1 [ RunTime:0.000946s ]
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.001137s ]
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.001217s ]
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.001210s ]
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.001056s ]
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.001045s ]
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.000954s ]
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.001358s ]
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.000896s ]
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.000878s ]
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.000839s ]
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.000639s ]
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.000625s ]
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.000710s ]
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.000747s ]
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.000679s ]
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.000599s ]
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.000551s ]
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.000622s ]
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.000554s ]
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.000670s ]
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.000589s ]
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.000549s ]
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.000987s ]
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.000961s ]
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.002205s ]
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.001586s ]
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.000792s ]
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.000806s ]
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.001004s ]
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.001033s ]
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.000846s ]
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.001014s ]
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.000997s ]
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.000869s ]
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.000937s ]
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.001204s ]
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.000644s ]
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.000564s ]
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.000655s ]
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.000553s ]
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.000713s ]
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.000788s ]
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.000787s ]
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.000637s ]
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.000693s ]
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.000844s ]
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.000882s ]
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.000682s ]
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.000684s ]
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.000655s ]
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.000616s ]
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.000660s ]
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.000695s ]
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.000652s ]
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.000702s ]
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.000564s ]
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.000526s ]
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.000542s ]
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.000604s ]
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.005006s ]
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.000739s ]
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.000851s ]
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.000667s ]
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.000691s ]
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.000652s ]
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.000737s ]
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.000628s ]
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.000848s ]
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.000921s ]
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.000817s ]
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.000836s ]
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.000888s ]
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.000784s ]
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.000902s ]
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.002032s ]
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.000811s ]
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.000896s ]
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.000710s ]
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.000717s ]
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.000703s ]
