Query Metrics
145
Database Queries
4
Different statements
62.83 ms
Query time
0
Invalid entities
1738
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
28.29 ms (45.03%) |
71 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.mark AS mark_3, t0.source AS source_4, t0.imported AS imported_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.product_id AS product_id_8, t0.related_id AS related_id_9 FROM product_relations t0 WHERE t0.product_id = ?
Parameters:
[
"94a04d22-c484-5a9b-8236-e3be9aca8b44"
]
|
||||||||||||||||||||||||||||
|
24.81 ms (39.48%) |
71 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.description AS description_4, t0.short_description AS short_description_5, t0.keywords AS keywords_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.product_id AS product_id_9 FROM product_translations t0 WHERE t0.product_id = ?
Parameters:
[
"94a04d22-c484-5a9b-8236-e3be9aca8b44"
]
|
||||||||||||||||||||||||||||
|
8.68 ms (13.82%) |
1 |
SELECT p0_.id AS id_0, p0_.sku AS sku_1, p0_.name AS name_2, p0_.description AS description_3, p0_.price_including_vat AS price_including_vat_4, p0_.featured AS featured_5, p0_.price AS price_6, p0_.currency AS currency_7, p0_.vat_rate AS vat_rate_8, p0_.enabled AS enabled_9, p0_.stock AS stock_10, p0_.image_path AS image_path_11, p0_.show_title AS show_title_12, p0_.show_content AS show_content_13, p0_.imported AS imported_14, p0_.imported_code AS imported_code_15, p0_.is_set AS is_set_16, p0_.obsolete AS obsolete_17, p0_.visibility_role AS visibility_role_18, p0_.metadata AS metadata_19, p0_.created_at AS created_at_20, p0_.updated_at AS updated_at_21, s1_.id AS id_22, s1_.plan_path AS plan_path_23, s1_.exploded_path AS exploded_path_24, s1_.assembly_path AS assembly_path_25, s1_.extra_info AS extra_info_26, s1_.created_at AS created_at_27, s1_.updated_at AS updated_at_28, m2_.id AS id_29, m2_.sku AS sku_30, m2_.name AS name_31, m2_.description AS description_32, m2_.visibility_role AS visibility_role_33, m2_.plan_path AS plan_path_34, m2_.exploded_path AS exploded_path_35, m2_.manual_path AS manual_path_36, m2_.created_at AS created_at_37, m2_.updated_at AS updated_at_38, c3_.id AS id_39, c3_.category_usage AS category_usage_40, c3_.created_at AS created_at_41, c3_.updated_at AS updated_at_42, c4_.id AS id_43, c4_.locale AS locale_44, c4_.name AS name_45, c4_.created_at AS created_at_46, c4_.updated_at AS updated_at_47, s1_.product_id AS product_id_48, c3_.parent_id AS parent_id_49, c4_.category_id AS category_id_50 FROM products p0_ LEFT JOIN set_details s1_ ON p0_.id = s1_.product_id LEFT JOIN set_detail_machine s5_ ON s1_.id = s5_.set_detail_id LEFT JOIN machines m2_ ON m2_.id = s5_.machine_id LEFT JOIN category_product c6_ ON p0_.id = c6_.product_id LEFT JOIN categories c3_ ON c3_.id = c6_.category_id LEFT JOIN category_translations c4_ ON c3_.id = c4_.category_id WHERE p0_.enabled = 1 AND p0_.is_set = 1 AND s1_.plan_path IS NOT NULL ORDER BY p0_.name ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
|
1.05 ms (1.67%) |
2 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.name AS name_4, t0.surname AS surname_5, t0.roles AS roles_6, t0.mobile_phone AS mobile_phone_7, t0.address AS address_8, t0.city AS city_9, t0.zip_code AS zip_code_10, t0.state AS state_11, t0.country AS country_12, t0.price_modifier AS price_modifier_13, t0.password AS password_14, t0.reset_password_token AS reset_password_token_15, t0.locale AS locale_16, t0.double_factor_method AS double_factor_method_17, t0.auth_code AS auth_code_18, t0.google_authenticator_secret AS google_authenticator_secret_19, t0.disabled_at AS disabled_at_20, t0.last_login_at AS last_login_at_21, t0.last_login_ip AS last_login_ip_22, t0.previous_login_at AS previous_login_at_23, t0.previous_login_ip AS previous_login_ip_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26 FROM users t0 WHERE t0.id = ?
Parameters:
[
"e1d213a7-a827-410f-8a36-623e68f7991b"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| legacy | doctrine.dbal.legacy_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\ProductRelation | 998 |
| App\Entity\Product | 535 |
| App\Entity\SetDetail | 71 |
| App\Entity\ProductTranslation | 71 |
| App\Entity\Category | 28 |
| App\Entity\CategoryTranslation | 25 |
| App\Entity\Machine | 8 |
| App\Entity\User | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\SetDetail | No errors. |
| App\Entity\Machine | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\CategoryTranslation | No errors. |
| App\Entity\ProductRelation | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\ProductTranslation | No errors. |
| App\Entity\ProductLibrary | No errors. |
| App\Entity\SetDetailBalloon | No errors. |
| App\Entity\SetDetailLine | No errors. |
| App\Entity\SetDetailImage | No errors. |
| App\Entity\MachineLibrary | No errors. |
| App\Entity\MachineImage | No errors. |
| App\Entity\MachineTranslation | No errors. |
| App\Entity\MachineProductRelation | No errors. |