Query Metrics

11 Database Queries
9 Different statements
16.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 5.22 ms
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 = ?
Parameters:
[
  "product-3"
]
2 1.45 ms
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"
]
3 0.96 ms
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"
]
4 0.99 ms
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:
[
  8
]
5 0.30 ms
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"
]
6 1.07 ms
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:
[
  9
]
7 2.37 ms
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:
[
  18
]
8 1.79 ms
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:
[
  18
]
9 0.84 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.title AS title_2, p0_.content AS content_3, p0_.language AS language_4, p0_.created_at AS created_at_5, p0_.updated_at AS updated_at_6, p0_.group_name AS group_name_7, p0_.primary_thumbnail AS primary_thumbnail_8, p0_.primary_image AS primary_image_9, p0_.tags AS tags_10, p0_.keywords AS keywords_11, p0_.meta_description AS meta_description_12, p0_.robot_tags AS robot_tags_13, p0_.title_format AS title_format_14, p0_.page_type AS page_type_15, p0_.page_type_data AS page_type_data_16, p0_.other_seo_tags AS other_seo_tags_17, p0_.open_graph_tags AS open_graph_tags_18, p0_.pinned AS pinned_19, p0_.ranking AS ranking_20, p0_.subgroup_name AS subgroup_name_21, p0_.primary_thumbnail_media_file_id AS primary_thumbnail_media_file_id_22, p0_.primary_image_media_file_id AS primary_image_media_file_id_23 FROM page_content p0_ WHERE p0_.name NOT IN (?) AND p0_.group_name = ? LIMIT 10
Parameters:
[
  "product-3"
  "services"
]
10 1.10 ms
SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.group_name AS group_name_3, f0_.display_rank AS display_rank_4, f0_.primary_thumb AS primary_thumb_5, f0_.primary_image AS primary_image_6, f0_.language AS language_7 FROM faqs f0_ WHERE f0_.id IN (NULL) ORDER BY f0_.display_rank DESC
Parameters:
[]
11 0.31 ms
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\Faqs No errors.