Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'c3_dls'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  *
FROM
  tl_catalog
ORDER BY
  `pTable` DESC,
  `tablename` ASC

SELECT * FROM tl_catalog ORDER BY `pTable` DESC, `tablename` ASC;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`type` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?

SELECT id FROM tl_catalog WHERE tablename = 'tl_page';

SELECT
  *
FROM
  tl_catalog
WHERE
  `tablename` = ?
LIMIT
  0, 1

SELECT * FROM tl_catalog WHERE `tablename` = 'tl_page' LIMIT 0,1;

SELECT
  *
FROM
  tl_catalog
WHERE
  `tablename` = ?
LIMIT
  0, 1

SELECT * FROM tl_catalog WHERE `tablename` = 'tl_page' LIMIT 0,1;

SELECT
  *
FROM
  tl_catalog_fields
WHERE
  `pid` = (
    SELECT
      id
    FROM
      tl_catalog
    WHERE
      `tablename` = ?
    LIMIT
      1
  ) AND invisible != "1"
ORDER BY
  `sorting`

SELECT * FROM tl_catalog_fields WHERE `pid` = ( SELECT id FROM tl_catalog WHERE `tablename` = 'tl_page' LIMIT 1 ) AND invisible != "1" ORDER BY `sorting`;

SHOW FULL COLUMNS
FROM
  ctlg_category

SHOW FULL COLUMNS FROM ctlg_category;

SHOW INDEXES
FROM
  `ctlg_category`

SHOW INDEXES FROM `ctlg_category`;

SELECT
  *
FROM
  tl_catalog
WHERE
  id = ?
LIMIT
  0, 1

SELECT * FROM tl_catalog WHERE id = 1 LIMIT 0,1;

SELECT
  *
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  1

SELECT * FROM tl_catalog WHERE tablename = 'ctlg_category' LIMIT 1;

SELECT
  *
FROM
  ctlg_category
ORDER BY
  title DESC

SELECT * FROM ctlg_category ORDER BY title DESC;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`type` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_cms_settings' LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.type = ?
  AND (
    tl_page.dns = ?
    OR tl_page.dns = ?
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND (tl_page.dns='dls.c5.bargon.net' OR tl_page.dns='') 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 ('aktuelles/gewinnspiel','aktuelles');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='aktuelles/gewinnspiel';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='dls.c5.bargon.net' OR tl_page.dns=''));

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('aktuelles/gewinnspiel','aktuelles');

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_linkingyou_redirecter_redirects' LIMIT 0,1;

