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 = '127';

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.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;

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 = 258;

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 = 259;

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 = 260;

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 = 261;

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 = 262;

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 = 263;

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 = ?