Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.20 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.38 ms
(62.90%)

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.professional_competence_number AS professional_competence_number_6, t0.calendar_token AS calendar_token_7, t0.booking_lead_hours AS booking_lead_hours_8, t0.subscription AS subscription_9, t0.roles AS roles_10, t0.password AS password_11, t0.company_id AS company_id_12 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.professional_competence_number AS professional_competence_number_6,
  t0.calendar_token AS calendar_token_7,
  t0.booking_lead_hours AS booking_lead_hours_8,
  t0.subscription AS subscription_9,
  t0.roles AS roles_10,
  t0.password AS password_11,
  t0.company_id AS company_id_12
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.professional_competence_number AS professional_competence_number_6, t0.calendar_token AS calendar_token_7, t0.booking_lead_hours AS booking_lead_hours_8, t0.subscription AS subscription_9, t0.roles AS roles_10, t0.password AS password_11, t0.company_id AS company_id_12 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 7)

0.82 ms
(37.10%)

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.standpipe_penetrations AS standpipe_penetrations_11, t0.vabi_general_source AS vabi_general_source_12, t0.remarks AS remarks_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.streetview_image_base64 AS streetview_image_base64_16, t0.building_sketch_path AS building_sketch_path_17, t0.preview_image_filename AS preview_image_filename_18, t0.preview_image_mime_type AS preview_image_mime_type_19, t0.preview_image_size AS preview_image_size_20, t0.preview_image_uploaded_at AS preview_image_uploaded_at_21, t0.status AS status_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.scheduling_token AS scheduling_token_25, t0.energy_data AS energy_data_26, t0.floor_plan AS floor_plan_27, t0.appendix_g_selections AS appendix_g_selections_28, t0.bouwlagen AS bouwlagen_29, t0.floor_mass_class AS floor_mass_class_30, t0.wall_mass_class AS wall_mass_class_31, t0.dwelling_type AS dwelling_type_32, t0.ground_height_nap AS ground_height_nap_33, t0.ridge_height_nap AS ridge_height_nap_34, t0.building_height_m AS building_height_m_35, t0.footprint_area_m2 AS footprint_area_m2_36, t0.roof_pitched_area_m2 AS roof_pitched_area_m2_37, t0.roof_flat_area_m2 AS roof_flat_area_m2_38, t0.outer_wall_area_m2 AS outer_wall_area_m2_39, t0.party_wall_area_m2 AS party_wall_area_m2_40, t0.building_volume_m3 AS building_volume_m3_41, t0.roof_type AS roof_type_42, t0.roof_facets AS roof_facets_43, t0.building_sketch_geometry AS building_sketch_geometry_44, t0.building_orientation_deg AS building_orientation_deg_45, t0.signature AS signature_46, t0.signed_at AS signed_at_47, t0.advisor_id AS advisor_id_48, t0.client_id AS client_id_49 FROM project t0 WHERE t0.id = ?

Parameters:

[
  "290"
]

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.standpipe_penetrations AS standpipe_penetrations_11,
  t0.vabi_general_source AS vabi_general_source_12,
  t0.remarks AS remarks_13,
  t0.lat AS lat_14,
  t0.lng AS lng_15,
  t0.streetview_image_base64 AS streetview_image_base64_16,
  t0.building_sketch_path AS building_sketch_path_17,
  t0.preview_image_filename AS preview_image_filename_18,
  t0.preview_image_mime_type AS preview_image_mime_type_19,
  t0.preview_image_size AS preview_image_size_20,
  t0.preview_image_uploaded_at AS preview_image_uploaded_at_21,
  t0.status AS status_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.scheduling_token AS scheduling_token_25,
  t0.energy_data AS energy_data_26,
  t0.floor_plan AS floor_plan_27,
  t0.appendix_g_selections AS appendix_g_selections_28,
  t0.bouwlagen AS bouwlagen_29,
  t0.floor_mass_class AS floor_mass_class_30,
  t0.wall_mass_class AS wall_mass_class_31,
  t0.dwelling_type AS dwelling_type_32,
  t0.ground_height_nap AS ground_height_nap_33,
  t0.ridge_height_nap AS ridge_height_nap_34,
  t0.building_height_m AS building_height_m_35,
  t0.footprint_area_m2 AS footprint_area_m2_36,
  t0.roof_pitched_area_m2 AS roof_pitched_area_m2_37,
  t0.roof_flat_area_m2 AS roof_flat_area_m2_38,
  t0.outer_wall_area_m2 AS outer_wall_area_m2_39,
  t0.party_wall_area_m2 AS party_wall_area_m2_40,
  t0.building_volume_m3 AS building_volume_m3_41,
  t0.roof_type AS roof_type_42,
  t0.roof_facets AS roof_facets_43,
  t0.building_sketch_geometry AS building_sketch_geometry_44,
  t0.building_orientation_deg AS building_orientation_deg_45,
  t0.signature AS signature_46,
  t0.signed_at AS signed_at_47,
  t0.advisor_id AS advisor_id_48,
  t0.client_id AS client_id_49
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.standpipe_penetrations AS standpipe_penetrations_11, t0.vabi_general_source AS vabi_general_source_12, t0.remarks AS remarks_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.streetview_image_base64 AS streetview_image_base64_16, t0.building_sketch_path AS building_sketch_path_17, t0.preview_image_filename AS preview_image_filename_18, t0.preview_image_mime_type AS preview_image_mime_type_19, t0.preview_image_size AS preview_image_size_20, t0.preview_image_uploaded_at AS preview_image_uploaded_at_21, t0.status AS status_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.scheduling_token AS scheduling_token_25, t0.energy_data AS energy_data_26, t0.floor_plan AS floor_plan_27, t0.appendix_g_selections AS appendix_g_selections_28, t0.bouwlagen AS bouwlagen_29, t0.floor_mass_class AS floor_mass_class_30, t0.wall_mass_class AS wall_mass_class_31, t0.dwelling_type AS dwelling_type_32, t0.ground_height_nap AS ground_height_nap_33, t0.ridge_height_nap AS ridge_height_nap_34, t0.building_height_m AS building_height_m_35, t0.footprint_area_m2 AS footprint_area_m2_36, t0.roof_pitched_area_m2 AS roof_pitched_area_m2_37, t0.roof_flat_area_m2 AS roof_flat_area_m2_38, t0.outer_wall_area_m2 AS outer_wall_area_m2_39, t0.party_wall_area_m2 AS party_wall_area_m2_40, t0.building_volume_m3 AS building_volume_m3_41, t0.roof_type AS roof_type_42, t0.roof_facets AS roof_facets_43, t0.building_sketch_geometry AS building_sketch_geometry_44, t0.building_orientation_deg AS building_orientation_deg_45, t0.signature AS signature_46, t0.signed_at AS signed_at_47, t0.advisor_id AS advisor_id_48, t0.client_id AS client_id_49 FROM project t0 WHERE t0.id = '290';

#	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 7)

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/290

Configuration Settings

Theme

Page Width