Query Metrics
10
Database Queries
6
Different statements
1.87 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.77 ms |
SELECT p0_.id AS id_0, p0_.product_reference AS product_reference_1, p0_.product_name AS product_name_2, p0_.product_description AS product_description_3, p0_.product_price AS product_price_4, p0_.product_quantity AS product_quantity_5, p0_.product_added_date AS product_added_date_6, p0_.product_year AS product_year_7, p0_.product_km AS product_km_8, p0_.product_weight AS product_weight_9, p0_.product_condition_id AS product_condition_id_10, p0_.product_category_id AS product_category_id_11, p0_.product_model_id AS product_model_id_12 FROM product p0_ INNER JOIN `condition` c1_ ON p0_.product_condition_id = c1_.id INNER JOIN model m2_ ON p0_.product_model_id = m2_.id INNER JOIN brand b3_ ON m2_.model_brand_id = b3_.id WHERE p0_.id = ?
Parameters:
[
8
]
|
| 2 | 0.33 ms |
SELECT i0_.id AS id_0, i0_.image_name AS image_name_1, i0_.image_product_id AS image_product_id_2 FROM image i0_ WHERE i0_.image_product_id = ? ORDER BY i0_.id ASC
Parameters:
[
8
]
|
| 3 | 0.17 ms |
SELECT b0_.id AS id_0, b0_.brand_name AS brand_name_1, b0_.brand_logo_id AS brand_logo_id_2 FROM brand b0_ INNER JOIN brand_logo b1_ ON b0_.brand_logo_id = b1_.id
Parameters:
[] |
| 4 | 0.13 ms |
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 5 | 0.10 ms |
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 6 | 0.07 ms |
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 7 | 0.07 ms |
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 8 | 0.09 ms |
SELECT b0_.id AS id_0, b0_.brand_name AS brand_name_1, b0_.brand_logo_id AS brand_logo_id_2 FROM brand b0_ INNER JOIN brand_logo b1_ ON b0_.brand_logo_id = b1_.id
Parameters:
[] |
| 9 | 0.09 ms |
SELECT t0.id AS id_1, t0.model_name AS model_name_2, t0.model_brand_id AS model_brand_id_3 FROM model t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 10 | 0.07 ms |
SELECT t0.id AS id_1, t0.condition_title AS condition_title_2 FROM `condition` t0 WHERE t0.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\Condition | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Brand | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\BrandLogo | No errors. |