Query Metrics

7 Database Queries
2 Different statements
5.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.01 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769379889
  "pfOnV5ZbFG:std_features"
]
2 1.09 ms
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
  "tracking_enable"
  ""
]
3 0.64 ms
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
  "tracking_same_page_min_interval_seconds"
  ""
]
4 0.70 ms
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
  "tracking_ask_precise_location"
  ""
]
5 0.95 ms
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
  "tracking_precise_location_hours"
  ""
]
6 0.66 ms
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
  "use_geo_map_for_tracking"
  ""
]
7 0.50 ms
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
  "use_api_for_tracking"
  ""
]

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