GET https://2025-mu.release.sb.paritet.sprintf.ru/product

Query Metrics

8 Database Queries
5 Different statements
6.46 ms Query time
1 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.75 ms
(42.48%)
1
SELECT DISTINCT id_2 FROM (SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3 FROM products p0_ WHERE (p0_.deleted_at IS NULL)) dctrn_result LIMIT 25
Parameters:
[]
1.75 ms
(27.10%)
4
SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4 FROM brands t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "38c2aff8-e10b-47e5-b1d9-d99053c27d6d"
]
1.27 ms
(19.58%)
1
SELECT t0.name AS name_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.group_id AS group_id_5 FROM product_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "8c80145a-9115-43cf-ad43-016638beeeba"
]
0.35 ms
(5.47%)
1
SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3, p0_.product_type_id AS product_type_id_4, p0_.brand_id AS brand_id_5 FROM products p0_ WHERE (p0_.id IN (?, ?, ?, ?, ?, ?, ?)) AND (p0_.deleted_at IS NULL)
Parameters:
[
  "1df45d75-bf6a-458a-86bb-aab2d770c9d7"
  "3576bf0c-7daa-4a0f-8b40-777a44f3ae9d"
  "37758d8c-f1e3-4349-b3d6-890d9303f44e"
  "5153e619-86e3-481f-8743-c36a5dfb45c5"
  "9b75f464-cf66-4042-a94d-cdeda4f92220"
  "ddded8b0-1ac9-423b-a78c-a14605b8a26b"
  "e4b6d9ba-b559-4fc8-b468-f192817f9b92"
]
0.35 ms
(5.37%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT p0_.name AS name_0, p0_.updated_at AS updated_at_1, p0_.id AS id_2, p0_.deleted_at AS deleted_at_3 FROM products p0_ WHERE (p0_.deleted_at IS NULL)) dctrn_result) dctrn_table
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Offer\Entity\Product 7
App\Brand\Entity\Brand 4
App\ProductType\Entity\ProductType 1
App\ProductType\Entity\ProductTypeGroup 1

Entities Mapping

Class Mapping errors
App\Offer\Entity\Product No errors.
App\ProductType\Entity\ProductType No errors.
App\Brand\Entity\Brand No errors.
App\ProductType\Entity\ProductTypeGroup
  • The field App\ProductType\Entity\ProductTypeGroup#productTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\ProductType\Entity\ProductType#group does not contain the required 'inversedBy="productTypes"' attribute.