POST https://pciservice.fr/get_last_article_row

Query Metrics

4 Database Queries
4 Different statements
2.02 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.44 ms
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:
[
  11
]
2 0.67 ms
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:
[
  604
]
3 0.60 ms
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.devis_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  604
]
4 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.coefficient AS coefficient_3 FROM coeff_prix t0
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\CoeffPrix 10
App\Entity\User 1
App\Entity\Devis 1
App\Entity\CompteCommerciaux 1
App\Entity\DevisLigne 1
App\Entity\Article 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\Article No errors.
App\Entity\CoeffPrix No errors.
App\Entity\BonDeLivraisonLigne No errors.