Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.41 ms Query time

1 Invalid entities

29 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.94 ms

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = ? LIMIT 1

Parameters:

[
  "admin@kms.cd"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.middle_name AS middle_name_3,
  t0.last_name AS last_name_4,
  t0.gender AS gender_5,
  t0.location AS location_6,
  t0.phone AS phone_7,
  t0.login AS login_8,
  t0.password AS password_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.status AS status_12,
  t0.city_id AS city_id_13,
  t0.parking_id AS parking_id_14
FROM
  user t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = 'admin@kms.cd' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

2.47 ms

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.visible_roles AS visible_roles_2, p0_.name AS name_3, p0_.created_at AS created_at_4, c1_.id AS id_5, c1_.code AS code_6, c1_.name AS name_7, c1_.created_at AS created_at_8, p2_.id AS id_9, p2_.code AS code_10, p2_.name AS name_11, p2_.created_at AS created_at_12, u3_.id AS id_13, u3_.first_name AS first_name_14, u3_.middle_name AS middle_name_15, u3_.last_name AS last_name_16, u3_.gender AS gender_17, u3_.location AS location_18, u3_.phone AS phone_19, u3_.login AS login_20, u3_.password AS password_21, u3_.roles AS roles_22, u3_.created_at AS created_at_23, u3_.status AS status_24, t4_.id AS id_25, t4_.type AS type_26, t4_.model AS model_27, t4_.label AS label_28, t4_.code AS code_29, t4_.imei AS imei_30, t4_.os AS os_31, t4_.status AS status_32, t4_.visible_roles AS visible_roles_33, t4_.visible_roles_from AS visible_roles_from_34, t4_.created_at AS created_at_35, p0_.created_by_id AS created_by_id_36, p0_.city_id AS city_id_37, c1_.province_id AS province_id_38, u3_.city_id AS city_id_39, u3_.parking_id AS parking_id_40, t4_.created_by_id AS created_by_id_41, t4_.parking_id AS parking_id_42 FROM parking p0_ LEFT JOIN city c1_ ON p0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN user u3_ ON p0_.id = u3_.parking_id LEFT JOIN terminal t4_ ON p0_.id = t4_.parking_id ORDER BY p0_.created_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.visible_roles AS visible_roles_2,
  p0_.name AS name_3,
  p0_.created_at AS created_at_4,
  c1_.id AS id_5,
  c1_.code AS code_6,
  c1_.name AS name_7,
  c1_.created_at AS created_at_8,
  p2_.id AS id_9,
  p2_.code AS code_10,
  p2_.name AS name_11,
  p2_.created_at AS created_at_12,
  u3_.id AS id_13,
  u3_.first_name AS first_name_14,
  u3_.middle_name AS middle_name_15,
  u3_.last_name AS last_name_16,
  u3_.gender AS gender_17,
  u3_.location AS location_18,
  u3_.phone AS phone_19,
  u3_.login AS login_20,
  u3_.password AS password_21,
  u3_.roles AS roles_22,
  u3_.created_at AS created_at_23,
  u3_.status AS status_24,
  t4_.id AS id_25,
  t4_.type AS type_26,
  t4_.model AS model_27,
  t4_.label AS label_28,
  t4_.code AS code_29,
  t4_.imei AS imei_30,
  t4_.os AS os_31,
  t4_.status AS status_32,
  t4_.visible_roles AS visible_roles_33,
  t4_.visible_roles_from AS visible_roles_from_34,
  t4_.created_at AS created_at_35,
  p0_.created_by_id AS created_by_id_36,
  p0_.city_id AS city_id_37,
  c1_.province_id AS province_id_38,
  u3_.city_id AS city_id_39,
  u3_.parking_id AS parking_id_40,
  t4_.created_by_id AS created_by_id_41,
  t4_.parking_id AS parking_id_42
FROM
  parking p0_
  LEFT JOIN city c1_ ON p0_.city_id = c1_.id
  LEFT JOIN province p2_ ON c1_.province_id = p2_.id
  LEFT JOIN user u3_ ON p0_.id = u3_.parking_id
  LEFT JOIN terminal t4_ ON p0_.id = t4_.parking_id
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.visible_roles AS visible_roles_2, p0_.name AS name_3, p0_.created_at AS created_at_4, c1_.id AS id_5, c1_.code AS code_6, c1_.name AS name_7, c1_.created_at AS created_at_8, p2_.id AS id_9, p2_.code AS code_10, p2_.name AS name_11, p2_.created_at AS created_at_12, u3_.id AS id_13, u3_.first_name AS first_name_14, u3_.middle_name AS middle_name_15, u3_.last_name AS last_name_16, u3_.gender AS gender_17, u3_.location AS location_18, u3_.phone AS phone_19, u3_.login AS login_20, u3_.password AS password_21, u3_.roles AS roles_22, u3_.created_at AS created_at_23, u3_.status AS status_24, t4_.id AS id_25, t4_.type AS type_26, t4_.model AS model_27, t4_.label AS label_28, t4_.code AS code_29, t4_.imei AS imei_30, t4_.os AS os_31, t4_.status AS status_32, t4_.visible_roles AS visible_roles_33, t4_.visible_roles_from AS visible_roles_from_34, t4_.created_at AS created_at_35, p0_.created_by_id AS created_by_id_36, p0_.city_id AS city_id_37, c1_.province_id AS province_id_38, u3_.city_id AS city_id_39, u3_.parking_id AS parking_id_40, t4_.created_by_id AS created_by_id_41, t4_.parking_id AS parking_id_42 FROM parking p0_ LEFT JOIN city c1_ ON p0_.city_id = c1_.id LEFT JOIN province p2_ ON c1_.province_id = p2_.id LEFT JOIN user u3_ ON p0_.id = u3_.parking_id LEFT JOIN terminal t4_ ON p0_.id = t4_.parking_id ORDER BY p0_.created_at 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\ParkingRepository->findFiltered (line 44)
7	App\Service\ZoneService->findPointsDeVente (line 143)
8	App\Controller\ZoneController->pointOfSale_find (line 64)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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\Terminal	15
App\Entity\Parking	11
App\Entity\User	1
App\Entity\City	1
App\Entity\Province	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\City	No errors.
App\Entity\Parking	No errors.
App\Entity\FonctionHistory	No errors.
App\Entity\Terminal	No errors.
App\Entity\Motor	No errors.
App\Entity\MotorMarque	No errors.
App\Entity\Province	No errors.
App\Entity\Session	The field App\Entity\Session#billets is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Billet#createdBy does not contain the required 'inversedBy: "billets"' attribute.
App\Entity\Billet	No errors.
App\Entity\Organization	No errors.

Symfony Profiler

POST http://kms-rdc.net/api/zone/poitOfsale/find

Configuration Settings

Theme

Page Width