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.001488s ]
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.001041s ]
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.001769s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [cat_id] = 19) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.001051s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 19) AS thinkphp) AS T1 [ RunTime:0.001291s ]
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.001882s ]
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.001568s ]
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.001552s ]
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.001334s ]
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.001407s ]
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.001405s ]
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.001500s ]
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.001086s ]
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.001201s ]
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.001334s ]
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.001148s ]
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.001255s ]
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.001240s ]
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.001372s ]
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.001546s ]
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.001434s ]
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.001458s ]
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.001257s ]
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.001171s ]
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.000851s ]
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.001078s ]
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.001279s ]
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.001026s ]
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.001107s ]
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.001252s ]
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.001280s ]
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.001270s ]
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.001571s ]
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.001616s ]
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.001564s ]
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.001425s ]
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.001468s ]
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.001514s ]
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.001355s ]
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.001396s ]
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.001121s ]
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.001081s ]
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.001282s ]
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.001060s ]
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.001137s ]
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.001171s ]
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.001286s ]
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.001014s ]
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.001019s ]
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.001178s ]
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.001262s ]
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.001106s ]
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.001890s ]
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.001093s ]
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.000996s ]
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.001082s ]
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.001118s ]
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.000999s ]
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.001260s ]
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.001206s ]
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.000984s ]
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.001024s ]
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.000987s ]
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.000942s ]
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.001057s ]
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.001081s ]
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.000902s ]
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.000990s ]
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.000787s ]
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.000841s ]
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.000802s ]
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.000747s ]
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.000923s ]
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.000965s ]
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.001222s ]
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.001138s ]
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.000998s ]
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.000906s ]
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.001216s ]
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.001117s ]
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.001176s ]
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.001129s ]
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.001057s ]
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.001117s ]
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.001067s ]
