Query Metrics
21
Database Queries
7
Different statements
3.87 ms
Query time
0
Invalid entities
112
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.63 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.is_admin_active AS is_admin_active_6, t0.is_anonimized AS is_anonimized_7, t0.is_ignore_permission AS is_ignore_permission_8, t0.is_credentials_sent AS is_credentials_sent_9, t0.directory_path AS directory_path_10, t0.one_time_code AS one_time_code_11, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_12, t13.id AS id_14, t13.name AS name_15, t13.surname AS surname_16, t13.image_path AS image_path_17, t13.gender AS gender_18, t13.job AS job_19, t13.address AS address_20, t13.phone AS phone_21, t13.emergency_1 AS emergency_1_22, t13.emergency_2 AS emergency_2_23, t13.user_id AS user_id_24, t25.id AS id_26, t25.tutorial_active AS tutorial_active_27, t25.email_notification_material_request AS email_notification_material_request_28, t25.user_id AS user_id_29 FROM m_o_user t0 LEFT JOIN m_o_user_profile t13 ON t13.user_id = t0.id LEFT JOIN m_o_user_settings t25 ON t25.user_id = t0.id WHERE t0.id = ?
Parameters:
[
"5"
]
|
| 2 | 0.29 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.user_id AS user_id_3, t0.permission_id AS permission_id_4 FROM m_o_jt_user_permission t0 WHERE t0.user_id = ?
Parameters:
[
"5"
]
|
| 3 | 0.15 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
| 4 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
| 5 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
| 6 | 0.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
| 7 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"5"
]
|
| 8 | 0.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
| 9 | 0.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"7"
]
|
| 10 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"8"
]
|
| 11 | 0.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"9"
]
|
| 12 | 0.14 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"10"
]
|
| 13 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"11"
]
|
| 14 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"12"
]
|
| 15 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"13"
]
|
| 16 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"14"
]
|
| 17 | 0.13 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.description AS description_4, t0.priority AS priority_5, t0.category_id AS category_id_6 FROM m_o_permission t0 WHERE t0.id = ?
Parameters:
[
"15"
]
|
| 18 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code_internal AS code_internal_3, t0.code_supplier AS code_supplier_4, t0.code_sale AS code_sale_5, t0.description AS description_6, t0.description_for_customer AS description_for_customer_7, t0.default_price AS default_price_8, t0.supplier_discount AS supplier_discount_9, t0.sell_price AS sell_price_10, t0.datetime_last_price_update AS datetime_last_price_update_11, t0.is_active AS is_active_12, t0.kit AS kit_13, t0.notes AS notes_14, t0.image_path AS image_path_15, t0.category_id AS category_id_16, t0.supplier_id AS supplier_id_17 FROM m_o_product t0 WHERE t0.id = ?
Parameters:
[
"2615"
]
|
| 19 | 0.08 ms |
"START TRANSACTION"
Parameters:
[] |
| 20 | 0.17 ms |
UPDATE m_o_product SET is_active = ? WHERE id = ?
Parameters:
[ 1 "2615" ] |
| 21 | 0.46 ms |
"COMMIT"
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\JTUserPermission | 52 |
| App\Entity\Permission | 52 |
| App\Entity\PermissionCategory | 2 |
| App\Entity\User | 1 |
| App\Entity\UserProfile | 1 |
| App\Entity\UserSettings | 1 |
| App\Entity\Product | 1 |
| App\Entity\ProductCategory | 1 |
| App\Entity\ProductSupplier | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\UserProfile | No errors. |
| App\Entity\UserSettings | No errors. |
| App\Entity\JTUserPermission | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\ProductRequest | No errors. |
| App\Entity\Permission | No errors. |
| App\Entity\PermissionCategory | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\ProductSupplier | No errors. |
| App\Entity\JTProductPerformance | No errors. |
| App\Entity\JTProductKit | No errors. |
| App\Entity\JTCustomerProduct | No errors. |