Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.52 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	1.52 ms	SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.active AS active_2, p0_.iso_code AS iso_code_3, p0_.language_code AS language_code_4, p0_.date_format_lite AS date_format_lite_5, p0_.date_format_full AS date_format_full_6, p0_.dictionary AS dictionary_7, p0_.currency_format AS currency_format_8, p0_.iso_code_real AS iso_code_real_9, p0_.name_english AS name_english_10 FROM ps_lang p0_ WHERE p0_.iso_code = ? Parameters: [`"en"`] View formatted query View runnable query Explain query SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.active AS active_2, p0_.iso_code AS iso_code_3, p0_.language_code AS language_code_4, p0_.date_format_lite AS date_format_lite_5, p0_.date_format_full AS date_format_full_6, p0_.dictionary AS dictionary_7, p0_.currency_format AS currency_format_8, p0_.iso_code_real AS iso_code_real_9, p0_.name_english AS name_english_10 FROM ps_lang p0_ WHERE p0_.iso_code = ? SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.active AS active_2, p0_.iso_code AS iso_code_3, p0_.language_code AS language_code_4, p0_.date_format_lite AS date_format_lite_5, p0_.date_format_full AS date_format_full_6, p0_.dictionary AS dictionary_7, p0_.currency_format AS currency_format_8, p0_.iso_code_real AS iso_code_real_9, p0_.name_english AS name_english_10 FROM ps_lang p0_ WHERE p0_.iso_code = 'en';

#▲

Time

Info

1.52 ms

SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.active AS active_2, p0_.iso_code AS iso_code_3, p0_.language_code AS language_code_4, p0_.date_format_lite AS date_format_lite_5, p0_.date_format_full AS date_format_full_6, p0_.dictionary AS dictionary_7, p0_.currency_format AS currency_format_8, p0_.iso_code_real AS iso_code_real_9, p0_.name_english AS name_english_10 FROM ps_lang p0_ WHERE p0_.iso_code = ?

Parameters:

[
  "en"
]

View formatted query View runnable query Explain query

SELECT
  p0_.id_lang AS id_lang_0,
  p0_.name AS name_1,
  p0_.active AS active_2,
  p0_.iso_code AS iso_code_3,
  p0_.language_code AS language_code_4,
  p0_.date_format_lite AS date_format_lite_5,
  p0_.date_format_full AS date_format_full_6,
  p0_.dictionary AS dictionary_7,
  p0_.currency_format AS currency_format_8,
  p0_.iso_code_real AS iso_code_real_9,
  p0_.name_english AS name_english_10
FROM
  ps_lang p0_
WHERE
  p0_.iso_code = ?

SELECT p0_.id_lang AS id_lang_0, p0_.name AS name_1, p0_.active AS active_2, p0_.iso_code AS iso_code_3, p0_.language_code AS language_code_4, p0_.date_format_lite AS date_format_lite_5, p0_.date_format_full AS date_format_full_6, p0_.dictionary AS dictionary_7, p0_.currency_format AS currency_format_8, p0_.iso_code_real AS iso_code_real_9, p0_.name_english AS name_english_10 FROM ps_lang p0_ WHERE p0_.iso_code = 'en';

Database Connections

Name	Service
default	doctrine.dbal.default_connection
report	doctrine.dbal.report_connection
logs	doctrine.dbal.logs_connection

Entity Managers

Name	Service
auto_generate_proxy_classes	doctrine.orm.auto_generate_proxy_classes_entity_manager
default	doctrine.orm.default_entity_manager
report	doctrine.orm.report_entity_manager
logs	doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

auto_generate_proxy_classes entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\System\Employee	No errors.
App\Entity\System\Customer	No errors.
App\Entity\System\ServiceCustomerParameter	No errors.
App\Entity\System\ServiceCustomer	No errors.
App\Entity\System\Supplier	No errors.
App\Entity\System\Warehouse	No errors.
App\Entity\System\Product	No errors.
App\Entity\System\ProductStock	No errors.
App\Entity\System\Language	No errors.
App\Entity\System\CmsLanguage	No errors.
App\Entity\System\TaxonomyLanguage	No errors.
App\Entity\System\BrandLanguage	No errors.
App\Entity\System\ProductImage	No errors.
App\Entity\System\CategoryLang	No errors.
App\Entity\System\Catalog	No errors.
App\Entity\System\PackLanguage	No errors.
App\Entity\System\SubscriptionLine	No errors.
App\Entity\System\MultifactorAuth	No errors.
App\Entity\System\Carrier	No errors.
App\Entity\System\Tracking	No errors.
App\Entity\System\OrderNotification	No errors.
App\Entity\System\CountryLanguage	No errors.
App\Entity\System\TaxRuleGroup	No errors.
App\Entity\System\TaxRule	No errors.
App\Entity\System\CustomerAnswer	No errors.
App\Entity\System\SubscriptionLineHistory	No errors.
App\Entity\System\EncryptionKey	No errors.
App\Entity\System\AdminAcl	No errors.
App\Entity\System\Answer	No errors.
App\Entity\System\Question	No errors.
App\Entity\System\CustomerApi	No errors.
App\Entity\System\ApiResponseTime	No errors.
App\Entity\System\TapfiliateCustomer	No errors.

report entity manager

Class	Mapping errors
App\Entity\Report\CustomerAuthenticationAccessControl	No errors.
App\Entity\Report\CustomerAuthenticationAccessControlLog	No errors.

logs entity manager

Class	Mapping errors
App\Entity\Logs\CustomerExternalReferer	No errors.
App\Entity\Logs\AdyenPaymentLink	No errors.