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