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
16
19
4
3
790
0.00
2
11
select
documentnf0_.cnpj_issuer as cnpj_iss1_12_, documentnf0_.type as type2_12_, documentnf0_.key as key3_12_, documentnf0_.nsu as nsu4_12_, documentnf0_.protocol as protocol5_12_, documentnf0_.addressee_name as addresse6_12_, documentnf0_.available_at as availabl7_12_, documentnf0_.bcicms as bcicms8_12_, documentnf0_.bcicmsst as bcicmsst9_12_, documentnf0_.canceled_at as cancele10_12_, documentnf0_.cce_events as cce_eve11_12_, documentnf0_.cnpj as cnpj12_12_, documentnf0_.cnpj_addressee as cnpj_ad13_12_, documentnf0_.cnpj_carrier as cnpj_ca14_12_, documentnf0_.data_emissao as data_em15_12_, documentnf0_.issuer_name as issuer_16_12_, documentnf0_.model as model17_12_, documentnf0_.name_file as name_fi18_12_, documentnf0_.nfe_number as nfe_num19_12_, documentnf0_.receiveruf as receive20_12_, documentnf0_.serie_number as serie_n21_12_, documentnf0_.status as status22_12_, documentnf0_.v_cofins as v_cofin23_12_, documentnf0_.vicms as vicms24_12_, documentnf0_.vipi as vipi25_12_, documentnf0_.v_other as v_other26_12_, documentnf0_.vpis as vpis27_12_, documentnf0_.v_prod as v_prod28_12_, documentnf0_.vst as vst29_12_, documentnf0_.value as value30_12_
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
11
2
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
2
3
0
0.00
Find usages