POST https://pciservice.fr/admin/devis/deverrouiller-pr/551

Query Metrics

6 Database Queries
6 Different statements
3.02 ms Query time
0 Invalid entities
6 Managed entities

Grouped Statements

Show all queries

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.