Query Metrics
475
Database Queries
17
Different statements
221.87 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
111.82 ms (50.40%) |
238 |
SELECT t0.id AS id_1, t0.total AS total_2, t0.created_at AS created_at_3, t0.modified_at AS modified_at_4, t0.xero_id AS xero_id_5, t0.type AS type_6, t0.invoice_number AS invoice_number_7, t0.transaction_id AS transaction_id_8, t0.salesforce_id AS salesforce_id_9, t0.is_refund AS is_refund_10, t0.refund_xero_id AS refund_xero_id_11, t0.xero_contact_id AS xero_contact_id_12, t0.popup_salesforce_id AS popup_salesforce_id_13, t0.user_id AS user_id_14, t0.order_billing_details_id AS order_billing_details_id_15, t16.id AS id_17, t16.amount AS amount_18, t16.status AS status_19, t16.created_at AS created_at_20, t16.modified_at AS modified_at_21, t16.type AS type_22, t16.is_paid AS is_paid_23, t16.order_details_id AS order_details_id_24, t0.film_project_id AS film_project_id_25, t26.id AS id_27, t26.created_at AS created_at_28, t26.modified_at AS modified_at_29, t26.is_donation_email AS is_donation_email_30, t26.is_organisation_consent AS is_organisation_consent_31, t26.is_contact_shared AS is_contact_shared_32, t26.is_name_approved AS is_name_approved_33, t26.is_recurring_donation AS is_recurring_donation_34, t26.supportdaf AS supportdaf_35, t26.is_amount_invisible AS is_amount_invisible_36, t26.support_daf_salesforce AS support_daf_salesforce_37, t26.is_display_organisation AS is_display_organisation_38, t26.wordpress_donor_name AS wordpress_donor_name_39, t26.film_project_id AS film_project_id_40, t26.order_details_id AS order_details_id_41, t26.recurring_donation_id AS recurring_donation_id_42 FROM order_details t0 LEFT JOIN payment_details t16 ON t16.order_details_id = t0.id LEFT JOIN donation t26 ON t26.order_details_id = t0.id WHERE t0.id = ?
Parameters:
[
281
]
|
|
22.03 ms (9.93%) |
32 |
SELECT t0.id AS id_1, t0.is_uptodate AS is_uptodate_2, t0.project_update AS project_update_3, t0.is_still_fundraising AS is_still_fundraising_4, t0.project_active_status AS project_active_status_5, t0.complete_film_year AS complete_film_year_6, t0.is_complete_film_release AS is_complete_film_release_7, t0.complete_film_where_available AS complete_film_where_available_8, t0.complete_film_type AS complete_film_type_9, t0.complete_film_progress_details AS complete_film_progress_details_10, t0.reach_response_details AS reach_response_details_11, t0.reach_response_use AS reach_response_use_12, t0.outcome_change AS outcome_change_13, t0.is_outcome_measured_impact AS is_outcome_measured_impact_14, t0.outcome_measured_impact_details AS outcome_measured_impact_details_15, t0.outcome_contribute_extent AS outcome_contribute_extent_16, t0.feedback_engagement AS feedback_engagement_17, t0.feedback_engagement_details AS feedback_engagement_details_18, t0.feedback_experience_agreement AS feedback_experience_agreement_19, t0.feedback_doing_well AS feedback_doing_well_20, t0.feedback_improvement AS feedback_improvement_21, t0.feedback_involvement AS feedback_involvement_22, t0.feedback_improvement_details AS feedback_improvement_details_23, t0.created_at AS created_at_24, t0.modified_at AS modified_at_25, t0.feedback_benefit_agreement AS feedback_benefit_agreement_26, t0.feedback_recommend_agreement AS feedback_recommend_agreement_27, t0.feedback_critical_role_agreement AS feedback_critical_role_agreement_28, t0.reach_response_use_details AS reach_response_use_details_29, t0.feedback_comment AS feedback_comment_30, t0.complete_film_type_details AS complete_film_type_details_31, t0.outcome_awareness_extent AS outcome_awareness_extent_32, t0.outcome_visibility_extent AS outcome_visibility_extent_33, t0.outcome_connection_extent AS outcome_connection_extent_34, t0.outcome_action_extent AS outcome_action_extent_35, t0.outcome_organisation_extent AS outcome_organisation_extent_36, t0.outcome_community_extent AS outcome_community_extent_37, t0.outcome_system_extent AS outcome_system_extent_38, t0.status AS status_39, t0.project_update_category AS project_update_category_40, t0.is_file_public AS is_file_public_41, t0.project_update_tags AS project_update_tags_42, t0.current_stage AS current_stage_43, t0.screener_link AS screener_link_44, t0.screen_password AS screen_password_45, t0.trailer_link AS trailer_link_46, t0.trailer_password AS trailer_password_47, t0.digital_assets_link AS digital_assets_link_48, t0.general_support_area AS general_support_area_49, t0.general_support_area_details AS general_support_area_details_50, t0.fundraising_status AS fundraising_status_51, t0.outcome_additional_information AS outcome_additional_information_52, t0.is_draft AS is_draft_53, t0.film_website_url AS film_website_url_54, t0.is_document AS is_document_55, t0.online_document_link AS online_document_link_56, t0.film_project_id AS film_project_id_57, t0.film_project_update_id AS film_project_update_id_58 FROM film_project_progress_report t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
16.57 ms (7.47%) |
32 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.modified_at AS modified_at_3, t0.is_donation_email AS is_donation_email_4, t0.is_organisation_consent AS is_organisation_consent_5, t0.is_contact_shared AS is_contact_shared_6, t0.is_name_approved AS is_name_approved_7, t0.is_recurring_donation AS is_recurring_donation_8, t0.supportdaf AS supportdaf_9, t0.is_amount_invisible AS is_amount_invisible_10, t0.support_daf_salesforce AS support_daf_salesforce_11, t0.is_display_organisation AS is_display_organisation_12, t0.wordpress_donor_name AS wordpress_donor_name_13, t0.film_project_id AS film_project_id_14, t0.order_details_id AS order_details_id_15, t0.recurring_donation_id AS recurring_donation_id_16 FROM donation t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
13.09 ms (5.90%) |
32 |
SELECT t0.id AS id_1, t0.development_budget AS development_budget_2, t0.production_budget AS production_budget_3, t0.post_production_budget AS post_production_budget_4, t0.outreach AS outreach_5, t0.screen_agencies AS screen_agencies_6, t0.government AS government_7, t0.corporate AS corporate_8, t0.philantrophy AS philantrophy_9, t0.crownfunding AS crownfunding_10, t0.other_budget AS other_budget_11, t0.total_budget AS total_budget_12, t0.funder_list AS funder_list_13, t0.is_confirmed_support_public AS is_confirmed_support_public_14, t0.fundraising_strategy AS fundraising_strategy_15, t0.fundraising_goal AS fundraising_goal_16, t0.campaign_end_method AS campaign_end_method_17, t0.heard_from AS heard_from_18, t0.approved_fiscal AS approved_fiscal_19, t0.fiscal_sponsorship_project AS fiscal_sponsorship_project_20, t0.is_previously_submitted AS is_previously_submitted_21, t0.previously_submitted_year AS previously_submitted_year_22, t0.film_project_id AS film_project_id_23 FROM film_project_funding t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
13.08 ms (5.90%) |
32 |
SELECT t0.id AS id_1, t0.is_episodes AS is_episodes_2, t0.episode_number AS episode_number_3, t0.is_short_film AS is_short_film_4, t0.short_film_length AS short_film_length_5, t0.production_length AS production_length_6, t0.project_hero_image AS project_hero_image_7, t0.project_trailer_link AS project_trailer_link_8, t0.project_trailer_password AS project_trailer_password_9, t0.is_completed AS is_completed_10, t0.project_complete_link AS project_complete_link_11, t0.screener_password AS screener_password_12, t0.twitter AS twitter_13, t0.instagram AS instagram_14, t0.facebook AS facebook_15, t0.youtube AS youtube_16, t0.vimeo AS vimeo_17, t0.website AS website_18, t0.is_display_donation AS is_display_donation_19, t0.film_project_id AS film_project_id_20 FROM film_project_details t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
12.97 ms (5.85%) |
32 |
SELECT t0.id AS id_1, t0.synopsis AS synopsis_2, t0.logline AS logline_3, t0.issue_addressed AS issue_addressed_4, t0.creative_treatment AS creative_treatment_5, t0.primary_impact_area AS primary_impact_area_6, t0.secondary_impact_area AS secondary_impact_area_7, t0.topic_covered AS topic_covered_8, t0.impact_vision_statement AS impact_vision_statement_9, t0.outcomes AS outcomes_10, t0.ourcome_information AS ourcome_information_11, t0.audiences AS audiences_12, t0.relationship_access AS relationship_access_13, t0.who_benefit AS who_benefit_14, t0.confirmed_role AS confirmed_role_15, t0.confirmed_role_name AS confirmed_role_name_16, t0.call_to_action AS call_to_action_17, t0.is_film_impact_partner AS is_film_impact_partner_18, t0.partner_name AS partner_name_19, t0.film_project_id AS film_project_id_20 FROM film_project_story_impact t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
11.50 ms (5.18%) |
32 |
SELECT t0.id AS id_1, t0.development_timeline AS development_timeline_2, t0.production_timeline AS production_timeline_3, t0.post_production_timeline AS post_production_timeline_4, t0.completion_timeline AS completion_timeline_5, t0.fundraising_campaign_start_date AS fundraising_campaign_start_date_6, t0.fundraising_campaign_end_date AS fundraising_campaign_end_date_7, t0.impact_campaign_start_date AS impact_campaign_start_date_8, t0.impact_campaign_end_date AS impact_campaign_end_date_9, t0.film_project_id AS film_project_id_10 FROM film_project_timeline t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
11.16 ms (5.03%) |
32 |
SELECT t0.id AS id_1, t0.data AS data_2, t0.film_project_id AS film_project_id_3 FROM film_project_original t0 WHERE t0.film_project_id = ?
Parameters:
[
45
]
|
|
1.97 ms (0.89%) |
3 |
SELECT t0.id AS id_1, t0.option_name AS option_name_2, t0.option_value AS option_value_3 FROM setting t0 WHERE t0.option_name = ? LIMIT 1
Parameters:
[
"is_progress_report"
]
|
|
1.74 ms (0.79%) |
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"
]
|
|
1.43 ms (0.65%) |
1 |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.production_stage AS production_stage_2, f0_.production_type AS production_type_3, f0_.status AS status_4, f0_.wordpress_id AS wordpress_id_5, f0_.wordpress_status AS wordpress_status_6, f0_.salesforce_id AS salesforce_id_7, f0_.note AS note_8, f0_.resubmit_count AS resubmit_count_9, f0_.created_at AS created_at_10, f0_.modified_at AS modified_at_11, f0_.total_donation AS total_donation_12, f0_.tracking_option_id AS tracking_option_id_13, f0_.tab_active AS tab_active_14, f0_.is_hide_donation_box AS is_hide_donation_box_15, f0_.wordpress_password AS wordpress_password_16, f0_.old_wordpress_id AS old_wordpress_id_17, f0_.is_daf_core AS is_daf_core_18, f0_.is_daf_program AS is_daf_program_19, f0_.xero_id AS xero_id_20, f0_.is_progress_report_active AS is_progress_report_active_21, f0_.progress_report_start_date AS progress_report_start_date_22, f0_.owner_id AS owner_id_23, f0_.order_details_id AS order_details_id_24, f0_.film_project_admin_id AS film_project_admin_id_25, f0_.film_project_producer_id AS film_project_producer_id_26, f0_.film_project_director_id AS film_project_director_id_27, f0_.product_id AS product_id_28, f0_.recurring_product_id AS recurring_product_id_29 FROM film_project f0_ WHERE (f0_.status = ? OR f0_.status = ? OR f0_.status = ?) AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.id DESC
Parameters:
[ "declined" "approved" "resubmit" 45 44 43 42 41 40 39 38 37 36 35 34 32 31 29 28 27 26 24 23 22 21 20 16 13 11 7 6 4 3 2 1 ] |
|
1.05 ms (0.47%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.gender AS gender_8, t0.is_diverse AS is_diverse_9, t0.organisation AS organisation_10, t0.area_interest AS area_interest_11, t0.account_salesforce_id AS account_salesforce_id_12, t0.is_aborigin AS is_aborigin_13, t0.is_success AS is_success_14, t0.is_guest AS is_guest_15, t16.id AS id_17, t16.description AS description_18, t16.short_description AS short_description_19, t16.long_description AS long_description_20, t16.profile_picture AS profile_picture_21, t16.user_roles AS user_roles_22, t16.reason_support_documentary AS reason_support_documentary_23, t16.user_id AS user_id_24, t25.id AS id_26, t25.street AS street_27, t25.city AS city_28, t25.state AS state_29, t25.postcode AS postcode_30, t25.country AS country_31, t25.user_id AS user_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.twitter AS twitter_37, t33.xero_id AS xero_id_38, t33.salesforce_id AS salesforce_id_39, t33.wordpress_id AS wordpress_id_40, t33.user_id AS user_id_41 FROM user t0 LEFT JOIN user_profile t16 ON t16.user_id = t0.id LEFT JOIN user_address t25 ON t25.user_id = t0.id LEFT JOIN user_information t33 ON t33.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.86 ms (0.39%) |
1 |
SELECT p0_.id AS id_0, p0_.category AS category_1, p0_.title AS title_2, p0_.subtitle AS subtitle_3, p0_.created_at AS created_at_4, p0_.is_read AS is_read_5, p0_.link AS link_6 FROM project_notification p0_ LEFT JOIN project_notification_user p2_ ON p0_.id = p2_.project_notification_id LEFT JOIN user u1_ ON u1_.id = p2_.user_id WHERE u1_.id = ? AND (p0_.is_read IS NULL OR p0_.is_read = 0) ORDER BY p0_.created_at DESC
Parameters:
[
1
]
|
|
0.83 ms (0.37%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.description AS description_4, t0.price AS price_5, t0.gl_code AS gl_code_6, t0.account_id AS account_id_7, t0.refund_code AS refund_code_8 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"2"
]
|
|
0.69 ms (0.31%) |
1 |
SELECT DISTINCT f0_.id AS id_0, f0_.id AS id_1 FROM film_project f0_ WHERE f0_.status = ? OR f0_.status = ? OR f0_.status = ? ORDER BY f0_.id DESC LIMIT 60
Parameters:
[ "declined" "approved" "resubmit" ] |
|
0.56 ms (0.25%) |
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 = ?
Parameters:
[
1
]
|
|
0.50 ms (0.22%) |
1 |
SELECT count(f0_.id) AS sclr_0 FROM film_project f0_ WHERE f0_.status = ? OR f0_.status = ? OR f0_.status = ?
Parameters:
[ "declined" "approved" "resubmit" ] |
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\UserProfile | No errors. |
| App\Entity\UserAddress | No errors. |
| App\Entity\UserInformation | No errors. |
| App\Entity\OrderDetails |
|
| App\Entity\FilmProject | No errors. |
| App\Entity\UserBilling | No errors. |
| App\Entity\UserCategory | No errors. |
| App\Entity\ProjectNotification | No errors. |
| App\Entity\EmailTemplate | No errors. |
| App\Entity\Donation | No errors. |
| App\Entity\XeroStorage | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\FilmProjectMember |
|
| App\Entity\Product | No errors. |
| App\Entity\FilmProjectDetails | No errors. |
| App\Entity\FilmProjectStoryImpact | No errors. |
| App\Entity\FilmProjectTimeline | No errors. |
| App\Entity\FilmProjectFunding | 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. |
| App\Entity\RecurringDonation | No errors. |
| App\Entity\FilmProjectProgressReportFile | No errors. |
| App\Entity\OrderBillingDetails | No errors. |
| App\Entity\PaymentDetails | No errors. |
| App\Entity\OrderItems | No errors. |
| App\Entity\ProductPercentageSplit | No errors. |