Query Metrics
5
Database Queries
5
Different statements
2.86 ms
Query time
0
Invalid entities
8
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.74 ms (25.73%) |
1 |
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.total_ligne AS total_ligne_3, t0.prix_unitaire AS prix_unitaire_4, t0.fully_delivered AS fully_delivered_5, t0.quantite_restante_alivrer AS quantite_restante_alivrer_6, t0.partially_delivered AS partially_delivered_7, t0.delai AS delai_8, t0.commentaire AS commentaire_9, t0.designation AS designation_10, t0.code_article AS code_article_11, t0.prf AS prf_12, t0.devis_id AS devis_id_13, t0.article_id AS article_id_14, t15.id AS id_16, t15.name AS name_17, t15.designation AS designation_18, t15.fabricant AS fabricant_19, t15.reference_fabricant AS reference_fabricant_20, t15.type AS type_21, t15.prf AS prf_22, t15.unite_de_prix AS unite_de_prix_23, t15.date_validite_tarif AS date_validite_tarif_24, t15.code_tarif AS code_tarif_25, t15.code_douanier AS code_douanier_26, t15.dimentions AS dimentions_27, t15.poids AS poids_28, t15.pays_origine AS pays_origine_29, t15.numero_magasin AS numero_magasin_30, t15.emplacement_magasin AS emplacement_magasin_31, t15.created_at AS created_at_32, t15.image AS image_33, t15.id_monday AS id_monday_34, t15.updated_at AS updated_at_35, t15.updated_by AS updated_by_36, t15.coeff_prix_id AS coeff_prix_id_37, t0.coeff_prix_id AS coeff_prix_id_38 FROM devis_ligne t0 INNER JOIN article t15 ON t0.article_id = t15.id WHERE t0.id = ?
Parameters:
[
347
]
|
0.68 ms (23.85%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.reference AS reference_3, t0.total_ht AS total_ht_4, t0.updated_at AS updated_at_5, t0.remise_commerciale AS remise_commerciale_6, t0.remise_en_p100 AS remise_en_p100_7, t0.version AS version_8, t0.description AS description_9, t0.numero_dossier AS numero_dossier_10, t0.id_monday AS id_monday_11, t0.contact_name AS contact_name_12, t0.contact_email AS contact_email_13, t0.contact_phone_number AS contact_phone_number_14, t0.contact_mobile_number AS contact_mobile_number_15, t0.item_id_monday AS item_id_monday_16, t0.adresse_livraison AS adresse_livraison_17, t0.compte_commercial_id AS compte_commercial_id_18, t19.id AS id_20, t19.name AS name_21, t19.commerciaux AS commerciaux_22, t19.affecte_a AS affecte_a_23, t19.type AS type_24, t19.status AS status_25, t19.interet AS interet_26, t19.tag_prioriry AS tag_prioriry_27, t19.email AS email_28, t19.telephone AS telephone_29, t19.mobile AS mobile_30, t19.adresse AS adresse_31, t19.adresse_old AS adresse_old_32, t19.adresse_complement AS adresse_complement_33, t19.adresse_rue AS adresse_rue_34, t19.adresse_cp AS adresse_cp_35, t19.adresse_ville AS adresse_ville_36, t19.remarques AS remarques_37, t19.tag_sector AS tag_sector_38, t19.my_group AS my_group_39, t19.site_web AS site_web_40, t19.pays AS pays_41, t19.region AS region_42, t19.origine AS origine_43, t19.effectifs AS effectifs_44, t19.fichier AS fichier_45, t19.tag_main_product AS tag_main_product_46, t19.tag_deals_part AS tag_deals_part_47, t19.agent AS agent_48, t19.commentaires AS commentaires_49, t19.commercial_local AS commercial_local_50, t19.commercial_sav AS commercial_sav_51, t19.commercial_service AS commercial_service_52, t19.opportunites_en_cours AS opportunites_en_cours_53, t19.id_monday AS id_monday_54 FROM devis t0 INNER JOIN compte_commerciaux t19 ON t0.compte_commercial_id = t19.id WHERE t0.id = ?
Parameters:
[
153
]
|
0.50 ms (17.60%) |
1 |
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_unitaire_livraison AS prix_unitaire_livraison_3, t0.designation_livree AS designation_livree_4, t0.code_article_livre AS code_article_livre_5, t0.bon_de_livraison_id AS bon_de_livraison_id_6, t0.devis_ligne_id AS devis_ligne_id_7 FROM bon_de_livraison_ligne t0 WHERE t0.bon_de_livraison_id = ?
Parameters:
[
77
]
|
0.48 ms (16.62%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.delivered AS delivered_3, t0.partially_delivered AS partially_delivered_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.version AS version_7, t0.adresse AS adresse_8, t0.info_commerciale AS info_commerciale_9, t0.contact AS contact_10, t0.delivery_mode AS delivery_mode_11, t0.devis_id AS devis_id_12 FROM bon_de_livraison t0 WHERE t0.id = ?
Parameters:
[
"77"
]
|
0.46 ms (16.20%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.service AS service_6, t0.phone AS phone_7 FROM user t0 WHERE t0.id = ?
Parameters:
[
9
]
|
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\User | 1 |
App\Entity\BonDeLivraison | 1 |
App\Entity\Devis | 1 |
App\Entity\CompteCommerciaux | 1 |
App\Entity\BonDeLivraisonLigne | 1 |
App\Entity\DevisLigne | 1 |
App\Entity\CoeffPrix | 1 |
App\Entity\Article | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User | No errors. |
App\Entity\BonDeLivraison | No errors. |
App\Entity\Devis | No errors. |
App\Entity\BonDeLivraisonLigne | No errors. |
App\Entity\CompteCommerciaux | No errors. |
App\Entity\DevisLigne | No errors. |
App\Entity\Article | No errors. |
App\Entity\CoeffPrix | No errors. |