Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.nom AS nom_2,
  c0_.type AS type_3,
  c0_.actif AS actif_4,
  c0_.sync_auto AS sync_auto_5,
  c0_.ordre AS ordre_6,
  c0_.base_url AS base_url_7,
  c0_.api_key AS api_key_8,
  c0_.language_id AS language_id_9,
  c0_.shop_id AS shop_id_10,
  c0_.root_category_id AS root_category_id_11,
  c0_.tax_rules_group_id AS tax_rules_group_id_12,
  c0_.zone_id AS zone_id_13
FROM
  canal c0_
  INNER JOIN zone z1_ ON c0_.zone_id = z1_.id
WHERE
  c0_.type = ?
  AND z1_.code = ?
  AND c0_.actif = true
LIMIT
  1

SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nom AS nom_2, c0_.type AS type_3, c0_.actif AS actif_4, c0_.sync_auto AS sync_auto_5, c0_.ordre AS ordre_6, c0_.base_url AS base_url_7, c0_.api_key AS api_key_8, c0_.language_id AS language_id_9, c0_.shop_id AS shop_id_10, c0_.root_category_id AS root_category_id_11, c0_.tax_rules_group_id AS tax_rules_group_id_12, c0_.zone_id AS zone_id_13 FROM canal c0_ INNER JOIN zone z1_ ON c0_.zone_id = z1_.id WHERE c0_.type = 'PARTENAIRES' AND z1_.code = 'METROPOLE' AND c0_.actif = true LIMIT 1;

SELECT
  DISTINCT id_0,
  MIN(sclr_50) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.nom AS nom_1,
      p0_.slug AS slug_2,
      p0_.reference AS reference_3,
      p0_.ean13 AS ean13_4,
      p0_.resume AS resume_5,
      p0_.description AS description_6,
      p0_.poids AS poids_7,
      p0_.stock AS stock_8,
      p0_.actif AS actif_9,
      p0_.afficher_prix AS afficher_prix_10,
      p0_.exclu_synchro AS exclu_synchro_11,
      p0_.cse AS cse_12,
      p0_.en_avant AS en_avant_13,
      p0_.libelle_declinaison AS libelle_declinaison_14,
      p0_.created_at AS created_at_15,
      p0_.updated_at AS updated_at_16,
      p1_.id AS id_17,
      p1_.visible AS visible_18,
      p1_.prix AS prix_19,
      p1_.external_id AS external_id_20,
      p1_.external_combination_id AS external_combination_id_21,
      p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22,
      p1_.sync_statut AS sync_statut_23,
      p1_.sync_erreur AS sync_erreur_24,
      p1_.sync_at AS sync_at_25,
      p1_.sync_hash AS sync_hash_26,
      p2_.id AS id_27,
      p2_.fichier AS fichier_28,
      p2_.taille AS taille_29,
      p2_.mime_type AS mime_type_30,
      p2_.nom_original AS nom_original_31,
      p2_.legende AS legende_32,
      p2_.position AS position_33,
      p2_.verrouillee AS verrouillee_34,
      p2_.hash AS hash_35,
      p2_.external_ids AS external_ids_36,
      p2_.updated_at AS updated_at_37,
      m3_.id AS id_38,
      m3_.nom AS nom_39,
      m3_.actif AS actif_40,
      m3_.external_ids AS external_ids_41,
      c4_.id AS id_42,
      c4_.nom AS nom_43,
      c4_.slug AS slug_44,
      c4_.description AS description_45,
      c4_.actif AS actif_46,
      c4_.accueil AS accueil_47,
      c4_.ordre AS ordre_48,
      c4_.external_ids AS external_ids_49,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.nom ASC,
          p2_.position ASC
      ) AS sclr_50
    FROM
      produit p0_
      INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id
      AND (
        p1_.canal_id = ?
        AND p1_.visible = true
        AND p1_.prix IS NOT NULL
      )
      LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id
      LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id
      LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id
      LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id
    WHERE
      p0_.actif = true
      AND p0_.parent_id IS NULL
      AND p0_.en_avant = true
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  8

SELECT DISTINCT id_0, MIN(sclr_50) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.reference AS reference_3, p0_.ean13 AS ean13_4, p0_.resume AS resume_5, p0_.description AS description_6, p0_.poids AS poids_7, p0_.stock AS stock_8, p0_.actif AS actif_9, p0_.afficher_prix AS afficher_prix_10, p0_.exclu_synchro AS exclu_synchro_11, p0_.cse AS cse_12, p0_.en_avant AS en_avant_13, p0_.libelle_declinaison AS libelle_declinaison_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p1_.id AS id_17, p1_.visible AS visible_18, p1_.prix AS prix_19, p1_.external_id AS external_id_20, p1_.external_combination_id AS external_combination_id_21, p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22, p1_.sync_statut AS sync_statut_23, p1_.sync_erreur AS sync_erreur_24, p1_.sync_at AS sync_at_25, p1_.sync_hash AS sync_hash_26, p2_.id AS id_27, p2_.fichier AS fichier_28, p2_.taille AS taille_29, p2_.mime_type AS mime_type_30, p2_.nom_original AS nom_original_31, p2_.legende AS legende_32, p2_.position AS position_33, p2_.verrouillee AS verrouillee_34, p2_.hash AS hash_35, p2_.external_ids AS external_ids_36, p2_.updated_at AS updated_at_37, m3_.id AS id_38, m3_.nom AS nom_39, m3_.actif AS actif_40, m3_.external_ids AS external_ids_41, c4_.id AS id_42, c4_.nom AS nom_43, c4_.slug AS slug_44, c4_.description AS description_45, c4_.actif AS actif_46, c4_.accueil AS accueil_47, c4_.ordre AS ordre_48, c4_.external_ids AS external_ids_49, ROW_NUMBER() OVER(ORDER BY p0_.nom ASC, p2_.position ASC) AS sclr_50 FROM produit p0_ INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id AND (p1_.canal_id = 1 AND p1_.visible = true AND p1_.prix IS NOT NULL) LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id WHERE p0_.actif = true AND p0_.parent_id IS NULL AND p0_.en_avant = true) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 8;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.slug AS slug_2,
  p0_.reference AS reference_3,
  p0_.ean13 AS ean13_4,
  p0_.resume AS resume_5,
  p0_.description AS description_6,
  p0_.poids AS poids_7,
  p0_.stock AS stock_8,
  p0_.actif AS actif_9,
  p0_.afficher_prix AS afficher_prix_10,
  p0_.exclu_synchro AS exclu_synchro_11,
  p0_.cse AS cse_12,
  p0_.en_avant AS en_avant_13,
  p0_.libelle_declinaison AS libelle_declinaison_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p1_.id AS id_17,
  p1_.visible AS visible_18,
  p1_.prix AS prix_19,
  p1_.external_id AS external_id_20,
  p1_.external_combination_id AS external_combination_id_21,
  p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22,
  p1_.sync_statut AS sync_statut_23,
  p1_.sync_erreur AS sync_erreur_24,
  p1_.sync_at AS sync_at_25,
  p1_.sync_hash AS sync_hash_26,
  p2_.id AS id_27,
  p2_.fichier AS fichier_28,
  p2_.taille AS taille_29,
  p2_.mime_type AS mime_type_30,
  p2_.nom_original AS nom_original_31,
  p2_.legende AS legende_32,
  p2_.position AS position_33,
  p2_.verrouillee AS verrouillee_34,
  p2_.hash AS hash_35,
  p2_.external_ids AS external_ids_36,
  p2_.updated_at AS updated_at_37,
  m3_.id AS id_38,
  m3_.nom AS nom_39,
  m3_.actif AS actif_40,
  m3_.external_ids AS external_ids_41,
  c4_.id AS id_42,
  c4_.nom AS nom_43,
  c4_.slug AS slug_44,
  c4_.description AS description_45,
  c4_.actif AS actif_46,
  c4_.accueil AS accueil_47,
  c4_.ordre AS ordre_48,
  c4_.external_ids AS external_ids_49,
  p0_.marque_id AS marque_id_50,
  p0_.parent_id AS parent_id_51,
  p0_.categorie_principale_id AS categorie_principale_id_52,
  p1_.produit_id AS produit_id_53,
  p1_.canal_id AS canal_id_54,
  p2_.produit_id AS produit_id_55,
  c4_.parent_id AS parent_id_56
FROM
  produit p0_
  INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id
  AND (
    p1_.canal_id = ?
    AND p1_.visible = true
    AND p1_.prix IS NOT NULL
  )
  LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id
  LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id
  LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id
  LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id
