Redirect 301 redirect from GET @n/a (5cdaeb)

GET https://pqna.preprod.seven-group.com/fr

Response
200 OK
Browse referrer URL
IP
10.2.3.129
Profiled on
Token
4f56be

Query Metrics

95 Database Queries
34 Different statements
302.75 ms Query time
0 Invalid entities
95 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
54.84 ms
(18.11%) 		14 
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_.origin AS origin_28, m4_.aiDisclosureDisabled AS aiDisclosureDisabled_29, m4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30, m4_.id AS id_31, m4_.created AS created_32, m4_.changed AS changed_33, m5_.crop_x AS crop_x_34, m5_.crop_y AS crop_y_35, m5_.crop_width AS crop_width_36, m5_.crop_height AS crop_height_37, m5_.format_key AS format_key_38, m6_.title AS title_39, m6_.description AS description_40, m6_.aiDisclosureText AS aiDisclosureText_41, m6_.copyright AS copyright_42, m6_.credits AS credits_43, m6_.locale AS locale_44, m6_.id AS id_45, m7_.title AS title_46, m7_.description AS description_47, m7_.aiDisclosureText AS aiDisclosureText_48, m7_.copyright AS copyright_49, m7_.credits AS credits_50, m7_.locale AS locale_51, m7_.id AS id_52, m8_.locale AS locale_53, m8_.id AS id_54, m9_.locale AS locale_55, m9_.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, s10_.enterprise AS enterprise_74, s10_.actorType AS actorType_75, s10_.isVisibleProfile AS isVisibleProfile_76, s10_.typologie_structure AS typologie_structure_77, s10_.fonction AS fonction_78, s10_.fonction_desc AS fonction_desc_79, s10_.typologie_acteur_value AS typologie_acteur_value_80, c11_.firstName AS firstName_81, c11_.middleName AS middleName_82, c11_.lastName AS lastName_83, c11_.birthday AS birthday_84, c11_.salutation AS salutation_85, c11_.formOfAddress AS formOfAddress_86, c11_.newsletter AS newsletter_87, c11_.gender AS gender_88, c11_.note AS note_89, c11_.mainEmail AS mainEmail_90, c11_.mainPhone AS mainPhone_91, c11_.mainFax AS mainFax_92, c11_.mainUrl AS mainUrl_93, c11_.id AS id_94, c11_.created AS created_95, c11_.changed AS changed_96, c11_.visible_annuaire AS visible_annuaire_97, c11_.free_text AS free_text_98, c11_.autres_typologie_acteur AS autres_typologie_acteur_99, c11_.structure AS structure_100, s12_.username AS username_101, s12_.password AS password_102, s12_.locale AS locale_103, s12_.salt AS salt_104, s12_.locked AS locked_105, s12_.enabled AS enabled_106, s12_.lastLogin AS lastLogin_107, s12_.confirmationKey AS confirmationKey_108, s12_.passwordResetToken AS passwordResetToken_109, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_110, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_111, s12_.privateKey AS privateKey_112, s12_.apiKey AS apiKey_113, s12_.email AS email_114, s12_.id AS id_115, s12_.created AS created_116, s12_.changed AS changed_117, s12_.enterprise AS enterprise_118, s12_.actorType AS actorType_119, s12_.isVisibleProfile AS isVisibleProfile_120, s12_.typologie_structure AS typologie_structure_121, s12_.fonction AS fonction_122, s12_.fonction_desc AS fonction_desc_123, s12_.typologie_acteur_value AS typologie_acteur_value_124, c13_.firstName AS firstName_125, c13_.middleName AS middleName_126, c13_.lastName AS lastName_127, c13_.birthday AS birthday_128, c13_.salutation AS salutation_129, c13_.formOfAddress AS formOfAddress_130, c13_.newsletter AS newsletter_131, c13_.gender AS gender_132, c13_.note AS note_133, c13_.mainEmail AS mainEmail_134, c13_.mainPhone AS mainPhone_135, c13_.mainFax AS mainFax_136, c13_.mainUrl AS mainUrl_137, c13_.id AS id_138, c13_.created AS created_139, c13_.changed AS changed_140, c13_.visible_annuaire AS visible_annuaire_141, c13_.free_text AS free_text_142, c13_.autres_typologie_acteur AS autres_typologie_acteur_143, c13_.structure AS structure_144, m14_.id AS id_145, m14_.created AS created_146, m14_.changed AS changed_147, m0_.idMediaTypes AS idMediaTypes_148, m0_.idPreviewImage AS idPreviewImage_149, m0_.idCollections AS idCollections_150, m0_.idUsersCreator AS idUsersCreator_151, m0_.idUsersChanger AS idUsersChanger_152, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_153, m2_.idCollectionTypes AS idCollectionTypes_154, m2_.idCollectionsParent AS idCollectionsParent_155, m2_.idUsersCreator AS idUsersCreator_156, m2_.idUsersChanger AS idUsersChanger_157, m3_.idMedia AS idMedia_158, m3_.idUsersCreator AS idUsersCreator_159, m3_.idUsersChanger AS idUsersChanger_160, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_161, m4_.idFiles AS idFiles_162, m4_.idUsersCreator AS idUsersCreator_163, m4_.idUsersChanger AS idUsersChanger_164, m5_.fileVersion AS fileVersion_165, m6_.idFileVersions AS idFileVersions_166, m7_.idFileVersions AS idFileVersions_167, m8_.idFileVersions AS idFileVersions_168, m9_.idFileVersions AS idFileVersions_169, s10_.idUsersCreator AS idUsersCreator_170, s10_.idUsersChanger AS idUsersChanger_171, s10_.idContacts AS idContacts_172, c11_.idTitles AS idTitles_173, c11_.avatar AS avatar_174, c11_.idUsersCreator AS idUsersCreator_175, c11_.idUsersChanger AS idUsersChanger_176, c11_.typologie_acteur_id AS typologie_acteur_id_177, c11_.typologie_structure_id AS typologie_structure_id_178, c11_.departement_id AS departement_id_179, c11_.territoire_interv_id AS territoire_interv_id_180, s12_.idUsersCreator AS idUsersCreator_181, s12_.idUsersChanger AS idUsersChanger_182, s12_.idContacts AS idContacts_183, c13_.idTitles AS idTitles_184, c13_.avatar AS avatar_185, c13_.idUsersCreator AS idUsersCreator_186, c13_.idUsersChanger AS idUsersChanger_187, c13_.typologie_acteur_id AS typologie_acteur_id_188, c13_.typologie_structure_id AS typologie_structure_id_189, c13_.departement_id AS departement_id_190, c13_.territoire_interv_id AS territoire_interv_id_191, m14_.idMediaTypes AS idMediaTypes_192, m14_.idPreviewImage AS idPreviewImage_193, m14_.idCollections AS idCollections_194, m14_.idUsersCreator AS idUsersCreator_195, m14_.idUsersChanger AS idUsersChanger_196 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: 
[
  24
]
View formatted query    View runnable query    Explain query
41.52 ms
(13.71%) 		2 
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 EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/pqna/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
38.34 ms
(12.66%) 		1 
SELECT
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-routePath\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-title\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-chapo\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-excerpt-categories\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-contributors\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-author\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-header_img\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-image_alt\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-template\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-authored\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-readtime\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-departement\"]/sv:value"),
        co_contacts.firstName,
        co_contacts.lastName,
        co_contacts.visible_annuaire,
        co_contacts.id
        FROM phpcr_nodes
        LEFT JOIN co_contacts 
        ON co_contacts.id = EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-author\"]/sv:value")
        LEFT JOIN se_users
        ON se_users.idContacts = co_contacts.id
        WHERE workspace_name = "default_live"
        AND EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-template\"]/sv:value") IN ("articles", "analyses", "guides_outils", "experiences")
        AND path LIKE "/cmf/articles/%"ORDER BY EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-authored\"]/sv:value") DESC LIMIT 6
