Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.msisdn AS msisdn_3,
  t0.create_time AS create_time_4,
  t0.update_time AS update_time_5,
  t0.menu_code AS menu_code_6,
  t0.menu_title AS menu_title_7,
  t0.next_menu_code AS next_menu_code_8,
  t0.previous_menu_code AS previous_menu_code_9,
  t0.is_input_request AS is_input_request_10,
  t0.menu_options_string AS menu_options_string_11,
  t0.screen_id AS screen_id_12,
  t0.operator_id AS operator_id_13,
  t0.service_id AS service_id_14
FROM
  sys_session_tmp t0
WHERE
  t0.msisdn = ?
  AND t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.msisdn AS msisdn_3, t0.create_time AS create_time_4, t0.update_time AS update_time_5, t0.menu_code AS menu_code_6, t0.menu_title AS menu_title_7, t0.next_menu_code AS next_menu_code_8, t0.previous_menu_code AS previous_menu_code_9, t0.is_input_request AS is_input_request_10, t0.menu_options_string AS menu_options_string_11, t0.screen_id AS screen_id_12, t0.operator_id AS operator_id_13, t0.service_id AS service_id_14 FROM sys_session_tmp t0 WHERE t0.msisdn = '22966458006' AND t0.session_id = '17275256210422226' LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.code_service AS code_service_2,
  t0.libelle AS libelle_3,
  t0.description AS description_4,
  t0.order_number AS order_number_5,
  t0.enable AS enable_6,
  t0.transaction_fee_charge AS transaction_fee_charge_7,
  t0.text_success_payement_sms AS text_success_payement_sms_8,
  t0.text_failed_payement_sms AS text_failed_payement_sms_9,
  t0.sms_sender_name AS sms_sender_name_10,
  t0.in_production AS in_production_11,
  t0.visible_to_all AS visible_to_all_12,
  t0.test_number_list AS test_number_list_13
FROM
  sys_service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code_service AS code_service_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.order_number AS order_number_5, t0.enable AS enable_6, t0.transaction_fee_charge AS transaction_fee_charge_7, t0.text_success_payement_sms AS text_success_payement_sms_8, t0.text_failed_payement_sms AS text_failed_payement_sms_9, t0.sms_sender_name AS sms_sender_name_10, t0.in_production AS in_production_11, t0.visible_to_all AS visible_to_all_12, t0.test_number_list AS test_number_list_13 FROM sys_service t0 WHERE t0.id = 49;

INSERT INTO sys_ussd_history (
  entry_time, operator_code, service_code,
  session_id, msisdn, source_ip_address,
  incoming_user_input, sys_response_title,
  sys_response_option, menu_code,
  session_flag, output_time
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sys_ussd_history (entry_time, operator_code, service_code, session_id, msisdn, source_ip_address, incoming_user_input, sys_response_title, sys_response_option, menu_code, session_flag, output_time) VALUES ('2024-09-28 13:13:54', 'MTNBJ', 'MAIN', '17275256210422226', '22966458006', '10.77.69.12', '22222', 'Choix incorrect, Reessayez:
Bienvenu sur ReservLine', '-1,libelle,-1+1,Ticket de bus,50+2,Ticket event/concert,51+3,Recharge de GAZ,52+5,Smart Loyer,54+9,Autres actions,56', 'MAIN', 'INTERMEDIATE', '2024-09-28 13:13:54');

"START TRANSACTION"

"START TRANSACTION";