SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531048 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531048 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369865,1002064,508553,743837,748096,255553,743818,357154,96195,326722,929969,1898,728312,802246,309111,474271,995560,965900,662002,63758,367481,40702,810712,717524,660326,458508,221340,91214,1032977,216004,979168,405033,452348,56272,944722,735475,366110,569185,585428,297751,908324,580359,279858,837455,764164,243626,478606,388358,215546,774215,105597,719299,131819,622461,665876,765492,93049,485754,680460,500374) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]