Query Metrics
33
Database Queries
23
Different statements
21.93 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.24 ms (23.88%) |
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 ((((((((((((n0.identifier = 'c8632751-54de-4532-a27e-a2968847e5be' OR n0.identifier = 'e9dbce43-4109-4972-91dc-213a94b1a9ab') OR n0.identifier = '92128f14-7893-432b-9a41-2917f00a1066') OR n0.identifier = '7b8aab22-2768-4ffb-8b41-037f8ee2f9c6') OR n0.identifier = '21ea5f3c-9440-465f-a8b2-cf008424aaaa') OR n0.identifier = '35ee054b-7dcf-4450-a893-5fa22d081e37') OR n0.identifier = 'f8847655-9161-4643-baf1-be30074cb1d7') OR n0.identifier = '15c8bdf0-f6f8-46e8-801d-324ef4a9e678') OR n0.identifier = '62d925bd-0ce2-4c41-b3b4-7cf8b5adfec1') OR n0.identifier = '1665c5cd-1e51-44df-9302-91bbdee31620') OR n0.identifier = 'e85be783-8af6-4b12-90fa-728e331b37d9') OR n0.identifier = '6d52dbaa-fae5-441e-8eac-820c05171421') AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:hr-state"]/sv:value'), ' ', ','))) 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"
]
|
|
2.43 ms (11.07%) |
1 |
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:
[
71
]
|
|
2.13 ms (9.71%) |
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:
[] |
|
1.84 ms (8.40%) |
4 |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/jagunic/routes/hr/uvjeti-kupnje" "default_live" ] |
|
1.75 ms (8.00%) |
3 |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/jagunic/routes/hr/uvjeti-kupnje" "default_live" ] |
|
1.41 ms (6.43%) |
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
]
|
|
1.02 ms (4.65%) |
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
Parameters:
[ "vina-jagunic.com" "dev" "jagunic" ] |
|
0.86 ms (3.94%) |
1 |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
|
0.53 ms (2.44%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2 FROM app_cookie a0_
Parameters:
[] |
|
0.48 ms (2.21%) |
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" "1665c5cd-1e51-44df-9302-91bbdee31620" ] |
|
0.44 ms (2.02%) |
1 |
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
]
|
|
0.41 ms (1.86%) |
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 n0.parent = '/cmf/jagunic/contents/o-nama' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.37 ms (1.67%) |
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 n0.parent = '/cmf/jagunic/contents/vina' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.35 ms (1.61%) |
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 n0.parent = '/cmf/jagunic/contents/gift-card' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.35 ms (1.59%) |
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 n0.parent = '/cmf/jagunic/contents/novosti' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.33 ms (1.49%) |
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 n0.parent = '/cmf/jagunic/contents/uvjeti-kupnje' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.32 ms (1.45%) |
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 n0.parent = '/cmf/jagunic/contents/pravila-privatnosti' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.30 ms (1.35%) |
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 n0.parent = '/cmf/jagunic/contents/vinogradi' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.29 ms (1.31%) |
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 n0.parent = '/cmf/jagunic/contents/kontakt' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.28 ms (1.29%) |
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 n0.parent = '/cmf/jagunic/contents/vodene-degustacije-i-posjete' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.28 ms (1.27%) |
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 n0.parent = '/cmf/jagunic/contents/vinski-podrum' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.27 ms (1.25%) |
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 n0.parent = '/cmf/jagunic/contents/organizacija-dogadaja' LIMIT 1
Parameters:
[
"default_live"
]
|
|
0.24 ms (1.11%) |
1 |
SELECT prefix, uri FROM phpcr_namespaces
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 | 1 |
| 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\MediaBundle\Entity\File | 1 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 1 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |
| App\Entity\Ribbon | 1 |