Symfony Profiler

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

Method: GET
HTTP Status: 200
IP: 109.29.161.22
Profiled on: Tue, 06 May 2025 08:31:47 +0000
Token: e3507e

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

4 Different statements

64.81 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
59.10 ms (91.19%)	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 Parameters: [`"43.6" "3.88333" "43.6" "43.6" "3.88333" "43.6" "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('43.6')) * COS(RADIANS(v0_.ville_latitude_deg)) * COS(RADIANS(v0_.ville_longitude_deg) - RADIANS('3.88333')) + SIN(RADIANS('43.6')) * SIN(RADIANS(v0_.ville_latitude_deg)))) AS sclr_2 FROM villes v0_ WHERE (6371 * ACOS(COS(RADIANS('43.6')) * COS(RADIANS(v0_.ville_latitude_deg)) * COS(RADIANS(v0_.ville_longitude_deg) - RADIANS('3.88333')) + SIN(RADIANS('43.6')) * SIN(RADIANS(v0_.ville_latitude_deg)))) <= '50' ORDER BY sclr_2 ASC;
3.17 ms (4.89%)	1	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:31:47" "2025-05-06 08:31:47" 13339 13121 13174 13251 13311 13277 13111 13338 13399 13225 13276 13184 13347 13157 13186 13449 13352 13319 13439 13272 13367 13109 13125 13332 13382 13438 13146 13263 13293 13418 13142 13126 13395 13314 13416 13343 13318 13363 13301 13202 13423 13215 13353 13345 13297 13219 13309 13294 13375 13290 13441 13374 13440 13163 13159 13151 13445 13193 13333 13390 13380 13255 13329 13366 13296 13245 13335 13414 13305 13406 13144 13150 13269 13302 13405 13213 11162 13364 13154 13307 13451 13119 13155 13340 13331 13138 13139 13137 13436 13326 13346 13165 11197 13437 13143 13136 13284 11253 13212 13178 11273 13356 13303 11449 11352 13118 13169 11418 11168 13288 11482 11480 11330 11192 13362 13289 11269 13231 13239 11486 13394 11481 11244 13341 13110 13431 11354 11208 11295 11422 13425 13359 11417 11182 11440 11425 13355 13261 13226 13233 11341 13221 13378 13373 13128 13192 13424 11450 11183 13133 13392 11175 13248 13236 13243 11442 13420 13312 11497 11229 13158 13266 11212 11363 11452 11214 13129 13325 11200 13404 13327 13411 13342 11267 11322 11314 13122 11415 13324 13280 11180 11302 13223 11202 13257 13283 13426 13428 13371 11191 13396 13419 13235 11506 13271 13258 11263 11297 13265 11188 13310 13145 13130 11247 13196 13222 11305 11187 13443 13389 11300 13400 11318 11299 13292 11373 11304 13336 11477 11401 13127 11186 13337 11242 13152 11460 13252 11471 11513 13383 11199 13135 13328 13386 13285 11378 11173 13171 13227 11426 11216 13409 13166 11388 13134 11282 13354 11337 13408 11207 13369 11230 13259 13190 13240 11478 11407 11483 13334 11421 11346 13140 11343 11368 11280 11495 11325 13191 11499 11296 11321 11326 13131 11336 13208 11420 13117 11361 13316 11287 13201 11372 13148 11222 11431 13120 11473 4500 11462 11166 11285 13376 13124 11405 11239 13153 13361 13401 11502 11283 13230 13264 13275 11266 11429 11215 13173 13250 11384 11416 11310 11316 13217 11403 11315 11276 13200 11312 11375 11231 11476 11507 11427 11221 13444 13446 13434 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:31:47' AND a0_.date_fin >= '2025-05-06 08:31:47' AND a0_.villes_id IN (13339, 13121, 13174, 13251, 13311, 13277, 13111, 13338, 13399, 13225, 13276, 13184, 13347, 13157, 13186, 13449, 13352, 13319, 13439, 13272, 13367, 13109, 13125, 13332, 13382, 13438, 13146, 13263, 13293, 13418, 13142, 13126, 13395, 13314, 13416, 13343, 13318, 13363, 13301, 13202, 13423, 13215, 13353, 13345, 13297, 13219, 13309, 13294, 13375, 13290, 13441, 13374, 13440, 13163, 13159, 13151, 13445, 13193, 13333, 13390, 13380, 13255, 13329, 13366, 13296, 13245, 13335, 13414, 13305, 13406, 13144, 13150, 13269, 13302, 13405, 13213, 11162, 13364, 13154, 13307, 13451, 13119, 13155, 13340, 13331, 13138, 13139, 13137, 13436, 13326, 13346, 13165, 11197, 13437, 13143, 13136, 13284, 11253, 13212, 13178, 11273, 13356, 13303, 11449, 11352, 13118, 13169, 11418, 11168, 13288, 11482, 11480, 11330, 11192, 13362, 13289, 11269, 13231, 13239, 11486, 13394, 11481, 11244, 13341, 13110, 13431, 11354, 11208, 11295, 11422, 13425, 13359, 11417, 11182, 11440, 11425, 13355, 13261, 13226, 13233, 11341, 13221, 13378, 13373, 13128, 13192, 13424, 11450, 11183, 13133, 13392, 11175, 13248, 13236, 13243, 11442, 13420, 13312, 11497, 11229, 13158, 13266, 11212, 11363, 11452, 11214, 13129, 13325, 11200, 13404, 13327, 13411, 13342, 11267, 11322, 11314, 13122, 11415, 13324, 13280, 11180, 11302, 13223, 11202, 13257, 13283, 13426, 13428, 13371, 11191, 13396, 13419, 13235, 11506, 13271, 13258, 11263, 11297, 13265, 11188, 13310, 13145, 13130, 11247, 13196, 13222, 11305, 11187, 13443, 13389, 11300, 13400, 11318, 11299, 13292, 11373, 11304, 13336, 11477, 11401, 13127, 11186, 13337, 11242, 13152, 11460, 13252, 11471, 11513, 13383, 11199, 13135, 13328, 13386, 13285, 11378, 11173, 13171, 13227, 11426, 11216, 13409, 13166, 11388, 13134, 11282, 13354, 11337, 13408, 11207, 13369, 11230, 13259, 13190, 13240, 11478, 11407, 11483, 13334, 11421, 11346, 13140, 11343, 11368, 11280, 11495, 11325, 13191, 11499, 11296, 11321, 11326, 13131, 11336, 13208, 11420, 13117, 11361, 13316, 11287, 13201, 11372, 13148, 11222, 11431, 13120, 11473, 4500, 11462, 11166, 11285, 13376, 13124, 11405, 11239, 13153, 13361, 13401, 11502, 11283, 13230, 13264, 13275, 11266, 11429, 11215, 13173, 13250, 11384, 11416, 11310, 11316, 13217, 11403, 11315, 11276, 13200, 11312, 11375, 11231, 11476, 11507, 11427, 11221, 13444, 13446, 13434) AND a0_.visible_pro = 0 ORDER BY a0_.booster DESC, a0_.prix ASC;
1.78 ms (2.75%)	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 = ? 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;
0.76 ms (1.18%)	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 Parameters: [`"13339"`] 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 = '13339' LIMIT 1;

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.