Symfony Profiler

Query Metrics

210 Database Queries

41 Different statements

30.26 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

19.71 ms
(65.12%)

138

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, c11_.firstName AS firstName_69, c11_.middleName AS middleName_70, c11_.lastName AS lastName_71, c11_.birthday AS birthday_72, c11_.salutation AS salutation_73, c11_.formOfAddress AS formOfAddress_74, c11_.newsletter AS newsletter_75, c11_.gender AS gender_76, c11_.note AS note_77, c11_.mainEmail AS mainEmail_78, c11_.mainPhone AS mainPhone_79, c11_.mainFax AS mainFax_80, c11_.mainUrl AS mainUrl_81, c11_.id AS id_82, c11_.created AS created_83, c11_.changed AS changed_84, s12_.username AS username_85, s12_.password AS password_86, s12_.locale AS locale_87, s12_.salt AS salt_88, s12_.locked AS locked_89, s12_.enabled AS enabled_90, s12_.lastLogin AS lastLogin_91, s12_.confirmationKey AS confirmationKey_92, s12_.passwordResetToken AS passwordResetToken_93, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95, s12_.privateKey AS privateKey_96, s12_.apiKey AS apiKey_97, s12_.email AS email_98, s12_.id AS id_99, s12_.created AS created_100, s12_.changed AS changed_101, c13_.firstName AS firstName_102, c13_.middleName AS middleName_103, c13_.lastName AS lastName_104, c13_.birthday AS birthday_105, c13_.salutation AS salutation_106, c13_.formOfAddress AS formOfAddress_107, c13_.newsletter AS newsletter_108, c13_.gender AS gender_109, c13_.note AS note_110, c13_.mainEmail AS mainEmail_111, c13_.mainPhone AS mainPhone_112, c13_.mainFax AS mainFax_113, c13_.mainUrl AS mainUrl_114, c13_.id AS id_115, c13_.created AS created_116, c13_.changed AS changed_117, m14_.id AS id_118, m14_.created AS created_119, m14_.changed AS changed_120, m0_.idMediaTypes AS idMediaTypes_121, m0_.idPreviewImage AS idPreviewImage_122, m0_.idCollections AS idCollections_123, m0_.idUsersCreator AS idUsersCreator_124, m0_.idUsersChanger AS idUsersChanger_125, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_126, m2_.idCollectionTypes AS idCollectionTypes_127, m2_.idCollectionsParent AS idCollectionsParent_128, m2_.idUsersCreator AS idUsersCreator_129, m2_.idUsersChanger AS idUsersChanger_130, m3_.idMedia AS idMedia_131, m3_.idUsersCreator AS idUsersCreator_132, m3_.idUsersChanger AS idUsersChanger_133, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134, m4_.idFiles AS idFiles_135, m4_.idUsersCreator AS idUsersCreator_136, m4_.idUsersChanger AS idUsersChanger_137, m5_.fileVersion AS fileVersion_138, m6_.idFileVersions AS idFileVersions_139, m7_.idFileVersions AS idFileVersions_140, m8_.idFileVersions AS idFileVersions_141, m9_.idFileVersions AS idFileVersions_142, s10_.idContacts AS idContacts_143, s10_.idUsersCreator AS idUsersCreator_144, s10_.idUsersChanger AS idUsersChanger_145, c11_.idTitles AS idTitles_146, c11_.avatar AS avatar_147, c11_.idUsersCreator AS idUsersCreator_148, c11_.idUsersChanger AS idUsersChanger_149, s12_.idContacts AS idContacts_150, s12_.idUsersCreator AS idUsersCreator_151, s12_.idUsersChanger AS idUsersChanger_152, c13_.idTitles AS idTitles_153, c13_.avatar AS avatar_154, c13_.idUsersCreator AS idUsersCreator_155, c13_.idUsersChanger AS idUsersChanger_156, m14_.idMediaTypes AS idMediaTypes_157, m14_.idPreviewImage AS idPreviewImage_158, m14_.idCollections AS idCollections_159, m14_.idUsersCreator AS idUsersCreator_160, m14_.idUsersChanger AS idUsersChanger_161 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_format_options m5_ ON m4_.id = m5_.fileVersion LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id LEFT JOIN me_media m14_ ON m0_.idPreviewImage = m14_.id WHERE m0_.id = ?

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

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,
  c11_.firstName AS firstName_69,
  c11_.middleName AS middleName_70,
  c11_.lastName AS lastName_71,
  c11_.birthday AS birthday_72,
  c11_.salutation AS salutation_73,
  c11_.formOfAddress AS formOfAddress_74,
  c11_.newsletter AS newsletter_75,
  c11_.gender AS gender_76,
  c11_.note AS note_77,
  c11_.mainEmail AS mainEmail_78,
  c11_.mainPhone AS mainPhone_79,
  c11_.mainFax AS mainFax_80,
  c11_.mainUrl AS mainUrl_81,
  c11_.id AS id_82,
  c11_.created AS created_83,
  c11_.changed AS changed_84,
  s12_.username AS username_85,
  s12_.password AS password_86,
  s12_.locale AS locale_87,
  s12_.salt AS salt_88,
  s12_.locked AS locked_89,
  s12_.enabled AS enabled_90,
  s12_.lastLogin AS lastLogin_91,
  s12_.confirmationKey AS confirmationKey_92,
  s12_.passwordResetToken AS passwordResetToken_93,
  s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94,
  s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95,
  s12_.privateKey AS privateKey_96,
  s12_.apiKey AS apiKey_97,
  s12_.email AS email_98,
  s12_.id AS id_99,
  s12_.created AS created_100,
  s12_.changed AS changed_101,
  c13_.firstName AS firstName_102,
  c13_.middleName AS middleName_103,
  c13_.lastName AS lastName_104,
  c13_.birthday AS birthday_105,
  c13_.salutation AS salutation_106,
  c13_.formOfAddress AS formOfAddress_107,
  c13_.newsletter AS newsletter_108,
  c13_.gender AS gender_109,
  c13_.note AS note_110,
  c13_.mainEmail AS mainEmail_111,
  c13_.mainPhone AS mainPhone_112,
  c13_.mainFax AS mainFax_113,
  c13_.mainUrl AS mainUrl_114,
  c13_.id AS id_115,
  c13_.created AS created_116,
  c13_.changed AS changed_117,
  m14_.id AS id_118,
  m14_.created AS created_119,
  m14_.changed AS changed_120,
  m0_.idMediaTypes AS idMediaTypes_121,
  m0_.idPreviewImage AS idPreviewImage_122,
  m0_.idCollections AS idCollections_123,
  m0_.idUsersCreator AS idUsersCreator_124,
  m0_.idUsersChanger AS idUsersChanger_125,
  m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_126,
  m2_.idCollectionTypes AS idCollectionTypes_127,
  m2_.idCollectionsParent AS idCollectionsParent_128,
  m2_.idUsersCreator AS idUsersCreator_129,
  m2_.idUsersChanger AS idUsersChanger_130,
  m3_.idMedia AS idMedia_131,
  m3_.idUsersCreator AS idUsersCreator_132,
  m3_.idUsersChanger AS idUsersChanger_133,
  m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134,
  m4_.idFiles AS idFiles_135,
  m4_.idUsersCreator AS idUsersCreator_136,
  m4_.idUsersChanger AS idUsersChanger_137,
  m5_.fileVersion AS fileVersion_138,
  m6_.idFileVersions AS idFileVersions_139,
  m7_.idFileVersions AS idFileVersions_140,
  m8_.idFileVersions AS idFileVersions_141,
  m9_.idFileVersions AS idFileVersions_142,
  s10_.idContacts AS idContacts_143,
  s10_.idUsersCreator AS idUsersCreator_144,
  s10_.idUsersChanger AS idUsersChanger_145,
  c11_.idTitles AS idTitles_146,
  c11_.avatar AS avatar_147,
  c11_.idUsersCreator AS idUsersCreator_148,
  c11_.idUsersChanger AS idUsersChanger_149,
  s12_.idContacts AS idContacts_150,
  s12_.idUsersCreator AS idUsersCreator_151,
  s12_.idUsersChanger AS idUsersChanger_152,
  c13_.idTitles AS idTitles_153,
  c13_.avatar AS avatar_154,
  c13_.idUsersCreator AS idUsersCreator_155,
  c13_.idUsersChanger AS idUsersChanger_156,
  m14_.idMediaTypes AS idMediaTypes_157,
  m14_.idPreviewImage AS idPreviewImage_158,
  m14_.idCollections AS idCollections_159,
  m14_.idUsersCreator AS idUsersCreator_160,
  m14_.idUsersChanger AS idUsersChanger_161
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 = ?

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, c11_.firstName AS firstName_69, c11_.middleName AS middleName_70, c11_.lastName AS lastName_71, c11_.birthday AS birthday_72, c11_.salutation AS salutation_73, c11_.formOfAddress AS formOfAddress_74, c11_.newsletter AS newsletter_75, c11_.gender AS gender_76, c11_.note AS note_77, c11_.mainEmail AS mainEmail_78, c11_.mainPhone AS mainPhone_79, c11_.mainFax AS mainFax_80, c11_.mainUrl AS mainUrl_81, c11_.id AS id_82, c11_.created AS created_83, c11_.changed AS changed_84, s12_.username AS username_85, s12_.password AS password_86, s12_.locale AS locale_87, s12_.salt AS salt_88, s12_.locked AS locked_89, s12_.enabled AS enabled_90, s12_.lastLogin AS lastLogin_91, s12_.confirmationKey AS confirmationKey_92, s12_.passwordResetToken AS passwordResetToken_93, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_94, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_95, s12_.privateKey AS privateKey_96, s12_.apiKey AS apiKey_97, s12_.email AS email_98, s12_.id AS id_99, s12_.created AS created_100, s12_.changed AS changed_101, c13_.firstName AS firstName_102, c13_.middleName AS middleName_103, c13_.lastName AS lastName_104, c13_.birthday AS birthday_105, c13_.salutation AS salutation_106, c13_.formOfAddress AS formOfAddress_107, c13_.newsletter AS newsletter_108, c13_.gender AS gender_109, c13_.note AS note_110, c13_.mainEmail AS mainEmail_111, c13_.mainPhone AS mainPhone_112, c13_.mainFax AS mainFax_113, c13_.mainUrl AS mainUrl_114, c13_.id AS id_115, c13_.created AS created_116, c13_.changed AS changed_117, m14_.id AS id_118, m14_.created AS created_119, m14_.changed AS changed_120, m0_.idMediaTypes AS idMediaTypes_121, m0_.idPreviewImage AS idPreviewImage_122, m0_.idCollections AS idCollections_123, m0_.idUsersCreator AS idUsersCreator_124, m0_.idUsersChanger AS idUsersChanger_125, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_126, m2_.idCollectionTypes AS idCollectionTypes_127, m2_.idCollectionsParent AS idCollectionsParent_128, m2_.idUsersCreator AS idUsersCreator_129, m2_.idUsersChanger AS idUsersChanger_130, m3_.idMedia AS idMedia_131, m3_.idUsersCreator AS idUsersCreator_132, m3_.idUsersChanger AS idUsersChanger_133, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_134, m4_.idFiles AS idFiles_135, m4_.idUsersCreator AS idUsersCreator_136, m4_.idUsersChanger AS idUsersChanger_137, m5_.fileVersion AS fileVersion_138, m6_.idFileVersions AS idFileVersions_139, m7_.idFileVersions AS idFileVersions_140, m8_.idFileVersions AS idFileVersions_141, m9_.idFileVersions AS idFileVersions_142, s10_.idContacts AS idContacts_143, s10_.idUsersCreator AS idUsersCreator_144, s10_.idUsersChanger AS idUsersChanger_145, c11_.idTitles AS idTitles_146, c11_.avatar AS avatar_147, c11_.idUsersCreator AS idUsersCreator_148, c11_.idUsersChanger AS idUsersChanger_149, s12_.idContacts AS idContacts_150, s12_.idUsersCreator AS idUsersCreator_151, s12_.idUsersChanger AS idUsersChanger_152, c13_.idTitles AS idTitles_153, c13_.avatar AS avatar_154, c13_.idUsersCreator AS idUsersCreator_155, c13_.idUsersChanger AS idUsersChanger_156, m14_.idMediaTypes AS idMediaTypes_157, m14_.idPreviewImage AS idPreviewImage_158, m14_.idCollections AS idCollections_159, m14_.idUsersCreator AS idUsersCreator_160, m14_.idUsersChanger AS idUsersChanger_161 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 = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 84)
7	Sulu\Bundle\MediaBundle\Entity\MediaRepository->findMediaById (line 148)
8	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->getEntityById (line 141)
9	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->getById (line 59)
10	Sulu\Bundle\MediaBundle\Content\Types\SingleMediaSelection->getContentData (line 350)
11	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
12	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
13	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
14	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
15	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
16	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
17	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
18	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 69)

2.92 ms
(9.66%)

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, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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:

View formatted query View runnable query Explain query View query backtrace

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,
  c11_.firstName AS firstName_68,
  c11_.middleName AS middleName_69,
  c11_.lastName AS lastName_70,
  c11_.birthday AS birthday_71,
  c11_.salutation AS salutation_72,
  c11_.formOfAddress AS formOfAddress_73,
  c11_.newsletter AS newsletter_74,
  c11_.gender AS gender_75,
  c11_.note AS note_76,
  c11_.mainEmail AS mainEmail_77,
  c11_.mainPhone AS mainPhone_78,
  c11_.mainFax AS mainFax_79,
  c11_.mainUrl AS mainUrl_80,
  c11_.id AS id_81,
  c11_.created AS created_82,
  c11_.changed AS changed_83,
  s12_.username AS username_84,
  s12_.password AS password_85,
  s12_.locale AS locale_86,
  s12_.salt AS salt_87,
  s12_.locked AS locked_88,
  s12_.enabled AS enabled_89,
  s12_.lastLogin AS lastLogin_90,
  s12_.confirmationKey AS confirmationKey_91,
  s12_.passwordResetToken AS passwordResetToken_92,
  s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93,
  s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94,
  s12_.privateKey AS privateKey_95,
  s12_.apiKey AS apiKey_96,
  s12_.email AS email_97,
  s12_.id AS id_98,
  s12_.created AS created_99,
  s12_.changed AS changed_100,
  c13_.firstName AS firstName_101,
  c13_.middleName AS middleName_102,
  c13_.lastName AS lastName_103,
  c13_.birthday AS birthday_104,
  c13_.salutation AS salutation_105,
  c13_.formOfAddress AS formOfAddress_106,
  c13_.newsletter AS newsletter_107,
  c13_.gender AS gender_108,
  c13_.note AS note_109,
  c13_.mainEmail AS mainEmail_110,
  c13_.mainPhone AS mainPhone_111,
  c13_.mainFax AS mainFax_112,
  c13_.mainUrl AS mainUrl_113,
  c13_.id AS id_114,
  c13_.created AS created_115,
  c13_.changed AS changed_116,
  m0_.idMediaTypes AS idMediaTypes_117,
  m0_.idPreviewImage AS idPreviewImage_118,
  m0_.idCollections AS idCollections_119,
  m0_.idUsersCreator AS idUsersCreator_120,
  m0_.idUsersChanger AS idUsersChanger_121,
  m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122,
  m2_.idCollectionTypes AS idCollectionTypes_123,
  m2_.idCollectionsParent AS idCollectionsParent_124,
  m2_.idUsersCreator AS idUsersCreator_125,
  m2_.idUsersChanger AS idUsersChanger_126,
  m3_.idMedia AS idMedia_127,
  m3_.idUsersCreator AS idUsersCreator_128,
  m3_.idUsersChanger AS idUsersChanger_129,
  m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130,
  m4_.idFiles AS idFiles_131,
  m4_.idUsersCreator AS idUsersCreator_132,
  m4_.idUsersChanger AS idUsersChanger_133,
  t5_.idUsersCreator AS idUsersCreator_134,
  t5_.idUsersChanger AS idUsersChanger_135,
  m6_.idFileVersions AS idFileVersions_136,
  m7_.idFileVersions AS idFileVersions_137,
  m8_.idFileVersions AS idFileVersions_138,
  m9_.idFileVersions AS idFileVersions_139,
  s10_.idContacts AS idContacts_140,
  s10_.idUsersCreator AS idUsersCreator_141,
  s10_.idUsersChanger AS idUsersChanger_142,
  c11_.idTitles AS idTitles_143,
  c11_.avatar AS avatar_144,
  c11_.idUsersCreator AS idUsersCreator_145,
  c11_.idUsersChanger AS idUsersChanger_146,
  s12_.idContacts AS idContacts_147,
  s12_.idUsersCreator AS idUsersCreator_148,
  s12_.idUsersChanger AS idUsersChanger_149,
  c13_.idTitles AS idTitles_150,
  c13_.avatar AS avatar_151,
  c13_.idUsersCreator AS idUsersCreator_152,
  c13_.idUsersChanger AS idUsersChanger_153
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

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, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 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 (27280, 27279, 27277, 27274, 27276, 27275, 27269, 27282, 41962, 41886, 27284, 27286, 41833, 41839, 41936, 41998) ORDER BY m0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 227)
7	Sulu\Bundle\MediaBundle\Entity\MediaRepository->findMedia (line 159)
8	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->getByIds (line 108)
9	Sulu\Bundle\MediaBundle\Content\MediaSelectionContainer->loadData (line 94)
10	Sulu\Bundle\MediaBundle\Content\MediaSelectionContainer->getData (line 141)
11	Sulu\Bundle\MediaBundle\Content\Types\MediaSelectionContentType->getContentData (line 350)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
15	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
16	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
17	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
18	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
19	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.26 ms
(4.17%)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.enabled AS enabled_3, t0.approved AS approved_4, t0.approval_pending AS approval_pending_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.price AS price_8, t0.currency AS currency_9, t0.zip AS zip_10, t0.surface AS surface_11, t0.divisible_surface AS divisible_surface_12, t0.high AS high_13, t0.availability AS availability_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.brochure AS brochure_17, t0.visit_link AS visit_link_18, t0.unemployment AS unemployment_19, t0.area AS area_20, t0.population AS population_21, t0.geometry AS geometry_22, t0.construction_year AS construction_year_23, t0.offices_surface AS offices_surface_24, t0.etat AS etat_25, t0.transaction AS transaction_26, t0.rent_price AS rent_price_27, t0.price_on_demand AS price_on_demand_28, t0.charge AS charge_29, t0.tax AS tax_30, t0.divisible AS divisible_31, t0.created_by AS created_by_32, t0.rent_price_on_demand AS rent_price_on_demand_33, t0.contact_person_uuid AS contact_person_uuid_34, t0.created_from AS created_from_35, t0.included_charges AS included_charges_36, t0.property_taxes AS property_taxes_37, t0.owner_id AS owner_id_38, t39.id AS id_40, t39.unemployment AS unemployment_41, t39.population AS population_42, t39.capital AS capital_43, t39.professional AS professional_44, t39.industry AS industry_45, t39.bien_id AS bien_id_46, t0.owner_contact_id AS owner_contact_id_47, t0.member_contact_id AS member_contact_id_48 FROM bien t0 LEFT JOIN source t39 ON t39.bien_id = t0.id WHERE t0.id IN (?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.enabled AS enabled_3,
  t0.approved AS approved_4,
  t0.approval_pending AS approval_pending_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.price AS price_8,
  t0.currency AS currency_9,
  t0.zip AS zip_10,
  t0.surface AS surface_11,
  t0.divisible_surface AS divisible_surface_12,
  t0.high AS high_13,
  t0.availability AS availability_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.brochure AS brochure_17,
  t0.visit_link AS visit_link_18,
  t0.unemployment AS unemployment_19,
  t0.area AS area_20,
  t0.population AS population_21,
  t0.geometry AS geometry_22,
  t0.construction_year AS construction_year_23,
  t0.offices_surface AS offices_surface_24,
  t0.etat AS etat_25,
  t0.transaction AS transaction_26,
  t0.rent_price AS rent_price_27,
  t0.price_on_demand AS price_on_demand_28,
  t0.charge AS charge_29,
  t0.tax AS tax_30,
  t0.divisible AS divisible_31,
  t0.created_by AS created_by_32,
  t0.rent_price_on_demand AS rent_price_on_demand_33,
  t0.contact_person_uuid AS contact_person_uuid_34,
  t0.created_from AS created_from_35,
  t0.included_charges AS included_charges_36,
  t0.property_taxes AS property_taxes_37,
  t0.owner_id AS owner_id_38,
  t39.id AS id_40,
  t39.unemployment AS unemployment_41,
  t39.population AS population_42,
  t39.capital AS capital_43,
  t39.professional AS professional_44,
  t39.industry AS industry_45,
  t39.bien_id AS bien_id_46,
  t0.owner_contact_id AS owner_contact_id_47,
  t0.member_contact_id AS member_contact_id_48
FROM
  bien t0
  LEFT JOIN source t39 ON t39.bien_id = t0.id
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.enabled AS enabled_3, t0.approved AS approved_4, t0.approval_pending AS approval_pending_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.price AS price_8, t0.currency AS currency_9, t0.zip AS zip_10, t0.surface AS surface_11, t0.divisible_surface AS divisible_surface_12, t0.high AS high_13, t0.availability AS availability_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.brochure AS brochure_17, t0.visit_link AS visit_link_18, t0.unemployment AS unemployment_19, t0.area AS area_20, t0.population AS population_21, t0.geometry AS geometry_22, t0.construction_year AS construction_year_23, t0.offices_surface AS offices_surface_24, t0.etat AS etat_25, t0.transaction AS transaction_26, t0.rent_price AS rent_price_27, t0.price_on_demand AS price_on_demand_28, t0.charge AS charge_29, t0.tax AS tax_30, t0.divisible AS divisible_31, t0.created_by AS created_by_32, t0.rent_price_on_demand AS rent_price_on_demand_33, t0.contact_person_uuid AS contact_person_uuid_34, t0.created_from AS created_from_35, t0.included_charges AS included_charges_36, t0.property_taxes AS property_taxes_37, t0.owner_id AS owner_id_38, t39.id AS id_40, t39.unemployment AS unemployment_41, t39.population AS population_42, t39.capital AS capital_43, t39.professional AS professional_44, t39.industry AS industry_45, t39.bien_id AS bien_id_46, t0.owner_contact_id AS owner_contact_id_47, t0.member_contact_id AS member_contact_id_48 FROM bien t0 LEFT JOIN source t39 ON t39.bien_id = t0.id WHERE t0.id IN (229, 214, 241, 173, 139);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 34)
4	App\Content\Type\MultipleBienSelection->getContentData (line 350)
5	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
6	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
7	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
8	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
9	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
10	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
11	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
12	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 69)

1.05 ms
(3.47%)

SELECT m0_.id AS id_0, m1_.version AS version_1, m1_.name AS name_2, m2_.title AS title_3, m3_.title AS title_4 FROM me_media m0_ LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles AND (m1_.version = m4_.version) LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = ?) WHERE m0_.id IN (?)

Parameters:

[
  "en"
  52811
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m1_.version AS version_1,
  m1_.name AS name_2,
  m2_.title AS title_3,
  m3_.title AS title_4
FROM
  me_media m0_
  LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia
  LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles
  AND (m1_.version = m4_.version)
  LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id
  LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions
  AND (m2_.locale = ?)
WHERE
  m0_.id IN (?)

SELECT m0_.id AS id_0, m1_.version AS version_1, m1_.name AS name_2, m2_.title AS title_3, m3_.title AS title_4 FROM me_media m0_ LEFT JOIN me_files m4_ ON m0_.id = m4_.idMedia LEFT JOIN me_file_versions m1_ ON m4_.id = m1_.idFiles AND (m1_.version = m4_.version) LEFT JOIN me_file_version_meta m3_ ON m1_.idFileVersionsMetaDefault = m3_.id LEFT JOIN me_file_version_meta m2_ ON m1_.id = m2_.idFileVersions AND (m2_.locale = 'en') WHERE m0_.id IN (52811);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 247)
7	Sulu\Bundle\MediaBundle\Entity\MediaRepository->findMediaDisplayInfo (line 34)
8	Sulu\Bundle\MediaBundle\Markup\Link\MediaLinkProvider->preload (line 103)
9	Sulu\Component\Content\Types\Link->getContentData (line 135)
10	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 76)
11	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 75)
12	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 48)
13	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 1493)
18	Twig\Extension\CoreExtension::include (line 425)
19	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
20	Twig\Template->yieldBlock (line 132)
21	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
22	Twig\Template->yield (line 54)
23	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
24	Twig\Template->yield (line 344)
25	Twig\Template->display (line 359)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 334)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
31	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
32	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.53 ms
(1.74%)

SELECT path, parent FROM phpcr_nodes WHERE parent IN (?) AND workspace_name = ? ORDER BY sort_order ASC

Parameters:

[
  "/cmf/storm/routes/en"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/storm/routes/en') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1268)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1196)
4	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
5	Jackalope\ObjectManager->getNodeByPath (line 228)
6	Jackalope\Session->getNode (line 78)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
9	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
10	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
11	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
12	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
13	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
14	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
15	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
16	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
17	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
18	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
19	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
20	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
21	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.38 ms
(1.24%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="burger_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="burger_menu"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="burger_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 98)
9	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 425)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
16	Twig\Template->yieldBlock (line 132)
17	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
27	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
28	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.32 ms
(1.06%)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.address AS address_4, t0.description AS description_5, t0.country AS country_6, t0.city AS city_7, t0.district AS district_8, t0.activity_zone AS activity_zone_9, t0.access AS access_10, t0.created AS created_11, t0.changed AS changed_12, t0.bien_id AS bien_id_13, t0.idUsersCreator AS idUsersCreator_14, t0.idUsersChanger AS idUsersChanger_15 FROM bien_translation t0 WHERE t0.bien_id = ?

Parameters:

[
  229
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.title AS title_3,
  t0.address AS address_4,
  t0.description AS description_5,
  t0.country AS country_6,
  t0.city AS city_7,
  t0.district AS district_8,
  t0.activity_zone AS activity_zone_9,
  t0.access AS access_10,
  t0.created AS created_11,
  t0.changed AS changed_12,
  t0.bien_id AS bien_id_13,
  t0.idUsersCreator AS idUsersCreator_14,
  t0.idUsersChanger AS idUsersChanger_15
FROM
  bien_translation t0
WHERE
  t0.bien_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.title AS title_3, t0.address AS address_4, t0.description AS description_5, t0.country AS country_6, t0.city AS city_7, t0.district AS district_8, t0.activity_zone AS activity_zone_9, t0.access AS access_10, t0.created AS created_11, t0.changed AS changed_12, t0.bien_id AS bien_id_13, t0.idUsersCreator AS idUsersCreator_14, t0.idUsersChanger AS idUsersChanger_15 FROM bien_translation t0 WHERE t0.bien_id = 229;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 412)
8	Doctrine\ORM\PersistentCollection->containsKey (line 707)
9	App\Entity\Bien->getTranslation (line 285)
10	App\Entity\Bien->getTitle (line 315)
11	App\Entity\Bien->getSlugByLocale (line 1882)
12	Twig\Extension\CoreExtension::getAttribute (line 108)
13	__TwigTemplate_c0c1bd235d8a6d421eee74c965292514->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 1493)
18	Twig\Extension\CoreExtension::include (line 125)
19	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->block_content (line 432)
20	Twig\Template->yieldBlock (line 146)
21	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
22	Twig\Template->yield (line 54)
23	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
24	Twig\Template->yield (line 344)
25	Twig\Template->display (line 359)
26	Twig\Template->render (line 51)
27	Twig\TemplateWrapper->render (line 334)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
31	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
32	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.28 ms
(0.93%)

SELECT * FROM phpcr_nodes
              WHERE path = ?
                AND workspace_name = ?
              ORDER BY depth, sort_order ASC

Parameters:

[
  "/cmf/storm/routes/en"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/storm/routes/en'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1190)
2	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
3	Jackalope\ObjectManager->getNodeByPath (line 228)
4	Jackalope\Session->getNode (line 78)
5	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
6	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
7	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
8	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
19	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.28 ms
(0.92%)

SELECT t0.id AS id_1, t0.image AS image_2, t0.bien_id AS bien_id_3 FROM gallery t0 WHERE t0.bien_id = ?

Parameters:

[
  229
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.bien_id AS bien_id_3
FROM
  gallery t0
WHERE
  t0.bien_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.bien_id AS bien_id_3 FROM gallery t0 WHERE t0.bien_id = 229;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1928)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1869)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 1882)
8	Twig\Extension\CoreExtension::getAttribute (line 87)
9	__TwigTemplate_c0c1bd235d8a6d421eee74c965292514->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 125)
15	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->block_content (line 432)
16	Twig\Template->yieldBlock (line 146)
17	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
27	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
28	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.27 ms
(0.90%)

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 View query backtrace

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

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
;

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 1938)
3	Jackalope\Transport\DoctrineDBAL\Client->fetchUserNodeTypes (line 1889)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodeTypes (line 627)
5	Jackalope\ObjectManager->getNodeTypes (line 639)
6	Jackalope\ObjectManager->getNodeType (line 101)
7	Jackalope\NodeType\NodeTypeManager->fetchNodeTypes (line 219)
8	Jackalope\NodeType\NodeTypeManager->getNodeType (line 1287)
9	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1196)
10	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
11	Jackalope\ObjectManager->getNodeByPath (line 228)
12	Jackalope\Session->getNode (line 78)
13	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
14	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
15	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
16	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
17	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
18	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
19	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
20	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
21	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
22	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
23	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
24	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
25	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
26	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
27	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.26 ms
(0.84%)

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 = ?) ORDER BY sort_order ASC

Parameters:

[
  "default_live"
  "/cmf/storm/contents/acheter"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?)
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/storm/contents/acheter') ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1344)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
3	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
4	Jackalope\NodePathIterator->loadBatch (line 45)
5	Jackalope\NodePathIterator->__construct (line 243)
6	Jackalope\ObjectManager->getNodesByPath (line 252)
7	Jackalope\Session->getNodes (line 83)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
10	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
11	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
12	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
13	Sulu\Component\Cache\Memoize->memoizeById (line 51)
14	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 95)
15	__TwigTemplate_e91ad1ce277d6967ed6029ef69d51262->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 1493)
20	Twig\Extension\CoreExtension::include (line 429)
21	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
22	Twig\Template->yieldBlock (line 132)
23	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
26	Twig\Template->yield (line 344)
27	Twig\Template->display (line 359)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 334)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
33	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
34	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.23 ms
(0.76%)

SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 449)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
10	Doctrine\ORM\AbstractQuery->execute (line 997)
11	Doctrine\ORM\AbstractQuery->getSingleResult (line 84)
12	Sulu\Bundle\MediaBundle\Entity\MediaRepository->findMediaById (line 148)
13	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->getEntityById (line 141)
14	Sulu\Bundle\MediaBundle\Media\Manager\MediaManager->getById (line 59)
15	Sulu\Bundle\MediaBundle\Content\Types\SingleMediaSelection->getContentData (line 350)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
20	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
21	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
23	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.20 ms
(0.65%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_3"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_3"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_3"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 154)
9	__TwigTemplate_16da3df581a55b2f5ca3db9a656b71fd->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 152)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
26	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.18 ms
(0.58%)

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 = '08b7eb09-c860-4b58-8250-d2d2a5562c2c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = '08b7eb09-c860-4b58-8250-d2d2a5562c2c'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '08b7eb09-c860-4b58-8250-d2d2a5562c2c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 350)
9	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
10	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
11	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
15	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
16	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
17	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
18	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
19	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.16 ms
(0.55%)

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 = ?) ORDER BY sort_order ASC

Parameters:

[
  "default_live"
  "/cmf/storm/contents/louer"
  "/cmf/storm/contents/about-us"
  "/cmf/storm/contents/buy"
  "/cmf/storm/contents/contact-us"
  "/cmf/storm/contents/storm-map"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?
  )
