Symfony Profiler

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

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`='49' 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')

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

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

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

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(
    23, 24, 47, 1, 36, 3, 0, 28, 0, 0, 61, 5, 35,
    38
  )
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '23,24,47,1,36,3,0,28,0,0,61,5,35,38'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(23,24,47,1,36,3,0,28,0,0,61,5,35,38) ORDER BY FIND_IN_SET(`tl_module`.`id`, '23,24,47,1,36,3,0,28,0,0,61,5,35,38');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(2, 48, 50)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '2,48,49,50')

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(51, 52, 53, 54, 55, 56, 57)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '51,52,53,54,55,56,57'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(51,52,53,54,55,56,57) ORDER BY FIND_IN_SET(`tl_page`.`id`, '51,52,53,54,55,56,57');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(63, 64, 58, 61, 60, 62, 66)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '63,64,58,59,61,60,62,66'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(63,64,58,61,60,62,66) ORDER BY FIND_IN_SET(`tl_page`.`id`, '63,64,58,59,61,60,62,66');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.pid = '1'
  AND tl_page.type != 'root'
  AND tl_page.type != 'error_401'
  AND tl_page.type != 'error_403'
  AND tl_page.type != 'error_404'
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1733365440'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1733365440'
  )
ORDER BY
  tl_page.sorting
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.pid='1' AND tl_page.type!='root' AND tl_page.type!='error_401' AND tl_page.type!='error_403' AND tl_page.type!='error_404' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1733365440') AND (tl_page.stop='' OR tl_page.stop>'1733365440') ORDER BY tl_page.sorting LIMIT 0,1;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = '59'
  AND tl_article.inColumn = 'header'
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= '1733365440'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1733365440'
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid='59' AND tl_article.inColumn='header' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1733365440') AND (tl_article.stop='' OR tl_article.stop>'1733365440') ORDER BY tl_article.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 <= '1733365440'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1733365440'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '49'
  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 <= '1733365440'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1733365440'
  )
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<='1733365440') AND (p2.stop='' OR p2.stop>'1733365440')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='49' 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<='1733365440') AND (p1.stop='' OR p1.stop>'1733365440') ORDER BY p1.sorting;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pid = '59'
  AND tl_article.inColumn = 'left'
  AND tl_article.published = '1'
  AND (
    tl_article.start = ''
    OR tl_article.start <= '1733365440'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1733365440'
  )
ORDER BY
  tl_article.sorting

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

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

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

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

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

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

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

SELECT
  MIN(startTime) AS dateFrom,
  MAX(endTime) AS dateTo,
  MAX(repeatEnd) AS repeatUntil
FROM
  tl_calendar_events
WHERE
  pid IN(3)
  AND published = '1'
  AND (
    start = ''
    OR start <= '1733365440'
  )
  AND (
    stop = ''
    OR stop > '1733365440'
  )

SELECT MIN(startTime) AS dateFrom, MAX(endTime) AS dateTo, MAX(repeatEnd) AS repeatUntil FROM tl_calendar_events WHERE pid IN(3) AND published='1' AND (start='' OR start<='1733365440') AND (stop='' OR stop>'1733365440');

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = '3'
  AND (
    (
      tl_calendar_events.startTime >= 1735689600
      AND tl_calendar_events.startTime <= 1738367999
    )
    OR (
      tl_calendar_events.endTime >= 1735689600
      AND tl_calendar_events.endTime <= 1738367999
    )
    OR (
      tl_calendar_events.startTime <= 1735689600
      AND tl_calendar_events.endTime >= 1738367999
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 1735689600
      )
      AND tl_calendar_events.startTime <= 1738367999
    )
  )
  AND tl_calendar_events.published = '1'
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1733365440'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1733365440'
  )
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid='3' AND ((tl_calendar_events.startTime>=1735689600 AND tl_calendar_events.startTime<=1738367999) OR (tl_calendar_events.endTime>=1735689600 AND tl_calendar_events.endTime<=1738367999) OR (tl_calendar_events.startTime<=1735689600 AND tl_calendar_events.endTime>=1738367999) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=1735689600) AND tl_calendar_events.startTime<=1738367999)) AND tl_calendar_events.published='1' AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1733365440') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1733365440') ORDER BY tl_calendar_events.startTime;

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

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

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

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

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

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

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

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

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

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

SELECT
  MIN(startTime) AS dateFrom,
  MAX(endTime) AS dateTo,
  MAX(repeatEnd) AS repeatUntil
FROM
  tl_calendar_events
WHERE
  pid IN(3)
  AND published = '1'
  AND (
    start = ''
    OR start <= '1733365440'
  )
  AND (
    stop = ''
    OR stop > '1733365440'
  )

SELECT MIN(startTime) AS dateFrom, MAX(endTime) AS dateTo, MAX(repeatEnd) AS repeatUntil FROM tl_calendar_events WHERE pid IN(3) AND published='1' AND (start='' OR start<='1733365440') AND (stop='' OR stop>'1733365440');

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = '3'
  AND (
    (
      tl_calendar_events.startTime >= 1735689600
      AND tl_calendar_events.startTime <= 1738367999
    )
    OR (
      tl_calendar_events.endTime >= 1735689600
      AND tl_calendar_events.endTime <= 1738367999
    )
    OR (
      tl_calendar_events.startTime <= 1735689600
      AND tl_calendar_events.endTime >= 1738367999
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 1735689600
      )
      AND tl_calendar_events.startTime <= 1738367999
    )
  )
  AND tl_calendar_events.published = '1'
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1733365440'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1733365440'
  )
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid='3' AND ((tl_calendar_events.startTime>=1735689600 AND tl_calendar_events.startTime<=1738367999) OR (tl_calendar_events.endTime>=1735689600 AND tl_calendar_events.endTime<=1738367999) OR (tl_calendar_events.startTime<=1735689600 AND tl_calendar_events.endTime>=1738367999) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=1735689600) AND tl_calendar_events.startTime<=1738367999)) AND tl_calendar_events.published='1' AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1733365440') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1733365440') ORDER BY tl_calendar_events.startTime;

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

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

SELECT
  tl_calendar_events.*
FROM
  tl_calendar_events
WHERE
  tl_calendar_events.pid = '3'
  AND (
    (
      tl_calendar_events.startTime >= 1733365460
      AND tl_calendar_events.startTime <= 4294967295
    )
    OR (
      tl_calendar_events.endTime >= 1733365460
      AND tl_calendar_events.endTime <= 4294967295
    )
    OR (
      tl_calendar_events.startTime <= 1733365460
      AND tl_calendar_events.endTime >= 4294967295
    )
    OR (
      tl_calendar_events.recurring = '1'
      AND (
        tl_calendar_events.recurrences = 0
        OR tl_calendar_events.repeatEnd >= 1733365460
      )
      AND tl_calendar_events.startTime <= 4294967295
    )
  )
  AND tl_calendar_events.published = '1'
  AND (
    tl_calendar_events.start = ''
    OR tl_calendar_events.start <= '1733365440'
  )
  AND (
    tl_calendar_events.stop = ''
    OR tl_calendar_events.stop > '1733365440'
  )
ORDER BY
  tl_calendar_events.startTime

SELECT tl_calendar_events.* FROM tl_calendar_events WHERE tl_calendar_events.pid='3' AND ((tl_calendar_events.startTime>=1733365460 AND tl_calendar_events.startTime<=4294967295) OR (tl_calendar_events.endTime>=1733365460 AND tl_calendar_events.endTime<=4294967295) OR (tl_calendar_events.startTime<=1733365460 AND tl_calendar_events.endTime>=4294967295) OR (tl_calendar_events.recurring='1' AND (tl_calendar_events.recurrences=0 OR tl_calendar_events.repeatEnd>=1733365460) AND tl_calendar_events.startTime<=4294967295)) AND tl_calendar_events.published='1' AND (tl_calendar_events.start='' OR tl_calendar_events.start<='1733365440') AND (tl_calendar_events.stop='' OR tl_calendar_events.stop>'1733365440') ORDER BY tl_calendar_events.startTime;

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

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`='53' 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 <= '1733365440'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1733365440'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '49'
  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 <= '1733365440'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1733365440'
  )
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<='1733365440') AND (p2.stop='' OR p2.stop>'1733365440')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='49' 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<='1733365440') AND (p1.stop='' OR p1.stop>'1733365440') 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 <= '1733365440'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1733365440'
      )
  ) AS hasSubpages
FROM
  tl_page p1
WHERE
  p1.pid = '1'
  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 <= '1733365440'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1733365440'
  )
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<='1733365440') AND (p2.stop='' OR p2.stop>'1733365440')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='1' 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<='1733365440') AND (p1.stop='' OR p1.stop>'1733365440') ORDER BY p1.sorting;

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(48)

SELECT id, pid FROM tl_page WHERE pid IN(48);

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(51, 52, 53, 54, 55, 56, 57)

SELECT id, pid FROM tl_page WHERE pid IN(51,52,53,54,55,56,57);

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(49)

SELECT id, pid FROM tl_page WHERE pid IN(49);

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(58, 59, 60, 61, 62, 63, 64, 66)

SELECT id, pid FROM tl_page WHERE pid IN(58,59,60,61,62,63,64,66);

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(8, 70, 45)

SELECT id, pid FROM tl_page WHERE pid IN(8,70,45);

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