GET https://www.maleco-officina.it/utente/prodotti/lista

Query Metrics

164 Database Queries
9 Different statements
29.95 ms Query time
0 Invalid entities
1576 Managed entities

Grouped Statements

Show all queries

Time Count Info
8.64 ms
(28.84%)
50
SELECT t0.id AS id_1, t0.total_price AS total_price_2, t0.quantity AS quantity_3, t0.assembled_quantity AS assembled_quantity_4, t0.notes AS notes_5, t0.is_replacement AS is_replacement_6, t0.product_id AS product_id_7, t0.performance_id AS performance_id_8 FROM m_o_jt_product_performance t0 WHERE t0.product_id = ?
Parameters:
[
  "2554"
]
7.92 ms
(26.44%)
50
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.parent_product_id AS parent_product_id_3, t0.child_product_id AS child_product_id_4 FROM m_o_jt_product_kit t0 WHERE t0.parent_product_id = ?
Parameters:
[
  "2554"
]
7.16 ms
(23.92%)
53
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"
]
3.38 ms
(11.27%)
1
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.code_internal AS code_internal_2, m0_.code_supplier AS code_supplier_3, m0_.code_sale AS code_sale_4, m0_.description AS description_5, m0_.description_for_customer AS description_for_customer_6, m0_.default_price AS default_price_7, m0_.supplier_discount AS supplier_discount_8, m0_.sell_price AS sell_price_9, m0_.datetime_last_price_update AS datetime_last_price_update_10, m0_.is_active AS is_active_11, m0_.kit AS kit_12, m0_.notes AS notes_13, m0_.image_path AS image_path_14, m0_.category_id AS category_id_15, m0_.supplier_id AS supplier_id_16 FROM m_o_product m0_ LEFT JOIN m_o_product_category m1_ ON m0_.category_id = m1_.id LEFT JOIN m_o_product_supplier m2_ ON m0_.supplier_id = m2_.id WHERE 1 = 1 ORDER BY m0_.datetime_last_price_update DESC
Parameters:
[]
1.10 ms
(3.67%)
6
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3, t0.priority AS priority_4 FROM m_o_permission_category t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.77 ms
(2.56%)
1
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:
[
  "11"
]
0.41 ms
(1.37%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM m_o_product_category t0 ORDER BY t0.name ASC
Parameters:
[]
0.37 ms
(1.24%)
1
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:
[
  "11"
]
0.21 ms
(0.69%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM m_o_product_supplier t0 ORDER BY t0.name ASC
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\Product 1340
App\Entity\ProductCategory 83
App\Entity\JTUserPermission 53
App\Entity\Permission 53
App\Entity\ProductSupplier 31
App\Entity\PermissionCategory 8
App\Entity\JTProductKit 5
App\Entity\User 1
App\Entity\UserProfile 1
App\Entity\UserSettings 1