Symfony Profiler

SELECT
  t0.al_id AS al_id_1,
  t0.al_restaurant_name AS al_restaurant_name_2,
  t0.al_date_created AS al_date_created_3,
  t0.al_license_status AS al_license_status_4,
  t0.al_license_username AS al_license_username_5,
  t0.al_contac_name AS al_contac_name_6,
  t0.al_license_email AS al_license_email_7,
  t0.al_addres AS al_addres_8,
  t0.al_suit_po_box AS al_suit_po_box_9,
  t0.al_longitude AS al_longitude_10,
  t0.al_latitude AS al_latitude_11,
  t0.al_phone_number AS al_phone_number_12,
  t0.al_license_key AS al_license_key_13,
  t0.al_has_android AS al_has_android_14,
  t0.al_android_vname AS al_android_vname_15,
  t0.al_device_uid AS al_device_uid_16,
  t0.al_is_callcenter AS al_is_callcenter_17,
  t0.al_pushy_key AS al_pushy_key_18,
  t0.al_gcm_key AS al_gcm_key_19,
  t0.al_is_testing AS al_is_testing_20,
  t0.al_is_demo AS al_is_demo_21,
  t0.al_android_ip AS al_android_ip_22,
  t0.al_times_checked_ip AS al_times_checked_ip_23,
  t0.al_apk_install_code AS al_apk_install_code_24,
  t0.al_has_loged_omt AS al_has_loged_omt_25,
  t0.al_type_test_license AS al_type_test_license_26,
  t0.auth_seed AS auth_seed_27,
  t0.is_plus_license AS is_plus_license_28,
  t0.al_consecutive_android_drying AS al_consecutive_android_drying_29,
  t0.al_last_s3_dbupload AS al_last_s3_dbupload_30,
  t0.al_last_auto_cleanse_date AS al_last_auto_cleanse_date_31,
  t0.al_last_duplicated_invoice_check AS al_last_duplicated_invoice_check_32,
  t0.al_last_timeclock_out_check AS al_last_timeclock_out_check_33,
  t0.al_last_device_expiration_check AS al_last_device_expiration_check_34,
  t0.al_zipcodes_are_needed AS al_zipcodes_are_needed_35,
  t0.has_level_zero AS has_level_zero_36,
  t0.al_level_zero_percentage AS al_level_zero_percentage_37,
  t0.al_has_cash_discount AS al_has_cash_discount_38,
  t0.al_cash_discount_percentage AS al_cash_discount_percentage_39,
  t0.al_level_zero_gateway_percentage AS al_level_zero_gateway_percentage_40,
  t0.omt_sync AS omt_sync_41,
  t0.al_android_database_size AS al_android_database_size_42,
  t0.al_is_level_light AS al_is_level_light_43,
  t0.al_levellight_user AS al_levellight_user_44,
  t0.al_last_s3_web_dbupload AS al_last_s3_web_dbupload_45,
  t0.al_last_logued_device_kind AS al_last_logued_device_kind_46,
  t0.al_service_prices_already_run AS al_service_prices_already_run_47,
  t0.al_nonsynced_brandservice AS al_nonsynced_brandservice_48,
  t0.al_lastCleanseLeftDays AS al_lastCleanseLeftDays_49,
  t0.al_registaction_already_cleaned AS al_registaction_already_cleaned_50,
  t0.al_updated_date AS al_updated_date_51,
  t0.al_consecutive_android_drying_second_stage AS al_consecutive_android_drying_second_stage_52,
  t0.al_last_login_was_ok AS al_last_login_was_ok_53,
  t0.al_last_login_date AS al_last_login_date_54,
  t0.al_last_validated_login_date AS al_last_validated_login_date_55,
  t0.al_last_cleaning_of_licensor_database AS al_last_cleaning_of_licensor_database_56,
  t0.al_schedule_menu_checked AS al_schedule_menu_checked_57,
  t0.al_active_zipcodes AS al_active_zipcodes_58,
  t0.al_time_zone_restaurant AS al_time_zone_restaurant_59,
  t0.al_checked_delete_notify AS al_checked_delete_notify_60,
  t0.al_checked_scanned_dir AS al_checked_scanned_dir_61,
  t0.al_copy_menu_of_restaurant AS al_copy_menu_of_restaurant_62,
  t0.al_menu_copy_done AS al_menu_copy_done_63,
  t0.al_is_franquise AS al_is_franquise_64,
  t0.al_login_type AS al_login_type_65,
  t0.al_public_address AS al_public_address_66,
  t0.al_consecutive_record_checked AS al_consecutive_record_checked_67,
  t0.al_single_menu_sizes_checked AS al_single_menu_sizes_checked_68,
  t0.al_user_property_and_roles_checked AS al_user_property_and_roles_checked_69,
  t0.al_sync_record_checked AS al_sync_record_checked_70,
  t0.al_lic_parasite AS al_lic_parasite_71,
  t0.al_licensor_cleanse_checked AS al_licensor_cleanse_checked_72,
  t0.al_last_resync_cleanse_checked AS al_last_resync_cleanse_checked_73,
  t0.al_send_allowed_autocleanse AS al_send_allowed_autocleanse_74,
  t0.al_date_created_cleaning_configuration AS al_date_created_cleaning_configuration_75,
  t0.al_record_quantity_for_cleaning AS al_record_quantity_for_cleaning_76,
  t0.al_duplicated_regist_action_checking AS al_duplicated_regist_action_checking_77,
  t0.al_duplicated_regist_action_free AS al_duplicated_regist_action_free_78,
  t0.al_duplicated_registaction_check AS al_duplicated_registaction_check_79,
  t0.al_last_update_of_database_size AS al_last_update_of_database_size_80,
  t0.al_consecutive_android_drying_third_stage AS al_consecutive_android_drying_third_stage_81,
  t0.al_last_quantity_cleanse_update AS al_last_quantity_cleanse_update_82,
  t0.al_locked_by_infinite_sync AS al_locked_by_infinite_sync_83,
  t0.al_number_syncdata_records AS al_number_syncdata_records_84,
  t0.conf_status_stock AS conf_status_stock_85,
  t0.default_customer_checked AS default_customer_checked_86,
  t0.no_data_file_flag AS no_data_file_flag_87,
  t0.payment_gateway AS payment_gateway_88,
  t0.time_to_next_epx_batch AS time_to_next_epx_batch_89,
  t0.aws_push_endpoint AS aws_push_endpoint_90,
  t0.aws_topic_arn AS aws_topic_arn_91,
  t0.aws_subscription_arn AS aws_subscription_arn_92,
  t0.aws_device_token AS aws_device_token_93,
  t0.al_itemized_card_price AS al_itemized_card_price_94,
  t0.al_missmatch_invoice_check_running AS al_missmatch_invoice_check_running_95,
  t0.mismmatch_invoices_checked_until AS mismmatch_invoices_checked_until_96,
  t0.checked_prices_by_levelzero_status_date AS checked_prices_by_levelzero_status_date_97,
  t0.checked_prices_by_levelzero_status AS checked_prices_by_levelzero_status_98,
  t0.pusher_own_verification_token AS pusher_own_verification_token_99,
  t0.pusher_verified AS pusher_verified_100,
  t0.ws_resource_id AS ws_resource_id_101,
  t0.ws_resource_id_verified AS ws_resource_id_verified_102,
  t0.cloud_package_name AS cloud_package_name_103,
  t0.whitelabel_package_name AS whitelabel_package_name_104,
  t0.al_nonprocedent_registaction_check AS al_nonprocedent_registaction_check_105,
  t0.al_last_nonprocedent_cleanse_update AS al_last_nonprocedent_cleanse_update_106,
  t0.al_last_cleaned_nonprocedent_registaction AS al_last_cleaned_nonprocedent_registaction_107,
  t0.al_database_update_date AS al_database_update_date_108,
  t0.al_place_id AS al_place_id_109,
  t0.al_owner_status AS al_owner_status_110,
  t0.dbugflag_forceinfiniteloop AS dbugflag_forceinfiniteloop_111,
  t0.fix_needs_one_updaown_sync AS fix_needs_one_updaown_sync_112,
  t0.al_captive_portal_status AS al_captive_portal_status_113,
  t0.omada_controller_id AS omada_controller_id_114,
  t0.operator_name AS operator_name_115,
  t0.operator_pass AS operator_pass_116,
  t0.portal_redirection_url AS portal_redirection_url_117,
  t0.allowed_navigation_time AS allowed_navigation_time_118,
  t0.omada_port AS omada_port_119,
  t0.in_house_delivery_status AS in_house_delivery_status_120,
  t0.al_date_paid AS al_date_paid_121,
  t0.al_date_unpaid AS al_date_unpaid_122,
  t0.al_last_daterelease AS al_last_daterelease_123,
  t0.al_giftcard_status AS al_giftcard_status_124,
  t0.al_has_active_caller_id AS al_has_active_caller_id_125,
  t0.al_type_price_discount AS al_type_price_discount_126,
  t0.al_last_execute_stock_command AS al_last_execute_stock_command_127,
  t0.al_tax_exempt AS al_tax_exempt_128,
  t0.al_user_creator_id AS al_user_creator_id_129,
  t0.al_account_license_id AS al_account_license_id_130,
  t0.al_zip_code_id AS al_zip_code_id_131,
  t0.al_city_id AS al_city_id_132,
  t0.al_company_id AS al_company_id_133
