SET @YEAR = EXTRACT(YEAR FROM now());
SET @MONTH = EXTRACT(MONTH FROM now());
INSERT INTO analytics (TYPE,path)
    SELECT  %d,
            '%s'
        FROM analytics
        WHERE NOT EXISTS (
            SELECT %d AS tmp
            FROM analytics
            WHERE EXTRACT(YEAR FROM ts) = @YEAR
                AND EXTRACT(MONTH FROM ts) = @MONTH
                AND `type`=%d
                AND `path`='%s'
            LIMIT 1
        );
UPDATE analytics
SET counter = counter + 1
WHERE EXTRACT(YEAR FROM ts) = @YEAR
    AND EXTRACT(MONTH FROM ts) = @MONTH
    AND `type`=%d
    AND `path`='%s';