https://daf-middleware.wtdevsite.com/donation?amount=50&wpId=37391

Query Metrics

5 Database Queries
3 Different statements
22.68 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.04 ms
(70.73%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.production_stage AS production_stage_3, t0.production_type AS production_type_4, t0.status AS status_5, t0.wordpress_id AS wordpress_id_6, t0.wordpress_status AS wordpress_status_7, t0.salesforce_id AS salesforce_id_8, t0.note AS note_9, t0.resubmit_count AS resubmit_count_10, t0.created_at AS created_at_11, t0.modified_at AS modified_at_12, t0.total_donation AS total_donation_13, t0.tracking_option_id AS tracking_option_id_14, t0.tab_active AS tab_active_15, t0.is_hide_donation_box AS is_hide_donation_box_16, t0.wordpress_password AS wordpress_password_17, t0.old_wordpress_id AS old_wordpress_id_18, t0.is_daf_core AS is_daf_core_19, t0.is_daf_program AS is_daf_program_20, t0.xero_id AS xero_id_21, t0.is_progress_report_active AS is_progress_report_active_22, t0.progress_report_start_date AS progress_report_start_date_23, t24.id AS id_25, t24.is_episodes AS is_episodes_26, t24.episode_number AS episode_number_27, t24.is_short_film AS is_short_film_28, t24.short_film_length AS short_film_length_29, t24.production_length AS production_length_30, t24.project_hero_image AS project_hero_image_31, t24.project_trailer_link AS project_trailer_link_32, t24.project_trailer_password AS project_trailer_password_33, t24.is_completed AS is_completed_34, t24.project_complete_link AS project_complete_link_35, t24.screener_password AS screener_password_36, t24.twitter AS twitter_37, t24.instagram AS instagram_38, t24.facebook AS facebook_39, t24.youtube AS youtube_40, t24.vimeo AS vimeo_41, t24.website AS website_42, t24.is_display_donation AS is_display_donation_43, t24.film_project_id AS film_project_id_44, t45.id AS id_46, t45.synopsis AS synopsis_47, t45.logline AS logline_48, t45.issue_addressed AS issue_addressed_49, t45.creative_treatment AS creative_treatment_50, t45.primary_impact_area AS primary_impact_area_51, t45.secondary_impact_area AS secondary_impact_area_52, t45.topic_covered AS topic_covered_53, t45.impact_vision_statement AS impact_vision_statement_54, t45.outcomes AS outcomes_55, t45.ourcome_information AS ourcome_information_56, t45.audiences AS audiences_57, t45.relationship_access AS relationship_access_58, t45.who_benefit AS who_benefit_59, t45.confirmed_role AS confirmed_role_60, t45.confirmed_role_name AS confirmed_role_name_61, t45.call_to_action AS call_to_action_62, t45.is_film_impact_partner AS is_film_impact_partner_63, t45.partner_name AS partner_name_64, t45.film_project_id AS film_project_id_65, t66.id AS id_67, t66.development_timeline AS development_timeline_68, t66.production_timeline AS production_timeline_69, t66.post_production_timeline AS post_production_timeline_70, t66.completion_timeline AS completion_timeline_71, t66.fundraising_campaign_start_date AS fundraising_campaign_start_date_72, t66.fundraising_campaign_end_date AS fundraising_campaign_end_date_73, t66.impact_campaign_start_date AS impact_campaign_start_date_74, t66.impact_campaign_end_date AS impact_campaign_end_date_75, t66.film_project_id AS film_project_id_76, t77.id AS id_78, t77.development_budget AS development_budget_79, t77.production_budget AS production_budget_80, t77.post_production_budget AS post_production_budget_81, t77.outreach AS outreach_82, t77.screen_agencies AS screen_agencies_83, t77.government AS government_84, t77.corporate AS corporate_85, t77.philantrophy AS philantrophy_86, t77.crownfunding AS crownfunding_87, t77.other_budget AS other_budget_88, t77.total_budget AS total_budget_89, t77.funder_list AS funder_list_90, t77.is_confirmed_support_public AS is_confirmed_support_public_91, t77.fundraising_strategy AS fundraising_strategy_92, t77.fundraising_goal AS fundraising_goal_93, t77.campaign_end_method AS campaign_end_method_94, t77.heard_from AS heard_from_95, t77.approved_fiscal AS approved_fiscal_96, t77.fiscal_sponsorship_project AS fiscal_sponsorship_project_97, t77.is_previously_submitted AS is_previously_submitted_98, t77.previously_submitted_year AS previously_submitted_year_99, t77.film_project_id AS film_project_id_100, t0.owner_id AS owner_id_101, t0.order_details_id AS order_details_id_102, t0.film_project_admin_id AS film_project_admin_id_103, t0.film_project_producer_id AS film_project_producer_id_104, t0.film_project_director_id AS film_project_director_id_105, t0.product_id AS product_id_106, t107.id AS id_108, t107.data AS data_109, t107.film_project_id AS film_project_id_110, t0.recurring_product_id AS recurring_product_id_111 FROM film_project t0 LEFT JOIN film_project_details t24 ON t24.film_project_id = t0.id LEFT JOIN film_project_story_impact t45 ON t45.film_project_id = t0.id LEFT JOIN film_project_timeline t66 ON t66.film_project_id = t0.id LEFT JOIN film_project_funding t77 ON t77.film_project_id = t0.id LEFT JOIN film_project_original t107 ON t107.film_project_id = t0.id WHERE t0.wordpress_id = ? LIMIT 1
Parameters:
[
  "37391"
]
3.56 ms
(15.68%)
3
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.08 ms
(13.59%)
1
SELECT t0.id AS id_1, t0.card_id AS card_id_2, t0.user_id AS user_id_3 FROM user_billing t0 WHERE t0.user_id IS NULL
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\XeroStorage No errors.
App\Entity\User No errors.
App\Entity\UserBilling No errors.
App\Entity\EmailTemplate No errors.
App\Entity\Donation No errors.
App\Entity\FilmProject No errors.
App\Entity\FilmProjectDetails No errors.
App\Entity\FilmProjectStoryImpact No errors.
App\Entity\FilmProjectTimeline No errors.
App\Entity\FilmProjectFunding 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\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\Product No errors.
App\Entity\FilmProjectOriginal No errors.
App\Entity\FilmProjectUpdate No errors.
App\Entity\FilmProjectImage No errors.
App\Entity\FilmProjectSponsor No errors.
App\Entity\FilmProjectChangeHistory No errors.
App\Entity\FilmProjectProgressReport No errors.