https://modixom.fr/api/searchAnnonces?p=api%2FsearchAnnonces&pro=false&token=48e0e689e427cc1fcb71cb2bcf2cdcc2&tri=ASC

Query Metrics

145 Database Queries
8 Different statements
107.57 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
39.16 ms
(36.41%)
34
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
]
21.17 ms
(19.68%)
34
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
]
19.80 ms
(18.41%)
34
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
]
18.61 ms
(17.30%)
34
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
  38
]
5.19 ms
(4.82%)
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:
[
  ""
]
1.33 ms
(1.24%)
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_.visible_pro = ? ORDER BY a0_.booster DESC, a0_.prix ASC
Parameters:
[
  "2024-11-19 14:31:24"
  "2024-11-19 14:31:24"
  0
]
1.22 ms
(1.14%)
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:
[
  "48e0e689e427cc1fcb71cb2bcf2cdcc2"
]
1.09 ms
(1.01%)
6
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
]

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.