Query Metrics
53
Database Queries
4
Different statements
11.32 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.49 ms |
SELECT c0_.id AS id_0, c0_.phone AS phone_1, c0_.email AS email_2, c0_.firstname AS firstname_3, c0_.lastname AS lastname_4, c0_.customer_type AS customer_type_5, c0_.status AS status_6, c0_.add_date AS add_date_7, c0_.reserved_to AS reserved_to_8, c0_.contract_date AS contract_date_9, c0_.link AS link_10, c0_.agent_id AS agent_id_11 FROM customer c0_ WHERE c0_.agent_id = ? ORDER BY c0_.id DESC LIMIT 50
Parameters:
[
69
]
|
2 | 0.26 ms |
SELECT count(c0_.id) AS sclr_0 FROM customer c0_ WHERE c0_.agent_id = ?
Parameters:
[
69
]
|
3 | 0.26 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7960
]
|
4 | 0.21 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password_to_email AS password_to_email_3, t0.how_many_messages AS how_many_messages_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.password AS password_7, t0.agent_role AS agent_role_8, t0.image_url AS image_url_9, t0.email_allow_date AS email_allow_date_10 FROM agent t0 WHERE t0.id = ?
Parameters:
[
69
]
|
5 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7947
]
|
6 | 0.22 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7946
]
|
7 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7945
]
|
8 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7944
]
|
9 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7943
]
|
10 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7942
]
|
11 | 0.22 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7941
]
|
12 | 0.24 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7940
]
|
13 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7917
]
|
14 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7916
]
|
15 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7915
]
|
16 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7914
]
|
17 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7913
]
|
18 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7912
]
|
19 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7905
]
|
20 | 0.18 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7904
]
|
21 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7903
]
|
22 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7902
]
|
23 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7901
]
|
24 | 0.23 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7900
]
|
25 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7899
]
|
26 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7898
]
|
27 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7897
]
|
28 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7896
]
|
29 | 0.18 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7895
]
|
30 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7888
]
|
31 | 0.22 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7886
]
|
32 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7885
]
|
33 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7882
]
|
34 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7880
]
|
35 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7879
]
|
36 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7878
]
|
37 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7875
]
|
38 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7868
]
|
39 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7867
]
|
40 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7865
]
|
41 | 0.26 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7864
]
|
42 | 0.24 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7863
]
|
43 | 0.22 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7862
]
|
44 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7861
]
|
45 | 0.18 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7860
]
|
46 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7854
]
|
47 | 0.20 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7849
]
|
48 | 0.18 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7844
]
|
49 | 0.26 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7839
]
|
50 | 0.19 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7829
]
|
51 | 0.23 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7812
]
|
52 | 0.21 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7809
]
|
53 | 0.22 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.comment_add_date AS comment_add_date_3, t0.comment AS comment_4, t0.customer_id AS customer_id_5 FROM customer_comment t0 WHERE t0.customer_id = ?
Parameters:
[
7806
]
|
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\Customer | No errors. |
App\Entity\Agent |
|
App\Entity\CustomerComment | No errors. |
App\Entity\Mail |
|