SELECT CAST(AVG(ABS(TIMESTAMPDIFF(SECOND,o.logtime,s.logtime))  ) AS UNSIGNED)   AS gap
FROM order_log AS o JOIN select_log AS s ON o.order_id = s.order_id