Query Metrics
65
Database Queries
9
Different statements
83.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
57.65 ms (69.24%) |
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:
[
10
]
|
|
11.22 ms (13.48%) |
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:
[
"10"
]
|
|
6.26 ms (7.51%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM category t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
3.43 ms (4.12%) |
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:
[
3
]
|
|
1.89 ms (2.27%) |
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
]
|
|
1.25 ms (1.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.74 ms (0.89%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3 FROM collection t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.50 ms (0.60%) |
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.33 ms (0.40%) |
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
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Collection | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Translation\ProductTranslation | No errors. |
| App\Entity\FixedPages | No errors. |
| App\Entity\Translation\FixedPagesTranslation | No errors. |
| App\Entity\Translation\CategoryTranslation | No errors. |
| App\Entity\Translation\CollectionTranslation | No errors. |