Symfony Profiler

SELECT
  c.TABLE_NAME,
  c.COLUMN_NAME AS field,
  IF(
    c.COLUMN_TYPE = 'longtext'
    AND EXISTS(
      SELECT
        *
      from
        information_schema.CHECK_CONSTRAINTS i_c
      WHERE
        i_c.CONSTRAINT_SCHEMA = 'essensei_v2_prod'
        AND i_c.TABLE_NAME = c.TABLE_NAME
        AND i_c.CHECK_CLAUSE = CONCAT(
          'json_valid(`', c.COLUMN_NAME, '`)'
        )
    ),
    'json',
    c.COLUMN_TYPE
  ) AS type,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS comment,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS collation
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
ORDER BY
  ORDINAL_POSITION

SELECT c.TABLE_NAME,       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'essensei_v2_prod'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'essensei_v2_prod' AND t.TABLE_SCHEMA = 'essensei_v2_prod' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;

SELECT
  t.*
FROM
  tl_tags AS t
  JOIN tl_tags_rel AS r ON (
    r.tag_id = t.id
    AND r.field = ?
    AND r.ptable = ?
  )
WHERE
  r.pid = ?
ORDER BY
  t.tag ASC

SELECT t.*
            FROM tl_tags AS t
                JOIN tl_tags_rel AS r ON (r.tag_id=t.id AND r.field='tags' AND r.ptable='tl_news')
            WHERE r.pid=72
            ORDER BY t.tag ASC;

SELECT
  t.TABLE_NAME,
  t.ENGINE,
  t.AUTO_INCREMENT,
  t.TABLE_COMMENT,
  t.CREATE_OPTIONS,
  t.TABLE_COLLATION,
  ccsa.CHARACTER_SET_NAME
FROM
  information_schema.TABLES t
  INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION
WHERE
  t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'

SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'essensei_v2_prod' AND t.TABLE_TYPE = 'BASE TABLE';

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 = 0
      AND p2.published = 1
      AND (
        p2.start = ''
        OR p2.start <= 1768594440
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1768594440
      )
  ) 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 = 0
  AND p1.published = 1
  AND (
    p1.start = ''
    OR p1.start <= 1768594440
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1768594440
  )
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=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1768594440) AND (p2.stop='' OR p2.stop>1768594440)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=225 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1768594440) AND (p1.stop='' OR p1.stop>1768594440) ORDER BY p1.sorting;

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

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

SELECT
  TABLE_NAME,
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_SCHEMA = ?
ORDER BY
  SEQ_IN_INDEX

SELECT TABLE_NAME,        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = 'essensei_v2_prod' ORDER BY SEQ_IN_INDEX;

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

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

SELECT
  COUNT(*) AS count
FROM
  tl_news_archive AS a
  JOIN tl_news AS n ON (n.pid = a.id)
  JOIN tl_tags_rel AS r ON (
    r.pid = n.id
    AND r.ptable = 'tl_news'
    AND r.field = 'tags'
  )
  JOIN tl_tags AS t ON (t.id = r.tag_id)
WHERE
  a.id in (6)
  AND t.id = ?
  AND n.published = '1'
  AND (
    n.start = ''
    OR n.start <= 1768594440
  )
  AND (
    n.stop = ''
    OR n.stop > 1768594440
  )

SELECT
                COUNT(*) AS count
            FROM tl_news_archive AS a
                JOIN tl_news AS n ON (n.pid = a.id)
                JOIN tl_tags_rel AS r ON (r.pid = n.id AND r.ptable = 'tl_news' AND r.field = 'tags')
                JOIN tl_tags AS t ON (t.id = r.tag_id)
            WHERE
                a.id in (6) AND t.id=13  AND n.published='1' AND (n.start='' OR n.start<=1768594440) AND (n.stop='' OR n.stop>1768594440);

SELECT
  DISTINCT k.TABLE_NAME,
  k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'essensei_v2_prod' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT k.TABLE_NAME,            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'essensei_v2_prod' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'essensei_v2_prod' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  COUNT(*) AS count
FROM
  tl_comments
WHERE
  tl_comments.source = ?
  AND tl_comments.parent = ?
  AND tl_comments.published = 1

SELECT COUNT(*) AS count FROM tl_comments WHERE tl_comments.source='tl_news' AND tl_comments.parent=72 AND tl_comments.published=1;

SELECT
  *
FROM
  tl_tags
WHERE
  tl_tags.`tag` = ?
LIMIT
  0, 1

SELECT * FROM tl_tags WHERE tl_tags.`tag`='Agilité à l'échelle' LIMIT 0,1;

SELECT
  urlPrefix,
  urlSuffix
FROM
  tl_page
WHERE
  type = 'root'

SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root';

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(226, 306, 322, 307, 290)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '226,306,322,307,317,290'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(226,306,322,307,290) ORDER BY FIND_IN_SET(`tl_page`.`id`, '226,306,322,307,317,290');

SELECT
  *
FROM
  tl_tiles
WHERE
  (
    start = ''
    OR start < 1768594489
  )
  AND (
    stop = ''
    OR stop > 1768594489
  )
  AND published = 1
ORDER by
  sorting ASC

SELECT * FROM tl_tiles WHERE (start='' OR start<1768594489) AND (stop='' OR stop>1768594489) AND published=1 ORDER by sorting ASC;

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

SELECT tl_user.* FROM tl_user WHERE tl_user.`id`=2 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 <= 1768594440
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1768594440
  )
ORDER BY
  tl_article.sorting

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

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

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

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

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

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.`pid` = ?
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.`pid`=297 ORDER BY tl_article.sorting;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(
    164, 160, 233, 188, 234, 235, 263, 190,
    236, 161, 165, 162, 190, 240, 163, 168,
    0, 169, 0, 0, 0, 186, 239, 185, 242, 182
  )
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '164,160,233,188,234,235,263,190,236,161,165,162,190,240,163,168,0,169,0,0,0,186,239,185,242,182'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(164,160,233,188,234,235,263,190,236,161,165,162,190,240,163,168,0,169,0,0,0,186,239,185,242,182) ORDER BY FIND_IN_SET(`tl_module`.`id`, '164,160,233,188,234,235,263,190,236,161,165,162,190,240,163,168,0,169,0,0,0,186,239,185,242,182');

SELECT
  DISTINCT t.*
FROM
  tl_news_archive AS a
  JOIN tl_news AS n ON (n.pid = a.id)
  JOIN tl_tags_rel AS r ON (
    r.pid = n.id
    AND r.ptable = 'tl_news'
    AND r.field = 'tags'
  )
  JOIN tl_tags AS t ON (t.id = r.tag_id)
WHERE
  a.id in (6)
  AND n.published = '1'
  AND (
    n.start = ''
    OR n.start <= 1768594440
  )
  AND (
    n.stop = ''
    OR n.stop > 1768594440
  )
ORDER BY
  t.tag ASC

SELECT DISTINCT
                t.*
            FROM tl_news_archive AS a
                JOIN tl_news AS n ON (n.pid = a.id)
                JOIN tl_tags_rel AS r ON (r.pid = n.id AND r.ptable = 'tl_news' AND r.field = 'tags')
                JOIN tl_tags AS t ON (t.id = r.tag_id)
            WHERE
                a.id in (6) AND n.published='1' AND (n.start='' OR n.start<=1768594440) AND (n.stop='' OR n.stop>1768594440)
            ORDER BY t.tag ASC;

SELECT
  tl_news.*
FROM
  tl_news
WHERE
  tl_news.pid IN(6)
  AND tl_news.featured = 1
  AND tl_news.published = 1
  AND (
    tl_news.start = ''
    OR tl_news.start <= 1768594440
  )
  AND (
    tl_news.stop = ''
    OR tl_news.stop > 1768594440
  )
ORDER BY
  RAND()
LIMIT
  0, 1

SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(6) AND tl_news.featured=1 AND tl_news.published=1 AND (tl_news.start='' OR tl_news.start<=1768594440) AND (tl_news.stop='' OR tl_news.stop>1768594440) ORDER BY RAND() LIMIT 0,1;

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

SELECT tl_news.* FROM tl_news WHERE CAST(tl_news.alias AS BINARY)=NULL AND tl_news.pid IN(6) AND tl_news.published=1 AND (tl_news.start='' OR tl_news.start<=1768594440) AND (tl_news.stop='' OR tl_news.stop>1768594440) 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 ('publications/tag/WyJBZ2lsaXRcdTAwZTkgXHUwMGUwIGwmIzM5O1x1MDBlOWNoZWxsZSIsIk9LUiIsIlBcdTAwZTlkYWdvZ2llIiwiUHJvZHVpdCIsInJvYWRtYXAgbmFycmF0aXZlIiwiU3RyYXRcdTAwZTlnaWUiLCJUcmFuc2Zvcm1hdGlvbiIsIk1hbmFnZXIiXQ==','publications/tag','publications');

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

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

SELECT
  tl_cookie.*
FROM
  tl_cookie
WHERE
  tl_cookie.pid = ?
  AND tl_cookie.published = '1'
ORDER BY
  tl_cookie.sorting

SELECT tl_cookie.* FROM tl_cookie WHERE tl_cookie.pid=1 AND tl_cookie.published='1' ORDER BY tl_cookie.sorting;

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

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

SELECT
  tl_files.*
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '83690f58aa0a11f09bc51daa3561b3d5'
    ),
    UNHEX(
      '423d0a1e921f11f0a8ef27cdc2543e2f'
    ),
    UNHEX(
      'a78b049c8d9311f0aca3f9eefb4f4453'
    ),
    UNHEX(
      '5bcfa4c85cc811f0b5c109ec074ab94a'
    ),
    UNHEX(
      'e1ef63c8536c11f09ca92b6a5ed5cf96'
    ),
    UNHEX(
      '24362850501811f0a01edfd9cd3a664e'
    ),
    UNHEX(
      'f3d20c00420311f08b386c2408b0350e'
    ),
    UNHEX(
      'd344e56e420611f09efc6c2408b0350e'
    ),
    UNHEX(
      'dccfab2c420611f0b47f45a19a9312a5'
    ),
    UNHEX(
      'dccf938a420611f0b1f845a19a9312a5'
    ),
    UNHEX(
      'dccf9092420611f0bcd245a19a9312a5'
    ),
    UNHEX(
      'dccf947a420611f0ab1445a19a9312a5'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '83690f58aa0a11f09bc51daa3561b3d5'
  ),
  tl_files.uuid != UNHEX(
    '423d0a1e921f11f0a8ef27cdc2543e2f'
  ),
  tl_files.uuid != UNHEX(
    'a78b049c8d9311f0aca3f9eefb4f4453'
  ),
  tl_files.uuid != UNHEX(
    '5bcfa4c85cc811f0b5c109ec074ab94a'
  ),
  tl_files.uuid != UNHEX(
    'e1ef63c8536c11f09ca92b6a5ed5cf96'
  ),
  tl_files.uuid != UNHEX(
    '24362850501811f0a01edfd9cd3a664e'
  ),
  tl_files.uuid != UNHEX(
    'f3d20c00420311f08b386c2408b0350e'
  ),
  tl_files.uuid != UNHEX(
    'd344e56e420611f09efc6c2408b0350e'
  ),
  tl_files.uuid != UNHEX(
    'dccfab2c420611f0b47f45a19a9312a5'
  ),
  tl_files.uuid != UNHEX(
    'dccf938a420611f0b1f845a19a9312a5'
  ),
  tl_files.uuid != UNHEX(
    'dccf9092420611f0bcd245a19a9312a5'
  ),
  tl_files.uuid != UNHEX(
    'dccf947a420611f0ab1445a19a9312a5'
  )

SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('83690f58aa0a11f09bc51daa3561b3d5'),UNHEX('423d0a1e921f11f0a8ef27cdc2543e2f'),UNHEX('a78b049c8d9311f0aca3f9eefb4f4453'),UNHEX('5bcfa4c85cc811f0b5c109ec074ab94a'),UNHEX('e1ef63c8536c11f09ca92b6a5ed5cf96'),UNHEX('24362850501811f0a01edfd9cd3a664e'),UNHEX('f3d20c00420311f08b386c2408b0350e'),UNHEX('d344e56e420611f09efc6c2408b0350e'),UNHEX('dccfab2c420611f0b47f45a19a9312a5'),UNHEX('dccf938a420611f0b1f845a19a9312a5'),UNHEX('dccf9092420611f0bcd245a19a9312a5'),UNHEX('dccf947a420611f0ab1445a19a9312a5')) ORDER BY tl_files.uuid!=UNHEX('83690f58aa0a11f09bc51daa3561b3d5'), tl_files.uuid!=UNHEX('423d0a1e921f11f0a8ef27cdc2543e2f'), tl_files.uuid!=UNHEX('a78b049c8d9311f0aca3f9eefb4f4453'), tl_files.uuid!=UNHEX('5bcfa4c85cc811f0b5c109ec074ab94a'), tl_files.uuid!=UNHEX('e1ef63c8536c11f09ca92b6a5ed5cf96'), tl_files.uuid!=UNHEX('24362850501811f0a01edfd9cd3a664e'), tl_files.uuid!=UNHEX('f3d20c00420311f08b386c2408b0350e'), tl_files.uuid!=UNHEX('d344e56e420611f09efc6c2408b0350e'), tl_files.uuid!=UNHEX('dccfab2c420611f0b47f45a19a9312a5'), tl_files.uuid!=UNHEX('dccf938a420611f0b1f845a19a9312a5'), tl_files.uuid!=UNHEX('dccf9092420611f0bcd245a19a9312a5'), tl_files.uuid!=UNHEX('dccf947a420611f0ab1445a19a9312a5');

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(310, 312, 311, 315)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '310,312,311,315'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(310,312,311,315) ORDER BY FIND_IN_SET(`tl_page`.`id`, '310,312,311,315');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(316)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '316')

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

SELECT
  tl_files.*
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '7a644076a0b411eea6f26c2408b0350e'
    ),
    UNHEX(
      '7a644061a0b411eea6f26c2408b0350e'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '7a644076a0b411eea6f26c2408b0350e'
  ),
  tl_files.uuid != UNHEX(
    '7a644061a0b411eea6f26c2408b0350e'
  )

SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('7a644076a0b411eea6f26c2408b0350e'),UNHEX('7a644061a0b411eea6f26c2408b0350e')) ORDER BY tl_files.uuid!=UNHEX('7a644076a0b411eea6f26c2408b0350e'), tl_files.uuid!=UNHEX('7a644061a0b411eea6f26c2408b0350e');

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(318, 319)
ORDER BY
  FIND_IN_SET(`tl_page`.`id`, '297,318,319')

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(318,319) ORDER BY FIND_IN_SET(`tl_page`.`id`, '297,318,319');

SELECT
  p.id
FROM
  tl_page p
WHERE
  (
    p.id IN (?, ?, ?)
  )
  AND (
    p.hofff_st IN (?, ?)
  )
  AND (
    (
      p.hofff_st != 'hofff_st_disableTree'
      OR FIND_IN_SET(p.id, ?) > (
        SELECT
          COALESCE(
            MAX(
              FIND_IN_SET(p2.id, ?)
            ),
            -1
          )
        FROM
          tl_page AS p2
        WHERE
          p2.id IN (?, ?, ?)
          AND p2.hofff_st = 'hofff_st_parent'
      )
    )
  )
ORDER BY
  FIND_IN_SET(p.id, ?) ASC
LIMIT
  1

SELECT p.id FROM tl_page p WHERE (p.id IN (225, 317, 297)) AND (p.hofff_st IN ('hofff_st_tree', 'hofff_st_disableTree')) AND ((p.hofff_st != 'hofff_st_disableTree' OR FIND_IN_SET(p.id, '225,317,297') > (
                            SELECT COALESCE(MAX(FIND_IN_SET(p2.id, '225,317,297')), -1)
                            FROM   tl_page AS p2
                            WHERE  p2.id IN (225, 317, 297)
                            AND	   p2.hofff_st = 'hofff_st_parent'
                        ))) ORDER BY FIND_IN_SET(p.id, '225,317,297') ASC LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

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

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

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

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

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

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

SELECT
  tl_files.*
FROM
  tl_files
WHERE
  tl_files.uuid IN(
    UNHEX(
      '7a578444a0b411eea6f26c2408b0350e'
    ),
    UNHEX(
      '7a57831aa0b411eea6f26c2408b0350e'
    )
  )
ORDER BY
  tl_files.uuid != UNHEX(
    '7a578444a0b411eea6f26c2408b0350e'
  ),
  tl_files.uuid != UNHEX(
    '7a57831aa0b411eea6f26c2408b0350e'
  )

SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('7a578444a0b411eea6f26c2408b0350e'),UNHEX('7a57831aa0b411eea6f26c2408b0350e')) ORDER BY tl_files.uuid!=UNHEX('7a578444a0b411eea6f26c2408b0350e'), tl_files.uuid!=UNHEX('7a57831aa0b411eea6f26c2408b0350e');

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

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

SELECT
  tl_cookie_group.*
FROM
  tl_cookie_group
WHERE
  tl_cookie_group.pid = ?
  AND tl_cookie_group.published = '1'
ORDER BY
  tl_cookie_group.sorting

SELECT tl_cookie_group.* FROM tl_cookie_group WHERE tl_cookie_group.pid=1 AND tl_cookie_group.published='1' ORDER BY tl_cookie_group.sorting;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

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

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