SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418149 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418149 [ RunTime:0.005541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211516,1034461,591265,396250,306241,150183,182767,193051,732136,1030448,888709,402786,314501,161776,453898,158218,79397,974087,526961,145882,321982,538505,921949,189503,374470,765146,930002,865231,347644,188698,143424,1011642,401309,1008050,981406,195016,566585,361270,51858,4150,927594,139570,147750,574329,524647,868237,988093,687892,630214,231914,301906,298381,399166,668840,966097,594221,140038,104174,758385,25518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002030s ]