GET https://axiumv2.optimumci.com/api/vente/latest

Query Metrics

14 Database Queries
6 Different statements
7.07 ms Query time
3 Invalid entities
40 Managed entities

Queries

Group similar statements

# Time Info
1 1.44 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.refresh_token AS refresh_token_8, t0.refresh_token_expires_at AS refresh_token_expires_at_9, t0.apps AS apps_10, t0.signature AS signature_11, t0.fleet_refresh_token AS fleet_refresh_token_12, t0.password AS password_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.station_id AS station_id_17, t0.lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "kouattara@sifogroup.com"
]
2 1.59 ms
SELECT v0_.id AS id_0, v0_.ref AS ref_1, v0_.date AS date_2, v0_.index_ouverture AS index_ouverture_3, v0_.index_cloture AS index_cloture_4, v0_.retour_en_cuve AS retour_en_cuve_5, v0_.vente AS vente_6, v0_.ca AS ca_7, v0_.jauge_ouverture AS jauge_ouverture_8, v0_.jauge_cloture AS jauge_cloture_9, v0_.stock_theorique AS stock_theorique_10, v0_.ecart AS ecart_11, v0_.stock_cuve_restant AS stock_cuve_restant_12, v0_.commentaire AS commentaire_13, v0_.statut AS statut_14, v0_.motif_rejet AS motif_rejet_15, v0_.counter_year AS counter_year_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18, v0_.operation_user_id AS operation_user_id_19, v0_.station_id AS station_id_20 FROM vente v0_ WHERE v0_.station_id = ? ORDER BY v0_.date DESC LIMIT 5
Parameters:
[
  1
]
3 0.54 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ref_client AS ref_client_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.localite_id AS localite_id_8 FROM station_service t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.71 ms
SELECT t0.id AS id_1, t0.index_ouverture AS index_ouverture_2, t0.index_cloture AS index_cloture_3, t0.retour_en_cuve AS retour_en_cuve_4, t0.produit_vendu AS produit_vendu_5, t0.ca AS ca_6, t0.product_name AS product_name_7, t0.jauge_ouverture AS jauge_ouverture_8, t0.jauge_cloture AS jauge_cloture_9, t0.stock_restant AS stock_restant_10, t0.stock_vendu AS stock_vendu_11, t0.type AS type_12, t0.stock_reception AS stock_reception_13, t0.stock_cuve_av_vente AS stock_cuve_av_vente_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.pompe_id AS pompe_id_17, t0.vente_id AS vente_id_18, t0.cuve_id AS cuve_id_19 FROM details_vente t0 WHERE t0.vente_id = ?
Parameters:
[
  25
]
5 0.44 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.25 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.25 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.27 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 0.24 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  33
]
10 0.26 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  34
]
11 0.24 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  35
]
12 0.22 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.status AS status_4, t0.produit_id AS produit_id_5, t0.product_name AS product_name_6, t0.last_index AS last_index_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.station_id AS station_id_10, t0.cuve_id AS cuve_id_11 FROM pompe t0 WHERE t0.id = ?
Parameters:
[
  36
]
13 0.41 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.capacity_max AS capacity_max_4, t0.stock_reel AS stock_reel_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.station_id AS station_id_8, t0.produit_id AS produit_id_9 FROM cuve t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.23 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.libelle AS libelle_3, t0.capacity_max AS capacity_max_4, t0.stock_reel AS stock_reel_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.station_id AS station_id_8, t0.produit_id AS produit_id_9 FROM cuve t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Domain\Controle\DetailsVente 20
App\Entity\Domain\Controle\Pompe 8
App\Entity\Domain\Controle\Vente 5
App\Entity\Domain\Controle\Cuve 2
App\Entity\Domain\Params\Produit 2
App\Entity\Admin\User 1
App\Entity\Domain\Chargement\StationService 1
App\Entity\Domain\System\Localite 1

Entities Mapping

Class Mapping errors
App\Entity\Admin\User
  • The mappings App\Entity\Admin\User#detailBonDeLivraisonsGerant and App\Entity\Domain\Chargement\DetailBonDeLivraison#gerant are inconsistent with each other.
App\Entity\Domain\Chargement\StationService
  • The mappings App\Entity\Domain\Chargement\StationService#produit and App\Entity\Domain\Controle\Cuve#station are inconsistent with each other.
App\Entity\Domain\Chargement\LieuEmpotage No errors.
App\Entity\Admin\Role No errors.
App\Entity\Domain\Depotage\Depotage No errors.
App\Entity\Domain\Chargement\DetailBonDeLivraison
  • The mappings App\Entity\Domain\Chargement\DetailBonDeLivraison#gerant and App\Entity\Admin\User#detailBonDeLivraisons are inconsistent with each other.
App\Entity\Domain\Controle\Versement No errors.
App\Entity\Domain\Controle\Credit No errors.
App\Entity\Domain\Controle\Vente No errors.
App\Entity\Domain\Chargement\BonDeLivraison No errors.
App\Entity\Domain\Controle\DetailsVente No errors.
App\Entity\Domain\System\Localite No errors.
App\Entity\Domain\Controle\Cuve No errors.
App\Entity\Domain\Controle\Pompe No errors.
App\Entity\Domain\Controle\Inventaire No errors.
App\Entity\Domain\Controle\RegelementCredit No errors.
App\Entity\Domain\System\Pompiste No errors.
App\Entity\Domain\Controle\RetourCuve No errors.
App\Entity\Domain\Controle\IndexPompe No errors.
App\Entity\Domain\Params\Produit No errors.
App\Entity\Domain\Controle\StockCuve No errors.