Symfony Profiler

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
  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 <= 1743740700
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1743740700
      )
  ) 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 <= 1743740700
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1743740700
  )
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<=1743740700) AND (p2.stop='' OR p2.stop>1743740700)) 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<=1743740700) AND (p1.stop='' OR p1.stop>1743740700) ORDER BY p1.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=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 <= 1743740700
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1743740700
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= 1743740700
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1743740700
  )
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<=1743740700) AND (tl_page.stop='' OR tl_page.stop>1743740700) 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
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      'a4e196a59a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dad8f07d9a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dacda75d9a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'daeece629a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dc42b21d9a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dcc50c589a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dd40026c9a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dd07dfab9a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dd536f669a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dd67f4ae9a0c11eca3e4efbbdc1e01aa'
    ),
    UNHEX(
      'dd856a019a0c11eca3e4efbbdc1e01aa'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    'a4e196a59a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dad8f07d9a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dacda75d9a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'daeece629a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dc42b21d9a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dcc50c589a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dd40026c9a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dd07dfab9a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dd536f669a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dd67f4ae9a0c11eca3e4efbbdc1e01aa'
  ),
  tl_files.uuid != UNHEX(
    'dd856a019a0c11eca3e4efbbdc1e01aa'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('a4e196a59a0c11eca3e4efbbdc1e01aa'),UNHEX('dad8f07d9a0c11eca3e4efbbdc1e01aa'),UNHEX('dacda75d9a0c11eca3e4efbbdc1e01aa'),UNHEX('daeece629a0c11eca3e4efbbdc1e01aa'),UNHEX('dc42b21d9a0c11eca3e4efbbdc1e01aa'),UNHEX('dcc50c589a0c11eca3e4efbbdc1e01aa'),UNHEX('dd40026c9a0c11eca3e4efbbdc1e01aa'),UNHEX('dd07dfab9a0c11eca3e4efbbdc1e01aa'),UNHEX('dd536f669a0c11eca3e4efbbdc1e01aa'),UNHEX('dd67f4ae9a0c11eca3e4efbbdc1e01aa'),UNHEX('dd856a019a0c11eca3e4efbbdc1e01aa')) ORDER BY tl_files.uuid!=UNHEX('a4e196a59a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dad8f07d9a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dacda75d9a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('daeece629a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dc42b21d9a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dcc50c589a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dd40026c9a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dd07dfab9a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dd536f669a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dd67f4ae9a0c11eca3e4efbbdc1e01aa'), tl_files.uuid!=UNHEX('dd856a019a0c11eca3e4efbbdc1e01aa');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.pid = ?
  AND tl_page.type != 'root'
  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 <= 1743740700
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1743740700
  )
ORDER BY
  tl_page.sorting
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.pid=1 AND tl_page.type!='root' 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<=1743740700) AND (tl_page.stop='' OR tl_page.stop>1743740700) ORDER BY tl_page.sorting 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`=61 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 ('solutions/instrumentation','solutions');

SELECT
  tl_sg_references.*,
  j1.`id` AS pid__id,
  j1.`tstamp` AS pid__tstamp,
  j1.`title` AS pid__title,
  j1.`jumpTo` AS pid__jumpTo,
  j1.`protected` AS pid__protected,
  j1.`groups` AS pid__groups
FROM
  tl_sg_references
  LEFT JOIN tl_sg_references_category j1 ON tl_sg_references.`pid` = j1.id
WHERE
  tl_sg_references.pid IN(3)
  AND (
    tl_sg_references.start = ''
    OR tl_sg_references.start < 1743740755
  )
  AND (
    tl_sg_references.stop = ''
    OR tl_sg_references.stop > 1743740755
  )
  AND tl_sg_references.invisible = ''
ORDER BY
  tl_sg_references.sorting ASC
LIMIT
  0, 2

SELECT tl_sg_references.*, j1.`id` AS pid__id, j1.`tstamp` AS pid__tstamp, j1.`title` AS pid__title, j1.`jumpTo` AS pid__jumpTo, j1.`protected` AS pid__protected, j1.`groups` AS pid__groups FROM tl_sg_references LEFT JOIN tl_sg_references_category j1 ON tl_sg_references.`pid`=j1.id WHERE tl_sg_references.pid IN(3) AND (tl_sg_references.start='' OR tl_sg_references.start<1743740755) AND (tl_sg_references.stop='' OR tl_sg_references.stop>1743740755) AND tl_sg_references.invisible='' ORDER BY tl_sg_references.sorting ASC LIMIT 0,2;

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = ?
  AND (
    (
      tl_calendar_events.startTime >= 0
      AND tl_calendar_events.startTime <= 4899414355
    )
    OR (
      tl_calendar_events.endTime >= 0
      AND tl_calendar_events.endTime <= 4899414355
    )
    OR (
      tl_calendar_events.startTime <= 0
      AND tl_calendar_events.endTime >= 4899414355
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 0
      )
      AND tl_calendar_events.startTime <= 4899414355
    )
  )
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1743740700'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1743740760'
  )
  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=4 AND ((tl_calendar_events.startTime>=0 AND tl_calendar_events.startTime<=4899414355) OR (tl_calendar_events.endTime>=0 AND tl_calendar_events.endTime<=4899414355) OR (tl_calendar_events.startTime<=0 AND tl_calendar_events.endTime>=4899414355) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=0) AND tl_calendar_events.startTime<=4899414355)) AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1743740700') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1743740760') AND tl_calendar_events.published='1' ORDER BY tl_calendar_events.startTime;

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 <= 4294967295
    )
    OR (
      tl_calendar_events.endTime >= 0
      AND tl_calendar_events.endTime <= 4294967295
    )
    OR (
      tl_calendar_events.startTime <= 0
      AND tl_calendar_events.endTime >= 4294967295
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 0
      )
      AND tl_calendar_events.startTime <= 4294967295
    )
  )
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1743740700'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1743740760'
  )
  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=4 AND ((tl_calendar_events.startTime>=0 AND tl_calendar_events.startTime<=4294967295) OR (tl_calendar_events.endTime>=0 AND tl_calendar_events.endTime<=4294967295) OR (tl_calendar_events.startTime<=0 AND tl_calendar_events.endTime>=4294967295) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=0) AND tl_calendar_events.startTime<=4294967295)) AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1743740700') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1743740760') AND tl_calendar_events.published='1' ORDER BY tl_calendar_events.startTime;

SHOW FULL COLUMNS
FROM
  tl_hofff_consent_tag

SHOW FULL COLUMNS FROM tl_hofff_consent_tag;

SELECT
  COUNT(*) AS count
FROM
  tl_sg_references
WHERE
  tl_sg_references.pid IN(3)
  AND (
    tl_sg_references.start = ''
    OR tl_sg_references.start < 1743740755
  )
  AND (
    tl_sg_references.stop = ''
    OR tl_sg_references.stop > 1743740755
  )
  AND tl_sg_references.invisible = ''

SELECT COUNT(*) AS count FROM tl_sg_references WHERE tl_sg_references.pid IN(3) AND (tl_sg_references.start='' OR tl_sg_references.start<1743740755) AND (tl_sg_references.stop='' OR tl_sg_references.stop>1743740755) AND tl_sg_references.invisible='';

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
  tl_sg_locations.*,
  j1.`id` AS pid__id,
  j1.`tstamp` AS pid__tstamp,
  j1.`title` AS pid__title
FROM
  tl_sg_locations
  LEFT JOIN tl_sg_locations_category j1 ON tl_sg_locations.`pid` = j1.id
WHERE
  tl_sg_locations.id = ?
LIMIT
  0, 1

SELECT tl_sg_locations.*, j1.`id` AS pid__id, j1.`tstamp` AS pid__tstamp, j1.`title` AS pid__title FROM tl_sg_locations LEFT JOIN tl_sg_locations_category j1 ON tl_sg_locations.`pid`=j1.id WHERE tl_sg_locations.id=1 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 = ?)
  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_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 <= 1743740700
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1743740700
  )
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<=1743740700) AND (tl_page.stop='' OR tl_page.stop>1743740700) ORDER BY FIND_IN_SET(`tl_page`.`id`, '36,37,38,118');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(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(40,48,41) ORDER BY FIND_IN_SET(`tl_page`.`id`, '39,40,48,41');

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 <= 1743740700
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1743740700
  )
ORDER BY
  tl_article.sorting

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

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(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(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(42, 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,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(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_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_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_calendar.*
FROM
  tl_calendar
WHERE
  tl_calendar.id IN(4)
ORDER BY
  FIND_IN_SET(`tl_calendar`.`id`, '4')

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

SHOW INDEXES
FROM
  `tl_hofff_consent_tag`

SHOW INDEXES FROM `tl_hofff_consent_tag`;

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

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

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';