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

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.msisdn AS msisdn_3,
  t0.date_film AS date_film_4,
  t0.libelle_film AS libelle_film_5,
  t0.code_resevation AS code_resevation_6,
  t0.categorie AS categorie_7,
  t0.update_date AS update_date_8
FROM
  cine_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_film AS date_film_4, t0.libelle_film AS libelle_film_5, t0.code_resevation AS code_resevation_6, t0.categorie AS categorie_7, t0.update_date AS update_date_8 FROM cine_session_temp t0 WHERE t0.session_id = '17894150481684045' AND t0.msisdn = '2290162508291' LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO cine_session_temp (
  session_id, msisdn, date_film, libelle_film,
  code_resevation, categorie, update_date
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO cine_session_temp (session_id, msisdn, date_film, libelle_film, code_resevation, categorie, update_date) VALUES ('17894150481684045', '2290162508291', '', '', '', 0, '2026-09-14 20:44:14');

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 = '51';

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 = 51 AND t0.level_order = 1 LIMIT 1;

DELETE FROM
  sys_session_tmp
WHERE
  id = ?

DELETE FROM sys_session_tmp WHERE id = 250573;

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 = 'TESTONLYTT' 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-09-14 20:44:14', 'MTNBJ', 'MAIN', '17894150481684045', '2290162508291', '10.77.69.46', '2', 'Pas d\'evenement ou concert disponible actuellement. Enregistrez un evenement ou concert en contactant nos services au 95203797', '-1,libelle,-1', 'TESTONLYTT', 'FINAL', '2026-09-14 20:44:14');

"START TRANSACTION"

"START TRANSACTION";