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_news
WHERE
  tl_news.pid IN(1)
  AND tl_news.published = '1'
  AND (
    tl_news.start = ''
    OR tl_news.start <= '1781342820'
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > '1781342820'
  )

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<='1781342820') AND (tl_news.stop='' OR tl_news.stop>'1781342820');

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

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

SELECT tl_article.* FROM tl_article WHERE tl_article.pid='39' AND tl_article.inColumn='header' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<='1781342820') AND (tl_article.stop='' OR tl_article.stop>'1781342820') 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`='24' 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 <= '1781342820'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1781342820'
  )
  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<='1781342820') AND (tl_content.stop='' OR tl_content.stop>'1781342820') AND tl_content.tstamp!=0;

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('demos/hotel/hotel-home','demos/hotel','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
  *
FROM
  tl_files
WHERE
  tl_files.pid = UNHEX(?)
ORDER BY
  name

SELECT * FROM tl_files WHERE tl_files.pid=UNHEX('1977fafe124411eba6c756e1675ea213') ORDER BY name;

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

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

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 <= '1781342820'
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > '1781342820'
  )
ORDER BY
  tl_news.date DESC

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<='1781342820') AND (tl_news.stop='' OR tl_news.stop>'1781342820') ORDER BY tl_news.date DESC;

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`='3' 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_page.*
FROM
  tl_page
WHERE
  tl_page.id = ?
LIMIT
  0, 1

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

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '1977fafe124411eba6c756e1675ea213'
    ),
    UNHEX(
      'efbeaeb2058f11eba33d74585bbfae2b'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '1977fafe124411eba6c756e1675ea213'
  ),
  tl_files.uuid != UNHEX(
    'efbeaeb2058f11eba33d74585bbfae2b'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('1977fafe124411eba6c756e1675ea213'),UNHEX('efbeaeb2058f11eba33d74585bbfae2b')) ORDER BY tl_files.uuid!=UNHEX('1977fafe124411eba6c756e1675ea213'), tl_files.uuid!=UNHEX('efbeaeb2058f11eba33d74585bbfae2b');

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

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

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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

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

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

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