| 1 |
241.15 ms |
SELECT p0_.created AS created_0, p0_.updated AS updated_1, p0_.id AS id_2, p0_.visible AS visible_3, p0_.archive AS archive_4, p0_.exclude_columbus AS exclude_columbus_5, p0_.nouveau AS nouveau_6, p0_.precommande AS precommande_7, p0_.precommande_date AS precommande_date_8, p0_.offre_speciale AS offre_speciale_9, p0_.cadeau AS cadeau_10, p0_.goodie AS goodie_11, p0_.declinaison AS declinaison_12, p0_.declinaison_principale AS declinaison_principale_13, p0_.reference AS reference_14, p0_.titre AS titre_15, p0_.titre_brouillon AS titre_brouillon_16, p0_.contenu AS contenu_17, p0_.contenu_brouillon AS contenu_brouillon_18, p0_.contenu2 AS contenu2_19, p0_.contenu2_brouillon AS contenu2_brouillon_20, p0_.slug AS slug_21, p0_.prix_achat_ht AS prix_achat_ht_22, p0_.montantHT AS montantHT_23, p0_.montantTTC AS montantTTC_24, p0_.montantActuelTTC AS montantActuelTTC_25, p0_.tva AS tva_26, p0_.stock AS stock_27, p0_.alerte_stock AS alerte_stock_28, p0_.stock_emaplacement AS stock_emaplacement_29, p0_.poids AS poids_30, p0_.recherche_keyword AS recherche_keyword_31, p0_.recherche_slug AS recherche_slug_32, p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33, p0_.produits_associes AS produits_associes_34, p0_.meta_title AS meta_title_35, p0_.meta_keyword AS meta_keyword_36, p0_.meta_description AS meta_description_37, p0_.note_avis AS note_avis_38, p0_.nb_avis AS nb_avis_39, p0_.image_panorama_name AS image_panorama_name_40, p0_.image_panorama_updated_at AS image_panorama_updated_at_41, p0_.image_portrait_name AS image_portrait_name_42, p0_.image_portrait_updated_at AS image_portrait_updated_at_43, p0_.image_name AS image_name_44, p0_.image_updated_at AS image_updated_at_45, p0_.image_alt AS image_alt_46, p0_.image_name_brouillon AS image_name_brouillon_47, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48, p0_.total_ca AS total_ca_49, p0_.count_commande AS count_commande_50, p0_.is_customizable AS is_customizable_51, c1_.id AS id_52, c1_.ordre AS ordre_53, c2_.id AS id_54, c2_.created AS created_55, c2_.updated AS updated_56, c2_.color AS color_57, c2_.with_associated_page AS with_associated_page_58, c2_.system AS system_59, c2_.auto AS auto_60, c2_.show_in_search AS show_in_search_61, c2_.total_ca AS total_ca_62, c2_.count_commande AS count_commande_63, c2_.titre AS titre_64, c2_.slug AS slug_65, p3_.created AS created_66, p3_.updated AS updated_67, p3_.id AS id_68, p3_.visible AS visible_69, p3_.archive AS archive_70, p3_.exclude_columbus AS exclude_columbus_71, p3_.nouveau AS nouveau_72, p3_.precommande AS precommande_73, p3_.precommande_date AS precommande_date_74, p3_.offre_speciale AS offre_speciale_75, p3_.cadeau AS cadeau_76, p3_.goodie AS goodie_77, p3_.declinaison AS declinaison_78, p3_.declinaison_principale AS declinaison_principale_79, p3_.reference AS reference_80, p3_.titre AS titre_81, p3_.titre_brouillon AS titre_brouillon_82, p3_.contenu AS contenu_83, p3_.contenu_brouillon AS contenu_brouillon_84, p3_.contenu2 AS contenu2_85, p3_.contenu2_brouillon AS contenu2_brouillon_86, p3_.slug AS slug_87, p3_.prix_achat_ht AS prix_achat_ht_88, p3_.montantHT AS montantHT_89, p3_.montantTTC AS montantTTC_90, p3_.montantActuelTTC AS montantActuelTTC_91, p3_.tva AS tva_92, p3_.stock AS stock_93, p3_.alerte_stock AS alerte_stock_94, p3_.stock_emaplacement AS stock_emaplacement_95, p3_.poids AS poids_96, p3_.recherche_keyword AS recherche_keyword_97, p3_.recherche_slug AS recherche_slug_98, p3_.recherche_carac_attr_slug AS recherche_carac_attr_slug_99, p3_.produits_associes AS produits_associes_100, p3_.meta_title AS meta_title_101, p3_.meta_keyword AS meta_keyword_102, p3_.meta_description AS meta_description_103, p3_.note_avis AS note_avis_104, p3_.nb_avis AS nb_avis_105, p3_.image_panorama_name AS image_panorama_name_106, p3_.image_panorama_updated_at AS image_panorama_updated_at_107, p3_.image_portrait_name AS image_portrait_name_108, p3_.image_portrait_updated_at AS image_portrait_updated_at_109, p3_.image_name AS image_name_110, p3_.image_updated_at AS image_updated_at_111, p3_.image_alt AS image_alt_112, p3_.image_name_brouillon AS image_name_brouillon_113, p3_.image_updated_at_brouillon AS image_updated_at_brouillon_114, p3_.total_ca AS total_ca_115, p3_.count_commande AS count_commande_116, p3_.is_customizable AS is_customizable_117, p0_.parent_id AS parent_id_118, c1_.produit_id AS produit_id_119, c1_.categorie_id AS categorie_id_120, p3_.parent_id AS parent_id_121 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id LEFT JOIN categorie c2_ ON c1_.categorie_id = c2_.id LEFT JOIN produit p3_ ON p0_.parent_id = p3_.id WHERE p0_.visible = ? AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.parent_id IS NULL AND (p0_.declinaison IS NULL OR p0_.declinaison = 0)) OR p0_.parent_id IS NOT NULL) ORDER BY p0_.reference ASC, c1_.ordre ASC
SELECT
p0_.created AS created_0,
p0_.updated AS updated_1,
p0_.id AS id_2,
p0_.visible AS visible_3,
p0_.archive AS archive_4,
p0_.exclude_columbus AS exclude_columbus_5,
p0_.nouveau AS nouveau_6,
p0_.precommande AS precommande_7,
p0_.precommande_date AS precommande_date_8,
p0_.offre_speciale AS offre_speciale_9,
p0_.cadeau AS cadeau_10,
p0_.goodie AS goodie_11,
p0_.declinaison AS declinaison_12,
p0_.declinaison_principale AS declinaison_principale_13,
p0_.reference AS reference_14,
p0_.titre AS titre_15,
p0_.titre_brouillon AS titre_brouillon_16,
p0_.contenu AS contenu_17,
p0_.contenu_brouillon AS contenu_brouillon_18,
p0_.contenu2 AS contenu2_19,
p0_.contenu2_brouillon AS contenu2_brouillon_20,
p0_.slug AS slug_21,
p0_.prix_achat_ht AS prix_achat_ht_22,
p0_.montantHT AS montantHT_23,
p0_.montantTTC AS montantTTC_24,
p0_.montantActuelTTC AS montantActuelTTC_25,
p0_.tva AS tva_26,
p0_.stock AS stock_27,
p0_.alerte_stock AS alerte_stock_28,
p0_.stock_emaplacement AS stock_emaplacement_29,
p0_.poids AS poids_30,
p0_.recherche_keyword AS recherche_keyword_31,
p0_.recherche_slug AS recherche_slug_32,
p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33,
p0_.produits_associes AS produits_associes_34,
p0_.meta_title AS meta_title_35,
p0_.meta_keyword AS meta_keyword_36,
p0_.meta_description AS meta_description_37,
p0_.note_avis AS note_avis_38,
p0_.nb_avis AS nb_avis_39,
p0_.image_panorama_name AS image_panorama_name_40,
p0_.image_panorama_updated_at AS image_panorama_updated_at_41,
p0_.image_portrait_name AS image_portrait_name_42,
p0_.image_portrait_updated_at AS image_portrait_updated_at_43,
p0_.image_name AS image_name_44,
p0_.image_updated_at AS image_updated_at_45,
p0_.image_alt AS image_alt_46,
p0_.image_name_brouillon AS image_name_brouillon_47,
p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48,
p0_.total_ca AS total_ca_49,
p0_.count_commande AS count_commande_50,
p0_.is_customizable AS is_customizable_51,
c1_.id AS id_52,
c1_.ordre AS ordre_53,
c2_.id AS id_54,
c2_.created AS created_55,
c2_.updated AS updated_56,
c2_.color AS color_57,
c2_.with_associated_page AS with_associated_page_58,
c2_.system AS system_59,
c2_.auto AS auto_60,
c2_.show_in_search AS show_in_search_61,
c2_.total_ca AS total_ca_62,
c2_.count_commande AS count_commande_63,
c2_.titre AS titre_64,
c2_.slug AS slug_65,
p3_.created AS created_66,
p3_.updated AS updated_67,
p3_.id AS id_68,
p3_.visible AS visible_69,
p3_.archive AS archive_70,
p3_.exclude_columbus AS exclude_columbus_71,
p3_.nouveau AS nouveau_72,
p3_.precommande AS precommande_73,
p3_.precommande_date AS precommande_date_74,
p3_.offre_speciale AS offre_speciale_75,
p3_.cadeau AS cadeau_76,
p3_.goodie AS goodie_77,
p3_.declinaison AS declinaison_78,
p3_.declinaison_principale AS declinaison_principale_79,
p3_.reference AS reference_80,
p3_.titre AS titre_81,
p3_.titre_brouillon AS titre_brouillon_82,
p3_.contenu AS contenu_83,
p3_.contenu_brouillon AS contenu_brouillon_84,
p3_.contenu2 AS contenu2_85,
p3_.contenu2_brouillon AS contenu2_brouillon_86,
p3_.slug AS slug_87,
p3_.prix_achat_ht AS prix_achat_ht_88,
p3_.montantHT AS montantHT_89,
p3_.montantTTC AS montantTTC_90,
p3_.montantActuelTTC AS montantActuelTTC_91,
p3_.tva AS tva_92,
p3_.stock AS stock_93,
p3_.alerte_stock AS alerte_stock_94,
p3_.stock_emaplacement AS stock_emaplacement_95,
p3_.poids AS poids_96,
p3_.recherche_keyword AS recherche_keyword_97,
p3_.recherche_slug AS recherche_slug_98,
p3_.recherche_carac_attr_slug AS recherche_carac_attr_slug_99,
p3_.produits_associes AS produits_associes_100,
p3_.meta_title AS meta_title_101,
p3_.meta_keyword AS meta_keyword_102,
p3_.meta_description AS meta_description_103,
p3_.note_avis AS note_avis_104,
p3_.nb_avis AS nb_avis_105,
p3_.image_panorama_name AS image_panorama_name_106,
p3_.image_panorama_updated_at AS image_panorama_updated_at_107,
p3_.image_portrait_name AS image_portrait_name_108,
p3_.image_portrait_updated_at AS image_portrait_updated_at_109,
p3_.image_name AS image_name_110,
p3_.image_updated_at AS image_updated_at_111,
p3_.image_alt AS image_alt_112,
p3_.image_name_brouillon AS image_name_brouillon_113,
p3_.image_updated_at_brouillon AS image_updated_at_brouillon_114,
p3_.total_ca AS total_ca_115,
p3_.count_commande AS count_commande_116,
p3_.is_customizable AS is_customizable_117,
p0_.parent_id AS parent_id_118,
c1_.produit_id AS produit_id_119,
c1_.categorie_id AS categorie_id_120,
p3_.parent_id AS parent_id_121
FROM
produit p0_
LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id
LEFT JOIN categorie c2_ ON c1_.categorie_id = c2_.id
LEFT JOIN produit p3_ ON p0_.parent_id = p3_.id
WHERE
p0_.visible = ?
AND (
(
p0_.cadeau IS NULL
OR p0_.cadeau = 0
)
)
AND (
(
p0_.parent_id IS NULL
AND (
p0_.declinaison IS NULL
OR p0_.declinaison = 0
)
)
OR p0_.parent_id IS NOT NULL
)
ORDER BY
p0_.reference ASC,
c1_.ordre ASC
SELECT p0_.created AS created_0, p0_.updated AS updated_1, p0_.id AS id_2, p0_.visible AS visible_3, p0_.archive AS archive_4, p0_.exclude_columbus AS exclude_columbus_5, p0_.nouveau AS nouveau_6, p0_.precommande AS precommande_7, p0_.precommande_date AS precommande_date_8, p0_.offre_speciale AS offre_speciale_9, p0_.cadeau AS cadeau_10, p0_.goodie AS goodie_11, p0_.declinaison AS declinaison_12, p0_.declinaison_principale AS declinaison_principale_13, p0_.reference AS reference_14, p0_.titre AS titre_15, p0_.titre_brouillon AS titre_brouillon_16, p0_.contenu AS contenu_17, p0_.contenu_brouillon AS contenu_brouillon_18, p0_.contenu2 AS contenu2_19, p0_.contenu2_brouillon AS contenu2_brouillon_20, p0_.slug AS slug_21, p0_.prix_achat_ht AS prix_achat_ht_22, p0_.montantHT AS montantHT_23, p0_.montantTTC AS montantTTC_24, p0_.montantActuelTTC AS montantActuelTTC_25, p0_.tva AS tva_26, p0_.stock AS stock_27, p0_.alerte_stock AS alerte_stock_28, p0_.stock_emaplacement AS stock_emaplacement_29, p0_.poids AS poids_30, p0_.recherche_keyword AS recherche_keyword_31, p0_.recherche_slug AS recherche_slug_32, p0_.recherche_carac_attr_slug AS recherche_carac_attr_slug_33, p0_.produits_associes AS produits_associes_34, p0_.meta_title AS meta_title_35, p0_.meta_keyword AS meta_keyword_36, p0_.meta_description AS meta_description_37, p0_.note_avis AS note_avis_38, p0_.nb_avis AS nb_avis_39, p0_.image_panorama_name AS image_panorama_name_40, p0_.image_panorama_updated_at AS image_panorama_updated_at_41, p0_.image_portrait_name AS image_portrait_name_42, p0_.image_portrait_updated_at AS image_portrait_updated_at_43, p0_.image_name AS image_name_44, p0_.image_updated_at AS image_updated_at_45, p0_.image_alt AS image_alt_46, p0_.image_name_brouillon AS image_name_brouillon_47, p0_.image_updated_at_brouillon AS image_updated_at_brouillon_48, p0_.total_ca AS total_ca_49, p0_.count_commande AS count_commande_50, p0_.is_customizable AS is_customizable_51, c1_.id AS id_52, c1_.ordre AS ordre_53, c2_.id AS id_54, c2_.created AS created_55, c2_.updated AS updated_56, c2_.color AS color_57, c2_.with_associated_page AS with_associated_page_58, c2_.system AS system_59, c2_.auto AS auto_60, c2_.show_in_search AS show_in_search_61, c2_.total_ca AS total_ca_62, c2_.count_commande AS count_commande_63, c2_.titre AS titre_64, c2_.slug AS slug_65, p3_.created AS created_66, p3_.updated AS updated_67, p3_.id AS id_68, p3_.visible AS visible_69, p3_.archive AS archive_70, p3_.exclude_columbus AS exclude_columbus_71, p3_.nouveau AS nouveau_72, p3_.precommande AS precommande_73, p3_.precommande_date AS precommande_date_74, p3_.offre_speciale AS offre_speciale_75, p3_.cadeau AS cadeau_76, p3_.goodie AS goodie_77, p3_.declinaison AS declinaison_78, p3_.declinaison_principale AS declinaison_principale_79, p3_.reference AS reference_80, p3_.titre AS titre_81, p3_.titre_brouillon AS titre_brouillon_82, p3_.contenu AS contenu_83, p3_.contenu_brouillon AS contenu_brouillon_84, p3_.contenu2 AS contenu2_85, p3_.contenu2_brouillon AS contenu2_brouillon_86, p3_.slug AS slug_87, p3_.prix_achat_ht AS prix_achat_ht_88, p3_.montantHT AS montantHT_89, p3_.montantTTC AS montantTTC_90, p3_.montantActuelTTC AS montantActuelTTC_91, p3_.tva AS tva_92, p3_.stock AS stock_93, p3_.alerte_stock AS alerte_stock_94, p3_.stock_emaplacement AS stock_emaplacement_95, p3_.poids AS poids_96, p3_.recherche_keyword AS recherche_keyword_97, p3_.recherche_slug AS recherche_slug_98, p3_.recherche_carac_attr_slug AS recherche_carac_attr_slug_99, p3_.produits_associes AS produits_associes_100, p3_.meta_title AS meta_title_101, p3_.meta_keyword AS meta_keyword_102, p3_.meta_description AS meta_description_103, p3_.note_avis AS note_avis_104, p3_.nb_avis AS nb_avis_105, p3_.image_panorama_name AS image_panorama_name_106, p3_.image_panorama_updated_at AS image_panorama_updated_at_107, p3_.image_portrait_name AS image_portrait_name_108, p3_.image_portrait_updated_at AS image_portrait_updated_at_109, p3_.image_name AS image_name_110, p3_.image_updated_at AS image_updated_at_111, p3_.image_alt AS image_alt_112, p3_.image_name_brouillon AS image_name_brouillon_113, p3_.image_updated_at_brouillon AS image_updated_at_brouillon_114, p3_.total_ca AS total_ca_115, p3_.count_commande AS count_commande_116, p3_.is_customizable AS is_customizable_117, p0_.parent_id AS parent_id_118, c1_.produit_id AS produit_id_119, c1_.categorie_id AS categorie_id_120, p3_.parent_id AS parent_id_121 FROM produit p0_ LEFT JOIN categorie_produit c1_ ON p0_.id = c1_.produit_id LEFT JOIN categorie c2_ ON c1_.categorie_id = c2_.id LEFT JOIN produit p3_ ON p0_.parent_id = p3_.id WHERE p0_.visible = 1 AND ((p0_.cadeau IS NULL OR p0_.cadeau = 0)) AND ((p0_.parent_id IS NULL AND (p0_.declinaison IS NULL OR p0_.declinaison = 0)) OR p0_.parent_id IS NOT NULL) ORDER BY p0_.reference ASC, c1_.ordre ASC;
|