Return
Main page
Update
PDF
Online help
Desktop
Choice of period :
Day
Week
Month
Year
All
Customized
From
to
(m/d/yy)
Request
Hits by parent request
Mean time (ms)
Max time (ms)
Standard deviation
Mean cpu time (ms)
Mean allocated Kb
% of system error
Mean hits sql
Mean time sql (ms)
DocumentNfeViewQueryService.findByKey
69
150
69
1
210
0.00
1
63
select
documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_
from
public.document_nfe_view documentnf0_
where
documentnf0_.key=? and (documentnf0_.type in (? , ? , ? , ?)) and (documentnf0_.data_emissao between ? and ?)
1.00
63
142
68
0.00
Find usages