Query Metrics
44
Database Queries
11
Different statements
120.54 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
59.26 ms (49.16%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0 WHERE t0.id = ?
Parameters:
[
1
]
|
55.12 ms (45.73%) |
22 |
SELECT count(a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id LEFT JOIN category2 c2_ ON c1_.category2_id = c2_.id WHERE a0_.enabled = 1 AND c1_.title = ? AND c2_.title = ?
Parameters:
[ "Ordinateur portable" "Ordinateurs" ] |
1.91 ms (1.58%) |
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0 WHERE t0.category2_id = ?
Parameters:
[
1
]
|
1.01 ms (0.84%) |
1 |
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id WHERE a0_.enabled = 1 AND c1_.is_active = 1 AND a0_.reduction > 0
Parameters:
[] |
0.95 ms (0.79%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0
Parameters:
[] |
0.49 ms (0.41%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.category3_id AS category3_id_5 FROM category2 t0
Parameters:
[] |
0.47 ms (0.39%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.quantity AS quantity_8, t0.buying_price AS buying_price_9, t0.etat AS etat_10, t0.qty_reel AS qty_reel_11, t0.label AS label_12, t0.reduction AS reduction_13, t0.status AS status_14, t0.ref AS ref_15, t0.detail AS detail_16, t0.category_id AS category_id_17, t0.brand_id AS brand_id_18 FROM article t0 WHERE t0.enabled = ? AND t0.etat = ? LIMIT 12
Parameters:
[ 1 "top" ] |
0.46 ms (0.38%) |
1 |
SELECT DISTINCT a0_.id AS id_0 FROM article a0_ LEFT JOIN category c1_ ON a0_.category_id = c1_.id WHERE a0_.enabled = 1 AND c1_.is_active = 1 AND a0_.reduction > 0 LIMIT 24
Parameters:
[] |
0.31 ms (0.26%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0
Parameters:
[] |
0.29 ms (0.24%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.slug AS slug_4, t0.category2_id AS category2_id_5 FROM category t0 WHERE t0.title IS NULL LIMIT 1
Parameters:
[] |
0.26 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.icon AS icon_4 FROM category3 t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Article | No errors. |
App\Entity\Category | No errors. |
App\Entity\Brand | No errors. |
App\Entity\Category2 | No errors. |
App\Entity\Category3 | No errors. |