Query Metrics
12
Database Queries
9
Different statements
5.31 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.43 ms (26.95%) |
2 |
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
"maintenance_mode"
]
|
||||||||||||||||||||||||||
|
0.80 ms (14.99%) |
2 |
SELECT t0.id AS id_1, t0.collab_id AS collab_id_2, t0.role AS role_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.enseigne_id AS enseigne_id_6, t0.entreprise_id AS entreprise_id_7, t0.plateforme_id AS plateforme_id_8, t0.plateforme_nom AS plateforme_nom_9, t0.user_uuid AS user_uuid_10, t0.user_email AS user_email_11, t0.user_prenom AS user_prenom_12, t0.user_nom AS user_nom_13, t0.user_photo AS user_photo_14, t0.statut AS statut_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM collaboration t0 WHERE t0.collab_id = ? LIMIT 1
Parameters:
[
233
]
|
||||||||||||||||||||||||||
|
0.70 ms (13.14%) |
1 |
SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.type_compte AS type_compte_9, t0.created_at AS created_at_10, t0.last_login_at AS last_login_at_11, t0.bpay_account AS bpay_account_12, t0.business_pay_account AS business_pay_account_13, t0.care_concept_account AS care_concept_account_14, t0.cashline_account AS cashline_account_15 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"noutaispriscillia@gmail.com"
]
|
||||||||||||||||||||||||||
|
0.69 ms (12.94%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_url_root AS main_url_root_5, t0.main_document_root AS main_document_root_6, t0.main_url_root_alt AS main_url_root_alt_7, t0.main_document_root_alt AS main_document_root_alt_8, t0.main_data_root AS main_data_root_9, t0.main_db_host AS main_db_host_10, t0.main_db_port AS main_db_port_11, t0.main_db_name AS main_db_name_12, t0.main_db_prefix AS main_db_prefix_13, t0.main_db_user AS main_db_user_14, t0.main_db_pass AS main_db_pass_15, t0.main_db_type AS main_db_type_16, t0.main_db_character_set AS main_db_character_set_17, t0.main_db_collation AS main_db_collation_18, t0.main_authentication AS main_authentication_19, t0.main_prod AS main_prod_20, t0.main_force_https AS main_force_https_21, t0.main_restrict_os_commands AS main_restrict_os_commands_22, t0.nocsrfcheck AS nocsrfcheck_23, t0.main_instance_unique_id AS main_instance_unique_id_24, t0.mailing_limit_sendbyweb AS mailing_limit_sendbyweb_25, t0.main_distrib AS main_distrib_26, t0.environnement AS environnement_27, t0.statut AS statut_28, t0.etat_instance AS etat_instance_29, t0.version_courante AS version_courante_30, t0.health AS health_31, t0.base_url AS base_url_32, t0.api_key AS api_key_33, t0.dgi_token AS dgi_token_34, t0.last_heartbeat_at AS last_heartbeat_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37 FROM enseignes t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"DSFH"
]
|
||||||||||||||||||||||||||
|
0.59 ms (11.02%) |
1 |
INSERT INTO collaboration (collab_id, role, date_debut, date_fin, enseigne_id, entreprise_id, plateforme_id, plateforme_nom, user_uuid, user_email, user_prenom, user_nom, user_photo, statut, created_at, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 246 "POWER_USER_ENSEIGNE" "2026-04-02 00:00:00" "2026-04-05 00:00:00" 0 62 1 "MagmaERP" "5c518083-a601-41a9-b51d-f20074ca2ef5" "noutaispriscillia@gmail.com" "Fabiola" "Ganhouemion" "https://business-n2a.myn2a.online/uploads/photos/profil/Fabiola-Ganhouemion6db3bf42-b076-4354-b4b9-948fb99c9498-69ce86f6baee2.jpg" "active" "2026-04-03 09:40:04" "2026-04-03 09:40:04" ]
|
||||||||||||||||||||||||||
|
0.35 ms (6.61%) |
1 |
SELECT t0.id AS id_1, t0.collab_id AS collab_id_2, t0.role AS role_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.enseigne_id AS enseigne_id_6, t0.entreprise_id AS entreprise_id_7, t0.plateforme_id AS plateforme_id_8, t0.plateforme_nom AS plateforme_nom_9, t0.user_uuid AS user_uuid_10, t0.user_email AS user_email_11, t0.user_prenom AS user_prenom_12, t0.user_nom AS user_nom_13, t0.user_photo AS user_photo_14, t0.statut AS statut_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM collaboration t0 WHERE t0.user_uuid = ? AND t0.plateforme_id = ?
Parameters:
[ "5c518083-a601-41a9-b51d-f20074ca2ef5" "1" ]
|
||||||||||||||||||||||||||
|
0.34 ms (6.38%) |
1 |
UPDATE collaboration SET date_debut = ?, date_fin = ?, user_photo = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-04-01 00:00:00" "2026-04-04 00:00:00" "https://business-n2a.myn2a.online/uploads/photos/profil/Fabiola-Ganhouemion6db3bf42-b076-4354-b4b9-948fb99c9498-69ce86f6baee2.jpg" "2026-04-03 09:40:04" 97 ]
|
||||||||||||||||||||||||||
|
0.27 ms (5.12%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.15 ms (2.84%) |
1 |
"START TRANSACTION"
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\AppConfig | 2 |
| App\Entity\Collaboration | 2 |
| App\Entity\Users | 1 |
| App\Entity\Enseigne | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AppConfig | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\Collaboration | No errors. |
| App\Entity\Enseigne | No errors. |