Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.20 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.42 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name_prefix AS last_name_prefix_4, t0.last_name AS last_name_5, t0.calendar_token AS calendar_token_6, t0.subscription AS subscription_7, t0.roles AS roles_8, t0.password AS password_9, t0.company_id AS company_id_10 FROM user t0 WHERE t0.email = ? LIMIT 1

Parameters:

[
  "adviseur@bedrijfx.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name_prefix AS last_name_prefix_4,
  t0.last_name AS last_name_5,
  t0.calendar_token AS calendar_token_6,
  t0.subscription AS subscription_7,
  t0.roles AS roles_8,
  t0.password AS password_9,
  t0.company_id AS company_id_10
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name_prefix AS last_name_prefix_4, t0.last_name AS last_name_5, t0.calendar_token AS calendar_token_6, t0.subscription AS subscription_7, t0.roles AS roles_8, t0.password AS password_9, t0.company_id AS company_id_10 FROM user t0 WHERE t0.email = 'adviseur@bedrijfx.com' LIMIT 1;

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

0.78 ms

SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.huisnummer AS huisnummer_3, t0.toevoeging AS toevoeging_4, t0.straat AS straat_5, t0.plaats AS plaats_6, t0.bag_id AS bag_id_7, t0.bouwjaar AS bouwjaar_8, t0.oppervlakte AS oppervlakte_9, t0.gebruikdsdoel AS gebruikdsdoel_10, t0.remarks AS remarks_11, t0.lat AS lat_12, t0.lng AS lng_13, t0.streetview_image_base64 AS streetview_image_base64_14, t0.building_sketch_path AS building_sketch_path_15, t0.preview_image_filename AS preview_image_filename_16, t0.preview_image_mime_type AS preview_image_mime_type_17, t0.preview_image_size AS preview_image_size_18, t0.preview_image_uploaded_at AS preview_image_uploaded_at_19, t0.status AS status_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.scheduling_token AS scheduling_token_23, t0.energy_data AS energy_data_24, t0.floor_plan AS floor_plan_25, t0.bouwlagen AS bouwlagen_26, t0.floor_mass_class AS floor_mass_class_27, t0.wall_mass_class AS wall_mass_class_28, t0.dwelling_type AS dwelling_type_29, t0.ground_height_nap AS ground_height_nap_30, t0.ridge_height_nap AS ridge_height_nap_31, t0.building_height_m AS building_height_m_32, t0.footprint_area_m2 AS footprint_area_m2_33, t0.roof_pitched_area_m2 AS roof_pitched_area_m2_34, t0.roof_flat_area_m2 AS roof_flat_area_m2_35, t0.outer_wall_area_m2 AS outer_wall_area_m2_36, t0.party_wall_area_m2 AS party_wall_area_m2_37, t0.building_volume_m3 AS building_volume_m3_38, t0.roof_type AS roof_type_39, t0.roof_facets AS roof_facets_40, t0.building_sketch_geometry AS building_sketch_geometry_41, t0.building_orientation_deg AS building_orientation_deg_42, t0.signature AS signature_43, t0.signed_at AS signed_at_44, t0.advisor_id AS advisor_id_45, t0.client_id AS client_id_46 FROM project t0 WHERE t0.id = ?

Parameters:

[
  "196"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.postcode AS postcode_2,
  t0.huisnummer AS huisnummer_3,
  t0.toevoeging AS toevoeging_4,
  t0.straat AS straat_5,
  t0.plaats AS plaats_6,
  t0.bag_id AS bag_id_7,
  t0.bouwjaar AS bouwjaar_8,
  t0.oppervlakte AS oppervlakte_9,
  t0.gebruikdsdoel AS gebruikdsdoel_10,
  t0.remarks AS remarks_11,
  t0.lat AS lat_12,
  t0.lng AS lng_13,
  t0.streetview_image_base64 AS streetview_image_base64_14,
  t0.building_sketch_path AS building_sketch_path_15,
  t0.preview_image_filename AS preview_image_filename_16,
  t0.preview_image_mime_type AS preview_image_mime_type_17,
  t0.preview_image_size AS preview_image_size_18,
  t0.preview_image_uploaded_at AS preview_image_uploaded_at_19,
  t0.status AS status_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.scheduling_token AS scheduling_token_23,
  t0.energy_data AS energy_data_24,
  t0.floor_plan AS floor_plan_25,
  t0.bouwlagen AS bouwlagen_26,
  t0.floor_mass_class AS floor_mass_class_27,
  t0.wall_mass_class AS wall_mass_class_28,
  t0.dwelling_type AS dwelling_type_29,
  t0.ground_height_nap AS ground_height_nap_30,
  t0.ridge_height_nap AS ridge_height_nap_31,
  t0.building_height_m AS building_height_m_32,
  t0.footprint_area_m2 AS footprint_area_m2_33,
  t0.roof_pitched_area_m2 AS roof_pitched_area_m2_34,
  t0.roof_flat_area_m2 AS roof_flat_area_m2_35,
  t0.outer_wall_area_m2 AS outer_wall_area_m2_36,
  t0.party_wall_area_m2 AS party_wall_area_m2_37,
  t0.building_volume_m3 AS building_volume_m3_38,
  t0.roof_type AS roof_type_39,
  t0.roof_facets AS roof_facets_40,
  t0.building_sketch_geometry AS building_sketch_geometry_41,
  t0.building_orientation_deg AS building_orientation_deg_42,
  t0.signature AS signature_43,
  t0.signed_at AS signed_at_44,
  t0.advisor_id AS advisor_id_45,
  t0.client_id AS client_id_46
FROM
  project t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.postcode AS postcode_2, t0.huisnummer AS huisnummer_3, t0.toevoeging AS toevoeging_4, t0.straat AS straat_5, t0.plaats AS plaats_6, t0.bag_id AS bag_id_7, t0.bouwjaar AS bouwjaar_8, t0.oppervlakte AS oppervlakte_9, t0.gebruikdsdoel AS gebruikdsdoel_10, t0.remarks AS remarks_11, t0.lat AS lat_12, t0.lng AS lng_13, t0.streetview_image_base64 AS streetview_image_base64_14, t0.building_sketch_path AS building_sketch_path_15, t0.preview_image_filename AS preview_image_filename_16, t0.preview_image_mime_type AS preview_image_mime_type_17, t0.preview_image_size AS preview_image_size_18, t0.preview_image_uploaded_at AS preview_image_uploaded_at_19, t0.status AS status_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.scheduling_token AS scheduling_token_23, t0.energy_data AS energy_data_24, t0.floor_plan AS floor_plan_25, t0.bouwlagen AS bouwlagen_26, t0.floor_mass_class AS floor_mass_class_27, t0.wall_mass_class AS wall_mass_class_28, t0.dwelling_type AS dwelling_type_29, t0.ground_height_nap AS ground_height_nap_30, t0.ridge_height_nap AS ridge_height_nap_31, t0.building_height_m AS building_height_m_32, t0.footprint_area_m2 AS footprint_area_m2_33, t0.roof_pitched_area_m2 AS roof_pitched_area_m2_34, t0.roof_flat_area_m2 AS roof_flat_area_m2_35, t0.outer_wall_area_m2 AS outer_wall_area_m2_36, t0.party_wall_area_m2 AS party_wall_area_m2_37, t0.building_volume_m3 AS building_volume_m3_38, t0.roof_type AS roof_type_39, t0.roof_facets AS roof_facets_40, t0.building_sketch_geometry AS building_sketch_geometry_41, t0.building_orientation_deg AS building_orientation_deg_42, t0.signature AS signature_43, t0.signed_at AS signed_at_44, t0.advisor_id AS advisor_id_45, t0.client_id AS client_id_46 FROM project t0 WHERE t0.id = '196';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
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 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
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)

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\User	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\AvailabilityException	No errors.
App\Entity\Project	No errors.
App\Entity\Client	No errors.
App\Entity\Product	No errors.
App\Entity\CompanyDocument	No errors.
App\Entity\ProjectProduct	No errors.
App\Entity\ProjectRemark	No errors.
App\Entity\EmailLog	No errors.

Symfony Profiler

PATCH https://backoffice.softlabel.nl/api/v1/projects/196

Configuration Settings

Theme

Page Width