Query Metrics
5
Database Queries
5
Different statements
14.73 ms
Query time
3
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.91 ms |
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.otp AS otp_19, t0.otp_sent_at AS otp_sent_at_20, t0.last_otp_verified AS last_otp_verified_21, t0.imap_setting AS imap_setting_22, t0.country_code AS country_code_23, t0.phone AS phone_24, t0.practitioner_commission AS practitioner_commission_25, t0.coordinator_commission AS coordinator_commission_26, t0.course_commission AS course_commission_27, t0.membership_commission AS membership_commission_28, t0.product_commission AS product_commission_29, t0.token AS token_30, t0.access_all_calendars AS access_all_calendars_31, t0.current_auth_token AS current_auth_token_32, t0.last_auth_time AS last_auth_time_33, t0.hash AS hash_34, t0.hx_change_token AS hx_change_token_35, t0.login_from AS login_from_36, t0.ever_login_in_v3 AS ever_login_in_v3_37, t0.deleted_at AS deleted_at_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.media_id AS media_id_41, t0.device_id AS device_id_42, t0.created_by_id AS created_by_id_43, t0.type, t0.organisation_id AS organisation_id_44, t0.current_clinic_id AS current_clinic_id_45, t0.status AS status_46, t0.birthday AS birthday_47, t0.country_code_alt AS country_code_alt_48, t0.secondary_phone AS secondary_phone_49, t0.next_kin AS next_kin_50, t0.next_kin_phone AS next_kin_phone_51, t0.description AS description_52, t0.glogau_scale AS glogau_scale_53, t0.fitzpatrick_scale AS fitzpatrick_scale_54, t0.gender AS gender_55, t0.receive_special_offer_email AS receive_special_offer_email_56, t0.receive_special_offer_sms AS receive_special_offer_sms_57, t0.receive_special_offer_push AS receive_special_offer_push_58, t0.receive_reminder_email AS receive_reminder_email_59, t0.receive_reminder_sms AS receive_reminder_sms_60, t0.receive_reminder_push AS receive_reminder_push_61, t0.parent_user_id AS parent_user_id_62, t0.account_type AS account_type_63, t0.terms_accepted AS terms_accepted_64, t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_65, t0.referral AS referral_66, t0.export_in_progress AS export_in_progress_67, t0.occupation AS occupation_68, t0.number_nhs AS number_nhs_69, t0.gp_name AS gp_name_70, t0.contact_gp AS contact_gp_71, t0.gp_address1 AS gp_address1_72, t0.gp_address2 AS gp_address2_73, t0.gp_town AS gp_town_74, t0.gp_county AS gp_county_75, t0.gp_post_code AS gp_post_code_76, t0.gp_country AS gp_country_77, t0.ref AS ref_78, t0.chronoscan_code AS chronoscan_code_79, t0.ethnicity AS ethnicity_80, t0.height AS height_81, t0.weight AS weight_82, t0.passport AS passport_83, t0.reference_number AS reference_number_84, t0.photo_consent AS photo_consent_85, t0.all_marketing AS all_marketing_86, t0.in_clinic_marketing AS in_clinic_marketing_87, t0.in_consultation AS in_consultation_88, t0.interested_in AS interested_in_89, t0.consultation_type AS consultation_type_90, t0.google_click_id AS google_click_id_91, t0.campaign_name AS campaign_name_92, t0.campaign_source AS campaign_source_93, t0.campaign_medium AS campaign_medium_94, t0.campaign_term AS campaign_term_95, t0.campaign_content AS campaign_content_96, t0.marketing_source AS marketing_source_97, t0.author AS author_98, t0.address1 AS address1_99, t0.address2 AS address2_100, t0.town AS town_101, t0.state AS state_102, t0.country AS country_103, t0.postcode AS postcode_104, t0.parent_id AS parent_id_105, t0.active_photo_id AS active_photo_id_106, t0.bar_code_image_id AS bar_code_image_id_107, t0.clinic_id AS clinic_id_108, t0.prospect_id AS prospect_id_109, t0.qualification AS qualification_110, t0.summary AS summary_111, t0.deleted AS deleted_112, t0.calendar_color AS calendar_color_113, t0.calendar_order_number AS calendar_order_number_114, t0.calendar_id AS calendar_id_115, t0.position AS position_116, t0.online_booking_availability AS online_booking_availability_117, t0.title AS title_118, t0.email_verify AS email_verify_119, t0.hash_user_short_url AS hash_user_short_url_120, t0.licence_number AS licence_number_121, t0.stripe_customer_id AS stripe_customer_id_122, t0.is_online AS is_online_123, t0.last_call_time AS last_call_time_124, t0.clinic_id AS clinic_id_125, t0.i_calendar_id AS i_calendar_id_126 FROM user t0 WHERE t0.id = ? AND t0.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user')
Parameters:
[
3229
]
|
| 2 | 2.29 ms |
SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.parent_id AS parent_id_3, t0.image AS image_4, t0.title AS title_5, t0.status AS status_6, t0.body AS body_7, t0.css AS css_8, t0.data AS data_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.clinic_id AS clinic_id_12 FROM template t0 WHERE t0.id = ?
Parameters:
[
"130"
]
|
| 3 | 4.93 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_domain AS sub_domain_3, t0.organisation_id AS organisation_id_4, t0.smscredit AS smscredit_5, t0.booking_btn_name AS booking_btn_name_6, t0.booking_btn_clr AS booking_btn_clr_7, t0.booking_btn_bg_clr AS booking_btn_bg_clr_8, t0.inner_color AS inner_color_9, t0.outer_color AS outer_color_10, t0.background_img AS background_img_11, t0.profile_img AS profile_img_12, t0.meeting_price AS meeting_price_13, t0.meeting_price_type AS meeting_price_type_14, t0.show_in_public_profile AS show_in_public_profile_15, t0.patient_ref_prefix AS patient_ref_prefix_16, t0.email AS email_17, t0.verified_email AS verified_email_18, t0.web_site AS web_site_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.description AS description_22, t0.widget_settings AS widget_settings_23, t0.sms_number AS sms_number_24, t0.sms_status AS sms_status_25, t0.timezone AS timezone_26, t0.reminder_header AS reminder_header_27, t0.reminder_footer AS reminder_footer_28, t0.reminder_recall_text AS reminder_recall_text_29, t0.google_token AS google_token_30, t0.google_id AS google_id_31, t0.topic_arn AS topic_arn_32, t0.pm_pin AS pm_pin_33, t0.auto_email_reply_address AS auto_email_reply_address_34, t0.pm_patient_message AS pm_patient_message_35, t0.pm_clinic_intro AS pm_clinic_intro_36, t0.auto_renew_subscription AS auto_renew_subscription_37, t0.subscription_expiry AS subscription_expiry_38, t0.email_reminder AS email_reminder_39, t0.email_new AS email_new_40, t0.sms_new AS sms_new_41, t0.sms_reminder AS sms_reminder_42, t0.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_43, t0.calendar_start_day AS calendar_start_day_44, t0.calendar_end_day AS calendar_end_day_45, t0.appointment_default_time AS appointment_default_time_46, t0.appointment_slot_duration AS appointment_slot_duration_47, t0.appointment_default_view AS appointment_default_view_48, t0.private_mode_calendar AS private_mode_calendar_49, t0.clinic_representative AS clinic_representative_50, t0.data_protection_officer AS data_protection_officer_51, t0.company_registration_number AS company_registration_number_52, t0.email_to_withdraw AS email_to_withdraw_53, t0.period_stored_data AS period_stored_data_54, t0.survey_email_text AS survey_email_text_55, t0.post_apt_form_email_text AS post_apt_form_email_text_56, t0.export_in_progress AS export_in_progress_57, t0.vat_number AS vat_number_58, t0.enabled_vat AS enabled_vat_59, t0.stripe_refresh_token AS stripe_refresh_token_60, t0.stripe_publishable_key AS stripe_publishable_key_61, t0.stripe_account_id AS stripe_account_id_62, t0.shared_all_patients AS shared_all_patients_63, t0.currency AS currency_64, t0.patient_info_to_document_header AS patient_info_to_document_header_65, t0.t_and_c AS t_and_c_66, t0.declaration AS declaration_67, t0.treatment_plan_tand_c AS treatment_plan_tand_c_68, t0.traffic_light AS traffic_light_69, t0.booking_required_fields AS booking_required_fields_70, t0.double_booking AS double_booking_71, t0.required_confirmation AS required_confirmation_72, t0.fixed_discount_amount AS fixed_discount_amount_73, t0.required_questionnaires AS required_questionnaires_74, t0.patient_required_fields AS patient_required_fields_75, t0.prospect_required_fields AS prospect_required_fields_76, t0.enabled_postcode AS enabled_postcode_77, t0.enabled_chronoscan AS enabled_chronoscan_78, t0.postcode_api_key AS postcode_api_key_79, t0.enabled_prospect_web_form AS enabled_prospect_web_form_80, t0.payment_sense AS payment_sense_81, t0.xero_tenant_id AS xero_tenant_id_82, t0.reduce_stock AS reduce_stock_83, t0.patient_questionnaire AS patient_questionnaire_84, t0.xero_bank_account AS xero_bank_account_85, t0.is_new_clinic AS is_new_clinic_86, t0.marketing_expert AS marketing_expert_87, t0.clinic_survey_email_text AS clinic_survey_email_text_88, t0.trial_end_date AS trial_end_date_89, t0.shared_patient_date AS shared_patient_date_90, t0.feature_custom_website_amount AS feature_custom_website_amount_91, t0.feature_ad_amount AS feature_ad_amount_92, t0.feature_message_amount AS feature_message_amount_93, t0.address1 AS address1_94, t0.address2 AS address2_95, t0.town AS town_96, t0.state AS state_97, t0.country AS country_98, t0.postcode AS postcode_99, t0.created_at AS created_at_100, t0.updated_at AS updated_at_101, t0.logo_id AS logo_id_102, t103.id AS id_104, t103.s3key AS s3key_105, t103.name_file AS name_file_106, t103.url AS url_107, t103.type AS type_108, t103.created_at AS created_at_109, t103.updated_at AS updated_at_110, t0.background_id AS background_id_111, t112.id AS id_113, t112.s3key AS s3key_114, t112.name_file AS name_file_115, t112.url AS url_116, t112.type AS type_117, t112.created_at AS created_at_118, t112.updated_at AS updated_at_119, t120.id AS id_121, t120.creditor AS creditor_122, t120.mandate AS mandate_123, t120.customer AS customer_124, t120.customer_bank_account AS customer_bank_account_125, t120.created_at AS created_at_126, t120.updated_at AS updated_at_127, t120.clinic_id AS clinic_id_128, t129.id AS id_130, t129.sid AS sid_131, t129.token AS token_132, t129.number_from AS number_from_133, t129.clinic_id AS clinic_id_134, t0.organisation_id AS organisation_id_135, t136.id AS id_137, t136.enabled AS enabled_138, t136.time_required_for_booking AS time_required_for_booking_139, t136.time_required_for_cancellation AS time_required_for_cancellation_140, t136.take_payment_for_new_patients AS take_payment_for_new_patients_141, t136.take_payment_for_existing_patients AS take_payment_for_existing_patients_142, t136.type AS type_143, t136.hide_full_price AS hide_full_price_144, t136.terms AS terms_145, t136.clinic_id AS clinic_id_146, t147.id AS id_148, t147.server AS server_149, t147.file_location AS file_location_150, t147.username AS username_151, t147.password AS password_152, t147.email AS email_153, t147.clinic_id AS clinic_id_154, t155.id AS id_156, t155.theme AS theme_157, t155.max_embed_width AS max_embed_width_158, t155.primary_interface_colour AS primary_interface_colour_159, t155.secondary_interface_colour AS secondary_interface_colour_160, t155.primary_font_colour AS primary_font_colour_161, t155.secondary_font_colour AS secondary_font_colour_162, t155.background_colour AS background_colour_163, t155.widget_hash AS widget_hash_164, t155.created_at AS created_at_165, t155.updated_at AS updated_at_166, t155.clinic_id AS clinic_id_167, t155.custom_css_id AS custom_css_id_168, t169.id AS id_170, t169.confirmation_text AS confirmation_text_171, t169.treatment_info AS treatment_info_172, t169.clinic_id AS clinic_id_173, t174.id AS id_175, t174.api_key AS api_key_176, t174.list_id AS list_id_177, t174.sync AS sync_178, t174.sync_date AS sync_date_179, t174.pro AS pro_180, t174.created_at AS created_at_181, t174.updated_at AS updated_at_182, t174.clinic_id AS clinic_id_183, t0.promo_code_id AS promo_code_id_184, t0.price_tier_id AS price_tier_id_185, t0.xero_sync_job_id AS xero_sync_job_id_186 FROM clinics t0 LEFT JOIN media t103 ON t0.logo_id = t103.id LEFT JOIN media t112 ON t0.background_id = t112.id LEFT JOIN gocardless_customer t120 ON t120.clinic_id = t0.id LEFT JOIN twilio t129 ON t129.clinic_id = t0.id LEFT JOIN setting_online_booking t136 ON t136.clinic_id = t0.id LEFT JOIN setting_chronoscan t147 ON t147.clinic_id = t0.id LEFT JOIN widget_online_booking t155 ON t155.clinic_id = t0.id LEFT JOIN email_setting_online_booking t169 ON t169.clinic_id = t0.id LEFT JOIN mail_chimp_config t174 ON t174.clinic_id = t0.id WHERE t0.id = ?
Parameters:
[
3
]
|
| 4 | 2.24 ms |
SELECT t0.id AS id_1, t0.s3key AS s3key_2, t0.name_file AS name_file_3, t0.url AS url_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM media t0 WHERE t0.id IN (?)
Parameters:
[
[
109932
]
]
|
| 5 | 2.37 ms |
SELECT t0_.id AS id_0, t0_.category_id AS category_id_1, t0_.parent_id AS parent_id_2, t0_.image AS image_3, t0_.title AS title_4, t0_.status AS status_5, t0_.body AS body_6, t0_.css AS css_7, t0_.data AS data_8, t0_.updated_at AS updated_at_9, t0_.created_at AS created_at_10, t0_.clinic_id AS clinic_id_11 FROM template t0_ WHERE t0_.id = ? OR t0_.parent_id = ?
Parameters:
[ 130 130 ] |
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\Media\Media | 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\Organisation\Organisation | No errors. |
| App\Entity\Clinic\Clinic |
|
| 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\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\Template | No errors. |
| App\Entity\Clinic\GocardlessCustomer | No errors. |
| App\Entity\Clinic\Twilio | No errors. |
| App\Entity\Clinic\OnlineBooking\Settings | No errors. |
| App\Entity\Clinic\Chronoscan\Settings | No errors. |
| App\Entity\Clinic\OnlineBooking\Widget | No errors. |
| App\Entity\Clinic\OnlineBooking\EmailSettings | No errors. |
| App\Entity\Clinic\MailChimp\MailChimpConfig | No errors. |
| App\Entity\Clinic\PriceTier\PromoCode | No errors. |
| App\Entity\Clinic\PriceTier\PriceTier | No errors. |
| Mcfedr\QueueManagerBundle\Entity\DoctrineDelayJob | No errors. |
| App\Entity\AppointmentLead | No errors. |
| App\Entity\ReminderTask | No errors. |
| App\Entity\Clinic\Equipment | No errors. |
| App\Entity\Clinic\Reminder | No errors. |
| App\Entity\Clinic\ReminderRecall | No errors. |
| App\Entity\Clinic\License | No errors. |
| App\Entity\Clinic\WebhookEvent | No errors. |
| App\Entity\Clinic\Room | No errors. |
| App\Entity\Clinic\Stock\TreatmentGroup | No errors. |
| App\Entity\Clinic\Stock\PriceList | No errors. |
| App\Entity\Clinic\Stock\Product | No errors. |
| App\Entity\Clinic\Marketing | No errors. |
| App\Entity\Clinic\FormFile | No errors. |
| App\Entity\SmsSetting | No errors. |
| App\Entity\Clinic\DocumentCategory | No errors. |
| App\Entity\Clinic\BlockerReason | No errors. |
| App\Entity\Clinic\DiscountReason | No errors. |
| App\Entity\Waiting\Item | No errors. |
| App\Entity\Clinic\Questionaire\Questionaire | No errors. |
| App\Entity\Clinic\Stock\GoodsReceived | No errors. |
| App\Entity\Clinic\Export\ExportData | No errors. |
| App\Entity\Clinic\Outcome | No errors. |
| App\Entity\Clinic\PatientStatus\PatientStatus | No errors. |
| App\Entity\Clinic\LearnAboutSource | No errors. |
| App\Entity\Clinic\PriceTier\Addon | No errors. |
| App\Entity\Clinic\Location | No errors. |
| App\Entity\Clinic\Appointment\AppointmentCode | No errors. |
| App\Entity\LeadCapture\LeadCaptureStage |
|
| App\Entity\Clinic\Membership\Membership | No errors. |
| App\Entity\Clinic\Filter | No errors. |