Symfony Profiler

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
  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
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.avatar AS avatar_7,
  t0.is_verified AS is_verified_8,
  t0.status AS status_9,
  t0.token AS token_10,
  t0.username AS username_11,
  t0.created_at AS created_at_12,
  t0.type_compte AS type_compte_13,
  t0.a_propos_de_moi AS a_propos_de_moi_14,
  t0.credit AS credit_15,
  t0.note AS note_16,
  t0.is_bloqued AS is_bloqued_17,
  t0.bloqued_until AS bloqued_until_18,
  t0.is_compte_deleted AS is_compte_deleted_19,
  t0.compte_deleted_at AS compte_deleted_at_20,
  t0.new_email AS new_email_21,
  t0.email_change_token AS email_change_token_22,
  t0.email_change_requested_at AS email_change_requested_at_23,
  t0.last_activity_at AS last_activity_at_24,
  t0.api_key AS api_key_25,
  t0.adresse_id AS adresse_id_26,
  t0.compte_supprime_id AS compte_supprime_id_27
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.avatar AS avatar_7, t0.is_verified AS is_verified_8, t0.status AS status_9, t0.token AS token_10, t0.username AS username_11, t0.created_at AS created_at_12, t0.type_compte AS type_compte_13, t0.a_propos_de_moi AS a_propos_de_moi_14, t0.credit AS credit_15, t0.note AS note_16, t0.is_bloqued AS is_bloqued_17, t0.bloqued_until AS bloqued_until_18, t0.is_compte_deleted AS is_compte_deleted_19, t0.compte_deleted_at AS compte_deleted_at_20, t0.new_email AS new_email_21, t0.email_change_token AS email_change_token_22, t0.email_change_requested_at AS email_change_requested_at_23, t0.last_activity_at AS last_activity_at_24, t0.api_key AS api_key_25, t0.adresse_id AS adresse_id_26, t0.compte_supprime_id AS compte_supprime_id_27 FROM user t0 WHERE t0.id = '28';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.label AS label_4
FROM
  options t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.label AS label_4 FROM options t0 WHERE t0.name = 'app_adresse' LIMIT 1;

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
  count(DISTINCT a0_.id) AS sclr_0
FROM
  annonce a0_
WHERE
  a0_.user_id = ?
  AND a0_.statut = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM annonce a0_ WHERE a0_.user_id = 28 AND a0_.statut = 'Publié';

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_.user_id = ?
  AND a0_.statut = ?
  AND a0_.id IN (?)
ORDER BY
  a0_.created_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, 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_.user_id = 28 AND a0_.statut = 'Publié' AND a0_.id IN (131) ORDER BY a0_.created_at DESC;

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

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.user_id AS user_id_3,
  t0.annonce_id AS annonce_id_4
FROM
  favori t0
WHERE
  t0.annonce_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.annonce_id AS annonce_id_4 FROM favori t0 WHERE t0.annonce_id = 131;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.created_at AS created_at_1
FROM
  annonce a0_
WHERE
  a0_.user_id = ?
  AND a0_.statut = ?
ORDER BY
  a0_.created_at DESC
LIMIT
  12

SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM annonce a0_ WHERE a0_.user_id = 28 AND a0_.statut = 'Publié' ORDER BY a0_.created_at DESC LIMIT 12;