GET https://www.maleco-officina.it/utente/prodotti/cambia-stato/2615

Query Metrics

21 Database Queries
7 Different statements
3.87 ms Query time
0 Invalid entities
112 Managed entities

Queries

Group similar statements

# 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