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

Query Metrics

4 Database Queries
4 Different statements
6.61 ms Query time
1 Invalid entities
26 Managed entities

Queries

Group similar statements

# Time Info
1 4.46 ms
SELECT DISTINCT id_4, MIN(sclr_6) AS dctrn_minrownum FROM (SELECT f0_.name AS name_0, f0_.description AS description_1, f0_.feature_type AS feature_type_2, f0_.updated_at AS updated_at_3, f0_.id AS id_4, f0_.deleted_at AS deleted_at_5, ROW_NUMBER() OVER(ORDER BY f0_.name ASC) AS sclr_6 FROM features f0_ WHERE (f0_.deleted_at IS NULL)) dctrn_result GROUP BY id_4 ORDER BY dctrn_minrownum ASC LIMIT 25
Parameters:
[]
2 0.74 ms
SELECT f0_.name AS name_0, f0_.description AS description_1, f0_.feature_type AS feature_type_2, f0_.updated_at AS updated_at_3, f0_.id AS id_4, f0_.deleted_at AS deleted_at_5, f0_.measure_id AS measure_id_6 FROM features f0_ WHERE (f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (f0_.deleted_at IS NULL) ORDER BY f0_.name ASC
Parameters:
[
  "8382c713-351d-4280-804f-6e2e7a4cbc47"
  "6d4a6603-7d27-4dec-89a8-7ec46514a6b4"
  "32df988a-84bd-42c8-95a7-0550dcfc9d08"
  "21890105-8daf-43fa-8797-9a16b522d5aa"
  "b58291f1-2054-48cb-b30b-2f319e2a794d"
  "36a9d45a-2ae7-40ea-952f-9fb2f7e6084a"
  "3ae54da6-cc4e-427a-bc42-7646bdab1fc2"
  "6fbb8d8e-1a21-4950-af8b-6d7c94381627"
  "9200032a-b614-4744-9351-5fe435a52ffe"
  "2a1ee5e0-35d1-423a-95c5-e61b6b507534"
  "24444f3e-9cef-4481-a246-e5e62ce263bd"
  "c64a718d-6a42-41e6-8082-574a35988c7b"
  "8e4293cf-7b95-438e-8919-4786f5900522"
  "fb86a0c8-9a8c-4769-aaec-89def85d534b"
  "445592b2-4730-41c9-848e-3e1d8467061e"
  "6ea69ce3-d4a1-4f8d-bdd0-f310471cefd0"
  "59121cf4-c1c3-4d5a-909d-1bae34bed6fe"
  "472d76c4-9b8f-4c5f-8bc3-45d0295f0f4a"
  "d58ab81d-3afc-4771-9748-eae031b75209"
  "28ca4365-c7a9-4149-93e8-3ddf20ce4a6b"
  "a798994d-5a15-43ca-8215-c26d0852bca1"
  "529f0b26-c1c7-44f5-9577-31d036bd2aa8"
  "5eb88e97-d1eb-4ffc-b3e9-f12e4a2cec31"
  "a0bbacd8-0696-4622-b443-d0a46c2245bd"
  "ac9749ab-4750-4ac2-8a21-222aedc08d93"
]
3 0.83 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:
[
  "43cb657e-1a94-43f2-a41c-9e3cfa48f463"
]
4 0.58 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (SELECT f0_.name AS name_0, f0_.description AS description_1, f0_.feature_type AS feature_type_2, f0_.updated_at AS updated_at_3, f0_.id AS id_4, f0_.deleted_at AS deleted_at_5 FROM features f0_ WHERE (f0_.deleted_at IS NULL) ORDER BY f0_.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\Feature\Entity\Feature 25
App\Measurement\Entity\MeasurementUnit 1

Entities Mapping

Class Mapping errors
App\Feature\Entity\Feature 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.