select
        cast(avg(abs(timestampdiff(second,ol.logtime,sl.logtime))) as signed) as gap
    from 
            order_log as ol
    left join
            select_log as sl
    on 
            ol.order_id = sl.order_id