This Query working fast : Showing rows 0 - 19 (20 total, Query took 1.8746 sec)
SELECT t_working_field.wf_id, t_working_field.field_id, t_working_field.wf_name_en, t_working_field.wf_name_ar, t_working_field.wf_owner_name_en, t_working_field.wf_owner_name_ar, t_working_field.wf_desc_en, t_working_field.wf_desc_ar, t_working_field.wf_join_date, t_working_field.wf_leaving_date, t_working_field.logo_url, t_working_field.working_hour, t_working_field.Tell, t_working_field.Mobile, t_working_field.Fax, t_working_field.Email, t_working_field.zipcode, t_working_field.pobox, t_working_field.membership_id, t_working_field.membership_join_date, t_working_field.url, t_working_field.Display_specialty, t_working_field.f_d_home_phone, t_working_field.f_d_home_check, t_working_field.f_d_pharmacist, t_working_field.f_d_on_duty, t_working_field.f_d_tests_types, t_working_field.f_d_docs_specialist, t_working_field.f_d_medicine_list, t_working_field.active, t_sponsor.s_id, t_doc_member.doc_member_id, t_membership.membership_name_en, field.field_name_en, t_type.type_name_en, location_en
FROM t_working_field, t_working_field_type
LEFT JOIN t_sponsor ON t_sponsor.wf_id = t_working_field.wf_id
LEFT JOIN t_membership ON t_membership.membership_id = t_working_field.membership_id
LEFT JOIN field ON field.field_id = t_working_field.field_id
LEFT JOIN t_type ON t_type.type_id = t_working_field_type.type_id
AND t_working_field_type.wf_id = t_working_field.wf_id
LEFT JOIN t_working_field_location ON t_working_field_location.wf_id = t_working_field.wf_id
LEFT JOIN t_doc_member ON t_doc_member.wf_id = t_working_field.wf_id
WHERE t_working_field.field_id =1
AND t_membership.membership_id =1
AND t_working_field_location.country_id =1
AND t_working_field_location.city_id =1
AND t_working_field_type.type_id =1
AND t_sponsor.wf_id IS NULL
AND t_type.type_name_en IS NOT NULL
ORDER BY t_working_field.wf_id
LIMIT 0 , 20
=============================================================
This Query Very Slow: Showing rows 0 - 4 (5 total, Query took 30.6405 sec)
SELECT t_working_field.wf_id, t_working_field.field_id, t_working_field.wf_name_en, t_working_field.wf_name_ar, t_working_field.wf_owner_name_en, t_working_field.wf_owner_name_ar, t_working_field.wf_desc_en, t_working_field.wf_desc_ar, t_working_field.wf_join_date, t_working_field.wf_leaving_date, t_working_field.logo_url, t_working_field.working_hour, t_working_field.Tell, t_working_field.Mobile, t_working_field.Fax, t_working_field.Email, t_working_field.zipcode, t_working_field.pobox, t_working_field.membership_id, t_working_field.membership_join_date, t_working_field.url, t_working_field.Display_specialty, t_working_field.f_d_home_phone, t_working_field.f_d_home_check, t_working_field.f_d_pharmacist, t_working_field.f_d_on_duty, t_working_field.f_d_tests_types, t_working_field.f_d_docs_specialist, t_working_field.f_d_medicine_list, t_working_field.active, t_sponsor.s_id, t_doc_member.doc_member_id, t_membership.membership_name_en, field.field_name_en, t_type.type_name_en, location_en
FROM t_working_field, t_working_field_type
LEFT JOIN t_sponsor ON t_sponsor.wf_id = t_working_field.wf_id
LEFT JOIN t_membership ON t_membership.membership_id = t_working_field.membership_id
LEFT JOIN field ON field.field_id = t_working_field.field_id
LEFT JOIN t_type ON t_type.type_id = t_working_field_type.type_id
AND t_working_field_type.wf_id = t_working_field.wf_id
LEFT JOIN t_working_field_location ON t_working_field_location.wf_id = t_working_field.wf_id
LEFT JOIN t_doc_member ON t_doc_member.wf_id = t_working_field.wf_id
WHERE t_working_field_location.city_id =4
AND t_type.type_name_en IS NOT NULL
ORDER BY t_working_field.wf_id
LIMIT 0 , 20