Query Metrics
36
Database Queries
21
Different statements
13.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.20 ms |
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters:
[
"default_live"
]
|
| 2 | 0.06 ms |
SELECT prefix, uri FROM phpcr_namespaces
Parameters:
[] |
| 3 | 0.08 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/main-website/routes/fr/connexion/inscription/confirmation" "default_live" ] |
| 4 | 0.08 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/main-website/routes/fr/connexion/inscription/confirmation" "default_live" ] |
| 5 | 0.19 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.06 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" "30bc1cec-ad2a-4e7a-aad3-fcf116953428" ] |
| 7 | 0.04 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription/creation-de-compte-reussie" "default_live" ] |
| 8 | 0.06 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription" "default_live" ] |
| 9 | 0.06 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription" "default_live" ] |
| 10 | 0.15 ms |
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.name AS name_2, c0_.short_name AS short_name_3, c0_.logo AS logo_4, c0_.size AS size_5, c0_.current_size AS current_size_6, c0_.partner_site_url AS partner_site_url_7, c0_.partner_site_login AS partner_site_login_8, c0_.partner_site_comment AS partner_site_comment_9, c0_.comment AS comment_10, c0_.type AS type_11, c0_.category AS category_12, c0_.closing_date AS closing_date_13, c0_.closing_date_note AS closing_date_note_14, c0_.deactivation_date AS deactivation_date_15, c0_.partner_pays_for_beneficiaries AS partner_pays_for_beneficiaries_16, c0_.current_year_turnover AS current_year_turnover_17, c0_.previous_year_turnover AS previous_year_turnover_18, c0_.partnership_started_at AS partnership_started_at_19, c0_.has_contacts AS has_contacts_20, c0_.commercial_description AS commercial_description_21, c0_.conditions AS conditions_22, c0_.presentation AS presentation_23, c0_.photo_presentation AS photo_presentation_24, c0_.video_presentation AS video_presentation_25, c0_.web_service AS web_service_26, c0_.created_at AS created_at_27, c0_.created_by AS created_by_28, c0_.updated_at AS updated_at_29, c0_.updated_by AS updated_by_30, c0_.active AS active_31, c0_.archived AS archived_32 FROM common_partner c0_ INNER JOIN common_partner_website c1_ ON c0_.id = c1_.partner_id WHERE c1_.sub_domain = ? AND c1_.active = ? AND c0_.active = ? AND c0_.archived = ?
Parameters:
[ "connect" 1 1 0 ] |
| 11 | 0.53 ms |
SELECT s0_.id AS id_0, s0_.created AS created_1, s0_.changed AS changed_2, s1_.name AS name_3, s1_.description AS description_4, s1_.id AS id_5, s2_.style AS style_6, s2_.lft AS lft_7, s2_.rgt AS rgt_8, s2_.depth AS depth_9, s2_.collection_key AS collection_key_10, s2_.id AS id_11, s2_.created AS created_12, s2_.changed AS changed_13, s3_.version AS version_14, s3_.id AS id_15, s3_.created AS created_16, s3_.changed AS changed_17, s4_.name AS name_18, s4_.version AS version_19, s4_.subVersion AS subVersion_20, s4_.size AS size_21, s4_.downloadCounter AS downloadCounter_22, s4_.storageOptions AS storageOptions_23, s4_.mimeType AS mimeType_24, s4_.properties AS properties_25, s4_.focusPointX AS focusPointX_26, s4_.focusPointY AS focusPointY_27, s4_.origin AS origin_28, s4_.aiDisclosureDisabled AS aiDisclosureDisabled_29, s4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30, s4_.id AS id_31, s4_.created AS created_32, s4_.changed AS changed_33, s5_.crop_x AS crop_x_34, s5_.crop_y AS crop_y_35, s5_.crop_width AS crop_width_36, s5_.crop_height AS crop_height_37, s5_.format_key AS format_key_38, s6_.title AS title_39, s6_.description AS description_40, s6_.aiDisclosureText AS aiDisclosureText_41, s6_.copyright AS copyright_42, s6_.credits AS credits_43, s6_.locale AS locale_44, s6_.id AS id_45, s7_.title AS title_46, s7_.description AS description_47, s7_.aiDisclosureText AS aiDisclosureText_48, s7_.copyright AS copyright_49, s7_.credits AS credits_50, s7_.locale AS locale_51, s7_.id AS id_52, s8_.locale AS locale_53, s8_.id AS id_54, s9_.locale AS locale_55, s9_.id AS id_56, s10_.username AS username_57, s10_.password AS password_58, s10_.locale AS locale_59, s10_.salt AS salt_60, s10_.locked AS locked_61, s10_.enabled AS enabled_62, s10_.lastLogin AS lastLogin_63, s10_.confirmationKey AS confirmationKey_64, s10_.passwordResetToken AS passwordResetToken_65, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_66, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_67, s10_.privateKey AS privateKey_68, s10_.apiKey AS apiKey_69, s10_.email AS email_70, s10_.id AS id_71, s10_.created AS created_72, s10_.changed AS changed_73, s11_.firstName AS firstName_74, s11_.middleName AS middleName_75, s11_.lastName AS lastName_76, s11_.birthday AS birthday_77, s11_.salutation AS salutation_78, s11_.formOfAddress AS formOfAddress_79, s11_.newsletter AS newsletter_80, s11_.gender AS gender_81, s11_.note AS note_82, s11_.mainEmail AS mainEmail_83, s11_.mainPhone AS mainPhone_84, s11_.mainFax AS mainFax_85, s11_.mainUrl AS mainUrl_86, s11_.id AS id_87, s11_.created AS created_88, s11_.changed AS changed_89, s12_.username AS username_90, s12_.password AS password_91, s12_.locale AS locale_92, s12_.salt AS salt_93, s12_.locked AS locked_94, s12_.enabled AS enabled_95, s12_.lastLogin AS lastLogin_96, s12_.confirmationKey AS confirmationKey_97, s12_.passwordResetToken AS passwordResetToken_98, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_99, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_100, s12_.privateKey AS privateKey_101, s12_.apiKey AS apiKey_102, s12_.email AS email_103, s12_.id AS id_104, s12_.created AS created_105, s12_.changed AS changed_106, s13_.firstName AS firstName_107, s13_.middleName AS middleName_108, s13_.lastName AS lastName_109, s13_.birthday AS birthday_110, s13_.salutation AS salutation_111, s13_.formOfAddress AS formOfAddress_112, s13_.newsletter AS newsletter_113, s13_.gender AS gender_114, s13_.note AS note_115, s13_.mainEmail AS mainEmail_116, s13_.mainPhone AS mainPhone_117, s13_.mainFax AS mainFax_118, s13_.mainUrl AS mainUrl_119, s13_.id AS id_120, s13_.created AS created_121, s13_.changed AS changed_122, s14_.id AS id_123, s14_.created AS created_124, s14_.changed AS changed_125, s0_.idMediaTypes AS idMediaTypes_126, s0_.idPreviewImage AS idPreviewImage_127, s0_.idCollections AS idCollections_128, s0_.idUsersCreator AS idUsersCreator_129, s0_.idUsersChanger AS idUsersChanger_130, s2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_131, s2_.idCollectionTypes AS idCollectionTypes_132, s2_.idCollectionsParent AS idCollectionsParent_133, s2_.idUsersCreator AS idUsersCreator_134, s2_.idUsersChanger AS idUsersChanger_135, s3_.idMedia AS idMedia_136, s3_.idUsersCreator AS idUsersCreator_137, s3_.idUsersChanger AS idUsersChanger_138, s4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_139, s4_.idFiles AS idFiles_140, s4_.idUsersCreator AS idUsersCreator_141, s4_.idUsersChanger AS idUsersChanger_142, s5_.fileVersion AS fileVersion_143, s6_.idFileVersions AS idFileVersions_144, s7_.idFileVersions AS idFileVersions_145, s8_.idFileVersions AS idFileVersions_146, s9_.idFileVersions AS idFileVersions_147, s10_.idContacts AS idContacts_148, s10_.idUsersCreator AS idUsersCreator_149, s10_.idUsersChanger AS idUsersChanger_150, s11_.idTitles AS idTitles_151, s11_.avatar AS avatar_152, s11_.idUsersCreator AS idUsersCreator_153, s11_.idUsersChanger AS idUsersChanger_154, s12_.idContacts AS idContacts_155, s12_.idUsersCreator AS idUsersCreator_156, s12_.idUsersChanger AS idUsersChanger_157, s13_.idTitles AS idTitles_158, s13_.avatar AS avatar_159, s13_.idUsersCreator AS idUsersCreator_160, s13_.idUsersChanger AS idUsersChanger_161, s14_.idMediaTypes AS idMediaTypes_162, s14_.idPreviewImage AS idPreviewImage_163, s14_.idCollections AS idCollections_164, s14_.idUsersCreator AS idUsersCreator_165, s14_.idUsersChanger AS idUsersChanger_166 FROM sulu_me_media s0_ LEFT JOIN sulu_me_media_types s1_ ON s0_.idMediaTypes = s1_.id LEFT JOIN sulu_me_collections s2_ ON s0_.idCollections = s2_.id LEFT JOIN sulu_me_files s3_ ON s0_.id = s3_.idMedia LEFT JOIN sulu_me_file_versions s4_ ON s3_.id = s4_.idFiles LEFT JOIN sulu_me_format_options s5_ ON s4_.id = s5_.fileVersion LEFT JOIN sulu_me_file_version_meta s6_ ON s4_.id = s6_.idFileVersions LEFT JOIN sulu_me_file_version_meta s7_ ON s4_.idFileVersionsMetaDefault = s7_.id LEFT JOIN sulu_me_file_version_content_languages s8_ ON s4_.id = s8_.idFileVersions LEFT JOIN sulu_me_file_version_publish_languages s9_ ON s4_.id = s9_.idFileVersions LEFT JOIN sulu_se_users s10_ ON s0_.idUsersCreator = s10_.id LEFT JOIN sulu_co_contacts s11_ ON s10_.idContacts = s11_.id LEFT JOIN sulu_se_users s12_ ON s0_.idUsersChanger = s12_.id LEFT JOIN sulu_co_contacts s13_ ON s12_.idContacts = s13_.id LEFT JOIN sulu_me_media s14_ ON s0_.idPreviewImage = s14_.id WHERE s0_.id = ?
Parameters:
[
18
]
|
| 12 | 0.09 ms |
SELECT DATABASE()
Parameters:
[] |
| 13 | 0.27 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:
[] |
| 14 | 0.19 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:
[] |
| 15 | 0.25 ms |
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 = '1cf6f3f0-5ca5-4d06-8522-70e9b3e77fac' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-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"
]
|
| 16 | 0.04 ms |
SELECT DATABASE()
Parameters:
[] |
| 17 | 0.12 ms |
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/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie' LIMIT 1
Parameters:
[
"default_live"
]
|
| 18 | 0.04 ms |
SELECT DATABASE()
Parameters:
[] |
| 19 | 0.14 ms |
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 = 'ab4fe349-55c9-47a9-a65f-9d6bd0173939' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-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"
]
|
| 20 | 0.03 ms |
SELECT DATABASE()
Parameters:
[] |
| 21 | 0.09 ms |
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/main-website/contents/connexion-espace-personnel/formulaire-d-inscription' LIMIT 1
Parameters:
[
"default_live"
]
|
| 22 | 0.03 ms |
SELECT DATABASE()
Parameters:
[] |
| 23 | 0.10 ms |
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 = 'd7174ea8-7718-4b95-ba89-1dd9ab911587' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-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"
]
|
| 24 | 0.02 ms |
SELECT DATABASE()
Parameters:
[] |
| 25 | 0.08 ms |
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/main-website/contents/connexion-espace-personnel' LIMIT 1
Parameters:
[
"default_live"
]
|
| 26 | 0.03 ms |
SELECT DATABASE()
Parameters:
[] |
| 27 | 0.11 ms |
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 = 'ad8f40d0-b02d-40bc-b9a9-2595e9c213d3' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-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"
]
|
| 28 | 0.02 ms |
SELECT DATABASE()
Parameters:
[] |
| 29 | 0.07 ms |
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/main-website/contents/connexion-espace-personnel/connexion-proposition-commerciale' LIMIT 1
Parameters:
[
"default_live"
]
|
| 30 | 0.04 ms |
SELECT DATABASE()
Parameters:
[] |
| 31 | 8.34 ms |
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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND ((n0.path LIKE '/cmf/main-website/contents/%' OR n0.path = '/cmf/main-website/contents') AND (NOT (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-seo-hideInSitemap"]/sv:value[1])') = 1) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-seo-hideInSitemap"]/sv:value[1]') = '0')))) ORDER BY n0.path ASC
Parameters:
[
"default_live"
]
|
| 32 | 0.70 ms |
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 = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR 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/main-website/contents" "/cmf/main-website/contents/assurances-voyage" "/cmf/main-website/contents/cgu" "/cmf/main-website/contents/compagnies" "/cmf/main-website/contents/confirmation-deconnexion" "/cmf/main-website/contents/connexion-espace-personnel" "/cmf/main-website/contents/connexion-espace-personnel/connexion-espace-personnel" "/cmf/main-website/contents/connexion-espace-personnel/connexion-proposition-commerciale" "/cmf/main-website/contents/connexion-espace-personnel/connexion-proposition-commerciale-1" "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription/email-confirme" "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription/inscription-confirmee-propositino-commerciale" "/cmf/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie" "/cmf/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie/reinitialisation-du-mot-de-passe" "/cmf/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie/reinitialisation-du-mot-de-passe/confirmation-reset-mdp" "/cmf/main-website/contents/contactez-nous" "/cmf/main-website/contents/croisieres-fluviales" "/cmf/main-website/contents/destinations" "/cmf/main-website/contents/faq" "/cmf/main-website/contents/inscription-a-la-newsletter" "/cmf/main-website/contents/mentions-legales" "/cmf/main-website/contents/page-groupes" "/cmf/main-website/contents/page-liste" "/cmf/main-website/contents/page-liste/detail-d-une-croisiere" "/cmf/main-website/contents/page-liste/detail-d-une-croisiere/reservation" "/cmf/main-website/contents/politique-de-confidentialite" "/cmf/main-website/contents/politique-de-gestion-des-cookies" "/cmf/main-website/contents/presentation-partenaires" "/cmf/main-website/contents/promotions" "/cmf/main-website/contents/proposition-commerciale-erreur-rattachee-a-un-autre-compte" "/cmf/main-website/contents/qui-sommes-nous" "/cmf/main-website/contents/qui-sommes-nous/la-meditation-du-tourisme" "/cmf/main-website/contents/recrutement" ] |
| 33 | 0.63 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/main-website/contents/compagnies" "/cmf/main-website/contents/destinations" "/cmf/main-website/contents/qui-sommes-nous/la-meditation-du-tourisme" "/cmf/main-website/contents/promotions" "/cmf/main-website/contents/page-liste/detail-d-une-croisiere/reservation" "/cmf/main-website/contents/page-liste/detail-d-une-croisiere" "/cmf/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie" "/cmf/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie/reinitialisation-du-mot-de-passe" "/cmf/main-website/contents/connexion-espace-personnel/mot-de-passe-oublie/reinitialisation-du-mot-de-passe/confirmation-reset-mdp" "/cmf/main-website/contents" "/cmf/main-website/contents/croisieres-fluviales" "/cmf/main-website/contents/connexion-espace-personnel/connexion-proposition-commerciale" "/cmf/main-website/contents/page-liste" "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription/email-confirme" "/cmf/main-website/contents/faq" "/cmf/main-website/contents/recrutement" "/cmf/main-website/contents/connexion-espace-personnel/formulaire-d-inscription/inscription-confirmee-propositino-commerciale" "/cmf/main-website/contents/mentions-legales" "/cmf/main-website/contents/connexion-espace-personnel/connexion-espace-personnel" "/cmf/main-website/contents/politique-de-confidentialite" "/cmf/main-website/contents/cgu" "/cmf/main-website/contents/connexion-espace-personnel/connexion-proposition-commerciale-1" "/cmf/main-website/contents/politique-de-gestion-des-cookies" "/cmf/main-website/contents/assurances-voyage" "/cmf/main-website/contents/qui-sommes-nous" "/cmf/main-website/contents/contactez-nous" "/cmf/main-website/contents/inscription-a-la-newsletter" "/cmf/main-website/contents/page-groupes" "/cmf/main-website/contents/presentation-partenaires" "/cmf/main-website/contents/connexion-espace-personnel" "/cmf/main-website/contents/confirmation-deconnexion" "/cmf/main-website/contents/proposition-commerciale-erreur-rattachee-a-un-autre-compte" "default_live" ] |
| 34 | 0.14 ms |
SELECT * FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ORDER BY depth, sort_order ASC
Parameters:
[ "/cmf/main-website" "default_live" ] |
| 35 | 0.07 ms |
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters:
[ "/cmf/main-website" "default_live" ] |
| 36 | 0.23 ms |
SELECT s0_.title AS title_0, s0_.webspace_key AS webspace_key_1, s0_.all_domains AS all_domains_2, s0_.content AS content_3, s0_.type AS type_4, s0_.id AS id_5, s1_.url AS url_6, s1_.environment AS environment_7, s1_.id AS id_8 FROM sulu_we_analytics s0_ LEFT JOIN sulu_we_analytics_domains s2_ ON s0_.id = s2_.analytics LEFT JOIN sulu_we_domains s1_ ON s1_.id = s2_.domain WHERE (s0_.all_domains = 1 OR (s1_.url = ? AND s1_.environment = ?)) AND s0_.webspace_key = ? ORDER BY s0_.id ASC
Parameters:
[ "connect.preprod-croisiland.dev/fr" "dev" "main-website" ] |
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.