ORDER BY
  sort_order ASC

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/storm/contents/louer' OR path = '/cmf/storm/contents/about-us' OR path = '/cmf/storm/contents/buy' OR path = '/cmf/storm/contents/contact-us' OR path = '/cmf/storm/contents/storm-map') ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1344)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
3	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
4	Jackalope\NodePathIterator->loadBatch (line 45)
5	Jackalope\NodePathIterator->__construct (line 243)
6	Jackalope\ObjectManager->getNodesByPath (line 252)
7	Jackalope\Session->getNodes (line 83)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
10	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
11	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
12	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
13	Sulu\Component\Cache\Memoize->memoizeById (line 51)
14	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 98)
15	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 1493)
20	Twig\Extension\CoreExtension::include (line 425)
21	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
22	Twig\Template->yieldBlock (line 132)
23	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
24	Twig\Template->yield (line 54)
25	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
26	Twig\Template->yield (line 344)
27	Twig\Template->display (line 359)
28	Twig\Template->render (line 51)
29	Twig\TemplateWrapper->render (line 334)
30	Twig\Environment->render (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
33	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
34	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
37	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.15 ms
(0.48%)

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"
  "50b63966-c0f8-4510-af86-a75cd8ace8a7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  path,
  parent,
  local_name,
  namespace,
  workspace_name,
  identifier,
  type,
  props,
  depth,
  sort_order
FROM
  phpcr_nodes
WHERE
  workspace_name = ?
  AND identifier IN (?)

SELECT id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
            FROM phpcr_nodes WHERE workspace_name = 'default_live' AND identifier IN ('50b63966-c0f8-4510-af86-a75cd8ace8a7');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1439)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesByIdentifier (line 581)
4	Jackalope\ObjectManager->getNodesByIdentifier (line 790)
5	Jackalope\Property->getReferencedNodes (line 424)
6	Jackalope\Property->getNode (line 211)
7	Jackalope\Property->getValue (line 763)
8	Jackalope\Node->getPropertyValue (line 253)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
19	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.15 ms
(0.48%)

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 = '7e797d2e-78cd-44b8-b673-e3c26761deaf' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = '7e797d2e-78cd-44b8-b673-e3c26761deaf'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '7e797d2e-78cd-44b8-b673-e3c26761deaf' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 350)
9	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
10	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
11	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
12	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
13	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
14	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
15	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
16	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.13 ms
(0.45%)

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/storm/contents/acheter' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/acheter'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/acheter' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 350)
13	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
14	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
15	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
20	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
21	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
23	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.12 ms
(0.39%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="service_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="service_menu"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="service_menu"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 95)
9	__TwigTemplate_e91ad1ce277d6967ed6029ef69d51262->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 429)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
16	Twig\Template->yieldBlock (line 132)
17	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
27	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
28	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.11 ms
(0.38%)

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 = '40c0b0b0-0c90-4f0c-81fd-fbce8da947b1' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = '40c0b0b0-0c90-4f0c-81fd-fbce8da947b1'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '40c0b0b0-0c90-4f0c-81fd-fbce8da947b1' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 350)
9	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
10	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
11	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
15	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
16	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
17	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
18	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
19	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.11 ms
(0.36%)

SELECT 1 FROM phpcr_workspaces WHERE name = ?

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 958)
2	Doctrine\DBAL\Connection->fetchFirstColumn (line 400)
3	Jackalope\Transport\DoctrineDBAL\Client->workspaceExists (line 333)
4	Jackalope\Transport\DoctrineDBAL\Client->login (line 438)
5	Jackalope\Transport\DoctrineDBAL\Client->assertLoggedIn (line 1167)
6	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
7	Jackalope\ObjectManager->getNodeByPath (line 228)
8	Jackalope\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
11	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
12	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
13	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
14	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
15	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
16	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
17	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
18	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
19	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
20	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
21	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
22	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
23	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.11 ms
(0.36%)

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/storm/contents/louer' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/louer'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/louer' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 350)
13	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
14	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
15	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
16	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
17	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
18	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
20	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.11 ms
(0.35%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_2"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_2"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_2"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 131)
9	__TwigTemplate_16da3df581a55b2f5ca3db9a656b71fd->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 152)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
26	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.10 ms
(0.32%)

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/storm/contents/actualites/food-sovereignty-smart-agro-warehouses-reinventing-our-strategic-autonomy"
  "/cmf/storm/contents/actualites/rare-metals-the-underground-silicon-valley-reshaping-european-geopolitics"
  "/cmf/storm/contents/actualites/dark-stores-2-0-the-chameleon-infrastructure-reshaping-urban-real-estate-dynamics"
  "/cmf/storm/contents/actualites/logistics-real-estate-2025-the-new-frontiers-of-the-french-supply-chain"
]

View formatted query View runnable query Explain query View query backtrace

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

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = 'default_live' AND (path = '/cmf/storm/contents/actualites/food-sovereignty-smart-agro-warehouses-reinventing-our-strategic-autonomy' OR path = '/cmf/storm/contents/actualites/rare-metals-the-underground-silicon-valley-reshaping-european-geopolitics' OR path = '/cmf/storm/contents/actualites/dark-stores-2-0-the-chameleon-infrastructure-reshaping-urban-real-estate-dynamics' OR path = '/cmf/storm/contents/actualites/logistics-real-estate-2025-the-new-frontiers-of-the-french-supply-chain') ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1344)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
3	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
4	Jackalope\NodePathIterator->loadBatch (line 45)
5	Jackalope\NodePathIterator->__construct (line 243)
6	Jackalope\ObjectManager->getNodesByPath (line 252)
7	Jackalope\Session->getNodes (line 83)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
10	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 147)
11	Sulu\Bundle\PageBundle\Content\PageSelectionContainer->loadData (line 127)
12	Sulu\Bundle\PageBundle\Content\PageSelectionContainer->getData (line 131)
13	Sulu\Bundle\PageBundle\Content\Types\PageSelection->getContentData (line 350)
14	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
15	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
16	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
17	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
18	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
20	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
21	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.09 ms
(0.31%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND (((n0.identifier = '5fddce57-01e8-441a-8a14-8a3babf30c1d' OR n0.identifier = '87f00fba-d2f2-4341-a558-7b660ca3876e') OR n0.identifier = '80787cdb-307b-4cd3-a17d-183c805229e6') OR n0.identifier = '48cab57c-d828-4363-a0e8-8de7155c3638'))) 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 View query backtrace

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:en-state"]/sv:value'
            ),
            ' ',
            ','
          )
        )
        OR EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
        ) = '1'
      )
      AND (
        (
          (
            n0.identifier = '5fddce57-01e8-441a-8a14-8a3babf30c1d'
            OR n0.identifier = '87f00fba-d2f2-4341-a558-7b660ca3876e'
          )
          OR n0.identifier = '80787cdb-307b-4cd3-a17d-183c805229e6'
        )
        OR n0.identifier = '48cab57c-d828-4363-a0e8-8de7155c3638'
      )
    )
  )
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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND (((n0.identifier = '5fddce57-01e8-441a-8a14-8a3babf30c1d' OR n0.identifier = '87f00fba-d2f2-4341-a558-7b660ca3876e') OR n0.identifier = '80787cdb-307b-4cd3-a17d-183c805229e6') OR n0.identifier = '48cab57c-d828-4363-a0e8-8de7155c3638'))) 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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 147)
5	Sulu\Bundle\PageBundle\Content\PageSelectionContainer->loadData (line 127)
6	Sulu\Bundle\PageBundle\Content\PageSelectionContainer->getData (line 131)
7	Sulu\Bundle\PageBundle\Content\Types\PageSelection->getContentData (line 350)
8	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
9	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
10	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
11	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
12	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
13	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
14	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
15	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.09 ms
(0.31%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="main"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 117)
9	__TwigTemplate_e91ad1ce277d6967ed6029ef69d51262->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 429)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
16	Twig\Template->yieldBlock (line 132)
17	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
18	Twig\Template->yield (line 54)
19	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
27	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
28	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.09 ms
(0.28%)

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 = '41324a71-e4ed-4921-8b5c-10de041756ff' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = '41324a71-e4ed-4921-8b5c-10de041756ff'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '41324a71-e4ed-4921-8b5c-10de041756ff' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 350)
9	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
10	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
11	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
12	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
13	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
14	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
15	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
16	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.08 ms
(0.28%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_4"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_4"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_4"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 177)
9	__TwigTemplate_16da3df581a55b2f5ca3db9a656b71fd->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 152)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
26	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.08 ms
(0.26%)

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/storm/contents/actualites' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/actualites'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/actualites' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 350)
13	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
14	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
15	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
16	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
17	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
18	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
19	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
20	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.08 ms
(0.26%)

SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC

Parameters:

[
  "/cmf/storm/contents/louer"
  "/cmf/storm/contents/about-us"
  "/cmf/storm/contents/buy"
  "/cmf/storm/contents/contact-us"
  "/cmf/storm/contents/storm-map"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/storm/contents/louer', '/cmf/storm/contents/about-us', '/cmf/storm/contents/buy', '/cmf/storm/contents/contact-us', '/cmf/storm/contents/storm-map') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1268)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1355)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
5	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
6	Jackalope\NodePathIterator->loadBatch (line 45)
7	Jackalope\NodePathIterator->__construct (line 243)
8	Jackalope\ObjectManager->getNodesByPath (line 252)
9	Jackalope\Session->getNodes (line 83)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
11	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
12	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
13	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
14	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
15	Sulu\Component\Cache\Memoize->memoizeById (line 51)
16	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 98)
17	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 1493)
22	Twig\Extension\CoreExtension::include (line 425)
23	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
24	Twig\Template->yieldBlock (line 132)
25	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
26	Twig\Template->yield (line 54)
27	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
28	Twig\Template->yield (line 344)
29	Twig\Template->display (line 359)
30	Twig\Template->render (line 51)
31	Twig\TemplateWrapper->render (line 334)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
35	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
36	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
39	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.08 ms
(0.25%)

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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_1"]) > 0')) AND n0.path LIKE '/cmf/storm/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 View query backtrace

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:en-state"]/sv:value'
              ),
              ' ',
              ','
            )
          )
          OR EXTRACTVALUE(
            n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]'
          ) = '1'
        )
        AND EXTRACTVALUE(
          n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_1"]) > 0'
        )
      )
      AND n0.path LIKE '/cmf/storm/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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' 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:en-state"]/sv:value'), ' ', ',')) OR EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-shadow-on"]/sv:value[1]') = '1') AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:en-navContexts"]/sv:value[text()="footer_menu_1"]) > 0')) AND n0.path LIKE '/cmf/storm/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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 54)
4	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 144)
5	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 82)
6	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 67)
7	Sulu\Component\Cache\Memoize->memoizeById (line 51)
8	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 108)
9	__TwigTemplate_16da3df581a55b2f5ca3db9a656b71fd->doDisplay (line 388)
10	Twig\Template->yield (line 344)
11	Twig\Template->display (line 359)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 1493)
14	Twig\Extension\CoreExtension::include (line 152)
15	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
16	Twig\Template->yield (line 54)
17	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
18	Twig\Template->yield (line 344)
19	Twig\Template->display (line 359)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 334)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
26	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.07 ms
(0.23%)

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:

[
  "storm-preprod.ewm.dev/{localization}"
  "dev"
  "storm"
]

View formatted query View runnable query Explain query View query backtrace

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

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 = 'storm-preprod.ewm.dev/{localization}' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'storm' ORDER BY w0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 66)
7	Sulu\Bundle\WebsiteBundle\Entity\AnalyticsRepository->findByUrl (line 109)
8	Sulu\Bundle\WebsiteBundle\EventListener\AppendAnalyticsListener->onResponse (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 216)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.06 ms
(0.21%)

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 = 'fe2c557b-08ba-49d8-bb7c-156b6abd9e0c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = 'fe2c557b-08ba-49d8-bb7c-156b6abd9e0c'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = 'fe2c557b-08ba-49d8-bb7c-156b6abd9e0c' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 135)
9	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 76)
10	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 75)
11	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 48)
12	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1493)
17	Twig\Extension\CoreExtension::include (line 425)
18	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
19	Twig\Template->yieldBlock (line 132)
20	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
30	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
31	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.06 ms
(0.20%)

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 = '7364f4a9-26d2-4687-9e51-ccbdd5f32b33' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = '7364f4a9-26d2-4687-9e51-ccbdd5f32b33'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '7364f4a9-26d2-4687-9e51-ccbdd5f32b33' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 350)
9	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
10	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
11	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
15	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
16	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
17	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
18	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
19	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.06 ms
(0.19%)

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/storm/contents/profile-settings' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/profile-settings'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/profile-settings' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 135)
13	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 76)
14	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 75)
15	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 48)
16	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1493)
21	Twig\Extension\CoreExtension::include (line 425)
22	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
23	Twig\Template->yieldBlock (line 132)
24	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
27	Twig\Template->yield (line 344)
28	Twig\Template->display (line 359)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 334)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
34	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
35	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.06 ms
(0.19%)

SELECT path, parent FROM phpcr_nodes WHERE parent IN (?, ?, ?, ?) AND workspace_name = ? ORDER BY sort_order ASC

Parameters:

