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

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

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.id = '230';

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

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

SELECT
  t0.id AS id_1,
  t0.street AS street_2,
  t0.suburb AS suburb_3,
  t0.state AS state_4,
  t0.country AS country_5,
  t0.postcode AS postcode_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.organisation AS organisation_9,
  t0.phone_number AS phone_number_10,
  t0.email_address AS email_address_11,
  t0.payframe_token AS payframe_token_12,
  t0.payframe_key AS payframe_key_13,
  t0.card_id AS card_id_14,
  t0.is_saved_credit_card AS is_saved_credit_card_15,
  t0.abn AS abn_16,
  t17.id AS id_18,
  t17.total AS total_19,
  t17.created_at AS created_at_20,
  t17.modified_at AS modified_at_21,
  t17.xero_id AS xero_id_22,
  t17.type AS type_23,
  t17.invoice_number AS invoice_number_24,
  t17.transaction_id AS transaction_id_25,
  t17.salesforce_id AS salesforce_id_26,
  t17.is_refund AS is_refund_27,
  t17.refund_xero_id AS refund_xero_id_28,
  t17.xero_contact_id AS xero_contact_id_29,
  t17.popup_salesforce_id AS popup_salesforce_id_30,
  t17.user_id AS user_id_31,
  t17.order_billing_details_id AS order_billing_details_id_32,
  t17.film_project_id AS film_project_id_33
FROM
  order_billing_details t0
  LEFT JOIN order_details t17 ON t17.order_billing_details_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.street AS street_2, t0.suburb AS suburb_3, t0.state AS state_4, t0.country AS country_5, t0.postcode AS postcode_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.organisation AS organisation_9, t0.phone_number AS phone_number_10, t0.email_address AS email_address_11, t0.payframe_token AS payframe_token_12, t0.payframe_key AS payframe_key_13, t0.card_id AS card_id_14, t0.is_saved_credit_card AS is_saved_credit_card_15, t0.abn AS abn_16, t17.id AS id_18, t17.total AS total_19, t17.created_at AS created_at_20, t17.modified_at AS modified_at_21, t17.xero_id AS xero_id_22, t17.type AS type_23, t17.invoice_number AS invoice_number_24, t17.transaction_id AS transaction_id_25, t17.salesforce_id AS salesforce_id_26, t17.is_refund AS is_refund_27, t17.refund_xero_id AS refund_xero_id_28, t17.xero_contact_id AS xero_contact_id_29, t17.popup_salesforce_id AS popup_salesforce_id_30, t17.user_id AS user_id_31, t17.order_billing_details_id AS order_billing_details_id_32, t17.film_project_id AS film_project_id_33 FROM order_billing_details t0 LEFT JOIN order_details t17 ON t17.order_billing_details_id = t0.id WHERE t0.id = 263;

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.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, 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.id = 23;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.modified_at AS modified_at_3,
  t0.product_type AS product_type_4,
  t0.product_description AS product_description_5,
  t0.product_price AS product_price_6,
  t0.order_details_id AS order_details_id_7,
  t0.product_id AS product_id_8
FROM
  order_items t0
WHERE
  t0.order_details_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.modified_at AS modified_at_3, t0.product_type AS product_type_4, t0.product_description AS product_description_5, t0.product_price AS product_price_6, t0.order_details_id AS order_details_id_7, t0.product_id AS product_id_8 FROM order_items t0 WHERE t0.order_details_id = 263;

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

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 = 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 = ?
  AND f0_.id IN (?)
ORDER BY
  f0_.title ASC

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 = 'approved' AND f0_.id IN ('23') ORDER BY f0_.title ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.category AS category_2,
  p0_.description AS description_3,
  p0_.price AS price_4,
  p0_.gl_code AS gl_code_5,
  p0_.account_id AS account_id_6,
  p0_.refund_code AS refund_code_7
FROM
  product p0_
