Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.53 ms Query time

3 Invalid entities

52 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.66 ms
(26.30%)

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.body AS body_2, n0_.type AS type_3, n0_.is_read AS is_read_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.importance AS importance_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.firstname AS firstname_12, u1_.lastname AS lastname_13, u1_.created_at AS created_at_14, u1_.birthdate AS birthdate_15, u1_.phone AS phone_16, u1_.adresse AS adresse_17, u1_.longitude AS longitude_18, u1_.latitude AS latitude_19, u1_.phone_verified AS phone_verified_20, u1_.expo_push_token AS expo_push_token_21, u1_.verified AS verified_22, u1_.registration_status AS registration_status_23, u1_.didit_session_url AS didit_session_url_24, u1_.mutual_contract AS mutual_contract_25, u1_.mutual_rate_ph7 AS mutual_rate_ph7_26, u1_.mutual_rate_ph4 AS mutual_rate_ph4_27, u1_.mutual_rate_ph2 AS mutual_rate_ph2_28, u1_.livraison_type AS livraison_type_29, u1_.mutual_rate_phn AS mutual_rate_phn_30, u1_.mutual_rate_phn_number AS mutual_rate_phn_number_31, n0_.user_id AS user_id_32, n0_.ordonnance_id_id AS ordonnance_id_id_33, u1_.user_date_preference_id AS user_date_preference_id_34 FROM nofication_global n0_ LEFT JOIN user u1_ ON n0_.user_id = u1_.id WHERE n0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY n0_.created_at DESC LIMIT 50

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.body AS body_2,
  n0_.type AS type_3,
  n0_.is_read AS is_read_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.importance AS importance_7,
  u1_.id AS id_8,
  u1_.email AS email_9,
  u1_.roles AS roles_10,
  u1_.password AS password_11,
  u1_.firstname AS firstname_12,
  u1_.lastname AS lastname_13,
  u1_.created_at AS created_at_14,
  u1_.birthdate AS birthdate_15,
  u1_.phone AS phone_16,
  u1_.adresse AS adresse_17,
  u1_.longitude AS longitude_18,
  u1_.latitude AS latitude_19,
  u1_.phone_verified AS phone_verified_20,
  u1_.expo_push_token AS expo_push_token_21,
  u1_.verified AS verified_22,
  u1_.registration_status AS registration_status_23,
  u1_.didit_session_url AS didit_session_url_24,
  u1_.mutual_contract AS mutual_contract_25,
  u1_.mutual_rate_ph7 AS mutual_rate_ph7_26,
  u1_.mutual_rate_ph4 AS mutual_rate_ph4_27,
  u1_.mutual_rate_ph2 AS mutual_rate_ph2_28,
  u1_.livraison_type AS livraison_type_29,
  u1_.mutual_rate_phn AS mutual_rate_phn_30,
  u1_.mutual_rate_phn_number AS mutual_rate_phn_number_31,
  n0_.user_id AS user_id_32,
  n0_.ordonnance_id_id AS ordonnance_id_id_33,
  u1_.user_date_preference_id AS user_date_preference_id_34
FROM
  nofication_global n0_
  LEFT JOIN user u1_ ON n0_.user_id = u1_.id
WHERE
  n0_.user_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  n0_.created_at DESC
LIMIT
  50

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.body AS body_2, n0_.type AS type_3, n0_.is_read AS is_read_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.importance AS importance_7, u1_.id AS id_8, u1_.email AS email_9, u1_.roles AS roles_10, u1_.password AS password_11, u1_.firstname AS firstname_12, u1_.lastname AS lastname_13, u1_.created_at AS created_at_14, u1_.birthdate AS birthdate_15, u1_.phone AS phone_16, u1_.adresse AS adresse_17, u1_.longitude AS longitude_18, u1_.latitude AS latitude_19, u1_.phone_verified AS phone_verified_20, u1_.expo_push_token AS expo_push_token_21, u1_.verified AS verified_22, u1_.registration_status AS registration_status_23, u1_.didit_session_url AS didit_session_url_24, u1_.mutual_contract AS mutual_contract_25, u1_.mutual_rate_ph7 AS mutual_rate_ph7_26, u1_.mutual_rate_ph4 AS mutual_rate_ph4_27, u1_.mutual_rate_ph2 AS mutual_rate_ph2_28, u1_.livraison_type AS livraison_type_29, u1_.mutual_rate_phn AS mutual_rate_phn_30, u1_.mutual_rate_phn_number AS mutual_rate_phn_number_31, n0_.user_id AS user_id_32, n0_.ordonnance_id_id AS ordonnance_id_id_33, u1_.user_date_preference_id AS user_date_preference_id_34 FROM nofication_global n0_ LEFT JOIN user u1_ ON n0_.user_id = u1_.id WHERE n0_.user_id IN (6, 115, 169, 175, 229, 253, 262, 181, 186, 195, 203, 204, 205, 206, 207, 208, 209, 266) ORDER BY n0_.created_at DESC LIMIT 50;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Service\NoficationGlobalService->getNotificationsByPharmacy (line 118)
7	App\Controller\NoficationGlobalApiController->getNotificationsByPharmacy (line 149)
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)

0.53 ms
(21.03%)

