Hibernate:
    select
        cardforeig0_.CARD_FOREIGN_ID as CARD_FOREIGN_ID1_21_,
        cardforeig0_.CARD_ID as CARD_ID4_21_,
        cardforeig0_.INTERFACE_ID as INTERFACE_ID5_21_,
        cardforeig0_.KEY_NUMBER as KEY_NUMBER2_21_,
        cardforeig0_.KEY_SOURCE as KEY_SOURCE3_21_
    from
        club.CARD_FOREIGN_IDS cardforeig0_
    where
        (
            cardforeig0_.KEY_NUMBER=?
        )
        AND(
            cardforeig0_.INTERFACE_ID=?
        )
Hibernate:
    select
        card0_.CARD_ID as CARD_ID1_17_0_,
        card0_.IS_ARCHIVED as IS_ARCHIVED2_17_0_,
        card0_.BIRTH_DATE as BIRTH_DATE3_17_0_,
        card0_.CARD_STATUS_ID as CARD_STATUS_ID78_17_0_,
        card0_.CARD_TYPE_ID as CARD_TYPE_ID79_17_0_,
        card0_.CELL_PHONE as CELL_PHONE4_17_0_,
        card0_.CITY as CITY5_17_0_,
        card0_.COMPANY as COMPANY6_17_0_,
        card0_.COUNTRY as COUNTRY7_17_0_,
        card0_.CREATED_DATE as CREATED_DATE8_17_0_,
        card0_.CREATED_PERSON as CREATED_PERSON9_17_0_,
        card0_.EMAIL as EMAIL10_17_0_,
        card0_.FIRST_NAME as FIRST_NAME11_17_0_,
        card0_.GENDER as GENDER12_17_0_,
        card0_.GREETING as GREETING13_17_0_,
        card0_.HEALTH_INFO as HEALTH_INFO14_17_0_,
        card0_.JOB_TITLE as JOB_TITLE15_17_0_,
        card0_.LANG as LANG16_17_0_,
        card0_.LAST_NAME as LAST_NAME17_17_0_,
        card0_.LAST_USED_RVC_ID as LAST_USED_RVC_ID18_17_0_,
        card0_.MAGSTRIPE as MAGSTRIPE19_17_0_,
        card0_.MAILING_OPT as MAILING_OPT20_17_0_,
        card0_.MASTER_CARD_ID as MASTER_CARD_ID80_17_0_,
        card0_.MAX_CHILDREN as MAX_CHILDREN21_17_0_,
        card0_.MLST_SYNC_STATUS as MLST_SYNC_STATUS22_17_0_,
        card0_.NOTES as NOTES23_17_0_,
        card0_.PASSPORT as PASSPORT24_17_0_,
        card0_.PASSWORD as PASSWORD25_17_0_,
        card0_.PHONE as PHONE26_17_0_,
        card0_.PROFILE_TYPE as PROFILE_TYPE27_17_0_,
        card0_.RATE as RATE28_17_0_,
        card0_.SECOND_NAME as SECOND_NAME29_17_0_,
        card0_.SOURCE as SOURCE30_17_0_,
        card0_.STREET_ADDRESS as STREET_ADDRESS31_17_0_,
        card0_.TITLE as TITLE32_17_0_,
        card0_.UDFD1 as UDFD33_17_0_,
        card0_.UDFD10 as UDFD34_17_0_,
        card0_.UDFD2 as UDFD35_17_0_,
        card0_.UDFD3 as UDFD36_17_0_,
        card0_.UDFD4 as UDFD37_17_0_,
        card0_.UDFD5 as UDFD38_17_0_,
        card0_.UDFD6 as UDFD39_17_0_,
        card0_.UDFD7 as UDFD40_17_0_,
        card0_.UDFD8 as UDFD41_17_0_,
        card0_.UDFD9 as UDFD42_17_0_,
        card0_.UDFN1 as UDFN43_17_0_,
        card0_.UDFN10 as UDFN44_17_0_,
        card0_.UDFN2 as UDFN45_17_0_,
        card0_.UDFN3 as UDFN46_17_0_,
        card0_.UDFN4 as UDFN47_17_0_,
        card0_.UDFN5 as UDFN48_17_0_,
        card0_.UDFN6 as UDFN49_17_0_,
        card0_.UDFN7 as UDFN50_17_0_,
        card0_.UDFN8 as UDFN51_17_0_,
        card0_.UDFN9 as UDFN52_17_0_,
        card0_.UDFS1 as UDFS53_17_0_,
        card0_.UDFS10 as UDFS54_17_0_,
        card0_.UDFS11 as UDFS55_17_0_,
        card0_.UDFS12 as UDFS56_17_0_,
        card0_.UDFS13 as UDFS57_17_0_,
        card0_.UDFS14 as UDFS58_17_0_,
        card0_.UDFS15 as UDFS59_17_0_,
        card0_.UDFS16 as UDFS60_17_0_,
        card0_.UDFS17 as UDFS61_17_0_,
        card0_.UDFS18 as UDFS62_17_0_,
        card0_.UDFS19 as UDFS63_17_0_,
        card0_.UDFS2 as UDFS64_17_0_,
        card0_.UDFS20 as UDFS65_17_0_,
        card0_.UDFS3 as UDFS66_17_0_,
        card0_.UDFS4 as UDFS67_17_0_,
        card0_.UDFS5 as UDFS68_17_0_,
        card0_.UDFS6 as UDFS69_17_0_,
        card0_.UDFS7 as UDFS70_17_0_,
        card0_.UDFS8 as UDFS71_17_0_,
        card0_.UDFS9 as UDFS72_17_0_,
        card0_.UPDATE_DATE as UPDATE_DATE73_17_0_,
        card0_.UPDATE_PERSON as UPDATE_PERSON74_17_0_,
        card0_.VALID_TILL as VALID_TILL75_17_0_,
        card0_.VIP_STATUS as VIP_STATUS76_17_0_,
        card0_.ZIP_CODE as ZIP_CODE77_17_0_
    from
        club.CARDS card0_
    where
        card0_.CARD_ID=?
