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 ('newyorkb_1166');

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 = 467;

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 = 1166;

SELECT
  o0_.oc_id AS oc_id_0
FROM
  omt_client o0_
WHERE
  o0_.oc_id NOT LIKE '1'
  AND o0_.oc_phone LIKE ?
LIMIT
  10

SELECT o0_.oc_id AS oc_id_0 FROM omt_client o0_ WHERE o0_.oc_id NOT LIKE '1' AND o0_.oc_phone LIKE '8432061383%' LIMIT 10;

SELECT
  count(DISTINCT o0_.oc_id) AS sclr_0
FROM
  omt_client o0_
WHERE
  o0_.oc_id NOT LIKE '1'

SELECT count(DISTINCT o0_.oc_id) AS sclr_0 FROM omt_client o0_ WHERE o0_.oc_id NOT LIKE '1';

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 = '5075b8e0-b35a-4f28-9c84-9f745864a183';

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 = ?
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_omt_client_fk = '5075b8e0-b35a-4f28-9c84-9f745864a183' LIMIT 1;

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_point_acount_fk = ?
  AND t0.tpa_license = ?
LIMIT
  1

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_point_acount_fk = '5075b8e0-b35a-4f28-9c84-9f745864a183' AND t0.tpa_license = 1166 LIMIT 1;

SELECT
  t0.ptar_id AS ptar_id_1,
  t0.ptar_name AS ptar_name_2,
  t0.ptar_pts_rate AS ptar_pts_rate_3,
  t0.ptar_watchable_objetc AS ptar_watchable_objetc_4,
  t0.ptar_apply_to_specific_record AS ptar_apply_to_specific_record_5,
  t0.ptar_just_claim_once AS ptar_just_claim_once_6,
  t0.ptar_creation_date AS ptar_creation_date_7,
  t0.ptar_update_date AS ptar_update_date_8,
  t0.ptar_delete_date AS ptar_delete_date_9,
  t0.ptar_initial_activation_date AS ptar_initial_activation_date_10,
  t0.ptar_final_activation_date AS ptar_final_activation_date_11,
  t0.ptar_minimum_purchase AS ptar_minimum_purchase_12,
  t0.ptar_minimum_purchase_quantity AS ptar_minimum_purchase_quantity_13,
  t0.ptar_just_get_these_pts AS ptar_just_get_these_pts_14,
  t0.ptar_basic_definition AS ptar_basic_definition_15,
  t0.ptar_parent_definition AS ptar_parent_definition_16,
  t0.ptar_license AS ptar_license_17,
  t0.ptar_pt_type AS ptar_pt_type_18
FROM
  ptar_adqui_redem_rules t0
WHERE
  t0.ptar_license = ?
  AND t0.ptar_parent_definition = ?
LIMIT
  1

SELECT t0.ptar_id AS ptar_id_1, t0.ptar_name AS ptar_name_2, t0.ptar_pts_rate AS ptar_pts_rate_3, t0.ptar_watchable_objetc AS ptar_watchable_objetc_4, t0.ptar_apply_to_specific_record AS ptar_apply_to_specific_record_5, t0.ptar_just_claim_once AS ptar_just_claim_once_6, t0.ptar_creation_date AS ptar_creation_date_7, t0.ptar_update_date AS ptar_update_date_8, t0.ptar_delete_date AS ptar_delete_date_9, t0.ptar_initial_activation_date AS ptar_initial_activation_date_10, t0.ptar_final_activation_date AS ptar_final_activation_date_11, t0.ptar_minimum_purchase AS ptar_minimum_purchase_12, t0.ptar_minimum_purchase_quantity AS ptar_minimum_purchase_quantity_13, t0.ptar_just_get_these_pts AS ptar_just_get_these_pts_14, t0.ptar_basic_definition AS ptar_basic_definition_15, t0.ptar_parent_definition AS ptar_parent_definition_16, t0.ptar_license AS ptar_license_17, t0.ptar_pt_type AS ptar_pt_type_18 FROM ptar_adqui_redem_rules t0 WHERE t0.ptar_license = 1166 AND t0.ptar_parent_definition = 'a00000a1-0aaa-00a0-a00a-0a0a00aaa0b0' LIMIT 1;

