GET https://liver.am/ru/heritage/products/60

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
78.19 ms
(83.51%)
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:
[
  60
]
5.31 ms
(5.67%)
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
]
3.99 ms
(4.26%)
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:
[
  "60"
]
2.75 ms
(2.94%)
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
]
1.51 ms
(1.61%)
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:
[
  1
]
0.70 ms
(0.74%)
1
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.59 ms
(0.62%)
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.33 ms
(0.35%)
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
]
0.27 ms
(0.29%)
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
]

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.