GET https://topavi.dracoder.com/api/distributor/cart

Query Metrics

8 Database Queries
5 Different statements
4.24 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.51 ms
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"
]
2 0.43 ms
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:
[
  "0240b712-e479-415d-b0c2-d0cf22341736"
]
3 0.59 ms
SELECT c0_.id AS id_0, c0_.status AS status_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.user_id AS user_id_4 FROM cart c0_ WHERE c0_.user_id = ? AND c0_.status = ?
Parameters:
[
  "0240b712-e479-415d-b0c2-d0cf22341736"
  "Active"
]
4 0.61 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ?
Parameters:
[
  "255de1be-7785-42c0-ac54-09907d2bd298"
]
5 0.68 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price_including_vat AS price_including_vat_5, t0.featured AS featured_6, t0.price AS price_7, t0.currency AS currency_8, t0.vat_rate AS vat_rate_9, t0.enabled AS enabled_10, t0.stock AS stock_11, t0.image_path AS image_path_12, t0.show_title AS show_title_13, t0.show_content AS show_content_14, t0.imported AS imported_15, t0.imported_code AS imported_code_16, t0.is_set AS is_set_17, t0.obsolete AS obsolete_18, t0.visibility_role AS visibility_role_19, t0.metadata AS metadata_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.plan_path AS plan_path_25, t23.exploded_path AS exploded_path_26, t23.assembly_path AS assembly_path_27, t23.extra_info AS extra_info_28, t23.created_at AS created_at_29, t23.updated_at AS updated_at_30, t23.product_id AS product_id_31 FROM products t0 LEFT JOIN set_details t23 ON t23.product_id = t0.id WHERE t0.id = ?
Parameters:
[
  "960083bf-02c2-57f8-a85a-68c1b4812819"
]
6 0.53 ms
SELECT t0.id AS id_1, t0.sku AS sku_2, t0.name AS name_3, t0.description AS description_4, t0.price_including_vat AS price_including_vat_5, t0.featured AS featured_6, t0.price AS price_7, t0.currency AS currency_8, t0.vat_rate AS vat_rate_9, t0.enabled AS enabled_10, t0.stock AS stock_11, t0.image_path AS image_path_12, t0.show_title AS show_title_13, t0.show_content AS show_content_14, t0.imported AS imported_15, t0.imported_code AS imported_code_16, t0.is_set AS is_set_17, t0.obsolete AS obsolete_18, t0.visibility_role AS visibility_role_19, t0.metadata AS metadata_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t23.id AS id_24, t23.plan_path AS plan_path_25, t23.exploded_path AS exploded_path_26, t23.assembly_path AS assembly_path_27, t23.extra_info AS extra_info_28, t23.created_at AS created_at_29, t23.updated_at AS updated_at_30, t23.product_id AS product_id_31 FROM products t0 LEFT JOIN set_details t23 ON t23.product_id = t0.id WHERE t0.id = ?
Parameters:
[
  "a8f579c3-8a21-52f0-a0c4-be78289d78dc"
]
7 0.57 ms
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:
[
  "960083bf-02c2-57f8-a85a-68c1b4812819"
]
8 0.32 ms
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:
[
  "a8f579c3-8a21-52f0-a0c4-be78289d78dc"
]

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\User 2
App\Entity\CartItem 2
App\Entity\Product 2
App\Entity\ProductTranslation 2
App\Entity\Cart 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Cart No errors.
App\Entity\CartItem No errors.
App\Entity\Product No errors.
App\Entity\SetDetail No errors.
App\Entity\ProductRelation No errors.
App\Entity\ProductImage No errors.
App\Entity\Category No errors.
App\Entity\ProductTranslation No errors.
App\Entity\ProductLibrary No errors.