SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539254 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539254 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270893,241728,836990,163674,356441,244302,824928,817584,974366,907899,87887,427849,162710,159761,693018,661575,787711,428943,520849,513001,165751,178628,433255,652929,989104,287362,45230,416366,1033623,822873,912514,629549,1045899,900706,771261,288086,679491,566108,615643,589939,639984,833607,283532,324905,847819,971909,940111,540232,675662,758158,985779,702031,143096,287700,721124,95183,464330,732012,102481,791355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539254 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539254 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]