Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.22 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.22 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.profile_picture_filename AS profile_picture_filename_10, t0.oauth_data AS oauth_data_11, t0.on_boarding_completed_at AS on_boarding_completed_at_12, t0.dob AS dob_13, t0.gender AS gender_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.bio AS bio_17, t0.nickname AS nickname_18, t0.blocked AS blocked_19, t0.is_hybrid_recruiter AS is_hybrid_recruiter_20, t0.address AS address_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.employer_id AS employer_id_24, t25.id AS id_26, t25.name AS name_27, t25.suffix AS suffix_28, t25.title AS title_29, t25.npi_number AS npi_number_30, t25.phone_home AS phone_home_31, t25.phone_work AS phone_work_32, t25.phone_mobile AS phone_mobile_33, t25.cv_filename AS cv_filename_34, t25.country AS country_35, t25.state AS state_36, t25.city AS city_37, t25.zip_code AS zip_code_38, t25.street_address AS street_address_39, t25.desired_pay_rate AS desired_pay_rate_40, t25.pay_rate_hourly AS pay_rate_hourly_41, t25.pay_rate_daily AS pay_rate_daily_42, t25.desired_hour AS desired_hour_43, t25.desired_states AS desired_states_44, t25.availability_to_start AS availability_to_start_45, t25.willing_to_travel AS willing_to_travel_46, t25.preferred_patient_volume AS preferred_patient_volume_47, t25.release_authorization_date AS release_authorization_date_48, t25.ssn AS ssn_49, t25.dob AS dob_50, t25.country_of_birth AS country_of_birth_51, t25.state_of_birth AS state_of_birth_52, t25.city_of_birth AS city_of_birth_53, t25.release_and_authorization_accepted AS release_and_authorization_accepted_54, t25.application_certification_date AS application_certification_date_55, t25.risk_assessment AS risk_assessment_56, t25.health_assessment AS health_assessment_57, t25.cashback AS cashback_58, t25.notification_preferences AS notification_preferences_59, t25.average_point AS average_point_60, t25.skip_onboarding AS skip_onboarding_61, t25.created_at AS created_at_62, t25.updated_at AS updated_at_63, t25.user_id AS user_id_64, t25.profession_id AS profession_id_65, t66.id AS id_67, t66.company_name AS company_name_68, t66.speciality AS speciality_69, t66.membership_level AS membership_level_70, t66.rating AS rating_71, t66.is_verified AS is_verified_72, t66.created_at AS created_at_73, t66.updated_at AS updated_at_74, t66.user_id AS user_id_75, t0.recruiter_id AS recruiter_id_76 FROM b_user t0 LEFT JOIN b_provider t25 ON t25.user_id = t0.id LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  b"\x1F\x0EdŸ\x12ÌdZ”)s$\x18ívÀ"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.user_type AS user_type_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.is_verified AS is_verified_7,
  t0.oauth_provider AS oauth_provider_8,
  t0.oauth_id AS oauth_id_9,
  t0.profile_picture_filename AS profile_picture_filename_10,
  t0.oauth_data AS oauth_data_11,
  t0.on_boarding_completed_at AS on_boarding_completed_at_12,
  t0.dob AS dob_13,
  t0.gender AS gender_14,
  t0.phone1 AS phone1_15,
  t0.phone2 AS phone2_16,
  t0.bio AS bio_17,
  t0.nickname AS nickname_18,
  t0.blocked AS blocked_19,
  t0.is_hybrid_recruiter AS is_hybrid_recruiter_20,
  t0.address AS address_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.employer_id AS employer_id_24,
  t25.id AS id_26,
  t25.name AS name_27,
  t25.suffix AS suffix_28,
  t25.title AS title_29,
  t25.npi_number AS npi_number_30,
  t25.phone_home AS phone_home_31,
  t25.phone_work AS phone_work_32,
  t25.phone_mobile AS phone_mobile_33,
  t25.cv_filename AS cv_filename_34,
  t25.country AS country_35,
  t25.state AS state_36,
  t25.city AS city_37,
  t25.zip_code AS zip_code_38,
  t25.street_address AS street_address_39,
  t25.desired_pay_rate AS desired_pay_rate_40,
  t25.pay_rate_hourly AS pay_rate_hourly_41,
  t25.pay_rate_daily AS pay_rate_daily_42,
  t25.desired_hour AS desired_hour_43,
  t25.desired_states AS desired_states_44,
  t25.availability_to_start AS availability_to_start_45,
  t25.willing_to_travel AS willing_to_travel_46,
  t25.preferred_patient_volume AS preferred_patient_volume_47,
  t25.release_authorization_date AS release_authorization_date_48,
  t25.ssn AS ssn_49,
  t25.dob AS dob_50,
  t25.country_of_birth AS country_of_birth_51,
  t25.state_of_birth AS state_of_birth_52,
  t25.city_of_birth AS city_of_birth_53,
  t25.release_and_authorization_accepted AS release_and_authorization_accepted_54,
  t25.application_certification_date AS application_certification_date_55,
  t25.risk_assessment AS risk_assessment_56,
  t25.health_assessment AS health_assessment_57,
  t25.cashback AS cashback_58,
  t25.notification_preferences AS notification_preferences_59,
  t25.average_point AS average_point_60,
  t25.skip_onboarding AS skip_onboarding_61,
  t25.created_at AS created_at_62,
  t25.updated_at AS updated_at_63,
  t25.user_id AS user_id_64,
  t25.profession_id AS profession_id_65,
  t66.id AS id_67,
  t66.company_name AS company_name_68,
  t66.speciality AS speciality_69,
  t66.membership_level AS membership_level_70,
  t66.rating AS rating_71,
  t66.is_verified AS is_verified_72,
  t66.created_at AS created_at_73,
  t66.updated_at AS updated_at_74,
  t66.user_id AS user_id_75,
  t0.recruiter_id AS recruiter_id_76
