SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920469 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920469 [ RunTime:0.004997s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034981,17401,958196,403354,884678,605106,25882,46284,603276,497525,650543,217387,455520,1001974,584325,177156,822835,160371,861819,324140,289387,611226,412318,646594,752581,679289,1015807,404470,155463,291012,578340,555084,351792,52642,467626,491040,778564,33122,225393,460820,483395,707683,22545,321614,693401,554959,571239,880928,768139,1026192,740758,128357,965334,824914,903449,36558,990055,396375,311062,914946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]