GET https://medmis-api-new.itlabs.top/api/entry/list?title=

Query Metrics

52 Database Queries
2 Different statements
4.57 ms Query time
0 Invalid entities
1936 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.75 ms
SELECT s0_.id AS id_0, s0_.external_id AS external_id_1, s0_.name AS name_2, s0_.price AS price_3, s0_.code AS code_4, s0_.duration AS duration_5, s0_.type_name AS type_name_6, s0_.is_active AS is_active_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.category_id AS category_id_10 FROM service s0_ WHERE s0_.is_active = ?
Parameters:
[
  1
]
2 0.11 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  116
]
3 0.10 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  77
]
4 0.08 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  150
]
5 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  19
]
6 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  171
]
7 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  114
]
8 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  33
]
9 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  101
]
10 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  84
]
11 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  160
]
12 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  74
]
13 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  107
]
14 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  106
]
15 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  119
]
16 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  118
]
17 0.08 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  34
]
18 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  157
]
19 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  64
]
20 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  167
]
21 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  125
]
22 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  27
]
23 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  128
]
24 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  28
]
25 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  56
]
26 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  155
]
27 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  168
]
28 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  130
]
29 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  120
]
30 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  80
]
31 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  38
]
32 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  166
]
33 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  132
]
34 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  66
]
35 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  70
]
36 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  105
]
37 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  153
]
38 0.06 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  96
]
39 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  104
]
40 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  117
]
41 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  62
]
42 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  88
]
43 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  89
]
44 0.08 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  90
]
45 0.07 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  93
]
46 0.09 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  94
]
47 0.08 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  92
]
48 0.08 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  91
]
49 0.18 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  52
]
50 0.08 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  133
]
51 0.09 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  78
]
52 0.11 ms
SELECT t0.id AS id_1, t0.external_id AS external_id_2, t0.name AS name_3, t0.image AS image_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.parent_id AS parent_id_8 FROM service_category t0 WHERE t0.id = ?
Parameters:
[
  165
]

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\Service 1885
App\Entity\ServiceCategory 51

Entities Mapping

Class Mapping errors
App\Entity\Service No errors.
App\Entity\ServiceCategory No errors.