SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106911 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106911 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286866,462246,213134,259084,205395,1048745,568377,495436,796919,153396,402521,574925,20894,515329,453969,990947,681559,261339,205465,420139,808906,163318,806715,993188,931072,844859,811,980543,187896,394248,932697,837072,592890,489511,100020,358521,391690,237640,339677,864048,252796,555876,424479,64729,513436,825351,879738,279196,591225,333144,978974,458158,972739,894800,95528,829780,621753,826645,841518,998390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]