Query Metrics

55 Database Queries
4 Different statements
32.86 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
20.49 ms
(62.37%)
34
SELECT t0.created_at AS created_at_1, t0.canceled_at AS canceled_at_2, t0.transmission_time AS transmission_time_3, t0.phone AS phone_4, t0.car_brand AS car_brand_5, t0.car_model AS car_model_6, t0.car_vin AS car_vin_7, t0.town_name AS town_name_8, t0.comment AS comment_9, t0.confirmed AS confirmed_10, t0.deprecated_order_id AS deprecated_order_id_11, t0.id AS id_12, t0.customer_id AS customer_id_13, t0.user_id AS user_id_14, t0.mango_call_id AS mango_call_id_15, t0.order_id AS order_id_16 FROM leads__leads t0 WHERE t0.mango_call_id = ?
Parameters:
[
  26745
]
8.84 ms
(26.89%)
17
SELECT t0.created_at AS created_at_1, t0.phone AS phone_2, t0.first_name AS first_name_3, t0.sure_name AS sure_name_4, t0.father_name AS father_name_5, t0.farpost_login AS farpost_login_6, t0.email AS email_7, t0.mango_contact_id AS mango_contact_id_8, t0.id AS id_9, t0.user_id AS user_id_10 FROM customers__customers t0 WHERE t0.id = ?
Parameters:
[
  6733
]
1.82 ms
(5.52%)
1
SELECT m0_.created_at AS created_at_0, m0_.phone AS phone_1, m0_.sip_id AS sip_id_2, m0_.recording_id AS recording_id_3, m0_.status AS status_4, m0_.duration AS duration_5, m0_.direction AS direction_6, m0_.missed_status AS missed_status_7, m0_.id AS id_8, m0_.updated AS updated_9, m0_.manager_id AS manager_id_10, m0_.customer_id AS customer_id_11 FROM mango__calls m0_ WHERE m0_.created_at BETWEEN ? AND ? ORDER BY m0_.created_at DESC
Parameters:
[
  "2025-04-16 00:00:00"
  "2025-04-16 23:59:00"
]
1.71 ms
(5.22%)
3
SELECT t0.created_at AS created_at_1, t0.visible AS visible_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.father_name AS father_name_5, t0.mango_extension_number AS mango_extension_number_6, t0.id AS id_7, t0.user_id AS user_id_8 FROM managers t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\User
  • The field App\Entity\User#roles is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserRole#user does not contain the required 'inversedBy="roles"' attribute.
  • The field App\Entity\User#manager is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Manager#user does not contain the required 'inversedBy="manager"' attribute.
App\Entity\MangoCall
  • The field App\Entity\MangoCall#lead is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Lead#mangoCall does not contain the required 'inversedBy="lead"' attribute.
App\Entity\Manager No errors.
App\Entity\Customer
  • The field App\Entity\Customer#garages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CustomerGarage#customer does not contain the required 'inversedBy="garages"' attribute.
App\Entity\Lead No errors.
App\Entity\Order
  • The field App\Entity\Order#elements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\OrderElement#order does not contain the required 'inversedBy="elements"' attribute.
  • The field App\Entity\Order#sberbankAcquiringOrders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SberbankAcquiringOrder#order does not contain the required 'inversedBy="sberbankAcquiringOrders"' attribute.
App\Entity\CustomerGarage No errors.