Query Metrics

7 Database Queries
6 Different statements
1.84 ms Query time
2 Invalid entities

Queries

Group similar statements

admin connection

# Time Info
1 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 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.23 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.22 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.28 ms
SELECT u0_.id AS id_0 FROM p_category p1_ LEFT JOIN upload u0_ ON p1_.upload_id = u0_.id WHERE p1_.id = ? LIMIT 1
Parameters:
[
  "412"
]
2 0.24 ms
SELECT u0_.id AS id_0 FROM p_category p1_ LEFT JOIN upload u0_ ON p1_.upload_id = u0_.id WHERE p1_.id = ? LIMIT 1
Parameters:
[
  "412"
]
3 0.24 ms
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.extension AS extension_2, u0_.mime AS mime_3, u0_.title AS title_4, u0_.short_description AS short_description_5, u0_.description AS description_6, u0_.created AS created_7, u0_.path AS path_8, u0_.original_name AS original_name_9, u0_.width AS width_10, u0_.height AS height_11, u0_.sequence AS sequence_12, u0_.note AS note_13, u0_.icon AS icon_14, u1_.id AS id_15, u1_.name AS name_16, u0_.upload_group_id AS upload_group_id_17, u0_.upload_type_id AS upload_type_id_18 FROM upload u0_ LEFT JOIN upload_type u1_ ON u0_.upload_type_id = u1_.id WHERE u0_.id = ? AND u0_.id = ? ORDER BY u0_.id ASC
Parameters:
[
  4114
  4114
]

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\Upload No errors.
App\Entity\Project\UploadGroup No errors.
App\Entity\Project\Category 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.

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.