SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1081 LIMIT 1 [ RunTime:0.000531s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1081 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469041,650885,507438,528898,133917,84142,461343,641913,873456,668731,502625,216531,244180,337682,282997,546003,821049,988432,365256,693437,731422,81939,310869,857126,197608,753720,657839,644701,750468,1018682,86262,444900,483000,131718,419358,677650,6638,490524,30415,275409,3612,514915,917904,450420,845428,789178,402722,966335,1045732,38704,449319,176048,31652,328716,395645,232632,135804,309231,997634,727516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]