Symfony Profiler

Query Metrics

386 Database Queries

31 Different statements

287.99 ms Query time

0 Invalid entities

373 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

49.54 ms
(17.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 ((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/website/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/website/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/website/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	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 54)
4	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 144)
5	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 82)
6	Sulu\Component\Cache\Memoize->memoizeById (line 67)
7	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 51)
8	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_header (line 236)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 112)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
22	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
23	App\Controller\Website\DefaultController->indexAction (line 58)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	App\DualKernel->handle (line 38)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 16)

37.47 ms
(13.01%)

SELECT t0.firstName AS firstName_1, t0.middleName AS middleName_2, t0.lastName AS lastName_3, t0.birthday AS birthday_4, t0.salutation AS salutation_5, t0.formOfAddress AS formOfAddress_6, t0.newsletter AS newsletter_7, t0.gender AS gender_8, t0.note AS note_9, t0.mainEmail AS mainEmail_10, t0.mainPhone AS mainPhone_11, t0.mainFax AS mainFax_12, t0.mainUrl AS mainUrl_13, t0.id AS id_14, t0.created AS created_15, t0.changed AS changed_16, t0.idTitles AS idTitles_17, t0.avatar AS avatar_18, t0.idUsersCreator AS idUsersCreator_19, t0.idUsersChanger AS idUsersChanger_20, t0.location_id AS location_id_21 FROM co_contacts t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.firstName AS firstName_1,
  t0.middleName AS middleName_2,
  t0.lastName AS lastName_3,
  t0.birthday AS birthday_4,
  t0.salutation AS salutation_5,
  t0.formOfAddress AS formOfAddress_6,
  t0.newsletter AS newsletter_7,
  t0.gender AS gender_8,
  t0.note AS note_9,
  t0.mainEmail AS mainEmail_10,
  t0.mainPhone AS mainPhone_11,
  t0.mainFax AS mainFax_12,
  t0.mainUrl AS mainUrl_13,
  t0.id AS id_14,
  t0.created AS created_15,
  t0.changed AS changed_16,
  t0.idTitles AS idTitles_17,
  t0.avatar AS avatar_18,
  t0.idUsersCreator AS idUsersCreator_19,
  t0.idUsersChanger AS idUsersChanger_20,
  t0.location_id AS location_id_21
FROM
  co_contacts t0
WHERE
  t0.id = ?

SELECT t0.firstName AS firstName_1, t0.middleName AS middleName_2, t0.lastName AS lastName_3, t0.birthday AS birthday_4, t0.salutation AS salutation_5, t0.formOfAddress AS formOfAddress_6, t0.newsletter AS newsletter_7, t0.gender AS gender_8, t0.note AS note_9, t0.mainEmail AS mainEmail_10, t0.mainPhone AS mainPhone_11, t0.mainFax AS mainFax_12, t0.mainUrl AS mainUrl_13, t0.id AS id_14, t0.created AS created_15, t0.changed AS changed_16, t0.idTitles AS idTitles_17, t0.avatar AS avatar_18, t0.idUsersCreator AS idUsersCreator_19, t0.idUsersChanger AS idUsersChanger_20, t0.location_id AS location_id_21 FROM co_contacts t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\App\Entity\Contact::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Contact->__get (line 146)
7	Sulu\Bundle\ContactBundle\Entity\Contact->getFullName (line 335)
8	Sulu\Bundle\ContactBundle\Api\AccountContact->getContact (line 104)
9	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
10	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
11	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
12	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
13	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
14	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
15	JMS\Serializer\Serializer->visit (line 256)
16	JMS\Serializer\Serializer->toArray (line 202)
17	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
18	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
19	array_map (line 129)
20	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
21	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
22	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
23	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
24	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
25	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
26	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
27	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
28	Twig\Template->yieldBlock (line 446)
29	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
30	Twig\Template->yield (line 402)
31	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
32	Twig\Template->yield (line 402)
33	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
34	Twig\Template->yield (line 402)
35	Twig\Template->display (line 358)
36	Twig\Template->render (line 373)
37	Twig\TemplateWrapper->render (line 51)
38	Twig\Environment->render (line 333)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
41	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
42	App\Controller\Website\DefaultController->indexAction (line 58)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
45	Symfony\Component\HttpKernel\Kernel->handle (line 182)
46	App\DualKernel->handle (line 38)
47	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
48	require_once (line 29)
49	require_once (line 16)

36.50 ms
(12.67%)

SELECT t0.main AS main_1, t0.id AS id_2, t0.idPositions AS idPositions_3, t0.idContacts AS idContacts_4, t0.idAccounts AS idAccounts_5 FROM co_account_contacts t0 WHERE t0.idContacts = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.main AS main_1,
  t0.id AS id_2,
  t0.idPositions AS idPositions_3,
  t0.idContacts AS idContacts_4,
  t0.idAccounts AS idAccounts_5
FROM
  co_account_contacts t0
WHERE
  t0.idContacts = ?

SELECT t0.main AS main_1, t0.id AS id_2, t0.idPositions AS idPositions_3, t0.idContacts AS idContacts_4, t0.idAccounts AS idAccounts_5 FROM co_account_contacts t0 WHERE t0.idContacts = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Sulu\Bundle\ContactBundle\Entity\Contact->getMainAccountContact (line 673)
8	Sulu\Bundle\ContactBundle\Entity\Contact->getPosition (line 364)
9	Sulu\Bundle\ContactBundle\Api\Contact->getPosition (line 251)
10	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
11	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
12	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
13	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
14	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
15	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
16	JMS\Serializer\Serializer->visit (line 256)
17	JMS\Serializer\Serializer->toArray (line 202)
18	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
19	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
20	array_map (line 129)
21	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
22	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
23	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
24	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
25	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
26	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
27	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
28	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
29	Twig\Template->yieldBlock (line 446)
30	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
33	Twig\Template->yield (line 402)
34	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
35	Twig\Template->yield (line 402)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 373)
38	Twig\TemplateWrapper->render (line 51)
39	Twig\Environment->render (line 333)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
42	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
43	App\Controller\Website\DefaultController->indexAction (line 58)
44	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
46	Symfony\Component\HttpKernel\Kernel->handle (line 182)
47	App\DualKernel->handle (line 38)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
49	require_once (line 29)
50	require_once (line 16)

33.65 ms
(11.69%)

SELECT f0_.defaultLocale AS defaultLocale_0, f0_.id AS id_1, f1_.title AS title_2, f1_.subject AS subject_3, f1_.fromEmail AS fromEmail_4, f1_.fromName AS fromName_5, f1_.toEmail AS toEmail_6, f1_.toName AS toName_7, f1_.mailText AS mailText_8, f1_.submitLabel AS submitLabel_9, f1_.successText AS successText_10, f1_.sendAttachments AS sendAttachments_11, f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12, f1_.deactivateNotifyMails AS deactivateNotifyMails_13, f1_.deactivateCustomerMails AS deactivateCustomerMails_14, f1_.replyTo AS replyTo_15, f1_.locale AS locale_16, f1_.id AS id_17, f1_.created AS created_18, f1_.changed AS changed_19, f2_.keyName AS keyName_20, f2_.orderNumber AS orderNumber_21, f2_.type AS type_22, f2_.width AS width_23, f2_.required AS required_24, f2_.defaultLocale AS defaultLocale_25, f2_.id AS id_26, f3_.title AS title_27, f3_.placeholder AS placeholder_28, f3_.defaultValue AS defaultValue_29, f3_.shortTitle AS shortTitle_30, f3_.locale AS locale_31, f3_.options AS options_32, f3_.id AS id_33, f4_.type AS type_34, f4_.email AS email_35, f4_.name AS name_36, f4_.id AS id_37, f1_.idForms AS idForms_38, f1_.idUsersCreator AS idUsersCreator_39, f1_.idUsersChanger AS idUsersChanger_40, f2_.idForms AS idForms_41, f3_.idFormFields AS idFormFields_42, f4_.idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations WHERE f0_.id = ? ORDER BY f2_.orderNumber ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.defaultLocale AS defaultLocale_0,
  f0_.id AS id_1,
  f1_.title AS title_2,
  f1_.subject AS subject_3,
  f1_.fromEmail AS fromEmail_4,
  f1_.fromName AS fromName_5,
  f1_.toEmail AS toEmail_6,
  f1_.toName AS toName_7,
  f1_.mailText AS mailText_8,
  f1_.submitLabel AS submitLabel_9,
  f1_.successText AS successText_10,
  f1_.sendAttachments AS sendAttachments_11,
  f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12,
  f1_.deactivateNotifyMails AS deactivateNotifyMails_13,
  f1_.deactivateCustomerMails AS deactivateCustomerMails_14,
  f1_.replyTo AS replyTo_15,
  f1_.locale AS locale_16,
  f1_.id AS id_17,
  f1_.created AS created_18,
  f1_.changed AS changed_19,
  f2_.keyName AS keyName_20,
  f2_.orderNumber AS orderNumber_21,
  f2_.type AS type_22,
  f2_.width AS width_23,
  f2_.required AS required_24,
  f2_.defaultLocale AS defaultLocale_25,
  f2_.id AS id_26,
  f3_.title AS title_27,
  f3_.placeholder AS placeholder_28,
  f3_.defaultValue AS defaultValue_29,
  f3_.shortTitle AS shortTitle_30,
  f3_.locale AS locale_31,
  f3_.options AS options_32,
  f3_.id AS id_33,
  f4_.type AS type_34,
  f4_.email AS email_35,
  f4_.name AS name_36,
  f4_.id AS id_37,
  f1_.idForms AS idForms_38,
  f1_.idUsersCreator AS idUsersCreator_39,
  f1_.idUsersChanger AS idUsersChanger_40,
  f2_.idForms AS idForms_41,
  f3_.idFormFields AS idFormFields_42,
  f4_.idFormTranslations AS idFormTranslations_43
