SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685312 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685312 [ RunTime:0.002024s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466251,824339,662992,492091,834528,803201,556934,557536,239734,618597,187928,463375,266774,120902,198993,740734,86944,674711,53215,293760,616958,611633,113978,380299,554254,745988,589887,957586,436884,195756,445867,177901,202998,491689,386249,671124,996034,177469,896421,670674,548997,217200,555561,634587,302777,922696,205743,84187,991796,187515,459465,1004827,172476,314952,20404,95166,30541,204749,872707,306448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]