Query Metrics
2
Database Queries
2
Different statements
0.82 ms
Query time
4
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.51 ms (62.25%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.login AS login_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.roles AS roles_6, t0.password AS password_7, t0.invitation_token AS invitation_token_8, t0.restore_password_token AS restore_password_token_9, t0.invited_at AS invited_at_10, t0.pharmacy_id AS pharmacy_id_11, t12.id AS id_13, t12.name AS name_14, t12.mail AS mail_15, t12.phone AS phone_16, t12.address AS address_17, t12.joining_date AS joining_date_18, t12.status AS status_19, t12.owner_id AS owner_id_20, t21.id AS id_22, t21.created_at AS created_at_23, t21.last_updated_at AS last_updated_at_24, t21.user_id AS user_id_25, t26.id AS id_27, t26.code AS code_28, t26.name AS name_29, t26.type AS type_30, t26.settings AS settings_31, t26.user_id AS user_id_32 FROM `user` t0 LEFT JOIN organization t12 ON t12.owner_id = t0.id LEFT JOIN `conversations` t21 ON t21.user_id = t0.id LEFT JOIN `integration` t26 ON t26.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.31 ms (37.75%) |
1 |
SELECT m0_.id AS id_0, m0_.message AS message_1, m0_.is_administrator_message AS is_administrator_message_2, m0_.read_at AS read_at_3, m0_.created_at AS created_at_4 FROM `messages` m0_ ORDER BY m0_.id DESC LIMIT 10
Parameters:
[] |
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 |
|---|---|
| App\User\Entity\User | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\User\Entity\User |
|
| App\Pharmacy\Entity\Pharmacy |
|
| App\Organization\Entity\Organization | No errors. |
| App\Messaging\Entity\Conversation |
|
| App\Integration\Entity\Integration | No errors. |
| App\Order\Entity\Order |
|
| App\Messaging\Entity\Message | No errors. |