SELECT
  CONCAT(
    CONCAT(o0_.oc_name, ' '),
    o0_.oc_last_name
  ) AS sclr_0,
  o0_.oc_name AS oc_name_1,
  o0_.oc_last_name AS oc_last_name_2,
  p1_.pa_id AS pa_id_3,
  o0_.oc_id AS oc_id_4,
  a2_.al_id AS al_id_5,
  o0_.oc_email AS oc_email_6,
  o0_.oc_username AS oc_username_7,
  o0_.oc_default_email AS oc_default_email_8,
  o0_.oc_phone AS oc_phone_9,
  t3_.tp_name AS tp_name_10,
  t3_.tp_type AS tp_type_11,
  t4_.tpa_id AS tpa_id_12,
  t4_.tpa_starting_date AS tpa_starting_date_13,
  t4_.tpa_pt_amount AS tpa_pt_amount_14,
  t4_.tpa_country_fk AS sclr_15,
  t3_.tp_cash_ratio AS tp_cash_ratio_16
FROM
  type_point_acount t4_
  INNER JOIN point_acount p1_ ON (
    t4_.tpa_point_acount_fk = p1_.pa_id
  )
  INNER JOIN type_point t3_ ON (
    t4_.tpa_type_point_fk = t3_.tp_id
  )
  INNER JOIN omt_client o0_ ON (p1_.pa_omt_client_fk = o0_.oc_id)
  LEFT JOIN account_license a2_ ON (a2_.al_id = t4_.tpa_license)
WHERE
  o0_.oc_id NOT LIKE '1'
  AND o0_.oc_phone LIKE ?
  AND (
    t4_.tpa_license = ?
    OR t4_.tpa_license IS NULL
  )
  AND o0_.oc_id IN (
    '5075b8e0-b35a-4f28-9c84-9f745864a183'
  )
ORDER BY
  t3_.tp_type ASC

SELECT CONCAT(CONCAT(o0_.oc_name, ' '), o0_.oc_last_name) AS sclr_0, o0_.oc_name AS oc_name_1, o0_.oc_last_name AS oc_last_name_2, p1_.pa_id AS pa_id_3, o0_.oc_id AS oc_id_4, a2_.al_id AS al_id_5, o0_.oc_email AS oc_email_6, o0_.oc_username AS oc_username_7, o0_.oc_default_email AS oc_default_email_8, o0_.oc_phone AS oc_phone_9, t3_.tp_name AS tp_name_10, t3_.tp_type AS tp_type_11, t4_.tpa_id AS tpa_id_12, t4_.tpa_starting_date AS tpa_starting_date_13, t4_.tpa_pt_amount AS tpa_pt_amount_14, t4_.tpa_country_fk AS sclr_15, t3_.tp_cash_ratio AS tp_cash_ratio_16 FROM type_point_acount t4_ INNER JOIN point_acount p1_ ON (t4_.tpa_point_acount_fk = p1_.pa_id) INNER JOIN type_point t3_ ON (t4_.tpa_type_point_fk = t3_.tp_id) INNER JOIN omt_client o0_ ON (p1_.pa_omt_client_fk = o0_.oc_id) LEFT JOIN account_license a2_ ON (a2_.al_id = t4_.tpa_license) WHERE o0_.oc_id NOT LIKE '1' AND o0_.oc_phone LIKE '8432061383%' AND (t4_.tpa_license = 1166 OR t4_.tpa_license IS NULL) AND o0_.oc_id IN ('5075b8e0-b35a-4f28-9c84-9f745864a183') ORDER BY t3_.tp_type ASC;

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 = ?
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_omt_client_fk = '5075b8e0-b35a-4f28-9c84-9f745864a183' LIMIT 1;

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_point_acount_fk = ?
  AND t0.tpa_license = ?
ORDER BY
  t0.tpa_pt_amount DESC

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_point_acount_fk = '5075b8e0-b35a-4f28-9c84-9f745864a183' AND t0.tpa_license = 1166 ORDER BY t0.tpa_pt_amount DESC;

SELECT
  t0_.tp_cash_ratio AS tp_cash_ratio_0,
  t0_.tp_name AS tp_name_1
FROM
  type_point t0_
WHERE
  t0_.tp_name = 'Local Points'
  OR t0_.tp_name = 'Global Points'

SELECT t0_.tp_cash_ratio AS tp_cash_ratio_0, t0_.tp_name AS tp_name_1 FROM type_point t0_ WHERE t0_.tp_name = 'Local Points' OR t0_.tp_name = 'Global Points';

SELECT
  r0_.rlc_local_points AS rlc_local_points_0
FROM
  restaurant_loyalty_configuration r0_
WHERE
  r0_.rlc_license = ?

SELECT r0_.rlc_local_points AS rlc_local_points_0 FROM restaurant_loyalty_configuration r0_ WHERE r0_.rlc_license = 1166;