SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503980 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503980 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518713,205342,902163,392188,492440,948817,613561,596889,568743,662871,860012,288225,161990,863273,849713,321082,433681,41459,232757,342142,986832,688584,931985,525315,253588,624531,529274,1040757,935529,448953,517726,368461,106589,936030,954448,709803,733836,123422,370408,665773,523693,404676,51399,398452,400330,771869,67634,389734,271675,325924,556119,784253,493252,764690,523746,433978,24444,426057,173800,294994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]