Query Metrics
4
Database Queries
4
Different statements
0.46 ms
Query time
6
Invalid entities
Grouped Statements
common connection
Time▼ | Count | Info |
---|---|---|
0.29 ms (63.09%) |
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"
]
|
company connection
Time▼ | Count | Info |
---|---|---|
0.07 ms (15.97%) |
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.slug AS slug_17, t0.timezone AS timezone_18, t0.locale AS locale_19, t0.avatar_name AS avatar_name_20, t0.avatar_size AS avatar_size_21, t0.branding_enabled AS branding_enabled_22, t0.is_proxy_enabled AS is_proxy_enabled_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.domain AS domain_26, t0.uuid AS uuid_27, t0.sender AS sender_28, t0.company_logo_name AS company_logo_name_29, t0.company_logo_size AS company_logo_size_30, t0.banner_name AS banner_name_31, t0.banner_size AS banner_size_32, t0.time_format AS time_format_33, t0.date_format AS date_format_34, t0.client_time_format AS client_time_format_35, t0.address AS address_36, t0.state AS state_37, t0.zip AS zip_38, t0.city AS city_39, t0.country_id AS country_id_40, t0.lat AS lat_41, t0.lng AS lng_42, t0.other_category AS other_category_43, t0.last_two_factor_code AS last_two_factor_code_44, t0.show_address_in_email AS show_address_in_email_45, t0.calendar_layout AS calendar_layout_46, t0.hide_unavailable_dates AS hide_unavailable_dates_47, t0.sunday_is_first_day AS sunday_is_first_day_48, t0.rtl AS rtl_49, t0.require_set_password AS require_set_password_50, t0.require_confirm_email AS require_confirm_email_51, t0.daylite_id AS daylite_id_52, t0.phone_number AS phone_number_53, t0.consent AS consent_54, t0.referral AS referral_55, t0.verification_code AS verification_code_56, t0.ada AS ada_57, t0.allow_login_as_user AS allow_login_as_user_58, t0.welcome_tour_step AS welcome_tour_step_59, t0.second_factor_skipped AS second_factor_skipped_60, t0.tutorial_skipped AS tutorial_skipped_61, t0.onboarding_skipped AS onboarding_skipped_62, t63.id AS id_64, t63.facebook_url AS facebook_url_65, t63.twitter_url AS twitter_url_66, t63.instagram_url AS instagram_url_67, t63.linkedin_url AS linkedin_url_68, t63.whatsapp_url AS whatsapp_url_69, t63.user_id AS user_id_70, t71.id AS id_72, t71.string_value AS string_value_73, t71.user_id AS user_id_74, t75.id AS id_76, t75.code AS code_77, t75.email AS email_78, t75.create_datetime AS create_datetime_79, t75.used_datetime AS used_datetime_80, t75.user_id AS user_id_81, t75.subscription_id AS subscription_id_82, t83.id AS id_84, t83.enabled AS enabled_85, t83.`period` AS period_86, t83.label AS label_87, t83.text AS text_88, t83.version AS version_89, t83.user_id AS user_id_90, t91.id AS id_92, t91.`config` AS config_93, t91.user_id AS user_id_94, t95.id AS id_96, t95.created_at AS created_at_97, t95.user_id AS user_id_98, t99.id AS id_100, t99.rate AS rate_101, t99.review AS review_102, t99.user_id AS user_id_103, t104.id AS id_105, t104.`login_type` AS login_type_106, t104.user_id AS user_id_107, t108.id AS id_109, t108.config AS config_110, t108.user_id AS user_id_111, t112.id AS id_113, t112.calendar_event_name_type AS calendar_event_name_type_114, t112.default_daily_meeting_limit AS default_daily_meeting_limit_115, t112.custom_booking_css AS custom_booking_css_116, t112.user_id AS user_id_117, t0.subscription_id AS subscription_id_118 FROM hly_user t0 LEFT JOIN `hly_user_social_link` t63 ON t63.user_id = t0.id LEFT JOIN `hly_user_google_authenticator` t71 ON t71.user_id = t0.id LEFT JOIN hly_migration_subscription t75 ON t75.user_id = t0.id LEFT JOIN hly_user_cancellation_policy t83 ON t83.user_id = t0.id LEFT JOIN hly_user_widget t91 ON t91.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t95 ON t95.user_id = t0.id LEFT JOIN hly_review t99 ON t99.user_id = t0.id LEFT JOIN hly_user_sso t104 ON t104.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t108 ON t108.user_id = t0.id LEFT JOIN hly_user_preferences t112 ON t112.user_id = t0.id WHERE t0.domain = ? LIMIT 1
Parameters:
[
"custom.test.d.simplybook.ovh"
]
|
0.06 ms (12.94%) |
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:
[
"custom.test.d.simplybook.ovh"
]
|
0.04 ms (8.01%) |
1 |
USE dimka_harmonizely
Parameters:
[] |
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 |
|
FOS\UserBundle\Model\User | No errors. |
Harmonizely\Model\User |
|
Harmonizely\Entity\Company\UserLoginAttemptEntity | No errors. |
Harmonizely\Entity\Company\SuperAdmin\UserEntity | 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\Integration | No errors. |
Harmonizely\Entity\Company\OrganizationIntegrationEntity |
|
Harmonizely\Entity\Company\OrganizationTaxEntity | No errors. |
Harmonizely\Entity\Company\OrganizationRoleEntity |
|
Harmonizely\Entity\Company\OrganizationTagEntity | No errors. |
Harmonizely\Model\Member | No errors. |
Harmonizely\Entity\Company\OrganizationLimitEntity | No errors. |
Harmonizely\Entity\Company\UserTaxEntity | No errors. |
Harmonizely\Entity\Company\PollEntity | No errors. |
Harmonizely\Entity\Company\ApiKeyEntity | No errors. |
Harmonizely\Entity\Company\RoutingFormEntity | No errors. |
Harmonizely\Entity\Company\UserNewsEntity | No errors. |
Harmonizely\Entity\Company\UserTokenEntity | No errors. |
Harmonizely\Entity\Company\UserDeviceTokenEntity | No errors. |
Harmonizely\Entity\Company\UserApiStatisticEntity | No errors. |
Harmonizely\Entity\Company\ExportEntity | No errors. |
Harmonizely\Entity\Company\UserOAuthEntity | No errors. |
Harmonizely\Entity\Company\UserSmsLogEntity | No errors. |
Harmonizely\Entity\Company\UserEmailLogEntity | No errors. |
Harmonizely\Entity\Company\UserPushNotificationLogEntity | No errors. |
Harmonizely\Entity\Company\UserLimitEntity | No errors. |
Harmonizely\Entity\Company\UserLoginCodeEntity | No errors. |
Harmonizely\Entity\Company\UserEventTypeTagEntity |
|
Harmonizely\Entity\Company\UserRelationEntity | No errors. |
Harmonizely\Entity\Company\CategoryEntity | No errors. |
Harmonizely\Model\CalendarAccount | No errors. |
Harmonizely\Model\EventPayment | No errors. |
Harmonizely\Model\Event |
|
Harmonizely\Entity\Company\SuperAdmin\UserGoogleAuthenticatorEntity | No errors. |
Harmonizely\Entity\Company\OktaDomainEntity | No errors. |
harmonizely entity manager
No loaded entities.