GET http://stoptysk.gp.gov.ua/

Query Metrics

13 Database Queries
6 Different statements
5.75 ms Query time
0 Invalid entities
113 Managed entities

Queries

Group similar statements

# Time Info
1 0.97 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.is_text_value AS is_text_value_3, d0_.created_at AS created_at_4, d0_.deleted_at AS deleted_at_5 FROM dictionary__agency d0_ WHERE d0_.is_active = ?
Parameters:
[
  1
]
2 0.47 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.prosecutor_office AS prosecutor_office_2, d0_.emails AS emails_3, d0_.is_active AS is_active_4, d0_.created_at AS created_at_5, d0_.deleted_at AS deleted_at_6 FROM dictionary__region d0_ WHERE d0_.is_active = ?
Parameters:
[
  1
]
3 0.42 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.created_at AS created_at_3, d0_.deleted_at AS deleted_at_4 FROM dictionary__industry d0_ WHERE d0_.is_active = ?
Parameters:
[
  1
]
4 0.41 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.is_active AS is_active_2, d0_.created_at AS created_at_3, d0_.deleted_at AS deleted_at_4 FROM dictionary__legal_form d0_ WHERE d0_.is_active = ?
Parameters:
[
  1
]
5 0.65 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_active AS is_active_2, c0_.created_at AS created_at_3, c0_.deleted_at AS deleted_at_4, c0_.order_num AS order_num_5 FROM claim__type c0_ WHERE c0_.is_active = ? ORDER BY c0_.order_num ASC
Parameters:
[
  1
]
6 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "862985d3-5bbc-4197-9a9b-71a770d8a912"
]
7 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "d7bb04e4-e4be-4a9c-9e75-09ca38df91b2"
]
8 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "df63ab1e-98f0-41c5-b610-3bd7b6e99be9"
]
9 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "5ceeeb09-632b-4c50-b195-04d07fc8eac0"
]
10 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "fdaefd66-f9e0-433d-8452-c22be249b892"
]
11 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "9fedb174-02d7-44d5-a4e0-f69ab7fafae2"
]
12 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "a33a3502-855f-40af-9283-7c9e7e8f56c6"
]
13 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.is_text_value AS is_text_value_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6, t0.order_num AS order_num_7, t0.type_id AS type_id_8 FROM claim__type_category t0 WHERE t0.type_id = ? ORDER BY t0.order_num ASC
Parameters:
[
  "953c02b0-94af-4f0e-94a6-851928566e04"
]

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\Entity\Claim\TypeCategory 33
App\Entity\Dictionary\Region 26
App\Entity\Dictionary\LegalForm 24
App\Entity\Dictionary\Industry 16
App\Entity\Claim\Type 8
App\Entity\Dictionary\Agency 6