Query Metrics
22
Database Queries
12
Different statements
16.97 ms
Query time
0
Invalid entities
19
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.91 ms |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
| 2 | 0.30 ms |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
| 3 | 0.41 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/jagunic/routes/hr/gift-card/gift-card-2" "default_live" ] |
| 4 | 0.41 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/jagunic/routes/hr/gift-card/gift-card-2" "default_live" ] |
| 5 | 0.76 ms |
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:
[] |
| 6 | 0.49 ms |
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" "5f313493-5519-429f-a927-0d73503b3658" ] |
| 7 | 0.38 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/jagunic/contents/gift-card/gift-card-2" "default_live" ] |
| 8 | 0.49 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/jagunic/contents/gift-card" "default_live" ] |
| 9 | 0.44 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/jagunic/contents/gift-card" "default_live" ] |
| 10 | 2.46 ms |
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:
[
109
]
|
| 11 | 0.52 ms |
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
]
|
| 12 | 0.61 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.percent AS percent_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.discount_type AS discount_type_6, a0_.products AS products_7, a0_.categories AS categories_8, a0_.assigned_products AS assigned_products_9 FROM app_discount a0_ WHERE a0_.assigned_products LIKE ? AND (a0_.end_date > ? AND a0_.start_date < ?)
Parameters:
[ "%5f313493-5519-429f-a927-0d73503b3658%" "2026-04-20 12:04:54" "2026-04-20 12:04:54" ] |
| 13 | 4.38 ms |
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:
[ 109 110 108 ] |
| 14 | 0.39 ms |
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
]
|
| 15 | 0.28 ms |
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
]
|
| 16 | 0.28 ms |
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
]
|
| 17 | 0.24 ms |
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
]
|
| 18 | 0.62 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/jagunic/contents" "default_live" ] |
| 19 | 0.60 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/jagunic/contents" "default_live" ] |
| 20 | 0.75 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/jagunic" "default_live" ] |
| 21 | 0.74 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/jagunic" "default_live" ] |
| 22 | 0.51 ms |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2 FROM app_cookie a0_
Parameters:
[] |
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\Media | 3 |
| Sulu\Bundle\MediaBundle\Entity\File | 3 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 3 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 3 |
| Sulu\Bundle\MediaBundle\Entity\MediaType | 1 |
| Sulu\Bundle\MediaBundle\Entity\Collection | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | 1 |
| App\Entity\User | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |
| App\Entity\Ribbon | 1 |