Symfony Profiler

Query Metrics

13 Database Queries

9 Different statements

11.90 ms Query time

0 Invalid entities

60 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.45 ms
(20.61%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.domain AS domain_3,
  t0.modules AS modules_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_check_valid_email AS is_check_valid_email_6,
  t0.gtm_id AS gtm_id_7,
  t0.identifier AS identifier_8,
  t0.deleted_at AS deleted_at_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.uuid AS uuid_12
FROM
  app_company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.domain AS domain_3, t0.modules AS modules_4, t0.is_enabled AS is_enabled_5, t0.is_check_valid_email AS is_check_valid_email_6, t0.gtm_id AS gtm_id_7, t0.identifier AS identifier_8, t0.deleted_at AS deleted_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.uuid AS uuid_12 FROM app_company 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\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 337)
4	Closure->__invoke (line 186)
5	Proxies\__CG__\App\Entity\Company->__toString (line 186)
6	Twig\Runtime\EscaperRuntime->escape (line 126)
7	__TwigTemplate_5b8fe57493ab2beafec08e70120762ab->doDisplay (line 139)
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_40d4a82081d4535e18624254a7a4e228::block_body (line 190)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->doDisplay (line 54)
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 452)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
26	App\Controller\Admin\CampaignController->index (line 78)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

2.11 ms
(17.72%)

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.61 ms
(13.53%)

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_40d4a82081d4535e18624254a7a4e228::block_body (line 107)
25	Twig\Template->yieldBlock (line 446)
26	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
27	Twig\Template->yield (line 402)
28	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->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->index (line 78)
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.12 ms
(9.41%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.id DESC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.identifier AS identifier_1,
          a0_.name AS name_2,
          a0_.is_enabled AS is_enabled_3,
          a0_.register_url AS register_url_4,
          a0_.crm_api_key AS crm_api_key_5,
          a0_.webhook_url AS webhook_url_6,
          a0_.olead_api_key AS olead_api_key_7,
          a0_.footer_content AS footer_content_8,
          a0_.utm_variables AS utm_variables_9,
          a0_.cgu_url AS cgu_url_10,
          a0_.privacy_url AS privacy_url_11,
          a0_.site_name AS site_name_12,
          a0_.deleted_at AS deleted_at_13,
          a0_.created_at AS created_at_14,
          a0_.updated_at AS updated_at_15,
          a0_.uuid AS uuid_16
        FROM
          app_campaign a0_
        WHERE
          a0_.deleted_at IS NULL
        ORDER BY
          a0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL ORDER BY a0_.id DESC) dctrn_result) dctrn_table;

#	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->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 42)
8	Pagerfanta\Pagerfanta->getNbResults (line 290)
9	Pagerfanta\Pagerfanta->count (line 404)
10	Twig\Extension\CoreExtension->length (line 1278)
11	__TwigTemplate_5b8fe57493ab2beafec08e70120762ab::doDisplay (line 48)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1526)
17	__TwigTemplate_40d4a82081d4535e18624254a7a4e228::block_body (line 190)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->doDisplay (line 54)
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 452)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
30	App\Controller\Admin\CampaignController->index (line 78)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 208)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

1.11 ms
(9.32%)

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_40d4a82081d4535e18624254a7a4e228::block_body (line 107)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->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->index (line 78)
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.05 ms
(8.79%)

SELECT DISTINCT id_0, MIN(sclr_17) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16, ROW_NUMBER() OVER(ORDER BY a0_.id DESC) AS sclr_17 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0,
  MIN(sclr_17) AS dctrn_minrownum
