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 = '17894150711349983' 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 = '52';

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

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.msisdn AS msisdn_3,
  t0.nom_quartier AS nom_quartier_4,
  t0.service_total_amount AS service_total_amount_5,
  t0.charge_fee_amount AS charge_fee_amount_6,
  t0.is_confirmed AS is_confirmed_7,
  t0.create_time AS create_time_8,
  t0.update_time AS update_time_9,
  t0.transaction_total_amount AS transaction_total_amount_10,
  t0.date_livraison AS date_livraison_11,
  t0.service_transaction_amount AS service_transaction_amount_12,
  t0.operator_id AS operator_id_13,
  t0.service_id AS service_id_14,
  t0.ville_id AS ville_id_15,
  t0.marque_id AS marque_id_16,
  t0.type_id AS type_id_17,
  t0.prix_id AS prix_id_18
FROM
  gaz_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.nom_quartier AS nom_quartier_4, t0.service_total_amount AS service_total_amount_5, t0.charge_fee_amount AS charge_fee_amount_6, t0.is_confirmed AS is_confirmed_7, t0.create_time AS create_time_8, t0.update_time AS update_time_9, t0.transaction_total_amount AS transaction_total_amount_10, t0.date_livraison AS date_livraison_11, t0.service_transaction_amount AS service_transaction_amount_12, t0.operator_id AS operator_id_13, t0.service_id AS service_id_14, t0.ville_id AS ville_id_15, t0.marque_id AS marque_id_16, t0.type_id AS type_id_17, t0.prix_id AS prix_id_18 FROM gaz_session_temp t0 WHERE t0.session_id = '17894150711349983' 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;

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

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO gaz_session_temp (
  session_id, msisdn, nom_quartier,
  service_total_amount, charge_fee_amount,
  is_confirmed, create_time, update_time,
  transaction_total_amount, date_livraison,
  service_transaction_amount, operator_id,
  service_id, ville_id, marque_id,
  type_id, prix_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO gaz_session_temp (session_id, msisdn, nom_quartier, service_total_amount, charge_fee_amount, is_confirmed, create_time, update_time, transaction_total_amount, date_livraison, service_transaction_amount, operator_id, service_id, ville_id, marque_id, type_id, prix_id) VALUES ('17894150711349983', '2290162508291', '', 0, 0, NULL, '2026-09-14 20:44:36', '2026-09-14 20:44:36', 0, NULL, 0, 14, 52, NULL, NULL, NULL, NULL);

"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 = ?
  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 = 'TESTONLY' AND t0.service_id = 52 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO sys_transaction (
  create_time, first_session_create_time,
  session_id, msisdn, reference_id,
  reservation_code, fee_charge_amount,
  service_total_amount, service_transaction_amount,
  transaction_total_amount, service_fee_amount,
  last_ussd_message, sms_message,
  sms_received, sms_received_time,
  is_success_transaction, is_client_paid,
  client_payement_account, client_payement_amount,
  client_payement_status, client_payement_reference,
  client_payement_time, client_payement_comment,
  additional_payemen_amount, additional_payement_account,
  additional_payement_reference,
  additional_payement_time, additional_payement_comment,
  partenariat_fee_amount, is_partner_paid,
  partner_payement_account, partner_payement_amount,
  partner_payement_status, partner_payement_reference,
  partner_payement_time, partner_payement_comment,
  is_closed, close_time, close_comment,
  client_auto_paid, partner_auto_paid,
  payement_reference, email_notif,
  operator_id, service_id, client_payement_canal_id,
  additional_payement_canal_id, partner_payement_canal_id,
  close_status_id, last_update_user_id,
  partner_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

INSERT INTO sys_transaction (create_time, first_session_create_time, session_id, msisdn, reference_id, reservation_code, fee_charge_amount, service_total_amount, service_transaction_amount, transaction_total_amount, service_fee_amount, last_ussd_message, sms_message, sms_received, sms_received_time, is_success_transaction, is_client_paid, client_payement_account, client_payement_amount, client_payement_status, client_payement_reference, client_payement_time, client_payement_comment, additional_payemen_amount, additional_payement_account, additional_payement_reference, additional_payement_time, additional_payement_comment, partenariat_fee_amount, is_partner_paid, partner_payement_account, partner_payement_amount, partner_payement_status, partner_payement_reference, partner_payement_time, partner_payement_comment, is_closed, close_time, close_comment, client_auto_paid, partner_auto_paid, payement_reference, email_notif, operator_id, service_id, client_payement_canal_id, additional_payement_canal_id, partner_payement_canal_id, close_status_id, last_update_user_id, partner_id) VALUES ('2026-09-14 20:44:36', '2026-09-14 20:44:36', '17894150711349983', '2290162508291', 'NA', 'TESTONLY', 0, 0, 0, 0, 0, 'NA', 'Cher client, nous sommes temporairement en rupture de Gaz pour livraison. Nous ne pouvons donc vous satisfaire ce jour. Toutes nos excuses.', 0, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 0, 0, NULL, 0, NULL, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, NULL, NULL, 14, 52, NULL, NULL, NULL, NULL, NULL, NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  sys_transaction
SET
  reference_id = ?,
  last_ussd_message = ?,
  sms_message = ?,
  email_notif = ?
WHERE
  id = ?

UPDATE sys_transaction SET reference_id = '19152443662297', last_ussd_message = 'Cher client, nous sommes temporairement en rupture de Gaz pour livraison. Nous ne pouvons donc vous satisfaire ce jour. Toutes nos excuses.', sms_message = 'NA', email_notif = 'NA' WHERE id = 62297;

DELETE FROM
  gaz_session_temp
WHERE
  id = ?

DELETE FROM gaz_session_temp WHERE id = 32206;

"COMMIT"

"COMMIT";

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 = 49;

"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 ('2026-09-14 20:44:36', 'MTNBJ', 'MAIN', '17894150711349983', '2290162508291', '10.77.69.45', '3', 'Cher client, nous sommes temporairement en rupture de Gaz pour livraison. Nous ne pouvons donc vous satisfaire ce jour. Toutes nos excuses.', '-1,libelle,-1', 'TESTONLY', 'FINAL', '2026-09-14 20:44:36');

DELETE FROM
  sys_session_tmp
WHERE
  id = ?

DELETE FROM sys_session_tmp WHERE id = 250574;

"COMMIT"

"COMMIT";