FROM
  account_license t0
WHERE
  t0.al_license_username IN (?)

SELECT t0.al_id AS al_id_1, t0.al_restaurant_name AS al_restaurant_name_2, t0.al_date_created AS al_date_created_3, t0.al_license_status AS al_license_status_4, t0.al_license_username AS al_license_username_5, t0.al_contac_name AS al_contac_name_6, t0.al_license_email AS al_license_email_7, t0.al_addres AS al_addres_8, t0.al_suit_po_box AS al_suit_po_box_9, t0.al_longitude AS al_longitude_10, t0.al_latitude AS al_latitude_11, t0.al_phone_number AS al_phone_number_12, t0.al_license_key AS al_license_key_13, t0.al_has_android AS al_has_android_14, t0.al_android_vname AS al_android_vname_15, t0.al_device_uid AS al_device_uid_16, t0.al_is_callcenter AS al_is_callcenter_17, t0.al_pushy_key AS al_pushy_key_18, t0.al_gcm_key AS al_gcm_key_19, t0.al_is_testing AS al_is_testing_20, t0.al_is_demo AS al_is_demo_21, t0.al_android_ip AS al_android_ip_22, t0.al_times_checked_ip AS al_times_checked_ip_23, t0.al_apk_install_code AS al_apk_install_code_24, t0.al_has_loged_omt AS al_has_loged_omt_25, t0.al_type_test_license AS al_type_test_license_26, t0.auth_seed AS auth_seed_27, t0.is_plus_license AS is_plus_license_28, t0.al_consecutive_android_drying AS al_consecutive_android_drying_29, t0.al_last_s3_dbupload AS al_last_s3_dbupload_30, t0.al_last_auto_cleanse_date AS al_last_auto_cleanse_date_31, t0.al_last_duplicated_invoice_check AS al_last_duplicated_invoice_check_32, t0.al_last_timeclock_out_check AS al_last_timeclock_out_check_33, t0.al_last_device_expiration_check AS al_last_device_expiration_check_34, t0.al_zipcodes_are_needed AS al_zipcodes_are_needed_35, t0.has_level_zero AS has_level_zero_36, t0.al_level_zero_percentage AS al_level_zero_percentage_37, t0.al_has_cash_discount AS al_has_cash_discount_38, t0.al_cash_discount_percentage AS al_cash_discount_percentage_39, t0.al_level_zero_gateway_percentage AS al_level_zero_gateway_percentage_40, t0.omt_sync AS omt_sync_41, t0.al_android_database_size AS al_android_database_size_42, t0.al_is_level_light AS al_is_level_light_43, t0.al_levellight_user AS al_levellight_user_44, t0.al_last_s3_web_dbupload AS al_last_s3_web_dbupload_45, t0.al_last_logued_device_kind AS al_last_logued_device_kind_46, t0.al_service_prices_already_run AS al_service_prices_already_run_47, t0.al_nonsynced_brandservice AS al_nonsynced_brandservice_48, t0.al_lastCleanseLeftDays AS al_lastCleanseLeftDays_49, t0.al_registaction_already_cleaned AS al_registaction_already_cleaned_50, t0.al_updated_date AS al_updated_date_51, t0.al_consecutive_android_drying_second_stage AS al_consecutive_android_drying_second_stage_52, t0.al_last_login_was_ok AS al_last_login_was_ok_53, t0.al_last_login_date AS al_last_login_date_54, t0.al_last_validated_login_date AS al_last_validated_login_date_55, t0.al_last_cleaning_of_licensor_database AS al_last_cleaning_of_licensor_database_56, t0.al_schedule_menu_checked AS al_schedule_menu_checked_57, t0.al_active_zipcodes AS al_active_zipcodes_58, t0.al_time_zone_restaurant AS al_time_zone_restaurant_59, t0.al_checked_delete_notify AS al_checked_delete_notify_60, t0.al_checked_scanned_dir AS al_checked_scanned_dir_61, t0.al_copy_menu_of_restaurant AS al_copy_menu_of_restaurant_62, t0.al_menu_copy_done AS al_menu_copy_done_63, t0.al_is_franquise AS al_is_franquise_64, t0.al_login_type AS al_login_type_65, t0.al_public_address AS al_public_address_66, t0.al_consecutive_record_checked AS al_consecutive_record_checked_67, t0.al_single_menu_sizes_checked AS al_single_menu_sizes_checked_68, t0.al_user_property_and_roles_checked AS al_user_property_and_roles_checked_69, t0.al_sync_record_checked AS al_sync_record_checked_70, t0.al_lic_parasite AS al_lic_parasite_71, t0.al_licensor_cleanse_checked AS al_licensor_cleanse_checked_72, t0.al_last_resync_cleanse_checked AS al_last_resync_cleanse_checked_73, t0.al_send_allowed_autocleanse AS al_send_allowed_autocleanse_74, t0.al_date_created_cleaning_configuration AS al_date_created_cleaning_configuration_75, t0.al_record_quantity_for_cleaning AS al_record_quantity_for_cleaning_76, t0.al_duplicated_regist_action_checking AS al_duplicated_regist_action_checking_77, t0.al_duplicated_regist_action_free AS al_duplicated_regist_action_free_78, t0.al_duplicated_registaction_check AS al_duplicated_registaction_check_79, t0.al_last_update_of_database_size AS al_last_update_of_database_size_80, t0.al_consecutive_android_drying_third_stage AS al_consecutive_android_drying_third_stage_81, t0.al_last_quantity_cleanse_update AS al_last_quantity_cleanse_update_82, t0.al_locked_by_infinite_sync AS al_locked_by_infinite_sync_83, t0.al_number_syncdata_records AS al_number_syncdata_records_84, t0.conf_status_stock AS conf_status_stock_85, t0.default_customer_checked AS default_customer_checked_86, t0.no_data_file_flag AS no_data_file_flag_87, t0.payment_gateway AS payment_gateway_88, t0.time_to_next_epx_batch AS time_to_next_epx_batch_89, t0.aws_push_endpoint AS aws_push_endpoint_90, t0.aws_topic_arn AS aws_topic_arn_91, t0.aws_subscription_arn AS aws_subscription_arn_92, t0.aws_device_token AS aws_device_token_93, t0.al_itemized_card_price AS al_itemized_card_price_94, t0.al_missmatch_invoice_check_running AS al_missmatch_invoice_check_running_95, t0.mismmatch_invoices_checked_until AS mismmatch_invoices_checked_until_96, t0.checked_prices_by_levelzero_status_date AS checked_prices_by_levelzero_status_date_97, t0.checked_prices_by_levelzero_status AS checked_prices_by_levelzero_status_98, t0.pusher_own_verification_token AS pusher_own_verification_token_99, t0.pusher_verified AS pusher_verified_100, t0.ws_resource_id AS ws_resource_id_101, t0.ws_resource_id_verified AS ws_resource_id_verified_102, t0.cloud_package_name AS cloud_package_name_103, t0.whitelabel_package_name AS whitelabel_package_name_104, t0.al_nonprocedent_registaction_check AS al_nonprocedent_registaction_check_105, t0.al_last_nonprocedent_cleanse_update AS al_last_nonprocedent_cleanse_update_106, t0.al_last_cleaned_nonprocedent_registaction AS al_last_cleaned_nonprocedent_registaction_107, t0.al_database_update_date AS al_database_update_date_108, t0.al_place_id AS al_place_id_109, t0.al_owner_status AS al_owner_status_110, t0.dbugflag_forceinfiniteloop AS dbugflag_forceinfiniteloop_111, t0.fix_needs_one_updaown_sync AS fix_needs_one_updaown_sync_112, t0.al_captive_portal_status AS al_captive_portal_status_113, t0.omada_controller_id AS omada_controller_id_114, t0.operator_name AS operator_name_115, t0.operator_pass AS operator_pass_116, t0.portal_redirection_url AS portal_redirection_url_117, t0.allowed_navigation_time AS allowed_navigation_time_118, t0.omada_port AS omada_port_119, t0.in_house_delivery_status AS in_house_delivery_status_120, t0.al_date_paid AS al_date_paid_121, t0.al_date_unpaid AS al_date_unpaid_122, t0.al_last_daterelease AS al_last_daterelease_123, t0.al_giftcard_status AS al_giftcard_status_124, t0.al_has_active_caller_id AS al_has_active_caller_id_125, t0.al_type_price_discount AS al_type_price_discount_126, t0.al_last_execute_stock_command AS al_last_execute_stock_command_127, t0.al_tax_exempt AS al_tax_exempt_128, t0.al_user_creator_id AS al_user_creator_id_129, t0.al_account_license_id AS al_account_license_id_130, t0.al_zip_code_id AS al_zip_code_id_131, t0.al_city_id AS al_city_id_132, t0.al_company_id AS al_company_id_133 FROM account_license t0 WHERE t0.al_license_username IN ('potheads_1221');

