SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 940651 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 940651 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (842557,918390,151191,122078,390014,738012,685790,360635,570938,599320,941830,256761,701023,622269,898815,4938,997582,662244,1038900,1014490,250062,464032,287249,402395,815462,200995,156338,126254,624664,861517,843356,12130,687383,1011862,908407,449781,442009,711313,377734,260174,199036,590171,853331,63255,740206,57113,445986,551505,820480,174116,700233,540500,324351,423350,831940,792395,610981,448918,996963,401014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 940651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000693s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 940651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]