Hi all,

Hibernate version: 2.1.4


Name and version of the database you are using: Oracle 8i


I have the following code in the hibernate:




I saw the log and for the HQL above is generated the following SQL.

I´m using outer join fetching in the xml mapping, by using many-to-one="true".

This is generating very network traffic.

Is there a way for solve this?



The generated SQL (show_sql=true):

[code]
1110310930421|31|2|statement|select distinct user0_.cpf as cpf, user0_.rg as rg, user0_.uf_rg as uf_rg, user0_.nome as nome, user0_.login as login, user0_.senha as senha, user0_.email as email, user0_.cargo as cargo, user0_.id_perfil as id_perfil, user0_.id_usuario_status as id_usua10_, user0_.dt_inclusao as dt_incl11_, user0_.dt_exclusao as dt_excl12_, user0_.primeiro_acesso as primeir13_ from usuario user0_, perfil template1_, empresa company2_, empresa company3_ where (user0_.login='fcompaq' )and(user0_.senha='01ux7/b5aiw=' )and(user0_.id_usuario_status='1' )and(company2_.id_empresa_status in('A' , 'S' , 'P') and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj)and(((company2_.cnpj_pai is null and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj))or(((company2_.cnpj_pai is not null and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj))and((company3_.id_empresa_status in('A' , 'S' , 'P') and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj and company2_.cnpj_pai=company3_.cnpj))))|select distinct user0_.cpf as cpf, user0_.rg as rg, user0_.uf_rg as uf_rg, user0_.nome as nome, user0_.login as login, user0_.senha as senha, user0_.email as email, user0_.cargo as cargo, user0_.id_perfil as id_perfil, user0_.id_usuario_status as id_usua10_, user0_.dt_inclusao as dt_incl11_, user0_.dt_exclusao as dt_excl12_, user0_.primeiro_acesso as primeir13_ from usuario user0_, perfil template1_, empresa company2_, empresa company3_ where (user0_.login='fcompaq' )and(user0_.senha='01ux7/b5aiw=' )and(user0_.id_usuario_status='1' )and(company2_.id_empresa_status in('A' , 'S' , 'P') and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj)and(((company2_.cnpj_pai is null and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj))or(((company2_.cnpj_pai is not null and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj))and((company3_.id_empresa_status in('A' , 'S' , 'P') and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj and company2_.cnpj_pai=company3_.cnpj))))
1110310930453|-1||resultset|select distinct user0_.cpf as cpf, user0_.rg as rg, user0_.uf_rg as uf_rg, user0_.nome as nome, user0_.login as login, user0_.senha as senha, user0_.email as email, user0_.cargo as cargo, user0_.id_perfil as id_perfil, user0_.id_usuario_status as id_usua10_, user0_.dt_inclusao as dt_incl11_, user0_.dt_exclusao as dt_excl12_, user0_.primeiro_acesso as primeir13_ from usuario user0_, perfil template1_, empresa company2_, empresa company3_ where (user0_.login='fcompaq' )and(user0_.senha='01ux7/b5aiw=' )and(user0_.id_usuario_status='1' )and(company2_.id_empresa_status in('A' , 'S' , 'P') and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj)and(((company2_.cnpj_pai is null and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj))or(((company2_.cnpj_pai is not null and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj))and((company3_.id_empresa_status in('A' , 'S' , 'P') and user0_.id_perfil=template1_.id_perfil and template1_.cnpj=company2_.cnpj and company2_.cnpj_pai=company3_.cnpj))))|cargo = PROGRAMADOR, cpf = 33807840281, email = bogas@hst.com.br, id_usua10_ = 1, login = fcompaq, nome = US. COMPAQ FILIAL, primeir13_ = 1, rg = 54625842, senha = 01ux7/b5aiw=, uf_rg = 30
1110310930562|94|2|statement|select state0_.id_estado as id_estado1_, state0_.no_estado as no_estado1_, state0_.id_pais as id_pais1_, country1_.id_pais as id_pais0_, country1_.no_pais as no_pais0_ from estado state0_, pais country1_ where state0_.id_estado=? and state0_.id_pais=country1_.id_pais(+)|select state0_.id_estado as id_estado1_, state0_.no_estado as no_estado1_, state0_.id_pais as id_pais1_, country1_.id_pais as id_pais0_, country1_.no_pais as no_pais0_ from estado state0_, pais country1_ where state0_.id_estado=30 and state0_.id_pais=country1_.id_pais(+)
1110310930562|-1||resultset|select state0_.id_estado as id_estado1_, state0_.no_estado as no_estado1_, state0_.id_pais as id_pais1_, country1_.id_pais as id_pais0_, country1_.no_pais as no_pais0_ from estado state0_, pais country1_ where state0_.id_estado=30 and state0_.id_pais=country1_.id_pais(+)|id_pais0_ = 8, id_pais1_ = 8, no_estado1_ = RS, no_pais0_ = BRASIL
1110310930750|157|2|statement|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=? and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=18 and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)
1110310930781|-1||resultset|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=18 and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|agencia0_ = 0001, bairro0_ = JARDIM DO TREVO, cep0_ = 12910000, cnpj0_ = 16361234000102, cnpj10_ = 16361234000102, cnpj9_ = 16361234000102, cnpj_pai0_ = 91971872000152, cnpj_ted0_ = 16361234000102, complem11_0_ = COMPLEM., cpf7_ = 33807840281, cpf_con19_0_ = 33807840281, ddd_fax0_ = 19, ddd_tel15_0_ = 19, ds_ativi2_3_ = TRANSPORTADOR, ds_empre2_2_ = ATIVO, ds_indic2_1_ = PONTO DE EMBARQUE, ds_perfil10_ = LIBERA ACESSO AOS USUARIOS DO PONTO DE EMBARQUE, ds_usuar2_8_ = HABILITADO, fax0_ = 38672222, fg_conta0_ = 0, fg_manu26_0_ = 0, fg_trans2_9_ = 0, id_ativi1_3_ = 2, id_ativi4_0_ = 2, id_empre1_2_ = A, id_empre3_0_ = A, id_estado4_ = 33, id_estado5_ = 33, id_indic1_1_ = E, id_indic2_0_ = E, id_pais5_ = 8, id_pais6_ = 8, id_usuar1_8_ = 1, logradouro0_ = R.TAQUARAL, no_cidade4_ = BRAGANCA PAULISTA, no_estado5_ = SP, nome0_ = COMPAQ FILIAL, nome10_ = MASTER EMBARQUE, nr_banco0_ = 749, nr_conta0_ = 0000000001, numero0_ = 20, pm_perfil10_ = C0A0F800F0D8F6C0FC00F8000000000000000000000000000000000000000000, razao_so8_0_ = COMPAQ FILIAL, telefone0_ = 38672222, tp_conta0_ = 0
1110310930953|141|2|statement|select company0_.cnpj as cnpj11_, company0_.id_indicador as id_indic2_11_, company0_.id_empresa_status as id_empre3_11_, company0_.id_atividade_tipo as id_ativi4_11_, company0_.dt_pedido_acesso as dt_pedid5_11_, company0_.dt_manutencao as dt_manut6_11_, company0_.nome as nome11_, company0_.razao_social as razao_so8_11_, company0_.logradouro as logradouro11_, company0_.numero as numero11_, company0_.complemento as complem11_11_, company0_.bairro as bairro11_, company0_.id_cidade as id_cidade11_, company0_.cep as cep11_, company0_.ddd_telefone as ddd_tel15_11_, company0_.telefone as telefone11_, company0_.ddd_fax as ddd_fax11_, company0_.fax as fax11_, company0_.cpf_contato as cpf_con19_11_, company0_.nr_banco as nr_banco11_, company0_.agencia as agencia11_, company0_.nr_conta as nr_conta11_, company0_.fg_conta as fg_conta11_, company0_.cnpj_ted as cnpj_ted11_, company0_.cnpj_pai as cnpj_pai11_, company0_.fg_manutencao as fg_manu26_11_, company0_.tp_conta as tp_conta11_, indicator1_.id_indicador as id_indic1_0_, indicator1_.ds_indicador as ds_indic2_0_, companysta2_.id_empresa_status as id_empre1_1_, companysta2_.ds_empresa_status as ds_empre2_1_, activityty3_.id_atividade_tipo as id_ativi1_2_, activityty3_.ds_atividade_tipo as ds_ativi2_2_, city4_.id_cidade as id_cidade3_, city4_.no_cidade as no_cidade3_, city4_.id_estado as id_estado3_, state5_.id_estado as id_estado4_, state5_.no_estado as no_estado4_, state5_.id_pais as id_pais4_, country6_.id_pais as id_pais5_, country6_.no_pais as no_pais5_, user7_.cpf as cpf6_, user7_.rg as rg6_, user7_.uf_rg as uf_rg6_, user7_.nome as nome6_, user7_.login as login6_, user7_.senha as senha6_, user7_.email as email6_, user7_.cargo as cargo6_, user7_.id_perfil as id_perfil6_, user7_.id_usuario_status as id_usua10_6_, user7_.dt_inclusao as dt_incl11_6_, user7_.dt_exclusao as dt_excl12_6_, user7_.primeiro_acesso as primeir13_6_, template8_.id_perfil as id_perfil7_, template8_.nome as nome7_, template8_.ds_perfil as ds_perfil7_, template8_.pm_perfil as pm_perfil7_, template8_.cnpj as cnpj7_, template8_.id_perfil_pai as id_perfi6_7_, template9_.id_perfil as id_perfil8_, template9_.nome as nome8_, template9_.ds_perfil as ds_perfil8_, template9_.pm_perfil as pm_perfil8_, template9_.cnpj as cnpj8_, template9_.id_perfil_pai as id_perfi6_8_, userstatus10_.id_usuario_status as id_usuar1_9_, userstatus10_.ds_usuario_status as ds_usuar2_9_, transactio11_.cnpj as cnpj10_, transactio11_.fg_transacao_taxa as fg_trans2_10_, transactio11_.valor as valor10_, transactio11_.porcentagem as porcenta4_10_, transactio11_.limite as limite10_ from empresa company0_, indicador indicator1_, empresa_status companysta2_, atividade_tipo activityty3_, cidade city4_, estado state5_, pais country6_, usuario user7_, perfil template8_, perfil template9_, usuario_status userstatus10_, transacao_taxa transactio11_ where company0_.cnpj=? and company0_.id_indicador=indicator1_.id_indicador(+) and company0_.id_empresa_status=companysta2_.id_empresa_status(+) and company0_.id_atividade_tipo=activityty3_.id_atividade_tipo(+) and company0_.id_cidade=city4_.id_cidade(+) and city4_.id_estado=state5_.id_estado(+) and state5_.id_pais=country6_.id_pais(+) and company0_.cpf_contato=user7_.cpf(+) and user7_.id_perfil=template8_.id_perfil(+) and template8_.id_perfil_pai=template9_.id_perfil(+) and user7_.id_usuario_status=userstatus10_.id_usuario_status(+) and company0_.cnpj=transactio11_.cnpj(+)|select company0_.cnpj as cnpj11_, company0_.id_indicador as id_indic2_11_, company0_.id_empresa_status as id_empre3_11_, company0_.id_atividade_tipo as id_ativi4_11_, company0_.dt_pedido_acesso as dt_pedid5_11_, company0_.dt_manutencao as dt_manut6_11_, company0_.nome as nome11_, company0_.razao_social as razao_so8_11_, company0_.logradouro as logradouro11_, company0_.numero as numero11_, company0_.complemento as complem11_11_, company0_.bairro as bairro11_, company0_.id_cidade as id_cidade11_, company0_.cep as cep11_, company0_.ddd_telefone as ddd_tel15_11_, company0_.telefone as telefone11_, company0_.ddd_fax as ddd_fax11_, company0_.fax as fax11_, company0_.cpf_contato as cpf_con19_11_, company0_.nr_banco as nr_banco11_, company0_.agencia as agencia11_, company0_.nr_conta as nr_conta11_, company0_.fg_conta as fg_conta11_, company0_.cnpj_ted as cnpj_ted11_, company0_.cnpj_pai as cnpj_pai11_, company0_.fg_manutencao as fg_manu26_11_, company0_.tp_conta as tp_conta11_, indicator1_.id_indicador as id_indic1_0_, indicator1_.ds_indicador as ds_indic2_0_, companysta2_.id_empresa_status as id_empre1_1_, companysta2_.ds_empresa_status as ds_empre2_1_, activityty3_.id_atividade_tipo as id_ativi1_2_, activityty3_.ds_atividade_tipo as ds_ativi2_2_, city4_.id_cidade as id_cidade3_, city4_.no_cidade as no_cidade3_, city4_.id_estado as id_estado3_, state5_.id_estado as id_estado4_, state5_.no_estado as no_estado4_, state5_.id_pais as id_pais4_, country6_.id_pais as id_pais5_, country6_.no_pais as no_pais5_, user7_.cpf as cpf6_, user7_.rg as rg6_, user7_.uf_rg as uf_rg6_, user7_.nome as nome6_, user7_.login as login6_, user7_.senha as senha6_, user7_.email as email6_, user7_.cargo as cargo6_, user7_.id_perfil as id_perfil6_, user7_.id_usuario_status as id_usua10_6_, user7_.dt_inclusao as dt_incl11_6_, user7_.dt_exclusao as dt_excl12_6_, user7_.primeiro_acesso as primeir13_6_, template8_.id_perfil as id_perfil7_, template8_.nome as nome7_, template8_.ds_perfil as ds_perfil7_, template8_.pm_perfil as pm_perfil7_, template8_.cnpj as cnpj7_, template8_.id_perfil_pai as id_perfi6_7_, template9_.id_perfil as id_perfil8_, template9_.nome as nome8_, template9_.ds_perfil as ds_perfil8_, template9_.pm_perfil as pm_perfil8_, template9_.cnpj as cnpj8_, template9_.id_perfil_pai as id_perfi6_8_, userstatus10_.id_usuario_status as id_usuar1_9_, userstatus10_.ds_usuario_status as ds_usuar2_9_, transactio11_.cnpj as cnpj10_, transactio11_.fg_transacao_taxa as fg_trans2_10_, transactio11_.valor as valor10_, transactio11_.porcentagem as porcenta4_10_, transactio11_.limite as limite10_ from empresa company0_, indicador indicator1_, empresa_status companysta2_, atividade_tipo activityty3_, cidade city4_, estado state5_, pais country6_, usuario user7_, perfil template8_, perfil template9_, usuario_status userstatus10_, transacao_taxa transactio11_ where company0_.cnpj='91971872000152' and company0_.id_indicador=indicator1_.id_indicador(+) and company0_.id_empresa_status=companysta2_.id_empresa_status(+) and company0_.id_atividade_tipo=activityty3_.id_atividade_tipo(+) and company0_.id_cidade=city4_.id_cidade(+) and city4_.id_estado=state5_.id_estado(+) and state5_.id_pais=country6_.id_pais(+) and company0_.cpf_contato=user7_.cpf(+) and user7_.id_perfil=template8_.id_perfil(+) and template8_.id_perfil_pai=template9_.id_perfil(+) and user7_.id_usuario_status=userstatus10_.id_usuario_status(+) and company0_.cnpj=transactio11_.cnpj(+)
1110310930984|-1||resultset|select company0_.cnpj as cnpj11_, company0_.id_indicador as id_indic2_11_, company0_.id_empresa_status as id_empre3_11_, company0_.id_atividade_tipo as id_ativi4_11_, company0_.dt_pedido_acesso as dt_pedid5_11_, company0_.dt_manutencao as dt_manut6_11_, company0_.nome as nome11_, company0_.razao_social as razao_so8_11_, company0_.logradouro as logradouro11_, company0_.numero as numero11_, company0_.complemento as complem11_11_, company0_.bairro as bairro11_, company0_.id_cidade as id_cidade11_, company0_.cep as cep11_, company0_.ddd_telefone as ddd_tel15_11_, company0_.telefone as telefone11_, company0_.ddd_fax as ddd_fax11_, company0_.fax as fax11_, company0_.cpf_contato as cpf_con19_11_, company0_.nr_banco as nr_banco11_, company0_.agencia as agencia11_, company0_.nr_conta as nr_conta11_, company0_.fg_conta as fg_conta11_, company0_.cnpj_ted as cnpj_ted11_, company0_.cnpj_pai as cnpj_pai11_, company0_.fg_manutencao as fg_manu26_11_, company0_.tp_conta as tp_conta11_, indicator1_.id_indicador as id_indic1_0_, indicator1_.ds_indicador as ds_indic2_0_, companysta2_.id_empresa_status as id_empre1_1_, companysta2_.ds_empresa_status as ds_empre2_1_, activityty3_.id_atividade_tipo as id_ativi1_2_, activityty3_.ds_atividade_tipo as ds_ativi2_2_, city4_.id_cidade as id_cidade3_, city4_.no_cidade as no_cidade3_, city4_.id_estado as id_estado3_, state5_.id_estado as id_estado4_, state5_.no_estado as no_estado4_, state5_.id_pais as id_pais4_, country6_.id_pais as id_pais5_, country6_.no_pais as no_pais5_, user7_.cpf as cpf6_, user7_.rg as rg6_, user7_.uf_rg as uf_rg6_, user7_.nome as nome6_, user7_.login as login6_, user7_.senha as senha6_, user7_.email as email6_, user7_.cargo as cargo6_, user7_.id_perfil as id_perfil6_, user7_.id_usuario_status as id_usua10_6_, user7_.dt_inclusao as dt_incl11_6_, user7_.dt_exclusao as dt_excl12_6_, user7_.primeiro_acesso as primeir13_6_, template8_.id_perfil as id_perfil7_, template8_.nome as nome7_, template8_.ds_perfil as ds_perfil7_, template8_.pm_perfil as pm_perfil7_, template8_.cnpj as cnpj7_, template8_.id_perfil_pai as id_perfi6_7_, template9_.id_perfil as id_perfil8_, template9_.nome as nome8_, template9_.ds_perfil as ds_perfil8_, template9_.pm_perfil as pm_perfil8_, template9_.cnpj as cnpj8_, template9_.id_perfil_pai as id_perfi6_8_, userstatus10_.id_usuario_status as id_usuar1_9_, userstatus10_.ds_usuario_status as ds_usuar2_9_, transactio11_.cnpj as cnpj10_, transactio11_.fg_transacao_taxa as fg_trans2_10_, transactio11_.valor as valor10_, transactio11_.porcentagem as porcenta4_10_, transactio11_.limite as limite10_ from empresa company0_, indicador indicator1_, empresa_status companysta2_, atividade_tipo activityty3_, cidade city4_, estado state5_, pais country6_, usuario user7_, perfil template8_, perfil template9_, usuario_status userstatus10_, transacao_taxa transactio11_ where company0_.cnpj='91971872000152' and company0_.id_indicador=indicator1_.id_indicador(+) and company0_.id_empresa_status=companysta2_.id_empresa_status(+) and company0_.id_atividade_tipo=activityty3_.id_atividade_tipo(+) and company0_.id_cidade=city4_.id_cidade(+) and city4_.id_estado=state5_.id_estado(+) and state5_.id_pais=country6_.id_pais(+) and company0_.cpf_contato=user7_.cpf(+) and user7_.id_perfil=template8_.id_perfil(+) and template8_.id_perfil_pai=template9_.id_perfil(+) and user7_.id_usuario_status=userstatus10_.id_usuario_status(+) and company0_.cnpj=transactio11_.cnpj(+)|agencia11_ = 0001, bairro11_ = SANTA CLARA, cargo6_ = TESTE, cep11_ = 12914000, cnpj10_ = 91971872000152, cnpj7_ = 91971872000152, cnpj8_ = 01000786000100, cnpj_pai11_ = null, cnpj_ted11_ = 91971872000152, complem11_11_ = null, cpf6_ = 12149743760, cpf_con19_11_ = 12149743760, ddd_fax11_ = 0, ddd_tel15_11_ = 11, ds_ativi2_2_ = EMBARCADOR, ds_empre2_1_ = SUSPENSO, ds_indic2_0_ = CONTRATANTE, ds_perfil7_ = LIBERA ACESSO AOS USUARIOS DA CONTRATANTE, ds_perfil8_ = I O RESPONSAVEL PELA EMPRESA MATRIZ (CONTRATANTE) , email6_ = ////////////, fax11_ = 0, fg_conta11_ = 0, fg_manu26_11_ = 0, fg_trans2_10_ = 1, id_ativi1_2_ = 1, id_ativi4_11_ = 1, id_empre1_1_ = S, id_empre3_11_ = S, id_estado4_ = 33, id_indic1_0_ = C, id_indic2_11_ = C, id_pais5_ = 8, id_usua10_6_ = 1, id_usuar1_9_ = 1, login6_ = compaq, logradouro11_ = R. EMILIO RIBAS, nome11_ = COMPAQ DESENVOLVIMENTO DE SISTEMAS ELETRTNICOS, nome6_ = ADAILTON SOARES MANTEIGA DA SILVA ANTUNES BREDA JR, nome7_ = MASTER CONTRATANTE, nome8_ = MASTER CONTRATANTE, nr_banco11_ = 749, nr_conta11_ = 0000000001, numero11_ = 2150, pm_perfil7_ = C0E0F800F0D8F6C0FC00F8000080000000000000000000000000000000000000, pm_perfil8_ = C0E0F800F0D8F6C0FC00F8000080000000000000000000000000000000000000, primeir13_6_ = 1, razao_so8_11_ = COMPAQ DESENVOLVIMENTO DE SISTEMAS ELETRTNICOS, rg6_ = 318943558, senha6_ = 01ux7/b5aiw=, telefone11_ = 40351000, tp_conta11_ = 0, uf_rg6_ = 33
1110310931203|125|2|statement|select company0_.cnpj as cnpj11_, company0_.id_indicador as id_indic2_11_, company0_.id_empresa_status as id_empre3_11_, company0_.id_atividade_tipo as id_ativi4_11_, company0_.dt_pedido_acesso as dt_pedid5_11_, company0_.dt_manutencao as dt_manut6_11_, company0_.nome as nome11_, company0_.razao_social as razao_so8_11_, company0_.logradouro as logradouro11_, company0_.numero as numero11_, company0_.complemento as complem11_11_, company0_.bairro as bairro11_, company0_.id_cidade as id_cidade11_, company0_.cep as cep11_, company0_.ddd_telefone as ddd_tel15_11_, company0_.telefone as telefone11_, company0_.ddd_fax as ddd_fax11_, company0_.fax as fax11_, company0_.cpf_contato as cpf_con19_11_, company0_.nr_banco as nr_banco11_, company0_.agencia as agencia11_, company0_.nr_conta as nr_conta11_, company0_.fg_conta as fg_conta11_, company0_.cnpj_ted as cnpj_ted11_, company0_.cnpj_pai as cnpj_pai11_, company0_.fg_manutencao as fg_manu26_11_, company0_.tp_conta as tp_conta11_, indicator1_.id_indicador as id_indic1_0_, indicator1_.ds_indicador as ds_indic2_0_, companysta2_.id_empresa_status as id_empre1_1_, companysta2_.ds_empresa_status as ds_empre2_1_, activityty3_.id_atividade_tipo as id_ativi1_2_, activityty3_.ds_atividade_tipo as ds_ativi2_2_, city4_.id_cidade as id_cidade3_, city4_.no_cidade as no_cidade3_, city4_.id_estado as id_estado3_, state5_.id_estado as id_estado4_, state5_.no_estado as no_estado4_, state5_.id_pais as id_pais4_, country6_.id_pais as id_pais5_, country6_.no_pais as no_pais5_, user7_.cpf as cpf6_, user7_.rg as rg6_, user7_.uf_rg as uf_rg6_, user7_.nome as nome6_, user7_.login as login6_, user7_.senha as senha6_, user7_.email as email6_, user7_.cargo as cargo6_, user7_.id_perfil as id_perfil6_, user7_.id_usuario_status as id_usua10_6_, user7_.dt_inclusao as dt_incl11_6_, user7_.dt_exclusao as dt_excl12_6_, user7_.primeiro_acesso as primeir13_6_, template8_.id_perfil as id_perfil7_, template8_.nome as nome7_, template8_.ds_perfil as ds_perfil7_, template8_.pm_perfil as pm_perfil7_, template8_.cnpj as cnpj7_, template8_.id_perfil_pai as id_perfi6_7_, template9_.id_perfil as id_perfil8_, template9_.nome as nome8_, template9_.ds_perfil as ds_perfil8_, template9_.pm_perfil as pm_perfil8_, template9_.cnpj as cnpj8_, template9_.id_perfil_pai as id_perfi6_8_, userstatus10_.id_usuario_status as id_usuar1_9_, userstatus10_.ds_usuario_status as ds_usuar2_9_, transactio11_.cnpj as cnpj10_, transactio11_.fg_transacao_taxa as fg_trans2_10_, transactio11_.valor as valor10_, transactio11_.porcentagem as porcenta4_10_, transactio11_.limite as limite10_ from empresa company0_, indicador indicator1_, empresa_status companysta2_, atividade_tipo activityty3_, cidade city4_, estado state5_, pais country6_, usuario user7_, perfil template8_, perfil template9_, usuario_status userstatus10_, transacao_taxa transactio11_ where company0_.cnpj=? and company0_.id_indicador=indicator1_.id_indicador(+) and company0_.id_empresa_status=companysta2_.id_empresa_status(+) and company0_.id_atividade_tipo=activityty3_.id_atividade_tipo(+) and company0_.id_cidade=city4_.id_cidade(+) and city4_.id_estado=state5_.id_estado(+) and state5_.id_pais=country6_.id_pais(+) and company0_.cpf_contato=user7_.cpf(+) and user7_.id_perfil=template8_.id_perfil(+) and template8_.id_perfil_pai=template9_.id_perfil(+) and user7_.id_usuario_status=userstatus10_.id_usuario_status(+) and company0_.cnpj=transactio11_.cnpj(+)|select company0_.cnpj as cnpj11_, company0_.id_indicador as id_indic2_11_, company0_.id_empresa_status as id_empre3_11_, company0_.id_atividade_tipo as id_ativi4_11_, company0_.dt_pedido_acesso as dt_pedid5_11_, company0_.dt_manutencao as dt_manut6_11_, company0_.nome as nome11_, company0_.razao_social as razao_so8_11_, company0_.logradouro as logradouro11_, company0_.numero as numero11_, company0_.complemento as complem11_11_, company0_.bairro as bairro11_, company0_.id_cidade as id_cidade11_, company0_.cep as cep11_, company0_.ddd_telefone as ddd_tel15_11_, company0_.telefone as telefone11_, company0_.ddd_fax as ddd_fax11_, company0_.fax as fax11_, company0_.cpf_contato as cpf_con19_11_, company0_.nr_banco as nr_banco11_, company0_.agencia as agencia11_, company0_.nr_conta as nr_conta11_, company0_.fg_conta as fg_conta11_, company0_.cnpj_ted as cnpj_ted11_, company0_.cnpj_pai as cnpj_pai11_, company0_.fg_manutencao as fg_manu26_11_, company0_.tp_conta as tp_conta11_, indicator1_.id_indicador as id_indic1_0_, indicator1_.ds_indicador as ds_indic2_0_, companysta2_.id_empresa_status as id_empre1_1_, companysta2_.ds_empresa_status as ds_empre2_1_, activityty3_.id_atividade_tipo as id_ativi1_2_, activityty3_.ds_atividade_tipo as ds_ativi2_2_, city4_.id_cidade as id_cidade3_, city4_.no_cidade as no_cidade3_, city4_.id_estado as id_estado3_, state5_.id_estado as id_estado4_, state5_.no_estado as no_estado4_, state5_.id_pais as id_pais4_, country6_.id_pais as id_pais5_, country6_.no_pais as no_pais5_, user7_.cpf as cpf6_, user7_.rg as rg6_, user7_.uf_rg as uf_rg6_, user7_.nome as nome6_, user7_.login as login6_, user7_.senha as senha6_, user7_.email as email6_, user7_.cargo as cargo6_, user7_.id_perfil as id_perfil6_, user7_.id_usuario_status as id_usua10_6_, user7_.dt_inclusao as dt_incl11_6_, user7_.dt_exclusao as dt_excl12_6_, user7_.primeiro_acesso as primeir13_6_, template8_.id_perfil as id_perfil7_, template8_.nome as nome7_, template8_.ds_perfil as ds_perfil7_, template8_.pm_perfil as pm_perfil7_, template8_.cnpj as cnpj7_, template8_.id_perfil_pai as id_perfi6_7_, template9_.id_perfil as id_perfil8_, template9_.nome as nome8_, template9_.ds_perfil as ds_perfil8_, template9_.pm_perfil as pm_perfil8_, template9_.cnpj as cnpj8_, template9_.id_perfil_pai as id_perfi6_8_, userstatus10_.id_usuario_status as id_usuar1_9_, userstatus10_.ds_usuario_status as ds_usuar2_9_, transactio11_.cnpj as cnpj10_, transactio11_.fg_transacao_taxa as fg_trans2_10_, transactio11_.valor as valor10_, transactio11_.porcentagem as porcenta4_10_, transactio11_.limite as limite10_ from empresa company0_, indicador indicator1_, empresa_status companysta2_, atividade_tipo activityty3_, cidade city4_, estado state5_, pais country6_, usuario user7_, perfil template8_, perfil template9_, usuario_status userstatus10_, transacao_taxa transactio11_ where company0_.cnpj='01000786000100' and company0_.id_indicador=indicator1_.id_indicador(+) and company0_.id_empresa_status=companysta2_.id_empresa_status(+) and company0_.id_atividade_tipo=activityty3_.id_atividade_tipo(+) and company0_.id_cidade=city4_.id_cidade(+) and city4_.id_estado=state5_.id_estado(+) and state5_.id_pais=country6_.id_pais(+) and company0_.cpf_contato=user7_.cpf(+) and user7_.id_perfil=template8_.id_perfil(+) and template8_.id_perfil_pai=template9_.id_perfil(+) and user7_.id_usuario_status=userstatus10_.id_usuario_status(+) and company0_.cnpj=transactio11_.cnpj(+)
1110310931234|-1||resultset|select company0_.cnpj as cnpj11_, company0_.id_indicador as id_indic2_11_, company0_.id_empresa_status as id_empre3_11_, company0_.id_atividade_tipo as id_ativi4_11_, company0_.dt_pedido_acesso as dt_pedid5_11_, company0_.dt_manutencao as dt_manut6_11_, company0_.nome as nome11_, company0_.razao_social as razao_so8_11_, company0_.logradouro as logradouro11_, company0_.numero as numero11_, company0_.complemento as complem11_11_, company0_.bairro as bairro11_, company0_.id_cidade as id_cidade11_, company0_.cep as cep11_, company0_.ddd_telefone as ddd_tel15_11_, company0_.telefone as telefone11_, company0_.ddd_fax as ddd_fax11_, company0_.fax as fax11_, company0_.cpf_contato as cpf_con19_11_, company0_.nr_banco as nr_banco11_, company0_.agencia as agencia11_, company0_.nr_conta as nr_conta11_, company0_.fg_conta as fg_conta11_, company0_.cnpj_ted as cnpj_ted11_, company0_.cnpj_pai as cnpj_pai11_, company0_.fg_manutencao as fg_manu26_11_, company0_.tp_conta as tp_conta11_, indicator1_.id_indicador as id_indic1_0_, indicator1_.ds_indicador as ds_indic2_0_, companysta2_.id_empresa_status as id_empre1_1_, companysta2_.ds_empresa_status as ds_empre2_1_, activityty3_.id_atividade_tipo as id_ativi1_2_, activityty3_.ds_atividade_tipo as ds_ativi2_2_, city4_.id_cidade as id_cidade3_, city4_.no_cidade as no_cidade3_, city4_.id_estado as id_estado3_, state5_.id_estado as id_estado4_, state5_.no_estado as no_estado4_, state5_.id_pais as id_pais4_, country6_.id_pais as id_pais5_, country6_.no_pais as no_pais5_, user7_.cpf as cpf6_, user7_.rg as rg6_, user7_.uf_rg as uf_rg6_, user7_.nome as nome6_, user7_.login as login6_, user7_.senha as senha6_, user7_.email as email6_, user7_.cargo as cargo6_, user7_.id_perfil as id_perfil6_, user7_.id_usuario_status as id_usua10_6_, user7_.dt_inclusao as dt_incl11_6_, user7_.dt_exclusao as dt_excl12_6_, user7_.primeiro_acesso as primeir13_6_, template8_.id_perfil as id_perfil7_, template8_.nome as nome7_, template8_.ds_perfil as ds_perfil7_, template8_.pm_perfil as pm_perfil7_, template8_.cnpj as cnpj7_, template8_.id_perfil_pai as id_perfi6_7_, template9_.id_perfil as id_perfil8_, template9_.nome as nome8_, template9_.ds_perfil as ds_perfil8_, template9_.pm_perfil as pm_perfil8_, template9_.cnpj as cnpj8_, template9_.id_perfil_pai as id_perfi6_8_, userstatus10_.id_usuario_status as id_usuar1_9_, userstatus10_.ds_usuario_status as ds_usuar2_9_, transactio11_.cnpj as cnpj10_, transactio11_.fg_transacao_taxa as fg_trans2_10_, transactio11_.valor as valor10_, transactio11_.porcentagem as porcenta4_10_, transactio11_.limite as limite10_ from empresa company0_, indicador indicator1_, empresa_status companysta2_, atividade_tipo activityty3_, cidade city4_, estado state5_, pais country6_, usuario user7_, perfil template8_, perfil template9_, usuario_status userstatus10_, transacao_taxa transactio11_ where company0_.cnpj='01000786000100' and company0_.id_indicador=indicator1_.id_indicador(+) and company0_.id_empresa_status=companysta2_.id_empresa_status(+) and company0_.id_atividade_tipo=activityty3_.id_atividade_tipo(+) and company0_.id_cidade=city4_.id_cidade(+) and city4_.id_estado=state5_.id_estado(+) and state5_.id_pais=country6_.id_pais(+) and company0_.cpf_contato=user7_.cpf(+) and user7_.id_perfil=template8_.id_perfil(+) and template8_.id_perfil_pai=template9_.id_perfil(+) and user7_.id_usuario_status=userstatus10_.id_usuario_status(+) and company0_.cnpj=transactio11_.cnpj(+)|agencia11_ = 0326, bairro11_ = PARAISO, cargo6_ = MASTER PAMCARY, cep11_ = 04005000, cnpj10_ = 01000786000100, cnpj7_ = 01000786000100, cnpj8_ = null, cnpj_pai11_ = null, cnpj_ted11_ = 01000786000100, complem11_11_ = null, cpf6_ = 11111111111, cpf_con19_11_ = 11111111111, ddd_fax11_ = 11, ddd_tel15_11_ = 11, ds_ativi2_2_ = OUTROS, ds_indic2_0_ = PAMCARY, ds_perfil7_ = LIBERA ACESSO A USUARIOS INTERNOS DA PAMCARY, ds_perfil8_ = LIBERA ACESSO A USUARIOS INTERNOS DA PAMCARY, email6_ = null, fax11_ = 38891100, fg_conta11_ = 0, fg_manu26_11_ = 0, fg_trans2_10_ = 0, id_ativi1_2_ = 4, id_ativi4_11_ = 4, id_empre1_1_ = A, id_empre3_11_ = A, id_estado3_ = 33, id_estado4_ = 33, id_indic1_0_ = P, id_indic2_11_ = P, id_pais5_ = 8, id_usua10_6_ = 1, id_usuar1_9_ = 1, login6_ = mpamcary, logradouro11_ = RUA ABILIO SOARES, no_cidade3_ = SAO PAULO, nome11_ = PAMCARY, nome6_ = MASTER PAMCARY, nome7_ = MASTER PAMCARY, nome8_ = MASTER PAMCARY, nr_banco11_ = 749, nr_conta11_ = 0000030019, numero11_ = 250, pm_perfil7_ = 00B0F880F0988000FC0050000080000000000000000000000000000000000000, pm_perfil8_ = C0B0F880F0908000FC0050000080000000000000000000000000000000000000, primeir13_6_ = 1, razao_so8_11_ = PAMCARY, rg6_ = 1, senha6_ = 01ux7/b5aiw=, telefone11_ = 38891111, tp_conta11_ = 0, uf_rg6_ = 33
1110310931406|141|2|statement|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=? and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=1 and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)
1110310931406|-1||resultset|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=1 and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|cnpj0_ = null, cnpj10_ = null, cnpj9_ = null, cpf7_ = null, ds_perfil10_ = LIBERA ACESSO AOS USUARIOS DA CONTRATANTE, id_ativi1_3_ = 0, id_empre1_2_ = null, id_estado5_ = 0, id_indic1_1_ = null, id_pais6_ = 0, id_usuar1_8_ = 0, nome10_ = MASTER CONTRATANTE, pm_perfil10_ = C0E0F800F0D8F6C0FC00F8000080000000000000000000000000000000000000
1110310931562|125|2|statement|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=? and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=8 and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)
1110310931562|-1||resultset|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=8 and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|cnpj0_ = 01000786000100, cnpj10_ = 01000786000100, cnpj9_ = 01000786000100, cpf7_ = 11111111111, ds_perfil10_ = I O RESPONSAVEL PELAS EMPRESAS FILIAIS. , id_ativi1_3_ = 4, id_empre1_2_ = A, id_estado5_ = 33, id_indic1_1_ = P, id_pais6_ = 8, id_usuar1_8_ = 1, nome10_ = MASTER EMBARQUE, pm_perfil10_ = C0A0F800F0D8F6C0FC00F8000080000000000000000000000000000000000000
1110310931718|125|2|statement|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_conta as tp_conta0_, indicator2_.id_indicador as id_indic1_1_, indicator2_.ds_indicador as ds_indic2_1_, companysta3_.id_empresa_status as id_empre1_2_, companysta3_.ds_empresa_status as ds_empre2_2_, activityty4_.id_atividade_tipo as id_ativi1_3_, activityty4_.ds_atividade_tipo as ds_ativi2_3_, city5_.id_cidade as id_cidade4_, city5_.no_cidade as no_cidade4_, city5_.id_estado as id_estado4_, state6_.id_estado as id_estado5_, state6_.no_estado as no_estado5_, state6_.id_pais as id_pais5_, country7_.id_pais as id_pais6_, country7_.no_pais as no_pais6_, user8_.cpf as cpf7_, user8_.rg as rg7_, user8_.uf_rg as uf_rg7_, user8_.nome as nome7_, user8_.login as login7_, user8_.senha as senha7_, user8_.email as email7_, user8_.cargo as cargo7_, user8_.id_perfil as id_perfil7_, user8_.id_usuario_status as id_usua10_7_, user8_.dt_inclusao as dt_incl11_7_, user8_.dt_exclusao as dt_excl12_7_, user8_.primeiro_acesso as primeir13_7_, userstatus9_.id_usuario_status as id_usuar1_8_, userstatus9_.ds_usuario_status as ds_usuar2_8_, transactio10_.cnpj as cnpj9_, transactio10_.fg_transacao_taxa as fg_trans2_9_, transactio10_.valor as valor9_, transactio10_.porcentagem as porcenta4_9_, transactio10_.limite as limite9_ from perfil template0_, empresa company1_, indicador indicator2_, empresa_status companysta3_, atividade_tipo activityty4_, cidade city5_, estado state6_, pais country7_, usuario user8_, usuario_status userstatus9_, transacao_taxa transactio10_ where template0_.id_perfil=? and template0_.cnpj=company1_.cnpj(+) and company1_.id_indicador=indicator2_.id_indicador(+) and company1_.id_empresa_status=companysta3_.id_empresa_status(+) and company1_.id_atividade_tipo=activityty4_.id_atividade_tipo(+) and company1_.id_cidade=city5_.id_cidade(+) and city5_.id_estado=state6_.id_estado(+) and state6_.id_pais=country7_.id_pais(+) and company1_.cpf_contato=user8_.cpf(+) and user8_.id_usuario_status=userstatus9_.id_usuario_status(+) and company1_.cnpj=transactio10_.cnpj(+)|select template0_.id_perfil as id_perfil10_, template0_.nome as nome10_, template0_.ds_perfil as ds_perfil10_, template0_.pm_perfil as pm_perfil10_, template0_.cnpj as cnpj10_, template0_.id_perfil_pai as id_perfi6_10_, company1_.cnpj as cnpj0_, company1_.id_indicador as id_indic2_0_, company1_.id_empresa_status as id_empre3_0_, company1_.id_atividade_tipo as id_ativi4_0_, company1_.dt_pedido_acesso as dt_pedid5_0_, company1_.dt_manutencao as dt_manut6_0_, company1_.nome as nome0_, company1_.razao_social as razao_so8_0_, company1_.logradouro as logradouro0_, company1_.numero as numero0_, company1_.complemento as complem11_0_, company1_.bairro as bairro0_, company1_.id_cidade as id_cidade0_, company1_.cep as cep0_, company1_.ddd_telefone as ddd_tel15_0_, company1_.telefone as telefone0_, company1_.ddd_fax as ddd_fax0_, company1_.fax as fax0_, company1_.cpf_contato as cpf_con19_0_, company1_.nr_banco as nr_banco0_, company1_.agencia as agencia0_, company1_.nr_conta as nr_conta0_, company1_.fg_conta as fg_conta0_, company1_.cnpj_ted as cnpj_ted0_, company1_.cnpj_pai as cnpj_pai0_, company1_.fg_manutencao as fg_manu26_0_, company1_.tp_c