Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.07 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
1.07 ms (100.00%)	1	SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1 Parameters: [`"es"`] View formatted query View runnable query Explain query SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1 SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'es' LIMIT 1;

Time▼

Count

Info

1.07 ms
(100.00%)

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1

Parameters:

[
  "es"
]

View formatted query View runnable query Explain query

SELECT
  t0.id_lang AS id_lang_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.iso_code AS iso_code_4,
  t0.language_code AS language_code_5,
  t0.date_format_lite AS date_format_lite_6,
  t0.date_format_full AS date_format_full_7,
  t0.dictionary AS dictionary_8,
  t0.currency_format AS currency_format_9,
  t0.iso_code_real AS iso_code_real_10,
  t0.name_english AS name_english_11
FROM
  ps_lang t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = 'es' LIMIT 1;

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\Configuration	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\Product	No errors.
App\Entity\System\Catalog	No errors.
App\Entity\System\Order	No errors.
App\Entity\System\Address	No errors.
App\Entity\System\Country	No errors.
App\Entity\System\MultifactorAuth	No errors.
App\Entity\System\Carrier	No errors.
App\Entity\System\Tracking	No errors.
App\Entity\System\Department	No errors.
App\Entity\System\Lock	No errors.
App\Entity\System\Cart	No errors.
App\Entity\System\Pack	No errors.
App\Entity\System\OrderNotification	No errors.
App\Entity\System\PaymentMethod	No errors.
App\Entity\System\CountryLanguage	No errors.
App\Entity\System\TaxRuleGroup	No errors.
App\Entity\System\TaxRule	No errors.
App\Entity\System\AdminAcl	No errors.
App\Entity\System\Answer	No errors.
App\Entity\System\Question	No errors.
App\Entity\System\ProductAttribute	No errors.
App\Entity\System\CarrierMaster	No errors.
App\Entity\System\OrderBankwire	No errors.
App\Entity\System\ProductDocument	No errors.
App\Entity\System\Invoice	No errors.
App\Entity\System\OrderInvoiceCustomer	No errors.
App\Entity\System\ViesValidationLog	No errors.
App\Entity\System\Tax	No errors.
App\Entity\System\TaxLanguage	No errors.
App\Entity\System\State	No errors.
App\Entity\System\Service	No errors.
App\Entity\System\CustomerApi	No errors.
App\Entity\System\SeoData	No errors.
App\Entity\System\Subscription	No errors.
App\Entity\System\SubscriptionData	No errors.
App\Entity\System\SubscriptionType	No errors.
App\Entity\System\TapfiliateCustomer	No errors.
App\Entity\System\CodeDiscount	No errors.
App\Entity\System\SubscriptionLine	No errors.
App\Entity\System\ServiceProduct	No errors.
App\Entity\System\Role	No errors.
App\Entity\System\SynchronisedShopStatusRegistry	No errors.
App\Entity\System\SynchronisedShopStatus	No errors.
App\Entity\System\SynchronisedShopConfiguration	No errors.
App\Entity\System\CartProduct	No errors.
App\Entity\System\SubscriptionCustomer	No errors.
App\Entity\System\SubscriptionStatus	No errors.
App\Entity\System\SubscriptionCustomerType	No errors.
App\Entity\System\SubscriptionCustomerHistory	No errors.
App\Entity\System\SubscriptionCustomerHistoryType	No errors.
App\Entity\System\SubscriptionLineHistory	No errors.
App\Entity\System\OrderDetail	No errors.
App\Entity\System\Group	No errors.
App\Entity\System\FuturePack	No errors.
App\Entity\System\SubscriptionGroup	No errors.
App\Entity\System\StockAvailable	No errors.
App\Entity\System\MinimumOrderQuantity	No errors.
App\Entity\System\SpecificPrice	No errors.
App\Entity\System\Warehouse	No errors.
App\Entity\System\Discount	No errors.
App\Entity\System\ProductPack	No errors.
App\Entity\System\Supplier	No errors.
App\Entity\System\AccountingMoneybox	No errors.
App\Entity\System\ApiResponseTime	No errors.

report entity manager

Class	Mapping errors
App\Entity\Report\CustomerAuthenticationAccessControl	No errors.
App\Entity\Report\CustomerAuthenticationAccessControlLog	No errors.
App\Entity\Report\SubscriptionRenew	No errors.
App\Entity\Report\SubscriptionRenewSubscriptionLine	No errors.
App\Entity\Report\StripeSubscription	No errors.
App\Entity\Report\StripeCustomer	No errors.
App\Entity\Report\OrderTransaction	No errors.

logs entity manager

Class	Mapping errors
App\Entity\Logs\PayPalIpnResponse	No errors.
App\Entity\Logs\PayPalRequest	No errors.
App\Entity\Logs\PayPalLog	No errors.
App\Entity\Logs\PayPalError	No errors.
App\Entity\Logs\PayPalLogError	No errors.
App\Entity\Logs\PaypalResponseIpn	No errors.
App\Entity\Logs\PayPalHistoryEmail	No errors.
App\Entity\Logs\Vies	No errors.
App\Entity\Logs\AdyenNotification	No errors.