GET https://apka.adamow.gmina.pl/api/category?extended=1

Query Metrics

48 Database Queries
5 Different statements
6.84 ms Query time
3 Invalid entities
99 Managed entities

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.name_hash AS name_hash_2, o0_.user_name AS user_name_3, o0_.user_name_hash AS user_name_hash_4, o0_.password AS password_5, o0_.token AS token_6, o0_.api_type AS api_type_7, o0_.base_url AS base_url_8, o0_.api_key AS api_key_9, o0_.status AS status_10, o0_.channel AS channel_11, o0_.short_name AS short_name_12 FROM outside_system o0_ WHERE o0_.user_name_hash = ?
Parameters:
[
  "0df29046a9d59c5039e39d69a53a3ae3daafba896e13724d6edeaf842ab88d095f5d9bfc9b3d77252e7934637e374c83710e15766f3512703f1531685471cd95"
]
2 0.28 ms
SELECT t0.category_id AS category_id_1, t0.category_name AS category_name_2, t0.category_desc AS category_desc_3, t0.category_type AS category_type_4, t0.category_theme AS category_theme_5, t0.category_priority AS category_priority_6, t0.category_option AS category_option_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_email_notification AS category_email_notification_10, t0.created_by AS created_by_11, t0.outside_system_created_by_id AS outside_system_created_by_id_12 FROM category t0
Parameters:
[]
3 0.99 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  1
]
4 0.24 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  1
  "mainphoto"
]
5 0.30 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  2
]
6 0.63 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.11 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  14
]
8 0.08 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.07 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  5
]
10 0.11 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  6
]
11 0.08 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  7
]
12 0.09 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  8
]
13 0.07 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  9
]
14 0.07 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  10
]
15 0.07 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  11
]
16 0.07 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  12
]
17 0.14 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  2
  "mainphoto"
]
18 0.10 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  3
]
19 0.13 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  3
  "mainphoto"
]
20 0.11 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  4
]
21 0.13 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  4
  "mainphoto"
]
22 0.11 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  5
]
23 0.09 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  3
]
24 0.07 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  4
]
25 0.08 ms
SELECT t0.id AS id_1, t0.category_type AS category_type_2, t0.short_name AS short_name_3, t0.label AS label_4, t0.field_type AS field_type_5, t0.form_field_type AS form_field_type_6, t0.form_field_required AS form_field_required_7, t0.dict AS dict_8 FROM category_params t0 WHERE t0.id = ?
Parameters:
[
  13
]
26 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  5
  "mainphoto"
]
27 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  6
]
28 0.11 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  6
  "mainphoto"
]
29 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  7
]
30 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  7
  "mainphoto"
]
31 0.10 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  8
]
32 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  8
  "mainphoto"
]
33 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  9
]
34 0.11 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  9
  "mainphoto"
]
35 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  10
]
36 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  10
  "mainphoto"
]
37 0.09 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  11
]
38 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  11
  "mainphoto"
]
39 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  12
]
40 0.13 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  12
  "mainphoto"
]
41 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  13
]
42 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  13
  "mainphoto"
]
43 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  14
]
44 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  14
  "mainphoto"
]
45 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  15
]
46 0.11 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  15
  "mainphoto"
]
47 0.08 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.category AS category_3, t0.category_param AS category_param_4 FROM category_values t0 WHERE t0.category = ?
Parameters:
[
  16
]
48 0.12 ms
SELECT te.file_id AS file_id, te.fid AS fid, te.file_type AS file_type, te.file_name AS file_name, te.file_label AS file_label, te.file_desc AS file_desc, te.file_size AS file_size, te.file_ext AS file_ext, te.file_link AS file_link, te.file_created_at AS file_created_at, te.file_tmp_status AS file_tmp_status, te.file_width AS file_width, te.file_height AS file_height, te.file_blurhash AS file_blurhash, te.file_mime_type AS file_mime_type, te.file_original_name AS file_original_name FROM file te JOIN category_to_file t ON t.file_id = te.file_id WHERE t.category_id = ? AND te.file_type = ?
Parameters:
[
  16
  "mainphoto"
]

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\Category\CategoryValues 68
App\Entity\Category\Category 16
App\Entity\Category\CategoryParams 14
App\Entity\Integration\OutsideSystem 1

Entities Mapping

Class Mapping errors
App\Entity\Integration\OutsideSystem No errors.
App\Entity\Enums\OutsideSystemServiceStatus No errors.
App\Entity\Integration\OutsideSystemService No errors.
App\Entity\Integration\UserToOutsideSystem No errors.
App\Entity\Widget No errors.
App\Entity\Category\Category No errors.
App\Entity\Enums\UserStatus No errors.
App\Entity\User\User
  • The association App\Entity\User\User#queuePushes refers to the owning side field App\Entity\Queue\QueuePush#user which does not exist.
  • The mappings App\Entity\User\User#visitSchedulerReservationsAppended and App\Entity\VisitScheduler\VisitSchedulerReservation#appendedTo are inconsistent with each other.
App\Entity\Enums\ContentStatus No errors.
App\Entity\Content\Content No errors.
App\Entity\User\UserMobDeviceToCategory No errors.
App\Entity\Notice No errors.
App\Entity\File No errors.
App\Entity\Partner\PartnerAddress
  • The association App\Entity\Partner\PartnerAddress#itemLimits refers to the owning side field App\Entity\Card\CardItemLimit#partnerAddresses which does not exist.
App\Entity\Category\CategoryValues No errors.
App\Entity\Enums\PartnerStatus No errors.
App\Entity\Partner\Partner No errors.
App\Entity\Enums\SiteStatus No errors.
App\Entity\Site\Site
  • The association App\Entity\Site\Site#parent refers to the inverse side field App\Entity\Site\Site#children which does not exist.
App\Entity\Category\CategoryParams No errors.