SELECT
  tl_linkingyou_redirecter_redirects.*,
  j1.`id` AS destination_page__id,
  j1.`pid` AS destination_page__pid,
  j1.`sorting` AS destination_page__sorting,
  j1.`tstamp` AS destination_page__tstamp,
  j1.`title` AS destination_page__title,
  j1.`type` AS destination_page__type,
  j1.`alias` AS destination_page__alias,
  j1.`requireItem` AS destination_page__requireItem,
  j1.`routePriority` AS destination_page__routePriority,
  j1.`pageTitle` AS destination_page__pageTitle,
  j1.`language` AS destination_page__language,
  j1.`robots` AS destination_page__robots,
  j1.`description` AS destination_page__description,
  j1.`redirect` AS destination_page__redirect,
  j1.`alwaysForward` AS destination_page__alwaysForward,
  j1.`jumpTo` AS destination_page__jumpTo,
  j1.`redirectBack` AS destination_page__redirectBack,
  j1.`url` AS destination_page__url,
  j1.`target` AS destination_page__target,
  j1.`dns` AS destination_page__dns,
  j1.`staticFiles` AS destination_page__staticFiles,
  j1.`staticPlugins` AS destination_page__staticPlugins,
  j1.`fallback` AS destination_page__fallback,
  j1.`disableLanguageRedirect` AS destination_page__disableLanguageRedirect,
  j1.`favicon` AS destination_page__favicon,
  j1.`robotsTxt` AS destination_page__robotsTxt,
  j1.`maintenanceMode` AS destination_page__maintenanceMode,
  j1.`mailerTransport` AS destination_page__mailerTransport,
  j1.`enableCanonical` AS destination_page__enableCanonical,
  j1.`canonicalLink` AS destination_page__canonicalLink,
  j1.`canonicalKeepParams` AS destination_page__canonicalKeepParams,
  j1.`adminEmail` AS destination_page__adminEmail,
  j1.`dateFormat` AS destination_page__dateFormat,
  j1.`timeFormat` AS destination_page__timeFormat,
  j1.`datimFormat` AS destination_page__datimFormat,
  j1.`validAliasCharacters` AS destination_page__validAliasCharacters,
  j1.`useFolderUrl` AS destination_page__useFolderUrl,
  j1.`urlPrefix` AS destination_page__urlPrefix,
  j1.`urlSuffix` AS destination_page__urlSuffix,
  j1.`useSSL` AS destination_page__useSSL,
  j1.`autoforward` AS destination_page__autoforward,
  j1.`protected` AS destination_page__protected,
  j1.`groups` AS destination_page__groups,
  j1.`includeLayout` AS destination_page__includeLayout,
  j1.`layout` AS destination_page__layout,
  j1.`subpageLayout` AS destination_page__subpageLayout,
  j1.`includeCache` AS destination_page__includeCache,
  j1.`cache` AS destination_page__cache,
  j1.`alwaysLoadFromCache` AS destination_page__alwaysLoadFromCache,
  j1.`clientCache` AS destination_page__clientCache,
  j1.`includeChmod` AS destination_page__includeChmod,
  j1.`cuser` AS destination_page__cuser,
  j1.`cgroup` AS destination_page__cgroup,
  j1.`chmod` AS destination_page__chmod,
  j1.`noSearch` AS destination_page__noSearch,
  j1.`cssClass` AS destination_page__cssClass,
  j1.`sitemap` AS destination_page__sitemap,
  j1.`hide` AS destination_page__hide,
  j1.`guests` AS destination_page__guests,
  j1.`tabindex` AS destination_page__tabindex,
  j1.`accesskey` AS destination_page__accesskey,
  j1.`published` AS destination_page__published,
  j1.`start` AS destination_page__start,
  j1.`stop` AS destination_page__stop,
  j1.`enforceTwoFactor` AS destination_page__enforceTwoFactor,
  j1.`twoFactorJumpTo` AS destination_page__twoFactorJumpTo,
  j1.`mobileLayout` AS destination_page__mobileLayout,
  j1.`dlh_googlemaps_apikey` AS destination_page__dlh_googlemaps_apikey,
  j1.`catalogUseMaster` AS destination_page__catalogUseMaster,
  j1.`catalogShowInBreadcrumb` AS destination_page__catalogShowInBreadcrumb,
  j1.`catalogUseChangeLanguage` AS destination_page__catalogUseChangeLanguage,
  j1.`catalogUseRouting` AS destination_page__catalogUseRouting,
  j1.`catalogRoutingParameter` AS destination_page__catalogRoutingParameter,
  j1.`catalogSetAutoItem` AS destination_page__catalogSetAutoItem,
  j1.`catalogRouting` AS destination_page__catalogRouting,
  j1.`catalogChangeLanguageTable` AS destination_page__catalogChangeLanguageTable,
  j1.`catalogMasterTable` AS destination_page__catalogMasterTable,
  j1.`catalogRoutingTable` AS destination_page__catalogRoutingTable,
  j1.`canonicalType` AS destination_page__canonicalType,
  j1.`canonicalJumpTo` AS destination_page__canonicalJumpTo,
  j1.`canonicalWebsite` AS destination_page__canonicalWebsite,
  j1.`cms_root_license` AS destination_page__cms_root_license,
  j1.`cms_exclude_health_check` AS destination_page__cms_exclude_health_check,
  j1.`cms_root_key` AS destination_page__cms_root_key,
  j1.`cms_root_data` AS destination_page__cms_root_data,
  j1.`cms_root_sign` AS destination_page__cms_root_sign,
  j1.`cms_mi_views` AS destination_page__cms_mi_views,
  j1.`cms_mi_reset` AS destination_page__cms_mi_reset,
  j1.`iso_config` AS destination_page__iso_config,
  j1.`iso_store_id` AS destination_page__iso_store_id,
  j1.`iso_readerMode` AS destination_page__iso_readerMode,
  j1.`iso_readerJumpTo` AS destination_page__iso_readerJumpTo,
  j1.`iso_sitemapVariants` AS destination_page__iso_sitemapVariants,
  j1.`dls_categories` AS destination_page__dls_categories
FROM
  tl_linkingyou_redirecter_redirects
  LEFT JOIN tl_page j1 ON tl_linkingyou_redirecter_redirects.`destination_page` = j1.id
WHERE
  tl_linkingyou_redirecter_redirects.source_url = ?
  AND tl_linkingyou_redirecter_redirects.published = ?
LIMIT
  0, 1

SELECT tl_linkingyou_redirecter_redirects.*, j1.`id` AS destination_page__id, j1.`pid` AS destination_page__pid, j1.`sorting` AS destination_page__sorting, j1.`tstamp` AS destination_page__tstamp, j1.`title` AS destination_page__title, j1.`type` AS destination_page__type, j1.`alias` AS destination_page__alias, j1.`requireItem` AS destination_page__requireItem, j1.`routePriority` AS destination_page__routePriority, j1.`pageTitle` AS destination_page__pageTitle, j1.`language` AS destination_page__language, j1.`robots` AS destination_page__robots, j1.`description` AS destination_page__description, j1.`redirect` AS destination_page__redirect, j1.`alwaysForward` AS destination_page__alwaysForward, j1.`jumpTo` AS destination_page__jumpTo, j1.`redirectBack` AS destination_page__redirectBack, j1.`url` AS destination_page__url, j1.`target` AS destination_page__target, j1.`dns` AS destination_page__dns, j1.`staticFiles` AS destination_page__staticFiles, j1.`staticPlugins` AS destination_page__staticPlugins, j1.`fallback` AS destination_page__fallback, j1.`disableLanguageRedirect` AS destination_page__disableLanguageRedirect, j1.`favicon` AS destination_page__favicon, j1.`robotsTxt` AS destination_page__robotsTxt, j1.`maintenanceMode` AS destination_page__maintenanceMode, j1.`mailerTransport` AS destination_page__mailerTransport, j1.`enableCanonical` AS destination_page__enableCanonical, j1.`canonicalLink` AS destination_page__canonicalLink, j1.`canonicalKeepParams` AS destination_page__canonicalKeepParams, j1.`adminEmail` AS destination_page__adminEmail, j1.`dateFormat` AS destination_page__dateFormat, j1.`timeFormat` AS destination_page__timeFormat, j1.`datimFormat` AS destination_page__datimFormat, j1.`validAliasCharacters` AS destination_page__validAliasCharacters, j1.`useFolderUrl` AS destination_page__useFolderUrl, j1.`urlPrefix` AS destination_page__urlPrefix, j1.`urlSuffix` AS destination_page__urlSuffix, j1.`useSSL` AS destination_page__useSSL, j1.`autoforward` AS destination_page__autoforward, j1.`protected` AS destination_page__protected, j1.`groups` AS destination_page__groups, j1.`includeLayout` AS destination_page__includeLayout, j1.`layout` AS destination_page__layout, j1.`subpageLayout` AS destination_page__subpageLayout, j1.`includeCache` AS destination_page__includeCache, j1.`cache` AS destination_page__cache, j1.`alwaysLoadFromCache` AS destination_page__alwaysLoadFromCache, j1.`clientCache` AS destination_page__clientCache, j1.`includeChmod` AS destination_page__includeChmod, j1.`cuser` AS destination_page__cuser, j1.`cgroup` AS destination_page__cgroup, j1.`chmod` AS destination_page__chmod, j1.`noSearch` AS destination_page__noSearch, j1.`cssClass` AS destination_page__cssClass, j1.`sitemap` AS destination_page__sitemap, j1.`hide` AS destination_page__hide, j1.`guests` AS destination_page__guests, j1.`tabindex` AS destination_page__tabindex, j1.`accesskey` AS destination_page__accesskey, j1.`published` AS destination_page__published, j1.`start` AS destination_page__start, j1.`stop` AS destination_page__stop, j1.`enforceTwoFactor` AS destination_page__enforceTwoFactor, j1.`twoFactorJumpTo` AS destination_page__twoFactorJumpTo, j1.`mobileLayout` AS destination_page__mobileLayout, j1.`dlh_googlemaps_apikey` AS destination_page__dlh_googlemaps_apikey, j1.`catalogUseMaster` AS destination_page__catalogUseMaster, j1.`catalogShowInBreadcrumb` AS destination_page__catalogShowInBreadcrumb, j1.`catalogUseChangeLanguage` AS destination_page__catalogUseChangeLanguage, j1.`catalogUseRouting` AS destination_page__catalogUseRouting, j1.`catalogRoutingParameter` AS destination_page__catalogRoutingParameter, j1.`catalogSetAutoItem` AS destination_page__catalogSetAutoItem, j1.`catalogRouting` AS destination_page__catalogRouting, j1.`catalogChangeLanguageTable` AS destination_page__catalogChangeLanguageTable, j1.`catalogMasterTable` AS destination_page__catalogMasterTable, j1.`catalogRoutingTable` AS destination_page__catalogRoutingTable, j1.`canonicalType` AS destination_page__canonicalType, j1.`canonicalJumpTo` AS destination_page__canonicalJumpTo, j1.`canonicalWebsite` AS destination_page__canonicalWebsite, j1.`cms_root_license` AS destination_page__cms_root_license, j1.`cms_exclude_health_check` AS destination_page__cms_exclude_health_check, j1.`cms_root_key` AS destination_page__cms_root_key, j1.`cms_root_data` AS destination_page__cms_root_data, j1.`cms_root_sign` AS destination_page__cms_root_sign, j1.`cms_mi_views` AS destination_page__cms_mi_views, j1.`cms_mi_reset` AS destination_page__cms_mi_reset, j1.`iso_config` AS destination_page__iso_config, j1.`iso_store_id` AS destination_page__iso_store_id, j1.`iso_readerMode` AS destination_page__iso_readerMode, j1.`iso_readerJumpTo` AS destination_page__iso_readerJumpTo, j1.`iso_sitemapVariants` AS destination_page__iso_sitemapVariants, j1.`dls_categories` AS destination_page__dls_categories FROM tl_linkingyou_redirecter_redirects LEFT JOIN tl_page j1 ON tl_linkingyou_redirecter_redirects.`destination_page`=j1.id WHERE tl_linkingyou_redirecter_redirects.source_url = '/aktuelles/gewinnspiel.html' AND tl_linkingyou_redirecter_redirects.published = 1 LIMIT 0,1;

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_layout' 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`=9 LIMIT 0,1;

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_theme' LIMIT 0,1;

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

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

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_module' LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`type` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`type` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`type` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_cms_tag_settings' LIMIT 0,1;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(39, 40, 86, 67, 0, 94)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '39,40,86,67,0,94'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(39,40,86,67,0,94) ORDER BY FIND_IN_SET(`tl_module`.`id`, '39,40,86,67,0,94');

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_article' LIMIT 0,1;

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

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

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_content' LIMIT 0,1;

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

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

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.type in ('cms_overlay')
  AND tl_content.ptable = ?
  AND tl_content.invisible = ?
  AND tl_content.cms_pages_scope != ?
  AND tl_content.cms_pages_scope != ?

SELECT tl_content.* FROM tl_content WHERE tl_content.type in ('cms_overlay') AND tl_content.ptable='tl_cms_conversion_item' AND tl_content.invisible='' AND tl_content.cms_pages_scope!='' AND tl_content.cms_pages_scope!='none';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.`type` = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';

SELECT
  *,
  (
    SELECT
      tstamp
    FROM
      tl_theme
    WHERE
      tl_theme.id = tl_style_sheet.pid
  ) AS tstamp3,
  (
    SELECT
      MAX(tstamp)
    FROM
      tl_style
    WHERE
      tl_style.pid = tl_style_sheet.id
  ) AS tstamp2,
  (
    SELECT
      COUNT(*)
    FROM
      tl_style
    WHERE
      tl_style.selector = '@font-face'
      AND tl_style.invisible = ''
      AND tl_style.pid = tl_style_sheet.id
  ) AS hasFontFace
FROM
  tl_style_sheet
WHERE
  id IN (
    5, 2, 3, 7, 8, 9, 11, 13, 14, 15, 17, 16, 18,
    19, 20, 21
  )
ORDER BY
  FIND_IN_SET(
    `id`, '5,2,3,7,8,9,11,13,14,15,17,16,18,19,20,21'
  )

SELECT *, (SELECT tstamp FROM tl_theme WHERE tl_theme.id=tl_style_sheet.pid) AS tstamp3, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.invisible='' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (5,2,3,7,8,9,11,13,14,15,17,16,18,19,20,21) ORDER BY FIND_IN_SET(`id`, '5,2,3,7,8,9,11,13,14,15,17,16,18,19,20,21');

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_style_sheet' LIMIT 0,1;

