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)
DocumentNfceViewQueryService.findDocumentWithData
18
18
0
8
2,197
0.00
2
11
select
documentnf0_.cnpj_issuer as cnpj_iss1_11_, documentnf0_.type as type2_11_, documentnf0_.key as key3_11_, documentnf0_.nsu as nsu4_11_, documentnf0_.protocol as protocol5_11_, documentnf0_.addressee_name as addresse6_11_, documentnf0_.available_at as availabl7_11_, documentnf0_.bcicms as bcicms8_11_, documentnf0_.bcicmsst as bcicmsst9_11_, documentnf0_.canceled_at as cancele10_11_, documentnf0_.cce_events as cce_eve11_11_, documentnf0_.cnpj as cnpj12_11_, documentnf0_.cnpj_addressee as cnpj_ad13_11_, documentnf0_.cnpj_carrier as cnpj_ca14_11_, documentnf0_.data_emissao as data_em15_11_, documentnf0_.issuer_name as issuer_16_11_, documentnf0_.model as model17_11_, documentnf0_.name_file as name_fi18_11_, documentnf0_.nfe_number as nfe_num19_11_, documentnf0_.receiveruf as receive20_11_, documentnf0_.serie_number as serie_n21_11_, documentnf0_.status as status22_11_, documentnf0_.v_cofins as v_cofin23_11_, documentnf0_.vicms as vicms24_11_, documentnf0_.vipi as vipi25_11_, documentnf0_.v_other as v_other26_11_, documentnf0_.vpis as vpis27_11_, documentnf0_.v_prod as v_prod28_11_, documentnf0_.vst as vst29_11_, documentnf0_.value as value30_11_
from
public.document_nfce_view documentnf0_
where
documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=?
order by
documentnf0_.data_emissao desc limit ?
1.00
8
8
0
0.00
select
documentwi0_.key as key3_4_, documentwi0_.data as data10_4_, documentwi0_.data_emissao as data_em11_4_, documentwi0_.type as type2_4_
from
public.document documentwi0_
where
(documentwi0_.key in (?)) and (documentwi0_.type in (? , ? , ?)) and (documentwi0_.data_emissao between ? and ?)
1.00
3
3
0
0.00
Find usages