Hi all, :-)
Hibernate version: 2.1.4
Name and version of the database you are using: oracle 8i
I´m executing the following code:
Code:
query = "select distinct u from User u";
query += " inner join fetch u.template t";
query += " inner join fetch t.company c";
query += " inner join fetch c.contactUser cu";
query += " inner join fetch c.indicator ci";
query += " inner join fetch c.companyStatus cs";
query += " inner join fetch c.city ct";
query += " inner join fetch ct.state st";
query += " inner join fetch st.country co";
query += " left join fetch c.companyParent cp";
query += " left join fetch cp.indicator cpi";
query += " left join fetch cp.companyStatus csp";
query += " left join fetch cp.city ctp";
query += " left join fetch ctp.state stp";
query += " left join fetch stp.country cop";
query += (" where u.login = '" + login + "'");
query += (" and u.password = '" + passCrypt + "'");
query += " and u.userStatus.idUserStatus = '1'";
query += " and cs.idCompanyStatus in ('A', 'S', 'P')";
query += " and ((cp is null)";
query += " or ((cp is not null)";
query += " and (csp.idCompanyStatus in ('A', 'S', 'P'))))";
list = session.createQuery(query);
All beans in the project (User, Template, Company...) are proxies, used to improve performance.
The HQL above is generating many queries Oracle and this depends of the bean User.
The user has the property List trips.
For example, the user "July" has 2 trips and the user "John" has 2000 trips, so when
the SQL above is executed for the user "John", many queries is generated,
much more than user "July".
The generated SQL (show_sql=true):
[code]
1110913676984|31|43|statement|select distinct user0_.cpf as cpf0_, state13_.id_estado as id_estado1_, user3_.cpf as cpf2_, country14_.id_pais as id_pais3_, company2_.cnpj as cnpj4_, companysta11_.id_empresa_status as id_empre1_5_, companysta5_.id_empresa_status as id_empre1_6_, indicator10_.id_indicador as id_indic1_7_, indicator4_.id_indicador as id_indic1_8_, country8_.id_pais as id_pais9_, state7_.id_estado as id_estado10_, template1_.id_perfil as id_perfil11_, city12_.id_cidade as id_cidade12_, company9_.cnpj as cnpj13_, city6_.id_cidade as id_cidade14_, user0_.rg as rg0_, user0_.uf_rg as uf_rg0_, user0_.nome as nome0_, user0_.login as login0_, user0_.senha as senha0_, user0_.email as email0_, user0_.cargo as cargo0_, user0_.id_perfil as id_perfil0_, user0_.id_usuario_status as id_usua10_0_, user0_.dt_inclusao as dt_incl11_0_, user0_.dt_exclusao as dt_excl12_0_, user0_.primeiro_acesso as primeir13_0_, state13_.no_estado as no_estado1_, state13_.id_pais as id_pais1_, user3_.rg as rg2_, user3_.uf_rg as uf_rg2_, user3_.nome as nome2_, user3_.login as login2_, user3_.senha as senha2_, user3_.email as email2_, user3_.cargo as cargo2_, user3_.id_perfil as id_perfil2_, user3_.id_usuario_status as id_usua10_2_, user3_.dt_inclusao as dt_incl11_2_, user3_.dt_exclusao as dt_excl12_2_, user3_.primeiro_acesso as primeir13_2_, country14_.no_pais as no_pais3_, company2_.id_indicador as id_indic2_4_, company2_.id_empresa_status as id_empre3_4_, company2_.id_atividade_tipo as id_ativi4_4_, company2_.dt_pedido_acesso as dt_pedid5_4_, company2_.dt_manutencao as dt_manut6_4_, company2_.nome as nome4_, company2_.razao_social as razao_so8_4_, company2_.logradouro as logradouro4_, company2_.numero as numero4_, company2_.complemento as complem11_4_, company2_.bairro as bairro4_, company2_.id_cidade as id_cidade4_, company2_.cep as cep4_, company2_.ddd_telefone as ddd_tel15_4_, company2_.telefone as telefone4_, company2_.ddd_fax as ddd_fax4_, company2_.fax as fax4_, company2_.cpf_contato as cpf_con19_4_, company2_.nr_banco as nr_banco4_, company2_.agencia as agencia4_, company2_.nr_conta as nr_conta4_, company2_.fg_conta as fg_conta4_, company2_.cnpj_ted as cnpj_ted4_, company2_.cnpj_pai as cnpj_pai4_, company2_.fg_manutencao as fg_manu26_4_, company2_.tp_conta as tp_conta4_, companysta11_.ds_empresa_status as ds_empre2_5_, companysta5_.ds_empresa_status as ds_empre2_6_, indicator10_.ds_indicador as ds_indic2_7_, indicator4_.ds_indicador as ds_indic2_8_, country8_.no_pais as no_pais9_, state7_.no_estado as no_estado10_, state7_.id_pais as id_pais10_, template1_.nome as nome11_, template1_.ds_perfil as ds_perfil11_, template1_.pm_perfil as pm_perfil11_, template1_.cnpj as cnpj11_, template1_.id_perfil_pai as id_perfi6_11_, city12_.no_cidade as no_cidade12_, city12_.id_estado as id_estado12_, company9_.id_indicador as id_indic2_13_, company9_.id_empresa_status as id_empre3_13_, company9_.id_atividade_tipo as id_ativi4_13_, company9_.dt_pedido_acesso as dt_pedid5_13_, company9_.dt_manutencao as dt_manut6_13_, company9_.nome as nome13_, company9_.razao_social as razao_so8_13_, company9_.logradouro as logradouro13_, company9_.numero as numero13_, company9_.complemento as complem11_13_, company9_.bairro as bairro13_, company9_.id_cidade as id_cidade13_, company9_.cep as cep13_, company9_.ddd_telefone as ddd_tel15_13_, company9_.telefone as telefone13_, company9_.ddd_fax as ddd_fax13_, company9_.fax as fax13_, company9_.cpf_contato as cpf_con19_13_, company9_.nr_banco as nr_banco13_, company9_.agencia as agencia13_, company9_.nr_conta as nr_conta13_, company9_.fg_conta as fg_conta13_, company9_.cnpj_ted as cnpj_ted13_, company9_.cnpj_pai as cnpj_pai13_, company9_.fg_manutencao as fg_manu26_13_, company9_.tp_conta as tp_conta13_, city6_.no_cidade as no_cidade14_, city6_.id_estado as id_estado14_ from usuario user0_, perfil template1_, empresa company2_, usuario user3_, indicador indicator4_, empresa_status companysta5_, cidade city6_, estado state7_, pais country8_, empresa company9_, indicador indicator10_, empresa_status companysta11_, cidade city12_, estado state13_, pais country14_ where user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj and company2_.cpf_contato=user3_.cpf and company2_.id_indicador=indicator4_.id_indicador and company2_.id_empresa_status=companysta5_.id_empresa_status and company2_.id_cidade=city6_.id_cidade and city6_.id_estado=state7_.id_estado and state7_.id_pais=country8_.id_pais and company2_.cnpj_pai=company9_.cnpj(+) and company9_.id_indicador=indicator10_.id_indicador(+) and company9_.id_empresa_status=companysta11_.id_empresa_status(+) and company9_.id_cidade=city12_.id_cidade(+) and city12_.id_estado=state13_.id_estado(+) and state13_.id_pais=country14_.id_pais(+) and ((user0_.login='thiago' )and(user0_.senha='5Q4wx8zJVg0=' )and(user0_.id_usuario_status='1' )and(companysta5_.id_empresa_status in('A' , 'S' , 'P'))and(((company9_.cnpj is null ))or(((company9_.cnpj is not null ))and((companysta11_.id_empresa_status in('A' , 'S' , 'P'))))))|select distinct user0_.cpf as cpf0_, state13_.id_estado as id_estado1_, user3_.cpf as cpf2_, country14_.id_pais as id_pais3_, company2_.cnpj as cnpj4_, companysta11_.id_empresa_status as id_empre1_5_, companysta5_.id_empresa_status as id_empre1_6_, indicator10_.id_indicador as id_indic1_7_, indicator4_.id_indicador as id_indic1_8_, country8_.id_pais as id_pais9_, state7_.id_estado as id_estado10_, template1_.id_perfil as id_perfil11_, city12_.id_cidade as id_cidade12_, company9_.cnpj as cnpj13_, city6_.id_cidade as id_cidade14_, user0_.rg as rg0_, user0_.uf_rg as uf_rg0_, user0_.nome as nome0_, user0_.login as login0_, user0_.senha as senha0_, user0_.email as email0_, user0_.cargo as cargo0_, user0_.id_perfil as id_perfil0_, user0_.id_usuario_status as id_usua10_0_, user0_.dt_inclusao as dt_incl11_0_, user0_.dt_exclusao as dt_excl12_0_, user0_.primeiro_acesso as primeir13_0_, state13_.no_estado as no_estado1_, state13_.id_pais as id_pais1_, user3_.rg as rg2_, user3_.uf_rg as uf_rg2_, user3_.nome as nome2_, user3_.login as login2_, user3_.senha as senha2_, user3_.email as email2_, user3_.cargo as cargo2_, user3_.id_perfil as id_perfil2_, user3_.id_usuario_status as id_usua10_2_, user3_.dt_inclusao as dt_incl11_2_, user3_.dt_exclusao as dt_excl12_2_, user3_.primeiro_acesso as primeir13_2_, country14_.no_pais as no_pais3_, company2_.id_indicador as id_indic2_4_, company2_.id_empresa_status as id_empre3_4_, company2_.id_atividade_tipo as id_ativi4_4_, company2_.dt_pedido_acesso as dt_pedid5_4_, company2_.dt_manutencao as dt_manut6_4_, company2_.nome as nome4_, company2_.razao_social as razao_so8_4_, company2_.logradouro as logradouro4_, company2_.numero as numero4_, company2_.complemento as complem11_4_, company2_.bairro as bairro4_, company2_.id_cidade as id_cidade4_, company2_.cep as cep4_, company2_.ddd_telefone as ddd_tel15_4_, company2_.telefone as telefone4_, company2_.ddd_fax as ddd_fax4_, company2_.fax as fax4_, company2_.cpf_contato as cpf_con19_4_, company2_.nr_banco as nr_banco4_, company2_.agencia as agencia4_, company2_.nr_conta as nr_conta4_, company2_.fg_conta as fg_conta4_, company2_.cnpj_ted as cnpj_ted4_, company2_.cnpj_pai as cnpj_pai4_, company2_.fg_manutencao as fg_manu26_4_, company2_.tp_conta as tp_conta4_, companysta11_.ds_empresa_status as ds_empre2_5_, companysta5_.ds_empresa_status as ds_empre2_6_, indicator10_.ds_indicador as ds_indic2_7_, indicator4_.ds_indicador as ds_indic2_8_, country8_.no_pais as no_pais9_, state7_.no_estado as no_estado10_, state7_.id_pais as id_pais10_, template1_.nome as nome11_, template1_.ds_perfil as ds_perfil11_, template1_.pm_perfil as pm_perfil11_, template1_.cnpj as cnpj11_, template1_.id_perfil_pai as id_perfi6_11_, city12_.no_cidade as no_cidade12_, city12_.id_estado as id_estado12_, company9_.id_indicador as id_indic2_13_, company9_.id_empresa_status as id_empre3_13_, company9_.id_atividade_tipo as id_ativi4_13_, company9_.dt_pedido_acesso as dt_pedid5_13_, company9_.dt_manutencao as dt_manut6_13_, company9_.nome as nome13_, company9_.razao_social as razao_so8_13_, company9_.logradouro as logradouro13_, company9_.numero as numero13_, company9_.complemento as complem11_13_, company9_.bairro as bairro13_, company9_.id_cidade as id_cidade13_, company9_.cep as cep13_, company9_.ddd_telefone as ddd_tel15_13_, company9_.telefone as telefone13_, company9_.ddd_fax as ddd_fax13_, company9_.fax as fax13_, company9_.cpf_contato as cpf_con19_13_, company9_.nr_banco as nr_banco13_, company9_.agencia as agencia13_, company9_.nr_conta as nr_conta13_, company9_.fg_conta as fg_conta13_, company9_.cnpj_ted as cnpj_ted13_, company9_.cnpj_pai as cnpj_pai13_, company9_.fg_manutencao as fg_manu26_13_, company9_.tp_conta as tp_conta13_, city6_.no_cidade as no_cidade14_, city6_.id_estado as id_estado14_ from usuario user0_, perfil template1_, empresa company2_, usuario user3_, indicador indicator4_, empresa_status companysta5_, cidade city6_, estado state7_, pais country8_, empresa company9_, indicador indicator10_, empresa_status companysta11_, cidade city12_, estado state13_, pais country14_ where user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj and company2_.cpf_contato=user3_.cpf and company2_.id_indicador=indicator4_.id_indicador and company2_.id_empresa_status=companysta5_.id_empresa_status and company2_.id_cidade=city6_.id_cidade and city6_.id_estado=state7_.id_estado and state7_.id_pais=country8_.id_pais and company2_.cnpj_pai=company9_.cnpj(+) and company9_.id_indicador=indicator10_.id_indicador(+) and company9_.id_empresa_status=companysta11_.id_empresa_status(+) and company9_.id_cidade=city12_.id_cidade(+) and city12_.id_estado=state13_.id_estado(+) and state13_.id_pais=country14_.id_pais(+) and ((user0_.login='thiago' )and(user0_.senha='5Q4wx8zJVg0=' )and(user0_.id_usuario_status='1' )and(companysta5_.id_empresa_status in('A' , 'S' , 'P'))and(((company9_.cnpj is null ))or(((company9_.cnpj is not null ))and((companysta11_.id_empresa_status in('A' , 'S' , 'P'))))))
1110913676984|-1||resultset|select distinct user0_.cpf as cpf0_, state13_.id_estado as id_estado1_, user3_.cpf as cpf2_, country14_.id_pais as id_pais3_, company2_.cnpj as cnpj4_, companysta11_.id_empresa_status as id_empre1_5_, companysta5_.id_empresa_status as id_empre1_6_, indicator10_.id_indicador as id_indic1_7_, indicator4_.id_indicador as id_indic1_8_, country8_.id_pais as id_pais9_, state7_.id_estado as id_estado10_, template1_.id_perfil as id_perfil11_, city12_.id_cidade as id_cidade12_, company9_.cnpj as cnpj13_, city6_.id_cidade as id_cidade14_, user0_.rg as rg0_, user0_.uf_rg as uf_rg0_, user0_.nome as nome0_, user0_.login as login0_, user0_.senha as senha0_, user0_.email as email0_, user0_.cargo as cargo0_, user0_.id_perfil as id_perfil0_, user0_.id_usuario_status as id_usua10_0_, user0_.dt_inclusao as dt_incl11_0_, user0_.dt_exclusao as dt_excl12_0_, user0_.primeiro_acesso as primeir13_0_, state13_.no_estado as no_estado1_, state13_.id_pais as id_pais1_, user3_.rg as rg2_, user3_.uf_rg as uf_rg2_, user3_.nome as nome2_, user3_.login as login2_, user3_.senha as senha2_, user3_.email as email2_, user3_.cargo as cargo2_, user3_.id_perfil as id_perfil2_, user3_.id_usuario_status as id_usua10_2_, user3_.dt_inclusao as dt_incl11_2_, user3_.dt_exclusao as dt_excl12_2_, user3_.primeiro_acesso as primeir13_2_, country14_.no_pais as no_pais3_, company2_.id_indicador as id_indic2_4_, company2_.id_empresa_status as id_empre3_4_, company2_.id_atividade_tipo as id_ativi4_4_, company2_.dt_pedido_acesso as dt_pedid5_4_, company2_.dt_manutencao as dt_manut6_4_, company2_.nome as nome4_, company2_.razao_social as razao_so8_4_, company2_.logradouro as logradouro4_, company2_.numero as numero4_, company2_.complemento as complem11_4_, company2_.bairro as bairro4_, company2_.id_cidade as id_cidade4_, company2_.cep as cep4_, company2_.ddd_telefone as ddd_tel15_4_, company2_.telefone as telefone4_, company2_.ddd_fax as ddd_fax4_, company2_.fax as fax4_, company2_.cpf_contato as cpf_con19_4_, company2_.nr_banco as nr_banco4_, company2_.agencia as agencia4_, company2_.nr_conta as nr_conta4_, company2_.fg_conta as fg_conta4_, company2_.cnpj_ted as cnpj_ted4_, company2_.cnpj_pai as cnpj_pai4_, company2_.fg_manutencao as fg_manu26_4_, company2_.tp_conta as tp_conta4_, companysta11_.ds_empresa_status as ds_empre2_5_, companysta5_.ds_empresa_status as ds_empre2_6_, indicator10_.ds_indicador as ds_indic2_7_, indicator4_.ds_indicador as ds_indic2_8_, country8_.no_pais as no_pais9_, state7_.no_estado as no_estado10_, state7_.id_pais as id_pais10_, template1_.nome as nome11_, template1_.ds_perfil as ds_perfil11_, template1_.pm_perfil as pm_perfil11_, template1_.cnpj as cnpj11_, template1_.id_perfil_pai as id_perfi6_11_, city12_.no_cidade as no_cidade12_, city12_.id_estado as id_estado12_, company9_.id_indicador as id_indic2_13_, company9_.id_empresa_status as id_empre3_13_, company9_.id_atividade_tipo as id_ativi4_13_, company9_.dt_pedido_acesso as dt_pedid5_13_, company9_.dt_manutencao as dt_manut6_13_, company9_.nome as nome13_, company9_.razao_social as razao_so8_13_, company9_.logradouro as logradouro13_, company9_.numero as numero13_, company9_.complemento as complem11_13_, company9_.bairro as bairro13_, company9_.id_cidade as id_cidade13_, company9_.cep as cep13_, company9_.ddd_telefone as ddd_tel15_13_, company9_.telefone as telefone13_, company9_.ddd_fax as ddd_fax13_, company9_.fax as fax13_, company9_.cpf_contato as cpf_con19_13_, company9_.nr_banco as nr_banco13_, company9_.agencia as agencia13_, company9_.nr_conta as nr_conta13_, company9_.fg_conta as fg_conta13_, company9_.cnpj_ted as cnpj_ted13_, company9_.cnpj_pai as cnpj_pai13_, company9_.fg_manutencao as fg_manu26_13_, company9_.tp_conta as tp_conta13_, city6_.no_cidade as no_cidade14_, city6_.id_estado as id_estado14_ from usuario user0_, perfil template1_, empresa company2_, usuario user3_, indicador indicator4_, empresa_status companysta5_, cidade city6_, estado state7_, pais country8_, empresa company9_, indicador indicator10_, empresa_status companysta11_, cidade city12_, estado state13_, pais country14_ where user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj and company2_.cpf_contato=user3_.cpf and company2_.id_indicador=indicator4_.id_indicador and company2_.id_empresa_status=companysta5_.id_empresa_status and company2_.id_cidade=city6_.id_cidade and city6_.id_estado=state7_.id_estado and state7_.id_pais=country8_.id_pais and company2_.cnpj_pai=company9_.cnpj(+) and company9_.id_indicador=indicator10_.id_indicador(+) and company9_.id_empresa_status=companysta11_.id_empresa_status(+) and company9_.id_cidade=city12_.id_cidade(+) and city12_.id_estado=state13_.id_estado(+) and state13_.id_pais=country14_.id_pais(+) and ((user0_.login='thiago' )and(user0_.senha='5Q4wx8zJVg0=' )and(user0_.id_usuario_status='1' )and(companysta5_.id_empresa_status in('A' , 'S' , 'P'))and(((company9_.cnpj is null ))or(((company9_.cnpj is not null ))and((companysta11_.id_empresa_status in('A' , 'S' , 'P'))))))|agencia4_ = 0000, bairro4_ = NOVO CAMBUM, cargo0_ = ANALISTA DE TESTES, cargo2_ = TESTES, cep4_ = 13026015, cnpj11_ = 07558205000136, cnpj13_ = null, cnpj4_ = 07558205000136, cnpj_pai4_ = null, cnpj_ted4_ = 07558205000136, complem11_4_ = null, cpf0_ = 23044262046, cpf2_ = 67536165781, cpf_con19_4_ = 67536165781, ddd_fax4_ = 0, ddd_tel15_4_ = 19, ds_empre2_6_ = ATIVO, ds_indic2_8_ = CONTRATANTE, ds_perfil11_ = LIBERA ACESSO AOS USUARIOS DA CONTRATANTE, email0_ =
thiago@hst.com.br, email2_ =
azzini@hst.com.br, fax4_ = 0, fg_conta4_ = 0, fg_manu26_4_ = 0, id_ativi4_4_ = 1, id_empre1_5_ = null, id_empre1_6_ = A, id_empre3_4_ = A, id_estado10_ = 33, id_estado14_ = 33, id_estado1_ = 0, id_indic1_7_ = null, id_indic1_8_ = C, id_indic2_4_ = C, id_pais10_ = 8, id_pais3_ = 0, id_pais9_ = 8, id_usua10_0_ = 1, id_usua10_2_ = 1, login0_ = thiago, login2_ = luiz.azzini, logradouro4_ = RUA DOS CONTABILISTAS , no_cidade14_ = CAMPINAS, no_estado10_ = SP, no_pais9_ = BRASIL, nome0_ = THIAGO CESAR DE ALMEIDA ORLANDO, nome11_ = MASTER CONTRATANTE, nome2_ = ANDRI, nome4_ = HST CONTRATANTE - INFOLOG, nr_banco4_ = 749, nr_conta4_ = 0011111111, numero4_ = 31, pm_perfil11_ = C0E0F800F0D8F6C0FC00F8000080000000000000000000000000000000000000, primeir13_0_ = 1, primeir13_2_ = 0, razao_so8_4_ = HST CONTRATANTE - INFOLOG, rg0_ = 266939727, rg2_ = null, senha0_ = 5Q4wx8zJVg0=, senha2_ = 5Q4wx8zJVg0=, telefone4_ = 32940331, tp_conta4_ = 0, uf_rg0_ = 33, uf_rg2_ = 33
1110913677015|15|43|statement|select transactio0_.cnpj as cnpj0_, transactio0_.fg_transacao_taxa as fg_trans2_0_, transactio0_.valor as valor0_, transactio0_.porcentagem as porcenta4_0_, transactio0_.limite as limite0_ from transacao_taxa transactio0_ where transactio0_.cnpj=?|select transactio0_.cnpj as cnpj0_, transactio0_.fg_transacao_taxa as fg_trans2_0_, transactio0_.valor as valor0_, transactio0_.porcentagem as porcenta4_0_, transactio0_.limite as limite0_ from transacao_taxa transactio0_ where transactio0_.cnpj='07558205000136'
1110913677015|-1||resultset|select transactio0_.cnpj as cnpj0_, transactio0_.fg_transacao_taxa as fg_trans2_0_, transactio0_.valor as valor0_, transactio0_.porcentagem as porcenta4_0_, transactio0_.limite as limite0_ from transacao_taxa transactio0_ where transactio0_.cnpj='07558205000136'|fg_trans2_0_ = 1
1110913677031|16|43|statement|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj=? and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)
1110913677031|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 24, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677031|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 24, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677031|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 17, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677046|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 17, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677046|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 17, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677046|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 17, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677046|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, id_dia_v3_1_ = 17, id_empre1_0_ = A, id_empre6_1_ = A, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677046|-1||resultset|select monthlyfee0_.id_mensalidade as id_mensa1___, monthlyfee0_.cnpj as cnpj__, monthlyfee0_.id_mensalidade as id_mensa1_1_, monthlyfee0_.cnpj as cnpj1_, monthlyfee0_.id_dia_vencimento as id_dia_v3_1_, monthlyfee0_.valor as valor1_, monthlyfee0_.id_mensalidade_status as id_mensa5_1_, monthlyfee0_.id_empresa_status as id_empre6_1_, monthlyfee0_.dt_pagamento as dt_pagam7_1_, monthlyfee0_.dt_vencimento as dt_venci8_1_, monthlyfee0_.tp_cobranca as tp_cobra9_1_, monthlyfee0_.agencia as agencia1_, monthlyfee0_.cd_cliente as cd_cliente1_, monthlyfee0_.dt_geracao as dt_geracao1_, companysta1_.id_empresa_status as id_empre1_0_, companysta1_.ds_empresa_status as ds_empre2_0_ from mensalidade monthlyfee0_, empresa_status companysta1_ where monthlyfee0_.cnpj='07558205000136' and monthlyfee0_.id_empresa_status=companysta1_.id_empresa_status(+)|agencia1_ = 326, cd_cliente1_ = 8, cnpj1_ = 07558205000136, cnpj__ = 07558205000136, ds_empre2_0_ = SUSPENSO, id_dia_v3_1_ = 7, id_empre1_0_ = S, id_empre6_1_ = S, id_mensa5_1_ = 5, tp_cobra9_1_ = 9
1110913677078|16|43|statement|select tolls0_.id_pedagio as id_pedagio__, tolls0_.id_mensalidade as id_mens15___, tolls0_.id_pedagio as id_pedagio2_, tolls0_.valor as valor2_, tolls0_.id_pedagio_status as id_pedag3_2_, tolls0_.id_transacao_status as id_trans4_2_, tolls0_.id_midia as id_midia2_, tolls0_.cpf as cpf2_, tolls0_.dt_pedagio as dt_pedagio2_, tolls0_.cd_ocorrencia as cd_ocorr8_2_, tolls0_.historico as historico2_, tolls0_.fg_transacao_taxa as fg_tran10_2_, tolls0_.valor_transacao_taxa as valor_t11_2_, tolls0_.pct_transacao_taxa as pct_tra12_2_, tolls0_.lmt_transacao_taxa as lmt_tra13_2_, tolls0_.dt_pagamento as dt_paga14_2_, tolls0_.id_mensalidade as id_mens15_2_, tolls0_.tp_conta as tp_conta2_, transactio1_.id_transacao_status as id_trans1_0_, transactio1_.ds_transacao_status as ds_trans2_0_, occurrence2_.cd_ocorrencia as cd_ocorr1_1_, occurrence2_.ds_ocorrencia as ds_ocorr2_1_, occurrence2_.ds_pos as ds_pos1_ from pedagio tolls0_, transacao_status transactio1_, ocorrencia occurrence2_ where tolls0_.id_mensalidade=? and tolls0_.id_transacao_status=transactio1_.id_transacao_status(+) and tolls0_.cd_ocorrencia=occurrence2_.cd_ocorrencia(+)|select tolls0_.id_pedagio as id_pedagio__, tolls0_.id_mensalidade as id_mens15___, tolls0_.id_pedagio as id_pedagio2_, tolls0_.valor as valor2_, tolls0_.id_pedagio_status as id_pedag3_2_, tolls0_.id_transacao_status as id_trans4_2_, tolls0_.id_midia as id_midia2_, tolls0_.cpf as cpf2_, tolls0_.dt_pedagio as dt_pedagio2_, tolls0_.cd_ocorrencia as cd_ocorr8_2_, tolls0_.historico as historico2_, tolls0_.fg_transacao_taxa as fg_tran10_2_, tolls0_.valor_transacao_taxa as valor_t11_2_, tolls0_.pct_transacao_taxa as pct_tra12_2_, tolls0_.lmt_transacao_taxa as lmt_tra13_2_, tolls0_.dt_pagamento as dt_paga14_2_, tolls0_.id_mensalidade as id_mens15_2_, tolls0_.tp_conta as tp_conta2_, transactio1_.id_transacao_status as id_trans1_0_, transactio1_.ds_transacao_status as ds_trans2_0_, occurrence2_.cd_ocorrencia as cd_ocorr1_1_, occurrence2_.ds_ocorrencia as ds_ocorr2_1_, occurrence2_.ds_pos as ds_pos1_ from pedagio tolls0_, transacao_status transactio1_, ocorrencia occurrence2_ where tolls0_.id_mensalidade=4264 and tolls0_.id_transacao_status=transactio1_.id_transacao_status(+) and tolls0_.cd_ocorrencia=occurrence2_.cd_ocorrencia(+)
1110913677109|31|43|statement|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=? and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)
1110913677109|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, ds_ocorr2_2_ = BEM SUCEDIDA APROVAGCO/CONCLUSCO OU ESSA VERIFICAGCO V.I.P. PIN I VALIDA, ds_pos2_ = APROVACAO OK/VERIF. VIP PIN OK, fg_tran11_3_ = 1, id_efeti9_3_ = 2, id_estado1_ = 33, id_parc10_3_ = 2, id_parce5_3_ = 5, nr_parcela3_ = 2, tp_conta3_ = 0
1110913677109|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 2, id_estado1_ = 33, id_parc10_3_ = 2, id_parce5_3_ = 5, nr_parcela3_ = 3, tp_conta3_ = 0
1110913677109|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 2, id_estado1_ = 33, id_parc10_3_ = 2, id_parce5_3_ = 5, nr_parcela3_ = 4, tp_conta3_ = 0
1110913677125|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 2, id_estado1_ = 33, id_parc10_3_ = 3, id_parce5_3_ = 5, nr_parcela3_ = 5, tp_conta3_ = 0
1110913677125|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 2, id_estado1_ = 33, id_parc10_3_ = 2, id_parce5_3_ = 5, nr_parcela3_ = 6, tp_conta3_ = 0
1110913677125|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 1, id_estado1_ = 33, id_parc10_3_ = 1, id_parce5_3_ = 5, nr_parcela3_ = 1, tp_conta3_ = 0
1110913677125|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 1, id_estado1_ = 33, id_parc10_3_ = 2, id_parce5_3_ = 5, nr_parcela3_ = 2, tp_conta3_ = 0
1110913677125|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 2, id_estado1_ = 33, id_parc10_3_ = 2, id_parce5_3_ = 5, nr_parcela3_ = 3, tp_conta3_ = 0
1110913677125|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 1, id_estado1_ = 33, id_parc10_3_ = 3, id_parce5_3_ = 5, nr_parcela3_ = 4, tp_conta3_ = 0
1110913677140|-1||resultset|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=4264 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|cd_ocorr1_2_ = 00, cd_ocorr8_3_ = 00, cpf0_ = 23044262046, cpf3_ = 23044262046, fg_tran11_3_ = 1, id_efeti9_3_ = 1, id_estado1_ = 33, id_parc10_3_ = 1, id_parce5_3_ = 5, nr_parcela3_ = 1, tp_conta3_ = 0
1110913677156|16|43|statement|select tolls0_.id_pedagio as id_pedagio__, tolls0_.id_mensalidade as id_mens15___, tolls0_.id_pedagio as id_pedagio2_, tolls0_.valor as valor2_, tolls0_.id_pedagio_status as id_pedag3_2_, tolls0_.id_transacao_status as id_trans4_2_, tolls0_.id_midia as id_midia2_, tolls0_.cpf as cpf2_, tolls0_.dt_pedagio as dt_pedagio2_, tolls0_.cd_ocorrencia as cd_ocorr8_2_, tolls0_.historico as historico2_, tolls0_.fg_transacao_taxa as fg_tran10_2_, tolls0_.valor_transacao_taxa as valor_t11_2_, tolls0_.pct_transacao_taxa as pct_tra12_2_, tolls0_.lmt_transacao_taxa as lmt_tra13_2_, tolls0_.dt_pagamento as dt_paga14_2_, tolls0_.id_mensalidade as id_mens15_2_, tolls0_.tp_conta as tp_conta2_, transactio1_.id_transacao_status as id_trans1_0_, transactio1_.ds_transacao_status as ds_trans2_0_, occurrence2_.cd_ocorrencia as cd_ocorr1_1_, occurrence2_.ds_ocorrencia as ds_ocorr2_1_, occurrence2_.ds_pos as ds_pos1_ from pedagio tolls0_, transacao_status transactio1_, ocorrencia occurrence2_ where tolls0_.id_mensalidade=? and tolls0_.id_transacao_status=transactio1_.id_transacao_status(+) and tolls0_.cd_ocorrencia=occurrence2_.cd_ocorrencia(+)|select tolls0_.id_pedagio as id_pedagio__, tolls0_.id_mensalidade as id_mens15___, tolls0_.id_pedagio as id_pedagio2_, tolls0_.valor as valor2_, tolls0_.id_pedagio_status as id_pedag3_2_, tolls0_.id_transacao_status as id_trans4_2_, tolls0_.id_midia as id_midia2_, tolls0_.cpf as cpf2_, tolls0_.dt_pedagio as dt_pedagio2_, tolls0_.cd_ocorrencia as cd_ocorr8_2_, tolls0_.historico as historico2_, tolls0_.fg_transacao_taxa as fg_tran10_2_, tolls0_.valor_transacao_taxa as valor_t11_2_, tolls0_.pct_transacao_taxa as pct_tra12_2_, tolls0_.lmt_transacao_taxa as lmt_tra13_2_, tolls0_.dt_pagamento as dt_paga14_2_, tolls0_.id_mensalidade as id_mens15_2_, tolls0_.tp_conta as tp_conta2_, transactio1_.id_transacao_status as id_trans1_0_, transactio1_.ds_transacao_status as ds_trans2_0_, occurrence2_.cd_ocorrencia as cd_ocorr1_1_, occurrence2_.ds_ocorrencia as ds_ocorr2_1_, occurrence2_.ds_pos as ds_pos1_ from pedagio tolls0_, transacao_status transactio1_, ocorrencia occurrence2_ where tolls0_.id_mensalidade=3990 and tolls0_.id_transacao_status=transactio1_.id_transacao_status(+) and tolls0_.cd_ocorrencia=occurrence2_.cd_ocorrencia(+)
1110913677171|0|43|statement|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=? and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=3990 and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)
1110913677187|0|43|statement|select tolls0_.id_pedagio as id_pedagio__, tolls0_.id_mensalidade as id_mens15___, tolls0_.id_pedagio as id_pedagio2_, tolls0_.valor as valor2_, tolls0_.id_pedagio_status as id_pedag3_2_, tolls0_.id_transacao_status as id_trans4_2_, tolls0_.id_midia as id_midia2_, tolls0_.cpf as cpf2_, tolls0_.dt_pedagio as dt_pedagio2_, tolls0_.cd_ocorrencia as cd_ocorr8_2_, tolls0_.historico as historico2_, tolls0_.fg_transacao_taxa as fg_tran10_2_, tolls0_.valor_transacao_taxa as valor_t11_2_, tolls0_.pct_transacao_taxa as pct_tra12_2_, tolls0_.lmt_transacao_taxa as lmt_tra13_2_, tolls0_.dt_pagamento as dt_paga14_2_, tolls0_.id_mensalidade as id_mens15_2_, tolls0_.tp_conta as tp_conta2_, transactio1_.id_transacao_status as id_trans1_0_, transactio1_.ds_transacao_status as ds_trans2_0_, occurrence2_.cd_ocorrencia as cd_ocorr1_1_, occurrence2_.ds_ocorrencia as ds_ocorr2_1_, occurrence2_.ds_pos as ds_pos1_ from pedagio tolls0_, transacao_status transactio1_, ocorrencia occurrence2_ where tolls0_.id_mensalidade=? and tolls0_.id_transacao_status=transactio1_.id_transacao_status(+) and tolls0_.cd_ocorrencia=occurrence2_.cd_ocorrencia(+)|select tolls0_.id_pedagio as id_pedagio__, tolls0_.id_mensalidade as id_mens15___, tolls0_.id_pedagio as id_pedagio2_, tolls0_.valor as valor2_, tolls0_.id_pedagio_status as id_pedag3_2_, tolls0_.id_transacao_status as id_trans4_2_, tolls0_.id_midia as id_midia2_, tolls0_.cpf as cpf2_, tolls0_.dt_pedagio as dt_pedagio2_, tolls0_.cd_ocorrencia as cd_ocorr8_2_, tolls0_.historico as historico2_, tolls0_.fg_transacao_taxa as fg_tran10_2_, tolls0_.valor_transacao_taxa as valor_t11_2_, tolls0_.pct_transacao_taxa as pct_tra12_2_, tolls0_.lmt_transacao_taxa as lmt_tra13_2_, tolls0_.dt_pagamento as dt_paga14_2_, tolls0_.id_mensalidade as id_mens15_2_, tolls0_.tp_conta as tp_conta2_, transactio1_.id_transacao_status as id_trans1_0_, transactio1_.ds_transacao_status as ds_trans2_0_, occurrence2_.cd_ocorrencia as cd_ocorr1_1_, occurrence2_.ds_ocorrencia as ds_ocorr2_1_, occurrence2_.ds_pos as ds_pos1_ from pedagio tolls0_, transacao_status transactio1_, ocorrencia occurrence2_ where tolls0_.id_mensalidade=3985 and tolls0_.id_transacao_status=transactio1_.id_transacao_status(+) and tolls0_.cd_ocorrencia=occurrence2_.cd_ocorrencia(+)
1110913677218|15|43|statement|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transacao_taxa as valor_t12_3_, parcels0_.pct_transacao_taxa as pct_tra13_3_, parcels0_.lmt_transacao_taxa as lmt_tra14_3_, parcels0_.dt_pagamento as dt_paga15_3_, parcels0_.id_mensalidade as id_mens16_3_, parcels0_.id_parcela_infolog as id_parc17_3_, parcels0_.tp_conta as tp_conta3_, user1_.cpf as cpf0_, user1_.rg as rg0_, user1_.uf_rg as uf_rg0_, user1_.nome as nome0_, user1_.login as login0_, user1_.senha as senha0_, user1_.email as email0_, user1_.cargo as cargo0_, user1_.id_perfil as id_perfil0_, user1_.id_usuario_status as id_usua10_0_, user1_.dt_inclusao as dt_incl11_0_, user1_.dt_exclusao as dt_excl12_0_, user1_.primeiro_acesso as primeir13_0_, state2_.id_estado as id_estado1_, state2_.no_estado as no_estado1_, state2_.id_pais as id_pais1_, occurrence3_.cd_ocorrencia as cd_ocorr1_2_, occurrence3_.ds_ocorrencia as ds_ocorr2_2_, occurrence3_.ds_pos as ds_pos2_ from parcela parcels0_, usuario user1_, estado state2_, ocorrencia occurrence3_ where parcels0_.id_mensalidade=? and parcels0_.cpf=user1_.cpf(+) and user1_.uf_rg=state2_.id_estado(+) and parcels0_.cd_ocorrencia=occurrence3_.cd_ocorrencia(+)|select parcels0_.id_parcela as id_parcela__, parcels0_.id_mensalidade as id_mens16___, parcels0_.id_parcela as id_parcela3_, parcels0_.id_viagem as id_viagem3_, parcels0_.nr_parcela as nr_parcela3_, parcels0_.valor as valor3_, parcels0_.id_parcela_status as id_parce5_3_, parcels0_.cpf as cpf3_, parcels0_.dt_parcela as dt_parcela3_, parcels0_.cd_ocorrencia as cd_ocorr8_3_, parcels0_.id_efetivacao_tipo as id_efeti9_3_, parcels0_.id_parcela_tipo as id_parc10_3_, parcels0_.fg_transacao_taxa as fg_tran11_3_, parcels0_.valor_transac
Login
FAQ
Search
