https://api.nomadcloud.fr/api/paniers-details-by-hour?page=1&pointOfSaleId=3

Query Metrics

5 Database Queries
4 Different statements
5274.97 ms Query time
3 Invalid entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\User#nmdArretCuivres and App\Entity\NmdArretCuivre#user are inconsistent with each other.
  • The mappings App\Entity\User#nmdArretFttbs and App\Entity\NmdArretFttb#user are inconsistent with each other.
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
  • The association App\Entity\NmdArretCuivre#user refers to the inverse side field App\Entity\User#NmdArretCuivres which does not exist.
App\Entity\NmdArretFttb
  • The association App\Entity\NmdArretFttb#user refers to the inverse side field App\Entity\User#NmdArretFttbs which does not exist.
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.