SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549703 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549703 [ RunTime:0.002216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519441,808067,56900,152883,402575,514750,921937,310221,30899,110605,736141,700647,452148,260874,906838,608398,1003071,150607,742949,133727,892074,466808,28327,475470,802976,143353,26565,929300,223703,169360,478312,187125,878585,961294,315226,93554,387740,303854,384985,977885,967467,64374,750941,194206,31678,604715,607354,490819,773274,711286,878653,167623,348020,786384,469331,659709,840623,933557,945022,653791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000361s ]