FROM
  fo_forms f0_
  LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms
  LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms
  LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields
  LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations
WHERE
  f0_.id = ?
ORDER BY
  f2_.orderNumber ASC

SELECT f0_.defaultLocale AS defaultLocale_0, f0_.id AS id_1, f1_.title AS title_2, f1_.subject AS subject_3, f1_.fromEmail AS fromEmail_4, f1_.fromName AS fromName_5, f1_.toEmail AS toEmail_6, f1_.toName AS toName_7, f1_.mailText AS mailText_8, f1_.submitLabel AS submitLabel_9, f1_.successText AS successText_10, f1_.sendAttachments AS sendAttachments_11, f1_.deactivateAttachmentSave AS deactivateAttachmentSave_12, f1_.deactivateNotifyMails AS deactivateNotifyMails_13, f1_.deactivateCustomerMails AS deactivateCustomerMails_14, f1_.replyTo AS replyTo_15, f1_.locale AS locale_16, f1_.id AS id_17, f1_.created AS created_18, f1_.changed AS changed_19, f2_.keyName AS keyName_20, f2_.orderNumber AS orderNumber_21, f2_.type AS type_22, f2_.width AS width_23, f2_.required AS required_24, f2_.defaultLocale AS defaultLocale_25, f2_.id AS id_26, f3_.title AS title_27, f3_.placeholder AS placeholder_28, f3_.defaultValue AS defaultValue_29, f3_.shortTitle AS shortTitle_30, f3_.locale AS locale_31, f3_.options AS options_32, f3_.id AS id_33, f4_.type AS type_34, f4_.email AS email_35, f4_.name AS name_36, f4_.id AS id_37, f1_.idForms AS idForms_38, f1_.idUsersCreator AS idUsersCreator_39, f1_.idUsersChanger AS idUsersChanger_40, f2_.idForms AS idForms_41, f3_.idFormFields AS idFormFields_42, f4_.idFormTranslations AS idFormTranslations_43 FROM fo_forms f0_ LEFT JOIN fo_form_translations f1_ ON f0_.id = f1_.idForms LEFT JOIN fo_form_fields f2_ ON f0_.id = f2_.idForms LEFT JOIN fo_form_field_translations f3_ ON f2_.id = f3_.idFormFields LEFT JOIN fo_form_translation_receivers f4_ ON f1_.id = f4_.idFormTranslations WHERE f0_.id = 2 ORDER BY f2_.orderNumber ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Sulu\Bundle\FormBundle\Repository\FormRepository->loadById (line 38)
7	Sulu\Bundle\FormBundle\Form\Builder->loadFormEntity (line 237)
8	Sulu\Bundle\FormBundle\Form\Builder->buildForm (line 174)
9	Sulu\Bundle\FormBundle\Form\Builder->build (line 160)
10	App\Sulu\Headless\Resolver\FormSelectionResolver->resolve (line 53)
11	Sulu\Bundle\HeadlessBundle\Content\ContentResolver->resolve (line 42)
12	Sulu\Bundle\HeadlessBundle\Content\StructureResolver->resolve (line 86)
13	Sulu\Bundle\HeadlessBundle\Controller\HeadlessWebsiteController->resolveStructure (line 62)
14	App\Controller\Website\DefaultController->indexAction (line 29)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	App\DualKernel->handle (line 38)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 16)

32.75 ms
(11.37%)

SELECT t0.main AS main_1, t0.id AS id_2, t0.idAddresses AS idAddresses_3, t0.idContacts AS idContacts_4 FROM co_contact_addresses t0 WHERE t0.idContacts = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.main AS main_1,
  t0.id AS id_2,
  t0.idAddresses AS idAddresses_3,
  t0.idContacts AS idContacts_4
FROM
  co_contact_addresses t0
WHERE
  t0.idContacts = ?

SELECT t0.main AS main_1, t0.id AS id_2, t0.idAddresses AS idAddresses_3, t0.idContacts AS idContacts_4 FROM co_contact_addresses t0 WHERE t0.idContacts = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Sulu\Bundle\ContactBundle\Api\Contact->getMainAddress (line 1010)
8	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
9	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
10	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
11	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
12	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
13	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
14	JMS\Serializer\Serializer->visit (line 256)
15	JMS\Serializer\Serializer->toArray (line 202)
16	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
17	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
18	array_map (line 129)
19	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
20	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
21	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
22	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
23	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
24	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
25	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
26	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
27	Twig\Template->yieldBlock (line 446)
28	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
31	Twig\Template->yield (line 402)
32	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
33	Twig\Template->yield (line 402)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 373)
36	Twig\TemplateWrapper->render (line 51)
37	Twig\Environment->render (line 333)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
40	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
41	App\Controller\Website\DefaultController->indexAction (line 58)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
44	Symfony\Component\HttpKernel\Kernel->handle (line 182)
45	App\DualKernel->handle (line 38)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
47	require_once (line 29)
48	require_once (line 16)

12.51 ms
(4.34%)

SELECT t0.position AS position_1, t0.id AS id_2 FROM co_positions t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.position AS position_1,
  t0.id AS id_2
FROM
  co_positions t0
WHERE
  t0.id = ?

SELECT t0.position AS position_1, t0.id AS id_2 FROM co_positions t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 369)
4	Proxies\__CG__\Sulu\Bundle\ContactBundle\Entity\Position::Doctrine\ORM\Proxy\{closure} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\Sulu\Bundle\ContactBundle\Entity\Position->__load (line 99)
7	JMS\Serializer\EventDispatcher\Subscriber\DoctrineProxySubscriber->onPreSerialize (line 77)
8	call_user_func_array (line 100)
9	JMS\SerializerBundle\Debug\TraceableEventDispatcher::JMS\SerializerBundle\Debug\{closure} (line 100)
10	JMS\Serializer\EventDispatcher\EventDispatcher->dispatch (line 112)
11	JMS\Serializer\EventDispatcher\Subscriber\DoctrineProxySubscriber->onPreSerializeTypedProxy (line 101)
12	call_user_func_array (line 100)
13	JMS\SerializerBundle\Debug\TraceableEventDispatcher::JMS\SerializerBundle\Debug\{closure} (line 100)
14	JMS\Serializer\EventDispatcher\EventDispatcher->dispatch (line 112)
15	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 215)
16	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
17	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
18	JMS\Serializer\JsonSerializationVisitor->visitArray (line 95)
19	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 175)
20	JMS\Serializer\JsonSerializationVisitor->visitProperty (line 139)
21	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 287)
22	JMS\Serializer\Serializer->visit (line 256)
23	JMS\Serializer\Serializer->toArray (line 202)
24	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
25	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
26	array_map (line 129)
27	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
28	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
29	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
30	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
31	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
32	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
33	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
34	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
35	Twig\Template->yieldBlock (line 446)
36	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
37	Twig\Template->yield (line 402)
38	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
39	Twig\Template->yield (line 402)
40	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
41	Twig\Template->yield (line 402)
42	Twig\Template->display (line 358)
43	Twig\Template->render (line 373)
44	Twig\TemplateWrapper->render (line 51)
45	Twig\Environment->render (line 333)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
48	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
49	App\Controller\Website\DefaultController->indexAction (line 58)
50	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
51	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
52	Symfony\Component\HttpKernel\Kernel->handle (line 182)
53	App\DualKernel->handle (line 38)
54	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
55	require_once (line 29)
56	require_once (line 16)

