SELECT
    id as id,
    deviceId as deviceId,
    username as username,
    cast(localtime as datetime) as localtime,
    AC as AC, FM as FM, UC as UC,
    DL as DL, DS as DS, DP as DP,
    LB as LB, ASTV as ASTV, MSTV as MSTV
FROM
    iot