Hibernate:
    select
        menuitem0_.MI_ID as MI_ID1_71_,
        menuitem0_.ACTIVE as ACTIVE2_71_,
        menuitem0_.BARCODE as BARCODE3_71_,
        menuitem0_.BASE_INV_UNIT_ID as BASE_INV_UNIT_ID30_71_,
        menuitem0_.BOOK_STEP as BOOK_STEP4_71_,
        menuitem0_.CODE as CODE5_71_,
        menuitem0_.COLOR as COLOR6_71_,
        menuitem0_.COMMISSION_GRP_ID as COMMISSION_GRP_ID31_71_,
        menuitem0_.COMPLEXITY as COMPLEXITY7_71_,
        menuitem0_.COST as COST8_71_,
        menuitem0_.DESCRIPTION as DESCRIPTION9_71_,
        menuitem0_.DESCRIPTION_STRING_ID as DESCRIPTION_STRIN10_71_,
        menuitem0_.DISCOUNT_RULESET_ID as DISCOUNT_RULESET_32_71_,
        menuitem0_.EXTN_GROUP as EXTN_GROUP11_71_,
        menuitem0_.FGRP as FGRP33_71_,
        menuitem0_.FAVOURITES_ID as FAVOURITES_ID34_71_,
        menuitem0_.HIERARCHY_ID as HIERARCHY_ID35_71_,
        menuitem0_.INITIAL_STATUS as INITIAL_STATUS12_71_,
        menuitem0_.MAX_PARTICIPANT as MAX_PARTICIPANT13_71_,
        menuitem0_.MAX_PARTICIPANT_WEB as MAX_PARTICIPANT_W14_71_,
        menuitem0_.MI_TYPE as MI_TYPE15_71_,
        menuitem0_.NAME1 as NAME16_71_,
        menuitem0_.NAME2 as NAME17_71_,
        menuitem0_.NAME_STRING_ID as NAME_STRING_ID18_71_,
        menuitem0_.OPTIONS as OPTIONS19_71_,
        menuitem0_.PMS_CODE as PMS_CODE20_71_,
        menuitem0_.RETURN_CHARGE as RETURN_CHARGE21_71_,
        menuitem0_.RSRV_COUNT as RSRV_COUNT22_71_,
        menuitem0_.SI as SI36_71_,
        menuitem0_.SPA_CANCEL_CAT_ID as SPA_CANCEL_CAT_ID37_71_,
        menuitem0_.SUBSCR_ACTIVE_MI as SUBSCR_ACTIVE_MI23_71_,
        menuitem0_.SUBSCR_FROZEN_MI as SUBSCR_FROZEN_MI24_71_,
        menuitem0_.SUBSCR_PERIOD_COUNT as SUBSCR_PERIOD_COU25_71_,
        menuitem0_.SUBSCR_PERIOD_TYPE as SUBSCR_PERIOD_TYP26_71_,
        menuitem0_.TAX_CLASS as TAX_CLASS38_71_,
        menuitem0_.TREAT_CLEANOUT_TIME as TREAT_CLEANOUT_TI27_71_,
        menuitem0_.TREAT_DURATION as TREAT_DURATION28_71_,
        menuitem0_.TREAT_PREP_TIME as TREAT_PREP_TIME29_71_,
        menuitem0_.VOUCHER_CAMPAIGN_ID as VOUCHER_CAMPAIGN_39_71_,
        menuitem0_.WEBGRP as WEBGRP40_71_,
        UPPER(menuitem0_.CODE || ' ' || menuitem0_.NAME1) as formula2_,
        UPPER(menuitem0_.NAME1 || ' (' || menuitem0_.CODE || ')' ) as formula3_
    from
        club.MENU_ITEMS menuitem0_
    where
        (
            menuitem0_.PMS_CODE=?
        )
Hibernate:
    select
        this_.SI_ID as SI_ID1_75_0_,
        this_.DEP_CODE as DEP_CODE2_75_0_,
        this_.NAME as NAME3_75_0_
    from
        club.MENU_SI this_
10.05.16 18:43:44:361 - INFO - FidelioXml - >> Fidelio XML: <fidelio Version="1.0.0"><request ID="2192571" UserName="s" Password="s" Vendor="Suite8"><command><post /></command></request></fidelio>
10.05.16 18:43:44:951 - INFO - FidelioXml - << Fidelio XML: <?xml version="1.0" encoding="utf-8" ?><fidelio Version="1.0.0"><response ID="2192571" Status="IR"  Message="This command type is not supported"/></fidelio>
Hibernate:
    select
        jrndbsync0_.ID as ID1_65_,
        jrndbsync0_.SITE_ID as SITE_ID4_65_,
        jrndbsync0_.SYNC_END as SYNC_END2_65_,
        jrndbsync0_.SYNC_START as SYNC_START3_65_
    from
        club.JRN_DBSYNC jrndbsync0_
    where
        (
            SYNC_END is null
        )