Symfony Profiler

Query Metrics

15 Database Queries
13 Different statements
1.98 ms Query time
0 Invalid entities
15 Managed entities
Queries

Group similar statements
default connection


SELECT a0_.title AS title_0, a0_.description AS description_1, a0_.priority AS priority_2, a0_.allWebspaces AS allWebspaces_3, a0_.active AS active_4, a0_.id AS id_5, a1_.title AS title_6, a1_.frequency AS frequency_7, a1_.id AS id_8, a2_.`type` AS type_9, a2_.`condition` AS condition_10, a2_.id AS id_11, a1_.idTargetGroups AS idTargetGroups_12, a2_.idTargetGroupRules AS idTargetGroupRules_13 FROM at_target_groups a0_ INNER JOIN at_target_group_rules a1_ ON a0_.id = a1_.idTargetGroups INNER JOIN at_target_group_conditions a2_ ON a1_.id = a2_.idTargetGroupRules LEFT JOIN at_target_group_webspaces a3_ ON a0_.id = a3_.idTargetGroups WHERE a0_.active = 1 AND ((a0_.allWebspaces = 1 OR a3_.webspaceKey = ?)) AND a1_.frequency <= ? ORDER BY a0_.priority DESC
SELECT t0.id AS id_1, t0.webspace_key AS webspace_key_2, t0.title AS title_3, t0.description AS description_4, t0.type AS type_5, t0.type_key AS type_key_6, t0.data AS data_7, t0.locale AS locale_8, t0.execute AS execute_9, t0.execute_log AS execute_log_10, t0.protected AS protected_11, t0.published AS published_12, t0.created AS created_13, t0.changed AS changed_14, t0.idUsersCreator AS idUsersCreator_15, t0.idUsersChanger AS idUsersChanger_16 FROM we_settings t0 WHERE t0.type_key = ? AND t0.webspace_key = ? AND t0.published = ? LIMIT 1
SELECT 1 FROM phpcr_workspaces WHERE name = ?
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
SELECT prefix, uri FROM phpcr_namespaces
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m0_.verify_download AS verify_download_3, m0_.is_ai_generated AS is_ai_generated_4, m1_.name AS name_5, m1_.description AS description_6, m1_.id AS id_7, m2_.style AS style_8, m2_.lft AS lft_9, m2_.rgt AS rgt_10, m2_.depth AS depth_11, m2_.collection_key AS collection_key_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.version AS version_16, m3_.id AS id_17, m3_.created AS created_18, m3_.changed AS changed_19, m4_.name AS name_20, m4_.version AS version_21, m4_.subVersion AS subVersion_22, m4_.size AS size_23, m4_.downloadCounter AS downloadCounter_24, m4_.storageOptions AS storageOptions_25, m4_.mimeType AS mimeType_26, m4_.properties AS properties_27, m4_.focusPointX AS focusPointX_28, m4_.focusPointY AS focusPointY_29, m4_.id AS id_30, m4_.created AS created_31, m4_.changed AS changed_32, m5_.crop_x AS crop_x_33, m5_.crop_y AS crop_y_34, m5_.crop_width AS crop_width_35, m5_.crop_height AS crop_height_36, m5_.format_key AS format_key_37, m6_.title AS title_38, m6_.description AS description_39, m6_.copyright AS copyright_40, m6_.credits AS credits_41, m6_.locale AS locale_42, m6_.id AS id_43, m7_.title AS title_44, m7_.description AS description_45, m7_.copyright AS copyright_46, m7_.credits AS credits_47, m7_.locale AS locale_48, m7_.id AS id_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, s10_.username AS username_54, s10_.password AS password_55, s10_.locale AS locale_56, s10_.salt AS salt_57, s10_.locked AS locked_58, s10_.enabled AS enabled_59, s10_.lastLogin AS lastLogin_60, s10_.confirmationKey AS confirmationKey_61, s10_.passwordResetToken AS passwordResetToken_62, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_63, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_64, s10_.privateKey AS privateKey_65, s10_.apiKey AS apiKey_66, s10_.email AS email_67, s10_.id AS id_68, s10_.created AS created_69, s10_.changed AS changed_70, c11_.firstName AS firstName_71, c11_.middleName AS middleName_72, c11_.lastName AS lastName_73, c11_.birthday AS birthday_74, c11_.salutation AS salutation_75, c11_.formOfAddress AS formOfAddress_76, c11_.newsletter AS newsletter_77, c11_.gender AS gender_78, c11_.note AS note_79, c11_.mainEmail AS mainEmail_80, c11_.mainPhone AS mainPhone_81, c11_.mainFax AS mainFax_82, c11_.mainUrl AS mainUrl_83, c11_.id AS id_84, c11_.created AS created_85, c11_.changed AS changed_86, s12_.username AS username_87, s12_.password AS password_88, s12_.locale AS locale_89, s12_.salt AS salt_90, s12_.locked AS locked_91, s12_.enabled AS enabled_92, s12_.lastLogin AS lastLogin_93, s12_.confirmationKey AS confirmationKey_94, s12_.passwordResetToken AS passwordResetToken_95, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_96, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_97, s12_.privateKey AS privateKey_98, s12_.apiKey AS apiKey_99, s12_.email AS email_100, s12_.id AS id_101, s12_.created AS created_102, s12_.changed AS changed_103, c13_.firstName AS firstName_104, c13_.middleName AS middleName_105, c13_.lastName AS lastName_106, c13_.birthday AS birthday_107, c13_.salutation AS salutation_108, c13_.formOfAddress AS formOfAddress_109, c13_.newsletter AS newsletter_110, c13_.gender AS gender_111, c13_.note AS note_112, c13_.mainEmail AS mainEmail_113, c13_.mainPhone AS mainPhone_114, c13_.mainFax AS mainFax_115, c13_.mainUrl AS mainUrl_116, c13_.id AS id_117, c13_.created AS created_118, c13_.changed AS changed_119, m14_.id AS id_120, m14_.created AS created_121, m14_.changed AS changed_122, m14_.verify_download AS verify_download_123, m14_.is_ai_generated AS is_ai_generated_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idCollections AS idCollections_126, m0_.idUsersCreator AS idUsersCreator_127, m0_.idUsersChanger AS idUsersChanger_128, m0_.idPreviewImage AS idPreviewImage_129, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_130, m2_.idCollectionTypes AS idCollectionTypes_131, m2_.idCollectionsParent AS idCollectionsParent_132, m2_.idUsersCreator AS idUsersCreator_133, m2_.idUsersChanger AS idUsersChanger_134, m3_.idMedia AS idMedia_135, m3_.idUsersCreator AS idUsersCreator_136, m3_.idUsersChanger AS idUsersChanger_137, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_138, m4_.idFiles AS idFiles_139, m4_.idUsersCreator AS idUsersCreator_140, m4_.idUsersChanger AS idUsersChanger_141, m5_.fileVersion AS fileVersion_142, m6_.idFileVersions AS idFileVersions_143, m7_.idFileVersions AS idFileVersions_144, m8_.idFileVersions AS idFileVersions_145, m9_.idFileVersions AS idFileVersions_146, s10_.idContacts AS idContacts_147, s10_.idUsersCreator AS idUsersCreator_148, s10_.idUsersChanger AS idUsersChanger_149, c11_.idTitles AS idTitles_150, c11_.avatar AS avatar_151, c11_.idUsersCreator AS idUsersCreator_152, c11_.idUsersChanger AS idUsersChanger_153, c11_.alternative_profile_picture_id AS alternative_profile_picture_id_154, s12_.idContacts AS idContacts_155, s12_.idUsersCreator AS idUsersCreator_156, s12_.idUsersChanger AS idUsersChanger_157, c13_.idTitles AS idTitles_158, c13_.avatar AS avatar_159, c13_.idUsersCreator AS idUsersCreator_160, c13_.idUsersChanger AS idUsersChanger_161, c13_.alternative_profile_picture_id AS alternative_profile_picture_id_162, m14_.idMediaTypes AS idMediaTypes_163, m14_.idCollections AS idCollections_164, m14_.idUsersCreator AS idUsersCreator_165, m14_.idUsersChanger AS idUsersChanger_166, m14_.idPreviewImage AS idPreviewImage_167 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_format_options m5_ ON m4_.id = m5_.fileVersion LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id LEFT JOIN me_media m14_ ON m0_.idPreviewImage = m14_.id WHERE m0_.id = ?
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
SELECT s0_.name AS name_0, s0_.role_key AS role_key_1, s0_.securitySystem AS securitySystem_2, s0_.anonymous AS anonymous_3, s0_.id AS id_4, s0_.created AS created_5, s0_.changed AS changed_6, s1_.context AS context_7, s1_.module AS module_8, s1_.permissions AS permissions_9, s1_.id AS id_10, s0_.idSecurityTypes AS idSecurityTypes_11, s0_.idUsersCreator AS idUsersCreator_12, s0_.idUsersChanger AS idUsersChanger_13, s1_.idRoles AS idRoles_14 FROM se_roles s0_ LEFT JOIN se_permissions s1_ ON s0_.id = s1_.idRoles WHERE s0_.anonymous = ?
SELECT s0_.permissions AS permissions_0, s0_.entityId AS entityId_1, s0_.entityClass AS entityClass_2, s0_.entityIdInteger AS entityIdInteger_3, s0_.id AS id_4, s0_.idRoles AS idRoles_5 FROM se_access_controls s0_ LEFT JOIN se_roles s1_ ON s0_.idRoles = s1_.id WHERE s0_.entityId = ? AND s0_.entityClass = ? AND s1_.securitySystem = ?
SELECT s0_.name AS name_0, s0_.role_key AS role_key_1, s0_.securitySystem AS securitySystem_2, s0_.anonymous AS anonymous_3, s0_.id AS id_4, s0_.created AS created_5, s0_.changed AS changed_6, s1_.context AS context_7, s1_.module AS module_8, s1_.permissions AS permissions_9, s1_.id AS id_10, s0_.idSecurityTypes AS idSecurityTypes_11, s0_.idUsersCreator AS idUsersCreator_12, s0_.idUsersChanger AS idUsersChanger_13, s1_.idRoles AS idRoles_14 FROM se_roles s0_ LEFT JOIN se_permissions s1_ ON s0_.id = s1_.idRoles WHERE s0_.anonymous = ?
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Database Connections

Name	Service
default	doctrine.dbal.default_connection
pharmacy	doctrine.dbal.pharmacy_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
Sulu\Bundle\MediaBundle\Entity\Collection	2
Sulu\Bundle\SecurityBundle\Entity\Permission	2
Alengo\Bundle\AlengoWebspaceSettingsBundle\Entity\WebspaceSettings	1
App\Entity\Media	1
Sulu\Bundle\MediaBundle\Entity\MediaType	1
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	1
Sulu\Bundle\MediaBundle\Entity\CollectionType	1
Sulu\Bundle\SecurityBundle\Entity\User	1
Sulu\Bundle\MediaBundle\Entity\File	1
Sulu\Bundle\MediaBundle\Entity\FileVersion	1
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	1
App\Entity\Contact	1
Sulu\Bundle\SecurityBundle\Entity\Role	1
Entities Mapping

No mapped entities.
Symfony Profiler

POST https://teamsante.alengo.dev/de/notification-modal

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping
