Query Metrics
40
Database Queries
11
Different statements
935.04 ms
Query time
0
Invalid entities
65
Managed entities
22
Cache hits
40
Cache misses
61
Cache puts
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 17.99 ms |
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"
]
|
| 2 | 16.36 ms |
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:
[
"languages"
]
|
| 3 | 18.93 ms |
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" "/contact" 1 ] |
| 4 | 20.57 ms |
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.uuid = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"f56c37bd-b48b-11eb-94b8-f615c056d74b"
]
|
| 5 | 19.40 ms |
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.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
5
]
|
| 6 | 17.78 ms |
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:
[
5
]
|
| 7 | 18.55 ms |
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:
[
"seo-site-title"
]
|
| 8 | 21.24 ms |
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:
[
"branding-favicon"
]
|
| 9 | 23.41 ms |
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"
]
|
| 10 | 21.65 ms |
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.id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
2
]
|
| 11 | 48.47 ms |
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
]
|
| 12 | 22.77 ms |
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"
]
|
| 13 | 18.66 ms |
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
]
|
| 14 | 17.86 ms |
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:
[
"nav-content"
]
|
| 15 | 19.11 ms |
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:
[
12
]
|
| 16 | 21.87 ms |
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"
]
|
| 17 | 28.57 ms |
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:
[
"dsg-logo-fc-svg"
]
|
| 18 | 23.92 ms |
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:
[
"guides"
]
|
| 19 | 18.74 ms |
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:
[
16
]
|
| 20 | 21.80 ms |
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:
[
"online-tool"
]
|
| 21 | 17.40 ms |
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:
[
13
]
|
| 22 | 22.47 ms |
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:
[
"contact"
]
|
| 23 | 22.49 ms |
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:
[
"blog"
]
|
| 24 | 20.02 ms |
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:
[
6
]
|
| 25 | 23.54 ms |
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:
[
"email-campaign-system"
]
|
| 26 | 85.87 ms |
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:
[
17
]
|
| 27 | 20.15 ms |
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:
[
"breadcrumbs"
]
|
| 28 | 18.81 ms |
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:
[
33
]
|
| 29 | 22.43 ms |
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.show_submit_button AS show_submit_button_13, t0.use_default_form_handler AS use_default_form_handler_14, t0.admin_email AS admin_email_15, t0.reply_to_email AS reply_to_email_16, t0.confirmation_field AS confirmation_field_17, t0.admin_email_html AS admin_email_html_18, t0.admin_reply_to AS admin_reply_to_19, t0.fields AS fields_20 FROM cms_form t0 WHERE t0.slug = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 1
Parameters:
[
"contact"
]
|
| 30 | 25.00 ms |
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.confirmation_email_html AS confirmation_email_html_12, t0.success_message AS success_message_13, t0.error_message AS error_message_14, t0.confirmation_subject AS confirmation_subject_15, t0.locale AS locale_16, t0.translatable_id AS translatable_id_17 FROM cms_form_translation t0 WHERE t0.translatable_id = ? AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP)))
Parameters:
[
1
]
|
| 31 | 18.38 ms |
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:
[
"above-footer"
]
|
| 32 | 19.17 ms |
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:
[
21
]
|
| 33 | 22.27 ms |
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:
[
"seo-words-list"
]
|
| 34 | 20.14 ms |
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:
[
3
]
|
| 35 | 22.38 ms |
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:
[
"footer"
]
|
| 36 | 19.10 ms |
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:
[
24
]
|
| 37 | 24.03 ms |
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:
[
"footer-text"
]
|
| 38 | 17.98 ms |
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:
[
4
]
|
| 39 | 20.33 ms |
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:
[
"partner"
]
|
| 40 | 35.43 ms |
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:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
22
Hits
40
Misses
61
Puts
Number of cache hits
| Region | Hits |
|---|---|
| fourbis_cmsbundle_entity_page | 20 |
| fourbis_cmsbundle_entity_block | 2 |
Number of cache misses
| Region | Misses |
|---|---|
| fourbis_cmsbundle_entity_setting | 4 |
| fourbis_cmsbundle_entity_url | 1 |
| fourbis_cmsbundle_entity_pagetranslation | 1 |
| fourbis_cmsbundle_entity_page | 9 |
| fourbis_cmsbundle_entity_page__translations | 7 |
| fourbis_cmsbundle_entity_media | 2 |
| fourbis_cmsbundle_entity_block | 7 |
| fourbis_cmsbundle_entity_block__translations | 7 |
| fourbis_cmsbundle_entity_form | 1 |
| fourbis_cmsbundle_entity_form__translations | 1 |
Number of cache puts
| Region | Puts |
|---|---|
| fourbis_cmsbundle_entity_setting | 8 |
| fourbis_cmsbundle_entity_url | 2 |
| fourbis_cmsbundle_entity_pagetranslation | 2 |
| fourbis_cmsbundle_entity_page | 14 |
| fourbis_cmsbundle_entity_page__translations | 7 |
| fourbis_cmsbundle_entity_media | 4 |
| fourbis_cmsbundle_entity_block | 14 |
| fourbis_cmsbundle_entity_block__translations | 7 |
| fourbis_cmsbundle_entity_form | 2 |
| fourbis_cmsbundle_entity_form__translations | 1 |
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Fourbis\CmsBundle\Entity\Url | 14 |
| Fourbis\CmsBundle\Entity\PageTranslation | 14 |
| Fourbis\CmsBundle\Entity\BlockTranslation | 14 |
| Fourbis\CmsBundle\Entity\Page | 7 |
| Fourbis\CmsBundle\Entity\Block | 7 |
| Fourbis\CmsBundle\Entity\Setting | 4 |
| Fourbis\CmsBundle\Entity\Media | 2 |
| Fourbis\CmsBundle\Entity\FormTranslation | 2 |
| Fourbis\CmsBundle\Entity\Form | 1 |
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\Page | No errors. |
| Fourbis\CmsBundle\Entity\PageTranslation | No errors. |
| Fourbis\CmsBundle\Entity\Media | No errors. |
| Fourbis\CmsBundle\Entity\Block | No errors. |
| Fourbis\CmsBundle\Entity\BlockTranslation | No errors. |
| Fourbis\CmsBundle\Entity\Form | No errors. |
| Fourbis\CmsBundle\Entity\FormTranslation | No errors. |