Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

4 Different statements

0.94 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

common connection

Time▼	Count	Info
0.14 ms (15.49%)	1	SELECT t0.id AS id_1, t0.login AS login_2, t0.secret_key AS secret_key_3, t0.status AS status_4, t0.sso_user_creation_allowed AS sso_user_creation_allowed_5, t0.public_host AS public_host_6, t0.secure_host AS secure_host_7, t0.super_admin_host AS super_admin_host_8, t0.default_user_email AS default_user_email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM `company` t0 WHERE t0.login = ? LIMIT 1 Parameters: [`"simplymeet"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.login AS login_2, t0.secret_key AS secret_key_3, t0.status AS status_4, t0.sso_user_creation_allowed AS sso_user_creation_allowed_5, t0.public_host AS public_host_6, t0.secure_host AS secure_host_7, t0.super_admin_host AS super_admin_host_8, t0.default_user_email AS default_user_email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM `company` t0 WHERE t0.login = ? LIMIT 1 SELECT t0.id AS id_1, t0.login AS login_2, t0.secret_key AS secret_key_3, t0.status AS status_4, t0.sso_user_creation_allowed AS sso_user_creation_allowed_5, t0.public_host AS public_host_6, t0.secure_host AS secure_host_7, t0.super_admin_host AS super_admin_host_8, t0.default_user_email AS default_user_email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM `company` t0 WHERE t0.login = 'simplymeet' LIMIT 1;

Time▼

Count

Info

0.14 ms
(15.49%)

SELECT t0.id AS id_1, t0.login AS login_2, t0.secret_key AS secret_key_3, t0.status AS status_4, t0.sso_user_creation_allowed AS sso_user_creation_allowed_5, t0.public_host AS public_host_6, t0.secure_host AS secure_host_7, t0.super_admin_host AS super_admin_host_8, t0.default_user_email AS default_user_email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM `company` t0 WHERE t0.login = ? LIMIT 1

Parameters:

[
  "simplymeet"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.login AS login_2,
  t0.secret_key AS secret_key_3,
  t0.status AS status_4,
  t0.sso_user_creation_allowed AS sso_user_creation_allowed_5,
  t0.public_host AS public_host_6,
  t0.secure_host AS secure_host_7,
  t0.super_admin_host AS super_admin_host_8,
  t0.default_user_email AS default_user_email_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11
FROM
  `company` t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.login AS login_2, t0.secret_key AS secret_key_3, t0.status AS status_4, t0.sso_user_creation_allowed AS sso_user_creation_allowed_5, t0.public_host AS public_host_6, t0.secure_host AS secure_host_7, t0.super_admin_host AS super_admin_host_8, t0.default_user_email AS default_user_email_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM `company` t0 WHERE t0.login = 'simplymeet' LIMIT 1;

company connection

Time▼	Count	Info
0.41 ms (43.38%)	1	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.full_name AS full_name_15, t0.intro AS intro_16, t0.default_message AS default_message_17, t0.slug AS slug_18, t0.timezone AS timezone_19, t0.locale AS locale_20, t0.avatar_name AS avatar_name_21, t0.avatar_size AS avatar_size_22, t0.branding_enabled AS branding_enabled_23, t0.is_proxy_enabled AS is_proxy_enabled_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.domain AS domain_27, t0.uuid AS uuid_28, t0.sender AS sender_29, t0.company_logo_name AS company_logo_name_30, t0.company_logo_size AS company_logo_size_31, t0.banner_name AS banner_name_32, t0.banner_size AS banner_size_33, t0.time_format AS time_format_34, t0.date_format AS date_format_35, t0.client_time_format AS client_time_format_36, t0.address AS address_37, t0.state AS state_38, t0.zip AS zip_39, t0.city AS city_40, t0.country_id AS country_id_41, t0.lat AS lat_42, t0.lng AS lng_43, t0.other_category AS other_category_44, t0.last_two_factor_code AS last_two_factor_code_45, t0.show_address_in_email AS show_address_in_email_46, t0.calendar_layout AS calendar_layout_47, t0.hide_unavailable_dates AS hide_unavailable_dates_48, t0.sunday_is_first_day AS sunday_is_first_day_49, t0.rtl AS rtl_50, t0.require_set_password AS require_set_password_51, t0.require_confirm_email AS require_confirm_email_52, t0.daylite_id AS daylite_id_53, t0.phone_number AS phone_number_54, t0.consent AS consent_55, t0.referral AS referral_56, t0.verification_code AS verification_code_57, t0.ada AS ada_58, t0.allow_login_as_user AS allow_login_as_user_59, t0.welcome_tour_step AS welcome_tour_step_60, t0.second_factor_skipped AS second_factor_skipped_61, t0.tutorial_skipped AS tutorial_skipped_62, t0.onboarding_skipped AS onboarding_skipped_63, t0.affiliate AS affiliate_64, t65.id AS id_66, t65.facebook_url AS facebook_url_67, t65.twitter_url AS twitter_url_68, t65.instagram_url AS instagram_url_69, t65.linkedin_url AS linkedin_url_70, t65.whatsapp_url AS whatsapp_url_71, t65.user_id AS user_id_72, t73.id AS id_74, t73.string_value AS string_value_75, t73.user_id AS user_id_76, t77.id AS id_78, t77.code AS code_79, t77.email AS email_80, t77.create_datetime AS create_datetime_81, t77.used_datetime AS used_datetime_82, t77.user_id AS user_id_83, t77.subscription_id AS subscription_id_84, t85.id AS id_86, t85.enabled AS enabled_87, t85.`period` AS period_88, t85.label AS label_89, t85.text AS text_90, t85.version AS version_91, t85.user_id AS user_id_92, t93.id AS id_94, t93.`config` AS config_95, t93.user_id AS user_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.user_id AS user_id_100, t101.id AS id_102, t101.rate AS rate_103, t101.review AS review_104, t101.user_id AS user_id_105, t106.id AS id_107, t106.`login_type` AS login_type_108, t106.user_id AS user_id_109, t110.id AS id_111, t110.config AS config_112, t110.user_id AS user_id_113, t114.id AS id_115, t114.calendar_event_name_type AS calendar_event_name_type_116, t114.default_daily_meeting_limit AS default_daily_meeting_limit_117, t114.custom_booking_css AS custom_booking_css_118, t114.user_id AS user_id_119, t0.subscription_id AS subscription_id_120 FROM hly_user t0 LEFT JOIN `hly_user_social_link` t65 ON t65.user_id = t0.id LEFT JOIN `hly_user_google_authenticator` t73 ON t73.user_id = t0.id LEFT JOIN hly_migration_subscription t77 ON t77.user_id = t0.id LEFT JOIN hly_user_cancellation_policy t85 ON t85.user_id = t0.id LEFT JOIN hly_user_widget t93 ON t93.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t97 ON t97.user_id = t0.id LEFT JOIN hly_review t101 ON t101.user_id = t0.id LEFT JOIN hly_user_sso t106 ON t106.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t110 ON t110.user_id = t0.id LEFT JOIN hly_user_preferences t114 ON t114.user_id = t0.id WHERE t0.domain = ? LIMIT 1 Parameters: [`"super-admin.test.d.simplybook.ovh"`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.full_name AS full_name_15, t0.intro AS intro_16, t0.default_message AS default_message_17, t0.slug AS slug_18, t0.timezone AS timezone_19, t0.locale AS locale_20, t0.avatar_name AS avatar_name_21, t0.avatar_size AS avatar_size_22, t0.branding_enabled AS branding_enabled_23, t0.is_proxy_enabled AS is_proxy_enabled_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.domain AS domain_27, t0.uuid AS uuid_28, t0.sender AS sender_29, t0.company_logo_name AS company_logo_name_30, t0.company_logo_size AS company_logo_size_31, t0.banner_name AS banner_name_32, t0.banner_size AS banner_size_33, t0.time_format AS time_format_34, t0.date_format AS date_format_35, t0.client_time_format AS client_time_format_36, t0.address AS address_37, t0.state AS state_38, t0.zip AS zip_39, t0.city AS city_40, t0.country_id AS country_id_41, t0.lat AS lat_42, t0.lng AS lng_43, t0.other_category AS other_category_44, t0.last_two_factor_code AS last_two_factor_code_45, t0.show_address_in_email AS show_address_in_email_46, t0.calendar_layout AS calendar_layout_47, t0.hide_unavailable_dates AS hide_unavailable_dates_48, t0.sunday_is_first_day AS sunday_is_first_day_49, t0.rtl AS rtl_50, t0.require_set_password AS require_set_password_51, t0.require_confirm_email AS require_confirm_email_52, t0.daylite_id AS daylite_id_53, t0.phone_number AS phone_number_54, t0.consent AS consent_55, t0.referral AS referral_56, t0.verification_code AS verification_code_57, t0.ada AS ada_58, t0.allow_login_as_user AS allow_login_as_user_59, t0.welcome_tour_step AS welcome_tour_step_60, t0.second_factor_skipped AS second_factor_skipped_61, t0.tutorial_skipped AS tutorial_skipped_62, t0.onboarding_skipped AS onboarding_skipped_63, t0.affiliate AS affiliate_64, t65.id AS id_66, t65.facebook_url AS facebook_url_67, t65.twitter_url AS twitter_url_68, t65.instagram_url AS instagram_url_69, t65.linkedin_url AS linkedin_url_70, t65.whatsapp_url AS whatsapp_url_71, t65.user_id AS user_id_72, t73.id AS id_74, t73.string_value AS string_value_75, t73.user_id AS user_id_76, t77.id AS id_78, t77.code AS code_79, t77.email AS email_80, t77.create_datetime AS create_datetime_81, t77.used_datetime AS used_datetime_82, t77.user_id AS user_id_83, t77.subscription_id AS subscription_id_84, t85.id AS id_86, t85.enabled AS enabled_87, t85.`period` AS period_88, t85.label AS label_89, t85.text AS text_90, t85.version AS version_91, t85.user_id AS user_id_92, t93.id AS id_94, t93.`config` AS config_95, t93.user_id AS user_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.user_id AS user_id_100, t101.id AS id_102, t101.rate AS rate_103, t101.review AS review_104, t101.user_id AS user_id_105, t106.id AS id_107, t106.`login_type` AS login_type_108, t106.user_id AS user_id_109, t110.id AS id_111, t110.config AS config_112, t110.user_id AS user_id_113, t114.id AS id_115, t114.calendar_event_name_type AS calendar_event_name_type_116, t114.default_daily_meeting_limit AS default_daily_meeting_limit_117, t114.custom_booking_css AS custom_booking_css_118, t114.user_id AS user_id_119, t0.subscription_id AS subscription_id_120 FROM hly_user t0 LEFT JOIN `hly_user_social_link` t65 ON t65.user_id = t0.id LEFT JOIN `hly_user_google_authenticator` t73 ON t73.user_id = t0.id LEFT JOIN hly_migration_subscription t77 ON t77.user_id = t0.id LEFT JOIN hly_user_cancellation_policy t85 ON t85.user_id = t0.id LEFT JOIN hly_user_widget t93 ON t93.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t97 ON t97.user_id = t0.id LEFT JOIN hly_review t101 ON t101.user_id = t0.id LEFT JOIN hly_user_sso t106 ON t106.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t110 ON t110.user_id = t0.id LEFT JOIN hly_user_preferences t114 ON t114.user_id = t0.id WHERE t0.domain = ? LIMIT 1 SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.full_name AS full_name_15, t0.intro AS intro_16, t0.default_message AS default_message_17, t0.slug AS slug_18, t0.timezone AS timezone_19, t0.locale AS locale_20, t0.avatar_name AS avatar_name_21, t0.avatar_size AS avatar_size_22, t0.branding_enabled AS branding_enabled_23, t0.is_proxy_enabled AS is_proxy_enabled_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.domain AS domain_27, t0.uuid AS uuid_28, t0.sender AS sender_29, t0.company_logo_name AS company_logo_name_30, t0.company_logo_size AS company_logo_size_31, t0.banner_name AS banner_name_32, t0.banner_size AS banner_size_33, t0.time_format AS time_format_34, t0.date_format AS date_format_35, t0.client_time_format AS client_time_format_36, t0.address AS address_37, t0.state AS state_38, t0.zip AS zip_39, t0.city AS city_40, t0.country_id AS country_id_41, t0.lat AS lat_42, t0.lng AS lng_43, t0.other_category AS other_category_44, t0.last_two_factor_code AS last_two_factor_code_45, t0.show_address_in_email AS show_address_in_email_46, t0.calendar_layout AS calendar_layout_47, t0.hide_unavailable_dates AS hide_unavailable_dates_48, t0.sunday_is_first_day AS sunday_is_first_day_49, t0.rtl AS rtl_50, t0.require_set_password AS require_set_password_51, t0.require_confirm_email AS require_confirm_email_52, t0.daylite_id AS daylite_id_53, t0.phone_number AS phone_number_54, t0.consent AS consent_55, t0.referral AS referral_56, t0.verification_code AS verification_code_57, t0.ada AS ada_58, t0.allow_login_as_user AS allow_login_as_user_59, t0.welcome_tour_step AS welcome_tour_step_60, t0.second_factor_skipped AS second_factor_skipped_61, t0.tutorial_skipped AS tutorial_skipped_62, t0.onboarding_skipped AS onboarding_skipped_63, t0.affiliate AS affiliate_64, t65.id AS id_66, t65.facebook_url AS facebook_url_67, t65.twitter_url AS twitter_url_68, t65.instagram_url AS instagram_url_69, t65.linkedin_url AS linkedin_url_70, t65.whatsapp_url AS whatsapp_url_71, t65.user_id AS user_id_72, t73.id AS id_74, t73.string_value AS string_value_75, t73.user_id AS user_id_76, t77.id AS id_78, t77.code AS code_79, t77.email AS email_80, t77.create_datetime AS create_datetime_81, t77.used_datetime AS used_datetime_82, t77.user_id AS user_id_83, t77.subscription_id AS subscription_id_84, t85.id AS id_86, t85.enabled AS enabled_87, t85.`period` AS period_88, t85.label AS label_89, t85.text AS text_90, t85.version AS version_91, t85.user_id AS user_id_92, t93.id AS id_94, t93.`config` AS config_95, t93.user_id AS user_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.user_id AS user_id_100, t101.id AS id_102, t101.rate AS rate_103, t101.review AS review_104, t101.user_id AS user_id_105, t106.id AS id_107, t106.`login_type` AS login_type_108, t106.user_id AS user_id_109, t110.id AS id_111, t110.config AS config_112, t110.user_id AS user_id_113, t114.id AS id_115, t114.calendar_event_name_type AS calendar_event_name_type_116, t114.default_daily_meeting_limit AS default_daily_meeting_limit_117, t114.custom_booking_css AS custom_booking_css_118, t114.user_id AS user_id_119, t0.subscription_id AS subscription_id_120 FROM hly_user t0 LEFT JOIN `hly_user_social_link` t65 ON t65.user_id = t0.id LEFT JOIN `hly_user_google_authenticator` t73 ON t73.user_id = t0.id LEFT JOIN hly_migration_subscription t77 ON t77.user_id = t0.id LEFT JOIN hly_user_cancellation_policy t85 ON t85.user_id = t0.id LEFT JOIN hly_user_widget t93 ON t93.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t97 ON t97.user_id = t0.id LEFT JOIN hly_review t101 ON t101.user_id = t0.id LEFT JOIN hly_user_sso t106 ON t106.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t110 ON t110.user_id = t0.id LEFT JOIN hly_user_preferences t114 ON t114.user_id = t0.id WHERE t0.domain = 'super-admin.test.d.simplybook.ovh' LIMIT 1;
0.35 ms (36.96%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.uuid AS uuid_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.avatar_name AS avatar_name_7, t0.avatar_size AS avatar_size_8, t0.banner_name AS banner_name_9, t0.banner_size AS banner_size_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.domain AS domain_13, t0.calendar_layout AS calendar_layout_14, t0.hide_unavailable_dates AS hide_unavailable_dates_15, t0.sunday_is_first_day AS sunday_is_first_day_16, t0.rtl AS rtl_17, t0.email AS email_18, t0.overwrite_personal_domain AS overwrite_personal_domain_19, t0.overwrite_personal_appearance AS overwrite_personal_appearance_20, t0.ada AS ada_21, t0.allow_login_as_user AS allow_login_as_user_22, t23.id AS id_24, t23.facebook_url AS facebook_url_25, t23.twitter_url AS twitter_url_26, t23.instagram_url AS instagram_url_27, t23.linkedin_url AS linkedin_url_28, t23.whatsapp_url AS whatsapp_url_29, t23.organization_id AS organization_id_30, t31.id AS id_32, t31.config AS config_33, t31.organization_id AS organization_id_34, t35.id AS id_36, t35.uuid AS uuid_37, t35.custom_booking_css AS custom_booking_css_38, t35.organization_id AS organization_id_39, t40.overwrite_personal AS overwrite_personal_41, t40.id AS id_42, t40.enabled AS enabled_43, t40.`period` AS period_44, t40.label AS label_45, t40.text AS text_46, t40.version AS version_47, t40.organization_id AS organization_id_48, t49.id AS id_50, t49.`config` AS config_51, t49.organization_id AS organization_id_52 FROM hly_organization t0 LEFT JOIN `hly_organization_social_link` t23 ON t23.organization_id = t0.id LEFT JOIN hly_organization_scheduling_page_appearance t31 ON t31.organization_id = t0.id LEFT JOIN hly_organization_preferences t35 ON t35.organization_id = t0.id LEFT JOIN hly_organization_cancellation_policy t40 ON t40.organization_id = t0.id LEFT JOIN hly_organization_widget t49 ON t49.organization_id = t0.id WHERE t0.domain = ? LIMIT 1 Parameters: [`"super-admin.test.d.simplybook.ovh"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.uuid AS uuid_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.avatar_name AS avatar_name_7, t0.avatar_size AS avatar_size_8, t0.banner_name AS banner_name_9, t0.banner_size AS banner_size_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.domain AS domain_13, t0.calendar_layout AS calendar_layout_14, t0.hide_unavailable_dates AS hide_unavailable_dates_15, t0.sunday_is_first_day AS sunday_is_first_day_16, t0.rtl AS rtl_17, t0.email AS email_18, t0.overwrite_personal_domain AS overwrite_personal_domain_19, t0.overwrite_personal_appearance AS overwrite_personal_appearance_20, t0.ada AS ada_21, t0.allow_login_as_user AS allow_login_as_user_22, t23.id AS id_24, t23.facebook_url AS facebook_url_25, t23.twitter_url AS twitter_url_26, t23.instagram_url AS instagram_url_27, t23.linkedin_url AS linkedin_url_28, t23.whatsapp_url AS whatsapp_url_29, t23.organization_id AS organization_id_30, t31.id AS id_32, t31.config AS config_33, t31.organization_id AS organization_id_34, t35.id AS id_36, t35.uuid AS uuid_37, t35.custom_booking_css AS custom_booking_css_38, t35.organization_id AS organization_id_39, t40.overwrite_personal AS overwrite_personal_41, t40.id AS id_42, t40.enabled AS enabled_43, t40.`period` AS period_44, t40.label AS label_45, t40.text AS text_46, t40.version AS version_47, t40.organization_id AS organization_id_48, t49.id AS id_50, t49.`config` AS config_51, t49.organization_id AS organization_id_52 FROM hly_organization t0 LEFT JOIN `hly_organization_social_link` t23 ON t23.organization_id = t0.id LEFT JOIN hly_organization_scheduling_page_appearance t31 ON t31.organization_id = t0.id LEFT JOIN hly_organization_preferences t35 ON t35.organization_id = t0.id LEFT JOIN hly_organization_cancellation_policy t40 ON t40.organization_id = t0.id LEFT JOIN hly_organization_widget t49 ON t49.organization_id = t0.id WHERE t0.domain = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.uuid AS uuid_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.avatar_name AS avatar_name_7, t0.avatar_size AS avatar_size_8, t0.banner_name AS banner_name_9, t0.banner_size AS banner_size_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.domain AS domain_13, t0.calendar_layout AS calendar_layout_14, t0.hide_unavailable_dates AS hide_unavailable_dates_15, t0.sunday_is_first_day AS sunday_is_first_day_16, t0.rtl AS rtl_17, t0.email AS email_18, t0.overwrite_personal_domain AS overwrite_personal_domain_19, t0.overwrite_personal_appearance AS overwrite_personal_appearance_20, t0.ada AS ada_21, t0.allow_login_as_user AS allow_login_as_user_22, t23.id AS id_24, t23.facebook_url AS facebook_url_25, t23.twitter_url AS twitter_url_26, t23.instagram_url AS instagram_url_27, t23.linkedin_url AS linkedin_url_28, t23.whatsapp_url AS whatsapp_url_29, t23.organization_id AS organization_id_30, t31.id AS id_32, t31.config AS config_33, t31.organization_id AS organization_id_34, t35.id AS id_36, t35.uuid AS uuid_37, t35.custom_booking_css AS custom_booking_css_38, t35.organization_id AS organization_id_39, t40.overwrite_personal AS overwrite_personal_41, t40.id AS id_42, t40.enabled AS enabled_43, t40.`period` AS period_44, t40.label AS label_45, t40.text AS text_46, t40.version AS version_47, t40.organization_id AS organization_id_48, t49.id AS id_50, t49.`config` AS config_51, t49.organization_id AS organization_id_52 FROM hly_organization t0 LEFT JOIN `hly_organization_social_link` t23 ON t23.organization_id = t0.id LEFT JOIN hly_organization_scheduling_page_appearance t31 ON t31.organization_id = t0.id LEFT JOIN hly_organization_preferences t35 ON t35.organization_id = t0.id LEFT JOIN hly_organization_cancellation_policy t40 ON t40.organization_id = t0.id LEFT JOIN hly_organization_widget t49 ON t49.organization_id = t0.id WHERE t0.domain = 'super-admin.test.d.simplybook.ovh' LIMIT 1;
0.04 ms (4.18%)	1	USE dimka_harmonizely Parameters: [] View formatted query View runnable query Explain query USE dimka_harmonizely USE dimka_harmonizely;

Time▼

Count

Info

0.41 ms
(43.38%)

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.full_name AS full_name_15, t0.intro AS intro_16, t0.default_message AS default_message_17, t0.slug AS slug_18, t0.timezone AS timezone_19, t0.locale AS locale_20, t0.avatar_name AS avatar_name_21, t0.avatar_size AS avatar_size_22, t0.branding_enabled AS branding_enabled_23, t0.is_proxy_enabled AS is_proxy_enabled_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.domain AS domain_27, t0.uuid AS uuid_28, t0.sender AS sender_29, t0.company_logo_name AS company_logo_name_30, t0.company_logo_size AS company_logo_size_31, t0.banner_name AS banner_name_32, t0.banner_size AS banner_size_33, t0.time_format AS time_format_34, t0.date_format AS date_format_35, t0.client_time_format AS client_time_format_36, t0.address AS address_37, t0.state AS state_38, t0.zip AS zip_39, t0.city AS city_40, t0.country_id AS country_id_41, t0.lat AS lat_42, t0.lng AS lng_43, t0.other_category AS other_category_44, t0.last_two_factor_code AS last_two_factor_code_45, t0.show_address_in_email AS show_address_in_email_46, t0.calendar_layout AS calendar_layout_47, t0.hide_unavailable_dates AS hide_unavailable_dates_48, t0.sunday_is_first_day AS sunday_is_first_day_49, t0.rtl AS rtl_50, t0.require_set_password AS require_set_password_51, t0.require_confirm_email AS require_confirm_email_52, t0.daylite_id AS daylite_id_53, t0.phone_number AS phone_number_54, t0.consent AS consent_55, t0.referral AS referral_56, t0.verification_code AS verification_code_57, t0.ada AS ada_58, t0.allow_login_as_user AS allow_login_as_user_59, t0.welcome_tour_step AS welcome_tour_step_60, t0.second_factor_skipped AS second_factor_skipped_61, t0.tutorial_skipped AS tutorial_skipped_62, t0.onboarding_skipped AS onboarding_skipped_63, t0.affiliate AS affiliate_64, t65.id AS id_66, t65.facebook_url AS facebook_url_67, t65.twitter_url AS twitter_url_68, t65.instagram_url AS instagram_url_69, t65.linkedin_url AS linkedin_url_70, t65.whatsapp_url AS whatsapp_url_71, t65.user_id AS user_id_72, t73.id AS id_74, t73.string_value AS string_value_75, t73.user_id AS user_id_76, t77.id AS id_78, t77.code AS code_79, t77.email AS email_80, t77.create_datetime AS create_datetime_81, t77.used_datetime AS used_datetime_82, t77.user_id AS user_id_83, t77.subscription_id AS subscription_id_84, t85.id AS id_86, t85.enabled AS enabled_87, t85.`period` AS period_88, t85.label AS label_89, t85.text AS text_90, t85.version AS version_91, t85.user_id AS user_id_92, t93.id AS id_94, t93.`config` AS config_95, t93.user_id AS user_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.user_id AS user_id_100, t101.id AS id_102, t101.rate AS rate_103, t101.review AS review_104, t101.user_id AS user_id_105, t106.id AS id_107, t106.`login_type` AS login_type_108, t106.user_id AS user_id_109, t110.id AS id_111, t110.config AS config_112, t110.user_id AS user_id_113, t114.id AS id_115, t114.calendar_event_name_type AS calendar_event_name_type_116, t114.default_daily_meeting_limit AS default_daily_meeting_limit_117, t114.custom_booking_css AS custom_booking_css_118, t114.user_id AS user_id_119, t0.subscription_id AS subscription_id_120 FROM hly_user t0 LEFT JOIN `hly_user_social_link` t65 ON t65.user_id = t0.id LEFT JOIN `hly_user_google_authenticator` t73 ON t73.user_id = t0.id LEFT JOIN hly_migration_subscription t77 ON t77.user_id = t0.id LEFT JOIN hly_user_cancellation_policy t85 ON t85.user_id = t0.id LEFT JOIN hly_user_widget t93 ON t93.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t97 ON t97.user_id = t0.id LEFT JOIN hly_review t101 ON t101.user_id = t0.id LEFT JOIN hly_user_sso t106 ON t106.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t110 ON t110.user_id = t0.id LEFT JOIN hly_user_preferences t114 ON t114.user_id = t0.id WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "super-admin.test.d.simplybook.ovh"
]

View formatted query View runnable query Explain query

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.first_name AS first_name_13,
  t0.last_name AS last_name_14,
  t0.full_name AS full_name_15,
  t0.intro AS intro_16,
  t0.default_message AS default_message_17,
  t0.slug AS slug_18,
  t0.timezone AS timezone_19,
  t0.locale AS locale_20,
  t0.avatar_name AS avatar_name_21,
  t0.avatar_size AS avatar_size_22,
  t0.branding_enabled AS branding_enabled_23,
  t0.is_proxy_enabled AS is_proxy_enabled_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.domain AS domain_27,
  t0.uuid AS uuid_28,
  t0.sender AS sender_29,
  t0.company_logo_name AS company_logo_name_30,
  t0.company_logo_size AS company_logo_size_31,
  t0.banner_name AS banner_name_32,
  t0.banner_size AS banner_size_33,
  t0.time_format AS time_format_34,
  t0.date_format AS date_format_35,
  t0.client_time_format AS client_time_format_36,
  t0.address AS address_37,
  t0.state AS state_38,
  t0.zip AS zip_39,
  t0.city AS city_40,
  t0.country_id AS country_id_41,
  t0.lat AS lat_42,
  t0.lng AS lng_43,
  t0.other_category AS other_category_44,
  t0.last_two_factor_code AS last_two_factor_code_45,
  t0.show_address_in_email AS show_address_in_email_46,
  t0.calendar_layout AS calendar_layout_47,
  t0.hide_unavailable_dates AS hide_unavailable_dates_48,
  t0.sunday_is_first_day AS sunday_is_first_day_49,
  t0.rtl AS rtl_50,
  t0.require_set_password AS require_set_password_51,
  t0.require_confirm_email AS require_confirm_email_52,
  t0.daylite_id AS daylite_id_53,
  t0.phone_number AS phone_number_54,
  t0.consent AS consent_55,
  t0.referral AS referral_56,
  t0.verification_code AS verification_code_57,
  t0.ada AS ada_58,
  t0.allow_login_as_user AS allow_login_as_user_59,
  t0.welcome_tour_step AS welcome_tour_step_60,
  t0.second_factor_skipped AS second_factor_skipped_61,
  t0.tutorial_skipped AS tutorial_skipped_62,
  t0.onboarding_skipped AS onboarding_skipped_63,
  t0.affiliate AS affiliate_64,
  t65.id AS id_66,
  t65.facebook_url AS facebook_url_67,
  t65.twitter_url AS twitter_url_68,
  t65.instagram_url AS instagram_url_69,
  t65.linkedin_url AS linkedin_url_70,
  t65.whatsapp_url AS whatsapp_url_71,
  t65.user_id AS user_id_72,
  t73.id AS id_74,
  t73.string_value AS string_value_75,
  t73.user_id AS user_id_76,
  t77.id AS id_78,
  t77.code AS code_79,
  t77.email AS email_80,
  t77.create_datetime AS create_datetime_81,
  t77.used_datetime AS used_datetime_82,
  t77.user_id AS user_id_83,
  t77.subscription_id AS subscription_id_84,
  t85.id AS id_86,
  t85.enabled AS enabled_87,
  t85.`period` AS period_88,
  t85.label AS label_89,
  t85.text AS text_90,
  t85.version AS version_91,
  t85.user_id AS user_id_92,
  t93.id AS id_94,
  t93.`config` AS config_95,
  t93.user_id AS user_id_96,
  t97.id AS id_98,
  t97.created_at AS created_at_99,
  t97.user_id AS user_id_100,
  t101.id AS id_102,
  t101.rate AS rate_103,
  t101.review AS review_104,
  t101.user_id AS user_id_105,
  t106.id AS id_107,
  t106.`login_type` AS login_type_108,
  t106.user_id AS user_id_109,
  t110.id AS id_111,
  t110.config AS config_112,
  t110.user_id AS user_id_113,
  t114.id AS id_115,
  t114.calendar_event_name_type AS calendar_event_name_type_116,
  t114.default_daily_meeting_limit AS default_daily_meeting_limit_117,
  t114.custom_booking_css AS custom_booking_css_118,
  t114.user_id AS user_id_119,
  t0.subscription_id AS subscription_id_120
