Symfony Profiler

Query Metrics

44 Database Queries

7 Different statements

16.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.83 ms
(41.73%)

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = ? AND (? BETWEEN c0_.dtfrom AND c0_.dtto)

Parameters:

[
  13
  "2025-12-09 18:06:22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0
FROM
  catalog c0_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )

SELECT c0_.id AS id_0 FROM catalog c0_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = 13 AND ('2025-12-09 18:06:22' BETWEEN c0_.dtfrom AND c0_.dtto);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 73)
7	App\Repository\CatalogRepository->countActiveForAdvertiser (line 24)
8	App\Controller\AdvertiserController->activeCatalogs (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 61)
16	__TwigTemplate_a8866121b50a3b824e44ee0b98dae46d->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 1347)
21	twig_include (line 287)
22	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->block_content (line 171)
23	Twig\Template->displayBlock (line 374)
24	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
25	Twig\Template->displayWithErrorHandling (line 367)
26	Twig\Template->display (line 51)
27	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->doDisplay (line 394)
28	Twig\Template->displayWithErrorHandling (line 367)
29	Twig\Template->display (line 379)
30	Twig\Template->render (line 38)
31	Twig\TemplateWrapper->render (line 280)
32	Twig\Environment->render (line 448)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
36	App\Controller\AdvertiserController->index (line 181)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

