https://daf-middleware.wtdevsite.com/progress-report/2025?projectId=2

Query Metrics

7 Database Queries
4 Different statements
5.31 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
  "primary"
]
2 0.38 ms
SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
  "primary"
]
3 0.59 ms
SELECT t0.id AS id_1, t0.access_token AS access_token_2, t0.expires AS expires_3, t0.tenant_id AS tenant_id_4, t0.refresh_token AS refresh_token_5, t0.id_token AS id_token_6, t0.tag AS tag_7 FROM xero_storage t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
  "primary"
]
4 0.94 ms
SELECT f0_.id AS id_0, f0_.is_uptodate AS is_uptodate_1, f0_.project_update AS project_update_2, f0_.is_still_fundraising AS is_still_fundraising_3, f0_.project_active_status AS project_active_status_4, f0_.complete_film_year AS complete_film_year_5, f0_.is_complete_film_release AS is_complete_film_release_6, f0_.complete_film_where_available AS complete_film_where_available_7, f0_.complete_film_type AS complete_film_type_8, f0_.complete_film_progress_details AS complete_film_progress_details_9, f0_.reach_response_details AS reach_response_details_10, f0_.reach_response_use AS reach_response_use_11, f0_.outcome_change AS outcome_change_12, f0_.is_outcome_measured_impact AS is_outcome_measured_impact_13, f0_.outcome_measured_impact_details AS outcome_measured_impact_details_14, f0_.outcome_contribute_extent AS outcome_contribute_extent_15, f0_.feedback_engagement AS feedback_engagement_16, f0_.feedback_engagement_details AS feedback_engagement_details_17, f0_.feedback_experience_agreement AS feedback_experience_agreement_18, f0_.feedback_doing_well AS feedback_doing_well_19, f0_.feedback_improvement AS feedback_improvement_20, f0_.feedback_involvement AS feedback_involvement_21, f0_.feedback_improvement_details AS feedback_improvement_details_22, f0_.created_at AS created_at_23, f0_.modified_at AS modified_at_24, f0_.feedback_benefit_agreement AS feedback_benefit_agreement_25, f0_.feedback_recommend_agreement AS feedback_recommend_agreement_26, f0_.feedback_critical_role_agreement AS feedback_critical_role_agreement_27, f0_.reach_response_use_details AS reach_response_use_details_28, f0_.feedback_comment AS feedback_comment_29, f0_.complete_film_type_details AS complete_film_type_details_30, f0_.outcome_awareness_extent AS outcome_awareness_extent_31, f0_.outcome_visibility_extent AS outcome_visibility_extent_32, f0_.outcome_connection_extent AS outcome_connection_extent_33, f0_.outcome_action_extent AS outcome_action_extent_34, f0_.outcome_organisation_extent AS outcome_organisation_extent_35, f0_.outcome_community_extent AS outcome_community_extent_36, f0_.outcome_system_extent AS outcome_system_extent_37, f0_.status AS status_38, f0_.project_update_category AS project_update_category_39, f0_.is_file_public AS is_file_public_40, f0_.project_update_tags AS project_update_tags_41, f0_.current_stage AS current_stage_42, f0_.screener_link AS screener_link_43, f0_.screen_password AS screen_password_44, f0_.trailer_link AS trailer_link_45, f0_.trailer_password AS trailer_password_46, f0_.digital_assets_link AS digital_assets_link_47, f0_.general_support_area AS general_support_area_48, f0_.general_support_area_details AS general_support_area_details_49, f0_.fundraising_status AS fundraising_status_50, f0_.outcome_additional_information AS outcome_additional_information_51, f0_.is_draft AS is_draft_52, f0_.film_website_url AS film_website_url_53, f0_.is_document AS is_document_54, f0_.online_document_link AS online_document_link_55, f0_.video_link AS video_link_56, f0_.film_project_id AS film_project_id_57, f0_.film_project_update_id AS film_project_update_id_58 FROM film_project_progress_report f0_ LEFT JOIN film_project f1_ ON f0_.film_project_id = f1_.id WHERE f0_.created_at >= ? AND f0_.created_at <= ? AND f1_.id = ?
Parameters:
[
  "2025-01-01 00:00:00"
  "2025-12-31 23:59:59"
  2
]
5 0.42 ms
SELECT DATABASE()
Parameters:
[]
6 2.17 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "daf_portal_staging"
]
7 0.24 ms
SELECT DATABASE()
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\UserBilling No errors.
App\Entity\EmailTemplate No errors.
App\Entity\XeroStorage No errors.
App\Entity\FilmProjectMember
  • The field App\Entity\FilmProjectMember#adminFilmProject is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\FilmProject#filmProjectAdmin does not contain the required 'mappedBy="adminFilmProject"' attribute.
  • The field App\Entity\FilmProjectMember#producerFilmProject is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\FilmProject#filmProjectProducer does not contain the required 'mappedBy="producerFilmProject"' attribute.
  • The field App\Entity\FilmProjectMember#directorFilmProject is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\FilmProject#filmProjectDirector does not contain the required 'mappedBy="directorFilmProject"' attribute.
App\Entity\FilmProjectProgressReport No errors.
App\Entity\FilmProject No errors.
App\Entity\FilmProjectUpdate No errors.
App\Entity\UserProfile No errors.
App\Entity\UserAddress No errors.
App\Entity\UserInformation No errors.
App\Entity\OrderDetails
  • The field App\Entity\OrderDetails#donation is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Donation#orderDetails does not contain the required 'inversedBy="donation"' attribute.
App\Entity\UserCategory No errors.
App\Entity\ProjectNotification No errors.
App\Entity\FilmProjectProgressReportFile No errors.
App\Entity\FilmProjectDetails No errors.
App\Entity\FilmProjectStoryImpact No errors.
App\Entity\FilmProjectTimeline No errors.
App\Entity\FilmProjectFunding No errors.
App\Entity\Product No errors.
App\Entity\Donation No errors.
App\Entity\FilmProjectOriginal No errors.
App\Entity\FilmProjectImage No errors.
App\Entity\FilmProjectSponsor No errors.
App\Entity\FilmProjectChangeHistory No errors.
App\Entity\ProjectUpdateTypeNomination No errors.
App\Entity\OrderItems No errors.
App\Entity\OrderBillingDetails No errors.
App\Entity\PaymentDetails No errors.
App\Entity\ProductPercentageSplit No errors.
App\Entity\RecurringDonation No errors.
App\Entity\Event No errors.
App\Entity\XeroTrackingOption No errors.
App\Entity\XeroTrackingCategory No errors.
App\Entity\Setting No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\XeroBrandingThemes No errors.
App\Entity\IssueTopic No errors.
App\Entity\IssueArea No errors.
Vich\UploaderBundle\Entity\File No errors.