Symfony Profiler

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.siren AS siren_2,
  t0.contact_name AS contact_name_3,
  t0.contact_phone AS contact_phone_4,
  t0.company_name AS company_name_5,
  t0.fax AS fax_6,
  t0.website AS website_7,
  t0.contact_civility AS contact_civility_8,
  t0.is_accept_condition AS is_accept_condition_9,
  t0.company_slug AS company_slug_10,
  t0.description AS description_11,
  t0.image AS image_12,
  t0.is_confirmed AS is_confirmed_13,
  t0.kbis AS kbis_14,
  t0.conditions_vente AS conditions_vente_15,
  t0.strip_id AS strip_id_16,
  t0.stripe_account AS stripe_account_17,
  t0.first_name AS first_name_18,
  t0.contact_birthday AS contact_birthday_19,
  t0.country AS country_20,
  t0.mango_id AS mango_id_21,
  t0.is_valid_document AS is_valid_document_22,
  t0.type AS type_23,
  t0.is_editor_guide AS is_editor_guide_24,
  t0.paiement_activ AS paiement_activ_25,
  t0.commission_active AS commission_active_26,
  t0.statu_con AS statu_con_27,
  t0.etat_network AS etat_network_28,
  t0.created_at AS created_at_29,
  t0.is_direct_reservation_mode AS is_direct_reservation_mode_30,
  t0.stripe_id AS stripe_id_31,
  t0.stripe_account_id AS stripe_account_id_32,
  t0.roles AS roles_33,
  t0.email AS email_34,
  t0.password AS password_35,
  t0.adress AS adress_36,
  t0.zip_code AS zip_code_37,
  t0.city AS city_38
FROM
  company t0
WHERE
  t0.is_confirmed = ?
  AND t0.is_valid_document = ?

SELECT t0.id AS id_1, t0.siren AS siren_2, t0.contact_name AS contact_name_3, t0.contact_phone AS contact_phone_4, t0.company_name AS company_name_5, t0.fax AS fax_6, t0.website AS website_7, t0.contact_civility AS contact_civility_8, t0.is_accept_condition AS is_accept_condition_9, t0.company_slug AS company_slug_10, t0.description AS description_11, t0.image AS image_12, t0.is_confirmed AS is_confirmed_13, t0.kbis AS kbis_14, t0.conditions_vente AS conditions_vente_15, t0.strip_id AS strip_id_16, t0.stripe_account AS stripe_account_17, t0.first_name AS first_name_18, t0.contact_birthday AS contact_birthday_19, t0.country AS country_20, t0.mango_id AS mango_id_21, t0.is_valid_document AS is_valid_document_22, t0.type AS type_23, t0.is_editor_guide AS is_editor_guide_24, t0.paiement_activ AS paiement_activ_25, t0.commission_active AS commission_active_26, t0.statu_con AS statu_con_27, t0.etat_network AS etat_network_28, t0.created_at AS created_at_29, t0.is_direct_reservation_mode AS is_direct_reservation_mode_30, t0.stripe_id AS stripe_id_31, t0.stripe_account_id AS stripe_account_id_32, t0.roles AS roles_33, t0.email AS email_34, t0.password AS password_35, t0.adress AS adress_36, t0.zip_code AS zip_code_37, t0.city AS city_38 FROM company t0 WHERE t0.is_confirmed = 1 AND t0.is_valid_document = 1;

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,
  c1_.id AS id_34,
  c1_.siren AS siren_35,
  c1_.contact_name AS contact_name_36,
  c1_.contact_phone AS contact_phone_37,
  c1_.company_name AS company_name_38,
  c1_.fax AS fax_39,
  c1_.website AS website_40,
  c1_.contact_civility AS contact_civility_41,
  c1_.is_accept_condition AS is_accept_condition_42,
  c1_.company_slug AS company_slug_43,
  c1_.description AS description_44,
  c1_.image AS image_45,
  c1_.is_confirmed AS is_confirmed_46,
  c1_.kbis AS kbis_47,
  c1_.conditions_vente AS conditions_vente_48,
  c1_.strip_id AS strip_id_49,
  c1_.stripe_account AS stripe_account_50,
  c1_.first_name AS first_name_51,
  c1_.contact_birthday AS contact_birthday_52,
  c1_.country AS country_53,
  c1_.mango_id AS mango_id_54,
  c1_.is_valid_document AS is_valid_document_55,
  c1_.type AS type_56,
  c1_.is_editor_guide AS is_editor_guide_57,
  c1_.paiement_activ AS paiement_activ_58,
  c1_.commission_active AS commission_active_59,
  c1_.statu_con AS statu_con_60,
  c1_.etat_network AS etat_network_61,
  c1_.created_at AS created_at_62,
  c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63,
  c1_.stripe_id AS stripe_id_64,
  c1_.stripe_account_id AS stripe_account_id_65,
  c1_.roles AS roles_66,
  c1_.email AS email_67,
  c1_.password AS password_68,
  c1_.adress AS adress_69,
  c1_.zip_code AS zip_code_70,
  c1_.city AS city_71,
  p0_.company_id AS company_id_72,
  p0_.pack_id AS pack_id_73,
  p0_.type_location_id AS type_location_id_74,
  p0_.type_prestation_id AS type_prestation_id_75,
  p0_.tva_id AS tva_id_76,
  p0_.type_hebergements_id AS type_hebergements_id_77,
  p0_.type_activity_id AS type_activity_id_78,
  p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79,
  p0_.commune_id AS commune_id_80
