Query Metrics
8
Database Queries
6
Different statements
6.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.01 ms (29.24%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.cost AS cost_4, t0.image AS image_5, t0.precommande AS precommande_6, t0.apropos AS apropos_7, t0.avertissement AS avertissement_8, t0.precautions_emploi AS precautions_emploi_9, t0.breve_description AS breve_description_10, t0.volume AS volume_11, t0.legende_image AS legende_image_12, t0.metatitle AS metatitle_13, t0.metadescription AS metadescription_14, t0.name_english AS name_english_15, t0.breve_description_english AS breve_description_english_16, t0.apropos_english AS apropos_english_17, t0.description_english AS description_english_18, t0.avertissement_english AS avertissement_english_19, t0.precautions_emploi_english AS precautions_emploi_english_20, t0.langue AS langue_21, t0.legal_notice AS legal_notice_22, t0.legal_notice_english AS legal_notice_english_23, t0.origin_and_current_production AS origin_and_current_production_24, t0.origin_and_current_production_english AS origin_and_current_production_english_25, t0.usage_tips AS usage_tips_26, t0.usage_tips_english AS usage_tips_english_27, t0.composition_and_precautions_for_use AS composition_and_precautions_for_use_28, t0.composition_and_precautions_for_use_english AS composition_and_precautions_for_use_english_29, t0.precautions_generales AS precautions_generales_30, t0.precautions_generales_english AS precautions_generales_english_31, t0.reference_sku AS reference_sku_32, t0.featured AS featured_33, t0.tva AS tva_34, t0.is_month_product AS is_month_product_35, t0.maj_date AS maj_date_36, t0.status AS status_37, t0.id_product_category AS id_product_category_38, t39.id AS id_40, t39.qte_stock AS qte_stock_41, t39.is_available_stock AS is_available_stock_42, t39.produit_id AS produit_id_43 FROM product t0 LEFT JOIN view_produit_qte_stock t39 ON t39.produit_id = t0.id WHERE t0.id = ?
Parameters:
[
"1"
]
|
|
1.62 ms (23.55%) |
1 |
SELECT t0.id AS id_1, t0.qte_stock AS qte_stock_2, t0.is_available_stock AS is_available_stock_3, t0.produit_id AS produit_id_4 FROM view_produit_qte_stock t0 WHERE t0.produit_id = ?
Parameters:
[
2
]
|
|
1.19 ms (17.33%) |
2 |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.val AS val_2, c0_.num AS num_3, c0_.statut AS statut_4 FROM config c0_ WHERE c0_.num = ? AND c0_.statut = ?
Parameters:
[ 1 1 ] |
|
1.15 ms (16.69%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.cost AS cost_3, p0_.image AS image_4, p0_.precommande AS precommande_5, p0_.apropos AS apropos_6, p0_.avertissement AS avertissement_7, p0_.precautions_emploi AS precautions_emploi_8, p0_.breve_description AS breve_description_9, p0_.volume AS volume_10, p0_.legende_image AS legende_image_11, p0_.metatitle AS metatitle_12, p0_.metadescription AS metadescription_13, p0_.name_english AS name_english_14, p0_.breve_description_english AS breve_description_english_15, p0_.apropos_english AS apropos_english_16, p0_.description_english AS description_english_17, p0_.avertissement_english AS avertissement_english_18, p0_.precautions_emploi_english AS precautions_emploi_english_19, p0_.langue AS langue_20, p0_.legal_notice AS legal_notice_21, p0_.legal_notice_english AS legal_notice_english_22, p0_.origin_and_current_production AS origin_and_current_production_23, p0_.origin_and_current_production_english AS origin_and_current_production_english_24, p0_.usage_tips AS usage_tips_25, p0_.usage_tips_english AS usage_tips_english_26, p0_.composition_and_precautions_for_use AS composition_and_precautions_for_use_27, p0_.composition_and_precautions_for_use_english AS composition_and_precautions_for_use_english_28, p0_.precautions_generales AS precautions_generales_29, p0_.precautions_generales_english AS precautions_generales_english_30, p0_.reference_sku AS reference_sku_31, p0_.featured AS featured_32, p0_.tva AS tva_33, p0_.is_month_product AS is_month_product_34, p0_.maj_date AS maj_date_35, p0_.status AS status_36, p0_.id_product_category AS id_product_category_37 FROM product p0_ WHERE p0_.id <> ? AND p0_.status > ? AND p0_.id_product_category IS NOT NULL LIMIT 4
Parameters:
[ "1" -2 ] |
|
0.58 ms (8.39%) |
2 |
SELECT t0.id AS id_1, t0.image AS image_2, t0.legende_image AS legende_image_3, t0.product_id AS product_id_4 FROM product_images t0 WHERE t0.product_id IN (?)
Parameters:
[
1
]
|
|
0.33 ms (4.80%) |
1 |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.fichier AS fichier_2, p0_.statut AS statut_3, p0_.date_ajout AS date_ajout_4, p0_.product_id AS product_id_5 FROM product_tracabilite p0_ WHERE p0_.product_id = ? AND p0_.statut = ? ORDER BY p0_.date_ajout DESC
Parameters:
[ 1 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\Product | No errors. |
| App\Entity\ProductCategory | No errors. |
| App\Entity\ViewProduitQteStock | No errors. |
| App\Entity\FavoriteProduct | No errors. |
| App\Entity\ProductImages | No errors. |
| App\Entity\ProductTracabilite | No errors. |
| App\Entity\Config | No errors. |