Query Metrics
41
Database Queries
3
Different statements
5.27 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.23 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"api_token"
]
|
2 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"api_username"
]
|
3 | 0.10 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"api_password"
]
|
4 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"api_server"
]
|
5 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"credit_dedipass_public_key"
]
|
6 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"credit_dedipass_private_key"
]
|
7 | 0.27 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
8 | 0.26 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
9 | 0.18 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"game_title"
]
|
10 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
11 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
12 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
13 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
14 | 0.10 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"game_title"
]
|
15 | 0.09 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
16 | 0.15 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
17 | 0.14 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"game_title"
]
|
18 | 0.10 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
19 | 0.09 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
20 | 0.07 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"game_title"
]
|
21 | 0.10 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
22 | 0.09 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"seo_description"
]
|
23 | 0.21 ms |
SELECT t0.id AS id_1, t0.category AS category_2, t0.unique_slug AS unique_slug_3, t0.name AS name_4, t0.content AS content_5, t0.is_visible AS is_visible_6 FROM cms_pages t0 WHERE t0.category = ? AND t0.is_visible = ?
Parameters:
[ "game" 1 ] |
24 | 0.15 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"use_nav_community"
]
|
25 | 0.12 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"discord_link"
]
|
26 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"discord_link"
]
|
27 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"facebook_link"
]
|
28 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"twitter_link"
]
|
29 | 0.07 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"youtube_link"
]
|
30 | 0.10 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"instagram_link"
]
|
31 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"instagram_link"
]
|
32 | 0.13 ms |
SELECT t0.id AS id_1, t0.category AS category_2, t0.unique_slug AS unique_slug_3, t0.name AS name_4, t0.content AS content_5, t0.is_visible AS is_visible_6 FROM cms_pages t0 WHERE t0.category = ? AND t0.is_visible = ?
Parameters:
[ "wiki" 1 ] |
33 | 0.12 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
34 | 0.11 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"game_title"
]
|
35 | 0.34 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
36 | 0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.date AS date_4, t0.author AS author_5, t0.img_url AS img_url_6, t0.slug AS slug_7, t0.category_id AS category_id_8 FROM cms_news t0 ORDER BY t0.id DESC LIMIT 5
Parameters:
[] |
37 | 0.19 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"theme"
]
|
38 | 0.19 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"use_right_community_button"
]
|
39 | 0.09 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"facebook_link"
]
|
40 | 0.08 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"twitter_link"
]
|
41 | 0.07 ms |
SELECT t0.id AS id_1, t0.setting AS setting_2, t0.default_value AS default_value_3, t0.description AS description_4 FROM cms_settings t0 WHERE t0.setting = ? LIMIT 1
Parameters:
[
"youtube_link"
]
|
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 |
---|---|
App\Entity\CmsSettings | No errors. |
App\Entity\CmsPages | No errors. |
App\Entity\CmsNews | No errors. |
App\Entity\CmsNewsCategory | No errors. |