SELECT
        CAST(
            AVG(
                ABS(TIMESTAMPDIFF(SECOND,a.time,b.time))
            ) AS SIGNED
            ) AS gap
    FROM order_log AS a
    INNER JOIN select_log AS b
        ON (a.order_id = b.order_id)