Symfony Profiler

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;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  xero_storage
SET
  access_token = ?,
  expires = ?,
  refresh_token = ?,
  id_token = ?
WHERE
  id = ?

UPDATE xero_storage SET access_token = 'eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NzUxNjU4MTAsImV4cCI6MTc3NTE2NzYxMCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.LUlFwGzYKhRGbKE3fcgFHKFEgD6StOmKfgZkVRH5O_qJ9KWdQ5tq6eqjgINltVyyPT3xCLKwsiDxkjAoVTu0ZGeaQKOWfd2MdPqT3wRAfjxxckHm6rzvgk9zJX_W_0R3PUaeBDzDG4ZVi-3UA-Ix3cZ9Gylonqeh8l9pA6jh3fxbv6PpP6wPwpdyTewXYRuEbGHfgMoY738goIEnJAA3z61LrNviwkBE4m-qlXJ-8DXQHmAOKbB8uGPIlkuorYnTXA9phkiX0gqY7Pr1TTyNTr2GlgohzE7cSsSUd81KaytMu2ZDTmcAY48zeThDIW9lNRAtuAHUsJOkPzMca9q0Jg', expires = '1775167611', refresh_token = 'lzkb7FnC_uMQ3JY21lsIsr_Ul-BAUuoWJFpFssC7POg', id_token = 'eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NzUxNjU4MTAsImV4cCI6MTc3NTE2NjExMCwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzc1MTY1ODEwLCJhdF9oYXNoIjoiOTU5V1lmcVpsa1p5QjNjQzI5WmVBQSIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.mkb2tV-rR9MwpNNGQLOpkLn1NXU1DQXkofvISEKAKmrgVxiWVQygN5vI-mFqr4vmnHAZUkg3ctHqKTJI2ASBcZ10DAo9KW-Su4Hr8vgd8r-8t2QOJGYRvaIazyg-gNUYN0n-1ammeJtmgA15xEmtHNo-NsL0CHt_oHIIoq1tnYV2uHOkJ_gk1NnDRYPlQDm4Gtip0qELenevHFrn8SQd0w2wKkmEAGe7HjhApAq3JbUHWn3FQkCM6YRNc9bJTehf7_MQCZMO1Gem3F6cnIWMkEjEUn3B3bhE6-6Vq0mzlm9PGWh_N8D7zaW6NBHYjY0hFELHGQ_lFuTEsxkz3h6VpQ' WHERE id = 1;

"COMMIT"

"COMMIT";

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
  f0_.id AS id_0,
  f0_.is_uptodate AS is_uptodate_1,
  f0_.project_update AS project_update_2,
  f0_.is_still_fundraising AS is_still_fundraising_3,
  f0_.project_active_status AS project_active_status_4,
  f0_.complete_film_year AS complete_film_year_5,
  f0_.is_complete_film_release AS is_complete_film_release_6,
  f0_.complete_film_where_available AS complete_film_where_available_7,
  f0_.complete_film_type AS complete_film_type_8,
  f0_.complete_film_progress_details AS complete_film_progress_details_9,
  f0_.reach_response_details AS reach_response_details_10,
  f0_.reach_response_use AS reach_response_use_11,
  f0_.outcome_change AS outcome_change_12,
  f0_.is_outcome_measured_impact AS is_outcome_measured_impact_13,
  f0_.outcome_measured_impact_details AS outcome_measured_impact_details_14,
  f0_.outcome_contribute_extent AS outcome_contribute_extent_15,
  f0_.feedback_engagement AS feedback_engagement_16,
  f0_.feedback_engagement_details AS feedback_engagement_details_17,
  f0_.feedback_experience_agreement AS feedback_experience_agreement_18,
  f0_.feedback_doing_well AS feedback_doing_well_19,
  f0_.feedback_improvement AS feedback_improvement_20,
  f0_.feedback_involvement AS feedback_involvement_21,
  f0_.feedback_improvement_details AS feedback_improvement_details_22,
  f0_.created_at AS created_at_23,
  f0_.modified_at AS modified_at_24,
  f0_.feedback_benefit_agreement AS feedback_benefit_agreement_25,
  f0_.feedback_recommend_agreement AS feedback_recommend_agreement_26,
  f0_.feedback_critical_role_agreement AS feedback_critical_role_agreement_27,
  f0_.reach_response_use_details AS reach_response_use_details_28,
  f0_.feedback_comment AS feedback_comment_29,
  f0_.complete_film_type_details AS complete_film_type_details_30,
  f0_.outcome_awareness_extent AS outcome_awareness_extent_31,
  f0_.outcome_visibility_extent AS outcome_visibility_extent_32,
  f0_.outcome_connection_extent AS outcome_connection_extent_33,
  f0_.outcome_action_extent AS outcome_action_extent_34,
  f0_.outcome_organisation_extent AS outcome_organisation_extent_35,
  f0_.outcome_community_extent AS outcome_community_extent_36,
  f0_.outcome_system_extent AS outcome_system_extent_37,
  f0_.status AS status_38,
  f0_.project_update_category AS project_update_category_39,
  f0_.is_file_public AS is_file_public_40,
  f0_.project_update_tags AS project_update_tags_41,
  f0_.current_stage AS current_stage_42,
  f0_.screener_link AS screener_link_43,
  f0_.screen_password AS screen_password_44,
  f0_.trailer_link AS trailer_link_45,
  f0_.trailer_password AS trailer_password_46,
  f0_.digital_assets_link AS digital_assets_link_47,
  f0_.general_support_area AS general_support_area_48,
  f0_.general_support_area_details AS general_support_area_details_49,
  f0_.fundraising_status AS fundraising_status_50,
  f0_.outcome_additional_information AS outcome_additional_information_51,
  f0_.is_draft AS is_draft_52,
  f0_.film_website_url AS film_website_url_53,
  f0_.is_document AS is_document_54,
  f0_.online_document_link AS online_document_link_55,
  f0_.is_active AS is_active_56,
  f0_.film_project_id AS film_project_id_57,
  f0_.film_project_update_id AS film_project_update_id_58
FROM
  film_project_progress_report f0_
  LEFT JOIN film_project f1_ ON f0_.film_project_id = f1_.id
WHERE
  f0_.created_at >= ?
  AND f0_.created_at <= ?
  AND f1_.id = ?

SELECT f0_.id AS id_0, f0_.is_uptodate AS is_uptodate_1, f0_.project_update AS project_update_2, f0_.is_still_fundraising AS is_still_fundraising_3, f0_.project_active_status AS project_active_status_4, f0_.complete_film_year AS complete_film_year_5, f0_.is_complete_film_release AS is_complete_film_release_6, f0_.complete_film_where_available AS complete_film_where_available_7, f0_.complete_film_type AS complete_film_type_8, f0_.complete_film_progress_details AS complete_film_progress_details_9, f0_.reach_response_details AS reach_response_details_10, f0_.reach_response_use AS reach_response_use_11, f0_.outcome_change AS outcome_change_12, f0_.is_outcome_measured_impact AS is_outcome_measured_impact_13, f0_.outcome_measured_impact_details AS outcome_measured_impact_details_14, f0_.outcome_contribute_extent AS outcome_contribute_extent_15, f0_.feedback_engagement AS feedback_engagement_16, f0_.feedback_engagement_details AS feedback_engagement_details_17, f0_.feedback_experience_agreement AS feedback_experience_agreement_18, f0_.feedback_doing_well AS feedback_doing_well_19, f0_.feedback_improvement AS feedback_improvement_20, f0_.feedback_involvement AS feedback_involvement_21, f0_.feedback_improvement_details AS feedback_improvement_details_22, f0_.created_at AS created_at_23, f0_.modified_at AS modified_at_24, f0_.feedback_benefit_agreement AS feedback_benefit_agreement_25, f0_.feedback_recommend_agreement AS feedback_recommend_agreement_26, f0_.feedback_critical_role_agreement AS feedback_critical_role_agreement_27, f0_.reach_response_use_details AS reach_response_use_details_28, f0_.feedback_comment AS feedback_comment_29, f0_.complete_film_type_details AS complete_film_type_details_30, f0_.outcome_awareness_extent AS outcome_awareness_extent_31, f0_.outcome_visibility_extent AS outcome_visibility_extent_32, f0_.outcome_connection_extent AS outcome_connection_extent_33, f0_.outcome_action_extent AS outcome_action_extent_34, f0_.outcome_organisation_extent AS outcome_organisation_extent_35, f0_.outcome_community_extent AS outcome_community_extent_36, f0_.outcome_system_extent AS outcome_system_extent_37, f0_.status AS status_38, f0_.project_update_category AS project_update_category_39, f0_.is_file_public AS is_file_public_40, f0_.project_update_tags AS project_update_tags_41, f0_.current_stage AS current_stage_42, f0_.screener_link AS screener_link_43, f0_.screen_password AS screen_password_44, f0_.trailer_link AS trailer_link_45, f0_.trailer_password AS trailer_password_46, f0_.digital_assets_link AS digital_assets_link_47, f0_.general_support_area AS general_support_area_48, f0_.general_support_area_details AS general_support_area_details_49, f0_.fundraising_status AS fundraising_status_50, f0_.outcome_additional_information AS outcome_additional_information_51, f0_.is_draft AS is_draft_52, f0_.film_website_url AS film_website_url_53, f0_.is_document AS is_document_54, f0_.online_document_link AS online_document_link_55, f0_.is_active AS is_active_56, f0_.film_project_id AS film_project_id_57, f0_.film_project_update_id AS film_project_update_id_58 FROM film_project_progress_report f0_ LEFT JOIN film_project f1_ ON f0_.film_project_id = f1_.id WHERE f0_.created_at >= '2024-01-01 00:00:00' AND f0_.created_at <= '2024-12-31 23:59:59' AND f1_.id = 2;

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

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'daf_portal_staging'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  DATABASE()

SELECT DATABASE();