ID_, PRIVATE_CLOUD_APPLY_ID_, CLOUD_TYPE_, USE_TYPE, CPU_NUM_TOTAL_, CPU_NUM_USE_, CPU_NUM_USE_RATE_, MEMORY_CAPACITY_TOTAL_, MEMORY_CAPACITY_USE_, MEMORY_CAPACITY_USE_RATE_, STORAGE_CAPACITY_TOTAL_, STORAGE_CAPACITY_USE_, STORAGE_CAPACITY_USE_RATE_, CREATE_BY_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ SELECT * FROM biz_cloud_apply_use_detailed b WHERE PRIVATE_CLOUD_APPLY_ID_ = ( SELECT ID_ FROM biz_cloud_apply WHERE IS_DELE_ = '0' AND STATUS_ = '40' ORDER BY CREATE_TIME_ DESC LIMIT 1 ) AND USE_TYPE = 2 ORDER BY CLOUD_TYPE_;