Symfony Profiler

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  s.id,
  s.name,
  s.width,
  s.height,
  t.name as theme
FROM
  tl_image_size s
  LEFT JOIN tl_theme t ON s.pid = t.id
ORDER BY
  s.pid,
  s.name

SELECT
                s.id, s.name, s.width, s.height, t.name as theme
            FROM
                tl_image_size s
            LEFT JOIN
                tl_theme t ON s.pid=t.id
            ORDER BY
                s.pid, s.name;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`id` = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=32 LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`id` = ?
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=1 LIMIT 0,1;

SELECT
  tl_layout.*
FROM
  tl_layout
WHERE
  tl_layout.`id` = ?
LIMIT
  0, 1

SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=1 LIMIT 0,1;

SHOW FULL COLUMNS
FROM
  tl_hofff_consent_tag

SHOW FULL COLUMNS FROM tl_hofff_consent_tag;

SHOW INDEXES
FROM
  `tl_hofff_consent_tag`

SHOW INDEXES FROM `tl_hofff_consent_tag`;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (tl_hofff_consent_tag.id = ?)
  AND (
    tl_hofff_consent_tag.published = ?
  )
ORDER BY
  tl_hofff_consent_tag.sorting
LIMIT
  0, 1

SELECT IFNULL(translation.id, tl_hofff_consent_tag.id) AS id, IFNULL(translation.language, tl_hofff_consent_tag.language) AS language, IFNULL(translation.lang_pid, tl_hofff_consent_tag.lang_pid) AS lang_pid, tl_hofff_consent_tag.tstamp, tl_hofff_consent_tag.pid, tl_hofff_consent_tag.sorting, tl_hofff_consent_tag.name, tl_hofff_consent_tag.type, tl_hofff_consent_tag.customize, tl_hofff_consent_tag.categoryType, tl_hofff_consent_tag.effectiveFrom, tl_hofff_consent_tag.showPlaceholder, tl_hofff_consent_tag.theme, tl_hofff_consent_tag.assetsPosition, tl_hofff_consent_tag.integrations, tl_hofff_consent_tag.published, tl_hofff_consent_tag.bannerTemplate, tl_hofff_consent_tag.assetsHtml, tl_hofff_consent_tag.head, tl_hofff_consent_tag.isVendor, tl_hofff_consent_tag.cookies, IFNULL(translation.storageDuration, tl_hofff_consent_tag.storageDuration) AS storageDuration, IFNULL(translation.title, tl_hofff_consent_tag.title) AS title, IFNULL(translation.provider, tl_hofff_consent_tag.provider) AS provider, IFNULL(translation.description, tl_hofff_consent_tag.description) AS description, IFNULL(translation.thirdCountryTransfer, tl_hofff_consent_tag.thirdCountryTransfer) AS thirdCountryTransfer, IFNULL(translation.acceptButton, tl_hofff_consent_tag.acceptButton) AS acceptButton, IFNULL(translation.denyButton, tl_hofff_consent_tag.denyButton) AS denyButton, IFNULL(translation.privacySettings, tl_hofff_consent_tag.privacySettings) AS privacySettings, IFNULL(translation.confirmation, tl_hofff_consent_tag.confirmation) AS confirmation, IFNULL(translation.purpose, tl_hofff_consent_tag.purpose) AS purpose, IFNULL(translation.jumpTo, tl_hofff_consent_tag.jumpTo) AS jumpTo, IFNULL(translation.privacyPage, tl_hofff_consent_tag.privacyPage) AS privacyPage, IFNULL(translation.privacyNote, tl_hofff_consent_tag.privacyNote) AS privacyNote, IFNULL(translation.outdatedNote, tl_hofff_consent_tag.outdatedNote) AS outdatedNote, IFNULL(translation.module, tl_hofff_consent_tag.module) AS module, IFNULL(translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle) AS placeholderTitle, IFNULL(translation.placeholderDescription, tl_hofff_consent_tag.placeholderDescription) AS placeholderDescription, IFNULL(translation.placeholderAcceptButton, tl_hofff_consent_tag.placeholderAcceptButton) AS placeholderAcceptButton, IFNULL(translation.vendors, tl_hofff_consent_tag.vendors) AS vendors FROM tl_hofff_consent_tag tl_hofff_consent_tag LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id=translation.lang_pid AND translation.language='' WHERE (tl_hofff_consent_tag.lang_pid=0) AND (tl_hofff_consent_tag.id=1) AND (tl_hofff_consent_tag.published='1') ORDER BY tl_hofff_consent_tag.sorting LIMIT 0,1;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (
    tl_hofff_consent_tag.published = ?
  )
  AND (tl_hofff_consent_tag.pid = ?)
ORDER BY
  tl_hofff_consent_tag.sorting

SELECT IFNULL(translation.id, tl_hofff_consent_tag.id) AS id, IFNULL(translation.language, tl_hofff_consent_tag.language) AS language, IFNULL(translation.lang_pid, tl_hofff_consent_tag.lang_pid) AS lang_pid, tl_hofff_consent_tag.tstamp, tl_hofff_consent_tag.pid, tl_hofff_consent_tag.sorting, tl_hofff_consent_tag.name, tl_hofff_consent_tag.type, tl_hofff_consent_tag.customize, tl_hofff_consent_tag.categoryType, tl_hofff_consent_tag.effectiveFrom, tl_hofff_consent_tag.showPlaceholder, tl_hofff_consent_tag.theme, tl_hofff_consent_tag.assetsPosition, tl_hofff_consent_tag.integrations, tl_hofff_consent_tag.published, tl_hofff_consent_tag.bannerTemplate, tl_hofff_consent_tag.assetsHtml, tl_hofff_consent_tag.head, tl_hofff_consent_tag.isVendor, tl_hofff_consent_tag.cookies, IFNULL(translation.storageDuration, tl_hofff_consent_tag.storageDuration) AS storageDuration, IFNULL(translation.title, tl_hofff_consent_tag.title) AS title, IFNULL(translation.provider, tl_hofff_consent_tag.provider) AS provider, IFNULL(translation.description, tl_hofff_consent_tag.description) AS description, IFNULL(translation.thirdCountryTransfer, tl_hofff_consent_tag.thirdCountryTransfer) AS thirdCountryTransfer, IFNULL(translation.acceptButton, tl_hofff_consent_tag.acceptButton) AS acceptButton, IFNULL(translation.denyButton, tl_hofff_consent_tag.denyButton) AS denyButton, IFNULL(translation.privacySettings, tl_hofff_consent_tag.privacySettings) AS privacySettings, IFNULL(translation.confirmation, tl_hofff_consent_tag.confirmation) AS confirmation, IFNULL(translation.purpose, tl_hofff_consent_tag.purpose) AS purpose, IFNULL(translation.jumpTo, tl_hofff_consent_tag.jumpTo) AS jumpTo, IFNULL(translation.privacyPage, tl_hofff_consent_tag.privacyPage) AS privacyPage, IFNULL(translation.privacyNote, tl_hofff_consent_tag.privacyNote) AS privacyNote, IFNULL(translation.outdatedNote, tl_hofff_consent_tag.outdatedNote) AS outdatedNote, IFNULL(translation.module, tl_hofff_consent_tag.module) AS module, IFNULL(translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle) AS placeholderTitle, IFNULL(translation.placeholderDescription, tl_hofff_consent_tag.placeholderDescription) AS placeholderDescription, IFNULL(translation.placeholderAcceptButton, tl_hofff_consent_tag.placeholderAcceptButton) AS placeholderAcceptButton, IFNULL(translation.vendors, tl_hofff_consent_tag.vendors) AS vendors FROM tl_hofff_consent_tag tl_hofff_consent_tag LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id=translation.lang_pid AND translation.language='' WHERE (tl_hofff_consent_tag.lang_pid=0) AND (tl_hofff_consent_tag.published='1') AND (tl_hofff_consent_tag.pid=1) ORDER BY tl_hofff_consent_tag.sorting;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (
    tl_hofff_consent_tag.published = ?
  )
  AND (tl_hofff_consent_tag.pid = ?)
ORDER BY
  tl_hofff_consent_tag.sorting

SELECT IFNULL(translation.id, tl_hofff_consent_tag.id) AS id, IFNULL(translation.language, tl_hofff_consent_tag.language) AS language, IFNULL(translation.lang_pid, tl_hofff_consent_tag.lang_pid) AS lang_pid, tl_hofff_consent_tag.tstamp, tl_hofff_consent_tag.pid, tl_hofff_consent_tag.sorting, tl_hofff_consent_tag.name, tl_hofff_consent_tag.type, tl_hofff_consent_tag.customize, tl_hofff_consent_tag.categoryType, tl_hofff_consent_tag.effectiveFrom, tl_hofff_consent_tag.showPlaceholder, tl_hofff_consent_tag.theme, tl_hofff_consent_tag.assetsPosition, tl_hofff_consent_tag.integrations, tl_hofff_consent_tag.published, tl_hofff_consent_tag.bannerTemplate, tl_hofff_consent_tag.assetsHtml, tl_hofff_consent_tag.head, tl_hofff_consent_tag.isVendor, tl_hofff_consent_tag.cookies, IFNULL(translation.storageDuration, tl_hofff_consent_tag.storageDuration) AS storageDuration, IFNULL(translation.title, tl_hofff_consent_tag.title) AS title, IFNULL(translation.provider, tl_hofff_consent_tag.provider) AS provider, IFNULL(translation.description, tl_hofff_consent_tag.description) AS description, IFNULL(translation.thirdCountryTransfer, tl_hofff_consent_tag.thirdCountryTransfer) AS thirdCountryTransfer, IFNULL(translation.acceptButton, tl_hofff_consent_tag.acceptButton) AS acceptButton, IFNULL(translation.denyButton, tl_hofff_consent_tag.denyButton) AS denyButton, IFNULL(translation.privacySettings, tl_hofff_consent_tag.privacySettings) AS privacySettings, IFNULL(translation.confirmation, tl_hofff_consent_tag.confirmation) AS confirmation, IFNULL(translation.purpose, tl_hofff_consent_tag.purpose) AS purpose, IFNULL(translation.jumpTo, tl_hofff_consent_tag.jumpTo) AS jumpTo, IFNULL(translation.privacyPage, tl_hofff_consent_tag.privacyPage) AS privacyPage, IFNULL(translation.privacyNote, tl_hofff_consent_tag.privacyNote) AS privacyNote, IFNULL(translation.outdatedNote, tl_hofff_consent_tag.outdatedNote) AS outdatedNote, IFNULL(translation.module, tl_hofff_consent_tag.module) AS module, IFNULL(translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle) AS placeholderTitle, IFNULL(translation.placeholderDescription, tl_hofff_consent_tag.placeholderDescription) AS placeholderDescription, IFNULL(translation.placeholderAcceptButton, tl_hofff_consent_tag.placeholderAcceptButton) AS placeholderAcceptButton, IFNULL(translation.vendors, tl_hofff_consent_tag.vendors) AS vendors FROM tl_hofff_consent_tag tl_hofff_consent_tag LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id=translation.lang_pid AND translation.language='' WHERE (tl_hofff_consent_tag.lang_pid=0) AND (tl_hofff_consent_tag.published='1') AND (tl_hofff_consent_tag.pid=3) ORDER BY tl_hofff_consent_tag.sorting;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (
    tl_hofff_consent_tag.published = ?
  )
  AND (tl_hofff_consent_tag.pid = ?)
ORDER BY
  tl_hofff_consent_tag.sorting

SELECT IFNULL(translation.id, tl_hofff_consent_tag.id) AS id, IFNULL(translation.language, tl_hofff_consent_tag.language) AS language, IFNULL(translation.lang_pid, tl_hofff_consent_tag.lang_pid) AS lang_pid, tl_hofff_consent_tag.tstamp, tl_hofff_consent_tag.pid, tl_hofff_consent_tag.sorting, tl_hofff_consent_tag.name, tl_hofff_consent_tag.type, tl_hofff_consent_tag.customize, tl_hofff_consent_tag.categoryType, tl_hofff_consent_tag.effectiveFrom, tl_hofff_consent_tag.showPlaceholder, tl_hofff_consent_tag.theme, tl_hofff_consent_tag.assetsPosition, tl_hofff_consent_tag.integrations, tl_hofff_consent_tag.published, tl_hofff_consent_tag.bannerTemplate, tl_hofff_consent_tag.assetsHtml, tl_hofff_consent_tag.head, tl_hofff_consent_tag.isVendor, tl_hofff_consent_tag.cookies, IFNULL(translation.storageDuration, tl_hofff_consent_tag.storageDuration) AS storageDuration, IFNULL(translation.title, tl_hofff_consent_tag.title) AS title, IFNULL(translation.provider, tl_hofff_consent_tag.provider) AS provider, IFNULL(translation.description, tl_hofff_consent_tag.description) AS description, IFNULL(translation.thirdCountryTransfer, tl_hofff_consent_tag.thirdCountryTransfer) AS thirdCountryTransfer, IFNULL(translation.acceptButton, tl_hofff_consent_tag.acceptButton) AS acceptButton, IFNULL(translation.denyButton, tl_hofff_consent_tag.denyButton) AS denyButton, IFNULL(translation.privacySettings, tl_hofff_consent_tag.privacySettings) AS privacySettings, IFNULL(translation.confirmation, tl_hofff_consent_tag.confirmation) AS confirmation, IFNULL(translation.purpose, tl_hofff_consent_tag.purpose) AS purpose, IFNULL(translation.jumpTo, tl_hofff_consent_tag.jumpTo) AS jumpTo, IFNULL(translation.privacyPage, tl_hofff_consent_tag.privacyPage) AS privacyPage, IFNULL(translation.privacyNote, tl_hofff_consent_tag.privacyNote) AS privacyNote, IFNULL(translation.outdatedNote, tl_hofff_consent_tag.outdatedNote) AS outdatedNote, IFNULL(translation.module, tl_hofff_consent_tag.module) AS module, IFNULL(translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle) AS placeholderTitle, IFNULL(translation.placeholderDescription, tl_hofff_consent_tag.placeholderDescription) AS placeholderDescription, IFNULL(translation.placeholderAcceptButton, tl_hofff_consent_tag.placeholderAcceptButton) AS placeholderAcceptButton, IFNULL(translation.vendors, tl_hofff_consent_tag.vendors) AS vendors FROM tl_hofff_consent_tag tl_hofff_consent_tag LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id=translation.lang_pid AND translation.language='' WHERE (tl_hofff_consent_tag.lang_pid=0) AND (tl_hofff_consent_tag.published='1') AND (tl_hofff_consent_tag.pid=11) ORDER BY tl_hofff_consent_tag.sorting;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (
    tl_hofff_consent_tag.published = ?
  )
  AND (tl_hofff_consent_tag.pid = ?)
ORDER BY
  tl_hofff_consent_tag.sorting

SELECT IFNULL(translation.id, tl_hofff_consent_tag.id) AS id, IFNULL(translation.language, tl_hofff_consent_tag.language) AS language, IFNULL(translation.lang_pid, tl_hofff_consent_tag.lang_pid) AS lang_pid, tl_hofff_consent_tag.tstamp, tl_hofff_consent_tag.pid, tl_hofff_consent_tag.sorting, tl_hofff_consent_tag.name, tl_hofff_consent_tag.type, tl_hofff_consent_tag.customize, tl_hofff_consent_tag.categoryType, tl_hofff_consent_tag.effectiveFrom, tl_hofff_consent_tag.showPlaceholder, tl_hofff_consent_tag.theme, tl_hofff_consent_tag.assetsPosition, tl_hofff_consent_tag.integrations, tl_hofff_consent_tag.published, tl_hofff_consent_tag.bannerTemplate, tl_hofff_consent_tag.assetsHtml, tl_hofff_consent_tag.head, tl_hofff_consent_tag.isVendor, tl_hofff_consent_tag.cookies, IFNULL(translation.storageDuration, tl_hofff_consent_tag.storageDuration) AS storageDuration, IFNULL(translation.title, tl_hofff_consent_tag.title) AS title, IFNULL(translation.provider, tl_hofff_consent_tag.provider) AS provider, IFNULL(translation.description, tl_hofff_consent_tag.description) AS description, IFNULL(translation.thirdCountryTransfer, tl_hofff_consent_tag.thirdCountryTransfer) AS thirdCountryTransfer, IFNULL(translation.acceptButton, tl_hofff_consent_tag.acceptButton) AS acceptButton, IFNULL(translation.denyButton, tl_hofff_consent_tag.denyButton) AS denyButton, IFNULL(translation.privacySettings, tl_hofff_consent_tag.privacySettings) AS privacySettings, IFNULL(translation.confirmation, tl_hofff_consent_tag.confirmation) AS confirmation, IFNULL(translation.purpose, tl_hofff_consent_tag.purpose) AS purpose, IFNULL(translation.jumpTo, tl_hofff_consent_tag.jumpTo) AS jumpTo, IFNULL(translation.privacyPage, tl_hofff_consent_tag.privacyPage) AS privacyPage, IFNULL(translation.privacyNote, tl_hofff_consent_tag.privacyNote) AS privacyNote, IFNULL(translation.outdatedNote, tl_hofff_consent_tag.outdatedNote) AS outdatedNote, IFNULL(translation.module, tl_hofff_consent_tag.module) AS module, IFNULL(translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle) AS placeholderTitle, IFNULL(translation.placeholderDescription, tl_hofff_consent_tag.placeholderDescription) AS placeholderDescription, IFNULL(translation.placeholderAcceptButton, tl_hofff_consent_tag.placeholderAcceptButton) AS placeholderAcceptButton, IFNULL(translation.vendors, tl_hofff_consent_tag.vendors) AS vendors FROM tl_hofff_consent_tag tl_hofff_consent_tag LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id=translation.lang_pid AND translation.language='' WHERE (tl_hofff_consent_tag.lang_pid=0) AND (tl_hofff_consent_tag.published='1') AND (tl_hofff_consent_tag.pid=4) ORDER BY tl_hofff_consent_tag.sorting;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (
    tl_hofff_consent_tag.published = ?
  )
  AND (tl_hofff_consent_tag.pid = ?)
ORDER BY
  tl_hofff_consent_tag.sorting

SELECT IFNULL(translation.id, tl_hofff_consent_tag.id) AS id, IFNULL(translation.language, tl_hofff_consent_tag.language) AS language, IFNULL(translation.lang_pid, tl_hofff_consent_tag.lang_pid) AS lang_pid, tl_hofff_consent_tag.tstamp, tl_hofff_consent_tag.pid, tl_hofff_consent_tag.sorting, tl_hofff_consent_tag.name, tl_hofff_consent_tag.type, tl_hofff_consent_tag.customize, tl_hofff_consent_tag.categoryType, tl_hofff_consent_tag.effectiveFrom, tl_hofff_consent_tag.showPlaceholder, tl_hofff_consent_tag.theme, tl_hofff_consent_tag.assetsPosition, tl_hofff_consent_tag.integrations, tl_hofff_consent_tag.published, tl_hofff_consent_tag.bannerTemplate, tl_hofff_consent_tag.assetsHtml, tl_hofff_consent_tag.head, tl_hofff_consent_tag.isVendor, tl_hofff_consent_tag.cookies, IFNULL(translation.storageDuration, tl_hofff_consent_tag.storageDuration) AS storageDuration, IFNULL(translation.title, tl_hofff_consent_tag.title) AS title, IFNULL(translation.provider, tl_hofff_consent_tag.provider) AS provider, IFNULL(translation.description, tl_hofff_consent_tag.description) AS description, IFNULL(translation.thirdCountryTransfer, tl_hofff_consent_tag.thirdCountryTransfer) AS thirdCountryTransfer, IFNULL(translation.acceptButton, tl_hofff_consent_tag.acceptButton) AS acceptButton, IFNULL(translation.denyButton, tl_hofff_consent_tag.denyButton) AS denyButton, IFNULL(translation.privacySettings, tl_hofff_consent_tag.privacySettings) AS privacySettings, IFNULL(translation.confirmation, tl_hofff_consent_tag.confirmation) AS confirmation, IFNULL(translation.purpose, tl_hofff_consent_tag.purpose) AS purpose, IFNULL(translation.jumpTo, tl_hofff_consent_tag.jumpTo) AS jumpTo, IFNULL(translation.privacyPage, tl_hofff_consent_tag.privacyPage) AS privacyPage, IFNULL(translation.privacyNote, tl_hofff_consent_tag.privacyNote) AS privacyNote, IFNULL(translation.outdatedNote, tl_hofff_consent_tag.outdatedNote) AS outdatedNote, IFNULL(translation.module, tl_hofff_consent_tag.module) AS module, IFNULL(translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle) AS placeholderTitle, IFNULL(translation.placeholderDescription, tl_hofff_consent_tag.placeholderDescription) AS placeholderDescription, IFNULL(translation.placeholderAcceptButton, tl_hofff_consent_tag.placeholderAcceptButton) AS placeholderAcceptButton, IFNULL(translation.vendors, tl_hofff_consent_tag.vendors) AS vendors FROM tl_hofff_consent_tag tl_hofff_consent_tag LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id=translation.lang_pid AND translation.language='' WHERE (tl_hofff_consent_tag.lang_pid=0) AND (tl_hofff_consent_tag.published='1') AND (tl_hofff_consent_tag.pid=9) ORDER BY tl_hofff_consent_tag.sorting;

SELECT
  IFNULL(
    translation.id, tl_hofff_consent_tag.id
  ) AS id,
  IFNULL(
    translation.language, tl_hofff_consent_tag.language
  ) AS language,
  IFNULL(
    translation.lang_pid, tl_hofff_consent_tag.lang_pid
  ) AS lang_pid,
  tl_hofff_consent_tag.tstamp,
  tl_hofff_consent_tag.pid,
  tl_hofff_consent_tag.sorting,
  tl_hofff_consent_tag.name,
  tl_hofff_consent_tag.type,
  tl_hofff_consent_tag.customize,
  tl_hofff_consent_tag.categoryType,
  tl_hofff_consent_tag.effectiveFrom,
  tl_hofff_consent_tag.showPlaceholder,
  tl_hofff_consent_tag.theme,
  tl_hofff_consent_tag.assetsPosition,
  tl_hofff_consent_tag.integrations,
  tl_hofff_consent_tag.published,
  tl_hofff_consent_tag.bannerTemplate,
  tl_hofff_consent_tag.assetsHtml,
  tl_hofff_consent_tag.head,
  tl_hofff_consent_tag.isVendor,
  tl_hofff_consent_tag.cookies,
  IFNULL(
    translation.storageDuration, tl_hofff_consent_tag.storageDuration
  ) AS storageDuration,
  IFNULL(
    translation.title, tl_hofff_consent_tag.title
  ) AS title,
  IFNULL(
    translation.provider, tl_hofff_consent_tag.provider
  ) AS provider,
  IFNULL(
    translation.description, tl_hofff_consent_tag.description
  ) AS description,
  IFNULL(
    translation.thirdCountryTransfer,
    tl_hofff_consent_tag.thirdCountryTransfer
  ) AS thirdCountryTransfer,
  IFNULL(
    translation.acceptButton, tl_hofff_consent_tag.acceptButton
  ) AS acceptButton,
  IFNULL(
    translation.denyButton, tl_hofff_consent_tag.denyButton
  ) AS denyButton,
  IFNULL(
    translation.privacySettings, tl_hofff_consent_tag.privacySettings
  ) AS privacySettings,
  IFNULL(
    translation.confirmation, tl_hofff_consent_tag.confirmation
  ) AS confirmation,
  IFNULL(
    translation.purpose, tl_hofff_consent_tag.purpose
  ) AS purpose,
  IFNULL(
    translation.jumpTo, tl_hofff_consent_tag.jumpTo
  ) AS jumpTo,
  IFNULL(
    translation.privacyPage, tl_hofff_consent_tag.privacyPage
  ) AS privacyPage,
  IFNULL(
    translation.privacyNote, tl_hofff_consent_tag.privacyNote
  ) AS privacyNote,
  IFNULL(
    translation.outdatedNote, tl_hofff_consent_tag.outdatedNote
  ) AS outdatedNote,
  IFNULL(
    translation.module, tl_hofff_consent_tag.module
  ) AS module,
  IFNULL(
    translation.placeholderTitle, tl_hofff_consent_tag.placeholderTitle
  ) AS placeholderTitle,
  IFNULL(
    translation.placeholderDescription,
    tl_hofff_consent_tag.placeholderDescription
  ) AS placeholderDescription,
  IFNULL(
    translation.placeholderAcceptButton,
    tl_hofff_consent_tag.placeholderAcceptButton
  ) AS placeholderAcceptButton,
  IFNULL(
    translation.vendors, tl_hofff_consent_tag.vendors
  ) AS vendors
FROM
  tl_hofff_consent_tag tl_hofff_consent_tag
  LEFT OUTER JOIN tl_hofff_consent_tag translation ON tl_hofff_consent_tag.id = translation.lang_pid
  AND translation.language = ''
WHERE
  (
    tl_hofff_consent_tag.lang_pid = 0
  )
  AND (
    tl_hofff_consent_tag.published = ?
  )
  AND (tl_hofff_consent_tag.pid = ?)
ORDER BY
  tl_hofff_consent_tag.sorting