Query Metrics
6
Database Queries
6
Different statements
51.03 ms
Query time
3
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.41 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.otp AS otp_18, u0_.otp_sent_at AS otp_sent_at_19, u0_.last_otp_verified AS last_otp_verified_20, u0_.imap_setting AS imap_setting_21, u0_.country_code AS country_code_22, u0_.phone AS phone_23, u0_.practitioner_commission AS practitioner_commission_24, u0_.coordinator_commission AS coordinator_commission_25, u0_.course_commission AS course_commission_26, u0_.membership_commission AS membership_commission_27, u0_.product_commission AS product_commission_28, u0_.token AS token_29, u0_.access_all_calendars AS access_all_calendars_30, u0_.current_auth_token AS current_auth_token_31, u0_.last_auth_time AS last_auth_time_32, u0_.hash AS hash_33, u0_.hx_change_token AS hx_change_token_34, u0_.login_from AS login_from_35, u0_.ever_login_in_v3 AS ever_login_in_v3_36, u0_.deleted_at AS deleted_at_37, u0_.created_at AS created_at_38, u0_.updated_at AS updated_at_39, u0_.status AS status_40, u0_.birthday AS birthday_41, u0_.country_code_alt AS country_code_alt_42, u0_.secondary_phone AS secondary_phone_43, u0_.next_kin AS next_kin_44, u0_.next_kin_phone AS next_kin_phone_45, u0_.description AS description_46, u0_.glogau_scale AS glogau_scale_47, u0_.fitzpatrick_scale AS fitzpatrick_scale_48, u0_.gender AS gender_49, u0_.receive_special_offer_email AS receive_special_offer_email_50, u0_.receive_special_offer_sms AS receive_special_offer_sms_51, u0_.receive_special_offer_push AS receive_special_offer_push_52, u0_.receive_reminder_email AS receive_reminder_email_53, u0_.receive_reminder_sms AS receive_reminder_sms_54, u0_.receive_reminder_push AS receive_reminder_push_55, u0_.parent_user_id AS parent_user_id_56, u0_.account_type AS account_type_57, u0_.terms_accepted AS terms_accepted_58, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_59, u0_.referral AS referral_60, u0_.export_in_progress AS export_in_progress_61, u0_.occupation AS occupation_62, u0_.number_nhs AS number_nhs_63, u0_.gp_name AS gp_name_64, u0_.contact_gp AS contact_gp_65, u0_.gp_address1 AS gp_address1_66, u0_.gp_address2 AS gp_address2_67, u0_.gp_town AS gp_town_68, u0_.gp_county AS gp_county_69, u0_.gp_post_code AS gp_post_code_70, u0_.gp_country AS gp_country_71, u0_.ref AS ref_72, u0_.chronoscan_code AS chronoscan_code_73, u0_.ethnicity AS ethnicity_74, u0_.height AS height_75, u0_.weight AS weight_76, u0_.passport AS passport_77, u0_.reference_number AS reference_number_78, u0_.photo_consent AS photo_consent_79, u0_.all_marketing AS all_marketing_80, u0_.in_clinic_marketing AS in_clinic_marketing_81, u0_.in_consultation AS in_consultation_82, u0_.interested_in AS interested_in_83, u0_.consultation_type AS consultation_type_84, u0_.google_click_id AS google_click_id_85, u0_.campaign_name AS campaign_name_86, u0_.campaign_source AS campaign_source_87, u0_.campaign_medium AS campaign_medium_88, u0_.campaign_term AS campaign_term_89, u0_.campaign_content AS campaign_content_90, u0_.marketing_source AS marketing_source_91, u0_.author AS author_92, u0_.address1 AS address1_93, u0_.address2 AS address2_94, u0_.town AS town_95, u0_.state AS state_96, u0_.country AS country_97, u0_.postcode AS postcode_98, u0_.qualification AS qualification_99, u0_.summary AS summary_100, u0_.deleted AS deleted_101, u0_.calendar_color AS calendar_color_102, u0_.calendar_order_number AS calendar_order_number_103, u0_.calendar_id AS calendar_id_104, u0_.position AS position_105, u0_.online_booking_availability AS online_booking_availability_106, u0_.title AS title_107, u0_.email_verify AS email_verify_108, u0_.hash_user_short_url AS hash_user_short_url_109, u0_.licence_number AS licence_number_110, u0_.stripe_customer_id AS stripe_customer_id_111, u0_.is_online AS is_online_112, u0_.last_call_time AS last_call_time_113, u0_.type AS type_114, u0_.media_id AS media_id_115, u0_.device_id AS device_id_116, u0_.created_by_id AS created_by_id_117, u0_.organisation_id AS organisation_id_118, u0_.current_clinic_id AS current_clinic_id_119, u0_.parent_id AS parent_id_120, u0_.active_photo_id AS active_photo_id_121, u0_.bar_code_image_id AS bar_code_image_id_122, u0_.clinic_id AS clinic_id_123, u0_.prospect_id AS prospect_id_124, u0_.clinic_id AS clinic_id_125, u0_.i_calendar_id AS i_calendar_id_126 FROM user u0_ LEFT JOIN device d1_ ON u0_.device_id = d1_.id WHERE (d1_.token = ? AND d1_.expired_at > ? AND d1_.logout_by_reason_of_license <> 1) AND u0_.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1
Parameters:
[ "demo" "2025-08-04 12:15:09" ] |
| 2 | 9.78 ms |
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.otp AS otp_18, u0_.otp_sent_at AS otp_sent_at_19, u0_.last_otp_verified AS last_otp_verified_20, u0_.imap_setting AS imap_setting_21, u0_.country_code AS country_code_22, u0_.phone AS phone_23, u0_.practitioner_commission AS practitioner_commission_24, u0_.coordinator_commission AS coordinator_commission_25, u0_.course_commission AS course_commission_26, u0_.membership_commission AS membership_commission_27, u0_.product_commission AS product_commission_28, u0_.token AS token_29, u0_.access_all_calendars AS access_all_calendars_30, u0_.current_auth_token AS current_auth_token_31, u0_.last_auth_time AS last_auth_time_32, u0_.hash AS hash_33, u0_.hx_change_token AS hx_change_token_34, u0_.login_from AS login_from_35, u0_.ever_login_in_v3 AS ever_login_in_v3_36, u0_.deleted_at AS deleted_at_37, u0_.created_at AS created_at_38, u0_.updated_at AS updated_at_39, u0_.status AS status_40, u0_.birthday AS birthday_41, u0_.country_code_alt AS country_code_alt_42, u0_.secondary_phone AS secondary_phone_43, u0_.next_kin AS next_kin_44, u0_.next_kin_phone AS next_kin_phone_45, u0_.description AS description_46, u0_.glogau_scale AS glogau_scale_47, u0_.fitzpatrick_scale AS fitzpatrick_scale_48, u0_.gender AS gender_49, u0_.receive_special_offer_email AS receive_special_offer_email_50, u0_.receive_special_offer_sms AS receive_special_offer_sms_51, u0_.receive_special_offer_push AS receive_special_offer_push_52, u0_.receive_reminder_email AS receive_reminder_email_53, u0_.receive_reminder_sms AS receive_reminder_sms_54, u0_.receive_reminder_push AS receive_reminder_push_55, u0_.parent_user_id AS parent_user_id_56, u0_.account_type AS account_type_57, u0_.terms_accepted AS terms_accepted_58, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_59, u0_.referral AS referral_60, u0_.export_in_progress AS export_in_progress_61, u0_.occupation AS occupation_62, u0_.number_nhs AS number_nhs_63, u0_.gp_name AS gp_name_64, u0_.contact_gp AS contact_gp_65, u0_.gp_address1 AS gp_address1_66, u0_.gp_address2 AS gp_address2_67, u0_.gp_town AS gp_town_68, u0_.gp_county AS gp_county_69, u0_.gp_post_code AS gp_post_code_70, u0_.gp_country AS gp_country_71, u0_.ref AS ref_72, u0_.chronoscan_code AS chronoscan_code_73, u0_.ethnicity AS ethnicity_74, u0_.height AS height_75, u0_.weight AS weight_76, u0_.passport AS passport_77, u0_.reference_number AS reference_number_78, u0_.photo_consent AS photo_consent_79, u0_.all_marketing AS all_marketing_80, u0_.in_clinic_marketing AS in_clinic_marketing_81, u0_.in_consultation AS in_consultation_82, u0_.interested_in AS interested_in_83, u0_.consultation_type AS consultation_type_84, u0_.google_click_id AS google_click_id_85, u0_.campaign_name AS campaign_name_86, u0_.campaign_source AS campaign_source_87, u0_.campaign_medium AS campaign_medium_88, u0_.campaign_term AS campaign_term_89, u0_.campaign_content AS campaign_content_90, u0_.marketing_source AS marketing_source_91, u0_.author AS author_92, u0_.address1 AS address1_93, u0_.address2 AS address2_94, u0_.town AS town_95, u0_.state AS state_96, u0_.country AS country_97, u0_.postcode AS postcode_98, u0_.qualification AS qualification_99, u0_.summary AS summary_100, u0_.deleted AS deleted_101, u0_.calendar_color AS calendar_color_102, u0_.calendar_order_number AS calendar_order_number_103, u0_.calendar_id AS calendar_id_104, u0_.position AS position_105, u0_.online_booking_availability AS online_booking_availability_106, u0_.title AS title_107, u0_.email_verify AS email_verify_108, u0_.hash_user_short_url AS hash_user_short_url_109, u0_.licence_number AS licence_number_110, u0_.stripe_customer_id AS stripe_customer_id_111, u0_.is_online AS is_online_112, u0_.last_call_time AS last_call_time_113, u0_.type AS type_114, u0_.media_id AS media_id_115, u0_.device_id AS device_id_116, u0_.created_by_id AS created_by_id_117, u0_.organisation_id AS organisation_id_118, u0_.current_clinic_id AS current_clinic_id_119, u0_.parent_id AS parent_id_120, u0_.active_photo_id AS active_photo_id_121, u0_.bar_code_image_id AS bar_code_image_id_122, u0_.clinic_id AS clinic_id_123, u0_.prospect_id AS prospect_id_124, u0_.clinic_id AS clinic_id_125, u0_.i_calendar_id AS i_calendar_id_126 FROM user u0_ WHERE (u0_.username = ?) AND u0_.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1
Parameters:
[
"demo"
]
|
| 3 | 24.92 ms |
SELECT l0_.id AS id_0, l0_.point_login AS point_login_1, l0_.created_at AS created_at_2, l0_.updated_at AS updated_at_3, l0_.user_id AS user_id_4 FROM login_log l0_ WHERE l0_.user_id = ? AND l0_.point_login = ? ORDER BY l0_.created_at DESC LIMIT 1
Parameters:
[ 3229 "LOGIN_WEB" ] |
| 4 | 2.44 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 2.56 ms |
UPDATE user SET last_auth_time = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2025-08-04 12:15:10" "2025-08-04 12:15:10" 3229 ] |
| 6 | 7.92 ms |
"COMMIT"
Parameters:
[] |
pgsql connection
No database queries were performed.
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\PendingCampaigns | No errors. |
| App\Entity\AdminSetting | No errors. |
| App\Entity\Person\User | No errors. |
| App\Entity\Person\Device | No errors. |
| App\Entity\Person\Admin | No errors. |
| App\Entity\Clinic\Person\ClinicUser | No errors. |
| App\Entity\Person\SuperClinicAdmin | No errors. |
| App\Entity\Person\Patient | No errors. |
| App\Entity\Media\Media | No errors. |
| App\Entity\Organisation\Organisation | No errors. |
| App\Entity\Clinic\Clinic |
|
| 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\Event | No errors. |
| App\Entity\Patient\TreatmentPlan |
|
| App\Entity\Patient\BaseInvoice | No errors. |
| App\Entity\Clinic\Stock\TreatmentClinic | No errors. |
| App\Entity\Clinic\Person\DailySchedule | No errors. |
| App\Entity\Person\LoginLog | No errors. |
| App\Entity\Clinic\PriceTier\PromoCode | No errors. |
| App\Entity\Clinic\PriceTier\PriceTier | No errors. |
| Mcfedr\QueueManagerBundle\Entity\DoctrineDelayJob | No errors. |
| App\Entity\Clinic\PriceTier\PriceTiersGroup | No errors. |
| App\Entity\AlanChat | No errors. |
| App\Entity\Clinic\NotConvertReason | No errors. |
| App\Entity\LeadCapture\LeadCaptureStage |
|
| App\Entity\Patient\TreatmentPhoto\TreatmentPhoto | No errors. |