Symfony Profiler

Query Metrics

9 Database Queries

3 Different statements

3.03 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.20 ms
(39.70%)

SELECT j0_.site AS site_0, j0_.updated AS updated_1, j0_.contract AS contract_2, j0_.created AS created_3, j0_.description AS description_4, j0_.id AS id_5, j0_.title AS title_6, j0_.visible AS visible_7, j0_.partner_id AS partner_id_8 FROM job j0_ WHERE j0_.visible = ? ORDER BY j0_.id DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.site AS site_0,
  j0_.updated AS updated_1,
  j0_.contract AS contract_2,
  j0_.created AS created_3,
  j0_.description AS description_4,
  j0_.id AS id_5,
  j0_.title AS title_6,
  j0_.visible AS visible_7,
  j0_.partner_id AS partner_id_8
FROM
  job j0_
WHERE
  j0_.visible = ?
ORDER BY
  j0_.id DESC

SELECT j0_.site AS site_0, j0_.updated AS updated_1, j0_.contract AS contract_2, j0_.created AS created_3, j0_.description AS description_4, j0_.id AS id_5, j0_.title AS title_6, j0_.visible AS visible_7, j0_.partner_id AS partner_id_8 FROM job j0_ WHERE j0_.visible = 1 ORDER BY j0_.id DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\Site\JobSiteRepository->findAll (line 25)
7	App\Controller\Site\JobSiteController->index (line 22)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.04 ms
(34.34%)

SELECT t0.date AS date_1, t0.email AS email_2, t0.phone AS phone_3, t0.site AS site_4, t0.updated AS updated_5, t0.center AS center_6, t0.close AS close_7, t0.created AS created_8, t0.description AS description_9, t0.id AS id_10, t0.name AS name_11, t0.slug AS slug_12, t0.title AS title_13, t0.visible AS visible_14, t0.address_id AS address_id_15, t0.pdf_id AS pdf_id_16, t0.picture_id AS picture_id_17 FROM partner t0 WHERE t0.id = ?

Parameters:

[
  170
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.date AS date_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.site AS site_4,
  t0.updated AS updated_5,
  t0.center AS center_6,
  t0.close AS close_7,
  t0.created AS created_8,
  t0.description AS description_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.slug AS slug_12,
  t0.title AS title_13,
  t0.visible AS visible_14,
  t0.address_id AS address_id_15,
  t0.pdf_id AS pdf_id_16,
  t0.picture_id AS picture_id_17
FROM
  partner t0
WHERE
  t0.id = ?

SELECT t0.date AS date_1, t0.email AS email_2, t0.phone AS phone_3, t0.site AS site_4, t0.updated AS updated_5, t0.center AS center_6, t0.close AS close_7, t0.created AS created_8, t0.description AS description_9, t0.id AS id_10, t0.name AS name_11, t0.slug AS slug_12, t0.title AS title_13, t0.visible AS visible_14, t0.address_id AS address_id_15, t0.pdf_id AS pdf_id_16, t0.picture_id AS picture_id_17 FROM partner t0 WHERE t0.id = 170;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Partner::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Partner->__isset (line 258)
7	App\Entity\Partner->getPicturePath (line 145)
8	Twig\Extension\CoreExtension->getAttribute (line 1911)
9	__TwigTemplate_650e3b6b9b50b8b54bb42ab85b8db2f6::doDisplay (line 72)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_0bc3e2fb50dc7b5bc5fcea80210039bb->doDisplay (line 83)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_34229548256bfce7d4af4d4e7a7973bf->block_body (line 130)
14	Twig\Template->yieldBlock (line 446)
15	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_34229548256bfce7d4af4d4e7a7973bf->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 463)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
26	App\Controller\Site\JobSiteController->index (line 20)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 182)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 5)

0.79 ms
(25.97%)

SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = ?

Parameters:

[
  8487
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.position AS position_1,
  t0.updated AS updated_2,
  t0.created AS created_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.article_id AS article_id_6,
  t0.partner_id AS partner_id_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.position AS position_1, t0.updated AS updated_2, t0.created AS created_3, t0.id AS id_4, t0.name AS name_5, t0.article_id AS article_id_6, t0.partner_id AS partner_id_7 FROM file t0 WHERE t0.id = 8487;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\File::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\File->__get (line 153)
7	App\Entity\Abstract\AbstractFile->getName (line 9)
8	App\Entity\Partner->getPicturePath (line 149)
9	Twig\Extension\CoreExtension->getAttribute (line 1911)
10	__TwigTemplate_650e3b6b9b50b8b54bb42ab85b8db2f6::doDisplay (line 72)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_0bc3e2fb50dc7b5bc5fcea80210039bb->doDisplay (line 83)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_34229548256bfce7d4af4d4e7a7973bf->block_body (line 130)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_2854fc17bdc9209cd3fc4ad982375742->doDisplay (line 106)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_34229548256bfce7d4af4d4e7a7973bf->doDisplay (line 54)
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\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\Site\JobSiteController->index (line 20)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Job	4
App\Entity\Partner	4
App\Entity\Address	4
App\Entity\File	4

Entities Mapping

Class	Mapping errors
App\Entity\Job	No errors.
App\Entity\Partner	No errors.
App\Entity\Address	No errors.
App\Entity\File	No errors.
App\Entity\Article	No errors.
App\Entity\Category	No errors.
App\Entity\Estate	No errors.
App\Entity\Event	No errors.
App\Entity\Like	No errors.
App\Entity\Network	No errors.
App\Entity\Reduction	No errors.
App\Entity\Schedule	No errors.
App\Entity\View	No errors.

Symfony Profiler

GET https://dev.wakeupamiens.fr/offres-emploi/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping