Query Metrics
4
Database Queries
4
Different statements
0.32 ms
Query time
9
Invalid entities
Grouped Statements
common connection
| Time▼ | Count | Info |
|---|---|---|
|
0.14 ms (43.14%) |
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.08 ms (24.87%) |
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.translation_enabled AS translation_enabled_92, t85.user_id AS user_id_93, t94.id AS id_95, t94.`config` AS config_96, t94.user_id AS user_id_97, t98.id AS id_99, t98.created_at AS created_at_100, t98.user_id AS user_id_101, t102.id AS id_103, t102.rate AS rate_104, t102.review AS review_105, t102.user_id AS user_id_106, t107.id AS id_108, t107.`login_type` AS login_type_109, t107.user_id AS user_id_110, t111.id AS id_112, t111.config AS config_113, t111.user_id AS user_id_114, t115.id AS id_116, t115.calendar_event_name_type AS calendar_event_name_type_117, t115.default_daily_meeting_limit AS default_daily_meeting_limit_118, t115.custom_booking_css AS custom_booking_css_119, t115.user_id AS user_id_120, t0.subscription_id AS subscription_id_121 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 t94 ON t94.user_id = t0.id LEFT JOIN `hly_user_email_unsubscribe` t98 ON t98.user_id = t0.id LEFT JOIN hly_review t102 ON t102.user_id = t0.id LEFT JOIN hly_user_sso t107 ON t107.user_id = t0.id LEFT JOIN hly_user_scheduling_page_appearance t111 ON t111.user_id = t0.id LEFT JOIN hly_user_preferences t115 ON t115.user_id = t0.id WHERE t0.domain = ? LIMIT 1
Parameters:
[
"146.59.52.180"
]
|
|
0.07 ms (20.32%) |
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.appearance_linked_to_personal AS appearance_linked_to_personal_21, t0.ada AS ada_22, t0.allow_login_as_user AS allow_login_as_user_23, t24.id AS id_25, t24.facebook_url AS facebook_url_26, t24.twitter_url AS twitter_url_27, t24.instagram_url AS instagram_url_28, t24.linkedin_url AS linkedin_url_29, t24.whatsapp_url AS whatsapp_url_30, t24.organization_id AS organization_id_31, t32.id AS id_33, t32.config AS config_34, t32.organization_id AS organization_id_35, t36.id AS id_37, t36.uuid AS uuid_38, t36.custom_booking_css AS custom_booking_css_39, t36.organization_id AS organization_id_40, t41.overwrite_personal AS overwrite_personal_42, t41.id AS id_43, t41.enabled AS enabled_44, t41.`period` AS period_45, t41.label AS label_46, t41.text AS text_47, t41.version AS version_48, t41.translation_enabled AS translation_enabled_49, t41.organization_id AS organization_id_50, t51.id AS id_52, t51.`config` AS config_53, t51.organization_id AS organization_id_54 FROM hly_organization t0 LEFT JOIN `hly_organization_social_link` t24 ON t24.organization_id = t0.id LEFT JOIN hly_organization_scheduling_page_appearance t32 ON t32.organization_id = t0.id LEFT JOIN hly_organization_preferences t36 ON t36.organization_id = t0.id LEFT JOIN hly_organization_cancellation_policy t41 ON t41.organization_id = t0.id LEFT JOIN hly_organization_widget t51 ON t51.organization_id = t0.id WHERE t0.domain = ? LIMIT 1
Parameters:
[
"146.59.52.180"
]
|
|
0.04 ms (11.67%) |
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\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 |
|
| 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\OrganizationCancellationPolicyTranslationEntity | No errors. |
| Harmonizely\Entity\Company\SubscriptionAttribute | No errors. |
| Harmonizely\Entity\Company\UserCancellationPolicyTranslationEntity | No errors. |
| Harmonizely\Model\EmailReminder | No errors. |
| Harmonizely\Model\SmsReminder | No errors. |
| Harmonizely\Entity\Company\EmailFollowUpEntity | No errors. |
| Harmonizely\Model\SmsFollowUp | No errors. |
| Harmonizely\Entity\Company\RoutingFormRouteEntity | No errors. |
| Harmonizely\Model\SingleUseLink | No errors. |
| Harmonizely\Model\EmailTemplate | No errors. |
| Harmonizely\Entity\Company\EventTypeDurationEntity | No errors. |
| Harmonizely\Entity\Company\EventTypeRequestLocationTypeEntity | No errors. |
| Harmonizely\Entity\Company\SmsTemplateEntity | No errors. |
| Harmonizely\Model\EventTypeUser |
|
| Harmonizely\Model\AvailabilityRule | No errors. |
| Harmonizely\Model\Question | No errors. |
| Harmonizely\Model\Calendar |
|
| Harmonizely\Entity\Company\OktaDomainEntity | No errors. |
harmonizely entity manager
No loaded entities.