FROM
  b_user t0
  LEFT JOIN b_provider t25 ON t25.user_id = t0.id
  LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.user_type AS user_type_4, t0.roles AS roles_5, t0.password AS password_6, t0.is_verified AS is_verified_7, t0.oauth_provider AS oauth_provider_8, t0.oauth_id AS oauth_id_9, t0.profile_picture_filename AS profile_picture_filename_10, t0.oauth_data AS oauth_data_11, t0.on_boarding_completed_at AS on_boarding_completed_at_12, t0.dob AS dob_13, t0.gender AS gender_14, t0.phone1 AS phone1_15, t0.phone2 AS phone2_16, t0.bio AS bio_17, t0.nickname AS nickname_18, t0.blocked AS blocked_19, t0.is_hybrid_recruiter AS is_hybrid_recruiter_20, t0.address AS address_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.employer_id AS employer_id_24, t25.id AS id_26, t25.name AS name_27, t25.suffix AS suffix_28, t25.title AS title_29, t25.npi_number AS npi_number_30, t25.phone_home AS phone_home_31, t25.phone_work AS phone_work_32, t25.phone_mobile AS phone_mobile_33, t25.cv_filename AS cv_filename_34, t25.country AS country_35, t25.state AS state_36, t25.city AS city_37, t25.zip_code AS zip_code_38, t25.street_address AS street_address_39, t25.desired_pay_rate AS desired_pay_rate_40, t25.pay_rate_hourly AS pay_rate_hourly_41, t25.pay_rate_daily AS pay_rate_daily_42, t25.desired_hour AS desired_hour_43, t25.desired_states AS desired_states_44, t25.availability_to_start AS availability_to_start_45, t25.willing_to_travel AS willing_to_travel_46, t25.preferred_patient_volume AS preferred_patient_volume_47, t25.release_authorization_date AS release_authorization_date_48, t25.ssn AS ssn_49, t25.dob AS dob_50, t25.country_of_birth AS country_of_birth_51, t25.state_of_birth AS state_of_birth_52, t25.city_of_birth AS city_of_birth_53, t25.release_and_authorization_accepted AS release_and_authorization_accepted_54, t25.application_certification_date AS application_certification_date_55, t25.risk_assessment AS risk_assessment_56, t25.health_assessment AS health_assessment_57, t25.cashback AS cashback_58, t25.notification_preferences AS notification_preferences_59, t25.average_point AS average_point_60, t25.skip_onboarding AS skip_onboarding_61, t25.created_at AS created_at_62, t25.updated_at AS updated_at_63, t25.user_id AS user_id_64, t25.profession_id AS profession_id_65, t66.id AS id_67, t66.company_name AS company_name_68, t66.speciality AS speciality_69, t66.membership_level AS membership_level_70, t66.rating AS rating_71, t66.is_verified AS is_verified_72, t66.created_at AS created_at_73, t66.updated_at AS updated_at_74, t66.user_id AS user_id_75, t0.recruiter_id AS recruiter_id_76 FROM b_user t0 LEFT JOIN b_provider t25 ON t25.user_id = t0.id LEFT JOIN b_recruiter t66 ON t66.user_id = t0.id WHERE t0.id = 0x1F0E649F12CC645A9429732418ED76C0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	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\Provider	1
App\Entity\Recruiter	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Employer	No errors.
App\Entity\Provider	No errors.
App\Entity\Profession	No errors.
App\Entity\Recruiter	No errors.
App\Entity\Speciality	No errors.
App\Entity\Application	No errors.
App\Entity\JobRecruiter	No errors.
App\Entity\Invoice	No errors.

Symfony Profiler

GET https://bill.flexzob.com/provider/jobs/application/1f0edd6d-521a-600c-a3c4-bf8ca0545471/detail-content

Configuration Settings

Theme

Page Width