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 = '22998429160' AND t0.session_id = '1960163419' 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.enable = ?
ORDER BY
  t0.order_number ASC

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.enable = 1 ORDER BY t0.order_number ASC;

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 = 'MOOVBJ' 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 = 'MAIN' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sys_session_tmp (
  session_id, msisdn, create_time, update_time,
  menu_code, menu_title, next_menu_code,
  previous_menu_code, is_input_request,
  menu_options_string, screen_id,
  operator_id, service_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO sys_session_tmp (session_id, msisdn, create_time, update_time, menu_code, menu_title, next_menu_code, previous_menu_code, is_input_request, menu_options_string, screen_id, operator_id, service_id) VALUES ('1960163419', '22998429160', '2024-09-28 15:18:04', '2024-09-28 15:18:04', 'MAIN', 'Bienvenu sur ReservLine', 'MAIN', 'MAIN', 0, '-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', 0, 13, 49);

"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 ('2024-09-28 15:18:04', 'MOOVBJ', '0', '1960163419', '22998429160', '144.91.67.100', '', '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', 'INTIAL', '2024-09-28 15:18:04');

"COMMIT"

"COMMIT";