Symfony Profiler

Query Metrics

64 Database Queries

28 Different statements

38.52 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
7.28 ms (18.90%)	1	SELECT t0_.name AS name_0, t0_.id AS id_1, t0_.created AS created_2, t0_.changed AS changed_3, t0_.idUsersCreator AS idUsersCreator_4, t0_.idUsersChanger AS idUsersChanger_5 FROM ta_tags t0_ WHERE t0_.id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT t0_.name AS name_0, t0_.id AS id_1, t0_.created AS created_2, t0_.changed AS changed_3, t0_.idUsersCreator AS idUsersCreator_4, t0_.idUsersChanger AS idUsersChanger_5 FROM ta_tags t0_ WHERE t0_.id = ? SELECT t0_.name AS name_0, t0_.id AS id_1, t0_.created AS created_2, t0_.changed AS changed_3, t0_.idUsersCreator AS idUsersCreator_4, t0_.idUsersChanger AS idUsersChanger_5 FROM ta_tags t0_ WHERE t0_.id = 14;
6.99 ms (18.15%)	5	SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_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, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_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_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ? Parameters: [`653`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_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, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_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_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = ? SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.crop_x AS crop_x_35, m6_.crop_y AS crop_y_36, m6_.crop_width AS crop_width_37, m6_.crop_height AS crop_height_38, m6_.format_key AS format_key_39, m7_.title AS title_40, m7_.description AS description_41, m7_.copyright AS copyright_42, m7_.credits AS credits_43, m7_.locale AS locale_44, m7_.id AS id_45, m8_.title AS title_46, m8_.description AS description_47, m8_.copyright AS copyright_48, m8_.credits AS credits_49, m8_.locale AS locale_50, m8_.id AS id_51, m9_.locale AS locale_52, m9_.id AS id_53, m10_.locale AS locale_54, m10_.id AS id_55, s11_.username AS username_56, s11_.password AS password_57, s11_.locale AS locale_58, s11_.salt AS salt_59, s11_.locked AS locked_60, s11_.enabled AS enabled_61, s11_.lastLogin AS lastLogin_62, s11_.confirmationKey AS confirmationKey_63, s11_.passwordResetToken AS passwordResetToken_64, s11_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s11_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s11_.privateKey AS privateKey_67, s11_.apiKey AS apiKey_68, s11_.email AS email_69, s11_.id AS id_70, s11_.created AS created_71, s11_.changed AS changed_72, c12_.firstName AS firstName_73, c12_.middleName AS middleName_74, c12_.lastName AS lastName_75, c12_.birthday AS birthday_76, c12_.salutation AS salutation_77, c12_.formOfAddress AS formOfAddress_78, c12_.newsletter AS newsletter_79, c12_.gender AS gender_80, c12_.note AS note_81, c12_.mainEmail AS mainEmail_82, c12_.mainPhone AS mainPhone_83, c12_.mainFax AS mainFax_84, c12_.mainUrl AS mainUrl_85, c12_.id AS id_86, c12_.created AS created_87, c12_.changed AS changed_88, s13_.username AS username_89, s13_.password AS password_90, s13_.locale AS locale_91, s13_.salt AS salt_92, s13_.locked AS locked_93, s13_.enabled AS enabled_94, s13_.lastLogin AS lastLogin_95, s13_.confirmationKey AS confirmationKey_96, s13_.passwordResetToken AS passwordResetToken_97, s13_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s13_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s13_.privateKey AS privateKey_100, s13_.apiKey AS apiKey_101, s13_.email AS email_102, s13_.id AS id_103, s13_.created AS created_104, s13_.changed AS changed_105, c14_.firstName AS firstName_106, c14_.middleName AS middleName_107, c14_.lastName AS lastName_108, c14_.birthday AS birthday_109, c14_.salutation AS salutation_110, c14_.formOfAddress AS formOfAddress_111, c14_.newsletter AS newsletter_112, c14_.gender AS gender_113, c14_.note AS note_114, c14_.mainEmail AS mainEmail_115, c14_.mainPhone AS mainPhone_116, c14_.mainFax AS mainFax_117, c14_.mainUrl AS mainUrl_118, c14_.id AS id_119, c14_.created AS created_120, c14_.changed AS changed_121, m15_.id AS id_122, m15_.created AS created_123, m15_.changed AS changed_124, m0_.idMediaTypes AS idMediaTypes_125, m0_.idPreviewImage AS idPreviewImage_126, m0_.idCollections AS idCollections_127, m0_.idUsersCreator AS idUsersCreator_128, m0_.idUsersChanger AS idUsersChanger_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, t5_.idUsersCreator AS idUsersCreator_142, t5_.idUsersChanger AS idUsersChanger_143, m6_.fileVersion AS fileVersion_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, m10_.idFileVersions AS idFileVersions_148, s11_.idContacts AS idContacts_149, s11_.idUsersCreator AS idUsersCreator_150, s11_.idUsersChanger AS idUsersChanger_151, c12_.idTitles AS idTitles_152, c12_.avatar AS avatar_153, c12_.idUsersCreator AS idUsersCreator_154, c12_.idUsersChanger AS idUsersChanger_155, s13_.idContacts AS idContacts_156, s13_.idUsersCreator AS idUsersCreator_157, s13_.idUsersChanger AS idUsersChanger_158, c14_.idTitles AS idTitles_159, c14_.avatar AS avatar_160, c14_.idUsersCreator AS idUsersCreator_161, c14_.idUsersChanger AS idUsersChanger_162, m15_.idMediaTypes AS idMediaTypes_163, m15_.idPreviewImage AS idPreviewImage_164, m15_.idCollections AS idCollections_165, m15_.idUsersCreator AS idUsersCreator_166, m15_.idUsersChanger AS idUsersChanger_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_file_version_tags m16_ ON m4_.id = m16_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m16_.idTags LEFT JOIN me_file_version_categories m18_ ON m4_.id = m18_.idFileVersions LEFT JOIN ca_categories c17_ ON c17_.id = m18_.idCategories LEFT JOIN me_format_options m6_ ON m4_.id = m6_.fileVersion LEFT JOIN me_file_version_meta m7_ ON m4_.id = m7_.idFileVersions LEFT JOIN me_file_version_meta m8_ ON m4_.idFileVersionsMetaDefault = m8_.id LEFT JOIN me_file_version_content_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN me_file_version_publish_languages m10_ ON m4_.id = m10_.idFileVersions LEFT JOIN se_users s11_ ON m0_.idUsersCreator = s11_.id LEFT JOIN co_contacts c12_ ON s11_.idContacts = c12_.id LEFT JOIN se_users s13_ ON m0_.idUsersChanger = s13_.id LEFT JOIN co_contacts c14_ ON s13_.idContacts = c14_.id LEFT JOIN me_media m15_ ON m0_.idPreviewImage = m15_.id WHERE m0_.id = 653;
4.71 ms (12.23%)	13	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/plan-d-berechtigungen/routes/de/stories/2023-06-27-jetzt-oder-ki-digitale-loesungen-fuer-echte-probleme" "default_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/plan-d-berechtigungen/routes/de/stories/2023-06-27-jetzt-oder-ki-digitale-loesungen-fuer-echte-probleme') AND workspace_name = 'default_live' ORDER BY sort_order ASC;
3.57 ms (9.27%)	9	SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC Parameters: [`"/cmf/plan-d-berechtigungen/routes/de/stories/2023-06-27-jetzt-oder-ki-digitale-loesungen-fuer-echte-probleme" "default_live"`] View formatted query View runnable query Explain query SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC SELECT * FROM phpcr_nodes WHERE path = '/cmf/plan-d-berechtigungen/routes/de/stories/2023-06-27-jetzt-oder-ki-digitale-loesungen-fuer-echte-probleme' AND workspace_name = 'default_live' ORDER BY depth, sort_order ASC;
3.10 ms (8.06%)	2	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC Parameters: [`"default_live" "/cmf/plan-d-berechtigungen/contents/ueber-uns" "/cmf/plan-d-berechtigungen/contents/leistungen" "/cmf/plan-d-berechtigungen/contents/cases" "/cmf/plan-d-berechtigungen/contents/career" "/cmf/plan-d-berechtigungen/contents/contact"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND ( path = ? OR path = ? OR path = ? OR path = ? OR path = ? ) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/plan-d-berechtigungen/contents/ueber-uns' OR path = '/cmf/plan-d-berechtigungen/contents/leistungen' OR path = '/cmf/plan-d-berechtigungen/contents/cases' OR path = '/cmf/plan-d-berechtigungen/contents/career' OR path = '/cmf/plan-d-berechtigungen/contents/contact') ORDER BY sort_order ASC;
1.72 ms (4.47%)	2	SELECT c0_.firstName AS firstName_0, c0_.middleName AS middleName_1, c0_.lastName AS lastName_2, c0_.birthday AS birthday_3, c0_.salutation AS salutation_4, c0_.formOfAddress AS formOfAddress_5, c0_.newsletter AS newsletter_6, c0_.gender AS gender_7, c0_.note AS note_8, c0_.mainEmail AS mainEmail_9, c0_.mainPhone AS mainPhone_10, c0_.mainFax AS mainFax_11, c0_.mainUrl AS mainUrl_12, c0_.id AS id_13, c0_.created AS created_14, c0_.changed AS changed_15, c1_.main AS main_16, c1_.id AS id_17, c2_.lft AS lft_18, c2_.rgt AS rgt_19, c2_.depth AS depth_20, c2_.name AS name_21, c2_.externalId AS externalId_22, c2_.number AS number_23, c2_.corporation AS corporation_24, c2_.note AS note_25, c2_.uid AS uid_26, c2_.registerNumber AS registerNumber_27, c2_.placeOfJurisdiction AS placeOfJurisdiction_28, c2_.mainEmail AS mainEmail_29, c2_.mainPhone AS mainPhone_30, c2_.mainFax AS mainFax_31, c2_.mainUrl AS mainUrl_32, c2_.id AS id_33, c2_.created AS created_34, c2_.changed AS changed_35, c3_.firstName AS firstName_36, c3_.middleName AS middleName_37, c3_.lastName AS lastName_38, c3_.birthday AS birthday_39, c3_.salutation AS salutation_40, c3_.formOfAddress AS formOfAddress_41, c3_.newsletter AS newsletter_42, c3_.gender AS gender_43, c3_.note AS note_44, c3_.mainEmail AS mainEmail_45, c3_.mainPhone AS mainPhone_46, c3_.mainFax AS mainFax_47, c3_.mainUrl AS mainUrl_48, c3_.id AS id_49, c3_.created AS created_50, c3_.changed AS changed_51, c4_.main AS main_52, c4_.id AS id_53, c5_.title AS title_54, c5_.primaryAddress AS primaryAddress_55, c5_.deliveryAddress AS deliveryAddress_56, c5_.billingAddress AS billingAddress_57, c5_.street AS street_58, c5_.number AS number_59, c5_.addition AS addition_60, c5_.zip AS zip_61, c5_.city AS city_62, c5_.state AS state_63, c5_.countryCode AS countryCode_64, c5_.postboxNumber AS postboxNumber_65, c5_.postboxPostcode AS postboxPostcode_66, c5_.postboxCity AS postboxCity_67, c5_.latitude AS latitude_68, c5_.longitude AS longitude_69, c5_.note AS note_70, c5_.id AS id_71, c6_.name AS name_72, c6_.id AS id_73, c7_.locale AS locale_74, c7_.id AS id_75, c8_.email AS email_76, c8_.id AS id_77, c9_.name AS name_78, c9_.id AS id_79, c10_.fax AS fax_80, c10_.id AS id_81, c11_.name AS name_82, c11_.id AS id_83, c12_.value AS value_84, c12_.id AS id_85, c13_.phone AS phone_86, c13_.id AS id_87, c14_.name AS name_88, c14_.id AS id_89, t15_.name AS name_90, t15_.id AS id_91, c16_.url AS url_92, c16_.id AS id_93, c17_.name AS name_94, c17_.id AS id_95, c18_.title AS title_96, c18_.id AS id_97, c19_.position AS position_98, c19_.id AS id_99, m20_.id AS id_100, m20_.created AS created_101, m20_.changed AS changed_102, c21_.category_key AS category_key_103, c21_.default_locale AS default_locale_104, c21_.lft AS lft_105, c21_.rgt AS rgt_106, c21_.depth AS depth_107, c21_.id AS id_108, c21_.created AS created_109, c21_.changed AS changed_110, c22_.translation AS translation_111, c22_.locale AS locale_112, c22_.description AS description_113, c22_.id AS id_114, c22_.created AS created_115, c22_.changed AS changed_116, c23_.bankName AS bankName_117, c23_.bic AS bic_118, c23_.iban AS iban_119, c23_.public AS public_120, c23_.id AS id_121, c0_.idTitles AS idTitles_122, c0_.avatar AS avatar_123, c0_.idUsersCreator AS idUsersCreator_124, c0_.idUsersChanger AS idUsersChanger_125, c1_.idPositions AS idPositions_126, c1_.idContacts AS idContacts_127, c1_.idAccounts AS idAccounts_128, c2_.idContactsMain AS idContactsMain_129, c2_.idAccountsParent AS idAccountsParent_130, c2_.logo AS logo_131, c2_.idUsersCreator AS idUsersCreator_132, c2_.idUsersChanger AS idUsersChanger_133, c3_.idTitles AS idTitles_134, c3_.avatar AS avatar_135, c3_.idUsersCreator AS idUsersCreator_136, c3_.idUsersChanger AS idUsersChanger_137, c4_.idAddresses AS idAddresses_138, c4_.idContacts AS idContacts_139, c5_.idAdressTypes AS idAdressTypes_140, c7_.idContacts AS idContacts_141, c8_.idEmailTypes AS idEmailTypes_142, c10_.idFaxTypes AS idFaxTypes_143, c13_.idPhoneTypes AS idPhoneTypes_144, t15_.idUsersCreator AS idUsersCreator_145, t15_.idUsersChanger AS idUsersChanger_146, c16_.idUrlTypes AS idUrlTypes_147, m20_.idMediaTypes AS idMediaTypes_148, m20_.idPreviewImage AS idPreviewImage_149, m20_.idCollections AS idCollections_150, m20_.idUsersCreator AS idUsersCreator_151, m20_.idUsersChanger AS idUsersChanger_152, c21_.idCategoriesParent AS idCategoriesParent_153, c21_.idUsersCreator AS idUsersCreator_154, c21_.idUsersChanger AS idUsersChanger_155, c22_.idCategories AS idCategories_156, c22_.idUsersCreator AS idUsersCreator_157, c22_.idUsersChanger AS idUsersChanger_158 FROM co_contacts c0_ LEFT JOIN co_account_contacts c1_ ON c0_.id = c1_.idContacts LEFT JOIN co_accounts c2_ ON c1_.idAccounts = c2_.id LEFT JOIN co_contacts c3_ ON c2_.idContactsMain = c3_.id LEFT JOIN co_contact_addresses c4_ ON c0_.id = c4_.idContacts LEFT JOIN co_addresses c5_ ON c4_.idAddresses = c5_.id LEFT JOIN co_address_types c6_ ON c5_.idAdressTypes = c6_.id LEFT JOIN co_contact_locales c7_ ON c0_.id = c7_.idContacts LEFT JOIN co_contact_emails c24_ ON c0_.id = c24_.idContacts LEFT JOIN co_emails c8_ ON c8_.id = c24_.idEmails LEFT JOIN co_email_types c9_ ON c8_.idEmailTypes = c9_.id LEFT JOIN co_contact_faxes c25_ ON c0_.id = c25_.idContacts LEFT JOIN co_faxes c10_ ON c10_.id = c25_.idFaxes LEFT JOIN co_fax_types c11_ ON c10_.idFaxTypes = c11_.id LEFT JOIN co_contact_notes c26_ ON c0_.id = c26_.idContacts LEFT JOIN co_notes c12_ ON c12_.id = c26_.idNotes LEFT JOIN co_contact_phones c27_ ON c0_.id = c27_.idContacts LEFT JOIN co_phones c13_ ON c13_.id = c27_.idPhones LEFT JOIN co_phone_types c14_ ON c13_.idPhoneTypes = c14_.id LEFT JOIN co_contact_tags c28_ ON c0_.id = c28_.idContacts LEFT JOIN ta_tags t15_ ON t15_.id = c28_.idTags LEFT JOIN co_contact_urls c29_ ON c0_.id = c29_.idContacts LEFT JOIN co_urls c16_ ON c16_.id = c29_.idUrls LEFT JOIN co_url_types c17_ ON c16_.idUrlTypes = c17_.id LEFT JOIN co_contact_titles c18_ ON c0_.idTitles = c18_.id LEFT JOIN co_positions c19_ ON c1_.idPositions = c19_.id LEFT JOIN co_contact_medias c30_ ON c0_.id = c30_.idContacts LEFT JOIN me_media m20_ ON m20_.id = c30_.idMedias LEFT JOIN co_contact_categories c31_ ON c0_.id = c31_.idContacts LEFT JOIN ca_categories c21_ ON c21_.id = c31_.idCategories LEFT JOIN ca_category_translations c22_ ON c21_.id = c22_.idCategories LEFT JOIN co_contact_bank_accounts c32_ ON c0_.id = c32_.idContacts LEFT JOIN co_bank_account c23_ ON c23_.id = c32_.idBankAccounts WHERE c0_.id = ? ORDER BY c8_.id ASC, c10_.id ASC, c12_.id ASC, c13_.id ASC, t15_.name ASC, c16_.id ASC, m20_.id ASC, c21_.id ASC, c23_.id ASC Parameters: [`3`] View formatted query View runnable query Explain query SELECT c0_.firstName AS firstName_0, c0_.middleName AS middleName_1, c0_.lastName AS lastName_2, c0_.birthday AS birthday_3, c0_.salutation AS salutation_4, c0_.formOfAddress AS formOfAddress_5, c0_.newsletter AS newsletter_6, c0_.gender AS gender_7, c0_.note AS note_8, c0_.mainEmail AS mainEmail_9, c0_.mainPhone AS mainPhone_10, c0_.mainFax AS mainFax_11, c0_.mainUrl AS mainUrl_12, c0_.id AS id_13, c0_.created AS created_14, c0_.changed AS changed_15, c1_.main AS main_16, c1_.id AS id_17, c2_.lft AS lft_18, c2_.rgt AS rgt_19, c2_.depth AS depth_20, c2_.name AS name_21, c2_.externalId AS externalId_22, c2_.number AS number_23, c2_.corporation AS corporation_24, c2_.note AS note_25, c2_.uid AS uid_26, c2_.registerNumber AS registerNumber_27, c2_.placeOfJurisdiction AS placeOfJurisdiction_28, c2_.mainEmail AS mainEmail_29, c2_.mainPhone AS mainPhone_30, c2_.mainFax AS mainFax_31, c2_.mainUrl AS mainUrl_32, c2_.id AS id_33, c2_.created AS created_34, c2_.changed AS changed_35, c3_.firstName AS firstName_36, c3_.middleName AS middleName_37, c3_.lastName AS lastName_38, c3_.birthday AS birthday_39, c3_.salutation AS salutation_40, c3_.formOfAddress AS formOfAddress_41, c3_.newsletter AS newsletter_42, c3_.gender AS gender_43, c3_.note AS note_44, c3_.mainEmail AS mainEmail_45, c3_.mainPhone AS mainPhone_46, c3_.mainFax AS mainFax_47, c3_.mainUrl AS mainUrl_48, c3_.id AS id_49, c3_.created AS created_50, c3_.changed AS changed_51, c4_.main AS main_52, c4_.id AS id_53, c5_.title AS title_54, c5_.primaryAddress AS primaryAddress_55, c5_.deliveryAddress AS deliveryAddress_56, c5_.billingAddress AS billingAddress_57, c5_.street AS street_58, c5_.number AS number_59, c5_.addition AS addition_60, c5_.zip AS zip_61, c5_.city AS city_62, c5_.state AS state_63, c5_.countryCode AS countryCode_64, c5_.postboxNumber AS postboxNumber_65, c5_.postboxPostcode AS postboxPostcode_66, c5_.postboxCity AS postboxCity_67, c5_.latitude AS latitude_68, c5_.longitude AS longitude_69, c5_.note AS note_70, c5_.id AS id_71, c6_.name AS name_72, c6_.id AS id_73, c7_.locale AS locale_74, c7_.id AS id_75, c8_.email AS email_76, c8_.id AS id_77, c9_.name AS name_78, c9_.id AS id_79, c10_.fax AS fax_80, c10_.id AS id_81, c11_.name AS name_82, c11_.id AS id_83, c12_.value AS value_84, c12_.id AS id_85, c13_.phone AS phone_86, c13_.id AS id_87, c14_.name AS name_88, c14_.id AS id_89, t15_.name AS name_90, t15_.id AS id_91, c16_.url AS url_92, c16_.id AS id_93, c17_.name AS name_94, c17_.id AS id_95, c18_.title AS title_96, c18_.id AS id_97, c19_.position AS position_98, c19_.id AS id_99, m20_.id AS id_100, m20_.created AS created_101, m20_.changed AS changed_102, c21_.category_key AS category_key_103, c21_.default_locale AS default_locale_104, c21_.lft AS lft_105, c21_.rgt AS rgt_106, c21_.depth AS depth_107, c21_.id AS id_108, c21_.created AS created_109, c21_.changed AS changed_110, c22_.translation AS translation_111, c22_.locale AS locale_112, c22_.description AS description_113, c22_.id AS id_114, c22_.created AS created_115, c22_.changed AS changed_116, c23_.bankName AS bankName_117, c23_.bic AS bic_118, c23_.iban AS iban_119, c23_.public AS public_120, c23_.id AS id_121, c0_.idTitles AS idTitles_122, c0_.avatar AS avatar_123, c0_.idUsersCreator AS idUsersCreator_124, c0_.idUsersChanger AS idUsersChanger_125, c1_.idPositions AS idPositions_126, c1_.idContacts AS idContacts_127, c1_.idAccounts AS idAccounts_128, c2_.idContactsMain AS idContactsMain_129, c2_.idAccountsParent AS idAccountsParent_130, c2_.logo AS logo_131, c2_.idUsersCreator AS idUsersCreator_132, c2_.idUsersChanger AS idUsersChanger_133, c3_.idTitles AS idTitles_134, c3_.avatar AS avatar_135, c3_.idUsersCreator AS idUsersCreator_136, c3_.idUsersChanger AS idUsersChanger_137, c4_.idAddresses AS idAddresses_138, c4_.idContacts AS idContacts_139, c5_.idAdressTypes AS idAdressTypes_140, c7_.idContacts AS idContacts_141, c8_.idEmailTypes AS idEmailTypes_142, c10_.idFaxTypes AS idFaxTypes_143, c13_.idPhoneTypes AS idPhoneTypes_144, t15_.idUsersCreator AS idUsersCreator_145, t15_.idUsersChanger AS idUsersChanger_146, c16_.idUrlTypes AS idUrlTypes_147, m20_.idMediaTypes AS idMediaTypes_148, m20_.idPreviewImage AS idPreviewImage_149, m20_.idCollections AS idCollections_150, m20_.idUsersCreator AS idUsersCreator_151, m20_.idUsersChanger AS idUsersChanger_152, c21_.idCategoriesParent AS idCategoriesParent_153, c21_.idUsersCreator AS idUsersCreator_154, c21_.idUsersChanger AS idUsersChanger_155, c22_.idCategories AS idCategories_156, c22_.idUsersCreator AS idUsersCreator_157, c22_.idUsersChanger AS idUsersChanger_158 FROM co_contacts c0_ LEFT JOIN co_account_contacts c1_ ON c0_.id = c1_.idContacts LEFT JOIN co_accounts c2_ ON c1_.idAccounts = c2_.id LEFT JOIN co_contacts c3_ ON c2_.idContactsMain = c3_.id LEFT JOIN co_contact_addresses c4_ ON c0_.id = c4_.idContacts LEFT JOIN co_addresses c5_ ON c4_.idAddresses = c5_.id LEFT JOIN co_address_types c6_ ON c5_.idAdressTypes = c6_.id LEFT JOIN co_contact_locales c7_ ON c0_.id = c7_.idContacts LEFT JOIN co_contact_emails c24_ ON c0_.id = c24_.idContacts LEFT JOIN co_emails c8_ ON c8_.id = c24_.idEmails LEFT JOIN co_email_types c9_ ON c8_.idEmailTypes = c9_.id LEFT JOIN co_contact_faxes c25_ ON c0_.id = c25_.idContacts LEFT JOIN co_faxes c10_ ON c10_.id = c25_.idFaxes LEFT JOIN co_fax_types c11_ ON c10_.idFaxTypes = c11_.id LEFT JOIN co_contact_notes c26_ ON c0_.id = c26_.idContacts LEFT JOIN co_notes c12_ ON c12_.id = c26_.idNotes LEFT JOIN co_contact_phones c27_ ON c0_.id = c27_.idContacts LEFT JOIN co_phones c13_ ON c13_.id = c27_.idPhones LEFT JOIN co_phone_types c14_ ON c13_.idPhoneTypes = c14_.id LEFT JOIN co_contact_tags c28_ ON c0_.id = c28_.idContacts LEFT JOIN ta_tags t15_ ON t15_.id = c28_.idTags LEFT JOIN co_contact_urls c29_ ON c0_.id = c29_.idContacts LEFT JOIN co_urls c16_ ON c16_.id = c29_.idUrls LEFT JOIN co_url_types c17_ ON c16_.idUrlTypes = c17_.id LEFT JOIN co_contact_titles c18_ ON c0_.idTitles = c18_.id LEFT JOIN co_positions c19_ ON c1_.idPositions = c19_.id LEFT JOIN co_contact_medias c30_ ON c0_.id = c30_.idContacts LEFT JOIN me_media m20_ ON m20_.id = c30_.idMedias LEFT JOIN co_contact_categories c31_ ON c0_.id = c31_.idContacts LEFT JOIN ca_categories c21_ ON c21_.id = c31_.idCategories LEFT JOIN ca_category_translations c22_ ON c21_.id = c22_.idCategories LEFT JOIN co_contact_bank_accounts c32_ ON c0_.id = c32_.idContacts LEFT JOIN co_bank_account c23_ ON c23_.id = c32_.idBankAccounts WHERE c0_.id = ? ORDER BY c8_.id ASC, c10_.id ASC, c12_.id ASC, c13_.id ASC, t15_.name ASC, c16_.id ASC, m20_.id ASC, c21_.id ASC, c23_.id ASC SELECT c0_.firstName AS firstName_0, c0_.middleName AS middleName_1, c0_.lastName AS lastName_2, c0_.birthday AS birthday_3, c0_.salutation AS salutation_4, c0_.formOfAddress AS formOfAddress_5, c0_.newsletter AS newsletter_6, c0_.gender AS gender_7, c0_.note AS note_8, c0_.mainEmail AS mainEmail_9, c0_.mainPhone AS mainPhone_10, c0_.mainFax AS mainFax_11, c0_.mainUrl AS mainUrl_12, c0_.id AS id_13, c0_.created AS created_14, c0_.changed AS changed_15, c1_.main AS main_16, c1_.id AS id_17, c2_.lft AS lft_18, c2_.rgt AS rgt_19, c2_.depth AS depth_20, c2_.name AS name_21, c2_.externalId AS externalId_22, c2_.number AS number_23, c2_.corporation AS corporation_24, c2_.note AS note_25, c2_.uid AS uid_26, c2_.registerNumber AS registerNumber_27, c2_.placeOfJurisdiction AS placeOfJurisdiction_28, c2_.mainEmail AS mainEmail_29, c2_.mainPhone AS mainPhone_30, c2_.mainFax AS mainFax_31, c2_.mainUrl AS mainUrl_32, c2_.id AS id_33, c2_.created AS created_34, c2_.changed AS changed_35, c3_.firstName AS firstName_36, c3_.middleName AS middleName_37, c3_.lastName AS lastName_38, c3_.birthday AS birthday_39, c3_.salutation AS salutation_40, c3_.formOfAddress AS formOfAddress_41, c3_.newsletter AS newsletter_42, c3_.gender AS gender_43, c3_.note AS note_44, c3_.mainEmail AS mainEmail_45, c3_.mainPhone AS mainPhone_46, c3_.mainFax AS mainFax_47, c3_.mainUrl AS mainUrl_48, c3_.id AS id_49, c3_.created AS created_50, c3_.changed AS changed_51, c4_.main AS main_52, c4_.id AS id_53, c5_.title AS title_54, c5_.primaryAddress AS primaryAddress_55, c5_.deliveryAddress AS deliveryAddress_56, c5_.billingAddress AS billingAddress_57, c5_.street AS street_58, c5_.number AS number_59, c5_.addition AS addition_60, c5_.zip AS zip_61, c5_.city AS city_62, c5_.state AS state_63, c5_.countryCode AS countryCode_64, c5_.postboxNumber AS postboxNumber_65, c5_.postboxPostcode AS postboxPostcode_66, c5_.postboxCity AS postboxCity_67, c5_.latitude AS latitude_68, c5_.longitude AS longitude_69, c5_.note AS note_70, c5_.id AS id_71, c6_.name AS name_72, c6_.id AS id_73, c7_.locale AS locale_74, c7_.id AS id_75, c8_.email AS email_76, c8_.id AS id_77, c9_.name AS name_78, c9_.id AS id_79, c10_.fax AS fax_80, c10_.id AS id_81, c11_.name AS name_82, c11_.id AS id_83, c12_.value AS value_84, c12_.id AS id_85, c13_.phone AS phone_86, c13_.id AS id_87, c14_.name AS name_88, c14_.id AS id_89, t15_.name AS name_90, t15_.id AS id_91, c16_.url AS url_92, c16_.id AS id_93, c17_.name AS name_94, c17_.id AS id_95, c18_.title AS title_96, c18_.id AS id_97, c19_.position AS position_98, c19_.id AS id_99, m20_.id AS id_100, m20_.created AS created_101, m20_.changed AS changed_102, c21_.category_key AS category_key_103, c21_.default_locale AS default_locale_104, c21_.lft AS lft_105, c21_.rgt AS rgt_106, c21_.depth AS depth_107, c21_.id AS id_108, c21_.created AS created_109, c21_.changed AS changed_110, c22_.translation AS translation_111, c22_.locale AS locale_112, c22_.description AS description_113, c22_.id AS id_114, c22_.created AS created_115, c22_.changed AS changed_116, c23_.bankName AS bankName_117, c23_.bic AS bic_118, c23_.iban AS iban_119, c23_.public AS public_120, c23_.id AS id_121, c0_.idTitles AS idTitles_122, c0_.avatar AS avatar_123, c0_.idUsersCreator AS idUsersCreator_124, c0_.idUsersChanger AS idUsersChanger_125, c1_.idPositions AS idPositions_126, c1_.idContacts AS idContacts_127, c1_.idAccounts AS idAccounts_128, c2_.idContactsMain AS idContactsMain_129, c2_.idAccountsParent AS idAccountsParent_130, c2_.logo AS logo_131, c2_.idUsersCreator AS idUsersCreator_132, c2_.idUsersChanger AS idUsersChanger_133, c3_.idTitles AS idTitles_134, c3_.avatar AS avatar_135, c3_.idUsersCreator AS idUsersCreator_136, c3_.idUsersChanger AS idUsersChanger_137, c4_.idAddresses AS idAddresses_138, c4_.idContacts AS idContacts_139, c5_.idAdressTypes AS idAdressTypes_140, c7_.idContacts AS idContacts_141, c8_.idEmailTypes AS idEmailTypes_142, c10_.idFaxTypes AS idFaxTypes_143, c13_.idPhoneTypes AS idPhoneTypes_144, t15_.idUsersCreator AS idUsersCreator_145, t15_.idUsersChanger AS idUsersChanger_146, c16_.idUrlTypes AS idUrlTypes_147, m20_.idMediaTypes AS idMediaTypes_148, m20_.idPreviewImage AS idPreviewImage_149, m20_.idCollections AS idCollections_150, m20_.idUsersCreator AS idUsersCreator_151, m20_.idUsersChanger AS idUsersChanger_152, c21_.idCategoriesParent AS idCategoriesParent_153, c21_.idUsersCreator AS idUsersCreator_154, c21_.idUsersChanger AS idUsersChanger_155, c22_.idCategories AS idCategories_156, c22_.idUsersCreator AS idUsersCreator_157, c22_.idUsersChanger AS idUsersChanger_158 FROM co_contacts c0_ LEFT JOIN co_account_contacts c1_ ON c0_.id = c1_.idContacts LEFT JOIN co_accounts c2_ ON c1_.idAccounts = c2_.id LEFT JOIN co_contacts c3_ ON c2_.idContactsMain = c3_.id LEFT JOIN co_contact_addresses c4_ ON c0_.id = c4_.idContacts LEFT JOIN co_addresses c5_ ON c4_.idAddresses = c5_.id LEFT JOIN co_address_types c6_ ON c5_.idAdressTypes = c6_.id LEFT JOIN co_contact_locales c7_ ON c0_.id = c7_.idContacts LEFT JOIN co_contact_emails c24_ ON c0_.id = c24_.idContacts LEFT JOIN co_emails c8_ ON c8_.id = c24_.idEmails LEFT JOIN co_email_types c9_ ON c8_.idEmailTypes = c9_.id LEFT JOIN co_contact_faxes c25_ ON c0_.id = c25_.idContacts LEFT JOIN co_faxes c10_ ON c10_.id = c25_.idFaxes LEFT JOIN co_fax_types c11_ ON c10_.idFaxTypes = c11_.id LEFT JOIN co_contact_notes c26_ ON c0_.id = c26_.idContacts LEFT JOIN co_notes c12_ ON c12_.id = c26_.idNotes LEFT JOIN co_contact_phones c27_ ON c0_.id = c27_.idContacts LEFT JOIN co_phones c13_ ON c13_.id = c27_.idPhones LEFT JOIN co_phone_types c14_ ON c13_.idPhoneTypes = c14_.id LEFT JOIN co_contact_tags c28_ ON c0_.id = c28_.idContacts LEFT JOIN ta_tags t15_ ON t15_.id = c28_.idTags LEFT JOIN co_contact_urls c29_ ON c0_.id = c29_.idContacts LEFT JOIN co_urls c16_ ON c16_.id = c29_.idUrls LEFT JOIN co_url_types c17_ ON c16_.idUrlTypes = c17_.id LEFT JOIN co_contact_titles c18_ ON c0_.idTitles = c18_.id LEFT JOIN co_positions c19_ ON c1_.idPositions = c19_.id LEFT JOIN co_contact_medias c30_ ON c0_.id = c30_.idContacts LEFT JOIN me_media m20_ ON m20_.id = c30_.idMedias LEFT JOIN co_contact_categories c31_ ON c0_.id = c31_.idContacts LEFT JOIN ca_categories c21_ ON c21_.id = c31_.idCategories LEFT JOIN ca_category_translations c22_ ON c21_.id = c22_.idCategories LEFT JOIN co_contact_bank_accounts c32_ ON c0_.id = c32_.idContacts LEFT JOIN co_bank_account c23_ ON c23_.id = c32_.idBankAccounts WHERE c0_.id = 3 ORDER BY c8_.id ASC, c10_.id ASC, c12_.id ASC, c13_.id ASC, t15_.name ASC, c16_.id ASC, m20_.id ASC, c21_.id ASC, c23_.id ASC;
1.53 ms (3.96%)	5	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
1.26 ms (3.26%)	1	SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_middle"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_middle"]) > 0' ) ) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%' ) ) ORDER BY CAST( EXTRACTVALUE( n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC, EXTRACTVALUE( n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_middle"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;
1.06 ms (2.75%)	2	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 = ? Parameters: [`7`] View formatted query View runnable query Explain query 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 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 = 7;
0.80 ms (2.08%)	3	SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?) Parameters: [`"default_live" "8a7272c5-fc59-426a-ae56-e84ff3164fb6"`] View formatted query View runnable query Explain query SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND identifier IN (?) SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('8a7272c5-fc59-426a-ae56-e84ff3164fb6');
0.80 ms (2.07%)	1	SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="main"]) > 0' ) ) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%' ) ) ORDER BY CAST( EXTRACTVALUE( n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC, EXTRACTVALUE( n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;
0.77 ms (2.00%)	1	SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_left"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_left"]) > 0' ) ) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%' ) ) ORDER BY CAST( EXTRACTVALUE( n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC, EXTRACTVALUE( n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_left"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;
0.58 ms (1.52%)	1	SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_right"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_right"]) > 0' ) ) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%' ) ) ORDER BY CAST( EXTRACTVALUE( n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC, EXTRACTVALUE( n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_right"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;
0.53 ms (1.37%)	2	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/plan-d-berechtigungen/contents/ueber-uns" "/cmf/plan-d-berechtigungen/contents/leistungen" "/cmf/plan-d-berechtigungen/contents/cases" "/cmf/plan-d-berechtigungen/contents/career" "/cmf/plan-d-berechtigungen/contents/contact" "default_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/plan-d-berechtigungen/contents/ueber-uns', '/cmf/plan-d-berechtigungen/contents/leistungen', '/cmf/plan-d-berechtigungen/contents/cases', '/cmf/plan-d-berechtigungen/contents/career', '/cmf/plan-d-berechtigungen/contents/contact') AND workspace_name = 'default_live' ORDER BY sort_order ASC;
0.49 ms (1.27%)	3	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 Parameters: [] View formatted query View runnable query Explain query 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 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 ;
0.40 ms (1.05%)	1	SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.id AS id_113, m19_.created AS created_114, m19_.changed AS changed_115, c0_.idContactsMain AS idContactsMain_116, c0_.idAccountsParent AS idAccountsParent_117, c0_.logo AS logo_118, c0_.idUsersCreator AS idUsersCreator_119, c0_.idUsersChanger AS idUsersChanger_120, c1_.idCategoriesParent AS idCategoriesParent_121, c1_.idUsersCreator AS idUsersCreator_122, c1_.idUsersChanger AS idUsersChanger_123, c2_.idCategories AS idCategories_124, c2_.idUsersCreator AS idUsersCreator_125, c2_.idUsersChanger AS idUsersChanger_126, c3_.idAddresses AS idAddresses_127, c3_.idAccounts AS idAccounts_128, c4_.idAdressTypes AS idAdressTypes_129, c6_.idContactsMain AS idContactsMain_130, c6_.idAccountsParent AS idAccountsParent_131, c6_.logo AS logo_132, c6_.idUsersCreator AS idUsersCreator_133, c6_.idUsersChanger AS idUsersChanger_134, c7_.idUrlTypes AS idUrlTypes_135, c9_.idPhoneTypes AS idPhoneTypes_136, c11_.idEmailTypes AS idEmailTypes_137, c14_.idFaxTypes AS idFaxTypes_138, t17_.idUsersCreator AS idUsersCreator_139, t17_.idUsersChanger AS idUsersChanger_140, c18_.idTitles AS idTitles_141, c18_.avatar AS avatar_142, c18_.idUsersCreator AS idUsersCreator_143, c18_.idUsersChanger AS idUsersChanger_144, m19_.idMediaTypes AS idMediaTypes_145, m19_.idPreviewImage AS idPreviewImage_146, m19_.idCollections AS idCollections_147, m19_.idUsersCreator AS idUsersCreator_148, m19_.idUsersChanger AS idUsersChanger_149 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN (?) ORDER BY c0_.id ASC, c1_.id ASC, c7_.id ASC, c9_.id ASC, c11_.id ASC, c13_.id ASC, c14_.id ASC, c16_.id ASC, t17_.name ASC, m19_.id ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.id AS id_113, m19_.created AS created_114, m19_.changed AS changed_115, c0_.idContactsMain AS idContactsMain_116, c0_.idAccountsParent AS idAccountsParent_117, c0_.logo AS logo_118, c0_.idUsersCreator AS idUsersCreator_119, c0_.idUsersChanger AS idUsersChanger_120, c1_.idCategoriesParent AS idCategoriesParent_121, c1_.idUsersCreator AS idUsersCreator_122, c1_.idUsersChanger AS idUsersChanger_123, c2_.idCategories AS idCategories_124, c2_.idUsersCreator AS idUsersCreator_125, c2_.idUsersChanger AS idUsersChanger_126, c3_.idAddresses AS idAddresses_127, c3_.idAccounts AS idAccounts_128, c4_.idAdressTypes AS idAdressTypes_129, c6_.idContactsMain AS idContactsMain_130, c6_.idAccountsParent AS idAccountsParent_131, c6_.logo AS logo_132, c6_.idUsersCreator AS idUsersCreator_133, c6_.idUsersChanger AS idUsersChanger_134, c7_.idUrlTypes AS idUrlTypes_135, c9_.idPhoneTypes AS idPhoneTypes_136, c11_.idEmailTypes AS idEmailTypes_137, c14_.idFaxTypes AS idFaxTypes_138, t17_.idUsersCreator AS idUsersCreator_139, t17_.idUsersChanger AS idUsersChanger_140, c18_.idTitles AS idTitles_141, c18_.avatar AS avatar_142, c18_.idUsersCreator AS idUsersCreator_143, c18_.idUsersChanger AS idUsersChanger_144, m19_.idMediaTypes AS idMediaTypes_145, m19_.idPreviewImage AS idPreviewImage_146, m19_.idCollections AS idCollections_147, m19_.idUsersCreator AS idUsersCreator_148, m19_.idUsersChanger AS idUsersChanger_149 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN (?) ORDER BY c0_.id ASC, c1_.id ASC, c7_.id ASC, c9_.id ASC, c11_.id ASC, c13_.id ASC, c14_.id ASC, c16_.id ASC, t17_.name ASC, m19_.id ASC SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.id AS id_113, m19_.created AS created_114, m19_.changed AS changed_115, c0_.idContactsMain AS idContactsMain_116, c0_.idAccountsParent AS idAccountsParent_117, c0_.logo AS logo_118, c0_.idUsersCreator AS idUsersCreator_119, c0_.idUsersChanger AS idUsersChanger_120, c1_.idCategoriesParent AS idCategoriesParent_121, c1_.idUsersCreator AS idUsersCreator_122, c1_.idUsersChanger AS idUsersChanger_123, c2_.idCategories AS idCategories_124, c2_.idUsersCreator AS idUsersCreator_125, c2_.idUsersChanger AS idUsersChanger_126, c3_.idAddresses AS idAddresses_127, c3_.idAccounts AS idAccounts_128, c4_.idAdressTypes AS idAdressTypes_129, c6_.idContactsMain AS idContactsMain_130, c6_.idAccountsParent AS idAccountsParent_131, c6_.logo AS logo_132, c6_.idUsersCreator AS idUsersCreator_133, c6_.idUsersChanger AS idUsersChanger_134, c7_.idUrlTypes AS idUrlTypes_135, c9_.idPhoneTypes AS idPhoneTypes_136, c11_.idEmailTypes AS idEmailTypes_137, c14_.idFaxTypes AS idFaxTypes_138, t17_.idUsersCreator AS idUsersCreator_139, t17_.idUsersChanger AS idUsersChanger_140, c18_.idTitles AS idTitles_141, c18_.avatar AS avatar_142, c18_.idUsersCreator AS idUsersCreator_143, c18_.idUsersChanger AS idUsersChanger_144, m19_.idMediaTypes AS idMediaTypes_145, m19_.idPreviewImage AS idPreviewImage_146, m19_.idCollections AS idCollections_147, m19_.idUsersCreator AS idUsersCreator_148, m19_.idUsersChanger AS idUsersChanger_149 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN (1) ORDER BY c0_.id ASC, c1_.id ASC, c7_.id ASC, c9_.id ASC, c11_.id ASC, c13_.id ASC, c14_.id ASC, c16_.id ASC, t17_.name ASC, m19_.id ASC;
0.35 ms (0.90%)	1	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ?) ORDER BY sort_order ASC Parameters: [`"default_live" "/cmf/plan-d-berechtigungen/contents/privacy-policy" "/cmf/plan-d-berechtigungen/contents/imprint"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND ( path = ? OR path = ? ) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/plan-d-berechtigungen/contents/privacy-policy' OR path = '/cmf/plan-d-berechtigungen/contents/imprint') ORDER BY sort_order ASC;
0.31 ms (0.81%)	1	SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ?) ORDER BY sort_order ASC Parameters: [`"default_live" "/cmf/plan-d-berechtigungen/contents/presse"`] View formatted query View runnable query Explain query SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = ? AND (path = ?) ORDER BY sort_order ASC SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/plan-d-berechtigungen/contents/presse') ORDER BY sort_order ASC;
0.29 ms (0.74%)	1	SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ? Parameters: [`307`] View formatted query View runnable query Explain query SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ? SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = 307;
0.27 ms (0.71%)	1	SELECT 1 FROM phpcr_workspaces WHERE name = ? Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT 1 FROM phpcr_workspaces WHERE name = ? SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';
0.27 ms (0.70%)	1	SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?) AND workspace_name = ? ORDER BY sort_order ASC Parameters: [`"/cmf/plan-d-berechtigungen/contents/privacy-policy" "/cmf/plan-d-berechtigungen/contents/imprint" "default_live"`] View formatted query View runnable query Explain query SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?) AND workspace_name = ? ORDER BY sort_order ASC SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/plan-d-berechtigungen/contents/privacy-policy', '/cmf/plan-d-berechtigungen/contents/imprint') AND workspace_name = 'default_live' ORDER BY sort_order ASC;
0.25 ms (0.66%)	1	SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ? Parameters: [`307`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = 307;
0.25 ms (0.66%)	1	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, w1_.id ASC Parameters: [`"dmz-test-pdwebsite.plan-d.cloud/{localization}" "dev" "plan-d-berechtigungen"`] View formatted query View runnable query Explain query 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, w1_.id ASC 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 = 'dmz-test-pdwebsite.plan-d.cloud/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'plan-d-berechtigungen' ORDER BY w0_.id ASC, w1_.id ASC;
0.24 ms (0.63%)	1	SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles WHERE co_account_social_media_profiles.idAccounts = ? ORDER BY t0.id ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles WHERE co_account_social_media_profiles.idAccounts = ? ORDER BY t0.id ASC SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles WHERE co_account_social_media_profiles.idAccounts = 1 ORDER BY t0.id ASC;
0.22 ms (0.58%)	1	SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = ? Parameters: [`332`] View formatted query View runnable query Explain query SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = ? SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = 332;
0.18 ms (0.47%)	1	SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_bottom"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC Parameters: [`"default_live"`] View formatted query View runnable query Explain query SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = ? AND n0.type IN ('nt:unstructured', 'rep:root') AND ( ( EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0' ) OR EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0' ) ) AND ( ( ( 0 != FIND_IN_SET( '2', REPLACE( EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value' ), ' ', ',' ) ) OR EXTRACTVALUE( n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]' ) = '1' ) AND EXTRACTVALUE( n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_bottom"]) > 0' ) ) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%' ) ) ORDER BY CAST( EXTRACTVALUE( n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) AS DECIMAL ) ASC, EXTRACTVALUE( n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]' ) ASC SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND ((EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')) AND (((0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:de-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:de-navContexts"]/sv:value[text()="footer_bottom"]) > 0')) AND n0.path LIKE '/cmf/plan-d-berechtigungen/contents/%')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="sulu:order"]/sv:value[1]') ASC;
0.15 ms (0.40%)	1	SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ? Parameters: [`307`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ? SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = 307;
0.12 ms (0.32%)	1	SELECT prefix, uri FROM phpcr_namespaces Parameters: [] View formatted query View runnable query Explain query SELECT prefix, uri FROM phpcr_namespaces SELECT prefix, uri FROM phpcr_namespaces;

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
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType	No errors.
Sulu\Bundle\MediaBundle\Entity\File	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersion	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\MediaBundle\Entity\FormatOptions	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage	No errors.
Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact	No errors.
Sulu\Bundle\ContactBundle\Entity\Url	No errors.
Sulu\Bundle\ContactBundle\Entity\Note	No errors.
Sulu\Bundle\ContactBundle\Entity\Email	No errors.
Sulu\Bundle\ContactBundle\Entity\Phone	No errors.
Sulu\Bundle\ContactBundle\Entity\Fax	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile	No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount	No errors.
Sulu\Bundle\ContactBundle\Entity\Account	No errors.
Sulu\Bundle\ContactBundle\Entity\Address	No errors.
Sulu\Bundle\ContactBundle\Entity\AddressType	No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType	No errors.
Sulu\Bundle\ContactBundle\Entity\FaxType	No errors.
Sulu\Bundle\ContactBundle\Entity\PhoneType	No errors.
Sulu\Bundle\ContactBundle\Entity\UrlType	No errors.
Sulu\Bundle\ContactBundle\Entity\Position	No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfileType	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://dmz-test-pdwebsite.plan-d.cloud/de/stories/2023-06-27-jetzt-oder-ki-digitale-loesungen-fuer-echte-probleme

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping