Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.30 ms Query time

3 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.30 ms
(100.00%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.full_name AS full_name_6, t0.password AS password_7, t0.booking_btn_name AS booking_btn_name_8, t0.booking_btn_clr AS booking_btn_clr_9, t0.booking_btn_bg_clr AS booking_btn_bg_clr_10, t0.inner_color AS inner_color_11, t0.outer_color AS outer_color_12, t0.background_img AS background_img_13, t0.profile_img AS profile_img_14, t0.role AS role_15, t0.enabled AS enabled_16, t0.locked AS locked_17, t0.visible AS visible_18, t0.is_disengaged AS is_disengaged_19, t0.otp AS otp_20, t0.otp_sent_at AS otp_sent_at_21, t0.last_otp_verified AS last_otp_verified_22, t0.imap_setting AS imap_setting_23, t0.country_code AS country_code_24, t0.phone AS phone_25, t0.practitioner_commission AS practitioner_commission_26, t0.coordinator_commission AS coordinator_commission_27, t0.course_commission AS course_commission_28, t0.membership_commission AS membership_commission_29, t0.product_commission AS product_commission_30, t0.token AS token_31, t0.access_all_calendars AS access_all_calendars_32, t0.current_auth_token AS current_auth_token_33, t0.last_auth_time AS last_auth_time_34, t0.hash AS hash_35, t0.fcm_token AS fcm_token_36, t0.hx_change_token AS hx_change_token_37, t0.login_from AS login_from_38, t0.ever_login_in_v3 AS ever_login_in_v3_39, t0.permissions AS permissions_40, t0.clinic_id AS clinic_id_41, t0.fp_promoter_id AS fp_promoter_id_42, t0.referral_link AS referral_link_43, t0.fp_tracking_id AS fp_tracking_id_44, t0.receive_special_offer_email AS receive_special_offer_email_45, t0.receive_special_offer_sms AS receive_special_offer_sms_46, t0.deleted_at AS deleted_at_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49, t0.media_id AS media_id_50, t0.device_id AS device_id_51, t0.created_by_id AS created_by_id_52, t0.type, t0.stripe_customer_id AS stripe_customer_id_53, t0.stripe_customer_id AS stripe_customer_id_54, t0.organisation_id AS organisation_id_55, t0.current_clinic_id AS current_clinic_id_56, t0.status AS status_57, t0.birthday AS birthday_58, t0.country_code_alt AS country_code_alt_59, t0.secondary_phone AS secondary_phone_60, t0.next_kin AS next_kin_61, t0.next_kin_phone AS next_kin_phone_62, t0.description AS description_63, t0.glogau_scale AS glogau_scale_64, t0.fitzpatrick_scale AS fitzpatrick_scale_65, t0.gender AS gender_66, t0.receive_special_offer_push AS receive_special_offer_push_67, t0.receive_reminder_email AS receive_reminder_email_68, t0.receive_reminder_sms AS receive_reminder_sms_69, t0.receive_reminder_push AS receive_reminder_push_70, t0.parent_user_id AS parent_user_id_71, t0.account_type AS account_type_72, t0.terms_accepted AS terms_accepted_73, t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_74, t0.referral AS referral_75, t0.export_in_progress AS export_in_progress_76, t0.occupation AS occupation_77, t0.number_nhs AS number_nhs_78, t0.gp_name AS gp_name_79, t0.contact_gp AS contact_gp_80, t0.gp_address1 AS gp_address1_81, t0.gp_address2 AS gp_address2_82, t0.gp_town AS gp_town_83, t0.gp_county AS gp_county_84, t0.gp_post_code AS gp_post_code_85, t0.gp_country AS gp_country_86, t0.ref AS ref_87, t0.chronoscan_code AS chronoscan_code_88, t0.ethnicity AS ethnicity_89, t0.height AS height_90, t0.weight AS weight_91, t0.passport AS passport_92, t0.reference_number AS reference_number_93, t0.photo_consent AS photo_consent_94, t0.all_marketing AS all_marketing_95, t0.in_clinic_marketing AS in_clinic_marketing_96, t0.in_consultation AS in_consultation_97, t0.interested_in AS interested_in_98, t0.consultation_type AS consultation_type_99, t0.google_click_id AS google_click_id_100, t0.campaign_name AS campaign_name_101, t0.campaign_source AS campaign_source_102, t0.campaign_medium AS campaign_medium_103, t0.campaign_term AS campaign_term_104, t0.campaign_content AS campaign_content_105, t0.marketing_source AS marketing_source_106, t0.author AS author_107, t0.address1 AS address1_108, t0.address2 AS address2_109, t0.town AS town_110, t0.state AS state_111, t0.country AS country_112, t0.postcode AS postcode_113, t0.parent_id AS parent_id_114, t0.active_photo_id AS active_photo_id_115, t0.bar_code_image_id AS bar_code_image_id_116, t0.clinic_id AS clinic_id_117, t0.prospect_id AS prospect_id_118, t0.qualification AS qualification_119, t0.summary AS summary_120, t0.deleted AS deleted_121, t0.calendar_color AS calendar_color_122, t0.calendar_order_number AS calendar_order_number_123, t0.calendar_id AS calendar_id_124, t0.position AS position_125, t0.online_booking_availability AS online_booking_availability_126, t0.title AS title_127, t0.email_verify AS email_verify_128, t0.hash_user_short_url AS hash_user_short_url_129, t0.licence_number AS licence_number_130, t0.stripe_customer_id AS stripe_customer_id_131, t0.is_online AS is_online_132, t0.last_call_time AS last_call_time_133, t0.hide_report_menus AS hide_report_menus_134, t0.clinic_id AS clinic_id_135, t0.i_calendar_id AS i_calendar_id_136 FROM user t0 WHERE t0.id = ? AND t0.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user')

Parameters:

[
  146719
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.full_name AS full_name_6,
  t0.password AS password_7,
  t0.booking_btn_name AS booking_btn_name_8,
  t0.booking_btn_clr AS booking_btn_clr_9,
  t0.booking_btn_bg_clr AS booking_btn_bg_clr_10,
  t0.inner_color AS inner_color_11,
  t0.outer_color AS outer_color_12,
  t0.background_img AS background_img_13,
  t0.profile_img AS profile_img_14,
  t0.role AS role_15,
  t0.enabled AS enabled_16,
  t0.locked AS locked_17,
  t0.visible AS visible_18,
  t0.is_disengaged AS is_disengaged_19,
  t0.otp AS otp_20,
  t0.otp_sent_at AS otp_sent_at_21,
  t0.last_otp_verified AS last_otp_verified_22,
  t0.imap_setting AS imap_setting_23,
  t0.country_code AS country_code_24,
  t0.phone AS phone_25,
  t0.practitioner_commission AS practitioner_commission_26,
  t0.coordinator_commission AS coordinator_commission_27,
  t0.course_commission AS course_commission_28,
  t0.membership_commission AS membership_commission_29,
  t0.product_commission AS product_commission_30,
  t0.token AS token_31,
  t0.access_all_calendars AS access_all_calendars_32,
  t0.current_auth_token AS current_auth_token_33,
  t0.last_auth_time AS last_auth_time_34,
  t0.hash AS hash_35,
  t0.fcm_token AS fcm_token_36,
  t0.hx_change_token AS hx_change_token_37,
  t0.login_from AS login_from_38,
  t0.ever_login_in_v3 AS ever_login_in_v3_39,
  t0.permissions AS permissions_40,
  t0.clinic_id AS clinic_id_41,
  t0.fp_promoter_id AS fp_promoter_id_42,
  t0.referral_link AS referral_link_43,
  t0.fp_tracking_id AS fp_tracking_id_44,
  t0.receive_special_offer_email AS receive_special_offer_email_45,
  t0.receive_special_offer_sms AS receive_special_offer_sms_46,
  t0.deleted_at AS deleted_at_47,
  t0.created_at AS created_at_48,
  t0.updated_at AS updated_at_49,
  t0.media_id AS media_id_50,
  t0.device_id AS device_id_51,
  t0.created_by_id AS created_by_id_52,
  t0.type,
  t0.stripe_customer_id AS stripe_customer_id_53,
  t0.stripe_customer_id AS stripe_customer_id_54,
  t0.organisation_id AS organisation_id_55,
  t0.current_clinic_id AS current_clinic_id_56,
  t0.status AS status_57,
  t0.birthday AS birthday_58,
  t0.country_code_alt AS country_code_alt_59,
  t0.secondary_phone AS secondary_phone_60,
  t0.next_kin AS next_kin_61,
  t0.next_kin_phone AS next_kin_phone_62,
  t0.description AS description_63,
  t0.glogau_scale AS glogau_scale_64,
  t0.fitzpatrick_scale AS fitzpatrick_scale_65,
  t0.gender AS gender_66,
  t0.receive_special_offer_push AS receive_special_offer_push_67,
  t0.receive_reminder_email AS receive_reminder_email_68,
  t0.receive_reminder_sms AS receive_reminder_sms_69,
  t0.receive_reminder_push AS receive_reminder_push_70,
  t0.parent_user_id AS parent_user_id_71,
  t0.account_type AS account_type_72,
  t0.terms_accepted AS terms_accepted_73,
  t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_74,
  t0.referral AS referral_75,
  t0.export_in_progress AS export_in_progress_76,
  t0.occupation AS occupation_77,
  t0.number_nhs AS number_nhs_78,
  t0.gp_name AS gp_name_79,
  t0.contact_gp AS contact_gp_80,
  t0.gp_address1 AS gp_address1_81,
  t0.gp_address2 AS gp_address2_82,
  t0.gp_town AS gp_town_83,
  t0.gp_county AS gp_county_84,
  t0.gp_post_code AS gp_post_code_85,
  t0.gp_country AS gp_country_86,
  t0.ref AS ref_87,
  t0.chronoscan_code AS chronoscan_code_88,
  t0.ethnicity AS ethnicity_89,
  t0.height AS height_90,
  t0.weight AS weight_91,
  t0.passport AS passport_92,
  t0.reference_number AS reference_number_93,
  t0.photo_consent AS photo_consent_94,
  t0.all_marketing AS all_marketing_95,
  t0.in_clinic_marketing AS in_clinic_marketing_96,
  t0.in_consultation AS in_consultation_97,
  t0.interested_in AS interested_in_98,
  t0.consultation_type AS consultation_type_99,
  t0.google_click_id AS google_click_id_100,
  t0.campaign_name AS campaign_name_101,
  t0.campaign_source AS campaign_source_102,
  t0.campaign_medium AS campaign_medium_103,
  t0.campaign_term AS campaign_term_104,
  t0.campaign_content AS campaign_content_105,
  t0.marketing_source AS marketing_source_106,
  t0.author AS author_107,
  t0.address1 AS address1_108,
  t0.address2 AS address2_109,
  t0.town AS town_110,
  t0.state AS state_111,
  t0.country AS country_112,
  t0.postcode AS postcode_113,
  t0.parent_id AS parent_id_114,
  t0.active_photo_id AS active_photo_id_115,
  t0.bar_code_image_id AS bar_code_image_id_116,
  t0.clinic_id AS clinic_id_117,
  t0.prospect_id AS prospect_id_118,
  t0.qualification AS qualification_119,
  t0.summary AS summary_120,
  t0.deleted AS deleted_121,
  t0.calendar_color AS calendar_color_122,
  t0.calendar_order_number AS calendar_order_number_123,
  t0.calendar_id AS calendar_id_124,
  t0.position AS position_125,
  t0.online_booking_availability AS online_booking_availability_126,
  t0.title AS title_127,
  t0.email_verify AS email_verify_128,
  t0.hash_user_short_url AS hash_user_short_url_129,
  t0.licence_number AS licence_number_130,
  t0.stripe_customer_id AS stripe_customer_id_131,
  t0.is_online AS is_online_132,
  t0.last_call_time AS last_call_time_133,
  t0.hide_report_menus AS hide_report_menus_134,
  t0.clinic_id AS clinic_id_135,
  t0.i_calendar_id AS i_calendar_id_136
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'admin', 'admin_support', 'super_clinic_admin',
    'patient', 'clinic_user'
  )

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.full_name AS full_name_6, t0.password AS password_7, t0.booking_btn_name AS booking_btn_name_8, t0.booking_btn_clr AS booking_btn_clr_9, t0.booking_btn_bg_clr AS booking_btn_bg_clr_10, t0.inner_color AS inner_color_11, t0.outer_color AS outer_color_12, t0.background_img AS background_img_13, t0.profile_img AS profile_img_14, t0.role AS role_15, t0.enabled AS enabled_16, t0.locked AS locked_17, t0.visible AS visible_18, t0.is_disengaged AS is_disengaged_19, t0.otp AS otp_20, t0.otp_sent_at AS otp_sent_at_21, t0.last_otp_verified AS last_otp_verified_22, t0.imap_setting AS imap_setting_23, t0.country_code AS country_code_24, t0.phone AS phone_25, t0.practitioner_commission AS practitioner_commission_26, t0.coordinator_commission AS coordinator_commission_27, t0.course_commission AS course_commission_28, t0.membership_commission AS membership_commission_29, t0.product_commission AS product_commission_30, t0.token AS token_31, t0.access_all_calendars AS access_all_calendars_32, t0.current_auth_token AS current_auth_token_33, t0.last_auth_time AS last_auth_time_34, t0.hash AS hash_35, t0.fcm_token AS fcm_token_36, t0.hx_change_token AS hx_change_token_37, t0.login_from AS login_from_38, t0.ever_login_in_v3 AS ever_login_in_v3_39, t0.permissions AS permissions_40, t0.clinic_id AS clinic_id_41, t0.fp_promoter_id AS fp_promoter_id_42, t0.referral_link AS referral_link_43, t0.fp_tracking_id AS fp_tracking_id_44, t0.receive_special_offer_email AS receive_special_offer_email_45, t0.receive_special_offer_sms AS receive_special_offer_sms_46, t0.deleted_at AS deleted_at_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49, t0.media_id AS media_id_50, t0.device_id AS device_id_51, t0.created_by_id AS created_by_id_52, t0.type, t0.stripe_customer_id AS stripe_customer_id_53, t0.stripe_customer_id AS stripe_customer_id_54, t0.organisation_id AS organisation_id_55, t0.current_clinic_id AS current_clinic_id_56, t0.status AS status_57, t0.birthday AS birthday_58, t0.country_code_alt AS country_code_alt_59, t0.secondary_phone AS secondary_phone_60, t0.next_kin AS next_kin_61, t0.next_kin_phone AS next_kin_phone_62, t0.description AS description_63, t0.glogau_scale AS glogau_scale_64, t0.fitzpatrick_scale AS fitzpatrick_scale_65, t0.gender AS gender_66, t0.receive_special_offer_push AS receive_special_offer_push_67, t0.receive_reminder_email AS receive_reminder_email_68, t0.receive_reminder_sms AS receive_reminder_sms_69, t0.receive_reminder_push AS receive_reminder_push_70, t0.parent_user_id AS parent_user_id_71, t0.account_type AS account_type_72, t0.terms_accepted AS terms_accepted_73, t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_74, t0.referral AS referral_75, t0.export_in_progress AS export_in_progress_76, t0.occupation AS occupation_77, t0.number_nhs AS number_nhs_78, t0.gp_name AS gp_name_79, t0.contact_gp AS contact_gp_80, t0.gp_address1 AS gp_address1_81, t0.gp_address2 AS gp_address2_82, t0.gp_town AS gp_town_83, t0.gp_county AS gp_county_84, t0.gp_post_code AS gp_post_code_85, t0.gp_country AS gp_country_86, t0.ref AS ref_87, t0.chronoscan_code AS chronoscan_code_88, t0.ethnicity AS ethnicity_89, t0.height AS height_90, t0.weight AS weight_91, t0.passport AS passport_92, t0.reference_number AS reference_number_93, t0.photo_consent AS photo_consent_94, t0.all_marketing AS all_marketing_95, t0.in_clinic_marketing AS in_clinic_marketing_96, t0.in_consultation AS in_consultation_97, t0.interested_in AS interested_in_98, t0.consultation_type AS consultation_type_99, t0.google_click_id AS google_click_id_100, t0.campaign_name AS campaign_name_101, t0.campaign_source AS campaign_source_102, t0.campaign_medium AS campaign_medium_103, t0.campaign_term AS campaign_term_104, t0.campaign_content AS campaign_content_105, t0.marketing_source AS marketing_source_106, t0.author AS author_107, t0.address1 AS address1_108, t0.address2 AS address2_109, t0.town AS town_110, t0.state AS state_111, t0.country AS country_112, t0.postcode AS postcode_113, t0.parent_id AS parent_id_114, t0.active_photo_id AS active_photo_id_115, t0.bar_code_image_id AS bar_code_image_id_116, t0.clinic_id AS clinic_id_117, t0.prospect_id AS prospect_id_118, t0.qualification AS qualification_119, t0.summary AS summary_120, t0.deleted AS deleted_121, t0.calendar_color AS calendar_color_122, t0.calendar_order_number AS calendar_order_number_123, t0.calendar_id AS calendar_id_124, t0.position AS position_125, t0.online_booking_availability AS online_booking_availability_126, t0.title AS title_127, t0.email_verify AS email_verify_128, t0.hash_user_short_url AS hash_user_short_url_129, t0.licence_number AS licence_number_130, t0.stripe_customer_id AS stripe_customer_id_131, t0.is_online AS is_online_132, t0.last_call_time AS last_call_time_133, t0.hide_report_menus AS hide_report_menus_134, t0.clinic_id AS clinic_id_135, t0.i_calendar_id AS i_calendar_id_136 FROM user t0 WHERE t0.id = 146719 AND t0.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user');

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
10	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
12	Symfony\Bundle\SecurityBundle\Security->getToken (line 97)
13	Symfony\Bundle\SecurityBundle\Security->getUser (line 52)
14	App\EventListener\ValidateSessionListener->__invoke (line 30)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 4)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
pgsql	doctrine.dbal.pgsql_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\Person\User	1
App\Entity\Media\Media	1
App\Entity\Patient\Photo	1
App\Entity\Clinic\Clinic	1

