Query Metrics

12 Database Queries
9 Different statements
38.32 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
14.80 ms
(38.63%)
1
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.image AS image_2, t0_.about AS about_3, t0_.position AS position_4, t0_.phone AS phone_5, t0_.email AS email_6, t0_.expertise AS expertise_7, t0_.website AS website_8, t0_.list_ranking AS list_ranking_9, t0_.group_names AS group_names_10 FROM team_member t0_ WHERE t0_.group_names LIKE ? ORDER BY t0_.list_ranking ASC
Parameters:
[
  "%team%"
]
6.24 ms
(16.29%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_public AS is_public_6, t0.ranking AS ranking_7 FROM photo_album t0 INNER JOIN page_content_photo_album ON t0.id = page_content_photo_album.photo_album_id WHERE page_content_photo_album.page_content_id = ?
Parameters:
[
  4
]
4.81 ms
(12.56%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.language AS language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.group_name AS group_name_8, t0.primary_thumbnail AS primary_thumbnail_9, t0.primary_image AS primary_image_10, t0.tags AS tags_11, t0.keywords AS keywords_12, t0.meta_description AS meta_description_13, t0.robot_tags AS robot_tags_14, t0.title_format AS title_format_15, t0.page_type AS page_type_16, t0.page_type_data AS page_type_data_17, t0.other_seo_tags AS other_seo_tags_18, t0.open_graph_tags AS open_graph_tags_19, t0.pinned AS pinned_20, t0.ranking AS ranking_21, t0.subgroup_name AS subgroup_name_22, t0.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_23, t0.primary_image_media_file_id AS primary_image_media_file_id_24 FROM page_content t0 WHERE t0.name IN (?) LIMIT 1
Parameters:
[
  "about"
]
3.68 ms
(9.62%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.language AS language_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.group_name AS group_name_8, t0.primary_thumbnail AS primary_thumbnail_9, t0.primary_image AS primary_image_10, t0.tags AS tags_11, t0.keywords AS keywords_12, t0.meta_description AS meta_description_13, t0.robot_tags AS robot_tags_14, t0.title_format AS title_format_15, t0.page_type AS page_type_16, t0.page_type_data AS page_type_data_17, t0.other_seo_tags AS other_seo_tags_18, t0.open_graph_tags AS open_graph_tags_19, t0.pinned AS pinned_20, t0.ranking AS ranking_21, t0.subgroup_name AS subgroup_name_22, t0.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_23, t0.primary_image_media_file_id AS primary_image_media_file_id_24 FROM page_content t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "about"
]
3.38 ms
(8.81%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.download_type AS download_type_3, t0.file_type AS file_type_4, t0.path AS path_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.page_id AS page_id_8, t0.page_id AS page_id_9 FROM page_download t0 WHERE t0.page_id = ?
Parameters:
[
  4
]
2.09 ms
(5.45%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.filename AS filename_3, t0.path AS path_4, t0.storage_type AS storage_type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.metadata AS metadata_8, t0.version AS version_9 FROM media_file t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.38 ms
(3.59%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.value AS value_4 FROM setting t0 WHERE t0.type = ?
Parameters:
[
  "siteSettings"
]
1.29 ms
(3.38%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.language AS language_4 FROM custom_content_fields t0 WHERE t0.language = ?
Parameters:
[
  "en"
]
0.64 ms
(1.67%)
1
SELECT p0_.name AS name_0, p0_.title AS title_1 FROM page_content p0_ WHERE p0_.group_name = ?
Parameters:
[
  "products"
]

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\PageContent No errors.
App\Entity\MediaFile No errors.
App\Entity\PageDownload No errors.
App\Entity\PhotoAlbum No errors.
App\Entity\CustomContentFields No errors.
App\Entity\Setting No errors.
App\Entity\Photo No errors.
App\Entity\YoutubeVideo No errors.
App\Entity\TeamMember No errors.