Query Metrics
17
Database Queries
15
Different statements
8.05 ms
Query time
4
Invalid entities
Queries
admin connection
#▲ | Time | Info |
---|---|---|
1 | 0.28 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.30 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.27 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.34 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_ WHERE p0_.id = ?
Parameters:
[
158
]
|
2 | 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_super_id = ? ORDER BY t0.sequence ASC
Parameters:
[
158
]
|
3 | 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:
[
158
]
|
4 | 0.55 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, p1_.id AS id_18, p1_.name AS name_19, l2_.id AS id_20, l2_.name AS name_21, l2_.color AS color_22, c3_.id AS id_23, c3_.name AS name_24, c3_.template AS template_25, c3_.slug_prefix AS slug_prefix_26, u4_.id AS id_27, u4_.name AS name_28, u4_.extension AS extension_29, u4_.mime AS mime_30, u4_.title AS title_31, u4_.short_description AS short_description_32, u4_.description AS description_33, u4_.created AS created_34, u4_.path AS path_35, u4_.original_name AS original_name_36, u4_.width AS width_37, u4_.height AS height_38, u4_.sequence AS sequence_39, u4_.note AS note_40, u4_.icon AS icon_41, c5_.id AS id_42, c5_.sequence AS sequence_43, m6_.id AS id_44, m6_.name AS name_45, m6_.template AS template_46, m6_.controller_name AS controller_name_47, s7_.id AS id_48, s7_.name AS name_49, s7_.template AS template_50, s7_.controller_name AS controller_name_51, p0_.category_type_id AS category_type_id_52, p0_.upload_id AS upload_id_53, p1_.label_type_id AS label_type_id_54, u4_.upload_group_id AS upload_group_id_55, u4_.upload_type_id AS upload_type_id_56, c5_.category_id AS category_id_57, c5_.menu_type_id AS menu_type_id_58 FROM p_category p0_ LEFT JOIN category_label c8_ ON p0_.id = c8_.category_id LEFT JOIN p_label p1_ ON p1_.id = c8_.label_id LEFT JOIN label_type l2_ ON p1_.label_type_id = l2_.id LEFT JOIN category_type c3_ ON p0_.category_type_id = c3_.id LEFT JOIN upload u4_ ON p0_.upload_id = u4_.id LEFT JOIN category_menu_type c5_ ON p0_.id = c5_.category_id LEFT JOIN menu_type m6_ ON c5_.menu_type_id = m6_.id LEFT JOIN category_sub_menu_type c9_ ON p0_.id = c9_.category_id LEFT JOIN sub_menu_type s7_ ON s7_.id = c9_.sub_menu_type_id WHERE p0_.id = ?
Parameters:
[
158
]
|
5 | 0.17 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 0.29 ms |
UPDATE p_category SET is_active = ? WHERE id = ?
Parameters:
[ 0 158 ] |
7 | 3.57 ms |
"COMMIT"
Parameters:
[] |
8 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_name AS menu_name_3, t0.description AS description_4, t0.html AS html_5, t0.title AS title_6, t0.is_active AS is_active_7, t0.slug AS slug_8, t0.javascript AS javascript_9, t0.sequence AS sequence_10, t0.is_menu AS is_menu_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.state AS state_14, t0.has_comments AS has_comments_15, t0.is_indexable AS is_indexable_16, t0.created_at AS created_at_17, t0.published_at AS published_at_18, t0.category_type_id AS category_type_id_19, t0.upload_id AS upload_id_20 FROM p_category t0 WHERE t0.id = ?
Parameters:
[
158
]
|
9 | 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:
[
158
]
|
10 | 0.25 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:
[
158
]
|
11 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.label_type_id AS label_type_id_3 FROM p_label t0 INNER JOIN category_label ON t0.id = category_label.label_id WHERE category_label.category_id = ?
Parameters:
[
158
]
|
12 | 0.23 ms |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.category_id AS category_id_3, t0.menu_type_id AS menu_type_id_4 FROM category_menu_type t0 WHERE t0.category_id = ?
Parameters:
[
158
]
|
13 | 0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.template AS template_3, t0.controller_name AS controller_name_4 FROM sub_menu_type t0 INNER JOIN category_sub_menu_type ON t0.id = category_sub_menu_type.sub_menu_type_id WHERE category_sub_menu_type.category_id = ?
Parameters:
[
158
]
|
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\CategoryType | No errors. |
App\Entity\Project\Upload | No errors. |
App\Entity\Project\Label |
|
App\Entity\Project\CategoryFile | No errors. |
App\Entity\Project\CategoryCategory | No errors. |
App\Entity\Project\Parameter | No errors. |
App\Entity\Project\CategoryProduct | No errors. |
App\Entity\Project\CategoryPerson |
|
App\Entity\Project\CategoryEvent | No errors. |
App\Entity\Project\CategoryUploadGroup | No errors. |
App\Entity\Project\CategoryParamGroup | No errors. |
App\Entity\Project\CategoryMenuType | No errors. |
App\Entity\Project\SubMenuType | No errors. |
App\Entity\Project\MenuType | No errors. |
App\Entity\Project\LabelType | No errors. |
App\Entity\Project\UploadGroup | 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 |
|
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry | No errors. |
Gedmo\Loggable\Entity\LogEntry | No errors. |
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation | No errors. |
Gedmo\Translatable\Entity\Translation | 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
Class | Mapping errors |
---|---|
App\Entity\Project\Category | No errors. |