Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

3.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.77 ms
(25.29%)

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = ?) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = ?) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = ? AND b0_.publication_at <= ? AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name ASC

Parameters:

[
  3
  3
  1
  "2024-11-25 17:29:07"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b1_.name AS name_1,
  b1_.slug AS slug_2,
  b2_.id AS id_3,
  b3_.name AS name_4
FROM
  brand b0_
  LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id
  AND (b1_.language_id = ?)
  LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id
  LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id
  AND (b3_.language_id = ?)
WHERE
  b0_.deleted_at IS NULL
  AND b0_.is_enable = ?
  AND b0_.publication_at <= ?
  AND b0_.is_public = 1
ORDER BY
  b2_.id ASC,
  b0_.position ASC,
  b1_.name ASC

SELECT b0_.id AS id_0, b1_.name AS name_1, b1_.slug AS slug_2, b2_.id AS id_3, b3_.name AS name_4 FROM brand b0_ LEFT JOIN brand_lang b1_ ON b0_.id = b1_.brand_id AND (b1_.language_id = 3) LEFT JOIN brand_type b2_ ON b0_.brand_type_id = b2_.id LEFT JOIN brand_type_lang b3_ ON b2_.id = b3_.brand_type_id AND (b3_.language_id = 3) WHERE b0_.deleted_at IS NULL AND b0_.is_enable = 1 AND b0_.publication_at <= '2024-11-25 17:29:07' AND b0_.is_public = 1 ORDER BY b2_.id ASC, b0_.position ASC, b1_.name 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 297)
7	App\Repository\Brand\BrandRepository->getBrandsAccess (line 28)
8	App\Service\Brand\BrandAccessManager->getBrands (line 38)
9	App\Service\Brand\BrandAccessManager->getBrandsByTypes (line 27)
10	App\Twig\Menu\MenuBrandExtension->getMenuBrand (line 244)
11	__TwigTemplate_8bc49cbc250b0d72987b303b338e6412->doDisplay (line 393)
12	Twig\Template->yield (line 83)
13	__TwigTemplate_b6c858afaa3f71a751e35cb05ace3ed7->doDisplay (line 393)
14	Twig\Template->yield (line 55)
15	__TwigTemplate_70096786c9a6c31ac2df12a6027307da->doDisplay (line 393)
16	Twig\Template->yield (line 349)
17	Twig\Template->display (line 364)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 306)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
24	App\Controller\Front\Contact\ContactController->form (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.61 ms
(19.88%)

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = ?) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = ?) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = ? AND m0_.is_enable = ? ORDER BY m0_.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.position AS position_1,
  m0_.is_enable AS is_enable_2,
  l1_.id AS id_3,
  m0_.title AS title_4,
  p2_.slug AS slug_5,
  m0_.page_statique AS page_statique_6,
  m0_.type AS type_7,
  c3_.slug AS slug_8,
  p4_.id AS id_9
FROM
  menu m0_
  LEFT JOIN page p4_ ON m0_.page_id = p4_.id
  LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id
  AND (p2_.language_id = ?)
  LEFT JOIN category c5_ ON m0_.category_id = c5_.id
  LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id
  AND (c3_.language_id = ?)
  LEFT JOIN language l1_ ON m0_.language_id = l1_.id
WHERE
  m0_.deleted_at IS NULL
  AND l1_.id = ?
  AND m0_.is_enable = ?
ORDER BY
  m0_.position ASC

SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.is_enable AS is_enable_2, l1_.id AS id_3, m0_.title AS title_4, p2_.slug AS slug_5, m0_.page_statique AS page_statique_6, m0_.type AS type_7, c3_.slug AS slug_8, p4_.id AS id_9 FROM menu m0_ LEFT JOIN page p4_ ON m0_.page_id = p4_.id LEFT JOIN page_lang p2_ ON p4_.id = p2_.page_id AND (p2_.language_id = 3) LEFT JOIN category c5_ ON m0_.category_id = c5_.id LEFT JOIN category_lang c3_ ON c5_.id = c3_.category_id AND (c3_.language_id = 3) LEFT JOIN language l1_ ON m0_.language_id = l1_.id WHERE m0_.deleted_at IS NULL AND l1_.id = 3 AND m0_.is_enable = '1' ORDER BY m0_.position 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 104)
7	App\Repository\MenuRepository->getMenuFooter (line 42)
8	App\Twig\Menu\MenuFooterExtension->getMenuFooter (line 79)
9	__TwigTemplate_281f9b51a0af5d23ad9f13acd594dacf->doDisplay (line 393)
10	Twig\Template->yield (line 95)
11	__TwigTemplate_b6c858afaa3f71a751e35cb05ace3ed7->doDisplay (line 393)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_70096786c9a6c31ac2df12a6027307da->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
22	App\Controller\Front\Contact\ContactController->form (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 5)

