SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504841 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504841 [ RunTime:0.002130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453432,390695,394319,427242,960669,481196,752180,30978,2625,1001496,868271,265106,948981,523259,173648,697760,925407,908076,414577,525721,102234,279002,1006667,420577,695066,257816,69865,190014,428281,296344,39125,448203,186482,757390,548218,947447,441787,684887,814079,998001,456131,401694,462162,553417,803487,15410,257457,988378,3611,185623,836260,701692,84892,878954,562007,676704,497151,26626,593627,203177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]