A new version of JavaMelody is available (1.91.0 instead of 1.90.0, see Release Notes)

Statistics of JavaMelody monitoring taken at 9/9/25, 8:32 AM on _ip-10-0-9-71.ec2.internal (application)

Update     PDF     Online help     Desktop     Choice of period :  Day  Week  Month  Year  All  Customized

From     to      (m/d/yy)     

Other charts

Statistics http - 1 day since midnight

1,603 hits/min on 34 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean size (Kb)	Mean hits sql	Mean time sql (ms)
/api/cte/credito-pis-cofins-frete-insumo-aliquota-zero/{cnpj}/period GET	73	84,222	10	316	6	58	0	242	0.00	0	1	7
/api/document/{cnpj}/v2/nfe POST	9	223	508	14,563	1,729	8	17	5,912	0.00	71	2	482
/api/consumo-documentos-conta/ GET	6	60	1,302	4,198	487	11	79	25,939	1.67	0	0	1,228
/api/document/{cnpj}/analise-servico-tomado POST	3	244	200	961	231	0	1	500	0.00	0	1	195
/api/consumo-documentos-conta GET	2	59	608	4,931	728	0	5	1,148	0.00	0	1	596
/api/reports/nfe/{key} GET	1	78	201	1,592	184	11	63	31,383	7.69	12	2	126
/api/document/{cnpj}/analise-servico-prestado POST	0	26	297	1,037	325	0	2	505	0.00	0	1	291
/api/document/{cnpj}/v2/nfe-canhoto POST	0	14	544	6,390	1,684	0	11	3,770	0.00	47	2	524
/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST	0	48	91	360	111	0	1	599	0.00	0	1	86
/api/download/{cnpj}/solicitacoes GET	0	29	150	1,399	255	0	11	2,159	0.00	8	1	128
/api/document/{cnpj}/obrigacoes POST	0	4	965	1,751	647	0	7	1,193	0.00	5	2	952
/api/document/{cnpj}/v2/cte POST	0	41	67	275	65	0	9	2,535	0.00	49	2	50
/api/etiqueta/listar POST	0	40	51	534	79	1	12	1,652	0.00	1	1	3
/api/download/nfse/pdf-zip-online POST	0	3	655	1,305	562	0	65	7,703	0.00	15	2	230
/api/regularize/divida-ativa/{cnpj}/total POST	0	19	95	485	128	0	1	397	0.00	0	1	87
/actuator/health GET	0	321	5	88	8	0	1	88	0.00	0	0	0
/api/reports/cte/{key} GET	0	6	214	421	133	0	50	10,717	0.00	10	2	136
/api/feature-flag/todas GET	0	79	10	44	5	0	1	185	0.00	0	1	3
/api/comercial/total-oportunidade/{cnpj} POST	0	3	271	300	42	0	90	29,216	0.00	8	17	174
/api/document/{cnpj}/analise-compra-devolucao POST	0	4	188	531	244	0	3	936	0.00	0	1	179
/api/download/nfe/xml/{key} GET	0	11	64	224	54	0	4	471	0.00	4	2	50
/api/document/codigos-servicos-nfse POST	0	16	35	107	31	0	5	515	0.00	0	2	26
/api/document/{cnpj}/oportunidade-tese-juridica-consolidada-resumida POST	0	1	543	543	0	0	120	65,184	0.00	0	19	381
/api/document/{cnpj}/v2/nfse POST	0	17	30	111	29	0	6	1,274	0.00	7	1	12
/api/download-nfe-canhoto/{cnpj}/excel POST	0	1	481	481	0	0	150	26,878	0.00	0	8	178
/api/document/{cnpj}/analise-venda-devolucao POST	0	18	19	44	8	0	2	796	0.00	0	1	11
/api/importacao-canhoto/{cnpj}/lotes/{loteId}/canhotos GET	0	4	49	78	24	0	9	1,470	0.00	0	4	36
/api/download/cte/xml/{key} GET	0	6	30	52	12	0	8	1,035	0.00	4	2	13
/api/importacao-canhoto/{cnpj}/lotes POST	0	4	39	60	13	0	7	1,174	0.00	2	2	10
/api/document/{cnpj}/v2/nfce POST	0	3	25	31	5	0	6	1,323	0.00	0	2	14
/api/server/publico/version GET	0	94	0	13	1	0	0	55	0.00	0	0	0
Error404	0	17	2	4	0	0	1	320	100.00	0	0	0
/api/download-nfe/{cnpj}/excel POST	0	4	4	9	3	0	2	564	0.00	0	0	0
/api/document/{cnpj}/analise-representatividade-consolidada POST	0	1	9	9	0	0	6	755	100.00	0	0	0

Statistics sql - 1 day since midnight

