SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311343 LIMIT 1 [ RunTime:0.001756s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311343 [ RunTime:0.003289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989848,383869,680337,800547,120643,793199,209684,379065,853309,433871,556293,704591,385749,814512,175972,412780,476116,455982,717850,785674,762828,187645,512492,929074,759699,870716,804289,624915,944129,52523,223809,543039,812225,197223,373805,804721,55586,924458,620303,786083,275010,116702,224065,289958,989159,102005,1047408,828233,467296,678229,909933,738898,199387,585119,987857,267638,792007,640813,161259,209811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000924s ]