SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001853 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001853 [ RunTime:0.003883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029199,763663,339012,118437,194206,779308,798665,69549,21829,404655,146132,585233,254581,761733,362237,47131,579380,17907,468479,396313,243280,44577,542274,378918,487685,208331,883914,854910,424670,157571,935291,906815,328223,64906,445492,820237,247818,871546,941043,1046805,806719,536345,911299,440903,239979,181275,8912,1007853,111120,715899,59582,576971,76138,647152,706543,126356,340419,323098,999068,438296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001853 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001853 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]