Query Metrics
2
Database Queries
2
Different statements
2.60 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.86 ms (71.31%) |
1 |
SELECT t0.client_identifier AS client_identifier_1, t0.name AS name_2, t0.description AS description_3, t0.logo_name AS logo_name_4, t0.logo_size AS logo_size_5, t0.favicon_name AS favicon_name_6, t0.favicon_size AS favicon_size_7, t0.primary_color AS primary_color_8, t0.secondary_color AS secondary_color_9, t0.accent_color AS accent_color_10, t0.website_url AS website_url_11, t0.privacy_policy_url AS privacy_policy_url_12, t0.terms_of_service_url AS terms_of_service_url_13, t0.support_email AS support_email_14, t0.custom_css AS custom_css_15, t0.metadata AS metadata_16, t0.additional_config AS additional_config_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19 FROM oauth2_client_branding t0 WHERE t0.client_identifier = ? LIMIT 1
Parameters:
[
"bbee5a7a243cb2732827127ac96686e7"
]
|
||||||||||||||||||||
|
0.75 ms (28.69%) |
1 |
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.identifier_type AS identifier_type_3, t0.otp_hash AS otp_hash_4, t0.created_at AS created_at_5, t0.expires_at AS expires_at_6, t0.attempts AS attempts_7, t0.used_at AS used_at_8, t0.device_id AS device_id_9, t0.ip AS ip_10, t0.session_id AS session_id_11, t0.validated_at AS validated_at_12, t0.challenge_id AS challenge_id_13, t0.user_agent AS user_agent_14 FROM passwordless_otps t0 WHERE t0.identifier = ? AND t0.challenge_id = ? AND t0.validated_at IS NULL LIMIT 1
Parameters:
[ "+5…" "b19a431e7c46e1f0388aee20a6918dbf" ]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| Codyas\SymfonyMetronicIntegrationSkeletonBundle\Entity\OAuth2ClientBranding | No errors. |
| Codyas\SymfonyMetronicIntegrationSkeletonBundle\Entity\PasswordlessOtp | No errors. |