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

Statistics of JavaMelody monitoring taken at 12/12/25, 7:59 AM on _ip-10-0-12-90.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

6,208 hits/min on 38 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	70	630,518	11	2,462	8	67	0	240	0.00	0	1	7
/api/document/{cnpj}/cruzamento-efd-nfse POST	11	5	237,275	1,015,270	436,722	0	8	3,336	0.00	289	0	0
/api/document/{cnpj}/v2/nfe POST	6	154	4,522	116,090	14,862	1	6	1,851	0.00	93	2	4,507
/api/nfe/credito-tese-artigo-426a/{cnpj}/period POST	6	2,256	288	26,457	1,106	3	1	583	0.00	0	1	283
/api/document/{cnpj}/v2/nfe-canhoto POST	1	3	53,143	83,234	46,110	0	7	1,541	0.00	1	2	53,132
/api/document/keys POST	0	400	164	967	211	16	33	15,161	0.00	1,047	1	130
/api/document/{cnpj}/obrigacoes POST	0	42	1,494	6,041	1,622	0	3	691	0.00	4	1	1,484
/api/document/{cnpj}/analise-representatividade-consolidada POST	0	29	1,753	6,954	1,464	0	6	3,016	0.00	14	2	17
/api/solicitacao-download-nfe/consulta POST	0	134	202	2,730	319	0	1	262	0.00	4	1	194
/api/reports/nfe/{key} GET	0	71	201	1,031	145	4	46	19,434	0.00	12	3	146
/api/consumo-documentos-conta GET	0	6	2,065	2,441	270	0	7	1,597	0.00	0	1	2,055
/api/consumo-documentos-conta/ GET	0	6	2,032	2,237	213	0	29	11,874	0.00	0	1	2,003
/api/email/{cnpj}/NFE/{batchType}/{tipoEmailDocumento} POST	0	1	11,695	11,695	0	0	201	33,665	0.00	0	9	10,529
/api/document/{cnpj}/oportunidade-tese-juridica-consolidada-resumida POST	0	31	316	606	98	1	47	22,956	0.00	0	20	236
/api/document/{cnpj}/period GET	0	149	44	298	57	2	12	5,644	0.00	355	1	29
/api/document/{cnpj}/nfse/period GET	0	495	12	140	13	0	0	411	0.00	1	1	7
/actuator/health GET	0	612	5	27	3	0	0	65	0.00	0	0	0
/api/download/{cnpj}/solicitacoes GET	0	2	685	1,329	910	0	13	3,019	0.00	40	2	660
/api/download/nfse/pdf-zip-online POST	0	1	1,276	1,276	0	0	137	17,388	0.00	15	2	332
/api/document/{cnpj}/v2/nfse POST	0	6	167	707	267	0	6	1,262	0.00	22	1	125
/api/etiqueta/listar POST	0	11	77	202	56	0	9	1,803	0.00	1	1	4
/api/document/{cnpj}/products-nfe GET	0	7	109	363	116	0	1	276	0.00	0	1	102
/api/reports/cte/{key} GET	0	2	241	388	207	0	50	11,557	0.00	10	2	179
/api/document/{cnpj}/v2/cte POST	0	6	69	116	43	0	9	2,455	0.00	78	4	56
/api/document/codigos-servicos-nfse POST	0	8	52	199	60	0	5	846	0.00	1	2	41
/api/feature-flag/todas GET	0	30	12	69	13	0	1	286	0.00	0	1	5
/api/download/nfe/xml/{key} GET	0	7	45	57	5	0	4	487	0.00	10	2	32
/api/document/{key}/sped-document GET	0	17	18	64	12	0	4	1,066	0.00	0	1	8
/api/document/{cnpj}/solicitar-download-documentos-cancelados POST	0	1	296	296	0	0	172	31,134	0.00	0	5	69
/api/uploads3/documents/generate/multiple/presigned POST	0	6	38	64	14	0	9	1,383	0.00	0	3	18
/api/uploads3/publico/documents/trigger/success-upload/presigned/{fileName}/{idRequest} POST	0	6	19	29	5	0	3	648	0.00	0	3	10
/api/document/{cnpj}/find-nota-emitida-periodo POST	0	5	13	21	5	0	1	547	0.00	0	1	7
/api/importacao-canhoto/{cnpj}/lotes POST	0	1	56	56	0	0	12	3,033	0.00	2	2	13
/api/document/{cnpj}/v2/cfe POST	0	2	18	22	5	0	5	1,593	0.00	0	2	7
/api/document/{cnpj}/v2/nfce POST	0	1	25	25	0	0	7	2,850	0.00	0	2	9
Error404	0	11	2	4	0	0	1	330	100.00	0	0	0
/api/server/publico/version GET	0	53	0	4	0	0	0	49	0.00	0	0	0
/api/download-nfe/{cnpj}/excel POST	0	4	3	6	2	0	2	568	0.00	0	0	0

Statistics sql - 1 day since midnight

6,217 hits/min on 188 requests       Details      

