Query Metrics
13
Database Queries
13
Different statements
16.16 ms
Query time
5
Invalid entities
Grouped Statements
admin connection
Time▼ | Count | Info |
---|---|---|
0.32 ms (1.97%) |
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.31 ms (1.95%) |
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.23 ms (1.41%) |
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.21 ms (1.29%) |
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 |
---|---|---|
13.21 ms (81.74%) |
1 |
"COMMIT"
Parameters:
[] |
0.35 ms (2.17%) |
1 |
SELECT i0_.id AS id_0, i0_.name AS name_1, i0_.title AS title_2, i0_.text AS text_3, i0_.is_active AS is_active_4, i0_.is_reusable AS is_reusable_5, i0_.state AS state_6, i1_.id AS id_7, i1_.name AS name_8, i1_.template AS template_9, c2_.id AS id_10, c2_.sequence AS sequence_11, p3_.id AS id_12, p3_.sequence AS sequence_13, e4_.id AS id_14, e4_.sequence AS sequence_15, p5_.id AS id_16, p5_.sequence AS sequence_17, i0_.information_block_type_id AS information_block_type_id_18, c2_.information_block_id AS information_block_id_19, c2_.category_id AS category_id_20, p3_.information_block_id AS information_block_id_21, p3_.product_id AS product_id_22, e4_.information_block_id AS information_block_id_23, e4_.event_id AS event_id_24, p5_.information_block_id AS information_block_id_25, p5_.person_id AS person_id_26 FROM information_block i0_ LEFT JOIN information_block_type i1_ ON i0_.information_block_type_id = i1_.id LEFT JOIN category_information_block c2_ ON i0_.id = c2_.information_block_id LEFT JOIN product_information_block p3_ ON i0_.id = p3_.information_block_id LEFT JOIN event_information_block e4_ ON i0_.id = e4_.information_block_id LEFT JOIN person_information_block p5_ ON i0_.id = p5_.information_block_id WHERE i0_.id = ?
Parameters:
[
125
]
|
0.24 ms (1.49%) |
1 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.event_id AS event_id_4 FROM event_information_block t0 WHERE t0.information_block_id = ?
Parameters:
[
125
]
|
0.24 ms (1.46%) |
1 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.category_id AS category_id_4 FROM category_information_block t0 WHERE t0.information_block_id = ?
Parameters:
[
125
]
|
0.23 ms (1.42%) |
1 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.person_id AS person_id_4 FROM person_information_block t0 WHERE t0.information_block_id = ?
Parameters:
[
125
]
|
0.23 ms (1.41%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.text AS text_4, t0.is_active AS is_active_5, t0.is_reusable AS is_reusable_6, t0.state AS state_7, t0.information_block_type_id AS information_block_type_id_8 FROM information_block t0 WHERE t0.id = ?
Parameters:
[
125
]
|
0.22 ms (1.39%) |
1 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.information_block_id AS information_block_id_3, t0.product_id AS product_id_4 FROM product_information_block t0 WHERE t0.information_block_id = ?
Parameters:
[
125
]
|
0.21 ms (1.33%) |
1 |
UPDATE information_block SET is_active = ? WHERE id = ?
Parameters:
[ 0 125 ] |
0.16 ms (1.00%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\InformationBlock |
|
App\Entity\Project\InformationBlockType |
|
App\Entity\Project\CategoryInformationBlock | No errors. |
App\Entity\Project\ProductInformationBlock | No errors. |
App\Entity\Project\EventInformationBlock | No errors. |
App\Entity\Project\PersonInformationBlock | No errors. |
App\Entity\Project\Category | No errors. |
App\Entity\Project\Product |
|
App\Entity\Project\Event | 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
Class | Mapping errors |
---|---|
App\Entity\Project\InformationBlock |
|