GET https://cv.sonacos.ma/fr/ventes

Query Metrics

15 Database Queries
9 Different statements
14.74 ms Query time
7 Invalid entities
2066 Managed entities

Queries

Group similar statements

# Time Info
1 0.42 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.usercode AS usercode_5, t0.nom AS nom_6, t0.prenom AS prenom_7, t0.telephone AS telephone_8, t0.lastvisit AS lastvisit_9, t0.lastip AS lastip_10, t0.password_request AS password_request_11, t0.password_request_at AS password_request_at_12, t0.password_updated_at AS password_updated_at_13, t0.point_vente_id AS point_vente_id_14, t0.region_id AS region_id_15 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1194
]
2 6.01 ms
SELECT v0_.id AS id_0, v0_.type AS type_1, v0_.quantite AS quantite_2, v0_.created_at AS created_at_3, v0_.region_name AS region_name_4, v0_.point_vente_name AS point_vente_name_5, v0_.category_name AS category_name_6, v0_.produit_name AS produit_name_7, v0_.espece_name AS espece_name_8, v0_.declaration_date AS declaration_date_9, v0_.produit_id AS produit_id_10, v0_.category_id AS category_id_11, v0_.declaration_vente_id AS declaration_vente_id_12, v0_.point_vente_id AS point_vente_id_13, v0_.user_id AS user_id_14, v0_.region_id AS region_id_15 FROM vente v0_ WHERE v0_.region_id IN (?)
Parameters:
[
  4
]
3 4.31 ms
SELECT v0_.id AS id_0, v0_.type AS type_1, v0_.quantite AS quantite_2, v0_.created_at AS created_at_3, v0_.region_name AS region_name_4, v0_.point_vente_name AS point_vente_name_5, v0_.category_name AS category_name_6, v0_.produit_name AS produit_name_7, v0_.espece_name AS espece_name_8, v0_.declaration_date AS declaration_date_9, v0_.produit_id AS produit_id_10, v0_.category_id AS category_id_11, v0_.declaration_vente_id AS declaration_vente_id_12, v0_.point_vente_id AS point_vente_id_13, v0_.user_id AS user_id_14, v0_.region_id AS region_id_15 FROM vente v0_ WHERE v0_.region_id IN (?) ORDER BY v0_.created_at DESC LIMIT 20
Parameters:
[
  4
]
4 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3 FROM region t0
Parameters:
[]
5 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.libelle AS libelle_4, t0.adresse AS adresse_5, t0.contrat AS contrat_6, t0.region_id AS region_id_7 FROM point_vente t0
Parameters:
[]
6 1.05 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.type AS type_2, p0_.espece_id AS espece_id_3 FROM produit p0_ ORDER BY p0_.nom ASC
Parameters:
[]
7 0.22 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM espece t0
Parameters:
[]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_pdt AS is_pdt_3 FROM category t0
Parameters:
[]
9 0.32 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  374956
]
10 0.25 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  384744
]
11 0.24 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  384651
]
12 0.25 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  384131
]
13 0.19 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  383510
]
14 0.19 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  384094
]
15 0.25 ms
SELECT t0.id AS id_1, t0.created AS created_2, t0.status AS status_3, t0.total_clients AS total_clients_4, t0.user_id AS user_id_5, t0.point_vente_id AS point_vente_id_6, t0.region_id AS region_id_7 FROM declaration_vente t0 WHERE t0.id = ?
Parameters:
[
  374418
]

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\Vente 1074
App\Entity\DeclarationVente 358
App\Entity\PointVente 323
App\Entity\Produit 268
App\Entity\Region 15
App\Entity\User 14
App\Entity\Category 9
App\Entity\Espece 5

Entities Mapping

Class Mapping errors
App\Entity\User
  • The association App\Entity\User#pointVente refers to the inverse side field App\Entity\PointVente#user which does not exist.
  • The association App\Entity\User#region refers to the inverse side field App\Entity\Region#user which does not exist.
  • The mappings App\Entity\User#validatationsAnnulationVente and App\Entity\AnnulationVente#validatedBy are inconsistent with each other.
App\Entity\PointVente
  • The mappings App\Entity\PointVente#users and App\Entity\User#pointVente are inconsistent with each other.
App\Entity\Region
  • The mappings App\Entity\Region#users and App\Entity\User#region are inconsistent with each other.
App\Entity\DeclarationVente No errors.
App\Entity\DeclarationCommande No errors.
App\Entity\Vente
  • The association App\Entity\Vente#produit refers to the inverse side field App\Entity\Produit#ventes which does not exist.
App\Entity\Commande No errors.
App\Entity\AnnulationVente
  • The association App\Entity\AnnulationVente#validatedBy refers to the inverse side field App\Entity\User#validatationsAnnualtion which does not exist.
App\Entity\PasswordRequest No errors.
App\Entity\Prix No errors.
App\Entity\Affectation No errors.
App\Entity\Produit No errors.
App\Entity\Category No errors.
App\Entity\Espece No errors.
App\Entity\DeclarationVenteHistorique
  • The association App\Entity\DeclarationVenteHistorique#user refers to the inverse side field App\Entity\User#decalarations which does not exist.
  • The association App\Entity\DeclarationVenteHistorique#ventes refers to the owning side field App\Entity\Vente#declarationVenteHistorique which does not exist.
  • The association App\Entity\DeclarationVenteHistorique#pointVente refers to the inverse side field App\Entity\PointVente#declarationVenteHistoriques which does not exist.
  • The association App\Entity\DeclarationVenteHistorique#region refers to the inverse side field App\Entity\Region#declarationVenteHistoriques which does not exist.
App\Entity\ProduitDemande
  • The association App\Entity\ProduitDemande#produit refers to the inverse side field App\Entity\Produit#demandes which does not exist.