http://crm.wronieruchomosci.pl:8000/myContacts

Query Metrics

53 Database Queries
4 Different statements
12.06 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.17 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.56 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.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:
[
  7947
]
6 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:
[
  7946
]
7 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:
[
  7945
]
8 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:
[
  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.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:
[
  7942
]
11 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:
[
  7941
]
12 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:
[
  7940
]
13 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:
[
  7917
]
14 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:
[
  7916
]
15 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:
[
  7915
]
16 0.17 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.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:
[
  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.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:
[
  7904
]
21 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:
[
  7903
]
22 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:
[
  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.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:
[
  7900
]
25 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:
[
  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.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:
[
  7897
]
28 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:
[
  7896
]
29 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:
[
  7895
]
30 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:
[
  7888
]
31 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:
[
  7886
]
32 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:
[
  7885
]
33 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:
[
  7882
]
34 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:
[
  7880
]
35 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:
[
  7879
]
36 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:
[
  7878
]
37 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:
[
  7875
]
38 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:
[
  7868
]
39 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:
[
  7867
]
40 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:
[
  7865
]
41 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:
[
  7864
]
42 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:
[
  7863
]
43 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:
[
  7862
]
44 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:
[
  7861
]
45 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:
[
  7860
]
46 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:
[
  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.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:
[
  7844
]
49 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:
[
  7839
]
50 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:
[
  7829
]
51 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:
[
  7812
]
52 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:
[
  7809
]
53 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:
[
  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
  • The field App\Entity\Agent#mails is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Mail#agent does not contain the required 'inversedBy="mails"' attribute.
App\Entity\CustomerComment No errors.
App\Entity\Mail
  • The field App\Entity\Mail#mailAttachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MailAttachment#mail does not contain the required 'inversedBy="mailAttachments"' attribute.