1,608 hits/min on 111 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of system error
SELECT CAST(cte.data -> 'cte' -> 'infCte' -> 'ide' ->> 'nct' AS int8) AS numeroCte, cte.key AS chaveCte, nfe_info.numeroNfe, item.produto ->> 'chave' AS chaveNfe, CAST(cte.data -> 'cte' -> 'infCte' -> 'vprest' ->> 'vtPrest' AS numeric) AS valorPrestacao FROM document cte, jsonb_array_elements(cte.data -> 'cte' -> 'infCteNorm' -> 'infDoc' -> 'infNFe') WITH ORDINALITY item(produto), LATERAL ( SELECT DISTINCT CAST(nfe.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS int8) AS numeroNfe FROM document nfe, jsonb_array_elements(nfe.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item_nfe(produto_nfe) WHERE nfe.key = item.produto ->> 'chave' AND nfe.data_emissao BETWEEN ? AND ? AND nfe.type IN ('NFE_4_0', 'NFE_3_1', 'NFE_2_0') AND produto_nfe -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '06' AND produto_nfe -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '06' ) AS nfe_info WHERE cte.type = 'CTE' AND cte.cnpj_addressee = ? AND cte.data_emissao BETWEEN ? AND ? AND EXISTS ( SELECT 1 FROM document nfe, jsonb_array_elements(nfe.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item_nfe(produto_nfe) WHERE nfe.key = item.produto ->> 'chave' AND nfe.data_emissao BETWEEN ? AND ? AND nfe.type IN ('NFE_4_0', 'NFE_3_1', 'NFE_2_0') AND produto_nfe -> 'imposto' -> 'pis' -> 'pisAliq' ->> 'cst' = '06' AND produto_nfe -> 'imposto' -> 'cofins' -> 'cofinsAliq' ->> 'cst' = '06' ) limit ?	66	84,222	7	261	5	0.00
WITH empresasConta AS (SELECT cnpj FROM revizia_vw_resumo_conta_empresa WHERE conta_id = ?) SELECT c.* FROM consumo_documentos_conta_empresa c INNER JOIN empresasConta ec ON c.cnpj_empresa = ec.cnpj WHERE c.data_consumo BETWEEN ? AND ?	11	118	922	4,921	686	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.nfe_number=? and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	7	83	872	14,439	2,629	0.00
SELECT 'TOMADO' AS tipoServico, DATE_TRUNC('month', d.data_emissao) AS periodo, SUM(CAST(d.info ->> 'value' AS NUMERIC)) AS valor FROM document d WHERE d.group_type = 'NFSE' AND d.cnpj_addressee = ? AND (d.info ->> 'status' = 'NORMAL' OR d.info ->> 'status' = 'N') AND (? = 'nao_filtrar_ie' OR d.data -> 'nfe' -> 'infNFe' -> 'emit' ->> 'ie' =?) AND d.data_emissao between ? and ? GROUP BY DATE_TRUNC('month', d.data_emissao) ORDER BY DATE_TRUNC('month', d.data_emissao)	5	244	195	955	230	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	2	104	246	6,434	664	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ?))	0	78	114	363	70	0.00
SELECT 'PRESTADO' AS tipoServico, DATE_TRUNC('month', d.data_emissao) AS periodo, SUM(CAST(d.info ->> 'value' AS NUMERIC)) AS valor FROM document d WHERE d.group_type = 'NFSE' AND d.cnpj_issuer = ? AND (d.info ->> 'status' = 'NORMAL' OR d.info ->> 'status' = 'N') AND d.data_emissao between ? and ? GROUP BY DATE_TRUNC('month', d.data_emissao) ORDER BY DATE_TRUNC('month', d.data_emissao)	0	26	291	1,031	324	0.00
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_.canceled_at as canceled8_12_, documentnf0_.canhoto_associado_at as canhoto_9_12_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_12_, documentnf0_.canhoto_id as canhoto11_12_, documentnf0_.canhoto_numero_nota as canhoto12_12_, documentnf0_.carta_correcao as carta_c13_12_, documentnf0_.cce_events as cce_eve14_12_, documentnf0_.cfops as cfops15_12_, documentnf0_.cnpj as cnpj16_12_, documentnf0_.cnpj_addressee as cnpj_ad17_12_, documentnf0_.cnpj_carrier as cnpj_ca18_12_, documentnf0_.data as data19_12_, documentnf0_.data_emissao as data_em20_12_, documentnf0_.duplicatas as duplica21_12_, documentnf0_.etiquetas as etiquet22_12_, documentnf0_.fatura as fatura23_12_, documentnf0_.issuer_name as issuer_24_12_, documentnf0_.manifestation as manifes25_12_, documentnf0_.name_file as name_fi26_12_, documentnf0_.nfe_number as nfe_num27_12_, documentnf0_.notas_referencia as notas_r28_12_, documentnf0_.status as status29_12_, documentnf0_.value as value30_12_ from public.document_nfe_canhoto_view documentnf0_ where documentnf0_.nfe_number=? and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=? order by documentnf0_.data_emissao desc limit ?	0	2	3,270	6,307	4,294	0.00
SELECT d.cnpj_issuer as cnpj, to_date(to_char(d.data_emissao, 'yyyy-MM-dd'), 'yyyy-MM-dd') as dataEmissao, d.key AS chaveNfe, d.data -> 'nfe' -> 'infNFe' -> 'ide' ->> 'nnf' AS numeroNfe, item.produto -> 'prod' ->> 'cprod' as codigoProduto, item.produto -> 'prod' ->> 'xprod' AS descricaoProduto, item.produto -> 'prod' ->> 'ncm' as codigoNcm, item.produto -> 'prod' ->> 'cfop' as cfop, CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC) as valorProduto FROM document d , jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') WITH ORDINALITY item(produto) WHERE d.cnpj_issuer IN (?) AND d.type IN ('NFE_2_0','NFE_3_1','NFE_4_0') AND data_emissao BETWEEN ? and ? AND item.produto -> 'prod' ->> 'cfop' IN ('5405', '5409') AND item.produto -> 'prod' ->> 'ncm' IN (?)ORDER BY d.key limit ?	0	48	86	353	111	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE d.cnpj_addressee = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ?	0	122	29	1,053	98	0.00
select dsb.* from document_batch_request dsb where dsb.cnpj = ? and date(dsb.created_at + interval '1 month') >= current_date order by dsb.created_at desc limit ?	0	29	118	1,367	250	0.00
select documentob0_.cnpj_issuer as cnpj_iss1_16_, documentob0_.type as type2_16_, documentob0_.key as key3_16_, documentob0_.nsu as nsu4_16_, documentob0_.protocol as protocol5_16_, documentob0_.cnpj as cnpj6_16_, documentob0_.data_emissao as data_emi7_16_, documentob0_.delivery_date as delivery8_16_, documentob0_.ends_date as ends_dat9_16_, documentob0_.final_type as final_t10_16_, documentob0_.imported_at as importe11_16_, documentob0_.inscricao_estadual as inscric12_16_, documentob0_.name_file as name_fi13_16_, documentob0_.original_file_name as origina14_16_, documentob0_.starts_date as starts_15_16_ from public.document_obrigacoes_view documentob0_ where (documentob0_.final_type in (? , ? , ? , ?)) and (documentob0_.type in (? , ? , ? , ? , ?)) and documentob0_.cnpj=? order by documentob0_.starts_date desc limit ?	0	3	647	990	461	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE d.cnpj_addressee = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and d.data ->>'chaveNfe' = ?	0	83	22	115	27	0.00
select documentob0_.cnpj_issuer as cnpj_iss1_16_, documentob0_.type as type2_16_, documentob0_.key as key3_16_, documentob0_.nsu as nsu4_16_, documentob0_.protocol as protocol5_16_, documentob0_.cnpj as cnpj6_16_, documentob0_.data_emissao as data_emi7_16_, documentob0_.delivery_date as delivery8_16_, documentob0_.ends_date as ends_dat9_16_, documentob0_.final_type as final_t10_16_, documentob0_.imported_at as importe11_16_, documentob0_.inscricao_estadual as inscric12_16_, documentob0_.name_file as name_fi13_16_, documentob0_.original_file_name as origina14_16_, documentob0_.starts_date as starts_15_16_ from public.document_obrigacoes_view documentob0_ where (documentob0_.final_type in (? , ? , ? , ?)) and (documentob0_.type in (? , ?)) and substring(documentob0_.cnpj, 1, 8)=? order by documentob0_.starts_date desc limit ?	0	1	1,697	1,697	0	0.00
SELECT SUM(dar.valor_consolidado) AS dividaAtiva FROM divida_ativa_regularize dar WHERE dar.cnpj = ? AND dar.valor_consolidado IS NOT NULL	0	19	87	477	126	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE d.cnpj_addressee = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and d.data ->'nfe'->'infNFe'->'emit'->>'xnome' = ?	0	9	176	1,392	458	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where (0=1 or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	0	18	82	280	85	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.addressee_cnpj_cpf=? limit ?	0	31	36	105	33	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where (upper(documentnf0_.issuer_name) like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	0	3	299	730	373	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ? offset ?	0	12	70	92	16	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?))	0	6	125	255	104	0.00
WITH compras AS ( SELECT 'COMPRA' AS tipoOperacao, TO_CHAR(d.data_emissao, 'YYYY-MM') AS periodo, SUM(CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC)) AS valor FROM document d JOIN jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') item(produto) ON TRUE WHERE d.cnpj_addressee = ? AND d.type IN ('NFE_4_0', 'NFE_3_1') AND ((null) is NULL OR d.key IN (null)) AND d.data_emissao BETWEEN ? AND ? AND item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'ie' = COALESCE(cast(? as text), d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'ie') GROUP BY TO_CHAR(d.data_emissao, 'YYYY-MM') ), devolucoes AS ( SELECT 'DEVOLUCAO' AS tipoOperacao, TO_CHAR(d.data_emissao, 'YYYY-MM') AS periodo, SUM(CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC)) AS valor FROM document d JOIN jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') item(produto) ON TRUE WHERE d.cnpj_addressee = ? AND d.type IN ('NFE_4_0', 'NFE_3_1') AND ((null) is NULL OR d.key IN (null)) AND d.data_emissao BETWEEN ? AND ? AND item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'ie' = COALESCE(cast(? as text), d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'ie') GROUP BY TO_CHAR(d.data_emissao, 'YYYY-MM') ), canceladas AS ( SELECT 'CANCELADA' AS tipoOperacao, TO_CHAR(d.data_emissao, 'YYYY-MM') AS periodo, SUM(CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC)) AS valor FROM document d JOIN document_status ds ON d.key = ds.key AND d.cnpj_issuer = ds.cnpj_issuer AND d.protocol = ds.protocol AND d.nsu = ds.nsu AND d.type = ds.type JOIN jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') item(produto) ON TRUE WHERE d.cnpj_addressee = ? AND d.type IN ('NFE_4_0', 'NFE_3_1') AND ((null) is NULL OR d.key IN (null)) AND d.data_emissao BETWEEN ? AND ? AND ds.status = '3' AND d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'ie' = COALESCE(cast(? as text), d.data -> 'nfe' -> 'infNFe' -> 'dest' ->> 'ie') GROUP BY TO_CHAR(d.data_emissao, 'YYYY-MM') ) SELECT tipoOperacao, periodo, valor FROM ( SELECT * FROM compras UNION ALL SELECT * FROM devolucoes UNION ALL SELECT * FROM canceladas ) totais ORDER BY periodo	0	4	179	513	238	0.00
select documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where documentnf0_.issuer_cpfcnpj=? and documentnf0_.addressee_cpfcnpj=? and documentnf0_.rps_number=? and documentnf0_.rps_serie=? and (documentnf0_.type in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	0	3	216	522	265	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=? and documentwi0_.type=? and (documentwi0_.data_emissao between ? and ?)	0	81	7	44	6	0.00
select count(*) as col_0_0_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=?	0	46	12	99	14	0.00
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_.canceled_at as canceled8_12_, documentnf0_.canhoto_associado_at as canhoto_9_12_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_12_, documentnf0_.canhoto_id as canhoto11_12_, documentnf0_.canhoto_numero_nota as canhoto12_12_, documentnf0_.carta_correcao as carta_c13_12_, documentnf0_.cce_events as cce_eve14_12_, documentnf0_.cfops as cfops15_12_, documentnf0_.cnpj as cnpj16_12_, documentnf0_.cnpj_addressee as cnpj_ad17_12_, documentnf0_.cnpj_carrier as cnpj_ca18_12_, documentnf0_.data as data19_12_, documentnf0_.data_emissao as data_em20_12_, documentnf0_.duplicatas as duplica21_12_, documentnf0_.etiquetas as etiquet22_12_, documentnf0_.fatura as fatura23_12_, documentnf0_.issuer_name as issuer_24_12_, documentnf0_.manifestation as manifes25_12_, documentnf0_.name_file as name_fi26_12_, documentnf0_.nfe_number as nfe_num27_12_, documentnf0_.notas_referencia as notas_r28_12_, documentnf0_.status as status29_12_, documentnf0_.value as value30_12_ from public.document_nfe_canhoto_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 ?	0	8	62	211	67	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ? , ?)) and (documentnf0_.data_emissao between ? and ?)	0	11	42	194	51	0.00
select canhotonot0_.id as id1_26_, canhotonot0_.canhoto_importacao_id as canhoto_6_26_, canhotonot0_.created_at as created_2_26_, canhotonot0_.documento_chave as document3_26_, canhotonot0_.empresa_cnpj as empresa_4_26_, canhotonot0_.numero_nota as numero_n5_26_ from canhoto_nota canhotonot0_ left outer join canhoto_importacao canhotoimp1_ on canhotonot0_.canhoto_importacao_id=canhotoimp1_.id where canhotonot0_.documento_chave=? and (canhotoimp1_.status in (? , ?))	0	72	5	82	9	0.00
select cnpjconsol0_.id as id1_2_, cnpjconsol0_.cnpj as cnpj2_2_, cnpjconsol0_.data as data3_2_, cnpjconsol0_.data_processamento as data_pro4_2_, cnpjconsol0_.duracao_ultimo_processamento as duracao_5_2_, cnpjconsol0_.inscricao_estadual as inscrica6_2_, cnpjconsol0_.periodo as periodo7_2_, cnpjconsol0_.tipo_consolidacao as tipo_con8_2_ from public.cnpj_consolidation cnpjconsol0_ where cnpjconsol0_.cnpj=? and (cnpjconsol0_.tipo_consolidacao in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (cnpjconsol0_.periodo in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	0	3	107	135	25	0.00
select count(dsb.*) from document_batch_request dsb where dsb.cnpj = ? and date(dsb.created_at + interval '1 month') >= current_date	0	18	16	149	37	0.00
SELECT nfse.service_code FROM document_nfse_view nfse WHERE nfse.addressee_cpfcnpj = ? AND nfse.data_emissao BETWEEN ? AND ? UNION SELECT nfse.service_code FROM document_nfse_view nfse WHERE nfse.issuer_cpfcnpj = ? AND nfse.data_emissao BETWEEN ? AND ?	0	16	17	88	26	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.numero_cte=? and documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.tomador4_cnpj=? limit ?	0	2	132	257	176	0.00
select featurefla0_.code as code1_61_, featurefla0_.value as value2_61_ from feature_flag featurefla0_	0	79	3	12	1	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where (upper(documentnf0_.issuer_name) like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao asc limit ?	0	6	39	53	9	0.00
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_.canceled_at as canceled8_12_, documentnf0_.canhoto_associado_at as canhoto_9_12_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_12_, documentnf0_.canhoto_id as canhoto11_12_, documentnf0_.canhoto_numero_nota as canhoto12_12_, documentnf0_.carta_correcao as carta_c13_12_, documentnf0_.cce_events as cce_eve14_12_, documentnf0_.cfops as cfops15_12_, documentnf0_.cnpj as cnpj16_12_, documentnf0_.cnpj_addressee as cnpj_ad17_12_, documentnf0_.cnpj_carrier as cnpj_ca18_12_, documentnf0_.data as data19_12_, documentnf0_.data_emissao as data_em20_12_, documentnf0_.duplicatas as duplica21_12_, documentnf0_.etiquetas as etiquet22_12_, documentnf0_.fatura as fatura23_12_, documentnf0_.issuer_name as issuer_24_12_, documentnf0_.manifestation as manifes25_12_, documentnf0_.name_file as name_fi26_12_, documentnf0_.nfe_number as nfe_num27_12_, documentnf0_.notas_referencia as notas_r28_12_, documentnf0_.status as status29_12_, documentnf0_.value as value30_12_ from public.document_nfe_canhoto_view documentnf0_ where (documentnf0_.status in (?)) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=? order by documentnf0_.data_emissao desc limit ?	0	4	57	109	41	0.00
WITH operacoes AS ( SELECT CASE WHEN item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN CASE WHEN ds.status = '3' THEN 'VENDA|CANCELADA' ELSE 'VENDA' END WHEN item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) THEN CASE WHEN ds.status = '3' THEN 'DEVOLUCAO|CANCELADA' ELSE 'DEVOLUCAO' END WHEN ds.status = '3' THEN 'CANCELADA' END AS tipoOperacao, TO_CHAR(d.data_emissao, 'YYYY-MM') AS periodo, SUM(CAST(item.produto -> 'prod' ->> 'vprod' AS NUMERIC)) AS valor FROM document d JOIN document_status ds ON d.key = ds.key AND d.cnpj_issuer = ds.cnpj_issuer AND d.protocol = ds.protocol AND d.nsu = ds.nsu AND d.type = ds.type JOIN jsonb_array_elements(d.data -> 'nfe' -> 'infNFe' -> 'det') item(produto) ON TRUE WHERE d.cnpj_issuer = ? AND d.type IN ('NFE_4_0', 'NFE_3_1') AND ((null) is NULL OR d.key IN (null)) AND d.data_emissao BETWEEN ? AND ? AND (? = 'nao_filtrar_ie' OR d.data -> 'nfe' -> 'infNFe' -> 'emit' ->> 'ie' =?) AND ( item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR item.produto -> 'prod' ->> 'cfop' IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR ds.status = '3' ) GROUP BY item.produto -> 'prod' ->> 'cfop', ds.status, TO_CHAR(d.data_emissao, 'YYYY-MM') ) SELECT tipoOperacao, periodo, SUM(valor) AS valor FROM operacoes GROUP BY tipoOperacao, periodo ORDER BY periodo	0	18	11	39	7	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 ?)	0	8	26	43	11	0.00
select sum(dividaativ0_.valor_consolidado) as col_0_0_ from divida_ativa_regularize dividaativ0_ where dividaativ0_.cnpj=? and dividaativ0_.grupo=? and (dividaativ0_.data_consolidacao between ? and ?)	0	1	208	208	0	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where (documentnf0_.cnpj_addressee=? or documentnf0_.cnpj_issuer=?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	0	4	52	79	19	0.00
select ofertaopor0_.id as col_0_0_, ofertaopor0_.status_indicador_oferta as col_1_0_ from oferta_oportunidade_tese ofertaopor0_ where ofertaopor0_.cnpj_cliente_oferta=? and ofertaopor0_.tipo_consolidacao_oferta=?	0	57	3	10	1	0.00
select codigoserv0_.id as id1_32_, codigoserv0_.cnpj as cnpj2_32_, codigoserv0_.codigo as codigo3_32_, codigoserv0_.descricao as descrica4_32_ from codigo_servico_nfse_empresa codigoserv0_ where codigoserv0_.cnpj=?	0	16	9	47	13	0.00
select documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.group_type=? and documentnf0_.addressee_cpfcnpj=? order by documentnf0_.data_emissao desc limit ?	0	15	8	34	10	0.00
select count(*) as col_0_0_ from public.document_obrigacoes_view documentob0_ where (documentob0_.final_type in (? , ? , ? , ?)) and (documentob0_.type in (? , ? , ? , ? , ?)) and documentob0_.cnpj=?	0	3	43	44	0	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where (0=1 or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ? offset ?	0	2	62	66	5	0.00
select documentwi0_.key as key3_4_, documentwi0_.data_emissao as data_em11_4_, documentwi0_.type as type2_4_, documentwi0_.gzip as gzip13_4_ from public.document documentwi0_ where documentwi0_.key=? and documentwi0_.type=? and (documentwi0_.data_emissao between ? and ?)	0	17	6	19	4	0.00
select documentos0_.id as id1_5_0_, documentos0_.batch_type as batch_ty2_5_0_, documentos0_.bucket as bucket3_5_0_, documentos0_.cnpj as cnpj4_5_0_, documentos0_.account_id as account_5_5_0_, documentos0_.created_at as created_6_5_0_, documentos0_.created_by as created_7_5_0_, documentos0_.direction as directio8_5_0_, documentos0_.filter_query as filter_q9_5_0_, documentos0_.info as info10_5_0_, documentos0_.total as total11_5_0_, documentos0_.stack_trace as stack_t12_5_0_, documentos0_.type as type13_5_0_ from public.document_batch_request documentos0_ where documentos0_.id=?	0	32	3	23	3	0.00
select cnpjconsol0_.id as id1_2_, cnpjconsol0_.cnpj as cnpj2_2_, cnpjconsol0_.data as data3_2_, cnpjconsol0_.data_processamento as data_pro4_2_, cnpjconsol0_.duracao_ultimo_processamento as duracao_5_2_, cnpjconsol0_.inscricao_estadual as inscrica6_2_, cnpjconsol0_.periodo as periodo7_2_, cnpjconsol0_.tipo_consolidacao as tipo_con8_2_ from public.cnpj_consolidation cnpjconsol0_ where cnpjconsol0_.cnpj=? and (cnpjconsol0_.tipo_consolidacao in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (cnpjconsol0_.periodo in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?))	0	1	103	103	0	0.00
select count(*) as col_0_0_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.addressee_cnpj_cpf=?	0	8	11	21	6	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.cnpj_cpf_remetente=? limit ?	0	3	28	73	38	0.00
select etiqueta0_.id as id1_47_, etiqueta0_.cnpj_empresa as cnpj_emp2_47_, etiqueta0_.cor_etiqueta as cor_etiq3_47_, etiqueta0_.etiqueta_padrao as etiqueta4_47_, etiqueta0_.id_conta as id_conta5_47_, etiqueta0_.nome_etiqueta as nome_eti6_47_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=1548 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	27	3	8	1	0.00
select canhotonot0_.id as id1_26_, canhotonot0_.canhoto_importacao_id as canhoto_6_26_, canhotonot0_.created_at as created_2_26_, canhotonot0_.documento_chave as document3_26_, canhotonot0_.empresa_cnpj as empresa_4_26_, canhotonot0_.numero_nota as numero_n5_26_ from canhoto_nota canhotonot0_ left outer join canhoto_importacao canhotoimp1_ on canhotonot0_.canhoto_importacao_id=canhotoimp1_.id where canhotoimp1_.id in (?)	0	4	18	31	11	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type left join canhoto_nota cn on d.key = cn.documento_chave and d.cnpj_issuer = cn.empresa_cnpj WHERE d.cnpj_issuer = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and d.data ->>'chaveNfe' = ?	0	2	32	58	36	0.00
/* BATCH */ update public.document_batch_request set batch_type=?, bucket=?, cnpj=?, account_id=?, created_at=?, created_by=?, direction=?, filter_query=?, info=?, total=?, stack_trace=?, type=? where id=?	0	20	3	5	0	0.00
select count(*) as col_0_0_ from public.document_nfe_view documentnf0_ where (0=1 or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ? or documentnf0_.cfops like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=?	0	3	20	25	6	0.00
select count(documentnf0_.key) as col_0_0_ from public.document_nfse_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.group_type=? and documentnf0_.addressee_cpfcnpj=?	0	2	30	36	7	0.00
select cnpjconsol0_.id as id1_2_, cnpjconsol0_.cnpj as cnpj2_2_, cnpjconsol0_.data as data3_2_, cnpjconsol0_.data_processamento as data_pro4_2_, cnpjconsol0_.duracao_ultimo_processamento as duracao_5_2_, cnpjconsol0_.inscricao_estadual as inscrica6_2_, cnpjconsol0_.periodo as periodo7_2_, cnpjconsol0_.tipo_consolidacao as tipo_con8_2_ from public.cnpj_consolidation cnpjconsol0_ where cnpjconsol0_.cnpj=? and (cnpjconsol0_.tipo_consolidacao in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (cnpjconsol0_.periodo is null)	0	3	18	21	3	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.nfe_number=? and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_carrier=? order by documentnf0_.data_emissao desc limit ?	0	2	26	29	4	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.key in (?)) and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	0	1	51	51	0	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type left join canhoto_nota cn on d.key = cn.documento_chave and d.cnpj_issuer = cn.empresa_cnpj WHERE d.cnpj_issuer = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ?	0	7	7	12	3	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 ?)	0	3	15	30	13	0.00
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_.canceled_at as canceled8_12_, documentnf0_.canhoto_associado_at as canhoto_9_12_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_12_, documentnf0_.canhoto_id as canhoto11_12_, documentnf0_.canhoto_numero_nota as canhoto12_12_, documentnf0_.carta_correcao as carta_c13_12_, documentnf0_.cce_events as cce_eve14_12_, documentnf0_.cfops as cfops15_12_, documentnf0_.cnpj as cnpj16_12_, documentnf0_.cnpj_addressee as cnpj_ad17_12_, documentnf0_.cnpj_carrier as cnpj_ca18_12_, documentnf0_.data as data19_12_, documentnf0_.data_emissao as data_em20_12_, documentnf0_.duplicatas as duplica21_12_, documentnf0_.etiquetas as etiquet22_12_, documentnf0_.fatura as fatura23_12_, documentnf0_.issuer_name as issuer_24_12_, documentnf0_.manifestation as manifes25_12_, documentnf0_.name_file as name_fi26_12_, documentnf0_.nfe_number as nfe_num27_12_, documentnf0_.notas_referencia as notas_r28_12_, documentnf0_.status as status29_12_, documentnf0_.value as value30_12_ from public.document_nfe_canhoto_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 ? offset ?	0	1	46	46	0	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?)) and (documentct0_.data_emissao between ? and ?)	0	6	7	11	3	0.00
insert into public.document_batch_request (batch_type, bucket, cnpj, account_id, created_at, created_by, direction, filter_query, info, total, stack_trace, type) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)	0	5	9	26	9	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 ?)	0	16	2	5	0	0.00
select count(*) as col_0_0_ from public.document_obrigacoes_view documentob0_ where (documentob0_.final_type in (? , ? , ? , ?)) and (documentob0_.type in (? , ?)) and substring(documentob0_.cnpj, 1, 8)=?	0	1	38	38	0	0.00
select ocrprocess0_.id as id1_76_0_, ocrprocess0_.bucket_name as bucket_n2_76_0_, ocrprocess0_.descricao_status as descrica3_76_0_, ocrprocess0_.s3_key as s4_76_0_, ocrprocess0_.status as status5_76_0_, ocrprocess0_.tipo_imagem as tipo_ima6_76_0_, resultados1_.ocr_processamento_id as ocr_proc8_77_1_, resultados1_.id as id1_77_1_, resultados1_.id as id1_77_2_, resultados1_.dados_extras_processamento as dados_ex2_77_2_, resultados1_.data_hora_fim_processamento as data_hor3_77_2_, resultados1_.data_hora_inicio_processamento as data_hor4_77_2_, resultados1_.data_hora_req_processamento as data_hor5_77_2_, resultados1_.id_usuario_resp_processamento as id_usuar6_77_2_, resultados1_.ocr_processamento_id as ocr_proc8_77_2_, resultados1_.resultado_textual as resultad7_77_2_ from ocr_processamento ocrprocess0_ left outer join ocr_processamento_resultado resultados1_ on ocrprocess0_.id=resultados1_.ocr_processamento_id where ocrprocess0_.id=?	0	4	9	14	4	0.00
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 ?	0	3	10	12	2	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type left join canhoto_nota cn on d.key = cn.documento_chave and d.cnpj_issuer = cn.empresa_cnpj WHERE d.cnpj_issuer = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and ds.status IN (?)	0	5	6	8	1	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and (documentnf0_.key in (select documentci1_.key from public.document_citadas documentci1_ where documentci1_.cnpj_citado=?)) order by documentnf0_.data_emissao desc limit ?	0	1	30	30	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 ?)	0	3	9	10	1	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.tomador4_cnpj=? limit ?	0	3	9	16	6	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE d.cnpj_addressee = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and d.cnpj_addressee = ?	0	4	6	7	0	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao asc limit ?	0	1	25	25	0	0.00
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_.canceled_at as canceled8_12_, documentnf0_.canhoto_associado_at as canhoto_9_12_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_12_, documentnf0_.canhoto_id as canhoto11_12_, documentnf0_.canhoto_numero_nota as canhoto12_12_, documentnf0_.carta_correcao as carta_c13_12_, documentnf0_.cce_events as cce_eve14_12_, documentnf0_.cfops as cfops15_12_, documentnf0_.cnpj as cnpj16_12_, documentnf0_.cnpj_addressee as cnpj_ad17_12_, documentnf0_.cnpj_carrier as cnpj_ca18_12_, documentnf0_.data as data19_12_, documentnf0_.data_emissao as data_em20_12_, documentnf0_.duplicatas as duplica21_12_, documentnf0_.etiquetas as etiquet22_12_, documentnf0_.fatura as fatura23_12_, documentnf0_.issuer_name as issuer_24_12_, documentnf0_.manifestation as manifes25_12_, documentnf0_.name_file as name_fi26_12_, documentnf0_.nfe_number as nfe_num27_12_, documentnf0_.notas_referencia as notas_r28_12_, documentnf0_.status as status29_12_, documentnf0_.value as value30_12_ from public.document_nfe_canhoto_view documentnf0_ where (0=1 or documentnf0_.cfops like ?) and (documentnf0_.status in (?)) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=? order by documentnf0_.data_emissao desc limit ?	0	1	25	25	0	0.00
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_.addressee_name as addresse6_14_, documentnf0_.available_at as availabl7_14_, documentnf0_.canceled_at as canceled8_14_, documentnf0_.carta_correcao as carta_co9_14_, documentnf0_.cce_events as cce_eve10_14_, documentnf0_.cfops as cfops11_14_, documentnf0_.cnpj as cnpj12_14_, documentnf0_.cnpj_addressee as cnpj_ad13_14_, documentnf0_.cnpj_carrier as cnpj_ca14_14_, documentnf0_.data as data15_14_, documentnf0_.data_emissao as data_em16_14_, documentnf0_.duplicatas as duplica17_14_, documentnf0_.etiquetas as etiquet18_14_, documentnf0_.fatura as fatura19_14_, documentnf0_.issuer_name as issuer_20_14_, documentnf0_.manifestation as manifes21_14_, documentnf0_.name_file as name_fi22_14_, documentnf0_.nfe_number as nfe_num23_14_, documentnf0_.notas_referencia as notas_r24_14_, documentnf0_.status as status25_14_, documentnf0_.value as value26_14_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_carrier=? order by documentnf0_.data_emissao desc limit ?	0	1	25	25	0	0.00
select canhotoimp0_.id as id1_25_, canhotoimp0_.cnpj as cnpj2_25_, canhotoimp0_.created_at as created_3_25_, canhotoimp0_.created_by as created_4_25_, canhotoimp0_.descricao as descrica5_25_ from canhoto_importacao_lote canhotoimp0_ where canhotoimp0_.cnpj=? order by canhotoimp0_.created_at desc limit ?	0	3	7	14	5	0.00
select configurac0_.id as id1_34_, configurac0_.ativa as ativa2_34_, configurac0_.descricao as descrica3_34_, configurac0_.grupo as grupo4_34_, configurac0_.habilitar_taxa_selic as habilita5_34_, configurac0_.nome_atributo_consolidacao as nome_atr6_34_, configurac0_.nome_fila as nome_fil7_34_, configurac0_.tipo_consolidacao as tipo_con8_34_, configurac0_.tipo_imposto as tipo_imp9_34_, configurac0_.tipo_tese as tipo_te10_34_, configurac0_.vigencia_final as vigenci11_34_, configurac0_.vigencia_inicial as vigenci12_34_ from configuracao_consolidacao configurac0_	0	4	5	7	1	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 ?)	0	1	21	21	0	0.00
select canhotoimp0_.id as id1_24_, canhotoimp0_.canhoto_nota_id_ja_associado as canhoto_2_24_, canhotoimp0_.data_hora_last_signed_url_generated as data_hor3_24_, canhotoimp0_.lote_id as lote_id7_24_, canhotoimp0_.nome_arquivo_cliente as nome_arq4_24_, canhotoimp0_.ocr_processamento_id as ocr_proc8_24_, canhotoimp0_.s3_key as s5_24_, canhotoimp0_.status as status6_24_ from canhoto_importacao canhotoimp0_ left outer join canhoto_importacao_lote canhotoimp1_ on canhotoimp0_.lote_id=canhotoimp1_.id where canhotoimp1_.id=? and canhotoimp1_.cnpj=?	0	4	4	7	1	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.numero_cte=? and documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.addressee_cnpj_cpf=? limit ?	0	1	16	16	0	0.00
select count(canhotoimp0_.id) as col_0_0_ from canhoto_importacao_lote canhotoimp0_ where canhotoimp0_.cnpj=?	0	4	4	7	2	0.00
select canhotoimp0_.id as id1_25_0_, canhotoimp0_.cnpj as cnpj2_25_0_, canhotoimp0_.created_at as created_3_25_0_, canhotoimp0_.created_by as created_4_25_0_, canhotoimp0_.descricao as descrica5_25_0_ from canhoto_importacao_lote canhotoimp0_ where canhotoimp0_.id=?	0	4	3	6	1	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 ?)	0	1	15	15	0	0.00
select etiqueta0_.id as id1_47_, etiqueta0_.cnpj_empresa as cnpj_emp2_47_, etiqueta0_.cor_etiqueta as cor_etiq3_47_, etiqueta0_.etiqueta_padrao as etiqueta4_47_, etiqueta0_.id_conta as id_conta5_47_, etiqueta0_.nome_etiqueta as nome_eti6_47_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=225 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	4	3	4	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 ?)	0	2	7	10	3	0.00
select count(*) as col_0_0_ from public.document_nfe_canhoto_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=?	0	2	7	10	4	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 ?)	0	3	4	6	1	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 ?)	0	1	12	12	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 ?)	0	1	12	12	0	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE d.cnpj_carrier = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and d.data ->>'chaveNfe' = ?	0	2	5	6	0	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type INNER JOIN document_citadas dc ON d.key = dc.key AND d.protocol = dc.protocol AND d.nsu = dc.nsu AND d.type = dc.type AND d.cnpj_issuer = dc.cnpj_issuer WHERE dc.cnpj_citado = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ?	0	1	11	11	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 ?)	0	1	11	11	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 ?)	0	1	9	9	0	0.00
select etiqueta0_.id as id1_47_, etiqueta0_.cnpj_empresa as cnpj_emp2_47_, etiqueta0_.cor_etiqueta as cor_etiq3_47_, etiqueta0_.etiqueta_padrao as etiqueta4_47_, etiqueta0_.id_conta as id_conta5_47_, etiqueta0_.nome_etiqueta as nome_eti6_47_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=1210 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	3	3	3	0	0.00
select cnpjconsol0_.id as id1_2_, cnpjconsol0_.cnpj as cnpj2_2_, cnpjconsol0_.data as data3_2_, cnpjconsol0_.data_processamento as data_pro4_2_, cnpjconsol0_.duracao_ultimo_processamento as duracao_5_2_, cnpjconsol0_.inscricao_estadual as inscrica6_2_, cnpjconsol0_.periodo as periodo7_2_, cnpjconsol0_.tipo_consolidacao as tipo_con8_2_ from public.cnpj_consolidation cnpjconsol0_ where cnpjconsol0_.cnpj=? and (cnpjconsol0_.tipo_consolidacao in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (cnpjconsol0_.periodo is null)	0	1	8	8	0	0.00
select etiqueta0_.id as id1_47_, etiqueta0_.cnpj_empresa as cnpj_emp2_47_, etiqueta0_.cor_etiqueta as cor_etiq3_47_, etiqueta0_.etiqueta_padrao as etiqueta4_47_, etiqueta0_.id_conta as id_conta5_47_, etiqueta0_.nome_etiqueta as nome_eti6_47_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=1367 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	3	2	4	1	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_8_, documentct0_.type as type2_8_, documentct0_.key as key3_8_, documentct0_.nsu as nsu4_8_, documentct0_.protocol as protocol5_8_, documentct0_.addressee_cnpj_cpf as addresse6_8_, documentct0_.addressee_inscricao_estadual as addresse7_8_, documentct0_.addressee_name as addresse8_8_, documentct0_.available_at as availabl9_8_, documentct0_.canceled_at as cancele10_8_, documentct0_.cnpj_carrier as cnpj_ca11_8_, documentct0_.cnpj_cpf_remetente as cnpj_cp12_8_, documentct0_.data_emissao as data_em13_8_, documentct0_.expedidor_cnpj as expedid14_8_, documentct0_.expedidor_inscricao_estadual as expedid15_8_, documentct0_.expedidor_nome as expedid16_8_, documentct0_.issuer_inscricao_estadual as issuer_17_8_, documentct0_.issuer_name as issuer_18_8_, documentct0_.manifestation as manifes19_8_, documentct0_.name_file as name_fi20_8_, documentct0_.numero_cte as numero_21_8_, documentct0_.recebedor_cnpj_cpf as recebed22_8_, documentct0_.recebedor_inscricao_estadual as recebed23_8_, documentct0_.recebedor_nome as recebed24_8_, documentct0_.remetente_cnpj_cpf as remeten25_8_, documentct0_.remetente_inscricao_estadual as remeten26_8_, documentct0_.remetente_nome as remeten27_8_, documentct0_.schema as schema28_8_, documentct0_.serial as serial29_8_, documentct0_.status as status30_8_, documentct0_.tipo_cte as tipo_ct31_8_, documentct0_.tipo_tomador_servico as tipo_to32_8_, documentct0_.tomador4_cnpj as tomador33_8_, documentct0_.tomador4_inscricao_estadual as tomador34_8_, documentct0_.tomador4_nome as tomador35_8_, documentct0_.value as value36_8_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.cnpj_issuer=? limit ?	0	1	7	7	0	0.00
select configurac0_.id as id1_34_, configurac0_.ativa as ativa2_34_, configurac0_.descricao as descrica3_34_, configurac0_.grupo as grupo4_34_, configurac0_.habilitar_taxa_selic as habilita5_34_, configurac0_.nome_atributo_consolidacao as nome_atr6_34_, configurac0_.nome_fila as nome_fil7_34_, configurac0_.tipo_consolidacao as tipo_con8_34_, configurac0_.tipo_imposto as tipo_imp9_34_, configurac0_.tipo_tese as tipo_te10_34_, configurac0_.vigencia_final as vigenci11_34_, configurac0_.vigencia_inicial as vigenci12_34_ from configuracao_consolidacao configurac0_ where configurac0_.grupo=? and (configurac0_.tipo_imposto is not null)	0	2	3	3	0	0.00
select etiqueta0_.id as id1_47_, etiqueta0_.cnpj_empresa as cnpj_emp2_47_, etiqueta0_.cor_etiqueta as cor_etiq3_47_, etiqueta0_.etiqueta_padrao as etiqueta4_47_, etiqueta0_.id_conta as id_conta5_47_, etiqueta0_.nome_etiqueta as nome_eti6_47_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=1693 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	2	3	3	0	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE SUBSTRING(d.cnpj_addressee, 1, 8) = ? and d.type IN (?, ?, ?) and d.key in (?) and d.data_emissao between ? and ?	0	1	6	6	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 ?)	0	1	6	6	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 ?)	0	1	6	6	0	0.00
select documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where (documentnf0_.opting_simple=? or documentnf0_.opcao_simples=?) and (documentnf0_.status in (? , ?)) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.group_type=? and documentnf0_.issuer_cpfcnpj=? order by documentnf0_.data_emissao desc limit ?	0	1	5	5	0	0.00
select count(*) as col_0_0_ from public.document_nfe_canhoto_view documentnf0_ where (documentnf0_.status in (?)) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=?	0	1	5	5	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 ?)	0	1	4	4	0	0.00
select count(*) as col_0_0_ from public.document_cte_view documentct0_ where documentct0_.data_emissao<=? and documentct0_.data_emissao>=? and (documentct0_.type in (? , ?)) and documentct0_.cnpj_cpf_remetente=?	0	1	4	4	0	0.00
SELECT SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vliq' AS NUMERIC)) AS total_valor_liquido, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vdesc' AS NUMERIC)) AS total_valor_desconto, SUM(CAST(d.data ->'nfe'->'infNFe'->'cobr'->'fat'->>'vorig' AS NUMERIC)) AS total_valor_origem, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vnf' AS NUMERIC)) AS total_vnf, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbc' AS NUMERIC)) AS total_vbc, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vbcst' AS NUMERIC)) AS total_vbcst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vst' AS NUMERIC)) AS total_vst, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vprod' AS NUMERIC)) AS total_vprod, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vipi' AS NUMERIC)) AS total_vipi, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vpis' AS NUMERIC)) AS total_vpis, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vcofins' AS NUMERIC)) AS total_vcofins, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'voutro' AS NUMERIC)) AS total_voutro, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vicms' AS NUMERIC)) AS total_vicms, SUM(CAST(d.data ->'nfe'->'infNFe'->'total'->'icmsTot'->>'vfrete' AS NUMERIC)) AS total_frete FROM document d INNER JOIN document_status ds ON d.key = ds.key and d.cnpj_issuer = ds.cnpj_issuer and d.protocol = ds.protocol and d.nsu = ds.nsu and d.type = ds.type WHERE d.cnpj_carrier = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ?	0	1	4	4	0	0.00
select documentnf0_.key as key1_15_, documentnf0_.addressee_cpfcnpj as addresse2_15_, documentnf0_.addressee_name as addresse3_15_, documentnf0_.city_name as city_nam4_15_, documentnf0_.competency_date as competen5_15_, documentnf0_.data_emissao as data_emi6_15_, documentnf0_.type as type7_15_, documentnf0_.group_type as group_ty8_15_, documentnf0_.ibge_city_code as ibge_cit9_15_, documentnf0_.imported_at as importe10_15_, documentnf0_.iss_value as iss_val11_15_, documentnf0_.issuer_cpfcnpj as issuer_12_15_, documentnf0_.issuer_name as issuer_13_15_, documentnf0_.name_file as name_fi14_15_, documentnf0_.number as number15_15_, documentnf0_.opcao_simples as opcao_s16_15_, documentnf0_.opting_simple as opting_17_15_, documentnf0_.rps_number as rps_num18_15_, documentnf0_.rps_serie as rps_ser19_15_, documentnf0_.service_code as service20_15_, documentnf0_.service_description as service21_15_, documentnf0_.status as status22_15_, documentnf0_.uf_initial as uf_init23_15_, documentnf0_.value as value24_15_, documentnf0_.verification_code as verific25_15_ from public.document_nfse_view documentnf0_ where (documentnf0_.opting_simple=? or documentnf0_.opcao_simples=?) and (documentnf0_.status in (? , ?)) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.group_type=? and documentnf0_.addressee_cpfcnpj=? order by documentnf0_.data_emissao desc limit ?	0	1	4	4	0	0.00
select count(documentnf0_.key) as col_0_0_ from public.document_nfse_view documentnf0_ where (documentnf0_.opting_simple=? or documentnf0_.opcao_simples=?) and (documentnf0_.status in (? , ?)) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and documentnf0_.group_type=? and documentnf0_.issuer_cpfcnpj=?	0	1	3	3	0	0.00
select canhotoimp0_.id as id1_25_, canhotoimp0_.cnpj as cnpj2_25_, canhotoimp0_.created_at as created_3_25_, canhotoimp0_.created_by as created_4_25_, canhotoimp0_.descricao as descrica5_25_ from canhoto_importacao_lote canhotoimp0_ where canhotoimp0_.cnpj=? order by canhotoimp0_.created_at desc limit ? offset ?	0	1	3	3	0	0.00
select etiqueta0_.id as id1_47_, etiqueta0_.cnpj_empresa as cnpj_emp2_47_, etiqueta0_.cor_etiqueta as cor_etiq3_47_, etiqueta0_.etiqueta_padrao as etiqueta4_47_, etiqueta0_.id_conta as id_conta5_47_, etiqueta0_.nome_etiqueta as nome_eti6_47_ from etiqueta etiqueta0_ where etiqueta0_.id_conta=123 and (etiqueta0_.cnpj_empresa is null or etiqueta0_.cnpj_empresa=?) order by etiqueta0_.id desc limit ?	0	1	2	2	0	0.00

