SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421096 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421096 [ RunTime:0.004364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712018,868514,656489,391829,199299,80228,50238,930711,365628,561856,483136,747486,841600,971285,270536,422281,1015056,174036,631358,974184,49568,14421,109785,777508,54625,411312,555974,88210,494355,875858,138573,316884,792025,42120,824931,891392,988870,957424,965670,199298,123500,697218,33591,96869,756300,257433,529738,1011603,822410,752474,388335,661636,862132,407969,438254,496585,942467,736882,842219,331193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002385s ]