Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.19 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.24 ms

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5 FROM user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 73)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 44)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 368)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 17)
14	App\Controller\IndexController->index (line 182)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.75 ms

SELECT r0_.id AS id_0, r0_.society AS society_1, r0_.name AS name_2, r0_.email AS email_3, r0_.contact AS contact_4, r0_.start_state AS start_state_5, r0_.start_date AS start_date_6, r0_.duration AS duration_7, r0_.cost AS cost_8, r0_.start_sign AS start_sign_9, r0_.end_date AS end_date_10, r0_.end_state AS end_state_11, r0_.end_sign AS end_sign_12, r0_.end_sign_date AS end_sign_date_13, r0_.archived AS archived_14, r0_.device_id AS device_id_15 FROM rental r0_ WHERE r0_.archived = 0 OR r0_.archived IS NULL ORDER BY r0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.society AS society_1,
  r0_.name AS name_2,
  r0_.email AS email_3,
  r0_.contact AS contact_4,
  r0_.start_state AS start_state_5,
  r0_.start_date AS start_date_6,
  r0_.duration AS duration_7,
  r0_.cost AS cost_8,
  r0_.start_sign AS start_sign_9,
  r0_.end_date AS end_date_10,
  r0_.end_state AS end_state_11,
  r0_.end_sign AS end_sign_12,
  r0_.end_sign_date AS end_sign_date_13,
  r0_.archived AS archived_14,
  r0_.device_id AS device_id_15
FROM
  rental r0_
WHERE
  r0_.archived = 0
  OR r0_.archived IS NULL
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.society AS society_1, r0_.name AS name_2, r0_.email AS email_3, r0_.contact AS contact_4, r0_.start_state AS start_state_5, r0_.start_date AS start_date_6, r0_.duration AS duration_7, r0_.cost AS cost_8, r0_.start_sign AS start_sign_9, r0_.end_date AS end_date_10, r0_.end_state AS end_state_11, r0_.end_sign AS end_sign_12, r0_.end_sign_date AS end_sign_date_13, r0_.archived AS archived_14, r0_.device_id AS device_id_15 FROM rental r0_ WHERE r0_.archived = 0 OR r0_.archived IS NULL ORDER BY r0_.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 34)
7	App\Repository\RentalRepository->findAllUnarchived (line 22)
8	App\Controller\IndexController->index (line 182)
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.74 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.content AS content_2, c0_.duration AS duration_3, c0_.cost AS cost_4, c1_.id AS id_5, c1_.society AS society_6, c1_.contact AS contact_7, c1_.email AS email_8, c1_.start_date AS start_date_9, c1_.end_date AS end_date_10, c1_.cost AS cost_11, c1_.object AS object_12, c1_.sign AS sign_13, c1_.name AS name_14, c1_.archived AS archived_15, c1_.category_id AS category_id_16 FROM contract_model c0_ INNER JOIN contract c1_ ON c0_.id = c1_.category_id WHERE c1_.archived = 0 OR c1_.archived IS NULL ORDER BY c1_.end_date ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.content AS content_2,
  c0_.duration AS duration_3,
  c0_.cost AS cost_4,
  c1_.id AS id_5,
  c1_.society AS society_6,
  c1_.contact AS contact_7,
  c1_.email AS email_8,
  c1_.start_date AS start_date_9,
  c1_.end_date AS end_date_10,
  c1_.cost AS cost_11,
  c1_.object AS object_12,
  c1_.sign AS sign_13,
  c1_.name AS name_14,
  c1_.archived AS archived_15,
  c1_.category_id AS category_id_16
FROM
  contract_model c0_
  INNER JOIN contract c1_ ON c0_.id = c1_.category_id
WHERE
  c1_.archived = 0
  OR c1_.archived IS NULL
ORDER BY
  c1_.end_date ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.content AS content_2, c0_.duration AS duration_3, c0_.cost AS cost_4, c1_.id AS id_5, c1_.society AS society_6, c1_.contact AS contact_7, c1_.email AS email_8, c1_.start_date AS start_date_9, c1_.end_date AS end_date_10, c1_.cost AS cost_11, c1_.object AS object_12, c1_.sign AS sign_13, c1_.name AS name_14, c1_.archived AS archived_15, c1_.category_id AS category_id_16 FROM contract_model c0_ INNER JOIN contract c1_ ON c0_.id = c1_.category_id WHERE c1_.archived = 0 OR c1_.archived IS NULL ORDER BY c1_.end_date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 75)
7	App\Repository\ContractModelRepository->findContracts (line 23)
8	App\Controller\IndexController->index (line 182)
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.47 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.brand AS brand_3, t0.serial AS serial_4, t0.config AS config_5, t0.state AS state_6, t0.archived AS archived_7 FROM device t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.brand AS brand_3,
  t0.serial AS serial_4,
  t0.config AS config_5,
  t0.state AS state_6,
  t0.archived AS archived_7
FROM
  device t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.brand AS brand_3, t0.serial AS serial_4, t0.config AS config_5, t0.state AS state_6, t0.archived AS archived_7 FROM device t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Device->__get (line 53)
8	App\Entity\Device->getType (line 1637)
9	twig_get_attribute (line 170)
10	__TwigTemplate_82f802baa1e27d231ac1fa53ce454e7f->block_body (line 171)
11	Twig\Template->displayBlock (line 361)
12	__TwigTemplate_9d1d5fd18752b006fd6c3958706768cf->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 51)
15	__TwigTemplate_82f802baa1e27d231ac1fa53ce454e7f->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 40)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 243)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
23	App\Controller\IndexController->index (line 182)
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)

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\User	No errors.
App\Entity\Rental	No errors.
App\Entity\Device	No errors.
App\Entity\ContractModel	No errors.
App\Entity\Contract	No errors.

Symfony Profiler

GET https://culturemac.macmedic.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping