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 = '2290167807389' AND t0.session_id = '17518441021046740' LIMIT 1;

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

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.msisdn AS msisdn_3,
  t0.operator_id AS operator_id_4,
  t0.create_time AS create_time_5,
  t0.update_time AS update_time_6,
  t0.contrat_id AS contrat_id_7,
  t0.contrat_ref AS contrat_ref_8,
  t0.payement_id AS payement_id_9,
  t0.payement_ref AS payement_ref_10,
  t0.payement_libelle AS payement_libelle_11,
  t0.monatant_contrat AS monatant_contrat_12,
  t0.charge_fee_amount AS charge_fee_amount_13,
  t0.transaction_total_amount AS transaction_total_amount_14,
  t0.service_fee AS service_fee_15
FROM
  smartloyer_session_tmp t0
WHERE
  t0.session_id = ?
  AND t0.msisdn = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.msisdn AS msisdn_3, t0.operator_id AS operator_id_4, t0.create_time AS create_time_5, t0.update_time AS update_time_6, t0.contrat_id AS contrat_id_7, t0.contrat_ref AS contrat_ref_8, t0.payement_id AS payement_id_9, t0.payement_ref AS payement_ref_10, t0.payement_libelle AS payement_libelle_11, t0.monatant_contrat AS monatant_contrat_12, t0.charge_fee_amount AS charge_fee_amount_13, t0.transaction_total_amount AS transaction_total_amount_14, t0.service_fee AS service_fee_15 FROM smartloyer_session_tmp t0 WHERE t0.session_id = '17518441021046740' AND t0.msisdn = '2290167807389' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  smartloyer_session_tmp
SET
  update_time = ?,
  contrat_id = ?
WHERE
  id = ?

UPDATE smartloyer_session_tmp SET update_time = '2025-07-07 00:22:15', contrat_id = 0 WHERE id = 2991;

"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.code_service = ?
LIMIT
  1

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.code_service = 'SLOYER' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.menu_code AS menu_code_2,
  t0.title AS title_3,
  t0.next_menu_code AS next_menu_code_4,
  t0.previous_menu_code AS previous_menu_code_5,
  t0.request_an_entry AS request_an_entry_6,
  t0.end_of_menu AS end_of_menu_7,
  t0.level_order AS level_order_8,
  t0.description AS description_9,
  t0.option_to_choose AS option_to_choose_10,
  t0.service_id AS service_id_11
FROM
  sys_ussd_menu t0
WHERE
  t0.menu_code = ?
  AND t0.service_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.menu_code AS menu_code_2, t0.title AS title_3, t0.next_menu_code AS next_menu_code_4, t0.previous_menu_code AS previous_menu_code_5, t0.request_an_entry AS request_an_entry_6, t0.end_of_menu AS end_of_menu_7, t0.level_order AS level_order_8, t0.description AS description_9, t0.option_to_choose AS option_to_choose_10, t0.service_id AS service_id_11 FROM sys_ussd_menu t0 WHERE t0.menu_code = 'GETCONTR' AND t0.service_id = 53 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sys_session_tmp
SET
  update_time = ?,
  menu_code = ?,
  menu_title = ?,
  is_input_request = ?,
  menu_options_string = ?,
  screen_id = ?
WHERE
  id = ?

UPDATE sys_session_tmp SET update_time = '2025-07-07 00:22:15', menu_code = 'GETCONTR', menu_title = 'Entrez votre reference de contrat:', is_input_request = 1, menu_options_string = '-1,libelle,-1', screen_id = 5 WHERE id = 194751;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

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 ('2025-07-07 00:22:15', 'MTNBJ', 'SLOYER', '17518441021046740', '2290167807389', '10.77.69.44', '1', 'Entrez votre reference de contrat:', '-1,libelle,-1', 'GETCONTR', 'INTERMEDIATE', '2025-07-07 00:22:15');

"COMMIT"

"COMMIT";