Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civilite AS civilite_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.raison_sociale AS raison_sociale_8,
  t0.siret AS siret_9,
  t0.tva AS tva_10,
  t0.adresse AS adresse_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.logo AS logo_14,
  t0.type AS type_15,
  t0.actif AS actif_16,
  t0.credits AS credits_17,
  t0.created AS created_18,
  t0.token_mobile AS token_mobile_19,
  t0.villes_id AS villes_id_20,
  t0.pays_id AS pays_id_21
FROM
  user t0
WHERE
  t0.token_mobile = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.civilite AS civilite_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.raison_sociale AS raison_sociale_8, t0.siret AS siret_9, t0.tva AS tva_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.logo AS logo_14, t0.type AS type_15, t0.actif AS actif_16, t0.credits AS credits_17, t0.created AS created_18, t0.token_mobile AS token_mobile_19, t0.villes_id AS villes_id_20, t0.pays_id AS pays_id_21 FROM user t0 WHERE t0.token_mobile = '5bb5657d13e367daa29e412114993385' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ville_nom_reel AS ville_nom_reel_2,
  t0.ville_nom AS ville_nom_3,
  t0.ville_code_postal AS ville_code_postal_4,
  t0.ville_longitude_deg AS ville_longitude_deg_5,
  t0.ville_latitude_deg AS ville_latitude_deg_6,
  t0.ville_slug AS ville_slug_7,
  t0.departements_id AS departements_id_8
FROM
  villes t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ville_nom_reel AS ville_nom_reel_2, t0.ville_nom AS ville_nom_3, t0.ville_code_postal AS ville_code_postal_4, t0.ville_longitude_deg AS ville_longitude_deg_5, t0.ville_latitude_deg AS ville_latitude_deg_6, t0.ville_slug AS ville_slug_7, t0.departements_id AS departements_id_8 FROM villes t0 WHERE t0.id = '21914' LIMIT 1;

SELECT
  v0_.id AS id_0,
  v0_.ville_nom AS ville_nom_1,
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(v0_.ville_latitude_deg)
      ) * COS(
        RADIANS(v0_.ville_longitude_deg) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(v0_.ville_latitude_deg)
      )
    )
  ) AS sclr_2
FROM
  villes v0_
WHERE
  (
    6371 * ACOS(
      COS(
        RADIANS(?)
      ) * COS(
        RADIANS(v0_.ville_latitude_deg)
      ) * COS(
        RADIANS(v0_.ville_longitude_deg) - RADIANS(?)
      ) + SIN(
        RADIANS(?)
      ) * SIN(
        RADIANS(v0_.ville_latitude_deg)
      )
    )
  ) <= ?
ORDER BY
  sclr_2 ASC

SELECT v0_.id AS id_0, v0_.ville_nom AS ville_nom_1, (6371 * ACOS(COS(RADIANS('49.1333')) * COS(RADIANS(v0_.ville_latitude_deg)) * COS(RADIANS(v0_.ville_longitude_deg) - RADIANS('6.16667')) + SIN(RADIANS('49.1333')) * SIN(RADIANS(v0_.ville_latitude_deg)))) AS sclr_2 FROM villes v0_ WHERE (6371 * ACOS(COS(RADIANS('49.1333')) * COS(RADIANS(v0_.ville_latitude_deg)) * COS(RADIANS(v0_.ville_longitude_deg) - RADIANS('6.16667')) + SIN(RADIANS('49.1333')) * SIN(RADIANS(v0_.ville_latitude_deg)))) <= '10' ORDER BY sclr_2 ASC;

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.prix AS prix_2,
  a0_.description AS description_3,
  a0_.pourcent_remise AS pourcent_remise_4,
  a0_.date_debut AS date_debut_5,
  a0_.date_fin AS date_fin_6,
  a0_.quantite AS quantite_7,
  a0_.visible_pro AS visible_pro_8,
  a0_.booster AS booster_9,
  a0_.nb_vues AS nb_vues_10,
  a0_.image AS image_11,
  a0_.categories_id AS categories_id_12,
  a0_.user_id AS user_id_13,
  a0_.villes_id AS villes_id_14
FROM
  annonces a0_
  LEFT JOIN user u1_ ON a0_.user_id = u1_.id
WHERE
  a0_.date_debut <= ?
  AND a0_.date_fin >= ?
  AND a0_.villes_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )
  AND a0_.visible_pro = ?
ORDER BY
  a0_.booster DESC,
  a0_.prix ASC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.prix AS prix_2, a0_.description AS description_3, a0_.pourcent_remise AS pourcent_remise_4, a0_.date_debut AS date_debut_5, a0_.date_fin AS date_fin_6, a0_.quantite AS quantite_7, a0_.visible_pro AS visible_pro_8, a0_.booster AS booster_9, a0_.nb_vues AS nb_vues_10, a0_.image AS image_11, a0_.categories_id AS categories_id_12, a0_.user_id AS user_id_13, a0_.villes_id AS villes_id_14 FROM annonces a0_ LEFT JOIN user u1_ ON a0_.user_id = u1_.id WHERE a0_.date_debut <= '2025-05-06 08:24:42' AND a0_.date_fin >= '2025-05-06 08:24:42' AND a0_.villes_id IN (21914, 21804, 21843, 22362, 22048, 22344, 22236, 22343, 22038, 21853, 21910, 21736, 21980, 22139, 22302, 21849, 21860, 22136, 21835, 21898, 22360, 22161, 21829, 21895, 21797, 21828, 22122, 21888, 21981, 22348, 21716, 21694, 22146, 21836, 21926, 22121, 21837, 21916, 21986, 22061, 21929, 21698, 22148, 21894, 21949, 21793, 21839, 22231, 21708) AND a0_.visible_pro = 0 ORDER BY a0_.booster DESC, a0_.prix ASC;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.annonces_id AS annonces_id_3,
  t0.user_id AS user_id_4
FROM
  favoris t0
WHERE
  t0.annonces_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.annonces_id AS annonces_id_3, t0.user_id AS user_id_4 FROM favoris t0 WHERE t0.annonces_id = 9 AND t0.user_id = 33 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civilite AS civilite_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.raison_sociale AS raison_sociale_8,
  t0.siret AS siret_9,
  t0.tva AS tva_10,
  t0.adresse AS adresse_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.logo AS logo_14,
  t0.type AS type_15,
  t0.actif AS actif_16,
  t0.credits AS credits_17,
  t0.created AS created_18,
  t0.token_mobile AS token_mobile_19,
  t0.villes_id AS villes_id_20,
  t0.pays_id AS pays_id_21
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.civilite AS civilite_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.raison_sociale AS raison_sociale_8, t0.siret AS siret_9, t0.tva AS tva_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.logo AS logo_14, t0.type AS type_15, t0.actif AS actif_16, t0.credits AS credits_17, t0.created AS created_18, t0.token_mobile AS token_mobile_19, t0.villes_id AS villes_id_20, t0.pays_id AS pays_id_21 FROM user t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.annonces_id AS annonces_id_3
FROM
  images t0
WHERE
  t0.annonces_id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.annonces_id AS annonces_id_3 FROM images t0 WHERE t0.annonces_id = 9;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.note AS note_3,
  t0.annonces_id AS annonces_id_4,
  t0.user_id AS user_id_5
FROM
  notes_annonces t0
WHERE
  t0.annonces_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.note AS note_3, t0.annonces_id AS annonces_id_4, t0.user_id AS user_id_5 FROM notes_annonces t0 WHERE t0.annonces_id = 9;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.note AS note_3,
  t0.user_id AS user_id_4,
  t0.enseigne_id AS enseigne_id_5
FROM
  notes_enseignes t0
WHERE
  t0.enseigne_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.note AS note_3, t0.user_id AS user_id_4, t0.enseigne_id AS enseigne_id_5 FROM notes_enseignes t0 WHERE t0.enseigne_id = 3;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.annonces_id AS annonces_id_3,
  t0.user_id AS user_id_4
FROM
  favoris t0