Entities Mapping

Class	Mapping errors
App\Entity\Person\User	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Person\Device	No errors.
App\Entity\Person\Admin	No errors.
App\Entity\Person\AdminSupport	No errors.
App\Entity\Clinic\Person\ClinicUser	No errors.
App\Entity\Person\SuperClinicAdmin	No errors.
App\Entity\Organisation\Organisation	No errors.
App\Entity\Clinic\Clinic	The mappings App\Entity\Clinic\Clinic#memberships and App\Entity\Clinic\Membership\Membership#clinic are inconsistent with each other.
App\Entity\Person\Patient	No errors.
App\Entity\Patient\Photo	No errors.
App\Entity\LeadCapture\LeadCapture	No errors.
App\Entity\ProspectsMessage	No errors.
App\Entity\Clinic\Appointment	No errors.
App\Entity\Patient\TreatmentPlan	The mappings App\Entity\Patient\TreatmentPlan#superClinicAdmin and App\Entity\Person\SuperClinicAdmin#treatmentPlans are inconsistent with each other.
App\Entity\Patient\SurveySent	No errors.
App\Entity\Patient\Form	No errors.
App\Entity\Patient\BaseInvoice	No errors.
App\Entity\Clinic\Questionaire\Answer	No errors.
App\Entity\Patient\Questionnaire\QuestionnairePDF	No errors.
App\Entity\Clinic\Stock\TreatmentClinic	No errors.
App\Entity\Patient\Note\Note	No errors.
App\Entity\Patient\Document	No errors.
App\Entity\Patient\Note\MemoryJog	No errors.
App\Entity\Patient\Note\ConsultationNote	No errors.
App\Entity\Patient\Sketch	No errors.
App\Entity\Person\Patient\Balance	No errors.
App\Entity\Clinic\Export\ExportData	No errors.
App\Entity\Patient\Correspondence\Correspondence	The association App\Entity\Patient\Correspondence\Correspondence#leadCapture refers to the inverse side field App\Entity\LeadCapture\LeadCapture#correspondences which does not exist.
App\Entity\Clinic\ViewedFormFile	No errors.
App\Entity\Patient\LearnAbout	No errors.
App\Entity\Patient\Incident	No errors.