SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318743 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318743 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (204134,967897,668538,973665,272478,509652,723655,1042943,851705,424433,932399,50192,166000,335607,959253,696367,141143,402135,161802,916632,916872,254505,339025,17036,849309,684586,107025,141590,884741,540906,297774,787821,259531,571741,680676,197379,8807,638914,520258,554941,12157,926581,828985,513360,499417,950651,240654,13527,912875,837789,308775,21744,381822,765408,4972,84464,963106,646455,397633,1031693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]