11.99 ms
(4.16%)

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/website/contents' 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/website/contents'
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/website/contents' LIMIT 1;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 400)
7	array_map (line 398)
8	Sulu\Component\Content\Repository\ContentRepository::resolveQueryBuilder (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
10	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
11	Sulu\Component\Content\Types\Link->getContentData (line 111)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
15	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
16	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
17	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
18	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
19	Twig\Template->yieldBlock (line 446)
20	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
23	Twig\Template->yield (line 402)
24	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
25	Twig\Template->yield (line 402)
26	Twig\Template->display (line 358)
27	Twig\Template->render (line 373)
28	Twig\TemplateWrapper->render (line 51)
29	Twig\Environment->render (line 333)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
32	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
33	App\Controller\Website\DefaultController->indexAction (line 58)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 182)
37	App\DualKernel->handle (line 38)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 16)

11.10 ms
(3.85%)

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 = '83d68abb-fba4-41ea-9ac0-71fcb4b7f6ab' 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 = '83d68abb-fba4-41ea-9ac0-71fcb4b7f6ab'
    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 = '83d68abb-fba4-41ea-9ac0-71fcb4b7f6ab' 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	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
6	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
7	Sulu\Component\Content\Types\Link->getContentData (line 111)
8	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
9	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
10	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
11	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
12	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
13	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
14	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
28	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
29	App\Controller\Website\DefaultController->indexAction (line 58)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	App\DualKernel->handle (line 38)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 16)

7.32 ms
(2.54%)

SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r0_.target_id AS target_id_8, r0_.idUsersCreator AS idUsersCreator_9, r0_.idUsersChanger AS idUsersChanger_10 FROM ro_routes r0_ WHERE r0_.entity_class = ? AND r0_.entity_id = ? AND r0_.locale = ? AND r0_.history = 0

Parameters:

[
  "Sulu\Bundle\ArticleBundle\Document\ArticleDocument"
  "d45506b2-82f9-4fc4-a093-dd1f0841ad68"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.path AS path_0,
  r0_.locale AS locale_1,
  r0_.entity_class AS entity_class_2,
  r0_.entity_id AS entity_id_3,
  r0_.history AS history_4,
  r0_.id AS id_5,
  r0_.created AS created_6,
  r0_.changed AS changed_7,
  r0_.target_id AS target_id_8,
  r0_.idUsersCreator AS idUsersCreator_9,
  r0_.idUsersChanger AS idUsersChanger_10
FROM
  ro_routes r0_
WHERE
  r0_.entity_class = ?
  AND r0_.entity_id = ?
  AND r0_.locale = ?
  AND r0_.history = 0

SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r0_.target_id AS target_id_8, r0_.idUsersCreator AS idUsersCreator_9, r0_.idUsersChanger AS idUsersChanger_10 FROM ro_routes r0_ WHERE r0_.entity_class = 'Sulu\\Bundle\\ArticleBundle\\Document\\ArticleDocument' AND r0_.entity_id = 'd45506b2-82f9-4fc4-a093-dd1f0841ad68' AND r0_.locale = 'en' AND r0_.history = 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Sulu\Bundle\RouteBundle\Entity\RouteRepository->findByEntity (line 53)
7	Sulu\Bundle\RouteBundle\Document\Subscriber\RoutableSubscriber->handleHydrate (line 97)
8	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
9	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 64)
12	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
13	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
16	Sulu\Bundle\ArticleBundle\Routing\ArticleRouteDefaultProvider->isPublished (line 123)
17	Sulu\Bundle\RouteBundle\Routing\Defaults\RouteDefaultsProvider->isPublished (line 42)
18	Sulu\Bundle\RouteBundle\Routing\RouteProvider->getRouteCollectionForRequest (line 107)
19	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
20	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
21	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
22	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
23	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
24	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
25	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
26	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
27	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
28	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
29	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	App\DualKernel->handle (line 38)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 16)

6.47 ms
(2.25%)

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->executeQuery (line 224)
2	Jackalope\Transport\DoctrineDBAL\Client->fetchUserNodeTypes (line 1954)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodeTypes (line 1905)
4	Jackalope\ObjectManager->getNodeTypes (line 627)
5	Jackalope\ObjectManager->getNodeType (line 639)
6	Jackalope\NodeType\NodeTypeManager->fetchNodeTypes (line 101)
7	Jackalope\NodeType\NodeTypeManager->getNodeType (line 219)
8	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1303)
9	Jackalope\Transport\DoctrineDBAL\Client->getNodeData (line 1247)
10	Jackalope\Transport\DoctrineDBAL\Client->getNodeByIdentifier (line 1429)
11	Jackalope\ObjectManager->getNodeByIdentifier (line 536)
12	Jackalope\Session->getNodeByIdentifier (line 185)
13	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
14	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
15	Sulu\Component\DocumentManager\NodeManager->find (line 43)
16	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 61)
17	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
18	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
21	Sulu\Bundle\ArticleBundle\Routing\ArticleRouteDefaultProvider->isPublished (line 123)
22	Sulu\Bundle\RouteBundle\Routing\Defaults\RouteDefaultsProvider->isPublished (line 42)
23	Sulu\Bundle\RouteBundle\Routing\RouteProvider->getRouteCollectionForRequest (line 107)
24	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
25	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
26	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
27	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
28	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
29	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
30	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
31	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
32	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
33	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
34	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 182)
38	App\DualKernel->handle (line 38)
39	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
40	require_once (line 29)
41	require_once (line 16)

6.28 ms
(2.18%)

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

Parameters:

[
  "/cmf/articles/2025/04/civil-infrastructure-engineer"
  "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/articles/2025/04/civil-infrastructure-engineer') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1284)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodeData (line 1247)
4	Jackalope\Transport\DoctrineDBAL\Client->getNodeByIdentifier (line 1429)
5	Jackalope\ObjectManager->getNodeByIdentifier (line 536)
6	Jackalope\Session->getNodeByIdentifier (line 185)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
9	Sulu\Component\DocumentManager\NodeManager->find (line 43)
10	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 61)
11	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
12	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
14	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
15	Sulu\Bundle\ArticleBundle\Routing\ArticleRouteDefaultProvider->isPublished (line 123)
16	Sulu\Bundle\RouteBundle\Routing\Defaults\RouteDefaultsProvider->isPublished (line 42)
17	Sulu\Bundle\RouteBundle\Routing\RouteProvider->getRouteCollectionForRequest (line 107)
18	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
19	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
20	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
21	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
22	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
23	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
24	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
25	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
26	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
27	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
28	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	App\DualKernel->handle (line 38)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 16)

6.01 ms
(2.09%)

SELECT path AS arraykey, id, path, parent, local_name, namespace, workspace_name, identifier, type, props, depth, sort_order
                FROM phpcr_nodes WHERE workspace_name = ? AND (path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ? OR path = ?) ORDER BY sort_order ASC

Parameters:

[
  "default_live"
  "/cmf/website/contents/what-we-do"
  "/cmf/website/contents/our-work"
  "/cmf/website/contents/what-we-do/sectors"
  "/cmf/website/contents/our-company/company-history"
  "/cmf/website/contents/opportunities/why-join-ardent"
  "/cmf/website/contents/our-company"
  "/cmf/website/contents/what-we-do/services"
  "/cmf/website/contents/our-company/meet-the-team"
  "/cmf/website/contents/opportunities/vacancies"
  "/cmf/website/contents/opportunities"
  "/cmf/website/contents/our-company/employee-owned"
  "/cmf/website/contents/opportunities/early-career-professionals"
  "/cmf/website/contents/our-company/making-a-difference"
  "/cmf/website/contents/our-company/a-better-place-to-work"
]

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 = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR path = ?
    OR 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/website/contents/what-we-do' OR path = '/cmf/website/contents/our-work' OR path = '/cmf/website/contents/what-we-do/sectors' OR path = '/cmf/website/contents/our-company/company-history' OR path = '/cmf/website/contents/opportunities/why-join-ardent' OR path = '/cmf/website/contents/our-company' OR path = '/cmf/website/contents/what-we-do/services' OR path = '/cmf/website/contents/our-company/meet-the-team' OR path = '/cmf/website/contents/opportunities/vacancies' OR path = '/cmf/website/contents/opportunities' OR path = '/cmf/website/contents/our-company/employee-owned' OR path = '/cmf/website/contents/opportunities/early-career-professionals' OR path = '/cmf/website/contents/our-company/making-a-difference' OR path = '/cmf/website/contents/our-company/a-better-place-to-work') ORDER BY sort_order ASC;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 1360)
2	Jackalope\ObjectManager->getNodesByPathAsArray (line 285)
3	Jackalope\NodePathIterator->loadBatch (line 130)
4	Jackalope\NodePathIterator->__construct (line 45)
5	Jackalope\ObjectManager->getNodesByPath (line 243)
6	Jackalope\Session->getNodes (line 252)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
9	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 79)
10	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 144)
11	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 82)
12	Sulu\Component\Cache\Memoize->memoizeById (line 67)
13	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 51)
14	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_header (line 236)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 112)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
21	Twig\Template->yield (line 402)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 373)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
28	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
29	App\Controller\Website\DefaultController->indexAction (line 58)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 182)
33	App\DualKernel->handle (line 38)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 16)

