SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023027 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023027 [ RunTime:0.001998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174233,518370,647464,421660,101308,261486,410977,504089,674494,591340,693983,224866,550321,154593,605825,903760,907921,912899,828591,844407,876562,734978,951407,808313,116094,787924,198821,295680,291713,642014,704972,398012,781341,470655,427757,568381,993231,596941,759494,125230,919038,889775,753021,663963,684454,849144,527517,551495,526585,576226,890962,556258,533593,888332,842290,968831,341183,317757,266526,284224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]