SELECT
  t0.ac_id AS ac_id_1,
  t0.ac_name AS ac_name_2,
  t0.ac_legal_name AS ac_legal_name_3,
  t0.ac_nick_name AS ac_nick_name_4,
  t0.ac_phone_number AS ac_phone_number_5,
  t0.ac_email AS ac_email_6,
  t0.ac_contact_name AS ac_contact_name_7,
  t0.ac_date_created AS ac_date_created_8,
  t0.ac_suit_po_box AS ac_suit_po_box_9,
  t0.ac_address AS ac_address_10,
  t0.ac_address_public AS ac_address_public_11,
  t0.ac_deleted AS ac_deleted_12,
  t0.omt_sync AS omt_sync_13,
  t0.ac_ein_number AS ac_ein_number_14,
  t0.ac_suite AS ac_suite_15,
  t0.ac_number_locations AS ac_number_locations_16,
  t0.ac_internal_notes AS ac_internal_notes_17,
  t0.ac_corporate_type_business AS ac_corporate_type_business_18,
  t0.ac_is_lead_account AS ac_is_lead_account_19,
  t0.ac_account_quote AS ac_account_quote_20,
  t0.ac_is_testing AS ac_is_testing_21,
  t0.ac_user AS ac_user_22,
  t0.ac_city_id AS ac_city_id_23,
  t0.ac_zip_code_id AS ac_zip_code_id_24,
  t0.company AS company_25
