Query Metrics
8
Database Queries
2
Different statements
72.01 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 68.91 ms |
SELECT t0.id AS id_1, t0.subject AS subject_2, t0.sender AS sender_3, t0.receiver AS receiver_4, t0.receive_date AS receive_date_5, t0.message_id AS message_id_6, t0.message_uid AS message_uid_7, t0.message_text AS message_text_8, t0.agent_id AS agent_id_9, t0.customer_id AS customer_id_10 FROM mail t0 WHERE t0.agent_id IS NULL ORDER BY t0.message_uid DESC
Parameters:
[] |
2 | 0.56 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
874
]
|
3 | 0.49 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
3079
]
|
4 | 0.43 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
6626
]
|
5 | 0.36 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
7125
]
|
6 | 0.47 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
7400
]
|
7 | 0.32 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
6790
]
|
8 | 0.47 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ?
Parameters:
[
3587
]
|
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\Mail |
|
App\Entity\Agent |
|
App\Entity\Customer | No errors. |
App\Entity\MailAttachment | No errors. |
App\Entity\CustomerComment | No errors. |