FROM
  product p0_
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id
WHERE
  p0_.company_id = ?
  AND c1_.is_confirmed = 1
  AND c1_.is_valid_document = 1
  AND p0_.is_activated = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

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, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = 218 AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = 1 ORDER BY p0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.synthetique_message AS synthetique_message_3,
  t0.photo1 AS photo1_4,
  t0.description AS description_5,
  t0.photo2 AS photo2_6,
  t0.details AS details_7,
  t0.photo3 AS photo3_8,
  t0.product_id AS product_id_9
FROM
  product_description t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = 29;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.product_id AS product_id_3
FROM
  photos t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = 29;

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,
  c1_.id AS id_34,
  c1_.siren AS siren_35,
  c1_.contact_name AS contact_name_36,
  c1_.contact_phone AS contact_phone_37,
  c1_.company_name AS company_name_38,
  c1_.fax AS fax_39,
  c1_.website AS website_40,
  c1_.contact_civility AS contact_civility_41,
  c1_.is_accept_condition AS is_accept_condition_42,
  c1_.company_slug AS company_slug_43,
  c1_.description AS description_44,
  c1_.image AS image_45,
  c1_.is_confirmed AS is_confirmed_46,
  c1_.kbis AS kbis_47,
  c1_.conditions_vente AS conditions_vente_48,
  c1_.strip_id AS strip_id_49,
  c1_.stripe_account AS stripe_account_50,
  c1_.first_name AS first_name_51,
  c1_.contact_birthday AS contact_birthday_52,
  c1_.country AS country_53,
  c1_.mango_id AS mango_id_54,
  c1_.is_valid_document AS is_valid_document_55,
  c1_.type AS type_56,
  c1_.is_editor_guide AS is_editor_guide_57,
  c1_.paiement_activ AS paiement_activ_58,
  c1_.commission_active AS commission_active_59,
  c1_.statu_con AS statu_con_60,
  c1_.etat_network AS etat_network_61,
  c1_.created_at AS created_at_62,
  c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63,
  c1_.stripe_id AS stripe_id_64,
  c1_.stripe_account_id AS stripe_account_id_65,
  c1_.roles AS roles_66,
  c1_.email AS email_67,
  c1_.password AS password_68,
  c1_.adress AS adress_69,
  c1_.zip_code AS zip_code_70,
  c1_.city AS city_71,
  p0_.company_id AS company_id_72,
  p0_.pack_id AS pack_id_73,
  p0_.type_location_id AS type_location_id_74,
  p0_.type_prestation_id AS type_prestation_id_75,
  p0_.tva_id AS tva_id_76,
  p0_.type_hebergements_id AS type_hebergements_id_77,
  p0_.type_activity_id AS type_activity_id_78,
  p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79,
  p0_.commune_id AS commune_id_80
FROM
  product p0_
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id
WHERE
  p0_.company_id = ?
  AND c1_.is_confirmed = 1
  AND c1_.is_valid_document = 1
  AND p0_.is_activated = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

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, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = 224 AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = 1 ORDER BY p0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.synthetique_message AS synthetique_message_3,
  t0.photo1 AS photo1_4,
  t0.description AS description_5,
  t0.photo2 AS photo2_6,
  t0.details AS details_7,
  t0.photo3 AS photo3_8,
  t0.product_id AS product_id_9
FROM
  product_description t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = 19;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.product_id AS product_id_3
FROM
  photos t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = 19;

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,
  c1_.id AS id_34,
  c1_.siren AS siren_35,
  c1_.contact_name AS contact_name_36,
  c1_.contact_phone AS contact_phone_37,
  c1_.company_name AS company_name_38,
  c1_.fax AS fax_39,
  c1_.website AS website_40,
  c1_.contact_civility AS contact_civility_41,
  c1_.is_accept_condition AS is_accept_condition_42,
  c1_.company_slug AS company_slug_43,
  c1_.description AS description_44,
  c1_.image AS image_45,
  c1_.is_confirmed AS is_confirmed_46,
  c1_.kbis AS kbis_47,
  c1_.conditions_vente AS conditions_vente_48,
  c1_.strip_id AS strip_id_49,
  c1_.stripe_account AS stripe_account_50,
  c1_.first_name AS first_name_51,
  c1_.contact_birthday AS contact_birthday_52,
  c1_.country AS country_53,
  c1_.mango_id AS mango_id_54,
  c1_.is_valid_document AS is_valid_document_55,
  c1_.type AS type_56,
  c1_.is_editor_guide AS is_editor_guide_57,
  c1_.paiement_activ AS paiement_activ_58,
  c1_.commission_active AS commission_active_59,
  c1_.statu_con AS statu_con_60,
  c1_.etat_network AS etat_network_61,
  c1_.created_at AS created_at_62,
  c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63,
  c1_.stripe_id AS stripe_id_64,
  c1_.stripe_account_id AS stripe_account_id_65,
  c1_.roles AS roles_66,
  c1_.email AS email_67,
  c1_.password AS password_68,
  c1_.adress AS adress_69,
  c1_.zip_code AS zip_code_70,
  c1_.city AS city_71,
  p0_.company_id AS company_id_72,
  p0_.pack_id AS pack_id_73,
  p0_.type_location_id AS type_location_id_74,
  p0_.type_prestation_id AS type_prestation_id_75,
  p0_.tva_id AS tva_id_76,
  p0_.type_hebergements_id AS type_hebergements_id_77,
  p0_.type_activity_id AS type_activity_id_78,
  p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79,
  p0_.commune_id AS commune_id_80
FROM
  product p0_
  LEFT JOIN company c1_ ON p0_.company_id = c1_.id
WHERE
  p0_.company_id = ?
  AND c1_.is_confirmed = 1
  AND c1_.is_valid_document = 1
  AND p0_.is_activated = ?
ORDER BY
  p0_.id DESC
LIMIT
  1

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, c1_.id AS id_34, c1_.siren AS siren_35, c1_.contact_name AS contact_name_36, c1_.contact_phone AS contact_phone_37, c1_.company_name AS company_name_38, c1_.fax AS fax_39, c1_.website AS website_40, c1_.contact_civility AS contact_civility_41, c1_.is_accept_condition AS is_accept_condition_42, c1_.company_slug AS company_slug_43, c1_.description AS description_44, c1_.image AS image_45, c1_.is_confirmed AS is_confirmed_46, c1_.kbis AS kbis_47, c1_.conditions_vente AS conditions_vente_48, c1_.strip_id AS strip_id_49, c1_.stripe_account AS stripe_account_50, c1_.first_name AS first_name_51, c1_.contact_birthday AS contact_birthday_52, c1_.country AS country_53, c1_.mango_id AS mango_id_54, c1_.is_valid_document AS is_valid_document_55, c1_.type AS type_56, c1_.is_editor_guide AS is_editor_guide_57, c1_.paiement_activ AS paiement_activ_58, c1_.commission_active AS commission_active_59, c1_.statu_con AS statu_con_60, c1_.etat_network AS etat_network_61, c1_.created_at AS created_at_62, c1_.is_direct_reservation_mode AS is_direct_reservation_mode_63, c1_.stripe_id AS stripe_id_64, c1_.stripe_account_id AS stripe_account_id_65, c1_.roles AS roles_66, c1_.email AS email_67, c1_.password AS password_68, c1_.adress AS adress_69, c1_.zip_code AS zip_code_70, c1_.city AS city_71, p0_.company_id AS company_id_72, p0_.pack_id AS pack_id_73, p0_.type_location_id AS type_location_id_74, p0_.type_prestation_id AS type_prestation_id_75, p0_.tva_id AS tva_id_76, p0_.type_hebergements_id AS type_hebergements_id_77, p0_.type_activity_id AS type_activity_id_78, p0_.caracteristique_vehicule_id AS caracteristique_vehicule_id_79, p0_.commune_id AS commune_id_80 FROM product p0_ LEFT JOIN company c1_ ON p0_.company_id = c1_.id WHERE p0_.company_id = 225 AND c1_.is_confirmed = 1 AND c1_.is_valid_document = 1 AND p0_.is_activated = 1 ORDER BY p0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.synthetique_message AS synthetique_message_3,
  t0.photo1 AS photo1_4,
  t0.description AS description_5,
  t0.photo2 AS photo2_6,
  t0.details AS details_7,
  t0.photo3 AS photo3_8,
  t0.product_id AS product_id_9
FROM
  product_description t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.synthetique_message AS synthetique_message_3, t0.photo1 AS photo1_4, t0.description AS description_5, t0.photo2 AS photo2_6, t0.details AS details_7, t0.photo3 AS photo3_8, t0.product_id AS product_id_9 FROM product_description t0 WHERE t0.product_id = 25;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.product_id AS product_id_3
FROM
  photos t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.product_id AS product_id_3 FROM photos t0 WHERE t0.product_id = 25;