Query Metrics
10
Database Queries
10
Different statements
2.09 ms
Query time
4
Invalid entities
18
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.31 ms |
SELECT d0_.id AS id_0, d0_.url AS url_1, d0_.position AS position_2, d0_.active AS active_3, d0_.created AS created_4, d0_.updated AS updated_5, d0_.in_certificate AS in_certificate_6, d0_.site_id AS site_id_7 FROM domain d0_ WHERE d0_.url IN (?, ?) ORDER BY d0_.position ASC
Parameters:
[ "www.jgonzalez.eu" "jgonzalez.eu" ] |
| 2 | 0.36 ms |
SELECT t0.id AS id_1, t0.reference_number AS reference_number_2, t0.name AS name_3, t0.slug AS slug_4, t0.colors AS colors_5, t0.gradients AS gradients_6, t0.font_primary AS font_primary_7, t0.font_secondary AS font_secondary_8, t0.custom_scss AS custom_scss_9, t0.custom_scss_vars AS custom_scss_vars_10, t0.custom_html_body AS custom_html_body_11, t0.custom_html_head AS custom_html_head_12, t0.deleted_at AS deleted_at_13, t0.created AS created_14, t0.updated AS updated_15, t0.status AS status_16, t0.ga_tracking_id AS ga_tracking_id_17, t0.gads_tracking_id AS gads_tracking_id_18, t0.last_global_change AS last_global_change_19, t0.delivery_date AS delivery_date_20, t0.presentation_date AS presentation_date_21, t0.interview_date AS interview_date_22, t0.interview_link AS interview_link_23, t0.locale AS locale_24, t0.enable_lightbox AS enable_lightbox_25, t0.xmas_theme AS xmas_theme_26, t0.round_buttons AS round_buttons_27, t0.umami_enabled AS umami_enabled_28, t0.umami_uuid AS umami_uuid_29, t0.umami_share_slug AS umami_share_slug_30, t0.enable_sentry AS enable_sentry_31, t0.redirection_uris AS redirection_uris_32, t0.favicon AS favicon_33, t0.favicon_dark AS favicon_dark_34, t0.logo AS logo_35, t0.alternate_logo AS alternate_logo_36, t37.id AS id_38, t37.old_id AS old_id_39, t37.template AS template_40, t37.ssl_state AS ssl_state_41, t37.ssl_last_request AS ssl_last_request_42, t37.ssl_last_log AS ssl_last_log_43, t37.archive_state AS archive_state_44, t37.archive_generation_info AS archive_generation_info_45, t37.tags AS tags_46, t37.multi_pages AS multi_pages_47, t37.developper_mode AS developper_mode_48, t37.expert_mode AS expert_mode_49, t37.crm_reference AS crm_reference_50, t37.google_search_console_api_added AS google_search_console_api_added_51, t37.google_search_console_api_sitemap AS google_search_console_api_sitemap_52, t37.google_site_verification_token AS google_site_verification_token_53, t37.bing_webmaster_tool_console_api_added AS bing_webmaster_tool_console_api_added_54, t37.bing_webmaster_tool_console_api_sitemap AS bing_webmaster_tool_console_api_sitemap_55, t37.bing_webmaster_tool_verification_token AS bing_webmaster_tool_verification_token_56, t37.module_redirection_enabled AS module_redirection_enabled_57, t37.module_blog_enabled AS module_blog_enabled_58, t37.module_blog_ai_enabled AS module_blog_ai_enabled_59, t37.module_seo_enabled AS module_seo_enabled_60, t37.site_id AS site_id_61, t0.agency_id AS agency_id_62, t63.id AS id_64, t63.created AS created_65, t63.updated AS updated_66, t63.cookie_consent_enabled AS cookie_consent_enabled_67, t63.cookie_consent_text AS cookie_consent_text_68, t63.email_consent_enabled AS email_consent_enabled_69, t63.email_consent_text AS email_consent_text_70, t63.enable_visitor_tracker AS enable_visitor_tracker_71, t63.disable_analytics AS disable_analytics_72, t63.site_id AS site_id_73, t63.cookie_consent_link AS cookie_consent_link_74, t63.email_consent_link AS email_consent_link_75 FROM site t0 LEFT JOIN site_metadata t37 ON t37.site_id = t0.id LEFT JOIN gdpr_settings t63 ON t63.site_id = t0.id WHERE t0.id = ?
Parameters:
[
"133e7840-479d-11f1-aa3f-565e1d1e56f6"
]
|
| 3 | 0.19 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.position AS position_3, t0.active AS active_4, t0.created AS created_5, t0.updated AS updated_6, t0.in_certificate AS in_certificate_7, t0.site_id AS site_id_8 FROM domain t0 WHERE t0.site_id IN (?)
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#1237 : "133e7840-479d-11f1-aa3f-565e1d1e56f6" } ] |
| 4 | 0.19 ms |
SELECT t0.id AS id_1, t0.previous_id AS previous_id_2, t0.old_id AS old_id_3, t0.title AS title_4, t0.description AS description_5, t0.url AS url_6, t0.main_page AS main_page_7, t0.created AS created_8, t0.updated AS updated_9, t0.custom_scss AS custom_scss_10, t0.custom_html_body AS custom_html_body_11, t0.custom_html_head AS custom_html_head_12, t0.disable_cache AS disable_cache_13, t0.no_index AS no_index_14, t0.no_follow AS no_follow_15, t0.no_llm AS no_llm_16, t0.children_no_llm AS children_no_llm_17, t0.type AS type_18, t0.cache_timestamp AS cache_timestamp_19, t0.published AS published_20, t0.site_id AS site_id_21, t0.parent_page_id AS parent_page_id_22 FROM page t0 WHERE t0.site_id = ?
Parameters:
[
"133e7840-479d-11f1-aa3f-565e1d1e56f6"
]
|
| 5 | 0.16 ms |
SELECT t0.id AS id_1, t0.previous_id AS previous_id_2, t0.old_id AS old_id_3, t0.title AS title_4, t0.description AS description_5, t0.url AS url_6, t0.main_page AS main_page_7, t0.created AS created_8, t0.updated AS updated_9, t0.custom_scss AS custom_scss_10, t0.custom_html_body AS custom_html_body_11, t0.custom_html_head AS custom_html_head_12, t0.disable_cache AS disable_cache_13, t0.no_index AS no_index_14, t0.no_follow AS no_follow_15, t0.no_llm AS no_llm_16, t0.children_no_llm AS children_no_llm_17, t0.type AS type_18, t0.cache_timestamp AS cache_timestamp_19, t0.published AS published_20, t0.site_id AS site_id_21, t0.parent_page_id AS parent_page_id_22 FROM page t0 WHERE t0.site_id = ? AND t0.type = ?
Parameters:
[ "133e7840-479d-11f1-aa3f-565e1d1e56f6" "dynamic" ] |
| 6 | 0.13 ms |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.number AS number_3, t0.comment AS comment_4, t0.site_id AS site_id_5, t0.template_page_id AS template_page_id_6 FROM epx_module_seo_approach t0 WHERE t0.site_id = ?
Parameters:
[
"133e7840-479d-11f1-aa3f-565e1d1e56f6"
]
|
| 7 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.generator AS generator_4, t0.vals AS vals_5, t0.site_id AS site_id_6, t0.approach_id AS approach_id_7 FROM epx_module_seo_approach_placeholder t0 WHERE t0.approach_id IN (?, ?)
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#3457 : "5e0f63d0-5435-11f1-81f3-6259e2a97c2c" } Ramsey\Uuid\Lazy\LazyUuidFromString {#3710 : "5f2ce60c-5435-11f1-ab91-6259e2a97c2c" } ] |
| 8 | 0.26 ms |
SELECT t1.id AS id_2, t1.previous_id AS previous_id_3, t1.layout_mode AS layout_mode_4, t1.background_value AS background_value_5, t1.background_gradient_color AS background_gradient_color_6, t1.foreground_color AS foreground_color_7, t1.accent_color AS accent_color_8, t1.disposition AS disposition_9, t1.position AS position_10, t1.created_at AS created_at_11, t1.updated_at AS updated_at_12, t1.title AS title_13, t1.title_color AS title_color_14, t1.title_style_color AS title_style_color_15, t1.title_align AS title_align_16, t1.title_size AS title_size_17, t1.title_style_auto AS title_style_auto_18, t1.arrow_effect AS arrow_effect_19, t1.top_divider AS top_divider_20, t1.bottom_divider AS bottom_divider_21, t1.global_section AS global_section_22, t1.background_mode AS background_mode_23, t1.background_sizing AS background_sizing_24, t1.background_align_x AS background_align_x_25, t1.background_align_y AS background_align_y_26, t1.custom_view AS custom_view_27, t1.custom_scss AS custom_scss_28, t1.custom_javascript AS custom_javascript_29, t1.enabled AS enabled_30, t1.shadow_behavior AS shadow_behavior_31, t1.content_before AS content_before_32, t1.margin_top AS margin_top_33, t1.margin_bottom AS margin_bottom_34, t1.margin_left AS margin_left_35, t1.margin_right AS margin_right_36, t1.min_height AS min_height_37, t1.content_align AS content_align_38, t1.footer_align AS footer_align_39, t1.vertical_align AS vertical_align_40, t1.content_size AS content_size_41, t1.buttons_size AS buttons_size_42, t1.heading_level AS heading_level_43, t1.allow_transparent_header AS allow_transparent_header_44, t1.blurred_background AS blurred_background_45, t1.links_equal_width AS links_equal_width_46, t1.link_style_options AS link_style_options_47, t1.alternate_link_style_options AS alternate_link_style_options_48, t0.old_id AS old_id_49, t0.title_template AS title_template_50, t0.item_limit AS item_limit_51, t1.background_media_id AS background_media_id_52, t1.page_id AS page_id_53, t1.parent_section_id AS parent_section_id_54, t1.site_id AS site_id_55, t1.title_style_id AS title_style_id_56, t1.link_style_id AS link_style_id_57, t1.alternate_link_style_id AS alternate_link_style_id_58, t0.approach_id AS approach_id_59, t1.dtype FROM epx_module_seo_combination_section t0 INNER JOIN section t1 ON t0.id = t1.id WHERE t0.approach_id IN (?, ?)
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#3457 : "5e0f63d0-5435-11f1-81f3-6259e2a97c2c" } Ramsey\Uuid\Lazy\LazyUuidFromString {#3710 : "5f2ce60c-5435-11f1-ab91-6259e2a97c2c" } ] |
| 9 | 0.11 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.created AS created_3, t0.page_id AS page_id_4, t0.site_id AS site_id_5 FROM history_url_page t0 WHERE t0.site_id = ? ORDER BY t0.created DESC
Parameters:
[
"133e7840-479d-11f1-aa3f-565e1d1e56f6"
]
|
| 10 | 0.23 ms |
SELECT e0_.id AS id_0, e0_.old_id AS old_id_1, e0_.title AS title_2, e0_.state AS state_3, e0_.date AS date_4, e0_.summary AS summary_5, e0_.seo_description AS seo_description_6, e0_.seo_title AS seo_title_7, e0_.author AS author_8, e0_.slug AS slug_9, e0_.content AS content_10, e0_.crop_media AS crop_media_11, e0_.tags AS tags_12, e0_.metadata AS metadata_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15, e0_.sent AS sent_16, e0_.media AS media_17, e0_.blog_id AS blog_id_18 FROM epx_module_blog_post e0_ INNER JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id WHERE e1_.site_id = ? AND (SELECT COUNT(*) FROM history_url_post h2_ WHERE h2_.post_id = e0_.id) > 0
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#1950 : "133e7840-479d-11f1-aa3f-565e1d1e56f6" } ] |
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Doctrine\Entity\Site\Section\SEO\Placeholder | 8 |
| App\Doctrine\Entity\Site\Page | 4 |
| App\Doctrine\Entity\Site\Section\SEO\Approach | 2 |
| App\Doctrine\Entity\Site\Domain | 1 |
| App\Doctrine\Entity\Site\Site | 1 |
| App\Doctrine\Entity\Super\Agency | 1 |
| App\Doctrine\Entity\Super\SiteMetadata | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Doctrine\Entity\Site\Section\SEO\Approach | No errors. |
| App\Doctrine\Entity\Site\Domain | No errors. |
| App\Doctrine\Entity\Site\Site | No errors. |
| App\Doctrine\Entity\Site\Media | No errors. |
| App\Doctrine\Entity\Super\SiteMetadata | No errors. |
| App\Doctrine\Entity\Super\Agency | No errors. |
| App\Doctrine\Entity\Site\GdprSettings | No errors. |
| App\Doctrine\Entity\Site\Link |
|
| App\Doctrine\Entity\Site\Page | No errors. |
| App\Doctrine\Entity\Site\HistoryUrlPage | No errors. |
| App\Doctrine\Entity\Site\Section\Section |
|
| App\Doctrine\Entity\Site\Navigation | No errors. |
| App\Doctrine\Entity\User | No errors. |
| App\Doctrine\Entity\SiteBackup | No errors. |
| App\Doctrine\Entity\Site\Message | No errors. |
| App\Doctrine\Entity\Site\ElementStyle\TitleStyle | No errors. |
| App\Doctrine\Entity\Site\ElementStyle\LinkStyle | No errors. |
| App\Doctrine\Entity\Site\Section\Blog\Blog | No errors. |
| App\Doctrine\Entity\Site\Section\SEO\Placeholder | No errors. |
| App\Doctrine\Entity\Site\Section\SEO\CombinationSection |
|
| App\Doctrine\Entity\Site\Section\GroupSection |
|
| App\Doctrine\Entity\Site\Section\Blog\Post | No errors. |
| App\Doctrine\Entity\Site\Section\Blog\HistoryUrlPost | No errors. |