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.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
  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 = '/' 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`=13 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(92, 93, 4, 0, 94)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '92,93,4,0,94'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(92,93,4,0,94) ORDER BY FIND_IN_SET(`tl_module`.`id`, '92,93,4,0,94');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(5, 38, 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,38,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 <= 1769981640
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1769981640
      )
  ) 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 <= 1769981640
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1769981640
  )
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<=1769981640) AND (p2.stop='' OR p2.stop>1769981640)) 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<=1769981640) AND (p1.stop='' OR p1.stop>1769981640) 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 <= 1769981640
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1769981640
      )
  ) 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 <= 1769981640
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1769981640
  )
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<=1769981640) AND (p2.stop='' OR p2.stop>1769981640)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=38 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<=1769981640) AND (p1.stop='' OR p1.stop>1769981640) ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(45, 46, 75, 47, 61, 71)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '45,46,75,47,61,71'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(45,46,75,47,61,71) ORDER BY FIND_IN_SET(`tl_page`.`id`, '45,46,75,47,61,71');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(14, 15, 16, 17, 43, 44)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '14,15,16,17,43,44'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(14,15,16,17,43,44) ORDER BY FIND_IN_SET(`tl_page`.`id`, '14,15,16,17,43,44');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(69, 70)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '69,70')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(69,70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70');

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

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=2 AND tl_article.inColumn='main' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1769981640) AND (tl_article.stop='' OR tl_article.stop>1769981640) 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 <= 1769981640
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1769981640
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

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 = UNHEX(?)
LIMIT
  0, 1

SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX('7c4d5768683b11ee881f8ada7f861d63') LIMIT 0,1;

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

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

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

SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`='15' LIMIT 0,1;

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

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

SELECT
  tl_image_size_item.*
FROM
  tl_image_size_item
WHERE
  tl_image_size_item.pid = ?
  AND tl_image_size_item.invisible = ''
  AND tl_image_size_item.tstamp > 0
ORDER BY
  sorting ASC

SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=15 AND tl_image_size_item.invisible='' AND tl_image_size_item.tstamp > 0 ORDER BY sorting ASC;

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

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