SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546563 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546563 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904285,591213,283403,385486,71803,808399,699349,340088,511365,204180,585123,961222,965700,622023,750719,575763,465748,41667,225211,361428,423270,43665,135201,681819,822309,303977,728723,246408,556875,551208,873504,828006,151336,247561,250304,540525,966603,1017415,918,566698,442556,610950,779716,471281,498649,523362,709303,652982,931376,285701,380447,521034,902898,410695,919579,661747,900842,425887,721342,175684) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]