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

Query Metrics

8 Database Queries
5 Different statements
7.82 ms Query time
1 Invalid entities
33 Managed entities

Queries

Group similar statements

# Time Info
1 3.17 ms
SELECT DISTINCT id_7 FROM (SELECT o0_.name AS name_0, o0_.product_size AS product_size_1, o0_.measurement_unit_coeff AS measurement_unit_coeff_2, o0_.pack_size AS pack_size_3, o0_.product_weight AS product_weight_4, o0_.product_features AS product_features_5, o0_.updated_at AS updated_at_6, o0_.id AS id_7, o0_.deleted_at AS deleted_at_8 FROM offers o0_ WHERE (o0_.deleted_at IS NULL)) dctrn_result LIMIT 25
Parameters:
[]
2 1.80 ms
SELECT o0_.name AS name_0, o0_.product_size AS product_size_1, o0_.measurement_unit_coeff AS measurement_unit_coeff_2, o0_.pack_size AS pack_size_3, o0_.product_weight AS product_weight_4, o0_.product_features AS product_features_5, o0_.updated_at AS updated_at_6, o0_.id AS id_7, o0_.deleted_at AS deleted_at_8, o0_.product_id AS product_id_9, o0_.main_measurement_id AS main_measurement_id_10, o0_.additional_measurement_id AS additional_measurement_id_11 FROM offers o0_ WHERE (o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (o0_.deleted_at IS NULL)
Parameters:
[
  "0010b65a-cf5b-4d96-9a80-623a9c0dc873"
  "00d47030-57e2-40eb-9be5-4f5d4cdb998f"
  "0105b309-7c6f-4e4a-b1fe-dfbf4a5cac6f"
  "01084ba3-2914-41d1-9ff3-57d922b39782"
  "01676cbb-23ed-4b7b-bf58-86b5e0693e43"
  "024c7113-c915-4376-a93a-d1fe6d0cb5fb"
  "040953ae-ddbc-4a46-b4c7-7339c0c1a712"
  "053d3e4c-9f7f-408f-b0d2-cc0eb7cb9bfb"
  "058a4165-8a85-4ce6-bf8e-eb33423e8b49"
  "075f5b9d-72ed-44ba-afbe-e3b40ab42d06"
  "077a4584-394a-43f0-8226-bbde6d3ae2b2"
  "07eddcce-3530-4fb8-bfd7-dfebe2ad12ca"
  "0857de06-0832-4df5-bee6-4a06a4fe263f"
  "0a28a583-a3af-4eba-af1e-8601edb5102b"
  "0cb6838f-ab0d-4c65-ba38-507ffabd3bf9"
  "0eb98bab-c895-484a-adbf-dd645f9d2753"
  "0fa53a1a-8ea5-4589-b5d8-7b12b31d3f60"
  "12e2f005-fb16-4cbf-8d35-0835c830dd2f"
  "14d04d07-465d-4793-96e8-6f185598d245"
  "15ba49f7-0b15-49b5-8543-799826054f98"
  "185bbbc7-0a03-4ee4-bf5d-585784ae1da0"
  "1bd6a092-d947-4ed2-a958-953ef0620cb7"
  "208f7087-6aa6-42a6-8351-ac89a53e535b"
  "23828a8a-1d2c-44aa-b814-39854465c6c4"
  "23923444-9ef1-4e2a-849f-e92b9373d33b"
]
3 1.18 ms
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.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "5153e619-86e3-481f-8743-c36a5dfb45c5"
]
4 0.57 ms
SELECT t0.name AS name_1, t0.short_name AS short_name_2, t0.dimension AS dimension_3, t0.coefficient AS coefficient_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.deleted_at AS deleted_at_7 FROM measurements t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "7b7711ab-79cd-48b7-8928-2242aabba34a"
]
5 0.21 ms
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.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "9b75f464-cf66-4042-a94d-cdeda4f92220"
]
6 0.17 ms
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.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "ddded8b0-1ac9-423b-a78c-a14605b8a26b"
]
7 0.28 ms
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.product_type_id AS product_type_id_5, t0.brand_id AS brand_id_6 FROM products t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "e4b6d9ba-b559-4fc8-b468-f192817f9b92"
]
8 0.45 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_7 FROM (SELECT o0_.name AS name_0, o0_.product_size AS product_size_1, o0_.measurement_unit_coeff AS measurement_unit_coeff_2, o0_.pack_size AS pack_size_3, o0_.product_weight AS product_weight_4, o0_.product_features AS product_features_5, o0_.updated_at AS updated_at_6, o0_.id AS id_7, o0_.deleted_at AS deleted_at_8 FROM offers o0_ WHERE (o0_.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\Offer 25
App\Offer\Entity\Product 4
App\Brand\Entity\Brand 2
App\Measurement\Entity\MeasurementUnit 1
App\ProductType\Entity\ProductType 1

Entities Mapping

Class Mapping errors
App\Offer\Entity\Offer No errors.
App\Offer\Entity\Product No errors.
App\Measurement\Entity\MeasurementUnit
  • The field 'App\Measurement\Entity\MeasurementUnit#coefficient' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\ProductType\Entity\ProductType No errors.
App\Brand\Entity\Brand No errors.