SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 60441 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 60441 [ RunTime:0.002153s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289323,1019210,544028,565947,949589,465290,1013102,168997,490350,1017065,28746,350120,810920,817819,967718,673608,497541,698876,846641,698013,401248,382138,997908,531354,104853,15391,55657,1018384,917774,34859,911365,357486,817228,245344,552290,81233,688981,614226,271882,753228,391463,563108,837316,354733,773405,324015,801975,653011,554764,1017211,426876,759629,933914,370350,641332,361396,900916,451877,481051,331058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 60441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 60441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]