Query Metrics
12
Database Queries
8
Different statements
4.48 ms
Query time
0
Invalid entities
7
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.88 ms |
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
"maintenance_mode"
]
|
||||||||||||||||||||||||||
| 2 | 0.21 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.58 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.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = ? LIMIT 1
Parameters:
[
"o_laminou@n2a.online"
]
|
||||||||||||||||||||||||||
| 4 | 0.48 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:
[
537
]
|
||||||||||||||||||||||||||
| 5 | 0.38 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11, t12.id AS id_13, t12.daily_prospection_target AS daily_prospection_target_14, t12.weekly_prospection_target AS weekly_prospection_target_15, t12.monthly_prospection_target AS monthly_prospection_target_16, t12.daily_conversion_rate AS daily_conversion_rate_17, t12.weekly_conversion_rate AS weekly_conversion_rate_18, t12.monthly_conversion_rate AS monthly_conversion_rate_19, t12.enseigne_id AS enseigne_id_20 FROM enseignes t0 LEFT JOIN enseigne_settings t12 ON t12.enseigne_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"ZKCG"
]
|
||||||||||||||||||||||||||
| 6 | 0.28 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:
[
606
]
|
||||||||||||||||||||||||||
| 7 | 0.27 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11, t12.id AS id_13, t12.daily_prospection_target AS daily_prospection_target_14, t12.weekly_prospection_target AS weekly_prospection_target_15, t12.monthly_prospection_target AS monthly_prospection_target_16, t12.daily_conversion_rate AS daily_conversion_rate_17, t12.weekly_conversion_rate AS weekly_conversion_rate_18, t12.monthly_conversion_rate AS monthly_conversion_rate_19, t12.enseigne_id AS enseigne_id_20 FROM enseignes t0 LEFT JOIN enseigne_settings t12 ON t12.enseigne_id = t0.id WHERE t0.code = ? LIMIT 1
Parameters:
[
"YLWE"
]
|
||||||||||||||||||||||||||
| 8 | 0.15 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 9 | 0.30 ms |
UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-04-16 00:00:00" "2026-04-30 00:29:19" "2026-04-29 00:29:19" 95 ]
|
||||||||||||||||||||||||||
| 10 | 0.17 ms |
UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-04-21 00:00:00" "2027-03-31 00:00:00" "2026-04-29 00:29:19" 122 ]
|
||||||||||||||||||||||||||
| 11 | 0.48 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||
| 12 | 0.29 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:
[ "a18667e2-6ec0-4cd8-890f-e3ae23f053c1" "4" ]
|
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 |
| App\Entity\Settings\EnseigneSettings | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AppConfig | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\FidelityCard | No errors. |
| App\Entity\Reward | No errors. |
| App\Entity\HR\UserOrganizationalUnit | No errors. |
| App\Entity\Collaboration | No errors. |
| App\Entity\Enseigne | No errors. |
| App\Entity\Settings\EnseigneSettings | No errors. |
| App\Entity\PointDeVente | No errors. |
| App\Entity\RewardType | No errors. |
| App\Entity\RedemptionType | No errors. |
| App\Entity\Settings\CommissionRule | No errors. |
| App\Entity\Settings\PrimeRule | No errors. |