Query Metrics

12 Database Queries
9 Different statements
2.52 ms Query time
0 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.67 ms
(26.45%)
3
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
0.35 ms
(13.91%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.mission AS mission_5, t0.region AS region_6, t0.website AS website_7, t0.logo_filename AS logo_filename_8, t0.membership_available AS membership_available_9, t0.donation_available AS donation_available_10, t0.verified_status AS verified_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by_id AS created_by_id_14 FROM association t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.29 ms
(11.52%)
1
SELECT COUNT(c0_.id) AS sclr_0 FROM child_profile c0_ WHERE c0_.visibility_level IN (?, ?)
Parameters:
[
  "public"
  "community"
]
0.26 ms
(10.14%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.image_urls AS image_urls_3, a0_.video_embeds AS video_embeds_4, a0_.resource_links AS resource_links_5, a0_.location_name AS location_name_6, a0_.address_line1 AS address_line1_7, a0_.postal_code AS postal_code_8, a0_.city AS city_9, a0_.country AS country_10, a0_.map_embed_url AS map_embed_url_11, a0_.starts_at AS starts_at_12, a0_.ends_at AS ends_at_13, a0_.status AS status_14, a0_.view_count AS view_count_15, a0_.participant_count AS participant_count_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.association_id AS association_id_19, a0_.created_by_id AS created_by_id_20 FROM association_event a0_ INNER JOIN association a1_ ON a0_.association_id = a1_.id WHERE a0_.status = ? AND a1_.verified_status = ? AND a0_.starts_at IS NOT NULL AND a0_.starts_at >= ? ORDER BY a0_.starts_at ASC LIMIT 3
Parameters:
[
  "published"
  "officielle"
  "2026-05-02 10:40:10"
]
0.24 ms
(9.42%)
1
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.short_summary AS short_summary_2, f0_.description AS description_3, f0_.project_type AS project_type_4, f0_.goal_amount AS goal_amount_5, f0_.collected_amount AS collected_amount_6, f0_.status AS status_7, f0_.visibility_level AS visibility_level_8, f0_.cover_filename AS cover_filename_9, f0_.pinned AS pinned_10, f0_.closing_message AS closing_message_11, f0_.closing_image_filename AS closing_image_filename_12, f0_.provider AS provider_13, f0_.fundraising_mode AS fundraising_mode_14, f0_.embed_url AS embed_url_15, f0_.embed_height AS embed_height_16, f0_.external_url AS external_url_17, f0_.created_at AS created_at_18, f0_.updated_at AS updated_at_19, f0_.child_profile_id AS child_profile_id_20, f0_.created_by_id AS created_by_id_21 FROM funding_project f0_ WHERE f0_.status = ? AND f0_.visibility_level = ? ORDER BY f0_.created_at DESC LIMIT 3
Parameters:
[
  "published"
  "public"
]
0.20 ms
(7.99%)
1
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.display_name AS display_name_2, c0_.birth_date AS birth_date_3, c0_.region AS region_4, c0_.bio AS bio_5, c0_.photo_filename AS photo_filename_6, c0_.hero_filename AS hero_filename_7, c0_.visibility_level AS visibility_level_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10 FROM child_profile c0_ WHERE c0_.visibility_level = ? ORDER BY c0_.created_at DESC LIMIT 3
Parameters:
[
  "public"
]
0.20 ms
(7.75%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.excerpt AS excerpt_2, n0_.content AS content_3, n0_.category AS category_4, n0_.is_published AS is_published_5, n0_.published_at AS published_at_6, n0_.view_count AS view_count_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n0_.author_id AS author_id_10, n0_.association_id AS association_id_11 FROM news_article n0_ WHERE n0_.is_published = 1 ORDER BY n0_.published_at DESC LIMIT 3
Parameters:
[]
0.17 ms
(6.63%)
1
SELECT COUNT(f0_.id) AS sclr_0 FROM funding_project f0_ WHERE f0_.status = ?
Parameters:
[
  "published"
]
0.16 ms
(6.20%)
1
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\News\NewsArticle 3
App\Entity\News\NewsArticlePhoto 3
App\Entity\Portrait\ChildProfile 2
App\Entity\Association\Association 2
App\Entity\Funding\FundingProject 1
App\Entity\Auth\User 1
App\Entity\Association\AssociationEvent 1