5.86 ms
(2.04%)

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

Parameters:

[
  "/cmf/website/routes/en/job/civil-infrastructure-engineer"
  "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/website/routes/en/job/civil-infrastructure-engineer'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 1206)
2	Jackalope\ObjectManager->getNodeByPath (line 189)
3	Jackalope\Session->getNode (line 228)
4	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
5	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
6	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 241)
7	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 207)
8	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 153)
9	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
10	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
11	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
14	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
15	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	App\DualKernel->handle (line 38)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 16)

3.12 ms
(1.08%)

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:

[
  "e.agileroutes.dev"
  "dev"
  "website"
]

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 = 'e.agileroutes.dev' AND w1_.environment = 'dev')) AND w0_.webspace_key = 'website' ORDER BY w0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	Sulu\Bundle\WebsiteBundle\Entity\AnalyticsRepository->findByUrl (line 66)
7	Sulu\Bundle\WebsiteBundle\EventListener\AppendAnalyticsListener->onResponse (line 109)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 216)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 204)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 182)
16	App\DualKernel->handle (line 38)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 16)

3.09 ms
(1.07%)

SELECT * FROM phpcr_nodes WHERE identifier = ? AND workspace_name = ?

Parameters:

[
  "d45506b2-82f9-4fc4-a093-dd1f0841ad68"
  "default_live"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  phpcr_nodes
WHERE
  identifier = ?
  AND workspace_name = ?

SELECT * FROM phpcr_nodes WHERE identifier = 'd45506b2-82f9-4fc4-a093-dd1f0841ad68' AND workspace_name = 'default_live';

#	File/Call
1	Doctrine\DBAL\Connection->fetchAssociative (line 593)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodeByIdentifier (line 1423)
3	Jackalope\ObjectManager->getNodeByIdentifier (line 536)
4	Jackalope\Session->getNodeByIdentifier (line 185)
5	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
6	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodeByIdentifier (line 63)
7	Sulu\Component\DocumentManager\NodeManager->find (line 43)
8	Sulu\Component\DocumentManager\Subscriber\Phpcr\FindSubscriber->handleFind (line 61)
9	Symfony\Component\EventDispatcher\EventDispatcher->Symfony\Component\EventDispatcher\{closure} (line 246)
10	Symfony\Component\EventDispatcher\EventDispatcher::callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Sulu\Component\DocumentManager\DocumentManager->find (line 34)
13	Sulu\Bundle\ArticleBundle\Routing\ArticleRouteDefaultProvider->isPublished (line 123)
14	Sulu\Bundle\RouteBundle\Routing\Defaults\RouteDefaultsProvider->isPublished (line 42)
15	Sulu\Bundle\RouteBundle\Routing\RouteProvider->getRouteCollectionForRequest (line 107)
16	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
17	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
18	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
19	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
20	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
21	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
22	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	App\DualKernel->handle (line 38)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 16)

2.87 ms
(1.00%)

SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.id AS id_113, m19_.created AS created_114, m19_.changed AS changed_115, c0_.idContactsMain AS idContactsMain_116, c0_.idAccountsParent AS idAccountsParent_117, c0_.logo AS logo_118, c0_.idUsersCreator AS idUsersCreator_119, c0_.idUsersChanger AS idUsersChanger_120, c1_.idCategoriesParent AS idCategoriesParent_121, c1_.idUsersCreator AS idUsersCreator_122, c1_.idUsersChanger AS idUsersChanger_123, c2_.idCategories AS idCategories_124, c2_.idUsersCreator AS idUsersCreator_125, c2_.idUsersChanger AS idUsersChanger_126, c3_.idAddresses AS idAddresses_127, c3_.idAccounts AS idAccounts_128, c4_.idAdressTypes AS idAdressTypes_129, c6_.idContactsMain AS idContactsMain_130, c6_.idAccountsParent AS idAccountsParent_131, c6_.logo AS logo_132, c6_.idUsersCreator AS idUsersCreator_133, c6_.idUsersChanger AS idUsersChanger_134, c7_.idUrlTypes AS idUrlTypes_135, c9_.idPhoneTypes AS idPhoneTypes_136, c11_.idEmailTypes AS idEmailTypes_137, c14_.idFaxTypes AS idFaxTypes_138, t17_.idUsersCreator AS idUsersCreator_139, t17_.idUsersChanger AS idUsersChanger_140, c18_.idTitles AS idTitles_141, c18_.avatar AS avatar_142, c18_.idUsersCreator AS idUsersCreator_143, c18_.idUsersChanger AS idUsersChanger_144, c18_.location_id AS location_id_145, m19_.idMediaTypes AS idMediaTypes_146, m19_.idPreviewImage AS idPreviewImage_147, m19_.idCollections AS idCollections_148, m19_.idUsersCreator AS idUsersCreator_149, m19_.idUsersChanger AS idUsersChanger_150 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN (?) ORDER BY c0_.id ASC

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.lft AS lft_0,
  c0_.rgt AS rgt_1,
  c0_.depth AS depth_2,
  c0_.name AS name_3,
  c0_.externalId AS externalId_4,
  c0_.number AS number_5,
  c0_.corporation AS corporation_6,
  c0_.note AS note_7,
  c0_.uid AS uid_8,
  c0_.registerNumber AS registerNumber_9,
  c0_.placeOfJurisdiction AS placeOfJurisdiction_10,
  c0_.mainEmail AS mainEmail_11,
  c0_.mainPhone AS mainPhone_12,
  c0_.mainFax AS mainFax_13,
  c0_.mainUrl AS mainUrl_14,
  c0_.id AS id_15,
  c0_.created AS created_16,
  c0_.changed AS changed_17,
  c1_.category_key AS category_key_18,
  c1_.default_locale AS default_locale_19,
  c1_.lft AS lft_20,
  c1_.rgt AS rgt_21,
  c1_.depth AS depth_22,
  c1_.id AS id_23,
  c1_.created AS created_24,
  c1_.changed AS changed_25,
  c2_.translation AS translation_26,
  c2_.locale AS locale_27,
  c2_.description AS description_28,
  c2_.id AS id_29,
  c2_.created AS created_30,
  c2_.changed AS changed_31,
  c3_.main AS main_32,
  c3_.id AS id_33,
  c4_.title AS title_34,
  c4_.primaryAddress AS primaryAddress_35,
  c4_.deliveryAddress AS deliveryAddress_36,
  c4_.billingAddress AS billingAddress_37,
  c4_.street AS street_38,
  c4_.number AS number_39,
  c4_.addition AS addition_40,
  c4_.zip AS zip_41,
  c4_.city AS city_42,
  c4_.state AS state_43,
  c4_.countryCode AS countryCode_44,
  c4_.postboxNumber AS postboxNumber_45,
  c4_.postboxPostcode AS postboxPostcode_46,
  c4_.postboxCity AS postboxCity_47,
  c4_.latitude AS latitude_48,
  c4_.longitude AS longitude_49,
  c4_.note AS note_50,
  c4_.id AS id_51,
  c5_.name AS name_52,
  c5_.id AS id_53,
  c6_.lft AS lft_54,
  c6_.rgt AS rgt_55,
  c6_.depth AS depth_56,
  c6_.name AS name_57,
  c6_.externalId AS externalId_58,
  c6_.number AS number_59,
  c6_.corporation AS corporation_60,
  c6_.note AS note_61,
  c6_.uid AS uid_62,
  c6_.registerNumber AS registerNumber_63,
  c6_.placeOfJurisdiction AS placeOfJurisdiction_64,
  c6_.mainEmail AS mainEmail_65,
  c6_.mainPhone AS mainPhone_66,
  c6_.mainFax AS mainFax_67,
  c6_.mainUrl AS mainUrl_68,
  c6_.id AS id_69,
  c6_.created AS created_70,
  c6_.changed AS changed_71,
  c7_.url AS url_72,
  c7_.id AS id_73,
  c8_.name AS name_74,
  c8_.id AS id_75,
  c9_.phone AS phone_76,
  c9_.id AS id_77,
  c10_.name AS name_78,
  c10_.id AS id_79,
  c11_.email AS email_80,
  c11_.id AS id_81,
  c12_.name AS name_82,
  c12_.id AS id_83,
  c13_.value AS value_84,
  c13_.id AS id_85,
  c14_.fax AS fax_86,
  c14_.id AS id_87,
  c15_.name AS name_88,
  c15_.id AS id_89,
  c16_.bankName AS bankName_90,
  c16_.bic AS bic_91,
  c16_.iban AS iban_92,
  c16_.public AS public_93,
  c16_.id AS id_94,
  t17_.name AS name_95,
  t17_.id AS id_96,
  c18_.firstName AS firstName_97,
  c18_.middleName AS middleName_98,
  c18_.lastName AS lastName_99,
  c18_.birthday AS birthday_100,
  c18_.salutation AS salutation_101,
  c18_.formOfAddress AS formOfAddress_102,
  c18_.newsletter AS newsletter_103,
  c18_.gender AS gender_104,
  c18_.note AS note_105,
  c18_.mainEmail AS mainEmail_106,
  c18_.mainPhone AS mainPhone_107,
  c18_.mainFax AS mainFax_108,
  c18_.mainUrl AS mainUrl_109,
  c18_.id AS id_110,
  c18_.created AS created_111,
  c18_.changed AS changed_112,
  m19_.id AS id_113,
  m19_.created AS created_114,
  m19_.changed AS changed_115,
  c0_.idContactsMain AS idContactsMain_116,
  c0_.idAccountsParent AS idAccountsParent_117,
  c0_.logo AS logo_118,
  c0_.idUsersCreator AS idUsersCreator_119,
  c0_.idUsersChanger AS idUsersChanger_120,
  c1_.idCategoriesParent AS idCategoriesParent_121,
  c1_.idUsersCreator AS idUsersCreator_122,
  c1_.idUsersChanger AS idUsersChanger_123,
  c2_.idCategories AS idCategories_124,
  c2_.idUsersCreator AS idUsersCreator_125,
  c2_.idUsersChanger AS idUsersChanger_126,
  c3_.idAddresses AS idAddresses_127,
  c3_.idAccounts AS idAccounts_128,
  c4_.idAdressTypes AS idAdressTypes_129,
  c6_.idContactsMain AS idContactsMain_130,
  c6_.idAccountsParent AS idAccountsParent_131,
  c6_.logo AS logo_132,
  c6_.idUsersCreator AS idUsersCreator_133,
  c6_.idUsersChanger AS idUsersChanger_134,
  c7_.idUrlTypes AS idUrlTypes_135,
  c9_.idPhoneTypes AS idPhoneTypes_136,
  c11_.idEmailTypes AS idEmailTypes_137,
  c14_.idFaxTypes AS idFaxTypes_138,
  t17_.idUsersCreator AS idUsersCreator_139,
  t17_.idUsersChanger AS idUsersChanger_140,
  c18_.idTitles AS idTitles_141,
  c18_.avatar AS avatar_142,
  c18_.idUsersCreator AS idUsersCreator_143,
  c18_.idUsersChanger AS idUsersChanger_144,
  c18_.location_id AS location_id_145,
  m19_.idMediaTypes AS idMediaTypes_146,
  m19_.idPreviewImage AS idPreviewImage_147,
  m19_.idCollections AS idCollections_148,
  m19_.idUsersCreator AS idUsersCreator_149,
  m19_.idUsersChanger AS idUsersChanger_150
