Symfony Profiler

SELECT
  param
FROM
  doli_extrafields
WHERE
  name = "sous_destination"
  AND elementtype = "societe"

SELECT param FROM doli_extrafields WHERE name = "sous_destination" AND elementtype = "societe";

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.email AS email_4,
  t0.is_active AS is_active_5,
  t0.firstname AS firstname_6,
  t0.lastname AS lastname_7,
  t0.phone AS phone_8,
  t0.cellphone AS cellphone_9,
  t0.address AS address_10,
  t0.city AS city_11,
  t0.zipcode AS zipcode_12,
  t0.avatar AS avatar_13,
  t0.uid AS uid_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.role_id AS role_id_17,
  t0.langue_id AS langue_id_18
FROM
  ba_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.is_active AS is_active_5, t0.firstname AS firstname_6, t0.lastname AS lastname_7, t0.phone AS phone_8, t0.cellphone AS cellphone_9, t0.address AS address_10, t0.city AS city_11, t0.zipcode AS zipcode_12, t0.avatar AS avatar_13, t0.uid AS uid_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.role_id AS role_id_17, t0.langue_id AS langue_id_18 FROM ba_user t0 WHERE t0.id = 26;

SELECT
  b0_.id AS id_0,
  b0_.icone AS icone_1,
  b0_.vue AS vue_2,
  b0_.email_sent AS email_sent_3,
  b0_.recap_sent AS recap_sent_4,
  b0_.titre AS titre_5,
  b0_.description AS description_6,
  b0_.date_publication AS date_publication_7,
  b0_.extra_info AS extra_info_8,
  b0_.is_rappel AS is_rappel_9,
  b0_.is_in_app AS is_in_app_10,
  b0_.is_recap AS is_recap_11,
  b0_.is_email AS is_email_12,
  b0_.created_at AS created_at_13,
  b0_.updated_at AS updated_at_14,
  b0_.type_id AS type_id_15,
  b0_.source_id AS source_id_16,
  b0_.destination_id AS destination_id_17,
  b0_.event_id AS event_id_18,
  b0_.created_by AS created_by_19,
  b0_.updated_by AS updated_by_20
FROM
  ba_notification b0_
WHERE
  b0_.destination_id = ?
  AND b0_.vue = 0
  AND b0_.date_publication >= 2025 - 07 - 01
ORDER BY
  b0_.date_publication DESC

SELECT b0_.id AS id_0, b0_.icone AS icone_1, b0_.vue AS vue_2, b0_.email_sent AS email_sent_3, b0_.recap_sent AS recap_sent_4, b0_.titre AS titre_5, b0_.description AS description_6, b0_.date_publication AS date_publication_7, b0_.extra_info AS extra_info_8, b0_.is_rappel AS is_rappel_9, b0_.is_in_app AS is_in_app_10, b0_.is_recap AS is_recap_11, b0_.is_email AS is_email_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.type_id AS type_id_15, b0_.source_id AS source_id_16, b0_.destination_id AS destination_id_17, b0_.event_id AS event_id_18, b0_.created_by AS created_by_19, b0_.updated_by AS updated_by_20 FROM ba_notification b0_ WHERE b0_.destination_id = 26 AND b0_.vue = 0 AND b0_.date_publication >= 2025 - 07 - 01 ORDER BY b0_.date_publication DESC;

SELECT
  b0_.id AS id_0,
  b0_.icone AS icone_1,
  b0_.vue AS vue_2,
  b0_.email_sent AS email_sent_3,
  b0_.recap_sent AS recap_sent_4,
  b0_.titre AS titre_5,
  b0_.description AS description_6,
  b0_.date_publication AS date_publication_7,
  b0_.extra_info AS extra_info_8,
  b0_.is_rappel AS is_rappel_9,
  b0_.is_in_app AS is_in_app_10,
  b0_.is_recap AS is_recap_11,
  b0_.is_email AS is_email_12,
  b0_.created_at AS created_at_13,
  b0_.updated_at AS updated_at_14,
  b0_.type_id AS type_id_15,
  b0_.source_id AS source_id_16,
  b0_.destination_id AS destination_id_17,
  b0_.event_id AS event_id_18,
  b0_.created_by AS created_by_19,
  b0_.updated_by AS updated_by_20
