Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

5.80 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.71 ms
(29.44%)

SELECT h0_.id AS id_0, h0_.contenu AS contenu_1, h0_.linkto AS linkto_2, h0_.image_name AS image_name_3, h0_.updated_at AS updated_at_4, h0_.actif AS actif_5 FROM homepub h0_ ORDER BY h0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.contenu AS contenu_1,
  h0_.linkto AS linkto_2,
  h0_.image_name AS image_name_3,
  h0_.updated_at AS updated_at_4,
  h0_.actif AS actif_5
FROM
  homepub h0_
ORDER BY
  h0_.id DESC
LIMIT
  1

SELECT h0_.id AS id_0, h0_.contenu AS contenu_1, h0_.linkto AS linkto_2, h0_.image_name AS image_name_3, h0_.updated_at AS updated_at_4, h0_.actif AS actif_5 FROM homepub h0_ ORDER BY h0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 25)
7	App\Domain\Portailweb\Admin\Repository\HomepubRepository->findLatestOne (line 29)
8	App\Controller\Portailweb\Frontoffice\PortailhomeController->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)

1.35 ms
(23.32%)

SELECT h0_.id AS id_0, h0_.designation AS designation_1, h0_.titre AS titre_2, h0_.contenu AS contenu_3, h0_.description AS description_4, h0_.linkto AS linkto_5, h0_.actif AS actif_6, h0_.homesection_name AS homesection_name_7, h0_.updated_at AS updated_at_8, h0_.background AS background_9 FROM homesection h0_ WHERE h0_.background = ? AND h0_.actif = ? ORDER BY h0_.id ASC

Parameters:

[
  "0"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.designation AS designation_1,
  h0_.titre AS titre_2,
  h0_.contenu AS contenu_3,
  h0_.description AS description_4,
  h0_.linkto AS linkto_5,
  h0_.actif AS actif_6,
  h0_.homesection_name AS homesection_name_7,
  h0_.updated_at AS updated_at_8,
  h0_.background AS background_9
FROM
  homesection h0_
WHERE
  h0_.background = ?
  AND h0_.actif = ?
ORDER BY
  h0_.id ASC

SELECT h0_.id AS id_0, h0_.designation AS designation_1, h0_.titre AS titre_2, h0_.contenu AS contenu_3, h0_.description AS description_4, h0_.linkto AS linkto_5, h0_.actif AS actif_6, h0_.homesection_name AS homesection_name_7, h0_.updated_at AS updated_at_8, h0_.background AS background_9 FROM homesection h0_ WHERE h0_.background = '0' AND h0_.actif = 1 ORDER BY h0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 31)
7	App\Domain\Portailweb\Admin\Repository\HomesectionRepository->findByBackground (line 33)
8	App\Controller\Portailweb\Frontoffice\PortailhomeController->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.57 ms
(9.86%)

SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.siteweb AS siteweb_2, e0_.entreprise_name AS entreprise_name_3, e0_.updated_at AS updated_at_4, e0_.type AS type_5, e0_.description AS description_6, e0_.actif AS actif_7 FROM entreprise e0_ WHERE e0_.type = ? AND e0_.actif = ? ORDER BY e0_.id DESC

Parameters:

[
  "Partenaire"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.designation AS designation_1,
  e0_.siteweb AS siteweb_2,
  e0_.entreprise_name AS entreprise_name_3,
  e0_.updated_at AS updated_at_4,
  e0_.type AS type_5,
  e0_.description AS description_6,
  e0_.actif AS actif_7
FROM
  entreprise e0_
WHERE
  e0_.type = ?
  AND e0_.actif = ?
ORDER BY
  e0_.id DESC

SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.siteweb AS siteweb_2, e0_.entreprise_name AS entreprise_name_3, e0_.updated_at AS updated_at_4, e0_.type AS type_5, e0_.description AS description_6, e0_.actif AS actif_7 FROM entreprise e0_ WHERE e0_.type = 'Partenaire' AND e0_.actif = 1 ORDER BY e0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 73)
7	App\Domain\Portailweb\Admin\Repository\EntrepriseRepository->findByType (line 31)
8	App\Controller\Portailweb\Frontoffice\PortailhomeController->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.53 ms
(9.07%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.homesection_id AS homesection_id_4 FROM sectionpoint t0 WHERE t0.homesection_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.titre AS titre_3,
  t0.homesection_id AS homesection_id_4
FROM
  sectionpoint t0
WHERE
  t0.homesection_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.titre AS titre_3, t0.homesection_id AS homesection_id_4 FROM sectionpoint t0 WHERE t0.homesection_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1241)
