Symfony Profiler

SELECT
  p.id,
  ts_rank(
    (
      setweight(
        to_tsvector(
          'german',
          coalesce(p.name, '')
        ),
        'A'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.teaser, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.seo_keywords, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(
            regexp_replace(p.content, '<[^>]+>', ' ', 'g'),
            ''
          )
        ),
        'C'
      )
    ),
    websearch_to_tsquery('german', ?)
  ) AS rank,
  g.name AS group_name,
  g.slug AS group_slug,
  c.name AS category_name,
  c.slug AS category_slug,
  CASE WHEN c.id = ? THEN
    1
  ELSE
    0
  END AS same_category
FROM
  settings_content_page p
  JOIN settings_content_group g ON g.id = p.group_id
  JOIN settings_content_category c ON c.id = g.category_id
WHERE
  c.client_id = ?
  AND p.id <> ?
  AND (
    (
      setweight(
        to_tsvector(
          'german',
          coalesce(p.name, '')
        ),
        'A'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.teaser, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(p.seo_keywords, '')
        ),
        'B'
      ) || setweight(
        to_tsvector(
          'german',
          coalesce(
            regexp_replace(p.content, '<[^>]+>', ' ', 'g'),
            ''
          )
        ),
        'C'
      )
    )
  ) @@ websearch_to_tsquery('german', ?)
ORDER BY
  same_category DESC,
  rank DESC,
  p.updated_at DESC
LIMIT
  ?

SELECT
  p.id,
  ts_rank((
  setweight(to_tsvector('german', coalesce(p.name,'')), 'A') ||
  setweight(to_tsvector('german', coalesce(p.teaser,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(p.seo_keywords,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(regexp_replace(p.content, '<[^>]+>', ' ', 'g'),'')), 'C')
), websearch_to_tsquery('german', 'stößt OR zahlungserinnerungen OR vor OR der OR mahnstufe OR eine OR freundliche OR erinnerung')) AS rank,
  g.name AS group_name,
  g.slug AS group_slug,
  c.name AS category_name,
  c.slug AS category_slug,
  CASE WHEN c.id = 39 THEN 1 ELSE 0 END AS same_category
FROM settings_content_page p
JOIN settings_content_group g ON g.id = p.group_id
JOIN settings_content_category c ON c.id = g.category_id
WHERE
  c.client_id = 2
  AND p.id <> 422
  AND ((
  setweight(to_tsvector('german', coalesce(p.name,'')), 'A') ||
  setweight(to_tsvector('german', coalesce(p.teaser,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(p.seo_keywords,'')), 'B') ||
  setweight(to_tsvector('german', coalesce(regexp_replace(p.content, '<[^>]+>', ' ', 'g'),'')), 'C')
)) @@ websearch_to_tsquery('german', 'stößt OR zahlungserinnerungen OR vor OR der OR mahnstufe OR eine OR freundliche OR erinnerung')
ORDER BY same_category DESC, rank DESC, p.updated_at DESC
LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.company AS company_4,
  t0.email AS email_5,
  t0.branch AS branch_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.telephone AS telephone_9,
  t0.subdomain AS subdomain_10,
  t0.status AS status_11,
  t0.layout_id AS layout_id_12
FROM
  client t0
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company AS company_4, t0.email AS email_5, t0.branch AS branch_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.telephone AS telephone_9, t0.subdomain AS subdomain_10, t0.status AS status_11, t0.layout_id AS layout_id_12 FROM client t0 WHERE t0.subdomain = 'rentsoft' LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.deleted_at AS deleted_at_7,
  t0.category_id AS category_id_8
FROM
  settings_content_group t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.id = 122 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.teaser AS teaser_6,
  t0.icon AS icon_7,
  t0.content AS content_8,
  t0.priority AS priority_9,
  t0.visible AS visible_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.seo_meta_description AS seo_meta_description_12,
  t0.page_view_counter AS page_view_counter_13,
  t0.deleted_at AS deleted_at_14,
  t0.group_id AS group_id_15
FROM
  settings_content_page t0
WHERE
  t0.slug = ?
  AND t0.group_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.teaser AS teaser_6, t0.icon AS icon_7, t0.content AS content_8, t0.priority AS priority_9, t0.visible AS visible_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_description AS seo_meta_description_12, t0.page_view_counter AS page_view_counter_13, t0.deleted_at AS deleted_at_14, t0.group_id AS group_id_15 FROM settings_content_page t0 WHERE t0.slug = 'zahlungserinnerungen' AND t0.group_id = 121 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.icon AS icon_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.visible AS visible_9,
  t0.deleted_at AS deleted_at_10,
  t0.client_id AS client_id_11,
  t0.user_id AS user_id_12
FROM
  settings_content_category t0
WHERE
  t0.slug = ?
  AND t0.client_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.slug = 'faktura' AND t0.client_id = 2 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.icon AS icon_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.visible AS visible_9,
  t0.deleted_at AS deleted_at_10,
  t0.client_id AS client_id_11,
  t0.user_id AS user_id_12
FROM
  settings_content_category t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.id = 36 AND ((t0.deleted_at IS NULL));

SELECT
  s0_.id AS id_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.name AS name_3,
  s0_.slug AS slug_4,
  s0_.teaser AS teaser_5,
  s0_.icon AS icon_6,
  s0_.content AS content_7,
  s0_.priority AS priority_8,
  s0_.visible AS visible_9,
  s0_.seo_keywords AS seo_keywords_10,
  s0_.seo_meta_description AS seo_meta_description_11,
  s0_.page_view_counter AS page_view_counter_12,
  s0_.deleted_at AS deleted_at_13,
  s0_.group_id AS group_id_14
FROM
  settings_content_page s0_
WHERE
  (
    s0_.id IN (?, ?, ?, ?, ?)
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.name AS name_3, s0_.slug AS slug_4, s0_.teaser AS teaser_5, s0_.icon AS icon_6, s0_.content AS content_7, s0_.priority AS priority_8, s0_.visible AS visible_9, s0_.seo_keywords AS seo_keywords_10, s0_.seo_meta_description AS seo_meta_description_11, s0_.page_view_counter AS page_view_counter_12, s0_.deleted_at AS deleted_at_13, s0_.group_id AS group_id_14 FROM settings_content_page s0_ WHERE (s0_.id IN (423, 421, 425, 364, 347)) AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.deleted_at AS deleted_at_7,
  t0.category_id AS category_id_8
FROM
  settings_content_group t0
WHERE
  t0.slug = ?
  AND t0.category_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.slug = 'offene-posten' AND t0.category_id = 39 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.logo AS logo_4,
  t0.logo_footer AS logo_footer_5,
  t0.favicon AS favicon_6,
  t0.link_imprint AS link_imprint_7,
  t0.link_agb AS link_agb_8,
  t0.seo_main_keywords AS seo_main_keywords_9,
  t0.seo_main_description AS seo_main_description_10,
  t0.header_background_color AS header_background_color_11,
  t0.primary_color AS primary_color_12,
  t0.dark_mode_default AS dark_mode_default_13,
  t0.hero_image AS hero_image_14
FROM
  client_layout t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo AS logo_4, t0.logo_footer AS logo_footer_5, t0.favicon AS favicon_6, t0.link_imprint AS link_imprint_7, t0.link_agb AS link_agb_8, t0.seo_main_keywords AS seo_main_keywords_9, t0.seo_main_description AS seo_main_description_10, t0.header_background_color AS header_background_color_11, t0.primary_color AS primary_color_12, t0.dark_mode_default AS dark_mode_default_13, t0.hero_image AS hero_image_14 FROM client_layout t0 WHERE t0.id = 2;

UPDATE
  settings_content_page
SET
  page_view_counter = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE settings_content_page SET page_view_counter = 13, updated_at = '2026-06-10 10:24:10' WHERE id = 422;

"START TRANSACTION"

"START TRANSACTION";