GET http://sch.ener.ru/price_requests

Query Metrics

4 Database Queries
4 Different statements
4.95 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.70 ms
(34.40%)
1
SELECT price_request_id AS id, COUNT(id) AS total, MIN(price) AS min_price, MAX(price) AS max_price FROM trade.price_request_answer WHERE price_request_id IN (?) GROUP BY price_request_id
Parameters:
[
  "85dbf9ad-345c-4c78-8910-b23f4533ee78"
]
1.60 ms
(32.32%)
1
SELECT id, name, parent_id FROM goods.category
Parameters:
[]
0.90 ms
(18.26%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.is_archive AS is_archive_5, t0.date_add AS date_add_6, t0.end_date AS end_date_7, t0.items_count AS items_count_8, t0.payload AS payload_9, t0.category_id AS category_id_10, t0.owner_id AS owner_id_11 FROM goods.price_request t0
Parameters:
[]
0.74 ms
(15.02%)
1
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.surname AS surname_2, p0_.patronymic AS patronymic_3, p0_.gender AS gender_4, p0_.birthdate AS birthdate_5, p0_.email AS email_6, p0_.phone AS phone_7, p0_.avatar AS avatar_8, p0_.user_id AS user_id_9 FROM account.person p0_ WHERE p0_.user_id = ?
Parameters:
[
  Ramsey\Uuid\Lazy\LazyUuidFromString {#846
    __toString(): "b19cf6bf-4799-4796-aa11-ee31467761cd"
  }
]

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\Goods\PriceRequest No errors.
App\Entity\Goods\Category
  • The field App\Entity\Goods\Category#manufacturers is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Dictionary\Manufacturer#categories does not contain the required 'mappedBy="manufacturers"' attribute.
App\Entity\Account\User No errors.
App\Entity\Account\Person No errors.