Symfony Profiler

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

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

SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = ?
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid
UNION
SELECT
  id,
  @pid := pid
FROM
  tl_news_category
WHERE
  id = @pid

SELECT id, @pid:=pid FROM tl_news_category WHERE id=? UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid UNION SELECT id, @pid:=pid FROM tl_news_category WHERE id=@pid;

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

SELECT
  *
FROM
  tl_news_category
WHERE
  tl_news_category.id IN (5, 10, 7, 6, 11, 12, 8, 9)
  AND tl_news_category.pid = ?
  AND tl_news_category.published = ?
ORDER BY
  tl_news_category.sorting

SELECT * FROM tl_news_category WHERE tl_news_category.id IN (5,10,7,6,11,12,8,9) AND tl_news_category.pid=1 AND tl_news_category.published=? ORDER BY tl_news_category.sorting;

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

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

SELECT
  *
FROM
  tl_news_category
WHERE
  tl_news_category.id IN (6)
  AND tl_news_category.published = ?
ORDER BY
  tl_news_category.sorting

SELECT * FROM tl_news_category WHERE tl_news_category.id IN (6) AND tl_news_category.published=? ORDER BY tl_news_category.sorting;

SELECT
  *
FROM
  tl_news_category
WHERE
  tl_news_category.alias = ?
  AND tl_news_category.published = ?
LIMIT
  0, 1

SELECT * FROM tl_news_category WHERE tl_news_category.alias=1 AND tl_news_category.published=? LIMIT 0,1;

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('6')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('6');

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('news/category','news',?);

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_content.*
FROM
  tl_content
WHERE
  tl_content.pid = ?
  AND tl_content.ptable = ?
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1743744000'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1743744000'
  )
  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<='1743744000') AND (tl_content.stop='' OR tl_content.stop>'1743744000') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

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_news_archive.*
FROM
  tl_news_archive
WHERE
  tl_news_archive.id IN(2)
ORDER BY
  FIND_IN_SET(`tl_news_archive`.`id`, '2')

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

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
  *
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_news.*
FROM
  tl_news
WHERE
  tl_news.pid IN(2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?
  AND tl_news.id IN(4, 6, 14, 19)
ORDER BY
  tl_news.date DESC
LIMIT
  0, 4

SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=? AND tl_news.id IN(4,6,14,19) ORDER BY tl_news.date DESC LIMIT 0,4;

SELECT
  category_id
FROM
  tl_news_categories
WHERE
  news_id IN ('14')

SELECT category_id FROM tl_news_categories WHERE news_id IN ('14');

SELECT
  category_id
FROM
  tl_news_categories
WHERE
  news_id IN ('6')

SELECT category_id FROM tl_news_categories WHERE news_id IN ('6');

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_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 <= '1743744000'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1743744000'
  )
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<='1743744000') AND (tl_article.stop='' OR tl_article.stop>'1743744000') ORDER BY tl_article.sorting;

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

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

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 <= '1743744000'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743744000'
  )
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<='1743744000') AND (tl_page.stop='' OR tl_page.stop>'1743744000') ORDER BY FIND_IN_SET(`tl_page`.`id`, '22,25,26');

SELECT
  category_id
FROM
  tl_news_categories
WHERE
  news_id IN ('4')

SELECT category_id FROM tl_news_categories WHERE news_id IN ('4');

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.pid IN(2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?
  AND tl_news.id IN(4, 6, 14, 19)

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.pid IN(2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=? AND tl_news.id IN(4,6,14,19);

SELECT
  *
FROM
  tl_news_category
WHERE
  tl_news_category.`published` = ?
ORDER BY
  tl_news_category.sorting

SELECT * FROM tl_news_category WHERE tl_news_category.`published`=? ORDER BY tl_news_category.sorting;

SELECT
  category_id
FROM
  tl_news_categories
WHERE
  news_id IN ('19')

SELECT category_id FROM tl_news_categories WHERE news_id IN ('19');

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 = ?
    OR tl_content.ptable = ''
  )
  AND tl_content.invisible = ''
  AND (
    tl_content.start = ''
    OR tl_content.start <= '1743744000'
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > '1743744000'
  )
  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<='1743744000') AND (tl_content.stop='' OR tl_content.stop>'1743744000') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;

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
  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 <= '1743744000'
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > '1743744000'
  )
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<='1743744000') AND (tl_page.stop='' OR tl_page.stop>'1743744000') ORDER BY FIND_IN_SET(`tl_page`.`id`, '23,17,24,19');

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
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (9, 16)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (9,16) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (4, 6, 14, 19)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (4,6,14,19) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  tl_news.*
FROM
  tl_news
WHERE
  BINARY tl_news.alias = ?
  AND tl_news.pid IN(2)
  AND tl_news.published = '1'
  AND (
    tl_news.start = ''
    OR tl_news.start <= '1743744000'
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > '1743744000'
  )
LIMIT
  0, 1

SELECT tl_news.* FROM tl_news WHERE BINARY tl_news.alias=? AND tl_news.pid IN(2) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<='1743744000') AND (tl_news.stop='' OR tl_news.stop>'1743744000') LIMIT 0,1;

SELECT
  news_id
FROM
  tl_news_categories

SELECT news_id FROM tl_news_categories;

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (
    1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
    15, 16, 17, 18, 19, 20
  )
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (11, 12, 20)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (11,12,20) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('5')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('5');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(3, 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(3,60,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '3,60,5,6');

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
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(59, 64, 65, 76, 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,76,63) ORDER BY FIND_IN_SET(`tl_page`.`id`, '59,64,65,76,63');

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (5, 10, 13)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (5,10,13) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (1, 17)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,17) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

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
  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(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
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (1, 2, 5, 10, 13, 17, 18)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (1,2,5,10,13,17,18) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  DATABASE()

SELECT DATABASE();

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');

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('7')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('7');

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('12')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('12');

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (3, 7, 8, 15)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (3,7,8,15) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.id IN (18)
  AND tl_news.pid IN (2)
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )
  AND tl_news.published = ?

SELECT COUNT(*) AS count FROM tl_news WHERE tl_news.id IN (18) AND tl_news.pid IN (2) AND (tl_news.start=1743744000 OR tl_news.start<='') AND (tl_news.stop=1743744060 OR tl_news.stop>1) AND tl_news.published=?;

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('10')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('10');

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('9')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('9');

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('8')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('8');

SELECT
  news_id
FROM
  tl_news_categories
WHERE
  category_id IN ('11')

SELECT news_id FROM tl_news_categories WHERE category_id IN ('11');