Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

8.56 ms Query time

0 Invalid entities

49 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.22 ms
(25.92%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.phone_number AS phone_number_7,
  t0.street AS street_8,
  t0.postcode AS postcode_9,
  t0.city AS city_10,
  t0.referrer AS referrer_11,
  t0.external_reference AS external_reference_12,
  t0.is_enabled AS is_enabled_13,
  t0.import_reference AS import_reference_14,
  t0.ip AS ip_15,
  t0.last_activity_at AS last_activity_at_16,
  t0.birthday AS birthday_17,
  t0.archived_at AS archived_at_18,
  t0.session_token AS session_token_19,
  t0.compliance AS compliance_20,
  t0.is_valid_email AS is_valid_email_21,
  t0.deleted_at AS deleted_at_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.uuid AS uuid_25,
  t0.civility_id AS civility_id_26,
  t0.avatar_id AS avatar_id_27,
  t0.company_id AS company_id_28
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.phone_number AS phone_number_7, t0.street AS street_8, t0.postcode AS postcode_9, t0.city AS city_10, t0.referrer AS referrer_11, t0.external_reference AS external_reference_12, t0.is_enabled AS is_enabled_13, t0.import_reference AS import_reference_14, t0.ip AS ip_15, t0.last_activity_at AS last_activity_at_16, t0.birthday AS birthday_17, t0.archived_at AS archived_at_18, t0.session_token AS session_token_19, t0.compliance AS compliance_20, t0.is_valid_email AS is_valid_email_21, t0.deleted_at AS deleted_at_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.uuid AS uuid_25, t0.civility_id AS civility_id_26, t0.avatar_id AS avatar_id_27, t0.company_id AS company_id_28 FROM app_user t0 WHERE t0.id = 1;

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.37 ms
(16.05%)

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_."rank" AS rank_4, a0_.short_name AS short_name_5, a0_.is_enabled AS is_enabled_6, a0_.is_check_compliance AS is_check_compliance_7, a0_.icon AS icon_8, a0_.allowed_countries AS allowed_countries_9, a0_.deleted_at AS deleted_at_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.uuid AS uuid_13, a1_.id AS id_14, a1_.identifier AS identifier_15, a1_.name AS name_16, a1_.description AS description_17, a1_.is_enabled AS is_enabled_18, a1_.deleted_at AS deleted_at_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.uuid AS uuid_22, a0_.company_id AS company_id_23, a0_.taxonomy_id AS taxonomy_id_24, a0_.parent_id AS parent_id_25 FROM app_term a0_ LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id WHERE a1_.identifier = ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC

Parameters:

[
  "partner_type"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_."rank" AS rank_4,
  a0_.short_name AS short_name_5,
  a0_.is_enabled AS is_enabled_6,
  a0_.is_check_compliance AS is_check_compliance_7,
  a0_.icon AS icon_8,
  a0_.allowed_countries AS allowed_countries_9,
  a0_.deleted_at AS deleted_at_10,
  a0_.created_at AS created_at_11,
  a0_.updated_at AS updated_at_12,
  a0_.uuid AS uuid_13,
  a1_.id AS id_14,
  a1_.identifier AS identifier_15,
  a1_.name AS name_16,
  a1_.description AS description_17,
  a1_.is_enabled AS is_enabled_18,
  a1_.deleted_at AS deleted_at_19,
  a1_.created_at AS created_at_20,
  a1_.updated_at AS updated_at_21,
  a1_.uuid AS uuid_22,
  a0_.company_id AS company_id_23,
  a0_.taxonomy_id AS taxonomy_id_24,
  a0_.parent_id AS parent_id_25
FROM
  app_term a0_
  LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id
WHERE
  a1_.identifier = ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_."rank" AS rank_4, a0_.short_name AS short_name_5, a0_.is_enabled AS is_enabled_6, a0_.is_check_compliance AS is_check_compliance_7, a0_.icon AS icon_8, a0_.allowed_countries AS allowed_countries_9, a0_.deleted_at AS deleted_at_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.uuid AS uuid_13, a1_.id AS id_14, a1_.identifier AS identifier_15, a1_.name AS name_16, a1_.description AS description_17, a1_.is_enabled AS is_enabled_18, a1_.deleted_at AS deleted_at_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.uuid AS uuid_22, a0_.company_id AS company_id_23, a0_.taxonomy_id AS taxonomy_id_24, a0_.parent_id AS parent_id_25 FROM app_term a0_ LEFT JOIN app_taxonomy a1_ ON a0_.taxonomy_id = a1_.id WHERE a1_.identifier = 'partner_type' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->fetchAllAssociative (line 907)
2	Doctrine\DBAL\Connection->executeCacheQuery (line 1157)
3	Doctrine\DBAL\Connection->executeQuery (line 1084)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
5	Doctrine\ORM\Query->_doExecute (line 330)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
7	Doctrine\ORM\AbstractQuery->execute (line 1167)
8	Doctrine\ORM\AbstractQuery->getResult (line 906)
9	App\Repository\TermRepository->getAll (line 76)
10	App\Controller\Admin\AdminController->mainMenu (line 109)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
14	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
15	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
16	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
17	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
18	__TwigTemplate_b5a8be9f18af217ed17ae01d0b15f0e0->doDisplay (line 52)
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\Extension\CoreExtension->include (line 1526)
24	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5::block_body (line 107)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5->doDisplay (line 54)
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 452)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
37	App\Controller\Admin\CampaignController->edit (line 169)
38	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
39	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
40	Symfony\Component\HttpKernel\Kernel->handle (line 208)
41	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
42	require_once (line 29)
43	require_once (line 5)

1.23 ms
(14.32%)

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.is_enabled AS is_enabled_4, t0.register_url AS register_url_5, t0.crm_api_key AS crm_api_key_6, t0.webhook_url AS webhook_url_7, t0.olead_api_key AS olead_api_key_8, t0.footer_content AS footer_content_9, t0.utm_variables AS utm_variables_10, t0.cgu_url AS cgu_url_11, t0.privacy_url AS privacy_url_12, t0.site_name AS site_name_13, t0.deleted_at AS deleted_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.uuid AS uuid_17, t0.company_id AS company_id_18 FROM app_campaign t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "e4fd65f7-72a6-4d6a-a135-fb02c3137d3d"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.name AS name_3,
  t0.is_enabled AS is_enabled_4,
  t0.register_url AS register_url_5,
  t0.crm_api_key AS crm_api_key_6,
  t0.webhook_url AS webhook_url_7,
  t0.olead_api_key AS olead_api_key_8,
  t0.footer_content AS footer_content_9,
  t0.utm_variables AS utm_variables_10,
  t0.cgu_url AS cgu_url_11,
  t0.privacy_url AS privacy_url_12,
  t0.site_name AS site_name_13,
  t0.deleted_at AS deleted_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.uuid AS uuid_17,
  t0.company_id AS company_id_18
FROM
  app_campaign t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.name AS name_3, t0.is_enabled AS is_enabled_4, t0.register_url AS register_url_5, t0.crm_api_key AS crm_api_key_6, t0.webhook_url AS webhook_url_7, t0.olead_api_key AS olead_api_key_8, t0.footer_content AS footer_content_9, t0.utm_variables AS utm_variables_10, t0.cgu_url AS cgu_url_11, t0.privacy_url AS privacy_url_12, t0.site_name AS site_name_13, t0.deleted_at AS deleted_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.uuid AS uuid_17, t0.company_id AS company_id_18 FROM app_campaign t0 WHERE t0.uuid = 'e4fd65f7-72a6-4d6a-a135-fb02c3137d3d' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
4	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 60)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
6	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 40)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 173)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.07 ms
(12.46%)

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.url AS url_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8, a0_.company_id AS company_id_9, a0_.campaign_id AS campaign_id_10, a0_.type_id AS type_id_11 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = ? AND a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC

