Query Metrics
5
Database Queries
5
Different statements
75.61 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 72.21 ms |
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
Parameters:
[ "22966458006" "17275256210422226" ] |
2 | 0.54 ms |
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 = ?
Parameters:
[
49
]
|
3 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
4 | 0.32 ms |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "2024-09-28 13:13:54" 2 => "MTNBJ" 3 => "MAIN" 4 => "17275256210422226" 5 => "22966458006" 6 => "10.77.69.12" 7 => "22222" 8 => """ Choix incorrect, Reessayez:\n Bienvenu sur ReservLine """ 9 => "-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" 10 => "MAIN" 11 => "INTERMEDIATE" 12 => "2024-09-28 13:13:54" ] |
5 | 2.41 ms |
"COMMIT"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\SysSessionTmp |
|
App\Entity\SysOperatorGSM |
|
App\Entity\SysService | No errors. |
App\Entity\SysUssdMenu | No errors. |
App\Entity\SysPartner |
|
App\Entity\SysCloseStatus | No errors. |
App\Entity\MobileBipUser | No errors. |
App\Entity\SysUssdHistory | No errors. |