Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

164.82 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	164.82 ms	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.service_fee_amount AS service_fee_amount_12, t0.last_ussd_message AS last_ussd_message_13, t0.sms_message AS sms_message_14, t0.sms_received AS sms_received_15, t0.sms_received_time AS sms_received_time_16, t0.is_success_transaction AS is_success_transaction_17, t0.is_client_paid AS is_client_paid_18, t0.client_payement_account AS client_payement_account_19, t0.client_payement_amount AS client_payement_amount_20, t0.client_payement_status AS client_payement_status_21, t0.client_payement_reference AS client_payement_reference_22, t0.client_payement_time AS client_payement_time_23, t0.client_payement_comment AS client_payement_comment_24, t0.additional_payemen_amount AS additional_payemen_amount_25, t0.additional_payement_account AS additional_payement_account_26, t0.additional_payement_reference AS additional_payement_reference_27, t0.additional_payement_time AS additional_payement_time_28, t0.additional_payement_comment AS additional_payement_comment_29, t0.partenariat_fee_amount AS partenariat_fee_amount_30, t0.is_partner_paid AS is_partner_paid_31, t0.partner_payement_account AS partner_payement_account_32, t0.partner_payement_amount AS partner_payement_amount_33, t0.partner_payement_status AS partner_payement_status_34, t0.partner_payement_reference AS partner_payement_reference_35, t0.partner_payement_time AS partner_payement_time_36, t0.partner_payement_comment AS partner_payement_comment_37, t0.is_closed AS is_closed_38, t0.close_time AS close_time_39, t0.close_comment AS close_comment_40, t0.client_auto_paid AS client_auto_paid_41, t0.partner_auto_paid AS partner_auto_paid_42, t0.payement_reference AS payement_reference_43, t0.email_notif AS email_notif_44, t0.operator_id AS operator_id_45, t0.service_id AS service_id_46, t0.client_payement_canal_id AS client_payement_canal_id_47, t0.additional_payement_canal_id AS additional_payement_canal_id_48, t0.partner_payement_canal_id AS partner_payement_canal_id_49, t0.close_status_id AS close_status_id_50, t0.last_update_user_id AS last_update_user_id_51, t0.partner_id AS partner_id_52 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.service_fee_amount AS service_fee_amount_12, t0.last_ussd_message AS last_ussd_message_13, t0.sms_message AS sms_message_14, t0.sms_received AS sms_received_15, t0.sms_received_time AS sms_received_time_16, t0.is_success_transaction AS is_success_transaction_17, t0.is_client_paid AS is_client_paid_18, t0.client_payement_account AS client_payement_account_19, t0.client_payement_amount AS client_payement_amount_20, t0.client_payement_status AS client_payement_status_21, t0.client_payement_reference AS client_payement_reference_22, t0.client_payement_time AS client_payement_time_23, t0.client_payement_comment AS client_payement_comment_24, t0.additional_payemen_amount AS additional_payemen_amount_25, t0.additional_payement_account AS additional_payement_account_26, t0.additional_payement_reference AS additional_payement_reference_27, t0.additional_payement_time AS additional_payement_time_28, t0.additional_payement_comment AS additional_payement_comment_29, t0.partenariat_fee_amount AS partenariat_fee_amount_30, t0.is_partner_paid AS is_partner_paid_31, t0.partner_payement_account AS partner_payement_account_32, t0.partner_payement_amount AS partner_payement_amount_33, t0.partner_payement_status AS partner_payement_status_34, t0.partner_payement_reference AS partner_payement_reference_35, t0.partner_payement_time AS partner_payement_time_36, t0.partner_payement_comment AS partner_payement_comment_37, t0.is_closed AS is_closed_38, t0.close_time AS close_time_39, t0.close_comment AS close_comment_40, t0.client_auto_paid AS client_auto_paid_41, t0.partner_auto_paid AS partner_auto_paid_42, t0.payement_reference AS payement_reference_43, t0.email_notif AS email_notif_44, t0.operator_id AS operator_id_45, t0.service_id AS service_id_46, t0.client_payement_canal_id AS client_payement_canal_id_47, t0.additional_payement_canal_id AS additional_payement_canal_id_48, t0.partner_payement_canal_id AS partner_payement_canal_id_49, t0.close_status_id AS close_status_id_50, t0.last_update_user_id AS last_update_user_id_51, t0.partner_id AS partner_id_52 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.service_fee_amount AS service_fee_amount_12, t0.last_ussd_message AS last_ussd_message_13, t0.sms_message AS sms_message_14, t0.sms_received AS sms_received_15, t0.sms_received_time AS sms_received_time_16, t0.is_success_transaction AS is_success_transaction_17, t0.is_client_paid AS is_client_paid_18, t0.client_payement_account AS client_payement_account_19, t0.client_payement_amount AS client_payement_amount_20, t0.client_payement_status AS client_payement_status_21, t0.client_payement_reference AS client_payement_reference_22, t0.client_payement_time AS client_payement_time_23, t0.client_payement_comment AS client_payement_comment_24, t0.additional_payemen_amount AS additional_payemen_amount_25, t0.additional_payement_account AS additional_payement_account_26, t0.additional_payement_reference AS additional_payement_reference_27, t0.additional_payement_time AS additional_payement_time_28, t0.additional_payement_comment AS additional_payement_comment_29, t0.partenariat_fee_amount AS partenariat_fee_amount_30, t0.is_partner_paid AS is_partner_paid_31, t0.partner_payement_account AS partner_payement_account_32, t0.partner_payement_amount AS partner_payement_amount_33, t0.partner_payement_status AS partner_payement_status_34, t0.partner_payement_reference AS partner_payement_reference_35, t0.partner_payement_time AS partner_payement_time_36, t0.partner_payement_comment AS partner_payement_comment_37, t0.is_closed AS is_closed_38, t0.close_time AS close_time_39, t0.close_comment AS close_comment_40, t0.client_auto_paid AS client_auto_paid_41, t0.partner_auto_paid AS partner_auto_paid_42, t0.payement_reference AS payement_reference_43, t0.email_notif AS email_notif_44, t0.operator_id AS operator_id_45, t0.service_id AS service_id_46, t0.client_payement_canal_id AS client_payement_canal_id_47, t0.additional_payement_canal_id AS additional_payement_canal_id_48, t0.partner_payement_canal_id AS partner_payement_canal_id_49, t0.close_status_id AS close_status_id_50, t0.last_update_user_id AS last_update_user_id_51, t0.partner_id AS partner_id_52 FROM sys_transaction t0 WHERE t0.client_payement_status = 'PENDING' AND t0.is_closed = 0;

#▲

Time

Info

164.82 ms

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.service_fee_amount AS service_fee_amount_12, t0.last_ussd_message AS last_ussd_message_13, t0.sms_message AS sms_message_14, t0.sms_received AS sms_received_15, t0.sms_received_time AS sms_received_time_16, t0.is_success_transaction AS is_success_transaction_17, t0.is_client_paid AS is_client_paid_18, t0.client_payement_account AS client_payement_account_19, t0.client_payement_amount AS client_payement_amount_20, t0.client_payement_status AS client_payement_status_21, t0.client_payement_reference AS client_payement_reference_22, t0.client_payement_time AS client_payement_time_23, t0.client_payement_comment AS client_payement_comment_24, t0.additional_payemen_amount AS additional_payemen_amount_25, t0.additional_payement_account AS additional_payement_account_26, t0.additional_payement_reference AS additional_payement_reference_27, t0.additional_payement_time AS additional_payement_time_28, t0.additional_payement_comment AS additional_payement_comment_29, t0.partenariat_fee_amount AS partenariat_fee_amount_30, t0.is_partner_paid AS is_partner_paid_31, t0.partner_payement_account AS partner_payement_account_32, t0.partner_payement_amount AS partner_payement_amount_33, t0.partner_payement_status AS partner_payement_status_34, t0.partner_payement_reference AS partner_payement_reference_35, t0.partner_payement_time AS partner_payement_time_36, t0.partner_payement_comment AS partner_payement_comment_37, t0.is_closed AS is_closed_38, t0.close_time AS close_time_39, t0.close_comment AS close_comment_40, t0.client_auto_paid AS client_auto_paid_41, t0.partner_auto_paid AS partner_auto_paid_42, t0.payement_reference AS payement_reference_43, t0.email_notif AS email_notif_44, t0.operator_id AS operator_id_45, t0.service_id AS service_id_46, t0.client_payement_canal_id AS client_payement_canal_id_47, t0.additional_payement_canal_id AS additional_payement_canal_id_48, t0.partner_payement_canal_id AS partner_payement_canal_id_49, t0.close_status_id AS close_status_id_50, t0.last_update_user_id AS last_update_user_id_51, t0.partner_id AS partner_id_52 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.service_fee_amount AS service_fee_amount_12,
  t0.last_ussd_message AS last_ussd_message_13,
  t0.sms_message AS sms_message_14,
  t0.sms_received AS sms_received_15,
  t0.sms_received_time AS sms_received_time_16,
  t0.is_success_transaction AS is_success_transaction_17,
  t0.is_client_paid AS is_client_paid_18,
  t0.client_payement_account AS client_payement_account_19,
  t0.client_payement_amount AS client_payement_amount_20,
  t0.client_payement_status AS client_payement_status_21,
  t0.client_payement_reference AS client_payement_reference_22,
  t0.client_payement_time AS client_payement_time_23,
  t0.client_payement_comment AS client_payement_comment_24,
  t0.additional_payemen_amount AS additional_payemen_amount_25,
  t0.additional_payement_account AS additional_payement_account_26,
  t0.additional_payement_reference AS additional_payement_reference_27,
  t0.additional_payement_time AS additional_payement_time_28,
  t0.additional_payement_comment AS additional_payement_comment_29,
  t0.partenariat_fee_amount AS partenariat_fee_amount_30,
  t0.is_partner_paid AS is_partner_paid_31,
  t0.partner_payement_account AS partner_payement_account_32,
  t0.partner_payement_amount AS partner_payement_amount_33,
  t0.partner_payement_status AS partner_payement_status_34,
  t0.partner_payement_reference AS partner_payement_reference_35,
  t0.partner_payement_time AS partner_payement_time_36,
  t0.partner_payement_comment AS partner_payement_comment_37,
  t0.is_closed AS is_closed_38,
  t0.close_time AS close_time_39,
  t0.close_comment AS close_comment_40,
  t0.client_auto_paid AS client_auto_paid_41,
  t0.partner_auto_paid AS partner_auto_paid_42,
  t0.payement_reference AS payement_reference_43,
  t0.email_notif AS email_notif_44,
  t0.operator_id AS operator_id_45,
  t0.service_id AS service_id_46,
  t0.client_payement_canal_id AS client_payement_canal_id_47,
  t0.additional_payement_canal_id AS additional_payement_canal_id_48,
  t0.partner_payement_canal_id AS partner_payement_canal_id_49,
  t0.close_status_id AS close_status_id_50,
  t0.last_update_user_id AS last_update_user_id_51,
  t0.partner_id AS partner_id_52
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.service_fee_amount AS service_fee_amount_12, t0.last_ussd_message AS last_ussd_message_13, t0.sms_message AS sms_message_14, t0.sms_received AS sms_received_15, t0.sms_received_time AS sms_received_time_16, t0.is_success_transaction AS is_success_transaction_17, t0.is_client_paid AS is_client_paid_18, t0.client_payement_account AS client_payement_account_19, t0.client_payement_amount AS client_payement_amount_20, t0.client_payement_status AS client_payement_status_21, t0.client_payement_reference AS client_payement_reference_22, t0.client_payement_time AS client_payement_time_23, t0.client_payement_comment AS client_payement_comment_24, t0.additional_payemen_amount AS additional_payemen_amount_25, t0.additional_payement_account AS additional_payement_account_26, t0.additional_payement_reference AS additional_payement_reference_27, t0.additional_payement_time AS additional_payement_time_28, t0.additional_payement_comment AS additional_payement_comment_29, t0.partenariat_fee_amount AS partenariat_fee_amount_30, t0.is_partner_paid AS is_partner_paid_31, t0.partner_payement_account AS partner_payement_account_32, t0.partner_payement_amount AS partner_payement_amount_33, t0.partner_payement_status AS partner_payement_status_34, t0.partner_payement_reference AS partner_payement_reference_35, t0.partner_payement_time AS partner_payement_time_36, t0.partner_payement_comment AS partner_payement_comment_37, t0.is_closed AS is_closed_38, t0.close_time AS close_time_39, t0.close_comment AS close_comment_40, t0.client_auto_paid AS client_auto_paid_41, t0.partner_auto_paid AS partner_auto_paid_42, t0.payement_reference AS payement_reference_43, t0.email_notif AS email_notif_44, t0.operator_id AS operator_id_45, t0.service_id AS service_id_46, t0.client_payement_canal_id AS client_payement_canal_id_47, t0.additional_payement_canal_id AS additional_payement_canal_id_48, t0.partner_payement_canal_id AS partner_payement_canal_id_49, t0.close_status_id AS close_status_id_50, t0.last_update_user_id AS last_update_user_id_51, t0.partner_id AS partner_id_52 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.

Symfony Profiler

http://144.91.67.100:6020/service/checkPaymentStatus

Configuration Settings

Theme