SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335590 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335590 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509957,979573,710347,521271,89049,82203,464854,262942,64185,709865,27827,141343,165342,258546,43615,32909,762322,889545,463410,925574,89438,1042532,172944,383726,322582,881399,510523,1047277,825544,36784,951636,77731,655313,391332,9444,387447,307505,512970,523047,1047643,252222,107981,949090,378262,571371,950101,786969,548942,168184,363332,122777,13015,474685,577368,913004,765572,837972,859250,276630,39171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]