Query Metrics
164
Database Queries
9
Different statements
30.87 ms
Query time
0
Invalid entities
1576
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.69 ms (28.15%) |
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"
]
|
|
8.37 ms (27.10%) |
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.40 ms (23.97%) |
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"
]
|
|
3.36 ms (10.89%) |
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.23 ms (3.99%) |
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.85 ms (2.74%) |
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.37 ms (1.19%) |
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.35 ms (1.14%) |
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.26 ms (0.83%) |
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 |
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. |
| App\Entity\JTCustomerSupplier | No errors. |
| App\Entity\Performance | No errors. |