Parameters:

[
  "module"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.url AS url_3,
  a0_.is_enabled AS is_enabled_4,
  a0_.deleted_at AS deleted_at_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.uuid AS uuid_8,
  a0_.company_id AS company_id_9,
  a0_.campaign_id AS campaign_id_10,
  a0_.type_id AS type_id_11
FROM
  app_partner a0_
  LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id
WHERE
  a1_.identifier = ?
  AND a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.url AS url_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8, a0_.company_id AS company_id_9, a0_.campaign_id AS campaign_id_10, a0_.type_id AS type_id_11 FROM app_partner a0_ LEFT JOIN app_term a1_ ON a0_.type_id = a1_.id WHERE a1_.identifier = 'module' AND a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name 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	App\Repository\PartnerRepository->getAll (line 72)
7	App\Controller\Admin\AdminController->mainMenu (line 117)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
15	__TwigTemplate_b5a8be9f18af217ed17ae01d0b15f0e0->doDisplay (line 52)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Extension\CoreExtension->include (line 1526)
21	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5::block_body (line 107)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5->doDisplay (line 54)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
34	App\Controller\Admin\CampaignController->edit (line 169)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 208)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

1.00 ms
(11.69%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.domain AS domain_2, a0_.modules AS modules_3, a0_.is_enabled AS is_enabled_4, a0_.is_check_valid_email AS is_check_valid_email_5, a0_.gtm_id AS gtm_id_6, a0_.identifier AS identifier_7, a0_.deleted_at AS deleted_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.uuid AS uuid_11 FROM app_company a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.domain AS domain_2,
  a0_.modules AS modules_3,
  a0_.is_enabled AS is_enabled_4,
  a0_.is_check_valid_email AS is_check_valid_email_5,
  a0_.gtm_id AS gtm_id_6,
  a0_.identifier AS identifier_7,
  a0_.deleted_at AS deleted_at_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.uuid AS uuid_11
FROM
  app_company a0_
WHERE
  a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.domain AS domain_2, a0_.modules AS modules_3, a0_.is_enabled AS is_enabled_4, a0_.is_check_valid_email AS is_check_valid_email_5, a0_.gtm_id AS gtm_id_6, a0_.identifier AS identifier_7, a0_.deleted_at AS deleted_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.uuid AS uuid_11 FROM app_company a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.name 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	App\Repository\CompanyRepository->getAll (line 70)
7	App\Form\CampaignFormType->buildForm (line 32)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 102)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 79)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 58)
11	Symfony\Component\Form\FormFactory->createBuilder (line 43)
12	Symfony\Component\Form\FormFactory->create (line 28)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 344)
14	App\Controller\Admin\CampaignController->edit (line 152)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 208)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

