SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406621 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406621 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331706,698726,285853,925089,912110,368139,881558,574079,300090,928229,321032,417848,627126,942334,243113,110870,618608,724140,742623,899255,794172,136623,114105,476973,400999,250805,803448,202095,81845,715761,1022246,877113,944687,509966,449313,932933,708375,163934,760916,92138,30625,74765,394848,479450,252250,228871,1003431,615273,934058,1038936,324193,628198,421819,868067,44185,700586,352088,596570,51175,203728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000685s ]