Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

49 Database Queries

9 Different statements

104.43 ms Query time

1 Invalid entities

Queries

Group similar statements


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.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 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 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 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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.user_id AS user_id_4, t0.enseigne_id AS enseigne_id_5 FROM notes_enseignes t0 WHERE t0.enseigne_id = ?

#▲	Time	Info
1	2.00 ms	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 Parameters: [`"5bb5657d13e367daa29e412114993385"`] View formatted query View runnable query Explain query 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;
2	0.77 ms	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 Parameters: [`"21914"`] View formatted query View runnable query Explain query 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;
3	53.83 ms	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 Parameters: [`"49.1333" "6.16667" "49.1333" "49.1333" "6.16667" "49.1333" "50"`] View formatted query View runnable query Explain query 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)))) <= '50' ORDER BY sclr_2 ASC;
4	6.28 ms	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 Parameters: ["2025-05-06 08:34:14" "2025-05-06 08:34:14" 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 22199 21748 21752 22197 21899 22352 22306 21803 22356 22175 22216 22066 22347 22013 22337 21696 21652 21689 22363 21838 22085 22079 22248 22166 22093 21948 22234 22211 22072 21745 21963 22182 21819 22349 21856 21811 20617 22308 21927 22331 21720 21871 22323 22198 22289 21964 21823 22307 22059 21821 21812 22336 20404 22271 21945 21897 20300 22004 22297 21777 21953 21962 20714 21869 20430 22097 20799 21932 21787 21909 21933 21840 21930 22265 21908 22009 21790 20648 22137 21658 20858 22074 20335 20460 22351 21918 20307 20576 22324 22273 22376 21693 20619 22286 22257 22002 21822 20766 21692 22228 22276 21968 21820 20828 22239 21741 20813 20638 20612 20869 21984 20831 21805 22252 20853 21771 20506 22037 21765 20511 20441 20698 22035 22329 20509 21814 21987 20755 22237 20782 21809 21718 22095 22309 21785 21697 20360 20702 20491 22098 22345 20794 21699 21955 20764 20425 22003 21877 22330 22223 22186 21766 22290 20508 20854 22189 20448 22036 22134 22132 20590 22372 20759 20655 22169 22123 20700 22319 20737 20543 22017 22000 22222 20447 22041 21957 20826 20624 22086 20345 22325 20681 21760 21779 21806 20317 20420 22281 20455 21808 22298 22366 20717 20677 21751 22284 21715 22129 20723 22200 20784 21946 20510 21870 22354 22226 20370 22084 20845 22115 20488 20559 21935 21758 20505 22016 22039 20558 22373 21684 21875 20435 20438 20980 20816 22326 20588 20485 20413 20653 22026 22374 21995 20842 20823 20672 20724 21971 21788 20524 21847 20801 21283 20728 22219 22011 22001 21943 21816 22087 22291 21679 21993 22218 21972 21775 21857 20824 20851 20349 20466 22195 22235 20586 21035 21862 21695 22089 20749 20359 21824 20369 21710 22335 22295 21990 20708 22103 22266 21117 22256 20426 21885 20697 22114 21938 20644 20548 22225 21941 22117 20531 22210 22158 20412 20501 20499 22241 22261 20613 21937 22005 20594 22300 21931 22201 20666 21992 21999 21991 22292 20295 20852 21737 21965 21063 20538 21690 21776 22301 21675 20398 20683 22375 21861 21889 22334 21151 21267 20355 21815 22032 20305 22287 21740 21087 20901 20955 20315 21712 20537 20351 21913 21746 21810 20520 21735 20434 22333 21049 21817 21781 20454 22245 21851 21757 21922 21954 21672 21750 20769 20740 21016 21842 20550 20647 22106 21884 21651 21711 20876 22170 20745 22065 21997 20555 22088 20960 20519 20540 21060 22058 20364 21012 22328 21768 20767 22357 21706 22361 21900 20514 22254 21734 22168 22317 22180 21103 22152 22076 20461 22232 21791 22176 21233 22070 20301 21176 22204 21747 22188 20486 20367 21707 22320 20725 21967 20786 20743 20830 21786 21802 21688 20468 20294 21784 20894 22190 20756 20811 22253 22133 22151 21881 20884 20395 20596 21825 21344 22078 22359 22143 20643 20711 22322 21126 22071 21723 20411 22315 21876 22063 22206 21731 20716 21123 22077 21118 21866 22101 22052 21081 21887 20542 21956 22127 21130 22138 21026 22064 21663 22369 20631 20477 21359 20872 20600 21850 20418 22029 21713 20532 20825 21782 21762 22049 22353 21961 21342 22069 20839 20445 22018 22358 22042 21650 20527 22259 20536 21346 20849 20557 21833 21085 21893 20923 20797 21099 20754 21668 20855 22083 21767 21061 20297 22346 21286 22318 22260 21384 22365 22081 21004 21792 22205 22340 20622 20636 22341 20741 22144 20578 22367 20688 22313 22316 21015 21907 20325 20363 22174 21780 21744 21250 21357 21217 20329 21732 20892 21010 22104 21705 21296 20402 22296 21068 21009 21818 22155 20959 20474 22033 20652 20602 20496 21872 20669 20533 22213 20761 21795 21800 21714 21042 21864 20385 21794 21936 21880 20598 21681 21315 21983 21100 20670 21703 20640 21902 21994 21378 20963 21915 20605 21647 20343 20844 22194 20503 21006 20444 20358 21161 21311 20630 21241 20525 21343 20437 20333 21882 22145 20957 21669 20706 22355 21385 20482 21951 21727 21199 21978 22267 22278 20553 21219 20476 20847 22371 21277 21940 21906 20916 21322 21721 21939 22022 21831 21244 21142 22285 20459 20449 20729 20427 21152 20881 20739 22280 20374 20308 22258 20322 20549 20534 22094 20993 21308 21154 20639 20860 21769 21268 21048 21291 20710 22128 22246 20932 22055 20585 20679 21292 22149 20934 20805 21313 21033 20829 21878 21275 22283 22140 21859 21192 20563 21197 22156 21079 22044 20642 20793 20495 21122 20379 20498 20316 21208 20423 22014 20995 21996 21827 20791 22230 20902 22050 20603 20311 20365 21858 22090 22111 21200 21243 20361 20773 20838 20324 20983 21666 21256 21361 20880 22067 21165 21330 21264 20645 20975 20546 20632 20790 22173 22053 22207 22025 22212 20387 21066 21729 20953 22179 21976 21193 20832 21682 20522 20634 20521 20348 21905 21846 21722 22203 22269 22171 22051 0] View formatted query View runnable query Explain query 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:34:14' AND a0_.date_fin >= '2025-05-06 08:34:14' 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, 22199, 21748, 21752, 22197, 21899, 22352, 22306, 21803, 22356, 22175, 22216, 22066, 22347, 22013, 22337, 21696, 21652, 21689, 22363, 21838, 22085, 22079, 22248, 22166, 22093, 21948, 22234, 22211, 22072, 21745, 21963, 22182, 21819, 22349, 21856, 21811, 20617, 22308, 21927, 22331, 21720, 21871, 22323, 22198, 22289, 21964, 21823, 22307, 22059, 21821, 21812, 22336, 20404, 22271, 21945, 21897, 20300, 22004, 22297, 21777, 21953, 21962, 20714, 21869, 20430, 22097, 20799, 21932, 21787, 21909, 21933, 21840, 21930, 22265, 21908, 22009, 21790, 20648, 22137, 21658, 20858, 22074, 20335, 20460, 22351, 21918, 20307, 20576, 22324, 22273, 22376, 21693, 20619, 22286, 22257, 22002, 21822, 20766, 21692, 22228, 22276, 21968, 21820, 20828, 22239, 21741, 20813, 20638, 20612, 20869, 21984, 20831, 21805, 22252, 20853, 21771, 20506, 22037, 21765, 20511, 20441, 20698, 22035, 22329, 20509, 21814, 21987, 20755, 22237, 20782, 21809, 21718, 22095, 22309, 21785, 21697, 20360, 20702, 20491, 22098, 22345, 20794, 21699, 21955, 20764, 20425, 22003, 21877, 22330, 22223, 22186, 21766, 22290, 20508, 20854, 22189, 20448, 22036, 22134, 22132, 20590, 22372, 20759, 20655, 22169, 22123, 20700, 22319, 20737, 20543, 22017, 22000, 22222, 20447, 22041, 21957, 20826, 20624, 22086, 20345, 22325, 20681, 21760, 21779, 21806, 20317, 20420, 22281, 20455, 21808, 22298, 22366, 20717, 20677, 21751, 22284, 21715, 22129, 20723, 22200, 20784, 21946, 20510, 21870, 22354, 22226, 20370, 22084, 20845, 22115, 20488, 20559, 21935, 21758, 20505, 22016, 22039, 20558, 22373, 21684, 21875, 20435, 20438, 20980, 20816, 22326, 20588, 20485, 20413, 20653, 22026, 22374, 21995, 20842, 20823, 20672, 20724, 21971, 21788, 20524, 21847, 20801, 21283, 20728, 22219, 22011, 22001, 21943, 21816, 22087, 22291, 21679, 21993, 22218, 21972, 21775, 21857, 20824, 20851, 20349, 20466, 22195, 22235, 20586, 21035, 21862, 21695, 22089, 20749, 20359, 21824, 20369, 21710, 22335, 22295, 21990, 20708, 22103, 22266, 21117, 22256, 20426, 21885, 20697, 22114, 21938, 20644, 20548, 22225, 21941, 22117, 20531, 22210, 22158, 20412, 20501, 20499, 22241, 22261, 20613, 21937, 22005, 20594, 22300, 21931, 22201, 20666, 21992, 21999, 21991, 22292, 20295, 20852, 21737, 21965, 21063, 20538, 21690, 21776, 22301, 21675, 20398, 20683, 22375, 21861, 21889, 22334, 21151, 21267, 20355, 21815, 22032, 20305, 22287, 21740, 21087, 20901, 20955, 20315, 21712, 20537, 20351, 21913, 21746, 21810, 20520, 21735, 20434, 22333, 21049, 21817, 21781, 20454, 22245, 21851, 21757, 21922, 21954, 21672, 21750, 20769, 20740, 21016, 21842, 20550, 20647, 22106, 21884, 21651, 21711, 20876, 22170, 20745, 22065, 21997, 20555, 22088, 20960, 20519, 20540, 21060, 22058, 20364, 21012, 22328, 21768, 20767, 22357, 21706, 22361, 21900, 20514, 22254, 21734, 22168, 22317, 22180, 21103, 22152, 22076, 20461, 22232, 21791, 22176, 21233, 22070, 20301, 21176, 22204, 21747, 22188, 20486, 20367, 21707, 22320, 20725, 21967, 20786, 20743, 20830, 21786, 21802, 21688, 20468, 20294, 21784, 20894, 22190, 20756, 20811, 22253, 22133, 22151, 21881, 20884, 20395, 20596, 21825, 21344, 22078, 22359, 22143, 20643, 20711, 22322, 21126, 22071, 21723, 20411, 22315, 21876, 22063, 22206, 21731, 20716, 21123, 22077, 21118, 21866, 22101, 22052, 21081, 21887, 20542, 21956, 22127, 21130, 22138, 21026, 22064, 21663, 22369, 20631, 20477, 21359, 20872, 20600, 21850, 20418, 22029, 21713, 20532, 20825, 21782, 21762, 22049, 22353, 21961, 21342, 22069, 20839, 20445, 22018, 22358, 22042, 21650, 20527, 22259, 20536, 21346, 20849, 20557, 21833, 21085, 21893, 20923, 20797, 21099, 20754, 21668, 20855, 22083, 21767, 21061, 20297, 22346, 21286, 22318, 22260, 21384, 22365, 22081, 21004, 21792, 22205, 22340, 20622, 20636, 22341, 20741, 22144, 20578, 22367, 20688, 22313, 22316, 21015, 21907, 20325, 20363, 22174, 21780, 21744, 21250, 21357, 21217, 20329, 21732, 20892, 21010, 22104, 21705, 21296, 20402, 22296, 21068, 21009, 21818, 22155, 20959, 20474, 22033, 20652, 20602, 20496, 21872, 20669, 20533, 22213, 20761, 21795, 21800, 21714, 21042, 21864, 20385, 21794, 21936, 21880, 20598, 21681, 21315, 21983, 21100, 20670, 21703, 20640, 21902, 21994, 21378, 20963, 21915, 20605, 21647, 20343, 20844, 22194, 20503, 21006, 20444, 20358, 21161, 21311, 20630, 21241, 20525, 21343, 20437, 20333, 21882, 22145, 20957, 21669, 20706, 22355, 21385, 20482, 21951, 21727, 21199, 21978, 22267, 22278, 20553, 21219, 20476, 20847, 22371, 21277, 21940, 21906, 20916, 21322, 21721, 21939, 22022, 21831, 21244, 21142, 22285, 20459, 20449, 20729, 20427, 21152, 20881, 20739, 22280, 20374, 20308, 22258, 20322, 20549, 20534, 22094, 20993, 21308, 21154, 20639, 20860, 21769, 21268, 21048, 21291, 20710, 22128, 22246, 20932, 22055, 20585, 20679, 21292, 22149, 20934, 20805, 21313, 21033, 20829, 21878, 21275, 22283, 22140, 21859, 21192, 20563, 21197, 22156, 21079, 22044, 20642, 20793, 20495, 21122, 20379, 20498, 20316, 21208, 20423, 22014, 20995, 21996, 21827, 20791, 22230, 20902, 22050, 20603, 20311, 20365, 21858, 22090, 22111, 21200, 21243, 20361, 20773, 20838, 20324, 20983, 21666, 21256, 21361, 20880, 22067, 21165, 21330, 21264, 20645, 20975, 20546, 20632, 20790, 22173, 22053, 22207, 22025, 22212, 20387, 21066, 21729, 20953, 22179, 21976, 21193, 20832, 21682, 20522, 20634, 20521, 20348, 21905, 21846, 21722, 22203, 22269, 22171, 22051) AND a0_.visible_pro = 0 ORDER BY a0_.booster DESC, a0_.prix ASC;
5	0.52 ms	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 Parameters: [`142 33`] View formatted query View runnable query Explain query 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 = 142 AND t0.user_id = 33 LIMIT 1;
6	2.17 ms	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 = ? Parameters: [`38`] View formatted query View runnable query Explain query 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 = 38;
7	0.26 ms	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 = ? Parameters: [`142`] View formatted query View runnable query Explain query 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 = 142;
8	1.69 ms	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 = ? Parameters: [`142`] View formatted query View runnable query Explain query 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 = 142;
9	0.40 ms	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 = ? Parameters: [`38`] View formatted query View runnable query Explain query 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 = 38;
10	0.34 ms	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 Parameters: [`145 33`] View formatted query View runnable query Explain query 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 = 145 AND t0.user_id = 33 LIMIT 1;
11	0.33 ms	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 = ? Parameters: [`145`] View formatted query View runnable query Explain query 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 = 145;
12	0.34 ms	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 = ? Parameters: [`145`] View formatted query View runnable query Explain query 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 = 145;
13	0.32 ms	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 = ? Parameters: [`38`] View formatted query View runnable query Explain query 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 = 38;
14	0.32 ms	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 Parameters: [`147 33`] View formatted query View runnable query Explain query 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 = 147 AND t0.user_id = 33 LIMIT 1;
15	0.24 ms	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 = ? Parameters: [`147`] View formatted query View runnable query Explain query 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 = 147;
16	0.32 ms	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 = ? Parameters: [`147`] View formatted query View runnable query Explain query 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 = 147;
17	19.95 ms	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 = ? Parameters: [`38`] View formatted query View runnable query Explain query 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 = 38;
18	0.48 ms	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 Parameters: [`146 33`] View formatted query View runnable query Explain query 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 = 146 AND t0.user_id = 33 LIMIT 1;
19	0.39 ms	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 = ? Parameters: [`146`] View formatted query View runnable query Explain query 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 = 146;
20	0.35 ms	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 = ? Parameters: [`146`] View formatted query View runnable query Explain query 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 = 146;
21	0.34 ms	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 = ? Parameters: [`38`] View formatted query View runnable query Explain query 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 = 38;
22	0.34 ms	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 Parameters: [`9 33`] View formatted query View runnable query Explain query 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;
23	0.31 ms	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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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;
24	0.32 ms	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 = ? Parameters: [`9`] View formatted query View runnable query Explain query 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;
25	0.26 ms	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 = ? Parameters: [`9`] View formatted query View runnable query Explain query 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;
26	0.39 ms	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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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;
27	0.34 ms	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 Parameters: [`7 33`] View formatted query View runnable query Explain query 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 = 7 AND t0.user_id = 33 LIMIT 1;
28	0.35 ms	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 = ? Parameters: [`5`] View formatted query View runnable query Explain query 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;
29	0.33 ms	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 = ? Parameters: [`7`] View formatted query View runnable query Explain query 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 = 7;
30	0.33 ms	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 = ? Parameters: [`7`] View formatted query View runnable query Explain query 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 = 7;
31	1.08 ms	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 = ? Parameters: [`5`] View formatted query View runnable query Explain query 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;
32	0.37 ms	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 Parameters: [`8 33`] View formatted query View runnable query Explain query 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;
33	0.32 ms	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 = ? Parameters: [`8`] View formatted query View runnable query Explain query 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;
34	0.82 ms	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 = ? Parameters: [`8`] View formatted query View runnable query Explain query 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;
35	0.41 ms	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 = ? Parameters: [`5`] View formatted query View runnable query Explain query 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;
36	0.74 ms	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 Parameters: [`2 33`] View formatted query View runnable query Explain query 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;
37	0.24 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
38	0.57 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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;
39	0.35 ms	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 = ? Parameters: [`2`] View formatted query View runnable query Explain query 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;
40	2.46 ms	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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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;
41	0.38 ms	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 Parameters: [`4 33`] View formatted query View runnable query Explain query 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 = 4 AND t0.user_id = 33 LIMIT 1;
42	0.23 ms	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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
43	0.34 ms	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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
44	0.28 ms	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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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;
45	0.20 ms	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 Parameters: [`25 33`] View formatted query View runnable query Explain query 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 = 25 AND t0.user_id = 33 LIMIT 1;
46	0.32 ms	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 = ? Parameters: [`30`] View formatted query View runnable query Explain query 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 = 30;
47	0.28 ms	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 = ? Parameters: [`25`] View formatted query View runnable query Explain query 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 = 25;
48	0.22 ms	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 = ? Parameters: [`25`] View formatted query View runnable query Explain query 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 = 25;
49	0.22 ms	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 = ? Parameters: [`30`] View formatted query View runnable query Explain query 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 = 30;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Favoris	No errors.
App\Entity\User	No errors.
App\Entity\Villes	No errors.
App\Entity\Categories	No errors.
App\Entity\Annonces	No errors.
App\Entity\NotesEnseignes	The mappings App\Entity\NotesEnseignes#Enseigne and App\Entity\User#notesEnseignes are inconsistent with each other.
App\Entity\Pays	No errors.
App\Entity\NotesAnnonces	No errors.
App\Entity\Alertes	No errors.
App\Entity\Commandes	No errors.
App\Entity\Factures	No errors.
App\Entity\Departements	No errors.
App\Entity\Images	No errors.

Symfony Profiler

https://modixom.fr/api/searchAnnonces?p=api%2FsearchAnnonces&pro=false&rayon=50&token=5bb5657d13e367daa29e412114993385&tri=ASC&ville=21914

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping