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

"COMMIT"

"COMMIT";

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 = '17894150911350110' AND t0.msisdn = '2290162508291' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code_operator AS code_operator_2,
  t0.libelle AS libelle_3,
  t0.contact_adress AS contact_adress_4,
  t0.support_email AS support_email_5,
  t0.support_telephone AS support_telephone_6
FROM
  sys_operator_gsm t0
WHERE
  t0.code_operator = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_operator AS code_operator_2, t0.libelle AS libelle_3, t0.contact_adress AS contact_adress_4, t0.support_email AS support_email_5, t0.support_telephone AS support_telephone_6 FROM sys_operator_gsm t0 WHERE t0.code_operator = 'MTNBJ' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

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.service_id = ?
  AND t0.level_order = ?
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.service_id = 53 AND t0.level_order = 1 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.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 = 'SELTCONTR' AND t0.service_id = 53 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 = ?
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;

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

UPDATE sys_session_tmp SET update_time = '2026-09-14 20:44:59', menu_code = 'SELTCONTR', menu_title = 'Choisir votre numero de contrat:Aucun contrat pour votre numero!', next_menu_code = 'SELTPAY', menu_options_string = '-1,libelle,-1+1,Entrez un numero contrat,0', screen_id = 1, service_id = 53 WHERE id = 250575;

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 ('2026-09-14 20:44:58', 'MTNBJ', 'SLOYER', '17894150911350110', '2290162508291', '10.77.69.45', '4', 'Choisir votre numero de contrat:Aucun contrat pour votre numero!', '-1,libelle,-1+1,Entrez un numero contrat,0', 'SELTCONTR', 'INTERMEDIATE', '2026-09-14 20:44:59');

INSERT INTO smartloyer_session_tmp (
  session_id, msisdn, operator_id, create_time,
  update_time, contrat_id, contrat_ref,
  payement_id, payement_ref, payement_libelle,
  monatant_contrat, charge_fee_amount,
  transaction_total_amount, service_fee
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO smartloyer_session_tmp (session_id, msisdn, operator_id, create_time, update_time, contrat_id, contrat_ref, payement_id, payement_ref, payement_libelle, monatant_contrat, charge_fee_amount, transaction_total_amount, service_fee) VALUES ('17894150911350110', '2290162508291', 14, '2026-09-14 20:44:59', '2026-09-14 20:44:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);