GET https://avaservice.allagence.com/

Query Metrics

8 Database Queries
6 Different statements
3.13 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT t0.id AS id_1, t0.gain_pack AS gain_pack_2, t0.montant_pack AS montant_pack_3, t0.promotion AS promotion_4, t0.niveau_pack_id AS niveau_pack_id_5 FROM pack t0
Parameters:
[]
2 0.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.isdelete AS isdelete_5, t0.one_connexion AS one_connexion_6, t0.log AS log_7 FROM `user` t0
Parameters:
[]
3 0.17 ms
SELECT t0.id AS id_1, t0.gain_pack AS gain_pack_2, t0.montant_pack AS montant_pack_3, t0.promotion AS promotion_4, t0.niveau_pack_id AS niveau_pack_id_5 FROM pack t0 WHERE t0.promotion = ?
Parameters:
[
  1
]
4 0.39 ms
SELECT t0.id AS id_1, t0.nom_paiement AS nom_paiement_2, t0.adresse_paiement AS adresse_paiement_3 FROM paiement t0
Parameters:
[]
5 0.54 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3 FROM paramettre t0
Parameters:
[]
6 0.13 ms
SELECT t0.id AS id_1, t0.gain_pack AS gain_pack_2, t0.montant_pack AS montant_pack_3, t0.promotion AS promotion_4, t0.niveau_pack_id AS niveau_pack_id_5 FROM pack t0 WHERE t0.promotion = ?
Parameters:
[
  1
]
7 0.27 ms
SELECT t0.id AS id_1, t0.gain_pack AS gain_pack_2, t0.montant_pack AS montant_pack_3, t0.promotion AS promotion_4, t0.niveau_pack_id AS niveau_pack_id_5 FROM pack t0 WHERE t0.niveau_pack_id = ?
Parameters:
[
  1
]
8 0.14 ms
SELECT t0.id AS id_1, t0.gain_pack AS gain_pack_2, t0.montant_pack AS montant_pack_3, t0.promotion AS promotion_4, t0.niveau_pack_id AS niveau_pack_id_5 FROM pack t0 WHERE t0.niveau_pack_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.

Entities Mapping

Class Mapping errors
App\Entity\Pack No errors.
App\Entity\NiveauPack No errors.
App\Entity\Acheter No errors.
App\Entity\User No errors.
App\Entity\Personne No errors.
App\Entity\Paiement No errors.
App\Entity\Paramettre No errors.