SELECT * FROM PRC_COLLECT_RANKCATEGORY(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_COLLECT_RANKCATEGORY NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
1008 records fetched
77758 ms, 118651323 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
IDEFORM 152
GRUPO2 1796
WAREH 2001
CHANGE_VENDA 116534661
SELECT * FROM PRC_RANK_V2(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_RANK_V2 NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
1245 records fetched
77793 ms, 118215515 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
IDEFORM 1813
GRUPO2 152
WAREH 2018
CHANGE_VENDA 116106539
SELECT * FROM PRC_EM_NEWP(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_EM_NEWP NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
263 records fetched
76819 ms, 119281820 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
IDEFORM 152
GRUPO2 152
WAREH 2015
CHANGE_VENDA 117158777
SELECT * FROM PRC_SL_OLDCLIENTCHK(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_SL_OLDCLIENTCHK NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
1651 records fetched
67615 ms, 101512699 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ESTOQ 1651
IDEFORM 152
GRUPO2 152
WAREH 2006
CHANGE_VENDA 99698011
SELECT FIRST 500 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODMAR = '4069' AND ESTOQ.INATIVO = 0 AND ((ESTOQ.QUAMERCN > 0) OR ( (ESTOQ.CN01> 0) OR (ESTOQ.CN02> 0) OR (ESTOQ.CN03> 0) OR (ESTOQ.CN04> 0) OR (ESTOQ.CN05> 0) OR (ESTOQ.CN06> 0) OR (ESTOQ.CN07> 0) OR (ESTOQ.CN08> 0) OR (ESTOQ.CN09> 0) OR (ESTOQ.CN10> 0) OR (ESTOQ.CN11> 0) OR (ESTOQ.CN12> 0) OR (ESTOQ.CN13> 0) OR (ESTOQ.CN14> 0) OR (ESTOQ.CN15> 0) OR (ESTOQ.CN16> 0) OR (ESTOQ.CN17> 0) OR (ESTOQ.CN18> 0) OR (ESTOQ.CN19> 0) OR (ESTOQ.CN20> 0) OR (ESTOQ.CN21> 0) OR (ESTOQ.CN22> 0) OR (ESTOQ.CN23> 0) OR (ESTOQ.CN24> 0) OR (ESTOQ.CN25> 0) OR (ESTOQ.CN26> 0) OR (ESTOQ.CN27> 0) OR (ESTOQ.CN28> 0) OR (ESTOQ.CN29> 0) OR (ESTOQ.CN30> 0) OR (ESTOQ.CN31> 0) OR (ESTOQ.CN32> 0) OR (ESTOQ.CN33> 0) OR (ESTOQ.CN34> 0) OR (ESTOQ.CN35> 0) OR (ESTOQ.CN36> 0) OR (ESTOQ.CN37> 0) OR (ESTOQ.CN38> 0) OR (ESTOQ.CN39> 0) OR (ESTOQ.CN40> 0) ) )
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (ESTOQ INDEX (ESTOQ_IDX24), FILIAL INDEX (PK_FILIAL)), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
500 records fetched
13195 ms, 5872 read(s), 95663 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ALIQUO 482
ESTOQ 2998
ESTOQ 2998
FILIAL 500
IDEFORM 500
FORNEC 500
GRADE 500
WAREH 40766
SELECT
VENDAS.BOLETA,
SALES2.PARCELA,
SALES2.CODFIL,
SALES2.OPERACAO,
SALES2.VALNOT,
SALES2.DATNOT,
SALES2.NUMNOT,
SALES2.CODCLI,
SALES2.CODFUN,
SALES2.DATVEN,
SALES2.VALVEN,
SALES2.DATPAG,
SALES2.VALPAG,
SALES2.MARCARC,
SALES2.SPC,
SALES2.NOMCOM,
SALES2.REGDEB,
SALES2.CREDITO,
SALES2.MARCCOB,
SALES2.BANDOC,
SALES2.CREDREC,
SALES2.CREDTRO,
SALES2.TROCA,
SALES2.COBRADOR,
SALES2.ACORDO,
SALES2.DATBLOQ,
SALES2.CAMPUB,
SALES2.CONFERER,
SALES2.CONFEREP,
SALES2.CONFEREE,
SALES2.CONFEREV,
SALES2.CONFUSU,
SALES2.TERMINAL,
SALES2.MARCGRID,
SALES2.MULTAREC,
SALES2.JURREC,
SALES2.DESREC,
SALES2.COBREC,
SALES2.PARCDEB,
SALES2.FORPAG,
SALES2.BOLTRO,
SALES2.DATLAN,
SALES2.DATREC,
SALES2.CODFUNLAN,
SALES2.CODFUNLIB,
SALES2.BOLCOND,
SALES2.DTCOBVAL,
SALES2.PEDIDO,
SALES2.CODCONV,
SALES2.FISCAL,
SALES2.FILCOD,
SALES2.PREVENDA,
SALES2.CODCLI_CONVERT,
SALES2.BOLETA_CONVERT,
SALES2.FKCOB_TRANSACAO,
SALES2.COB_VALPAG,
SALES2.COB_DESREC,
SALES2.COB_JURREC,
SALES2.COB_COBREC,
SALES2.COB_MULTAREC,
SALES2.RISCO,
MODALI.MODALI,
CLIENT.NOMRAZ,
FUNCIO.NOMFUN,
FILIAL.NOMFIL,
CONVCLI.NOMCONV,
COB_TRANSACAO.STATUS AS STATUS_TRANSACAO,
VENDABASE.ECOMMERCE_ORDER_ID,
VENDABASE.FKPLUGGTOID,
VENDABASE.FRETE
FROM SALES2
LEFT OUTER JOIN CLIENT ON (SALES2.CODCLI = CLIENT.CODCLI)
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN FILIAL ON (SALES2.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN MODALI ON (SALES2.OPERACAO = MODALI.CODMODALI)
LEFT OUTER JOIN CONVCLI ON (SALES2.CODCONV = CONVCLI.CODCONV)
LEFT OUTER JOIN COB_TRANSACAO ON (SALES2.FKCOB_TRANSACAO = COB_TRANSACAO.ID)
LEFT OUTER JOIN SALESBASE ON (SALES2.CODFIL = VENDABASE.CODFIL) and (SALES2.boleta = VENDABASE.boleta) WHERE (SALES2.CODFIL = '12') AND (SALES2.DATNOT BETWEEN '01.02.2022' AND '30.12.2022') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX')) AND (SALES2.BANDOC NOT IN (SELECT BANCO.BANDOC FROM BANCO WHERE (BANCO.BANDOC = SALES2.BANDOC) AND BANCO.TIPO = 'ENTRADAS')) ORDER BY CLIENT.NOMRAZ,SALES2.DATNOT,SALES2.BOLETA,SALES2.PARCELA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN (BANCO INDEX (BANCO_IDX10))
PLAN (BANCO INDEX (BANCO_IDX10, BANCO_IDX10))
PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (SALES2 INDEX (SALES2_IDX2, SALES2_IDX9), CLIENT INDEX (PK_CLIENT)), FUNCIO INDEX (UNQ1_FUNCIO)), FILIAL INDEX (PK_FILIAL)), MODALI INDEX (PK_MODALI)), CONVCLI INDEX (PK_CONVCLI)), COB_TRANSACAO INDEX (PK_COB_TRANSACAO)), SALESBASE INDEX (PK_VENDABASE)))
20605 records fetched
10906 ms, 5250 read(s), 1113465 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
BANCO 32699
CLIENT 14558
FILIAL 20605
FUNCIO 20605
MODALI 64383
SALES2 23173
SALESBASE 20605
SELECT FIRST 100 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODFIL = '01' AND ESTOQ.CODMAR = '2450' AND ESTOQ.INATIVO = 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (ESTOQ INDEX (ESTOQ_IDX24, ESTOQ_IDX14), FILIAL INDEX (PK_FILIAL)), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
100 records fetched
8333 ms, 2617 read(s), 10214 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ALIQUO 78
ESTOQ 835
FILIAL 100
IDEFORM 100
FORNEC 99
GRADE 100
WAREH 3404
SELECT FIRST 100 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODFIL = '01' AND ESTOQ.CODMAR = '1640' AND ESTOQ.INATIVO = 0
order by 3 DESC
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (SORT (JOIN (ESTOQ INDEX (ESTOQ_IDX24, ESTOQ_IDX14), FILIAL INDEX (PK_FILIAL))), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
100 records fetched
7303 ms, 3085 read(s), 16052 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ALIQUO 93
ESTOQ 372
FILIAL 225
IDEFORM 100
FORNEC 100
GRADE 100
WAREH 6386
SELECT * FROM VIEW_CAIXA WHERE CODFIL = '16' AND DATMOV = '25.02.2023' AND FORMA = 'I' ORDER BY NOMRAZ
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (VIEW_CAIXA SALES2 INDEX (SALES2_IDX26))
PLAN (VIEW_CAIXA SALES2 INDEX (SALES2_IDX26))
PLAN JOIN (VIEW_CAIXA BANCO ORDER BANCO_IDX8 INDEX (BANCO_IDX32), VIEW_CAIXA FUNCIO INDEX (UNQ1_FUNCIO))
1 records fetched
7140 ms, 4583 read(s), 4858 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
BANCO 24
SALES2 2
SELECT FIRST 100 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODMER = '0000001985542'
AND ESTOQ.INATIVO = 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (ESTOQ INDEX (ESTOQ_IDX25), FILIAL INDEX (PK_FILIAL)), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
42 records fetched
6695 ms, 10 read(s), 1518 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ALIQUO 42
ESTOQ 42
FILIAL 42
IDEFORM 42
FORNEC 42
GRADE 42
WAREH 218
select SALES2.boleta, SALES2.codfil, SALES2.valnot, SALES2.datnot, SALES2.datven, SALES2.valven, SALES2.datpag, SALES2.valpag, SALES2.acordo, SALES2.codcli, SALES2.operacao, SALES2.parcela from SALES2
where
SALES2.boleta = ? and SALES2.codfil = ?
order by SALES2.datven
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (SALES2 ORDER SALES2_IDX6 INDEX (PK_SALES2))
param0 = varchar(8), "03344414"
param1 = varchar(2), "01"
6 records fetched
3188 ms, 6798 read(s), 7148 fetch(es)
select distinct SALES2.boleta, SALES2.codfil from SALES2
where SALES2.codcli = ? and (SALES2.acordo is null or SALES2.acordo = '') and
(SALES2.datpag >= '25.02.2020' or SALES2.datpag is null) and
(SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX') AND (SALES2.CREDREC > 0 /*OR (SALES2.ACORDO IS DISTINCT FROM '')*/ OR SALES2.DATPAG IS NULL OR SALES2.BANDOC IN (SELECT BANCO.BANDOC FROM BANCO WHERE BANCO.BANDOC = SALES2.BANDOC AND BANCO.ARQUI = 'SALES2' AND (BANCO.TIPO IN ('RECEB. CARNE','CHEQUES PRE REC','TROCO REC') OR SUBSTRING(BANCO.TIPO FROM 1 FOR 10) = 'CARTAO REC')))
order by SALES2.datven + 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN (BANCO INDEX (BANCO_IDX10))
PLAN SORT (SORT (SALES2 INDEX (SALES2_IDX31, SALES2_IDX31, SALES2_IDX14, SALES2_IDX14)))
param0 = varchar(8), "00410224"
1 records fetched
313 ms, 3943 fetch(es)
SELECT
CREDITO.*,
(SELECT FIRST 1 SALES2.CODFUN||'-'||FUNCIO.NOMFUN FROM SALES2 LEFT JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN) WHERE SALES2.BOLETA = CREDITO.BOLGER AND SALES2.CODFIL = CREDITO.CODFIL) AS "VENDORIGEM",
(SELECT FIRST 1 SALES2.CODFUN||'-'||FUNCIO.NOMFUN FROM SALES2 LEFT JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN) WHERE SALES2.BOLETA = CREDITO.BOLUSO AND SALES2.CODFIL = CREDITO.CODFILUSO) AS "VENDDESTINO"
FROM
CREDITO where 1=2
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN JOIN (SALES2 INDEX (PK_SALES2), FUNCIO INDEX (UNQ1_FUNCIO))
PLAN JOIN (SALES2 INDEX (PK_SALES2), FUNCIO INDEX (UNQ1_FUNCIO))
PLAN (CREDITO NATURAL)
0 records fetched
400 ms, 717712 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '14'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
3 records fetched
443 ms, 6046 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '14'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI INDEX (PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
3 records fetched
443 ms, 5377 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '05'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
4 records fetched
445 ms, 6046 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '05'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI INDEX (PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
4 records fetched
444 ms, 5374 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '06'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
2 records fetched
451 ms, 6802 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '06'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI INDEX (PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
1 records fetched
446 ms, 5893 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '16'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI INDEX (PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
0 records fetched
442 ms, 5371 fetch(es)
select SALES2.boleta, SALES2.codfil, SALES2.valnot, SALES2.datnot, SALES2.datven, SALES2.valven, SALES2.datpag, SALES2.valpag, SALES2.acordo, SALES2.codcli, SALES2.operacao, SALES2.parcela from SALES2
where
SALES2.boleta = ? and SALES2.codfil = ?
order by SALES2.datven
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (SALES2 ORDER SALES2_IDX6 INDEX (PK_SALES2))
param0 = varchar(8), "03344414"
param1 = varchar(2), "01"
6 records fetched
3188 ms, 6798 read(s), 7148 fetch(es)
SELECT * FROM PRC_COLLECT_RANKCATEGORY(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_COLLECT_RANKCATEGORY NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
123 records fetched
12357 ms, 18615774 fetch(es)
SELECT * FROM PRC_EM_NEWP(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_EM_NEWP NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
37 records fetched
12270 ms, 18382854 fetch(es)
SELECT * FROM PRC_RANK_V2(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_RANK_V2 NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
145 records fetched
11818 ms, 17964820 fetch(es)
SELECT * FROM PRC_SL_OLDCLIENTCHK(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_SL_OLDCLIENTCHK NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
169 records fetched
11153 ms, 16880230 fetch(es)
select distinct SALES2.boleta, SALES2.codfil from SALES2
where SALES2.codcli = ? and (SALES2.acordo is null or SALES2.acordo = '') and
(SALES2.datpag >= '25.02.2020' or SALES2.datpag is null) and
(SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX') AND (SALES2.CREDREC > 0 /*OR (SALES2.ACORDO IS DISTINCT FROM '')*/ OR SALES2.DATPAG IS NULL OR SALES2.BANDOC IN (SELECT BANCO.BANDOC FROM BANCO WHERE BANCO.BANDOC = SALES2.BANDOC AND BANCO.ARQUI = 'SALES2' AND (BANCO.TIPO IN ('RECEB. CARNE','CHEQUES PRE REC','TROCO REC') OR SUBSTRING(BANCO.TIPO FROM 1 FOR 10) = 'CARTAO REC')))
order by SALES2.datven + 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN (BANCO INDEX (BANCO_IDX10))
PLAN SORT (SORT (SALES2 INDEX (SALES2_IDX31, SALES2_IDX31, SALES2_IDX14, SALES2_IDX14)))
param0 = varchar(8), "00410224"
1 records fetched
313 ms, 3943 fetch(es)
insert into CLCONT
(ID, CODCLI, TELEFONE, DESCRICAO, RAMAL)
values
(?, ?, ?, ?, ?)
param0 = integer, "707491"
param1 = varchar(8), "00412209"
param2 = varchar(14), "(22)99874-2783"
param3 = varchar(30), "PROPRIO"
param4 = varchar(4), ""
0 records fetched
3663 ms, 3495502 fetch(es), 9 mark(s)
execute procedure PRC_SALESVL2_FORECAST(?, ?, ?)
param0 = varchar(13), "062487"
param1 = varchar(8), "005731"
param2 = varchar(4), "0449"
0 records fetched
2429 ms, 2571003 fetch(es), 37 mark(s)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '14'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
3 records fetched
443 ms, 6046 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '25.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '14'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI INDEX (PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
3 records fetched
443 ms, 5377 fetch(es)
SELECT * FROM PRC_COLLECT_RANKCATEGORY(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_COLLECT_RANKCATEGORY NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
123 records fetched
12357 ms, 18615774 fetch(es)
SELECT * FROM PRC_EM_NEWP(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_EM_NEWP NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
37 records fetched
12270 ms, 18382854 fetch(es)
SELECT * FROM PRC_RANK_V2(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_RANK_V2 NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
145 records fetched
11818 ms, 17964820 fetch(es)
SELECT * FROM PRC_SL_OLDCLIENTCHK(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_SL_OLDCLIENTCHK NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
169 records fetched
11153 ms, 16880230 fetch(es)
insert into CLCONT
(ID, CODCLI, TELEFONE, DESCRICAO, RAMAL)
values
(?, ?, ?, ?, ?)
param0 = integer, "707491"
param1 = varchar(8), "00412209"
param2 = varchar(14), "(22)99874-2783"
param3 = varchar(30), "PROPRIO"
param4 = varchar(4), ""
0 records fetched
3663 ms, 3495502 fetch(es), 9 mark(s)
SELECT
CREDITO.*,
(SELECT FIRST 1 SALES2.CODFUN||'-'||FUNCIO.NOMFUN FROM SALES2 LEFT JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN) WHERE SALES2.BOLETA = CREDITO.BOLGER AND SALES2.CODFIL = CREDITO.CODFIL) AS "VENDORIGEM",
(SELECT FIRST 1 SALES2.CODFUN||'-'||FUNCIO.NOMFUN FROM SALES2 LEFT JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN) WHERE SALES2.BOLETA = CREDITO.BOLUSO AND SALES2.CODFIL = CREDITO.CODFILUSO) AS "VENDDESTINO"
FROM
CREDITO where 1=2
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN JOIN (SALES2 INDEX (PK_SALES2), FUNCIO INDEX (UNQ1_FUNCIO))
PLAN JOIN (SALES2 INDEX (PK_SALES2), FUNCIO INDEX (UNQ1_FUNCIO))
PLAN (CREDITO NATURAL)
0 records fetched
400 ms, 717712 fetch(es)
execute procedure PRC_SALESVL2_FORECAST(?, ?, ?)
param0 = varchar(13), "062487"
param1 = varchar(8), "005731"
param2 = varchar(4), "0449"
0 records fetched
2429 ms, 2571003 fetch(es), 37 mark(s)
select SALES2.boleta, SALES2.codfil, SALES2.valnot, SALES2.datnot, SALES2.datven, SALES2.valven, SALES2.datpag, SALES2.valpag, SALES2.acordo, SALES2.codcli, SALES2.operacao, SALES2.parcela from SALES2
where
SALES2.boleta = ? and SALES2.codfil = ?
order by SALES2.datven
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (SALES2 ORDER SALES2_IDX6 INDEX (PK_SALES2))
param0 = varchar(8), "03344414"
param1 = varchar(2), "01"
6 records fetched
3188 ms, 6798 read(s), 7148 fetch(es)
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '01.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '06'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
6 records fetched
1336 ms, 465445 fetch(es)
select count(*)
FROM COMPRAS
LEFT OUTER JOIN FILIAL FILIAL_A ON (COMPRAS.CODFIL = FILIAL_A.CODFIL)
LEFT OUTER JOIN FILIAL FILIAL_B ON (COMPRAS.CODFILENT = FILIAL_B.CODFIL)
LEFT OUTER JOIN FORNEC ON (COMPRAS.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN FUNCIO ON (COMPRAS.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN TRANSPO ON (COMPRAS.FKTRANSPO = TRANSPO.PKCODIGO)
LEFT OUTER JOIN MODCOM ON (COMPRAS.CODMODCOM = MODCOM.CODMODCOM)
WHERE FORNEC.RAZSOC LIKE '%VULCA%'
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (COMPRAS NATURAL, FILIAL_A INDEX (PK_FILIAL)), FILIAL_B INDEX (PK_FILIAL)), FORNEC INDEX (PK_FORNEC)), FUNCIO INDEX (UNQ1_FUNCIO)), TRANSPO INDEX (PK_TRANSPO)), MODCOM INDEX (PK_MODCOM))
1 records fetched
900 ms, 1062439 fetch(es)
insert into ENTRADA
(CONTADOR, QUAMERCN, CN01, CN02, CN03, CN04, CN05, CN06, CN07, CN08, CN09, CN10, CN11, CN12, CN13, CN14, CN15, CN16, CN17, CN18, CN19, CN20, CN21, CN22, CN23, CN24, CN25, CN26, CN27, CN28, CN29, CN30, CN31, CN32, CN33, CN34, CN35, CN36, CN37, CN38, CN39, CN40, CODMER, CODFIL, GR, CODMAR, CODFOR, REFFOR, CODGRU1, NOMGRU1, CODGRU2, NOMGRU2, CODGRU3, NOMGRU3, CODGRU4, NOMGRU4, CODGRU5, NOMGRU5, CODGRU6, NOMGRU6, UNIDADE, CUSTO, VENDA, LUCRO, IPI, FRETE, ENCARGO, NUMNOT, DATNOT, VALNOT, DATMOV, CODFUN, OPERACAO, CUSTOA, VENDAA, LUCROA, IPIA, FRETEA, ENCARGOA, FILCOD, CONFERIDO, SERIE, CUSTOM, CUSTOMA, QUANTF, ICMS, DESCONTO, CUSTON, CUSTOMN, CUSTONA, CUSTOMNA, DESGER, DATENT, CODALQ, PERCALQ, CFOP, VALICMS, VALIPI, VALDESC, CUSTONT, COMISSIND, DATVALI, VALENCARGO, CST, ORDEMNF, VALFRE, CONF, CODFORNEC, ICMSSTREC, FRETET, SEGURO, BASEICMS, BASEICMSST, ICMSST, VALSEGURO, PERCALQST, CUSTOUNIT, CUSTOFINAL, NCM, FKCOMPRAU, VALPIS, VALCOFINS, VALICMSDES, PIS, COFINS, ICMSDES)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
param0 = integer, "2087617"
param1 = double precision, "12"
param2 = double precision, "0"
param3 = double precision, "1"
param4 = double precision, "2"
param5 = double precision, "3"
param6 = double precision, "3"
param7 = double precision, "2"
param8 = double precision, "1"
param9 = double precision, "0"
param10 = double precision, "0"
param11 = double precision, "0"
param12 = double precision, "0"
param13 = double precision, "0"
param14 = double precision, "0"
param15 = double precision, "0"
param16 = double precision, "0"
param17 = double precision, "0"
param18 = double precision, "0"
param19 = double precision, "0"
param20 = double precision, "0"
param21 = double precision, "0"
param22 = double precision, "0"
param23 = double precision, "0"
param24 = double precision, "0"
param25 = double precision, "0"
param26 = double precision, "0"
param27 = double precision, "0"
param28 = double precision, "0"
param29 = double precision, "0"
param30 = double precision, "0"
param31 = double precision, "0"
param32 = double precision, "0"
param33 = double precision, "0"
param34 = double precision, "0"
param35 = double precision, "0"
param36 = double precision, "0"
param37 = double precision, "0"
param38 = double precision, "0"
param39 = double precision, "0"
param40 = double precision, "0"
param41 = double precision, "0"
param42 = varchar(13), "0000001986402"
param43 = varchar(2), "24"
param44 = varchar(2), "CF"
param45 = varchar(4), "1387"
param46 = varchar(4), "0449"
param47 = varchar(50), "Y0571"
param48 = varchar(4), "9245"
param49 = varchar(20), "BRONZE"
param50 = varchar(4), "RT"
param51 = varchar(20), "RASTEIRA"
param52 = varchar(4), "0022"
param53 = varchar(20), "FEMININO"
param54 = varchar(4), ""
param55 = varchar(20), ""
param56 = varchar(4), "0023"
param57 = varchar(20), "PRI/VER 2022/23"
param58 = varchar(4), "0001"
param59 = varchar(20), "RASTEIRAS"
param60 = varchar(3), "UN"
param61 = double precision, "41.25"
param62 = double precision, "119.9"
param63 = double precision, "190.67"
param64 = double precision, "0"
param65 = double precision, "0"
param66 = double precision, "0"
param67 = varchar(9), "805621"
param68 = date, "2024-02-01"
param69 = double precision, "3700.14"
param70 = date, "2024-02-25"
param71 = varchar(8), "00032605"
param72 = varchar(2), "RP"
param73 = double precision, "0"
param74 = double precision, "0"
param75 = double precision, "0"
param76 = double precision, "0"
param77 = double precision, "0"
param78 = double precision, "0"
param79 = varchar(2), "24"
param80 = varchar(1), "N"
param81 = varchar(6), "062487"
param82 = double precision, "41.25"
param83 = double precision, "0"
param84 = double precision, "0"
param85 = double precision, "8.25"
param86 = double precision, "0"
param87 = double precision, "41.25"
param88 = double precision, "41.25"
param89 = double precision, "0"
param90 = double precision, "0"
param91 = varchar(1), ""
param92 = date, "2024-02-25"
param93 = varchar(2), "19"
param94 = double precision, "20"
param95 = varchar(5), "5102"
param96 = bigint(*, -2), "99.00"
param97 = bigint(*, -2), "0"
param98 = bigint(*, -2), "0"
param99 = bigint(*, -2), "495.00"
param100 = bigint(*, -2), "0"
param101 = date, "<NULL>"
param102 = bigint(*, -2), "0"
param103 = varchar(3), "000"
param104 = integer, "0"
param105 = bigint(*, -2), "0"
param106 = varchar(1), ""
param107 = varchar(60), ""
param108 = bigint(*, -2), "0"
param109 = bigint(*, -2), "0"
param110 = bigint(*, -2), "0"
param111 = bigint(*, -2), "0"
param112 = bigint(*, -2), "0"
param113 = bigint(*, -2), "0"
param114 = bigint(*, -2), "0"
param115 = bigint(*, -2), "0"
param116 = bigint(*, -2), "0"
param117 = bigint(*, -2), "0"
param118 = varchar(8), ""
param119 = integer, "561536"
param120 = bigint(*, -2), "0"
param121 = bigint(*, -2), "0"
param122 = bigint(*, -2), "0"
param123 = bigint(*, -2), "0"
param124 = bigint(*, -2), "0"
param125 = bigint(*, -2), "0"
0 records fetched
279 ms, 1 read(s), 165598 fetch(es), 39 mark(s)
insert into entrada (
entrada.idWAREH,
entrada.quamercn,
entrada.cn01,
entrada.cn02,
entrada.cn03,
entrada.cn04,
entrada.cn05,
entrada.cn06,
entrada.cn07,
entrada.cn08,
entrada.cn09,
entrada.cn10,
entrada.cn11,
entrada.cn12,
entrada.cn13,
entrada.cn14,
entrada.cn15,
entrada.cn16,
entrada.cn17,
entrada.cn18,
entrada.cn19,
entrada.cn20,
entrada.cn21,
entrada.cn22,
entrada.cn23,
entrada.cn24,
entrada.cn25,
entrada.cn26,
entrada.cn27,
entrada.cn28,
entrada.cn29,
entrada.cn30,
entrada.cn31,
entrada.cn32,
entrada.cn33,
entrada.cn34,
entrada.cn35,
entrada.cn36,
entrada.cn37,
entrada.cn38,
entrada.cn39,
entrada.cn40,
entrada.codmer,
entrada.codfil,
entrada.gr,
entrada.codmar,
entrada.codfor,
entrada.reffor,
entrada.codgru1,
entrada.nomgru1,
entrada.codgru2,
entrada.nomgru2,
entrada.codgru3,
entrada.nomgru3,
entrada.codgru4,
entrada.nomgru4,
entrada.codgru5,
entrada.nomgru5,
entrada.codgru6,
entrada.nomgru6,
entrada.unidade,
entrada.quauni,
entrada.venda,
entrada.custo,
entrada.boleta,
entrada.operacao,
entrada.filcod,
entrada.datmov,
entrada.datent,
entrada.ncm,
entrada.cst,
entrada.csosn)
select
WAREH.contador,
WAREH.quamercn,
WAREH.cn01,
WAREH.cn02,
WAREH.cn03,
WAREH.cn04,
WAREH.cn05,
WAREH.cn06,
WAREH.cn07,
WAREH.cn08,
WAREH.cn09,
WAREH.cn10,
WAREH.cn11,
WAREH.cn12,
WAREH.cn13,
WAREH.cn14,
WAREH.cn15,
WAREH.cn16,
WAREH.cn17,
WAREH.cn18,
WAREH.cn19,
WAREH.cn20,
WAREH.cn21,
WAREH.cn22,
WAREH.cn23,
WAREH.cn24,
WAREH.cn25,
WAREH.cn26,
WAREH.cn27,
WAREH.cn28,
WAREH.cn29,
WAREH.cn30,
WAREH.cn31,
WAREH.cn32,
WAREH.cn33,
WAREH.cn34,
WAREH.cn35,
WAREH.cn36,
WAREH.cn37,
WAREH.cn38,
WAREH.cn39,
WAREH.cn40,
WAREH.codmer,
'25',
WAREH.gr,
WAREH.codmar,
WAREH.codfor,
WAREH.reffor,
WAREH.codgru1,
WAREH.nomgru1,
WAREH.codgru2,
WAREH.nomgru2,
WAREH.codgru3,
WAREH.nomgru3,
WAREH.codgru4,
WAREH.nomgru4,
WAREH.codgru5,
WAREH.nomgru5,
WAREH.codgru6,
WAREH.nomgru6,
WAREH.unidade,
WAREH.quauni,
WAREH.venda,
WAREH.custo,
WAREH.boleta,
WAREH.operacao,
WAREH.codfil,
WAREH.datdev,
WAREH.datdev,
WAREH.ncm,
WAREH.cst,
WAREH.csosn
from WAREH
where
WAREH.contador = 7538417
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX24))
0 records fetched
611 ms, 303 read(s), 3 write(s), 5140 fetch(es), 35 mark(s)
EXECUTE PROCEDURE ATU_VENDA_FOMAPAG('000000610410501')
0 records fetched
200 ms, 1 write(s), 2021 fetch(es), 33 mark(s)
EXECUTE PROCEDURE ATU_VENDA_FOMAPAG('000000610373015')
0 records fetched
200 ms, 1 write(s), 1963 fetch(es), 23 mark(s)
EXECUTE PROCEDURE ATU_VENDA_FOMAPAG('000000610329925')
0 records fetched
200 ms, 1 write(s), 1916 fetch(es), 13 mark(s)
SELECT * FROM PRC_COLLECT_RANKCATEGORY(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_COLLECT_RANKCATEGORY NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
123 records fetched
12357 ms, 18615774 fetch(es)
SELECT * FROM PRC_EM_NEWP(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_EM_NEWP NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
37 records fetched
12270 ms, 18382854 fetch(es)
SELECT * FROM PRC_RANK_V2(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_RANK_V2 NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
145 records fetched
11818 ms, 17964820 fetch(es)
SELECT * FROM PRC_SL_OLDCLIENTCHK(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (PRC_SL_OLDCLIENTCHK NATURAL)
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
169 records fetched
11153 ms, 16880230 fetch(es)
insert into CLCONT
(ID, CODCLI, TELEFONE, DESCRICAO, RAMAL)
values
(?, ?, ?, ?, ?)
param0 = integer, "707491"
param1 = varchar(8), "00412209"
param2 = varchar(14), "(22)99874-2783"
param3 = varchar(30), "PROPRIO"
param4 = varchar(4), ""
0 records fetched
3663 ms, 3495502 fetch(es), 9 mark(s)
select SALES2.boleta, SALES2.codfil, SALES2.valnot, SALES2.datnot, SALES2.datven, SALES2.valven, SALES2.datpag, SALES2.valpag, SALES2.acordo, SALES2.codcli, SALES2.operacao, SALES2.parcela from SALES2
where
SALES2.boleta = ? and SALES2.codfil = ?
order by SALES2.datven
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (SALES2 ORDER SALES2_IDX6 INDEX (PK_SALES2))
param0 = varchar(8), "03344414"
param1 = varchar(2), "01"
6 records fetched
3188 ms, 6798 read(s), 7148 fetch(es)
SELECT FIRST 500 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODMAR = '4069' AND ESTOQ.INATIVO = 0 AND ((ESTOQ.QUAMERCN > 0) OR ( (ESTOQ.CN01> 0) OR (ESTOQ.CN02> 0) OR (ESTOQ.CN03> 0) OR (ESTOQ.CN04> 0) OR (ESTOQ.CN05> 0) OR (ESTOQ.CN06> 0) OR (ESTOQ.CN07> 0) OR (ESTOQ.CN08> 0) OR (ESTOQ.CN09> 0) OR (ESTOQ.CN10> 0) OR (ESTOQ.CN11> 0) OR (ESTOQ.CN12> 0) OR (ESTOQ.CN13> 0) OR (ESTOQ.CN14> 0) OR (ESTOQ.CN15> 0) OR (ESTOQ.CN16> 0) OR (ESTOQ.CN17> 0) OR (ESTOQ.CN18> 0) OR (ESTOQ.CN19> 0) OR (ESTOQ.CN20> 0) OR (ESTOQ.CN21> 0) OR (ESTOQ.CN22> 0) OR (ESTOQ.CN23> 0) OR (ESTOQ.CN24> 0) OR (ESTOQ.CN25> 0) OR (ESTOQ.CN26> 0) OR (ESTOQ.CN27> 0) OR (ESTOQ.CN28> 0) OR (ESTOQ.CN29> 0) OR (ESTOQ.CN30> 0) OR (ESTOQ.CN31> 0) OR (ESTOQ.CN32> 0) OR (ESTOQ.CN33> 0) OR (ESTOQ.CN34> 0) OR (ESTOQ.CN35> 0) OR (ESTOQ.CN36> 0) OR (ESTOQ.CN37> 0) OR (ESTOQ.CN38> 0) OR (ESTOQ.CN39> 0) OR (ESTOQ.CN40> 0) ) )
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (ESTOQ INDEX (ESTOQ_IDX24), FILIAL INDEX (PK_FILIAL)), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
500 records fetched
13195 ms, 5872 read(s), 95663 fetch(es)
SELECT
SALES2.BOLETA,
SALES2.PARCELA,
SALES2.CODFIL,
SALES2.OPERACAO,
SALES2.VALNOT,
SALES2.DATNOT,
SALES2.NUMNOT,
SALES2.CODCLI,
SALES2.CODFUN,
SALES2.DATVEN,
SALES2.VALVEN,
SALES2.DATPAG,
SALES2.VALPAG,
SALES2.MARCARC,
SALES2.SPC,
SALES2.NOMCOM,
SALES2.REGDEB,
SALES2.CREDITO,
SALES2.MARCCOB,
SALES2.BANDOC,
SALES2.CREDREC,
SALES2.CREDTRO,
SALES2.TROCA,
SALES2.COBRADOR,
SALES2.ACORDO,
SALES2.DATBLOQ,
SALES2.CAMPUB,
SALES2.CONFERER,
SALES2.CONFEREP,
SALES2.CONFEREE,
SALES2.CONFEREV,
SALES2.CONFUSU,
SALES2.TERMINAL,
SALES2.MARCGRID,
SALES2.MULTAREC,
SALES2.JURREC,
SALES2.DESREC,
SALES2.COBREC,
SALES2.PARCDEB,
SALES2.FORPAG,
SALES2.BOLTRO,
SALES2.DATLAN,
SALES2.DATREC,
SALES2.CODFUNLAN,
SALES2.CODFUNLIB,
SALES2.BOLCOND,
SALES2.DTCOBVAL,
SALES2.PEDIDO,
SALES2.CODCONV,
SALES2.FISCAL,
SALES2.FILCOD,
SALES2.PREVENDA,
SALES2.CODCLI_CONVERT,
SALES2.BOLETA_CONVERT,
SALES2.FKCOB_TRANSACAO,
SALES2.COB_VALPAG,
SALES2.COB_DESREC,
SALES2.COB_JURREC,
SALES2.COB_COBREC,
SALES2.COB_MULTAREC,
SALES2.RISCO,
MODALI.MODALI,
CLIENT.NOMRAZ,
FUNCIO.NOMFUN,
FILIAL.NOMFIL,
CONVCLI.NOMCONV,
COB_TRANSACAO.STATUS AS STATUS_TRANSACAO,
VENDABASE.ECOMMERCE_ORDER_ID,
VENDABASE.FKPLUGGTOID,
VENDABASE.FRETE
FROM SALES2
LEFT OUTER JOIN CLIENT ON (SALES2.CODCLI = CLIENT.CODCLI)
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN FILIAL ON (SALES2.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN MODALI ON (SALES2.OPERACAO = MODALI.CODMODALI)
LEFT OUTER JOIN CONVCLI ON (SALES2.CODCONV = CONVCLI.CODCONV)
LEFT OUTER JOIN COB_TRANSACAO ON (SALES2.FKCOB_TRANSACAO = COB_TRANSACAO.ID)
LEFT OUTER JOIN SALESBASE ON (SALES2.CODFIL = VENDABASE.CODFIL) and (SALES2.boleta = VENDABASE.boleta) WHERE (SALES2.CODFIL = '12') AND (SALES2.DATNOT BETWEEN '01.02.2022' AND '30.12.2022') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX')) AND (SALES2.BANDOC NOT IN (SELECT BANCO.BANDOC FROM BANCO WHERE (BANCO.BANDOC = SALES2.BANDOC) AND BANCO.TIPO = 'ENTRADAS')) ORDER BY CLIENT.NOMRAZ,SALES2.DATNOT,SALES2.BOLETA,SALES2.PARCELA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN (BANCO INDEX (BANCO_IDX10))
PLAN (BANCO INDEX (BANCO_IDX10, BANCO_IDX10))
PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (SALES2 INDEX (SALES2_IDX2, SALES2_IDX9), CLIENT INDEX (PK_CLIENT)), FUNCIO INDEX (UNQ1_FUNCIO)), FILIAL INDEX (PK_FILIAL)), MODALI INDEX (PK_MODALI)), CONVCLI INDEX (PK_CONVCLI)), COB_TRANSACAO INDEX (PK_COB_TRANSACAO)), SALESBASE INDEX (PK_VENDABASE)))
20605 records fetched
10906 ms, 5250 read(s), 1113465 fetch(es)
SELECT
SALES2.BOLETA,
SALES2.PARCELA,
SALES2.CODFIL,
SALES2.OPERACAO,
SALES2.VALNOT,
SALES2.DATNOT,
SALES2.NUMNOT,
SALES2.CODCLI,
SALES2.CODFUN,
SALES2.DATVEN,
SALES2.VALVEN,
SALES2.DATPAG,
SALES2.VALPAG,
SALES2.MARCARC,
SALES2.SPC,
SALES2.NOMCOM,
SALES2.REGDEB,
SALES2.CREDITO,
SALES2.MARCCOB,
SALES2.BANDOC,
SALES2.CREDREC,
SALES2.CREDTRO,
SALES2.TROCA,
SALES2.COBRADOR,
SALES2.ACORDO,
SALES2.DATBLOQ,
SALES2.CAMPUB,
SALES2.CONFERER,
SALES2.CONFEREP,
SALES2.CONFEREE,
SALES2.CONFEREV,
SALES2.CONFUSU,
SALES2.TERMINAL,
SALES2.MARCGRID,
SALES2.MULTAREC,
SALES2.JURREC,
SALES2.DESREC,
SALES2.COBREC,
SALES2.PARCDEB,
SALES2.FORPAG,
SALES2.BOLTRO,
SALES2.DATLAN,
SALES2.DATREC,
SALES2.CODFUNLAN,
SALES2.CODFUNLIB,
SALES2.BOLCOND,
SALES2.DTCOBVAL,
SALES2.PEDIDO,
SALES2.CODCONV,
SALES2.FISCAL,
SALES2.FILCOD,
SALES2.PREVENDA,
SALES2.CODCLI_CONVERT,
SALES2.BOLETA_CONVERT,
SALES2.FKCOB_TRANSACAO,
SALES2.COB_VALPAG,
SALES2.COB_DESREC,
SALES2.COB_JURREC,
SALES2.COB_COBREC,
SALES2.COB_MULTAREC,
SALES2.RISCO,
MODALI.MODALI,
CLIENT.NOMRAZ,
FUNCIO.NOMFUN,
FILIAL.NOMFIL,
CONVCLI.NOMCONV,
COB_TRANSACAO.STATUS AS STATUS_TRANSACAO,
VENDABASE.ECOMMERCE_ORDER_ID,
VENDABASE.FKPLUGGTOID,
VENDABASE.FRETE
FROM SALES2
LEFT OUTER JOIN CLIENT ON (SALES2.CODCLI = CLIENT.CODCLI)
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN FILIAL ON (SALES2.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN MODALI ON (SALES2.OPERACAO = MODALI.CODMODALI)
LEFT OUTER JOIN CONVCLI ON (SALES2.CODCONV = CONVCLI.CODCONV)
LEFT OUTER JOIN COB_TRANSACAO ON (SALES2.FKCOB_TRANSACAO = COB_TRANSACAO.ID)
LEFT OUTER JOIN SALESBASE ON (SALES2.CODFIL = VENDABASE.CODFIL) and (SALES2.boleta = VENDABASE.boleta) WHERE (SALES2.CODFIL = '12') AND (SALES2.DATNOT BETWEEN '01.01.2022' AND '30.11.2022') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX')) ORDER BY CLIENT.NOMRAZ,SALES2.DATNOT,SALES2.BOLETA,SALES2.PARCELA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (SALES2 INDEX (SALES2_IDX2, SALES2_IDX9), CLIENT INDEX (PK_CLIENT)), FUNCIO INDEX (UNQ1_FUNCIO)), FILIAL INDEX (PK_FILIAL)), MODALI INDEX (PK_MODALI)), CONVCLI INDEX (PK_CONVCLI)), COB_TRANSACAO INDEX (PK_COB_TRANSACAO)), SALESBASE INDEX (PK_VENDABASE)))
19286 records fetched
2664 ms, 4928 read(s), 691394 fetch(es)
SELECT * FROM VIEW_CAIXA WHERE CODFIL = '16' AND DATMOV = '25.02.2023' AND FORMA = 'I' ORDER BY NOMRAZ
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (VIEW_CAIXA SALES2 INDEX (SALES2_IDX26))
PLAN (VIEW_CAIXA SALES2 INDEX (SALES2_IDX26))
PLAN JOIN (VIEW_CAIXA BANCO ORDER BANCO_IDX8 INDEX (BANCO_IDX32), VIEW_CAIXA FUNCIO INDEX (UNQ1_FUNCIO))
1 records fetched
7140 ms, 4583 read(s), 4858 fetch(es)
select distinct SALES2.boleta, SALES2.codfil from SALES2
where SALES2.codcli = ? and (SALES2.acordo is null or SALES2.acordo = '') and
(SALES2.datpag >= '25.02.2020' or SALES2.datpag is null) and
(SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX') AND (SALES2.CREDREC > 0 /*OR (SALES2.ACORDO IS DISTINCT FROM '')*/ OR SALES2.DATPAG IS NULL OR SALES2.BANDOC IN (SELECT BANCO.BANDOC FROM BANCO WHERE BANCO.BANDOC = SALES2.BANDOC AND BANCO.ARQUI = 'SALES2' AND (BANCO.TIPO IN ('RECEB. CARNE','CHEQUES PRE REC','TROCO REC') OR SUBSTRING(BANCO.TIPO FROM 1 FOR 10) = 'CARTAO REC')))
order by SALES2.datven + 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN (BANCO INDEX (BANCO_IDX10))
PLAN SORT (SORT (SALES2 INDEX (SALES2_IDX31, SALES2_IDX31, SALES2_IDX14, SALES2_IDX14)))
param0 = varchar(8), "00410224"
1 records fetched
313 ms, 3943 fetch(es)
SELECT FIRST 100 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODFIL = '01' AND ESTOQ.CODMAR = '1640' AND ESTOQ.INATIVO = 0
order by 3 DESC
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (SORT (JOIN (ESTOQ INDEX (ESTOQ_IDX24, ESTOQ_IDX14), FILIAL INDEX (PK_FILIAL))), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
100 records fetched
7303 ms, 3085 read(s), 16052 fetch(es)
select first 100
MEUCREDIARIO_INTEGRACAO.id,
MEUCREDIARIO_INTEGRACAO.boleta,
MEUCREDIARIO_INTEGRACAO.codfil,
cast(MEUCREDIARIO_INTEGRACAO.createat as date) as data,
cast(MEUCREDIARIO_INTEGRACAO.createat as time) as hora,
MEUCREDIARIO_INTEGRACAO.exclusao
from
MEUCREDIARIO_INTEGRACAO
inner join config_filial on (config_filial.fkfilial = MEUCREDIARIO_INTEGRACAO.codfil)
where
MEUCREDIARIO_INTEGRACAO.concluido is null
and meucrediario_integracao.tentativa <= 10
and config_filial.campo = 'MEUCREDIARIO_TOKEN'
order by
MEUCREDIARIO_INTEGRACAO.TENTATIVA, MEUCREDIARIO_INTEGRACAO.exclusao, MEUCREDIARIO_INTEGRACAO.codfil, MEUCREDIARIO_INTEGRACAO.id
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN SORT (JOIN (MEUCREDIARIO_INTEGRACAO INDEX (MEUCREDIARIO_INTEGRACAO_IDX3), CONFIG_FILIAL INDEX (PK_CONFIG_FILIAL)))
100 records fetched
3351 ms, 2853 read(s), 102355 fetch(es)
SELECT
SALES2.BOLETA,
SALES2.PARCELA,
SALES2.CODFIL,
SALES2.OPERACAO,
SALES2.VALNOT,
SALES2.DATNOT,
SALES2.NUMNOT,
SALES2.CODCLI,
SALES2.CODFUN,
SALES2.DATVEN,
SALES2.VALVEN,
SALES2.DATPAG,
SALES2.VALPAG,
SALES2.MARCARC,
SALES2.SPC,
SALES2.NOMCOM,
SALES2.REGDEB,
SALES2.CREDITO,
SALES2.MARCCOB,
SALES2.BANDOC,
SALES2.CREDREC,
SALES2.CREDTRO,
SALES2.TROCA,
SALES2.COBRADOR,
SALES2.ACORDO,
SALES2.DATBLOQ,
SALES2.CAMPUB,
SALES2.CONFERER,
SALES2.CONFEREP,
SALES2.CONFEREE,
SALES2.CONFEREV,
SALES2.CONFUSU,
SALES2.TERMINAL,
SALES2.MARCGRID,
SALES2.MULTAREC,
SALES2.JURREC,
SALES2.DESREC,
SALES2.COBREC,
SALES2.PARCDEB,
SALES2.FORPAG,
SALES2.BOLTRO,
SALES2.DATLAN,
SALES2.DATREC,
SALES2.CODFUNLAN,
SALES2.CODFUNLIB,
SALES2.BOLCOND,
SALES2.DTCOBVAL,
SALES2.PEDIDO,
SALES2.CODCONV,
SALES2.FISCAL,
SALES2.FILCOD,
SALES2.PREVENDA,
SALES2.CODCLI_CONVERT,
SALES2.BOLETA_CONVERT,
SALES2.FKCOB_TRANSACAO,
SALES2.COB_VALPAG,
SALES2.COB_DESREC,
SALES2.COB_JURREC,
SALES2.COB_COBREC,
SALES2.COB_MULTAREC,
SALES2.RISCO,
MODALI.MODALI,
CLIENT.NOMRAZ,
FUNCIO.NOMFUN,
FILIAL.NOMFIL,
CONVCLI.NOMCONV,
COB_TRANSACAO.STATUS AS STATUS_TRANSACAO,
VENDABASE.ECOMMERCE_ORDER_ID,
VENDABASE.FKPLUGGTOID,
VENDABASE.FRETE
FROM SALES2
LEFT OUTER JOIN CLIENT ON (SALES2.CODCLI = CLIENT.CODCLI)
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN FILIAL ON (SALES2.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN MODALI ON (SALES2.OPERACAO = MODALI.CODMODALI)
LEFT OUTER JOIN CONVCLI ON (SALES2.CODCONV = CONVCLI.CODCONV)
LEFT OUTER JOIN COB_TRANSACAO ON (SALES2.FKCOB_TRANSACAO = COB_TRANSACAO.ID)
LEFT OUTER JOIN SALESBASE ON (SALES2.CODFIL = VENDABASE.CODFIL) and (SALES2.boleta = VENDABASE.boleta) WHERE (SALES2.CODFIL = '02') AND (SALES2.DATNOT BETWEEN '01.01.2022' AND '30.11.2022') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX')) ORDER BY CLIENT.NOMRAZ,SALES2.DATNOT,SALES2.BOLETA,SALES2.PARCELA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (MODALI NATURAL)
PLAN (MODALI INDEX (PK_MODALI, PK_MODALI))
PLAN SORT (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (SALES2 INDEX (SALES2_IDX2, SALES2_IDX9), CLIENT INDEX (PK_CLIENT)), FUNCIO INDEX (UNQ1_FUNCIO)), FILIAL INDEX (PK_FILIAL)), MODALI INDEX (PK_MODALI)), CONVCLI INDEX (PK_CONVCLI)), COB_TRANSACAO INDEX (PK_COB_TRANSACAO)), SALESBASE INDEX (PK_VENDABASE)))
23628 records fetched
2102 ms, 2686 read(s), 846480 fetch(es)
SELECT FIRST 100 SKIP 0
ESTOQ.CODMER,
ESTOQ.CODFIL,
ESTOQ.QUAMERCN,
ESTOQ.CN01,
ESTOQ.CN02,
ESTOQ.CN03,
ESTOQ.CN04,
ESTOQ.CN05,
ESTOQ.CN06,
ESTOQ.CN07,
ESTOQ.CN08,
ESTOQ.CN09,
ESTOQ.CN10,
ESTOQ.CN11,
ESTOQ.CN12,
ESTOQ.CN13,
ESTOQ.CN14,
ESTOQ.CN15,
ESTOQ.CN16,
ESTOQ.CN17,
ESTOQ.CN18,
ESTOQ.CN19,
ESTOQ.CN20,
ESTOQ.CN21,
ESTOQ.CN22,
ESTOQ.CN23,
ESTOQ.CN24,
ESTOQ.CN25,
ESTOQ.CN26,
ESTOQ.CN27,
ESTOQ.CN28,
ESTOQ.CN29,
ESTOQ.CN30,
ESTOQ.CN31,
ESTOQ.CN32,
ESTOQ.CN33,
ESTOQ.CN34,
ESTOQ.CN35,
ESTOQ.CN36,
ESTOQ.CN37,
ESTOQ.CN38,
ESTOQ.CN39,
ESTOQ.CN40,
ESTOQ.GR,
ESTOQ.CODMAR,
ESTOQ.REFFOR,
ESTOQ.CODGRU1,
ESTOQ.NOMGRU1,
ESTOQ.CODGRU2,
ESTOQ.NOMGRU2,
ESTOQ.CODGRU3,
ESTOQ.NOMGRU3,
ESTOQ.CODGRU4,
ESTOQ.NOMGRU4,
ESTOQ.CODGRU5,
ESTOQ.NOMGRU5,
ESTOQ.CODGRU6,
ESTOQ.NOMGRU6,
ESTOQ.UNIDADE,
ESTOQ.QUAUNI,
ESTOQ.CUSTO,
ESTOQ.VENDA,
ESTOQ.VENDAA,
ESTOQ.LUCRO,
ESTOQ.IPI,
ESTOQ.FRETE,
ESTOQ.ENCARGO,
ESTOQ.NUMNOT,
ESTOQ.DATACONF1,
ESTOQ.DATACONF2,
ESTOQ.CODBAR,
ESTOQ.CODALQ,
ESTOQ.DESFIS,
ESTOQ.QUANTF,
ESTOQ.CUSTOM,
ESTOQ.PROMOC,
ESTOQ.QUAAPRO,
ESTOQ.QUADPRO,
ESTOQ.VALAPRO,
ESTOQ.VALPRO,
ESTOQ.DATIPRO,
ESTOQ.DATFPRO,
ESTOQ.CODFOR,
ESTOQ.DESGER,
ESTOQ.ESTMIN,
ESTOQ.CODFORP,
ESTOQ.PRATELEIRA,
ESTOQ.ESTMAX,
ESTOQ.DESCVEN,
ESTOQ.COMISSIND,
ESTOQ.DATVALI,
ESTOQ.NCM,
ESTOQ.INATIVO,
ESTOQ.CODREGRA,
ESTOQ.CONF,
ESTOQ.VOLUME,
ESTOQ.CODREGRATMP,
ESTOQ.CODFORNEC,
ESTOQ.ICMSSTREC,
ESTOQ.FRETET,
ESTOQ.CUSTON,
ESTOQ.CST,
ESTOQ.CSOSN,
ESTOQ.CODMER_CONVERT,
ESTOQ.INDESCALA,
ESTOQ.CNPJFABESCALA,
ESTOQ.DATVPRO,
ESTOQ.DESCONTO,
ESTOQ.SEGURO,
ESTOQ.FORADELINHA,
ESTOQ.SITE,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FORNEC.NOMFOR,
GRADE.NOMGRA,
FORPRE.NOMFORP,
FORNEC.RAZSOC,
ALIQUO.DESALQ,
MODALIREGRANEG.DESCRICAO,
MODALIREGRANEGTMP.DESCRICAO AS DESCRICAOTMP,
(SELECT SUM(QUAMERCN) FROM WAREH WHERE WAREH.CODFIL = ESTOQ.CODFIL AND WAREH.CODMER = ESTOQ.CODMER AND WAREH.OPERACAO = 'CD') AS CONDI
FROM ESTOQ
LEFT OUTER JOIN FILIAL ON (ESTOQ.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN IDEFORM ON (ESTOQ.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FORNEC ON (ESTOQ.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (ESTOQ.GR = GRADE.CODGRA)
LEFT OUTER JOIN FORPRE ON (ESTOQ.CODFORP = FORPRE.CODFORP)
LEFT OUTER JOIN ALIQUO ON (ESTOQ.CODALQ = ALIQUO.CODALQ)
LEFT OUTER JOIN MODALIREGRANEG ON (ESTOQ.CODREGRA = MODALIREGRANEG.CODIGO)
LEFT OUTER JOIN MODALIREGRANEG MODALIREGRANEGTMP ON (ESTOQ.CODREGRATMP = MODALIREGRANEGTMP.CODIGO)
WHERE 1=1 AND ESTOQ.CODFIL = '01' AND ESTOQ.CODMAR = '2450' AND ESTOQ.INATIVO = 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
PLAN (WAREH INDEX (WAREH_IDX18))
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (ESTOQ INDEX (ESTOQ_IDX24, ESTOQ_IDX14), FILIAL INDEX (PK_FILIAL)), IDEFORM INDEX (PK_IDEFORM)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE)), FORPRE INDEX (PK_FORPRE)), ALIQUO INDEX (PK_ALIQUO)), MODALIREGRANEG INDEX (PK_MODALIREGRANEG)), MODALIREGRANEGTMP INDEX (PK_MODALIREGRANEG))
100 records fetched
8333 ms, 2617 read(s), 10214 fetch(es)
PLAN (SALES2 ORDER SALES2_IDX6 INDEX (PK_SALES2))
select SALES2.boleta, SALES2.codfil, SALES2.valnot, SALES2.datnot, SALES2.datven, SALES2.valven, SALES2.datpag, SALES2.valpag, SALES2.acordo, SALES2.codcli, SALES2.operacao, SALES2.parcela from SALES2
where
SALES2.boleta = ? and SALES2.codfil = ?
order by SALES2.datven
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = varchar(8), "03361088"
param1 = varchar(2), "01"
5 records fetched
3919 ms, 6995 read(s), 7148 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
SALES2 6
PLAN (MODALI NATURAL) PLAN (MODALI INDEX (PK_MODALI, PK_MODALI)) PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '01.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '14'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
11 records fetched
1417 ms, 480401 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FUNCIO 10860
MODALI 43528
WAREH 25037
SALES2 59215
PLAN SORT (JOIN (SALES2 INDEX (SALES2_IDX31, SALES2_IDX14, SALES2_IDX14), A NATURAL))
select
SALES2.boleta,
SALES2.codfil,
SALES2.parcela,
SALES2.operacao,
SALES2.datnot,
SALES2.datven,
SALES2.datpag,
SALES2.valven,
SALES2.valpag,
a.ojurostotal,
a.odias
from SALES2
left join PRC_SALES2_CALCULOJUROS(SALES2.boleta, SALES2.codfil, SALES2.parcela, current_date) a on (1=1) WHERE SALES2.CODCLI = '00006145' AND SALES2.DATPAG IS NOT NULL and (ACORDO IS NUlL OR ACORDO ='') ORDER BY SALES2.BOLETA, SALES2.PARCELA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
2276 records fetched
738 ms, 249 read(s), 20497 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
JURDES 2276
SALES2 4622
PLAN SORT (SORT (JOIN (JOIN (JOIN (SALES2 INDEX (SALES2_IDX31, SALES2_IDX14, SALES2_IDX14), A NATURAL), FILIAL INDEX (PK_FILIAL)), GRUPO_FILIAL INDEX (PK_GRUPO_FILIAL))))
select
SUM(SALES2.valven) AS VALVEN,
SUM(SALES2.valpag) AS VALPAG,
SUM(a.ojurostotal) AS oJurosTotal,
filial.FKGRFILIAL,
GRUPO_FILIAL.DESCRICAO
from SALES2
left join PRC_SALES2_CALCULOJUROS(SALES2.boleta, SALES2.codfil, SALES2.parcela, current_date) a on (1=1)
left join filial on (SALES2.codfil = filial.codfil)
left join GRUPO_FILIAL on (filial.FKGRFILIAL = GRUPO_FILIAL.codigo)
WHERE SALES2.CODCLI = '00006145' AND SALES2.DATPAG IS NOT NULL and (ACORDO IS NUlL OR ACORDO ='')
GROUP BY
filial.FKGRFILIAL,
GRUPO_FILIAL.DESCRICAO
ORDER BY
GRUPO_FILIAL.DESCRICAO
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
2 records fetched
627 ms, 34153 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FILIAL 2276
JURDES 2276
SALES2 4622
GRUPO_FILIAL 2276
PLAN (MODALI INDEX (PK_MODALI)) PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '01.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '21'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
6 records fetched
1375 ms, 301649 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FUNCIO 7276
MODALI 28728
WAREH 10245
SALES2 59188
PLAN (BANCO ORDER BANCO_IDX14 INDEX (BANCO_IDX18))
SELECT NUMCHECAR, DESBANCO, AGENCIA, CONTA, DATMOV, DATCHE, VALOR, CODFIL FROM BANCO WHERE BANCO.CODCLI = '00384016' AND BANCO.FORMA = 'X' ORDER BY BANCO.DATCHE
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
0 records fetched
385 ms, 1696 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
BANCO 58
PLAN (PRC_COLLECT_RANKCATEGORY NATURAL)
SELECT * FROM PRC_COLLECT_RANKCATEGORY(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
1008 records fetched
77758 ms, 118651323 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
IDEFORM 152
GRUPO2 1796
WAREH 2001
CHANGE_VENDA 116534661
PLAN (PRC_EM_NEWP NATURAL)
SELECT * FROM PRC_EM_NEWP(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
263 records fetched
76819 ms, 119281820 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
IDEFORM 152
GRUPO2 152
WAREH 2015
CHANGE_VENDA 117158777
PLAN (PRC_RANK_V2 NATURAL)
SELECT * FROM PRC_RANK_V2(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
1245 records fetched
77793 ms, 118215515 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
IDEFORM 1813
GRUPO2 152
WAREH 2018
CHANGE_VENDA 116106539
PLAN (PRC_SL_OLDCLIENTCHK NATURAL)
SELECT * FROM PRC_SL_OLDCLIENTCHK(?,?)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = date, "2024-02-25"
param1 = date, "2024-02-25"
1651 records fetched
67615 ms, 101512699 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
ESTOQ 1651
IDEFORM 152
GRUPO2 152
WAREH 2006
CHANGE_VENDA 99698011
PLAN (SALES2 ORDER SALES2_IDX6 INDEX (PK_SALES2))
select SALES2.boleta, SALES2.codfil, SALES2.valnot, SALES2.datnot, SALES2.datven, SALES2.valven, SALES2.datpag, SALES2.valpag, SALES2.acordo, SALES2.codcli, SALES2.operacao, SALES2.parcela from SALES2
where
SALES2.boleta = ? and SALES2.codfil = ?
order by SALES2.datven
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = varchar(8), "03361088"
param1 = varchar(2), "01"
5 records fetched
3919 ms, 6995 read(s), 7148 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
SALES2 6
PLAN (BANCO ORDER BANCO_IDX14 INDEX (BANCO_IDX18))
SELECT NUMCHECAR, DESBANCO, AGENCIA, CONTA, DATMOV, DATCHE, VALOR, CODFIL FROM BANCO WHERE BANCO.CODCLI = '00384016' AND BANCO.FORMA = 'X' ORDER BY BANCO.DATCHE
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
0 records fetched
385 ms, 1696 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
BANCO 58
PLAN SORT (JOIN (SALES2 INDEX (SALES2_IDX31, SALES2_IDX14, SALES2_IDX14), A NATURAL))
select
SALES2.boleta,
SALES2.codfil,
SALES2.parcela,
SALES2.operacao,
SALES2.datnot,
SALES2.datven,
SALES2.datpag,
SALES2.valven,
SALES2.valpag,
a.ojurostotal,
a.odias
from SALES2
left join PRC_SALES2_CALCULOJUROS(SALES2.boleta, SALES2.codfil, SALES2.parcela, current_date) a on (1=1) WHERE SALES2.CODCLI = '00006145' AND SALES2.DATPAG IS NOT NULL and (ACORDO IS NUlL OR ACORDO ='') ORDER BY SALES2.BOLETA, SALES2.PARCELA
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
2276 records fetched
738 ms, 249 read(s), 20497 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
JURDES 2276
SALES2 4622
PLAN SORT (SORT (JOIN (JOIN (JOIN (SALES2 INDEX (SALES2_IDX31, SALES2_IDX14, SALES2_IDX14), A NATURAL), FILIAL INDEX (PK_FILIAL)), GRUPO_FILIAL INDEX (PK_GRUPO_FILIAL))))
select
SUM(SALES2.valven) AS VALVEN,
SUM(SALES2.valpag) AS VALPAG,
SUM(a.ojurostotal) AS oJurosTotal,
filial.FKGRFILIAL,
GRUPO_FILIAL.DESCRICAO
from SALES2
left join PRC_SALES2_CALCULOJUROS(SALES2.boleta, SALES2.codfil, SALES2.parcela, current_date) a on (1=1)
left join filial on (SALES2.codfil = filial.codfil)
left join GRUPO_FILIAL on (filial.FKGRFILIAL = GRUPO_FILIAL.codigo)
WHERE SALES2.CODCLI = '00006145' AND SALES2.DATPAG IS NOT NULL and (ACORDO IS NUlL OR ACORDO ='')
GROUP BY
filial.FKGRFILIAL,
GRUPO_FILIAL.DESCRICAO
ORDER BY
GRUPO_FILIAL.DESCRICAO
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
2 records fetched
627 ms, 34153 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FILIAL 2276
JURDES 2276
SALES2 4622
GRUPO_FILIAL 2276
PLAN (MODALI INDEX (PK_MODALI)) PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '01.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '21'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
6 records fetched
1375 ms, 301649 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FUNCIO 7276
MODALI 28728
WAREH 10245
SALES2 59188
PLAN (MODALI NATURAL) PLAN (MODALI INDEX (PK_MODALI, PK_MODALI)) PLAN JOIN (JOIN (SALES2 ORDER SALES2_IDX5 INDEX (SALES2_IDX2), FUNCIO INDEX (UNQ1_FUNCIO)), WAREH INDEX (WAREH_IDX21))
SELECT
SUM(WAREH.QUAMERCN) AS "QNT",
SALES2.CODFUN
FROM
SALES2
LEFT OUTER JOIN FUNCIO ON (SALES2.CODFUN = FUNCIO.CODFUN)
LEFT OUTER JOIN WAREH ON (SALES2.BOLETA = WAREH.BOLETA AND SALES2.CODFIL = WAREH.CODFIL)
WHERE
(SALES2.DATNOT BETWEEN '01.02.2023' AND '25.02.2023') AND (SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S') AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX','DV','DC')) AND (SUBSTRING(SALES2.OPERACAO FROM 2 FOR 1) <> 'F') AND SALES2.PARCELA = '01'
AND FUNCIO.CODFIL = '14'
GROUP BY
SALES2.CODFUN
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
11 records fetched
1417 ms, 480401 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FUNCIO 10860
MODALI 43528
WAREH 25037
SALES2 59215
PLAN (MODALI NATURAL) PLAN (MODALI INDEX (PK_MODALI, PK_MODALI)) PLAN (BANCO INDEX (BANCO_IDX10)) PLAN SORT (SORT (SALES2 INDEX (SALES2_IDX31, SALES2_IDX31, SALES2_IDX14, SALES2_IDX14)))
select distinct SALES2.boleta, SALES2.codfil from SALES2
where SALES2.codcli = ? and (SALES2.acordo is null or SALES2.acordo = '') and
(SALES2.datpag >= '25.02.2020' or SALES2.datpag is null) and
(SALES2.OPERACAO NOT IN (SELECT CODMODALI FROM MODALI WHERE AV = 'S')) AND SALES2.OPERACAO NOT IN ('CD','DB','DA','DX') AND (SALES2.CREDREC > 0 /*OR (SALES2.ACORDO IS DISTINCT FROM '')*/ OR SALES2.DATPAG IS NULL OR SALES2.BANDOC IN (SELECT BANCO.BANDOC FROM BANCO WHERE BANCO.BANDOC = SALES2.BANDOC AND BANCO.ARQUI = 'SALES2' AND (BANCO.TIPO IN ('RECEB. CARNE','CHEQUES PRE REC','TROCO REC') OR SUBSTRING(BANCO.TIPO FROM 1 FOR 10) = 'CARTAO REC')))
order by SALES2.datven + 0
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
param0 = varchar(8), "00313676"
29 records fetched
843 ms, 115 read(s), 5519 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
BANCO 124
MODALI 140
SALES2 140
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (WAREH ORDER WAREH_IDX3 INDEX (WAREH_IDX21), IDEFORM INDEX (PK_IDEFORM)), FILIAL_B INDEX (PK_FILIAL)), FILIAL INDEX (PK_FILIAL)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE))
SELECT
WAREH.CONTADOR,
WAREH.CODFIL,
WAREH.QUAMERCN,
WAREH.CN01,
WAREH.CN02,
WAREH.CN03,
WAREH.CN04,
WAREH.CN05,
WAREH.CN06,
WAREH.CN07,
WAREH.CN08,
WAREH.CN09,
WAREH.CN10,
WAREH.CN11,
WAREH.CN12,
WAREH.CN13,
WAREH.CN14,
WAREH.CN15,
WAREH.CN16,
WAREH.CN17,
WAREH.CN18,
WAREH.CN19,
WAREH.CN20,
WAREH.CN21,
WAREH.CN22,
WAREH.CN23,
WAREH.CN24,
WAREH.CN25,
WAREH.CN26,
WAREH.CN27,
WAREH.CN28,
WAREH.CN29,
WAREH.CN30,
WAREH.CN31,
WAREH.CN32,
WAREH.CN33,
WAREH.CN34,
WAREH.CN35,
WAREH.CN36,
WAREH.CN37,
WAREH.CN38,
WAREH.CN39,
WAREH.CN40,
WAREH.CODMER,
WAREH.GR,
WAREH.CODMAR,
WAREH.REFFOR,
WAREH.CODGRU1,
WAREH.NOMGRU1,
WAREH.CODGRU2,
WAREH.NOMGRU2,
WAREH.CODGRU3,
WAREH.NOMGRU3,
WAREH.CODGRU4,
WAREH.NOMGRU4,
WAREH.CODGRU5,
WAREH.NOMGRU5,
WAREH.CODGRU6,
WAREH.NOMGRU6,
WAREH.UNIDADE,
WAREH.QUAUNI,
WAREH.CUSTO,
WAREH.VENDA,
WAREH.LUCRO,
WAREH.IPI,
WAREH.FRETE,
WAREH.ENCARGO,
WAREH.NUMNOT,
WAREH.DATNOT,
WAREH.VALNOT,
WAREH.DATMOV,
WAREH.BOLETA,
WAREH.CODFUN,
WAREH.OPERACAO,
WAREH.FILCOD,
WAREH.VALREC,
WAREH.MARCARC,
WAREH.CREDITO,
WAREH.CONFERIDO,
WAREH.CODBAR,
WAREH.CODALQ,
WAREH.DESALQ,
WAREH.DESFIS,
WAREH.QUANTF,
WAREH.DATSAI,
WAREH.HORSAI,
WAREH.PROMOC,
WAREH.VALATU,
WAREH.CODFOR,
WAREH.DNVEND,
WAREH.SEQRET,
WAREH.ARQVEN,
WAREH.BOLTRO,
WAREH.DATDEV,
WAREH.PRATELEIRA,
WAREH.LOTE,
WAREH.IDTRANSF,
WAREH.PREMOD,
WAREH.DESCVEN,
WAREH.COMISSIND,
WAREH.DATVALI,
WAREH.VOLUME,
WAREH.RESERVA,
WAREH.TRANSFON,
WAREH.CONF,
WAREH.ICMSSTREC,
WAREH.FRETET,
WAREH.CST,
WAREH.CSOSN,
WAREH.NCM,
WAREH.CODREGRA,
WAREH.CODREGRATMP,
WAREH.VALORREAL,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FILIAL_B.NOMFIL AS FILNOM,
FORNEC.NOMFOR,
GRADE.NOMGRA
FROM WAREH
LEFT OUTER JOIN IDEFORM ON (WAREH.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FILIAL FILIAL_B ON (WAREH.FILCOD = FILIAL_B.CODFIL)
LEFT OUTER JOIN FILIAL ON (WAREH.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN FORNEC ON (WAREH.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (WAREH.GR = GRADE.CODGRA) WHERE WAREH.CODFIL = '04' AND WAREH.BOLETA = '03253599' ORDER BY WAREH.CODMER
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
3 records fetched
283 ms, 3582 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FILIAL 6
IDEFORM 3
FORNEC 3
GRADE 3
WAREH 3
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (WAREH ORDER WAREH_IDX3 INDEX (WAREH_IDX25), IDEFORM INDEX (PK_IDEFORM)), FILIAL_B INDEX (PK_FILIAL)), FILIAL INDEX (PK_FILIAL)), FORNEC INDEX (PK_FORNEC)), GRADE INDEX (PK_GRADE))
SELECT
WAREH.CONTADOR,
WAREH.CODFIL,
WAREH.QUAMERCN,
WAREH.CN01,
WAREH.CN02,
WAREH.CN03,
WAREH.CN04,
WAREH.CN05,
WAREH.CN06,
WAREH.CN07,
WAREH.CN08,
WAREH.CN09,
WAREH.CN10,
WAREH.CN11,
WAREH.CN12,
WAREH.CN13,
WAREH.CN14,
WAREH.CN15,
WAREH.CN16,
WAREH.CN17,
WAREH.CN18,
WAREH.CN19,
WAREH.CN20,
WAREH.CN21,
WAREH.CN22,
WAREH.CN23,
WAREH.CN24,
WAREH.CN25,
WAREH.CN26,
WAREH.CN27,
WAREH.CN28,
WAREH.CN29,
WAREH.CN30,
WAREH.CN31,
WAREH.CN32,
WAREH.CN33,
WAREH.CN34,
WAREH.CN35,
WAREH.CN36,
WAREH.CN37,
WAREH.CN38,
WAREH.CN39,
WAREH.CN40,
WAREH.CODMER,
WAREH.GR,
WAREH.CODMAR,
WAREH.REFFOR,
WAREH.CODGRU1,
WAREH.NOMGRU1,
WAREH.CODGRU2,
WAREH.NOMGRU2,
WAREH.CODGRU3,
WAREH.NOMGRU3,
WAREH.CODGRU4,
WAREH.NOMGRU4,
WAREH.CODGRU5,
WAREH.NOMGRU5,
WAREH.CODGRU6,
WAREH.NOMGRU6,
WAREH.UNIDADE,
WAREH.QUAUNI,
WAREH.CUSTO,
WAREH.VENDA,
WAREH.LUCRO,
WAREH.IPI,
WAREH.FRETE,
WAREH.ENCARGO,
WAREH.NUMNOT,
WAREH.DATNOT,
WAREH.VALNOT,
WAREH.DATMOV,
WAREH.BOLETA,
WAREH.CODFUN,
WAREH.OPERACAO,
WAREH.FILCOD,
WAREH.VALREC,
WAREH.MARCARC,
WAREH.CREDITO,
WAREH.CONFERIDO,
WAREH.CODBAR,
WAREH.CODALQ,
WAREH.DESALQ,
WAREH.DESFIS,
WAREH.QUANTF,
WAREH.DATSAI,
WAREH.HORSAI,
WAREH.PROMOC,
WAREH.VALATU,
WAREH.CODFOR,
WAREH.DNVEND,
WAREH.SEQRET,
WAREH.ARQVEN,
WAREH.BOLTRO,
WAREH.DATDEV,
WAREH.PRATELEIRA,
WAREH.LOTE,
WAREH.IDTRANSF,
WAREH.PREMOD,
WAREH.DESCVEN,
WAREH.COMISSIND,
WAREH.DATVALI,
WAREH.VOLUME,
WAREH.RESERVA,
WAREH.TRANSFON,
WAREH.CONF,
WAREH.ICMSSTREC,
WAREH.FRETET,
WAREH.CST,
WAREH.CSOSN,
WAREH.NCM,
WAREH.CODREGRA,
WAREH.CODREGRATMP,
WAREH.VALORREAL,
FILIAL.NOMFIL,
IDEFORM.NOMMAR,
FILIAL_B.NOMFIL AS FILNOM,
FORNEC.NOMFOR,
GRADE.NOMGRA
FROM WAREH
LEFT OUTER JOIN IDEFORM ON (WAREH.CODMAR = IDEFORM.CODMAR)
LEFT OUTER JOIN FILIAL FILIAL_B ON (WAREH.FILCOD = FILIAL_B.CODFIL)
LEFT OUTER JOIN FILIAL ON (WAREH.CODFIL = FILIAL.CODFIL)
LEFT OUTER JOIN FORNEC ON (WAREH.CODFOR = FORNEC.CODFOR)
LEFT OUTER JOIN GRADE ON (WAREH.GR = GRADE.CODGRA) WHERE WAREH.ARQVEN = '*' AND WAREH.DATDEV IS NULL AND WAREH.CODFIL = '19' AND WAREH.BOLETA = '03382147' ORDER BY WAREH.CODMER
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
...plan text skipped...
3 records fetched
291 ms, 3584 fetch(es)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
FILIAL 6
IDEFORM 3
FORNEC 3
GRADE 3
WAREH 3
--no plan found--
insert into CLCONT
(ID, CODCLI, TELEFONE, DESCRICAO, RAMAL)
values
(?, ?, ?, ?, ?)
param0 = integer, "707530"
param1 = varchar(8), "00412245"
param2 = varchar(14), "(21)99615-6087"
param3 = varchar(30), "PROPRIO"
param4 = varchar(4), ""
0 records fetched
4234 ms, 3495679 fetch(es), 9 mark(s)
Table Natural Index Update Insert Delete Backout Purge Expunge
***************************************************************************************************************
RDB$INDICES 5
RDB$RELATION_CONSTRAINTS 1
CLIENT 655410
CLCONT 655409 1
CRM_CONNECT 1
| No | Process | Att | Det | Conn | Count | U.S. | U.P. | Total Duration | Fetch | Read | Write | Mark |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 0 | 101 | 116 | 5 | 5 | 2097083 | 3125843684 | 0 | 0 | 0 | |
| 2 | C:\Program Files\Firebird\Firebird_3_0\firebird.exe | 0 | 0 | 6 | 6 | 1 | 1 | 9035 | 1216 | 7 | 0 | 57 |
| 3 | F:\Exectbl\SrvMWc164.exe | 0 | 0 | 119 | 2988 | 849 | 45 | 1423913 | 341406150 | 45312 | 5 | 2706 |
| 4 | F:\Exectbl\SrvMWc264.exe | 0 | 0 | 129 | 3285 | 978 | 36 | 1431433 | 297409317 | 37906 | 7 | 1420 |
| 5 | F:\Exectbl\SrvMWc364.exe | 0 | 0 | 87 | 2362 | 699 | 38 | 1095567 | 185356115 | 35892 | 2 | 1745 |
| 6 | F:\Exectbl\SrvMWc64.exe | 0 | 0 | 112 | 3827 | 1099 | 37 | 1497885 | 226291230 | 28929 | 0 | 1041 |
| 7 | F:\Exectbl\SrvCRMMyBank64.exe | 0 | 0 | 1116 | 5543 | 3 | 3 | 2433559 | 36412098 | 20452 | 0 | 0 |
| 8 | F:\Exectbl\SrvJDP64.exe | 0 | 0 | 1 | 1 | 1 | 1 | 246 | 83 | 32 | 0 | 0 |
| No | Cl.Adr. | Att | Det | Conn | Count | U.S. | U.P. | Total Duration | Fetch | Read | Write | Mark | Proc |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | TCPv4:127.0.0.1 | 0 | 0 | 101 | 116 | 5 | 5 | 2097083 | 3125843684 | 0 | 0 | 0 | |
| 2 | TCPv6:::1 | 0 | 0 | 1570 | 18012 | 2583 | 73 | 7891638 | 1086876209 | 168530 | 14 | 6969 | 7: SrvCRMMyBank64.exe (5543), SrvMWc64.exe (3827), SrvMWc264.exe (3285), Other: 5357 |