Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

1 Different statements

3.70 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.55 ms	SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1 Parameters: [`"API" "token_read"`] View formatted query View runnable query Explain query SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1 SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = 'API' AND t0.name = 'token_read' LIMIT 1;
2	2.77 ms	SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1 Parameters: [`"API" "token_all"`] View formatted query View runnable query Explain query SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1 SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = 'API' AND t0.name = 'token_all' LIMIT 1;
3	0.38 ms	SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1 Parameters: [`"API" "storefront_token"`] View formatted query View runnable query Explain query SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1 SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = 'API' AND t0.name = 'storefront_token' LIMIT 1;

#▲

Time

Info

0.55 ms

SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1

Parameters:

[
  "API"
  "token_read"
]

View formatted query View runnable query Explain query

SELECT
  t0.config_id AS config_id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.type AS type_4,
  t0.orderby AS orderby_5,
  t0.value AS value_6,
  t0.widgetParameters AS widgetParameters_7,
  t0.module AS module_8
FROM
  xlite_config t0
WHERE
  t0.category = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = 'API' AND t0.name = 'token_read' LIMIT 1;

2.77 ms

SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1

Parameters:

[
  "API"
  "token_all"
]

View formatted query View runnable query Explain query

SELECT
  t0.config_id AS config_id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.type AS type_4,
  t0.orderby AS orderby_5,
  t0.value AS value_6,
  t0.widgetParameters AS widgetParameters_7,
  t0.module AS module_8
FROM
  xlite_config t0
WHERE
  t0.category = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = 'API' AND t0.name = 'token_all' LIMIT 1;

0.38 ms

SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = ? AND t0.name = ? LIMIT 1

Parameters:

[
  "API"
  "storefront_token"
]

View formatted query View runnable query Explain query

SELECT
  t0.config_id AS config_id_1,
  t0.name AS name_2,
  t0.category AS category_3,
  t0.type AS type_4,
  t0.orderby AS orderby_5,
  t0.value AS value_6,
  t0.widgetParameters AS widgetParameters_7,
  t0.module AS module_8
FROM
  xlite_config t0
WHERE
  t0.category = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.config_id AS config_id_1, t0.name AS name_2, t0.category AS category_3, t0.type AS type_4, t0.orderby AS orderby_5, t0.value AS value_6, t0.widgetParameters AS widgetParameters_7, t0.module AS module_8 FROM xlite_config t0 WHERE t0.category = 'API' AND t0.name = 'storefront_token' LIMIT 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
XLite\Model\Profile	No errors.
XLite\Model\Cart	No errors.
XLite\Model\OrderItem	No errors.
CDev\Coupons\Model\UsedCoupon	No errors.
XLite\Model\Zone	No errors.
XLite\Model\Membership	No errors.
QSL\ProductStickers\Model\ProductSticker	No errors.
CDev\Coupons\Model\Coupon	No errors.
XLite\Model\Product	The field XLite\Model\Product#variations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity XC\ProductVariations\Model\Variation#product does not contain the required 'inversedBy="variations"' attribute.
XLite\Model\ProductClass	No errors.
CDev\Coupons\Model\CouponProduct	No errors.
XLite\Model\Category	No errors.
CDev\Sale\Model\SaleDiscountProduct	No errors.
QSL\Make\Model\Level2	No errors.
QSL\Make\Model\Level1	No errors.
QSL\Make\Model\Level3	No errors.
QSL\Make\Model\Level4	No errors.
XLite\Model\Config	No errors.
XLite\Model\ConfigTranslation	No errors.

Symfony Profiler

https://192.241.167.57/api/sonicos/tfa

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping