Query Metrics
78
Database Queries
13
Different statements
21.92 ms
Query time
0
Invalid entities
166
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
6.92 ms (31.58%) |
51 |
SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = ? AND c0_.locale = ?
Parameters:
[ "home.section.hero.enabled" "fr" ]
|
||||||||||||||||||||||||||||||||||
|
4.24 ms (19.33%) |
1 |
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.slug AS slug_2, c0_.title AS title_3, c0_.category_label AS category_label_4, c0_.short_description AS short_description_5, c0_.detail_lead_paragraph1 AS detail_lead_paragraph1_6, c0_.detail_lead_paragraph2 AS detail_lead_paragraph2_7, c0_.detail_section2_title AS detail_section2_title_8, c0_.detail_section2_body AS detail_section2_body_9, c0_.detail_section3_title AS detail_section3_title_10, c0_.detail_section3_body AS detail_section3_body_11, c0_.detail_section4_title AS detail_section4_title_12, c0_.detail_section4_body AS detail_section4_body_13, c0_.detail_challenge_title AS detail_challenge_title_14, c0_.detail_challenge_body AS detail_challenge_body_15, c0_.donation_enabled AS donation_enabled_16, c0_.donation_goal_cents AS donation_goal_cents_17, c0_.donation_raised_cents AS donation_raised_cents_18, c0_.donation_preset_amounts AS donation_preset_amounts_19, c0_.donation_default_amount AS donation_default_amount_20, c0_.donation_min_amount AS donation_min_amount_21, c0_.donation_allow_custom_amount AS donation_allow_custom_amount_22, c0_.donation_offline_enabled AS donation_offline_enabled_23, c0_.donation_offline_instructions AS donation_offline_instructions_24, c0_.donation_button_label AS donation_button_label_25, c0_.is_featured AS is_featured_26, c0_.sort_order AS sort_order_27, c0_.is_active AS is_active_28, c0_.created_at AS created_at_29, c0_.updated_at AS updated_at_30, c0_.list_media_id AS list_media_id_31, c0_.detail_media_id AS detail_media_id_32 FROM cms_cause c0_ WHERE c0_.locale = ? AND c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.title ASC
Parameters:
[ "fr" 1 ]
|
||||||||||||||||||||||||||||||||||
|
1.60 ms (7.28%) |
1 |
SELECT e0_.id AS id_0, e0_.locale AS locale_1, e0_.slug AS slug_2, e0_.title AS title_3, e0_.description AS description_4, e0_.content_html AS content_html_5, e0_.start_at AS start_at_6, e0_.end_at AS end_at_7, e0_.location AS location_8, e0_.image_path AS image_path_9, e0_.status AS status_10, e0_.requires_registration AS requires_registration_11, e0_.price_cents AS price_cents_12, e0_.currency AS currency_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15 FROM event e0_ WHERE e0_.locale = ? AND e0_.status = ? AND e0_.start_at >= ? ORDER BY e0_.start_at ASC, e0_.created_at DESC LIMIT 3
Parameters:
[ "fr" "published" "2026-03-01 10:15:14" ]
|
||||||||||||||||||||||||||||||||||
|
1.20 ms (5.49%) |
1 |
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.locale AS locale_3, t0.slug AS slug_4, t0.title_h1 AS title_h1_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.body_html AS body_html_8, t0.needs_translation AS needs_translation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM cms_page t0 WHERE t0.route_name = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "app_home" "fr" ]
|
||||||||||||||||||||||||||||||||||
|
1.13 ms (5.15%) |
3 |
SELECT c0_.id AS id_0, c0_.label AS label_1, c0_.link_type AS link_type_2, c0_.route_token AS route_token_3, c0_.external_url AS external_url_4, c0_.open_in_new_tab AS open_in_new_tab_5, c0_.sort_order AS sort_order_6, c0_.is_enabled AS is_enabled_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.menu_id AS menu_id_10, c0_.parent_id AS parent_id_11 FROM cms_navigation_item c0_ WHERE c0_.menu_id = ? AND c0_.is_enabled = true ORDER BY c0_.sort_order ASC, c0_.label ASC
Parameters:
[ Symfony\Component\Uid\Uuid {#2492 : "10000000-0000-0000-0000-000000000001" } ] |
||||||||||||||||||||||||||||||||||
|
1.03 ms (4.68%) |
4 |
SELECT t0.id AS id_1, t0.file_path AS file_path_2, t0.original_name AS original_name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.title AS title_6, t0.alt_fr AS alt_fr_7, t0.alt_en AS alt_en_8, t0.created_at AS created_at_9 FROM cms_media t0 WHERE t0.id = ?
Parameters:
[
"019b4b0e-91f1-7bb6-91fc-4e819a1c83d5"
]
|
||||||||||||||||||||||||||||||||||
|
1.02 ms (4.66%) |
8 |
SELECT c0_.id AS id_0, c0_.key AS key_1, c0_.locale AS locale_2, c0_.value_type AS value_type_3, c0_.value AS value_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_site_setting c0_ WHERE c0_.key = ? AND c0_.locale IS NULL
Parameters:
[
"contact.email"
]
|
||||||||||||||||||||||||||||||||||
|
0.94 ms (4.30%) |
1 |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.locale AS locale_2, c0_.key AS key_3, c0_.tab_title AS tab_title_4, c0_.tab_day_short AS tab_day_short_5, c0_.tab_time_line1 AS tab_time_line1_6, c0_.tab_time_line2 AS tab_time_line2_7, c0_.panel_time_label AS panel_time_label_8, c0_.panel_title AS panel_title_9, c0_.panel_excerpt AS panel_excerpt_10, c0_.panel_cta_label AS panel_cta_label_11, c0_.panel_cta_route AS panel_cta_route_12, c0_.sort_order AS sort_order_13, c0_.is_active AS is_active_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.media_id AS media_id_17 FROM cms_recurring_activity c0_ WHERE c0_.locale = ? AND c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.id ASC
Parameters:
[ "fr" 1 ]
|
||||||||||||||||||||||||||||||||||
|
0.87 ms (3.95%) |
3 |
SELECT c0_.id AS id_0, c0_.location AS location_1, c0_.locale AS locale_2, c0_.title AS title_3, c0_.is_enabled AS is_enabled_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6 FROM cms_navigation_menu c0_ WHERE c0_.location = ? AND c0_.locale = ? AND c0_.is_enabled = true LIMIT 1
Parameters:
[ "header_main" "fr" ] |
||||||||||||||||||||||||||||||||||
|
0.86 ms (3.90%) |
1 |
SELECT b0_.id AS id_0, b0_.locale AS locale_1, b0_.slug AS slug_2, b0_.title AS title_3, b0_.excerpt AS excerpt_4, b0_.content_html AS content_html_5, b0_.author_name AS author_name_6, b0_.category_label AS category_label_7, b0_.featured_image_path AS featured_image_path_8, b0_.status AS status_9, b0_.published_at AS published_at_10, b0_.created_at AS created_at_11, b0_.updated_at AS updated_at_12 FROM blog_post b0_ WHERE b0_.locale = ? AND b0_.status = ? AND ((b0_.published_at IS NULL OR b0_.published_at <= ?)) ORDER BY b0_.published_at DESC, b0_.created_at DESC LIMIT 3
Parameters:
[ "fr" "published" "2026-03-01 10:15:14" ]
|
||||||||||||||||||||||||||||||||||
|
0.74 ms (3.36%) |
2 |
SELECT c0_.id AS id_0, c0_.enabled AS enabled_1, c0_.sort_order AS sort_order_2, c0_.platform AS platform_3, c0_.url AS url_4, c0_.icon_class AS icon_class_5, c0_.label_fr AS label_fr_6, c0_.label_en AS label_en_7 FROM cms_social_link c0_ WHERE c0_.enabled = ? AND c0_.url <> ? ORDER BY c0_.sort_order ASC, c0_.platform ASC
Parameters:
[
1
""
]
|
||||||||||||||||||||||||||||||||||
|
0.74 ms (3.36%) |
1 |
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.author_name AS author_name_2, c0_.author_role AS author_role_3, c0_.quote AS quote_4, c0_.rating AS rating_5, c0_.sort_order AS sort_order_6, c0_.is_active AS is_active_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.media_id AS media_id_10 FROM cms_testimonial c0_ WHERE c0_.locale = ? AND c0_.is_active = ? ORDER BY c0_.sort_order ASC, c0_.updated_at DESC LIMIT 8
Parameters:
[ "fr" 1 ]
|
||||||||||||||||||||||||||||||||||
|
0.64 ms (2.94%) |
1 |
SELECT t0.id AS id_1, t0.asset_key AS asset_key_2, t0.asset_kind AS asset_kind_3, t0.page_id AS page_id_4, t0.media_id AS media_id_5 FROM cms_page_asset t0 WHERE t0.page_id = ?
Parameters:
[
"019b6a92-8b57-7063-a371-f665c593f0e6"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Cms\SiteSetting | 59 |
| App\Entity\Cms\NavigationItem | 28 |
| App\Entity\Cms\PageAsset | 27 |
| App\Entity\Cms\Media | 27 |
| App\Entity\Cms\Cause | 4 |
| App\Entity\Cms\RecurringActivity | 4 |
| App\Entity\Cms\SocialLink | 4 |
| App\Entity\Event | 3 |
| App\Entity\Cms\Testimonial | 3 |
| App\Entity\Blog\BlogPost | 3 |
| App\Entity\Cms\NavigationMenu | 3 |
| App\Entity\Cms\Page | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Cms\Cause | No errors. |
| App\Entity\Cms\Media | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\EventRegistration | No errors. |
| App\Entity\Cms\RecurringActivity | No errors. |
| App\Entity\Cms\SocialLink | No errors. |
| App\Entity\Cms\Testimonial | No errors. |
| App\Entity\Blog\BlogPost | No errors. |
| App\Entity\Cms\SiteSetting | No errors. |
| App\Entity\Cms\Page | No errors. |
| App\Entity\Cms\PageAsset | No errors. |
| App\Entity\Cms\NavigationMenu | No errors. |
| App\Entity\Cms\NavigationItem | No errors. |