Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.user_id AS user_id_2,
  t0.login AS login_3,
  t0.session_id AS session_id_4,
  t0.date_debut AS date_debut_5,
  t0.date_fin AS date_fin_6
FROM
  session_log t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.login AS login_3, t0.session_id AS session_id_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6 FROM session_log t0 WHERE t0.user_id = 1 ORDER BY t0.id DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  session_log
SET
  date_fin = ?
WHERE
  id = ?

UPDATE session_log SET date_fin = '2025-09-30 14:42:56' WHERE id = 647;

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.site_id AS site_id_1,
  s0_.nom AS nom_2,
  s0_.nom_raccourci AS nom_raccourci_3,
  s0_.nom_short AS nom_short_4,
  s0_.email_from AS email_from_5,
  s0_.email_to_test AS email_to_test_6,
  s0_.couleur AS couleur_7,
  s0_.ordre AS ordre_8,
  s0_.planning1_id AS planning1_id_9,
  s0_.planning2_id AS planning2_id_10,
  s0_.supervision_planning_id AS supervision_planning_id_11,
  s0_.vetcoach_planning_id AS vetcoach_planning_id_12,
  s0_.asv_planning_id AS asv_planning_id_13,
  s0_.astreinte_chirurgie_planning_id AS astreinte_chirurgie_planning_id_14,
  s0_.adresse1 AS adresse1_15,
  s0_.adresse2 AS adresse2_16,
  s0_.texte_mono_langue1 AS texte_mono_langue1_17,
  s0_.texte_mono_langue2 AS texte_mono_langue2_18,
  s0_.texte_multi_langue1 AS texte_multi_langue1_19,
  s0_.texte_multi_langue2 AS texte_multi_langue2_20,
  s0_.texte_sans_langue1 AS texte_sans_langue1_21,
  s0_.texte_sans_langue2 AS texte_sans_langue2_22,
  s0_.coeff_feux AS coeff_feux_23,
  s0_.lien_externe_message AS lien_externe_message_24,
  s0_.lien_externe_prise_appel AS lien_externe_prise_appel_25,
  s0_.lien_externe_veterinaire_planning AS lien_externe_veterinaire_planning_26,
  s0_.url_root AS url_root_27,
  s0_.email_manager_service_regulation AS email_manager_service_regulation_28,
  s0_.content_estimatif_tarifs AS content_estimatif_tarifs_29,
  s0_.content_infos_secteur AS content_infos_secteur_30,
  s0_.content_infos_admin AS content_infos_admin_31,
  s0_.content_contacts_utiles AS content_contacts_utiles_32,
  s0_.content_processus AS content_processus_33,
  s0_.sms_expediteur AS sms_expediteur_34,
  s0_.sms_contenue_langue1 AS sms_contenue_langue1_35,
  s0_.sms_contenue_langue2 AS sms_contenue_langue2_36,
  s0_.chat_consultation_acces_restreint AS chat_consultation_acces_restreint_37,
  s0_.chat_consultation_creation_mono_langue1 AS chat_consultation_creation_mono_langue1_38,
  s0_.chat_consultation_creation_mono_langue2 AS chat_consultation_creation_mono_langue2_39,
  s0_.chat_consultation_creation_multi_langue1 AS chat_consultation_creation_multi_langue1_40,
  s0_.chat_consultation_creation_multi_langue2 AS chat_consultation_creation_multi_langue2_41,
  s0_.chat_consultation_creation_sans_langue1 AS chat_consultation_creation_sans_langue1_42,
  s0_.chat_consultation_creation_sans_langue2 AS chat_consultation_creation_sans_langue2_43,
  s0_.date_creation AS date_creation_44,
  s0_.date_modification AS date_modification_45,
  s0_.ville_id AS ville_id_46,
  s0_.fonctionnement_id AS fonctionnement_id_47,
  s0_.langue1_id AS langue1_id_48,
  s0_.langue2_id AS langue2_id_49,
  s0_.secteur_delai_defaut_id AS secteur_delai_defaut_id_50,
  s0_.referant_id AS referant_id_51
FROM
  secteur s0_
  LEFT JOIN secteur_planning_regulation s1_ ON s0_.id = s1_.secteur_id
WHERE
  s0_.id = ?
  AND (
    (
      s0_.planning1_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
      OR s0_.planning2_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
      OR s0_.supervision_planning_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
      OR s0_.astreinte_chirurgie_planning_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
      OR s1_.planning_id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
      )
    )
  )
GROUP BY
  s0_.id

SELECT s0_.id AS id_0, s0_.site_id AS site_id_1, s0_.nom AS nom_2, s0_.nom_raccourci AS nom_raccourci_3, s0_.nom_short AS nom_short_4, s0_.email_from AS email_from_5, s0_.email_to_test AS email_to_test_6, s0_.couleur AS couleur_7, s0_.ordre AS ordre_8, s0_.planning1_id AS planning1_id_9, s0_.planning2_id AS planning2_id_10, s0_.supervision_planning_id AS supervision_planning_id_11, s0_.vetcoach_planning_id AS vetcoach_planning_id_12, s0_.asv_planning_id AS asv_planning_id_13, s0_.astreinte_chirurgie_planning_id AS astreinte_chirurgie_planning_id_14, s0_.adresse1 AS adresse1_15, s0_.adresse2 AS adresse2_16, s0_.texte_mono_langue1 AS texte_mono_langue1_17, s0_.texte_mono_langue2 AS texte_mono_langue2_18, s0_.texte_multi_langue1 AS texte_multi_langue1_19, s0_.texte_multi_langue2 AS texte_multi_langue2_20, s0_.texte_sans_langue1 AS texte_sans_langue1_21, s0_.texte_sans_langue2 AS texte_sans_langue2_22, s0_.coeff_feux AS coeff_feux_23, s0_.lien_externe_message AS lien_externe_message_24, s0_.lien_externe_prise_appel AS lien_externe_prise_appel_25, s0_.lien_externe_veterinaire_planning AS lien_externe_veterinaire_planning_26, s0_.url_root AS url_root_27, s0_.email_manager_service_regulation AS email_manager_service_regulation_28, s0_.content_estimatif_tarifs AS content_estimatif_tarifs_29, s0_.content_infos_secteur AS content_infos_secteur_30, s0_.content_infos_admin AS content_infos_admin_31, s0_.content_contacts_utiles AS content_contacts_utiles_32, s0_.content_processus AS content_processus_33, s0_.sms_expediteur AS sms_expediteur_34, s0_.sms_contenue_langue1 AS sms_contenue_langue1_35, s0_.sms_contenue_langue2 AS sms_contenue_langue2_36, s0_.chat_consultation_acces_restreint AS chat_consultation_acces_restreint_37, s0_.chat_consultation_creation_mono_langue1 AS chat_consultation_creation_mono_langue1_38, s0_.chat_consultation_creation_mono_langue2 AS chat_consultation_creation_mono_langue2_39, s0_.chat_consultation_creation_multi_langue1 AS chat_consultation_creation_multi_langue1_40, s0_.chat_consultation_creation_multi_langue2 AS chat_consultation_creation_multi_langue2_41, s0_.chat_consultation_creation_sans_langue1 AS chat_consultation_creation_sans_langue1_42, s0_.chat_consultation_creation_sans_langue2 AS chat_consultation_creation_sans_langue2_43, s0_.date_creation AS date_creation_44, s0_.date_modification AS date_modification_45, s0_.ville_id AS ville_id_46, s0_.fonctionnement_id AS fonctionnement_id_47, s0_.langue1_id AS langue1_id_48, s0_.langue2_id AS langue2_id_49, s0_.secteur_delai_defaut_id AS secteur_delai_defaut_id_50, s0_.referant_id AS referant_id_51 FROM secteur s0_ LEFT JOIN secteur_planning_regulation s1_ ON s0_.id = s1_.secteur_id WHERE s0_.id = 25 AND ((s0_.planning1_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78) OR s0_.planning2_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78) OR s0_.supervision_planning_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78) OR s0_.astreinte_chirurgie_planning_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78) OR s1_.planning_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78))) GROUP BY s0_.id;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_short AS nom_short_3,
  t0.couleur AS couleur_4,
  t0.secteur_id AS secteur_id_5
FROM
  chat_canal t0
WHERE
  t0.secteur_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_short AS nom_short_3, t0.couleur AS couleur_4, t0.secteur_id AS secteur_id_5 FROM chat_canal t0 WHERE t0.secteur_id = 25;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.planning_type_id AS planning_type_id_4
FROM
  fonctionnement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.planning_type_id AS planning_type_id_4 FROM fonctionnement t0 WHERE t0.id = 1;

SELECT
  c0_.id AS id_0,
  s1_.nom AS nom_1,
  c0_.info_arv AS info_arv_2,
  c0_.debut_consultation AS debut_consultation_3,
  c0_.fin_consultation AS fin_consultation_4,
  c0_.date_eta AS date_eta_5,
  c0_.veterinaire_intervenant_id AS veterinaire_intervenant_id_6,
  c0_.externe_id AS externe_id_7,
  a2_.motif_appel AS motif_appel_8,
  v3_.cp AS cp_9,
  v3_.nom AS nom_10,
  CASE WHEN s4_.prefix_phone IS NULL THEN 99 ELSE s4_.prefix_phone END AS sclr_11,
  l5_.locale AS locale_12,
  c6_.code AS code_13,
  c7_.code AS code_14,
  c8_.id AS id_15,
  c8_.nom AS nom_16,
  c8_.telephone1 AS telephone1_17,
  c8_.telephone2 AS telephone2_18,
  c8_.informations_particulier AS informations_particulier_19,
  r9_.nom AS nom_20,
  c10_.saisie_user_id AS saisie_user_id_21,
  c10_.date_creation AS date_creation_22,
  a11_.nom AS nom_23,
  a11_.animal_race_autre_nom AS animal_race_autre_nom_24,
  a12_.code AS code_25,
  a13_.code AS code_26,
  c14_.id AS id_27,
  c14_.code AS code_28,
  s15_.url_root AS url_root_29,
  (
    SELECT
      COUNT(a16_.id) AS sclr_31
    FROM
      appel a16_
      INNER JOIN appel_animal a17_ ON (
        a16_.id = a17_.appel_id
        AND a17_.active = 1
      )
    WHERE
      a16_.appel_type_id = 4
      AND a16_.demande_de_nouvelle_faite = 0
      AND a17_.animal_id = a18_.animal_id
      AND a16_.date_creation >= c10_.date_creation
  ) AS sclr_30
FROM
  consultation c0_
  INNER JOIN appel_animal a18_ ON c0_.appel_animal_id = a18_.id
  INNER JOIN appel a2_ ON a18_.appel_id = a2_.id
  INNER JOIN animal a11_ ON a18_.animal_id = a11_.id
  INNER JOIN animal_espece a12_ ON a11_.animal_espece_id = a12_.id
  INNER JOIN consultation_etat c6_ ON c0_.consultation_etat_id = c6_.id
  INNER JOIN secteur s15_ ON a2_.secteur_id = s15_.id
  INNER JOIN client c8_ ON a2_.client_id = c8_.id
  INNER JOIN referant r9_ ON a2_.referant_id = r9_.id
  INNER JOIN consultation_etat_historique c10_ ON (
    c10_.id = (
      SELECT
        MAX(c19_.id) AS sclr_32
      FROM
        consultation_etat_historique c19_
      WHERE
        c19_.consultation_id = c0_.id
    )
  )
  LEFT JOIN ville v3_ ON a2_.ville_id = v3_.id
  LEFT JOIN pays p20_ ON (
    LOCATE(p20_.indicatif, c8_.telephone1) = 1
  )
  LEFT JOIN secteur_pays s4_ ON (
    s15_.id = s4_.secteur_id
    AND s4_.pays_id = p20_.id
  )
  LEFT JOIN secteur_zone s21_ ON a2_.secteur_zone_id = s21_.id
  LEFT JOIN langue l5_ ON a2_.langue_id = l5_.id
  LEFT JOIN sous_secteur s1_ ON s21_.sous_secteur_id = s1_.id
  LEFT JOIN consultation_delai_urgence c7_ ON c0_.consultation_delai_urgence_id = c7_.id
  LEFT JOIN consultation_niveau_urgence c14_ ON c0_.consultation_niveau_urgence_id = c14_.id
  LEFT JOIN animal_race a13_ ON a11_.animal_race_id = a13_.id
WHERE
  s15_.id = ?
  AND c0_.active = 1
  AND a18_.active = 1
ORDER BY
  c0_.date_creation DESC

SELECT c0_.id AS id_0, s1_.nom AS nom_1, c0_.info_arv AS info_arv_2, c0_.debut_consultation AS debut_consultation_3, c0_.fin_consultation AS fin_consultation_4, c0_.date_eta AS date_eta_5, c0_.veterinaire_intervenant_id AS veterinaire_intervenant_id_6, c0_.externe_id AS externe_id_7, a2_.motif_appel AS motif_appel_8, v3_.cp AS cp_9, v3_.nom AS nom_10, CASE WHEN s4_.prefix_phone IS NULL THEN 99 ELSE s4_.prefix_phone END AS sclr_11, l5_.locale AS locale_12, c6_.code AS code_13, c7_.code AS code_14, c8_.id AS id_15, c8_.nom AS nom_16, c8_.telephone1 AS telephone1_17, c8_.telephone2 AS telephone2_18, c8_.informations_particulier AS informations_particulier_19, r9_.nom AS nom_20, c10_.saisie_user_id AS saisie_user_id_21, c10_.date_creation AS date_creation_22, a11_.nom AS nom_23, a11_.animal_race_autre_nom AS animal_race_autre_nom_24, a12_.code AS code_25, a13_.code AS code_26, c14_.id AS id_27, c14_.code AS code_28, s15_.url_root AS url_root_29, (SELECT COUNT(a16_.id) AS sclr_31 FROM appel a16_ INNER JOIN appel_animal a17_ ON (a16_.id = a17_.appel_id AND a17_.active = 1) WHERE a16_.appel_type_id = 4 AND a16_.demande_de_nouvelle_faite = 0 AND a17_.animal_id = a18_.animal_id AND a16_.date_creation >= c10_.date_creation) AS sclr_30 FROM consultation c0_ INNER JOIN appel_animal a18_ ON c0_.appel_animal_id = a18_.id INNER JOIN appel a2_ ON a18_.appel_id = a2_.id INNER JOIN animal a11_ ON a18_.animal_id = a11_.id INNER JOIN animal_espece a12_ ON a11_.animal_espece_id = a12_.id INNER JOIN consultation_etat c6_ ON c0_.consultation_etat_id = c6_.id INNER JOIN secteur s15_ ON a2_.secteur_id = s15_.id INNER JOIN client c8_ ON a2_.client_id = c8_.id INNER JOIN referant r9_ ON a2_.referant_id = r9_.id INNER JOIN consultation_etat_historique c10_ ON (c10_.id = (SELECT MAX(c19_.id) AS sclr_32 FROM consultation_etat_historique c19_ WHERE c19_.consultation_id = c0_.id)) LEFT JOIN ville v3_ ON a2_.ville_id = v3_.id LEFT JOIN pays p20_ ON (LOCATE(p20_.indicatif, c8_.telephone1) = 1) LEFT JOIN secteur_pays s4_ ON (s15_.id = s4_.secteur_id AND s4_.pays_id = p20_.id) LEFT JOIN secteur_zone s21_ ON a2_.secteur_zone_id = s21_.id LEFT JOIN langue l5_ ON a2_.langue_id = l5_.id LEFT JOIN sous_secteur s1_ ON s21_.sous_secteur_id = s1_.id LEFT JOIN consultation_delai_urgence c7_ ON c0_.consultation_delai_urgence_id = c7_.id LEFT JOIN consultation_niveau_urgence c14_ ON c0_.consultation_niveau_urgence_id = c14_.id LEFT JOIN animal_race a13_ ON a11_.animal_race_id = a13_.id WHERE s15_.id = 25 AND c0_.active = 1 AND a18_.active = 1 ORDER BY c0_.date_creation DESC;

SELECT
  s0_.id AS id_0
FROM
  user u1_
  INNER JOIN user_site u2_ ON (u1_.id = u2_.user_id)
  INNER JOIN site s0_ ON u2_.site_id = s0_.id
  AND (u2_.site_id = s0_.id)
WHERE
  u1_.id = ?

SELECT s0_.id AS id_0 FROM user u1_ INNER JOIN user_site u2_ ON (u1_.id = u2_.user_id) INNER JOIN site s0_ ON u2_.site_id = s0_.id AND (u2_.site_id = s0_.id) WHERE u1_.id = 1;

SELECT
  u0_.id AS id_0,
  u0_.nom AS nom_1,
  u0_.prenom AS prenom_2,
  u0_.email AS email_3
FROM
  user u0_
WHERE
  u0_.active = 1
  AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  nom_1 ASC,
  prenom_2 ASC

SELECT u0_.id AS id_0, u0_.nom AS nom_1, u0_.prenom AS prenom_2, u0_.email AS email_3 FROM user u0_ WHERE u0_.active = 1 AND u0_.id IN (169, 1, 1285, 1370, 188, 729, 1347, 607) ORDER BY nom_1 ASC, prenom_2 ASC;