Query Metrics
6
Database Queries
6
Different statements
2.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.49 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.variant_type AS variant_type_13, t0.variant_type2 AS variant_type2_14, t0.variant_type3 AS variant_type3_15, t0.category_id AS category_id_16, t0.user_id AS user_id_17, t0.magasin_id AS magasin_id_18 FROM produit t0 WHERE t0.id = ?
Parameters:
[
"29"
]
|
| 2 | 0.36 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_path AS logo_path_3, t0.active AS active_4, t0.subscription_paid_until AS subscription_paid_until_5, t0.adresse AS adresse_6, t0.telephone AS telephone_7, t0.numero_cr AS numero_cr_8, t0.numero_tva AS numero_tva_9, t0.country_id AS country_id_10, t0.region_id AS region_id_11, t0.city_id AS city_id_12 FROM magasin t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 3 | 0.40 ms |
SELECT t0.id AS id_1, t0.size AS size_2, t0.color AS color_3, t0.option_label AS option_label_4, t0.option_label2 AS option_label2_5, t0.option_label3 AS option_label3_6, t0.prix AS prix_7, t0.cost_price AS cost_price_8, t0.qtt AS qtt_9, t0.produit_id AS produit_id_10, t0.param_color_id AS param_color_id_11, t0.param_size_id AS param_size_id_12 FROM produit_variant t0 WHERE t0.produit_id = ?
Parameters:
[
29
]
|
| 4 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.phone_code AS phone_code_4 FROM country t0 ORDER BY t0.name ASC
Parameters:
[] |
| 5 | 0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.tax AS tax_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.image_url AS image_url_3, t0.produit_id AS produit_id_4, t0.produit_variant_id AS produit_variant_id_5 FROM image t0 WHERE t0.produit_id = ?
Parameters:
[
29
]
|
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\Produit | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Magasin | No errors. |
| App\Entity\CommandeDetails | No errors. |
| App\Entity\Image | No errors. |
| App\Entity\ProduitPromotion | No errors. |
| App\Entity\ProduitVariant | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Region | No errors. |
| App\Entity\City | No errors. |
| App\Entity\MagasinDeliveryFee | No errors. |
| App\Entity\MagasinUser | No errors. |
| App\Entity\ParamColor | No errors. |
| App\Entity\ParamSize | No errors. |