GET https://kopela.mg/api/clientparticulier

Query Metrics

316 Database Queries
2 Different statements
120.64 ms Query time
5 Invalid entities
631 Managed entities

Grouped Statements

Show all queries

Time Count Info
119.10 ms
(98.73%)
315
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.contact AS contact_7, t0.profile_picture AS profile_picture_8, t9.id AS id_10, t9.identifiant AS identifiant_11, t9.civilite AS civilite_12, t9.nif AS nif_13, t9.rcs AS rcs_14, t9.stat AS stat_15, t9.date_inscription AS date_inscription_16, t9.code_parrain AS code_parrain_17, t9.points AS points_18, t9.status AS status_19, t9.user_id AS user_id_20, t9.type_client_id AS type_client_id_21, t22.id AS id_23, t22.adresssmallparcel AS adresssmallparcel_24, t22.adressregularparcel AS adressregularparcel_25, t22.nom_societe AS nom_societe_26, t22.connexion AS connexion_27, t22.id_user_id AS id_user_id_28, t22.localisation_id AS localisation_id_29, t22.type_id AS type_id_30 FROM user t0 LEFT JOIN client t9 ON t9.user_id = t0.id LEFT JOIN agent_chine t22 ON t22.id_user_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
1.54 ms
(1.27%)
1
SELECT t0.id AS id_1, t0.identifiant AS identifiant_2, t0.civilite AS civilite_3, t0.nif AS nif_4, t0.rcs AS rcs_5, t0.stat AS stat_6, t0.date_inscription AS date_inscription_7, t0.code_parrain AS code_parrain_8, t0.points AS points_9, t0.status AS status_10, t0.user_id AS user_id_11, t0.type_client_id AS type_client_id_12 FROM client t0 WHERE t0.type_client_id = ?
Parameters:
[
  2
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Client 315
App\Entity\User 315
App\Entity\TypeClient 1

Entities Mapping

Class Mapping errors
App\Entity\Client
  • The association App\Entity\Client#expeditionClients refers to the owning side field App\Entity\ExpeditionClient#Client which does not exist.
App\Entity\User
  • The association App\Entity\User#bookings refers to the owning side field App\Entity\Booking#User which does not exist.
App\Entity\TypeClient No errors.
App\Entity\ExpeditionClient
  • The mappings App\Entity\ExpeditionClient#user and App\Entity\User#expeditionClients are inconsistent with each other.
  • The association App\Entity\ExpeditionClient#bookingDetails refers to the owning side field App\Entity\BookingDetails#ExpeditionClient which does not exist.
App\Entity\AgentChine No errors.
App\Entity\Localisation No errors.
App\Entity\TypeAgent
  • The association App\Entity\TypeAgent#categories refers to the owning side field App\Entity\Categorie#TypeAgent which does not exist.
App\Entity\Booking
  • The mappings App\Entity\Booking#user and App\Entity\User#bookings are inconsistent with each other.
App\Entity\Transport No errors.
App\Entity\NotificationUser No errors.