SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575203 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575203 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (873382,992910,3924,286998,1012237,789994,627546,730117,500518,270704,197780,878737,219577,519177,61951,946154,740030,568142,399147,783075,72764,949435,772565,601621,679569,344647,858154,19441,582479,838846,656354,318197,857991,975215,96311,319246,151465,859532,998468,322490,645309,641101,688808,853329,219131,702603,772718,600073,651016,785321,545966,880026,434848,147365,134147,216167,963158,355904,823378,463713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]