SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148451 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148451 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412510,649078,783065,431632,496254,84986,548109,48571,574740,200907,614079,1120,41334,674440,397925,129076,142160,306607,17008,184064,699232,207620,309841,147196,831336,263517,682990,931426,787520,648199,209104,788805,692138,970625,612243,834187,913624,614265,858798,327840,115004,535555,955081,526579,513217,219754,160440,747898,66656,533981,891903,980862,659459,237593,317065,810946,102358,369444,35111,816729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]