Query Metrics
10
Database Queries
6
Different statements
1.48 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.47 ms |
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_logo_id AS brand_logo_id_3 FROM brand t0
Parameters:
[] |
| 2 | 0.12 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
Parameters:
[] |
| 3 | 0.22 ms |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.image_product_id INNER JOIN `condition` c2_ ON p0_.product_condition_id = c2_.id INNER JOIN model m3_ ON p0_.product_model_id = m3_.id INNER JOIN brand b4_ ON m3_.model_brand_id = b4_.id WHERE (i1_.id IN (SELECT MIN(i5_.id) AS sclr_1 FROM product p6_ LEFT JOIN image i5_ ON p6_.id = i5_.image_product_id WHERE i5_.image_product_id = p0_.id) OR i1_.id IS NULL) AND p0_.product_quantity > 0 AND b4_.id = ?
Parameters:
[
2
]
|
| 4 | 0.11 ms |
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.image_product_id INNER JOIN `condition` c2_ ON p0_.product_condition_id = c2_.id INNER JOIN model m3_ ON p0_.product_model_id = m3_.id INNER JOIN brand b4_ ON m3_.model_brand_id = b4_.id WHERE (i1_.id IN (SELECT MIN(i5_.id) AS sclr_1 FROM product p6_ LEFT JOIN image i5_ ON p6_.id = i5_.image_product_id WHERE i5_.image_product_id = p0_.id) OR i1_.id IS NULL) AND p0_.product_quantity > 0 AND b4_.id = ? LIMIT 12
Parameters:
[
2
]
|
| 5 | 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:
[] |
| 6 | 0.09 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
]
|
| 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:
[
1
]
|
| 8 | 0.06 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
]
|
| 9 | 0.06 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
]
|
| 10 | 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:
[] |
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\Brand | No errors. |
| App\Entity\BrandLogo | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\Condition | No errors. |