Query Metrics
5
Database Queries
3
Different statements
22.68 ms
Query time
2
Invalid entities
Grouped Statements
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 |
|
App\Entity\FilmProjectMember |
|
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. |