FROM
  (
    SELECT
      a0_.id AS id_0,
      a0_.identifier AS identifier_1,
      a0_.name AS name_2,
      a0_.is_enabled AS is_enabled_3,
      a0_.register_url AS register_url_4,
      a0_.crm_api_key AS crm_api_key_5,
      a0_.webhook_url AS webhook_url_6,
      a0_.olead_api_key AS olead_api_key_7,
      a0_.footer_content AS footer_content_8,
      a0_.utm_variables AS utm_variables_9,
      a0_.cgu_url AS cgu_url_10,
      a0_.privacy_url AS privacy_url_11,
      a0_.site_name AS site_name_12,
      a0_.deleted_at AS deleted_at_13,
      a0_.created_at AS created_at_14,
      a0_.updated_at AS updated_at_15,
      a0_.uuid AS uuid_16,
      ROW_NUMBER() OVER(
        ORDER BY
          a0_.id DESC
      ) AS sclr_17
    FROM
      app_campaign a0_
    WHERE
      a0_.deleted_at IS NULL
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  50

SELECT DISTINCT id_0, MIN(sclr_17) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16, ROW_NUMBER() OVER(ORDER BY a0_.id DESC) AS sclr_17 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 50;

#	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->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 153)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
10	Pagerfanta\Pagerfanta->getIterator (line 412)
11	__TwigTemplate_5b8fe57493ab2beafec08e70120762ab->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1526)
17	__TwigTemplate_40d4a82081d4535e18624254a7a4e228::block_body (line 190)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->doDisplay (line 54)
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 452)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
30	App\Controller\Admin\CampaignController->index (line 78)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 208)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

0.96 ms
(8.09%)

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_40d4a82081d4535e18624254a7a4e228::block_body (line 107)
22	Twig\Template->yieldBlock (line 446)
23	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
24	Twig\Template->yield (line 402)
25	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->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->index (line 78)
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.76 ms
(6.38%)

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_40d4a82081d4535e18624254a7a4e228::block_body (line 107)
20	Twig\Template->yieldBlock (line 446)
21	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
22	Twig\Template->yield (line 402)
23	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->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->index (line 78)
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)

0.73 ms
(6.15%)

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16, a0_.company_id AS company_id_17 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.id DESC

Parameters:

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_.is_enabled AS is_enabled_3,
  a0_.register_url AS register_url_4,
  a0_.crm_api_key AS crm_api_key_5,
  a0_.webhook_url AS webhook_url_6,
  a0_.olead_api_key AS olead_api_key_7,
  a0_.footer_content AS footer_content_8,
  a0_.utm_variables AS utm_variables_9,
  a0_.cgu_url AS cgu_url_10,
  a0_.privacy_url AS privacy_url_11,
  a0_.site_name AS site_name_12,
  a0_.deleted_at AS deleted_at_13,
  a0_.created_at AS created_at_14,
  a0_.updated_at AS updated_at_15,
  a0_.uuid AS uuid_16,
  a0_.company_id AS company_id_17
FROM
  app_campaign a0_
WHERE
  a0_.deleted_at IS NULL
  AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.name AS name_2, a0_.is_enabled AS is_enabled_3, a0_.register_url AS register_url_4, a0_.crm_api_key AS crm_api_key_5, a0_.webhook_url AS webhook_url_6, a0_.olead_api_key AS olead_api_key_7, a0_.footer_content AS footer_content_8, a0_.utm_variables AS utm_variables_9, a0_.cgu_url AS cgu_url_10, a0_.privacy_url AS privacy_url_11, a0_.site_name AS site_name_12, a0_.deleted_at AS deleted_at_13, a0_.created_at AS created_at_14, a0_.updated_at AS updated_at_15, a0_.uuid AS uuid_16, a0_.company_id AS company_id_17 FROM app_campaign a0_ WHERE a0_.deleted_at IS NULL AND a0_.id IN (12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1) ORDER BY a0_.id DESC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
7	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 57)
8	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
9	Pagerfanta\Pagerfanta->getCurrentPageResults (line 243)
10	Pagerfanta\Pagerfanta->getIterator (line 412)
11	__TwigTemplate_5b8fe57493ab2beafec08e70120762ab->doDisplay (line 121)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Extension\CoreExtension->include (line 1526)
17	__TwigTemplate_40d4a82081d4535e18624254a7a4e228::block_body (line 190)
18	Twig\Template->yieldBlock (line 446)
19	__TwigTemplate_4aced05cc208fc9e8645a5980880d4c1->doDisplay (line 105)
20	Twig\Template->yield (line 402)
21	__TwigTemplate_40d4a82081d4535e18624254a7a4e228->doDisplay (line 54)
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 452)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
30	App\Controller\Admin\CampaignController->index (line 78)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 208)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	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\Campaign	12
App\Entity\Partner	6
App\Entity\Company	5
App\Entity\Term	2
App\Entity\User	1
App\Entity\Media	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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping