https://daf-middleware.wtdevsite.com/progress-report/2025?projectId=3

Query Metrics

8 Database Queries
6 Different statements
24.68 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.30 ms
(49.84%)
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_.film_project_id AS film_project_id_56, f0_.film_project_update_id AS film_project_update_id_57 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 = ?
Parameters:
[
  "2025-01-01 00:00:00"
  "2025-12-31 23:59:59"
  3
]
4.99 ms
(20.21%)
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"
]
4.29 ms
(17.40%)
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 = ? LIMIT 1
Parameters:
[
  "progress_report_intro_copy"
]
1.73 ms
(7.00%)
1
"COMMIT"
Parameters:
[]
0.98 ms
(3.99%)
1
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[
  "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTgzOTQ4NDMsImV4cCI6MTc1ODM5NjY0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.SbssywXkrQIsFGbqDHHn4uGL2LjowKEeE6YZFTCr31452luzvGOjmEa2mREMikI70aUO8MmyzICBwZeyw_AmIt4ZpV2eBbnMsf_N-42CcbNsQ1GIQXv3cHfPT7NTPVeEAUUyF8BGfA2YC0-n6iGk204R-GBdrz_mnbpq6BdMoUgubg9l8AHL3FM9lBUKHE8gGkyKC9DKYSHGEAAM8Fsf5jKwyx6f2_bNJgSMrV8dyauijTm1gp3UDguzpgW4k3vrEJXCwzG63zs7VsYZPgVEpDzb2PJbUO1sidyvNRa2wWR-PbXgzH8OIWezTBGGk0sJbnf3GpaQhY_c3tiWrMp8rg"
  "1758396643"
  "4hWbq4d0Tg3D5cnqmuL3DtDYJCfndNY0t3obUAvQB5c"
  "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NTgzOTQ4NDMsImV4cCI6MTc1ODM5NTE0MywiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzU4Mzk0ODQzLCJhdF9oYXNoIjoiTzgxTEVzZlExb0o4YlhkV1AwQVV1QSIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.TGPSR1y95vcF-3qlXMhKymZ9pK1DHdSCygTR2V1edd1zMOk6dR9KWO9Y3jXg8MlI09G6-QCu0H4ZIMdjRq9hbiLsbv42KiR-YV9ELLdOQ0jC0qlP8GjXnZp3S54ckneERw_HYxQdeRaG2iIVHhjtd9ftSSI7nCqCvai43T5vPv6D9-awCxGlxyM__RamfMmmu82HIbwhfNoVxNlsCI1KAM2JfSTbX_lwTbEmTo46RntsGq5aQxNzNYjcULaYB8oMCqLdkSjOHzWdOt9wd7wn-6NxhwNsOIXJdkxWe9oSFs3gurMqQ8TYEN7eR_qZug6LJcbYdqDf-9NcpXnlAIvVrA"
  1
]
0.38 ms
(1.56%)
1
"START TRANSACTION"
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.