SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002637s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423571 LIMIT 1 [ RunTime:0.000662s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423571 [ RunTime:0.008426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978843,530800,721519,879249,633968,697677,464114,872824,886876,57186,934319,584337,36770,418914,782462,345776,880186,634367,819280,396233,937889,1041837,31391,211170,224072,706402,92708,692990,563698,967583,127590,607141,737073,396886,96112,824143,161972,320538,63862,636226,423765,516963,819143,308472,156747,172926,229226,280532,88362,784461,68705,273306,490931,321738,540698,147552,468323,74361,678098,370104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]