Query Metrics
4
Database Queries
4
Different statements
0.64 ms
Query time
5
Invalid entities
Queries
common connection
#▲ | Time | Info |
---|---|---|
1 | 0.23 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.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.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.id = ? LIMIT 1
Parameters:
[
1411
]
|
3 | 0.29 ms |
SELECT h0_.id AS id_0, h0_.status AS status_1, h0_.type AS type_2, h0_.file_path AS file_path_3, h0_.datetime AS datetime_4, h0_.user_id AS user_id_5 FROM `hly_export` h0_ WHERE h0_.type = ? AND h0_.status NOT IN (?) AND h0_.datetime >= ? AND h0_.user_id = ?
Parameters:
[ "event" [ "downloaded" "error" ] "2025-07-06 07:44:31" 1411 ] |
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\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\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\Model\Member | 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\OrganizationTagEntity | No errors. |
Harmonizely\Entity\Company\CategoryEntity | No errors. |
Harmonizely\Model\Integration | No errors. |
Harmonizely\Model\CalendarAccount | No errors. |
Harmonizely\Model\EventPayment | No errors. |
Harmonizely\Model\Event |
|
Harmonizely\Entity\Company\OrganizationLimitEntity | No errors. |
Harmonizely\Entity\Company\OktaDomainEntity | No errors. |
Harmonizely\Entity\Company\OrganizationIntegrationEntity |
|
Harmonizely\Entity\Company\SuperAdmin\UserGoogleAuthenticatorEntity | No errors. |
Harmonizely\Entity\Company\SuperAdmin\UserLoginAttemptEntity | No errors. |
harmonizely entity manager
No loaded entities.