9	Twig\Extension\CoreExtension::length (line 426)
10	__TwigTemplate_a91d2cc013225317ae5cfcf7fe6f471a->block_body (line 432)
11	Twig\Template->yieldBlock (line 527)
12	__TwigTemplate_6a14b95e3a74b8f704898ffdd8baca59->doDisplay (line 388)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_a91d2cc013225317ae5cfcf7fe6f471a->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 40)
23	App\Controller\Portailweb\Frontoffice\PortailhomeController->index (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.48 ms
(8.33%)

SELECT r0_.id AS id_0, r0_.designation AS designation_1, r0_.actif AS actif_2, r0_.url AS url_3 FROM reseausocial r0_ WHERE r0_.actif = ? ORDER BY r0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.designation AS designation_1,
  r0_.actif AS actif_2,
  r0_.url AS url_3
FROM
  reseausocial r0_
WHERE
  r0_.actif = ?
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.designation AS designation_1, r0_.actif AS actif_2, r0_.url AS url_3 FROM reseausocial r0_ WHERE r0_.actif = 1 ORDER BY r0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 31)
7	App\Domain\Portailweb\Admin\Repository\ReseausocialRepository->findByStatut (line 144)
8	App\GlobalCall\Portailweb\PortailwebGlobalCall->getActifReseauxsociaux (line 246)
9	App\GlobalCall\GlobalCall->getActifReseauxsociaux (line 1882)
10	Twig\Extension\CoreExtension::getAttribute (line 60)
11	__TwigTemplate_6a14b95e3a74b8f704898ffdd8baca59->doDisplay (line 388)
12	Twig\Template->yield (line 55)
13	__TwigTemplate_a91d2cc013225317ae5cfcf7fe6f471a->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
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 40)
22	App\Controller\Portailweb\Frontoffice\PortailhomeController->index (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.43 ms
(7.36%)

SELECT q0_.id AS id_0, q0_.question AS question_1, q0_.response AS response_2, q0_.for_home AS for_home_3, q0_.icone AS icone_4, q0_.questioncategory_id AS questioncategory_id_5 FROM question q0_ WHERE q0_.for_home = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  q0_.id AS id_0,
  q0_.question AS question_1,
  q0_.response AS response_2,
  q0_.for_home AS for_home_3,
  q0_.icone AS icone_4,
  q0_.questioncategory_id AS questioncategory_id_5
FROM
  question q0_
WHERE
  q0_.for_home = ?

SELECT q0_.id AS id_0, q0_.question AS question_1, q0_.response AS response_2, q0_.for_home AS for_home_3, q0_.icone AS icone_4, q0_.questioncategory_id AS questioncategory_id_5 FROM question q0_ WHERE q0_.for_home = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 28)
7	App\Domain\Portailweb\Admin\Repository\QuestionRepository->showQuestionForHome (line 38)
8	App\Controller\Portailweb\Frontoffice\PortailhomeController->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.37 ms
(6.41%)

SELECT t0.id AS id_1, t0.titretab AS titretab_2, t0.contenu AS contenu_3 FROM hometab t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titretab AS titretab_2,
  t0.contenu AS contenu_3
FROM
  hometab t0

SELECT t0.id AS id_1, t0.titretab AS titretab_2, t0.contenu AS contenu_3 FROM hometab t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 30)
6	App\Controller\Portailweb\Frontoffice\PortailhomeController->index (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.36 ms
(6.19%)

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.designation AS designation_2
FROM
  shop_categorie t0

SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 78)
6	App\GlobalCall\Shop\ShopGlobalCall->getCategories (line 252)
7	App\GlobalCall\GlobalCall->getShopCategories (line 1882)
8	Twig\Extension\CoreExtension::getAttribute (line 63)
9	__TwigTemplate_6a14b95e3a74b8f704898ffdd8baca59->doDisplay (line 388)
10	Twig\Template->yield (line 55)
11	__TwigTemplate_a91d2cc013225317ae5cfcf7fe6f471a->doDisplay (line 388)
12	Twig\Template->yield (line 344)
13	Twig\Template->display (line 359)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 334)
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 40)
20	App\Controller\Portailweb\Frontoffice\PortailhomeController->index (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\Domain\Portailweb\Admin\Homepub	No errors.
App\Domain\Portailweb\Admin\Hometab	No errors.
App\Domain\Portailweb\Admin\Entreprise	No errors.
App\Domain\Portailweb\Admin\Homesection	No errors.
App\Domain\Portailweb\Admin\Sectionpoint	No errors.
App\Domain\Portailweb\Admin\Question	No errors.
App\Domain\Portailweb\Admin\Questioncategory	No errors.
App\Domain\Portailweb\Admin\Reseausocial	No errors.
App\Domain\Shop\ShopCategorie	No errors.
App\Domain\Shop\ShopSouscategorie	No errors.

Symfony Profiler

GET https://hellocolis.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping