Query Metrics
15
Database Queries
2
Different statements
3.63 ms
Query time
4
Invalid entities
11
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.30 ms |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.class AS class_2, w0_.code AS code_3, w0_.template AS template_4, w0_.is_deleted AS is_deleted_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7 FROM widget w0_
Parameters:
[] |
2 | 0.39 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"name"
]
|
3 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"slogan"
]
|
4 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"keyword"
]
|
5 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"description"
]
|
6 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"favicon"
]
|
7 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"logo"
]
|
8 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"logo_s"
]
|
9 | 0.22 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"principalColor"
]
|
10 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"secondaryColor"
]
|
11 | 0.21 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"algoliaIndex"
]
|
12 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"logo_s"
]
|
13 | 0.24 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"name"
]
|
14 | 0.22 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"logo"
]
|
15 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.parameter_key AS parameter_key_1, p0_.parameter_value AS parameter_value_2, p0_.parameter_label AS parameter_label_3, p0_.parameter_type AS parameter_type_4, p0_.parameter_category AS parameter_category_5, p0_.in_session AS in_session_6, p0_.parameter_category_enabled AS parameter_category_enabled_7, p0_.is_deleted AS is_deleted_8, p0_.created_at AS created_at_9, p0_.updated_at AS updated_at_10 FROM parameter p0_ WHERE COALESCE(p0_.is_deleted, 0) = 0 AND p0_.parameter_key = ?
Parameters:
[
"enableRegistration"
]
|
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
Graphlife\CMSBundle\Entity\Parameter | 11 |