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 = '2290167820517' AND t0.session_id = '17714067201354954' 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 = ?
  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 = '17714067201354954' AND t0.msisdn = '2290167820517' LIMIT 1;

"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 = 'BUS4' LIMIT 1;

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-02-18 10:26:06', 'MTNBJ', 'TTBUS', '17714067201354954', '2290167820517', '10.77.69.45', '2', 'Desole, nous nos disposons plus de ticket pour la destination choisie. Merci de ressayer prochainement. ', '-1,libelle,-1', 'BUSNOTICK', 'FINAL', '2026-02-18 10:26:06');

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.tarif AS tarif_3,
  t0.number_available AS number_available_4,
  t0.compagnie_id AS compagnie_id_5,
  t0.ville_depart_id AS ville_depart_id_6,
  t0.ville_destination_id AS ville_destination_id_7
FROM
  bus_trajet t0
WHERE
  t0.ville_depart_id = ?
  AND t0.ville_destination_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.tarif AS tarif_3, t0.number_available AS number_available_4, t0.compagnie_id AS compagnie_id_5, t0.ville_depart_id AS ville_depart_id_6, t0.ville_destination_id AS ville_destination_id_7 FROM bus_trajet t0 WHERE t0.ville_depart_id = 30 AND t0.ville_destination_id = 26;

INSERT INTO bus_transaction (
  creation_time, msisdn, resevation_code,
  transaction_amount, is_client_payed,
  date_depart, status, comment, ville_depart_id,
  ville_destination_id, compagnie_id,
  point_depart_id, trajet_id, sys_transaction_id,
  heure_depart_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO bus_transaction (creation_time, msisdn, resevation_code, transaction_amount, is_client_payed, date_depart, status, comment, ville_depart_id, ville_destination_id, compagnie_id, point_depart_id, trajet_id, sys_transaction_id, heure_depart_id) VALUES ('2026-02-18 10:26:06', '2290167820517', 'null', '0', 0, NULL, 'FAILURE', 'NO BUS COMPANY', 30, 26, NULL, NULL, NULL, NULL, NULL);

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;

DELETE FROM
  sys_session_tmp
WHERE
  id = ?

DELETE FROM sys_session_tmp WHERE id = 223593;

UPDATE
  bus_session_temp
SET
  date_voyage = ?
WHERE
  id = ?

UPDATE bus_session_temp SET date_voyage = '2026-02-19' WHERE id = 54956;