Query Metrics
2
Database Queries
2
Different statements
2.11 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.43 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.deleted AS deleted_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.club_member_since AS club_member_since_9, t0.user_detail_id AS user_detail_id_10, t11.id AS id_12, t11.document_filename AS document_filename_13, t11.saw_verification_at AS saw_verification_at_14, t11.user_id AS user_id_15, t0.statistic_id AS statistic_id_16, t17.id AS id_18, t17.hash AS hash_19, t17.is_subscribed AS is_subscribed_20, t17.inx_mail_recipient_id AS inx_mail_recipient_id_21, t17.opt_in_mail_sent_at AS opt_in_mail_sent_at_22, t17.user_id AS user_id_23 FROM user t0 LEFT JOIN verify_hcp_request t11 ON t11.user_id = t0.id LEFT JOIN user_newsletter t17 ON t17.user_id = t0.id WHERE t0.id = ?
Parameters:
[
111
]
|
| 2 | 0.67 ms |
SELECT t0.id AS id_1, t0.gender AS gender_2, t0.title AS title_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.newsletter AS newsletter_6, t0.phone_number AS phone_number_7, t0.fax_number AS fax_number_8, t0.deleted_at AS deleted_at_9, t0.inx_mail_recipient_id AS inx_mail_recipient_id_10, t0.from_apothekia AS from_apothekia_11, t0.address_id AS address_id_12, t0.crm_user_detail_id AS crm_user_detail_id_13 FROM user_detail t0 WHERE t0.id = ?
Parameters:
[
1561
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\UserDetail | No errors. |
| App\Entity\VerifyHcpRequest | No errors. |
| App\Entity\UserStatistic | No errors. |
| App\Entity\UserNewsletter | No errors. |
| App\Entity\ELearningStatus | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\CrmUserDetail | No errors. |
| App\Entity\CrmState | No errors. |
| App\Entity\UserCode | No errors. |