Query Metrics
7
Database Queries
4
Different statements
5.31 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.57 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.38 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"
]
|
3 | 0.59 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"
]
|
4 | 0.94 ms |
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_.video_link AS video_link_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 = ?
Parameters:
[ "2025-01-01 00:00:00" "2025-12-31 23:59:59" 2 ] |
5 | 0.42 ms |
SELECT DATABASE()
Parameters:
[] |
6 | 2.17 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"daf_portal_staging"
]
|
7 | 0.24 ms |
SELECT DATABASE()
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\User | No errors. |
App\Entity\UserBilling | No errors. |
App\Entity\EmailTemplate | No errors. |
App\Entity\XeroStorage | No errors. |
App\Entity\FilmProjectMember |
|
App\Entity\FilmProjectProgressReport | No errors. |
App\Entity\FilmProject | No errors. |
App\Entity\FilmProjectUpdate | No errors. |
App\Entity\UserProfile | No errors. |
App\Entity\UserAddress | No errors. |
App\Entity\UserInformation | No errors. |
App\Entity\OrderDetails |
|
App\Entity\UserCategory | No errors. |
App\Entity\ProjectNotification | No errors. |
App\Entity\FilmProjectProgressReportFile | No errors. |
App\Entity\FilmProjectDetails | No errors. |
App\Entity\FilmProjectStoryImpact | No errors. |
App\Entity\FilmProjectTimeline | No errors. |
App\Entity\FilmProjectFunding | No errors. |
App\Entity\Product | No errors. |
App\Entity\Donation | No errors. |
App\Entity\FilmProjectOriginal | No errors. |
App\Entity\FilmProjectImage | No errors. |
App\Entity\FilmProjectSponsor | No errors. |
App\Entity\FilmProjectChangeHistory | No errors. |
App\Entity\ProjectUpdateTypeNomination | No errors. |
App\Entity\OrderItems | No errors. |
App\Entity\OrderBillingDetails | No errors. |
App\Entity\PaymentDetails | No errors. |
App\Entity\ProductPercentageSplit | No errors. |
App\Entity\RecurringDonation | No errors. |
App\Entity\Event | No errors. |
App\Entity\XeroTrackingOption | No errors. |
App\Entity\XeroTrackingCategory | No errors. |
App\Entity\Setting | No errors. |
App\Entity\ResetPasswordRequest | No errors. |
App\Entity\XeroBrandingThemes | No errors. |
App\Entity\IssueTopic | No errors. |
App\Entity\IssueArea | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |