Query Metrics
3
Database Queries
3
Different statements
14.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.29 ms (92.29%) |
1 |
SELECT DISTINCT count(DISTINCT d0_.id) AS sclr_0 FROM d_product d0_ LEFT JOIN r_related_product r2_ ON d0_.id = r2_.product_source LEFT JOIN d_product d1_ ON d1_.id = r2_.product_target LEFT JOIN r_related_product r4_ ON d0_.id = r4_.product_target LEFT JOIN d_product d3_ ON d3_.id = r4_.product_source WHERE d0_.active = 1 AND (d0_.slug <> ? AND (d1_.slug = ? OR d3_.slug = ?))
Parameters:
[ "product_166_202502080032" "product_166_202502080032" "product_166_202502080032" ] |
|
0.69 ms (4.80%) |
1 |
SELECT DISTINCT d0_.id AS id_0, d0_.id AS id_1 FROM d_product d0_ LEFT JOIN r_related_product r2_ ON d0_.id = r2_.product_source LEFT JOIN d_product d1_ ON d1_.id = r2_.product_target LEFT JOIN r_related_product r4_ ON d0_.id = r4_.product_target LEFT JOIN d_product d3_ ON d3_.id = r4_.product_source WHERE d0_.active = 1 AND (d0_.slug <> ? AND (d1_.slug = ? OR d3_.slug = ?)) ORDER BY d0_.id DESC LIMIT 8
Parameters:
[ "product_166_202502080032" "product_166_202502080032" "product_166_202502080032" ] |
|
0.42 ms (2.90%) |
1 |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.value AS value_3, t0.type AS type_4 FROM s_setting 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\Setting | No errors. |
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
| App\Entity\RefreshToken | No errors. |
| App\Entity\Product | No errors. |