Query Metrics
5
Database Queries
5
Different statements
1.78 ms
Query time
0
Invalid entities
Grouped Statements
admin connection
Time▼ | Count | Info |
---|---|---|
0.46 ms (25.60%) |
1 |
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
]
|
0.32 ms (17.73%) |
1 |
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
]
|
0.32 ms (17.73%) |
1 |
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:
[] |
0.30 ms (16.95%) |
1 |
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
]
|
project connection
Time▼ | Count | Info |
---|---|---|
0.39 ms (22.00%) |
1 |
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:
[
13
]
|
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\CategoryCategory | No errors. |
App\Entity\Project\Category | 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.