Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.85 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.27 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.whitelist_ip AS whitelist_ip_4, t0.password AS password_5, t0.created AS created_6, t0.name AS name_7, t0.google_authenticator_enabled AS google_authenticator_enabled_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.totp_authentication_enabled AS totp_authentication_enabled_10, t0.static_password AS static_password_11, t0.status AS status_12, t0.merchant_id AS merchant_id_13, t0.user_group_id AS user_group_id_14, t0.retailer_id AS retailer_id_15 FROM user t0 WHERE t0.id = ? Parameters: [`123`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.whitelist_ip AS whitelist_ip_4, t0.password AS password_5, t0.created AS created_6, t0.name AS name_7, t0.google_authenticator_enabled AS google_authenticator_enabled_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.totp_authentication_enabled AS totp_authentication_enabled_10, t0.static_password AS static_password_11, t0.status AS status_12, t0.merchant_id AS merchant_id_13, t0.user_group_id AS user_group_id_14, t0.retailer_id AS retailer_id_15 FROM user t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.whitelist_ip AS whitelist_ip_4, t0.password AS password_5, t0.created AS created_6, t0.name AS name_7, t0.google_authenticator_enabled AS google_authenticator_enabled_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.totp_authentication_enabled AS totp_authentication_enabled_10, t0.static_password AS static_password_11, t0.status AS status_12, t0.merchant_id AS merchant_id_13, t0.user_group_id AS user_group_id_14, t0.retailer_id AS retailer_id_15 FROM user t0 WHERE t0.id = 123;
2	0.58 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.user_type AS user_type_4 FROM user_group t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.user_type AS user_type_4 FROM user_group t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.user_type AS user_type_4 FROM user_group t0 WHERE t0.id = 1;

#▲

Time

Info

1.27 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.whitelist_ip AS whitelist_ip_4, t0.password AS password_5, t0.created AS created_6, t0.name AS name_7, t0.google_authenticator_enabled AS google_authenticator_enabled_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.totp_authentication_enabled AS totp_authentication_enabled_10, t0.static_password AS static_password_11, t0.status AS status_12, t0.merchant_id AS merchant_id_13, t0.user_group_id AS user_group_id_14, t0.retailer_id AS retailer_id_15 FROM user t0 WHERE t0.id = ?

Parameters:

[
  123
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.whitelist_ip AS whitelist_ip_4,
  t0.password AS password_5,
  t0.created AS created_6,
  t0.name AS name_7,
  t0.google_authenticator_enabled AS google_authenticator_enabled_8,
  t0.google_authenticator_secret AS google_authenticator_secret_9,
  t0.totp_authentication_enabled AS totp_authentication_enabled_10,
  t0.static_password AS static_password_11,
  t0.status AS status_12,
  t0.merchant_id AS merchant_id_13,
  t0.user_group_id AS user_group_id_14,
  t0.retailer_id AS retailer_id_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.whitelist_ip AS whitelist_ip_4, t0.password AS password_5, t0.created AS created_6, t0.name AS name_7, t0.google_authenticator_enabled AS google_authenticator_enabled_8, t0.google_authenticator_secret AS google_authenticator_secret_9, t0.totp_authentication_enabled AS totp_authentication_enabled_10, t0.static_password AS static_password_11, t0.status AS status_12, t0.merchant_id AS merchant_id_13, t0.user_group_id AS user_group_id_14, t0.retailer_id AS retailer_id_15 FROM user t0 WHERE t0.id = 123;

0.58 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.user_type AS user_type_4 FROM user_group t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.roles AS roles_3,
  t0.user_type AS user_type_4
FROM
  user_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.user_type AS user_type_4 FROM user_group t0 WHERE t0.id = 1;

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\User	The field App\Entity\User#conversionRates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ConversionRates#user does not contain the required 'inversedBy="conversionRates"' attribute.
App\Entity\Merchants	The association App\Entity\Merchants#cardWhitelists refers to the owning side field App\Entity\CardWhitelist#mercahnt which does not exist.
App\Entity\UserGroup	No errors.
App\Entity\Retailer	No errors.
App\Entity\ConversionRates	No errors.
App\Entity\Rates	No errors.
App\Entity\FraudControl	No errors.
App\Entity\CardWhitelist	The mappings App\Entity\CardWhitelist#merchant and App\Entity\Merchants#cardWhitelists are inconsistent with each other.
App\Entity\MerchantWhitelist	No errors.
App\Entity\TransactionCommissions	The association App\Entity\TransactionCommissions#transaction refers to the inverse side field App\Entity\Transactions#transactionCommissions which does not exist.

Symfony Profiler

POST https://noidev.xinpay.org/office/fraud_blacklist/delete

Configuration Settings

Theme