Parameters: 
[]
View formatted query    View runnable query    Explain query
27.47 ms
(9.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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="bottomfooter"]) > 0')) AND n0.path LIKE '/cmf/pqna/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
26.40 ms
(8.72%) 		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:fr-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-navContexts"]/sv:value[text()="footer"]) > 0')) AND n0.path LIKE '/cmf/pqna/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
19.26 ms
(6.36%) 		1 
SELECT
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-routePath\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-title\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-chapo\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-excerpt-categories\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-header_img\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-image_alt\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-template\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-published\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-date\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-time\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-price\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-place_select\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-place_text\"]/sv:value"),
        EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-place_link\"]/sv:value")
        FROM phpcr_nodes 
        WHERE workspace_name = "default_live"
        AND path LIKE "/cmf/articles/%"
        AND EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-template\"]/sv:value") = "agenda"
        AND EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-date\"]/sv:value") >= CURDATE()
        ORDER BY EXTRACTVALUE(props, "//sv:property[@sv:name=\"i18n:fr-date\"]/sv:value") ASC LIMIT 9
Parameters: 
[]
View formatted query    View runnable query    Explain query
11.12 ms
(3.67%) 		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_.origin AS origin_28, m4_.aiDisclosureDisabled AS aiDisclosureDisabled_29, m4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30, m4_.id AS id_31, m4_.created AS created_32, m4_.changed AS changed_33, t5_.name AS name_34, t5_.id AS id_35, t5_.created AS created_36, t5_.changed AS changed_37, m6_.title AS title_38, m6_.description AS description_39, m6_.aiDisclosureText AS aiDisclosureText_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, m7_.title AS title_45, m7_.description AS description_46, m7_.aiDisclosureText AS aiDisclosureText_47, m7_.copyright AS copyright_48, m7_.credits AS credits_49, m7_.locale AS locale_50, m7_.id AS id_51, m8_.locale AS locale_52, m8_.id AS id_53, m9_.locale AS locale_54, m9_.id AS id_55, s10_.username AS username_56, s10_.password AS password_57, s10_.locale AS locale_58, s10_.salt AS salt_59, s10_.locked AS locked_60, s10_.enabled AS enabled_61, s10_.lastLogin AS lastLogin_62, s10_.confirmationKey AS confirmationKey_63, s10_.passwordResetToken AS passwordResetToken_64, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s10_.privateKey AS privateKey_67, s10_.apiKey AS apiKey_68, s10_.email AS email_69, s10_.id AS id_70, s10_.created AS created_71, s10_.changed AS changed_72, s10_.enterprise AS enterprise_73, s10_.actorType AS actorType_74, s10_.isVisibleProfile AS isVisibleProfile_75, s10_.typologie_structure AS typologie_structure_76, s10_.fonction AS fonction_77, s10_.fonction_desc AS fonction_desc_78, s10_.typologie_acteur_value AS typologie_acteur_value_79, c11_.firstName AS firstName_80, c11_.middleName AS middleName_81, c11_.lastName AS lastName_82, c11_.birthday AS birthday_83, c11_.salutation AS salutation_84, c11_.formOfAddress AS formOfAddress_85, c11_.newsletter AS newsletter_86, c11_.gender AS gender_87, c11_.note AS note_88, c11_.mainEmail AS mainEmail_89, c11_.mainPhone AS mainPhone_90, c11_.mainFax AS mainFax_91, c11_.mainUrl AS mainUrl_92, c11_.id AS id_93, c11_.created AS created_94, c11_.changed AS changed_95, c11_.visible_annuaire AS visible_annuaire_96, c11_.free_text AS free_text_97, c11_.autres_typologie_acteur AS autres_typologie_acteur_98, c11_.structure AS structure_99, s12_.username AS username_100, s12_.password AS password_101, s12_.locale AS locale_102, s12_.salt AS salt_103, s12_.locked AS locked_104, s12_.enabled AS enabled_105, s12_.lastLogin AS lastLogin_106, s12_.confirmationKey AS confirmationKey_107, s12_.passwordResetToken AS passwordResetToken_108, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_109, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_110, s12_.privateKey AS privateKey_111, s12_.apiKey AS apiKey_112, s12_.email AS email_113, s12_.id AS id_114, s12_.created AS created_115, s12_.changed AS changed_116, s12_.enterprise AS enterprise_117, s12_.actorType AS actorType_118, s12_.isVisibleProfile AS isVisibleProfile_119, s12_.typologie_structure AS typologie_structure_120, s12_.fonction AS fonction_121, s12_.fonction_desc AS fonction_desc_122, s12_.typologie_acteur_value AS typologie_acteur_value_123, c13_.firstName AS firstName_124, c13_.middleName AS middleName_125, c13_.lastName AS lastName_126, c13_.birthday AS birthday_127, c13_.salutation AS salutation_128, c13_.formOfAddress AS formOfAddress_129, c13_.newsletter AS newsletter_130, c13_.gender AS gender_131, c13_.note AS note_132, c13_.mainEmail AS mainEmail_133, c13_.mainPhone AS mainPhone_134, c13_.mainFax AS mainFax_135, c13_.mainUrl AS mainUrl_136, c13_.id AS id_137, c13_.created AS created_138, c13_.changed AS changed_139, c13_.visible_annuaire AS visible_annuaire_140, c13_.free_text AS free_text_141, c13_.autres_typologie_acteur AS autres_typologie_acteur_142, c13_.structure AS structure_143, m0_.idMediaTypes AS idMediaTypes_144, m0_.idPreviewImage AS idPreviewImage_145, m0_.idCollections AS idCollections_146, m0_.idUsersCreator AS idUsersCreator_147, m0_.idUsersChanger AS idUsersChanger_148, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_149, m2_.idCollectionTypes AS idCollectionTypes_150, m2_.idCollectionsParent AS idCollectionsParent_151, m2_.idUsersCreator AS idUsersCreator_152, m2_.idUsersChanger AS idUsersChanger_153, m3_.idMedia AS idMedia_154, m3_.idUsersCreator AS idUsersCreator_155, m3_.idUsersChanger AS idUsersChanger_156, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_157, m4_.idFiles AS idFiles_158, m4_.idUsersCreator AS idUsersCreator_159, m4_.idUsersChanger AS idUsersChanger_160, t5_.idUsersCreator AS idUsersCreator_161, t5_.idUsersChanger AS idUsersChanger_162, m6_.idFileVersions AS idFileVersions_163, m7_.idFileVersions AS idFileVersions_164, m8_.idFileVersions AS idFileVersions_165, m9_.idFileVersions AS idFileVersions_166, s10_.idUsersCreator AS idUsersCreator_167, s10_.idUsersChanger AS idUsersChanger_168, s10_.idContacts AS idContacts_169, c11_.idTitles AS idTitles_170, c11_.avatar AS avatar_171, c11_.idUsersCreator AS idUsersCreator_172, c11_.idUsersChanger AS idUsersChanger_173, c11_.typologie_acteur_id AS typologie_acteur_id_174, c11_.typologie_structure_id AS typologie_structure_id_175, c11_.departement_id AS departement_id_176, c11_.territoire_interv_id AS territoire_interv_id_177, s12_.idUsersCreator AS idUsersCreator_178, s12_.idUsersChanger AS idUsersChanger_179, s12_.idContacts AS idContacts_180, c13_.idTitles AS idTitles_181, c13_.avatar AS avatar_182, c13_.idUsersCreator AS idUsersCreator_183, c13_.idUsersChanger AS idUsersChanger_184, c13_.typologie_acteur_id AS typologie_acteur_id_185, c13_.typologie_structure_id AS typologie_structure_id_186, c13_.departement_id AS departement_id_187, c13_.territoire_interv_id AS territoire_interv_id_188 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: 
[
  26
]
View formatted query    View runnable query    Explain query
10.18 ms
(3.36%) 		11 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/pqna/routes/fr"
  "default_live"
]
View formatted query    View runnable query    Explain query
9.77 ms
(3.23%) 		14 
SELECT DATABASE()
Parameters: 
[]
View formatted query    View runnable query    Explain query
8.97 ms
(2.96%) 		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_.origin AS origin_28, m4_.aiDisclosureDisabled AS aiDisclosureDisabled_29, m4_.aiDisclosureIconVariant AS aiDisclosureIconVariant_30, m4_.id AS id_31, m4_.created AS created_32, m4_.changed AS changed_33, t5_.name AS name_34, t5_.id AS id_35, t5_.created AS created_36, t5_.changed AS changed_37, m6_.title AS title_38, m6_.description AS description_39, m6_.aiDisclosureText AS aiDisclosureText_40, m6_.copyright AS copyright_41, m6_.credits AS credits_42, m6_.locale AS locale_43, m6_.id AS id_44, m7_.title AS title_45, m7_.description AS description_46, m7_.aiDisclosureText AS aiDisclosureText_47, m7_.copyright AS copyright_48, m7_.credits AS credits_49, m7_.locale AS locale_50, m7_.id AS id_51, m8_.locale AS locale_52, m8_.id AS id_53, m9_.locale AS locale_54, m9_.id AS id_55, s10_.username AS username_56, s10_.password AS password_57, s10_.locale AS locale_58, s10_.salt AS salt_59, s10_.locked AS locked_60, s10_.enabled AS enabled_61, s10_.lastLogin AS lastLogin_62, s10_.confirmationKey AS confirmationKey_63, s10_.passwordResetToken AS passwordResetToken_64, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_65, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_66, s10_.privateKey AS privateKey_67, s10_.apiKey AS apiKey_68, s10_.email AS email_69, s10_.id AS id_70, s10_.created AS created_71, s10_.changed AS changed_72, s10_.enterprise AS enterprise_73, s10_.actorType AS actorType_74, s10_.isVisibleProfile AS isVisibleProfile_75, s10_.typologie_structure AS typologie_structure_76, s10_.fonction AS fonction_77, s10_.fonction_desc AS fonction_desc_78, s10_.typologie_acteur_value AS typologie_acteur_value_79, c11_.firstName AS firstName_80, c11_.middleName AS middleName_81, c11_.lastName AS lastName_82, c11_.birthday AS birthday_83, c11_.salutation AS salutation_84, c11_.formOfAddress AS formOfAddress_85, c11_.newsletter AS newsletter_86, c11_.gender AS gender_87, c11_.note AS note_88, c11_.mainEmail AS mainEmail_89, c11_.mainPhone AS mainPhone_90, c11_.mainFax AS mainFax_91, c11_.mainUrl AS mainUrl_92, c11_.id AS id_93, c11_.created AS created_94, c11_.changed AS changed_95, c11_.visible_annuaire AS visible_annuaire_96, c11_.free_text AS free_text_97, c11_.autres_typologie_acteur AS autres_typologie_acteur_98, c11_.structure AS structure_99, s12_.username AS username_100, s12_.password AS password_101, s12_.locale AS locale_102, s12_.salt AS salt_103, s12_.locked AS locked_104, s12_.enabled AS enabled_105, s12_.lastLogin AS lastLogin_106, s12_.confirmationKey AS confirmationKey_107, s12_.passwordResetToken AS passwordResetToken_108, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_109, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_110, s12_.privateKey AS privateKey_111, s12_.apiKey AS apiKey_112, s12_.email AS email_113, s12_.id AS id_114, s12_.created AS created_115, s12_.changed AS changed_116, s12_.enterprise AS enterprise_117, s12_.actorType AS actorType_118, s12_.isVisibleProfile AS isVisibleProfile_119, s12_.typologie_structure AS typologie_structure_120, s12_.fonction AS fonction_121, s12_.fonction_desc AS fonction_desc_122, s12_.typologie_acteur_value AS typologie_acteur_value_123, c13_.firstName AS firstName_124, c13_.middleName AS middleName_125, c13_.lastName AS lastName_126, c13_.birthday AS birthday_127, c13_.salutation AS salutation_128, c13_.formOfAddress AS formOfAddress_129, c13_.newsletter AS newsletter_130, c13_.gender AS gender_131, c13_.note AS note_132, c13_.mainEmail AS mainEmail_133, c13_.mainPhone AS mainPhone_134, c13_.mainFax AS mainFax_135, c13_.mainUrl AS mainUrl_136, c13_.id AS id_137, c13_.created AS created_138, c13_.changed AS changed_139, c13_.visible_annuaire AS visible_annuaire_140, c13_.free_text AS free_text_141, c13_.autres_typologie_acteur AS autres_typologie_acteur_142, c13_.structure AS structure_143, m0_.idMediaTypes AS idMediaTypes_144, m0_.idPreviewImage AS idPreviewImage_145, m0_.idCollections AS idCollections_146, m0_.idUsersCreator AS idUsersCreator_147, m0_.idUsersChanger AS idUsersChanger_148, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_149, m2_.idCollectionTypes AS idCollectionTypes_150, m2_.idCollectionsParent AS idCollectionsParent_151, m2_.idUsersCreator AS idUsersCreator_152, m2_.idUsersChanger AS idUsersChanger_153, m3_.idMedia AS idMedia_154, m3_.idUsersCreator AS idUsersCreator_155, m3_.idUsersChanger AS idUsersChanger_156, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_157, m4_.idFiles AS idFiles_158, m4_.idUsersCreator AS idUsersCreator_159, m4_.idUsersChanger AS idUsersChanger_160, t5_.idUsersCreator AS idUsersCreator_161, t5_.idUsersChanger AS idUsersChanger_162, m6_.idFileVersions AS idFileVersions_163, m7_.idFileVersions AS idFileVersions_164, m8_.idFileVersions AS idFileVersions_165, m9_.idFileVersions AS idFileVersions_166, s10_.idUsersCreator AS idUsersCreator_167, s10_.idUsersChanger AS idUsersChanger_168, s10_.idContacts AS idContacts_169, c11_.idTitles AS idTitles_170, c11_.avatar AS avatar_171, c11_.idUsersCreator AS idUsersCreator_172, c11_.idUsersChanger AS idUsersChanger_173, c11_.typologie_acteur_id AS typologie_acteur_id_174, c11_.typologie_structure_id AS typologie_structure_id_175, c11_.departement_id AS departement_id_176, c11_.territoire_interv_id AS territoire_interv_id_177, s12_.idUsersCreator AS idUsersCreator_178, s12_.idUsersChanger AS idUsersChanger_179, s12_.idContacts AS idContacts_180, c13_.idTitles AS idTitles_181, c13_.avatar AS avatar_182, c13_.idUsersCreator AS idUsersCreator_183, c13_.idUsersChanger AS idUsersChanger_184, c13_.typologie_acteur_id AS typologie_acteur_id_185, c13_.typologie_structure_id AS typologie_structure_id_186, c13_.departement_id AS departement_id_187, c13_.territoire_interv_id AS territoire_interv_id_188 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: 
[
  29
  25
  27
  28
  26
]
View formatted query    View runnable query    Explain query
8.86 ms
(2.93%) 		10 
SELECT t0.position AS position_1, t0.id AS id_2, t0.idCategoryTranslations AS idCategoryTranslations_3, t0.idMedia AS idMedia_4 FROM ca_category_translation_medias t0 WHERE t0.idCategoryTranslations = ?
Parameters: 
[
  26
]
View formatted query    View runnable query    Explain query
5.60 ms
(1.85%) 		6 
SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC
Parameters: 
[
  "/cmf/pqna/routes/fr"
  "default_live"
]
View formatted query    View runnable query    Explain query
5.00 ms
(1.65%) 		5 
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"
  "9ee8e820-1f78-433c-8503-2a695378fba1"
]
View formatted query    View runnable query    Explain query
3.64 ms
(1.20%) 		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
3.30 ms
(1.09%) 		1 
SELECT c0_.category_key AS category_key_0, c0_.default_locale AS default_locale_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.depth AS depth_4, c0_.id AS id_5, c0_.created AS created_6, c0_.changed AS changed_7, c0_.page_link AS page_link_8, c0_.color AS color_9, c1_.meta_key AS meta_key_10, c1_.value AS value_11, c1_.locale AS locale_12, c1_.id AS id_13, c2_.translation AS translation_14, c2_.locale AS locale_15, c2_.description AS description_16, c2_.id AS id_17, c2_.created AS created_18, c2_.changed AS changed_19, c3_.locale AS locale_20, c3_.keyword AS keyword_21, c3_.id AS id_22, c3_.created AS created_23, c3_.changed AS changed_24, c4_.category_key AS category_key_25, c4_.default_locale AS default_locale_26, c4_.lft AS lft_27, c4_.rgt AS rgt_28, c4_.depth AS depth_29, c4_.id AS id_30, c4_.created AS created_31, c4_.changed AS changed_32, c4_.page_link AS page_link_33, c4_.color AS color_34, c5_.category_key AS category_key_35, c5_.default_locale AS default_locale_36, c5_.lft AS lft_37, c5_.rgt AS rgt_38, c5_.depth AS depth_39, c5_.id AS id_40, c5_.created AS created_41, c5_.changed AS changed_42, c5_.page_link AS page_link_43, c5_.color AS color_44, c0_.idCategoriesParent AS idCategoriesParent_45, c0_.idUsersCreator AS idUsersCreator_46, c0_.idUsersChanger AS idUsersChanger_47, c1_.idCategories AS idCategories_48, c2_.idCategories AS idCategories_49, c2_.idUsersCreator AS idUsersCreator_50, c2_.idUsersChanger AS idUsersChanger_51, c3_.idUsersCreator AS idUsersCreator_52, c3_.idUsersChanger AS idUsersChanger_53, c4_.idCategoriesParent AS idCategoriesParent_54, c4_.idUsersCreator AS idUsersCreator_55, c4_.idUsersChanger AS idUsersChanger_56, c5_.idCategoriesParent AS idCategoriesParent_57, c5_.idUsersCreator AS idUsersCreator_58, c5_.idUsersChanger AS idUsersChanger_59 FROM ca_categories c0_ LEFT JOIN ca_category_meta c1_ ON c0_.id = c1_.idCategories LEFT JOIN ca_category_translations c2_ ON c0_.id = c2_.idCategories LEFT JOIN ca_category_translation_keywords c6_ ON c2_.id = c6_.idCategoryTranslations LEFT JOIN ca_keywords c3_ ON c3_.id = c6_.idKeywords LEFT JOIN ca_categories c4_ ON c0_.idCategoriesParent = c4_.id LEFT JOIN ca_categories c5_ ON c0_.id = c5_.idCategoriesParent WHERE c4_.category_key = ?
Parameters: 
[
  "thematiques"
]
View formatted query    View runnable query    Explain query
3.09 ms
(1.02%) 		4 
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: 
[
  4
]
View formatted query    View runnable query    Explain query
3.03 ms
(1.00%) 		1 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/pqna/contents/pqn-a/gouvernance"
  "/cmf/pqna/contents/pqn-a/missions"
  "/cmf/pqna/contents/actualites"
  "/cmf/pqna/contents/actualites/articles"
  "/cmf/pqna/contents/ressources/thematiques"
  "/cmf/pqna/contents/contact/contactez-nous"
  "/cmf/pqna/contents/acteurs-territoires/carte-des-territoires"
  "/cmf/pqna/contents/pqn-a/equipe"
  "/cmf/pqna/contents/pqn-a/partenaires"
  "/cmf/pqna/contents/actualites/aap-ami"
  "/cmf/pqna/contents/ressources"
  "/cmf/pqna/contents/ressources/analyses"
  "/cmf/pqna/contents/contact/ressources"
  "/cmf/pqna/contents/acteurs-territoires/carte-des-experiences"
  "/cmf/pqna/contents/pqn-a/modalites-d-acces"
  "/cmf/pqna/contents/contact/proposez-une-fiche-experience"
  "/cmf/pqna/contents/actualites/offres-d-emploi"
  "/cmf/pqna/contents/acteurs-territoires"
  "/cmf/pqna/contents/ressources/guides-et-outils"
  "/cmf/pqna/contents/acteurs-territoires/annuaire"
  "/cmf/pqna/contents/actualites/newsletters"
  "/cmf/pqna/contents/pqn-a"
  "/cmf/pqna/contents/actualites/agenda"
  "/cmf/pqna/contents/contact"
  "default_live"
]
View formatted query    View runnable query    Explain query
2.94 ms
(0.97%) 		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 = '9185faa4-fedd-4607-994e-3ecf897a5ab8' 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"
]
View formatted query    View runnable query    Explain query
2.73 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 = ? 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/pqna/contents/pqn-a/gouvernance"
  "/cmf/pqna/contents/actualites"
  "/cmf/pqna/contents/actualites/articles"
  "/cmf/pqna/contents/ressources/thematiques"
  "/cmf/pqna/contents/contact/contactez-nous"
  "/cmf/pqna/contents/pqn-a/missions"
  "/cmf/pqna/contents/acteurs-territoires/carte-des-territoires"
  "/cmf/pqna/contents/actualites/aap-ami"
  "/cmf/pqna/contents/ressources"
  "/cmf/pqna/contents/ressources/analyses"
  "/cmf/pqna/contents/contact/ressources"
  "/cmf/pqna/contents/acteurs-territoires/carte-des-experiences"
  "/cmf/pqna/contents/pqn-a/equipe"
  "/cmf/pqna/contents/contact/proposez-une-fiche-experience"
  "/cmf/pqna/contents/actualites/offres-d-emploi"
  "/cmf/pqna/contents/acteurs-territoires"
  "/cmf/pqna/contents/ressources/guides-et-outils"
  "/cmf/pqna/contents/acteurs-territoires/annuaire"
  "/cmf/pqna/contents/pqn-a/partenaires"
  "/cmf/pqna/contents/actualites/newsletters"
  "/cmf/pqna/contents/pqn-a"
  "/cmf/pqna/contents/pqn-a/modalites-d-acces"
  "/cmf/pqna/contents/actualites/agenda"
  "/cmf/pqna/contents/contact"
]
View formatted query    View runnable query    Explain query
1.86 ms
(0.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.identifier = 'b22ede65-71eb-45e6-86e6-8e43eb85a4a6' 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"
]
View formatted query    View runnable query    Explain query
1.54 ms
(0.51%) 		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 = '3932d632-b236-4e4f-925a-199da4ebaa8f' 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"
]
View formatted query    View runnable query    Explain query
1.53 ms
(0.51%) 		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 = 'b81180f3-a0e1-4a42-ac78-d58af7e963a4' 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"
]
View formatted query    View runnable query    Explain query
1.29 ms
(0.43%) 		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: 
[
  "pqna.preprod.seven-group.com/{localization}"
  "dev"
  "pqna"
]
View formatted query    View runnable query    Explain query
1.21 ms
(0.40%) 		1 
SELECT c0_.category_key AS category_key_0, c0_.default_locale AS default_locale_1, c0_.lft AS lft_2, c0_.rgt AS rgt_3, c0_.depth AS depth_4, c0_.id AS id_5, c0_.created AS created_6, c0_.changed AS changed_7, c0_.page_link AS page_link_8, c0_.color AS color_9, 1 AS sclr_10, c0_.idCategoriesParent AS idCategoriesParent_11, c0_.idUsersCreator AS idUsersCreator_12, c0_.idUsersChanger AS idUsersChanger_13 FROM ca_categories c0_ WHERE c0_.category_key = ? LIMIT 1
Parameters: 
[
  "thematiques"
]
View formatted query    View runnable query    Explain query
1.20 ms
(0.40%) 		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 = 'd353d011-d93e-444a-8ffc-4eca132e5524' 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"
]
View formatted query    View runnable query    Explain query
1.06 ms
(0.35%) 		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 = ?) ORDER BY sort_order ASC
Parameters: 
[
  "default_live"
  "/cmf/pqna/contents/mentions-legales"
  "/cmf/pqna/contents/politique-de-confidentialite"
  "/cmf/pqna/contents/reglement-general-sur-la-protection-des-donnees"
  "/cmf/pqna/contents/plan-du-site"
]
View formatted query    View runnable query    Explain query
1.06 ms
(0.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/pqna/contents/contact' LIMIT 1
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
1.04 ms
(0.34%) 		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/pqna/contents/actualites/newsletters' LIMIT 1
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.99 ms
(0.33%) 		1 
SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC
Parameters: 
[
  "/cmf/pqna/contents/mentions-legales"
  "/cmf/pqna/contents/politique-de-confidentialite"
  "/cmf/pqna/contents/reglement-general-sur-la-protection-des-donnees"
  "/cmf/pqna/contents/plan-du-site"
  "default_live"
]
View formatted query    View runnable query    Explain query
0.89 ms
(0.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/pqna/contents/contact/contactez-nous' LIMIT 1
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.87 ms
(0.29%) 		1 
SELECT 1 FROM phpcr_workspaces WHERE name = ?
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.84 ms
(0.28%) 		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/pqna/contents/contact/ressources' LIMIT 1
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.82 ms
(0.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/pqna/contents/actualites/agenda' LIMIT 1
Parameters: 
[
  "default_live"
]
View formatted query    View runnable query    Explain query
0.50 ms
(0.17%) 		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 14
Sulu\Bundle\MediaBundle\Entity\FileVersionMeta 14
Sulu\Bundle\MediaBundle\Entity\Media 13
Sulu\Bundle\MediaBundle\Entity\File 13
App\Entity\Category 13
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation 10
App\Entity\User 4
App\Entity\Contact 4
Sulu\Bundle\MediaBundle\Entity\Collection 3
Sulu\Bundle\MediaBundle\Entity\CollectionMeta 3
App\Entity\TypologieStructure 2
Sulu\Bundle\MediaBundle\Entity\MediaType 1
Sulu\Bundle\MediaBundle\Entity\CollectionType 1

Entities Mapping

Class Mapping errors
Sulu\Bundle\FormBundle\Entity\Form No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\FormBundle\Entity\Dynamic No errors.
Sulu\Bundle\MediaBundle\Entity\Collection 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.
App\Entity\Contact No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType No errors.
App\Entity\TypologieActeur No errors.
App\Entity\TypologieStructure No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
App\Entity\Category No errors.
Sulu\Bundle\TagBundle\Entity\Tag 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\CategoryBundle\Entity\CategoryMeta No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation No errors.
Sulu\Bundle\CategoryBundle\Entity\Keyword No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslationMedia No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.