SELECT
  id
FROM
  tl_catalog
WHERE
  tablename = ?
LIMIT
  0, 1

SELECT id FROM tl_catalog WHERE tablename = 'tl_files' LIMIT 0,1;

SELECT
  tl_files.*
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '9e7d6fd8a4ca11e6ac25001c42000273'
    ),
    UNHEX(
      'e4696c8e908911e68044001c42000273'
    ),
    UNHEX(
      '55bc4b40bbce11e6b371001c42000273'
    ),
    UNHEX(
      'b363117e8ad311e68044001c42000273'
    ),
    UNHEX(
      '1021d5ac8ecc11e68044001c42000273'
    ),
    UNHEX(
      '3804a3d74f4811e69e21001c42000273'
    ),
    UNHEX(
      '3804a3a94f4811e69e21001c42000273'
    ),
    UNHEX(
      '1cfb5efe5e8511e886060cc47a76f45e'
    ),
    UNHEX(
      'f31522343f7b11efa0078ada7f861d63'
    ),
    UNHEX(
      '60e9e37968d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '60e9e36568d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '60e9e35a68d211ee881f8ada7f861d63'
    ),
    UNHEX(
      'd5434da968d411ee881f8ada7f861d63'
    ),
    UNHEX(
      '60e9e33b68d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '60f1e4f368d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '3b6e2b21555a11ef88ab8ada7f861d63'
    ),
    UNHEX(
      '30b1f1605bcc11ef88ab8ada7f861d63'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '9e7d6fd8a4ca11e6ac25001c42000273'
  ),
  tl_files.uuid != UNHEX(
    'e4696c8e908911e68044001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '55bc4b40bbce11e6b371001c42000273'
  ),
  tl_files.uuid != UNHEX(
    'b363117e8ad311e68044001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '1021d5ac8ecc11e68044001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '3804a3d74f4811e69e21001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '3804a3a94f4811e69e21001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '1cfb5efe5e8511e886060cc47a76f45e'
  ),
  tl_files.uuid != UNHEX(
    'f31522343f7b11efa0078ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e37968d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e36568d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e35a68d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    'd5434da968d411ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e33b68d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60f1e4f368d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '3b6e2b21555a11ef88ab8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '30b1f1605bcc11ef88ab8ada7f861d63'
  )

SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('9e7d6fd8a4ca11e6ac25001c42000273'),UNHEX('e4696c8e908911e68044001c42000273'),UNHEX('55bc4b40bbce11e6b371001c42000273'),UNHEX('b363117e8ad311e68044001c42000273'),UNHEX('1021d5ac8ecc11e68044001c42000273'),UNHEX('3804a3d74f4811e69e21001c42000273'),UNHEX('3804a3a94f4811e69e21001c42000273'),UNHEX('1cfb5efe5e8511e886060cc47a76f45e'),UNHEX('f31522343f7b11efa0078ada7f861d63'),UNHEX('60e9e37968d211ee881f8ada7f861d63'),UNHEX('60e9e36568d211ee881f8ada7f861d63'),UNHEX('60e9e35a68d211ee881f8ada7f861d63'),UNHEX('d5434da968d411ee881f8ada7f861d63'),UNHEX('60e9e33b68d211ee881f8ada7f861d63'),UNHEX('60f1e4f368d211ee881f8ada7f861d63'),UNHEX('3b6e2b21555a11ef88ab8ada7f861d63'),UNHEX('30b1f1605bcc11ef88ab8ada7f861d63')) ORDER BY tl_files.uuid!=UNHEX('9e7d6fd8a4ca11e6ac25001c42000273'), tl_files.uuid!=UNHEX('e4696c8e908911e68044001c42000273'), tl_files.uuid!=UNHEX('55bc4b40bbce11e6b371001c42000273'), tl_files.uuid!=UNHEX('b363117e8ad311e68044001c42000273'), tl_files.uuid!=UNHEX('1021d5ac8ecc11e68044001c42000273'), tl_files.uuid!=UNHEX('3804a3d74f4811e69e21001c42000273'), tl_files.uuid!=UNHEX('3804a3a94f4811e69e21001c42000273'), tl_files.uuid!=UNHEX('1cfb5efe5e8511e886060cc47a76f45e'), tl_files.uuid!=UNHEX('f31522343f7b11efa0078ada7f861d63'), tl_files.uuid!=UNHEX('60e9e37968d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e36568d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e35a68d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('d5434da968d411ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e33b68d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60f1e4f368d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('3b6e2b21555a11ef88ab8ada7f861d63'), tl_files.uuid!=UNHEX('30b1f1605bcc11ef88ab8ada7f861d63');

SELECT
  tl_files.*
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '9e7d6fd8a4ca11e6ac25001c42000273'
    ),
    UNHEX(
      'e4696c8e908911e68044001c42000273'
    ),
    UNHEX(
      '55bc4b40bbce11e6b371001c42000273'
    ),
    UNHEX(
      'b363117e8ad311e68044001c42000273'
    ),
    UNHEX(
      '1021d5ac8ecc11e68044001c42000273'
    ),
    UNHEX(
      '3804a3d74f4811e69e21001c42000273'
    ),
    UNHEX(
      '3804a3a94f4811e69e21001c42000273'
    ),
    UNHEX(
      '1cfb5efe5e8511e886060cc47a76f45e'
    ),
    UNHEX(
      'f31522343f7b11efa0078ada7f861d63'
    ),
    UNHEX(
      '60e9e37968d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '60e9e36568d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '60e9e35a68d211ee881f8ada7f861d63'
    ),
    UNHEX(
      'd5434da968d411ee881f8ada7f861d63'
    ),
    UNHEX(
      '60e9e33b68d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '60f1e4f368d211ee881f8ada7f861d63'
    ),
    UNHEX(
      '3b6e2b21555a11ef88ab8ada7f861d63'
    ),
    UNHEX(
      '30b1f1605bcc11ef88ab8ada7f861d63'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '9e7d6fd8a4ca11e6ac25001c42000273'
  ),
  tl_files.uuid != UNHEX(
    'e4696c8e908911e68044001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '55bc4b40bbce11e6b371001c42000273'
  ),
  tl_files.uuid != UNHEX(
    'b363117e8ad311e68044001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '1021d5ac8ecc11e68044001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '3804a3d74f4811e69e21001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '3804a3a94f4811e69e21001c42000273'
  ),
  tl_files.uuid != UNHEX(
    '1cfb5efe5e8511e886060cc47a76f45e'
  ),
  tl_files.uuid != UNHEX(
    'f31522343f7b11efa0078ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e37968d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e36568d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e35a68d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    'd5434da968d411ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60e9e33b68d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '60f1e4f368d211ee881f8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '3b6e2b21555a11ef88ab8ada7f861d63'
  ),
  tl_files.uuid != UNHEX(
    '30b1f1605bcc11ef88ab8ada7f861d63'
  )

SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('9e7d6fd8a4ca11e6ac25001c42000273'),UNHEX('e4696c8e908911e68044001c42000273'),UNHEX('55bc4b40bbce11e6b371001c42000273'),UNHEX('b363117e8ad311e68044001c42000273'),UNHEX('1021d5ac8ecc11e68044001c42000273'),UNHEX('3804a3d74f4811e69e21001c42000273'),UNHEX('3804a3a94f4811e69e21001c42000273'),UNHEX('1cfb5efe5e8511e886060cc47a76f45e'),UNHEX('f31522343f7b11efa0078ada7f861d63'),UNHEX('60e9e37968d211ee881f8ada7f861d63'),UNHEX('60e9e36568d211ee881f8ada7f861d63'),UNHEX('60e9e35a68d211ee881f8ada7f861d63'),UNHEX('d5434da968d411ee881f8ada7f861d63'),UNHEX('60e9e33b68d211ee881f8ada7f861d63'),UNHEX('60f1e4f368d211ee881f8ada7f861d63'),UNHEX('3b6e2b21555a11ef88ab8ada7f861d63'),UNHEX('30b1f1605bcc11ef88ab8ada7f861d63')) ORDER BY tl_files.uuid!=UNHEX('9e7d6fd8a4ca11e6ac25001c42000273'), tl_files.uuid!=UNHEX('e4696c8e908911e68044001c42000273'), tl_files.uuid!=UNHEX('55bc4b40bbce11e6b371001c42000273'), tl_files.uuid!=UNHEX('b363117e8ad311e68044001c42000273'), tl_files.uuid!=UNHEX('1021d5ac8ecc11e68044001c42000273'), tl_files.uuid!=UNHEX('3804a3d74f4811e69e21001c42000273'), tl_files.uuid!=UNHEX('3804a3a94f4811e69e21001c42000273'), tl_files.uuid!=UNHEX('1cfb5efe5e8511e886060cc47a76f45e'), tl_files.uuid!=UNHEX('f31522343f7b11efa0078ada7f861d63'), tl_files.uuid!=UNHEX('60e9e37968d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e36568d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e35a68d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('d5434da968d411ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e33b68d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60f1e4f368d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('3b6e2b21555a11ef88ab8ada7f861d63'), tl_files.uuid!=UNHEX('30b1f1605bcc11ef88ab8ada7f861d63');

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

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`='1' 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 <= 1769976300
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1769976300
      )
  ) 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 <= 1769976300
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1769976300
  )
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<=1769976300) AND (p2.stop='' OR p2.stop>1769976300)) 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<=1769976300) AND (p1.stop='' OR p1.stop>1769976300) ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(5, 6, 77, 76, 3)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '5,38,6,77,76,3'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(5,6,77,76,3) ORDER BY FIND_IN_SET(`tl_page`.`id`, '5,38,6,77,76,3');

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 <= 1769976300
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1769976300
      )
  ) 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 <= 1769976300
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1769976300
  )
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<=1769976300) AND (p2.stop='' OR p2.stop>1769976300)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=5 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<=1769976300) AND (p1.stop='' OR p1.stop>1769976300) ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(68, 48, 49, 50, 18, 60, 101)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '68,48,49,50,18,60,101'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(68,48,49,50,18,60,101) ORDER BY FIND_IN_SET(`tl_page`.`id`, '68,48,49,50,18,60,101');

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 <= 1769976300
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1769976300
      )
  ) 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 <= 1769976300
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1769976300
  )
ORDER BY
  p1.sorting