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)
DocumentNfeOuroViewQueryService.findDocumentNfeOuro
9
36
10
1
296
0.00
1
6
select
documentnf0_.cnpj_issuer as cnpj_iss1_14_, documentnf0_.type as type2_14_, documentnf0_.key as key3_14_, documentnf0_.nsu as nsu4_14_, documentnf0_.protocol as protocol5_14_, documentnf0_.aliquota_cfem as aliquota6_14_, documentnf0_.aliquota_iof as aliquota7_14_, documentnf0_.cnpj_vendedor as cnpj_ven8_14_, documentnf0_.data_competencia as data_com9_14_, documentnf0_.data_emissao as data_em10_14_, documentnf0_.nome_emitente as nome_em11_14_, documentnf0_.nome_vendedor as nome_ve12_14_, documentnf0_.status as status13_14_, documentnf0_.tipo_operacao as tipo_op14_14_, documentnf0_.uf_emitente as uf_emit15_14_, documentnf0_.uf_vendedor as uf_vend16_14_, documentnf0_.valor_cfem as valor_c17_14_, documentnf0_.valor_iof as valor_i18_14_, documentnf0_.valor_liquido_nfe_ouro as valor_l19_14_, documentnf0_.valor_total_nfe_ouro as valor_t20_14_, documentnf0_.valor_total_quantidade_ouro_liquido as valor_t21_14_
from
public.document_nfe_ouro_view documentnf0_
where
documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.cnpj_issuer=?
order by
documentnf0_.data_emissao desc limit ?
1.00
6
27
7
0.00
select
count(*) as col_0_0_
from
public.document_nfe_ouro_view documentnf0_
where
documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.cnpj_issuer=?
0.11
3
3
0
0.00
Find usages