5.32 ms
(32.52%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM image t0 WHERE t0.id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.alt AS alt_3,
  t0.filename AS filename_4
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.filename AS filename_4 FROM image t0 WHERE t0.id = 25;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\Image::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Image->__get (line 77)
8	App\Entity\Image->getFilename (line 1635)
9	twig_get_attribute (line 95)
10	__TwigTemplate_a8866121b50a3b824e44ee0b98dae46d->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 1347)
15	twig_include (line 287)
16	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->block_content (line 171)
17	Twig\Template->displayBlock (line 374)
18	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 51)
21	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
30	App\Controller\AdvertiserController->index (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.26 ms
(7.70%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE ? BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 2

Parameters:

[
  "2025-12-09 18:06:22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  ? BETWEEN c0_.dtfrom
  AND c0_.dtto
ORDER BY
  c0_.id DESC
LIMIT
  2

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE '2025-12-09 18:06:22' BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 164)
7	App\Repository\CatalogRepository->findLatest (line 50)
8	App\Controller\AdvertiserController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.89 ms
(5.43%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE c0_.label_code <> 0 AND c0_.label_code IS NOT NULL AND (? BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.label_code ASC

Parameters:

[
  "2025-12-09 18:06:22"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.date AS date_2,
  c0_.dtfrom AS dtfrom_3,
  c0_.dtto AS dtto_4,
  c0_.link AS link_5,
  c0_.precedence AS precedence_6,
  c0_.statut AS statut_7,
  c0_.label_code AS label_code_8,
  c0_.label_text AS label_text_9,
  c0_.keywords AS keywords_10,
  c0_.slug AS slug_11,
  c0_.cover_id AS cover_id_12,
  c0_.pdf_id AS pdf_id_13,
  c0_.advertiser_id AS advertiser_id_14
FROM
  catalog c0_
WHERE
  c0_.label_code <> 0
  AND c0_.label_code IS NOT NULL
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )
ORDER BY
  c0_.label_code ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.dtfrom AS dtfrom_3, c0_.dtto AS dtto_4, c0_.link AS link_5, c0_.precedence AS precedence_6, c0_.statut AS statut_7, c0_.label_code AS label_code_8, c0_.label_text AS label_text_9, c0_.keywords AS keywords_10, c0_.slug AS slug_11, c0_.cover_id AS cover_id_12, c0_.pdf_id AS pdf_id_13, c0_.advertiser_id AS advertiser_id_14 FROM catalog c0_ WHERE c0_.label_code <> 0 AND c0_.label_code IS NOT NULL AND ('2025-12-09 18:06:22' BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.label_code ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 154)
7	App\Repository\CatalogRepository->findANPM (line 46)
8	App\Controller\AdvertiserController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.80 ms
(4.89%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%' ORDER BY a0_.company ASC) 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_.company AS company_1,
          a0_.category AS category_2,
          a0_.adress AS adress_3,
          a0_.box AS box_4,
          a0_.zip AS zip_5,
          a0_.city AS city_6,
          a0_.facebook AS facebook_7,
          a0_.twitter AS twitter_8,
          a0_.linkedin AS linkedin_9,
          a0_.date AS date_10,
          a0_.phones AS phones_11,
          a0_.slug AS slug_12
        FROM
          advertiser a0_
        WHERE
          a0_.company NOT LIKE 'ZZZ%'
        ORDER BY
          a0_.company ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%' ORDER BY a0_.company ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 45)
8	App\Controller\AdvertiserController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.69 ms
(4.23%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, company_1 FROM (SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%') dctrn_result_inner ORDER BY company_1 ASC) dctrn_result LIMIT 20 OFFSET 40

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      company_1
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.company AS company_1,
          a0_.category AS category_2,
          a0_.adress AS adress_3,
          a0_.box AS box_4,
          a0_.zip AS zip_5,
          a0_.city AS city_6,
          a0_.facebook AS facebook_7,
          a0_.twitter AS twitter_8,
          a0_.linkedin AS linkedin_9,
          a0_.date AS date_10,
          a0_.phones AS phones_11,
          a0_.slug AS slug_12
        FROM
          advertiser a0_
        WHERE
          a0_.company NOT LIKE 'ZZZ%'
      ) dctrn_result_inner
    ORDER BY
      company_1 ASC
  ) dctrn_result
LIMIT
  20 OFFSET 40

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, company_1 FROM (SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%') dctrn_result_inner ORDER BY company_1 ASC) dctrn_result LIMIT 20 OFFSET 40;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 50)
8	__TwigTemplate_a8866121b50a3b824e44ee0b98dae46d->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 1347)
13	twig_include (line 287)
14	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->block_content (line 171)
15	Twig\Template->displayBlock (line 374)
16	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 51)
19	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
28	App\Controller\AdvertiserController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.57 ms
(3.50%)

SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12, a0_.logobig_id AS logobig_id_13, a0_.logosmall_id AS logosmall_id_14, a0_.loyalty_id AS loyalty_id_15 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%' AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.company ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.company AS company_1,
  a0_.category AS category_2,
  a0_.adress AS adress_3,
  a0_.box AS box_4,
  a0_.zip AS zip_5,
  a0_.city AS city_6,
  a0_.facebook AS facebook_7,
  a0_.twitter AS twitter_8,
  a0_.linkedin AS linkedin_9,
  a0_.date AS date_10,
  a0_.phones AS phones_11,
  a0_.slug AS slug_12,
  a0_.logobig_id AS logobig_id_13,
  a0_.logosmall_id AS logosmall_id_14,
  a0_.loyalty_id AS loyalty_id_15
FROM
  advertiser a0_
WHERE
  a0_.company NOT LIKE 'ZZZ%'
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  a0_.company ASC

SELECT a0_.id AS id_0, a0_.company AS company_1, a0_.category AS category_2, a0_.adress AS adress_3, a0_.box AS box_4, a0_.zip AS zip_5, a0_.city AS city_6, a0_.facebook AS facebook_7, a0_.twitter AS twitter_8, a0_.linkedin AS linkedin_9, a0_.date AS date_10, a0_.phones AS phones_11, a0_.slug AS slug_12, a0_.logobig_id AS logobig_id_13, a0_.logosmall_id AS logosmall_id_14, a0_.loyalty_id AS loyalty_id_15 FROM advertiser a0_ WHERE a0_.company NOT LIKE 'ZZZ%' AND a0_.id IN (13, 14, 84, 89, 101, 155, 92, 162, 115, 146, 87, 81, 123, 168, 192, 182, 189, 159, 16, 17) ORDER BY a0_.company ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 50)
8	__TwigTemplate_a8866121b50a3b824e44ee0b98dae46d->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 1347)
13	twig_include (line 287)
14	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->block_content (line 171)
15	Twig\Template->displayBlock (line 374)
16	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 51)
19	__TwigTemplate_6fe242aa99c2f2f21dc9ca8f0ad63d22->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 448)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 66)
28	App\Controller\AdvertiserController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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.

Entities Mapping

Class	Mapping errors
App\Entity\Advertiser	No errors.
App\Entity\Catalog	No errors.
App\Entity\Cover	No errors.
App\Entity\CatalogPdf	No errors.
App\Entity\Image	No errors.
App\Entity\Contact	No errors.
App\Entity\Googlemap	No errors.
App\Entity\Category	No errors.
App\Entity\Code	No errors.
App\Entity\Icon	No errors.
App\Entity\CategoryGroup	No errors.

Symfony Profiler

GET https://test20204.tahitibestpromo.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CAdvertiserController%253A%253AactiveCa…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping