Symfony Profiler

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

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 = 'primarylanguage' AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 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.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

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 = 'languages' AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 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

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 = 'nl' AND t0.url = '/digitalsignaturegenerator.com' AND t0.deleted_at IS NULL AND t0.public = 1 AND (((t0.deleted_at IS NULL OR t0.deleted_at > CURRENT_TIMESTAMP))) LIMIT 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_.url AS url_10,
  c0_.locale AS locale_11,
  c0_.urlable_class AS urlable_class_12,
  c0_.urlable_uuid AS urlable_uuid_13,
  c0_.public AS public_14
FROM
  cms_url c0_
WHERE
  (
    c0_.public = 1
    AND c0_.url LIKE ?
    AND c0_.locale = ?
    AND c0_.deleted_at IS NULL
  )
  AND (
    (
      c0_.deleted_at IS NULL
      OR c0_.deleted_at > CURRENT_TIMESTAMP
    )
  )

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_.url AS url_10, c0_.locale AS locale_11, c0_.urlable_class AS urlable_class_12, c0_.urlable_uuid AS urlable_uuid_13, c0_.public AS public_14 FROM cms_url c0_ WHERE (c0_.public = 1 AND c0_.url LIKE '%/digitalsignaturegenerator.com' AND c0_.locale = 'nl' AND c0_.deleted_at IS NULL) AND ((c0_.deleted_at IS NULL OR c0_.deleted_at > CURRENT_TIMESTAMP));

(
  SELECT
    id,
    title as field_0,
    description as field_1,
    full_url as field_2,
    content as field_3,
    'pageTranslation' as metaId
  FROM
    cms_page_translation
  WHERE
    public = 1
    and (
      locale = ?
      AND (
        deleted_at is null
        AND (
          title LIKE ?
          or title LIKE ?
          or description LIKE ?
          or description LIKE ?
          or full_url LIKE ?
          or full_url LIKE ?
          or content LIKE ?
          or content LIKE ?
        )
      )
    )
  ORDER BY
    created_at DESC
  LIMIT
    20
)
UNION
  (
    SELECT
      id,
      title as field_0,
      description as field_1,
      full_url as field_2,
      content as field_3,
      'postTranslation' as metaId
    FROM
      cms_post_translation
    WHERE
      public = 1
      and (
        locale = ?
        AND (
          deleted_at is null
          AND (
            title LIKE ?
            or title LIKE ?
            or description LIKE ?
            or description LIKE ?
            or full_url LIKE ?
            or full_url LIKE ?
            or content LIKE ?
            or content LIKE ?
          )
        )
      )
    ORDER BY
      created_at DESC
    LIMIT
      20
  )
UNION
  (
    SELECT
      id,
      name as field_0,
      description as field_1,
      full_url as field_2,
      0 as field_3,
      'postCategoryTranslation' as metaId
    FROM
      cms_post_category_translation
    WHERE
      public = 1
      and (
        locale = ?
        AND (
          deleted_at is null
          AND (
            name LIKE ?
            or name LIKE ?
            or description LIKE ?
            or description LIKE ?
            or full_url LIKE ?
            or full_url LIKE ?
          )
        )
      )
    ORDER BY
      created_at DESC
    LIMIT
      20
  )

(SELECT id, title as field_0, description as field_1, full_url as field_2, content as field_3, 'pageTranslation' as metaId FROM cms_page_translation WHERE public = 1 and (locale = 'nl' AND (deleted_at is null AND (title LIKE '%digitalsignaturegenerator%' or title LIKE '%com%' or description LIKE '%digitalsignaturegenerator%' or description LIKE '%com%' or full_url LIKE '%digitalsignaturegenerator%' or full_url LIKE '%com%' or content LIKE '%digitalsignaturegenerator%' or content LIKE '%com%'))) ORDER BY created_at DESC LIMIT 20 ) UNION (SELECT id, title as field_0, description as field_1, full_url as field_2, content as field_3, 'postTranslation' as metaId FROM cms_post_translation WHERE public = 1 and (locale = 'nl' AND (deleted_at is null AND (title LIKE '%digitalsignaturegenerator%' or title LIKE '%com%' or description LIKE '%digitalsignaturegenerator%' or description LIKE '%com%' or full_url LIKE '%digitalsignaturegenerator%' or full_url LIKE '%com%' or content LIKE '%digitalsignaturegenerator%' or content LIKE '%com%'))) ORDER BY created_at DESC LIMIT 20 ) UNION (SELECT id, name as field_0, description as field_1, full_url as field_2, 0 as field_3, 'postCategoryTranslation' as metaId FROM cms_post_category_translation WHERE public = 1 and (locale = 'nl' AND (deleted_at is null AND (name LIKE '%digitalsignaturegenerator%' or name LIKE '%com%' or description LIKE '%digitalsignaturegenerator%' or description LIKE '%com%' or full_url LIKE '%digitalsignaturegenerator%' or full_url LIKE '%com%'))) ORDER BY created_at DESC LIMIT 20 );