Query Metrics
51
Database Queries
17
Different statements
1140.66 ms
Query time
0
Invalid entities
105
Managed entities
32
Cache hits
51
Cache misses
80
Cache puts
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
174.35 ms (15.29%) |
7 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.content AS content_11, t0.description AS description_12, t0.title AS title_13, t0.seo_title AS seo_title_14, t0.url AS url_15, t0.full_url AS full_url_16, t0.public AS public_17, t0.locale AS locale_18, t0.lookup_url_id AS lookup_url_id_19, t0.translatable_id AS translatable_id_20 FROM cms_page_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
2
]
|
|
162.10 ms (14.21%) |
7 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.content AS content_11, t0.locale AS locale_12, t0.translatable_id AS translatable_id_13 FROM cms_block_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
37
]
|
|
156.09 ms (13.68%) |
7 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.private AS private_13, t0.parent_page_id AS parent_page_id_14 FROM cms_page t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"home"
]
|
|
145.39 ms (12.75%) |
7 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12 FROM cms_block t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"head-javascripts"
]
|
|
110.14 ms (9.66%) |
5 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.disable_page AS disable_page_11, t0.title AS title_12, t0.excerpt AS excerpt_13, t0.content AS content_14, t0.description AS description_15, t0.author AS author_16, t0.seo_title AS seo_title_17, t0.field_values AS field_values_18, t0.url AS url_19, t0.full_url AS full_url_20, t0.public AS public_21, t0.locale AS locale_22, t0.lookup_url_id AS lookup_url_id_23, t0.translatable_id AS translatable_id_24 FROM cms_post_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
36
]
|
|
96.58 ms (8.47%) |
4 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.extension AS extension_13, t0.webdav_path AS webdav_path_14, t0.public_url AS public_url_15, t0.public_path AS public_path_16, t0.size AS size_17, t0.file_name AS file_name_18, t0.public AS public_19, t0.alt AS alt_20 FROM cms_media t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"favicon"
]
|
|
82.01 ms (7.19%) |
4 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.value AS value_13, t0.default_setting_id AS default_setting_id_14, t0.description AS description_15 FROM cms_setting t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"primarylanguage"
]
|
|
28.12 ms (2.47%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.category_in_url AS category_in_url_13, t0.fields AS fields_14, t0.disable_page AS disable_page_15 FROM cms_post_type t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
4
]
|
|
24.82 ms (2.18%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.published_at AS published_at_13, t0.post_type_id AS post_type_id_14, t0.category_gallery_id AS category_gallery_id_15, t0.primary_category_id AS primary_category_id_16, t0.featured_media_id AS featured_media_id_17 FROM cms_post t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
36
]
|
|
22.67 ms (1.99%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10 FROM cms_post_category_gallery t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
39
]
|
|
22.57 ms (1.98%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.position AS position_11, t0.gallery_id AS gallery_id_12, t0.category_id AS category_id_13 FROM cms_post_category_attachment t0 WHERE t0.gallery_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
39
]
|
|
22.41 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.url_prefix AS url_prefix_11, t0.title AS title_12, t0.template AS template_13, t0.description AS description_14, t0.url AS url_15, t0.full_url AS full_url_16, t0.public AS public_17, t0.locale AS locale_18, t0.lookup_url_id AS lookup_url_id_19, t0.translatable_id AS translatable_id_20 FROM cms_post_type_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
4
]
|
|
21.76 ms (1.91%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.extension AS extension_13, t0.webdav_path AS webdav_path_14, t0.public_url AS public_url_15, t0.public_path AS public_path_16, t0.size AS size_17, t0.file_name AS file_name_18, t0.public AS public_19, t0.alt AS alt_20 FROM cms_media t0 WHERE t0.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
63
]
|
|
19.18 ms (1.68%) |
1 |
SELECT c0_.id AS id_0, c0_.active AS active_1, c0_.deleted_at AS deleted_at_2, c0_.uuid AS uuid_3, c0_.created_by AS created_by_4, c0_.updated_by AS updated_by_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.version AS version_8, c0_.data AS data_9, c0_.slug AS slug_10, c0_.name AS name_11, c0_.published_at AS published_at_12, c0_.post_type_id AS post_type_id_13, c0_.category_gallery_id AS category_gallery_id_14, c0_.primary_category_id AS primary_category_id_15, c0_.featured_media_id AS featured_media_id_16 FROM cms_post c0_ WHERE (c0_.post_type_id = ? AND c0_.deleted_at IS NULL AND c0_.published_at < ? AND c0_.deleted_at IS NULL) AND ((c0_.deleted_at IS NULL OR c0_.deleted_at > CURRENT_TIMESTAMP)) ORDER BY c0_.published_at DESC LIMIT 4
Parameters:
[ 2 "2026-06-24 11:38:21" ] |
|
19.04 ms (1.67%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.disable_page AS disable_page_11, t0.title AS title_12, t0.excerpt AS excerpt_13, t0.content AS content_14, t0.description AS description_15, t0.author AS author_16, t0.seo_title AS seo_title_17, t0.field_values AS field_values_18, t0.url AS url_19, t0.full_url AS full_url_20, t0.public AS public_21, t0.locale AS locale_22, t0.lookup_url_id AS lookup_url_id_23, t0.translatable_id AS translatable_id_24 FROM cms_post_translation t0 WHERE t0.uuid = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"1f058265-39a0-607e-bb7a-bd3983128f71"
]
|
|
17.72 ms (1.55%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.slug AS slug_11, t0.name AS name_12, t0.category_in_url AS category_in_url_13, t0.fields AS fields_14, t0.disable_page AS disable_page_15 FROM cms_post_type t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"blog"
]
|
|
15.72 ms (1.38%) |
1 |
SELECT t0.id AS id_1, t0.active AS active_2, t0.deleted_at AS deleted_at_3, t0.uuid AS uuid_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.version AS version_9, t0.data AS data_10, t0.url AS url_11, t0.locale AS locale_12, t0.urlable_class AS urlable_class_13, t0.urlable_uuid AS urlable_uuid_14, t0.public AS public_15 FROM cms_url t0 WHERE t0.locale = ? AND t0.url = ? AND t0.deleted_at IS NULL AND t0.public = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[ "en" "/guide/how-to-add-an-email-signature-on-iphone" 1 ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
32
Hits
51
Misses
80
Puts
Number of cache hits
| Region | Hits |
|---|---|
| fourbis_cmsbundle_entity_page | 30 |
| fourbis_cmsbundle_entity_block | 2 |
Number of cache misses
| Region | Misses |
|---|---|
| fourbis_cmsbundle_entity_setting | 4 |
| fourbis_cmsbundle_entity_url | 1 |
| fourbis_cmsbundle_entity_post_posttranslation | 1 |
| fourbis_cmsbundle_entity_post_post | 1 |
| fourbis_cmsbundle_entity_post_post__translations | 5 |
| fourbis_cmsbundle_entity_post_posttype | 2 |
| fourbis_cmsbundle_entity_post_posttype__translations | 1 |
| fourbis_cmsbundle_entity_media | 5 |
| fourbis_cmsbundle_entity_post_postcategorygallery | 1 |
| fourbis_cmsbundle_entity_post_postcategorygallery__attachments | 1 |
| fourbis_cmsbundle_entity_block | 7 |
| fourbis_cmsbundle_entity_block__translations | 7 |
| fourbis_cmsbundle_entity_page | 7 |
| fourbis_cmsbundle_entity_page__translations | 7 |
| query_cache_region | 1 |
Number of cache puts
| Region | Puts |
|---|---|
| fourbis_cmsbundle_entity_setting | 8 |
| fourbis_cmsbundle_entity_url | 2 |
| fourbis_cmsbundle_entity_post_posttranslation | 2 |
| fourbis_cmsbundle_entity_post_post | 5 |
| fourbis_cmsbundle_entity_post_post__translations | 5 |
| fourbis_cmsbundle_entity_post_posttype | 3 |
| fourbis_cmsbundle_entity_post_posttype__translations | 1 |
| fourbis_cmsbundle_entity_media | 9 |
| fourbis_cmsbundle_entity_post_postcategorygallery | 1 |
| fourbis_cmsbundle_entity_post_postcategorygallery__attachments | 1 |
| fourbis_cmsbundle_entity_block | 14 |
| fourbis_cmsbundle_entity_block__translations | 7 |
| fourbis_cmsbundle_entity_page | 14 |
| fourbis_cmsbundle_entity_page__translations | 7 |
| query_cache_region | 1 |
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Fourbis\CmsBundle\Entity\Url | 26 |
| Fourbis\CmsBundle\Entity\BlockTranslation | 14 |
| Fourbis\CmsBundle\Entity\PageTranslation | 14 |
| Fourbis\CmsBundle\Entity\Post\PostTranslation | 10 |
| Fourbis\CmsBundle\Entity\Media | 9 |
| Fourbis\CmsBundle\Entity\Block | 7 |
| Fourbis\CmsBundle\Entity\Page | 7 |
| Fourbis\CmsBundle\Entity\Post\Post | 5 |
| Fourbis\CmsBundle\Entity\Post\PostCategoryGallery | 5 |
| Fourbis\CmsBundle\Entity\Setting | 4 |
| Fourbis\CmsBundle\Entity\Post\PostType | 2 |
| Fourbis\CmsBundle\Entity\Post\PostTypeTranslation | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Fourbis\CmsBundle\Entity\BaseEntity | No errors. |
| Fourbis\CmsBundle\Entity\RichEntity | No errors. |
| Fourbis\CmsBundle\Entity\SluggableEntity | No errors. |
| Fourbis\CmsBundle\Entity\Setting | No errors. |
| Fourbis\CmsBundle\Entity\Url | No errors. |
| Fourbis\CmsBundle\Entity\Post\Post | No errors. |
| Fourbis\CmsBundle\Entity\Post\PostTranslation | No errors. |
| Fourbis\CmsBundle\Entity\Post\PostType | No errors. |
| Fourbis\CmsBundle\Entity\Post\PostCategoryGallery | No errors. |
| Fourbis\CmsBundle\Entity\Post\PostCategory | No errors. |
| Fourbis\CmsBundle\Entity\Media | No errors. |
| Fourbis\CmsBundle\Entity\Post\PostTypeTranslation | No errors. |
| Fourbis\CmsBundle\Entity\Post\PostCategoryAttachment | No errors. |
| Fourbis\CmsBundle\Entity\Block | No errors. |
| Fourbis\CmsBundle\Entity\BlockTranslation | No errors. |
| Fourbis\CmsBundle\Entity\Page | No errors. |
| Fourbis\CmsBundle\Entity\PageTranslation | No errors. |