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

Query Metrics

3 Database Queries
3 Different statements
5.61 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 4.36 ms
SELECT DISTINCT id_2, MIN(sclr_4) AS dctrn_minrownum FROM (SELECT b0_.name AS name_0, b0_.updated_at AS updated_at_1, b0_.id AS id_2, b0_.deleted_at AS deleted_at_3, ROW_NUMBER() OVER(ORDER BY b0_.name ASC) AS sclr_4 FROM brands b0_ WHERE (b0_.deleted_at IS NULL)) dctrn_result GROUP BY id_2 ORDER BY dctrn_minrownum ASC LIMIT 25
Parameters:
[]
2 0.48 ms
SELECT b0_.name AS name_0, b0_.updated_at AS updated_at_1, b0_.id AS id_2, b0_.deleted_at AS deleted_at_3 FROM brands b0_ WHERE (b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (b0_.deleted_at IS NULL) ORDER BY b0_.name ASC
Parameters:
[
  "e915d3dc-fc5f-4033-844b-8d1037b6c0d1"
  "63606e53-f84a-44cf-b8a4-a12b09e6e2f0"
  "b0620ca1-c27a-4a39-8aed-a260a8667b6e"
  "9e98a24f-0624-4dde-b741-d471bdca97f7"
  "97693faa-f30b-4769-a5b5-893dd7ac27d8"
  "ccc9ab7d-7a57-4f5b-8b88-b152fee0aa46"
  "2c2408b1-c5c3-4df9-9bd6-e0382a8d0a2b"
  "382a914e-a8f4-423e-b860-58ef5c3feeec"
  "f0450121-db34-4c43-b81e-246f7661cde5"
  "62ff3b03-3ae1-41aa-a7cd-38fda09971af"
  "1d7e4a44-bede-408c-97fb-ebe016c26ebd"
  "26f88ab3-1300-426d-8f45-f9fb99fde114"
  "191aa723-f937-4cc9-855d-0622a8718772"
  "dd0785a6-fad1-4f20-ac5a-1405aac6a721"
  "49a52c32-d2a9-4f13-aef3-780532774f7f"
  "876523e1-0571-49b0-8a02-794d58344643"
  "d533607a-5e8c-4742-a9c3-019c2ee0f6e6"
  "85cf5d35-f015-4c2f-95c4-88d22256ca3a"
  "6e4ca28f-588a-4622-81e3-1623b922015b"
  "316447cc-fad7-44a1-b528-fda78b3f9ffd"
  "47db032d-c787-4bf8-88c7-fec504b0a54b"
  "43426c3a-65ca-43f9-8df6-7112f3a662a7"
  "2ac6d4b9-cf02-42aa-aa1a-d10baed46390"
  "2853dde7-0cbe-44e2-9c0a-0a262a912cab"
  "0798fa03-e4e1-4d30-b37e-848ab545f1c1"
]
3 0.77 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_2 FROM (SELECT b0_.name AS name_0, b0_.updated_at AS updated_at_1, b0_.id AS id_2, b0_.deleted_at AS deleted_at_3 FROM brands b0_ WHERE (b0_.deleted_at IS NULL) ORDER BY b0_.name 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\Brand\Entity\Brand 25

Entities Mapping

Class Mapping errors
App\Brand\Entity\Brand No errors.