SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484831 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484831 [ RunTime:0.001599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507492,430995,670251,265137,269354,736737,86042,989938,209667,925401,456216,444844,598624,231574,482904,903585,516483,1038314,474546,792392,360734,223378,815371,673066,776503,40015,363601,433800,742823,163446,508314,314146,158791,952422,139716,427612,938135,998393,45270,820115,506823,1034875,199655,314872,158238,661601,391294,578587,169108,84550,681066,750718,662335,540244,957314,763523,66005,138121,339339,1025055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]