https://www.demoshop.to2facil.com/api/v1/product?limit=8&random=true&related=product_166_202502080032

Query Metrics

3 Database Queries
3 Different statements
14.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.42 ms
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:
[]
2 13.29 ms
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"
]
3 0.69 ms
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"
]

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