Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.04 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.31 ms

SELECT t0.is_verified AS is_verified_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.id AS id_7, t8.phone AS phone_9, t8.loc_country AS loc_country_10, t8.loc_state AS loc_state_11, t8.loc_city AS loc_city_12, t8.loc_address AS loc_address_13, t8.last_login AS last_login_14, t8.started AS started_15, t8.driver_num AS driver_num_16, t8.bio AS bio_17, t8.show_contact AS show_contact_18, t8.show_profile AS show_profile_19, t8.driver AS driver_20, t8.owner AS owner_21, t8.id AS id_22, t8.created_at AS created_at_23, t8.updated_at AS updated_at_24, t8.user_id AS user_id_25 FROM user t0 LEFT JOIN user_profile t8 ON t8.user_id = t0.id WHERE t0.email = ? LIMIT 2

Parameters:

[
  "wfurtney@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.is_verified AS is_verified_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.id AS id_7,
  t8.phone AS phone_9,
  t8.loc_country AS loc_country_10,
  t8.loc_state AS loc_state_11,
  t8.loc_city AS loc_city_12,
  t8.loc_address AS loc_address_13,
  t8.last_login AS last_login_14,
  t8.started AS started_15,
  t8.driver_num AS driver_num_16,
  t8.bio AS bio_17,
  t8.show_contact AS show_contact_18,
  t8.show_profile AS show_profile_19,
  t8.driver AS driver_20,
  t8.owner AS owner_21,
  t8.id AS id_22,
  t8.created_at AS created_at_23,
  t8.updated_at AS updated_at_24,
  t8.user_id AS user_id_25
FROM
  user t0
  LEFT JOIN user_profile t8 ON t8.user_id = t0.id
WHERE
  t0.email = ?
LIMIT
  2

SELECT t0.is_verified AS is_verified_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.id AS id_7, t8.phone AS phone_9, t8.loc_country AS loc_country_10, t8.loc_state AS loc_state_11, t8.loc_city AS loc_city_12, t8.loc_address AS loc_address_13, t8.last_login AS last_login_14, t8.started AS started_15, t8.driver_num AS driver_num_16, t8.bio AS bio_17, t8.show_contact AS show_contact_18, t8.show_profile AS show_profile_19, t8.driver AS driver_20, t8.owner AS owner_21, t8.id AS id_22, t8.created_at AS created_at_23, t8.updated_at AS updated_at_24, t8.user_id AS user_id_25 FROM user t0 LEFT JOIN user_profile t8 ON t8.user_id = t0.id WHERE t0.email = 'wfurtney@gmail.com' LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 155)
4	Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntityValidator->validate (line 747)
5	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 480)
6	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 296)
7	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 126)
8	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 105)
9	Symfony\Component\Form\Extension\Validator\Constraints\FormValidator->validate (line 747)
10	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 480)
11	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 296)
12	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 126)
13	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 81)
14	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 57)
15	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 43)
16	Symfony\Component\Form\Extension\Validator\EventListener\ValidationListener->validateForm (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 28)
19	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 585)
20	Symfony\Component\Form\Form->submit (line 107)
21	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 414)
22	Symfony\Component\Form\Form->handleRequest (line 70)
23	App\Controller\PublicController->home (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.73 ms

SELECT t0.image AS image_1, t0.make AS make_2, t0.model AS model_3, t0.year AS year_4, t0.engine AS engine_5, t0.description AS description_6, t0.number AS number_7, t0.id AS id_8, t0.driver_id AS driver_id_9, t0.owner_id AS owner_id_10 FROM `car` t0 WHERE t0.driver_id = ?

Parameters:

[
  468
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.image AS image_1,
  t0.make AS make_2,
  t0.model AS model_3,
  t0.year AS year_4,
  t0.engine AS engine_5,
  t0.description AS description_6,
  t0.number AS number_7,
  t0.id AS id_8,
  t0.driver_id AS driver_id_9,
  t0.owner_id AS owner_id_10
FROM
  `car` t0
WHERE
  t0.driver_id = ?

SELECT t0.image AS image_1, t0.make AS make_2, t0.model AS model_3, t0.year AS year_4, t0.engine AS engine_5, t0.description AS description_6, t0.number AS number_7, t0.id AS id_8, t0.driver_id AS driver_id_9, t0.owner_id AS owner_id_10 FROM `car` t0 WHERE t0.driver_id = 468;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 873)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 449)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 973)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
10	Doctrine\ORM\EntityRepository->findBy (line 155)
11	Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntityValidator->validate (line 747)
12	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 480)
13	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 296)
14	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 126)
15	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 105)
16	Symfony\Component\Form\Extension\Validator\Constraints\FormValidator->validate (line 747)
17	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 480)
18	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 296)
19	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 126)
20	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 81)
21	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 57)
22	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 43)
23	Symfony\Component\Form\Extension\Validator\EventListener\ValidationListener->validateForm (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 28)
26	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 585)
27	Symfony\Component\Form\Form->submit (line 107)
28	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 414)
29	Symfony\Component\Form\Form->handleRequest (line 70)
30	App\Controller\PublicController->home (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	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\UserProfile	No errors.
App\Entity\Payment	No errors.
App\Entity\Car	No errors.
App\Entity\Result	No errors.
App\Entity\Photo	No errors.

Symfony Profiler

POST https://imsra.com/

Configuration Settings

Theme