SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020896 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020896 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276664,9842,105772,176135,480650,178485,972161,441398,58055,827094,670568,267043,964531,761927,470870,708062,885178,972515,97978,75249,148834,108517,257557,688615,719257,918855,813804,865940,873172,239456,382505,669558,1008762,226390,945614,304615,660618,788028,799345,70980,932764,546204,595153,192068,646100,871109,291978,750362,444331,649132,518049,557598,587559,860650,530764,915161,173880,531765,515435,950557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]