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 = 'Product' [ RunTime:0.008523s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [prd_new] desc,[sortid] desc,[updatetime] desc,[prd_name] asc) AS ROW_NUMBER FROM (SELECT * FROM [Product] WHERE [brd_id] = 16 AND [cat1_id] = 40 AND [online] = 1) AS thinkphp) AS T1 [ RunTime:0.017141s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [prd_new] desc,[sortid] desc,[updatetime] desc,[prd_name] asc) AS ROW_NUMBER FROM (SELECT * FROM [Product] WHERE [BRD_ID] = '16' AND [cat1_id] = 40 AND [online] = 1 AND [cat2_id] = 0) AS thinkphp) AS T1 [ RunTime:0.017149s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [prd_new] desc,[sortid] desc,[updatetime] desc,[prd_name] asc) AS ROW_NUMBER FROM (SELECT * FROM [Product] WHERE [BRD_ID] = '16' AND [cat1_id] = 40 AND [online] = 1 AND [cat2_id] = 2) AS thinkphp) AS T1 [ RunTime:0.016876s ]
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 = 'Pro_Cat1' [ RunTime:0.016167s ]
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Pro_Cat1] WHERE [BRD_ID] = '16' AND [id] = 40) AS thinkphp) AS T1 [ RunTime:0.015849s ]