GET https://facture.mayexperinfo.com/version

Query Metrics

17 Database Queries
5 Different statements
2.73 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.82 ms
SELECT t0.id AS id_1, t0.abrege AS abrege_2, t0.intitule AS intitule_3, t0.type_abonnement AS type_abonnement_4, t0.tarif AS tarif_5 FROM forfait t0
Parameters:
[]
2 0.26 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "REC_GEST"
]
3 0.14 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "DEV_GEST"
]
4 0.13 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "FCT_GEST"
]
5 0.12 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "BDL_GEST"
]
6 0.12 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "AVR_GEST"
]
7 0.06 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "AVR_GEST"
]
8 0.11 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "SRV_GEST"
]
9 0.12 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "CAT_GEST"
]
10 0.11 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "FNS_GEST"
]
11 0.11 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "INF_GEST"
]
12 0.12 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "ITV_GEST"
]
13 0.12 ms
SELECT h0_.id AS id_0, h0_.profil_id AS profil_id_1, h0_.module AS module_2 FROM habilitation_profil_module h0_ INNER JOIN utilisateur u1_ WHERE h0_.profil_id = u1_.profil_id AND ((u1_.id = ?) AND (h0_.module = ?))
Parameters:
[
  null
  "PRM_GEST"
]
14 0.05 ms
SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.numero_version AS numero_version_3, t0.description AS description_4 FROM version t0 ORDER BY t0.date_livraison DESC LIMIT 1
Parameters:
[]
15 0.18 ms
SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.numero_version AS numero_version_3, t0.description AS description_4 FROM version t0 ORDER BY t0.date_livraison DESC LIMIT 2
Parameters:
[]
16 0.11 ms
SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.numero_version AS numero_version_3, t0.description AS description_4 FROM version t0 ORDER BY t0.date_livraison ASC LIMIT 1
Parameters:
[]
17 0.04 ms
SELECT t0.id AS id_1, t0.date_livraison AS date_livraison_2, t0.numero_version AS numero_version_3, t0.description AS description_4 FROM version t0 ORDER BY t0.date_livraison DESC LIMIT 1
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Forfait 3
App\Entity\Version 3

Entities Mapping