SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672523 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672523 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334354,516473,378180,514919,537224,318905,590852,201238,418923,582088,684921,936281,753742,90606,463406,237530,659054,500430,925906,955717,491239,903378,388516,299414,1039331,445011,1004928,589816,836763,54508,482324,559661,215072,765461,36498,997020,930623,429705,833189,292227,977409,946785,468590,1004558,599809,889766,54004,197593,413122,684055,58934,719592,97502,405762,165531,342203,469200,679931,264647,239990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]