[
  "/cmf/storm/contents/actualites/food-sovereignty-smart-agro-warehouses-reinventing-our-strategic-autonomy"
  "/cmf/storm/contents/actualites/rare-metals-the-underground-silicon-valley-reshaping-european-geopolitics"
  "/cmf/storm/contents/actualites/dark-stores-2-0-the-chameleon-infrastructure-reshaping-urban-real-estate-dynamics"
  "/cmf/storm/contents/actualites/logistics-real-estate-2025-the-new-frontiers-of-the-french-supply-chain"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?, ?, ?, ?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/storm/contents/actualites/food-sovereignty-smart-agro-warehouses-reinventing-our-strategic-autonomy', '/cmf/storm/contents/actualites/rare-metals-the-underground-silicon-valley-reshaping-european-geopolitics', '/cmf/storm/contents/actualites/dark-stores-2-0-the-chameleon-infrastructure-reshaping-urban-real-estate-dynamics', '/cmf/storm/contents/actualites/logistics-real-estate-2025-the-new-frontiers-of-the-french-supply-chain') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1268)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1355)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 285)
5	Jackalope\ObjectManager->getNodesByPathAsArray (line 130)
6	Jackalope\NodePathIterator->loadBatch (line 45)
7	Jackalope\NodePathIterator->__construct (line 243)
8	Jackalope\ObjectManager->getNodesByPath (line 252)
9	Jackalope\Session->getNodes (line 83)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
11	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 79)
12	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 147)
13	Sulu\Bundle\PageBundle\Content\PageSelectionContainer->loadData (line 127)
14	Sulu\Bundle\PageBundle\Content\PageSelectionContainer->getData (line 131)
15	Sulu\Bundle\PageBundle\Content\Types\PageSelection->getContentData (line 350)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
20	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
21	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
23	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.06 ms
(0.18%)

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 = '35e8121f-c8e9-4cc7-8ff5-9cd381abbf42' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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 View query backtrace

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 = '35e8121f-c8e9-4cc7-8ff5-9cd381abbf42'
    AND 0 != FIND_IN_SET(
      '2',
      REPLACE(
        EXTRACTVALUE(
          n0.props, '//sv:property[@sv:name="i18n:en-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

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.identifier = '35e8121f-c8e9-4cc7-8ff5-9cd381abbf42' AND 0 != FIND_IN_SET('2', REPLACE(EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:en-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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
6	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
7	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
8	Sulu\Component\Content\Types\Link->getContentData (line 135)
9	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 76)
10	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 75)
11	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 48)
12	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
13	Twig\Template->yield (line 344)
14	Twig\Template->display (line 359)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 1493)
17	Twig\Extension\CoreExtension::include (line 425)
18	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
19	Twig\Template->yieldBlock (line 132)
20	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
21	Twig\Template->yield (line 54)
22	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
23	Twig\Template->yield (line 344)
24	Twig\Template->display (line 359)
25	Twig\Template->render (line 51)
26	Twig\TemplateWrapper->render (line 334)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
30	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
31	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.05 ms
(0.18%)

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/storm/contents/storm-map' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/storm-map'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/storm-map' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 350)
13	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
14	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
15	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
20	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
21	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
23	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.05 ms
(0.18%)

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/storm/contents/connexion' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/connexion'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/connexion' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 135)
13	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 76)
14	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 75)
15	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 48)
16	__TwigTemplate_04bd907dd1cef4ac494cfad73f1b1d5f->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 1493)
21	Twig\Extension\CoreExtension::include (line 425)
22	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->block_includes (line 432)
23	Twig\Template->yieldBlock (line 132)
24	__TwigTemplate_9d73c8cb19e13b615dce5c46e439005b->doDisplay (line 388)
25	Twig\Template->yield (line 54)
26	__TwigTemplate_08f45bdc4fe85825a4a74d19557b22c5->doDisplay (line 388)
27	Twig\Template->yield (line 344)
28	Twig\Template->display (line 359)
29	Twig\Template->render (line 51)
30	Twig\TemplateWrapper->render (line 334)
31	Twig\Environment->render (line 431)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 229)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 77)
34	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
35	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
36	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
37	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
38	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.05 ms
(0.17%)

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/storm/contents/inscription' LIMIT 1

Parameters:

[
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

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/storm/contents/inscription'
LIMIT
  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 = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND n0.parent = '/cmf/storm/contents/inscription' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 2174)
2	Jackalope\Transport\DoctrineDBAL\Client->query (line 89)
3	Jackalope\Query\Query->execute (line 436)
4	PHPCR\Util\QOM\QueryBuilder->execute (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 400)
7	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 1)
8	array_map (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 228)
10	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 64)
11	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 103)
12	Sulu\Component\Content\Types\Link->getContentData (line 350)
13	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
14	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
15	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 401)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 347)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 135)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 83)
20	Sulu\Bundle\WebsiteBundle\Resolver\ParameterResolver->resolve (line 111)
21	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->getAttributes (line 62)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 33)
23	Sulu\Bundle\WebsiteBundle\Controller\DefaultController->indexAction (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 69)

0.05 ms
(0.16%)

SELECT prefix, uri FROM phpcr_namespaces

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 517)
2	Jackalope\Transport\DoctrineDBAL\Client->getNamespacesObject (line 507)
3	Jackalope\Transport\DoctrineDBAL\Client->getNamespaces (line 502)
4	Jackalope\Transport\DoctrineDBAL\Client->getNamespacePrefixes (line 1168)
5	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 189)
6	Jackalope\ObjectManager->getNodeByPath (line 228)
7	Jackalope\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 35)
10	Sulu\Component\PHPCR\SessionManager\SessionManager->getRouteNode (line 371)
11	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->getWebspaceRouteNode (line 244)
12	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 207)
13	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 153)
14	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 97)
15	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 203)
16	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 69)
17	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 161)
18	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 134)
19	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 101)
20	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 58)
21	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 246)
22	Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure} (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 69)

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.

Entities Mapping

Class	Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	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\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\SecurityBundle\Entity\User	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionMeta	No errors.
Sulu\Bundle\MediaBundle\Entity\CollectionType	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserGroup	No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact	No errors.
Sulu\Bundle\ContactBundle\Entity\Url	No errors.
Sulu\Bundle\ContactBundle\Entity\Note	No errors.
Sulu\Bundle\ContactBundle\Entity\Email	No errors.
Sulu\Bundle\ContactBundle\Entity\Phone	No errors.
Sulu\Bundle\ContactBundle\Entity\Fax	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile	No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount	No errors.
App\Entity\Bien	No errors.
App\Entity\Owner	No errors.
App\Entity\Source	No errors.
App\Entity\Member	No errors.
App\Entity\BienTranslation	No errors.
App\Entity\Gallery	No errors.
App\Entity\File	No errors.
App\Entity\Category	No errors.
App\Entity\Detail	No errors.
App\Entity\Population	No errors.
App\Entity\Capital	No errors.
App\Entity\Professional	No errors.
App\Entity\Industry	No errors.
App\Entity\Equipment	No errors.
App\Entity\Certification	No errors.
App\Entity\Broker	No errors.
App\Entity\PropertyPublished	No errors.
App\Entity\HistoricPublishedProperty	No errors.
App\Entity\Statistic	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://storm-preprod.ewm.dev/en

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping