https://tracking.afisarl.com/tracking/query Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
419.43 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
418.85 ms
(99.86%)
1
SELECT t0.id AS id_1, t0.date_chargement AS date_chargement_2, t0.date_depart AS date_depart_3, t0.date_arriver AS date_arriver_4, t0.date_operation AS date_operation_5, t0.nom_bateau AS nom_bateau_6, t0.id_ag AS id_ag_7, t0.flag AS flag_8, t0.numero_contenaire AS numero_contenaire_9, t0.transporteur AS transporteur_10, t0.complet_flag AS complet_flag_11, t0.proprietaire_conteneur AS proprietaire_conteneur_12, t0.destination AS destination_13, t0.validation AS validation_14, t0.depenses_prevue AS depenses_prevue_15, t0.remarque_conteneur AS remarque_conteneur_16, t0.is_mco AS is_mco_17, t0.is_rapport AS is_rapport_18, t0.date_rapport_at AS date_rapport_at_19, t0.is_clients AS is_clients_20, t0.rapport AS rapport_21, t0.id_ct_id AS id_ct_id_22, t0.id_ville_id AS id_ville_id_23, t0.ville_initiale_id AS ville_initiale_id_24 FROM programme_contenaire t0 WHERE t0.numero_contenaire = ? LIMIT 1
Parameters:
[
  "PCIU9356137"
]
0.36 ms
(0.09%)
1
SELECT t0.id AS id_1, t0.lieu AS lieu_2, t0.id_position AS id_position_3, t0.date_operation AS date_operation_4, t0.position_actuelle_flag AS position_actuelle_flag_5, t0.id_ct_pr_id AS id_ct_pr_id_6 FROM suivi_contenaire t0 WHERE t0.id_ct_pr_id = ?
Parameters:
[
  4640
]
0.22 ms
(0.05%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.commentaire AS commentaire_3, t0.suivi_id AS suivi_id_4, t0.sous_position_id AS sous_position_id_5 FROM sous_suivi t0 WHERE t0.suivi_id = ?
Parameters:
[
  6019
]

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\ProgrammeContenaire
  • The mappings App\Entity\ProgrammeContenaire#commandes and App\Entity\Commande#IdCtPr are inconsistent with each other.
App\Entity\Contenaire No errors.
App\Entity\Ville No errors.
App\Entity\SuiviContenaire No errors.
App\Entity\DepensesContenaire No errors.
App\Entity\Declarant No errors.
App\Entity\Commande
  • The mappings App\Entity\Commande#IdCl and App\Entity\Agent#agent are inconsistent with each other.
  • The association App\Entity\Commande#IdCtPr refers to the inverse side field App\Entity\ProgrammeContenaire#$commandes which does not exist.
App\Entity\RemarqueConteneur No errors.
App\Entity\Notification No errors.
App\Entity\TmpConteneurReception No errors.
App\Entity\SousSuivi No errors.
App\Entity\SousPosition No errors.