WHERE
  p0_.actif = true
  AND p0_.parent_id IS NULL
  AND p0_.en_avant = true
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.nom ASC,
  p2_.position ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.reference AS reference_3, p0_.ean13 AS ean13_4, p0_.resume AS resume_5, p0_.description AS description_6, p0_.poids AS poids_7, p0_.stock AS stock_8, p0_.actif AS actif_9, p0_.afficher_prix AS afficher_prix_10, p0_.exclu_synchro AS exclu_synchro_11, p0_.cse AS cse_12, p0_.en_avant AS en_avant_13, p0_.libelle_declinaison AS libelle_declinaison_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p1_.id AS id_17, p1_.visible AS visible_18, p1_.prix AS prix_19, p1_.external_id AS external_id_20, p1_.external_combination_id AS external_combination_id_21, p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22, p1_.sync_statut AS sync_statut_23, p1_.sync_erreur AS sync_erreur_24, p1_.sync_at AS sync_at_25, p1_.sync_hash AS sync_hash_26, p2_.id AS id_27, p2_.fichier AS fichier_28, p2_.taille AS taille_29, p2_.mime_type AS mime_type_30, p2_.nom_original AS nom_original_31, p2_.legende AS legende_32, p2_.position AS position_33, p2_.verrouillee AS verrouillee_34, p2_.hash AS hash_35, p2_.external_ids AS external_ids_36, p2_.updated_at AS updated_at_37, m3_.id AS id_38, m3_.nom AS nom_39, m3_.actif AS actif_40, m3_.external_ids AS external_ids_41, c4_.id AS id_42, c4_.nom AS nom_43, c4_.slug AS slug_44, c4_.description AS description_45, c4_.actif AS actif_46, c4_.accueil AS accueil_47, c4_.ordre AS ordre_48, c4_.external_ids AS external_ids_49, p0_.marque_id AS marque_id_50, p0_.parent_id AS parent_id_51, p0_.categorie_principale_id AS categorie_principale_id_52, p1_.produit_id AS produit_id_53, p1_.canal_id AS canal_id_54, p2_.produit_id AS produit_id_55, c4_.parent_id AS parent_id_56 FROM produit p0_ INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id AND (p1_.canal_id = 1 AND p1_.visible = true AND p1_.prix IS NOT NULL) LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id WHERE p0_.actif = true AND p0_.parent_id IS NULL AND p0_.en_avant = true AND p0_.id IN (539, 155, 571, 559, 265, 679, 688, 557) ORDER BY p0_.nom ASC, p2_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.actif AS actif_4,
  c0_.accueil AS accueil_5,
  c0_.ordre AS ordre_6,
  c0_.external_ids AS external_ids_7,
  c0_.parent_id AS parent_id_8
FROM
  categorie c0_
WHERE
  LOWER(c0_.nom) LIKE ?
  AND c0_.actif = true
ORDER BY
  c0_.parent_id ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.actif AS actif_4, c0_.accueil AS accueil_5, c0_.ordre AS ordre_6, c0_.external_ids AS external_ids_7, c0_.parent_id AS parent_id_8 FROM categorie c0_ WHERE LOWER(c0_.nom) LIKE '%nos produits%' AND c0_.actif = true ORDER BY c0_.parent_id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.actif AS actif_5,
  t0.accueil AS accueil_6,
  t0.ordre AS ordre_7,
  t0.external_ids AS external_ids_8,
  t0.parent_id AS parent_id_9
FROM
  categorie t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.ordre ASC,
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.actif AS actif_5, t0.accueil AS accueil_6, t0.ordre AS ordre_7, t0.external_ids AS external_ids_8, t0.parent_id AS parent_id_9 FROM categorie t0 WHERE t0.parent_id = 1 ORDER BY t0.ordre ASC, t0.nom ASC;

