Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('unsere-kanzlei',?);

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

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('unsere-kanzlei',?);

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(4, 1, 3, 9, 0, 6, 12, 5)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '4,1,3,9,0,6,12,5'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(4,1,3,9,0,6,12,5) ORDER BY FIND_IN_SET(`tl_module`.`id`, '4,1,3,9,0,6,12,5');

SELECT
  tl_node.*
FROM
  tl_node
WHERE
  id IN (2)
  AND type = ?
ORDER BY
  FIND_IN_SET(`id`, ?)

SELECT tl_node.* FROM tl_node WHERE id IN (2) AND type='2' ORDER BY FIND_IN_SET(`id`, ?);

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

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

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

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

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(59, 64, 65, 63)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '59,64,65,76,63'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(59,64,65,63) ORDER BY FIND_IN_SET(`tl_page`.`id`, '59,64,65,76,63');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(61, 98, 99)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '61,98,99')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(61,98,99) ORDER BY FIND_IN_SET(`tl_page`.`id`, '61,98,99');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(106, 107, 108, 109, 110, 111)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '106,107,108,109,110,111'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(106,107,108,109,110,111) ORDER BY FIND_IN_SET(`tl_page`.`id`, '106,107,108,109,110,111');

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(48, 47, 57, 58)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '48,47,57,58')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(48,47,57,58) ORDER BY FIND_IN_SET(`tl_page`.`id`, '48,47,57,58');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(23, 17, 24, 19)
  AND tl_page.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '23,17,24,19')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(23,17,24,19) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') ORDER BY FIND_IN_SET(`tl_page`.`id`, '23,17,24,19');

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') LIMIT 0,1;

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') 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 <= '1743674340'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1743674340'
  )
ORDER BY
  tl_article.sorting

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

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

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

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

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) 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`=? 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 = ''
ORDER BY
  sorting ASC

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

SELECT
  tl_node.*
FROM
  tl_node
WHERE
  id IN (3)
  AND type = ?
ORDER BY
  FIND_IN_SET(`id`, ?)

SELECT tl_node.* FROM tl_node WHERE id IN (3) AND type='3' ORDER BY FIND_IN_SET(`id`, ?);

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(22, 25, 26)
  AND tl_page.type NOT IN (
    'error_401', 'error_403', 'error_404',
    'error_503'
  )
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '22,25,26')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(22,25,26) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') ORDER BY FIND_IN_SET(`tl_page`.`id`, '22,25,26');

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1743674340'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743674340'
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1743674340') AND (tl_page.stop='' OR tl_page.stop>'1743674340') LIMIT 0,1;

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

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

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

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