Symfony Profiler

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  annonce a0_
  LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id
  LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  a0_.statut = ?
  AND (
    (
      c1_.slug = ?
      OR c2_.slug = ?
    )
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = 'Publié' AND ((c1_.slug = 'Ordinateurs' OR c2_.slug = 'Ordinateurs'));

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.publication_at AS publication_at_1
FROM
  annonce a0_
  LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id
  LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  a0_.statut = ?
  AND (
    (
      c1_.slug = ?
      OR c2_.slug = ?
    )
  )
ORDER BY
  a0_.publication_at DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.publication_at AS publication_at_1 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = 'Publié' AND ((c1_.slug = 'Ordinateurs' OR c2_.slug = 'Ordinateurs')) ORDER BY a0_.publication_at DESC LIMIT 12;

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,
  c1_.id AS id_25,
  c1_.nom AS nom_26,
  c1_.description AS description_27,
  c1_.is_active AS is_active_28,
  c1_.slug AS slug_29,
  c2_.id AS id_30,
  c2_.nom AS nom_31,
  c2_.description AS description_32,
  c2_.is_active AS is_active_33,
  c2_.slug AS slug_34,
  a0_.user_id AS user_id_35,
  a0_.categorie_id AS categorie_id_36,
  a0_.supprime_paradmin_id AS supprime_paradmin_id_37,
  c1_.parent_id AS parent_id_38,
  c2_.parent_id AS parent_id_39
FROM
  annonce a0_
  LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id
  LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id
WHERE
  a0_.statut = ?
  AND (
    (
      c1_.slug = ?
      OR c2_.slug = ?
    )
  )
  AND a0_.id IN (?)
ORDER BY
  a0_.publication_at DESC

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, c1_.id AS id_25, c1_.nom AS nom_26, c1_.description AS description_27, c1_.is_active AS is_active_28, c1_.slug AS slug_29, c2_.id AS id_30, c2_.nom AS nom_31, c2_.description AS description_32, c2_.is_active AS is_active_33, c2_.slug AS slug_34, a0_.user_id AS user_id_35, a0_.categorie_id AS categorie_id_36, a0_.supprime_paradmin_id AS supprime_paradmin_id_37, c1_.parent_id AS parent_id_38, c2_.parent_id AS parent_id_39 FROM annonce a0_ LEFT JOIN categorie c1_ ON a0_.categorie_id = c1_.id LEFT JOIN categorie c2_ ON c1_.parent_id = c2_.id WHERE a0_.statut = 'Publié' AND ((c1_.slug = 'Ordinateurs' OR c2_.slug = 'Ordinateurs')) AND a0_.id IN (136) ORDER BY a0_.publication_at DESC;

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