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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
22.91 ms
(89.65%)
42
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
]
1.45 ms
(5.67%)
1
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
]
0.68 ms
(2.65%)
1
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
]
0.52 ms
(2.02%)
1
SELECT count(c0_.id) AS sclr_0 FROM customer c0_ WHERE c0_.agent_id = ?
Parameters:
[
  69
]

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.