Query Metrics
12
Database Queries
6
Different statements
1.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.69 ms (38.71%) |
3 |
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:
[] |
|
0.37 ms (20.77%) |
4 |
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.25 ms (13.69%) |
2 |
SELECT t0.id AS id_1, t0.condition_title AS condition_title_2 FROM `condition` t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.20 ms (11.19%) |
1 |
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:
[] |
|
0.17 ms (9.52%) |
1 |
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, i1_.id AS id_10, i1_.image_name AS image_name_11, p0_.product_condition_id AS product_condition_id_12, p0_.product_category_id AS product_category_id_13, p0_.product_model_id AS product_model_id_14, i1_.image_product_id AS image_product_id_15 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 MAX(i5_.id) AS sclr_16 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 ORDER BY p0_.product_added_date DESC LIMIT 6
Parameters:
[] |
|
0.11 ms (6.12%) |
1 |
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:
[] |
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. |
| App\Entity\Category | No errors. |
| App\Entity\OrderItem | No errors. |
| App\Entity\Tag | No errors. |