Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

134.36 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
134.36 ms (100.00%)	1	SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.first_session_create_time AS first_session_create_time_3, t0.session_id AS session_id_4, t0.msisdn AS msisdn_5, t0.reference_id AS reference_id_6, t0.reservation_code AS reservation_code_7, t0.fee_charge_amount AS fee_charge_amount_8, t0.service_total_amount AS service_total_amount_9, t0.service_transaction_amount AS service_transaction_amount_10, t0.transaction_total_amount AS transaction_total_amount_11, t0.last_ussd_message AS last_ussd_message_12, t0.sms_message AS sms_message_13, t0.sms_received AS sms_received_14, t0.sms_received_time AS sms_received_time_15, t0.is_success_transaction AS is_success_transaction_16, t0.is_client_paid AS is_client_paid_17, t0.client_payement_account AS client_payement_account_18, t0.client_payement_amount AS client_payement_amount_19, t0.client_payement_status AS client_payement_status_20, t0.client_payement_reference AS client_payement_reference_21, t0.client_payement_time AS client_payement_time_22, t0.client_payement_comment AS client_payement_comment_23, t0.additional_payemen_amount AS additional_payemen_amount_24, t0.additional_payement_account AS additional_payement_account_25, t0.additional_payement_reference AS additional_payement_reference_26, t0.additional_payement_time AS additional_payement_time_27, t0.additional_payement_comment AS additional_payement_comment_28, t0.partenariat_fee_amount AS partenariat_fee_amount_29, t0.is_partner_paid AS is_partner_paid_30, t0.partner_payement_account AS partner_payement_account_31, t0.partner_payement_amount AS partner_payement_amount_32, t0.partner_payement_status AS partner_payement_status_33, t0.partner_payement_reference AS partner_payement_reference_34, t0.partner_payement_time AS partner_payement_time_35, t0.partner_payement_comment AS partner_payement_comment_36, t0.is_closed AS is_closed_37, t0.close_time AS close_time_38, t0.close_comment AS close_comment_39, t0.client_auto_paid AS client_auto_paid_40, t0.partner_auto_paid AS partner_auto_paid_41, t0.payement_reference AS payement_reference_42, t0.email_notif AS email_notif_43, t0.operator_id AS operator_id_44, t0.service_id AS service_id_45, t0.client_payement_canal_id AS client_payement_canal_id_46, t0.additional_payement_canal_id AS additional_payement_canal_id_47, t0.partner_payement_canal_id AS partner_payement_canal_id_48, t0.close_status_id AS close_status_id_49, t0.last_update_user_id AS last_update_user_id_50, t0.partner_id AS partner_id_51 FROM sys_transaction t0 WHERE t0.client_payement_status = ? AND t0.is_closed = ? Parameters: [`"PENDING" 0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.first_session_create_time AS first_session_create_time_3, t0.session_id AS session_id_4, t0.msisdn AS msisdn_5, t0.reference_id AS reference_id_6, t0.reservation_code AS reservation_code_7, t0.fee_charge_amount AS fee_charge_amount_8, t0.service_total_amount AS service_total_amount_9, t0.service_transaction_amount AS service_transaction_amount_10, t0.transaction_total_amount AS transaction_total_amount_11, t0.last_ussd_message AS last_ussd_message_12, t0.sms_message AS sms_message_13, t0.sms_received AS sms_received_14, t0.sms_received_time AS sms_received_time_15, t0.is_success_transaction AS is_success_transaction_16, t0.is_client_paid AS is_client_paid_17, t0.client_payement_account AS client_payement_account_18, t0.client_payement_amount AS client_payement_amount_19, t0.client_payement_status AS client_payement_status_20, t0.client_payement_reference AS client_payement_reference_21, t0.client_payement_time AS client_payement_time_22, t0.client_payement_comment AS client_payement_comment_23, t0.additional_payemen_amount AS additional_payemen_amount_24, t0.additional_payement_account AS additional_payement_account_25, t0.additional_payement_reference AS additional_payement_reference_26, t0.additional_payement_time AS additional_payement_time_27, t0.additional_payement_comment AS additional_payement_comment_28, t0.partenariat_fee_amount AS partenariat_fee_amount_29, t0.is_partner_paid AS is_partner_paid_30, t0.partner_payement_account AS partner_payement_account_31, t0.partner_payement_amount AS partner_payement_amount_32, t0.partner_payement_status AS partner_payement_status_33, t0.partner_payement_reference AS partner_payement_reference_34, t0.partner_payement_time AS partner_payement_time_35, t0.partner_payement_comment AS partner_payement_comment_36, t0.is_closed AS is_closed_37, t0.close_time AS close_time_38, t0.close_comment AS close_comment_39, t0.client_auto_paid AS client_auto_paid_40, t0.partner_auto_paid AS partner_auto_paid_41, t0.payement_reference AS payement_reference_42, t0.email_notif AS email_notif_43, t0.operator_id AS operator_id_44, t0.service_id AS service_id_45, t0.client_payement_canal_id AS client_payement_canal_id_46, t0.additional_payement_canal_id AS additional_payement_canal_id_47, t0.partner_payement_canal_id AS partner_payement_canal_id_48, t0.close_status_id AS close_status_id_49, t0.last_update_user_id AS last_update_user_id_50, t0.partner_id AS partner_id_51 FROM sys_transaction t0 WHERE t0.client_payement_status = ? AND t0.is_closed = ? SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.first_session_create_time AS first_session_create_time_3, t0.session_id AS session_id_4, t0.msisdn AS msisdn_5, t0.reference_id AS reference_id_6, t0.reservation_code AS reservation_code_7, t0.fee_charge_amount AS fee_charge_amount_8, t0.service_total_amount AS service_total_amount_9, t0.service_transaction_amount AS service_transaction_amount_10, t0.transaction_total_amount AS transaction_total_amount_11, t0.last_ussd_message AS last_ussd_message_12, t0.sms_message AS sms_message_13, t0.sms_received AS sms_received_14, t0.sms_received_time AS sms_received_time_15, t0.is_success_transaction AS is_success_transaction_16, t0.is_client_paid AS is_client_paid_17, t0.client_payement_account AS client_payement_account_18, t0.client_payement_amount AS client_payement_amount_19, t0.client_payement_status AS client_payement_status_20, t0.client_payement_reference AS client_payement_reference_21, t0.client_payement_time AS client_payement_time_22, t0.client_payement_comment AS client_payement_comment_23, t0.additional_payemen_amount AS additional_payemen_amount_24, t0.additional_payement_account AS additional_payement_account_25, t0.additional_payement_reference AS additional_payement_reference_26, t0.additional_payement_time AS additional_payement_time_27, t0.additional_payement_comment AS additional_payement_comment_28, t0.partenariat_fee_amount AS partenariat_fee_amount_29, t0.is_partner_paid AS is_partner_paid_30, t0.partner_payement_account AS partner_payement_account_31, t0.partner_payement_amount AS partner_payement_amount_32, t0.partner_payement_status AS partner_payement_status_33, t0.partner_payement_reference AS partner_payement_reference_34, t0.partner_payement_time AS partner_payement_time_35, t0.partner_payement_comment AS partner_payement_comment_36, t0.is_closed AS is_closed_37, t0.close_time AS close_time_38, t0.close_comment AS close_comment_39, t0.client_auto_paid AS client_auto_paid_40, t0.partner_auto_paid AS partner_auto_paid_41, t0.payement_reference AS payement_reference_42, t0.email_notif AS email_notif_43, t0.operator_id AS operator_id_44, t0.service_id AS service_id_45, t0.client_payement_canal_id AS client_payement_canal_id_46, t0.additional_payement_canal_id AS additional_payement_canal_id_47, t0.partner_payement_canal_id AS partner_payement_canal_id_48, t0.close_status_id AS close_status_id_49, t0.last_update_user_id AS last_update_user_id_50, t0.partner_id AS partner_id_51 FROM sys_transaction t0 WHERE t0.client_payement_status = 'PENDING' AND t0.is_closed = 0;

Time▼

Count

Info

134.36 ms
(100.00%)

SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.first_session_create_time AS first_session_create_time_3, t0.session_id AS session_id_4, t0.msisdn AS msisdn_5, t0.reference_id AS reference_id_6, t0.reservation_code AS reservation_code_7, t0.fee_charge_amount AS fee_charge_amount_8, t0.service_total_amount AS service_total_amount_9, t0.service_transaction_amount AS service_transaction_amount_10, t0.transaction_total_amount AS transaction_total_amount_11, t0.last_ussd_message AS last_ussd_message_12, t0.sms_message AS sms_message_13, t0.sms_received AS sms_received_14, t0.sms_received_time AS sms_received_time_15, t0.is_success_transaction AS is_success_transaction_16, t0.is_client_paid AS is_client_paid_17, t0.client_payement_account AS client_payement_account_18, t0.client_payement_amount AS client_payement_amount_19, t0.client_payement_status AS client_payement_status_20, t0.client_payement_reference AS client_payement_reference_21, t0.client_payement_time AS client_payement_time_22, t0.client_payement_comment AS client_payement_comment_23, t0.additional_payemen_amount AS additional_payemen_amount_24, t0.additional_payement_account AS additional_payement_account_25, t0.additional_payement_reference AS additional_payement_reference_26, t0.additional_payement_time AS additional_payement_time_27, t0.additional_payement_comment AS additional_payement_comment_28, t0.partenariat_fee_amount AS partenariat_fee_amount_29, t0.is_partner_paid AS is_partner_paid_30, t0.partner_payement_account AS partner_payement_account_31, t0.partner_payement_amount AS partner_payement_amount_32, t0.partner_payement_status AS partner_payement_status_33, t0.partner_payement_reference AS partner_payement_reference_34, t0.partner_payement_time AS partner_payement_time_35, t0.partner_payement_comment AS partner_payement_comment_36, t0.is_closed AS is_closed_37, t0.close_time AS close_time_38, t0.close_comment AS close_comment_39, t0.client_auto_paid AS client_auto_paid_40, t0.partner_auto_paid AS partner_auto_paid_41, t0.payement_reference AS payement_reference_42, t0.email_notif AS email_notif_43, t0.operator_id AS operator_id_44, t0.service_id AS service_id_45, t0.client_payement_canal_id AS client_payement_canal_id_46, t0.additional_payement_canal_id AS additional_payement_canal_id_47, t0.partner_payement_canal_id AS partner_payement_canal_id_48, t0.close_status_id AS close_status_id_49, t0.last_update_user_id AS last_update_user_id_50, t0.partner_id AS partner_id_51 FROM sys_transaction t0 WHERE t0.client_payement_status = ? AND t0.is_closed = ?

Parameters:

[
  "PENDING"
  0
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.create_time AS create_time_2,
  t0.first_session_create_time AS first_session_create_time_3,
  t0.session_id AS session_id_4,
  t0.msisdn AS msisdn_5,
  t0.reference_id AS reference_id_6,
  t0.reservation_code AS reservation_code_7,
  t0.fee_charge_amount AS fee_charge_amount_8,
  t0.service_total_amount AS service_total_amount_9,
  t0.service_transaction_amount AS service_transaction_amount_10,
  t0.transaction_total_amount AS transaction_total_amount_11,
  t0.last_ussd_message AS last_ussd_message_12,
  t0.sms_message AS sms_message_13,
  t0.sms_received AS sms_received_14,
  t0.sms_received_time AS sms_received_time_15,
  t0.is_success_transaction AS is_success_transaction_16,
  t0.is_client_paid AS is_client_paid_17,
  t0.client_payement_account AS client_payement_account_18,
  t0.client_payement_amount AS client_payement_amount_19,
  t0.client_payement_status AS client_payement_status_20,
  t0.client_payement_reference AS client_payement_reference_21,
  t0.client_payement_time AS client_payement_time_22,
  t0.client_payement_comment AS client_payement_comment_23,
  t0.additional_payemen_amount AS additional_payemen_amount_24,
  t0.additional_payement_account AS additional_payement_account_25,
  t0.additional_payement_reference AS additional_payement_reference_26,
  t0.additional_payement_time AS additional_payement_time_27,
  t0.additional_payement_comment AS additional_payement_comment_28,
  t0.partenariat_fee_amount AS partenariat_fee_amount_29,
  t0.is_partner_paid AS is_partner_paid_30,
  t0.partner_payement_account AS partner_payement_account_31,
  t0.partner_payement_amount AS partner_payement_amount_32,
  t0.partner_payement_status AS partner_payement_status_33,
  t0.partner_payement_reference AS partner_payement_reference_34,
  t0.partner_payement_time AS partner_payement_time_35,
  t0.partner_payement_comment AS partner_payement_comment_36,
  t0.is_closed AS is_closed_37,
  t0.close_time AS close_time_38,
  t0.close_comment AS close_comment_39,
  t0.client_auto_paid AS client_auto_paid_40,
  t0.partner_auto_paid AS partner_auto_paid_41,
  t0.payement_reference AS payement_reference_42,
  t0.email_notif AS email_notif_43,
  t0.operator_id AS operator_id_44,
  t0.service_id AS service_id_45,
  t0.client_payement_canal_id AS client_payement_canal_id_46,
  t0.additional_payement_canal_id AS additional_payement_canal_id_47,
  t0.partner_payement_canal_id AS partner_payement_canal_id_48,
  t0.close_status_id AS close_status_id_49,
  t0.last_update_user_id AS last_update_user_id_50,
  t0.partner_id AS partner_id_51
FROM
  sys_transaction t0
WHERE
  t0.client_payement_status = ?
  AND t0.is_closed = ?

SELECT t0.id AS id_1, t0.create_time AS create_time_2, t0.first_session_create_time AS first_session_create_time_3, t0.session_id AS session_id_4, t0.msisdn AS msisdn_5, t0.reference_id AS reference_id_6, t0.reservation_code AS reservation_code_7, t0.fee_charge_amount AS fee_charge_amount_8, t0.service_total_amount AS service_total_amount_9, t0.service_transaction_amount AS service_transaction_amount_10, t0.transaction_total_amount AS transaction_total_amount_11, t0.last_ussd_message AS last_ussd_message_12, t0.sms_message AS sms_message_13, t0.sms_received AS sms_received_14, t0.sms_received_time AS sms_received_time_15, t0.is_success_transaction AS is_success_transaction_16, t0.is_client_paid AS is_client_paid_17, t0.client_payement_account AS client_payement_account_18, t0.client_payement_amount AS client_payement_amount_19, t0.client_payement_status AS client_payement_status_20, t0.client_payement_reference AS client_payement_reference_21, t0.client_payement_time AS client_payement_time_22, t0.client_payement_comment AS client_payement_comment_23, t0.additional_payemen_amount AS additional_payemen_amount_24, t0.additional_payement_account AS additional_payement_account_25, t0.additional_payement_reference AS additional_payement_reference_26, t0.additional_payement_time AS additional_payement_time_27, t0.additional_payement_comment AS additional_payement_comment_28, t0.partenariat_fee_amount AS partenariat_fee_amount_29, t0.is_partner_paid AS is_partner_paid_30, t0.partner_payement_account AS partner_payement_account_31, t0.partner_payement_amount AS partner_payement_amount_32, t0.partner_payement_status AS partner_payement_status_33, t0.partner_payement_reference AS partner_payement_reference_34, t0.partner_payement_time AS partner_payement_time_35, t0.partner_payement_comment AS partner_payement_comment_36, t0.is_closed AS is_closed_37, t0.close_time AS close_time_38, t0.close_comment AS close_comment_39, t0.client_auto_paid AS client_auto_paid_40, t0.partner_auto_paid AS partner_auto_paid_41, t0.payement_reference AS payement_reference_42, t0.email_notif AS email_notif_43, t0.operator_id AS operator_id_44, t0.service_id AS service_id_45, t0.client_payement_canal_id AS client_payement_canal_id_46, t0.additional_payement_canal_id AS additional_payement_canal_id_47, t0.partner_payement_canal_id AS partner_payement_canal_id_48, t0.close_status_id AS close_status_id_49, t0.last_update_user_id AS last_update_user_id_50, t0.partner_id AS partner_id_51 FROM sys_transaction t0 WHERE t0.client_payement_status = 'PENDING' AND t0.is_closed = 0;

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\SysTransaction	No errors.
App\Entity\SysOperatorGSM	The association App\Entity\SysOperatorGSM#sysSessionTmps refers to the owning side field App\Entity\SysSessionTmp#operatorCode which does not exist.
App\Entity\SysService	No errors.
App\Entity\SysPayementCanal	No errors.
App\Entity\SysCloseStatus	No errors.
App\Entity\SysUser	No errors.
App\Entity\SysPartner	The association App\Entity\SysPartner#gazTransactions refers to the owning side field App\Entity\GazTransaction#partner which does not exist.
App\Entity\SysSmsHistory	No errors.

Symfony Profiler

http://144.91.67.100:6020/service/checkPaymentStatus

Configuration Settings

Theme