PATCH https://simple-ws.greendot.cz/api/categories/158

Query Metrics

17 Database Queries
15 Different statements
8.05 ms Query time
4 Invalid entities

Queries

Group similar statements

admin connection

# Time Info
1 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13 FROM project t0 WHERE t0.id = ?
Parameters:
[
  17
]
2 0.32 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.locale AS locale_2, l0_.is_right_to_left AS is_right_to_left_3, l0_.short AS short_4 FROM language l0_ INNER JOIN language_project l1_ ON l0_.id = l1_.language_id INNER JOIN project p2_ ON l1_.project_id = p2_.id WHERE p2_.id = ? ORDER BY l1_.is_default DESC LIMIT 1
Parameters:
[
  17
]
3 0.30 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.phone AS phone_5, t0.is_greendot AS is_greendot_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  24
]
4 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_test AS uri_test_3, t0.db_name_test AS db_name_test_4, t0.db_user_test AS db_user_test_5, t0.db_password_test AS db_password_test_6, t0.uri_prod AS uri_prod_7, t0.db_name_prod AS db_name_prod_8, t0.db_user_prod AS db_user_prod_9, t0.db_password_prod AS db_password_prod_10, t0.css_path_test AS css_path_test_11, t0.css_path_prod AS css_path_prod_12, t0.deepl_api_key AS deepl_api_key_13 FROM project t0
Parameters:
[]

project connection

# Time Info
1 0.34 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p0_.category_type_id AS category_type_id_18, p0_.upload_id AS upload_id_19 FROM p_category p0_ WHERE p0_.id = ?
Parameters:
[
  158
]
2 0.24 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  158
]
3 0.19 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  158
]
4 0.55 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.html AS html_4, p0_.title AS title_5, p0_.is_active AS is_active_6, p0_.slug AS slug_7, p0_.javascript AS javascript_8, p0_.sequence AS sequence_9, p0_.is_menu AS is_menu_10, p0_.latitude AS latitude_11, p0_.longitude AS longitude_12, p0_.state AS state_13, p0_.has_comments AS has_comments_14, p0_.is_indexable AS is_indexable_15, p0_.created_at AS created_at_16, p0_.published_at AS published_at_17, p1_.id AS id_18, p1_.name AS name_19, l2_.id AS id_20, l2_.name AS name_21, l2_.color AS color_22, c3_.id AS id_23, c3_.name AS name_24, c3_.template AS template_25, c3_.slug_prefix AS slug_prefix_26, u4_.id AS id_27, u4_.name AS name_28, u4_.extension AS extension_29, u4_.mime AS mime_30, u4_.title AS title_31, u4_.short_description AS short_description_32, u4_.description AS description_33, u4_.created AS created_34, u4_.path AS path_35, u4_.original_name AS original_name_36, u4_.width AS width_37, u4_.height AS height_38, u4_.sequence AS sequence_39, u4_.note AS note_40, u4_.icon AS icon_41, c5_.id AS id_42, c5_.sequence AS sequence_43, m6_.id AS id_44, m6_.name AS name_45, m6_.template AS template_46, m6_.controller_name AS controller_name_47, s7_.id AS id_48, s7_.name AS name_49, s7_.template AS template_50, s7_.controller_name AS controller_name_51, p0_.category_type_id AS category_type_id_52, p0_.upload_id AS upload_id_53, p1_.label_type_id AS label_type_id_54, u4_.upload_group_id AS upload_group_id_55, u4_.upload_type_id AS upload_type_id_56, c5_.category_id AS category_id_57, c5_.menu_type_id AS menu_type_id_58 FROM p_category p0_ LEFT JOIN category_label c8_ ON p0_.id = c8_.category_id LEFT JOIN p_label p1_ ON p1_.id = c8_.label_id LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id LEFT JOIN sub_menu_type s7_ ON s7_.id = c9_.sub_menu_type_id WHERE p0_.id = ?
Parameters:
[
  158
]
5 0.17 ms
"START TRANSACTION"
Parameters:
[]
6 0.29 ms
UPDATE p_category SET is_active = ? WHERE id = ?
Parameters:
[
  0
  158
]
7 3.57 ms
"COMMIT"
Parameters:
[]
8 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id = ?
Parameters:
[
  158
]
9 0.26 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_super_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  158
]
10 0.25 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.is_menu_item AS is_menu_item_3, t0.category_super_id AS category_super_id_4, t0.category_sub_id AS category_sub_id_5 FROM p_category_category t0 WHERE t0.category_sub_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  158
]
11 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label_type_id AS label_type_id_3 FROM p_label t0 INNER JOIN category_label ON t0.id = category_label.label_id WHERE category_label.category_id = ?
Parameters:
[
  158
]
12 0.23 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.category_id AS category_id_3, t0.menu_type_id AS menu_type_id_4 FROM category_menu_type t0 WHERE t0.category_id = ?
Parameters:
[
  158
]
13 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = ?
Parameters:
[
  158
]

Database Connections

Name Service
project doctrine.dbal.project_connection
admin doctrine.dbal.admin_connection

Entity Managers

Name Service
project doctrine.orm.project_entity_manager
admin doctrine.orm.admin_entity_manager
other doctrine.orm.other_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

project entity manager

Class Mapping errors
App\Entity\Project\Category No errors.
App\Entity\Project\CategoryType No errors.
App\Entity\Project\Upload No errors.
App\Entity\Project\Label
  • The association App\Entity\Project\Label#products refers to the owning side field App\Entity\Project\Product#labels which does not exist.
App\Entity\Project\CategoryFile No errors.
App\Entity\Project\CategoryCategory No errors.
App\Entity\Project\Parameter No errors.
App\Entity\Project\CategoryProduct No errors.
App\Entity\Project\CategoryPerson
  • The association App\Entity\Project\CategoryPerson#Person refers to the inverse side field App\Entity\Project\Person#categoryPeople which does not exist.
App\Entity\Project\CategoryEvent No errors.
App\Entity\Project\CategoryUploadGroup No errors.
App\Entity\Project\CategoryParamGroup No errors.
App\Entity\Project\CategoryMenuType No errors.
App\Entity\Project\SubMenuType No errors.
App\Entity\Project\MenuType No errors.
App\Entity\Project\LabelType No errors.
App\Entity\Project\UploadGroup No errors.
App\Entity\Project\UploadType No errors.
App\Entity\Project\Product
  • The mappings App\Entity\Project\Product#productUploadGroup and App\Entity\Project\ProductUploadGroup#Product are inconsistent with each other.
App\Entity\Project\ProductVariant No errors.
App\Entity\Project\Producer No errors.
App\Entity\Project\Person
  • The mappings App\Entity\Project\Person#category and App\Entity\Project\CategoryPerson#Person are inconsistent with each other.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.

admin entity manager

Class Mapping errors
App\Entity\Admin\Project No errors.
App\Entity\Admin\User No errors.
App\Entity\Admin\Permission No errors.
App\Entity\Admin\LanguageProject No errors.
App\Entity\Admin\Language No errors.
App\Entity\Admin\Role No errors.

other entity manager

Class Mapping errors
App\Entity\Project\Category No errors.