Symfony Profiler

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 = ?

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 = 29;

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

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 = 'primary' LIMIT 1;

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

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 = 'primary' LIMIT 1;

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

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 = 'primary' LIMIT 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

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 = 29 AND (p0_.is_read IS NULL OR p0_.is_read = 0) ORDER BY p0_.created_at DESC;

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

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 = 'is_progress_report' LIMIT 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,
  t0.current_progress_report_year AS current_progress_report_year_24,
  t0.project_approval_date AS project_approval_date_25,
  t26.id AS id_27,
  t26.is_episodes AS is_episodes_28,
  t26.episode_number AS episode_number_29,
  t26.is_short_film AS is_short_film_30,
  t26.short_film_length AS short_film_length_31,
  t26.production_length AS production_length_32,
  t26.project_hero_image AS project_hero_image_33,
  t26.project_trailer_link AS project_trailer_link_34,
  t26.project_trailer_password AS project_trailer_password_35,
  t26.is_completed AS is_completed_36,
  t26.project_complete_link AS project_complete_link_37,
  t26.screener_password AS screener_password_38,
  t26.twitter AS twitter_39,
  t26.instagram AS instagram_40,
  t26.facebook AS facebook_41,
  t26.youtube AS youtube_42,
  t26.vimeo AS vimeo_43,
  t26.website AS website_44,
  t26.is_display_donation AS is_display_donation_45,
  t26.film_project_id AS film_project_id_46,
  t47.id AS id_48,
  t47.synopsis AS synopsis_49,
  t47.logline AS logline_50,
  t47.issue_addressed AS issue_addressed_51,
  t47.creative_treatment AS creative_treatment_52,
  t47.primary_impact_area AS primary_impact_area_53,
  t47.secondary_impact_area AS secondary_impact_area_54,
  t47.topic_covered AS topic_covered_55,
  t47.impact_vision_statement AS impact_vision_statement_56,
  t47.outcomes AS outcomes_57,
  t47.ourcome_information AS ourcome_information_58,
  t47.audiences AS audiences_59,
  t47.relationship_access AS relationship_access_60,
  t47.who_benefit AS who_benefit_61,
  t47.confirmed_role AS confirmed_role_62,
  t47.confirmed_role_name AS confirmed_role_name_63,
  t47.call_to_action AS call_to_action_64,
  t47.is_film_impact_partner AS is_film_impact_partner_65,
  t47.partner_name AS partner_name_66,
  t47.film_project_id AS film_project_id_67,
  t68.id AS id_69,
  t68.development_timeline AS development_timeline_70,
  t68.production_timeline AS production_timeline_71,
  t68.post_production_timeline AS post_production_timeline_72,
  t68.completion_timeline AS completion_timeline_73,
  t68.fundraising_campaign_start_date AS fundraising_campaign_start_date_74,
  t68.fundraising_campaign_end_date AS fundraising_campaign_end_date_75,
  t68.impact_campaign_start_date AS impact_campaign_start_date_76,
  t68.impact_campaign_end_date AS impact_campaign_end_date_77,
  t68.film_project_id AS film_project_id_78,
  t79.id AS id_80,
  t79.development_budget AS development_budget_81,
  t79.production_budget AS production_budget_82,
  t79.post_production_budget AS post_production_budget_83,
  t79.outreach AS outreach_84,
  t79.screen_agencies AS screen_agencies_85,
  t79.government AS government_86,
  t79.corporate AS corporate_87,
  t79.philantrophy AS philantrophy_88,
  t79.crownfunding AS crownfunding_89,
  t79.other_budget AS other_budget_90,
  t79.total_budget AS total_budget_91,
  t79.funder_list AS funder_list_92,
  t79.is_confirmed_support_public AS is_confirmed_support_public_93,
  t79.fundraising_strategy AS fundraising_strategy_94,
  t79.fundraising_goal AS fundraising_goal_95,
  t79.campaign_end_method AS campaign_end_method_96,
  t79.heard_from AS heard_from_97,
  t79.approved_fiscal AS approved_fiscal_98,
  t79.fiscal_sponsorship_project AS fiscal_sponsorship_project_99,
  t79.is_previously_submitted AS is_previously_submitted_100,
  t79.previously_submitted_year AS previously_submitted_year_101,
  t79.film_project_id AS film_project_id_102,
  t0.owner_id AS owner_id_103,
  t0.order_details_id AS order_details_id_104,
  t0.film_project_admin_id AS film_project_admin_id_105,
  t0.film_project_producer_id AS film_project_producer_id_106,
  t0.film_project_director_id AS film_project_director_id_107,
  t0.product_id AS product_id_108,
  t109.id AS id_110,
  t109.data AS data_111,
  t109.film_project_id AS film_project_id_112,
  t0.recurring_product_id AS recurring_product_id_113
FROM
  film_project t0
  LEFT JOIN film_project_details t26 ON t26.film_project_id = t0.id
  LEFT JOIN film_project_story_impact t47 ON t47.film_project_id = t0.id
  LEFT JOIN film_project_timeline t68 ON t68.film_project_id = t0.id
  LEFT JOIN film_project_funding t79 ON t79.film_project_id = t0.id
  LEFT JOIN film_project_original t109 ON t109.film_project_id = t0.id
WHERE
  t0.id = ?

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, t0.current_progress_report_year AS current_progress_report_year_24, t0.project_approval_date AS project_approval_date_25, t26.id AS id_27, t26.is_episodes AS is_episodes_28, t26.episode_number AS episode_number_29, t26.is_short_film AS is_short_film_30, t26.short_film_length AS short_film_length_31, t26.production_length AS production_length_32, t26.project_hero_image AS project_hero_image_33, t26.project_trailer_link AS project_trailer_link_34, t26.project_trailer_password AS project_trailer_password_35, t26.is_completed AS is_completed_36, t26.project_complete_link AS project_complete_link_37, t26.screener_password AS screener_password_38, t26.twitter AS twitter_39, t26.instagram AS instagram_40, t26.facebook AS facebook_41, t26.youtube AS youtube_42, t26.vimeo AS vimeo_43, t26.website AS website_44, t26.is_display_donation AS is_display_donation_45, t26.film_project_id AS film_project_id_46, t47.id AS id_48, t47.synopsis AS synopsis_49, t47.logline AS logline_50, t47.issue_addressed AS issue_addressed_51, t47.creative_treatment AS creative_treatment_52, t47.primary_impact_area AS primary_impact_area_53, t47.secondary_impact_area AS secondary_impact_area_54, t47.topic_covered AS topic_covered_55, t47.impact_vision_statement AS impact_vision_statement_56, t47.outcomes AS outcomes_57, t47.ourcome_information AS ourcome_information_58, t47.audiences AS audiences_59, t47.relationship_access AS relationship_access_60, t47.who_benefit AS who_benefit_61, t47.confirmed_role AS confirmed_role_62, t47.confirmed_role_name AS confirmed_role_name_63, t47.call_to_action AS call_to_action_64, t47.is_film_impact_partner AS is_film_impact_partner_65, t47.partner_name AS partner_name_66, t47.film_project_id AS film_project_id_67, t68.id AS id_69, t68.development_timeline AS development_timeline_70, t68.production_timeline AS production_timeline_71, t68.post_production_timeline AS post_production_timeline_72, t68.completion_timeline AS completion_timeline_73, t68.fundraising_campaign_start_date AS fundraising_campaign_start_date_74, t68.fundraising_campaign_end_date AS fundraising_campaign_end_date_75, t68.impact_campaign_start_date AS impact_campaign_start_date_76, t68.impact_campaign_end_date AS impact_campaign_end_date_77, t68.film_project_id AS film_project_id_78, t79.id AS id_80, t79.development_budget AS development_budget_81, t79.production_budget AS production_budget_82, t79.post_production_budget AS post_production_budget_83, t79.outreach AS outreach_84, t79.screen_agencies AS screen_agencies_85, t79.government AS government_86, t79.corporate AS corporate_87, t79.philantrophy AS philantrophy_88, t79.crownfunding AS crownfunding_89, t79.other_budget AS other_budget_90, t79.total_budget AS total_budget_91, t79.funder_list AS funder_list_92, t79.is_confirmed_support_public AS is_confirmed_support_public_93, t79.fundraising_strategy AS fundraising_strategy_94, t79.fundraising_goal AS fundraising_goal_95, t79.campaign_end_method AS campaign_end_method_96, t79.heard_from AS heard_from_97, t79.approved_fiscal AS approved_fiscal_98, t79.fiscal_sponsorship_project AS fiscal_sponsorship_project_99, t79.is_previously_submitted AS is_previously_submitted_100, t79.previously_submitted_year AS previously_submitted_year_101, t79.film_project_id AS film_project_id_102, t0.owner_id AS owner_id_103, t0.order_details_id AS order_details_id_104, t0.film_project_admin_id AS film_project_admin_id_105, t0.film_project_producer_id AS film_project_producer_id_106, t0.film_project_director_id AS film_project_director_id_107, t0.product_id AS product_id_108, t109.id AS id_110, t109.data AS data_111, t109.film_project_id AS film_project_id_112, t0.recurring_product_id AS recurring_product_id_113 FROM film_project t0 LEFT JOIN film_project_details t26 ON t26.film_project_id = t0.id LEFT JOIN film_project_story_impact t47 ON t47.film_project_id = t0.id LEFT JOIN film_project_timeline t68 ON t68.film_project_id = t0.id LEFT JOIN film_project_funding t79 ON t79.film_project_id = t0.id LEFT JOIN film_project_original t109 ON t109.film_project_id = t0.id WHERE t0.id = '46';