Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_, languageim0_.client_id as client6_11_, languageim0_.deactivation_date as deactiva2_11_, languageim0_.registration_date as registra3_11_, languageim0_.language as language11_, languageim0_.country as country11_ from infra.i18n_language languageim0_ where (languageim0_.client_id=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select distinct domainimpl0_.id as id1_, domainimpl0_.client_id as client5_1_, domainimpl0_.security_engine_class as security2_1_, domainimpl0_.name as name1_, domainimpl0_.description as descript4_1_ from infra.domain domainimpl0_ where (domainimpl0_.client_id=? )and(domainimpl0_.id in(select domainattr1_.domain_id from infra.domain_attribute domainattr1_ where (domainattr1_.client_id=? )and((upper(domainattr1_.name)=‘CAN_AUTO_LOGIN’ )and(upper(domainattr1_.value)=‘TRUE’ ))))
Hibernate: select domainimpl0_.id as id1_, domainimpl0_.client_id as client5_1_, domainimpl0_.security_engine_class as security2_1_, domainimpl0_.name as name1_, domainimpl0_.description as descript4_1_ from infra.domain domainimpl0_ where (domainimpl0_.client_id=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_1_, languageim0_.client_id as client6_11_1_, languageim0_.deactivation_date as deactiva2_11_1_, languageim0_.registration_date as registra3_11_1_, languageim0_.language as language11_1_, languageim0_.country as country11_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.i18n_language languageim0_ left outer join infra.client clientimpl1_ on languageim0_.client_id=clientimpl1_.id where languageim0_.id=?
Hibernate: select domainimpl0_.id as id1_1_, domainimpl0_.client_id as client5_1_1_, domainimpl0_.security_engine_class as security2_1_1_, domainimpl0_.name as name1_1_, domainimpl0_.description as descript4_1_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.domain domainimpl0_ left outer join infra.client clientimpl1_ on domainimpl0_.client_id=clientimpl1_.id where domainimpl0_.id=?
Hibernate: select domainimpl0_.id as id1_1_, domainimpl0_.client_id as client5_1_1_, domainimpl0_.security_engine_class as security2_1_1_, domainimpl0_.name as name1_1_, domainimpl0_.description as descript4_1_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.domain domainimpl0_ left outer join infra.client clientimpl1_ on domainimpl0_.client_id=clientimpl1_.id where domainimpl0_.id=?
Hibernate: select memberimpl0_.id as id3_, memberimpl0_.domain_id as domain8_3_, memberimpl0_.client_id as client9_3_, memberimpl0_.deactivation_date as deactiva2_3_, memberimpl0_.registration_date as registra3_3_, memberimpl0_.login as login3_, memberimpl0_.pwd as pwd3_, memberimpl0_.email as email3_, memberimpl0_.name as name3_ from infra.member memberimpl0_ where (upper(memberimpl0_.login)=? )and(memberimpl0_.domain_id=? )and(memberimpl0_.client_id=? )
Hibernate: select memberimpl0_.id as id3_, memberimpl0_.domain_id as domain8_3_, memberimpl0_.client_id as client9_3_, memberimpl0_.deactivation_date as deactiva2_3_, memberimpl0_.registration_date as registra3_3_, memberimpl0_.login as login3_, memberimpl0_.pwd as pwd3_, memberimpl0_.email as email3_, memberimpl0_.name as name3_ from infra.member memberimpl0_ where (upper(memberimpl0_.login)=? )and(memberimpl0_.domain_id=? )and(memberimpl0_.client_id=? )
Hibernate: select domainimpl0_.id as id1_1_, domainimpl0_.client_id as client5_1_1_, domainimpl0_.security_engine_class as security2_1_1_, domainimpl0_.name as name1_1_, domainimpl0_.description as descript4_1_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.domain domainimpl0_ left outer join infra.client clientimpl1_ on domainimpl0_.client_id=clientimpl1_.id where domainimpl0_.id=?
Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_1_, languageim0_.client_id as client6_11_1_, languageim0_.deactivation_date as deactiva2_11_1_, languageim0_.registration_date as registra3_11_1_, languageim0_.language as language11_1_, languageim0_.country as country11_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.i18n_language languageim0_ left outer join infra.client clientimpl1_ on languageim0_.client_id=clientimpl1_.id where languageim0_.id=?
Hibernate: select memberimpl0_.id as id3_3_, memberimpl0_.domain_id as domain8_3_3_, memberimpl0_.client_id as client9_3_3_, memberimpl0_.deactivation_date as deactiva2_3_3_, memberimpl0_.registration_date as registra3_3_3_, memberimpl0_.login as login3_3_, memberimpl0_.pwd as pwd3_3_, memberimpl0_.email as email3_3_, memberimpl0_.name as name3_3_, domainimpl1_.id as id1_0_, domainimpl1_.client_id as client5_1_0_, domainimpl1_.security_engine_class as security2_1_0_, domainimpl1_.name as name1_0_, domainimpl1_.description as descript4_1_0_, clientimpl2_.id as id9_1_, clientimpl2_.deactivation_date as deactiva2_9_1_, clientimpl2_.registration_date as registra3_9_1_, clientimpl2_.name as name9_1_, clientimpl3_.id as id9_2_, clientimpl3_.deactivation_date as deactiva2_9_2_, clientimpl3_.registration_date as registra3_9_2_, clientimpl3_.name as name9_2_ from infra.member memberimpl0_ inner join infra.domain domainimpl1_ on memberimpl0_.domain_id=domainimpl1_.id left outer join infra.client clientimpl2_ on domainimpl1_.client_id=clientimpl2_.id inner join infra.client clientimpl3_ on memberimpl0_.client_id=clientimpl3_.id where memberimpl0_.id=?
Hibernate: select languageim0_.id as id11_, languageim0_.client_id as client6_11_, languageim0_.deactivation_date as deactiva2_11_, languageim0_.registration_date as registra3_11_, languageim0_.language as language11_, languageim0_.country as country11_ from infra.i18n_language languageim0_ where (languageim0_.client_id=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select memberimpl0_.id as id3_3_, memberimpl0_.domain_id as domain8_3_3_, memberimpl0_.client_id as client9_3_3_, memberimpl0_.deactivation_date as deactiva2_3_3_, memberimpl0_.registration_date as registra3_3_3_, memberimpl0_.login as login3_3_, memberimpl0_.pwd as pwd3_3_, memberimpl0_.email as email3_3_, memberimpl0_.name as name3_3_, domainimpl1_.id as id1_0_, domainimpl1_.client_id as client5_1_0_, domainimpl1_.security_engine_class as security2_1_0_, domainimpl1_.name as name1_0_, domainimpl1_.description as descript4_1_0_, clientimpl2_.id as id9_1_, clientimpl2_.deactivation_date as deactiva2_9_1_, clientimpl2_.registration_date as registra3_9_1_, clientimpl2_.name as name9_1_, clientimpl3_.id as id9_2_, clientimpl3_.deactivation_date as deactiva2_9_2_, clientimpl3_.registration_date as registra3_9_2_, clientimpl3_.name as name9_2_ from infra.member memberimpl0_ inner join infra.domain domainimpl1_ on memberimpl0_.domain_id=domainimpl1_.id left outer join infra.client clientimpl2_ on domainimpl1_.client_id=clientimpl2_.id inner join infra.client clientimpl3_ on memberimpl0_.client_id=clientimpl3_.id where memberimpl0_.id=?
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_1_, languageim0_.client_id as client6_11_1_, languageim0_.deactivation_date as deactiva2_11_1_, languageim0_.registration_date as registra3_11_1_, languageim0_.language as language11_1_, languageim0_.country as country11_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.i18n_language languageim0_ left outer join infra.client clientimpl1_ on languageim0_.client_id=clientimpl1_.id where languageim0_.id=?
Hibernate: select memberimpl0_.id as id3_3_, memberimpl0_.domain_id as domain8_3_3_, memberimpl0_.client_id as client9_3_3_, memberimpl0_.deactivation_date as deactiva2_3_3_, memberimpl0_.registration_date as registra3_3_3_, memberimpl0_.login as login3_3_, memberimpl0_.pwd as pwd3_3_, memberimpl0_.email as email3_3_, memberimpl0_.name as name3_3_, domainimpl1_.id as id1_0_, domainimpl1_.client_id as client5_1_0_, domainimpl1_.security_engine_class as security2_1_0_, domainimpl1_.name as name1_0_, domainimpl1_.description as descript4_1_0_, clientimpl2_.id as id9_1_, clientimpl2_.deactivation_date as deactiva2_9_1_, clientimpl2_.registration_date as registra3_9_1_, clientimpl2_.name as name9_1_, clientimpl3_.id as id9_2_, clientimpl3_.deactivation_date as deactiva2_9_2_, clientimpl3_.registration_date as registra3_9_2_, clientimpl3_.name as name9_2_ from infra.member memberimpl0_ inner join infra.domain domainimpl1_ on memberimpl0_.domain_id=domainimpl1_.id left outer join infra.client clientimpl2_ on domainimpl1_.client_id=clientimpl2_.id inner join infra.client clientimpl3_ on memberimpl0_.client_id=clientimpl3_.id where memberimpl0_.id=?
Hibernate: select languageim0_.id as id11_, languageim0_.client_id as client6_11_, languageim0_.deactivation_date as deactiva2_11_, languageim0_.registration_date as registra3_11_, languageim0_.language as language11_, languageim0_.country as country11_ from infra.i18n_language languageim0_ where (languageim0_.client_id=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select memberimpl0_.id as id3_3_, memberimpl0_.domain_id as domain8_3_3_, memberimpl0_.client_id as client9_3_3_, memberimpl0_.deactivation_date as deactiva2_3_3_, memberimpl0_.registration_date as registra3_3_3_, memberimpl0_.login as login3_3_, memberimpl0_.pwd as pwd3_3_, memberimpl0_.email as email3_3_, memberimpl0_.name as name3_3_, domainimpl1_.id as id1_0_, domainimpl1_.client_id as client5_1_0_, domainimpl1_.security_engine_class as security2_1_0_, domainimpl1_.name as name1_0_, domainimpl1_.description as descript4_1_0_, clientimpl2_.id as id9_1_, clientimpl2_.deactivation_date as deactiva2_9_1_, clientimpl2_.registration_date as registra3_9_1_, clientimpl2_.name as name9_1_, clientimpl3_.id as id9_2_, clientimpl3_.deactivation_date as deactiva2_9_2_, clientimpl3_.registration_date as registra3_9_2_, clientimpl3_.name as name9_2_ from infra.member memberimpl0_ inner join infra.domain domainimpl1_ on memberimpl0_.domain_id=domainimpl1_.id left outer join infra.client clientimpl2_ on domainimpl1_.client_id=clientimpl2_.id inner join infra.client clientimpl3_ on memberimpl0_.client_id=clientimpl3_.id where memberimpl0_.id=?
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_1_, languageim0_.client_id as client6_11_1_, languageim0_.deactivation_date as deactiva2_11_1_, languageim0_.registration_date as registra3_11_1_, languageim0_.language as language11_1_, languageim0_.country as country11_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.i18n_language languageim0_ left outer join infra.client clientimpl1_ on languageim0_.client_id=clientimpl1_.id where languageim0_.id=?
Hibernate: select memberimpl0_.id as id3_3_, memberimpl0_.domain_id as domain8_3_3_, memberimpl0_.client_id as client9_3_3_, memberimpl0_.deactivation_date as deactiva2_3_3_, memberimpl0_.registration_date as registra3_3_3_, memberimpl0_.login as login3_3_, memberimpl0_.pwd as pwd3_3_, memberimpl0_.email as email3_3_, memberimpl0_.name as name3_3_, domainimpl1_.id as id1_0_, domainimpl1_.client_id as client5_1_0_, domainimpl1_.security_engine_class as security2_1_0_, domainimpl1_.name as name1_0_, domainimpl1_.description as descript4_1_0_, clientimpl2_.id as id9_1_, clientimpl2_.deactivation_date as deactiva2_9_1_, clientimpl2_.registration_date as registra3_9_1_, clientimpl2_.name as name9_1_, clientimpl3_.id as id9_2_, clientimpl3_.deactivation_date as deactiva2_9_2_, clientimpl3_.registration_date as registra3_9_2_, clientimpl3_.name as name9_2_ from infra.member memberimpl0_ inner join infra.domain domainimpl1_ on memberimpl0_.domain_id=domainimpl1_.id left outer join infra.client clientimpl2_ on domainimpl1_.client_id=clientimpl2_.id inner join infra.client clientimpl3_ on memberimpl0_.client_id=clientimpl3_.id where memberimpl0_.id=?
Hibernate: select languageim0_.id as id11_, languageim0_.client_id as client6_11_, languageim0_.deactivation_date as deactiva2_11_, languageim0_.registration_date as registra3_11_, languageim0_.language as language11_, languageim0_.country as country11_ from infra.i18n_language languageim0_ where (languageim0_.client_id=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select memberimpl0_.id as id3_3_, memberimpl0_.domain_id as domain8_3_3_, memberimpl0_.client_id as client9_3_3_, memberimpl0_.deactivation_date as deactiva2_3_3_, memberimpl0_.registration_date as registra3_3_3_, memberimpl0_.login as login3_3_, memberimpl0_.pwd as pwd3_3_, memberimpl0_.email as email3_3_, memberimpl0_.name as name3_3_, domainimpl1_.id as id1_0_, domainimpl1_.client_id as client5_1_0_, domainimpl1_.security_engine_class as security2_1_0_, domainimpl1_.name as name1_0_, domainimpl1_.description as descript4_1_0_, clientimpl2_.id as id9_1_, clientimpl2_.deactivation_date as deactiva2_9_1_, clientimpl2_.registration_date as registra3_9_1_, clientimpl2_.name as name9_1_, clientimpl3_.id as id9_2_, clientimpl3_.deactivation_date as deactiva2_9_2_, clientimpl3_.registration_date as registra3_9_2_, clientimpl3_.name as name9_2_ from infra.member memberimpl0_ inner join infra.domain domainimpl1_ on memberimpl0_.domain_id=domainimpl1_.id left outer join infra.client clientimpl2_ on domainimpl1_.client_id=clientimpl2_.id inner join infra.client clientimpl3_ on memberimpl0_.client_id=clientimpl3_.id where memberimpl0_.id=?
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select memberreso0_.permission_type as col_0_0_ from infra.member_resource_permission memberreso0_ inner join infra.application_resource resourceim1_ on memberreso0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on memberreso0_.permission_id=permission3_.id inner join infra.member memberimpl4_ on memberreso0_.member_id=memberimpl4_.id where (memberimpl4_.id=? )and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(memberimpl4_.client_id=? )
Hibernate: select profileres0_.id as col_0_0_ from infra.profile_resource_permission profileres0_ inner join infra.application_resource resourceim1_ on profileres0_.resource_id=resourceim1_.id inner join infra.application applicatio2_ on resourceim1_.application_id=applicatio2_.id inner join infra.permission permission3_ on profileres0_.permission_id=permission3_.id where (profileres0_.profile_id in(select profileimp6_.id from infra.member memberimpl4_, infra.member_profile profiles5_, infra.profile profileimp6_ where memberimpl4_.id=profiles5_.member_id and profiles5_.profile_id=profileimp6_.id and ((memberimpl4_.id=? )and(memberimpl4_.client_id=? ))))and(resourceim1_.name=? )and(permission3_.name=? )and(applicatio2_.name=? )and(profileres0_.permission_type=? )
Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_1_, languageim0_.client_id as client6_11_1_, languageim0_.deactivation_date as deactiva2_11_1_, languageim0_.registration_date as registra3_11_1_, languageim0_.language as language11_1_, languageim0_.country as country11_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.i18n_language languageim0_ left outer join infra.client clientimpl1_ on languageim0_.client_id=clientimpl1_.id where languageim0_.id=?
Hibernate: select urlimpl0_.id as id10_, urlimpl0_.client_id as client3_10_, urlimpl0_.url_address as url2_10_ from infra.client_url urlimpl0_ where (upper(urlimpl0_.url_address)=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?
Hibernate: select languageim0_.id as id11_1_, languageim0_.client_id as client6_11_1_, languageim0_.deactivation_date as deactiva2_11_1_, languageim0_.registration_date as registra3_11_1_, languageim0_.language as language11_1_, languageim0_.country as country11_1_, clientimpl1_.id as id9_0_, clientimpl1_.deactivation_date as deactiva2_9_0_, clientimpl1_.registration_date as registra3_9_0_, clientimpl1_.name as name9_0_ from infra.i18n_language languageim0_ left outer join infra.client clientimpl1_ on languageim0_.client_id=clientimpl1_.id where languageim0_.id=?
Hibernate: select distinct domainimpl0_.id as id1_, domainimpl0_.client_id as client5_1_, domainimpl0_.security_engine_class as security2_1_, domainimpl0_.name as name1_, domainimpl0_.description as descript4_1_ from infra.domain domainimpl0_ where (domainimpl0_.client_id=? )and(domainimpl0_.id in(select domainattr1_.domain_id from infra.domain_attribute domainattr1_ where (domainattr1_.client_id=? )and((upper(domainattr1_.name)=‘CAN_AUTO_LOGIN’ )and(upper(domainattr1_.value)=‘TRUE’ ))))
Hibernate: select domainimpl0_.id as id1_, domainimpl0_.client_id as client5_1_, domainimpl0_.security_engine_class as security2_1_, domainimpl0_.name as name1_, domainimpl0_.description as descript4_1_ from infra.domain domainimpl0_ where (domainimpl0_.client_id=? )
Hibernate: select clientimpl0_.id as id9_0_, clientimpl0_.deactivation_date as deactiva2_9_0_, clientimpl0_.registration_date as registra3_9_0_, clientimpl0_.name as name9_0_ from infra.client clientimpl0_ where clientimpl0_.id=?