Return Return     Main page Main page      Update Update     PDF PDF     Online help Online help     Monitoring with a Rich Desktop Application Desktop     Choice of period :  Day Day  Week Week  Month Month  Year Year  All All  Customized Customized


           (m/d/yy)     



Request Hits by parent request Mean time (ms)Max time (ms) Standard deviationMean cpu time (ms) Mean allocated Kb % of system error Mean hits sql Mean time sql (ms)
spring  ChecagemAliquotaIcmsQueryService.findChecagemAliquotaIcmsByCnpjDestinatario  1,079 1,233 159 0 30 0.00 1 1,077
sql  graphselect checagemal0_.id as id1_33_, checagemal0_.aliquota_icms_nfe as aliquota2_33_, checagemal0_.aliquota_tabela as aliquota3_33_, checagemal0_.cfop_produto as cfop_pro4_33_, checagemal0_.chave_nota as chave_no5_33_, checagemal0_.id_consolidacao as id_cons24_33_, checagemal0_.cnpj_destinatario as cnpj_des6_33_, checagemal0_.cnpj_emitente as cnpj_emi7_33_, checagemal0_.codigo_produto as codigo_p8_33_, checagemal0_.cst as cst9_33_, checagemal0_.data_emissao as data_em10_33_, checagemal0_.descricao_produto as descric11_33_, checagemal0_.destinatario as destina12_33_, checagemal0_.diferenca_imposto as diferen13_33_, checagemal0_.emitente as emitent14_33_, checagemal0_.ncm_produto as ncm_pro15_33_, checagemal0_.numero_nota as numero_16_33_, checagemal0_.origem as origem17_33_, checagemal0_.periodo as periodo18_33_, checagemal0_.uf_destinatario as uf_dest19_33_, checagemal0_.uf_emitente as uf_emit20_33_, checagemal0_.valor_base_calculo as valor_b21_33_, checagemal0_.valor_icms_calculado as valor_i22_33_, checagemal0_.valor_icms_xml as valor_i23_33_ from checagem_aliquota_icms checagemal0_ cross join public.cnpj_consolidation cnpjconsol1_ where checagemal0_.id_consolidacao=cnpjconsol1_.id and checagemal0_.data_emissao<=? and checagemal0_.data_emissao>=? and cnpjconsol1_.cnpj=? order by checagemal0_.id desc limit ?
 1.00 2,078 4,921 1,691     0.00    
Find usages Find usages