SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516701 LIMIT 1 [ RunTime:0.001949s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516701 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826144,528848,595967,420128,189968,734511,1010196,914661,273455,75113,703170,690633,889778,904912,1045756,850208,306424,12646,988877,818209,137651,463841,367069,66136,787413,327090,728540,552956,675144,369378,929422,752953,767623,356465,931783,590188,148572,197407,228420,173735,797062,795188,335718,453014,631740,278716,660735,362180,502886,602460,487744,645913,65767,269229,250491,951071,286645,386703,619473,967453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]