Query Metrics

2 Database Queries
2 Different statements
2.02 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.11 ms
(55.10%)
1
SELECT o0_.id AS id_0, o0_.tracking_number AS tracking_number_1, o0_.created_at AS created_at_2, o0_.payment_status AS payment_status_3, o0_.updated_at AS updated_at_4, o0_.payment_token AS payment_token_5, o0_.payment_data AS payment_data_6, o0_.type AS type_7, o0_.widget_id AS widget_id_8 FROM "order" o0_ WHERE o0_.created_at >= ? AND o0_.created_at < ? AND o0_.widget_id IN ('6ae10f63-c32d-4b17-8d45-88eceee4a9aa')
Parameters:
[
  "2024-11-15 00:00:00"
  "2024-12-15 00:00:00"
]
0.91 ms
(44.90%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.last_login AS last_login_6, t0.roles AS roles_7 FROM widget_user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "a_kotunov@mail.ru"
]

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\WidgetUser
  • The field App\Entity\WidgetUser#availableWidgets is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Widget#widgetUsers does not contain the required 'mappedBy="availableWidgets"' attribute.
App\Entity\Widget
  • The mappings App\Entity\Widget#mailTemplate and App\Entity\MailTemplate#widgets are inconsistent with each other.
  • The mappings App\Entity\Widget#widgetUsers and App\Entity\WidgetUser#widgets are inconsistent with each other.
  • If association App\Entity\Widget#widgetUsers is many-to-many, then the inversed side App\Entity\WidgetUser#widgets has to be many-to-many as well.
App\Entity\HistorySend
  • The mappings App\Entity\HistorySend#order and App\Entity\Order#historySends are inconsistent with each other.
App\Entity\Order
  • The association App\Entity\Order#historySends refers to the owning side field App\Entity\HistorySend#orderId which does not exist.