Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.type AS type_5,
  t0.users_id AS users_id_6,
  t7.id AS id_8,
  t7.civility AS civility_9,
  t7.first_name AS first_name_10,
  t7.last_name AS last_name_11,
  t7.phone AS phone_12,
  t7.wedding_date AS wedding_date_13,
  t7.image AS image_14,
  t7.id_stripe AS id_stripe_15,
  t7.livraison_adress AS livraison_adress_16,
  t7.livraison_zip_code AS livraison_zip_code_17,
  t7.livraison_city AS livraison_city_18,
  t7.birth_at AS birth_at_19,
  t7.nationality AS nationality_20,
  t7.country_residence AS country_residence_21,
  t7.mango_id AS mango_id_22,
  t7.is_valid AS is_valid_23,
  t7.service_address AS service_address_24,
  t7.service_zip_code AS service_zip_code_25,
  t7.service_city AS service_city_26,
  t7.statu_con AS statu_con_27,
  t7.etat_network AS etat_network_28,
  t7.roles AS roles_29,
  t7.email AS email_30,
  t7.password AS password_31,
  t7.adress AS adress_32,
  t7.zip_code AS zip_code_33,
  t7.city AS city_34,
  t0.categorys_id AS categorys_id_35,
  t0.category_annonce_client_id AS category_annonce_client_id_36,
  t37.id AS id_38,
  t37.name AS name_39,
  t0.subcategory_id AS subcategory_id_40
FROM
  annonce t0
  LEFT JOIN user t7 ON t0.users_id = t7.id
  LEFT JOIN category_annonce_client t37 ON t0.category_annonce_client_id = t37.id

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.type AS type_5, t0.users_id AS users_id_6, t7.id AS id_8, t7.civility AS civility_9, t7.first_name AS first_name_10, t7.last_name AS last_name_11, t7.phone AS phone_12, t7.wedding_date AS wedding_date_13, t7.image AS image_14, t7.id_stripe AS id_stripe_15, t7.livraison_adress AS livraison_adress_16, t7.livraison_zip_code AS livraison_zip_code_17, t7.livraison_city AS livraison_city_18, t7.birth_at AS birth_at_19, t7.nationality AS nationality_20, t7.country_residence AS country_residence_21, t7.mango_id AS mango_id_22, t7.is_valid AS is_valid_23, t7.service_address AS service_address_24, t7.service_zip_code AS service_zip_code_25, t7.service_city AS service_city_26, t7.statu_con AS statu_con_27, t7.etat_network AS etat_network_28, t7.roles AS roles_29, t7.email AS email_30, t7.password AS password_31, t7.adress AS adress_32, t7.zip_code AS zip_code_33, t7.city AS city_34, t0.categorys_id AS categorys_id_35, t0.category_annonce_client_id AS category_annonce_client_id_36, t37.id AS id_38, t37.name AS name_39, t0.subcategory_id AS subcategory_id_40 FROM annonce t0 LEFT JOIN user t7 ON t0.users_id = t7.id LEFT JOIN category_annonce_client t37 ON t0.category_annonce_client_id = t37.id;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.description AS description_2,
  a0_.created_at AS created_at_3,
  a0_.type AS type_4,
  a0_.users_id AS users_id_5,
  a0_.categorys_id AS categorys_id_6,
  a0_.category_annonce_client_id AS category_annonce_client_id_7,
  a0_.subcategory_id AS subcategory_id_8
FROM
  annonce a0_