SELECT u0_.id AS id_0, u0_.is_added AS is_added_1, u0_.user_id AS user_id_2, u0_.pharmacie_id AS pharmacie_id_3 FROM user_pharmacie u0_ WHERE u0_.pharmacie_id = ? AND (u0_.is_added = 0 OR u0_.is_added IS NULL)

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.is_added AS is_added_1,
  u0_.user_id AS user_id_2,
  u0_.pharmacie_id AS pharmacie_id_3
FROM
  user_pharmacie u0_
WHERE
  u0_.pharmacie_id = ?
  AND (
    u0_.is_added = 0
    OR u0_.is_added IS NULL
  )

SELECT u0_.id AS id_0, u0_.is_added AS is_added_1, u0_.user_id AS user_id_2, u0_.pharmacie_id AS pharmacie_id_3 FROM user_pharmacie u0_ WHERE u0_.pharmacie_id = 2 AND (u0_.is_added = 0 OR u0_.is_added IS NULL);

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\UserPharmacieRepository->findNotAddedByPharmacie (line 52)
7	App\Service\UserPharmacieService->getUsersByPharmacie (line 139)
8	App\Service\NoficationGlobalService->getNotificationsByPharmacy (line 54)
9	App\Controller\NoficationGlobalApiController->getNotificationsByPharmacy (line 149)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.47 ms
(18.66%)

SELECT COUNT(n0_.id) AS sclr_0 FROM nofication_global n0_ WHERE n0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND n0_.is_read = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(n0_.id) AS sclr_0
FROM
  nofication_global n0_
WHERE
  n0_.user_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND n0_.is_read = ?

SELECT COUNT(n0_.id) AS sclr_0 FROM nofication_global n0_ WHERE n0_.user_id IN (6, 115, 169, 175, 229, 253, 262, 181, 186, 195, 203, 204, 205, 206, 207, 208, 209, 266) AND n0_.is_read = 0;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 802)
7	App\Service\NoficationGlobalService->getNotificationsByPharmacy (line 133)
8	App\Controller\NoficationGlobalApiController->getNotificationsByPharmacy (line 149)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.47 ms
(18.57%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.address AS address_4, t0.ville AS ville_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.phone AS phone_8, t0.email AS email_9, t0.code_postal AS code_postal_10, t0.departement AS departement_11 FROM pharmacie t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.address AS address_4,
  t0.ville AS ville_5,
  t0.latitude AS latitude_6,
  t0.longitude AS longitude_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.code_postal AS code_postal_10,
  t0.departement AS departement_11
FROM
  pharmacie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.address AS address_4, t0.ville AS ville_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.phone AS phone_8, t0.email AS email_9, t0.code_postal AS code_postal_10, t0.departement AS departement_11 FROM pharmacie t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Service\UserPharmacieService->getUsersByPharmacie (line 132)
7	App\Service\NoficationGlobalService->getNotificationsByPharmacy (line 54)
8	App\Controller\NoficationGlobalApiController->getNotificationsByPharmacy (line 149)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.39 ms
(15.45%)

SELECT DISTINCT user_added_id 
                FROM user_added 
                WHERE user_adder_id IN (?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT user_added_id
FROM
  user_added
WHERE
  user_adder_id IN (?, ?, ?, ?, ?, ?, ?)

SELECT DISTINCT user_added_id 
                FROM user_added 
                WHERE user_adder_id IN (6, 115, 169, 175, 229, 253, 262);

#	File/Call
1	Doctrine\DBAL\Connection->fetchFirstColumn (line 958)
2	App\Service\NoficationGlobalService->getNotificationsByPharmacy (line 73)
3	App\Controller\NoficationGlobalApiController->getNotificationsByPharmacy (line 149)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	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\NoficationGlobal	15
App\Entity\Ordonnance	15
App\Entity\User	14
App\Entity\UserPharmacie	7
App\Entity\Pharmacie	1

Entities Mapping

Class	Mapping errors
App\Entity\Pharmacie	No errors.
App\Entity\Stocks	No errors.
App\Entity\Dispensation	No errors.
App\Entity\UserPharmacie	No errors.
App\Entity\PharmacieLivraisonDate	No errors.
App\Entity\Tournee	No errors.
App\Entity\ClickCollectDispensation	No errors.
App\Entity\Ordonnance	No errors.
App\Entity\PharmacieRib	No errors.
App\Entity\PharmacieStripe	No errors.
App\Entity\User	No errors.
App\Entity\NoficationGlobal	No errors.
App\Entity\UserDatePreference	No errors.
App\Entity\UserFile	No errors.
App\Entity\PhoneVerification	No errors.
App\Entity\UserOrdonnance	No errors.
App\Entity\UserAdded	The mappings App\Entity\UserAdded#userAdder and App\Entity\User#userAddeds are inconsistent with each other.
App\Entity\UserMessage	No errors.
App\Entity\NurseInfo	No errors.
App\Entity\WaitList	No errors.
App\Entity\UserAddress	No errors.
App\Entity\UserReferralInvitation	The mappings App\Entity\UserReferralInvitation#userAdded and App\Entity\User#userReferralInvitations are inconsistent with each other.
App\Entity\Message	The mappings App\Entity\Message#receiver and App\Entity\User#messages are inconsistent with each other.
App\Entity\DateChangeRequest	No errors.
App\Entity\NotificationCount	No errors.

Symfony Profiler

GET https://api.re-med.fr/api/notification-global/pharmacy/2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping