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