WHERE
  t0.annonces_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.annonces_id AS annonces_id_3, t0.user_id AS user_id_4 FROM favoris t0 WHERE t0.annonces_id = 8 AND t0.user_id = 33 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civilite AS civilite_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.raison_sociale AS raison_sociale_8,
  t0.siret AS siret_9,
  t0.tva AS tva_10,
  t0.adresse AS adresse_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.logo AS logo_14,
  t0.type AS type_15,
  t0.actif AS actif_16,
  t0.credits AS credits_17,
  t0.created AS created_18,
  t0.token_mobile AS token_mobile_19,
  t0.villes_id AS villes_id_20,
  t0.pays_id AS pays_id_21
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.civilite AS civilite_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.raison_sociale AS raison_sociale_8, t0.siret AS siret_9, t0.tva AS tva_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.logo AS logo_14, t0.type AS type_15, t0.actif AS actif_16, t0.credits AS credits_17, t0.created AS created_18, t0.token_mobile AS token_mobile_19, t0.villes_id AS villes_id_20, t0.pays_id AS pays_id_21 FROM user t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.annonces_id AS annonces_id_3
FROM
  images t0
WHERE
  t0.annonces_id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.annonces_id AS annonces_id_3 FROM images t0 WHERE t0.annonces_id = 8;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.note AS note_3,
  t0.annonces_id AS annonces_id_4,
  t0.user_id AS user_id_5
FROM
  notes_annonces t0
WHERE
  t0.annonces_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.note AS note_3, t0.annonces_id AS annonces_id_4, t0.user_id AS user_id_5 FROM notes_annonces t0 WHERE t0.annonces_id = 8;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.note AS note_3,
  t0.user_id AS user_id_4,
  t0.enseigne_id AS enseigne_id_5
FROM
  notes_enseignes t0
WHERE
  t0.enseigne_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.note AS note_3, t0.user_id AS user_id_4, t0.enseigne_id AS enseigne_id_5 FROM notes_enseignes t0 WHERE t0.enseigne_id = 5;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.annonces_id AS annonces_id_3,
  t0.user_id AS user_id_4
FROM
  favoris t0
WHERE
  t0.annonces_id = ?
  AND t0.user_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.annonces_id AS annonces_id_3, t0.user_id AS user_id_4 FROM favoris t0 WHERE t0.annonces_id = 2 AND t0.user_id = 33 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.civilite AS civilite_5,
  t0.nom AS nom_6,
  t0.prenom AS prenom_7,
  t0.raison_sociale AS raison_sociale_8,
  t0.siret AS siret_9,
  t0.tva AS tva_10,
  t0.adresse AS adresse_11,
  t0.code_postal AS code_postal_12,
  t0.telephone AS telephone_13,
  t0.logo AS logo_14,
  t0.type AS type_15,
  t0.actif AS actif_16,
  t0.credits AS credits_17,
  t0.created AS created_18,
  t0.token_mobile AS token_mobile_19,
  t0.villes_id AS villes_id_20,
  t0.pays_id AS pays_id_21
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.civilite AS civilite_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.raison_sociale AS raison_sociale_8, t0.siret AS siret_9, t0.tva AS tva_10, t0.adresse AS adresse_11, t0.code_postal AS code_postal_12, t0.telephone AS telephone_13, t0.logo AS logo_14, t0.type AS type_15, t0.actif AS actif_16, t0.credits AS credits_17, t0.created AS created_18, t0.token_mobile AS token_mobile_19, t0.villes_id AS villes_id_20, t0.pays_id AS pays_id_21 FROM user t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.annonces_id AS annonces_id_3
FROM
  images t0
WHERE
  t0.annonces_id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.annonces_id AS annonces_id_3 FROM images t0 WHERE t0.annonces_id = 2;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.note AS note_3,
  t0.annonces_id AS annonces_id_4,
  t0.user_id AS user_id_5
FROM
  notes_annonces t0
WHERE
  t0.annonces_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.note AS note_3, t0.annonces_id AS annonces_id_4, t0.user_id AS user_id_5 FROM notes_annonces t0 WHERE t0.annonces_id = 2;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.note AS note_3,
  t0.user_id AS user_id_4,
  t0.enseigne_id AS enseigne_id_5
FROM
  notes_enseignes t0
WHERE
  t0.enseigne_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.note AS note_3, t0.user_id AS user_id_4, t0.enseigne_id AS enseigne_id_5 FROM notes_enseignes t0 WHERE t0.enseigne_id = 1;