SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001487s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201477 LIMIT 1 [ RunTime:0.002679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201477 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21434,98818,731184,530917,322257,533212,995770,145144,377632,648736,606107,10275,505653,468548,149870,143963,5326,1037141,344801,972912,383641,831596,466136,221699,821289,584065,60025,78272,886129,261741,906581,353733,613797,365790,577583,468527,450374,74966,94625,946560,48154,925765,859376,587473,960554,293013,20258,286440,971848,20535,752428,745866,46784,1029187,599493,306087,372737,909938,209380,515471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]