Symfony Profiler

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 (?)

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 ('133e7840-479d-11f1-aa3f-565e1d1e56f6');

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 = ?

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 = '133e7840-479d-11f1-aa3f-565e1d1e56f6';

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

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 ('www.jgonzalez.eu', 'jgonzalez.eu') ORDER BY d0_.position ASC;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  epx_module_blog_post e0_
  LEFT JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id
  LEFT JOIN epx_module_blog_ai e2_ ON e1_.id = e2_.blog_id
WHERE
  e0_.blog_id = ?
  AND e0_.state = ?
  AND (
    e2_.demo_mode = ?
    OR e2_.demo_mode IS NULL
    OR (
      e2_.demo_mode = ?
      AND (
        JSON_EXTRACT(e0_.metadata, '$.source') NOT LIKE ?
        OR JSON_EXTRACT(e0_.metadata, '$.source') IS NULL
      )
    )
  )

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM epx_module_blog_post e0_ LEFT JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id LEFT JOIN epx_module_blog_ai e2_ ON e1_.id = e2_.blog_id WHERE e0_.blog_id = '52ca3856-5435-11f1-829a-6259e2a97c2c' AND e0_.state = 'published' AND (e2_.demo_mode = 0 OR e2_.demo_mode IS NULL OR (e2_.demo_mode = 1 AND (JSON_EXTRACT(e0_.metadata, '$.source') NOT LIKE '%blog_ai%' OR JSON_EXTRACT(e0_.metadata, '$.source') IS NULL)));

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_
  LEFT JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id
  LEFT JOIN epx_module_blog_ai e2_ ON e1_.id = e2_.blog_id
WHERE
  e0_.blog_id = ?
  AND e0_.state = ?
  AND (
    e2_.demo_mode = ?
    OR e2_.demo_mode IS NULL
    OR (
      e2_.demo_mode = ?
      AND (
        JSON_EXTRACT(e0_.metadata, '$.source') NOT LIKE ?
        OR JSON_EXTRACT(e0_.metadata, '$.source') IS NULL
      )
    )
  )
  AND e0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  e0_.date DESC

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_ LEFT JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id LEFT JOIN epx_module_blog_ai e2_ ON e1_.id = e2_.blog_id WHERE e0_.blog_id = '52ca3856-5435-11f1-829a-6259e2a97c2c' AND e0_.state = 'published' AND (e2_.demo_mode = 0 OR e2_.demo_mode IS NULL OR (e2_.demo_mode = 1 AND (JSON_EXTRACT(e0_.metadata, '$.source') NOT LIKE '%blog_ai%' OR JSON_EXTRACT(e0_.metadata, '$.source') IS NULL))) AND e0_.id IN ('65a563b0-5435-11f1-9138-6259e2a97c2c', '65a55ee2-5435-11f1-b614-6259e2a97c2c', '65a559ec-5435-11f1-a183-6259e2a97c2c', '65a55528-5435-11f1-9ddd-6259e2a97c2c', '65a547fe-5435-11f1-a2cb-6259e2a97c2c') ORDER BY e0_.date DESC;

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.date AS date_1
FROM
  epx_module_blog_post e0_
  LEFT JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id
  LEFT JOIN epx_module_blog_ai e2_ ON e1_.id = e2_.blog_id
WHERE
  e0_.blog_id = ?
  AND e0_.state = ?
  AND (
    e2_.demo_mode = ?
    OR e2_.demo_mode IS NULL
    OR (
      e2_.demo_mode = ?
      AND (
        JSON_EXTRACT(e0_.metadata, '$.source') NOT LIKE ?
        OR JSON_EXTRACT(e0_.metadata, '$.source') IS NULL
      )
    )
  )
ORDER BY
  e0_.date DESC
LIMIT
  200

SELECT DISTINCT e0_.id AS id_0, e0_.date AS date_1 FROM epx_module_blog_post e0_ LEFT JOIN epx_module_blog e1_ ON e0_.blog_id = e1_.id LEFT JOIN epx_module_blog_ai e2_ ON e1_.id = e2_.blog_id WHERE e0_.blog_id = '52ca3856-5435-11f1-829a-6259e2a97c2c' AND e0_.state = 'published' AND (e2_.demo_mode = 0 OR e2_.demo_mode IS NULL OR (e2_.demo_mode = 1 AND (JSON_EXTRACT(e0_.metadata, '$.source') NOT LIKE '%blog_ai%' OR JSON_EXTRACT(e0_.metadata, '$.source') IS NULL))) ORDER BY e0_.date DESC LIMIT 200;

