https://modixom.fr/api/addAnnonce?p=api%2FaddAnnonce&token=48e0e689e427cc1fcb71cb2bcf2cdcc2 Return to referer URL

Query Metrics

11 Database Queries
7 Different statements
7.50 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.16 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:
[
  "48e0e689e427cc1fcb71cb2bcf2cdcc2"
]
2 0.46 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM categories t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  20
]
3 0.25 ms
"START TRANSACTION"
Parameters:
[]
4 0.46 ms
INSERT INTO annonces (titre, prix, description, pourcent_remise, date_debut, date_fin, quantite, visible_pro, booster, nb_vues, image, categories_id, user_id, villes_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "testt"
  200.0
  "estetesttes"
  20.0
  "2024-11-19 14:53:00"
  "2024-11-20 14:53:00"
  450
  0
  1
  0
  null
  20
  38
  22354
]
5 1.89 ms
"COMMIT"
Parameters:
[]
6 0.15 ms
"START TRANSACTION"
Parameters:
[]
7 0.35 ms
INSERT INTO images (lien, annonces_id) VALUES (?, ?)
Parameters:
[
  "image673ca68588905.png"
  147
]
8 1.44 ms
"COMMIT"
Parameters:
[]
9 0.20 ms
"START TRANSACTION"
Parameters:
[]
10 0.51 ms
UPDATE user SET credits = ? WHERE id = ?
Parameters:
[
  58
  38
]
11 0.65 ms
"COMMIT"
Parameters:
[]

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\User No errors.
App\Entity\Images 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\Favoris 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.