FROM
  co_accounts c0_
  LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts
  LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories
  LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories
  LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts
  LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id
  LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id
  LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id
  LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts
  LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls
  LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id
  LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts
  LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones
  LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id
  LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts
  LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails
  LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id
  LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts
  LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes
  LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts
  LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes
  LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id
  LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts
  LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts
  LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts
  LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags
  LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id
  LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts
  LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias
WHERE
  c0_.id IN (?)
ORDER BY
  c0_.id ASC

SELECT c0_.lft AS lft_0, c0_.rgt AS rgt_1, c0_.depth AS depth_2, c0_.name AS name_3, c0_.externalId AS externalId_4, c0_.number AS number_5, c0_.corporation AS corporation_6, c0_.note AS note_7, c0_.uid AS uid_8, c0_.registerNumber AS registerNumber_9, c0_.placeOfJurisdiction AS placeOfJurisdiction_10, c0_.mainEmail AS mainEmail_11, c0_.mainPhone AS mainPhone_12, c0_.mainFax AS mainFax_13, c0_.mainUrl AS mainUrl_14, c0_.id AS id_15, c0_.created AS created_16, c0_.changed AS changed_17, c1_.category_key AS category_key_18, c1_.default_locale AS default_locale_19, c1_.lft AS lft_20, c1_.rgt AS rgt_21, c1_.depth AS depth_22, c1_.id AS id_23, c1_.created AS created_24, c1_.changed AS changed_25, c2_.translation AS translation_26, c2_.locale AS locale_27, c2_.description AS description_28, c2_.id AS id_29, c2_.created AS created_30, c2_.changed AS changed_31, c3_.main AS main_32, c3_.id AS id_33, c4_.title AS title_34, c4_.primaryAddress AS primaryAddress_35, c4_.deliveryAddress AS deliveryAddress_36, c4_.billingAddress AS billingAddress_37, c4_.street AS street_38, c4_.number AS number_39, c4_.addition AS addition_40, c4_.zip AS zip_41, c4_.city AS city_42, c4_.state AS state_43, c4_.countryCode AS countryCode_44, c4_.postboxNumber AS postboxNumber_45, c4_.postboxPostcode AS postboxPostcode_46, c4_.postboxCity AS postboxCity_47, c4_.latitude AS latitude_48, c4_.longitude AS longitude_49, c4_.note AS note_50, c4_.id AS id_51, c5_.name AS name_52, c5_.id AS id_53, c6_.lft AS lft_54, c6_.rgt AS rgt_55, c6_.depth AS depth_56, c6_.name AS name_57, c6_.externalId AS externalId_58, c6_.number AS number_59, c6_.corporation AS corporation_60, c6_.note AS note_61, c6_.uid AS uid_62, c6_.registerNumber AS registerNumber_63, c6_.placeOfJurisdiction AS placeOfJurisdiction_64, c6_.mainEmail AS mainEmail_65, c6_.mainPhone AS mainPhone_66, c6_.mainFax AS mainFax_67, c6_.mainUrl AS mainUrl_68, c6_.id AS id_69, c6_.created AS created_70, c6_.changed AS changed_71, c7_.url AS url_72, c7_.id AS id_73, c8_.name AS name_74, c8_.id AS id_75, c9_.phone AS phone_76, c9_.id AS id_77, c10_.name AS name_78, c10_.id AS id_79, c11_.email AS email_80, c11_.id AS id_81, c12_.name AS name_82, c12_.id AS id_83, c13_.value AS value_84, c13_.id AS id_85, c14_.fax AS fax_86, c14_.id AS id_87, c15_.name AS name_88, c15_.id AS id_89, c16_.bankName AS bankName_90, c16_.bic AS bic_91, c16_.iban AS iban_92, c16_.public AS public_93, c16_.id AS id_94, t17_.name AS name_95, t17_.id AS id_96, c18_.firstName AS firstName_97, c18_.middleName AS middleName_98, c18_.lastName AS lastName_99, c18_.birthday AS birthday_100, c18_.salutation AS salutation_101, c18_.formOfAddress AS formOfAddress_102, c18_.newsletter AS newsletter_103, c18_.gender AS gender_104, c18_.note AS note_105, c18_.mainEmail AS mainEmail_106, c18_.mainPhone AS mainPhone_107, c18_.mainFax AS mainFax_108, c18_.mainUrl AS mainUrl_109, c18_.id AS id_110, c18_.created AS created_111, c18_.changed AS changed_112, m19_.id AS id_113, m19_.created AS created_114, m19_.changed AS changed_115, c0_.idContactsMain AS idContactsMain_116, c0_.idAccountsParent AS idAccountsParent_117, c0_.logo AS logo_118, c0_.idUsersCreator AS idUsersCreator_119, c0_.idUsersChanger AS idUsersChanger_120, c1_.idCategoriesParent AS idCategoriesParent_121, c1_.idUsersCreator AS idUsersCreator_122, c1_.idUsersChanger AS idUsersChanger_123, c2_.idCategories AS idCategories_124, c2_.idUsersCreator AS idUsersCreator_125, c2_.idUsersChanger AS idUsersChanger_126, c3_.idAddresses AS idAddresses_127, c3_.idAccounts AS idAccounts_128, c4_.idAdressTypes AS idAdressTypes_129, c6_.idContactsMain AS idContactsMain_130, c6_.idAccountsParent AS idAccountsParent_131, c6_.logo AS logo_132, c6_.idUsersCreator AS idUsersCreator_133, c6_.idUsersChanger AS idUsersChanger_134, c7_.idUrlTypes AS idUrlTypes_135, c9_.idPhoneTypes AS idPhoneTypes_136, c11_.idEmailTypes AS idEmailTypes_137, c14_.idFaxTypes AS idFaxTypes_138, t17_.idUsersCreator AS idUsersCreator_139, t17_.idUsersChanger AS idUsersChanger_140, c18_.idTitles AS idTitles_141, c18_.avatar AS avatar_142, c18_.idUsersCreator AS idUsersCreator_143, c18_.idUsersChanger AS idUsersChanger_144, c18_.location_id AS location_id_145, m19_.idMediaTypes AS idMediaTypes_146, m19_.idPreviewImage AS idPreviewImage_147, m19_.idCollections AS idCollections_148, m19_.idUsersCreator AS idUsersCreator_149, m19_.idUsersChanger AS idUsersChanger_150 FROM co_accounts c0_ LEFT JOIN co_account_categories c20_ ON c0_.id = c20_.idAccounts LEFT JOIN ca_categories c1_ ON c1_.id = c20_.idCategories LEFT JOIN ca_category_translations c2_ ON c1_.id = c2_.idCategories LEFT JOIN co_account_addresses c3_ ON c0_.id = c3_.idAccounts LEFT JOIN co_addresses c4_ ON c3_.idAddresses = c4_.id LEFT JOIN co_address_types c5_ ON c4_.idAdressTypes = c5_.id LEFT JOIN co_accounts c6_ ON c0_.idAccountsParent = c6_.id LEFT JOIN co_account_urls c21_ ON c0_.id = c21_.idAccounts LEFT JOIN co_urls c7_ ON c7_.id = c21_.idUrls LEFT JOIN co_url_types c8_ ON c7_.idUrlTypes = c8_.id LEFT JOIN co_account_phones c22_ ON c0_.id = c22_.idAccounts LEFT JOIN co_phones c9_ ON c9_.id = c22_.idPhones LEFT JOIN co_phone_types c10_ ON c9_.idPhoneTypes = c10_.id LEFT JOIN co_account_emails c23_ ON c0_.id = c23_.idAccounts LEFT JOIN co_emails c11_ ON c11_.id = c23_.idEmails LEFT JOIN co_email_types c12_ ON c11_.idEmailTypes = c12_.id LEFT JOIN co_account_notes c24_ ON c0_.id = c24_.idAccounts LEFT JOIN co_notes c13_ ON c13_.id = c24_.idNotes LEFT JOIN co_account_faxes c25_ ON c0_.id = c25_.idAccounts LEFT JOIN co_faxes c14_ ON c14_.id = c25_.idFaxes LEFT JOIN co_fax_types c15_ ON c14_.idFaxTypes = c15_.id LEFT JOIN co_account_bank_accounts c26_ ON c0_.id = c26_.idAccounts LEFT JOIN co_bank_account c16_ ON c16_.id = c26_.idBankAccounts LEFT JOIN co_account_tags c27_ ON c0_.id = c27_.idAccounts LEFT JOIN ta_tags t17_ ON t17_.id = c27_.idTags LEFT JOIN co_contacts c18_ ON c0_.idContactsMain = c18_.id LEFT JOIN co_account_medias c28_ ON c0_.id = c28_.idAccounts LEFT JOIN me_media m19_ ON m19_.id = c28_.idMedias WHERE c0_.id IN ('1') ORDER BY c0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	Sulu\Bundle\ContactBundle\Entity\AccountRepository->findByIds (line 179)
7	Sulu\Bundle\ContactBundle\Contact\AccountManager->getByIds (line 171)
8	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->getContentData (line 115)
9	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
10	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
11	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
12	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
13	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
14	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
15	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
29	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
30	App\Controller\Website\DefaultController->indexAction (line 58)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	App\DualKernel->handle (line 38)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 16)

