Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.created_at AS created_at_3,
  t0.titre AS titre_4,
  t0.limite_at AS limite_at_5,
  t0.nombre_de_vues AS nombre_de_vues_6,
  t0.publication_at AS publication_at_7,
  t0.prix AS prix_8,
  t0.start_at AS start_at_9,
  t0.slug AS slug_10,
  t0.statut AS statut_11,
  t0.numero_annonce AS numero_annonce_12,
  t0.region AS region_13,
  t0.ville AS ville_14,
  t0.quartier AS quartier_15,
  t0.latitude AS latitude_16,
  t0.longitude AS longitude_17,
  t0.es_negociable AS es_negociable_18,
  t0.vedette AS vedette_19,
  t0.is_annonce_deleted AS is_annonce_deleted_20,
  t0.annonce_deleted_at AS annonce_deleted_at_21,
  t0.disponibilite AS disponibilite_22,
  t0.temps_de_reponse AS temps_de_reponse_23,
  t0.telephone AS telephone_24,
  t0.whatsapp AS whatsapp_25,
  t0.user_id AS user_id_26,
  t0.categorie_id AS categorie_id_27,
  t0.supprime_paradmin_id AS supprime_paradmin_id_28
FROM
  annonce t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.titre AS titre_4, t0.limite_at AS limite_at_5, t0.nombre_de_vues AS nombre_de_vues_6, t0.publication_at AS publication_at_7, t0.prix AS prix_8, t0.start_at AS start_at_9, t0.slug AS slug_10, t0.statut AS statut_11, t0.numero_annonce AS numero_annonce_12, t0.region AS region_13, t0.ville AS ville_14, t0.quartier AS quartier_15, t0.latitude AS latitude_16, t0.longitude AS longitude_17, t0.es_negociable AS es_negociable_18, t0.vedette AS vedette_19, t0.is_annonce_deleted AS is_annonce_deleted_20, t0.annonce_deleted_at AS annonce_deleted_at_21, t0.disponibilite AS disponibilite_22, t0.temps_de_reponse AS temps_de_reponse_23, t0.telephone AS telephone_24, t0.whatsapp AS whatsapp_25, t0.user_id AS user_id_26, t0.categorie_id AS categorie_id_27, t0.supprime_paradmin_id AS supprime_paradmin_id_28 FROM annonce t0 WHERE t0.id = '125';

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.created_at AS created_at_2,
  a0_.titre AS titre_3,
  a0_.limite_at AS limite_at_4,
  a0_.nombre_de_vues AS nombre_de_vues_5,
  a0_.publication_at AS publication_at_6,
  a0_.prix AS prix_7,
  a0_.start_at AS start_at_8,
  a0_.slug AS slug_9,
  a0_.statut AS statut_10,
  a0_.numero_annonce AS numero_annonce_11,
  a0_.region AS region_12,
  a0_.ville AS ville_13,
  a0_.quartier AS quartier_14,
  a0_.latitude AS latitude_15,
  a0_.longitude AS longitude_16,
  a0_.es_negociable AS es_negociable_17,
  a0_.vedette AS vedette_18,
  a0_.is_annonce_deleted AS is_annonce_deleted_19,
  a0_.annonce_deleted_at AS annonce_deleted_at_20,
  a0_.disponibilite AS disponibilite_21,
  a0_.temps_de_reponse AS temps_de_reponse_22,
  a0_.telephone AS telephone_23,
  a0_.whatsapp AS whatsapp_24,
  a0_.user_id AS user_id_25,
  a0_.categorie_id AS categorie_id_26,
  a0_.supprime_paradmin_id AS supprime_paradmin_id_27
FROM
  annonce a0_
WHERE
  a0_.categorie_id = ?
  AND a0_.id <> ?
  AND a0_.statut = ?
  AND (
    a0_.limite_at IS NULL
    OR a0_.limite_at > ?
  )
ORDER BY
  a0_.publication_at DESC
