Query Metrics
5
Database Queries
5
Different statements
7.04 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.27 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_first_connexion AS is_first_connexion_5, t0.compte_id AS compte_id_6, t0.client_id AS client_id_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
190
]
|
2 | 1.49 ms |
SELECT t0.id AS id_1, t0.nombre_colis_total AS nombre_colis_total_2, t0.numero_dae AS numero_dae_3, t0.assurance_livraison AS assurance_livraison_4, t0.emballage_livraison AS emballage_livraison_5, t0.fichier_facture AS fichier_facture_6, t0.numero_facture AS numero_facture_7, t0.montant_total_facture AS montant_total_facture_8, t0.date_debut_fenetre AS date_debut_fenetre_9, t0.date_fin_fenetre AS date_fin_fenetre_10, t0.date_commande_soumission AS date_commande_soumission_11, t0.code_postal_livraison AS code_postal_livraison_12, t0.ville_livraison AS ville_livraison_13, t0.adresse_livraison AS adresse_livraison_14, t0.complement_adresse_livraison AS complement_adresse_livraison_15, t0.etat_us AS etat_us_16, t0.state AS state_17, t0.observation AS observation_18, t0.province AS province_19, t0.nombre_bouteille_rouge AS nombre_bouteille_rouge_20, t0.nombre_bouteille_blanc AS nombre_bouteille_blanc_21, t0.nombre_bouteille_petillant AS nombre_bouteille_petillant_22, t0.token AS token_23, t0.fedex_pdf_generated AS fedex_pdf_generated_24, t0.is_temporaire AS is_temporaire_25, t0.is_validee_par_client AS is_validee_par_client_26, t0.commande_massive AS commande_massive_27, t0.date_collecte AS date_collecte_28, t0.nombre_magnum_rouge AS nombre_magnum_rouge_29, t0.nombre_magnum_blanc AS nombre_magnum_blanc_30, t0.nombre_magnum_petillant AS nombre_magnum_petillant_31, t0.tracking_number AS tracking_number_32, t0.fedex_pdf_available AS fedex_pdf_available_33, t0.ship_date AS ship_date_34, t0.prior_url AS prior_url_35, t0.type_emballage AS type_emballage_36, t0.individual_tracking_numbers AS individual_tracking_numbers_37, t0.fast_pickup AS fast_pickup_38, t0.fichier_facture_pro_forma AS fichier_facture_pro_forma_39, t0.pro_forma AS pro_forma_40, t0.dap AS dap_41, t0.service_priority AS service_priority_42, t0.client_id AS client_id_43, t0.client_final_id AS client_final_id_44 FROM commande t0 WHERE t0.id = ?
Parameters:
[
"7771"
]
|
3 | 1.59 ms |
SELECT c0_.id AS id_0, c0_.nombre_bouteille AS nombre_bouteille_1, c0_.commande_id AS commande_id_2 FROM colis c0_ WHERE c0_.commande_id = ?
Parameters:
[
7771
]
|
4 | 1.20 ms |
SELECT t0.id AS id_1, t0.raison_sociale AS raison_sociale_2, t0.id_client_mbehub AS id_client_mbehub_3, t0.nom_contact AS nom_contact_4, t0.prenom_contact AS prenom_contact_5, t0.email_contact AS email_contact_6, t0.telephone_contact AS telephone_contact_7, t0.assurance_defaut AS assurance_defaut_8, t0.emballage_defaut AS emballage_defaut_9, t0.code_postal AS code_postal_10, t0.ville AS ville_11, t0.adresse AS adresse_12, t0.eori AS eori_13, t0.fast_pickup AS fast_pickup_14, t15.id AS id_16, t15.email AS email_17, t15.roles AS roles_18, t15.password AS password_19, t15.is_first_connexion AS is_first_connexion_20, t15.compte_id AS compte_id_21, t15.client_id AS client_id_22 FROM client t0 LEFT JOIN user t15 ON t15.client_id = t0.id WHERE t0.id = ?
Parameters:
[
373
]
|
5 | 1.49 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.telephone AS telephone_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.full_name AS full_name_6, t7.id AS id_8, t7.nombre_colis_total AS nombre_colis_total_9, t7.numero_dae AS numero_dae_10, t7.assurance_livraison AS assurance_livraison_11, t7.emballage_livraison AS emballage_livraison_12, t7.fichier_facture AS fichier_facture_13, t7.numero_facture AS numero_facture_14, t7.montant_total_facture AS montant_total_facture_15, t7.date_debut_fenetre AS date_debut_fenetre_16, t7.date_fin_fenetre AS date_fin_fenetre_17, t7.date_commande_soumission AS date_commande_soumission_18, t7.code_postal_livraison AS code_postal_livraison_19, t7.ville_livraison AS ville_livraison_20, t7.adresse_livraison AS adresse_livraison_21, t7.complement_adresse_livraison AS complement_adresse_livraison_22, t7.etat_us AS etat_us_23, t7.state AS state_24, t7.observation AS observation_25, t7.province AS province_26, t7.nombre_bouteille_rouge AS nombre_bouteille_rouge_27, t7.nombre_bouteille_blanc AS nombre_bouteille_blanc_28, t7.nombre_bouteille_petillant AS nombre_bouteille_petillant_29, t7.token AS token_30, t7.fedex_pdf_generated AS fedex_pdf_generated_31, t7.is_temporaire AS is_temporaire_32, t7.is_validee_par_client AS is_validee_par_client_33, t7.commande_massive AS commande_massive_34, t7.date_collecte AS date_collecte_35, t7.nombre_magnum_rouge AS nombre_magnum_rouge_36, t7.nombre_magnum_blanc AS nombre_magnum_blanc_37, t7.nombre_magnum_petillant AS nombre_magnum_petillant_38, t7.tracking_number AS tracking_number_39, t7.fedex_pdf_available AS fedex_pdf_available_40, t7.ship_date AS ship_date_41, t7.prior_url AS prior_url_42, t7.type_emballage AS type_emballage_43, t7.individual_tracking_numbers AS individual_tracking_numbers_44, t7.fast_pickup AS fast_pickup_45, t7.fichier_facture_pro_forma AS fichier_facture_pro_forma_46, t7.pro_forma AS pro_forma_47, t7.dap AS dap_48, t7.service_priority AS service_priority_49, t7.client_id AS client_id_50, t7.client_final_id AS client_final_id_51 FROM client_final t0 LEFT JOIN commande t7 ON t7.client_final_id = t0.id WHERE t0.id = ?
Parameters:
[
10281
]
|
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\Compte | No errors. |
App\Entity\Client | No errors. |
App\Entity\StockBandeau | No errors. |
App\Entity\Commande | No errors. |
App\Entity\ClientFinal | No errors. |
App\Entity\Colis | No errors. |