2.68 ms
(0.93%)

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 = 'd5f3a45a-c2ed-46ac-ba6f-059b0d28757f' 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 = 'd5f3a45a-c2ed-46ac-ba6f-059b0d28757f'
    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 = 'd5f3a45a-c2ed-46ac-ba6f-059b0d28757f' 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	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
6	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
7	Sulu\Component\Content\Types\Link->getContentData (line 111)
8	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
9	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
10	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
11	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_header (line 239)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 112)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
25	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
26	App\Controller\Website\DefaultController->indexAction (line 58)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	App\DualKernel->handle (line 38)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 29)
33	require_once (line 16)

2.64 ms
(0.92%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.account_id AS account_id_3 FROM co_account_locations t0 WHERE t0.id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.account_id AS account_id_3
FROM
  co_account_locations t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.account_id AS account_id_3 FROM co_account_locations t0 WHERE t0.id = 17;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\Website\JobArticleController->getAttributes (line 46)
6	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 61)
7	App\Controller\Website\DefaultController->indexAction (line 58)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	App\DualKernel->handle (line 38)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 16)

2.58 ms
(0.90%)

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

Parameters:

[
  "/cmf/website/contents/opportunities/why-join-ardent"
  "/cmf/website/contents/our-company/company-history"
  "/cmf/website/contents/what-we-do"
  "/cmf/website/contents/opportunities/vacancies"
  "/cmf/website/contents/our-company/meet-the-team"
  "/cmf/website/contents/our-work"
  "/cmf/website/contents/our-company"
  "/cmf/website/contents/our-company/employee-owned"
  "/cmf/website/contents/what-we-do/sectors"
  "/cmf/website/contents/opportunities"
  "/cmf/website/contents/our-company/making-a-difference"
  "/cmf/website/contents/our-company/a-better-place-to-work"
  "/cmf/website/contents/what-we-do/services"
  "/cmf/website/contents/opportunities/early-career-professionals"
  "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/website/contents/opportunities/why-join-ardent', '/cmf/website/contents/our-company/company-history', '/cmf/website/contents/what-we-do', '/cmf/website/contents/opportunities/vacancies', '/cmf/website/contents/our-company/meet-the-team', '/cmf/website/contents/our-work', '/cmf/website/contents/our-company', '/cmf/website/contents/our-company/employee-owned', '/cmf/website/contents/what-we-do/sectors', '/cmf/website/contents/opportunities', '/cmf/website/contents/our-company/making-a-difference', '/cmf/website/contents/our-company/a-better-place-to-work', '/cmf/website/contents/what-we-do/services', '/cmf/website/contents/opportunities/early-career-professionals') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodesData (line 1284)
3	Jackalope\Transport\DoctrineDBAL\Client->getNodes (line 1371)
4	Jackalope\ObjectManager->getNodesByPathAsArray (line 285)
5	Jackalope\NodePathIterator->loadBatch (line 130)
6	Jackalope\NodePathIterator->__construct (line 45)
7	Jackalope\ObjectManager->getNodesByPath (line 243)
8	Jackalope\Session->getNodes (line 252)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
10	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNodes (line 83)
11	Sulu\Component\Content\Query\ContentQueryExecutor->execute (line 79)
12	Sulu\Bundle\WebsiteBundle\Navigation\NavigationMapper->getRootNavigation (line 144)
13	Sulu\Bundle\WebsiteBundle\Twig\Navigation\NavigationTwigExtension->treeRootNavigationFunction (line 82)
14	Sulu\Component\Cache\Memoize->memoizeById (line 67)
15	Sulu\Bundle\WebsiteBundle\Twig\Navigation\MemoizedNavigationTwigExtension->Sulu\Component\Cache\{closure} (line 51)
16	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_header (line 236)
17	Twig\Template->yieldBlock (line 446)
18	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 112)
19	Twig\Template->yield (line 402)
20	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
21	Twig\Template->yield (line 402)
22	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
23	Twig\Template->yield (line 402)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 373)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
30	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
31	App\Controller\Website\DefaultController->indexAction (line 58)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 182)
35	App\DualKernel->handle (line 38)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 16)

2.45 ms
(0.85%)

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 = '433c253b-13f8-438d-a78b-b7a6882756d1' 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 = '433c253b-13f8-438d-a78b-b7a6882756d1'
    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 = '433c253b-13f8-438d-a78b-b7a6882756d1' 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	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
6	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
7	Sulu\Component\Content\Types\Link->getContentData (line 111)
8	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
9	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
10	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
11	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
12	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
13	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
14	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
15	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
16	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
17	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
31	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
32	App\Controller\Website\DefaultController->indexAction (line 58)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	App\DualKernel->handle (line 38)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 16)

2.01 ms
(0.70%)

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	Jackalope\Transport\DoctrineDBAL\Client->getNamespacesObject (line 533)
2	Jackalope\Transport\DoctrineDBAL\Client->getNamespaces (line 523)
3	Jackalope\Transport\DoctrineDBAL\Client->getNamespacePrefixes (line 518)
4	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 1184)
5	Jackalope\ObjectManager->getNodeByPath (line 189)
6	Jackalope\Session->getNode (line 228)
7	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 241)
10	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 207)
11	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 153)
12	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
13	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
14	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
15	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
16	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
17	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
18	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	App\DualKernel->handle (line 38)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 16)

