GET https://simple-ws.greendot.cz/api/connected-content/category/558/connected-categorySuper

Query Metrics

17 Database Queries
8 Different statements
6.01 ms Query time
2 Invalid entities

Queries

Group similar statements

admin connection

# Time Info
1 0.74 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:
[
  18
]
2 0.38 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:
[
  18
]
3 0.31 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:
[
  26
]
4 0.31 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:
[]
5 0.31 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:
[
  18
]

project connection

# Time Info
1 1.63 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_ LEFT JOIN p_category_category p1_ ON p0_.id = p1_.category_sub_id WHERE p0_.id > 1 AND p0_.is_menu = ? AND p1_.id IS NULL AND p0_.id > 10 ORDER BY p0_.sequence ASC
Parameters:
[
  1
]
2 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:
[
  2136
]
3 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_sub_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  2136
]
4 0.20 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:
[
  2128
]
5 0.23 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:
[
  2128
]
6 0.20 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:
[
  2137
]
7 0.23 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:
[
  2137
]
8 0.20 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:
[
  2129
]
9 0.20 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:
[
  2129
]
10 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_super_id = ? ORDER BY t0.sequence ASC
Parameters:
[
  68
]
11 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:
[
  68
]
12 0.20 ms
SELECT p0_.sequence AS sequence_0, p0_.id AS id_1, p1_.id AS id_2, p1_.name AS name_3 FROM p_category_category p0_ LEFT JOIN p_category p1_ ON p0_.category_super_id = p1_.id WHERE p0_.category_sub_id = ?
Parameters:
[
  558
]

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\CategoryCategory 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\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\MenuType No errors.
App\Entity\Project\SubMenuType 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

No loaded entities.