GET https://lemdu.pink/product/1

Query Metrics

9 Database Queries
4 Different statements
1.98 ms Query time
0 Invalid entities
4 Managed entities
0 Cache hits
1 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.pk = ?
Parameters:
[
  "1"
]
2 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.pk AS pk_4, t0.product_id AS product_id_5 FROM parameter t0 WHERE t0.product_id = ?
Parameters:
[
  1
]
3 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.pk AS pk_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.parent AS parent_6 FROM category t0 WHERE t0.id = ?
Parameters:
[
  13
]
4 0.43 ms
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.parent_id = ? ORDER BY p0_.id ASC
Parameters:
[
  "1"
]
5 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.pk AS pk_4, t0.product_id AS product_id_5 FROM parameter t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
6 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.pk AS pk_4, t0.product_id AS product_id_5 FROM parameter t0 WHERE t0.product_id = ?
Parameters:
[
  3
]
7 0.09 ms
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.parent_id = ? ORDER BY p0_.id ASC
Parameters:
[
  "1"
]
8 0.04 ms
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.pk = ?
Parameters:
[
  "1"
]
9 0.03 ms
SELECT p0_.id AS id_0, p0_.active AS active_1, p0_.description AS description_2, p0_.keywords AS keywords_3, p0_.name AS name_4, p0_.image AS image_5, p0_.thumbnail AS thumbnail_6, p0_.pk AS pk_7, p0_.template AS template_8, p0_.salable AS salable_9, p0_.in_stock AS in_stock_10, p0_.price_min AS price_min_11, p0_.price_max AS price_max_12, p0_.virtual_product AS virtual_product_13, p0_.purchaseable AS purchaseable_14, p0_.category_id AS category_id_15, p0_.parent_id AS parent_id_16 FROM product p0_ WHERE p0_.pk = ?
Parameters:
[
  "1"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

0 Hits
1 Misses
0 Puts

Number of cache misses

Region Misses
app_entity_category 1

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product 3
App\Entity\Category 1

Entities Mapping

Class Mapping errors
App\Entity\Product No errors.
App\Entity\Category No errors.
App\Entity\Parameter No errors.