https://groupgica.com/in_back/clients/130

Query Metrics

3 Database Queries
3 Different statements
1.93 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.02 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.adresse AS adresse_4, t0.num_telephone AS num_telephone_5, t0.email AS email_6, t0.date_inscription AS date_inscription_7, t0.nif AS nif_8, t0.is_visible AS is_visible_9, t0.document AS document_10, t0.birthdate_at AS birthdate_at_11, t0.created_by_id AS created_by_id_12, t0.city_id AS city_id_13 FROM client t0 WHERE t0.id = ?
Parameters:
[
  "130"
]
2 0.49 ms
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.prenom AS prenom_2, g0_.nif AS nif_3, g0_.adresse AS adresse_4, g0_.telephone AS telephone_5, g0_.email AS email_6, g0_.date_enregistrement AS date_enregistrement_7, g0_.profession AS profession_8, g0_.employeur AS employeur_9, g0_.tel_employeur AS tel_employeur_10, g0_.nom_entreprise AS nom_entreprise_11, g0_.document AS document_12 FROM garant g0_
Parameters:
[]
3 0.42 ms
SELECT * FROM user 
         WHERE JSON_CONTAINS(roles, :adminRole, "$")
            OR JSON_CONTAINS(roles, :superAdminRole, "$")
Parameters:
[
  "adminRole" => ""ROLE_ADMIN""
  "superAdminRole" => ""ROLE_SUPERADMIN""
]

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\Client No errors.
App\Entity\User No errors.
App\Entity\City No errors.
App\Entity\Transaction No errors.
App\Entity\Plan No errors.
App\Entity\Pret No errors.
App\Entity\Placement No errors.
App\Entity\Sol No errors.
App\Entity\Escalier No errors.
App\Entity\Terrain No errors.
App\Entity\Garant No errors.
App\Entity\Documents No errors.
App\Entity\Notification No errors.
App\Entity\AuthenticatedDevice No errors.