Query Metrics
5
Database Queries
4
Different statements
5274.97 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.36 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.roles AS roles_5, t0.password AS password_6, t0.internal_ref AS internal_ref_7, t0.origin_id AS origin_id_8, t0.parent_origin_id AS parent_origin_id_9, t0.picto AS picto_10, t0.parent_id AS parent_id_11, t0.point_of_sale_id AS point_of_sale_id_12, t0.role_app_id AS role_app_id_13, t0.organisation_id AS organisation_id_14 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"bolting@nomad.fr"
]
|
| 2 | 0.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code AS code_4, t0.operator_id AS operator_id_5, t0.organisation_id AS organisation_id_6 FROM point_of_sale t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3"
]
|
| 3 | 4690.01 ms |
SELECT u.id AS user_id, HOUR(p.date_panier) AS heure, COUNT(*) AS nombre_lignes, p.* FROM nmd_app_panier p LEFT JOIN user u ON u.internal_ref = p.login_vendeur_init WHERE LOWER(p.login_vendeur_init) LIKE :loginPattern AND p.point_of_sale_id = :pointOfSaleId AND MONTH(p.date_panier) = :mois AND YEAR(p.date_panier) = :annee GROUP BY u.id, heure, p.id ORDER BY heure
Parameters:
[ "loginPattern" => "e%" "pointOfSaleId" => 3 "mois" => 2 "annee" => 2026 ] |
| 4 | 284.48 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM nmd_app_panier n0_ WHERE n0_.point_of_sale_id = ? AND (n0_.date_panier BETWEEN ? AND ?)
Parameters:
[ 3 "2026-02-10 00:00:00" "2026-02-10 09:09:57" ] |
| 5 | 299.16 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM nmd_app_panier n0_ WHERE n0_.point_of_sale_id = ? AND (n0_.date_panier BETWEEN ? AND ?)
Parameters:
[ 3 "2026-02-10 08:09:57" "2026-02-10 09:09:57" ] |
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User |
|
| App\Entity\PointOfSale | No errors. |
| App\Entity\RoleApp | No errors. |
| App\Entity\Organisation | No errors. |
| App\Entity\Operator | No errors. |
| App\Entity\Declarative | No errors. |
| App\Entity\InterventionPlace | No errors. |
| App\Entity\Production | No errors. |
| App\Entity\History | No errors. |
| App\Entity\DistributionAdresse | No errors. |
| App\Entity\ObjectivesManagement | No errors. |
| App\Entity\IncidentsTickets | No errors. |
| App\Entity\SchedulerSector | No errors. |
| App\Entity\SalesCoachProfile | No errors. |
| App\Entity\SalesCoachInteraction | No errors. |
| App\Entity\UsersRefExterne | No errors. |
| App\Entity\NmdAdressesIncomming | No errors. |
| App\Entity\NmdArretCuivre |
|
| App\Entity\NmdArretFttb |
|
| App\Entity\TourneeToken | No errors. |
| App\Entity\NmdAppPanier | No errors. |
| App\Entity\Cluster | No errors. |
| App\Entity\NmdModules | No errors. |
| App\Entity\ProspectionCycle | No errors. |