After logging in with an OpenID 24 queries are generated for each call. As metrics needs the user ffor each request this means every page now has at least 24 queries. For pages that need to get the current user more times the number of queries is multiplied.

Queries issued:
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select user0_.id as id81_, user0_1_.version as version81_, user0_1_.gateway_id as gateway3_81_, user0_1_.date_created as date4_81_, user0_.firstName as firstName84_, user0_.middleName as middleName84_, user0_.lastName as lastName84_, user0_.email as email84_, user0_.userName as userName84_, user0_.password as password84_, user0_.loginType as loginType84_, user0_.organization as organiza9_84_, user0_.organization_type as organiz10_84_, user0_.city as city84_, user0_.state as state84_, user0_.country as country84_, user0_.openid as openid84_, user0_.dn as dn84_ from security.user user0_ inner join security.principal user0_1_ on user0_.id=user0_1_.id where user0_.openid=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select membership0_.user_id as user3_1_, membership0_.id as id1_, membership0_.id as id79_0_, membership0_.version as version79_0_, membership0_.user_id as user3_79_0_, membership0_.group_id as group4_79_0_, membership0_.role_id as role5_79_0_, membership0_.status_id as status6_79_0_ from security.membership membership0_ where membership0_.user_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select workspaces0_.principal_id as principal4_3_, workspaces0_.id as id3_, workspaces0_.gateway_id as gateway3_3_, workspaces0_.id as id92_2_, workspaces0_.version as version92_2_, workspaces0_.gateway_id as gateway3_92_2_, workspaces0_.principal_id as principal4_92_2_, workspaces0_.next_request_number as next5_92_2_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, searchcrit2_.id as id89_1_, searchcrit2_.version as version89_1_, searchcrit2_.workspace_id as workspace3_89_1_, searchcrit2_.name as name89_1_, searchcrit2_.date_inserted as date5_89_1_, searchcrit2_.product as product89_1_ from workspace.workspace workspaces0_ left outer join metadata.gateway gatewayimp1_ on workspaces0_.gateway_id=gatewayimp1_.id left outer join workspace.search_criteria searchcrit2_ on workspaces0_.id=searchcrit2_.workspace_id where workspaces0_.principal_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select operations0_.role_id as role1_0_, operations0_.operation_id as operation2_0_ from security.role_operation_xref operations0_ where operations0_.role_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select role0_.id as id82_0_, role0_.name as name82_0_, role0_.description as descript3_82_0_ from security.role role0_ where role0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select operations0_.role_id as role1_0_, operations0_.operation_id as operation2_0_ from security.role_operation_xref operations0_ where operations0_.role_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select role0_.id as id82_0_, role0_.name as name82_0_, role0_.description as descript3_82_0_ from security.role role0_ where role0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select operations0_.role_id as role1_0_, operations0_.operation_id as operation2_0_ from security.role_operation_xref operations0_ where operations0_.role_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select operations0_.role_id as role1_0_, operations0_.operation_id as operation2_0_ from security.role_operation_xref operations0_ where operations0_.role_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select group0_.id as id81_4_, group0_1_.version as version81_4_, group0_1_.gateway_id as gateway3_81_4_, group0_1_.date_created as date4_81_4_, group0_.name as name93_4_, group0_.description as descript3_93_4_, group0_.visible as visible93_4_, group0_.automatic_approval as automatic5_93_4_, gatewayimp1_.id as id0_0_, gatewayimp1_.version as version0_0_, gatewayimp1_.name as name0_0_, gatewayimp1_.description as descript4_0_0_, gatewayimp1_.system_message as system5_0_0_, gatewayimp1_.base_url as base6_0_0_, gatewayimp1_.base_secure_url as base7_0_0_, gatewayimp1_.attributes_service_url as attributes8_0_0_, gatewayimp1_.oai_repository_url as oai9_0_0_, gatewayimp1_.project_view_handler_name as project10_0_0_, gatewayimp1_.collection_view_handler_name as collection11_0_0_, gatewayimp1_.identity as identity0_0_, workspaces2_.principal_id as principal4_6_, workspaces2_.id as id6_, workspaces2_.gateway_id as gateway3_6_, workspaces2_.id as id92_1_, workspaces2_.version as version92_1_, workspaces2_.gateway_id as gateway3_92_1_, workspaces2_.principal_id as principal4_92_1_, workspaces2_.next_request_number as next5_92_1_, gatewayimp3_.id as id0_2_, gatewayimp3_.version as version0_2_, gatewayimp3_.name as name0_2_, gatewayimp3_.description as descript4_0_2_, gatewayimp3_.system_message as system5_0_2_, gatewayimp3_.base_url as base6_0_2_, gatewayimp3_.base_secure_url as base7_0_2_, gatewayimp3_.attributes_service_url as attributes8_0_2_, gatewayimp3_.oai_repository_url as oai9_0_2_, gatewayimp3_.project_view_handler_name as project10_0_2_, gatewayimp3_.collection_view_handler_name as collection11_0_2_, gatewayimp3_.identity as identity0_2_, searchcrit4_.id as id89_3_, searchcrit4_.version as version89_3_, searchcrit4_.workspace_id as workspace3_89_3_, searchcrit4_.name as name89_3_, searchcrit4_.date_inserted as date5_89_3_, searchcrit4_.product as product89_3_ from security.group group0_ inner join security.principal group0_1_ on group0_.id=group0_1_.id left outer join metadata.gateway gatewayimp1_ on group0_1_.gateway_id=gatewayimp1_.id left outer join workspace.workspace workspaces2_ on group0_.id=workspaces2_.principal_id left outer join metadata.gateway gatewayimp3_ on workspaces2_.gateway_id=gatewayimp3_.id left outer join workspace.search_criteria searchcrit4_ on workspaces2_.id=searchcrit4_.workspace_id where group0_.id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select defaultrol0_.group_id as group1_1_, defaultrol0_.role_id as role2_1_, role1_.id as id82_0_, role1_.name as name82_0_, role1_.description as descript3_82_0_ from security.group_default_role defaultrol0_ left outer join security.role role1_ on defaultrol0_.role_id=role1_.id where defaultrol0_.group_id=?
[DEBUG] org.hibernate.jdbc.util.SQLStatementLogger: select user0_.id as id81_, user0_1_.version as version81_, user0_1_.gateway_id as gateway3_81_, user0_1_.date_created as date4_81_, user0_.firstName as firstName84_, user0_.middleName as middleName84_, user0_.lastName as lastName84_, user0_.email as email84_, user0_.userName as userName84_, user0_.password as password84_, user0_.loginType as loginType84_, user0_.organization as organiza9_84_, user0_.organization_type as organiz10_84_, user0_.city as city84_, user0_.state as state84_, user0_.country as country84_, user0_.openid as openid84_, user0_.dn as dn84_ from security.user user0_ inner join security.principal user0_1_ on user0_.id=user0_1_.id where user0_.openid=?