GET https://liver.am/en/heritage/products/20

Query Metrics

65 Database Queries
9 Different statements
101.33 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
82.62 ms
(81.54%)
57
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM product_translation t0 WHERE t0.object_id = ?
Parameters:
[
  20
]
5.54 ms
(5.46%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.min_image AS min_image_4, t0.mini_second_image AS mini_second_image_5, t0.product_description AS product_description_6, t0.type AS type_7, t0.weight AS weight_8, t0.gold AS gold_9, t0.stone AS stone_10, t0.price AS price_11, t0.ref_number AS ref_number_12, t0.category_id AS category_id_13, t0.collection_id AS collection_id_14 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "20"
]
2.64 ms
(2.61%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM collection t0 WHERE t0.id = ?
Parameters:
[
  4
]
2.57 ms
(2.54%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM fixed_pages_translation t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
2.54 ms
(2.51%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM collection_translation t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
2.26 ms
(2.23%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.description AS description_4 FROM fixed_pages t0 WHERE t0.id = ?
Parameters:
[
  4
]
2.21 ms
(2.18%)
1
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  7
]
0.51 ms
(0.50%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.min_image AS min_image_4, t0.mini_second_image AS mini_second_image_5, t0.product_description AS product_description_6, t0.type AS type_7, t0.weight AS weight_8, t0.gold AS gold_9, t0.stone AS stone_10, t0.price AS price_11, t0.ref_number AS ref_number_12, t0.category_id AS category_id_13, t0.collection_id AS collection_id_14 FROM product t0
Parameters:
[]
0.43 ms
(0.42%)
1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM category_translation t0 WHERE t0.object_id = ?
Parameters:
[
  7
]

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.