SELECT
  DISTINCT id_0,
  MIN(sclr_50) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.nom AS nom_1,
      p0_.slug AS slug_2,
      p0_.reference AS reference_3,
      p0_.ean13 AS ean13_4,
      p0_.resume AS resume_5,
      p0_.description AS description_6,
      p0_.poids AS poids_7,
      p0_.stock AS stock_8,
      p0_.actif AS actif_9,
      p0_.afficher_prix AS afficher_prix_10,
      p0_.exclu_synchro AS exclu_synchro_11,
      p0_.cse AS cse_12,
      p0_.en_avant AS en_avant_13,
      p0_.libelle_declinaison AS libelle_declinaison_14,
      p0_.created_at AS created_at_15,
      p0_.updated_at AS updated_at_16,
      p1_.id AS id_17,
      p1_.visible AS visible_18,
      p1_.prix AS prix_19,
      p1_.external_id AS external_id_20,
      p1_.external_combination_id AS external_combination_id_21,
      p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22,
      p1_.sync_statut AS sync_statut_23,
      p1_.sync_erreur AS sync_erreur_24,
      p1_.sync_at AS sync_at_25,
      p1_.sync_hash AS sync_hash_26,
      p2_.id AS id_27,
      p2_.fichier AS fichier_28,
      p2_.taille AS taille_29,
      p2_.mime_type AS mime_type_30,
      p2_.nom_original AS nom_original_31,
      p2_.legende AS legende_32,
      p2_.position AS position_33,
      p2_.verrouillee AS verrouillee_34,
      p2_.hash AS hash_35,
      p2_.external_ids AS external_ids_36,
      p2_.updated_at AS updated_at_37,
      m3_.id AS id_38,
      m3_.nom AS nom_39,
      m3_.actif AS actif_40,
      m3_.external_ids AS external_ids_41,
      c4_.id AS id_42,
      c4_.nom AS nom_43,
      c4_.slug AS slug_44,
      c4_.description AS description_45,
      c4_.actif AS actif_46,
      c4_.accueil AS accueil_47,
      c4_.ordre AS ordre_48,
      c4_.external_ids AS external_ids_49,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.nom ASC,
          p2_.position ASC
      ) AS sclr_50
    FROM
      produit p0_
      INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id
      AND (
        p1_.canal_id = ?
        AND p1_.visible = true
        AND p1_.prix IS NOT NULL
      )
      LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id
      LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id
      LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id
      LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id
      INNER JOIN produit_categorie p7_ ON p0_.id = p7_.produit_id
      INNER JOIN categorie c6_ ON c6_.id = p7_.categorie_id
      AND (c6_.id = ?)
    WHERE
      p0_.actif = true
      AND p0_.parent_id IS NULL
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  3

