Symfony Profiler

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

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

SELECT
  COUNT(*) AS count
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND tl_content.ptable = ?
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1771987440'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1771987440'
  )
  AND tl_content.tstamp != 0

SELECT COUNT(*) AS count FROM tl_content WHERE tl_content.pid='1' AND tl_content.ptable='tl_news' AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1771987440') AND (tl_content.stop='' OR tl_content.stop>'1771987440') AND tl_content.tstamp!=0;

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.pid IN(1)
  AND tl_news.published = '1'
  AND (
    tl_news.start = ''
    OR tl_news.start <= '1771987440'
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > '1771987440'
  )

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(1) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1771987440') AND (tl_news.stop='' OR tl_news.stop>'1771987440');

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

SELECT tl_content.* FROM tl_content WHERE tl_content.pid='86' AND (tl_content.ptable='tl_article' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<='1771987440') AND (tl_content.stop='' OR tl_content.stop>'1771987440') 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('ca5b257e211411eb8fad3853f8e386f7') 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 <= '1771987440'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1771987440'
  )
ORDER BY
  tl_article.sorting

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

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

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`='18' 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 ('demos/agentur/agentur-02','demos/agentur','demos');

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

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

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

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

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

SELECT tl_article.* FROM tl_article WHERE tl_article.id='19' LIMIT 0,1;

SELECT
  tl_news.*
FROM
  tl_news
WHERE
  tl_news.pid IN(1)
  AND tl_news.published = '1'
  AND (
    tl_news.start = ''
    OR tl_news.start <= '1771987440'
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > '1771987440'
  )
ORDER BY
  tl_news.date DESC
LIMIT
  0, 8

SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1771987440') AND (tl_news.stop='' OR tl_news.stop>'1771987440') ORDER BY tl_news.date DESC LIMIT 0,8;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(15, 1, 19, 0, 0, 0, 0, 14)
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '15,1,19,0,0,0,0,14'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(15,1,19,0,0,0,0,14) ORDER BY FIND_IN_SET(`tl_module`.`id`, '15,1,19,0,0,0,0,14');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.pid = ?
  AND tl_page.type = 'regular'
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start <= '1771987440'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1771987440'
  )
ORDER BY
  tl_page.sorting
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.pid='25' AND tl_page.type='regular' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1771987440') AND (tl_page.stop='' OR tl_page.stop>'1771987440') ORDER BY tl_page.sorting LIMIT 0,1;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '2af4a3c2239711eb9fb2b0060a20853d'
    ),
    UNHEX(
      'efb20658058f11eba33d74585bbfae2b'
    ),
    UNHEX(
      '2af4a3ae239711eb9fb2b0060a20853d'
    ),
    UNHEX(
      'efb76d96058f11eba33d74585bbfae2b'
    ),
    UNHEX(
      'efb2063a058f11eba33d74585bbfae2b'
    ),
    UNHEX(
      'efb2064e058f11eba33d74585bbfae2b'
    ),
    UNHEX(
      'efb2063b058f11eba33d74585bbfae2b'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '2af4a3c2239711eb9fb2b0060a20853d'
  ),
  tl_files.uuid != UNHEX(
    'efb20658058f11eba33d74585bbfae2b'
  ),
  tl_files.uuid != UNHEX(
    '2af4a3ae239711eb9fb2b0060a20853d'
  ),
  tl_files.uuid != UNHEX(
    'efb76d96058f11eba33d74585bbfae2b'
  ),
  tl_files.uuid != UNHEX(
    'efb2063a058f11eba33d74585bbfae2b'
  ),
  tl_files.uuid != UNHEX(
    'efb2064e058f11eba33d74585bbfae2b'
  ),
  tl_files.uuid != UNHEX(
    'efb2063b058f11eba33d74585bbfae2b'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('2af4a3c2239711eb9fb2b0060a20853d'),UNHEX('efb20658058f11eba33d74585bbfae2b'),UNHEX('2af4a3ae239711eb9fb2b0060a20853d'),UNHEX('efb76d96058f11eba33d74585bbfae2b'),UNHEX('efb2063a058f11eba33d74585bbfae2b'),UNHEX('efb2064e058f11eba33d74585bbfae2b'),UNHEX('efb2063b058f11eba33d74585bbfae2b')) ORDER BY tl_files.uuid!=UNHEX('2af4a3c2239711eb9fb2b0060a20853d'), tl_files.uuid!=UNHEX('efb20658058f11eba33d74585bbfae2b'), tl_files.uuid!=UNHEX('2af4a3ae239711eb9fb2b0060a20853d'), tl_files.uuid!=UNHEX('efb76d96058f11eba33d74585bbfae2b'), tl_files.uuid!=UNHEX('efb2063a058f11eba33d74585bbfae2b'), tl_files.uuid!=UNHEX('efb2064e058f11eba33d74585bbfae2b'), tl_files.uuid!=UNHEX('efb2063b058f11eba33d74585bbfae2b');

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

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

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

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

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.pid = ?
  AND tl_page.type != 'root'
  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 <= '1771987440'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1771987440'
  )
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 NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1771987440') AND (tl_page.stop='' OR tl_page.stop>'1771987440') ORDER BY tl_page.sorting LIMIT 0,1;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(82, 73, 81, 83, 84, 85, 74)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '2,82,73,81,83,84,85,74'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(82,73,81,83,84,85,74) ORDER BY FIND_IN_SET(`tl_page`.`id`, '2,82,73,81,83,84,85,74');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(76, 77)
  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 <= '1771987440'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1771987440'
  )
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '76,77')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(76,77) 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<='1771987440') AND (tl_page.stop='' OR tl_page.stop>'1771987440') ORDER BY FIND_IN_SET(`tl_page`.`id`, '76,77');

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

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

SELECT
  tl_newsletter_channel.*
FROM
  tl_newsletter_channel
WHERE
  tl_newsletter_channel.id IN(1)
ORDER BY
  tl_newsletter_channel.title

SELECT tl_newsletter_channel.* FROM tl_newsletter_channel WHERE tl_newsletter_channel.id IN(1) ORDER BY tl_newsletter_channel.title;

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

SELECT * FROM tl_files WHERE tl_files.`id`='' 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 <= '1771987440'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1771987440'
      )
  ) 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 <= '1771987440'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1771987440'
  )
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<='1771987440') AND (p2.stop='' OR p2.stop>'1771987440')) 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<='1771987440') AND (p1.stop='' OR p1.stop>'1771987440') ORDER BY p1.sorting;