Symfony Profiler

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias IN (
    'event/experience-the-colle2021-11-27',
    'event'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('event/experience-the-colle2021-11-27','event');

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

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`='158' 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 (
    'event/experience-the-colle2021-11-27',
    'event'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('event/experience-the-colle2021-11-27','event');

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 = '171'
  AND tl_article.inColumn = 'pageheader'
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= '1758334740'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1758334740'
  )
ORDER BY
  tl_article.sorting

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

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

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

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

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

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

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

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

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

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

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

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  BINARY tl_calendar_events.alias = 'experience-the-colle2021-11-27'
  AND tl_calendar_events.pid IN(2)
  AND tl_calendar_events.published = '1'
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1758334740'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1758334740'
  )
LIMIT
  0, 1

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE BINARY tl_calendar_events.alias='experience-the-colle2021-11-27' AND tl_calendar_events.pid IN(2) AND tl_calendar_events.published='1' AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1758334740') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1758334740') LIMIT 0,1;

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

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(
    161, 162, 164, 163, 165, 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,165,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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') ORDER BY p1.sorting;

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

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(170,178) 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') 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 <= '1758334740'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1758334740'
  )
  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<='1758334740') AND (tl_content.stop='' OR tl_content.stop>'1758334740') 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
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<='1758334740') AND (p2.stop='' OR p2.stop>'1758334740')) 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<='1758334740') AND (p1.stop='' OR p1.stop>'1758334740') 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 <= '1758334740'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1758334740'
      )
  ) 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 <= '1758334740'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1758334740'
  )
ORDER BY
  p1.sorting