http://crm.wronieruchomosci.pl:8000/details?id=4801

Query Metrics

3 Database Queries
3 Different statements
1.66 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.customer_type AS customer_type_6, t0.status AS status_7, t0.add_date AS add_date_8, t0.reserved_to AS reserved_to_9, t0.contract_date AS contract_date_10, t0.link AS link_11, t0.agent_id AS agent_id_12 FROM customer t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "4801"
]
2 0.26 ms
SELECT t0.id AS id_1, t0.subject AS subject_2, t0.sender AS sender_3, t0.receiver AS receiver_4, t0.receive_date AS receive_date_5, t0.message_id AS message_id_6, t0.message_uid AS message_uid_7, t0.message_text AS message_text_8, t0.agent_id AS agent_id_9, t0.customer_id AS customer_id_10 FROM mail t0 WHERE t0.customer_id = ?
Parameters:
[
  "4801"
]
3 0.71 ms
SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.comment_add_date AS comment_add_date_2, c0_.comment AS comment_3, c0_.customer_id AS customer_id_4 FROM customer_comment c0_ WHERE c0_.customer_id = ? ORDER BY c0_.date DESC LIMIT 50
Parameters:
[
  "4801"
]

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\CustomerComment 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\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.