FROM
  hly_user t0
  LEFT JOIN `hly_user_social_link` t65 ON t65.user_id = t0.id
  LEFT JOIN `hly_user_google_authenticator` t73 ON t73.user_id = t0.id
  LEFT JOIN hly_migration_subscription t77 ON t77.user_id = t0.id
  LEFT JOIN hly_user_cancellation_policy t85 ON t85.user_id = t0.id
  LEFT JOIN hly_user_widget t93 ON t93.user_id = t0.id
  LEFT JOIN `hly_user_email_unsubscribe` t97 ON t97.user_id = t0.id
  LEFT JOIN hly_review t101 ON t101.user_id = t0.id
  LEFT JOIN hly_user_sso t106 ON t106.user_id = t0.id
  LEFT JOIN hly_user_scheduling_page_appearance t110 ON t110.user_id = t0.id
  LEFT JOIN hly_user_preferences t114 ON t114.user_id = t0.id
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.full_name AS full_name_15, t0.intro AS intro_16, t0.default_message AS default_message_17, t0.slug AS slug_18, t0.timezone AS timezone_19, t0.locale AS locale_20, t0.avatar_name AS avatar_name_21, t0.avatar_size AS avatar_size_22, t0.branding_enabled AS branding_enabled_23, t0.is_proxy_enabled AS is_proxy_enabled_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.domain AS domain_27, t0.uuid AS uuid_28, t0.sender AS sender_29, t0.company_logo_name AS company_logo_name_30, t0.company_logo_size AS company_logo_size_31, t0.banner_name AS banner_name_32, t0.banner_size AS banner_size_33, t0.time_format AS time_format_34, t0.date_format AS date_format_35, t0.client_time_format AS client_time_format_36, t0.address AS address_37, t0.state AS state_38, t0.zip AS zip_39, t0.city AS city_40, t0.country_id AS country_id_41, t0.lat AS lat_42, t0.lng AS lng_43, t0.other_category AS other_category_44, t0.last_two_factor_code AS last_two_factor_code_45, t0.show_address_in_email AS show_address_in_email_46, t0.calendar_layout AS calendar_layout_47, t0.hide_unavailable_dates AS hide_unavailable_dates_48, t0.sunday_is_first_day AS sunday_is_first_day_49, t0.rtl AS rtl_50, t0.require_set_password AS require_set_password_51, t0.require_confirm_email AS require_confirm_email_52, t0.daylite_id AS daylite_id_53, t0.phone_number AS phone_number_54, t0.consent AS consent_55, t0.referral AS referral_56, t0.verification_code AS verification_code_57, t0.ada AS ada_58, t0.allow_login_as_user AS allow_login_as_user_59, t0.welcome_tour_step AS welcome_tour_step_60, t0.second_factor_skipped AS second_factor_skipped_61, t0.tutorial_skipped AS tutorial_skipped_62, t0.onboarding_skipped AS onboarding_skipped_63, t0.affiliate AS affiliate_64, t65.id AS id_66, t65.facebook_url AS facebook_url_67, t65.twitter_url AS twitter_url_68, t65.instagram_url AS instagram_url_69, t65.linkedin_url AS linkedin_url_70, t65.whatsapp_url AS whatsapp_url_71, t65.user_id AS user_id_72, t73.id AS id_74, t73.string_value AS string_value_75, t73.user_id AS user_id_76, t77.id AS id_78, t77.code AS code_79, t77.email AS email_80, t77.create_datetime AS create_datetime_81, t77.used_datetime AS used_datetime_82, t77.user_id AS user_id_83, t77.subscription_id AS subscription_id_84, t85.id AS id_86, t85.enabled AS enabled_87, t85.`period` AS period_88, t85.label AS label_89, t85.text AS text_90, t85.version AS version_91, t85.user_id AS user_id_92, t93.id AS id_94, t93.`config` AS config_95, t93.user_id AS user_id_96, t97.id AS id_98, t97.created_at AS created_at_99, t97.user_id AS user_id_100, t101.id AS id_102, t101.rate AS rate_103, t101.review AS review_104, t101.user_id AS user_id_105, t106.id AS id_107, t106.`login_type` AS login_type_108, t106.user_id AS user_id_109, t110.id AS id_111, t110.config AS config_112, t110.user_id AS user_id_113, t114.id AS id_115, t114.calendar_event_name_type AS calendar_event_name_type_116, t114.default_daily_meeting_limit AS default_daily_meeting_limit_117, t114.custom_booking_css AS custom_booking_css_118, t114.user_id AS user_id_119, t0.subscription_id AS subscription_id_120 FROM hly_user t0 LEFT JOIN `hly_user_social_link` t65 ON t65.user_id = t0.id LEFT JOIN `hly_user_google_authenticator` t73 ON t73.user_id = t0.id LEFT JOIN hly_migration_subscription t77 ON t77.user_id = t0.id LEFT JOIN hly_user_cancellation_policy t85 ON t85.user_id = t0.id LEFT JOIN hly_user_widget t93 ON t93.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t97 ON t97.user_id = t0.id LEFT JOIN hly_review t101 ON t101.user_id = t0.id LEFT JOIN hly_user_sso t106 ON t106.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t110 ON t110.user_id = t0.id LEFT JOIN hly_user_preferences t114 ON t114.user_id = t0.id WHERE t0.domain = 'super-admin.test.d.simplybook.ovh' LIMIT 1;

