GET https://mail.vina-jagunic.com/_fragment?_path=_format%3Dhtml%26_locale%3Dhr%26_controller%3DApp%255CController%255CWebsite%255CCookies%255CCookiesController%253…

Response
200 OK
IP
216.73.217.33
Profiled on
Token
4b0bc1

Query Metrics

47 Database Queries
15 Different statements
61.15 ms Query time
0 Invalid entities
59 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
37.45 ms
(61.25%) 		18 
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_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, s10_.tracking AS tracking_68, s10_.buying_and_selling AS buying_and_selling_69, s10_.delivery AS delivery_70, s10_.marketing AS marketing_71, c11_.firstName AS firstName_72, c11_.middleName AS middleName_73, c11_.lastName AS lastName_74, c11_.birthday AS birthday_75, c11_.salutation AS salutation_76, c11_.formOfAddress AS formOfAddress_77, c11_.newsletter AS newsletter_78, c11_.gender AS gender_79, c11_.note AS note_80, c11_.mainEmail AS mainEmail_81, c11_.mainPhone AS mainPhone_82, c11_.mainFax AS mainFax_83, c11_.mainUrl AS mainUrl_84, c11_.id AS id_85, c11_.created AS created_86, c11_.changed AS changed_87, s12_.username AS username_88, s12_.password AS password_89, s12_.locale AS locale_90, s12_.salt AS salt_91, s12_.locked AS locked_92, s12_.enabled AS enabled_93, s12_.lastLogin AS lastLogin_94, s12_.confirmationKey AS confirmationKey_95, s12_.passwordResetToken AS passwordResetToken_96, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_97, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_98, s12_.privateKey AS privateKey_99, s12_.apiKey AS apiKey_100, s12_.email AS email_101, s12_.id AS id_102, s12_.created AS created_103, s12_.changed AS changed_104, s12_.tracking AS tracking_105, s12_.buying_and_selling AS buying_and_selling_106, s12_.delivery AS delivery_107, s12_.marketing AS marketing_108, c13_.firstName AS firstName_109, c13_.middleName AS middleName_110, c13_.lastName AS lastName_111, c13_.birthday AS birthday_112, c13_.salutation AS salutation_113, c13_.formOfAddress AS formOfAddress_114, c13_.newsletter AS newsletter_115, c13_.gender AS gender_116, c13_.note AS note_117, c13_.mainEmail AS mainEmail_118, c13_.mainPhone AS mainPhone_119, c13_.mainFax AS mainFax_120, c13_.mainUrl AS mainUrl_121, c13_.id AS id_122, c13_.created AS created_123, c13_.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_.idFileVersions AS idFileVersions_144, m7_.idFileVersions AS idFileVersions_145, m8_.idFileVersions AS idFileVersions_146, m9_.idFileVersions AS idFileVersions_147, s10_.idUsersCreator AS idUsersCreator_148, s10_.idUsersChanger AS idUsersChanger_149, s10_.cart_id AS cart_id_150, s10_.idContacts AS idContacts_151, c11_.idTitles AS idTitles_152, c11_.avatar AS avatar_153, c11_.idUsersCreator AS idUsersCreator_154, c11_.idUsersChanger AS idUsersChanger_155, s12_.idUsersCreator AS idUsersCreator_156, s12_.idUsersChanger AS idUsersChanger_157, s12_.cart_id AS cart_id_158, s12_.idContacts AS idContacts_159, c13_.idTitles AS idTitles_160, c13_.avatar AS avatar_161, c13_.idUsersCreator AS idUsersCreator_162, c13_.idUsersChanger AS idUsersChanger_163 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 INNER JOIN me_files m3_ ON m0_.id = m3_.idMedia INNER JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles AND (m4_.version = m3_.version) LEFT JOIN me_file_version_tags m14_ ON m4_.id = m14_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m14_.idTags LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query
5.98 ms
(9.78%) 		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:hr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:hr-shadow-on"]/sv:value[1]') = '1') AND n0.parent = '/cmf/jagunic/contents/vina') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:hr-template"]/sv:value[text()="productDisplayPage"]) > 0')) AND NOT (n0.identifier = '92128f14-7893-432b-9a41-2917f00a1066'))) 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
4.40 ms
(7.19%) 		2 
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, m5_.crop_x AS crop_x_31, m5_.crop_y AS crop_y_32, m5_.crop_width AS crop_width_33, m5_.crop_height AS crop_height_34, m5_.format_key AS format_key_35, m6_.title AS title_36, m6_.description AS description_37, m6_.copyright AS copyright_38, m6_.credits AS credits_39, m6_.locale AS locale_40, m6_.id AS id_41, m7_.title AS title_42, m7_.description AS description_43, m7_.copyright AS copyright_44, m7_.credits AS credits_45, m7_.locale AS locale_46, m7_.id AS id_47, m8_.locale AS locale_48, m8_.id AS id_49, m9_.locale AS locale_50, m9_.id AS id_51, s10_.username AS username_52, s10_.password AS password_53, s10_.locale AS locale_54, s10_.salt AS salt_55, s10_.locked AS locked_56, s10_.enabled AS enabled_57, s10_.lastLogin AS lastLogin_58, s10_.confirmationKey AS confirmationKey_59, s10_.passwordResetToken AS passwordResetToken_60, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_61, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_62, s10_.privateKey AS privateKey_63, s10_.apiKey AS apiKey_64, s10_.email AS email_65, s10_.id AS id_66, s10_.created AS created_67, s10_.changed AS changed_68, s10_.tracking AS tracking_69, s10_.buying_and_selling AS buying_and_selling_70, s10_.delivery AS delivery_71, s10_.marketing AS marketing_72, c11_.firstName AS firstName_73, c11_.middleName AS middleName_74, c11_.lastName AS lastName_75, c11_.birthday AS birthday_76, c11_.salutation AS salutation_77, c11_.formOfAddress AS formOfAddress_78, c11_.newsletter AS newsletter_79, c11_.gender AS gender_80, c11_.note AS note_81, c11_.mainEmail AS mainEmail_82, c11_.mainPhone AS mainPhone_83, c11_.mainFax AS mainFax_84, c11_.mainUrl AS mainUrl_85, c11_.id AS id_86, c11_.created AS created_87, c11_.changed AS changed_88, s12_.username AS username_89, s12_.password AS password_90, s12_.locale AS locale_91, s12_.salt AS salt_92, s12_.locked AS locked_93, s12_.enabled AS enabled_94, s12_.lastLogin AS lastLogin_95, s12_.confirmationKey AS confirmationKey_96, s12_.passwordResetToken AS passwordResetToken_97, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_98, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_99, s12_.privateKey AS privateKey_100, s12_.apiKey AS apiKey_101, s12_.email AS email_102, s12_.id AS id_103, s12_.created AS created_104, s12_.changed AS changed_105, s12_.tracking AS tracking_106, s12_.buying_and_selling AS buying_and_selling_107, s12_.delivery AS delivery_108, s12_.marketing AS marketing_109, c13_.firstName AS firstName_110, c13_.middleName AS middleName_111, c13_.lastName AS lastName_112, c13_.birthday AS birthday_113, c13_.salutation AS salutation_114, c13_.formOfAddress AS formOfAddress_115, c13_.newsletter AS newsletter_116, c13_.gender AS gender_117, c13_.note AS note_118, c13_.mainEmail AS mainEmail_119, c13_.mainPhone AS mainPhone_120, c13_.mainFax AS mainFax_121, c13_.mainUrl AS mainUrl_122, c13_.id AS id_123, c13_.created AS created_124, c13_.changed AS changed_125, m14_.id AS id_126, m14_.created AS created_127, m14_.changed AS changed_128, m0_.idMediaTypes AS idMediaTypes_129, m0_.idPreviewImage AS idPreviewImage_130, m0_.idCollections AS idCollections_131, m0_.idUsersCreator AS idUsersCreator_132, m0_.idUsersChanger AS idUsersChanger_133, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_134, m2_.idCollectionTypes AS idCollectionTypes_135, m2_.idCollectionsParent AS idCollectionsParent_136, m2_.idUsersCreator AS idUsersCreator_137, m2_.idUsersChanger AS idUsersChanger_138, m3_.idMedia AS idMedia_139, m3_.idUsersCreator AS idUsersCreator_140, m3_.idUsersChanger AS idUsersChanger_141, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_142, m4_.idFiles AS idFiles_143, m4_.idUsersCreator AS idUsersCreator_144, m4_.idUsersChanger AS idUsersChanger_145, m5_.fileVersion AS fileVersion_146, m6_.idFileVersions AS idFileVersions_147, m7_.idFileVersions AS idFileVersions_148, m8_.idFileVersions AS idFileVersions_149, m9_.idFileVersions AS idFileVersions_150, s10_.idUsersCreator AS idUsersCreator_151, s10_.idUsersChanger AS idUsersChanger_152, s10_.cart_id AS cart_id_153, s10_.idContacts AS idContacts_154, c11_.idTitles AS idTitles_155, c11_.avatar AS avatar_156, c11_.idUsersCreator AS idUsersCreator_157, c11_.idUsersChanger AS idUsersChanger_158, s12_.idUsersCreator AS idUsersCreator_159, s12_.idUsersChanger AS idUsersChanger_160, s12_.cart_id AS cart_id_161, s12_.idContacts AS idContacts_162, c13_.idTitles AS idTitles_163, c13_.avatar AS avatar_164, c13_.idUsersCreator AS idUsersCreator_165, c13_.idUsersChanger AS idUsersChanger_166, m14_.idMediaTypes AS idMediaTypes_167, m14_.idPreviewImage AS idPreviewImage_168, m14_.idCollections AS idCollections_169, m14_.idUsersCreator AS idUsersCreator_170, m14_.idUsersChanger AS idUsersChanger_171 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_format_options m5_ ON m4_.id = m5_.fileVersion LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id LEFT JOIN me_media m14_ ON m0_.idPreviewImage = m14_.id WHERE m0_.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
3.28 ms
(5.37%) 		6 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/jagunic/routes/hr/vina"
  "default_live"
]
View formatted query    View runnable query    Explain query
2.37 ms
(3.87%) 		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
1.95 ms
(3.20%) 		4 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/jagunic/routes/hr/vina"
  "default_live"
]
View formatted query    View runnable query    Explain query
1.28 ms
(2.09%) 		4 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.background AS background_4, t0.text_color AS text_color_5, t0.active AS active_6 FROM app_ribbon t0 WHERE t0.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.78 ms
(1.27%) 		1 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.72 ms
(1.17%) 		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 = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC
Parameters: 
[
  "default_live"
  "/cmf/jagunic/contents/vina/three-stars-rose-brut"
  "/cmf/jagunic/contents/vina/signature-no-1"
  "/cmf/jagunic/contents/vina/killer-queen"
  "/cmf/jagunic/contents/vina/mraz-o-mor"
  "/cmf/jagunic/contents/vina/traminac-crveni"
  "/cmf/jagunic/contents/vina/traminac-crveni-amber-selection"
  "/cmf/jagunic/contents/vina/blanc-de-blancs"
  "/cmf/jagunic/contents/vina/three-stars-brut"
  "/cmf/jagunic/contents/vina/three-stars-brut-0-375l"
]
View formatted query    View runnable query    Explain query
0.68 ms
(1.12%) 		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: 
[
  1
]
View formatted query    View runnable query    Explain query
0.58 ms
(0.94%) 		1 
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2 FROM app_cookie a0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.47 ms
(0.77%) 		1 
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"
  "92128f14-7893-432b-9a41-2917f00a1066"
]
View formatted query    View runnable query    Explain query
0.47 ms
(0.77%) 		1 
SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?
Parameters: 
[
  "6b7a00a3-a2d0-4528-9b40-3e0b358baaa8"
  "default_live"
]
View formatted query    View runnable query    Explain query
0.45 ms
(0.74%) 		1 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/jagunic/contents/vina/three-stars-rose-brut"
  "/cmf/jagunic/contents/vina/signature-no-1"
  "/cmf/jagunic/contents/vina/killer-queen"
  "/cmf/jagunic/contents/vina/mraz-o-mor"
  "/cmf/jagunic/contents/vina/traminac-crveni"
  "/cmf/jagunic/contents/vina/traminac-crveni-amber-selection"
  "/cmf/jagunic/contents/vina/blanc-de-blancs"
  "/cmf/jagunic/contents/vina/three-stars-brut"
  "/cmf/jagunic/contents/vina/three-stars-brut-0-375l"
  "default_live"
]
View formatted query    View runnable query    Explain query
0.29 ms
(0.47%) 		1 
SELECT prefix, uri FROM phpcr_namespaces
Parameters: 
[]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Sulu\Bundle\MediaBundle\Entity\FileVersion 12
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta 12
Sulu\Bundle\MediaBundle\Entity\Media 11
Sulu\Bundle\MediaBundle\Entity\File 11
Sulu\Bundle\MediaBundle\Entity\Collection 3
Sulu\Bundle\MediaBundle\Entity\CollectionMeta 3
App\Entity\User 2
Sulu\Bundle\ContactBundle\Entity\Contact 2
Sulu\Bundle\MediaBundle\Entity\MediaType 1
Sulu\Bundle\MediaBundle\Entity\CollectionType 1
App\Entity\Ribbon 1

Entities Mapping

Class Mapping errors
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
Sulu\Bundle\SecurityBundle\Entity\User No errors.
App\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\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.
App\Entity\Cart No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
App\Entity\UserOrder 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.
App\Entity\Ribbon No errors.
App\Entity\Cookie No errors.