WHERE
  p0_.category = ?
  AND p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.category AS category_2, p0_.description AS description_3, p0_.price AS price_4, p0_.gl_code AS gl_code_5, p0_.account_id AS account_id_6, p0_.refund_code AS refund_code_7 FROM product p0_ WHERE p0_.category = 'donations' AND p0_.id IN ('1');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.xero_id AS xero_id_3
FROM
  xero_tracking_category t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.xero_id AS xero_id_3 FROM xero_tracking_category t0 WHERE t0.name = 'Documentaries' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.xero_id AS xero_id_3,
  t0.xero_tracking_category_id AS xero_tracking_category_id_4
FROM
  xero_tracking_option t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.xero_id AS xero_id_3, t0.xero_tracking_category_id AS xero_tracking_category_id_4 FROM xero_tracking_option t0 WHERE t0.name = '37539-Progress Report Testing 3' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.percentage AS percentage_3,
  t0.gl_code AS gl_code_4,
  t0.account_id AS account_id_5,
  t0.is_round_down AS is_round_down_6,
  t0.refund_code AS refund_code_7,
  t0.product_id AS product_id_8
FROM
  product_percentage_split t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.percentage AS percentage_3, t0.gl_code AS gl_code_4, t0.account_id AS account_id_5, t0.is_round_down AS is_round_down_6, t0.refund_code AS refund_code_7, t0.product_id AS product_id_8 FROM product_percentage_split t0 WHERE t0.product_id = 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  order_details
SET
  salesforce_id = ?
WHERE
  id = ?

UPDATE order_details SET salesforce_id = '006Bn00000HOXHBIA5' WHERE id = 263;

"COMMIT"

"COMMIT";

SELECT
  d0_.id AS id_0,
  d0_.created_at AS created_at_1,
  d0_.modified_at AS modified_at_2,
  d0_.is_donation_email AS is_donation_email_3,
  d0_.is_organisation_consent AS is_organisation_consent_4,
  d0_.is_contact_shared AS is_contact_shared_5,
  d0_.is_name_approved AS is_name_approved_6,
  d0_.is_recurring_donation AS is_recurring_donation_7,
  d0_.supportdaf AS supportdaf_8,
  d0_.is_amount_invisible AS is_amount_invisible_9,
  d0_.support_daf_salesforce AS support_daf_salesforce_10,
  d0_.is_display_organisation AS is_display_organisation_11,
  d0_.wordpress_donor_name AS wordpress_donor_name_12,
  d0_.film_project_id AS film_project_id_13,
  d0_.order_details_id AS order_details_id_14,
  d0_.recurring_donation_id AS recurring_donation_id_15
FROM
  donation d0_
  INNER JOIN order_details o1_ ON d0_.order_details_id = o1_.id
  INNER JOIN payment_details p2_ ON o1_.id = p2_.order_details_id
WHERE
  d0_.film_project_id = ?
  AND p2_.status = ?
GROUP BY
  o1_.invoice_number
ORDER BY
  d0_.created_at ASC

SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.modified_at AS modified_at_2, d0_.is_donation_email AS is_donation_email_3, d0_.is_organisation_consent AS is_organisation_consent_4, d0_.is_contact_shared AS is_contact_shared_5, d0_.is_name_approved AS is_name_approved_6, d0_.is_recurring_donation AS is_recurring_donation_7, d0_.supportdaf AS supportdaf_8, d0_.is_amount_invisible AS is_amount_invisible_9, d0_.support_daf_salesforce AS support_daf_salesforce_10, d0_.is_display_organisation AS is_display_organisation_11, d0_.wordpress_donor_name AS wordpress_donor_name_12, d0_.film_project_id AS film_project_id_13, d0_.order_details_id AS order_details_id_14, d0_.recurring_donation_id AS recurring_donation_id_15 FROM donation d0_ INNER JOIN order_details o1_ ON d0_.order_details_id = o1_.id INNER JOIN payment_details p2_ ON o1_.id = p2_.order_details_id WHERE d0_.film_project_id = 23 AND p2_.status = 'Completed' GROUP BY o1_.invoice_number ORDER BY d0_.created_at ASC;