Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.image_en AS image_en_5,
  t0.status AS status_6,
  t0.name_english AS name_english_7,
  t0.description_english AS description_english_8
FROM
  product_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.image_en AS image_en_5, t0.status AS status_6, t0.name_english AS name_english_7, t0.description_english AS description_english_8 FROM product_category t0;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  INNER JOIN view_produit_qte_stock v1_ ON p0_.id = v1_.produit_id
WHERE
  (
    p0_.langue = ?
    OR p0_.langue = ?
  )
  AND p0_.status > ?
  AND p0_.id_product_category IS NOT NULL

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN view_produit_qte_stock v1_ ON p0_.id = v1_.produit_id WHERE (p0_.langue = 1 OR p0_.langue = 0) AND p0_.status > -2 AND p0_.id_product_category IS NOT NULL;

SELECT
  DISTINCT p0_.id AS id_0,
  v1_.is_available_stock AS is_available_stock_1,
  v1_.is_available_stock AS is_available_stock_2,
  p0_.name AS name_3
FROM
  product p0_
  INNER JOIN view_produit_qte_stock v1_ ON p0_.id = v1_.produit_id
WHERE
  (
    p0_.langue = ?
    OR p0_.langue = ?
  )
  AND p0_.status > ?
  AND p0_.id_product_category IS NOT NULL
ORDER BY
  v1_.is_available_stock DESC,
  v1_.is_available_stock DESC,
  p0_.name ASC
LIMIT
  12

SELECT DISTINCT p0_.id AS id_0, v1_.is_available_stock AS is_available_stock_1, v1_.is_available_stock AS is_available_stock_2, p0_.name AS name_3 FROM product p0_ INNER JOIN view_produit_qte_stock v1_ ON p0_.id = v1_.produit_id WHERE (p0_.langue = 1 OR p0_.langue = 0) AND p0_.status > -2 AND p0_.id_product_category IS NOT NULL ORDER BY v1_.is_available_stock DESC, v1_.is_available_stock DESC, p0_.name ASC LIMIT 12;

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_
  INNER JOIN view_produit_qte_stock v1_ ON p0_.id = v1_.produit_id
WHERE
  (
    p0_.langue = ?
    OR p0_.langue = ?
  )
  AND p0_.status > ?
  AND p0_.id_product_category IS NOT NULL
  AND p0_.id IN (?, ?)
ORDER BY
  v1_.is_available_stock DESC,
  v1_.is_available_stock DESC,
  p0_.name ASC

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_ INNER JOIN view_produit_qte_stock v1_ ON p0_.id = v1_.produit_id WHERE (p0_.langue = 1 OR p0_.langue = 0) AND p0_.status > -2 AND p0_.id_product_category IS NOT NULL AND p0_.id IN (2, 1) ORDER BY v1_.is_available_stock DESC, v1_.is_available_stock DESC, p0_.name ASC;

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 = ?

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 = 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 (?)

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 (2);

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 = ?

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 = 1;

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 (?)

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 (1);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.image_en AS image_en_5,
  t0.status AS status_6,
  t0.name_english AS name_english_7,
  t0.description_english AS description_english_8
FROM
  product_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.image_en AS image_en_5, t0.status AS status_6, t0.name_english AS name_english_7, t0.description_english AS description_english_8 FROM product_category t0;

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 = ?

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 = 1 AND c0_.statut = 1;

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 = ?

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 = 3 AND c0_.statut = 1;