SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 271081 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 271081 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902337,144271,440542,873110,641884,190520,422798,125166,367356,406046,325792,712587,328167,383592,550901,483737,532571,255972,915386,1000923,93775,635006,1013003,43753,955273,36919,615430,36543,15579,239925,724927,618793,500163,919420,59212,293317,22639,948741,843253,997068,253811,967577,143527,269328,44700,857935,288830,199948,8695,473841,345665,124030,685114,210664,566844,824981,53226,200910,724088,297598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 271081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 271081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]