1.51 ms
(0.52%)

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"
  "a7b66d3a-0455-4ea1-9604-39df657bd1c5"
]

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 ('a7b66d3a-0455-4ea1-9604-39df657bd1c5');

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Jackalope\Transport\DoctrineDBAL\Client->getNodesByIdentifier (line 1455)
3	Jackalope\ObjectManager->getNodesByIdentifier (line 581)
4	Jackalope\Property->getReferencedNodes (line 790)
5	Jackalope\Property->getNode (line 424)
6	Jackalope\Property->getValue (line 211)
7	Jackalope\Node->getPropertyValue (line 763)
8	Jackalope\Node->getPropertyValueWithDefault (line 782)
9	Sulu\Component\Webspace\Settings\SettingsManager->load (line 64)
10	Sulu\Bundle\SnippetBundle\Snippet\DefaultSnippetManager->load (line 85)
11	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 66)
12	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_header (line 239)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 112)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
26	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
27	App\Controller\Website\DefaultController->indexAction (line 58)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	App\DualKernel->handle (line 38)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 29)
34	require_once (line 16)

1.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 (n0.identifier = 'eea52da6-50bf-41ae-9e16-925b1f1b8290' 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 = 'eea52da6-50bf-41ae-9e16-925b1f1b8290'
    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 = 'eea52da6-50bf-41ae-9e16-925b1f1b8290' 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	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveQueryBuilder (line 392)
5	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
6	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
7	Sulu\Component\Content\Types\Link->getContentData (line 111)
8	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
9	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
10	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
11	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
12	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
13	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
14	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
15	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
16	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
17	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
24	Twig\Template->yield (line 402)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 373)
27	Twig\TemplateWrapper->render (line 51)
28	Twig\Environment->render (line 333)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
31	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
32	App\Controller\Website\DefaultController->indexAction (line 58)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 182)
36	App\DualKernel->handle (line 38)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
38	require_once (line 29)
39	require_once (line 16)

1.09 ms
(0.38%)

SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = ? AND r0_.locale = ?

Parameters:

[
  "/job/civil-infrastructure-engineer"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.path AS path_0,
  r0_.locale AS locale_1,
  r0_.entity_class AS entity_class_2,
  r0_.entity_id AS entity_id_3,
  r0_.history AS history_4,
  r0_.id AS id_5,
  r0_.created AS created_6,
  r0_.changed AS changed_7,
  r1_.path AS path_8,
  r1_.locale AS locale_9,
  r1_.entity_class AS entity_class_10,
  r1_.entity_id AS entity_id_11,
  r1_.history AS history_12,
  r1_.id AS id_13,
  r1_.created AS created_14,
  r1_.changed AS changed_15,
  r0_.target_id AS target_id_16,
  r0_.idUsersCreator AS idUsersCreator_17,
  r0_.idUsersChanger AS idUsersChanger_18,
  r1_.target_id AS target_id_19,
  r1_.idUsersCreator AS idUsersCreator_20,
  r1_.idUsersChanger AS idUsersChanger_21
FROM
  ro_routes r0_
  LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id
WHERE
  r0_.path = ?
  AND r0_.locale = ?

SELECT r0_.path AS path_0, r0_.locale AS locale_1, r0_.entity_class AS entity_class_2, r0_.entity_id AS entity_id_3, r0_.history AS history_4, r0_.id AS id_5, r0_.created AS created_6, r0_.changed AS changed_7, r1_.path AS path_8, r1_.locale AS locale_9, r1_.entity_class AS entity_class_10, r1_.entity_id AS entity_id_11, r1_.history AS history_12, r1_.id AS id_13, r1_.created AS created_14, r1_.changed AS changed_15, r0_.target_id AS target_id_16, r0_.idUsersCreator AS idUsersCreator_17, r0_.idUsersChanger AS idUsersChanger_18, r1_.target_id AS target_id_19, r1_.idUsersCreator AS idUsersCreator_20, r1_.idUsersChanger AS idUsersChanger_21 FROM ro_routes r0_ LEFT JOIN ro_routes r1_ ON r0_.target_id = r1_.id WHERE r0_.path = '/job/civil-infrastructure-engineer' AND r0_.locale = 'en';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 996)
6	Sulu\Bundle\RouteBundle\Entity\RouteRepository->findByPath (line 36)
7	Sulu\Bundle\RouteBundle\Routing\RouteProvider->findRouteByPath (line 147)
8	Sulu\Bundle\RouteBundle\Routing\RouteProvider->getRouteCollectionForRequest (line 95)
9	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
10	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
11	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
12	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
13	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
14	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
15	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	App\DualKernel->handle (line 38)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 16)

1.04 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/website/contents/opportunities/why-join-ardent' 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/website/contents/opportunities/why-join-ardent'
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/website/contents/opportunities/why-join-ardent' LIMIT 1;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 400)
7	array_map (line 398)
8	Sulu\Component\Content\Repository\ContentRepository::resolveQueryBuilder (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
10	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
11	Sulu\Component\Content\Types\Link->getContentData (line 111)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
15	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
16	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
17	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
18	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
19	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
20	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
21	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
35	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
36	App\Controller\Website\DefaultController->indexAction (line 58)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 182)
40	App\DualKernel->handle (line 38)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 16)

0.98 ms
(0.34%)

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/website/contents/opportunities/vacancies' 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/website/contents/opportunities/vacancies'
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/website/contents/opportunities/vacancies' LIMIT 1;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 400)
7	array_map (line 398)
8	Sulu\Component\Content\Repository\ContentRepository::resolveQueryBuilder (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
10	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
11	Sulu\Component\Content\Types\Link->getContentData (line 111)
12	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
13	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
14	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
15	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_header (line 239)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 112)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
22	Twig\Template->yield (line 402)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 373)
25	Twig\TemplateWrapper->render (line 51)
26	Twig\Environment->render (line 333)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
29	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
30	App\Controller\Website\DefaultController->indexAction (line 58)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 182)
34	App\DualKernel->handle (line 38)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 29)
37	require_once (line 16)

0.95 ms
(0.33%)

SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles WHERE co_account_social_media_profiles.idAccounts = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.username AS username_1,
  t0.id AS id_2,
  t0.idSocialMediaTypes AS idSocialMediaTypes_3
FROM
  co_social_media_profiles t0
  INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles
WHERE
  co_account_social_media_profiles.idAccounts = ?

SELECT t0.username AS username_1, t0.id AS id_2, t0.idSocialMediaTypes AS idSocialMediaTypes_3 FROM co_social_media_profiles t0 INNER JOIN co_account_social_media_profiles ON t0.id = co_account_social_media_profiles.idSocialMediaProfiles WHERE co_account_social_media_profiles.idAccounts = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1143)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1065)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3322)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Sulu\Bundle\ContactBundle\Api\Account->getSocialMediaProfiles (line 454)
8	Sulu\Bundle\ContactBundle\Api\Account->getContactDetails (line 383)
9	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
10	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
11	JMS\Serializer\Serializer->visit (line 256)
12	JMS\Serializer\Serializer->toArray (line 202)
13	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
14	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
15	array_map (line 129)
16	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
17	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
18	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
19	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
20	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
21	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
22	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
23	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
24	Twig\Template->yieldBlock (line 446)
25	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
28	Twig\Template->yield (line 402)
29	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
30	Twig\Template->yield (line 402)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 373)
33	Twig\TemplateWrapper->render (line 51)
34	Twig\Environment->render (line 333)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
37	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
38	App\Controller\Website\DefaultController->indexAction (line 58)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
41	Symfony\Component\HttpKernel\Kernel->handle (line 182)
42	App\DualKernel->handle (line 38)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 29)
45	require_once (line 16)

0.80 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.parent = '/cmf/website/contents/opportunities/early-career-professionals' 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/website/contents/opportunities/early-career-professionals'
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/website/contents/opportunities/early-career-professionals' LIMIT 1;

#	File/Call
1	Jackalope\Transport\DoctrineDBAL\Client->query (line 2190)
2	Jackalope\Query\Query->execute (line 89)
3	PHPCR\Util\QOM\QueryBuilder->execute (line 436)
4	Sulu\Component\Content\Repository\ContentRepository->resolveHasChildren (line 879)
5	Sulu\Component\Content\Repository\ContentRepository->resolveContent (line 683)
6	Sulu\Component\Content\Repository\ContentRepository->Sulu\Component\Content\Repository\{closure} (line 400)
7	array_map (line 398)
8	Sulu\Component\Content\Repository\ContentRepository::resolveQueryBuilder (line 398)
9	Sulu\Component\Content\Repository\ContentRepository->findByUuids (line 228)
10	Sulu\Bundle\PageBundle\Markup\Link\PageLinkProvider->preload (line 66)
11	Sulu\Component\Content\Types\Link->getContentData (line 111)
12	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
13	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
14	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
15	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
16	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
17	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
18	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
19	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
20	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
21	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
26	Twig\Template->yield (line 402)
27	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
28	Twig\Template->yield (line 402)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 373)
31	Twig\TemplateWrapper->render (line 51)
32	Twig\Environment->render (line 333)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
35	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
36	App\Controller\Website\DefaultController->indexAction (line 58)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
39	Symfony\Component\HttpKernel\Kernel->handle (line 182)
40	App\DualKernel->handle (line 38)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 16)

