Symfony Profiler

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_.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_.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 = '/moderation/translations' AND b1_.updated_at >= '2025-07-01 15:26:01' 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 <> ?
  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 = '/moderation/translations' AND b1_.updated_at >= '2025-07-01 15:25:01' ORDER BY b1_.id ASC;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.key_name AS key_name_2,
  t0.locale AS locale_3,
  t0.translated_text AS translated_text_4,
  t0.is_validated AS is_validated_5,
  t0.redirect_url AS redirect_url_6,
  t0.sub_redirect_url AS sub_redirect_url_7
FROM
  translation t0
WHERE
  t0.is_validated = ?

SELECT t0.id AS id_1, t0.key_name AS key_name_2, t0.locale AS locale_3, t0.translated_text AS translated_text_4, t0.is_validated AS is_validated_5, t0.redirect_url AS redirect_url_6, t0.sub_redirect_url AS sub_redirect_url_7 FROM translation t0 WHERE t0.is_validated = 0;

SELECT
  t0.id AS id_1,
  t0.icone AS icone_2,
  t0.libelle AS libelle_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  ba_notification_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.icone AS icone_2, t0.libelle AS libelle_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM ba_notification_type t0 WHERE t0.id = 2;

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;

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 ('/moderation/translations', '[]', '[]', 1, '2025-07-01 15:27:01', '2025-07-01 15:27:01', 26, 26, NULL);

"START TRANSACTION"

"START TRANSACTION";