0.35 ms
(36.96%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.uuid AS uuid_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.avatar_name AS avatar_name_7, t0.avatar_size AS avatar_size_8, t0.banner_name AS banner_name_9, t0.banner_size AS banner_size_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.domain AS domain_13, t0.calendar_layout AS calendar_layout_14, t0.hide_unavailable_dates AS hide_unavailable_dates_15, t0.sunday_is_first_day AS sunday_is_first_day_16, t0.rtl AS rtl_17, t0.email AS email_18, t0.overwrite_personal_domain AS overwrite_personal_domain_19, t0.overwrite_personal_appearance AS overwrite_personal_appearance_20, t0.ada AS ada_21, t0.allow_login_as_user AS allow_login_as_user_22, t23.id AS id_24, t23.facebook_url AS facebook_url_25, t23.twitter_url AS twitter_url_26, t23.instagram_url AS instagram_url_27, t23.linkedin_url AS linkedin_url_28, t23.whatsapp_url AS whatsapp_url_29, t23.organization_id AS organization_id_30, t31.id AS id_32, t31.config AS config_33, t31.organization_id AS organization_id_34, t35.id AS id_36, t35.uuid AS uuid_37, t35.custom_booking_css AS custom_booking_css_38, t35.organization_id AS organization_id_39, t40.overwrite_personal AS overwrite_personal_41, t40.id AS id_42, t40.enabled AS enabled_43, t40.`period` AS period_44, t40.label AS label_45, t40.text AS text_46, t40.version AS version_47, t40.organization_id AS organization_id_48, t49.id AS id_50, t49.`config` AS config_51, t49.organization_id AS organization_id_52 FROM hly_organization t0 LEFT JOIN `hly_organization_social_link` t23 ON t23.organization_id = t0.id LEFT JOIN hly_organization_scheduling_page_appearance t31 ON t31.organization_id = t0.id LEFT JOIN hly_organization_preferences t35 ON t35.organization_id = t0.id LEFT JOIN hly_organization_cancellation_policy t40 ON t40.organization_id = t0.id LEFT JOIN hly_organization_widget t49 ON t49.organization_id = t0.id WHERE t0.domain = ? LIMIT 1

Parameters:

[
  "super-admin.test.d.simplybook.ovh"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.uuid AS uuid_4,
  t0.slug AS slug_5,
  t0.intro AS intro_6,
  t0.avatar_name AS avatar_name_7,
  t0.avatar_size AS avatar_size_8,
  t0.banner_name AS banner_name_9,
  t0.banner_size AS banner_size_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.domain AS domain_13,
  t0.calendar_layout AS calendar_layout_14,
  t0.hide_unavailable_dates AS hide_unavailable_dates_15,
  t0.sunday_is_first_day AS sunday_is_first_day_16,
  t0.rtl AS rtl_17,
  t0.email AS email_18,
  t0.overwrite_personal_domain AS overwrite_personal_domain_19,
  t0.overwrite_personal_appearance AS overwrite_personal_appearance_20,
  t0.ada AS ada_21,
  t0.allow_login_as_user AS allow_login_as_user_22,
  t23.id AS id_24,
  t23.facebook_url AS facebook_url_25,
  t23.twitter_url AS twitter_url_26,
  t23.instagram_url AS instagram_url_27,
  t23.linkedin_url AS linkedin_url_28,
  t23.whatsapp_url AS whatsapp_url_29,
  t23.organization_id AS organization_id_30,
  t31.id AS id_32,
  t31.config AS config_33,
  t31.organization_id AS organization_id_34,
  t35.id AS id_36,
  t35.uuid AS uuid_37,
  t35.custom_booking_css AS custom_booking_css_38,
  t35.organization_id AS organization_id_39,
  t40.overwrite_personal AS overwrite_personal_41,
  t40.id AS id_42,
  t40.enabled AS enabled_43,
  t40.`period` AS period_44,
  t40.label AS label_45,
  t40.text AS text_46,
  t40.version AS version_47,
  t40.organization_id AS organization_id_48,
  t49.id AS id_50,
  t49.`config` AS config_51,
  t49.organization_id AS organization_id_52
FROM
  hly_organization t0
  LEFT JOIN `hly_organization_social_link` t23 ON t23.organization_id = t0.id
  LEFT JOIN hly_organization_scheduling_page_appearance t31 ON t31.organization_id = t0.id
  LEFT JOIN hly_organization_preferences t35 ON t35.organization_id = t0.id
  LEFT JOIN hly_organization_cancellation_policy t40 ON t40.organization_id = t0.id
  LEFT JOIN hly_organization_widget t49 ON t49.organization_id = t0.id
WHERE
  t0.domain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.uuid AS uuid_4, t0.slug AS slug_5, t0.intro AS intro_6, t0.avatar_name AS avatar_name_7, t0.avatar_size AS avatar_size_8, t0.banner_name AS banner_name_9, t0.banner_size AS banner_size_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.domain AS domain_13, t0.calendar_layout AS calendar_layout_14, t0.hide_unavailable_dates AS hide_unavailable_dates_15, t0.sunday_is_first_day AS sunday_is_first_day_16, t0.rtl AS rtl_17, t0.email AS email_18, t0.overwrite_personal_domain AS overwrite_personal_domain_19, t0.overwrite_personal_appearance AS overwrite_personal_appearance_20, t0.ada AS ada_21, t0.allow_login_as_user AS allow_login_as_user_22, t23.id AS id_24, t23.facebook_url AS facebook_url_25, t23.twitter_url AS twitter_url_26, t23.instagram_url AS instagram_url_27, t23.linkedin_url AS linkedin_url_28, t23.whatsapp_url AS whatsapp_url_29, t23.organization_id AS organization_id_30, t31.id AS id_32, t31.config AS config_33, t31.organization_id AS organization_id_34, t35.id AS id_36, t35.uuid AS uuid_37, t35.custom_booking_css AS custom_booking_css_38, t35.organization_id AS organization_id_39, t40.overwrite_personal AS overwrite_personal_41, t40.id AS id_42, t40.enabled AS enabled_43, t40.`period` AS period_44, t40.label AS label_45, t40.text AS text_46, t40.version AS version_47, t40.organization_id AS organization_id_48, t49.id AS id_50, t49.`config` AS config_51, t49.organization_id AS organization_id_52 FROM hly_organization t0 LEFT JOIN `hly_organization_social_link` t23 ON t23.organization_id = t0.id LEFT JOIN hly_organization_scheduling_page_appearance t31 ON t31.organization_id = t0.id LEFT JOIN hly_organization_preferences t35 ON t35.organization_id = t0.id LEFT JOIN hly_organization_cancellation_policy t40 ON t40.organization_id = t0.id LEFT JOIN hly_organization_widget t49 ON t49.organization_id = t0.id WHERE t0.domain = 'super-admin.test.d.simplybook.ovh' LIMIT 1;

0.04 ms
(4.18%)

USE dimka_harmonizely

Parameters:

[]

View formatted query View runnable query Explain query

USE dimka_harmonizely

USE dimka_harmonizely;

harmonizely connection

No database queries were performed.

Database Connections

Name	Service
common	doctrine.dbal.common_connection
company	doctrine.dbal.company_connection
harmonizely	doctrine.dbal.harmonizely_connection

Entity Managers

Name	Service
common	doctrine.orm.common_entity_manager
company	doctrine.orm.company_entity_manager
harmonizely	doctrine.orm.harmonizely_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

common entity manager

Class	Mapping errors
Harmonizely\Entity\Common\CompanyEntity	No errors.

company entity manager

Class	Mapping errors
Harmonizely\Model\Organization	The field Harmonizely\Model\Organization#organizationTag is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\OrganizationTagEntity#organization does not contain the required 'inversedBy="organizationTag"' attribute. The field Harmonizely\Model\Organization#organizationLimit is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\OrganizationLimitEntity#organization does not contain the required 'inversedBy="organizationLimit"' attribute.
FOS\UserBundle\Model\User	No errors.
Harmonizely\Model\User	The field Harmonizely\Model\User#userNews is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\UserNewsEntity#user does not contain the required 'inversedBy="userNews"' attribute. The field Harmonizely\Model\User#userExport is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\ExportEntity#user does not contain the required 'inversedBy="userExport"' attribute. The field Harmonizely\Model\User#userSmsLog is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\UserSmsLogEntity#user does not contain the required 'inversedBy="userSmsLog"' attribute. The field Harmonizely\Model\User#userEmailLog is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\UserEmailLogEntity#user does not contain the required 'inversedBy="userEmailLog"' attribute. The field Harmonizely\Model\User#userLimit is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\UserLimitEntity#user does not contain the required 'inversedBy="userLimit"' attribute. The field Harmonizely\Model\User#userLoginCode is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\UserLoginCodeEntity#user does not contain the required 'inversedBy="userLoginCode"' attribute. The field Harmonizely\Model\User#userEventTypeTag is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\UserEventTypeTagEntity#user does not contain the required 'inversedBy="userEventTypeTag"' attribute. The field Harmonizely\Model\User#subscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Model\Subscription#user does not contain the required 'inversedBy="subscriptions"' attribute. The field Harmonizely\Model\User#events is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Model\Event#user does not contain the required 'inversedBy="events"' attribute.
Harmonizely\Entity\Company\UserLoginAttemptEntity	No errors.
Harmonizely\Entity\Company\SuperAdmin\UserEntity	No errors.
Harmonizely\Entity\Company\UserTermsAcceptanceEntity	No errors.
Harmonizely\Entity\Company\OrganizationSocialLinkEntity	No errors.
Harmonizely\Model\OrganizationSchedulingPageAppearance	No errors.
Harmonizely\Model\OrganizationPreferences	No errors.
Harmonizely\Entity\Company\OrganizationCancellationPolicyEntity	No errors.
Harmonizely\Entity\Company\OrganizationWidgetEntity	No errors.
Harmonizely\Entity\Company\UserSocialLinkEntity	No errors.
Harmonizely\Entity\Company\UserGoogleAuthenticatorEntity	No errors.
Harmonizely\Entity\Company\MigrationSubscriptionEntity	No errors.
Harmonizely\Model\Subscription	No errors.
Harmonizely\Entity\Company\UserCancellationPolicyEntity	No errors.
Harmonizely\Entity\Company\UserWidgetEntity	No errors.
Harmonizely\Entity\Company\UserEmailUnsubscribeEntity	No errors.
Harmonizely\Entity\Company\ReviewEntity	No errors.
Harmonizely\Entity\Company\UserSsoEntity	No errors.
Harmonizely\Model\UserSchedulingPageAppearance	No errors.
Harmonizely\Model\UserPreferences	No errors.
Harmonizely\Model\EventTypePayment	No errors.
Harmonizely\Model\EventType	The field Harmonizely\Model\EventType#singleUseLinks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Model\SingleUseLink#eventType does not contain the required 'inversedBy="singleUseLinks"' attribute. The field Harmonizely\Model\EventType#eventTypeDurations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\EventTypeDurationEntity#eventType does not contain the required 'inversedBy="eventTypeDurations"' attribute. The field Harmonizely\Model\EventType#eventTypeRequestLocationTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\EventTypeRequestLocationTypeEntity#eventType does not contain the required 'inversedBy="eventTypeRequestLocationTypes"' attribute.
Harmonizely\Model\Integration	No errors.
Harmonizely\Entity\Company\OrganizationIntegrationEntity	The field Harmonizely\Entity\Company\OrganizationIntegrationEntity#oktaDomain is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Harmonizely\Entity\Company\OktaDomainEntity#organizationIntegration does not contain the required 'inversedBy="oktaDomain"' attribute.

harmonizely entity manager

No loaded entities.

Symfony Profiler

https://simplymeet.test.d.simplybook.ovh/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

common connection

company connection

harmonizely connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

common entity manager

company entity manager

harmonizely entity manager