0.76 ms
(0.26%)

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->fetchFirstColumn (line 958)
2	Jackalope\Transport\DoctrineDBAL\Client->workspaceExists (line 416)
3	Jackalope\Transport\DoctrineDBAL\Client->login (line 349)
4	Jackalope\Transport\DoctrineDBAL\Client->assertLoggedIn (line 454)
5	Jackalope\Transport\DoctrineDBAL\Client->getNode (line 1183)
6	Jackalope\ObjectManager->getNodeByPath (line 189)
7	Jackalope\Session->getNode (line 228)
8	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
9	Sulu\Bundle\DocumentManagerBundle\Session\Session->getNode (line 78)
10	Sulu\Component\Content\Types\ResourceLocator\Mapper\PhpcrMapper->loadByResourceLocator (line 241)
11	Sulu\Component\Content\Types\ResourceLocator\Strategy\ResourceLocatorStrategy->loadByResourceLocator (line 207)
12	Sulu\Bundle\WebsiteBundle\Routing\ContentRouteProvider->getRouteCollectionForRequest (line 153)
13	Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest (line 97)
14	Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest (line 203)
15	Symfony\Cmf\Bundle\RoutingBundle\Routing\DynamicRouter->matchRequest (line 69)
16	Symfony\Cmf\Component\Routing\ChainRouter->doMatch (line 161)
17	Symfony\Cmf\Component\Routing\ChainRouter->matchRequest (line 134)
18	Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest (line 101)
19	Sulu\Bundle\WebsiteBundle\EventListener\RouterListener->onKernelRequest (line 58)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	App\DualKernel->handle (line 38)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 16)

0.50 ms
(0.17%)

SELECT t0.main AS main_1, t0.id AS id_2, t0.idPositions AS idPositions_3, t0.idContacts AS idContacts_4, t0.idAccounts AS idAccounts_5 FROM co_account_contacts t0 WHERE t0.idAccounts = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.main AS main_1,
  t0.id AS id_2,
  t0.idPositions AS idPositions_3,
  t0.idContacts AS idContacts_4,
  t0.idAccounts AS idAccounts_5
FROM
  co_account_contacts t0
WHERE
  t0.idAccounts = ?

SELECT t0.main AS main_1, t0.id AS id_2, t0.idPositions AS idPositions_3, t0.idContacts AS idContacts_4, t0.idAccounts AS idAccounts_5 FROM co_account_contacts t0 WHERE t0.idAccounts = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	Sulu\Bundle\ContactBundle\Api\Account->getAccountContacts (line 649)
8	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
9	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
10	JMS\Serializer\Serializer->visit (line 256)
11	JMS\Serializer\Serializer->toArray (line 202)
12	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
13	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
14	array_map (line 129)
15	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
20	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
21	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
22	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
36	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
37	App\Controller\Website\DefaultController->indexAction (line 58)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 182)
41	App\DualKernel->handle (line 38)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 16)

0.34 ms
(0.12%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.account_id AS account_id_3 FROM co_account_locations t0 WHERE t0.account_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.account_id AS account_id_3
FROM
  co_account_locations t0
WHERE
  t0.account_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.account_id AS account_id_3 FROM co_account_locations t0 WHERE t0.account_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Contact\Api\Account->getLocations (line 18)
8	JMS\Serializer\Accessor\DefaultAccessorStrategy->getValue (line 73)
9	JMS\Serializer\GraphNavigator\SerializationGraphNavigator->accept (line 277)
10	JMS\Serializer\Serializer->visit (line 256)
11	JMS\Serializer\Serializer->toArray (line 202)
12	Sulu\Component\Serializer\ArraySerializer->serialize (line 31)
13	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection->Sulu\Bundle\ContactBundle\Content\Types\{closure} (line 138)
14	array_map (line 129)
15	Sulu\Bundle\ContactBundle\Content\Types\ContactAccountSelection::getContentData (line 129)
16	Sulu\Component\Content\Types\BlockContentType->Sulu\Component\Content\Types\{closure} (line 353)
17	Sulu\Component\Content\Types\BlockContentType->prepareData (line 404)
18	Sulu\Component\Content\Types\BlockContentType->getContentData (line 350)
19	Sulu\Bundle\WebsiteBundle\Resolver\StructureResolver->resolve (line 135)
20	Sulu\Bundle\SnippetBundle\Snippet\SnippetResolver->resolve (line 76)
21	Sulu\Bundle\SnippetBundle\Twig\SnippetAreaTwigExtension->loadByArea (line 77)
22	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->block_footer (line 302)
23	Twig\Template->yieldBlock (line 446)
24	__TwigTemplate_d0b8ba0bebb3c746a3e585ead6c392ef->doDisplay (line 124)
25	Twig\Template->yield (line 402)
26	__TwigTemplate_cede6e0eb822c9aebf46bcec23aa8ea8->doDisplay (line 51)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_04b51fb6574db2b13fb7d920ba10bb17->doDisplay (line 53)
29	Twig\Template->yield (line 402)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 373)
32	Twig\TemplateWrapper->render (line 51)
33	Twig\Environment->render (line 333)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
36	Sulu\Bundle\WebsiteBundle\Controller\WebsiteController->renderStructure (line 76)
37	App\Controller\Website\DefaultController->indexAction (line 58)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 182)
41	App\DualKernel->handle (line 38)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
43	require_once (line 29)
44	require_once (line 16)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Sulu\Bundle\ContactBundle\Entity\AccountContact	98
App\Entity\Contact	97
Sulu\Bundle\MediaBundle\Entity\Media	96
Sulu\Bundle\ContactBundle\Entity\Position	43
App\Entity\AccountLocation	8
Sulu\Bundle\FormBundle\Entity\FormField	7
Sulu\Bundle\FormBundle\Entity\FormFieldTranslation	7
Sulu\Bundle\SecurityBundle\Entity\User	5
App\Entity\Account	2
Sulu\Bundle\RouteBundle\Entity\Route	1
Sulu\Bundle\FormBundle\Entity\Form	1
Sulu\Bundle\FormBundle\Entity\FormTranslation	1
Sulu\Bundle\ContactBundle\Entity\AccountAddress	1
Sulu\Bundle\ContactBundle\Entity\Address	1
Sulu\Bundle\ContactBundle\Entity\AddressType	1
Sulu\Bundle\ContactBundle\Entity\Phone	1
Sulu\Bundle\ContactBundle\Entity\PhoneType	1
Sulu\Bundle\ContactBundle\Entity\Email	1
Sulu\Bundle\ContactBundle\Entity\EmailType	1

Entities Mapping

Class	Mapping errors
Sulu\Bundle\MediaBundle\Entity\Collection	No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem	No errors.
Sulu\Bundle\FormBundle\Entity\Form	No errors.
Sulu\Bundle\ContactBundle\Entity\Contact	No errors.
App\Entity\Contact	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle	No errors.
Sulu\Bundle\SecurityBundle\Entity\Group	No errors.
Sulu\Bundle\RouteBundle\Entity\Route	No errors.
Sulu\Bundle\SecurityBundle\Entity\User	No errors.
Sulu\Bundle\ContactBundle\Entity\Position	No errors.
Sulu\Bundle\FormBundle\Entity\FormTranslation	No errors.
Sulu\Bundle\FormBundle\Entity\FormField	No errors.
Sulu\Bundle\FormBundle\Entity\FormFieldTranslation	No errors.
Sulu\Bundle\FormBundle\Entity\FormTranslationReceiver	No errors.
App\Entity\AccountLocation	No errors.
Sulu\Bundle\ContactBundle\Entity\Account	No errors.
App\Entity\Account	No errors.
Sulu\Bundle\CategoryBundle\Entity\Category	No errors.
Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\Address	No errors.
Sulu\Bundle\ContactBundle\Entity\AddressType	No errors.
Sulu\Bundle\ContactBundle\Entity\Url	No errors.
Sulu\Bundle\ContactBundle\Entity\UrlType	No errors.
Sulu\Bundle\ContactBundle\Entity\Phone	No errors.
Sulu\Bundle\ContactBundle\Entity\PhoneType	No errors.
Sulu\Bundle\ContactBundle\Entity\Email	No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType	No errors.
Sulu\Bundle\ContactBundle\Entity\Note	No errors.
Sulu\Bundle\ContactBundle\Entity\Fax	No errors.
Sulu\Bundle\ContactBundle\Entity\FaxType	No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount	No errors.
Sulu\Bundle\TagBundle\Entity\Tag	No errors.
Sulu\Bundle\MediaBundle\Entity\Media	No errors.
Sulu\Bundle\MediaBundle\Entity\MediaType	No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress	No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfileType	No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics	No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain	No errors.

Symfony Profiler

GET https://e.agileroutes.dev/job/civil-infrastructure-engineer

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping