Symfony Profiler

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'eleaz_dev'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  *
FROM
  tl_dma_eg
WHERE
  tl_dma_eg.`content` = ?

SELECT * FROM tl_dma_eg WHERE tl_dma_eg.`content`=1;

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('blog');

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
  *
FROM
  tl_files
WHERE
  tl_files.uuid = UNHEX(?)
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('e38e9cc00c4111ee903202000a14005b') 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`=85 LIMIT 0,1;

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

SELECT
  *
FROM
  tl_dma_eg
WHERE
  tl_dma_eg.`content` = ?

SELECT * FROM tl_dma_eg WHERE tl_dma_eg.`content`=1;

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

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

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

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

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

SELECT tl_article.* FROM tl_article WHERE tl_article.pid=246 AND tl_article.inColumn='main' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1766055240) AND (tl_article.stop='' OR tl_article.stop>1766055240) 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 <= 1766055240
  )
  AND (
    tl_content.stop = ''
    OR tl_content.stop > 1766055240
  )
  AND tl_content.tstamp != 0
ORDER BY
  tl_content.sorting

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

SELECT
  *
FROM
  tl_dma_eg_fields
WHERE
  tl_dma_eg_fields.pid = ?
  AND tl_dma_eg_fields.type != ?
ORDER BY
  sorting

SELECT * FROM tl_dma_eg_fields WHERE tl_dma_eg_fields.pid='21' AND tl_dma_eg_fields.type!='lengend' ORDER BY sorting;

SELECT
  title,
  alias
FROM
  tl_article
WHERE
  id = ?
LIMIT
  0, 1

SELECT title,alias FROM tl_article WHERE id=248 LIMIT 0,1;

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

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

SELECT
  *
FROM
  tl_dma_eg_fields
WHERE
  tl_dma_eg_fields.pid = ?
  AND tl_dma_eg_fields.type != ?
ORDER BY
  sorting

SELECT * FROM tl_dma_eg_fields WHERE tl_dma_eg_fields.pid='12' AND tl_dma_eg_fields.type!='lengend' ORDER BY sorting;

SELECT
  title,
  alias
FROM
  tl_article
WHERE
  id = ?
LIMIT
  0, 1

SELECT title,alias FROM tl_article WHERE id=248 LIMIT 0,1;

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

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=10 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
  COUNT(*) AS count
FROM
  tl_news
WHERE
  tl_news.pid IN(1)
  AND tl_news.published = ?
  AND (
    tl_news.start = ?
    OR tl_news.start <= ?
  )
  AND (
    tl_news.stop = ?
    OR tl_news.stop > ?
  )

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

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

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<=1766055240) AND (tl_news.stop='' OR tl_news.stop>1766055240) ORDER BY tl_news.date DESC LIMIT 0,9;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '2fc153e4abca11efac7602000a14005b'
    ),
    UNHEX(
      '3587abe2855111efa5d002000a14005b'
    ),
    UNHEX(
      'be973af95a4811efb21f02000a14005b'
    ),
    UNHEX(
      'a941d90e1ceb11efba5102000a14005b'
    ),
    UNHEX(
      'b389cd165ef211efb21f02000a14005b'
    ),
    UNHEX(
      '6bbc5f1b0b7611efba5102000a14005b'
    ),
    UNHEX(
      'a0e7f742b6df11eeaf1502000a14005b'
    ),
    UNHEX(
      'eee018ceb6df11eeaf1502000a14005b'
    ),
    UNHEX(
      'd1e61c3caedb11eeaf1502000a14005b'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '2fc153e4abca11efac7602000a14005b'
  ),
  tl_files.uuid != UNHEX(
    '3587abe2855111efa5d002000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'be973af95a4811efb21f02000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'a941d90e1ceb11efba5102000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'b389cd165ef211efb21f02000a14005b'
  ),
  tl_files.uuid != UNHEX(
    '6bbc5f1b0b7611efba5102000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'a0e7f742b6df11eeaf1502000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'eee018ceb6df11eeaf1502000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'd1e61c3caedb11eeaf1502000a14005b'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('2fc153e4abca11efac7602000a14005b'),UNHEX('3587abe2855111efa5d002000a14005b'),UNHEX('be973af95a4811efb21f02000a14005b'),UNHEX('a941d90e1ceb11efba5102000a14005b'),UNHEX('b389cd165ef211efb21f02000a14005b'),UNHEX('6bbc5f1b0b7611efba5102000a14005b'),UNHEX('a0e7f742b6df11eeaf1502000a14005b'),UNHEX('eee018ceb6df11eeaf1502000a14005b'),UNHEX('d1e61c3caedb11eeaf1502000a14005b')) ORDER BY tl_files.uuid!=UNHEX('2fc153e4abca11efac7602000a14005b'), tl_files.uuid!=UNHEX('3587abe2855111efa5d002000a14005b'), tl_files.uuid!=UNHEX('be973af95a4811efb21f02000a14005b'), tl_files.uuid!=UNHEX('a941d90e1ceb11efba5102000a14005b'), tl_files.uuid!=UNHEX('b389cd165ef211efb21f02000a14005b'), tl_files.uuid!=UNHEX('6bbc5f1b0b7611efba5102000a14005b'), tl_files.uuid!=UNHEX('a0e7f742b6df11eeaf1502000a14005b'), tl_files.uuid!=UNHEX('eee018ceb6df11eeaf1502000a14005b'), tl_files.uuid!=UNHEX('d1e61c3caedb11eeaf1502000a14005b');

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '2fc153e4abca11efac7602000a14005b'
    ),
    UNHEX(
      '3587abe2855111efa5d002000a14005b'
    ),
    UNHEX(
      'be973af95a4811efb21f02000a14005b'
    ),
    UNHEX(
      'a941d90e1ceb11efba5102000a14005b'
    ),
    UNHEX(
      'b389cd165ef211efb21f02000a14005b'
    ),
    UNHEX(
      '6bbc5f1b0b7611efba5102000a14005b'
    ),
    UNHEX(
      'a0e7f742b6df11eeaf1502000a14005b'
    ),
    UNHEX(
      'eee018ceb6df11eeaf1502000a14005b'
    ),
    UNHEX(
      'd1e61c3caedb11eeaf1502000a14005b'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '2fc153e4abca11efac7602000a14005b'
  ),
  tl_files.uuid != UNHEX(
    '3587abe2855111efa5d002000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'be973af95a4811efb21f02000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'a941d90e1ceb11efba5102000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'b389cd165ef211efb21f02000a14005b'
  ),
  tl_files.uuid != UNHEX(
    '6bbc5f1b0b7611efba5102000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'a0e7f742b6df11eeaf1502000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'eee018ceb6df11eeaf1502000a14005b'
  ),
  tl_files.uuid != UNHEX(
    'd1e61c3caedb11eeaf1502000a14005b'
  )

SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('2fc153e4abca11efac7602000a14005b'),UNHEX('3587abe2855111efa5d002000a14005b'),UNHEX('be973af95a4811efb21f02000a14005b'),UNHEX('a941d90e1ceb11efba5102000a14005b'),UNHEX('b389cd165ef211efb21f02000a14005b'),UNHEX('6bbc5f1b0b7611efba5102000a14005b'),UNHEX('a0e7f742b6df11eeaf1502000a14005b'),UNHEX('eee018ceb6df11eeaf1502000a14005b'),UNHEX('d1e61c3caedb11eeaf1502000a14005b')) ORDER BY tl_files.uuid!=UNHEX('2fc153e4abca11efac7602000a14005b'), tl_files.uuid!=UNHEX('3587abe2855111efa5d002000a14005b'), tl_files.uuid!=UNHEX('be973af95a4811efb21f02000a14005b'), tl_files.uuid!=UNHEX('a941d90e1ceb11efba5102000a14005b'), tl_files.uuid!=UNHEX('b389cd165ef211efb21f02000a14005b'), tl_files.uuid!=UNHEX('6bbc5f1b0b7611efba5102000a14005b'), tl_files.uuid!=UNHEX('a0e7f742b6df11eeaf1502000a14005b'), tl_files.uuid!=UNHEX('eee018ceb6df11eeaf1502000a14005b'), tl_files.uuid!=UNHEX('d1e61c3caedb11eeaf1502000a14005b');

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

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

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

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('07ad6f7b8f0f11e6bf936e8371cb4820') 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`=22 LIMIT 0,1;

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

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

SHOW FULL COLUMNS
FROM
  tl_news_category

SHOW FULL COLUMNS FROM tl_news_category;

SHOW INDEXES
FROM
  `tl_news_category`

SHOW INDEXES FROM `tl_news_category`;

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'de'
WHERE
  (tl_news_category.lid = 0)
  AND (
    tl_news_category.id IN (2, 6)
  )
  AND (tl_news_category.published = ?)
ORDER BY
  tl_news_category.sorting

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='de' WHERE (tl_news_category.lid=0) AND (tl_news_category.id IN (2,6)) AND (tl_news_category.published=1) ORDER BY tl_news_category.sorting;

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

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

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

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

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'en'
WHERE
  (tl_news_category.lid = 0)
  AND (tl_news_category.id = ?)
LIMIT
  0, 1

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='en' WHERE (tl_news_category.lid=0) AND (tl_news_category.id=2) 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 <= 1766055240
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1766055240
  )
LIMIT
  0, 1

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

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

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

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'en'
WHERE
  (tl_news_category.lid = 0)
  AND (tl_news_category.id = ?)
LIMIT
  0, 1

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='en' WHERE (tl_news_category.lid=0) AND (tl_news_category.id=6) 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`=34 LIMIT 0,1;

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

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

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'de'
WHERE
  (tl_news_category.lid = 0)
  AND (
    tl_news_category.id IN (6, 7)
  )
  AND (tl_news_category.published = ?)
ORDER BY
  tl_news_category.sorting

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='de' WHERE (tl_news_category.lid=0) AND (tl_news_category.id IN (6,7)) AND (tl_news_category.published=1) ORDER BY tl_news_category.sorting;

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'en'
WHERE
  (tl_news_category.lid = 0)
  AND (tl_news_category.id = ?)
LIMIT
  0, 1

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='en' WHERE (tl_news_category.lid=0) AND (tl_news_category.id=6) LIMIT 0,1;

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'de'
WHERE
  (tl_news_category.lid = 0)
  AND (tl_news_category.id = ?)
LIMIT
  0, 1

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='de' WHERE (tl_news_category.lid=0) AND (tl_news_category.id=0) LIMIT 0,1;

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

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

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

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

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'de'
WHERE
  (tl_news_category.lid = 0)
  AND (
    tl_news_category.id IN (2, 6)
  )
  AND (tl_news_category.published = ?)
ORDER BY
  tl_news_category.sorting

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='de' WHERE (tl_news_category.lid=0) AND (tl_news_category.id IN (2,6)) AND (tl_news_category.published=1) ORDER BY tl_news_category.sorting;

SELECT
  IFNULL(
    translation.id, tl_news_category.id
  ) AS id,
  IFNULL(
    translation.language, tl_news_category.language
  ) AS language,
  IFNULL(
    translation.lid, tl_news_category.lid
  ) AS lid,
  tl_news_category.pid,
  tl_news_category.sorting,
  tl_news_category.tstamp,
  tl_news_category.cssClass,
  tl_news_category.image,
  tl_news_category.hideInList,
  tl_news_category.hideInReader,
  tl_news_category.excludeInRelated,
  tl_news_category.jumpTo,
  tl_news_category.published,
  IFNULL(
    translation.title, tl_news_category.title
  ) AS title,
  IFNULL(
    translation.frontendTitle, tl_news_category.frontendTitle
  ) AS frontendTitle,
  IFNULL(
    translation.alias, tl_news_category.alias
  ) AS alias,
  IFNULL(
    translation.description, tl_news_category.description
  ) AS description
FROM
  tl_news_category tl_news_category
  LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id = translation.lid
  AND translation.language = 'en'
WHERE
  (tl_news_category.lid = 0)
  AND (tl_news_category.id = ?)
LIMIT
  0, 1

SELECT IFNULL(translation.id, tl_news_category.id) AS id, IFNULL(translation.language, tl_news_category.language) AS language, IFNULL(translation.lid, tl_news_category.lid) AS lid, tl_news_category.pid, tl_news_category.sorting, tl_news_category.tstamp, tl_news_category.cssClass, tl_news_category.image, tl_news_category.hideInList, tl_news_category.hideInReader, tl_news_category.excludeInRelated, tl_news_category.jumpTo, tl_news_category.published, IFNULL(translation.title, tl_news_category.title) AS title, IFNULL(translation.frontendTitle, tl_news_category.frontendTitle) AS frontendTitle, IFNULL(translation.alias, tl_news_category.alias) AS alias, IFNULL(translation.description, tl_news_category.description) AS description FROM tl_news_category tl_news_category LEFT OUTER JOIN tl_news_category translation ON tl_news_category.id=translation.lid AND translation.language='en' WHERE (tl_news_category.lid=0) AND (tl_news_category.id=2) LIMIT 0,1;