FROM
  account t0
WHERE
  t0.ac_id = ?

SELECT t0.ac_id AS ac_id_1, t0.ac_name AS ac_name_2, t0.ac_legal_name AS ac_legal_name_3, t0.ac_nick_name AS ac_nick_name_4, t0.ac_phone_number AS ac_phone_number_5, t0.ac_email AS ac_email_6, t0.ac_contact_name AS ac_contact_name_7, t0.ac_date_created AS ac_date_created_8, t0.ac_suit_po_box AS ac_suit_po_box_9, t0.ac_address AS ac_address_10, t0.ac_address_public AS ac_address_public_11, t0.ac_deleted AS ac_deleted_12, t0.omt_sync AS omt_sync_13, t0.ac_ein_number AS ac_ein_number_14, t0.ac_suite AS ac_suite_15, t0.ac_number_locations AS ac_number_locations_16, t0.ac_internal_notes AS ac_internal_notes_17, t0.ac_corporate_type_business AS ac_corporate_type_business_18, t0.ac_is_lead_account AS ac_is_lead_account_19, t0.ac_account_quote AS ac_account_quote_20, t0.ac_is_testing AS ac_is_testing_21, t0.ac_user AS ac_user_22, t0.ac_city_id AS ac_city_id_23, t0.ac_zip_code_id AS ac_zip_code_id_24, t0.company AS company_25 FROM account t0 WHERE t0.ac_id = 507;

SELECT
  t0.oc_id AS oc_id_1,
  t0.oc_name AS oc_name_2,
  t0.oc_last_name AS oc_last_name_3,
  t0.oc_email AS oc_email_4,
  t0.oc_username AS oc_username_5,
  t0.oc_birthdate AS oc_birthdate_6,
  t0.oc_phone AS oc_phone_7,
  t0.oc_phone_2 AS oc_phone_2_8,
  t0.oc_is_created_card AS oc_is_created_card_9,
  t0.oc_lang_code AS oc_lang_code_10,
  t0.oc_omt_user_id AS oc_omt_user_id_11,
  t0.oc_user_phone_order AS oc_user_phone_order_12,
  t0.oc_omt_username AS oc_omt_username_13,
  t0.oc_temporal_omt_pass AS oc_temporal_omt_pass_14,
  t0.oc_company_name AS oc_company_name_15,
  t0.oc_default_email AS oc_default_email_16,
  t0.oc_phone_verification_id AS oc_phone_verification_id_17,
  t0.oc_is_phone_verified AS oc_is_phone_verified_18,
  t0.oc_already_reset AS oc_already_reset_19,
  t0.oc_global_checking AS oc_global_checking_20,
  t0.oc_joined_date AS oc_joined_date_21,
  t0.oc_last_checking AS oc_last_checking_22,
  t0.oc_record_created_at AS oc_record_created_at_23,
  t0.oc_date_created AS oc_date_created_24,
  t0.oc_discart_client AS oc_discart_client_25,
  t0.oc_from_portal AS oc_from_portal_26
FROM
  omt_client t0
WHERE
  t0.oc_id = ?

SELECT t0.oc_id AS oc_id_1, t0.oc_name AS oc_name_2, t0.oc_last_name AS oc_last_name_3, t0.oc_email AS oc_email_4, t0.oc_username AS oc_username_5, t0.oc_birthdate AS oc_birthdate_6, t0.oc_phone AS oc_phone_7, t0.oc_phone_2 AS oc_phone_2_8, t0.oc_is_created_card AS oc_is_created_card_9, t0.oc_lang_code AS oc_lang_code_10, t0.oc_omt_user_id AS oc_omt_user_id_11, t0.oc_user_phone_order AS oc_user_phone_order_12, t0.oc_omt_username AS oc_omt_username_13, t0.oc_temporal_omt_pass AS oc_temporal_omt_pass_14, t0.oc_company_name AS oc_company_name_15, t0.oc_default_email AS oc_default_email_16, t0.oc_phone_verification_id AS oc_phone_verification_id_17, t0.oc_is_phone_verified AS oc_is_phone_verified_18, t0.oc_already_reset AS oc_already_reset_19, t0.oc_global_checking AS oc_global_checking_20, t0.oc_joined_date AS oc_joined_date_21, t0.oc_last_checking AS oc_last_checking_22, t0.oc_record_created_at AS oc_record_created_at_23, t0.oc_date_created AS oc_date_created_24, t0.oc_discart_client AS oc_discart_client_25, t0.oc_from_portal AS oc_from_portal_26 FROM omt_client t0 WHERE t0.oc_id = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1';

SELECT
  t0.rlc_id AS rlc_id_1,
  t0.rlc_created AS rlc_created_2,
  t0.rlc_local_points AS rlc_local_points_3,
  t0.rlc_global_points AS rlc_global_points_4,
  t0.rlc_earn_points_with_points AS rlc_earn_points_with_points_5,
  t0.rlc_minimum_exchange AS rlc_minimum_exchange_6,
  t0.rlc_license AS rlc_license_7
FROM
  restaurant_loyalty_configuration t0
WHERE
  t0.rlc_license = ?

SELECT t0.rlc_id AS rlc_id_1, t0.rlc_created AS rlc_created_2, t0.rlc_local_points AS rlc_local_points_3, t0.rlc_global_points AS rlc_global_points_4, t0.rlc_earn_points_with_points AS rlc_earn_points_with_points_5, t0.rlc_minimum_exchange AS rlc_minimum_exchange_6, t0.rlc_license AS rlc_license_7 FROM restaurant_loyalty_configuration t0 WHERE t0.rlc_license = 1221;

SELECT
  t0.tp_id AS tp_id_1,
  t0.tp_type AS tp_type_2,
  t0.tp_name AS tp_name_3,
  t0.tp_description AS tp_description_4,
  t0.tp_date_created AS tp_date_created_5,
  t0.tp_cash_ratio AS tp_cash_ratio_6,
  t0.tp_work_as AS tp_work_as_7
