http://192.241.167.57/api/v1/keys

Query Metrics

6 Database Queries
4 Different statements
11.81 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 3.00 ms
SELECT t0.is_fraudlent AS is_fraudlent_1, t0.code AS code_2, t0.id AS id_3, t0.code3 AS code3_4, t0.enabled AS enabled_5, t0.active_currency AS active_currency_6, t0.currency_id AS currency_id_7, t0.lng_id AS lng_id_8 FROM xlite_countries t0 WHERE t0.code = ?
Parameters:
[
  "US"
]
2 1.64 ms
SELECT t0.state_id AS state_id_1, t0.state AS state_2, t0.code AS code_3, t0.country_code AS country_code_4, t0.region_code AS region_code_5 FROM xlite_states t0 WHERE t0.country_code = ? ORDER BY t0.state ASC
Parameters:
[
  "US"
]
3 4.71 ms
SELECT t0.lng_id AS lng_id_1, t0.code AS code_2, t0.code3 AS code3_3, t0.r2l AS r2l_4, t0.added AS added_5, t0.enabled AS enabled_6, t0.module AS module_7 FROM xlite_languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
4 1.96 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"
]
5 0.26 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"
]
6 0.25 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"
]

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\Country No errors.
XC\MultiCurrency\Model\ActiveCurrency No errors.
XLite\Model\Currency No errors.
XLite\Model\Language No errors.
XLite\Model\State No errors.
XLite\Model\Region No errors.
XLite\Model\CountryTranslation No errors.
XLite\Model\LanguageTranslation No errors.
XLite\Model\ConfigTranslation No errors.