SELECT DISTINCT id_0, MIN(sclr_50) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.reference AS reference_3, p0_.ean13 AS ean13_4, p0_.resume AS resume_5, p0_.description AS description_6, p0_.poids AS poids_7, p0_.stock AS stock_8, p0_.actif AS actif_9, p0_.afficher_prix AS afficher_prix_10, p0_.exclu_synchro AS exclu_synchro_11, p0_.cse AS cse_12, p0_.en_avant AS en_avant_13, p0_.libelle_declinaison AS libelle_declinaison_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p1_.id AS id_17, p1_.visible AS visible_18, p1_.prix AS prix_19, p1_.external_id AS external_id_20, p1_.external_combination_id AS external_combination_id_21, p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22, p1_.sync_statut AS sync_statut_23, p1_.sync_erreur AS sync_erreur_24, p1_.sync_at AS sync_at_25, p1_.sync_hash AS sync_hash_26, p2_.id AS id_27, p2_.fichier AS fichier_28, p2_.taille AS taille_29, p2_.mime_type AS mime_type_30, p2_.nom_original AS nom_original_31, p2_.legende AS legende_32, p2_.position AS position_33, p2_.verrouillee AS verrouillee_34, p2_.hash AS hash_35, p2_.external_ids AS external_ids_36, p2_.updated_at AS updated_at_37, m3_.id AS id_38, m3_.nom AS nom_39, m3_.actif AS actif_40, m3_.external_ids AS external_ids_41, c4_.id AS id_42, c4_.nom AS nom_43, c4_.slug AS slug_44, c4_.description AS description_45, c4_.actif AS actif_46, c4_.accueil AS accueil_47, c4_.ordre AS ordre_48, c4_.external_ids AS external_ids_49, ROW_NUMBER() OVER(ORDER BY p0_.nom ASC, p2_.position ASC) AS sclr_50 FROM produit p0_ INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id AND (p1_.canal_id = 1 AND p1_.visible = true AND p1_.prix IS NOT NULL) LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id INNER JOIN produit_categorie p7_ ON p0_.id = p7_.produit_id INNER JOIN categorie c6_ ON c6_.id = p7_.categorie_id AND (c6_.id = 11) WHERE p0_.actif = true AND p0_.parent_id IS NULL) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 3;

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.slug AS slug_2,
  p0_.reference AS reference_3,
  p0_.ean13 AS ean13_4,
  p0_.resume AS resume_5,
  p0_.description AS description_6,
  p0_.poids AS poids_7,
  p0_.stock AS stock_8,
  p0_.actif AS actif_9,
  p0_.afficher_prix AS afficher_prix_10,
  p0_.exclu_synchro AS exclu_synchro_11,
  p0_.cse AS cse_12,
  p0_.en_avant AS en_avant_13,
  p0_.libelle_declinaison AS libelle_declinaison_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p1_.id AS id_17,
  p1_.visible AS visible_18,
  p1_.prix AS prix_19,
  p1_.external_id AS external_id_20,
  p1_.external_combination_id AS external_combination_id_21,
  p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22,
  p1_.sync_statut AS sync_statut_23,
  p1_.sync_erreur AS sync_erreur_24,
  p1_.sync_at AS sync_at_25,
  p1_.sync_hash AS sync_hash_26,
  p2_.id AS id_27,
  p2_.fichier AS fichier_28,
  p2_.taille AS taille_29,
  p2_.mime_type AS mime_type_30,
  p2_.nom_original AS nom_original_31,
  p2_.legende AS legende_32,
  p2_.position AS position_33,
  p2_.verrouillee AS verrouillee_34,
  p2_.hash AS hash_35,
  p2_.external_ids AS external_ids_36,
  p2_.updated_at AS updated_at_37,
  m3_.id AS id_38,
  m3_.nom AS nom_39,
  m3_.actif AS actif_40,
  m3_.external_ids AS external_ids_41,
  c4_.id AS id_42,
  c4_.nom AS nom_43,
  c4_.slug AS slug_44,
  c4_.description AS description_45,
  c4_.actif AS actif_46,
  c4_.accueil AS accueil_47,
  c4_.ordre AS ordre_48,
  c4_.external_ids AS external_ids_49,
  p0_.marque_id AS marque_id_50,
  p0_.parent_id AS parent_id_51,
  p0_.categorie_principale_id AS categorie_principale_id_52,
  p1_.produit_id AS produit_id_53,
  p1_.canal_id AS canal_id_54,
  p2_.produit_id AS produit_id_55,
  c4_.parent_id AS parent_id_56
FROM
  produit p0_
  INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id
  AND (
    p1_.canal_id = ?
    AND p1_.visible = true
    AND p1_.prix IS NOT NULL
  )
  LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id
  LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id
  LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id
  LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id
  INNER JOIN produit_categorie p7_ ON p0_.id = p7_.produit_id
  INNER JOIN categorie c6_ ON c6_.id = p7_.categorie_id
  AND (c6_.id = ?)
WHERE
  p0_.actif = true
  AND p0_.parent_id IS NULL
  AND p0_.id IN (?, ?, ?)
ORDER BY
  p0_.nom ASC,
  p2_.position ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.slug AS slug_2, p0_.reference AS reference_3, p0_.ean13 AS ean13_4, p0_.resume AS resume_5, p0_.description AS description_6, p0_.poids AS poids_7, p0_.stock AS stock_8, p0_.actif AS actif_9, p0_.afficher_prix AS afficher_prix_10, p0_.exclu_synchro AS exclu_synchro_11, p0_.cse AS cse_12, p0_.en_avant AS en_avant_13, p0_.libelle_declinaison AS libelle_declinaison_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p1_.id AS id_17, p1_.visible AS visible_18, p1_.prix AS prix_19, p1_.external_id AS external_id_20, p1_.external_combination_id AS external_combination_id_21, p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22, p1_.sync_statut AS sync_statut_23, p1_.sync_erreur AS sync_erreur_24, p1_.sync_at AS sync_at_25, p1_.sync_hash AS sync_hash_26, p2_.id AS id_27, p2_.fichier AS fichier_28, p2_.taille AS taille_29, p2_.mime_type AS mime_type_30, p2_.nom_original AS nom_original_31, p2_.legende AS legende_32, p2_.position AS position_33, p2_.verrouillee AS verrouillee_34, p2_.hash AS hash_35, p2_.external_ids AS external_ids_36, p2_.updated_at AS updated_at_37, m3_.id AS id_38, m3_.nom AS nom_39, m3_.actif AS actif_40, m3_.external_ids AS external_ids_41, c4_.id AS id_42, c4_.nom AS nom_43, c4_.slug AS slug_44, c4_.description AS description_45, c4_.actif AS actif_46, c4_.accueil AS accueil_47, c4_.ordre AS ordre_48, c4_.external_ids AS external_ids_49, p0_.marque_id AS marque_id_50, p0_.parent_id AS parent_id_51, p0_.categorie_principale_id AS categorie_principale_id_52, p1_.produit_id AS produit_id_53, p1_.canal_id AS canal_id_54, p2_.produit_id AS produit_id_55, c4_.parent_id AS parent_id_56 FROM produit p0_ INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id AND (p1_.canal_id = 1 AND p1_.visible = true AND p1_.prix IS NOT NULL) LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id INNER JOIN produit_categorie p7_ ON p0_.id = p7_.produit_id INNER JOIN categorie c6_ ON c6_.id = p7_.categorie_id AND (c6_.id = 11) WHERE p0_.actif = true AND p0_.parent_id IS NULL AND p0_.id IN (539, 155, 571) ORDER BY p0_.nom ASC, p2_.position ASC;

