Symfony Profiler

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN ('events/submit', 'events')

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('events/submit','events');

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN ('events/submit', 'events')

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('events/submit','events');

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(59, 49, 0, 0, 0, 56, 50)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '59,49,0,0,0,56,50'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(59,49,0,0,0,56,50) ORDER BY FIND_IN_SET(`tl_module`.`id`, '59,49,0,0,0,56,50');

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
  tl_form.*
FROM
  tl_form
WHERE
  tl_form.`id` = '9'
LIMIT
  0, 1

SELECT tl_form.* FROM tl_form WHERE tl_form.`id`='9' LIMIT 0,1;

SELECT
  tl_form_field.*
FROM
  tl_form_field
WHERE
  tl_form_field.pid = '9'
  AND tl_form_field.invisible = ''
  AND tl_form_field.tstamp != 0
ORDER BY
  tl_form_field.sorting

SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid='9' AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting;

SELECT
  *
FROM
  tl_mae_event_cat

SELECT * FROM tl_mae_event_cat;

SELECT
  tl_artshub_profile_item.*
FROM
  tl_artshub_profile_item
WHERE
  tl_artshub_profile_item.published = '1'
ORDER BY
  name ASC

SELECT tl_artshub_profile_item.* FROM tl_artshub_profile_item WHERE tl_artshub_profile_item.published='1' ORDER BY name ASC;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      'a7372e81fa1611eb890ef23c9128ddb0'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    'a7372e81fa1611eb890ef23c9128ddb0'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('a7372e81fa1611eb890ef23c9128ddb0')) ORDER BY tl_files.uuid!=UNHEX('a7372e81fa1611eb890ef23c9128ddb0');

SELECT
  tl_node.*
FROM
  tl_node
WHERE
  id = 15
  AND type = 'content'
LIMIT
  0, 1

SELECT tl_node.* FROM tl_node WHERE id=15 AND type='content' LIMIT 0,1;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = '15'
  AND tl_content.ptable = 'tl_node'
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1761040320'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1761040320'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

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

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '160'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='160' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(161, 162, 164, 163, 166, 167, 168)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '161,162,164,163,165,166,167,168'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(161,162,164,163,166,167,168) ORDER BY FIND_IN_SET(`tl_page`.`id`, '161,162,164,163,165,166,167,168');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '161'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='161' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(180, 172, 173, 181)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '180,172,173,181'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(180,172,173,181) ORDER BY FIND_IN_SET(`tl_page`.`id`, '180,172,173,181');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '164'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='164' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') ORDER BY p1.sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(169, 193, 194)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '169,193,194')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(169,193,194) ORDER BY FIND_IN_SET(`tl_page`.`id`, '169,193,194');

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '165'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='165' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') ORDER BY p1.sorting;

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

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '168'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='168' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') ORDER BY p1.sorting;

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

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

SELECT
  tl_node.*
FROM
  tl_node
WHERE
  id = 2
  AND type = 'content'
LIMIT
  0, 1

SELECT tl_node.* FROM tl_node WHERE id=2 AND type='content' LIMIT 0,1;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.pid = '2'
  AND tl_content.ptable = 'tl_node'
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1761040320'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1761040320'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = '150'
LIMIT
  0, 1

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

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

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

SELECT
  p1.id,
  EXISTS(
    SELECT
      *
    FROM
      tl_page p2
    WHERE
      p2.pid = p1.id
      AND p2.type != 'root'
      AND p2.type != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '160'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='160' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') 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 != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '161'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='161' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') 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 != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '164'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
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!='error_401' AND p2.type!='error_403' AND p2.type!='error_404' AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<='1761040320') AND (p2.stop='' OR p2.stop>'1761040320')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='164' AND p1.type!='root' AND p1.type!='error_401' AND p1.type!='error_403' AND p1.type!='error_404' AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<='1761040320') AND (p1.stop='' OR p1.stop>'1761040320') 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 != 'error_401'
      AND p2.type != 'error_403'
      AND p2.type != 'error_404'
      AND p2.hide = ''
      AND p2.published = '1'
      AND (
        p2.start = ''
        OR p2.start <= '1761040320'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1761040320'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '165'
  AND p1.type != 'root'
  AND p1.type != 'error_401'
  AND p1.type != 'error_403'
  AND p1.type != 'error_404'
  AND p1.hide = ''
  AND p1.published = '1'
  AND (
    p1.start = ''
    OR p1.start <= '1761040320'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1761040320'
  )
ORDER BY
  p1.sorting