SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 936183 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 936183 [ RunTime:0.001975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021022,256014,364670,203666,898886,336103,747402,434166,755786,225337,610511,741911,14357,901509,239347,891111,515399,937047,507781,765849,279419,57670,411485,227432,60035,695155,979737,567890,135127,367774,78185,758602,588317,799937,425330,168689,1036596,148983,23918,763912,952753,35251,302764,684602,464798,312944,499214,634295,894938,261419,90640,579625,806350,164949,217884,12650,912315,947723,764937,506523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 936183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 936183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]