Query Metrics
9
Database Queries
7
Different statements
2.96 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.29 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"
]
|
| 2 | 0.32 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
]
|
| 3 | 0.41 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 "banerPicture" ] |
| 4 | 0.30 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 6 ] |
| 5 | 0.60 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
]
]
|
| 6 | 0.35 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
]
]
|
| 7 | 0.27 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"
]
|
| 8 | 0.14 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 ASC
Parameters:
[ 2 "A" ] |
| 9 | 0.29 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 ASC
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\File | No errors. |
| Maris\CmsBundle\Entity\FileVersion | No errors. |
| Maris\CmsBundle\Entity\ModuleFieldConfig | No errors. |
| Maris\CmsBundle\Entity\Module | 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. |