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

Query Metrics

4 Database Queries
4 Different statements
36.58 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 1.47 ms
SELECT a0_.name AS name_0, a0_.type AS type_1, a0_.updated_at AS updated_at_2, a0_.id AS id_3, a0_.deleted_at AS deleted_at_4 FROM assortment_plans a0_
Parameters:
[]
2 23.20 ms
SELECT DISTINCT id_0, MIN(sclr_2) AS dctrn_minrownum FROM (SELECT a0_.id AS id_0, a0_.source_id AS source_id_1, ROW_NUMBER() OVER(ORDER BY a1_.name ASC, a0_.assortment_plan_id ASC) AS sclr_2 FROM assortment_plan_offers a0_ LEFT JOIN assortment_plans a1_ ON a0_.assortment_plan_id = a1_.id) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 25
Parameters:
[]
3 1.05 ms
SELECT a0_.id AS id_0, a0_.source_id AS source_id_1, a0_.assortment_plan_id AS assortment_plan_id_2 FROM assortment_plan_offers a0_ LEFT JOIN assortment_plans a1_ ON a0_.assortment_plan_id = a1_.id WHERE a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a1_.name ASC, a0_.assortment_plan_id ASC
Parameters:
[
  "dcdf4989-dae2-4c12-9fe3-c8896fed8ad6"
  "727b30a7-ec27-491b-967e-429307beda45"
  "2a4101e1-aa10-4709-83bc-a77931c4cffd"
  "dafb23ca-a7f0-47cc-a64d-c3558688ada9"
  "5a1abedf-7f42-4249-9499-cde173d4d7ff"
  "f1b4eadb-a541-4daa-8583-d000c9c0ec21"
  "4d2fb67a-52ad-4934-a50e-7f54ab6c9bdf"
  "96f1833b-75de-4f99-a28b-29755b3bd6c6"
  "57096ee5-2e3a-4bef-8488-80c2357bd9b5"
  "db897fe6-b2cc-4b2b-b7a8-07e9900dcfa7"
  "38ca57ee-920c-4e05-a59c-37a4dd04fe47"
  "a39f5b45-3e32-4bf6-aaa4-05c1437a05d7"
  "7ae6307b-347b-468d-a36b-d9ccaad18c9a"
  "8da4d1b1-9b50-4bae-9ae2-7f8a716f9d14"
  "fcc48552-e1ba-4746-8ee3-7f71b707d16a"
  "4226ba92-67f7-4e4a-afec-d38a2b7e6af5"
  "42dd4692-73fa-465d-9936-a73f862a8e96"
  "54ffc636-ffd9-412e-9c60-8f69e7ecca25"
  "0eba3f30-c0e7-44ce-b379-2be004363630"
  "94a34730-1b68-4982-8533-199e0ac34af7"
  "97999686-6762-4f6b-aad2-0ee568d95c77"
  "13240b4d-0be6-4c95-bf43-d87d89ee2cea"
  "489e6100-33a1-4ff2-bed3-8512586288b9"
  "f146eec2-e75b-4100-8044-38a7b69a2b80"
  "efc00d34-e110-43c9-9f2a-15c1475fb275"
]
4 10.86 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.source_id AS source_id_1 FROM assortment_plan_offers a0_ LEFT JOIN assortment_plans a1_ ON a0_.assortment_plan_id = a1_.id ORDER BY a1_.name ASC, a0_.assortment_plan_id ASC) 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\AssortmentPlan\Entity\AssortmentPlanOffer 25
App\AssortmentPlan\Entity\AssortmentPlan 3

Entities Mapping