Request	% of cumulative time	Hits	Mean time (ms)	Max time (ms)	Standard deviation	% of system error
SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d.cnpj_issuer in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR d.cnpj_addressee in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))	53	9	1,015,004	1,015,006	1	0.00
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 ?	29	630,522	7	440	6	0.00
SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d.cnpj_issuer in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR d.cnpj_addressee in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))	5	1	1,015,005	1,015,005	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.data_emissao between ? and ? and d.data ->'nfe'->'infNFe'->'emit'->>'xnome' = ?	2	29	12,508	81,661	23,610	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	840	158	25,924	997	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 SUBSTRING(d.cnpj_issuer, 1, 8) = ? and d.type IN (?, ?, ?) and d.data_emissao between ? and ? and d.data ->'nfe'->'infNFe'->'emit'->>'xnome' = ?	0	2	60,023	60,179	219	0.00
SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d.cnpj_issuer in (?, ?, ?, ?, ?) OR d.cnpj_addressee in (?, ?, ?, ?, ?))	0	1	108,619	108,619	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	440	229	26,450	1,327	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	0	2	44,704	88,961	62,588	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	67	1,147	7,656	2,219	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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 substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	0	172	380	10,526	1,508	0.00
select documentob0_.cnpj_issuer as cnpj_iss1_17_, documentob0_.type as type2_17_, documentob0_.key as key3_17_, documentob0_.nsu as nsu4_17_, documentob0_.protocol as protocol5_17_, documentob0_.cnpj as cnpj6_17_, documentob0_.data_emissao as data_emi7_17_, documentob0_.delivery_date as delivery8_17_, documentob0_.ends_date as ends_dat9_17_, documentob0_.exibir_popup_escrituracao as exibir_10_17_, documentob0_.final_type as final_t11_17_, documentob0_.imported_at as importe12_17_, documentob0_.inscricao_estadual as inscric13_17_, documentob0_.name_file as name_fi14_17_, documentob0_.original_file_name as origina15_17_, documentob0_.parcial as parcial16_17_, documentob0_.starts_date as starts_17_17_ 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	35	1,656	6,035	1,672	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	187	248	909	228	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	32	1,417	6,272	1,943	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_13_, documentnf0_.type as type2_13_, documentnf0_.key as key3_13_, documentnf0_.nsu as nsu4_13_, documentnf0_.protocol as protocol5_13_, documentnf0_.addressee_name as addresse6_13_, documentnf0_.available_at as availabl7_13_, documentnf0_.canceled_at as canceled8_13_, documentnf0_.canhoto_associado_at as canhoto_9_13_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_13_, documentnf0_.canhoto_id as canhoto11_13_, documentnf0_.canhoto_numero_nota as canhoto12_13_, documentnf0_.carta_correcao as carta_c13_13_, documentnf0_.cce_events as cce_eve14_13_, documentnf0_.cfops as cfops15_13_, documentnf0_.chaves_cte_associadas_sistema as chaves_16_13_, documentnf0_.cnpj as cnpj17_13_, documentnf0_.cnpj_addressee as cnpj_ad18_13_, documentnf0_.cnpj_carrier as cnpj_ca19_13_, documentnf0_.data as data20_13_, documentnf0_.data_emissao as data_em21_13_, documentnf0_.duplicatas as duplica22_13_, documentnf0_.etiquetas as etiquet23_13_, documentnf0_.fatura as fatura24_13_, documentnf0_.issuer_name as issuer_25_13_, documentnf0_.manifestation as manifes26_13_, documentnf0_.name_file as name_fi27_13_, documentnf0_.nfe_number as nfe_num28_13_, documentnf0_.notas_referencia as notas_r29_13_, documentnf0_.status as status30_13_, documentnf0_.value as value31_13_ from public.document_nfe_canhoto_view documentnf0_ where (upper(documentnf0_.issuer_name) like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_issuer, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	0	2	19,656	23,361	5,238	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	74	488	5,699	1,363	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.nfe_number=? and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.data_emissao desc limit ?	0	5	7,096	10,855	4,240	0.00
SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?)) AND (d.cnpj_issuer in (?) OR d.cnpj_addressee in (?))	0	1	33,131	33,131	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	245	133	865	233	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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 ?	0	37	821	8,001	1,457	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	23	1,084	5,883	1,675	0.00
select count(*) from ( select row_number() over ( partition by sdn.cnpj order by sdn.id desc ) rank from solicitacao_download_nfe sdn where (cast(? as text) is null or sdn.cnpj = cast(? as text)) and (cast(? as text) is null or substring(sdn.cnpj, 1, 8) = cast(? as text)) and (cast(? as text) is null or sdn.status = cast(? as text)) ) resultado where rank <= ?	0	128	193	2,700	319	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 ?	0	12	2,029	2,433	230	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.data_emissao between ? and ?	0	2	11,921	23,827	16,837	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	80	269	4,179	726	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	14	1,454	4,359	1,822	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	15	1,273	4,575	1,980	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	12	1,433	6,046	2,300	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	109	154	2,424	446	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	12	1,395	5,686	2,287	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	12	1,367	5,156	2,070	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	19	856	4,094	1,327	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	16	1,016	4,711	1,573	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	16	1,002	5,430	1,513	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	22	651	5,482	1,412	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	110	123	1,792	274	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	37	357	5,219	962	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	30	438	2,494	824	0.00
SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d.cnpj_issuer in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR d.cnpj_addressee in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))	0	1	12,129	12,129	0	0.00
SELECT d.data_emissao AS dataEmissao, CAST(d.info ->> 'number' AS BIGINT) AS numeroNotaFiscal , CAST(d.info ->> 'value' AS NUMERIC) AS valor, CAST(d.info ->> 'iss_value' AS NUMERIC) AS valorIss, d.cnpj_issuer AS cnpjServicoPrestado, d.cnpj_addressee AS cnpjServicoTomado FROM document d WHERE d.type like 'NFSE%' AND d.info ->> 'value' IS NOT NULL AND d.info ->> 'value' <> '' AND ((?, ?, ?) is NULL OR CAST(d.info ->> 'number' AS TEXT) IN (?, ?, ?)) AND (d.cnpj_issuer in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR d.cnpj_addressee in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))	0	1	11,948	11,948	0	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_13_, documentnf0_.type as type2_13_, documentnf0_.key as key3_13_, documentnf0_.nsu as nsu4_13_, documentnf0_.protocol as protocol5_13_, documentnf0_.addressee_name as addresse6_13_, documentnf0_.available_at as availabl7_13_, documentnf0_.canceled_at as canceled8_13_, documentnf0_.canhoto_associado_at as canhoto_9_13_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_13_, documentnf0_.canhoto_id as canhoto11_13_, documentnf0_.canhoto_numero_nota as canhoto12_13_, documentnf0_.carta_correcao as carta_c13_13_, documentnf0_.cce_events as cce_eve14_13_, documentnf0_.cfops as cfops15_13_, documentnf0_.chaves_cte_associadas_sistema as chaves_16_13_, documentnf0_.cnpj as cnpj17_13_, documentnf0_.cnpj_addressee as cnpj_ad18_13_, documentnf0_.cnpj_carrier as cnpj_ca19_13_, documentnf0_.data as data20_13_, documentnf0_.data_emissao as data_em21_13_, documentnf0_.duplicatas as duplica22_13_, documentnf0_.etiquetas as etiquet23_13_, documentnf0_.fatura as fatura24_13_, documentnf0_.issuer_name as issuer_25_13_, documentnf0_.manifestation as manifes26_13_, documentnf0_.name_file as name_fi27_13_, documentnf0_.nfe_number as nfe_num28_13_, documentnf0_.notas_referencia as notas_r29_13_, documentnf0_.status as status30_13_, documentnf0_.value as value31_13_ from public.document_nfe_canhoto_view documentnf0_ where (upper(documentnf0_.issuer_name) like ?) and documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.key asc limit ?	0	1	10,492	10,492	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	4	2,605	5,360	2,973	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ?))	0	71	135	427	95	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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 substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.data_emissao desc limit ? offset ?	0	44	202	876	198	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	17	507	2,812	1,004	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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 ?	0	67	97	438	82	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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 substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.key asc limit ?	0	36	156	680	189	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where (0=1 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	2	2,404	4,754	3,322	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	2	2,203	4,378	3,075	0.00
SELECT d.key, d.cnpj_issuer as cnpjIssuer, d.cnpj_addressee as cnpjAddressee, s.status, d.type, d.data, d.info, d.imported_at as importedAt, d.name_file as nameFile, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d, document_status s WHERE d.cnpj_issuer = s.cnpj_issuer AND d.nsu = s.nsu AND d.key = s.key AND d.protocol = s.protocol AND d.type = s.type AND d.data_emissao BETWEEN (?) AND (?) AND (d.cnpj_issuer = ? OR d.cnpj_addressee = ? OR d.cnpj_cpf_remetente = ?) order by d.key desc limit ?	0	91	44	262	58	0.00
select count(*) as col_0_0_ 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 substring(documentnf0_.cnpj_addressee, 1, 8)=?	0	46	82	166	69	0.00
SELECT d.key, d.cnpj_issuer as cnpjIssuer, d.cnpj_addressee as cnpjAddressee, d.type, d.data, d.info, d.imported_at as importedAt, d.name_file as nameFile, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d WHERE d.data_emissao BETWEEN (?) AND (?) AND d.cnpj_issuer = ? AND d.group_type = 'NFSE' AND d.info ->> 'status' = 'NORMAL' order by d.key desc limit ?	0	453	8	132	13	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	31	119	211	49	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	8	435	2,742	953	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 substring(documentnf0_.cnpj_addressee, 1, 8)=?	0	2	1,642	3,277	2,312	0.00
select documentob0_.cnpj_issuer as cnpj_iss1_17_, documentob0_.type as type2_17_, documentob0_.key as key3_17_, documentob0_.nsu as nsu4_17_, documentob0_.protocol as protocol5_17_, documentob0_.cnpj as cnpj6_17_, documentob0_.data_emissao as data_emi7_17_, documentob0_.delivery_date as delivery8_17_, documentob0_.ends_date as ends_dat9_17_, documentob0_.exibir_popup_escrituracao as exibir_10_17_, documentob0_.final_type as final_t11_17_, documentob0_.imported_at as importe12_17_, documentob0_.inscricao_estadual as inscric13_17_, documentob0_.name_file as name_fi14_17_, documentob0_.original_file_name as origina15_17_, documentob0_.parcial as parcial16_17_, documentob0_.starts_date as starts_17_17_ 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	2	1,554	2,646	1,543	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	26	108	1,519	298	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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	5	531	2,397	1,045	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	42	61	724	135	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	3	812	2,369	1,348	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	3	790	2,311	1,317	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	5	430	1,473	648	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	24	76	141	45	0.00
select id, cnpj, nsu_inicio, ultimo_nsu_disponivel, maximo_nsu_disponivel, data_solicitacao, data_ultima_resposta, data_inicio_download, data_fim_download, quantidade_documentos, status, descricao_status_resposta, mensagem_erro, codigo_status_resposta, ultimo_nsu_solicitado from ( select sdn.id, sdn.cnpj, sdn.nsu_inicio, sdn.ultimo_nsu_disponivel, sdn.maximo_nsu_disponivel, sdn.data_solicitacao, sdn.data_ultima_resposta, sdn.data_inicio_download, sdn.data_fim_download, sdn.quantidade_documentos, sdn.status, sdn.descricao_status_resposta, sdn.mensagem_erro, sdn.codigo_status_resposta, sdn.ultimo_nsu_solicitado, row_number() over ( partition by sdn.cnpj order by sdn.id desc ) rank from solicitacao_download_nfe sdn where (cast(? as text) is null or sdn.cnpj = cast(? as text)) and (cast(? as text) is null or substring(sdn.cnpj, 1, 8) = cast(? as text)) and (cast(? as text) is null or sdn.status = cast(? as text)) ) resultado where rank <= ? limit ?	0	134	9	84	10	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	2	620	1,228	859	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	422	2	11	1	0.00
SELECT d.data_emissao AS dataNfe, d.key AS chaveNfe, (items.prod ->> 'cprod') AS codigoProduto, (items.prod ->> 'xprod') AS nomeProduto, CAST((items.prod ->> 'vprod') AS NUMERIC) AS valorProduto, (items.prod ->> 'qcom') AS quantidadeProduto, (items.prod ->> 'cfop') AS cfop FROM document d, jsonb_to_recordset(d.data -> 'nfe' -> 'infNFe' -> 'det') AS items(prod jsonb) WHERE (items.prod ->> 'cfop') IN (?, ?) AND d.cnpj_issuer = ? AND d.type IN (?, ?, ?, ?, ?, ?, ?, ?) AND (d.data_emissao BETWEEN CAST(? as date) AND CAST(? as date))	0	7	102	358	117	0.00
select documentnf0_.key as key1_16_, documentnf0_.addressee_cpfcnpj as addresse2_16_, documentnf0_.addressee_name as addresse3_16_, documentnf0_.city_name as city_nam4_16_, documentnf0_.competency_date as competen5_16_, documentnf0_.data_emissao as data_emi6_16_, documentnf0_.type as type7_16_, documentnf0_.group_type as group_ty8_16_, documentnf0_.ibge_city_code as ibge_cit9_16_, documentnf0_.imported_at as importe10_16_, documentnf0_.iss_value as iss_val11_16_, documentnf0_.issuer_cpfcnpj as issuer_12_16_, documentnf0_.issuer_name as issuer_13_16_, documentnf0_.name_file as name_fi14_16_, documentnf0_.number as number15_16_, documentnf0_.opcao_simples as opcao_s16_16_, documentnf0_.opting_simple as opting_17_16_, documentnf0_.other_information as other_i18_16_, documentnf0_.rps_number as rps_num19_16_, documentnf0_.rps_serie as rps_ser20_16_, documentnf0_.service_code as service21_16_, documentnf0_.service_description as service22_16_, documentnf0_.status as status23_16_, documentnf0_.uf_initial as uf_init24_16_, documentnf0_.value as value25_16_, documentnf0_.verification_code as verific26_16_ 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	6	119	649	259	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	3	188	530	296	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	26	21	87	20	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	7	75	186	53	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	39	13	160	24	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	238	256	25	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.data_emissao between ? and ? and d.data ->>'chaveNfe' = ?	0	5	93	109	14	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	4	111	210	110	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	8	52	87	14	0.00
select canhotonot0_.id as id1_28_, canhotonot0_.canhoto_importacao_id as canhoto_6_28_, canhotonot0_.created_at as created_2_28_, canhotonot0_.documento_chave as document3_28_, canhotonot0_.empresa_cnpj as empresa_4_28_, canhotonot0_.numero_nota as numero_n5_28_ 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	71	5	17	4	0.00
SELECT d.key, d.cnpj_issuer as cnpjIssuer, d.cnpj_addressee as cnpjAddressee, s.status, d.type, d.data, d.info, d.imported_at as importedAt, d.name_file as nameFile, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d, document_status s WHERE d.cnpj_issuer = s.cnpj_issuer AND d.nsu = s.nsu AND d.key = s.key AND d.protocol = s.protocol AND d.type = s.type AND d.data_emissao BETWEEN (?) AND (?) AND (d.cnpj_issuer = ? OR d.cnpj_addressee = ? OR d.cnpj_cpf_remetente = ?) order by d.key desc limit ? offset ?	0	58	6	16	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=? and documentwi0_.type=? and (documentwi0_.data_emissao between ? and ?)	0	74	5	17	2	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?) AND d.data_emissao BETWEEN ? AND ?	0	50	7	27	5	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	4	88	137	60	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_9_, documentct0_.type as type2_9_, documentct0_.key as key3_9_, documentct0_.nsu as nsu4_9_, documentct0_.protocol as protocol5_9_, documentct0_.addressee_cnpj_cpf as addresse6_9_, documentct0_.addressee_inscricao_estadual as addresse7_9_, documentct0_.addressee_name as addresse8_9_, documentct0_.available_at as availabl9_9_, documentct0_.canceled_at as cancele10_9_, documentct0_.chaves_nfe_associadas_sistema as chaves_11_9_, documentct0_.chaves_nfe_documento as chaves_12_9_, documentct0_.cnpj_carrier as cnpj_ca13_9_, documentct0_.cnpj_cpf_remetente as cnpj_cp14_9_, documentct0_.cst as cst15_9_, documentct0_.data_emissao as data_em16_9_, documentct0_.expedidor_cnpj as expedid17_9_, documentct0_.expedidor_inscricao_estadual as expedid18_9_, documentct0_.expedidor_nome as expedid19_9_, documentct0_.issuer_inscricao_estadual as issuer_20_9_, documentct0_.issuer_name as issuer_21_9_, documentct0_.manifestation as manifes22_9_, documentct0_.name_file as name_fi23_9_, documentct0_.numero_cte as numero_24_9_, documentct0_.picms as picms25_9_, documentct0_.recebedor_cnpj_cpf as recebed26_9_, documentct0_.recebedor_inscricao_estadual as recebed27_9_, documentct0_.recebedor_nome as recebed28_9_, documentct0_.remetente_cnpj_cpf as remeten29_9_, documentct0_.remetente_inscricao_estadual as remeten30_9_, documentct0_.remetente_nome as remeten31_9_, documentct0_.schema as schema32_9_, documentct0_.serial as serial33_9_, documentct0_.status as status34_9_, documentct0_.tipo_cte as tipo_ct35_9_, documentct0_.tipo_tomador_servico as tipo_to36_9_, documentct0_.tomador4_cnpj as tomador37_9_, documentct0_.tomador4_inscricao_estadual as tomador38_9_, documentct0_.tomador4_nome as tomador39_9_, documentct0_.value as value40_9_, documentct0_.vbc as vbc41_9_, documentct0_.vicms as vicms42_9_ from public.document_cte_view documentct0_ where documentct0_.key=? and (documentct0_.type in (? , ?))	0	2	173	305	186	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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	3	112	172	54	0.00
select documentob0_.cnpj_issuer as cnpj_iss1_17_, documentob0_.type as type2_17_, documentob0_.key as key3_17_, documentob0_.nsu as nsu4_17_, documentob0_.protocol as protocol5_17_, documentob0_.cnpj as cnpj6_17_, documentob0_.data_emissao as data_emi7_17_, documentob0_.delivery_date as delivery8_17_, documentob0_.ends_date as ends_dat9_17_, documentob0_.exibir_popup_escrituracao as exibir_10_17_, documentob0_.final_type as final_t11_17_, documentob0_.imported_at as importe12_17_, documentob0_.inscricao_estadual as inscric13_17_, documentob0_.name_file as name_fi14_17_, documentob0_.original_file_name as origina15_17_, documentob0_.parcial as parcial16_17_, documentob0_.starts_date as starts_17_17_ 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 ? offset ?	0	5	67	98	24	0.00
select item.produto ->> 'codigo' as codigo, item.produto ->> 'nome' as nome, item.produto ->> 'codigo_ncm' as codigoNcm, item.produto ->> 'descricao_unidade_medida' as descricaoUnidadeMedida, sum(cast(item.produto ->> 'valor' as numeric)) as valor, sum(cast(item.produto ->> 'quantidade' as numeric)) as quantidade, sum(cast(item.produto ->> 'valor' as numeric)) / sum(cast(item.produto ->> 'quantidade' as numeric)) as valorUnitario, max(data_processamento) as dataProcessamento, max(duracao_ultimo_processamento) as duracaoUltimoProcessamento from cnpj_consolidation, jsonb_array_elements(data -> 'produtos_vendidos') with ordinality item(produto) where cnpj in (?) and tipo_consolidacao = 'ANALISE_REPRESENTATIVIDADE' and item.produto ->> 'periodo' between ? and ? and cast(item.produto ->> 'valor' as numeric) > 0 AND (? = 'nao_filtrar_ie' OR inscricao_estadual =?) group by item.produto ->> 'codigo', item.produto ->> 'nome', item.produto ->> 'codigo_ncm', item.produto ->> 'descricao_unidade_medida' order by valor desc limit 100	0	31	10	29	6	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	165	294	181	0.00
select documentnf0_.key as key1_16_, documentnf0_.addressee_cpfcnpj as addresse2_16_, documentnf0_.addressee_name as addresse3_16_, documentnf0_.city_name as city_nam4_16_, documentnf0_.competency_date as competen5_16_, documentnf0_.data_emissao as data_emi6_16_, documentnf0_.type as type7_16_, documentnf0_.group_type as group_ty8_16_, documentnf0_.ibge_city_code as ibge_cit9_16_, documentnf0_.imported_at as importe10_16_, documentnf0_.iss_value as iss_val11_16_, documentnf0_.issuer_cpfcnpj as issuer_12_16_, documentnf0_.issuer_name as issuer_13_16_, documentnf0_.name_file as name_fi14_16_, documentnf0_.number as number15_16_, documentnf0_.opcao_simples as opcao_s16_16_, documentnf0_.opting_simple as opting_17_16_, documentnf0_.other_information as other_i18_16_, documentnf0_.rps_number as rps_num19_16_, documentnf0_.rps_serie as rps_ser20_16_, documentnf0_.service_code as service21_16_, documentnf0_.service_description as service22_16_, documentnf0_.status as status23_16_, documentnf0_.uf_initial as uf_init24_16_, documentnf0_.value as value25_16_, documentnf0_.verification_code as verific26_16_ 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	1	324	324	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	31	9	48	8	0.00
select codigoserv0_.id as id1_34_, codigoserv0_.cnpj as cnpj2_34_, codigoserv0_.codigo as codigo3_34_, codigoserv0_.descricao as descrica4_34_ from codigo_servico_nfse_empresa codigoserv0_ where codigoserv0_.cnpj=?	0	8	31	160	53	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	124	223	140	0.00
select documentct0_.cnpj_issuer as cnpj_iss1_9_, documentct0_.type as type2_9_, documentct0_.key as key3_9_, documentct0_.nsu as nsu4_9_, documentct0_.protocol as protocol5_9_, documentct0_.addressee_cnpj_cpf as addresse6_9_, documentct0_.addressee_inscricao_estadual as addresse7_9_, documentct0_.addressee_name as addresse8_9_, documentct0_.available_at as availabl9_9_, documentct0_.canceled_at as cancele10_9_, documentct0_.chaves_nfe_associadas_sistema as chaves_11_9_, documentct0_.chaves_nfe_documento as chaves_12_9_, documentct0_.cnpj_carrier as cnpj_ca13_9_, documentct0_.cnpj_cpf_remetente as cnpj_cp14_9_, documentct0_.cst as cst15_9_, documentct0_.data_emissao as data_em16_9_, documentct0_.expedidor_cnpj as expedid17_9_, documentct0_.expedidor_inscricao_estadual as expedid18_9_, documentct0_.expedidor_nome as expedid19_9_, documentct0_.issuer_inscricao_estadual as issuer_20_9_, documentct0_.issuer_name as issuer_21_9_, documentct0_.manifestation as manifes22_9_, documentct0_.name_file as name_fi23_9_, documentct0_.numero_cte as numero_24_9_, documentct0_.picms as picms25_9_, documentct0_.recebedor_cnpj_cpf as recebed26_9_, documentct0_.recebedor_inscricao_estadual as recebed27_9_, documentct0_.recebedor_nome as recebed28_9_, documentct0_.remetente_cnpj_cpf as remeten29_9_, documentct0_.remetente_inscricao_estadual as remeten30_9_, documentct0_.remetente_nome as remeten31_9_, documentct0_.schema as schema32_9_, documentct0_.serial as serial33_9_, documentct0_.status as status34_9_, documentct0_.tipo_cte as tipo_ct35_9_, documentct0_.tipo_tomador_servico as tipo_to36_9_, documentct0_.tomador4_cnpj as tomador37_9_, documentct0_.tomador4_inscricao_estadual as tomador38_9_, documentct0_.tomador4_nome as tomador39_9_, documentct0_.value as value40_9_, documentct0_.vbc as vbc41_9_, documentct0_.vicms as vicms42_9_ 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	6	40	75	34	0.00
select item.produto ->> 'codigo' as codigo, item.produto ->> 'nome' as nome, item.produto ->> 'codigo_ncm' as codigoNcm, item.produto ->> 'descricao_unidade_medida' as descricaoUnidadeMedida, sum(cast(item.produto ->> 'valor' as numeric)) as valor, sum(cast(item.produto ->> 'quantidade' as numeric)) as quantidade, sum(cast(item.produto ->> 'valor' as numeric)) / sum(cast(item.produto ->> 'quantidade' as numeric)) as valorUnitario, max(data_processamento) as dataProcessamento, max(duracao_ultimo_processamento) as duracaoUltimoProcessamento from cnpj_consolidation, jsonb_array_elements(data -> 'produtos_comprados') with ordinality item(produto) where cnpj in (?) and tipo_consolidacao = 'ANALISE_REPRESENTATIVIDADE' and item.produto ->> 'periodo' between ? and ? and cast(item.produto ->> 'valor' as numeric) > 0 AND (? = 'nao_filtrar_ie' OR inscricao_estadual =?) group by item.produto ->> 'codigo', item.produto ->> 'nome', item.produto ->> 'codigo_ncm', item.produto ->> 'descricao_unidade_medida' order by valor desc limit 100	0	31	6	27	4	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	12	16	104	28	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?) AND d.data_emissao BETWEEN ? AND ?	0	21	9	24	7	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.key=? and (documentnf0_.type in (? , ? , ? , ?)) and (documentnf0_.data_emissao between ? and ?)	0	7	27	31	2	0.00
select configurac0_.id as id1_36_, configurac0_.ativa as ativa2_36_, configurac0_.descricao as descrica3_36_, configurac0_.grupo as grupo4_36_, configurac0_.habilitar_taxa_selic as habilita5_36_, configurac0_.nome_atributo_consolidacao as nome_atr6_36_, configurac0_.nome_fila as nome_fil7_36_, configurac0_.origem_contribuicoes as origem_c8_36_, configurac0_.origem_ecd as origem_e9_36_, configurac0_.origem_ecf as origem_10_36_, configurac0_.origem_esocial as origem_11_36_, configurac0_.origem_icms_ipi as origem_12_36_, configurac0_.origem_xml as origem_13_36_, configurac0_.tipo_consolidacao as tipo_co14_36_, configurac0_.tipo_imposto as tipo_im15_36_, configurac0_.tipo_tese as tipo_te16_36_, configurac0_.versao_consolidacao as versao_17_36_, configurac0_.vigencia_final as vigenci18_36_, configurac0_.vigencia_inicial as vigenci19_36_ from configuracao_consolidacao configurac0_ where configurac0_.grupo=? and (configurac0_.tipo_imposto is not null) and configurac0_.ativa=true	0	62	3	8	1	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	94	132	53	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	33	5	14	2	0.00
select featurefla0_.code as code1_63_, featurefla0_.value as value2_63_ from feature_flag featurefla0_	0	30	5	36	6	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	174	174	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	5	34	127	52	0.00
SELECT d.key, d.cnpj_issuer as cnpjIssuer, d.cnpj_addressee as cnpjAddressee, d.type, d.data, d.info, d.imported_at as importedAt, d.name_file as nameFile, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d WHERE d.data_emissao BETWEEN (?) AND (?) AND d.cnpj_issuer = ? AND d.group_type = 'NFSE' AND d.info ->> 'status' = 'NORMAL' order by d.key desc limit ? offset ?	0	42	3	10	1	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	81	147	93	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	154	154	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	76	141	91	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	147	147	0	0.00
select key, type, cast(data->'header'->>'version' as text) as version, cast(data->'header'->>'endsDate' as date) as periodo, cast(data->'header'->>'endsDate' as date) as periodoFinal, cast(data->'header'->>'startsDate' as date) as periodoInicial, cast(data->'header'->>'ecdType' as text) as ecdType, cast(data->'header'->>'ecfType' as text) as ecfType, cast(data->'header'->>'finalType' as text) as purpose, name_file as nameFile, cnpj, cast(data->'header'->>'deliveryDate' as timestamp) as deliveryDate, info->>'originalFileName' as fileNameOriginal, inscricao_estadual as inscricaoEstadual, cast(coalesce(data -> 'header' ->> 'parcial','false') as boolean) as parcial from document where key = ? and group_type = 'SPED' and data_emissao between ? and ?	0	17	8	16	4	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	143	143	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	7	19	55	19	0.00
select configurac0_.tipo_consolidacao as col_0_0_ from configuracao_consolidacao configurac0_ where (configurac0_.grupo is not null) and configurac0_.ativa=true	0	31	4	19	3	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	4	30	33	2	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	121	121	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	4	29	32	2	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	16	3	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	114	114	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	3	37	93	48	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ from public.document_nfe_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.key in (?)) and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_addressee=? order by documentnf0_.data_emissao desc limit ?	0	2	51	56	6	0.00
select configurac0_.id as id1_36_, configurac0_.ativa as ativa2_36_, configurac0_.descricao as descrica3_36_, configurac0_.grupo as grupo4_36_, configurac0_.habilitar_taxa_selic as habilita5_36_, configurac0_.nome_atributo_consolidacao as nome_atr6_36_, configurac0_.nome_fila as nome_fil7_36_, configurac0_.origem_contribuicoes as origem_c8_36_, configurac0_.origem_ecd as origem_e9_36_, configurac0_.origem_ecf as origem_10_36_, configurac0_.origem_esocial as origem_11_36_, configurac0_.origem_icms_ipi as origem_12_36_, configurac0_.origem_xml as origem_13_36_, configurac0_.tipo_consolidacao as tipo_co14_36_, configurac0_.tipo_imposto as tipo_im15_36_, configurac0_.tipo_tese as tipo_te16_36_, configurac0_.versao_consolidacao as versao_17_36_, configurac0_.vigencia_final as vigenci18_36_, configurac0_.vigencia_inicial as vigenci19_36_ from configuracao_consolidacao configurac0_ where configurac0_.ativa=true	0	31	3	6	1	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	5	19	61	24	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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 substring(documentnf0_.cnpj_addressee, 1, 8)=? order by documentnf0_.nfe_number asc limit ?	0	1	95	95	0	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	8	10	41	12	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	80	80	0	0.00
select count(dsb.*) from document_batch_request dsb where dsb.cnpj = ? and date(dsb.created_at + interval '1 month') >= current_date	0	2	39	70	43	0.00
select count(*) as col_0_0_ 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=?	0	1	74	74	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	5	14	31	12	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	6	11	35	12	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	71	71	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	34	35	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	33	34	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	33	34	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	31	57	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	2	4	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	29	29	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	27	28	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	6	9	27	9	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	26	26	0	0.00
select etiqueta0_.id as id1_49_, etiqueta0_.cnpj_empresa as cnpj_emp2_49_, etiqueta0_.cor_etiqueta as cor_etiq3_49_, etiqueta0_.etiqueta_padrao as etiqueta4_49_, etiqueta0_.id_conta as id_conta5_49_, etiqueta0_.nome_etiqueta as nome_eti6_49_ 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	10	4	10	2	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	48	48	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	3	14	20	5	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	44	44	0	0.00
insert into public.document_load_batch_request (cnpj, account_id, created_at, created_by, info, last_updated, message, status, total, type) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)	0	6	7	10	2	0.00
select documentwi0_.key as key3_4_, documentwi0_.data as data10_4_, documentwi0_.data_emissao as data_em11_4_, documentwi0_.type as type2_4_ from public.document documentwi0_ where (documentwi0_.key in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) and (documentwi0_.type in (? , ?)) and (documentwi0_.data_emissao between ? and ?)	0	5	8	14	4	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	8	12	3	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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	40	40	0	0.00
select documentoc0_.file_name as file_nam1_11_0_, documentoc0_.document_load_batch_request_id as document2_11_0_, documentoc0_.description as descript3_11_0_, documentoc0_.status as status4_11_0_, documentoc0_.type as type5_11_0_ from public.document_load_validations documentoc0_ where documentoc0_.file_name=? and documentoc0_.document_load_batch_request_id=?	0	6	6	10	3	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	4	9	11	2	0.00
WITH consultaNfeCfe AS ( SELECT 'NFE_CFE_EMITIDA' AS notaEmitida FROM document d WHERE d.type IN ('NFE_3_1', 'NFE_4_0', 'CFE_0_6', 'CFE_00_6', 'CFE_0_7', 'CFE_00_7', 'CFE_0_8','CFE_0_9','CFE_0_10') AND d.cnpj_issuer = ? AND d.data_emissao BETWEEN ? AND ? LIMIT 1 ), consultaCte AS ( SELECT 'CTE_EMITIDA' AS notaEmitida FROM document d WHERE d.type = 'CTE' AND d.cnpj_issuer = ? AND d.data_emissao BETWEEN ? AND ? LIMIT 1 ) SELECT notaEmitida FROM consultaNfeCfe UNION ALL SELECT notaEmitida FROM consultaCte	0	5	7	13	3	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_13_, documentnf0_.type as type2_13_, documentnf0_.key as key3_13_, documentnf0_.nsu as nsu4_13_, documentnf0_.protocol as protocol5_13_, documentnf0_.addressee_name as addresse6_13_, documentnf0_.available_at as availabl7_13_, documentnf0_.canceled_at as canceled8_13_, documentnf0_.canhoto_associado_at as canhoto_9_13_, documentnf0_.canhoto_diferenca_dias_associacao as canhoto10_13_, documentnf0_.canhoto_id as canhoto11_13_, documentnf0_.canhoto_numero_nota as canhoto12_13_, documentnf0_.carta_correcao as carta_c13_13_, documentnf0_.cce_events as cce_eve14_13_, documentnf0_.cfops as cfops15_13_, documentnf0_.chaves_cte_associadas_sistema as chaves_16_13_, documentnf0_.cnpj as cnpj17_13_, documentnf0_.cnpj_addressee as cnpj_ad18_13_, documentnf0_.cnpj_carrier as cnpj_ca19_13_, documentnf0_.data as data20_13_, documentnf0_.data_emissao as data_em21_13_, documentnf0_.duplicatas as duplica22_13_, documentnf0_.etiquetas as etiquet23_13_, documentnf0_.fatura as fatura24_13_, documentnf0_.issuer_name as issuer_25_13_, documentnf0_.manifestation as manifes26_13_, documentnf0_.name_file as name_fi27_13_, documentnf0_.nfe_number as nfe_num28_13_, documentnf0_.notas_referencia as notas_r29_13_, documentnf0_.status as status30_13_, documentnf0_.value as value31_13_ 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	1	33	33	0	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	4	7	13	3	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	3	10	16	6	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	15	16	1	0.00
select documentnf0_.cnpj_issuer as cnpj_iss1_15_, documentnf0_.type as type2_15_, documentnf0_.key as key3_15_, documentnf0_.nsu as nsu4_15_, documentnf0_.protocol as protocol5_15_, documentnf0_.addressee_name as addresse6_15_, documentnf0_.available_at as availabl7_15_, documentnf0_.canceled_at as canceled8_15_, documentnf0_.carta_correcao as carta_co9_15_, documentnf0_.cce_events as cce_eve10_15_, documentnf0_.cfops as cfops11_15_, documentnf0_.chaves_cte_associadas_sistema as chaves_12_15_, documentnf0_.cnpj as cnpj13_15_, documentnf0_.cnpj_addressee as cnpj_ad14_15_, documentnf0_.cnpj_carrier as cnpj_ca15_15_, documentnf0_.data as data16_15_, documentnf0_.data_emissao as data_em17_15_, documentnf0_.duplicatas as duplica18_15_, documentnf0_.etiquetas as etiquet19_15_, documentnf0_.fatura as fatura20_15_, documentnf0_.issuer_name as issuer_21_15_, documentnf0_.manifestation as manifes22_15_, documentnf0_.name_file as name_fi23_15_, documentnf0_.nfe_number as nfe_num24_15_, documentnf0_.notas_referencia as notas_r25_15_, documentnf0_.status as status26_15_, documentnf0_.value as value27_15_ 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	28	28	0	0.00
/* BATCH */ insert into public.document_load_validations (description, status, type, file_name, document_load_batch_request_id) values (?, ?, ?, ?, ?)	0	6	4	7	1	0.00
update document_load_batch_request set status = ?, last_updated = now() where id = ? ;	0	6	4	16	5	0.00
SET parallel_setup_cost = 1000000	0	6	4	13	4	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	13	14	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	12	13	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	3	8	18	8	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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 ? offset ?	0	2	12	13	0	0.00
select document0_.cnpj_issuer as cnpj_iss1_4_, document0_.type as type2_4_, document0_.key as key3_4_, document0_.nsu as nsu4_4_, document0_.protocol as protocol5_4_, document0_.cnpj as cnpj6_4_, document0_.cnpj_addressee as cnpj_add7_4_, document0_.cnpj_carrier as cnpj_car8_4_, document0_.cnpj_cpf_remetente as cnpj_cpf9_4_, document0_.data as data10_4_, document0_.data_emissao as data_em11_4_, document0_.group_type as group_t12_4_, document0_.gzip as gzip13_4_, document0_.import_type as import_14_4_, document0_.imported_at as importe15_4_, document0_.info as info16_4_, document0_.inscricao_estadual as inscric17_4_, document0_.name_file as name_fi18_4_, document0_.schema as schema19_4_ from public.document document0_ where (document0_.type in ('NFE_4_0' , 'NFE_3_1' , 'NFE_2_0')) and (document0_.key in (? , ? , ? , ?)) and (document0_.data_emissao between ? and ?)	0	1	25	25	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	25	25	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	2	11	16	7	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	3	7	14	5	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	21	21	0	0.00
SELECT total = (select count(dvl.*) from document_load_validations dvl where dvl.document_load_batch_request_id = ? AND dvl.status = ?) FROM document_load_batch_request WHERE id = ? ;	0	6	3	4	0	0.00
update document_load_validations set status = ? where document_load_batch_request_id = ? and file_name = ? ;	0	6	2	3	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	16	16	0	0.00
SET parallel_tuple_cost = 1000000	0	6	2	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 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	14	14	0	0.00
insert into documento_ausente_download_lote (data_atualizacao, data_criacao, checksum, cnpj, nome, planilha, quantidade_documentos, status, tipo_documento) values (?, ?, ?, ?, ?, ?, ?, ?, ?)	0	1	14	14	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_addressee = ? and d.type IN (?, ?, ?) and d.key in (?) and d.data_emissao between ? and ?	0	2	7	8	1	0.00
select documentoa0_.chave_acesso as col_0_0_ from documento_ausente_download documentoa0_ where documentoa0_.chave_acesso in (?)	0	1	13	13	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	13	13	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	2	6	8	2	0.00
insert into documento_ausente_download (chave_acesso, documento_ausente_download_lote_id, quantidade_tentativas, status, ultima_tentativa) values (?, ?, ?, ?, ?)	0	1	13	13	0	0.00
/*+ Set(parallel_setup_cost 1000000) Set(parallel_tuple_cost 1000000) */ 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	2	5	6	0	0.00
select documentcf0_.cnpj_issuer as cnpj_iss1_6_, documentcf0_.type as type2_6_, documentcf0_.key as key3_6_, documentcf0_.nsu as nsu4_6_, documentcf0_.protocol as protocol5_6_, documentcf0_.cnpj as cnpj6_6_, documentcf0_.addressee_cnpj as addresse7_6_, documentcf0_.addressee_name as addresse8_6_, documentcf0_.addressee_type as addresse9_6_, documentcf0_.cfe_type as cfe_typ10_6_, documentcf0_.coupon_number as coupon_11_6_, documentcf0_.data_emissao as data_em12_6_, documentcf0_.imported_at as importe13_6_, documentcf0_.issuer_cnpj as issuer_14_6_, documentcf0_.issuer_name as issuer_15_6_, documentcf0_.name_file as name_fi16_6_, documentcf0_.serie_sat as serie_s17_6_, documentcf0_.status as status18_6_, documentcf0_.valor as valor19_6_ from public.document_cfe_view documentcf0_ where documentcf0_.data_emissao<=? and documentcf0_.data_emissao>=? and (documentcf0_.type in (? , ? , ? , ? , ? , ? , ?)) and documentcf0_.cnpj_issuer=? order by documentcf0_.data_emissao desc limit ?	0	2	5	6	1	0.00
select canhotoimp0_.id as id1_27_, canhotoimp0_.cnpj as cnpj2_27_, canhotoimp0_.created_at as created_3_27_, canhotoimp0_.created_by as created_4_27_, canhotoimp0_.descricao as descrica5_27_ from canhoto_importacao_lote canhotoimp0_ where canhotoimp0_.cnpj=? order by canhotoimp0_.created_at desc limit ?	0	1	9	9	0	0.00
select featurefla0_.code as code1_63_, featurefla0_.value as value2_63_ from feature_flag featurefla0_ where featurefla0_.code=?	0	2	4	5	1	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_.bcicms as bcicms8_12_, documentnf0_.bcicmsst as bcicmsst9_12_, documentnf0_.canceled_at as cancele10_12_, documentnf0_.cce_events as cce_eve11_12_, documentnf0_.cnpj as cnpj12_12_, documentnf0_.cnpj_addressee as cnpj_ad13_12_, documentnf0_.cnpj_carrier as cnpj_ca14_12_, documentnf0_.data_emissao as data_em15_12_, documentnf0_.issuer_name as issuer_16_12_, documentnf0_.model as model17_12_, documentnf0_.name_file as name_fi18_12_, documentnf0_.nfe_number as nfe_num19_12_, documentnf0_.receiveruf as receive20_12_, documentnf0_.serie_number as serie_n21_12_, documentnf0_.status as status22_12_, documentnf0_.v_cofins as v_cofin23_12_, documentnf0_.vicms as vicms24_12_, documentnf0_.vipi as vipi25_12_, documentnf0_.v_other as v_other26_12_, documentnf0_.vpis as vpis27_12_, documentnf0_.v_prod as v_prod28_12_, documentnf0_.vst as vst29_12_, documentnf0_.value as value30_12_ from public.document_nfce_view documentnf0_ where documentnf0_.data_emissao<=? and documentnf0_.data_emissao>=? and (documentnf0_.type in (? , ? , ?)) and documentnf0_.cnpj_issuer=? order by documentnf0_.data_emissao desc limit ?	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	2	2	3	0	0.00
SELECT d.key, d.cnpj_issuer as issuerCnpj, d.cnpj_addressee as addresseeCnpj, d.type, d.data, d.info, d.nsu, ds.status, d.imported_at as importedAt, d.data_emissao as dataEmissao, d.data_entrada_saida as dataEntradaSaida FROM document d LEFT 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.key IN (?, ?, ?, ?, ?, ?, ?) AND d.data_emissao BETWEEN ? AND ?	0	1	4	4	0	0.00
/* BATCH */ update documento_ausente_download_lote set data_atualizacao=?, data_criacao=?, checksum=?, cnpj=?, nome=?, planilha=?, quantidade_documentos=?, status=?, tipo_documento=? where id=?	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 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	1	4	4	0	0.00
select count(canhotoimp0_.id) as col_0_0_ from canhoto_importacao_lote canhotoimp0_ where canhotoimp0_.cnpj=?	0	1	4	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	1	3	3	0	0.00
select etiqueta0_.id as id1_49_, etiqueta0_.cnpj_empresa as cnpj_emp2_49_, etiqueta0_.cor_etiqueta as cor_etiq3_49_, etiqueta0_.etiqueta_padrao as etiqueta4_49_, etiqueta0_.id_conta as id_conta5_49_, etiqueta0_.nome_etiqueta as nome_eti6_49_ 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	1	3	3	0	0.00

Statistics spring - 1 day since midnight

12,410 hits/min on 105 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	34	630,523	10	471	7	1	0	45	0.00	1	7
CreditoPisCofinsFreteInsumosAliquotaZeroServiceImpl.consultar	34	630,523	10	471	7	1	0	43	0.00	1	7
DocumentController.cruzamentoEfdNfse	5	5	237,268	1,015,241	436,710	0	1	94	0.00	0	0
DocumentService.cruzamentoEfdNfse	5	5	237,266	1,015,239	436,710	0	0	73	0.00	0	0
DocumentController.getDocumentsNFEV2	3	155	4,489	116,082	14,818	1	3	1,090	0.00	2	4,478
DocumentNfeViewQueryService.findDocumentsWithData	3	154	4,513	116,077	14,862	1	3	1,074	0.00	2	4,507
CreditoTeseArtigo426AController.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	3	2,256	287	26,455	1,105	0	0	57	0.00	1	283
CreditoTeseArtigo426AServiceImpl.consultarCreditoTeseArtigo426AByCnpjAndPeriodoAndInCodigoNcm	3	2,256	287	26,455	1,105	0	0	56	0.00	1	283
DocumentController.getDocumentsNFECanhoto	0	3	53,140	83,233	46,113	0	4	935	0.00	2	53,132
DocumentNfeCanhotoViewQueryService.findDocumentsWithData	0	3	53,136	83,229	46,112	0	4	928	0.00	2	53,132
DocumentController.getDocumentsObrigacoes	0	42	1,492	6,039	1,622	0	1	189	0.00	1	1,484
DocumentObrigacoesViewQueryService.findDocuments	0	42	1,487	6,036	1,622	0	1	177	0.00	1	1,484
DocumentController.listDocumentsByKeys	0	400	144	928	199	17	13	11,636	0.00	1	130
DocumentService.listDocumentsByKeys	0	400	141	926	199	17	13	11,630	0.00	1	130
DocumentController.analiseRepresentatividadeConsolidada	0	29	1,749	6,952	1,465	0	5	2,490	0.00	2	17
DocumentService.analiseRepresentatividadeConsolidadaGrafico	0	29	1,746	6,950	1,465	0	5	2,484	0.00	2	17
FiscalntelligenceCoreService.findAnaliseClienteFornecedor	0	29	1,723	6,940	1,468	0	0	99	0.00	0	0
NfeServiceImpl.downloadExcel	0	4	9,331	12,636	3,774	3	267	46,755	0.00	74	8,035
ExportadorNfeParaExcelImpl.exportar	0	4	8,241	11,456	3,732	1	91	21,149	0.00	61	7,986
DocumentNfeViewQueryService.findDocumentsNfeViewWithData	0	224	146	803	189	0	0	302	0.00	1	142
SolicitacaoDownloadNfeController.consultarProcessamentos	0	134	197	2,720	319	0	0	104	0.00	1	194
SolicitacaoDownloadNfeServiceImpl.findSolicitacaoDownloadNfe	0	134	197	2,720	319	0	0	98	0.00	1	194
ConsumoDocumentosContaEmpresaController.cosumoDocumentosPorConta	0	12	2,045	2,438	232	0	16	6,452	0.00	1	2,029
ConsumoDocumentosContaEmpresaServiceImp.consultarQuantidadeDocumentosUtilizadosNoMesConta	0	12	2,044	2,438	232	0	16	6,325	0.00	1	2,029
ReportController.generateNfeReport	0	71	197	1,026	145	10	45	19,337	0.00	3	146
GeradorPdfNfeServiceImpl.generatePdfByKey	0	71	196	1,022	145	10	45	19,318	0.00	3	146
EmailController.generateZipNfe	0	1	11,693	11,693	0	0	198	33,018	0.00	9	10,529
EmailDocumentosService.generateEmailByFilterAndBatchTypeAndDocumentGroupTypeAndTipoEmailDocumento	0	1	11,690	11,690	0	0	195	31,528	0.00	9	10,529
DownloadService.gerarDocumentos	0	1	11,689	11,689	0	0	194	30,537	0.00	9	10,529
DocumentNfeCanhotoViewQueryService.findDocumentNfe	0	1	10,499	10,499	0	0	4	1,458	0.00	1	10,492
DocumentController.findOportunidadeTeseJuridicaCnpjResumida	0	31	313	602	98	4	46	22,479	0.00	20	236
DocumentService.findOportunidadeTeseJuridicaCnpjResumida	0	31	309	597	98	4	45	22,342	0.00	20	236
DocumentController.listNfseByCnpjAndPeriod	0	495	11	138	13	0	0	213	0.00	1	7
DocumentController.listDocumentsByCnpjAndPeriod	0	149	37	282	52	2	5	4,414	0.00	1	29
NextGenService.obterCnpjMatrizEFiliais	0	5	1,086	1,334	491	0	0	27	0.00	0	0
DocumentService.listDocumentsByCnpjAndPeriod	0	149	34	273	52	2	5	4,407	0.00	1	29
DocumentService.listNfseByCnpjAndPeriod	0	495	8	135	13	0	0	206	0.00	1	7
DividaAtivaRegularizeQueryServiceImpl.consultarTotal	0	31	87	169	51	0	1	242	0.00	0	59
NextGenService.obterDadosConta	0	4	647	817	117	0	0	21	0.00	0	0
CnpjConsolidationServiceImpl.findOportunidadeTeseJuridicaCnpj	0	31	69	207	30	3	33	19,298	0.00	13	35
DownloadService.retornarTodasSolicitacoesDeDownload	0	2	672	1,315	908	0	10	2,361	0.00	2	660
DownloadController.retornarTodasSolicitacoesDeDownload	0	2	672	1,315	908	0	10	2,363	0.00	2	660
DownloadController.downloadNfsePdfZipOnline	0	1	1,260	1,260	0	0	136	17,283	0.00	2	332
DownloadService.downloadNfsePdfZip	0	1	1,258	1,258	0	0	133	15,413	0.00	2	332
GeradorPdfNfseServiceImpl.generatePdfByNfseDTO	0	1	1,252	1,252	0	0	128	14,129	0.00	2	332
DocumentController.getNfse	0	6	165	700	265	0	4	599	0.00	1	125
DocumentService.findDocumentNfseDto	0	6	160	697	265	0	3	585	0.00	1	125
NextGenService.getRvzByCnpj	0	31	27	69	8	0	0	82	0.00	0	0
EtiquetaController.listarEtiquetas	0	11	73	201	57	0	8	1,677	0.00	1	4
EtiquetaServiceImpl.consultarEtiquetas	0	11	72	201	56	0	8	1,598	0.00	1	4
DocumentNfseViewQueryService.findDocumentNfse	0	6	127	661	261	0	1	245	0.00	1	125
DocumentController.getProductsNfe	0	7	108	361	116	0	0	84	0.00	1	102
DocumentService.findProductDescriptionByCnpjAndCfop	0	7	105	358	116	0	0	78	0.00	1	102
CoreApiServiceImpl.consultaContasPorIds	0	11	56	151	43	0	2	589	0.00	0	0
ReportController.generateCteReport	0	2	236	382	206	0	49	11,460	0.00	2	179
GeradorPdfCteServiceImpl.generatePdfByKey	0	2	236	382	206	0	49	11,453	0.00	2	179
AnaliseRepresentatividadeServiceImpl.consultarProdutosVendidos	0	31	13	30	6	0	1	797	0.00	1	10
DocumentController.findCodigosServicosNfse	0	8	50	197	60	0	4	736	0.00	2	41
AwsService.uploadInBucketCustom	0	4	100	153	50	0	24	4,570	0.00	0	0
DocumentController.getDocumentsCte	0	6	65	108	42	0	5	1,559	0.00	4	56
DocumentCteViewQueryService.findDocumentsWithData	0	6	63	105	42	0	5	1,513	0.00	4	56
DocumentNfseViewQueryService.findCodigosServicosNfse	0	8	46	195	61	0	4	711	0.00	2	41
FeatureFlagController.listarTodas	0	30	12	63	12	0	1	182	0.00	1	5
FiscalntelligenceCoreService.buscarServicos	0	1	347	347	0	0	0	42	0.00	0	0
SolicitacaoDownloadDocumentoBatchServiceImpl.atualizarPassos	0	16	19	39	6	0	3	365	0.00	3	10
DownloadService.getFileXmlInS3ByTypeAndKey	0	7	42	53	5	0	3	374	0.00	2	32
DownloadController.retornaBytesXmlZipadoPelaChaveNfe	0	7	42	53	5	0	3	376	0.00	2	32
DocumentController.solicitarDownloadDocumentosCancelados	0	1	293	293	0	0	169	30,668	0.00	5	69
NextGenService.obterTodasCidades	0	1	284	284	0	0	8	2,200	0.00	0	0
AnaliseRepresentatividadeServiceImpl.consultarProdutosComprados	0	31	9	28	5	0	1	1,451	0.00	1	6
DocumentController.findSpedByKey	0	17	16	47	9	0	2	773	0.00	1	8
DocumentService.realizarBaixaDocumentosSeNaoExistirNaBase	0	1	278	278	0	0	163	29,450	0.00	4	65
FeatureFlagService.listarTodas	0	30	8	43	9	0	0	131	0.00	1	5
DocumentNfeViewQueryService.findByKey	0	7	35	40	2	0	1	190	0.00	1	27
DocumentoAusenteDownloadLoteService.salvarLoteComChavesDeAcesso	0	1	241	241	0	0	155	28,704	0.00	3	40
DocumentService.findSpedByKey	0	17	13	38	8	0	2	519	0.00	1	8
UploadS3Controller.documentsGenerateGrupo	0	6	37	62	14	0	7	1,237	0.00	3	18
UploadService.gerarLoteDeUpload	0	6	36	59	13	0	7	1,086	0.00	3	18
CoreApiServiceImpl.buscarCidades	0	4	49	71	20	0	2	465	0.00	0	0
EtiquetaQueryService.listarEtiquetas	0	11	12	49	12	0	1	219	0.00	1	4
UploadS3Controller.triggerSuccessUploadDireclyS3	0	6	18	29	5	0	2	131	0.00	3	10
AwsService.uploadFileInBucketCustom	0	1	110	110	0	0	11	1,258	0.00	0	0
UploadService.registrarSucessoAoRealizarUploadParaUmArquivoDiretoParaS3	0	6	18	29	5	0	2	128	0.00	3	10
NextGenService.findAtividadeEconomica	0	1	107	107	0	0	0	25	0.00	0	0
SolicitacaoDownloadDocumentoBatchServiceImpl.inserir	0	4	17	24	5	0	3	415	0.00	1	8
SalvaDocumentoAusenteDownloadLoteService.salvar	0	1	66	66	0	0	45	10,202	0.00	1	14
DocumentController.findNotaEmitidaNfeCfeCteByCnpjPeriod	0	5	12	20	5	0	0	81	0.00	1	7
CanhotoImportacaoController.listarLotesPorCnpjPaginado	0	1	52	52	0	0	10	2,518	0.00	2	13
DocumentService.findNotaEmitidaNfeCfeCteByCnpjPeriod	0	5	10	17	4	0	0	73	0.00	1	7
CanhotoImportacaoLoteServiceImpl.listarLotesPorCnpj	0	1	50	50	0	0	8	1,516	0.00	2	13
AwsService.getFileFromS3	0	1	45	45	0	0	18	2,928	0.00	0	0
SalvaChavesAcessoDocumentoAusenteDownloadService.salvar	0	1	35	35	0	0	9	1,486	0.00	2	26
DocumentController.getDocumentsCFEV2	0	2	16	19	4	0	3	995	0.00	2	7
CoreApiServiceImpl.consultarUsuariosEmailNomePorIds	0	1	31	31	0	0	2	471	0.00	0	0
DocumentCfeViewQueryService.findDocumentsWithData	0	2	13	17	4	0	3	987	0.00	2	7
AwsService.documentsGeneratePresigned	0	6	4	15	5	0	3	743	0.00	0	0
DocumentNfceViewQueryService.findDocumentWithData	0	1	17	17	0	0	5	2,202	0.00	2	9
FeatureFlagService.getIntegerValueByCode	0	1	9	9	0	0	1	132	0.00	1	5
FeatureFlagService.getLongValueByCode	0	1	6	6	0	0	0	36	0.00	1	3
DownloadNfeController.exportarExcel	0	4	1	4	1	0	0	189	0.00	0	0
AwsService.getBucketNameDocumentDownload	0	6	0	3	1	0	0	202	0.00	0	0
BasicErrorController.error	0	15	0	2	0	0	0	88	0.00	0	0
SalvaDocumentoAusenteDownloadLoteService.concluirImportacaoChaves	0	1	2	2	0	0	2	211	0.00	0	0
AuditorAwareImpl.getCurrentAuditor	0	2	0	1	0	0	0	277	0.00	0	0
ServerController.version	0	53	0	1	0	0	0	10	0.00	0	0

Statistics http system errors - 1 day since midnight

0 hits/min on 1 errors       Details       Last errors      

Statistics system errors logs - 1 day since midnight

0 hits/min on 33 errors       Details       Last errors