Query Metrics

84 Database Queries
9 Different statements
27.09 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
21.10 ms
(77.89%)
70
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.published AS published_4, t0.slug AS slug_5, t0.position AS position_6, t0.parent_page AS parent_page_7, t0.featured_image AS featured_image_8, t0.external_link AS external_link_9, t0.file AS file_10, t0.category_id AS category_id_11 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
  5
]
2.64 ms
(9.76%)
7
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.published AS published_4, t0.slug AS slug_5, t0.position AS position_6, t0.parent_page AS parent_page_7, t0.featured_image AS featured_image_8, t0.external_link AS external_link_9, t0.file AS file_10, t0.category_id AS category_id_11 FROM PAGE t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.85 ms
(3.13%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.published AS published_4, t0.slug AS slug_5, t0.position AS position_6, t0.parent_page AS parent_page_7, t0.featured_image AS featured_image_8, t0.external_link AS external_link_9, t0.file AS file_10, t0.category_id AS category_id_11 FROM PAGE t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "existing-committee"
]
0.60 ms
(2.22%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.designation AS designation_2, m0_.email AS email_3, m0_.info AS info_4, m0_.description AS description_5, m0_.photo AS photo_6, m0_.membership_year AS membership_year_7, m0_.type_id AS type_id_8 FROM member m0_ LEFT JOIN member_type m1_ ON m0_.type_id = m1_.id WHERE m1_.page_id = ? ORDER BY m0_.membership_year DESC
Parameters:
[
  18
]
0.44 ms
(1.62%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.published AS published_4, t0.slug AS slug_5, t0.position AS position_6, t0.parent_page AS parent_page_7, t0.featured_image AS featured_image_8, t0.external_link AS external_link_9, t0.file AS file_10, t0.category_id AS category_id_11 FROM PAGE t0 WHERE t0.parent_page = ? AND t0.published = ?
Parameters:
[
  18
  1
]
0.43 ms
(1.58%)
1
SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.date AS date_2, a0_.attachment AS attachment_3, a0_.number AS number_4, a0_.page_id AS page_id_5 FROM attachments a0_ WHERE a0_.page_id = ? ORDER BY a0_.date DESC
Parameters:
[
  18
]
0.38 ms
(1.41%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.date AS date_3, t0.attachment AS attachment_4, t0.number AS number_5, t0.page_id AS page_id_6 FROM attachments t0 WHERE t0.page_id = ?
Parameters:
[
  18
]
0.33 ms
(1.21%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3 FROM important_links t0
Parameters:
[]
0.32 ms
(1.17%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.position AS position_2 FROM category c0_ ORDER BY c0_.position ASC
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