SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036676 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036676 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (330749,865920,678407,763405,606715,740641,422898,527851,21147,75928,986097,771758,92667,965849,402851,24200,468060,968586,942882,463127,637471,386150,91578,956931,765080,813863,641255,151407,23196,680789,515947,416395,560551,581271,477936,1007147,760033,415567,1048413,121269,176543,7327,784648,69649,556939,9439,178498,869589,1026608,414863,93967,995426,521933,38221,204,573139,523754,719752,1032770,163135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036676 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036676 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]