SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201606 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201606 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172374,434986,297390,73200,28807,726055,960199,333259,66271,250455,265088,1018273,170696,662177,299167,427802,548838,186783,408249,797763,254895,244433,1008859,231902,872986,991984,40859,750924,796137,639216,734071,344150,958974,270653,958280,31411,436477,249127,577388,763921,734969,1020180,1011794,333912,322506,115567,764527,479794,559090,18664,374193,83079,818467,503451,70625,679125,560382,63848,322648,458827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201606 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201606 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]