Query Metrics
6
Database Queries
6
Different statements
3.02 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.12 ms (37.24%) |
1 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||
|
0.63 ms (20.82%) |
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.address AS address_18, t0.contact_livraison AS contact_livraison_19, t0.delivery_fee_manual AS delivery_fee_manual_20, t0.delivery_fee_note AS delivery_fee_note_21, t0.locked_by_userd_id AS locked_by_userd_id_22, t0.locked_at AS locked_at_23, t0.compte_commercial_id AS compte_commercial_id_24, t25.id AS id_26, t25.name AS name_27, t25.commerciaux AS commerciaux_28, t25.affecte_a AS affecte_a_29, t25.type AS type_30, t25.status AS status_31, t25.interet AS interet_32, t25.tag_prioriry AS tag_prioriry_33, t25.email AS email_34, t25.telephone AS telephone_35, t25.mobile AS mobile_36, t25.adresse AS adresse_37, t25.adresse_old AS adresse_old_38, t25.adresse_complement AS adresse_complement_39, t25.adresse_rue AS adresse_rue_40, t25.adresse_cp AS adresse_cp_41, t25.adresse_ville AS adresse_ville_42, t25.remarques AS remarques_43, t25.tag_sector AS tag_sector_44, t25.my_group AS my_group_45, t25.site_web AS site_web_46, t25.pays AS pays_47, t25.region AS region_48, t25.origine AS origine_49, t25.effectifs AS effectifs_50, t25.fichier AS fichier_51, t25.tag_main_product AS tag_main_product_52, t25.tag_deals_part AS tag_deals_part_53, t25.agent AS agent_54, t25.commentaires AS commentaires_55, t25.commercial_local AS commercial_local_56, t25.commercial_sav AS commercial_sav_57, t25.commercial_service AS commercial_service_58, t25.opportunites_en_cours AS opportunites_en_cours_59, t25.id_monday AS id_monday_60, t25.monday_board_id AS monday_board_id_61, t25.type_index AS type_index_62, t25.qualification_index AS qualification_index_63, t25.secteur1_index AS secteur1_index_64, t25.secteur2_index AS secteur2_index_65, t25.secteur3_index AS secteur3_index_66, t25.groupe_id AS groupe_id_67, t25.pays_dropdown_id AS pays_dropdown_id_68, t25.effectifs_id AS effectifs_id_69, t25.reservation_honor_index AS reservation_honor_index_70, t25.teleprospection_index AS teleprospection_index_71, t25.reseaux_index AS reseaux_index_72, t25.upload_pipeline_index AS upload_pipeline_index_73 FROM devis t0 LEFT JOIN compte_commerciaux t25 ON t0.compte_commercial_id = t25.id WHERE t0.id = ?
Parameters:
[
551
]
|
||||||||||||||||||||||||||
|
0.44 ms (14.52%) |
1 |
SELECT t0.id AS id_1, t0.delivery_rate_percent AS delivery_rate_percent_2, t0.enabled AS enabled_3, t0.delivery_article_id AS delivery_article_id_4, t5.id AS id_6, t5.name AS name_7, t5.designation AS designation_8, t5.fabricant AS fabricant_9, t5.reference_fabricant AS reference_fabricant_10, t5.type AS type_11, t5.prf AS prf_12, t5.unite_de_prix AS unite_de_prix_13, t5.date_validite_tarif AS date_validite_tarif_14, t5.code_tarif AS code_tarif_15, t5.code_douanier AS code_douanier_16, t5.dimentions AS dimentions_17, t5.poids AS poids_18, t5.pays_origine AS pays_origine_19, t5.numero_magasin AS numero_magasin_20, t5.emplacement_magasin AS emplacement_magasin_21, t5.created_at AS created_at_22, t5.image AS image_23, t5.id_monday AS id_monday_24, t5.updated_at AS updated_at_25, t5.updated_by AS updated_by_26, t5.coeff_prix_id AS coeff_prix_id_27 FROM commercial_setting t0 INNER JOIN article t5 ON t0.delivery_article_id = t5.id LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||
|
0.37 ms (12.17%) |
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:
[
4
]
|
||||||||||||||||||||||||||
|
0.33 ms (10.88%) |
1 |
UPDATE devis SET locked_by_userd_id = ?, locked_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ null null "2026-01-27 17:13:27" 551 ]
|
||||||||||||||||||||||||||
|
0.13 ms (4.37%) |
1 |
"START TRANSACTION"
Parameters:
[]
|
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\Devis | 1 |
| App\Entity\CompteCommerciaux | 1 |
| App\Entity\CommercialSetting | 1 |
| App\Entity\Article | 1 |
| App\Entity\CoeffPrix | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Devis | No errors. |
| App\Entity\CompteCommerciaux | No errors. |
| App\Entity\DevisLigne | No errors. |
| App\Entity\BonDeLivraison | No errors. |
| App\Entity\CommercialSetting | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\CoeffPrix | No errors. |