SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292514 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292514 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68848,2951,401959,208204,980975,62570,960099,604195,889833,1025475,548247,931899,906228,340416,643118,1002989,586160,317992,219172,287896,397548,574774,623981,610031,54816,986823,798114,662767,611606,569148,79437,830216,760964,602977,740027,613384,940258,406842,189124,34343,296705,414659,638311,521809,972874,117206,686223,553794,5401,700420,954365,452859,135264,1020933,110953,496539,989798,196333,686890,483323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]