Query Metrics
18
Database Queries
8
Different statements
5.57 ms
Query time
0
Invalid entities
11
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.86 ms |
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
"maintenance_mode"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.28 ms |
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
"maintenance_resume_at"
]
|
||||||||||||||||||||||||||||||||||
| 3 | 0.50 ms |
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:
[
"gbenagnonagbannon@gmail.com"
]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.57 ms |
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:
[
186
]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.49 ms |
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, t0.active AS active_38 FROM enseignes t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"QRLE"
]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.22 ms |
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:
[
205
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.21 ms |
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, t0.active AS active_38 FROM enseignes t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"YLWE"
]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.20 ms |
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:
[
876
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.19 ms |
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, t0.active AS active_38 FROM enseignes t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"PICJ"
]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.15 ms |
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:
[
894
]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.16 ms |
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, t0.active AS active_38 FROM enseignes t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"LQNJ"
]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.17 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.31 ms |
UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-03-09 00:00:00" "2026-12-31 00:00:00" "2026-09-12 03:01:25" 80 ]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.17 ms |
UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-03-10 00:00:00" "2026-12-31 00:00:00" "2026-09-12 03:01:25" 84 ]
|
||||||||||||||||||||||||||||||||||
| 15 | 0.14 ms |
UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-06-03 00:00:00" "2026-09-13 03:01:25" "2026-09-12 03:01:25" 236 ]
|
||||||||||||||||||||||||||||||||||
| 16 | 0.12 ms |
UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-08-14 00:00:00" "2026-12-31 00:00:00" "2026-09-12 03:01:25" 240 ]
|
||||||||||||||||||||||||||||||||||
| 17 | 0.52 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 18 | 0.31 ms |
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:
[ "759d4938-4a3a-4c94-b244-28d1bf506b0f" "1" ]
|
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\Collaboration | 4 |
| App\Entity\Enseigne | 4 |
| App\Entity\AppConfig | 2 |
| App\Entity\Users | 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. |