SELECT
  t0.id AS id_1,
  t0.old_id AS old_id_2,
  t0.name AS name_3,
  t0.site_id AS site_id_4,
  t0.list_page_id AS list_page_id_5,
  t6.id AS id_7,
  t6.prompt_post_generation AS prompt_post_generation_8,
  t6.prompt_image_generation AS prompt_image_generation_9,
  t6.prompt_post_ideas AS prompt_post_ideas_10,
  t6.generation_status AS generation_status_11,
  t6.auto_generation AS auto_generation_12,
  t6.demo_mode AS demo_mode_13,
  t6.workflow AS workflow_14,
  t6.subscription_date AS subscription_date_15,
  t6.site_id AS site_id_16,
  t6.blog_id AS blog_id_17
FROM
  epx_module_blog t0
  LEFT JOIN epx_module_blog_ai t6 ON t6.blog_id = t0.id
WHERE
  t0.site_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.name AS name_3, t0.site_id AS site_id_4, t0.list_page_id AS list_page_id_5, t6.id AS id_7, t6.prompt_post_generation AS prompt_post_generation_8, t6.prompt_image_generation AS prompt_image_generation_9, t6.prompt_post_ideas AS prompt_post_ideas_10, t6.generation_status AS generation_status_11, t6.auto_generation AS auto_generation_12, t6.demo_mode AS demo_mode_13, t6.workflow AS workflow_14, t6.subscription_date AS subscription_date_15, t6.site_id AS site_id_16, t6.blog_id AS blog_id_17 FROM epx_module_blog t0 LEFT JOIN epx_module_blog_ai t6 ON t6.blog_id = t0.id WHERE t0.site_id = '133e7840-479d-11f1-aa3f-565e1d1e56f6' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.previous_id AS previous_id_1,
  p0_.old_id AS old_id_2,
  p0_.title AS title_3,
  p0_.description AS description_4,
  p0_.url AS url_5,
  p0_.main_page AS main_page_6,
  p0_.created AS created_7,
  p0_.updated AS updated_8,
  p0_.custom_scss AS custom_scss_9,
  p0_.custom_html_body AS custom_html_body_10,
  p0_.custom_html_head AS custom_html_head_11,
  p0_.disable_cache AS disable_cache_12,
  p0_.no_index AS no_index_13,
  p0_.no_follow AS no_follow_14,
  p0_.no_llm AS no_llm_15,
  p0_.children_no_llm AS children_no_llm_16,
  p0_.type AS type_17,
  p0_.cache_timestamp AS cache_timestamp_18,
  p0_.published AS published_19,
  p0_.site_id AS site_id_20,
  p0_.parent_page_id AS parent_page_id_21
FROM
  page p0_
WHERE
  p0_.site_id = ?
  AND (
    p0_.url LIKE ?
    OR p0_.url LIKE ?
  )
  AND p0_.type = ?

SELECT p0_.id AS id_0, p0_.previous_id AS previous_id_1, p0_.old_id AS old_id_2, p0_.title AS title_3, p0_.description AS description_4, p0_.url AS url_5, p0_.main_page AS main_page_6, p0_.created AS created_7, p0_.updated AS updated_8, p0_.custom_scss AS custom_scss_9, p0_.custom_html_body AS custom_html_body_10, p0_.custom_html_head AS custom_html_head_11, p0_.disable_cache AS disable_cache_12, p0_.no_index AS no_index_13, p0_.no_follow AS no_follow_14, p0_.no_llm AS no_llm_15, p0_.children_no_llm AS children_no_llm_16, p0_.type AS type_17, p0_.cache_timestamp AS cache_timestamp_18, p0_.published AS published_19, p0_.site_id AS site_id_20, p0_.parent_page_id AS parent_page_id_21 FROM page p0_ WHERE p0_.site_id = '133e7840-479d-11f1-aa3f-565e1d1e56f6' AND (p0_.url LIKE '%[post_id]%' OR p0_.url LIKE '%[post_slug]%') AND p0_.type = 'dynamic';

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 = ?

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 = '133e7840-479d-11f1-aa3f-565e1d1e56f6';