FROM
  type_point t0
WHERE
  t0.tp_type = ?

SELECT t0.tp_id AS tp_id_1, t0.tp_type AS tp_type_2, t0.tp_name AS tp_name_3, t0.tp_description AS tp_description_4, t0.tp_date_created AS tp_date_created_5, t0.tp_cash_ratio AS tp_cash_ratio_6, t0.tp_work_as AS tp_work_as_7 FROM type_point t0 WHERE t0.tp_type = 1;

SELECT
  p0_.ptar_id AS ptar_id_0
FROM
  omt_client o1_
  INNER JOIN point_acount p2_ ON (
    (
      p2_.pa_omt_client_fk = o1_.oc_id
      AND p2_.pa_omt_client_fk = ?
    )
  )
  INNER JOIN point_deal p3_ ON (
    p3_.pd_point_acount_fk = p2_.pa_id
  )
  INNER JOIN ptar_adqui_redem_rules p0_ ON (
    p3_.pd_related_rule = p0_.ptar_id
  )
  INNER JOIN type_point_acount t4_ ON (
    p3_.pd_type_point_acount_fk = t4_.tpa_id
  )
  INNER JOIN type_point t5_ ON (
    t4_.tpa_type_point_fk = t5_.tp_id
  )
  INNER JOIN type_pts_generic_definition_rules t6_ ON (
    p0_.ptar_basic_definition = t6_.pgdr_id
  )
WHERE
  p0_.ptar_delete_date IS NULL
  AND (
    (
      '2026-04-04 09:00:56' > p0_.ptar_initial_activation_date
      AND p0_.ptar_final_activation_date < '2026-04-04 09:00:56'
    )
    OR (
      '2026-04-04 09:00:56' > p0_.ptar_initial_activation_date
      AND p0_.ptar_final_activation_date IS NULL
    )
  )
  AND p0_.ptar_just_claim_once = ?
  AND t5_.tp_type = ?
  AND (
    p0_.ptar_license = ?
    OR p0_.ptar_license IS NULL
  )

