基本
文件
流程
错误
SQL
调试
- 请求信息 : 2022-05-16 15:36:40 HTTP/1.1 GET : http://www3.koreano.cn/home/goods/list.html?cid=17
- 运行时间 : 0.154611s [ 吞吐率:6.47req/s ] 内存消耗:4,160.47kb 文件加载:145
- 查询信息 : 85 queries
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=d98510f247f612f7bc60f30217fc00f6
- CONNECT:[ UseTime:0.014190s ] sqlsrv:Database=koreanosite;Server=192.168.1.6,1433
- 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.001108s ]
- 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.001161s ]
- 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.001343s ]
- SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [cat_id] FROM [ems_category] WHERE [pid] = 17) AS thinkphp) AS T1 [ RunTime:0.000635s ]
- 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_goods' [ RunTime:0.001067s ]
- SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT COUNT(*) AS think_count FROM [ems_goods] WHERE [cid] = 17 AND [is_show] = 1) AS thinkphp) AS T1 [ RunTime:0.001013s ]
- SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [ems_goods] WHERE [cid] = 17 AND [is_show] = 1) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 12) [ 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] = 0 AND [is_open] = 1 AND [is_nav] = 0) AS thinkphp) AS T1 [ RunTime:0.001133s ]
- 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.000998s ]
- 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.000805s ]
- 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.000731s ]
- 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.000704s ]
- 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.000764s ]
- 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.000793s ]
- 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.000644s ]
- 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.000632s ]
- 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.000584s ]
- 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.000739s ]
- 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.000619s ]
- 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.000707s ]
- 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.000749s ]
- 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.000696s ]
- 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.000814s ]
- 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.000789s ]
- 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.000816s ]
- 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.000638s ]
- 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.000737s ]
- 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.000683s ]
- 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.000725s ]
- 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.000637s ]
- 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.000664s ]
- 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.000536s ]
- 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.000683s ]
- 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.000869s ]
- 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.000911s ]
- 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.000671s ]
- 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.000825s ]
- 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.000639s ]
- 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.000625s ]
- 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.000745s ]
- 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.000582s ]
- 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.000726s ]
- 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.000658s ]
- 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.000622s ]
- 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.000643s ]
- 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.000891s ]
- 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.000843s ]
- 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.000616s ]
- 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.000709s ]
- 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.000671s ]
- 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.000938s ]
- 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.000983s ]
- 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.000786s ]
- 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.000804s ]
- 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.000696s ]
- 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.000755s ]
- 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.000684s ]
- 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.000680s ]
- 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.000634s ]
- 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.000642s ]
- 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.000670s ]
- 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.000591s ]
- 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.000594s ]
- 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.000607s ]
- 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.000725s ]
- 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.000674s ]
- 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.000598s ]
- 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.000592s ]
- 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.000621s ]
- 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.000596s ]
- 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.000625s ]
- 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.000724s ]
- 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.000575s ]
- 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.000550s ]
- 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.000596s ]
- 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.000826s ]
- 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.000758s ]
- 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.000582s ]
- 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.000638s ]
- 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.000642s ]
- 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.000733s ]
- 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.000789s ]
- 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.000621s ]

0.157313s