Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

9.14 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.21 ms
(35.09%)

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 3

Parameters:

[
  "2025-12-09 19:19:09"
]

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
  3

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 19:19:09' BETWEEN c0_.dtfrom AND c0_.dtto ORDER BY c0_.id DESC LIMIT 3;

#	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 64)
8	App\Controller\CatalogController->indexForAdvertiser (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)

1.91 ms
(20.93%)

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE ? BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption ASC

Parameters:

[
  "2025-12-09 19:19:09"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.caption AS caption_1,
  c0_.font AS font_2,
  c0_.picture AS picture_3,
  c0_.slug AS slug_4,
  c0_.icon_id AS icon_id_5,
  c0_.icon2_id AS icon2_id_6,
  c0_.categorygroup_id AS categorygroup_id_7
FROM
  category c0_
  INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id
  INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id
WHERE
  ? BETWEEN c1_.dtfrom
  AND c1_.dtto
ORDER BY
  c0_.caption ASC

SELECT c0_.id AS id_0, c0_.caption AS caption_1, c0_.font AS font_2, c0_.picture AS picture_3, c0_.slug AS slug_4, c0_.icon_id AS icon_id_5, c0_.icon2_id AS icon2_id_6, c0_.categorygroup_id AS categorygroup_id_7 FROM category c0_ INNER JOIN catalog_category c2_ ON c0_.id = c2_.category_id INNER JOIN catalog c1_ ON c1_.id = c2_.catalog_id WHERE '2025-12-09 19:19:09' BETWEEN c1_.dtfrom AND c1_.dtto ORDER BY c0_.caption 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 83)
7	App\Repository\CategoryRepository->findActive (line 64)
8	App\Repository\CategoryRepository->findForFooter (line 17)
9	App\Controller\FooterController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
12	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
13	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
14	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
15	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
16	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 428)
17	__TwigTemplate_cf6e113c8d8894064dd48e7c9b0d9150->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 51)
20	__TwigTemplate_57471f67086bc2beef4258809c51ebdd->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
29	App\Controller\CatalogController->indexForAdvertiser (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

1.07 ms
(11.75%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1427)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 64)
5	App\Tools\ClicCount->addClicCount (line 61)
6	App\Controller\CatalogController->indexForAdvertiser (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.78 ms
(8.48%)

SELECT t0.id AS id_1, t0.company AS company_2, t0.category AS category_3, t0.adress AS adress_4, t0.box AS box_5, t0.zip AS zip_6, t0.city AS city_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.date AS date_11, t0.phones AS phones_12, t0.slug AS slug_13, t0.logobig_id AS logobig_id_14, t0.logosmall_id AS logosmall_id_15, t0.loyalty_id AS loyalty_id_16 FROM advertiser t0 WHERE t0.id = ?

Parameters:

[
  "118"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.category AS category_3,
  t0.adress AS adress_4,
  t0.box AS box_5,
  t0.zip AS zip_6,
  t0.city AS city_7,
  t0.facebook AS facebook_8,
  t0.twitter AS twitter_9,
  t0.linkedin AS linkedin_10,
  t0.date AS date_11,
  t0.phones AS phones_12,
  t0.slug AS slug_13,
  t0.logobig_id AS logobig_id_14,
  t0.logosmall_id AS logosmall_id_15,
  t0.loyalty_id AS loyalty_id_16
FROM
  advertiser t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company AS company_2, t0.category AS category_3, t0.adress AS adress_4, t0.box AS box_5, t0.zip AS zip_6, t0.city AS city_7, t0.facebook AS facebook_8, t0.twitter AS twitter_9, t0.linkedin AS linkedin_10, t0.date AS date_11, t0.phones AS phones_12, t0.slug AS slug_13, t0.logobig_id AS logobig_id_14, t0.logosmall_id AS logosmall_id_15, t0.loyalty_id AS loyalty_id_16 FROM advertiser t0 WHERE t0.id = '118';

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 57)
7	App\Controller\CatalogController->indexForAdvertiser (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.76 ms
(8.33%)

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_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = ? AND (? BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.id DESC

Parameters:

[
  "118"
  "2025-12-09 19:19:09"
]

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_
  INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id
WHERE
  a1_.id = ?
  AND (
    ? BETWEEN c0_.dtfrom
    AND c0_.dtto
  )
ORDER BY
  c0_.id DESC

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_ INNER JOIN advertiser a1_ ON c0_.advertiser_id = a1_.id WHERE a1_.id = '118' AND ('2025-12-09 19:19:09' BETWEEN c0_.dtfrom AND c0_.dtto) ORDER BY c0_.id DESC;

#	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 86)
7	App\Repository\CatalogRepository->findByAdvertiser (line 63)
8	App\Controller\CatalogController->indexForAdvertiser (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.51 ms
(5.64%)

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.comment AS comment_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.phone AS phone_6, t0.advertiser_id AS advertiser_id_7 FROM googlemap t0 WHERE t0.advertiser_id = ?

Parameters:

[
  118
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.comment AS comment_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.phone AS phone_6,
  t0.advertiser_id AS advertiser_id_7
FROM
  googlemap t0
WHERE
  t0.advertiser_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.comment AS comment_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.phone AS phone_6, t0.advertiser_id AS advertiser_id_7 FROM googlemap t0 WHERE t0.advertiser_id = 118;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2696)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 107)
8	App\Controller\CatalogController->getMaps (line 71)
9	App\Controller\CatalogController->indexForAdvertiser (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.45 ms
(4.96%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 64)
4	App\Tools\ClicCount->addClicCount (line 61)
5	App\Controller\CatalogController->indexForAdvertiser (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.44 ms
(4.83%)

INSERT INTO visit_catalog (addressip, datetime, userid, username, count, catalogid) VALUES (?, ?, ?, ?, ?, ?)

Parameters:

[
  "216.73.216.44"
  "2025-12-09 19:19:09"
  1
  "ADVERTISER"
  1
  118
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO visit_catalog (
  addressip, datetime, userid, username,
  count, catalogid
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO visit_catalog (addressip, datetime, userid, username, count, catalogid) VALUES ('216.73.216.44', '2025-12-09 19:19:09', 1, 'ADVERTISER', 1, 118);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 249)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1048)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 399)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 64)
7	App\Tools\ClicCount->addClicCount (line 61)
8	App\Controller\CatalogController->indexForAdvertiser (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)

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\Catalog	No errors.
App\Entity\Advertiser	No errors.
App\Entity\Image	No errors.
App\Entity\Contact	No errors.
App\Entity\Googlemap	No errors.
App\Entity\VisitCatalog	No errors.
App\Entity\Cover	No errors.
App\Entity\CatalogPdf	No errors.
App\Entity\Category	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%255CFooterController%253A%253Aindex

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping