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.001683s ]
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.001452s ]
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.001689s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [cat_id] = 20) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.000989s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_category] WHERE [pid] = 20) AS thinkphp) AS T1 [ RunTime:0.000618s ]
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.000940s ]
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.000948s ]
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.000753s ]
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.000788s ]
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.000884s ]
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.000808s ]
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.000778s ]
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.000834s ]
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.000754s ]
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.000720s ]
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.000858s ]
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.000720s ]
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.000677s ]
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.000692s ]
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.000705s ]
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.000820s ]
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.000647s ]
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.000778s ]
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.000806s ]
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.000620s ]
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.000814s ]
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.000942s ]
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.000866s ]
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.000929s ]
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.000710s ]
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.000593s ]
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.000728s ]
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.000640s ]
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.000602s ]
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.000600s ]
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.000648s ]
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.000677s ]
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.000616s ]
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.000587s ]
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.000726s ]
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.000687s ]
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.000676s ]
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.000700s ]
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.000699s ]
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.000941s ]
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.000829s ]
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.000749s ]
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.000617s ]
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.000633s ]
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.000835s ]
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.000636s ]
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.000653s ]
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.000627s ]
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.000592s ]
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.000632s ]
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.000677s ]
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.000600s ]
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.000686s ]
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.000634s ]
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.000657s ]
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.000633s ]
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.000664s ]
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.000875s ]
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.000782s ]
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.000662s ]
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.000582s ]
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.000966s ]
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.000789s ]
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.000601s ]
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.000615s ]
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.000645s ]
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.000644s ]
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.000503s ]
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.000549s ]
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.000560s ]
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.000561s ]
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.000591s ]
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.000586s ]
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.000672s ]
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.000663s ]
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.000592s ]
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.000552s ]
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.000669s ]
