Symfony Profiler

Query Metrics

170 Database Queries

6 Different statements

50.69 ms Query time

0 Invalid entities

343 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

48.19 ms
(95.06%)

164

SELECT t0.id_project AS id_project_1, t0.name_project AS name_project_2, t0.description_project AS description_project_3, t0.status_project AS status_project_4, t0.year_project AS year_project_5, t0.active AS active_6, t0.date_insert AS date_insert_7, t0.start_date AS start_date_8, t0.end_date AS end_date_9, t0.budget_project AS budget_project_10, t0.quote_number AS quote_number_11, t0.use_manager AS use_manager_12, t0.id_wiki AS id_wiki_13, t0.archived AS archived_14, t0.archived_at AS archived_at_15, t0.id_client AS id_client_16, t0.id_projecttype AS id_projecttype_17, t0.id_project_techno AS id_project_techno_18, t0.id_project_manager AS id_project_manager_19 FROM project t0 WHERE t0.id_client = ?

Parameters:

[
  394
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_project AS id_project_1,
  t0.name_project AS name_project_2,
  t0.description_project AS description_project_3,
  t0.status_project AS status_project_4,
  t0.year_project AS year_project_5,
  t0.active AS active_6,
  t0.date_insert AS date_insert_7,
  t0.start_date AS start_date_8,
  t0.end_date AS end_date_9,
  t0.budget_project AS budget_project_10,
  t0.quote_number AS quote_number_11,
  t0.use_manager AS use_manager_12,
  t0.id_wiki AS id_wiki_13,
  t0.archived AS archived_14,
  t0.archived_at AS archived_at_15,
  t0.id_client AS id_client_16,
  t0.id_projecttype AS id_projecttype_17,
  t0.id_project_techno AS id_project_techno_18,
  t0.id_project_manager AS id_project_manager_19
FROM
  project t0
WHERE
  t0.id_client = ?

SELECT t0.id_project AS id_project_1, t0.name_project AS name_project_2, t0.description_project AS description_project_3, t0.status_project AS status_project_4, t0.year_project AS year_project_5, t0.active AS active_6, t0.date_insert AS date_insert_7, t0.start_date AS start_date_8, t0.end_date AS end_date_9, t0.budget_project AS budget_project_10, t0.quote_number AS quote_number_11, t0.use_manager AS use_manager_12, t0.id_wiki AS id_wiki_13, t0.archived AS archived_14, t0.archived_at AS archived_at_15, t0.id_client AS id_client_16, t0.id_projecttype AS id_projecttype_17, t0.id_project_techno AS id_project_techno_18, t0.id_project_manager AS id_project_manager_19 FROM project t0 WHERE t0.id_client = 394;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 73)
8	App\Controller\Api\ClientApiController->App\Controller\Api\{closure} (line 1)
9	array_map (line 70)
10	App\Controller\Api\ClientApiController->list (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.82 ms
(1.63%)

SELECT c0_.id_client AS id_client_0, c0_.name_client AS name_client_1, c0_.email_client AS email_client_2, c0_.phone_client AS phone_client_3, c0_.nom_contact_client AS nom_contact_client_4, c0_.maintenance_client AS maintenance_client_5, c0_.billable_entity AS billable_entity_6, c0_.code_client AS code_client_7, c0_.contracts AS contracts_8, c0_.active AS active_9, c0_.date_insert AS date_insert_10 FROM client c0_ WHERE 1 = 1 AND c0_.active = ? ORDER BY c0_.name_client ASC LIMIT 1000

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id_client AS id_client_0,
  c0_.name_client AS name_client_1,
  c0_.email_client AS email_client_2,
  c0_.phone_client AS phone_client_3,
  c0_.nom_contact_client AS nom_contact_client_4,
  c0_.maintenance_client AS maintenance_client_5,
  c0_.billable_entity AS billable_entity_6,
  c0_.code_client AS code_client_7,
  c0_.contracts AS contracts_8,
  c0_.active AS active_9,
  c0_.date_insert AS date_insert_10
FROM
  client c0_
WHERE
  1 = 1
  AND c0_.active = ?
ORDER BY
  c0_.name_client ASC
LIMIT
  1000

SELECT c0_.id_client AS id_client_0, c0_.name_client AS name_client_1, c0_.email_client AS email_client_2, c0_.phone_client AS phone_client_3, c0_.nom_contact_client AS nom_contact_client_4, c0_.maintenance_client AS maintenance_client_5, c0_.billable_entity AS billable_entity_6, c0_.code_client AS code_client_7, c0_.contracts AS contracts_8, c0_.active AS active_9, c0_.date_insert AS date_insert_10 FROM client c0_ WHERE 1 = 1 AND c0_.active = 1 ORDER BY c0_.name_client ASC LIMIT 1000;

#	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 158)
7	App\Repository\ClientRepository->findWithPaginationAndFilters (line 58)
8	App\Controller\Api\ClientApiController->list (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.50 ms
(0.99%)

SELECT t0.id_projecttype AS id_projecttype_1, t0.name_projecttype AS name_projecttype_2 FROM projecttype t0 WHERE t0.id_projecttype = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_projecttype AS id_projecttype_1,
  t0.name_projecttype AS name_projecttype_2
FROM
  projecttype t0
WHERE
  t0.id_projecttype = ?

SELECT t0.id_projecttype AS id_projecttype_1, t0.name_projecttype AS name_projecttype_2 FROM projecttype t0 WHERE t0.id_projecttype = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\ProjectType::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\ProjectType->__get (line 37)
8	App\Entity\ProjectType->getName (line 78)
9	App\Controller\Api\ClientApiController->App\Controller\Api\{closure} (line 1)
10	array_map (line 70)
11	App\Controller\Api\ClientApiController->list (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.45 ms
(0.90%)

SELECT t0.id_user AS id_user_1, t0.login_user AS login_user_2, t0.password_user AS password_user_3, t0.email_user AS email_user_4, t0.firstname_user AS firstname_user_5, t0.lastname_user AS lastname_user_6, t0.color_user AS color_user_7, t0.active AS active_8, t0.reset_token AS reset_token_9, t0.reset_token_expires_at AS reset_token_expires_at_10, t0.id_usergroup AS id_usergroup_11 FROM user t0 WHERE t0.id_user = ?

Parameters:

[
  36
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_user AS id_user_1,
  t0.login_user AS login_user_2,
  t0.password_user AS password_user_3,
  t0.email_user AS email_user_4,
  t0.firstname_user AS firstname_user_5,
  t0.lastname_user AS lastname_user_6,
  t0.color_user AS color_user_7,
  t0.active AS active_8,
  t0.reset_token AS reset_token_9,
  t0.reset_token_expires_at AS reset_token_expires_at_10,
  t0.id_usergroup AS id_usergroup_11
FROM
  user t0
WHERE
  t0.id_user = ?

SELECT t0.id_user AS id_user_1, t0.login_user AS login_user_2, t0.password_user AS password_user_3, t0.email_user AS email_user_4, t0.firstname_user AS firstname_user_5, t0.lastname_user AS lastname_user_6, t0.color_user AS color_user_7, t0.active AS active_8, t0.reset_token AS reset_token_9, t0.reset_token_expires_at AS reset_token_expires_at_10, t0.id_usergroup AS id_usergroup_11 FROM user t0 WHERE t0.id_user = 36;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 375)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 43)
15	App\Controller\Api\ClientApiController->list (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.41 ms
(0.81%)

SELECT COUNT(DISTINCT c0_.id_client) AS sclr_0 FROM client c0_ WHERE 1 = 1 AND c0_.active = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(DISTINCT c0_.id_client) AS sclr_0
FROM
  client c0_
WHERE
  1 = 1
  AND c0_.active = ?

SELECT COUNT(DISTINCT c0_.id_client) AS sclr_0 FROM client c0_ WHERE 1 = 1 AND c0_.active = 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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 201)
8	App\Repository\ClientRepository->countWithFilters (line 67)
9	App\Controller\Api\ClientApiController->list (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.31 ms
(0.61%)

SELECT t0.id_usergroup AS id_usergroup_1, t0.name_usergroup AS name_usergroup_2, t0.code_usergroup AS code_usergroup_3 FROM usergroup t0 WHERE t0.id_usergroup = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_usergroup AS id_usergroup_1,
  t0.name_usergroup AS name_usergroup_2,
  t0.code_usergroup AS code_usergroup_3
FROM
  usergroup t0
WHERE
  t0.id_usergroup = ?

SELECT t0.id_usergroup AS id_usergroup_1, t0.name_usergroup AS name_usergroup_2, t0.code_usergroup AS code_usergroup_3 FROM usergroup t0 WHERE t0.id_usergroup = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\UserGroup::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\UserGroup->__get (line 51)
8	App\Entity\UserGroup->getCode (line 417)
9	App\Entity\User->getRoles (line 318)
10	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 217)
11	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
12	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 74)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
15	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 42)
16	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 375)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->getUser (line 43)
18	App\Controller\Api\ClientApiController->list (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Project	168
App\Entity\Client	164
App\Entity\User	8
App\Entity\ProjectType	2
App\Entity\UserGroup	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserGroup	No errors.
App\Entity\Entry	No errors.
App\Entity\TaskUser	No errors.
App\Entity\ProjectUser	No errors.
App\Entity\LotUser	No errors.
App\Entity\TacheUser	No errors.
App\Entity\MaintenanceTaskUser	No errors.
App\Entity\Client	No errors.
App\Entity\Project	No errors.
App\Entity\MaintenanceClient	No errors.
App\Entity\Wiki	No errors.
App\Entity\SiteInternet	No errors.
App\Entity\Domaine	No errors.
App\Entity\ClientContact	No errors.
App\Entity\ProjectType	No errors.
App\Entity\ProjectTechno	No errors.
App\Entity\Lot	No errors.
App\Entity\Task	No errors.

Symfony Profiler

GET https://pistache.definima.io/api/clients?page=1&search=&size=1000&status=active

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping