Symfony Profiler

SELECT
  h0_.id AS id_0,
  h0_.ip AS ip_1,
  h0_.datetime AS datetime_2,
  h0_.route AS route_3
FROM
  historique_route h0_
WHERE
  h0_.ip = ?
  AND h0_.route = ?
  AND h0_.datetime >= ?
LIMIT
  1

SELECT h0_.id AS id_0, h0_.ip AS ip_1, h0_.datetime AS datetime_2, h0_.route AS route_3 FROM historique_route h0_ WHERE h0_.ip = '216.73.216.149' AND h0_.route = 'afficher_avis' AND h0_.datetime >= '2026-05-10 23:08:44' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.date_obseques AS date_obseques_3,
  t0.lieu_obseques AS lieu_obseques_4,
  t0.code_famille AS code_famille_5,
  t0.date_publication AS date_publication_6,
  t0.creneau_visite AS creneau_visite_7,
  t0.avis_depose AS avis_depose_8,
  t0.actif AS actif_9,
  t0.cloture_espace_condoleance AS cloture_espace_condoleance_10,
  t0.nb_visite AS nb_visite_11,
  t0.alerte_auto_famille AS alerte_auto_famille_12,
  t0.email_famille AS email_famille_13,
  t0.couple AS couple_14,
  t0.masquer_age AS masquer_age_15,
  t0.date_publication_remerciement AS date_publication_remerciement_16,
  t0.defunt_id AS defunt_id_17,
  t0.utilisateur_id AS utilisateur_id_18
FROM
  avis_deces t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_obseques AS date_obseques_3, t0.lieu_obseques AS lieu_obseques_4, t0.code_famille AS code_famille_5, t0.date_publication AS date_publication_6, t0.creneau_visite AS creneau_visite_7, t0.avis_depose AS avis_depose_8, t0.actif AS actif_9, t0.cloture_espace_condoleance AS cloture_espace_condoleance_10, t0.nb_visite AS nb_visite_11, t0.alerte_auto_famille AS alerte_auto_famille_12, t0.email_famille AS email_famille_13, t0.couple AS couple_14, t0.masquer_age AS masquer_age_15, t0.date_publication_remerciement AS date_publication_remerciement_16, t0.defunt_id AS defunt_id_17, t0.utilisateur_id AS utilisateur_id_18 FROM avis_deces t0 WHERE t0.id = '3045';

SELECT
  a0_.id AS id_0,
  a0_.date_creation AS date_creation_1,
  a0_.date_obseques AS date_obseques_2,
  a0_.lieu_obseques AS lieu_obseques_3,
  a0_.code_famille AS code_famille_4,
  a0_.date_publication AS date_publication_5,
  a0_.creneau_visite AS creneau_visite_6,
  a0_.avis_depose AS avis_depose_7,
  a0_.actif AS actif_8,
  a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9,
  a0_.nb_visite AS nb_visite_10,
  a0_.alerte_auto_famille AS alerte_auto_famille_11,
  a0_.email_famille AS email_famille_12,
  a0_.couple AS couple_13,
  a0_.masquer_age AS masquer_age_14,
  a0_.date_publication_remerciement AS date_publication_remerciement_15,
  a0_.defunt_id AS defunt_id_16,
  a0_.utilisateur_id AS utilisateur_id_17
FROM
  avis_deces a0_
WHERE
  a0_.id > ?
  AND a0_.actif = ?
ORDER BY
  a0_.id ASC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.date_creation AS date_creation_1, a0_.date_obseques AS date_obseques_2, a0_.lieu_obseques AS lieu_obseques_3, a0_.code_famille AS code_famille_4, a0_.date_publication AS date_publication_5, a0_.creneau_visite AS creneau_visite_6, a0_.avis_depose AS avis_depose_7, a0_.actif AS actif_8, a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9, a0_.nb_visite AS nb_visite_10, a0_.alerte_auto_famille AS alerte_auto_famille_11, a0_.email_famille AS email_famille_12, a0_.couple AS couple_13, a0_.masquer_age AS masquer_age_14, a0_.date_publication_remerciement AS date_publication_remerciement_15, a0_.defunt_id AS defunt_id_16, a0_.utilisateur_id AS utilisateur_id_17 FROM avis_deces a0_ WHERE a0_.id > '3045' AND a0_.actif = 1 ORDER BY a0_.id ASC LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.date_creation AS date_creation_1,
  a0_.date_obseques AS date_obseques_2,
  a0_.lieu_obseques AS lieu_obseques_3,
  a0_.code_famille AS code_famille_4,
  a0_.date_publication AS date_publication_5,
  a0_.creneau_visite AS creneau_visite_6,
  a0_.avis_depose AS avis_depose_7,
  a0_.actif AS actif_8,
  a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9,
  a0_.nb_visite AS nb_visite_10,
  a0_.alerte_auto_famille AS alerte_auto_famille_11,
  a0_.email_famille AS email_famille_12,
  a0_.couple AS couple_13,
  a0_.masquer_age AS masquer_age_14,
  a0_.date_publication_remerciement AS date_publication_remerciement_15,
  a0_.defunt_id AS defunt_id_16,
  a0_.utilisateur_id AS utilisateur_id_17
FROM
  avis_deces a0_
WHERE
  a0_.id < ?
  AND a0_.actif = ?
ORDER BY
  a0_.id DESC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.date_creation AS date_creation_1, a0_.date_obseques AS date_obseques_2, a0_.lieu_obseques AS lieu_obseques_3, a0_.code_famille AS code_famille_4, a0_.date_publication AS date_publication_5, a0_.creneau_visite AS creneau_visite_6, a0_.avis_depose AS avis_depose_7, a0_.actif AS actif_8, a0_.cloture_espace_condoleance AS cloture_espace_condoleance_9, a0_.nb_visite AS nb_visite_10, a0_.alerte_auto_famille AS alerte_auto_famille_11, a0_.email_famille AS email_famille_12, a0_.couple AS couple_13, a0_.masquer_age AS masquer_age_14, a0_.date_publication_remerciement AS date_publication_remerciement_15, a0_.defunt_id AS defunt_id_16, a0_.utilisateur_id AS utilisateur_id_17 FROM avis_deces a0_ WHERE a0_.id < '3045' AND a0_.actif = 1 ORDER BY a0_.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.essais AS essais_3,
  t0.date_essai AS date_essai_4,
  t0.avis_deces_id AS avis_deces_id_5
FROM
  bruteforce t0
WHERE
  t0.ip = ?
  AND t0.avis_deces_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.essais AS essais_3, t0.date_essai AS date_essai_4, t0.avis_deces_id AS avis_deces_id_5 FROM bruteforce t0 WHERE t0.ip = '216.73.216.149' AND t0.avis_deces_id = 3045 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.email AS email_5,
  t0.date_creation AS date_creation_6,
  t0.validite AS validite_7,
  t0.prive AS prive_8,
  t0.nom_fichier AS nom_fichier_9,
  t0.adresse AS adresse_10,
  t0.commune AS commune_11,
  t0.avis_deces_id AS avis_deces_id_12
FROM
  condoleance t0
WHERE
  t0.avis_deces_id = ?
  AND t0.validite = ?
ORDER BY
  t0.date_creation DESC

SELECT t0.id AS id_1, t0.message AS message_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.email AS email_5, t0.date_creation AS date_creation_6, t0.validite AS validite_7, t0.prive AS prive_8, t0.nom_fichier AS nom_fichier_9, t0.adresse AS adresse_10, t0.commune AS commune_11, t0.avis_deces_id AS avis_deces_id_12 FROM condoleance t0 WHERE t0.avis_deces_id = 3045 AND t0.validite = 1 ORDER BY t0.date_creation DESC;

SELECT
  t0.id AS id_1,
  t0.genre AS genre_2,
  t0.nom AS nom_3,
  t0.nom_jeune_fille AS nom_jeune_fille_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.date_deces AS date_deces_7,
  t0.lieu_naissance AS lieu_naissance_8,
  t0.lieu_deces AS lieu_deces_9,
  t0.commune_residence AS commune_residence_10,
  t0.commune_codepostal AS commune_codepostal_11
FROM
  defunt t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.genre AS genre_2, t0.nom AS nom_3, t0.nom_jeune_fille AS nom_jeune_fille_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.date_deces AS date_deces_7, t0.lieu_naissance AS lieu_naissance_8, t0.lieu_deces AS lieu_deces_9, t0.commune_residence AS commune_residence_10, t0.commune_codepostal AS commune_codepostal_11 FROM defunt t0 WHERE t0.id = 3048;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  avis_deces
SET
  nb_visite = ?
WHERE
  id = ?

UPDATE avis_deces SET nb_visite = 180 WHERE id = 3045;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.validite AS validite_2,
  t0.date_creation AS date_creation_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.email AS email_6,
  t0.nom_fichier AS nom_fichier_7,
  t0.avis_deces_id AS avis_deces_id_8
FROM
  portrait t0
WHERE
  t0.avis_deces_id = ?
  AND t0.validite = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.validite AS validite_2, t0.date_creation AS date_creation_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.email AS email_6, t0.nom_fichier AS nom_fichier_7, t0.avis_deces_id AS avis_deces_id_8 FROM portrait t0 WHERE t0.avis_deces_id = 3045 AND t0.validite = 1 LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.contenu AS contenu_1,
  a0_.avis_deces_id AS avis_deces_id_2
FROM
  avis_deces_remerciement a0_
WHERE
  a0_.avis_deces_id = ?
ORDER BY
  a0_.id ASC
LIMIT
  1

SELECT a0_.id AS id_0, a0_.contenu AS contenu_1, a0_.avis_deces_id AS avis_deces_id_2 FROM avis_deces_remerciement a0_ WHERE a0_.avis_deces_id = 3045 ORDER BY a0_.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.genre AS genre_2,
  t0.nom AS nom_3,
  t0.nom_jeune_fille AS nom_jeune_fille_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.date_deces AS date_deces_7,
  t0.lieu_naissance AS lieu_naissance_8,
  t0.lieu_deces AS lieu_deces_9,
  t0.commune_residence AS commune_residence_10,
  t0.commune_codepostal AS commune_codepostal_11
FROM
  defunt t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.genre AS genre_2, t0.nom AS nom_3, t0.nom_jeune_fille AS nom_jeune_fille_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.date_deces AS date_deces_7, t0.lieu_naissance AS lieu_naissance_8, t0.lieu_deces AS lieu_deces_9, t0.commune_residence AS commune_residence_10, t0.commune_codepostal AS commune_codepostal_11 FROM defunt t0 WHERE t0.id = 3047;

SELECT
  t0.id AS id_1,
  t0.genre AS genre_2,
  t0.nom AS nom_3,
  t0.nom_jeune_fille AS nom_jeune_fille_4,
  t0.prenom AS prenom_5,
  t0.date_naissance AS date_naissance_6,
  t0.date_deces AS date_deces_7,
  t0.lieu_naissance AS lieu_naissance_8,
  t0.lieu_deces AS lieu_deces_9,
  t0.commune_residence AS commune_residence_10,
  t0.commune_codepostal AS commune_codepostal_11
FROM
  defunt t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.genre AS genre_2, t0.nom AS nom_3, t0.nom_jeune_fille AS nom_jeune_fille_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.date_deces AS date_deces_7, t0.lieu_naissance AS lieu_naissance_8, t0.lieu_deces AS lieu_deces_9, t0.commune_residence AS commune_residence_10, t0.commune_codepostal AS commune_codepostal_11 FROM defunt t0 WHERE t0.id = 3049;

SELECT
  t0.id AS id_1,
  t0.libelle_etape AS libelle_etape_2,
  t0.date_etape AS date_etape_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.rue AS rue_6,
  t0.ville AS ville_7,
  t0.code_postal AS code_postal_8,
  t0.ordre AS ordre_9,
  t0.avis_deces_id AS avis_deces_id_10
FROM
  etape t0
WHERE
  t0.avis_deces_id = ?

SELECT t0.id AS id_1, t0.libelle_etape AS libelle_etape_2, t0.date_etape AS date_etape_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.rue AS rue_6, t0.ville AS ville_7, t0.code_postal AS code_postal_8, t0.ordre AS ordre_9, t0.avis_deces_id AS avis_deces_id_10 FROM etape t0 WHERE t0.avis_deces_id = 3045;