Query Metrics

66 Database Queries
9 Different statements
11.40 ms Query time
0 Invalid entities
232 Managed entities

Grouped Statements

Show all queries

Time Count Info
7.49 ms
(65.64%)
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"
]
1.01 ms
(8.84%)
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.86 ms
(7.56%)
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 AND m0_.code_internal LIKE ? ORDER BY m0_.datetime_last_price_update DESC
Parameters:
[
  "%M798000079%"
]
0.83 ms
(7.31%)
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.36 ms
(3.15%)
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.31 ms
(2.75%)
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.22 ms
(1.92%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM m_o_product_supplier t0 ORDER BY t0.name ASC
Parameters:
[]
0.17 ms
(1.46%)
1
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:
[
  "2316"
]
0.16 ms
(1.38%)
1
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:
[
  "2316"
]

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\ProductCategory 83
App\Entity\JTUserPermission 53
App\Entity\Permission 53
App\Entity\ProductSupplier 31
App\Entity\PermissionCategory 8
App\Entity\User 1
App\Entity\UserProfile 1
App\Entity\UserSettings 1
App\Entity\Product 1