SELECT
  DISTINCT id_0,
  MIN(sclr_50) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.nom AS nom_1,
      p0_.slug AS slug_2,
      p0_.reference AS reference_3,
      p0_.ean13 AS ean13_4,
      p0_.resume AS resume_5,
      p0_.description AS description_6,
      p0_.poids AS poids_7,
      p0_.stock AS stock_8,
      p0_.actif AS actif_9,
      p0_.afficher_prix AS afficher_prix_10,
      p0_.exclu_synchro AS exclu_synchro_11,
      p0_.cse AS cse_12,
      p0_.en_avant AS en_avant_13,
      p0_.libelle_declinaison AS libelle_declinaison_14,
      p0_.created_at AS created_at_15,
      p0_.updated_at AS updated_at_16,
      p1_.id AS id_17,
      p1_.visible AS visible_18,
      p1_.prix AS prix_19,
      p1_.external_id AS external_id_20,
      p1_.external_combination_id AS external_combination_id_21,
      p1_.external_tax_rules_group_id AS external_tax_rules_group_id_22,
      p1_.sync_statut AS sync_statut_23,
      p1_.sync_erreur AS sync_erreur_24,
      p1_.sync_at AS sync_at_25,
      p1_.sync_hash AS sync_hash_26,
      p2_.id AS id_27,
      p2_.fichier AS fichier_28,
      p2_.taille AS taille_29,
      p2_.mime_type AS mime_type_30,
      p2_.nom_original AS nom_original_31,
      p2_.legende AS legende_32,
      p2_.position AS position_33,
      p2_.verrouillee AS verrouillee_34,
      p2_.hash AS hash_35,
      p2_.external_ids AS external_ids_36,
      p2_.updated_at AS updated_at_37,
      m3_.id AS id_38,
      m3_.nom AS nom_39,
      m3_.actif AS actif_40,
      m3_.external_ids AS external_ids_41,
      c4_.id AS id_42,
      c4_.nom AS nom_43,
      c4_.slug AS slug_44,
      c4_.description AS description_45,
      c4_.actif AS actif_46,
      c4_.accueil AS accueil_47,
      c4_.ordre AS ordre_48,
      c4_.external_ids AS external_ids_49,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.nom ASC,
          p2_.position ASC
      ) AS sclr_50
    FROM
      produit p0_
      INNER JOIN produit_canal p1_ ON p0_.id = p1_.produit_id
      AND (
        p1_.canal_id = ?
        AND p1_.visible = true
        AND p1_.prix IS NOT NULL
      )
      LEFT JOIN produit_image p2_ ON p0_.id = p2_.produit_id
      LEFT JOIN marque m3_ ON p0_.marque_id = m3_.id
      LEFT JOIN produit_categorie p5_ ON p0_.id = p5_.produit_id
      LEFT JOIN categorie c4_ ON c4_.id = p5_.categorie_id
      INNER JOIN produit_categorie p7_ ON p0_.id = p7_.produit_id
      INNER JOIN categorie c6_ ON c6_.id = p7_.categorie_id
      AND (c6_.id = ?)
    WHERE
      p0_.actif = true
      AND p0_.parent_id IS NULL
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  3