GET https://lingevres.ddns.net/lingevres/api_user/get_user_by_systeme_client/1

Query Metrics

2 Database Queries
2 Different statements
1.16 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.65 ms
(55.59%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM systeme_client t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.52 ms
(44.41%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.prenom AS prenom_4, u0_.nom AS nom_5, u0_.initiales AS initiales_6, u0_.matricule AS matricule_7, u0_.actif AS actif_8, u0_.carte_clef_rendu AS carte_clef_rendu_9, u0_.rappel_sms AS rappel_sms_10, u0_.telephone AS telephone_11, u0_.telephone_pro AS telephone_pro_12, u0_.ville_id AS ville_id_13, u0_.ville_attache_id AS ville_attache_id_14, u0_.systeme_client_id AS systeme_client_id_15 FROM user u0_ WHERE u0_.roles NOT LIKE ? AND u0_.roles NOT LIKE ? AND u0_.roles NOT LIKE ? AND u0_.systeme_client_id = ? AND u0_.actif = 1 ORDER BY u0_.prenom ASC
Parameters:
[
  "%ROLE_ANAL%"
  "%ROLE_TECH%"
  "%ROLE_PAS_AFFICH%"
  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\SystemeClient
  • The association App\Entity\SystemeClient#maintenanceTypes refers to the owning side field App\Entity\MaintenanceType#SystemeClient which does not exist.
App\Entity\User
  • The association App\Entity\User#camions refers to the owning side field App\Entity\Camion#user which does not exist.
  • The association App\Entity\User#cartePaiements refers to the owning side field App\Entity\CartePaiement#user which does not exist.
App\Entity\Remorque
  • The association App\Entity\Remorque#factures refers to the owning side field App\Entity\Facture#Remorque which does not exist.
  • The association App\Entity\Remorque#constructeur refers to the inverse side field App\Entity\Constructeur#constructeur which does not exist.
App\Entity\Camion
  • The association App\Entity\Camion#cartePaiements refers to the owning side field App\Entity\CartePaiement#camion which does not exist.
  • The association App\Entity\Camion#maintenances refers to the owning side field App\Entity\Maintenance#Camion which does not exist.
  • The association App\Entity\Camion#constructeur refers to the inverse side field App\Entity\Constructeur#constructeur which does not exist.
App\Entity\Maintenance
  • The mappings App\Entity\Maintenance#camion and App\Entity\Camion#maintenances are inconsistent with each other.
App\Entity\TourneeTheorique No errors.
App\Entity\Client
  • The mappings App\Entity\Client#transportReel and App\Entity\TransportReel#client are inconsistent with each other.
App\Entity\Pneu No errors.
App\Entity\MaintenanceType
  • The mappings App\Entity\MaintenanceType#systemeClient and App\Entity\SystemeClient#maintenanceTypes are inconsistent with each other.
App\Entity\VilleFrance No errors.
App\Entity\CamionUser No errors.
App\Entity\Documentation No errors.
App\Entity\CartePaiement No errors.
App\Entity\Absence No errors.
App\Entity\PlanningReccurence No errors.
App\Entity\InfoChauffeur No errors.
App\Entity\InfoChauffeurDate No errors.
App\Entity\PlanningUpdateDateTime No errors.
App\Entity\HoraireExploit No errors.