Query Metrics
4
Database Queries
4
Different statements
0.31 ms
Query time
9
Invalid entities
Queries
common connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.13 ms |
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 | Info |
|---|---|---|
| 1 | 0.04 ms |
USE dimka_harmonizely
Parameters:
[] |
| 2 | 0.07 ms |
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:
[
"secure.marina.d.simplybook.ovh"
]
|
| 3 | 0.08 ms |
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:
[
"secure.marina.d.simplybook.ovh"
]
|
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\SubscriptionAttribute | 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.