GET https://topavi.dracoder.com/api/distributor/product/exploded-views

Query Metrics

145 Database Queries
4 Different statements
62.83 ms Query time
0 Invalid entities
1738 Managed entities

Grouped Statements

Show all queries

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