生产环境，oceanBase 云平台，版本号: 4.2.2-20240315150745，分配的mysql类型数据库，
SELECT
kmimissive0_.fd_id AS fd_id1_2414_,
kmimissive0_.fd_is_offline AS fd_is_of2_2414_,
kmimissive0_.fd_is_topiced AS fd_is_to3_2414_,
kmimissive0_.fd_is_supervised AS fd_is_su4_2414_,
kmimissive0_.fd_supervise_flag AS fd_super5_2414_,
kmimissive0_.fd_reserve_one AS fd_reser6_2414_,
kmimissive0_.fd_reserve_two AS fd_reser7_2414_,
kmimissive0_.doc_delete_flag AS doc_dele8_2414_,
kmimissive0_.doc_delete_time AS doc_dele9_2414_,
kmimissive0_.doc_delete_by AS doc_del10_2414_,
kmimissive0_.fd_reserve_three AS fd_rese11_2414_,
kmimissive0_.fd_reserve_four AS fd_rese12_2414_,
kmimissive0_.fd_reserve_five AS fd_rese13_2414_,
kmimissive0_.fd_isfrom_out AS fd_isfr14_2414_,
kmimissive0_.convert_show_flag AS convert15_2414_,
kmimissive0_.fd_is_change_pdf AS fd_is_c16_2414_,
kmimissive0_.fd_is_instruct AS fd_is_i17_2414_,
kmimissive0_.fd_instruct_num AS fd_inst18_2414_,
kmimissive0_.fd_instruct_time AS fd_inst19_2414_,
kmimissive0_.fd_instruct_content AS fd_inst20_2414_,
kmimissive0_.fd_other_num AS fd_othe21_2414_,
kmimissive0_.fd_to_unit_id AS fd_to_u22_2414_,
kmimissive0_.fd_instruct_leader AS fd_inst23_2414_,
kmimissive0_.fd_old_data AS fd_old_24_2414_,
kmimissive0_.fd_main_id AS fd_main25_2414_,
kmimissive0_.fd_need_content AS fd_need26_2414_,
kmimissive0_.fd_detail_id AS fd_deta27_2414_,
kmimissive0_.fd_third_id AS fd_thir28_2414_,
kmimissive0_.fd_is_advice AS fd_is_a29_2414_,
kmimissive0_.fd_is_return AS fd_is_r30_2414_,
kmimissive0_.fd_is_writesignopinion AS fd_is_w31_2414_,
kmimissive0_.fd_readsend_opinion AS fd_read32_2414_,
kmimissive0_.fd_deliver_type AS fd_deli33_2414_,
kmimissive0_.fd_receive_time AS fd_rece34_2414_,
kmimissive0_.fd_receive_num AS fd_rece35_2414_,
kmimissive0_.fd_doc_flow AS fd_doc_36_2414_,
kmimissive0_.fd_flow_no AS fd_flow37_2414_,
kmimissive0_.fd_no_rule AS fd_no_r38_2414_,
kmimissive0_.fd_record_time AS fd_reco39_2414_,
kmimissive0_.fd_sign_time AS fd_sign40_2414_,
kmimissive0_.fd_out_sendto AS fd_out_41_2414_,
kmimissive0_.fd_share_num AS fd_shar42_2414_,
kmimissive0_.fd_last_modified_time AS fd_last43_2414_,
kmimissive0_.sign_type AS sign_ty44_2414_,
kmimissive0_.fd_recorder AS fd_reco45_2414_,
kmimissive0_.fd_signer AS fd_sign46_2414_,
kmimissive0_.fd_receive_unit AS fd_rece47_2414_,
kmimissive0_.auth_area_id AS auth_ar48_2414_,
kmimissive0_.doc_subject AS doc_sub49_2414_,
kmimissive0_.fd_template_id AS fd_temp50_2414_,
kmimissive0_.fd_number_main_id AS fd_numb51_2414_,
kmimissive0_.fd_table_head AS fd_tabl52_2414_,
kmimissive0_.fd_doc_num AS fd_doc_53_2414_,
kmimissive0_.fd_content AS fd_cont54_2414_,
kmimissive0_.fd_handle_result AS fd_hand55_2414_,
kmimissive0_.fd_use_form AS fd_use_56_2414_,
kmimissive0_.extend_file_path AS extend_57_2414_,
kmimissive0_.doc_read_count AS doc_rea59_2414_,
kmimissive0_.auth_att_nodownload AS auth_at60_2414_,
kmimissive0_.auth_att_nocopy AS auth_at61_2414_,
kmimissive0_.auth_att_noprint AS auth_at62_2414_,
kmimissive0_.auth_reader_flag AS auth_re63_2414_,
kmimissive0_.doc_status AS doc_sta64_2414_,
kmimissive0_.doc_alter_time AS doc_alt65_2414_,
kmimissive0_.doc_publish_time AS doc_pub66_2414_,
kmimissive0_.doc_publish_time_upper AS doc_pub67_2414_,
kmimissive0_.doc_publish_time_num AS doc_pub68_2414_,
kmimissive0_.doc_create_time AS doc_cre69_2414_,
kmimissive0_.fd_year_no AS fd_year70_2414_,
kmimissive0_.fd_no_create_time AS fd_no_c71_2414_,
kmimissive0_.fd_dead_time AS fd_dead72_2414_,
kmimissive0_.fd_model_name AS fd_mode73_2414_,
kmimissive0_.fd_model_id AS fd_mode74_2414_,
kmimissive0_.fd_is_filing AS fd_is_f75_2414_,
kmimissive0_.fd_filing_time AS fd_fili76_2414_,
kmimissive0_.fd_change_reader_flag AS fd_chan77_2414_,
kmimissive0_.fd_rbp_flag AS fd_rbp_78_2414_,
kmimissive0_.fd_change_att AS fd_chan79_2414_,
kmimissive0_.fd_filinger_id AS fd_fili80_2414_,
kmimissive0_.doc_create_id AS doc_cre81_2414_,
kmimissive0_.fd_secret_grade AS fd_secr82_2414_,
kmimissive0_.fd_emergency_grade AS fd_emer83_2414_,
kmimissive0_.fd_sendto_unit AS fd_send84_2414_,
kmimissive0_.fd_secret_grade_str AS fd_secr85_2414_,
kmimissive0_.fd_emergency_grade_str AS fd_emer86_2414_,
kmimissive0_.fd_doc_type_str AS fd_doc_87_2414_,
kmimissive0_.fd_doc_type AS fd_doc_88_2414_,
kmimissive0_.doc_alteror_id AS doc_alt89_2414_,
kmimissive0_.fd_is_paradigm AS fd_is_p90_2414_
FROM
km_imissive_receive_main kmimissive0_
WHERE
kmimissive0_.fd_id IN (
SELECT
kmimissive1_.fd_id
FROM
km_imissive_receive_main kmimissive1_
INNER JOIN km_imissive_rmain_areader authallrea2_ ON kmimissive1_.fd_id = authallrea2_.fd_main_id
INNER JOIN sys_org_element sysorgelem3_ ON authallrea2_.auth_all_reader_id = sysorgelem3_.fd_id
INNER JOIN sys_org_element sysorgpers4_ ON kmimissive1_.doc_create_id = sysorgpers4_.fd_id
INNER JOIN sys_org_person sysorgpers4_1_ ON sysorgpers4_.fd_id = sysorgpers4_1_.fd_id
WHERE
( kmimissive1_.fd_receive_time BETWEEN ‘2025-07-12 23:59:59’ AND ‘2026-01-13 23:59:59’ )
AND ( kmimissive1_.fd_is_offline = 0 OR kmimissive1_.fd_is_offline IS NULL )
AND ( kmimissive1_.fd_is_instruct IS NULL OR kmimissive1_.fd_is_instruct = ‘’ )
AND ( kmimissive1_.doc_status <> ‘10’ OR kmimissive1_.doc_status = ‘10’ AND sysorgpers4_.fd_id = ‘18faa7cb3446333717e39354ba2830f1’ )
AND 1 = 1
AND kmimissive1_.doc_status <> ‘00’
AND (
sysorgelem3_.fd_id IN (
‘1183b0b84ee4f581bba001c47a78b39d’,
‘18faa7cb3446333717e39354ba2830f1’,
‘18ffad51d3b6773e7be866540b09af66’,
‘19033216dc5a342bd26d1784cfd8534a’,
‘1905d8966f2a6fcf140e29f4d3f8a355’,
‘196d66f57d2553ca09a45394eb18f58a’,
‘194490954ba764568f70e06465b9b9db’,
‘1973a56bb9a7a67e66e6eb8483fbb47e’,
‘18faa788b88802089896e434e64bb9b2’,
‘18fdd5bf42d347b93cb47f94a8fb5b44’,
‘18faa788dafb58761cc5ef7488eb6bac’,
‘1919801a51f519030511aa84c969186e’,
‘1919836808507707fbb46874819b3b54’,
‘1917e57ce08b51e72da1911485288895’
)
)
AND kmimissive1_.doc_delete_flag = 0
)
ORDER BY
kmimissive0_.fd_receive_time DESC,
kmimissive0_.fd_id DESC
limit 15;
这个sql,去掉limit运行时间为0.4s,出结果，不加上limit则需要25s才能出结果， 按时加上limit sql不应该运行速度会更快吗？我该怎么修复这种类似的sql问题。