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 = '2290165326311' AND t0.session_id = '2080773005' 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 = 50;

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.msisdn AS msisdn_3,
  t0.date_voyage AS date_voyage_4,
  t0.montant AS montant_5,
  t0.create_time AS create_time_6,
  t0.operator_id AS operator_id_7,
  t0.ville_depart_id AS ville_depart_id_8,
  t0.ville_destination_id AS ville_destination_id_9,
  t0.compagnie_id AS compagnie_id_10,
  t0.heure_depart_id AS heure_depart_id_11,
  t0.point_depart_id AS point_depart_id_12,
  t0.trajet_id AS trajet_id_13
FROM
  bus_session_temp 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.date_voyage AS date_voyage_4, t0.montant AS montant_5, t0.create_time AS create_time_6, t0.operator_id AS operator_id_7, t0.ville_depart_id AS ville_depart_id_8, t0.ville_destination_id AS ville_destination_id_9, t0.compagnie_id AS compagnie_id_10, t0.heure_depart_id AS heure_depart_id_11, t0.point_depart_id AS point_depart_id_12, t0.trajet_id AS trajet_id_13 FROM bus_session_temp t0 WHERE t0.session_id = '2080773005' AND t0.msisdn = '2290165326311' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.compagnie_id AS compagnie_id_3,
  t0.ville_id AS ville_id_4
FROM
  bus_point_depart t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.compagnie_id AS compagnie_id_3, t0.ville_id AS ville_id_4 FROM bus_point_depart t0 WHERE t0.id = '78';

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  bus_session_temp
SET
  point_depart_id = ?
WHERE
  id = ?

UPDATE bus_session_temp SET point_depart_id = 78 WHERE id = 50149;

"COMMIT"

"COMMIT";

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 = ?
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 = 'BUS6' 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 = ?
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 = 'BUS6' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.heure_depart AS heure_depart_2,
  t0.point_depart_id AS point_depart_id_3,
  t0.trajet_id AS trajet_id_4
FROM
  bus_heure_depart t0
WHERE
  t0.trajet_id = ?
  AND t0.point_depart_id = ?

SELECT t0.id AS id_1, t0.heure_depart AS heure_depart_2, t0.point_depart_id AS point_depart_id_3, t0.trajet_id AS trajet_id_4 FROM bus_heure_depart t0 WHERE t0.trajet_id = 53 AND t0.point_depart_id = 78;

"START TRANSACTION"

"START TRANSACTION";

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

UPDATE sys_session_tmp SET update_time = '2025-11-04 13:36:33', menu_code = 'BUS6', menu_title = 'Choix de l\'heure depart', next_menu_code = 'BUSPAYE1', previous_menu_code = 'BUS5', menu_options_string = '-1,libelle,-1', screen_id = 6 WHERE id = 210447;

"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-11-04 13:36:33', 'MOOVBJ', 'TTBUS', '2080773005', '2290165326311', '144.91.67.100', '1', 'Choix de l\'heure depart', '-1,libelle,-1', 'BUS6', 'INTERMEDIATE', '2025-11-04 13:36:33');

"COMMIT"

"COMMIT";