Symfony Profiler

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type NOT IN (
        'error_401', 'error_403', 'error_404',
        'error_503'
      )
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= 1743673380
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1743673380
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = ?
  AND p1.type != 'root'
  AND p1.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= 1743673380
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1743673380
  )
ORDER BY
  p1.sorting

SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1743673380) AND (p2.stop='' OR p2.stop>1743673380)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=1 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1743673380) AND (p1.stop='' OR p1.stop>1743673380) ORDER BY p1.sorting;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid = UNHEX(?)
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('d8925d0f6e1711e7a71d0050560034f9') 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
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND (
    tl_content.ptable = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= 1743673380
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1743673380
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

SELECT tl_content.* FROM tl_content WHERE tl_content.pid=114 AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1743673380) AND (tl_content.stop='' OR tl_content.stop>1743673380) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      'e40e4c753ae811ebb15c83aedc46c81b'
    )
  )
  AND tl_files.extension IN('mp4', 'm4v', 'mov', 'wmv', 'webm')
ORDER BY
  tl_files.uuid != UNHEX(
    'e40e4c753ae811ebb15c83aedc46c81b'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('e40e4c753ae811ebb15c83aedc46c81b')) AND tl_files.extension IN('mp4','m4v','mov','wmv','webm') ORDER BY tl_files.uuid!=UNHEX('e40e4c753ae811ebb15c83aedc46c81b');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1743673380
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1743673380
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=42 AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1743673380) AND (tl_page.stop='' OR tl_page.stop>1743673380) LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN (?)

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('home');

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_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = ?
  AND (
    (
      tl_calendar_events.startTime >= 0
      AND tl_calendar_events.startTime <= 4899347024
    )
    OR (
      tl_calendar_events.endTime >= 0
      AND tl_calendar_events.endTime <= 4899347024
    )
    OR (
      tl_calendar_events.startTime <= 0
      AND tl_calendar_events.endTime >= 4899347024
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 0
      )
      AND tl_calendar_events.startTime <= 4899347024
    )
  )
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1743673380'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1743673440'
  )
  AND tl_calendar_events.published = '1'
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid=1 AND ((tl_calendar_events.startTime>=0 AND tl_calendar_events.startTime<=4899347024) OR (tl_calendar_events.endTime>=0 AND tl_calendar_events.endTime<=4899347024) OR (tl_calendar_events.startTime<=0 AND tl_calendar_events.endTime>=4899347024) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=0) AND tl_calendar_events.startTime<=4899347024)) AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1743673380') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1743673440') AND tl_calendar_events.published='1' ORDER BY tl_calendar_events.startTime;

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;

SHOW FULL COLUMNS
FROM
  tl_hofff_consent_tag

SHOW FULL COLUMNS FROM tl_hofff_consent_tag;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(36, 37, 38, 118)
  AND tl_page.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1743673380
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1743673380
  )
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '36,37,38,118')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(36,37,38,118) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1743673380) AND (tl_page.stop='' OR tl_page.stop>1743673380) ORDER BY FIND_IN_SET(`tl_page`.`id`, '36,37,38,118');

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = ?
  AND tl_article.inColumn = ?
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= 1743673380
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1743673380
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=32 AND tl_article.inColumn='main' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1743673380) AND (tl_article.stop='' OR tl_article.stop>1743673380) ORDER BY tl_article.sorting;

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = ?
  AND (
    (
      tl_calendar_events.startTime >= 1743673424
      AND tl_calendar_events.startTime <= 4294967295
    )
    OR (
      tl_calendar_events.endTime >= 1743673424
      AND tl_calendar_events.endTime <= 4294967295
    )
    OR (
      tl_calendar_events.startTime <= 1743673424
      AND tl_calendar_events.endTime >= 4294967295
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 1743673424
      )
      AND tl_calendar_events.startTime <= 4294967295
    )
  )
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1743673380'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1743673440'
  )
  AND tl_calendar_events.published = '1'
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid=1 AND ((tl_calendar_events.startTime>=1743673424 AND tl_calendar_events.startTime<=4294967295) OR (tl_calendar_events.endTime>=1743673424 AND tl_calendar_events.endTime<=4294967295) OR (tl_calendar_events.startTime<=1743673424 AND tl_calendar_events.endTime>=4294967295) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=1743673424) AND tl_calendar_events.startTime<=4294967295)) AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1743673380') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1743673440') AND tl_calendar_events.published='1' ORDER BY tl_calendar_events.startTime;

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = ?
  AND (
    (
      tl_calendar_events.startTime >= 0
      AND tl_calendar_events.startTime <= 4899347025
    )
    OR (
      tl_calendar_events.endTime >= 0
      AND tl_calendar_events.endTime <= 4899347025
    )
    OR (
      tl_calendar_events.startTime <= 0
      AND tl_calendar_events.endTime >= 4899347025
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 0
      )
      AND tl_calendar_events.startTime <= 4899347025
    )
  )
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1743673380'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1743673440'
  )
  AND tl_calendar_events.published = '1'
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid=1 AND ((tl_calendar_events.startTime>=0 AND tl_calendar_events.startTime<=4899347025) OR (tl_calendar_events.endTime>=0 AND tl_calendar_events.endTime<=4899347025) OR (tl_calendar_events.startTime<=0 AND tl_calendar_events.endTime>=4899347025) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=0) AND tl_calendar_events.startTime<=4899347025)) AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1743673380') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1743673440') AND tl_calendar_events.published='1' ORDER BY tl_calendar_events.startTime;

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = ?
  AND (
    (
      tl_calendar_events.startTime >= 1743673425
      AND tl_calendar_events.startTime <= 4294967295
    )
    OR (
      tl_calendar_events.endTime >= 1743673425
      AND tl_calendar_events.endTime <= 4294967295
    )
    OR (
      tl_calendar_events.startTime <= 1743673425
      AND tl_calendar_events.endTime >= 4294967295
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 1743673425
      )
      AND tl_calendar_events.startTime <= 4294967295
    )
  )
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1743673380'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1743673440'
  )
  AND tl_calendar_events.published = '1'
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid=1 AND ((tl_calendar_events.startTime>=1743673425 AND tl_calendar_events.startTime<=4294967295) OR (tl_calendar_events.endTime>=1743673425 AND tl_calendar_events.endTime<=4294967295) OR (tl_calendar_events.startTime<=1743673425 AND tl_calendar_events.endTime>=4294967295) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=1743673425) AND tl_calendar_events.startTime<=4294967295)) AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1743673380') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1743673440') AND tl_calendar_events.published='1' ORDER BY tl_calendar_events.startTime;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(37, 38, 53, 52, 0, 36, 34, 35)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '37,38,53,52,0,36,34,35'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(37,38,53,52,0,36,34,35) ORDER BY FIND_IN_SET(`tl_module`.`id`, '37,38,53,52,0,36,34,35');

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
  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;

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

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

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

SELECT tl_article.* FROM tl_article WHERE tl_article.id='109' LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(77, 78, 79, 124, 119, 113, 80, 81, 120)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '77,78,79,124,119,113,80,81,120'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(77,78,79,124,119,113,80,81,120) ORDER BY FIND_IN_SET(`tl_page`.`id`, '77,78,79,124,119,113,80,81,120');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(63, 64, 65, 66, 67, 68, 69)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '63,64,65,66,67,68,69'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(63,64,65,66,67,68,69) ORDER BY FIND_IN_SET(`tl_page`.`id`, '63,64,65,66,67,68,69');

SELECT
  tl_calendar.*
FROM
  tl_calendar
WHERE
  tl_calendar.id IN(1)
ORDER BY
  FIND_IN_SET(`tl_calendar`.`id`, '1')

SELECT tl_calendar.* FROM tl_calendar WHERE tl_calendar.id IN(1) ORDER BY FIND_IN_SET(`tl_calendar`.`id`, '1');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(57, 46, 49, 50, 51)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '57,46,49,50,51'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(57,46,49,50,51) ORDER BY FIND_IN_SET(`tl_page`.`id`, '57,46,49,50,51');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(61, 62, 70, 71, 72, 75, 76, 82, 86)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '61,62,70,71,72,75,76,82,86'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(61,62,70,71,72,75,76,82,86) ORDER BY FIND_IN_SET(`tl_page`.`id`, '61,62,70,71,72,75,76,82,86');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(39, 40, 48, 41)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '39,40,48,41')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(39,40,48,41) ORDER BY FIND_IN_SET(`tl_page`.`id`, '39,40,48,41');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(42, 43, 45, 87)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '42,43,45,87')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(42,43,45,87) ORDER BY FIND_IN_SET(`tl_page`.`id`, '42,43,45,87');

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

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

SHOW INDEXES
FROM
  `tl_hofff_consent_tag`

SHOW INDEXES FROM `tl_hofff_consent_tag`;

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';