Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

6.39 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.73 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.firstname AS firstname_6,
  t0.sales_person_code AS sales_person_code_7,
  t0.function AS function_8
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
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 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

2.77 ms

SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.salesperson_code = ?

Parameters:

[
  "15"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.no AS no_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.contact AS contact_6,
  t0.phone AS phone_7,
  t0.salesperson_code AS salesperson_code_8,
  t0.blocked AS blocked_9,
  t0.post_code AS post_code_10,
  t0.address2 AS address2_11,
  t0.sales_lcy AS sales_lcy_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.active AS active_15,
  t0.show_on_web AS show_on_web_16
FROM
  client t0
WHERE
  t0.salesperson_code = ?

SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.salesperson_code = '15';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 100)
5	App\Service\DataService->getClients (line 88)
6	App\Controller\ClientController->clients (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

2.88 ms

SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.salesperson_code = ?

Parameters:

[
  "15C"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.no AS no_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.contact AS contact_6,
  t0.phone AS phone_7,
  t0.salesperson_code AS salesperson_code_8,
  t0.blocked AS blocked_9,
  t0.post_code AS post_code_10,
  t0.address2 AS address2_11,
  t0.sales_lcy AS sales_lcy_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.active AS active_15,
  t0.show_on_web AS show_on_web_16
FROM
  client t0
WHERE
  t0.salesperson_code = ?

SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.salesperson_code = '15C';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 101)
5	App\Service\DataService->getClients (line 88)
6	App\Controller\ClientController->clients (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Client	No errors.
App\Entity\Visit	No errors.
App\Entity\Activity	No errors.
App\Entity\Access	No errors.

Symfony Profiler

GET https://www.deltamics-connect.fr/clients

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping