Symfony Profiler

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

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`='13' 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_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 <= '1775902260'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1775902260'
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('news-blog/text-layout/news-text-sidebar','news-blog/text-layout','news-blog');

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.id='59' 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 <= '1775902260'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1775902260'
  )
ORDER BY
  tl_article.sorting

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

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 <= '1775902260'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1775902260'
  )
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<='1775902260') AND (tl_page.stop='' OR tl_page.stop>'1775902260') ORDER BY FIND_IN_SET(`tl_page`.`id`, '76,77');

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_news.*
FROM
  tl_news
WHERE
  tl_news.date >= ?
  AND tl_news.date <= ?
  AND tl_news.pid IN(1)
  AND tl_news.published = '1'
  AND (
    tl_news.start = ''
    OR tl_news.start <= '1775902260'
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > '1775902260'
  )
ORDER BY
  tl_news.date DESC

SELECT tl_news.* FROM tl_news WHERE tl_news.date>=1514761200 AND tl_news.date<=1546297199 AND tl_news.pid IN(1) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1775902260') AND (tl_news.stop='' OR tl_news.stop>'1775902260') ORDER BY tl_news.date DESC;

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

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

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

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

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

SELECT * FROM tl_files WHERE tl_files.`id`='' 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='251' LIMIT 0,1;

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

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

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
  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 <= '1775902260'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1775902260'
  )
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<='1775902260') AND (tl_page.stop='' OR tl_page.stop>'1775902260') ORDER BY tl_page.sorting LIMIT 0,1;

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

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

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

SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`='1' 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 <= '1775902260'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1775902260'
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id='42' AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<='1775902260') AND (tl_page.stop='' OR tl_page.stop>'1775902260') LIMIT 0,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_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(1) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '1');

SELECT
  FROM_UNIXTIME(date, '%Y') AS year,
  COUNT(*) AS count
FROM
  tl_news
WHERE
  pid IN(1)
  AND published = '1'
  AND (
    start = ''
    OR start <= '1775902260'
  )
  AND (
    stop = ''
    OR stop > '1775902260'
  )
GROUP BY
  year
ORDER BY
  year DESC

SELECT FROM_UNIXTIME(date, '%Y') AS year, COUNT(*) AS count FROM tl_news WHERE pid IN(1) AND published='1' AND (start='' OR start<='1775902260') AND (stop='' OR stop>'1775902260') GROUP BY year ORDER BY year DESC;

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

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