We should not be using `ON DUPLICATE KEY` on tables with an `AUTO_INCREMENT` because it will increment the `id` when no insert occurs. It looks like this comment should be removed, we're using the `INSERT/SELECT... FROM DUAL WHERE NOT EXISTS` strategy everywhere.