Optimize queries for main views #374
Description
Several views could load faster by optimizing their queries.
- dashboard
- create_reference
- create_taxa
- create_location
- create_authors
- upload_media_step1
- upload_media_step2
- synchronize_fields
- editing_media_details
- search_media
- filter_medias
- editing_media_list
- my_media_details
- my_media_list
- manage_users
- revision_media_list
- revision_modified_media
- revision_media_details
- my_curations_media_list
- my_curations_media_details
- download_media
- tour_list
- tour_add
- tour_details
- get_tour_medias
- search_page
- org_page
- old_media
- media_page
- tour_page
- taxa_page
- places_page
- tags_page
- contributors_page
- refs_page
- tours_page
- press_page
- catch_get