Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.10 ms Query time

1 Invalid entities

Queries

Group similar statements

common connection

#▲	Time	Info
1	0.10 ms	SELECT t0.login AS login_1, t0.status AS status_2, t0.week_start AS week_start_3, t0.language AS language_4, t0.base_currency AS base_currency_5, t0.server AS server_6, t0.registration_datetime AS registration_datetime_7, t0.block_datetime AS block_datetime_8, t0.activation_datetime AS activation_datetime_9, t0.id AS id_10, t0.name AS name_11, t0.email AS email_12, t0.phone AS phone_13, t0.description AS description_14, t0.country AS country_15, t0.address AS address_16 FROM merchant t0 WHERE t0.login = ? LIMIT 1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT t0.login AS login_1, t0.status AS status_2, t0.week_start AS week_start_3, t0.language AS language_4, t0.base_currency AS base_currency_5, t0.server AS server_6, t0.registration_datetime AS registration_datetime_7, t0.block_datetime AS block_datetime_8, t0.activation_datetime AS activation_datetime_9, t0.id AS id_10, t0.name AS name_11, t0.email AS email_12, t0.phone AS phone_13, t0.description AS description_14, t0.country AS country_15, t0.address AS address_16 FROM merchant t0 WHERE t0.login = ? LIMIT 1 SELECT t0.login AS login_1, t0.status AS status_2, t0.week_start AS week_start_3, t0.language AS language_4, t0.base_currency AS base_currency_5, t0.server AS server_6, t0.registration_datetime AS registration_datetime_7, t0.block_datetime AS block_datetime_8, t0.activation_datetime AS activation_datetime_9, t0.id AS id_10, t0.name AS name_11, t0.email AS email_12, t0.phone AS phone_13, t0.description AS description_14, t0.country AS country_15, t0.address AS address_16 FROM merchant t0 WHERE t0.login = '' LIMIT 1;

#▲

Time

Info

0.10 ms

SELECT t0.login AS login_1, t0.status AS status_2, t0.week_start AS week_start_3, t0.language AS language_4, t0.base_currency AS base_currency_5, t0.server AS server_6, t0.registration_datetime AS registration_datetime_7, t0.block_datetime AS block_datetime_8, t0.activation_datetime AS activation_datetime_9, t0.id AS id_10, t0.name AS name_11, t0.email AS email_12, t0.phone AS phone_13, t0.description AS description_14, t0.country AS country_15, t0.address AS address_16 FROM merchant t0 WHERE t0.login = ? LIMIT 1

Parameters:

[
  ""
]

View formatted query View runnable query Explain query

SELECT
  t0.login AS login_1,
  t0.status AS status_2,
  t0.week_start AS week_start_3,
  t0.language AS language_4,
  t0.base_currency AS base_currency_5,
  t0.server AS server_6,
  t0.registration_datetime AS registration_datetime_7,
  t0.block_datetime AS block_datetime_8,
  t0.activation_datetime AS activation_datetime_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.email AS email_12,
  t0.phone AS phone_13,
  t0.description AS description_14,
  t0.country AS country_15,
  t0.address AS address_16
FROM
  merchant t0
WHERE
  t0.login = ?
LIMIT
  1

SELECT t0.login AS login_1, t0.status AS status_2, t0.week_start AS week_start_3, t0.language AS language_4, t0.base_currency AS base_currency_5, t0.server AS server_6, t0.registration_datetime AS registration_datetime_7, t0.block_datetime AS block_datetime_8, t0.activation_datetime AS activation_datetime_9, t0.id AS id_10, t0.name AS name_11, t0.email AS email_12, t0.phone AS phone_13, t0.description AS description_14, t0.country AS country_15, t0.address AS address_16 FROM merchant t0 WHERE t0.login = '' LIMIT 1;

Database Connections

Name	Service
common	doctrine.dbal.common_connection
merchant	doctrine.dbal.merchant_connection
lock	doctrine.dbal.lock_connection

Entity Managers

Name	Service
common	doctrine.orm.common_entity_manager
merchant	doctrine.orm.merchant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

common entity manager

Class	Mapping errors
App\Entity\Common\MerchantEntity	No errors.

merchant entity manager

Class	Mapping errors
App\Entity\Merchant\UserEntity	No errors.
App\Entity\Merchant\OrderEntity	The field App\Entity\Merchant\OrderEntity#freshbooksIntegrationStatusLog is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Merchant\FreshbooksRecordEntity#order does not contain the required 'inversedBy="freshbooksIntegrationStatusLog"' attribute.
App\Entity\Merchant\OrderReferenceEntity	No errors.
App\Entity\Merchant\CustomFeatureEntity	No errors.
App\Entity\Merchant\CustomFeatureConfigEntity	No errors.