SELECT t1.* FROM
bc_barcode_details AS t1
INNER JOIN
bc_barcode_details AS t2
ON t1.`BarcodeID` = t2.`BarcodeID` AND t1.`BarcodePageIndex` != t2.`BarcodePageIndex`
AND t1.`PageStatus` != t2.`PageStatus`
SELECT t1.* FROM
(SELECT * FROM bc_barcode_details) AS t1
INNER JOIN
(SELECT * FROM bc_barcode_details) AS t2
ON t1.`BarcodeID` = t2.`BarcodeID` AND t1.`BarcodePageIndex` != t2.`BarcodePageIndex`
AND t1.`PageStatus` != t2.`PageStatus`
第一个SQL语句执行的时间比第二个多的太多了,求下原理,为什么,怎么做
第一个sql语句执行3分多,第二个2秒