0.54 ms
(17.79%)

SELECT s0_.id AS id_0, s0_.is_public AS is_public_1, s0_.is_connect AS is_connect_2, s0_.is_enable AS is_enable_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM subject s0_ LEFT JOIN subject_lang s1_ ON s0_.id = s1_.subject_id AND (s1_.language_id = ?) WHERE s0_.deleted_at IS NULL AND s0_.is_enable = ? AND s0_.is_public = ? ORDER BY s0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.is_public AS is_public_1,
  s0_.is_connect AS is_connect_2,
  s0_.is_enable AS is_enable_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  subject s0_
  LEFT JOIN subject_lang s1_ ON s0_.id = s1_.subject_id
  AND (s1_.language_id = ?)
WHERE
  s0_.deleted_at IS NULL
  AND s0_.is_enable = ?
  AND s0_.is_public = ?
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.is_public AS is_public_1, s0_.is_connect AS is_connect_2, s0_.is_enable AS is_enable_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM subject s0_ LEFT JOIN subject_lang s1_ ON s0_.id = s1_.subject_id AND (s1_.language_id = 3) WHERE s0_.deleted_at IS NULL AND s0_.is_enable = 1 AND s0_.is_public = 1 ORDER BY s0_.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 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 194)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 83)
21	App\Controller\Front\Contact\ContactController->form (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.46 ms
(15.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.subject_id AS subject_id_4 FROM subject_lang t0 WHERE t0.language_id = ? AND t0.subject_id = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.subject_id AS subject_id_4
FROM
  subject_lang t0
WHERE
  t0.language_id = ?
  AND t0.subject_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.subject_id AS subject_id_4 FROM subject_lang t0 WHERE t0.language_id = 3 AND t0.subject_id = 4 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 53)
5	App\Form\Contact\UserMessageType->App\Form\Contact\{closure} (line 162)
6	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 249)
7	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 128)
8	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 183)
9	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 194)
10	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 473)
11	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
13	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
14	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
17	Symfony\Component\Form\Form->createView (line 903)
18	Symfony\Component\Form\Form->createView (line 83)
19	App\Controller\Front\Contact\ContactController->form (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.34 ms
(11.24%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.is_enable AS is_enable_4,
  t0.is_default AS is_default_5
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_enable AS is_enable_4, t0.is_default AS is_default_5 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 37)
5	App\Service\Manager\LanguagesManager->getCurrentLangue (line 20)
6	App\Controller\CoreController->getCurrentLangue (line 32)
7	App\Controller\Front\Contact\ContactController->form (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.33 ms
(10.71%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = ? AND t0.parameter IS NULL AND t0.route = ? LIMIT 1

Parameters:

[
  3
  "app_front_contact"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.route AS route_3,
  t0.parameter AS parameter_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.no_index AS no_index_7,
  t0.language_id AS language_id_8
FROM
  seo t0
WHERE
  t0.language_id = ?
  AND t0.parameter IS NULL
  AND t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.route AS route_3, t0.parameter AS parameter_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.no_index AS no_index_7, t0.language_id AS language_id_8 FROM seo t0 WHERE t0.language_id = 3 AND t0.parameter IS NULL AND t0.route = 'app_front_contact' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 42)
5	App\Service\Data\SeoData->getSeo (line 29)
6	App\Twig\Seo\MetaSeoExtension->getMetaSeo (line 140)
7	__TwigTemplate_b6c858afaa3f71a751e35cb05ace3ed7->block_meta (line 437)
8	Twig\Template->yieldBlock (line 62)
9	__TwigTemplate_b6c858afaa3f71a751e35cb05ace3ed7->doDisplay (line 393)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_70096786c9a6c31ac2df12a6027307da->doDisplay (line 393)
12	Twig\Template->yield (line 349)
13	Twig\Template->display (line 364)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 83)
20	App\Controller\Front\Contact\ContactController->form (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\Language	No errors.
App\Entity\Contact\Subject	No errors.
App\Entity\Contact\SubjectLang	No errors.
App\Entity\Contact\SubjectEmailList	No errors.
App\Entity\Contact\UserMessage	No errors.
App\Entity\Seo	No errors.
App\Entity\Brand\Brand	No errors.
App\Entity\Brand\BrandLang	No errors.
App\Entity\Brand\BrandType	No errors.
App\Entity\Brand\BrandTypeLang	No errors.
App\Entity\Menu	No errors.
App\Entity\Pages\Page	No errors.
App\Entity\Pages\PageLang	No errors.
App\Entity\Pages\Category	No errors.
App\Entity\Pages\CategoryLang	No errors.

Symfony Profiler

GET https://brandcenter.covea.netissedev.com/fr/contact/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping