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

Query Metrics

45 Database Queries
4 Different statements
25.55 ms Query time
2 Invalid entities

Queries

Group similar statements

# 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
  • 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.