Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

5.40 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
3.20 ms (59.31%)	1	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`] View formatted query View runnable query Explain query 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' ) 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 = 3229 AND t0.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user');
2.20 ms (40.69%)	1	select * from advertisements where FIND_IN_SET(?,receiver_user_ids) and not FIND_IN_SET(?,read_user_ids) Parameters: [`3229 3229`] View formatted query View runnable query Explain query select * from advertisements where FIND_IN_SET(?, receiver_user_ids) and not FIND_IN_SET(?, read_user_ids) select * from advertisements where FIND_IN_SET(3229,receiver_user_ids) and not FIND_IN_SET(3229,read_user_ids);

Time▼

Count

Info

3.20 ms
(59.31%)

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
]

View formatted query View runnable query Explain query

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

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 = 3229 AND t0.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user');

2.20 ms
(40.69%)

select * from advertisements where FIND_IN_SET(?,receiver_user_ids) and not FIND_IN_SET(?,read_user_ids)

Parameters:

View formatted query View runnable query Explain query

select
  *
from
  advertisements
where
  FIND_IN_SET(?, receiver_user_ids)
  and not FIND_IN_SET(?, read_user_ids)

select * from advertisements where FIND_IN_SET(3229,receiver_user_ids) and not FIND_IN_SET(3229,read_user_ids);

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	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\Event	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\BaseInvoice	No errors.
App\Entity\Clinic\Stock\TreatmentClinic	No errors.
App\Entity\Clinic\Person\DailySchedule	No errors.

Symfony Profiler

https://staging.consentz.com/admin/message/popup_unread Return to referer URL

Configuration Settings

Theme

Page Width