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

Query Metrics

35 Database Queries
5 Different statements
11.88 ms Query time
3 Invalid entities
65 Managed entities

Queries

Group similar statements

# Time Info
1 1.02 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:
[
  "dzebada@sifogroup.com"
]
2 1.43 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:
[
  18
]
3 0.43 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:
[
  3
]
4 0.27 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.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:
[
  44
]
6 2.31 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.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:
[
  48
]
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.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:
[
  75
]
10 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:
[
  76
]
11 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:
[
  78
]
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:
[
  79
]
13 0.18 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:
[
  80
]
14 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:
[
  81
]
15 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:
[
  82
]
16 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:
[
  89
]
17 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:
[
  90
]
18 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:
[
  92
]
19 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:
[
  93
]
20 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:
[
  108
]
21 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:
[
  109
]
22 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:
[
  111
]
23 0.18 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:
[
  112
]
24 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:
[
  153
]
25 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:
[
  154
]
26 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:
[
  155
]
27 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:
[
  61
]
28 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:
[
  62
]
29 0.18 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:
[
  63
]
30 0.18 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:
[
  64
]
31 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:
[
  65
]
32 0.18 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:
[
  66
]
33 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:
[
  67
]
34 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:
[
  68
]
35 0.74 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, s1_.id AS id_31, s1_.libelle AS libelle_32, s1_.ref_client AS ref_client_33, s1_.latitude AS latitude_34, s1_.longitude AS longitude_35, s1_.created_at AS created_at_36, s1_.updated_at AS updated_at_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, s1_.localite_id AS localite_id_43 FROM bon_de_livraison b0_ LEFT JOIN station_service s1_ ON b0_.station_service_id = s1_.id WHERE b0_.isdraft = 0 AND b0_.granted = 1 AND s1_.id = ? AND b0_.isdepoted = 1 AND b0_.is_validated = 0 ORDER BY b0_.created_at DESC
Parameters:
[
  4
]

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\Admin\RolePermission 31
App\Entity\Admin\Permission 31
App\Entity\Admin\User 1
App\Entity\Domain\Chargement\StationService 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\Localite No errors.