Query Metrics
4
Database Queries
3
Different statements
11.03 ms
Query time
0
Invalid entities
46
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.65 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.value AS value_3, p0_.parameter_category_id AS parameter_category_id_4 FROM parameter p0_ ORDER BY p0_.parameter_category_id ASC
Parameters:
[] |
| 2 | 0.42 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.value AS value_3, p0_.parameter_category_id AS parameter_category_id_4 FROM parameter p0_ ORDER BY p0_.parameter_category_id ASC
Parameters:
[] |
| 3 | 6.22 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.is_active AS is_active_5, t0.zone AS zone_6, t0.roles AS roles_7, t0.hash AS hash_8, t0.admin AS admin_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.numtel AS numtel_12, t0.cgu AS cgu_13, t0.civilite AS civilite_14, t0.naissance AS naissance_15, t0.address AS address_16, t0.zip AS zip_17, t0.city AS city_18, t0.country AS country_19, t0.communication AS communication_20, t0.is_verified AS is_verified_21, t0.deleted_at AS deleted_at_22, t0.datecreation AS datecreation_23, t0.datemodification AS datemodification_24, t0.optin AS optin_25, t0.fantome AS fantome_26, t0.doubleauth AS doubleauth_27, t0.auth_code AS auth_code_28, t0.validity_code AS validity_code_29, t0.id_document AS id_document_30, t0.is_synchro_with_front AS is_synchro_with_front_31, t0.bi_sync AS bi_sync_32, t0.id_bi AS id_bi_33, t0.last_passage AS last_passage_34, t0.keycloakid AS keycloakid_35, t36.id AS id_37, t36.luckeyid AS luckeyid_38, t36.user_id AS user_id_39 FROM user t0 LEFT JOIN user_luckey t36 ON t36.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters:
[
"fabien"
]
|
| 4 | 3.73 ms |
SELECT t0.id AS id_1, t0.datedebut AS datedebut_2, t0.datefin AS datefin_3, t0.intitule AS intitule_4, t0.global AS global_5, t0.active AS active_6, t0.resubdays AS resubdays_7, t0.idabofo AS idabofo_8, t0.navigo_cert AS navigo_cert_9, t0.bi_sync AS bi_sync_10, t0.id_bi AS id_bi_11, t0.date_modification AS date_modification_12, t0.user_id AS user_id_13, t0.offre_id AS offre_id_14, t0.code_id AS code_id_15, t0.rack_id AS rack_id_16 FROM abonnement t0 WHERE t0.user_id IN (?) ORDER BY t0.datefin DESC
Parameters:
[
19
]
|
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\Parameter | 38 |
| App\Entity\ParameterCategory | 7 |
| App\Entity\User | 1 |