GET https://axiumv2.optimumci.com/api/chargement/bondeLivraisons/station-depoted-validated

Query Metrics

38 Database Queries
14 Different statements
15.14 ms Query time
3 Invalid entities
84 Managed entities

Queries

Group similar statements

# Time Info
1 1.43 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:
[
  "gbetta@sifogroup.com"
]
2 1.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ?
Parameters:
[
  15
]
3 0.54 ms
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.role_id AS role_id_3, t0.permission_id AS permission_id_4 FROM role_permission t0 WHERE t0.role_id = ?
Parameters:
[
  4
]
4 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  137
]
5 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  44
]
6 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  45
]
7 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  46
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  50
]
9 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  51
]
10 0.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  52
]
11 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  53
]
12 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  54
]
13 1.25 ms
SELECT b0_.id AS id_0, b0_.super AS super_1, b0_.gasoil AS gasoil_2, b0_.fuel AS fuel_3, b0_.petrol AS petrol_4, b0_.date_de_chargement AS date_de_chargement_5, b0_.photo_bl AS photo_bl_6, b0_.numero AS numero_7, b0_.chauffeur AS chauffeur_8, b0_.isdepoted AS isdepoted_9, b0_.isdraft AS isdraft_10, b0_.date_edition AS date_edition_11, b0_.is_agent_traited AS is_agent_traited_12, b0_.is_validated AS is_validated_13, b0_.is_started AS is_started_14, b0_.date_arrivee_camion AS date_arrivee_camion_15, b0_.date_depart_camion AS date_depart_camion_16, b0_.date_debut_depotage AS date_debut_depotage_17, b0_.date_fin_depotage AS date_fin_depotage_18, b0_.temps_depotage AS temps_depotage_19, b0_.is_charged AS is_charged_20, b0_.granted AS granted_21, b0_.prix_super AS prix_super_22, b0_.prix_gasoil AS prix_gasoil_23, b0_.prix_fuel AS prix_fuel_24, b0_.prix_petrol AS prix_petrol_25, b0_.regime_douanier AS regime_douanier_26, b0_.differentiel_transport AS differentiel_transport_27, b0_.bc_client AS bc_client_28, b0_.created_at AS created_at_29, b0_.updated_at AS updated_at_30, l1_.id AS id_31, l1_.label AS label_32, l1_.latitude AS latitude_33, l1_.longitude AS longitude_34, l1_.created_at AS created_at_35, l1_.updated_at AS updated_at_36, l1_.slug AS slug_37, b0_.station_service_id AS station_service_id_38, b0_.camion_id AS camion_id_39, b0_.lieux_empotage_id AS lieux_empotage_id_40, b0_.operation_user_id AS operation_user_id_41, b0_.agent_granted_id AS agent_granted_id_42 FROM bon_de_livraison b0_ LEFT JOIN lieu_empotage l1_ ON b0_.lieux_empotage_id = l1_.id WHERE b0_.isdraft = 0 AND b0_.granted = 1 AND l1_.id = ? AND b0_.isdepoted = 1 AND b0_.is_validated = 1 ORDER BY b0_.created_at DESC
Parameters:
[
  2
]
14 0.41 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
]
15 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.differentiel_transport AS differentiel_transport_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.slug AS slug_8 FROM localite t0 WHERE t0.id = ?
Parameters:
[
  4
]
16 0.47 ms
SELECT t0.id AS id_1, t0.chauffeur AS chauffeur_2, t0.parking AS parking_3, t0.status AS status_4, t0.tractor_id AS tractor_id_5, t0.trailer_id AS trailer_id_6 FROM camion t0 WHERE t0.id = ?
Parameters:
[
  33
]
17 0.47 ms
SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.capacity AS capacity_3, t0.nbrcompatiment AS nbrcompatiment_4, t0.typeatelage AS typeatelage_5, t0.company AS company_6, t0.slug AS slug_7, t0.marque AS marque_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.tractor_id AS tractor_id_11, t0.carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0.id = ?
Parameters:
[
  29
]
18 0.53 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.capacity AS capacity_3, t0.creux_certificat AS creux_certificat_4, t0.status AS status_5, t0.trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0.trailer_id = ?
Parameters:
[
  29
]
19 0.57 ms
SELECT t0.id AS id_1, t0.creux_gestoci AS creux_gestoci_2, t0.dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3, t0.creux_station AS creux_station_4, t0.dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5, t0.ecart AS ecart_6, t0.contre_plain AS contre_plain_7, t0.date_debut_depotage AS date_debut_depotage_8, t0.date_fin_depotage AS date_fin_depotage_9, t0.temps_depotage AS temps_depotage_10, t0.commentaire AS commentaire_11, t0.stock_avant_depotage AS stock_avant_depotage_12, t0.stock_apres_depotage AS stock_apres_depotage_13, t0.stock_theorique AS stock_theorique_14, t0.stock_reel AS stock_reel_15, t0.bon_de_livraison_id AS bon_de_livraison_id_16, t0.compartiment_id AS compartiment_id_17, t0.produit_id AS produit_id_18, t0.jaugeur_id AS jaugeur_id_19, t0.gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0.bon_de_livraison_id = ?
Parameters:
[
  6
]
20 0.28 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  2
]
21 0.33 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.id = ?
Parameters:
[
  14
]
22 0.28 ms
SELECT t0.id AS id_1, t0.chauffeur AS chauffeur_2, t0.parking AS parking_3, t0.status AS status_4, t0.tractor_id AS tractor_id_5, t0.trailer_id AS trailer_id_6 FROM camion t0 WHERE t0.id = ?
Parameters:
[
  29
]
23 0.25 ms
SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.capacity AS capacity_3, t0.nbrcompatiment AS nbrcompatiment_4, t0.typeatelage AS typeatelage_5, t0.company AS company_6, t0.slug AS slug_7, t0.marque AS marque_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.tractor_id AS tractor_id_11, t0.carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0.id = ?
Parameters:
[
  8
]
24 0.27 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.capacity AS capacity_3, t0.creux_certificat AS creux_certificat_4, t0.status AS status_5, t0.trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0.trailer_id = ?
Parameters:
[
  8
]
25 0.50 ms
SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.company AS company_3, t0.marque AS marque_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t8.id AS id_9, t8.immatriculation AS immatriculation_10, t8.capacity AS capacity_11, t8.nbrcompatiment AS nbrcompatiment_12, t8.typeatelage AS typeatelage_13, t8.company AS company_14, t8.slug AS slug_15, t8.marque AS marque_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.tractor_id AS tractor_id_19, t8.carburant_id AS carburant_id_20, t0.carburant_id AS carburant_id_21 FROM tractor t0 LEFT JOIN trailer t8 ON t8.tractor_id = t0.id WHERE t0.id = ?
Parameters:
[
  17
]
26 0.39 ms
SELECT t0.id AS id_1, t0.creux_gestoci AS creux_gestoci_2, t0.dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3, t0.creux_station AS creux_station_4, t0.dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5, t0.ecart AS ecart_6, t0.contre_plain AS contre_plain_7, t0.date_debut_depotage AS date_debut_depotage_8, t0.date_fin_depotage AS date_fin_depotage_9, t0.temps_depotage AS temps_depotage_10, t0.commentaire AS commentaire_11, t0.stock_avant_depotage AS stock_avant_depotage_12, t0.stock_apres_depotage AS stock_apres_depotage_13, t0.stock_theorique AS stock_theorique_14, t0.stock_reel AS stock_reel_15, t0.bon_de_livraison_id AS bon_de_livraison_id_16, t0.compartiment_id AS compartiment_id_17, t0.produit_id AS produit_id_18, t0.jaugeur_id AS jaugeur_id_19, t0.gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0.bon_de_livraison_id = ?
Parameters:
[
  3
]
27 0.22 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  1
]
28 0.26 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:
[
  6
]
29 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.differentiel_transport AS differentiel_transport_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.slug AS slug_8 FROM localite t0 WHERE t0.id = ?
Parameters:
[
  6
]
30 0.23 ms
SELECT t0.id AS id_1, t0.chauffeur AS chauffeur_2, t0.parking AS parking_3, t0.status AS status_4, t0.tractor_id AS tractor_id_5, t0.trailer_id AS trailer_id_6 FROM camion t0 WHERE t0.id = ?
Parameters:
[
  32
]
31 0.26 ms
SELECT t0.id AS id_1, t0.immatriculation AS immatriculation_2, t0.capacity AS capacity_3, t0.nbrcompatiment AS nbrcompatiment_4, t0.typeatelage AS typeatelage_5, t0.company AS company_6, t0.slug AS slug_7, t0.marque AS marque_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.tractor_id AS tractor_id_11, t0.carburant_id AS carburant_id_12 FROM trailer t0 WHERE t0.id = ?
Parameters:
[
  28
]
32 0.28 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.capacity AS capacity_3, t0.creux_certificat AS creux_certificat_4, t0.status AS status_5, t0.trailer_id AS trailer_id_6 FROM compartiment t0 WHERE t0.trailer_id = ?
Parameters:
[
  28
]
33 0.38 ms
SELECT t0.id AS id_1, t0.creux_gestoci AS creux_gestoci_2, t0.dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3, t0.creux_station AS creux_station_4, t0.dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5, t0.ecart AS ecart_6, t0.contre_plain AS contre_plain_7, t0.date_debut_depotage AS date_debut_depotage_8, t0.date_fin_depotage AS date_fin_depotage_9, t0.temps_depotage AS temps_depotage_10, t0.commentaire AS commentaire_11, t0.stock_avant_depotage AS stock_avant_depotage_12, t0.stock_apres_depotage AS stock_apres_depotage_13, t0.stock_theorique AS stock_theorique_14, t0.stock_reel AS stock_reel_15, t0.bon_de_livraison_id AS bon_de_livraison_id_16, t0.compartiment_id AS compartiment_id_17, t0.produit_id AS produit_id_18, t0.jaugeur_id AS jaugeur_id_19, t0.gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0.bon_de_livraison_id = ?
Parameters:
[
  2
]
34 0.30 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.id = ?
Parameters:
[
  16
]
35 0.24 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:
[
  5
]
36 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.differentiel_transport AS differentiel_transport_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.slug AS slug_8 FROM localite t0 WHERE t0.id = ?
Parameters:
[
  7
]
37 0.45 ms
SELECT t0.id AS id_1, t0.creux_gestoci AS creux_gestoci_2, t0.dif_creux_certifier_vs_creux_gestoci AS dif_creux_certifier_vs_creux_gestoci_3, t0.creux_station AS creux_station_4, t0.dif_creux_gestoci_vs_creux_station AS dif_creux_gestoci_vs_creux_station_5, t0.ecart AS ecart_6, t0.contre_plain AS contre_plain_7, t0.date_debut_depotage AS date_debut_depotage_8, t0.date_fin_depotage AS date_fin_depotage_9, t0.temps_depotage AS temps_depotage_10, t0.commentaire AS commentaire_11, t0.stock_avant_depotage AS stock_avant_depotage_12, t0.stock_apres_depotage AS stock_apres_depotage_13, t0.stock_theorique AS stock_theorique_14, t0.stock_reel AS stock_reel_15, t0.bon_de_livraison_id AS bon_de_livraison_id_16, t0.compartiment_id AS compartiment_id_17, t0.produit_id AS produit_id_18, t0.jaugeur_id AS jaugeur_id_19, t0.gerant_id AS gerant_id_20 FROM detail_bon_de_livraison t0 WHERE t0.bon_de_livraison_id = ?
Parameters:
[
  1
]
38 0.34 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.id = ?
Parameters:
[
  19
]

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\Chargement\DetailBonDeLivraison 20
App\Entity\Domain\Flotte\Compartiment 18
App\Entity\Admin\RolePermission 9
App\Entity\Admin\Permission 9
App\Entity\Admin\User 6
App\Entity\Domain\Chargement\BonDeLivraison 4
App\Entity\Domain\Chargement\StationService 3
App\Entity\Domain\Flotte\Camion 3
App\Entity\Domain\System\Localite 3
App\Entity\Domain\Flotte\Trailer 3
App\Entity\Domain\Params\Produit 2
App\Entity\Domain\Flotte\Tractor 2
App\Entity\Domain\Chargement\LieuEmpotage 1
App\Entity\Admin\Role 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\Admin\RolePermission No errors.
App\Entity\Admin\Permission No errors.
App\Entity\Domain\Flotte\Camion No errors.
App\Entity\Domain\System\Parking 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\Flotte\Tractor No errors.
App\Entity\Domain\Flotte\Trailer No errors.
App\Entity\Domain\Params\Produit No errors.
App\Entity\Domain\Flotte\Compartiment No errors.
App\Entity\Domain\Params\PrixProduit No errors.