SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 850083 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 850083 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30005,596929,279639,199240,225841,752381,77335,389228,931126,15894,327895,841781,212922,170866,489511,868013,115163,142512,91092,247006,860910,628183,881117,523548,838895,91981,710677,366525,63684,227795,7144,486540,281791,395477,230190,468058,979505,144608,490882,302517,920123,337422,1020168,820692,908774,183660,583937,782062,591086,551787,884764,172069,882078,560754,802432,514467,435135,494975,492675,140564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 850083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 850083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000744s ]