Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.civility AS civility_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone AS phone_5,
  t0.wedding_date AS wedding_date_6,
  t0.image AS image_7,
  t0.id_stripe AS id_stripe_8,
  t0.livraison_adress AS livraison_adress_9,
  t0.livraison_zip_code AS livraison_zip_code_10,
  t0.livraison_city AS livraison_city_11,
  t0.birth_at AS birth_at_12,
  t0.nationality AS nationality_13,
  t0.country_residence AS country_residence_14,
  t0.mango_id AS mango_id_15,
  t0.is_valid AS is_valid_16,
  t0.service_address AS service_address_17,
  t0.service_zip_code AS service_zip_code_18,
  t0.service_city AS service_city_19,
  t0.statu_con AS statu_con_20,
  t0.etat_network AS etat_network_21,
  t0.roles AS roles_22,
  t0.email AS email_23,
  t0.password AS password_24,
  t0.adress AS adress_25,
  t0.zip_code AS zip_code_26,
  t0.city AS city_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.civility AS civility_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.wedding_date AS wedding_date_6, t0.image AS image_7, t0.id_stripe AS id_stripe_8, t0.livraison_adress AS livraison_adress_9, t0.livraison_zip_code AS livraison_zip_code_10, t0.livraison_city AS livraison_city_11, t0.birth_at AS birth_at_12, t0.nationality AS nationality_13, t0.country_residence AS country_residence_14, t0.mango_id AS mango_id_15, t0.is_valid AS is_valid_16, t0.service_address AS service_address_17, t0.service_zip_code AS service_zip_code_18, t0.service_city AS service_city_19, t0.statu_con AS statu_con_20, t0.etat_network AS etat_network_21, t0.roles AS roles_22, t0.email AS email_23, t0.password AS password_24, t0.adress AS adress_25, t0.zip_code AS zip_code_26, t0.city AS city_27 FROM user t0 WHERE t0.id = 39;

SELECT
  c0_.id AS id_0,
  c0_.siren AS siren_1,
  c0_.contact_name AS contact_name_2,
  c0_.contact_phone AS contact_phone_3,
  c0_.company_name AS company_name_4,
  c0_.fax AS fax_5,
  c0_.website AS website_6,
  c0_.contact_civility AS contact_civility_7,
  c0_.is_accept_condition AS is_accept_condition_8,
  c0_.company_slug AS company_slug_9,
  c0_.description AS description_10,
  c0_.image AS image_11,
  c0_.is_confirmed AS is_confirmed_12,
  c0_.kbis AS kbis_13,
  c0_.conditions_vente AS conditions_vente_14,
  c0_.strip_id AS strip_id_15,
  c0_.stripe_account AS stripe_account_16,
  c0_.first_name AS first_name_17,
  c0_.contact_birthday AS contact_birthday_18,
  c0_.country AS country_19,
  c0_.mango_id AS mango_id_20,
  c0_.is_valid_document AS is_valid_document_21,
  c0_.type AS type_22,
  c0_.is_editor_guide AS is_editor_guide_23,
  c0_.paiement_activ AS paiement_activ_24,
  c0_.commission_active AS commission_active_25,
  c0_.statu_con AS statu_con_26,
  c0_.etat_network AS etat_network_27,
  c0_.created_at AS created_at_28,
  c0_.is_direct_reservation_mode AS is_direct_reservation_mode_29,
  c0_.stripe_id AS stripe_id_30,
  c0_.stripe_account_id AS stripe_account_id_31,
  c0_.roles AS roles_32,
  c0_.email AS email_33,
  c0_.password AS password_34,
  c0_.adress AS adress_35,
  c0_.zip_code AS zip_code_36,
  c0_.city AS city_37
FROM
  company c0_
  INNER JOIN abonnement a1_ ON c0_.id = a1_.company_id
WHERE
  a1_.is_active = 1
  OR a1_.is_active = 0
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.siren AS siren_1, c0_.contact_name AS contact_name_2, c0_.contact_phone AS contact_phone_3, c0_.company_name AS company_name_4, c0_.fax AS fax_5, c0_.website AS website_6, c0_.contact_civility AS contact_civility_7, c0_.is_accept_condition AS is_accept_condition_8, c0_.company_slug AS company_slug_9, c0_.description AS description_10, c0_.image AS image_11, c0_.is_confirmed AS is_confirmed_12, c0_.kbis AS kbis_13, c0_.conditions_vente AS conditions_vente_14, c0_.strip_id AS strip_id_15, c0_.stripe_account AS stripe_account_16, c0_.first_name AS first_name_17, c0_.contact_birthday AS contact_birthday_18, c0_.country AS country_19, c0_.mango_id AS mango_id_20, c0_.is_valid_document AS is_valid_document_21, c0_.type AS type_22, c0_.is_editor_guide AS is_editor_guide_23, c0_.paiement_activ AS paiement_activ_24, c0_.commission_active AS commission_active_25, c0_.statu_con AS statu_con_26, c0_.etat_network AS etat_network_27, c0_.created_at AS created_at_28, c0_.is_direct_reservation_mode AS is_direct_reservation_mode_29, c0_.stripe_id AS stripe_id_30, c0_.stripe_account_id AS stripe_account_id_31, c0_.roles AS roles_32, c0_.email AS email_33, c0_.password AS password_34, c0_.adress AS adress_35, c0_.zip_code AS zip_code_36, c0_.city AS city_37 FROM company c0_ INNER JOIN abonnement a1_ ON c0_.id = a1_.company_id WHERE a1_.is_active = 1 OR a1_.is_active = 0 ORDER BY c0_.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
WHERE
  t0.company_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 WHERE t0.company_id = 266;

SELECT
  t0.id AS id_1,
  t0.mango_recurring_registration_id AS mango_recurring_registration_id_2,
  t0.created_at AS created_at_3,
  t0.next_update AS next_update_4,
  t0.is_active AS is_active_5,
  t0.disabling_reason AS disabling_reason_6,
  t0.stripe_subscription_id AS stripe_subscription_id_7,
  t0.company_id AS company_id_8,
  t0.type_abonnement_id AS type_abonnement_id_9,
  t10.id AS id_11,
  t10.label AS label_12,
  t10.prix AS prix_13,
  t10.explication AS explication_14,
  t10.stripe_id AS stripe_id_15,
  t10.payment_link AS payment_link_16
FROM
  abonnement t0
  LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.mango_recurring_registration_id AS mango_recurring_registration_id_2, t0.created_at AS created_at_3, t0.next_update AS next_update_4, t0.is_active AS is_active_5, t0.disabling_reason AS disabling_reason_6, t0.stripe_subscription_id AS stripe_subscription_id_7, t0.company_id AS company_id_8, t0.type_abonnement_id AS type_abonnement_id_9, t10.id AS id_11, t10.label AS label_12, t10.prix AS prix_13, t10.explication AS explication_14, t10.stripe_id AS stripe_id_15, t10.payment_link AS payment_link_16 FROM abonnement t0 LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id WHERE t0.company_id = 266;

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
WHERE
  t0.company_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 WHERE t0.company_id = 265;

SELECT
  t0.id AS id_1,
  t0.mango_recurring_registration_id AS mango_recurring_registration_id_2,
  t0.created_at AS created_at_3,
  t0.next_update AS next_update_4,
  t0.is_active AS is_active_5,
  t0.disabling_reason AS disabling_reason_6,
  t0.stripe_subscription_id AS stripe_subscription_id_7,
  t0.company_id AS company_id_8,
  t0.type_abonnement_id AS type_abonnement_id_9,
  t10.id AS id_11,
  t10.label AS label_12,
  t10.prix AS prix_13,
  t10.explication AS explication_14,
  t10.stripe_id AS stripe_id_15,
  t10.payment_link AS payment_link_16
FROM
  abonnement t0
  LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.mango_recurring_registration_id AS mango_recurring_registration_id_2, t0.created_at AS created_at_3, t0.next_update AS next_update_4, t0.is_active AS is_active_5, t0.disabling_reason AS disabling_reason_6, t0.stripe_subscription_id AS stripe_subscription_id_7, t0.company_id AS company_id_8, t0.type_abonnement_id AS type_abonnement_id_9, t10.id AS id_11, t10.label AS label_12, t10.prix AS prix_13, t10.explication AS explication_14, t10.stripe_id AS stripe_id_15, t10.payment_link AS payment_link_16 FROM abonnement t0 LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id WHERE t0.company_id = 265;

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
WHERE
  t0.company_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 WHERE t0.company_id = 248;

SELECT
  t0.id AS id_1,
  t0.mango_recurring_registration_id AS mango_recurring_registration_id_2,
  t0.created_at AS created_at_3,
  t0.next_update AS next_update_4,
  t0.is_active AS is_active_5,
  t0.disabling_reason AS disabling_reason_6,
  t0.stripe_subscription_id AS stripe_subscription_id_7,
  t0.company_id AS company_id_8,
  t0.type_abonnement_id AS type_abonnement_id_9,
  t10.id AS id_11,
  t10.label AS label_12,
  t10.prix AS prix_13,
  t10.explication AS explication_14,
  t10.stripe_id AS stripe_id_15,
  t10.payment_link AS payment_link_16
FROM
  abonnement t0
  LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.mango_recurring_registration_id AS mango_recurring_registration_id_2, t0.created_at AS created_at_3, t0.next_update AS next_update_4, t0.is_active AS is_active_5, t0.disabling_reason AS disabling_reason_6, t0.stripe_subscription_id AS stripe_subscription_id_7, t0.company_id AS company_id_8, t0.type_abonnement_id AS type_abonnement_id_9, t10.id AS id_11, t10.label AS label_12, t10.prix AS prix_13, t10.explication AS explication_14, t10.stripe_id AS stripe_id_15, t10.payment_link AS payment_link_16 FROM abonnement t0 LEFT JOIN type_abonnement t10 ON t0.type_abonnement_id = t10.id WHERE t0.company_id = 248;