Query Metrics
6
Database Queries
4
Different statements
11.81 ms
Query time
1
Invalid entities
Queries
#▲ | 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.