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