Symfony Profiler

Query Metrics

41 Database Queries
5 Different statements
31.91 ms Query time
0 Invalid entities
78 Managed entities
Queries


SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company AS company_4, t0.email AS email_5, t0.branch AS branch_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.telephone AS telephone_9, t0.subdomain AS subdomain_10, t0.status AS status_11, t0.layout_id AS layout_id_12 FROM client t0 WHERE t0.subdomain = ? LIMIT 1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.client_id = ? AND t0.visible = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ INNER JOIN settings_content_group s1_ ON s0_.group_id = s1_.id AND (s1_.deleted_at IS NULL) INNER JOIN settings_content_category s2_ ON s1_.category_id = s2_.id AND (s2_.deleted_at IS NULL) WHERE (s2_.id = ?) AND (s0_.deleted_at IS NULL) ORDER BY s0_.page_view_counter DESC, s0_.id DESC LIMIT 3
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo AS logo_4, t0.logo_footer AS logo_footer_5, t0.favicon AS favicon_6, t0.link_imprint AS link_imprint_7, t0.link_agb AS link_agb_8, t0.seo_main_keywords AS seo_main_keywords_9, t0.seo_main_description AS seo_main_description_10, t0.header_background_color AS header_background_color_11, t0.primary_color AS primary_color_12, t0.dark_mode_default AS dark_mode_default_13, t0.hero_image AS hero_image_14 FROM client_layout t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
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\Content\Page	36
App\Entity\Content\Group	26
App\Entity\Content\Category	12
App\Entity\User	2
App\Entity\Client\Client	1
App\Entity\Client\Layout	1
Entities Mapping

Class	Mapping errors
App\Entity\Client\Client	No errors.
App\Entity\Client\Layout	No errors.
App\Entity\Settings\General	No errors.
App\Entity\User	No errors.
App\Entity\Content\Category	No errors.
App\Entity\Content\Group	No errors.
App\Entity\Content\Page	No errors.
App\Entity\Content\PageRating	No errors.
Symfony Profiler

GET https://hilfe.patientify.io/de/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
