Query Metrics
5
Database Queries
5
Different statements
2.56 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.74 ms (28.78%) |
1 |
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-grand"
]
|
0.57 ms (22.22%) |
1 |
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:
[
1
]
|
0.45 ms (17.65%) |
1 |
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:
[
1
]
|
0.44 ms (17.29%) |
1 |
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:
[
1
]
|
0.36 ms (14.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0
Parameters:
[] |
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. |