0.86 ms
(10.06%)

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8 FROM app_taxonomy a0_ WHERE a0_.is_enabled = ? AND a0_.deleted_at IS NULL ORDER BY a0_.name ASC

Parameters:

[
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.identifier AS identifier_1,
  a0_.name AS name_2,
  a0_.description AS description_3,
  a0_.is_enabled AS is_enabled_4,
  a0_.deleted_at AS deleted_at_5,
  a0_.created_at AS created_at_6,
  a0_.updated_at AS updated_at_7,
  a0_.uuid AS uuid_8
FROM
  app_taxonomy a0_
WHERE
  a0_.is_enabled = ?
  AND a0_.deleted_at IS NULL
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.description AS description_3, a0_.is_enabled AS is_enabled_4, a0_.deleted_at AS deleted_at_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7, a0_.uuid AS uuid_8 FROM app_taxonomy a0_ WHERE a0_.is_enabled = 1 AND a0_.deleted_at IS NULL ORDER BY a0_.name 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	App\Repository\TaxonomyRepository->getAll (line 70)
7	App\Controller\Admin\AdminController->mainMenu (line 108)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 78)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 83)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 47)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 44)
15	__TwigTemplate_b5a8be9f18af217ed17ae01d0b15f0e0->doDisplay (line 52)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Extension\CoreExtension->include (line 1526)
21	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5::block_body (line 107)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5->doDisplay (line 54)
26	Twig\Template->yield (line 402)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 373)
29	Twig\TemplateWrapper->render (line 51)
30	Twig\Environment->render (line 333)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
34	App\Controller\Admin\CampaignController->edit (line 169)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
37	Symfony\Component\HttpKernel\Kernel->handle (line 208)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
39	require_once (line 29)
40	require_once (line 5)

0.81 ms
(9.49%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.is_public AS is_public_4, t0.is_enabled AS is_enabled_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uuid AS uuid_9 FROM app_media t0 WHERE t0.id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.original_filename AS original_filename_3,
  t0.is_public AS is_public_4,
  t0.is_enabled AS is_enabled_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.uuid AS uuid_9
FROM
  app_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_filename AS original_filename_3, t0.is_public AS is_public_4, t0.is_enabled AS is_enabled_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uuid AS uuid_9 FROM app_media t0 WHERE t0.id = 25;

#	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 337)
4	Closure->__invoke (line 201)
5	Proxies\__CG__\App\Entity\Media->getFilename (line 201)
6	Twig\Extension\CoreExtension->getAttribute (line 1919)
7	__TwigTemplate_37f60a7ccd5c3ccd572e7457caff7fa0::doDisplay (line 227)
8	Twig\Template->yield (line 402)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Extension\CoreExtension->include (line 1526)
13	__TwigTemplate_b5a8be9f18af217ed17ae01d0b15f0e0::doDisplay (line 48)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Extension\CoreExtension->include (line 1526)
19	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5::block_body (line 107)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_2a50e02ff5fa7e10153bb19e92e8cff5->doDisplay (line 54)
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 452)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
32	App\Controller\Admin\CampaignController->edit (line 169)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
35	Symfony\Component\HttpKernel\Kernel->handle (line 208)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
37	require_once (line 29)
38	require_once (line 5)

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
App\Entity\Taxonomy	33
App\Entity\Partner	6
App\Entity\Company	5
App\Entity\Term	2
App\Entity\User	1
App\Entity\Media	1
App\Entity\Campaign	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Term	No errors.
App\Entity\Media	No errors.
App\Entity\Company	No errors.
App\Entity\Event	No errors.
App\Entity\Campaign	No errors.
App\Entity\Taxonomy	No errors.
App\Entity\Partner	No errors.
App\Entity\Lead	No errors.

Symfony Profiler

GET https://d.app.woptimizer.com/admin/campaign/e4fd65f7-72a6-4d6a-a135-fb02c3137d3d/edit

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping