GET https://mathis-ablo.enotelco.com/api/public/products/product-detail/1

Query Metrics

13 Database Queries
11 Different statements
13.32 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.91 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.video AS video_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.supplier_id AS supplier_id_8, t0.sub_category_id AS sub_category_id_9 FROM product t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 1.42 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.size AS size_3, t0.color AS color_4, t0.stock_quantity AS stock_quantity_5, t0.image_base AS image_base_6, t0.is_main AS is_main_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
3 1.58 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.variant_id AS variant_id_5 FROM product_variant_image t0 WHERE t0.variant_id = ?
Parameters:
[
  1
]
4 0.33 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.variant_id AS variant_id_5 FROM product_variant_image t0 WHERE t0.variant_id = ?
Parameters:
[
  2
]
5 0.33 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.variant_id AS variant_id_5 FROM product_variant_image t0 WHERE t0.variant_id = ?
Parameters:
[
  3
]
6 0.52 ms
SELECT t0.id AS id_1, t0.min_quantity AS min_quantity_2, t0.max_quantity AS max_quantity_3, t0.price AS price_4, t0.transit_price AS transit_price_5, t0.customs_price AS customs_price_6, t0.transaction_fees AS transaction_fees_7, t0.delivery_fees AS delivery_fees_8, t0.additional_fees AS additional_fees_9, t0.customs_tier AS customs_tier_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.product_id AS product_id_13 FROM product_price_tier t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
7 1.98 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.product_id AS product_id_4, t0.attribute_value_id AS attribute_value_id_5 FROM product_attribute t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
8 1.20 ms
SELECT AVG(r0_.rating) AS sclr_0, COUNT(r0_.id) AS sclr_1 FROM review r0_ WHERE r0_.product_id = ?
Parameters:
[
  1
]
9 0.72 ms
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.product_id AS product_id_6, t0.user_id AS user_id_7 FROM review t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
10 0.68 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.discout_percentage AS discout_percentage_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.product_id AS product_id_10 FROM special_offer t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
11 0.78 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.description AS description_4, t0.address AS address_5, t0.country AS country_6, t0.site_url AS site_url_7, t0.image AS image_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.user_id AS user_id_11 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.category_id AS category_id_7 FROM sub_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 1.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.