GET https://lims.kudzuscience.com/operateur/show/commande/detail/698

Query Metrics

10 Database Queries
9 Different statements
5.39 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.status AS status_7, t0.is_verified AS is_verified_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  6
]
2 1.77 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.numero AS numero_3, t0.code AS code_4, t0.ref_client AS ref_client_5, t0.numero_expedition AS numero_expedition_6, t0.a_facturer AS a_facturer_7, t0.facture_num AS facture_num_8, t0.devis_num AS devis_num_9, t0.paiement_en_attente AS paiement_en_attente_10, t0.facture_dans_colis AS facture_dans_colis_11, t0.commentaire AS commentaire_12, t0.create_by_id AS create_by_id_13, t0.client_id AS client_id_14, t0.adresse_id AS adresse_id_15, t0.transporteur_id AS transporteur_id_16, t0.statut_id AS statut_id_17 FROM commande t0 WHERE t0.id = ?
Parameters:
[
  "698"
]
3 0.43 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.position AS position_3 FROM kit_statut t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.27 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM transporteur t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.32 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.ref_client_dolibarr AS ref_client_dolibarr_3, t0.societe AS societe_4, t0.nom AS nom_5, t0.prenom AS prenom_6 FROM client t0 WHERE t0.id = ?
Parameters:
[
  392
]
6 0.34 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.adresse AS adresse_4, t0.cp AS cp_5, t0.ville AS ville_6, t0.pays AS pays_7, t0.is_facturation AS is_facturation_8, t0.livraison_default AS livraison_default_9, t0.societe AS societe_10, t0.client_id AS client_id_11 FROM adresse t0 WHERE t0.id = ?
Parameters:
[
  429
]
7 0.56 ms
SELECT t0.id AS id_1, t0.blacklisted AS blacklisted_2, t0.blacklisted_commentaire AS blacklisted_commentaire_3, t0.codekit AS codekit_4, t0.numero_retour AS numero_retour_5, t0.delai AS delai_6, t0.cofrac AS cofrac_7, t0.commentaire AS commentaire_8, t0.prep_date AS prep_date_9, t0.prelev_start_date AS prelev_start_date_10, t0.prelev_end_date AS prelev_end_date_11, t0.recpt_date AS recpt_date_12, t0.rapport_deadline AS rapport_deadline_13, t0.recpt_commentaire AS recpt_commentaire_14, t0.ncr AS ncr_15, t0.ncr_ref AS ncr_ref_16, t0.rapport_signe AS rapport_signe_17, t0.format AS format_18, t0.prelev_piece_text AS prelev_piece_text_19, t0.prelev_temp AS prelev_temp_20, t0.prelev_filtration_mol AS prelev_filtration_mol_21, t0.prelev_nature AS prelev_nature_22, t0.prelev_traitement AS prelev_traitement_23, t0.prelev_quantite AS prelev_quantite_24, t0.prelev_long AS prelev_long_25, t0.prelev_couleur AS prelev_couleur_26, t0.prelev_prox_cultures AS prelev_prox_cultures_27, t0.prelev_expo_pro AS prelev_expo_pro_28, t0.prelev_pest_dom AS prelev_pest_dom_29, t0.facture_num AS facture_num_30, t0.rapport_email AS rapport_email_31, t0.kit_type_id AS kit_type_id_32, t0.statut_id AS statut_id_33, t0.prep_user_id AS prep_user_id_34, t0.recpt_user_id AS recpt_user_id_35, t0.commande_id AS commande_id_36, t0.prelev_piece_id AS prelev_piece_id_37 FROM kit t0 WHERE t0.commande_id = ?
Parameters:
[
  698
]
8 0.31 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.position AS position_3 FROM kit_statut t0 WHERE t0.id = ?
Parameters:
[
  9
]
9 0.39 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.rapport_type AS rapport_type_3, t0.delai AS delai_4, t0.code AS code_5, t0.code_old AS code_old_6, t0.ref_dolibarr AS ref_dolibarr_7, t0.delai_express AS delai_express_8, t0.active AS active_9, t0.prelev_end_date AS prelev_end_date_10, t0.prelev_lieu AS prelev_lieu_11, t0.prelev_temp AS prelev_temp_12, t0.prelev_pesticides AS prelev_pesticides_13, t0.category_id AS category_id_14 FROM kit_type t0 WHERE t0.id = ?
Parameters:
[
  25
]
10 0.48 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_badge AS numero_badge_3 FROM support t0 INNER JOIN kit_type_support ON t0.id = kit_type_support.support_id WHERE kit_type_support.kit_type_id = ?
Parameters:
[
  25
]

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\User No errors.
App\Entity\Commande No errors.
App\Entity\Client No errors.
App\Entity\Adresse No errors.
App\Entity\Transporteur No errors.
App\Entity\KitStatut No errors.
App\Entity\Kit No errors.
App\Entity\KitType No errors.
App\Entity\PiecePrelevt No errors.
App\Entity\Echantillon No errors.
App\Entity\Rapport No errors.
App\Entity\KitCategory No errors.
App\Entity\Molecule No errors.
App\Entity\Support No errors.
App\Entity\MoleculeCategory No errors.
App\Entity\Lot No errors.