Query Metrics

10 Database Queries
6 Different statements
4.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.product_name AS product_name_2, t0.qtt AS qtt_3, t0.prix AS prix_4, t0.publish_item AS publish_item_5, t0.promo AS promo_6, t0.description AS description_7, t0.publish_date AS publish_date_8, t0.sale_price AS sale_price_9, t0.cost_price AS cost_price_10, t0.date_production AS date_production_11, t0.date_expiration AS date_expiration_12, t0.category_id AS category_id_13, t0.user_id AS user_id_14, t0.magasin_id AS magasin_id_15 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  "58"
]
2 1.68 ms
SELECT t0.id AS id_1, t0.size AS size_2, t0.color AS color_3, t0.prix AS prix_4, t0.qtt AS qtt_5, t0.produit_id AS produit_id_6, t0.param_color_id AS param_color_id_7, t0.param_size_id AS param_size_id_8 FROM produit_variant t0 WHERE t0.produit_id = ?
Parameters:
[
  58
]
3 0.57 ms
SELECT t0.id AS id_1, t0.size_name AS size_name_2, t0.size_abreviation AS size_abreviation_3 FROM param_size t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 0.22 ms
SELECT t0.id AS id_1, t0.size_name AS size_name_2, t0.size_abreviation AS size_abreviation_3 FROM param_size t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.45 ms
SELECT t0.id AS id_1, t0.color_code AS color_code_2, t0.color_name AS color_name_3 FROM param_color t0 WHERE t0.id = ?
Parameters:
[
  16
]
6 0.24 ms
SELECT t0.id AS id_1, t0.color_code AS color_code_2, t0.color_name AS color_name_3 FROM param_color t0 WHERE t0.id = ?
Parameters:
[
  17
]
7 0.22 ms
SELECT t0.id AS id_1, t0.color_code AS color_code_2, t0.color_name AS color_name_3 FROM param_color t0 WHERE t0.id = ?
Parameters:
[
  20
]
8 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC
Parameters:
[]
9 0.22 ms
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.tax AS tax_2 FROM category c0_
Parameters:
[]
10 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 ORDER BY t0.nom ASC
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