#explain 
SELECT 
    x.ddl,
    n.clazz,
    IF(n.clazz IN ('33' , '54'),
        'HONG KONG',
        t.mddmc1),
    IF(dt = '', optime, dt) AS orderdt,
    y.ydh AS waybillno
    ,x.para AS ordersn
FROM
    n_op n
        LEFT JOIN
    s_branch b ON b.branch_cd = n.yyd,
    y_yd y,
    s_khdl s,
    y_pack p,
    x_jdparcel x,
    t_mdd t
WHERE
n.ydh = 'DS01172673' 
#and x.ddl = '5101711976' 
and
    n.ydh = y.ydh AND y.khdm = s.gsdm
        AND s.company = 'JOLLY'
        AND n.clazz NOT IN ('' , 'HAND')
        AND y.tyjzt NOT IN ('NE' , 'DR')
        AND y.ydh = p.ydh
        AND p.code = x.bddl
        AND x.customercode = s.gsdm
        AND x.clazz = 'AIRCARGO'
        AND IFNULL(b.city, n.yyd) = t.mdddm
        AND optime BETWEEN '2019-10-01 04:19:01' AND '2019-11-35 07:20:31'
        AND (n.clazz IN ('0' , '33', '54', '55', '98', '99')
        OR (n.clazz = '22' AND y.iyjxz = 'LT'
        AND n.yyd = 'KC')
        OR (n.clazz = '44' AND n.yyd = y.tpsdl
        AND y.iyjxz = 'LT')
        OR (n.clazz = '66' AND y.iyjxz = 'TS')
        OR (n.clazz = '22' AND y.iyjxz = 'TS'))
ORDER BY 
x.ddl , 
orderdt , n.clazz
limit 
;