LIMIT
  4

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.created_at AS created_at_2, a0_.titre AS titre_3, a0_.limite_at AS limite_at_4, a0_.nombre_de_vues AS nombre_de_vues_5, a0_.publication_at AS publication_at_6, a0_.prix AS prix_7, a0_.start_at AS start_at_8, a0_.slug AS slug_9, a0_.statut AS statut_10, a0_.numero_annonce AS numero_annonce_11, a0_.region AS region_12, a0_.ville AS ville_13, a0_.quartier AS quartier_14, a0_.latitude AS latitude_15, a0_.longitude AS longitude_16, a0_.es_negociable AS es_negociable_17, a0_.vedette AS vedette_18, a0_.is_annonce_deleted AS is_annonce_deleted_19, a0_.annonce_deleted_at AS annonce_deleted_at_20, a0_.disponibilite AS disponibilite_21, a0_.temps_de_reponse AS temps_de_reponse_22, a0_.telephone AS telephone_23, a0_.whatsapp AS whatsapp_24, a0_.user_id AS user_id_25, a0_.categorie_id AS categorie_id_26, a0_.supprime_paradmin_id AS supprime_paradmin_id_27 FROM annonce a0_ WHERE a0_.categorie_id = 332 AND a0_.id <> 125 AND a0_.statut = 'Publié' AND (a0_.limite_at IS NULL OR a0_.limite_at > '2026-03-05 18:10:31') ORDER BY a0_.publication_at DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.description AS description_1,
  a0_.created_at AS created_at_2,
  a0_.titre AS titre_3,
  a0_.limite_at AS limite_at_4,
  a0_.nombre_de_vues AS nombre_de_vues_5,
  a0_.publication_at AS publication_at_6,
  a0_.prix AS prix_7,
  a0_.start_at AS start_at_8,
  a0_.slug AS slug_9,
  a0_.statut AS statut_10,
  a0_.numero_annonce AS numero_annonce_11,
  a0_.region AS region_12,
  a0_.ville AS ville_13,
  a0_.quartier AS quartier_14,
  a0_.latitude AS latitude_15,
  a0_.longitude AS longitude_16,
  a0_.es_negociable AS es_negociable_17,
  a0_.vedette AS vedette_18,
  a0_.is_annonce_deleted AS is_annonce_deleted_19,
  a0_.annonce_deleted_at AS annonce_deleted_at_20,
  a0_.disponibilite AS disponibilite_21,
  a0_.temps_de_reponse AS temps_de_reponse_22,
  a0_.telephone AS telephone_23,
  a0_.whatsapp AS whatsapp_24,
  a0_.user_id AS user_id_25,
  a0_.categorie_id AS categorie_id_26,
  a0_.supprime_paradmin_id AS supprime_paradmin_id_27
FROM
  annonce a0_
WHERE
  a0_.publication_at IS NOT NULL
  AND a0_.statut = ?
  AND (
    a0_.limite_at IS NULL
    OR a0_.limite_at > ?
  )
ORDER BY
  a0_.publication_at DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.description AS description_1, a0_.created_at AS created_at_2, a0_.titre AS titre_3, a0_.limite_at AS limite_at_4, a0_.nombre_de_vues AS nombre_de_vues_5, a0_.publication_at AS publication_at_6, a0_.prix AS prix_7, a0_.start_at AS start_at_8, a0_.slug AS slug_9, a0_.statut AS statut_10, a0_.numero_annonce AS numero_annonce_11, a0_.region AS region_12, a0_.ville AS ville_13, a0_.quartier AS quartier_14, a0_.latitude AS latitude_15, a0_.longitude AS longitude_16, a0_.es_negociable AS es_negociable_17, a0_.vedette AS vedette_18, a0_.is_annonce_deleted AS is_annonce_deleted_19, a0_.annonce_deleted_at AS annonce_deleted_at_20, a0_.disponibilite AS disponibilite_21, a0_.temps_de_reponse AS temps_de_reponse_22, a0_.telephone AS telephone_23, a0_.whatsapp AS whatsapp_24, a0_.user_id AS user_id_25, a0_.categorie_id AS categorie_id_26, a0_.supprime_paradmin_id AS supprime_paradmin_id_27 FROM annonce a0_ WHERE a0_.publication_at IS NOT NULL AND a0_.statut = 'Publié' AND (a0_.limite_at IS NULL OR a0_.limite_at > '2026-03-05 18:10:31') ORDER BY a0_.publication_at DESC LIMIT 3;

SELECT
  COUNT(*)
FROM
  annonce t0
WHERE
  t0.user_id = ?
  AND t0.statut = ?

SELECT COUNT(*) FROM annonce t0 WHERE t0.user_id = 20 AND t0.statut = 'Publié';

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.slug AS slug_5,
  t0.parent_id AS parent_id_6
FROM
  categorie t0
WHERE
  t0.is_active = ?
  AND t0.parent_id IS NULL

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.is_active = 1 AND t0.parent_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.type AS type_3,
  t0.date_ajout AS date_ajout_4,
  t0.taille AS taille_5,
  t0.position AS position_6,
  t0.annonce_id AS annonce_id_7
FROM
  media t0
WHERE
  t0.annonce_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.type AS type_3, t0.date_ajout AS date_ajout_4, t0.taille AS taille_5, t0.position AS position_6, t0.annonce_id AS annonce_id_7 FROM media t0 WHERE t0.annonce_id = 125;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.slug AS slug_5,
  t0.parent_id AS parent_id_6
FROM
  categorie t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.parent_id = 235;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 243;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 244;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 245;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 246;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 247;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 248;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 249;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 250;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 251;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 252;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 253;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 254;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 255;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 256;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.is_active AS is_active_4,
  t0.slug AS slug_5,
  t0.parent_id AS parent_id_6
FROM
  categorie t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.is_active AS is_active_4, t0.slug AS slug_5, t0.parent_id AS parent_id_6 FROM categorie t0 WHERE t0.parent_id = 236;

SELECT
  COUNT(a0_.id) AS sclr_0
FROM
  annonce a0_
  INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id
WHERE
  a0_.statut = ?
  AND c1_.id = ?

SELECT COUNT(a0_.id) AS sclr_0 FROM annonce a0_ INNER JOIN categorie c1_ ON a0_.categorie_id = c1_.id WHERE a0_.statut = 'Publié' AND c1_.id = 257;