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