Query Metrics
45
Database Queries
4
Different statements
25.55 ms
Query time
2
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.45 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.52 ms |
SELECT count(c0_.id) AS sclr_0 FROM customer c0_ WHERE c0_.agent_id = ?
Parameters:
[
69
]
|
3 | 0.63 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
]
|
4 | 0.68 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.60 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
]
|
6 | 0.53 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
]
|
7 | 0.69 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
]
|
8 | 0.61 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
]
|
9 | 0.53 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
]
|
10 | 0.63 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
]
|
11 | 0.93 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
]
|
12 | 0.75 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
]
|
13 | 0.52 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
]
|
14 | 0.88 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
]
|
15 | 0.81 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
]
|
16 | 0.81 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
]
|
17 | 0.90 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
]
|
18 | 0.88 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:
[
7805
]
|
19 | 0.62 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:
[
7801
]
|
20 | 0.43 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:
[
7799
]
|
21 | 0.45 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:
[
7796
]
|
22 | 0.44 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:
[
7795
]
|
23 | 0.41 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:
[
7794
]
|
24 | 0.43 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:
[
7792
]
|
25 | 0.43 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:
[
7782
]
|
26 | 0.48 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:
[
7774
]
|
27 | 0.45 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:
[
7771
]
|
28 | 0.43 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:
[
7769
]
|
29 | 0.43 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:
[
7766
]
|
30 | 0.42 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:
[
7765
]
|
31 | 0.50 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:
[
7762
]
|
32 | 0.46 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:
[
7755
]
|
33 | 0.46 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:
[
7751
]
|
34 | 0.42 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:
[
7750
]
|
35 | 0.48 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:
[
7740
]
|
36 | 0.44 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:
[
7734
]
|
37 | 0.39 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:
[
7732
]
|
38 | 0.46 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:
[
7731
]
|
39 | 0.37 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:
[
7730
]
|
40 | 0.46 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:
[
7729
]
|
41 | 0.39 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:
[
7728
]
|
42 | 0.50 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:
[
7727
]
|
43 | 0.45 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:
[
7300
]
|
44 | 0.53 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:
[
5846
]
|
45 | 0.49 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:
[
3143
]
|
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 |
|