FROM
  ba_notification b0_
WHERE
  b0_.destination_id = ?
  AND b0_.vue = 1
  AND b0_.date_publication >= 2025 - 07 - 01
ORDER BY
  b0_.date_publication DESC

SELECT b0_.id AS id_0, b0_.icone AS icone_1, b0_.vue AS vue_2, b0_.email_sent AS email_sent_3, b0_.recap_sent AS recap_sent_4, b0_.titre AS titre_5, b0_.description AS description_6, b0_.date_publication AS date_publication_7, b0_.extra_info AS extra_info_8, b0_.is_rappel AS is_rappel_9, b0_.is_in_app AS is_in_app_10, b0_.is_recap AS is_recap_11, b0_.is_email AS is_email_12, b0_.created_at AS created_at_13, b0_.updated_at AS updated_at_14, b0_.type_id AS type_id_15, b0_.source_id AS source_id_16, b0_.destination_id AS destination_id_17, b0_.event_id AS event_id_18, b0_.created_by AS created_by_19, b0_.updated_by AS updated_by_20 FROM ba_notification b0_ WHERE b0_.destination_id = 26 AND b0_.vue = 1 AND b0_.date_publication >= 2025 - 07 - 01 ORDER BY b0_.date_publication DESC;

SELECT
  b0_.id AS id_0,
  b0_.username AS username_1,
  b0_.password AS password_2,
  b0_.email AS email_3,
  b0_.is_active AS is_active_4,
  b0_.firstname AS firstname_5,
  b0_.lastname AS lastname_6,
  b0_.phone AS phone_7,
  b0_.cellphone AS cellphone_8,
  b0_.address AS address_9,
  b0_.city AS city_10,
  b0_.zipcode AS zipcode_11,
  b0_.avatar AS avatar_12,
  b0_.uid AS uid_13,
  b0_.created_at AS created_at_14,
  b0_.updated_at AS updated_at_15,
  b1_.id AS id_16,
  b1_.url AS url_17,
  b1_.query AS query_18,
  b1_.request AS request_19,
  b1_.user_actif AS user_actif_20,
  b1_.created_at AS created_at_21,
  b1_.updated_at AS updated_at_22,
  b0_.role_id AS role_id_23,
  b0_.langue_id AS langue_id_24,
  b1_.user_id AS user_id_25,
  b1_.created_by AS created_by_26,
  b1_.updated_by AS updated_by_27
FROM
  ba_user b0_
  LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id
WHERE
  b1_.url = ?
  AND b1_.updated_at >= ?
ORDER BY
  b1_.id ASC

SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.password AS password_2, b0_.email AS email_3, b0_.is_active AS is_active_4, b0_.firstname AS firstname_5, b0_.lastname AS lastname_6, b0_.phone AS phone_7, b0_.cellphone AS cellphone_8, b0_.address AS address_9, b0_.city AS city_10, b0_.zipcode AS zipcode_11, b0_.avatar AS avatar_12, b0_.uid AS uid_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b1_.id AS id_16, b1_.url AS url_17, b1_.query AS query_18, b1_.request AS request_19, b1_.user_actif AS user_actif_20, b1_.created_at AS created_at_21, b1_.updated_at AS updated_at_22, b0_.role_id AS role_id_23, b0_.langue_id AS langue_id_24, b1_.user_id AS user_id_25, b1_.created_by AS created_by_26, b1_.updated_by AS updated_by_27 FROM ba_user b0_ LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id WHERE b1_.url = '/dossier/4595/edit_document_generator_dossier/5137' AND b1_.updated_at >= '2025-07-01 15:26:00' ORDER BY b1_.id ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO ba_historique_page (
  url, query, request, user_actif, created_at,
  updated_at, user_id, created_by,
  updated_by
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO ba_historique_page (url, query, request, user_actif, created_at, updated_at, user_id, created_by, updated_by) VALUES ('/dossier/4595/edit_document_generator_dossier/5137', '[]', '[]', 1, '2025-07-01 15:27:00', '2025-07-01 15:27:00', 26, 26, NULL);

"COMMIT"

"COMMIT";

SELECT
  b0_.id AS id_0,
  b0_.username AS username_1,
  b0_.password AS password_2,
  b0_.email AS email_3,
  b0_.is_active AS is_active_4,
  b0_.firstname AS firstname_5,
  b0_.lastname AS lastname_6,
  b0_.phone AS phone_7,
  b0_.cellphone AS cellphone_8,
  b0_.address AS address_9,
  b0_.city AS city_10,
  b0_.zipcode AS zipcode_11,
  b0_.avatar AS avatar_12,
  b0_.uid AS uid_13,
  b0_.created_at AS created_at_14,
  b0_.updated_at AS updated_at_15,
  b1_.id AS id_16,
  b1_.url AS url_17,
  b1_.query AS query_18,
  b1_.request AS request_19,
  b1_.user_actif AS user_actif_20,
  b1_.created_at AS created_at_21,
  b1_.updated_at AS updated_at_22,
  b0_.role_id AS role_id_23,
  b0_.langue_id AS langue_id_24,
  b1_.user_id AS user_id_25,
  b1_.created_by AS created_by_26,
  b1_.updated_by AS updated_by_27
FROM
  ba_user b0_
  LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id
WHERE
  b1_.user_id <> ?
  AND b1_.url = ?
  AND b1_.updated_at >= ?
ORDER BY
  b1_.id ASC

SELECT b0_.id AS id_0, b0_.username AS username_1, b0_.password AS password_2, b0_.email AS email_3, b0_.is_active AS is_active_4, b0_.firstname AS firstname_5, b0_.lastname AS lastname_6, b0_.phone AS phone_7, b0_.cellphone AS cellphone_8, b0_.address AS address_9, b0_.city AS city_10, b0_.zipcode AS zipcode_11, b0_.avatar AS avatar_12, b0_.uid AS uid_13, b0_.created_at AS created_at_14, b0_.updated_at AS updated_at_15, b1_.id AS id_16, b1_.url AS url_17, b1_.query AS query_18, b1_.request AS request_19, b1_.user_actif AS user_actif_20, b1_.created_at AS created_at_21, b1_.updated_at AS updated_at_22, b0_.role_id AS role_id_23, b0_.langue_id AS langue_id_24, b1_.user_id AS user_id_25, b1_.created_by AS created_by_26, b1_.updated_by AS updated_by_27 FROM ba_user b0_ LEFT JOIN ba_historique_page b1_ ON b0_.id = b1_.user_id WHERE b1_.user_id <> 26 AND b1_.url = '/dossier/4595/edit_document_generator_dossier/5137' AND b1_.updated_at >= '2025-07-01 15:25:00' ORDER BY b1_.id ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.reference_resa_client AS reference_resa_client_4,
  t0.client_id AS client_id_5,
  t0.nb_jours AS nb_jours_6,
  t0.note AS note_7,
  t0.actif AS actif_8,
  t0.description AS description_9,
  t0.code_walkinn AS code_walkinn_10,
  t0.date_depart AS date_depart_11,
  t0.is_valide AS is_valide_12,
  t0.annee AS annee_13,
  t0.date_confirmation AS date_confirmation_14,
  t0.code_client AS code_client_15,
  t0.docs AS docs_16,
  t0.envoi_docs AS envoi_docs_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.dossier_type_id AS dossier_type_id_20,
  t0.dossier_etat_id AS dossier_etat_id_21,
  t0.destination_id AS destination_id_22,
  t0.charge_dossier_id AS charge_dossier_id_23,
  t24.id AS id_25,
  t24.html AS html_26,
  t24.dossier_id AS dossier_id_27,
  t0.charge_dossier2_id AS charge_dossier2_id_28,
  t0.theme_id AS theme_id_29,
  t0.categorie_id AS categorie_id_30,
  t0.created_by AS created_by_31,
  t0.updated_by AS updated_by_32
FROM
  walkinn_dossier t0
  LEFT JOIN walkinn_dossier_guide t24 ON t24.dossier_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.reference_resa_client AS reference_resa_client_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.is_valide AS is_valide_12, t0.annee AS annee_13, t0.date_confirmation AS date_confirmation_14, t0.code_client AS code_client_15, t0.docs AS docs_16, t0.envoi_docs AS envoi_docs_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.dossier_type_id AS dossier_type_id_20, t0.dossier_etat_id AS dossier_etat_id_21, t0.destination_id AS destination_id_22, t0.charge_dossier_id AS charge_dossier_id_23, t24.id AS id_25, t24.html AS html_26, t24.dossier_id AS dossier_id_27, t0.charge_dossier2_id AS charge_dossier2_id_28, t0.theme_id AS theme_id_29, t0.categorie_id AS categorie_id_30, t0.created_by AS created_by_31, t0.updated_by AS updated_by_32 FROM walkinn_dossier t0 LEFT JOIN walkinn_dossier_guide t24 ON t24.dossier_id = t0.id WHERE t0.id = '4595';

SELECT
  code,
  label
FROM
  doli_c_country
WHERE
  favorite = 1
  AND code != ''

SELECT code, label FROM doli_c_country WHERE favorite=1 AND code != '';

SELECT
  t0.id AS id_1,
  t0.entite AS entite_2,
  t0.langue AS langue_3,
  t0.entite_id AS entite_id_4,
  t0.segment_pax_id AS segment_pax_id_5,
  t0.entity_ids AS entity_ids_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.actif AS actif_9,
  t0.is_deleted AS is_deleted_10,
  t0.modele_id AS modele_id_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13
FROM
  walkinn_document_generator t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.entite AS entite_2, t0.langue AS langue_3, t0.entite_id AS entite_id_4, t0.segment_pax_id AS segment_pax_id_5, t0.entity_ids AS entity_ids_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.actif AS actif_9, t0.is_deleted AS is_deleted_10, t0.modele_id AS modele_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM walkinn_document_generator t0 WHERE t0.id = '5137' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.libelle_long AS libelle_long_4,
  t0.client_id AS client_id_5,
  t0.nb_jours AS nb_jours_6,
  t0.note AS note_7,
  t0.actif AS actif_8,
  t0.description AS description_9,
  t0.code_walkinn AS code_walkinn_10,
  t0.date_depart AS date_depart_11,
  t0.min_pax AS min_pax_12,
  t0.max_pax AS max_pax_13,
  t0.code_interne AS code_interne_14,
  t0.is_prestation_seche AS is_prestation_seche_15,
  t0.prix_achat_tooltip AS prix_achat_tooltip_16,
  t0.prix_vente AS prix_vente_17,
  t0.regulation_manuelle AS regulation_manuelle_18,
  t0.sup_single_achat AS sup_single_achat_19,
  t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20,
  t0.sup_single_vente AS sup_single_vente_21,
  t0.reduction_enfant AS reduction_enfant_22,
  t0.reduction_lead AS reduction_lead_23,
  t0.is_sup_single AS is_sup_single_24,
  t0.is_ventes_simple AS is_ventes_simple_25,
  t0.note_facturation AS note_facturation_26,
  t0.is_compo_valide AS is_compo_valide_27,
  t0.is_achats_valide AS is_achats_valide_28,
  t0.is_ventes_valide AS is_ventes_valide_29,
  t0.is_pax_valide AS is_pax_valide_30,
  t0.is_transfer_valide AS is_transfer_valide_31,
  t0.prix_cession AS prix_cession_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.voyage_id AS voyage_id_35,
  t0.dossier_segment_etat_id AS dossier_segment_etat_id_36,
  t0.voyage_type_id AS voyage_type_id_37,
  t0.voyage_categorie_id AS voyage_categorie_id_38,
  t0.voyage_theme_id AS voyage_theme_id_39,
  t0.dossier_id AS dossier_id_40,
  t0.destination_id AS destination_id_41,
  t0.created_by AS created_by_42,
  t0.updated_by AS updated_by_43
FROM
  walkinn_dossier_segment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.id = 10792;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.content AS content_3,
  t0.langue AS langue_4,
  t0.thumbnail AS thumbnail_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.actif AS actif_8,
  t0.is_deleted AS is_deleted_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11
FROM
  walkinn_document_generator_page_template t0
WHERE
  t0.actif = ?
  AND t0.langue = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.content AS content_3, t0.langue AS langue_4, t0.thumbnail AS thumbnail_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.actif AS actif_8, t0.is_deleted AS is_deleted_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11 FROM walkinn_document_generator_page_template t0 WHERE t0.actif = 1 AND t0.langue = 'FR';

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.icon AS icon_3,
  t0.color AS color_4,
  t0.config AS config_5,
  t0.entite AS entite_6,
  t0.langue AS langue_7,
  t0.format AS format_8,
  t0.orientation AS orientation_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.actif AS actif_12,
  t0.is_deleted AS is_deleted_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15
FROM
  walkinn_document_generator_modele t0
WHERE
  t0.entite = ?
  AND t0.actif = ?
  AND t0.langue = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.icon AS icon_3, t0.color AS color_4, t0.config AS config_5, t0.entite AS entite_6, t0.langue AS langue_7, t0.format AS format_8, t0.orientation AS orientation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.actif AS actif_12, t0.is_deleted AS is_deleted_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM walkinn_document_generator_modele t0 WHERE t0.entite = 'dossier' AND t0.actif = 1 AND t0.langue = 'FR';

SELECT
  soc.rowid,
  soc.nom AS nom,
  soc.nom AS four_nom,
  soc.name_alias,
  soc.code_fournisseur,
  soc.email,
  soc.phone,
  soc.logo,
  IFNULL(soc.default_lang, "en_GB") AS default_lang,
  soc.multicurrency_code,
  soc.fk_typent =(
    SELECT
      id
    FROM
      doli_c_typent
    WHERE
      code = "CLIENT_PAX"
    LIMIT
      1
  ) AS is_pax,
  soc.fk_typent =(
    SELECT
      id
    FROM
      doli_c_typent
    WHERE
      code = "CLIENT_TO"
    LIMIT
      1
  ) AS is_to,
  dest.libelle AS destination_libelle,
  dest.code AS destination_code,
  socext.frais_fonctionnement AS frais_fonctionnement
FROM
  doli_societe soc
  LEFT JOIN doli_societe_extrafields socext ON socext.fk_object = soc.rowid
  LEFT JOIN walkinn_destination dest ON dest.id = socext.destination
WHERE
  soc.rowid = 11

SELECT 
            soc.rowid
            , soc.nom AS nom
            , soc.nom AS four_nom
            , soc.name_alias
            , soc.code_fournisseur
            , soc.email
            , soc.phone
            , soc.logo
            , IFNULL(soc.default_lang, "en_GB") AS default_lang
            , soc.multicurrency_code
            , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_PAX" LIMIT 1) AS is_pax
            , soc.fk_typent=(SELECT id FROM doli_c_typent WHERE code = "CLIENT_TO" LIMIT 1) AS is_to
            , dest.libelle AS destination_libelle
            , dest.code AS destination_code
            , socext.frais_fonctionnement AS frais_fonctionnement
            FROM doli_societe soc
            LEFT JOIN doli_societe_extrafields socext ON socext.fk_object = soc.rowid
            LEFT JOIN walkinn_destination dest ON dest.id = socext.destination
            WHERE soc.rowid = 11;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.libelle AS libelle_3,
  t0.libelle_long AS libelle_long_4,
  t0.client_id AS client_id_5,
  t0.nb_jours AS nb_jours_6,
  t0.note AS note_7,
  t0.actif AS actif_8,
  t0.description AS description_9,
  t0.code_walkinn AS code_walkinn_10,
  t0.date_depart AS date_depart_11,
  t0.min_pax AS min_pax_12,
  t0.max_pax AS max_pax_13,
  t0.code_interne AS code_interne_14,
  t0.is_prestation_seche AS is_prestation_seche_15,
  t0.prix_achat_tooltip AS prix_achat_tooltip_16,
  t0.prix_vente AS prix_vente_17,
  t0.regulation_manuelle AS regulation_manuelle_18,
  t0.sup_single_achat AS sup_single_achat_19,
  t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20,
  t0.sup_single_vente AS sup_single_vente_21,
  t0.reduction_enfant AS reduction_enfant_22,
  t0.reduction_lead AS reduction_lead_23,
  t0.is_sup_single AS is_sup_single_24,
  t0.is_ventes_simple AS is_ventes_simple_25,
  t0.note_facturation AS note_facturation_26,
  t0.is_compo_valide AS is_compo_valide_27,
  t0.is_achats_valide AS is_achats_valide_28,
  t0.is_ventes_valide AS is_ventes_valide_29,
  t0.is_pax_valide AS is_pax_valide_30,
  t0.is_transfer_valide AS is_transfer_valide_31,
  t0.prix_cession AS prix_cession_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34,
  t0.voyage_id AS voyage_id_35,
  t0.dossier_segment_etat_id AS dossier_segment_etat_id_36,
  t0.voyage_type_id AS voyage_type_id_37,
  t0.voyage_categorie_id AS voyage_categorie_id_38,
  t0.voyage_theme_id AS voyage_theme_id_39,
  t0.dossier_id AS dossier_id_40,
  t0.destination_id AS destination_id_41,
  t0.created_by AS created_by_42,
  t0.updated_by AS updated_by_43
FROM
  walkinn_dossier_segment t0
WHERE
  t0.dossier_id = ?
  AND t0.actif = ?
ORDER BY
  t0.date_depart ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.libelle_long AS libelle_long_4, t0.client_id AS client_id_5, t0.nb_jours AS nb_jours_6, t0.note AS note_7, t0.actif AS actif_8, t0.description AS description_9, t0.code_walkinn AS code_walkinn_10, t0.date_depart AS date_depart_11, t0.min_pax AS min_pax_12, t0.max_pax AS max_pax_13, t0.code_interne AS code_interne_14, t0.is_prestation_seche AS is_prestation_seche_15, t0.prix_achat_tooltip AS prix_achat_tooltip_16, t0.prix_vente AS prix_vente_17, t0.regulation_manuelle AS regulation_manuelle_18, t0.sup_single_achat AS sup_single_achat_19, t0.sup_single_achat_tooltip AS sup_single_achat_tooltip_20, t0.sup_single_vente AS sup_single_vente_21, t0.reduction_enfant AS reduction_enfant_22, t0.reduction_lead AS reduction_lead_23, t0.is_sup_single AS is_sup_single_24, t0.is_ventes_simple AS is_ventes_simple_25, t0.note_facturation AS note_facturation_26, t0.is_compo_valide AS is_compo_valide_27, t0.is_achats_valide AS is_achats_valide_28, t0.is_ventes_valide AS is_ventes_valide_29, t0.is_pax_valide AS is_pax_valide_30, t0.is_transfer_valide AS is_transfer_valide_31, t0.prix_cession AS prix_cession_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.voyage_id AS voyage_id_35, t0.dossier_segment_etat_id AS dossier_segment_etat_id_36, t0.voyage_type_id AS voyage_type_id_37, t0.voyage_categorie_id AS voyage_categorie_id_38, t0.voyage_theme_id AS voyage_theme_id_39, t0.dossier_id AS dossier_id_40, t0.destination_id AS destination_id_41, t0.created_by AS created_by_42, t0.updated_by AS updated_by_43 FROM walkinn_dossier_segment t0 WHERE t0.dossier_id = 4595 AND t0.actif = 1 ORDER BY t0.date_depart ASC;

SELECT
  e.id AS editorialId,
  c.id AS contentId,
  c.id AS "id",
  c.libelle AS `libelle`,
  c.libelle AS `text`,
  c.contenu AS html,
  t.libelle AS `type`,
  (
    SELECT
      GROUP_CONCAT(d.path)
    FROM
      walkinn_document d
    WHERE
      d.entite = 'editorial'
      AND d.entite_id = e.id
      AND d.actif = 1
  ) AS images
FROM
  walkinn_editorial e
  INNER JOIN walkinn_editorial_contenu c ON c.editorial_id = e.id
  AND c.langue = "FR"
  INNER JOIN walkinn_editorial_type t ON t.id = e.type_id
WHERE
  e.type_id = 3
  AND (c.contexte_id = 1)
  AND (e.categorie_id = 3)
  AND e.actif = 1
  AND e.statut_id = 1
  AND c.actif = 1
ORDER BY
  c.libelle ASC

SELECT e.id AS editorialId     , 
                        c.id AS contentId       ,  
                        c.id AS "id"            ,  
                        c.libelle AS `libelle`  ,
                        c.libelle AS `text`     , 
                        c.contenu AS html       ,
                        t.libelle AS `type`     ,
                        ( SELECT GROUP_CONCAT(d.path) 
                          FROM walkinn_document d 
                          WHERE d.entite = 'editorial' AND d.entite_id = e.id AND d.actif = 1
                        ) AS images
                 FROM walkinn_editorial e 
                 INNER JOIN walkinn_editorial_contenu c ON c.editorial_id = e.id AND c.langue = "FR"
                 INNER JOIN walkinn_editorial_type t ON t.id = e.type_id
                 WHERE e.type_id = 3 AND ( c.contexte_id = 1 ) AND ( e.categorie_id = 3 ) AND e.actif = 1 AND e.statut_id = 1 AND c.actif = 1 ORDER BY c.libelle ASC;

CALL erpwiStaging.GET(
  'erpwiStaging', 'walkinn_dossier_segment',
  '10792', '(SELECT \" \" AS blank) AS "custom1",(SELECT \"<div class=\\\"page-break\\\"></div>\") AS "custom2",c_voyage_id.libelle AS "voyage_id.libelle",c_voyage_id.libelle_long AS "voyage_id.libelle_long",(SELECT c.code_walkinn AS code_voyage) AS "custom3",(SELECT DATE_FORMAT(c.date_depart , \"%d/%m/%Y\")) AS "custom4",(SELECT COUNT(*) FROM walkinn_dossier_segment_pax WHERE actif=1 AND segment_id=c.id) AS "custom5",(SELECT DATE_FORMAT(DATE_ADD(c.date_depart, INTERVAL (c.nb_jours -1) DAY), \"%d/%m/%Y\")) AS "custom6",c.code AS "code",c.code_interne AS "code_interne",c.libelle AS "libelle",c_dossier_id.libelle AS "dossier_id.libelle",(SELECT CONCAT(\"du \", DATE_FORMAT(c.date_depart , \"%d/%m/%Y\"), IF(c.nb_jours > 1, CONCAT(\" au \", DATE_FORMAT(DATE_ADD(c.date_depart, INTERVAL (c.nb_jours -1) DAY) , \"%d/%m/%Y\")), \"\")) AS \"dates\") AS "custom7",(SELECT ext_soc.nom FROM doli_societe ext_soc WHERE ext_soc.rowid = c.client_id) AS "custom8",c_destination_id.libelle AS "destination_id.libelle",c_voyage_type_id.libelle AS "voyage_type_id.libelle",c_voyage_categorie_id.libelle AS "voyage_categorie_id.libelle",c_voyage_theme_id.libelle AS "voyage_theme_id.libelle",c.nb_jours AS "nb_jours",c.min_pax AS "min_pax",c.max_pax AS "max_pax",c.prix_vente AS "prix_vente",c.sup_single_vente AS "sup_single_vente"',
  '', '', '', '', 1, 1
)

CALL erpwiStaging.GET(
                     'erpwiStaging', 
                     'walkinn_dossier_segment', 
                     '10792', 
                     '(SELECT \" \" AS blank) AS "custom1",(SELECT \"<div class=\\\"page-break\\\"></div>\") AS "custom2",c_voyage_id.libelle AS "voyage_id.libelle",c_voyage_id.libelle_long AS "voyage_id.libelle_long",(SELECT c.code_walkinn AS code_voyage) AS "custom3",(SELECT DATE_FORMAT(c.date_depart , \"%d/%m/%Y\")) AS "custom4",(SELECT COUNT(*) FROM walkinn_dossier_segment_pax WHERE actif=1 AND segment_id=c.id) AS "custom5",(SELECT DATE_FORMAT(DATE_ADD(c.date_depart, INTERVAL (c.nb_jours -1) DAY), \"%d/%m/%Y\")) AS "custom6",c.code AS "code",c.code_interne AS "code_interne",c.libelle AS "libelle",c_dossier_id.libelle AS "dossier_id.libelle",(SELECT CONCAT(\"du \", DATE_FORMAT(c.date_depart , \"%d/%m/%Y\"), IF(c.nb_jours > 1, CONCAT(\" au \", DATE_FORMAT(DATE_ADD(c.date_depart, INTERVAL (c.nb_jours -1) DAY) , \"%d/%m/%Y\")), \"\")) AS \"dates\") AS "custom7",(SELECT ext_soc.nom FROM doli_societe ext_soc WHERE ext_soc.rowid = c.client_id) AS "custom8",c_destination_id.libelle AS "destination_id.libelle",c_voyage_type_id.libelle AS "voyage_type_id.libelle",c_voyage_categorie_id.libelle AS "voyage_categorie_id.libelle",c_voyage_theme_id.libelle AS "voyage_theme_id.libelle",c.nb_jours AS "nb_jours",c.min_pax AS "min_pax",c.max_pax AS "max_pax",c.prix_vente AS "prix_vente",c.sup_single_vente AS "sup_single_vente"', 
                     '', 
                     '', 
                     '', 
                     '', 
                     1, 
                     1
                );

SELECT
  CONCAT(
    "documents/societe/", soc.rowid,
    "/logos/", soc.logo
  ) AS "image",
  "max-width: 150px; margin: 0;" AS style
FROM
  walkinn_dossier_segment seg
  LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id
WHERE
  seg.id = :entiteId

SELECT CONCAT("documents/societe/", soc.rowid, "/logos/", soc.logo) AS "image" , "max-width: 150px; margin: 0;" AS style 
                FROM walkinn_dossier_segment seg
                LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id 
                WHERE seg.id = 10792
              ;

SELECT
  CONCAT(
    "documents/societe/", soc.rowid,
    "/logos/", soc.logo
  ) AS "image",
  "max-height: 70px; max-width: 300px; min-height: 50px; min-width: 100px; width: auto; height: auto; margin: 0;" AS style
FROM
  walkinn_dossier_segment seg
  LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id
WHERE
  seg.id = :entiteId

SELECT CONCAT("documents/societe/", soc.rowid, "/logos/", soc.logo) AS "image" , "max-height: 70px; max-width: 300px; min-height: 50px; min-width: 100px; width: auto; height: auto; margin: 0;" AS style 
                FROM walkinn_dossier_segment seg
                LEFT JOIN doli_societe soc ON soc.rowid = seg.client_id 
                WHERE seg.id = 10792
              ;

SELECT
  "/symfony/public/icon/logo.jpg" AS "image",
  "max-height: 70px; max-width: 300px; min-height: 50px; min-width: 100px; width: auto; height: auto; margin: 0; float: right;" AS style

SELECT "/symfony/public/icon/logo.jpg" AS "image", "max-height: 70px; max-width: 300px; min-height: 50px; min-width: 100px; width: auto; height: auto; margin: 0; float: right;" AS style 
              ;

SELECT
  IFNULL(dot.transvalue, v.libelle) AS title
FROM
  walkinn_dossier_segment s
  LEFT JOIN walkinn_voyage v ON v.id = s.voyage_id
  LEFT JOIN doli_overwrite_trans dot ON dot.transkey COLLATE utf8mb4_general_ci = v.libelle COLLATE utf8mb4_general_ci
  AND dot.lang LIKE :Langue
WHERE
  s.id = :entiteId

SELECT IFNULL(dot.transvalue, v.libelle) AS title FROM walkinn_dossier_segment s
                LEFT JOIN walkinn_voyage v ON v.id = s.voyage_id
                LEFT JOIN doli_overwrite_trans dot ON dot.transkey COLLATE utf8mb4_general_ci = v.libelle COLLATE utf8mb4_general_ci AND dot.lang LIKE '%FR%'
                WHERE s.id = 10792 ;

SELECT
  IFNULL(dot.transvalue, v.libelle_long) AS title
FROM
  walkinn_dossier_segment s
  LEFT JOIN walkinn_voyage v ON v.id = s.voyage_id
  LEFT JOIN doli_overwrite_trans dot ON dot.transkey COLLATE utf8mb4_general_ci = v.libelle_long COLLATE utf8mb4_general_ci
  AND dot.lang LIKE :Langue
WHERE
  s.id = :entiteId