SELECT 
    logtime,
    logapi,
    logapipost,
    JSON_VALUE(logapipost, '$.KSSJ') AS KSSJ,
    JSON_VALUE(logapipost, '$.JSSJ') AS JSSJ
FROM 
    sys_log_histroy
WHERE 
    logapipost LIKE '%1438978841787875328%'
    AND logapipost LIKE '%KSSJ%' 
    AND logapipost LIKE '%JSSJ%'
ORDER BY 
    logtime;