Query Metrics

6 Database Queries
6 Different statements
1.47 ms Query time
0 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.33 ms
(22.27%)
1
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:
[
  "6"
]
0.27 ms
(18.18%)
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 AND n0_.association_id = ? ORDER BY n0_.published_at DESC LIMIT 10
Parameters:
[
  6
]
0.24 ms
(16.07%)
1
SELECT t0.id AS id_1, t0.relation_type AS relation_type_2, t0.child_profile_id AS child_profile_id_3, t0.association_id AS association_id_4 FROM child_association t0 WHERE t0.association_id = ?
Parameters:
[
  6
]
0.23 ms
(15.73%)
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_ WHERE a0_.association_id = ? AND a0_.status = ? ORDER BY a0_.created_at DESC LIMIT 3
Parameters:
[
  6
  "published"
]
0.21 ms
(14.36%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5, t0.association_id AS association_id_6 FROM association_contact t0 WHERE t0.association_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]
0.20 ms
(13.40%)
1
SELECT t0.id AS id_1, t0.platform AS platform_2, t0.url AS url_3, t0.label AS label_4, t0.position AS position_5, t0.association_id AS association_id_6 FROM association_social_network t0 WHERE t0.association_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]

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\Association\Association 1
App\Entity\Association\AssociationContact 1