https://blackstarsco.fr/bscm/admin/gestion/requete-de-financement/requete-de-financement

Query Metrics

4 Database Queries
4 Different statements
1.12 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 0.69 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.niveau AS niveau_4, t0.name AS name_5, t0.matricule AS matricule_6, t0.roles AS roles_7, t0.email_pro AS email_pro_8, t0.fonction AS fonction_9, t0.entry_at AS entry_at_10, t0.prenoms AS prenoms_11, t0.date_sortie AS date_sortie_12, t0.status_id AS status_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  32
]
2 0.15 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.formulaire AS formulaire_2, s0_.description AS description_3 FROM status s0_ WHERE LOWER(s0_.formulaire) LIKE ?
Parameters:
[
  "%requ%de%financement%"
]
3 0.16 ms
SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.password AS password_2, u0_.niveau AS niveau_3, u0_.name AS name_4, u0_.matricule AS matricule_5, u0_.roles AS roles_6, u0_.email_pro AS email_pro_7, u0_.fonction AS fonction_8, u0_.entry_at AS entry_at_9, u0_.prenoms AS prenoms_10, u0_.date_sortie AS date_sortie_11, u0_.status_id AS status_id_12 FROM user u0_
Parameters:
[]
4 0.12 ms
SELECT n0_.id AS id_0, n0_.niveau AS niveau_1, n0_.created_at AS created_at_2, n0_.description AS description_3 FROM niveau n0_
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
  • The mappings App\Entity\User#suivipars and App\Entity\LetterOfIntentToPurchase#suivipar are inconsistent with each other.
App\Entity\UserStatus No errors.
App\Entity\PlaceDeMarche No errors.
App\Entity\TraitementDsDemdDachat No errors.
App\Entity\AdminDonneurOrdre
  • The mappings App\Entity\AdminDonneurOrdre#mandats and App\Entity\SousJacent#mandat are inconsistent with each other.
  • The mappings App\Entity\AdminDonneurOrdre#qmandats and App\Entity\Quotation#mandat are inconsistent with each other.
  • The mappings App\Entity\AdminDonneurOrdre#recipient and App\Entity\LetterOfIntentToPurchase#recipient are inconsistent with each other.
App\Entity\LeveeDeFond No errors.
App\Entity\LetterOfIntentToPurchase
  • The association App\Entity\LetterOfIntentToPurchase#recipient refers to the inverse side field App\Entity\AdminDonneurOrdre#letterOfIntentToPurchases which does not exist.
  • The mappings App\Entity\LetterOfIntentToPurchase#suivipar and App\Entity\User#letterOfIntentToPurchases are inconsistent with each other.
  • The mappings App\Entity\LetterOfIntentToPurchase#paiement_mode and App\Entity\PaymentMethod#letterOfIntentToPurchases are inconsistent with each other.
App\Entity\Document No errors.
App\Entity\DemandeDeCotation No errors.
App\Entity\Prospect No errors.
App\Entity\RequeteDeFinancement No errors.
App\Entity\Visiteur No errors.
App\Entity\Abonne No errors.
App\Entity\Status No errors.
App\Entity\Niveau No errors.
App\Entity\Appariement
  • The mappings App\Entity\Appariement#spot_devise and App\Entity\Devise#appariements are inconsistent with each other.
App\Entity\AppelDeMarge No errors.
App\Entity\SousJacent
  • The association App\Entity\SousJacent#mandat refers to the inverse side field App\Entity\AdminDonneurOrdre#sousJacents which does not exist.
  • The mappings App\Entity\SousJacent#stade and App\Entity\Stade#sousJacents are inconsistent with each other.
App\Entity\Quotation
  • The association App\Entity\Quotation#incoterm refers to the inverse side field App\Entity\Incoterm#quotations which does not exist.
  • The association App\Entity\Quotation#mandat refers to the inverse side field App\Entity\AdminDonneurOrdre#quotations which does not exist.
App\Entity\Transaction
  • The association App\Entity\Transaction#total_unite refers to the inverse side field App\Entity\Devise#transactions which does not exist.
App\Entity\Operation No errors.
App\Entity\FraisDeCourtage No errors.