Statistics spring - 1 day since midnight

3,197 hits/min on 84 requests       Summary by class       Dependencies       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of cumulative cpu time	Mean cpu time (ms)	Mean allocated Kb	% of system error	Mean hits sql	Mean time sql (ms)
CreditoPisCofinsFreteInsumosAliquotaZeroController.consultar	36	84,222	10	316	6	2	0	45	0.00	1	7
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar	35	84,222	10	316	6	1	0	44	0.00	1	7
ConsumoDocumentosContaEmpresaController.cosumoDocumentosPorConta	4	119	953	4,927	706	14	40	13,244	0.00	0	915
ConsumoDocumentosContaEmpresaServiceImp.consultarQuantidadeDocumentosUtilizadosNoMesConta	4	119	952	4,927	706	14	39	13,227	0.00	0	915
DocumentController.getDocumentsNFEV2	4	226	496	14,561	1,719	8	12	5,158	0.00	2	476
DocumentNfeViewQueryService.findDocumentsWithData	4	223	496	14,558	1,729	6	10	4,279	0.00	2	482
DocumentController.analiseServicoTomado	2	244	199	960	231	0	0	53	0.00	1	195
DocumentService.findAnaliseServicoTomado	1	244	195	957	230	0	0	46	0.00	1	195
ReportController.generateNfeReport	0	78	193	1,561	178	14	62	31,140	0.00	2	126
GeradorPdfNfeServiceImpl.generatePdfByKey	0	78	193	1,557	177	14	62	31,123	0.00	2	126
DocumentController.analiseServicoPrestado	0	26	295	1,035	324	0	0	52	0.00	1	291
DocumentService.findAnaliseServicoPrestado	0	26	292	1,032	324	0	0	45	0.00	1	291
DocumentController.getDocumentsNFECanhoto	0	14	540	6,382	1,683	0	8	3,111	0.00	2	524
DocumentNfeCanhotoViewQueryService.findDocumentsWithData	0	14	535	6,379	1,683	0	7	2,604	0.00	2	524
NfeServiceImpl.downloadExcel	0	4	1,118	2,106	688	3	291	44,443	0.00	19	568
CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	0	48	89	359	111	0	0	75	0.00	1	86
CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	0	48	89	359	111	0	0	61	0.00	1	86
DownloadService.retornarTodasSolicitacoesDeDownload	0	29	144	1,395	254	0	9	1,923	0.00	1	128
DownloadController.retornarTodasSolicitacoesDeDownload	0	29	144	1,395	254	0	9	1,925	0.00	1	128
DocumentController.getDocumentsObrigacoes	0	4	962	1,748	646	0	4	609	0.00	2	952
DocumentObrigacoesViewQueryService.findDocuments	0	4	958	1,744	646	0	3	591	0.00	2	952
DocumentController.getDocumentsCte	0	41	62	270	64	0	5	1,886	0.00	2	50
DocumentCteViewQueryService.findDocumentsWithData	0	41	58	268	63	0	4	1,256	0.00	2	50
ExportadorNfeParaExcelImpl.exportar	0	4	555	803	227	0	28	9,544	0.00	6	518
DocumentNfeViewQueryService.findDocumentsNfeViewWithData	0	15	145	525	128	0	4	2,085	0.00	1	138
EtiquetaController.listarEtiquetas	0	40	48	525	78	1	10	1,536	0.00	1	3
EtiquetaServiceImpl.consultarEtiquetas	0	40	48	523	77	1	10	1,513	0.00	1	3
DownloadService.downloadNfsePdfZip	0	3	646	1,291	558	0	64	7,649	0.00	2	230
DownloadController.downloadNfsePdfZipOnline	0	3	646	1,291	558	0	64	7,652	0.00	2	230
GeradorPdfNfseServiceImpl.generatePdfByNfseDTO	0	3	644	1,288	557	0	62	7,600	0.00	2	230
DividaAtivaRegularizeController.findDividaAtivaByCnpj	0	19	94	484	128	0	0	113	0.00	1	87
DividaAtivaRegularizeServiceImpl.findDividaAtivaByCnpj	0	19	94	484	127	0	0	76	0.00	1	87
CoreApiServiceImpl.consultaContasPorIds	0	40	38	459	69	0	7	1,135	0.00	0	0
ReportController.generateCteReport	0	6	198	373	124	0	49	10,622	0.00	2	136
GeradorPdfCteServiceImpl.generatePdfByKey	0	6	198	373	124	0	49	10,618	0.00	2	136
DownloadService.getFileXmlInS3ByTypeAndKey	0	17	48	220	46	0	4	448	0.00	2	36
ComercialController.consultarTotalOportunidadeCnpj	0	3	267	291	39	0	85	28,360	0.00	17	174
DocumentService.consultarTotalOportunidadeCnpj	0	3	266	289	39	0	85	28,159	0.00	17	174
FeatureFlagController.listarTodas	0	79	9	36	5	0	0	82	0.00	1	3
DocumentController.analiseCompraDevolucao	0	4	186	530	244	0	1	475	0.00	1	179
DocumentService.findComparativePurchaseReturnByCnpjKeyPeriodCfop	0	4	180	515	238	0	1	468	0.00	1	179
DownloadController.retornaBytesXmlZipadoPelaChaveNfe	0	11	60	220	54	0	3	359	0.00	2	50
FiscalntelligenceCoreService.buscarServicos	0	3	192	238	40	0	2	771	0.00	0	0
DocumentNfeViewQueryService.findByKey	0	11	50	198	49	0	1	247	0.00	1	42
DocumentController.findCodigosServicosNfse	0	16	34	103	30	0	4	404	0.00	2	26
FeatureFlagService.listarTodas	0	79	6	26	4	0	0	50	0.00	1	3
DocumentController.findOportunidadeTeseJuridicaCnpjResumida	0	1	537	537	0	0	114	64,456	0.00	19	381
AwsService.uploadInBucketCustom	0	5	106	224	65	0	40	5,965	0.00	0	0
DocumentService.findOportunidadeTeseJuridicaCnpjResumida	0	1	531	531	0	0	111	62,597	0.00	19	381
DocumentNfseViewQueryService.findCodigosServicosNfse	0	16	32	99	29	0	3	389	0.00	2	26
DownloadNfeCanhotoController.exportarExcel	0	1	478	478	0	0	148	26,504	0.00	8	178
NfeCanhotoServiceImpl.downloadExcel	0	1	475	475	0	0	145	25,791	0.00	8	178
DocumentController.getNfse	0	17	27	106	29	0	4	715	0.00	1	12
CnpjConsolidationServiceImpl.findOportunidadeTeseJuridicaCnpj	0	4	115	151	30	0	70	27,143	0.00	14	45
DocumentService.findDocumentNfseDto	0	17	25	103	28	0	3	706	0.00	1	12
SolicitacaoDownloadDocumentoBatchServiceImpl.atualizarPassos	0	20	20	47	9	0	6	884	0.00	2	8
EtiquetaQueryService.listarEtiquetas	0	40	9	22	3	0	1	115	0.00	1	3
DocumentController.analiseVendaDevolucao	0	18	17	42	8	0	1	339	0.00	1	11
DocumentService.findComparativeSaleReturnByCnpjKeyPeriodCfop	0	18	14	40	7	0	1	332	0.00	1	11
DocumentNfseViewQueryService.findDocumentNfse	0	17	15	76	20	0	1	161	0.00	1	12
DividaAtivaRegularizeQueryServiceImpl.consultarTotal	0	1	254	254	0	0	8	3,487	0.00	1	208
NextGenService.obterDadosConta	0	5	47	69	20	0	0	246	0.00	0	0
NextGenService.obterTodasCidades	0	1	211	211	0	0	10	2,356	0.00	0	0
SolicitacaoDownloadDocumentoBatchServiceImpl.inserir	0	5	38	77	28	0	9	1,402	0.00	1	9
ExportadorNfeEmitidaParaExcelImpl.exportar	0	1	183	183	0	0	17	6,604	0.00	3	162
CanhotoImportacaoController.listarCanhotosDoLotePorCnpj	0	4	44	73	24	0	7	1,264	0.00	4	36
CanhotoImportacaoServiceImpl.listarCanhotosDoLotePorCnpj	0	4	44	71	23	0	6	1,012	0.00	4	36
DocumentNfeCanhotoViewQueryService.findDocumentsNfeCanhotoViewWithData	0	2	88	125	52	0	4	2,591	0.00	1	81
NextGenService.findAtividadeEconomica	0	3	56	76	18	0	0	19	0.00	0	0
CoreApiServiceImpl.buscarCidades	0	8	21	35	6	0	2	443	0.00	0	0
DownloadController.retornaBytesXmlZipadoPelaChaveCte	0	6	26	48	12	0	7	918	0.00	2	13
CanhotoImportacaoController.listarLotesPorCnpjPaginado	0	4	34	54	12	0	6	752	0.00	2	10
CanhotoImportacaoLoteServiceImpl.listarLotesPorCnpj	0	4	34	54	12	0	6	749	0.00	2	10
DocumentCteViewQueryService.findByKey	0	6	15	19	4	0	1	117	0.00	1	7
CanhotoNotaSericeImp.listarCanhotoNotaPorIdCanhoto	0	4	20	32	11	0	0	236	0.00	1	18
CoreApiServiceImpl.consultarUsuariosEmailNomePorIds	0	4	18	23	3	0	2	430	0.00	0	0
DocumentNfceViewQueryService.findDocumentWithData	0	3	19	23	4	0	3	788	0.00	2	14
NextGenService.getRvzByCnpj	0	1	39	39	0	0	1	59	0.00	0	0
BasicErrorController.error	0	30	0	4	0	0	0	85	0.00	0	0
DownloadNfeController.exportarExcel	0	4	1	5	2	0	1	190	0.00	0	0
DocumentController.analiseRepresentatividadeConsolidada	0	1	6	6	0	0	2	125	0.00	0	0
AwsService.getBucketNameDocumentDownload	0	5	1	5	2	0	0	227	0.00	0	0
ServerController.version	0	94	0	2	0	0	0	6	0.00	0	0
DocumentService.analiseRepresentatividadeConsolidadaGrafico	0	1	1	1	0	0	0	26	0.00	0	0

Statistics http system errors - 1 day since midnight

0 hits/min on 5 errors       Details       Last errors      

Statistics system errors logs - 1 day since midnight

0 hits/min on 15 errors       Details       Last errors