Query Metrics
5
Database Queries
5
Different statements
11.69 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.price AS price_4, t0.stock AS stock_5, t0.color AS color_6, t0.materials_origin AS materials_origin_7, t0.technical_sheet AS technical_sheet_8, t0.height AS height_9, t0.width AS width_10, t0.depth AS depth_11, t0.kit_content AS kit_content_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.category_id AS category_id_15 FROM product t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"agribac-fruitiers-kit-petit"
]
|
2 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0
Parameters:
[] |
3 | 2.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.thumb AS thumb_3, t0.mime_type AS mime_type_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.product_id AS product_id_7 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3
]
|
4 | 4.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM material t0 INNER JOIN product_materials ON t0.id = product_materials.material_id WHERE product_materials.product_id = ?
Parameters:
[
3
]
|
5 | 3.81 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM `option` t0 INNER JOIN product_options ON t0.id = product_options.option_id WHERE product_options.product_id = ?
Parameters:
[
3
]
|
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\ProductImage | No errors. |
App\Entity\Material | No errors. |
App\Entity\Option | No errors. |