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
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    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
        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
        ORDER BY
          p0_.nom ASC,
          p2_.position ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 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 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 ORDER BY p0_.nom ASC, p2_.position ASC) dctrn_result) dctrn_table;

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 IS NULL
  AND t0.actif = ?
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 IS NULL AND t0.actif = 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
    WHERE
      p0_.actif = true
      AND p0_.parent_id IS NULL
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  24

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) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 24;

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_.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_.id IN (539, 155, 571, 559, 265, 679, 688, 557, 683, 545, 175, 546, 602, 603, 280, 676, 177, 547, 548, 544, 549, 550, 266, 174) ORDER BY p0_.nom ASC, p2_.position ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.type AS type_4,
  t0.actif AS actif_5,
  t0.sync_auto AS sync_auto_6,
  t0.ordre AS ordre_7,
  t0.base_url AS base_url_8,
  t0.api_key AS api_key_9,
  t0.language_id AS language_id_10,
  t0.shop_id AS shop_id_11,
  t0.root_category_id AS root_category_id_12,
  t0.tax_rules_group_id AS tax_rules_group_id_13,
  t0.zone_id AS zone_id_14
FROM
  canal t0
WHERE
  t0.type = ?
  AND t0.actif = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.type AS type_4, t0.actif AS actif_5, t0.sync_auto AS sync_auto_6, t0.ordre AS ordre_7, t0.base_url AS base_url_8, t0.api_key AS api_key_9, t0.language_id AS language_id_10, t0.shop_id AS shop_id_11, t0.root_category_id AS root_category_id_12, t0.tax_rules_group_id AS tax_rules_group_id_13, t0.zone_id AS zone_id_14 FROM canal t0 WHERE t0.type = 'PARTENAIRES' AND t0.actif = 1 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.actif AS actif_4,
  t0.taxe_id AS taxe_id_5
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.actif AS actif_4,
  t0.taxe_id AS taxe_id_5
FROM
  zone t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.actif AS actif_4, t0.taxe_id AS taxe_id_5 FROM zone t0 WHERE t0.id = 2;

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
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.reference AS reference_4,
  t0.ean13 AS ean13_5,
  t0.resume AS resume_6,
  t0.description AS description_7,
  t0.poids AS poids_8,
  t0.stock AS stock_9,
  t0.actif AS actif_10,
  t0.afficher_prix AS afficher_prix_11,
  t0.exclu_synchro AS exclu_synchro_12,
  t0.cse AS cse_13,
  t0.en_avant AS en_avant_14,
  t0.libelle_declinaison AS libelle_declinaison_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.marque_id AS marque_id_18,
  t0.parent_id AS parent_id_19,
  t0.categorie_principale_id AS categorie_principale_id_20
FROM
  produit t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.libelle_declinaison ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.reference AS reference_4, t0.ean13 AS ean13_5, t0.resume AS resume_6, t0.description AS description_7, t0.poids AS poids_8, t0.stock AS stock_9, t0.actif AS actif_10, t0.afficher_prix AS afficher_prix_11, t0.exclu_synchro AS exclu_synchro_12, t0.cse AS cse_13, t0.en_avant AS en_avant_14, t0.libelle_declinaison AS libelle_declinaison_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.marque_id AS marque_id_18, t0.parent_id AS parent_id_19, t0.categorie_principale_id AS categorie_principale_id_20 FROM produit t0 WHERE t0.parent_id = 539 ORDER BY t0.libelle_declinaison ASC;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.slug AS slug_3,
  t0.reference AS reference_4,
  t0.ean13 AS ean13_5,
  t0.resume AS resume_6,
  t0.description AS description_7,
  t0.poids AS poids_8,
  t0.stock AS stock_9,
  t0.actif AS actif_10,
  t0.afficher_prix AS afficher_prix_11,
  t0.exclu_synchro AS exclu_synchro_12,
  t0.cse AS cse_13,
  t0.en_avant AS en_avant_14,
  t0.libelle_declinaison AS libelle_declinaison_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.marque_id AS marque_id_18,
  t0.parent_id AS parent_id_19,
  t0.categorie_principale_id AS categorie_principale_id_20
FROM
  produit t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.libelle_declinaison ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.reference AS reference_4, t0.ean13 AS ean13_5, t0.resume AS resume_6, t0.description AS description_7, t0.poids AS poids_8, t0.stock AS stock_9, t0.actif AS actif_10, t0.afficher_prix AS afficher_prix_11, t0.exclu_synchro AS exclu_synchro_12, t0.cse AS cse_13, t0.en_avant AS en_avant_14, t0.libelle_declinaison AS libelle_declinaison_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.marque_id AS marque_id_18, t0.parent_id AS parent_id_19, t0.categorie_principale_id AS categorie_principale_id_20 FROM produit t0 WHERE t0.parent_id = 155 ORDER BY t0.libelle_declinaison ASC;