如何优化这个复杂的EAV MYSQL查询？

实际上，Chibuzo是正确的。首先删除它：-)）但是在此之前，先玩一下，这是很好的大脑锻炼，例如象棋之类的东西:-)

select     case_id,    d_status.data_field_value as case_status,    d_client1_name.forename_company as client1_forename_companyfrom db_cases         join db_data as d_status  on d_status.data_case_id = case_id     AND d_status.data_field_name = 'casestatus'        join db_data as d_client1 on d_client1.data_case_id = case_id     AND d_client1.data_field_name = 'client1'        join db_names as d_client1_name on d_client1_name.name_id = d_client1.data_field_value

我希望没有子查询的这些直接联接会更加高效，尽管您必须对其进行测试-优化经常会让人感到意外。