SELECT p0_.ptar_id AS ptar_id_0 FROM omt_client o1_ INNER JOIN point_acount p2_ ON ((p2_.pa_omt_client_fk = o1_.oc_id AND p2_.pa_omt_client_fk = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1')) INNER JOIN point_deal p3_ ON (p3_.pd_point_acount_fk = p2_.pa_id) INNER JOIN ptar_adqui_redem_rules p0_ ON (p3_.pd_related_rule = p0_.ptar_id) INNER JOIN type_point_acount t4_ ON (p3_.pd_type_point_acount_fk = t4_.tpa_id) INNER JOIN type_point t5_ ON (t4_.tpa_type_point_fk = t5_.tp_id) INNER JOIN type_pts_generic_definition_rules t6_ ON (p0_.ptar_basic_definition = t6_.pgdr_id) WHERE p0_.ptar_delete_date IS NULL AND (('2026-04-04 0911' > p0_.ptar_initial_activation_date AND p0_.ptar_final_activation_date < '2026-04-04 091221:56') OR ('2026-04-04 09:00:56' > p0_.ptar_initial_activation_date AND p0_.ptar_final_activation_date IS NULL)) AND p0_.ptar_just_claim_once = ? AND t5_.tp_type = ? AND (p0_.ptar_license = ? OR p0_.ptar_license IS NULL);

SELECT
  DISTINCT (p0_.ptar_parent_definition) AS sclr_0
FROM
  ptar_adqui_redem_rules p0_
  INNER JOIN type_point t1_ ON (p0_.ptar_pt_type = t1_.tp_id)
  INNER JOIN type_pts_generic_definition_rules t2_ ON (
    p0_.ptar_basic_definition = t2_.pgdr_id
  )
WHERE
  p0_.ptar_delete_date IS NULL
  AND p0_.ptar_parent_definition IS NOT NULL
  AND (
    (
      '2026-04-04 09:00:56' > p0_.ptar_initial_activation_date
      AND p0_.ptar_final_activation_date < '2026-04-04 09:00:56'
    )
    OR (
      '2026-04-04 09:00:56' > p0_.ptar_initial_activation_date
      AND p0_.ptar_final_activation_date IS NULL
    )
  )
  AND t1_.tp_type = ?
  AND (
    p0_.ptar_license = ?
    OR p0_.ptar_license IS NULL
  )

SELECT DISTINCT (p0_.ptar_parent_definition) AS sclr_0 FROM ptar_adqui_redem_rules p0_ INNER JOIN type_point t1_ ON (p0_.ptar_pt_type = t1_.tp_id) INNER JOIN type_pts_generic_definition_rules t2_ ON (p0_.ptar_basic_definition = t2_.pgdr_id) WHERE p0_.ptar_delete_date IS NULL AND p0_.ptar_parent_definition IS NOT NULL AND (('2026-04-04 0911221' > p0_.ptar_initial_activation_date AND p0_.ptar_final_activation_date < '2026-04-04 09:00:56') OR ('2026-04-04 09:00:56' > p0_.ptar_initial_activation_date AND p0_.ptar_final_activation_date IS NULL)) AND t1_.tp_type = ? AND (p0_.ptar_license = ? OR p0_.ptar_license IS NULL);

SELECT
  p0_.ptar_id AS ptar_id_0,
  p0_.ptar_name AS ptar_name_1,
  p0_.ptar_pts_rate AS ptar_pts_rate_2,
  p0_.ptar_watchable_objetc AS ptar_watchable_objetc_3,
  p0_.ptar_apply_to_specific_record AS ptar_apply_to_specific_record_4,
  p0_.ptar_just_claim_once AS ptar_just_claim_once_5,
  p0_.ptar_creation_date AS ptar_creation_date_6,
  p0_.ptar_update_date AS ptar_update_date_7,
  p0_.ptar_delete_date AS ptar_delete_date_8,
  p0_.ptar_initial_activation_date AS ptar_initial_activation_date_9,
  p0_.ptar_final_activation_date AS ptar_final_activation_date_10,
  p0_.ptar_minimum_purchase AS ptar_minimum_purchase_11,
  p0_.ptar_minimum_purchase_quantity AS ptar_minimum_purchase_quantity_12,
  p0_.ptar_just_get_these_pts AS ptar_just_get_these_pts_13,
  p0_.ptar_basic_definition AS ptar_basic_definition_14,
  p0_.ptar_parent_definition AS ptar_parent_definition_15,
  p0_.ptar_license AS ptar_license_16,
  p0_.ptar_pt_type AS ptar_pt_type_17
FROM
  ptar_adqui_redem_rules p0_
  INNER JOIN type_point t1_ ON (p0_.ptar_pt_type = t1_.tp_id)
  INNER JOIN type_pts_generic_definition_rules t2_ ON (
    p0_.ptar_basic_definition = t2_.pgdr_id
  )
WHERE
  p0_.ptar_delete_date IS NULL
  AND (
    (
      '2026-04-04 09:00:56' > p0_.ptar_initial_activation_date
      AND p0_.ptar_final_activation_date < '2026-04-04 09:00:56'
    )
    OR (
      '2026-04-04 09:00:56' > p0_.ptar_initial_activation_date
      AND p0_.ptar_final_activation_date IS NULL
    )
  )
  AND t1_.tp_type = ?
  AND t2_.pgdr_type = ?
  AND (
    p0_.ptar_license = ?
    OR p0_.ptar_license IS NULL
  )
  AND p0_.ptar_id NOT IN (
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b8',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b7',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b5',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b4',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b1',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b2',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b6',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b0',
    'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b3'
  )

SELECT p0_.ptar_id AS ptar_id_0, p0_.ptar_name AS ptar_name_1, p0_.ptar_pts_rate AS ptar_pts_rate_2, p0_.ptar_watchable_objetc AS ptar_watchable_objetc_3, p0_.ptar_apply_to_specific_record AS ptar_apply_to_specific_record_4, p0_.ptar_just_claim_once AS ptar_just_claim_once_5, p0_.ptar_creation_date AS ptar_creation_date_6, p0_.ptar_update_date AS ptar_update_date_7, p0_.ptar_delete_date AS ptar_delete_date_8, p0_.ptar_initial_activation_date AS ptar_initial_activation_date_9, p0_.ptar_final_activation_date AS ptar_final_activation_date_10, p0_.ptar_minimum_purchase AS ptar_minimum_purchase_11, p0_.ptar_minimum_purchase_quantity AS ptar_minimum_purchase_quantity_12, p0_.ptar_just_get_these_pts AS ptar_just_get_these_pts_13, p0_.ptar_basic_definition AS ptar_basic_definition_14, p0_.ptar_parent_definition AS ptar_parent_definition_15, p0_.ptar_license AS ptar_license_16, p0_.ptar_pt_type AS ptar_pt_type_17 FROM ptar_adqui_redem_rules p0_ INNER JOIN type_point t1_ ON (p0_.ptar_pt_type = t1_.tp_id) INNER JOIN type_pts_generic_definition_rules t2_ ON (p0_.ptar_basic_definition = t2_.pgdr_id) WHERE p0_.ptar_delete_date IS NULL AND (('2026-04-04 091'2'' > p0_.ptar_initial_activation_date AND p0_.ptar_final_activation_date < '2026-04-04 091221:56') OR ('2026-04-04 09:00:56' > p0_.ptar_initial_activation_date AND p0_.ptar_final_activation_date IS NULL)) AND t1_.tp_type = ? AND t2_.pgdr_type = ? AND (p0_.ptar_license = ? OR p0_.ptar_license IS NULL) AND p0_.ptar_id NOT IN ('a00000a1-0aaa-00a0-a00a-0a0a00aaa0b8', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b7', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b5', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b4', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b1', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b2', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b6', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b0', 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b3');

SELECT
  t0_.tp_id AS tp_id_0,
  t0_.tp_type AS tp_type_1,
  t0_.tp_name AS tp_name_2,
  t0_.tp_description AS tp_description_3,
  t0_.tp_date_created AS tp_date_created_4,
  t0_.tp_cash_ratio AS tp_cash_ratio_5,
  t0_.tp_work_as AS tp_work_as_6
FROM
  type_point t0_
WHERE
  t0_.tp_id = ?
LIMIT
  1

SELECT t0_.tp_id AS tp_id_0, t0_.tp_type AS tp_type_1, t0_.tp_name AS tp_name_2, t0_.tp_description AS tp_description_3, t0_.tp_date_created AS tp_date_created_4, t0_.tp_cash_ratio AS tp_cash_ratio_5, t0_.tp_work_as AS tp_work_as_6 FROM type_point t0_ WHERE t0_.tp_id = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0a0' LIMIT 1;

SELECT
  t0_.tpa_id AS tpa_id_0,
  t0_.tpa_pt_amount AS tpa_pt_amount_1,
  t0_.tpa_starting_date AS tpa_starting_date_2,
  t0_.tpa_point_arm_acount AS tpa_point_arm_acount_3,
  t0_.tpa_specific_acount_token AS tpa_specific_acount_token_4,
  t0_.tpa_arm_identifier AS tpa_arm_identifier_5,
  t0_.tpa_transaction_verification_token AS tpa_transaction_verification_token_6,
  t0_.tpa_verification_token_created_date AS tpa_verification_token_created_date_7,
  t0_.tpa_type_point_fk AS tpa_type_point_fk_8,
  t0_.tpa_point_acount_fk AS tpa_point_acount_fk_9,
  t0_.tpa_country_fk AS tpa_country_fk_10,
  t0_.tpa_license AS tpa_license_11
FROM
  type_point_acount t0_
  INNER JOIN point_acount p1_ ON (
    t0_.tpa_point_acount_fk = p1_.pa_id
  )
  INNER JOIN type_point t2_ ON (
    t0_.tpa_type_point_fk = t2_.tp_id
  )
  INNER JOIN omt_client o3_ ON (p1_.pa_omt_client_fk = o3_.oc_id)
WHERE
  o3_.oc_id = ?
  AND t2_.tp_id = ?
  AND t0_.tpa_license = ?
LIMIT
  1

SELECT t0_.tpa_id AS tpa_id_0, t0_.tpa_pt_amount AS tpa_pt_amount_1, t0_.tpa_starting_date AS tpa_starting_date_2, t0_.tpa_point_arm_acount AS tpa_point_arm_acount_3, t0_.tpa_specific_acount_token AS tpa_specific_acount_token_4, t0_.tpa_arm_identifier AS tpa_arm_identifier_5, t0_.tpa_transaction_verification_token AS tpa_transaction_verification_token_6, t0_.tpa_verification_token_created_date AS tpa_verification_token_created_date_7, t0_.tpa_type_point_fk AS tpa_type_point_fk_8, t0_.tpa_point_acount_fk AS tpa_point_acount_fk_9, t0_.tpa_country_fk AS tpa_country_fk_10, t0_.tpa_license AS tpa_license_11 FROM type_point_acount t0_ INNER JOIN point_acount p1_ ON (t0_.tpa_point_acount_fk = p1_.pa_id) INNER JOIN type_point t2_ ON (t0_.tpa_type_point_fk = t2_.tp_id) INNER JOIN omt_client o3_ ON (p1_.pa_omt_client_fk = o3_.oc_id) WHERE o3_.oc_id = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1' AND t2_.tp_id = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0a0' AND t0_.tpa_license = 1221 LIMIT 1;

SELECT
  t0_.tpa_id AS tpa_id_0,
  t0_.tpa_pt_amount AS tpa_pt_amount_1,
  t0_.tpa_starting_date AS tpa_starting_date_2,
  t0_.tpa_point_arm_acount AS tpa_point_arm_acount_3,
  t0_.tpa_specific_acount_token AS tpa_specific_acount_token_4,
  t0_.tpa_arm_identifier AS tpa_arm_identifier_5,
  t0_.tpa_transaction_verification_token AS tpa_transaction_verification_token_6,
  t0_.tpa_verification_token_created_date AS tpa_verification_token_created_date_7,
  t0_.tpa_type_point_fk AS tpa_type_point_fk_8,
  t0_.tpa_point_acount_fk AS tpa_point_acount_fk_9,
  t0_.tpa_country_fk AS tpa_country_fk_10,
  t0_.tpa_license AS tpa_license_11
FROM
  type_point_acount t0_
  INNER JOIN point_acount p1_ ON (
    t0_.tpa_point_acount_fk = p1_.pa_id
  )
  INNER JOIN type_point t2_ ON (
    t0_.tpa_type_point_fk = t2_.tp_id
  )
  INNER JOIN omt_client o3_ ON (p1_.pa_omt_client_fk = o3_.oc_id)
WHERE
  o3_.oc_id = ?
  AND t2_.tp_id = ?
  AND t0_.tpa_license = ?
LIMIT
  1

SELECT t0_.tpa_id AS tpa_id_0, t0_.tpa_pt_amount AS tpa_pt_amount_1, t0_.tpa_starting_date AS tpa_starting_date_2, t0_.tpa_point_arm_acount AS tpa_point_arm_acount_3, t0_.tpa_specific_acount_token AS tpa_specific_acount_token_4, t0_.tpa_arm_identifier AS tpa_arm_identifier_5, t0_.tpa_transaction_verification_token AS tpa_transaction_verification_token_6, t0_.tpa_verification_token_created_date AS tpa_verification_token_created_date_7, t0_.tpa_type_point_fk AS tpa_type_point_fk_8, t0_.tpa_point_acount_fk AS tpa_point_acount_fk_9, t0_.tpa_country_fk AS tpa_country_fk_10, t0_.tpa_license AS tpa_license_11 FROM type_point_acount t0_ INNER JOIN point_acount p1_ ON (t0_.tpa_point_acount_fk = p1_.pa_id) INNER JOIN type_point t2_ ON (t0_.tpa_type_point_fk = t2_.tp_id) INNER JOIN omt_client o3_ ON (p1_.pa_omt_client_fk = o3_.oc_id) WHERE o3_.oc_id = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1' AND t2_.tp_id = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0a0' AND t0_.tpa_license = 1221 LIMIT 1;

SELECT
  t0.pa_id AS pa_id_1,
  t0.pa_omt_client_fk AS pa_omt_client_fk_2,
  t0.pa_base_point_acount_token AS pa_base_point_acount_token_3,
  t0.pa_activation_date AS pa_activation_date_4,
  t0.pa_blocked_other_transaction AS pa_blocked_other_transaction_5
FROM
  point_acount t0
WHERE
  t0.pa_id = ?

SELECT t0.pa_id AS pa_id_1, t0.pa_omt_client_fk AS pa_omt_client_fk_2, t0.pa_base_point_acount_token AS pa_base_point_acount_token_3, t0.pa_activation_date AS pa_activation_date_4, t0.pa_blocked_other_transaction AS pa_blocked_other_transaction_5 FROM point_acount t0 WHERE t0.pa_id = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1';

SELECT
  t0.tpa_id AS tpa_id_1,
  t0.tpa_pt_amount AS tpa_pt_amount_2,
  t0.tpa_starting_date AS tpa_starting_date_3,
  t0.tpa_point_arm_acount AS tpa_point_arm_acount_4,
  t0.tpa_specific_acount_token AS tpa_specific_acount_token_5,
  t0.tpa_arm_identifier AS tpa_arm_identifier_6,
  t0.tpa_transaction_verification_token AS tpa_transaction_verification_token_7,
  t0.tpa_verification_token_created_date AS tpa_verification_token_created_date_8,
  t0.tpa_type_point_fk AS tpa_type_point_fk_9,
  t0.tpa_point_acount_fk AS tpa_point_acount_fk_10,
  t0.tpa_country_fk AS tpa_country_fk_11,
  t0.tpa_license AS tpa_license_12
FROM
  type_point_acount t0
WHERE
  t0.tpa_arm_identifier = ?

SELECT t0.tpa_id AS tpa_id_1, t0.tpa_pt_amount AS tpa_pt_amount_2, t0.tpa_starting_date AS tpa_starting_date_3, t0.tpa_point_arm_acount AS tpa_point_arm_acount_4, t0.tpa_specific_acount_token AS tpa_specific_acount_token_5, t0.tpa_arm_identifier AS tpa_arm_identifier_6, t0.tpa_transaction_verification_token AS tpa_transaction_verification_token_7, t0.tpa_verification_token_created_date AS tpa_verification_token_created_date_8, t0.tpa_type_point_fk AS tpa_type_point_fk_9, t0.tpa_point_acount_fk AS tpa_point_acount_fk_10, t0.tpa_country_fk AS tpa_country_fk_11, t0.tpa_license AS tpa_license_12 FROM type_point_acount t0 WHERE t0.tpa_arm_identifier = '21b30ef3-2def-11f1-8fe1-0af49f593302';

SELECT
  t0.pgdr_id AS pgdr_id_1,
  t0.pgdr_name AS pgdr_name_2,
  t0.pgdr_basic_type AS pgdr_basic_type_3,
  t0.pgdr_type AS pgdr_type_4,
  t0.pgdr_effect AS pgdr_effect_5
FROM
  type_pts_generic_definition_rules t0
WHERE
  t0.pgdr_id = ?

SELECT t0.pgdr_id AS pgdr_id_1, t0.pgdr_name AS pgdr_name_2, t0.pgdr_basic_type AS pgdr_basic_type_3, t0.pgdr_type AS pgdr_type_4, t0.pgdr_effect AS pgdr_effect_5 FROM type_pts_generic_definition_rules t0 WHERE t0.pgdr_id = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0a2';

SELECT
  t0.co_id AS co_id_1,
  t0.co_name AS co_name_2,
  t0.co_value AS co_value_3,
  t0.co_three_value AS co_three_value_4,
  t0.co_phone_prefix AS co_phone_prefix_5,
  t0.co_dian_code_lc AS co_dian_code_lc_6,
  t0.co_name_es AS co_name_es_7
FROM
  country t0
WHERE
  t0.co_id = ?

SELECT t0.co_id AS co_id_1, t0.co_name AS co_name_2, t0.co_value AS co_value_3, t0.co_three_value AS co_three_value_4, t0.co_phone_prefix AS co_phone_prefix_5, t0.co_dian_code_lc AS co_dian_code_lc_6, t0.co_name_es AS co_name_es_7 FROM country t0 WHERE t0.co_id = 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  type_point_acount
SET
  tpa_pt_amount = ?
WHERE
  tpa_id = ?

UPDATE type_point_acount SET tpa_pt_amount = 1.79 WHERE tpa_id = 'd67c5399-a22a-44ec-a5f5-73d524b2a8af';

"COMMIT"

"COMMIT";

SELECT
  t0.pa_id AS pa_id_1,
  t0.pa_omt_client_fk AS pa_omt_client_fk_2,
  t0.pa_base_point_acount_token AS pa_base_point_acount_token_3,
  t0.pa_activation_date AS pa_activation_date_4,
  t0.pa_blocked_other_transaction AS pa_blocked_other_transaction_5
FROM
  point_acount t0
WHERE
  t0.pa_omt_client_fk = ?

SELECT t0.pa_id AS pa_id_1, t0.pa_omt_client_fk AS pa_omt_client_fk_2, t0.pa_base_point_acount_token AS pa_base_point_acount_token_3, t0.pa_activation_date AS pa_activation_date_4, t0.pa_blocked_other_transaction AS pa_blocked_other_transaction_5 FROM point_acount t0 WHERE t0.pa_omt_client_fk = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1';

SELECT
  t0_.tp_id AS tp_id_0,
  t0_.tp_type AS tp_type_1,
  t0_.tp_name AS tp_name_2,
  t0_.tp_description AS tp_description_3,
  t0_.tp_date_created AS tp_date_created_4,
  t0_.tp_cash_ratio AS tp_cash_ratio_5,
  t0_.tp_work_as AS tp_work_as_6
FROM
  type_point t0_
WHERE
  t0_.tp_id = ?
LIMIT
  1

SELECT t0_.tp_id AS tp_id_0, t0_.tp_type AS tp_type_1, t0_.tp_name AS tp_name_2, t0_.tp_description AS tp_description_3, t0_.tp_date_created AS tp_date_created_4, t0_.tp_cash_ratio AS tp_cash_ratio_5, t0_.tp_work_as AS tp_work_as_6 FROM type_point t0_ WHERE t0_.tp_id = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0a0' LIMIT 1;

SELECT
  t0_.tpa_id AS tpa_id_0,
  t0_.tpa_pt_amount AS tpa_pt_amount_1,
  t0_.tpa_starting_date AS tpa_starting_date_2,
  t0_.tpa_point_arm_acount AS tpa_point_arm_acount_3,
  t0_.tpa_specific_acount_token AS tpa_specific_acount_token_4,
  t0_.tpa_arm_identifier AS tpa_arm_identifier_5,
  t0_.tpa_transaction_verification_token AS tpa_transaction_verification_token_6,
  t0_.tpa_verification_token_created_date AS tpa_verification_token_created_date_7,
  t0_.tpa_type_point_fk AS tpa_type_point_fk_8,
  t0_.tpa_point_acount_fk AS tpa_point_acount_fk_9,
  t0_.tpa_country_fk AS tpa_country_fk_10,
  t0_.tpa_license AS tpa_license_11
FROM
  type_point_acount t0_
  INNER JOIN point_acount p1_ ON (
    t0_.tpa_point_acount_fk = p1_.pa_id
  )
  INNER JOIN type_point t2_ ON (
    t0_.tpa_type_point_fk = t2_.tp_id
  )
  INNER JOIN omt_client o3_ ON (p1_.pa_omt_client_fk = o3_.oc_id)
WHERE
  o3_.oc_id = ?
  AND t2_.tp_id = ?
  AND t0_.tpa_license = ?
LIMIT
  1

SELECT t0_.tpa_id AS tpa_id_0, t0_.tpa_pt_amount AS tpa_pt_amount_1, t0_.tpa_starting_date AS tpa_starting_date_2, t0_.tpa_point_arm_acount AS tpa_point_arm_acount_3, t0_.tpa_specific_acount_token AS tpa_specific_acount_token_4, t0_.tpa_arm_identifier AS tpa_arm_identifier_5, t0_.tpa_transaction_verification_token AS tpa_transaction_verification_token_6, t0_.tpa_verification_token_created_date AS tpa_verification_token_created_date_7, t0_.tpa_type_point_fk AS tpa_type_point_fk_8, t0_.tpa_point_acount_fk AS tpa_point_acount_fk_9, t0_.tpa_country_fk AS tpa_country_fk_10, t0_.tpa_license AS tpa_license_11 FROM type_point_acount t0_ INNER JOIN point_acount p1_ ON (t0_.tpa_point_acount_fk = p1_.pa_id) INNER JOIN type_point t2_ ON (t0_.tpa_type_point_fk = t2_.tp_id) INNER JOIN omt_client o3_ ON (p1_.pa_omt_client_fk = o3_.oc_id) WHERE o3_.oc_id = 'c224f14f-2dc7-4617-bf5d-e5f1697a3ef1' AND t2_.tp_id = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0a0' AND t0_.tpa_license = 1221 LIMIT 1;