ORDER BY
  a0_.created_at DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.description AS description_2, a0_.created_at AS created_at_3, a0_.type AS type_4, a0_.users_id AS users_id_5, a0_.categorys_id AS categorys_id_6, a0_.category_annonce_client_id AS category_annonce_client_id_7, a0_.subcategory_id AS subcategory_id_8 FROM annonce a0_ ORDER BY a0_.created_at DESC LIMIT 3;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.description AS description_2,
  a0_.created_at AS created_at_3,
  a0_.type AS type_4,
  c1_.id AS id_5,
  c1_.siren AS siren_6,
  c1_.contact_name AS contact_name_7,
  c1_.contact_phone AS contact_phone_8,
  c1_.company_name AS company_name_9,
  c1_.fax AS fax_10,
  c1_.website AS website_11,
  c1_.contact_civility AS contact_civility_12,
  c1_.is_accept_condition AS is_accept_condition_13,
  c1_.company_slug AS company_slug_14,
  c1_.description AS description_15,
  c1_.image AS image_16,
  c1_.is_confirmed AS is_confirmed_17,
  c1_.kbis AS kbis_18,
  c1_.conditions_vente AS conditions_vente_19,
  c1_.strip_id AS strip_id_20,
  c1_.stripe_account AS stripe_account_21,
  c1_.first_name AS first_name_22,
  c1_.contact_birthday AS contact_birthday_23,
  c1_.country AS country_24,
  c1_.mango_id AS mango_id_25,
  c1_.is_valid_document AS is_valid_document_26,
  c1_.type AS type_27,
  c1_.is_editor_guide AS is_editor_guide_28,
  c1_.paiement_activ AS paiement_activ_29,
  c1_.commission_active AS commission_active_30,
  c1_.statu_con AS statu_con_31,
  c1_.etat_network AS etat_network_32,
  c1_.created_at AS created_at_33,
  c1_.is_direct_reservation_mode AS is_direct_reservation_mode_34,
  c1_.stripe_id AS stripe_id_35,
  c1_.stripe_account_id AS stripe_account_id_36,
  c1_.roles AS roles_37,
  c1_.email AS email_38,
  c1_.password AS password_39,
  c1_.adress AS adress_40,
  c1_.zip_code AS zip_code_41,
  c1_.city AS city_42,
  p2_.id AS id_43,
  p2_.name AS name_44,
  p2_.text AS text_45,
  p2_.price AS price_46,
  p2_.quantity AS quantity_47,
  p2_.product_slug AS product_slug_48,
  p2_.percent_deposit AS percent_deposit_49,
  p2_.deadline AS deadline_50,
  p2_.sizes AS sizes_51,
  p2_.colors AS colors_52,
  p2_.size_ring AS size_ring_53,
  p2_.nb_guest AS nb_guest_54,
  p2_.youtube_video AS youtube_video_55,
  p2_.is_activated AS is_activated_56,
  p2_.is_desactivated_by_admin AS is_desactivated_by_admin_57,
  p2_.mode_livraison AS mode_livraison_58,
  p2_.frais_livraison AS frais_livraison_59,
  p2_.weight AS weight_60,
  p2_.transporteurs AS transporteurs_61,
  p2_.code_promo AS code_promo_62,
  p2_.code_promo_euro AS code_promo_euro_63,
  p2_.template AS template_64,
  p2_.taxe_sejour AS taxe_sejour_65,
  p2_.prix_caution AS prix_caution_66,
  p2_.longitude AS longitude_67,
  p2_.latitude AS latitude_68,
  p2_.spring_price AS spring_price_69,
  p2_.summer_price AS summer_price_70,
  p2_.autumn_price AS autumn_price_71,
  p2_.winter_price AS winter_price_72,
  p2_.week_end_price AS week_end_price_73,
  p2_.city_localisation AS city_localisation_74,
  p2_.nb_chambre AS nb_chambre_75,
  p2_.night_min AS night_min_76,
  a0_.companys_id AS companys_id_77,
  a0_.products_id AS products_id_78,
  a0_.category_annonce_prestataire_id AS category_annonce_prestataire_id_79,
  p2_.company_id AS company_id_80,
  p2_.pack_id AS pack_id_81,
  p2_.type_location_id AS type_location_id_82,
  p2_.type_prestation_id AS type_prestation_id_83,
  p2_.tva_id AS tva_id_84,
  p2_.type_hebergements_id AS type_hebergements_id_85,
  p2_.type_activity_id AS type_activity_id_86,
  p2_.caracteristique_vehicule_id AS caracteristique_vehicule_id_87,
  p2_.commune_id AS commune_id_88
FROM
  annonce_company a0_
  LEFT JOIN company c1_ ON a0_.companys_id = c1_.id
  LEFT JOIN product p2_ ON a0_.products_id = p2_.id
ORDER BY
  a0_.created_at DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.description AS description_2, a0_.created_at AS created_at_3, a0_.type AS type_4, c1_.id AS id_5, c1_.siren AS siren_6, c1_.contact_name AS contact_name_7, c1_.contact_phone AS contact_phone_8, c1_.company_name AS company_name_9, c1_.fax AS fax_10, c1_.website AS website_11, c1_.contact_civility AS contact_civility_12, c1_.is_accept_condition AS is_accept_condition_13, c1_.company_slug AS company_slug_14, c1_.description AS description_15, c1_.image AS image_16, c1_.is_confirmed AS is_confirmed_17, c1_.kbis AS kbis_18, c1_.conditions_vente AS conditions_vente_19, c1_.strip_id AS strip_id_20, c1_.stripe_account AS stripe_account_21, c1_.first_name AS first_name_22, c1_.contact_birthday AS contact_birthday_23, c1_.country AS country_24, c1_.mango_id AS mango_id_25, c1_.is_valid_document AS is_valid_document_26, c1_.type AS type_27, c1_.is_editor_guide AS is_editor_guide_28, c1_.paiement_activ AS paiement_activ_29, c1_.commission_active AS commission_active_30, c1_.statu_con AS statu_con_31, c1_.etat_network AS etat_network_32, c1_.created_at AS created_at_33, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_34, c1_.stripe_id AS stripe_id_35, c1_.stripe_account_id AS stripe_account_id_36, c1_.roles AS roles_37, c1_.email AS email_38, c1_.password AS password_39, c1_.adress AS adress_40, c1_.zip_code AS zip_code_41, c1_.city AS city_42, p2_.id AS id_43, p2_.name AS name_44, p2_.text AS text_45, p2_.price AS price_46, p2_.quantity AS quantity_47, p2_.product_slug AS product_slug_48, p2_.percent_deposit AS percent_deposit_49, p2_.deadline AS deadline_50, p2_.sizes AS sizes_51, p2_.colors AS colors_52, p2_.size_ring AS size_ring_53, p2_.nb_guest AS nb_guest_54, p2_.youtube_video AS youtube_video_55, p2_.is_activated AS is_activated_56, p2_.is_desactivated_by_admin AS is_desactivated_by_admin_57, p2_.mode_livraison AS mode_livraison_58, p2_.frais_livraison AS frais_livraison_59, p2_.weight AS weight_60, p2_.transporteurs AS transporteurs_61, p2_.code_promo AS code_promo_62, p2_.code_promo_euro AS code_promo_euro_63, p2_.template AS template_64, p2_.taxe_sejour AS taxe_sejour_65, p2_.prix_caution AS prix_caution_66, p2_.longitude AS longitude_67, p2_.latitude AS latitude_68, p2_.spring_price AS spring_price_69, p2_.summer_price AS summer_price_70, p2_.autumn_price AS autumn_price_71, p2_.winter_price AS winter_price_72, p2_.week_end_price AS week_end_price_73, p2_.city_localisation AS city_localisation_74, p2_.nb_chambre AS nb_chambre_75, p2_.night_min AS night_min_76, a0_.companys_id AS companys_id_77, a0_.products_id AS products_id_78, a0_.category_annonce_prestataire_id AS category_annonce_prestataire_id_79, p2_.company_id AS company_id_80, p2_.pack_id AS pack_id_81, p2_.type_location_id AS type_location_id_82, p2_.type_prestation_id AS type_prestation_id_83, p2_.tva_id AS tva_id_84, p2_.type_hebergements_id AS type_hebergements_id_85, p2_.type_activity_id AS type_activity_id_86, p2_.caracteristique_vehicule_id AS caracteristique_vehicule_id_87, p2_.commune_id AS commune_id_88 FROM annonce_company a0_ LEFT JOIN company c1_ ON a0_.companys_id = c1_.id LEFT JOIN product p2_ ON a0_.products_id = p2_.id ORDER BY a0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.type AS type_5,
  t0.companys_id AS companys_id_6,
  t0.products_id AS products_id_7,
  t0.category_annonce_prestataire_id AS category_annonce_prestataire_id_8
FROM
  annonce_company t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.type AS type_5, t0.companys_id AS companys_id_6, t0.products_id AS products_id_7, t0.category_annonce_prestataire_id AS category_annonce_prestataire_id_8 FROM annonce_company t0;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.text AS text_2,
  p0_.price AS price_3,
  p0_.quantity AS quantity_4,
  p0_.product_slug AS product_slug_5,
  p0_.percent_deposit AS percent_deposit_6,
  p0_.deadline AS deadline_7,
  p0_.sizes AS sizes_8,
  p0_.colors AS colors_9,
  p0_.size_ring AS size_ring_10,
  p0_.nb_guest AS nb_guest_11,
  p0_.youtube_video AS youtube_video_12,
  p0_.is_activated AS is_activated_13,
  p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14,
  p0_.mode_livraison AS mode_livraison_15,
  p0_.frais_livraison AS frais_livraison_16,
  p0_.weight AS weight_17,
  p0_.transporteurs AS transporteurs_18,
  p0_.code_promo AS code_promo_19,
  p0_.code_promo_euro AS code_promo_euro_20,
  p0_.template AS template_21,
  p0_.taxe_sejour AS taxe_sejour_22,
  p0_.prix_caution AS prix_caution_23,
  p0_.longitude AS longitude_24,
  p0_.latitude AS latitude_25,
  p0_.spring_price AS spring_price_26,
  p0_.summer_price AS summer_price_27,
  p0_.autumn_price AS autumn_price_28,
  p0_.winter_price AS winter_price_29,
  p0_.week_end_price AS week_end_price_30,
  p0_.city_localisation AS city_localisation_31,
  p0_.nb_chambre AS nb_chambre_32,
  p0_.night_min AS night_min_33,
  d1_.id AS id_34,
  d1_.name AS name_35,
  d1_.numero AS numero_36,
  p0_.company_id AS company_id_37,
  p0_.pack_id AS pack_id_38,
  p0_.type_location_id AS type_location_id_39,
  p0_.type_prestation_id AS type_prestation_id_40,
  p0_.tva_id AS tva_id_41,
  p0_.type_hebergements_id AS type_hebergements_id_42,
  p0_.type_activity_id AS type_activity_id_43,
  p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_44,
  p0_.commune_id AS commune_id_45
FROM
  product p0_
  LEFT JOIN product_department p2_ ON p0_.id = p2_.product_id
  LEFT JOIN department d1_ ON d1_.id = p2_.department_id
  LEFT JOIN company c3_ ON p0_.company_id = c3_.id
  INNER JOIN product_sub_category p5_ ON p0_.id = p5_.product_id
  INNER JOIN sub_category s4_ ON s4_.id = p5_.sub_category_id
WHERE
  c3_.is_confirmed = 1
  AND c3_.is_valid_document = 1
  AND p0_.is_activated = 1
  AND (
    s4_.is_service IS NULL
    OR s4_.is_service = 0
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.text AS text_2, p0_.price AS price_3, p0_.quantity AS quantity_4, p0_.product_slug AS product_slug_5, p0_.percent_deposit AS percent_deposit_6, p0_.deadline AS deadline_7, p0_.sizes AS sizes_8, p0_.colors AS colors_9, p0_.size_ring AS size_ring_10, p0_.nb_guest AS nb_guest_11, p0_.youtube_video AS youtube_video_12, p0_.is_activated AS is_activated_13, p0_.is_desactivated_by_admin AS is_desactivated_by_admin_14, p0_.mode_livraison AS mode_livraison_15, p0_.frais_livraison AS frais_livraison_16, p0_.weight AS weight_17, p0_.transporteurs AS transporteurs_18, p0_.code_promo AS code_promo_19, p0_.code_promo_euro AS code_promo_euro_20, p0_.template AS template_21, p0_.taxe_sejour AS taxe_sejour_22, p0_.prix_caution AS prix_caution_23, p0_.longitude AS longitude_24, p0_.latitude AS latitude_25, p0_.spring_price AS spring_price_26, p0_.summer_price AS summer_price_27, p0_.autumn_price AS autumn_price_28, p0_.winter_price AS winter_price_29, p0_.week_end_price AS week_end_price_30, p0_.city_localisation AS city_localisation_31, p0_.nb_chambre AS nb_chambre_32, p0_.night_min AS night_min_33, d1_.id AS id_34, d1_.name AS name_35, d1_.numero AS numero_36, p0_.company_id AS company_id_37, p0_.pack_id AS pack_id_38, p0_.type_location_id AS type_location_id_39, p0_.type_prestation_id AS type_prestation_id_40, p0_.tva_id AS tva_id_41, p0_.type_hebergements_id AS type_hebergements_id_42, p0_.type_activity_id AS type_activity_id_43, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_44, p0_.commune_id AS commune_id_45 FROM product p0_ LEFT JOIN product_department p2_ ON p0_.id = p2_.product_id LEFT JOIN department d1_ ON d1_.id = p2_.department_id LEFT JOIN company c3_ ON p0_.company_id = c3_.id INNER JOIN product_sub_category p5_ ON p0_.id = p5_.product_id INNER JOIN sub_category s4_ ON s4_.id = p5_.sub_category_id WHERE c3_.is_confirmed = 1 AND c3_.is_valid_document = 1 AND p0_.is_activated = 1 AND (s4_.is_service IS NULL OR s4_.is_service = 0) ORDER BY p0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.text AS text_3,
  t0.price AS price_4,
  t0.quantity AS quantity_5,
  t0.product_slug AS product_slug_6,
  t0.percent_deposit AS percent_deposit_7,
  t0.deadline AS deadline_8,
  t0.sizes AS sizes_9,
  t0.colors AS colors_10,
  t0.size_ring AS size_ring_11,
  t0.nb_guest AS nb_guest_12,
  t0.youtube_video AS youtube_video_13,
  t0.is_activated AS is_activated_14,
  t0.is_desactivated_by_admin AS is_desactivated_by_admin_15,
  t0.mode_livraison AS mode_livraison_16,
  t0.frais_livraison AS frais_livraison_17,
  t0.weight AS weight_18,
  t0.transporteurs AS transporteurs_19,
  t0.code_promo AS code_promo_20,
  t0.code_promo_euro AS code_promo_euro_21,
  t0.template AS template_22,
  t0.taxe_sejour AS taxe_sejour_23,
  t0.prix_caution AS prix_caution_24,
  t0.longitude AS longitude_25,
  t0.latitude AS latitude_26,
  t0.spring_price AS spring_price_27,
  t0.summer_price AS summer_price_28,
  t0.autumn_price AS autumn_price_29,
  t0.winter_price AS winter_price_30,
  t0.week_end_price AS week_end_price_31,
  t0.city_localisation AS city_localisation_32,
  t0.nb_chambre AS nb_chambre_33,
  t0.night_min AS night_min_34,
  t0.company_id AS company_id_35,
  t0.pack_id AS pack_id_36,
  t37.id AS id_38,
  t37.title AS title_39,
  t37.synthetique_message AS synthetique_message_40,
  t37.photo1 AS photo1_41,
  t37.description AS description_42,
  t37.photo2 AS photo2_43,
  t37.details AS details_44,
  t37.photo3 AS photo3_45,
  t37.product_id AS product_id_46,
  t0.type_location_id AS type_location_id_47,
  t0.type_prestation_id AS type_prestation_id_48,
  t0.tva_id AS tva_id_49,
  t0.type_hebergements_id AS type_hebergements_id_50,
  t0.type_activity_id AS type_activity_id_51,
  t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52,
  t0.commune_id AS commune_id_53
FROM
  product t0
  LEFT JOIN product_description t37 ON t37.product_id = t0.id
ORDER BY
  t0.id DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.product_slug AS product_slug_6, t0.percent_deposit AS percent_deposit_7, t0.deadline AS deadline_8, t0.sizes AS sizes_9, t0.colors AS colors_10, t0.size_ring AS size_ring_11, t0.nb_guest AS nb_guest_12, t0.youtube_video AS youtube_video_13, t0.is_activated AS is_activated_14, t0.is_desactivated_by_admin AS is_desactivated_by_admin_15, t0.mode_livraison AS mode_livraison_16, t0.frais_livraison AS frais_livraison_17, t0.weight AS weight_18, t0.transporteurs AS transporteurs_19, t0.code_promo AS code_promo_20, t0.code_promo_euro AS code_promo_euro_21, t0.template AS template_22, t0.taxe_sejour AS taxe_sejour_23, t0.prix_caution AS prix_caution_24, t0.longitude AS longitude_25, t0.latitude AS latitude_26, t0.spring_price AS spring_price_27, t0.summer_price AS summer_price_28, t0.autumn_price AS autumn_price_29, t0.winter_price AS winter_price_30, t0.week_end_price AS week_end_price_31, t0.city_localisation AS city_localisation_32, t0.nb_chambre AS nb_chambre_33, t0.night_min AS night_min_34, t0.company_id AS company_id_35, t0.pack_id AS pack_id_36, t37.id AS id_38, t37.title AS title_39, t37.synthetique_message AS synthetique_message_40, t37.photo1 AS photo1_41, t37.description AS description_42, t37.photo2 AS photo2_43, t37.details AS details_44, t37.photo3 AS photo3_45, t37.product_id AS product_id_46, t0.type_location_id AS type_location_id_47, t0.type_prestation_id AS type_prestation_id_48, t0.tva_id AS tva_id_49, t0.type_hebergements_id AS type_hebergements_id_50, t0.type_activity_id AS type_activity_id_51, t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52, t0.commune_id AS commune_id_53 FROM product t0 LEFT JOIN product_description t37 ON t37.product_id = t0.id ORDER BY t0.id DESC LIMIT 6;

SELECT
  a0_.id AS id_0,
  a0_.service_quality AS service_quality_1,
  a0_.fiability AS fiability_2,
  a0_.price AS price_3,
  a0_.speed AS speed_4,
  a0_.text AS text_5,
  a0_.conform_description AS conform_description_6,
  a0_.communication AS communication_7,
  a0_.global_note AS global_note_8,
  a0_.created_at AS created_at_9,
  a0_.response_company AS response_company_10,
  a0_.is_desactivated_by_admin AS is_desactivated_by_admin_11,
  a0_.product_id AS product_id_12,
  a0_.client_id AS client_id_13
FROM
  avis a0_
WHERE
  a0_.text IS NOT NULL
ORDER BY
  a0_.id DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.service_quality AS service_quality_1, a0_.fiability AS fiability_2, a0_.price AS price_3, a0_.speed AS speed_4, a0_.text AS text_5, a0_.conform_description AS conform_description_6, a0_.communication AS communication_7, a0_.global_note AS global_note_8, a0_.created_at AS created_at_9, a0_.response_company AS response_company_10, a0_.is_desactivated_by_admin AS is_desactivated_by_admin_11, a0_.product_id AS product_id_12, a0_.client_id AS client_id_13 FROM avis a0_ WHERE a0_.text IS NOT NULL ORDER BY a0_.id DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.image1 AS image1_2,
  t0.image2 AS image2_3,
  t0.image3 AS image3_4
FROM
  slider t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.image1 AS image1_2, t0.image2 AS image2_3, t0.image3 AS image3_4 FROM slider t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.slug AS slug_4
FROM
  category t0
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.slug AS slug_4 FROM category t0 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sub_category_slug AS sub_category_slug_3,
  t0.is_suivi AS is_suivi_4,
  t0.is_clothing AS is_clothing_5,
  t0.is_color AS is_color_6,
  t0.is_nb_guest AS is_nb_guest_7,
  t0.image AS image_8,
  t0.is_clothing_ring AS is_clothing_ring_9,
  t0.is_service AS is_service_10,
  t0.is_fairepart AS is_fairepart_11,
  t0.is_vehicle AS is_vehicle_12
FROM
  sub_category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id
WHERE
  sub_category_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id WHERE sub_category_category.category_id = 32;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.text AS text_3,
  t0.price AS price_4,
  t0.quantity AS quantity_5,
  t0.product_slug AS product_slug_6,
  t0.percent_deposit AS percent_deposit_7,
  t0.deadline AS deadline_8,
  t0.sizes AS sizes_9,
  t0.colors AS colors_10,
  t0.size_ring AS size_ring_11,
  t0.nb_guest AS nb_guest_12,
  t0.youtube_video AS youtube_video_13,
  t0.is_activated AS is_activated_14,
  t0.is_desactivated_by_admin AS is_desactivated_by_admin_15,
  t0.mode_livraison AS mode_livraison_16,
  t0.frais_livraison AS frais_livraison_17,
  t0.weight AS weight_18,
  t0.transporteurs AS transporteurs_19,
  t0.code_promo AS code_promo_20,
  t0.code_promo_euro AS code_promo_euro_21,
  t0.template AS template_22,
  t0.taxe_sejour AS taxe_sejour_23,
  t0.prix_caution AS prix_caution_24,
  t0.longitude AS longitude_25,
  t0.latitude AS latitude_26,
  t0.spring_price AS spring_price_27,
  t0.summer_price AS summer_price_28,
  t0.autumn_price AS autumn_price_29,
  t0.winter_price AS winter_price_30,
  t0.week_end_price AS week_end_price_31,
  t0.city_localisation AS city_localisation_32,
  t0.nb_chambre AS nb_chambre_33,
  t0.night_min AS night_min_34,
  t0.company_id AS company_id_35,
  t0.pack_id AS pack_id_36,
  t37.id AS id_38,
  t37.title AS title_39,
  t37.synthetique_message AS synthetique_message_40,
  t37.photo1 AS photo1_41,
  t37.description AS description_42,
  t37.photo2 AS photo2_43,
  t37.details AS details_44,
  t37.photo3 AS photo3_45,
  t37.product_id AS product_id_46,
  t0.type_location_id AS type_location_id_47,
  t0.type_prestation_id AS type_prestation_id_48,
  t0.tva_id AS tva_id_49,
  t0.type_hebergements_id AS type_hebergements_id_50,
  t0.type_activity_id AS type_activity_id_51,
  t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52,
  t0.commune_id AS commune_id_53
FROM
  product t0
  LEFT JOIN product_description t37 ON t37.product_id = t0.id
  INNER JOIN product_sub_category ON t0.id = product_sub_category.product_id
WHERE
  product_sub_category.sub_category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.price AS price_4, t0.quantity AS quantity_5, t0.product_slug AS product_slug_6, t0.percent_deposit AS percent_deposit_7, t0.deadline AS deadline_8, t0.sizes AS sizes_9, t0.colors AS colors_10, t0.size_ring AS size_ring_11, t0.nb_guest AS nb_guest_12, t0.youtube_video AS youtube_video_13, t0.is_activated AS is_activated_14, t0.is_desactivated_by_admin AS is_desactivated_by_admin_15, t0.mode_livraison AS mode_livraison_16, t0.frais_livraison AS frais_livraison_17, t0.weight AS weight_18, t0.transporteurs AS transporteurs_19, t0.code_promo AS code_promo_20, t0.code_promo_euro AS code_promo_euro_21, t0.template AS template_22, t0.taxe_sejour AS taxe_sejour_23, t0.prix_caution AS prix_caution_24, t0.longitude AS longitude_25, t0.latitude AS latitude_26, t0.spring_price AS spring_price_27, t0.summer_price AS summer_price_28, t0.autumn_price AS autumn_price_29, t0.winter_price AS winter_price_30, t0.week_end_price AS week_end_price_31, t0.city_localisation AS city_localisation_32, t0.nb_chambre AS nb_chambre_33, t0.night_min AS night_min_34, t0.company_id AS company_id_35, t0.pack_id AS pack_id_36, t37.id AS id_38, t37.title AS title_39, t37.synthetique_message AS synthetique_message_40, t37.photo1 AS photo1_41, t37.description AS description_42, t37.photo2 AS photo2_43, t37.details AS details_44, t37.photo3 AS photo3_45, t37.product_id AS product_id_46, t0.type_location_id AS type_location_id_47, t0.type_prestation_id AS type_prestation_id_48, t0.tva_id AS tva_id_49, t0.type_hebergements_id AS type_hebergements_id_50, t0.type_activity_id AS type_activity_id_51, t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52, t0.commune_id AS commune_id_53 FROM product t0 LEFT JOIN product_description t37 ON t37.product_id = t0.id INNER JOIN product_sub_category ON t0.id = product_sub_category.product_id WHERE product_sub_category.sub_category_id = 53;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sub_category_slug AS sub_category_slug_3,
  t0.is_suivi AS is_suivi_4,
  t0.is_clothing AS is_clothing_5,
  t0.is_color AS is_color_6,
  t0.is_nb_guest AS is_nb_guest_7,
  t0.image AS image_8,
  t0.is_clothing_ring AS is_clothing_ring_9,
  t0.is_service AS is_service_10,
  t0.is_fairepart AS is_fairepart_11,
  t0.is_vehicle AS is_vehicle_12
FROM
  sub_category t0
  INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id
WHERE
  sub_category_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_category_slug AS sub_category_slug_3, t0.is_suivi AS is_suivi_4, t0.is_clothing AS is_clothing_5, t0.is_color AS is_color_6, t0.is_nb_guest AS is_nb_guest_7, t0.image AS image_8, t0.is_clothing_ring AS is_clothing_ring_9, t0.is_service AS is_service_10, t0.is_fairepart AS is_fairepart_11, t0.is_vehicle AS is_vehicle_12 FROM sub_category t0 INNER JOIN sub_category_category ON t0.id = sub_category_category.sub_category_id WHERE sub_category_category.category_id = 31;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.text AS text_3,
  t0.price AS price_4,
  t0.quantity AS quantity_5,
  t0.product_slug AS product_slug_6,
  t0.percent_deposit AS percent_deposit_7,
  t0.deadline AS deadline_8,
  t0.sizes AS sizes_9,
  t0.colors AS colors_10,
  t0.size_ring AS size_ring_11,
  t0.nb_guest AS nb_guest_12,
  t0.youtube_video AS youtube_video_13,
  t0.is_activated AS is_activated_14,
  t0.is_desactivated_by_admin AS is_desactivated_by_admin_15,
  t0.mode_livraison AS mode_livraison_16,
  t0.frais_livraison AS frais_livraison_17,
  t0.weight AS weight_18,
  t0.transporteurs AS transporteurs_19,
  t0.code_promo AS code_promo_20,
  t0.code_promo_euro AS code_promo_euro_21,
  t0.template AS template_22,
  t0.taxe_sejour AS taxe_sejour_23,
  t0.prix_caution AS prix_caution_24,
  t0.longitude AS longitude_25,
  t0.latitude AS latitude_26,
  t0.spring_price AS spring_price_27,
  t0.summer_price AS summer_price_28,
  t0.autumn_price AS autumn_price_29,
  t0.winter_price AS winter_price_30,
  t0.week_end_price AS week_end_price_31,
  t0.city_localisation AS city_localisation_32,
  t0.nb_chambre AS nb_chambre_33,
  t0.night_min AS night_min_34,
  t0.company_id AS company_id_35,
  t0.pack_id AS pack_id_36,
  t37.id AS id_38,
  t37.title AS title_39,
  t37.synthetique_message AS synthetique_message_40,
  t37.photo1 AS photo1_41,
  t37.description AS description_42,
  t37.photo2 AS photo2_43,
  t37.details AS details_44,
  t37.photo3 AS photo3_45,
  t37.product_id AS product_id_46,
  t0.type_location_id AS type_location_id_47,
  t0.type_prestation_id AS type_prestation_id_48,
  t0.tva_id AS tva_id_49,
  t0.type_hebergements_id AS type_hebergements_id_50,
  t0.type_activity_id AS type_activity_id_51,
  t0.caracteristique_vehicule_id AS caracteristique_vehicule_id_52,
  t0.commune_id AS commune_id_53
FROM
  product t0
  LEFT JOIN product_description t37 ON t37.product_id = t0.id
  INNER JOIN product_sub_category ON t0.id = product_sub_category.product_id
WHERE
  product_sub_category.sub_category_id = ?