Query Metrics
7
Database Queries
6
Different statements
1.84 ms
Query time
2
Invalid entities
Grouped Statements
admin connection
Time▼ | Count | Info |
---|---|---|
0.32 ms (17.57%) |
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.31 ms (17.03%) |
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
]
|
0.23 ms (12.69%) |
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.22 ms (11.82%) |
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:
[] |
project connection
Time▼ | Count | Info |
---|---|---|
0.52 ms (28.09%) |
2 |
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"
]
|
0.24 ms (12.80%) |
1 |
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 |
|
App\Entity\Project\ProductVariant | No errors. |
App\Entity\Project\Producer | No errors. |
App\Entity\Project\Person |
|
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.