SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533847 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533847 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (537073,55849,844315,490098,411865,1018161,543885,412588,25850,198404,175309,342537,923122,790290,691105,413878,366757,75562,275023,103859,190505,616566,729652,561346,451813,889973,153503,380938,540697,443249,581658,910077,749595,912135,1007252,439213,403450,149107,257566,1019006,1045037,986249,215014,708328,332333,169507,352350,651482,961639,161737,788556,572577,620023,508011,656526,170970,51996,36058,183013,834610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]