Query Metrics

4 Database Queries
3 Different statements
7.15 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 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.id IS NULL LIMIT 1
Parameters:
[]
2 4.87 ms
SELECT DATABASE()
Parameters:
[]
3 1.39 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "crm"
]
4 0.26 ms
SELECT DATABASE()
Parameters:
[]

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\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.
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\Customer No errors.
App\Entity\MailAttachment No errors.
App\Entity\CustomerComment No errors.