Query Metrics
30
Database Queries
10
Different statements
5.35 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.39 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mirror_id AS mirror_id_3, t0.name AS name_4, t0.seo_title AS seo_title_5, t0.seo_keywords AS seo_keywords_6, t0.seo_description AS seo_description_7, t0.create_dt AS create_dt_8, t0.modify_dt AS modify_dt_9, t0.slug AS slug_10, t0.position AS position_11, t0.lang_id AS lang_id_12, t0.user_id AS user_id_13, t0.module_id AS module_id_14, t0.category_id AS category_id_15 FROM post t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
2 | 0.20 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.module_id = ? AND t0.name = ? LIMIT 1
Parameters:
[ 1 "mpPartners" ] |
3 | 0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.create_dt AS create_dt_3, t0.modify_dt AS modify_dt_4, t0.path AS path_5, t0.content_type AS content_type_6, t0.size AS size_7, t0.title AS title_8, t0.alternative_text AS alternative_text_9, t0.sizes AS sizes_10, t0.position AS position_11, t0.main AS main_12, t0.module_id AS module_id_13, t0.post_id AS post_id_14, t0.module_field_config_id AS module_field_config_id_15 FROM file t0 WHERE t0.post_id = ? AND t0.module_field_config_id = ? AND t0.main = ? ORDER BY t0.position ASC
Parameters:
[ 1 10 1 ] |
4 | 0.27 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[
[
23
]
]
|
5 | 0.16 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[
[
23
]
]
|
6 | 0.15 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.module_id = ? AND t0.name = ? LIMIT 1
Parameters:
[ 1 "mpPartners" ] |
7 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.create_dt AS create_dt_3, t0.modify_dt AS modify_dt_4, t0.path AS path_5, t0.content_type AS content_type_6, t0.size AS size_7, t0.title AS title_8, t0.alternative_text AS alternative_text_9, t0.sizes AS sizes_10, t0.position AS position_11, t0.main AS main_12, t0.module_id AS module_id_13, t0.post_id AS post_id_14, t0.module_field_config_id AS module_field_config_id_15 FROM file t0 WHERE t0.post_id = ? AND t0.module_field_config_id = ? ORDER BY t0.position ASC
Parameters:
[ 1 10 ] |
8 | 0.16 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[ [ 1 2 3 4 5 23 ] ] |
9 | 0.16 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[ [ 1 2 3 4 5 23 ] ] |
10 | 0.22 ms |
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.create_dt AS create_dt_4, t0.modify_dt AS modify_dt_5, t0.post_id AS post_id_6, t0.field_id AS field_id_7 FROM post_meta t0 WHERE t0.post_id = ?
Parameters:
[
"1"
]
|
11 | 0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.categories AS categories_5, t0.editable_cats AS editable_cats_6, t0.editable_main_cats AS editable_main_cats_7, t0.sort_available AS sort_available_8, t0.fa_icon AS fa_icon_9, t0.konfiguracja AS konfiguracja_10, t0.subcategories AS subcategories_11, t0.depth AS depth_12 FROM module t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
12 | 0.21 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mirror_id AS mirror_id_3, t0.name AS name_4, t0.seo_title AS seo_title_5, t0.seo_keywords AS seo_keywords_6, t0.seo_description AS seo_description_7, t0.create_dt AS create_dt_8, t0.modify_dt AS modify_dt_9, t0.slug AS slug_10, t0.position AS position_11, t0.lang_id AS lang_id_12, t0.user_id AS user_id_13, t0.module_id AS module_id_14, t0.category_id AS category_id_15 FROM post t0 WHERE t0.module_id = ? AND t0.status = ? ORDER BY t0.position DESC
Parameters:
[ 2 "A" ] |
13 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.categories AS categories_5, t0.editable_cats AS editable_cats_6, t0.editable_main_cats AS editable_main_cats_7, t0.sort_available AS sort_available_8, t0.fa_icon AS fa_icon_9, t0.konfiguracja AS konfiguracja_10, t0.subcategories AS subcategories_11, t0.depth AS depth_12 FROM module t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
14 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mirror_id AS mirror_id_3, t0.name AS name_4, t0.seo_title AS seo_title_5, t0.seo_keywords AS seo_keywords_6, t0.seo_description AS seo_description_7, t0.create_dt AS create_dt_8, t0.modify_dt AS modify_dt_9, t0.slug AS slug_10, t0.position AS position_11, t0.lang_id AS lang_id_12, t0.user_id AS user_id_13, t0.module_id AS module_id_14, t0.category_id AS category_id_15 FROM post t0 WHERE t0.module_id = ? AND t0.status = ? ORDER BY t0.position DESC
Parameters:
[ 3 "A" ] |
15 | 0.15 ms |
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.create_dt AS create_dt_4, t0.modify_dt AS modify_dt_5, t0.post_id AS post_id_6, t0.field_id AS field_id_7 FROM post_meta t0 WHERE t0.post_id = ?
Parameters:
[
11
]
|
16 | 0.15 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.id = ?
Parameters:
[
18
]
|
17 | 0.14 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.id = ?
Parameters:
[
19
]
|
18 | 0.14 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.id = ?
Parameters:
[
20
]
|
19 | 0.19 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.module_id = ? AND t0.name = ? LIMIT 1
Parameters:
[ 3 "slideImage" ] |
20 | 0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.create_dt AS create_dt_3, t0.modify_dt AS modify_dt_4, t0.path AS path_5, t0.content_type AS content_type_6, t0.size AS size_7, t0.title AS title_8, t0.alternative_text AS alternative_text_9, t0.sizes AS sizes_10, t0.position AS position_11, t0.main AS main_12, t0.module_id AS module_id_13, t0.post_id AS post_id_14, t0.module_field_config_id AS module_field_config_id_15 FROM file t0 WHERE t0.post_id = ? AND t0.module_field_config_id = ? AND t0.main = ? ORDER BY t0.position ASC
Parameters:
[ 11 20 1 ] |
21 | 0.16 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[
[
25
]
]
|
22 | 0.16 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[
[
25
]
]
|
23 | 0.14 ms |
SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.create_dt AS create_dt_4, t0.modify_dt AS modify_dt_5, t0.post_id AS post_id_6, t0.field_id AS field_id_7 FROM post_meta t0 WHERE t0.post_id = ?
Parameters:
[
3
]
|
24 | 0.17 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.field_type AS field_type_3, t0.label AS label_4, t0.name AS name_5, t0.default_value AS default_value_6, t0.available_values AS available_values_7, t0.select_one_range AS select_one_range_8, t0.main AS main_9, t0.tab_id AS tab_id_10, t0.module_id AS module_id_11 FROM module_field_config t0 WHERE t0.module_id = ? AND t0.name = ? LIMIT 1
Parameters:
[ 3 "slideImage" ] |
25 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.create_dt AS create_dt_3, t0.modify_dt AS modify_dt_4, t0.path AS path_5, t0.content_type AS content_type_6, t0.size AS size_7, t0.title AS title_8, t0.alternative_text AS alternative_text_9, t0.sizes AS sizes_10, t0.position AS position_11, t0.main AS main_12, t0.module_id AS module_id_13, t0.post_id AS post_id_14, t0.module_field_config_id AS module_field_config_id_15 FROM file t0 WHERE t0.post_id = ? AND t0.module_field_config_id = ? AND t0.main = ? ORDER BY t0.position ASC
Parameters:
[ 3 20 1 ] |
26 | 0.17 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[
[
6
]
]
|
27 | 0.17 ms |
SELECT t0.id AS id_1, t0.version AS version_2, t0.public_path AS public_path_3, t0.data AS data_4, t0.file_id AS file_id_5, t0.post_id AS post_id_6 FROM file_version t0 WHERE t0.file_id IN (?)
Parameters:
[
[
6
]
]
|
28 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4, t0.categories AS categories_5, t0.editable_cats AS editable_cats_6, t0.editable_main_cats AS editable_main_cats_7, t0.sort_available AS sort_available_8, t0.fa_icon AS fa_icon_9, t0.konfiguracja AS konfiguracja_10, t0.subcategories AS subcategories_11, t0.depth AS depth_12 FROM module t0 WHERE t0.id = ?
Parameters:
[
"4"
]
|
29 | 0.18 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mirror_id AS mirror_id_3, t0.name AS name_4, t0.seo_title AS seo_title_5, t0.seo_keywords AS seo_keywords_6, t0.seo_description AS seo_description_7, t0.create_dt AS create_dt_8, t0.modify_dt AS modify_dt_9, t0.slug AS slug_10, t0.position AS position_11, t0.lang_id AS lang_id_12, t0.user_id AS user_id_13, t0.module_id AS module_id_14, t0.category_id AS category_id_15 FROM post t0 WHERE t0.module_id IN (?) AND t0.status = ? ORDER BY t0.position DESC LIMIT 4
Parameters:
[ [ 4 ] "A" ] |
30 | 0.17 ms |
SELECT t0.id AS id_1, t0.status AS status_2, t0.mirror_id AS mirror_id_3, t0.name AS name_4, t0.seo_title AS seo_title_5, t0.seo_keywords AS seo_keywords_6, t0.seo_description AS seo_description_7, t0.create_dt AS create_dt_8, t0.modify_dt AS modify_dt_9, t0.slug AS slug_10, t0.position AS position_11, t0.lang_id AS lang_id_12, t0.user_id AS user_id_13, t0.module_id AS module_id_14, t0.category_id AS category_id_15 FROM post t0 WHERE t0.module_id = ? AND t0.status = ? ORDER BY t0.position DESC
Parameters:
[ 2 "A" ] |
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 |
---|---|
Maris\CmsBundle\Entity\PostMeta | No errors. |
Maris\CmsBundle\Entity\Post | No errors. |
Maris\CmsBundle\Entity\Module | No errors. |
Maris\CmsBundle\Entity\File | No errors. |
Maris\CmsBundle\Entity\FileVersion | No errors. |
Maris\CmsBundle\Entity\ModuleFieldConfig | No errors. |
Maris\CmsBundle\Entity\Language | No errors. |
App\Entity\User | No errors. |
Maris\CmsBundle\Entity\Categories | No errors. |
Maris\CmsBundle\Entity\ModuleTabs | No errors. |