Symfony Profiler

[
  "route" => "app_accueil"
  "route_parameters" => [
    "_route" => "app_accueil"
    "_controller" => "App\Controller\Site\CatalogueController::accueil"
  ]
  "request_uri" => "https://melgav2.conception-jc.fr/"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "database"
    "port" => 5432
    "user" => "melga"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "melga"
    "serverVersion" => "16"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "PARTENAIRES"
    2 => "METROPOLE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#889}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 539
    3 => 155
    4 => 571
    5 => 559
    6 => 265
    7 => 679
    8 => 688
    9 => 557
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
    6 => Doctrine\DBAL\ParameterType {#996}
    7 => Doctrine\DBAL\ParameterType {#996}
    8 => Doctrine\DBAL\ParameterType {#996}
    9 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "%nos produits%"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 11
    3 => 539
    4 => 155
    5 => 571
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 20
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 20
    3 => 193
    4 => 195
    5 => 196
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 15
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 15
    3 => 474
    4 => 595
    5 => 54
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 8
    3 => 539
    4 => 99
    5 => 94
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 5
    3 => 155
    4 => 571
    5 => 559
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 9
    3 => 280
    4 => 351
    5 => 142
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 12
    3 => 193
    4 => 195
    5 => 196
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 2
    3 => 53
    4 => 54
    5 => 50
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 16
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 16
    3 => 442
    4 => 306
    5 => 436
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 3
    3 => 78
    4 => 254
    5 => 84
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 4
    3 => 389
    4 => 578
    5 => 380
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 7
    3 => 652
    4 => 389
    5 => 695
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 13
    3 => 595
    4 => 251
    5 => 140
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 14
    3 => 362
    4 => 189
    5 => 185
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 17
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 17
    3 => 355
    4 => 357
    5 => 362
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 22
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 22
    3 => 474
    4 => 652
    5 => 648
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 10
    3 => 350
    4 => 126
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 23
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 23
    3 => 586
    4 => 585
    5 => 584
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 19
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 19
    3 => 64
    4 => 409
    5 => 76
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 21
    3 => 72
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 18
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 18
    3 => 348
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => 6
    3 => 664
    4 => 250
    5 => 249
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "%partenaires%"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#889
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) WHERE p0_.actif = true AND p0_.parent_id IS NULL) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 8"
  "params" => [
    1 => 1
    2 => 11
    3 => 35
    4 => 28
    5 => 29
    6 => 27
    7 => 31
    8 => 37
    9 => 32
    10 => 43
    11 => 42
    12 => 30
    13 => 41
    14 => 33
    15 => 36
    16 => 38
    17 => 39
    18 => 48
    19 => 50
    20 => 34
    21 => 40
    22 => 44
    23 => 53
    24 => 47
    25 => 49
    26 => 51
    27 => 52
    28 => 54
    29 => 55
    30 => 56
    31 => 57
    32 => 58
    33 => 59
    34 => 60
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
    6 => Doctrine\DBAL\ParameterType {#996}
    7 => Doctrine\DBAL\ParameterType {#996}
    8 => Doctrine\DBAL\ParameterType {#996}
    9 => Doctrine\DBAL\ParameterType {#996}
    10 => Doctrine\DBAL\ParameterType {#996}
    11 => Doctrine\DBAL\ParameterType {#996}
    12 => Doctrine\DBAL\ParameterType {#996}
    13 => Doctrine\DBAL\ParameterType {#996}
    14 => Doctrine\DBAL\ParameterType {#996}
    15 => Doctrine\DBAL\ParameterType {#996}
    16 => Doctrine\DBAL\ParameterType {#996}
    17 => Doctrine\DBAL\ParameterType {#996}
    18 => Doctrine\DBAL\ParameterType {#996}
    19 => Doctrine\DBAL\ParameterType {#996}
    20 => Doctrine\DBAL\ParameterType {#996}
    21 => Doctrine\DBAL\ParameterType {#996}
    22 => Doctrine\DBAL\ParameterType {#996}
    23 => Doctrine\DBAL\ParameterType {#996}
    24 => Doctrine\DBAL\ParameterType {#996}
    25 => Doctrine\DBAL\ParameterType {#996}
    26 => Doctrine\DBAL\ParameterType {#996}
    27 => Doctrine\DBAL\ParameterType {#996}
    28 => Doctrine\DBAL\ParameterType {#996}
    29 => Doctrine\DBAL\ParameterType {#996}
    30 => Doctrine\DBAL\ParameterType {#996}
    31 => Doctrine\DBAL\ParameterType {#996}
    32 => Doctrine\DBAL\ParameterType {#996}
    33 => Doctrine\DBAL\ParameterType {#996}
    34 => Doctrine\DBAL\ParameterType {#996}
  ]
]

[
  "sql" => "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 IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) WHERE p0_.actif = true AND p0_.parent_id IS NULL AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.nom ASC, p2_.position ASC"
  "params" => [
    1 => 1
    2 => 11
    3 => 35
    4 => 28
    5 => 29
    6 => 27
    7 => 31
    8 => 37
    9 => 32
    10 => 43
    11 => 42
    12 => 30
    13 => 41
    14 => 33
    15 => 36
    16 => 38
    17 => 39
    18 => 48
    19 => 50
    20 => 34
    21 => 40
    22 => 44
    23 => 53
    24 => 47
    25 => 49
    26 => 51
    27 => 52
    28 => 54
    29 => 55
    30 => 56
    31 => 57
    32 => 58
    33 => 59
    34 => 60
    35 => 539
    36 => 155
    37 => 571
    38 => 559
    39 => 265
    40 => 679
    41 => 688
    42 => 557
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#996
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#996}
    3 => Doctrine\DBAL\ParameterType {#996}
    4 => Doctrine\DBAL\ParameterType {#996}
    5 => Doctrine\DBAL\ParameterType {#996}
    6 => Doctrine\DBAL\ParameterType {#996}
    7 => Doctrine\DBAL\ParameterType {#996}
    8 => Doctrine\DBAL\ParameterType {#996}
    9 => Doctrine\DBAL\ParameterType {#996}
    10 => Doctrine\DBAL\ParameterType {#996}
    11 => Doctrine\DBAL\ParameterType {#996}
    12 => Doctrine\DBAL\ParameterType {#996}
    13 => Doctrine\DBAL\ParameterType {#996}
    14 => Doctrine\DBAL\ParameterType {#996}
    15 => Doctrine\DBAL\ParameterType {#996}
    16 => Doctrine\DBAL\ParameterType {#996}
    17 => Doctrine\DBAL\ParameterType {#996}
    18 => Doctrine\DBAL\ParameterType {#996}
    19 => Doctrine\DBAL\ParameterType {#996}
    20 => Doctrine\DBAL\ParameterType {#996}
    21 => Doctrine\DBAL\ParameterType {#996}
    22 => Doctrine\DBAL\ParameterType {#996}
    23 => Doctrine\DBAL\ParameterType {#996}
    24 => Doctrine\DBAL\ParameterType {#996}
    25 => Doctrine\DBAL\ParameterType {#996}
    26 => Doctrine\DBAL\ParameterType {#996}
    27 => Doctrine\DBAL\ParameterType {#996}
    28 => Doctrine\DBAL\ParameterType {#996}
    29 => Doctrine\DBAL\ParameterType {#996}
    30 => Doctrine\DBAL\ParameterType {#996}
    31 => Doctrine\DBAL\ParameterType {#996}
    32 => Doctrine\DBAL\ParameterType {#996}
    33 => Doctrine\DBAL\ParameterType {#996}
    34 => Doctrine\DBAL\ParameterType {#996}
    35 => Doctrine\DBAL\ParameterType {#996}
    36 => Doctrine\DBAL\ParameterType {#996}
    37 => Doctrine\DBAL\ParameterType {#996}
    38 => Doctrine\DBAL\ParameterType {#996}
    39 => Doctrine\DBAL\ParameterType {#996}
    40 => Doctrine\DBAL\ParameterType {#996}
    41 => Doctrine\DBAL\ParameterType {#996}
    42 => Doctrine\DBAL\ParameterType {#996}
  ]
]