Query Metrics
8
Database Queries
6
Different statements
26.04 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 6.06 ms |
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"
]
|
| 2 | 0.48 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.84 ms |
UPDATE xero_storage SET access_token = ?, expires = ?, refresh_token = ?, id_token = ? WHERE id = ?
Parameters:
[ "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NjEzOTEyNzYsImV4cCI6MTc2MTM5MzA3NiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Imh0dHBzOi8vaWRlbnRpdHkueGVyby5jb20vcmVzb3VyY2VzIiwiY2xpZW50X2lkIjoiOTQ5NjRGMDI5MDkxNDI0NUI1OTdDNkFDNEQ0MTU4MDIiLCJzdWIiOiIyYjZhN2M2YjJlZTE1M2Y1YTA0ODdkMGNmOGJjM2VlOSIsImF1dGhfdGltZSI6MTY5MTk5MjU5NywieGVyb191c2VyaWQiOiJhYjg4ZTU1My0yNDZlLTQ4ZDMtOTJkYy0wYTFmNmVmMzkxY2UiLCJnbG9iYWxfc2Vzc2lvbl9pZCI6IjY3NjYxMWEwZDM5MDRhZGVhMmIzMmVmNTA0ODU4YWExIiwic2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJqdGkiOiIwMzA2RDFBMkQ4QUY3Qzc3OThGNEI1REQxRjlCOTZBOCIsImF1dGhlbnRpY2F0aW9uX2V2ZW50X2lkIjoiYzk3YTI4ZTktNDU4YS00MzZjLWJkZTMtZDZjZWExNWI0ZDJmIiwic2NvcGUiOlsiZW1haWwiLCJwcm9maWxlIiwib3BlbmlkIiwiYWNjb3VudGluZy5yZXBvcnRzLnJlYWQiLCJhY2NvdW50aW5nLnNldHRpbmdzIiwiYWNjb3VudGluZy5hdHRhY2htZW50cyIsImFjY291bnRpbmcudHJhbnNhY3Rpb25zIiwiYWNjb3VudGluZy5qb3VybmFscy5yZWFkIiwiYWNjb3VudGluZy5jb250YWN0cyIsIm9mZmxpbmVfYWNjZXNzIl0sImFtciI6WyJwd2QiXX0.F5APGRp9dM1GnVATG0P2nyaK6lAYKIQb23zL2Xbm2PChaegzEORDWPpC0G8VzUDQEZJbhiCytGUOWeS4TX2nNP_BBGxumebezXyMkq-YCvWRUYiOMKaTg-4KGSqq8BuGznZnu6PY9DgeZX9AhKXgtmjWWNs2bApnuwblQRzEM_kaZVhPtTgOPUPT9jqR2eTGxT0DCLGhme4Rn716i46JNJcGZxKujedOlEFe6j76v4AmyRF_cw1Sf4n88D95LBcEhcgnmHyl6yispRzA3ZPwnV713_Y9elG7vIBnxbCkUknpHQgMlocA4iAyDFsZawMsefQ8EsmWyeE1jaO_zMQxgA" "1761393076" "lKqcruG6mGQ9PCoCHIodJKFEIfsw8KwF2la1w5rz4sk" "eyJhbGciOiJSUzI1NiIsImtpZCI6IjFDQUY4RTY2NzcyRDZEQzAyOEQ2NzI2RkQwMjYxNTgxNTcwRUZDMTkiLCJ0eXAiOiJKV1QiLCJ4NXQiOiJISy1PWm5jdGJjQW8xbkp2MENZVmdWY09fQmsifQ.eyJuYmYiOjE3NjEzOTEyNzYsImV4cCI6MTc2MTM5MTU3NiwiaXNzIjoiaHR0cHM6Ly9pZGVudGl0eS54ZXJvLmNvbSIsImF1ZCI6Ijk0OTY0RjAyOTA5MTQyNDVCNTk3QzZBQzRENDE1ODAyIiwiaWF0IjoxNzYxMzkxMjc2LCJhdF9oYXNoIjoiMnI1d3pPcE13ZXlCeUo4ZDBndEtLdyIsInN1YiI6IjJiNmE3YzZiMmVlMTUzZjVhMDQ4N2QwY2Y4YmMzZWU5IiwiYXV0aF90aW1lIjoxNjkxOTkyNTk3LCJ4ZXJvX3VzZXJpZCI6ImFiODhlNTUzLTI0NmUtNDhkMy05MmRjLTBhMWY2ZWYzOTFjZSIsImdsb2JhbF9zZXNzaW9uX2lkIjoiNjc2NjExYTBkMzkwNGFkZWEyYjMyZWY1MDQ4NThhYTEiLCJzaWQiOiI2NzY2MTFhMGQzOTA0YWRlYTJiMzJlZjUwNDg1OGFhMSIsInByZWZlcnJlZF91c2VybmFtZSI6ImtldmluQHdoaXRldG93ZXIuY29tLmF1IiwiZW1haWwiOiJrZXZpbkB3aGl0ZXRvd2VyLmNvbS5hdSIsImdpdmVuX25hbWUiOiJLZXZpbiIsImZhbWlseV9uYW1lIjoiS2V2aW4iLCJuYW1lIjoiS2V2aW4gS2V2aW4iLCJhbXIiOlsicHdkIl19.ItiKaJ3QYThGVdFWr7EFgeq4EecnY5O2VJrcF4Vvfpf7SGuREHyUq93fnFihWJsvccq7vqMXGsClc2MWBdShM_aW6P7uk_O-USveBIh1lWmnNpxEEFad4Zn9HXb3RLfEns507EMjZz-rRummagPVtt0Pae5NeKI8DmrJ3-Zxy5J_1xDFTOwiA9jE5jOvM3xx9HSFk1xT235G9NpBHqcERN-S_dE9Wiv6kz8OyJpY72P8ro2C717UA07v3lEdgXX_Yes57_tA6NxTSZnGSFH8TGwiRQSHlDr7c8Xe55bjdDLq14oW7dZo7rUK_9WZf1tXRmaqyLOb3WiUT3Xk6jvnLw" 1 ] |
| 4 | 0.68 ms |
"COMMIT"
Parameters:
[] |
| 5 | 0.30 ms |
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"
]
|
| 6 | 0.79 ms |
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"
]
|
| 7 | 13.90 ms |
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.wordpress_id = ? LIMIT 1
Parameters:
[
"37438"
]
|
| 8 | 2.99 ms |
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 IS NULL
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\XeroStorage | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserBilling | No errors. |
| App\Entity\EmailTemplate | No errors. |
| App\Entity\Donation | No errors. |
| App\Entity\FilmProject | No errors. |
| App\Entity\FilmProjectDetails | No errors. |
| App\Entity\FilmProjectStoryImpact | No errors. |
| App\Entity\FilmProjectTimeline | No errors. |
| App\Entity\FilmProjectFunding | No errors. |
| App\Entity\OrderDetails |
|
| App\Entity\FilmProjectMember |
|
| App\Entity\Product | 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. |