Query Metrics
3
Database Queries
3
Different statements
2.39 ms
Query time
0
Invalid entities
1
Managed entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.00 ms |
SELECT c0_.id AS id_0, c0_.display_name AS display_name_1, c0_.legal_name AS legal_name_2, c0_.tagline AS tagline_3, c0_.logo_path AS logo_path_4, c0_.logo_light_path AS logo_light_path_5, c0_.favicon_path AS favicon_path_6, c0_.primary_color AS primary_color_7, c0_.accent_color AS accent_color_8, c0_.dark_sidebar AS dark_sidebar_9, c0_.template AS template_10, c0_.powered_by AS powered_by_11, c0_.email_from_name AS email_from_name_12, c0_.email_from_address AS email_from_address_13, c0_.email_reply_to AS email_reply_to_14, c0_.commercial_from_name AS commercial_from_name_15, c0_.commercial_from_address AS commercial_from_address_16, c0_.finance_from_name AS finance_from_name_17, c0_.finance_from_address AS finance_from_address_18, c0_.portal_from_name AS portal_from_name_19, c0_.portal_from_address AS portal_from_address_20, c0_.portal_reply_to AS portal_reply_to_21, c0_.portal_domain AS portal_domain_22, c0_.portal_domain_status AS portal_domain_status_23, c0_.portal_domain_status_message AS portal_domain_status_message_24, c0_.portal_domain_verified_at AS portal_domain_verified_at_25, c0_.portal_domain_attempted_at AS portal_domain_attempted_at_26, c0_.portal_notification_emails AS portal_notification_emails_27, c0_.email_footer_html AS email_footer_html_28, c0_.bank_accounts AS bank_accounts_29, c0_.email_transport AS email_transport_30, c0_.email_transport_config AS email_transport_config_31, c0_.login_background_path AS login_background_path_32, c0_.login_page_message AS login_page_message_33, c0_.custom_css AS custom_css_34, c0_.locale_default AS locale_default_35, c0_.timezone_default AS timezone_default_36, c0_.compliance_request_default_basis AS compliance_request_default_basis_37, c0_.notes AS notes_38, c0_.created_at AS created_at_39, c0_.updated_at AS updated_at_40, c0_.tenant_id AS tenant_id_41 FROM cp_branding c0_ INNER JOIN cp_tenants c1_ ON c0_.tenant_id = c1_.id WHERE c1_.slug = ? LIMIT 1
Parameters:
[
"local"
]
|
| 2 | 0.51 ms |
SELECT enabled FROM tenant_module_state WHERE tenant_slug = ? AND module_key = ? LIMIT 1
Parameters:
[ "local" "capability.oauth-login" ] |
| 3 | 0.88 ms |
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.roles AS roles_3, t0.password AS password_4, t0.email_address AS email_address_5, t0.user_name AS user_name_6, t0.is_verified AS is_verified_7, t0.google_id AS google_id_8, t0.google_access_token AS google_access_token_9, t0.azure_id AS azure_id_10, t0.azure_access_token AS azure_access_token_11, t0.is_on_premise AS is_on_premise_12, t0.preferred_theme AS preferred_theme_13, t0.preferred_locale AS preferred_locale_14, t0.api_key AS api_key_15, t0.api_key_generated_at AS api_key_generated_at_16, t0.is_customer_user AS is_customer_user_17, t0.last_login_at AS last_login_at_18, t0.email_signature AS email_signature_19, t0.is_commercial AS is_commercial_20, t0.is_awb_signer AS is_awb_signer_21, t0.is_operator AS is_operator_22, t0.profile_image_path AS profile_image_path_23, t0.job_title AS job_title_24, t0.ui_preferences AS ui_preferences_25, t0.privacy_consented_at AS privacy_consented_at_26, t0.phone AS phone_27, t0.mobile_phone AS mobile_phone_28, t0.website AS website_29, t0.totp_secret AS totp_secret_30, t0.is_two_factor_enabled AS is_two_factor_enabled_31, t0.allowed_ip_ranges AS allowed_ip_ranges_32, t0.is_active AS is_active_33, t0.department_id AS department_id_34, t0.current_department_id AS current_department_id_35, t0.customer_organization_id AS customer_organization_id_36 FROM user t0 WHERE t0.id = ?
Parameters:
[
90
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| legacy | doctrine.dbal.legacy_connection |
| legacy_adhocs | doctrine.dbal.legacy_adhocs_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| legacy | doctrine.orm.legacy_entity_manager |
| legacy_adhocs | doctrine.orm.legacy_adhocs_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| CTS\SkeletonCore\Entity\User | 1 |
legacy entity manager
| Class | Amount of managed objects |
|---|
legacy_adhocs entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| CTS\SkeletonCore\Entity\Branding | No errors. |
| CTS\SkeletonCore\Entity\Tenant | No errors. |
| CTS\SkeletonCore\Entity\User | No errors. |
| CTS\Shared\Entity\Department | No errors. |
| CTS\Shared\Entity\Organization | No errors. |
| CTS\Shared\Entity\UserOrganization | No errors. |
legacy entity manager
No loaded entities.
legacy_adhocs entity manager
No loaded entities.