Symfony Profiler

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 <= 1776051300
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1776051300
      )
  ) 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 <= 1776051300
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1776051300
  )
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<=1776051300) AND (p2.stop='' OR p2.stop>1776051300)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=90 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<=1776051300) AND (p1.stop='' OR p1.stop>1776051300) ORDER BY p1.sorting;

SELECT
  id,
  protected,
  `groups`,
  similarity / vectorLength AS relevance
FROM
  (
    SELECT
      tl_search_index.pid AS sid,
      (
        0 + (
          (
            1 + LOG(
              SUM(
                match0 * tl_search_index.relevance
              )
            )
          ) * POW(
            MIN(match0 * matchedTerm.idf),
            2
          ) / 1
        )
      ) / sqrt(
        0 + POW(
          MIN(match0 * matchedTerm.idf) / 1,
          2
        )
      ) AS similarity
    FROM
      (
        SELECT
          id,
          term,
          LOG(
            (@searchCount + 1) / GREATEST(1, documentFrequency)
          ) AS idf,
          IF(term = ?, 1, null) AS match0
        FROM
          (
            SELECT
              @searchCount := (
                SELECT
                  COUNT(*)
                FROM
                  tl_search
              )
          ) variables,
          tl_search_term
        HAVING
          match0 = 1
      ) matchedTerm
      JOIN tl_search_index ON tl_search_index.termId = matchedTerm.id
    GROUP BY
      tl_search_index.pid
    HAVING
      COUNT(matchedTerm.match0) > 0
  ) matches
  LEFT JOIN tl_search ON(matches.sid = tl_search.id)
WHERE
  1
  AND tl_search.pid IN(
    140,
    105,
    187,
    190,
    143,
    161,
    91,
    134,
    139,
    159,
    160,
    162,
    163,
    164,
    165,
    171,
    172,
    173,
    175,
    179,
    180,
    106,
    107,
    123,
    135,
    92,
    101,
    118,
    166,
    167,
    208,
    384,
    169,
    170,
    181,
    326,
    328,
    330,
    331,
    332,
    333,
    183,
    334,
    337,
    184,
    185,
    186,
    216,
    217,
    218,
    219,
    220,
    222,
    261,
    176,
    207,
    381,
    382,
    383,
    188,
    189,
    129,
    130,
    133,
    138,
    147,
    113,
    114,
    115,
    116,
    125,
    126,
    127,
    128,
    149,
    120,
    121,
    122,
    124,
    174,
    315,
    316,
    317,
    318,
    319,
    320,
    321,
    322,
    323,
    324,
    325,
    223,
    224,
    236,
    237,
    238,
    239,
    240,
    241,
    242,
    243,
    244,
    245,
    252,
    253,
    254,
    255,
    256,
    257,
    258,
    259,
    225,
    229,
    230,
    231,
    232,
    233,
    234,
    235,
    246,
    247,
    248,
    249,
    250,
    251,
    271,
    272,
    273,
    274,
    275,
    276,
    277,
    278,
    279,
    262,
    263,
    264,
    265,
    266,
    267,
    268,
    269,
    270,
    327,
    329,
    335,
    338,
    155,
    156,
    152,
    153,
    154,
    336,
    339,
    182,
    340,
    341,
    342,
    343,
    344
  )
ORDER BY
  relevance DESC

SELECT id, protected, `groups`, similarity / vectorLength AS relevance FROM (SELECT tl_search_index.pid AS sid, (0+ ((1+LOG(SUM(match0 * tl_search_index.relevance))) * POW(MIN(match0 * matchedTerm.idf), 2) / 1)) / sqrt(0+ POW(MIN(match0 * matchedTerm.idf) / 1, 2)) AS similarity FROM (SELECT id, term, LOG((@searchCount + 1) / GREATEST(1, documentFrequency)) AS idf, IF(term='2025', 1, null) AS match0 FROM ( SELECT @searchCount := (SELECT COUNT(*) FROM tl_search)) variables, tl_search_term HAVING match0 = 1) matchedTerm JOIN tl_search_index ON tl_search_index.termId = matchedTerm.id GROUP BY tl_search_index.pid HAVING COUNT(matchedTerm.match0) > 0) matches LEFT JOIN tl_search ON(matches.sid=tl_search.id) WHERE 1 AND tl_search.pid IN(140,105,187,190,143,161,91,134,139,159,160,162,163,164,165,171,172,173,175,179,180,106,107,123,135,92,101,118,166,167,208,384,169,170,181,326,328,330,331,332,333,183,334,337,184,185,186,216,217,218,219,220,222,261,176,207,381,382,383,188,189,129,130,133,138,147,113,114,115,116,125,126,127,128,149,120,121,122,124,174,315,316,317,318,319,320,321,322,323,324,325,223,224,236,237,238,239,240,241,242,243,244,245,252,253,254,255,256,257,258,259,225,229,230,231,232,233,234,235,246,247,248,249,250,251,271,272,273,274,275,276,277,278,279,262,263,264,265,266,267,268,269,270,327,329,335,338,155,156,152,153,154,336,339,182,340,341,342,343,344) ORDER BY relevance DESC;

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

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

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

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

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.pdir_th_tag = ?
  AND tl_article.pdir_th_domain = ?
LIMIT
  0, 1

SELECT tl_article.* FROM tl_article WHERE tl_article.pdir_th_tag='MATE01/04' AND tl_article.pdir_th_domain=90 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 ('module/suche','module');

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(179, 172, 139, 134, 180)
  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 <= 1776051300
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1776051300
  )
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '179,172,139,134,180'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(179,172,139,134,180) 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<=1776051300) AND (tl_page.stop='' OR tl_page.stop>1776051300) ORDER BY FIND_IN_SET(`tl_page`.`id`, '179,172,139,134,180');

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

SELECT tl_article.* FROM tl_article WHERE tl_article.`pdir_th_tag`='MATE01/04' 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 <= 1776051300
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1776051300
  )
LIMIT
  0, 1

SELECT tl_page.* FROM tl_page WHERE tl_page.id=129 AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1776051300) AND (tl_page.stop='' OR tl_page.stop>1776051300) 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='191' LIMIT 0,1;

SELECT
  TLB.`id`,
  TLB.`banner_weighting`
FROM
  tl_banner AS TLB
  LEFT JOIN tl_banner_category ON tl_banner_category.id = TLB.pid
  LEFT OUTER JOIN tl_banner_stat AS TLS ON TLB.id = TLS.id
WHERE
  pid = ?
  AND (
    (TLB.banner_until = ?)
    OR (
      TLB.banner_until = 1
      AND TLB.banner_views_until > TLS.banner_views
    )
    OR (
      TLB.banner_until = 1
      AND TLB.banner_views_until = ?
    )
    OR (
      TLB.banner_until = 1
      AND TLS.banner_views is NULL
    )
  )
  AND (
    (TLB.banner_until = ?)
    OR (
      TLB.banner_until = 1
      AND TLB.banner_clicks_until > TLS.banner_clicks
    )
    OR (
      TLB.banner_until = 1
      AND TLB.banner_clicks_until = ?
    )
    OR (
      TLB.banner_until = 1
      AND TLS.banner_clicks is NULL
    )
  )
  AND TLB.banner_published = ?
  AND (
    TLB.banner_start = ?
    OR TLB.banner_start <= ?
  )
  AND (
    TLB.banner_stop = ?
    OR TLB.banner_stop >= ?
  )
  AND (
    TLB.banner_domain = ?
    OR RIGHT(
      ?,
      CHAR_LENGTH(TLB.banner_domain)
    ) = TLB.banner_domain
  )
ORDER BY
  TLB.`sorting`

SELECT 
                                        TLB.`id`, TLB.`banner_weighting`
                                   FROM 
                                        tl_banner AS TLB 
                                   LEFT JOIN 
                                        tl_banner_category ON tl_banner_category.id=TLB.pid
                                   LEFT OUTER JOIN 
                                        tl_banner_stat AS TLS ON TLB.id=TLS.id
                                   WHERE 
                                        pid='1'
                                   AND (
                                           (TLB.banner_until='') 
		                                OR (TLB.banner_until=1 AND TLB.banner_views_until>TLS.banner_views)   
                                        OR (TLB.banner_until=1 AND TLB.banner_views_until='')  
                                        OR (TLB.banner_until=1 AND TLS.banner_views is NULL)
                                       )
                                   AND (
                                           (TLB.banner_until='') 
                                        OR (TLB.banner_until=1 AND TLB.banner_clicks_until>TLS.banner_clicks) 
                                        OR (TLB.banner_until=1 AND TLB.banner_clicks_until='') 
                                        OR (TLB.banner_until=1 AND TLS.banner_clicks is NULL)
                                       )
                                   AND 
                                        TLB.banner_published =1
                                   AND 
                                       (TLB.banner_start='' OR TLB.banner_start<=1776051354) 
                                   AND 
                                       (TLB.banner_stop='' OR TLB.banner_stop>=1776051354)
                                   AND 
                                       (TLB.banner_domain='' OR RIGHT('www.share.pano.pdir.dev', CHAR_LENGTH(TLB.banner_domain)) = TLB.banner_domain)
                                   ORDER BY TLB.`sorting`;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(
    314, 358, 330, 365, 0, 356, 0, 0, 0, 271
  )
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '314,358,330,365,0,356,0,0,0,271'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(314,358,330,365,0,356,0,0,0,271) ORDER BY FIND_IN_SET(`tl_module`.`id`, '314,358,330,365,0,356,0,0,0,271');

INSERT INTO tl_log (
  tstamp, source, action, username, text,
  func, browser
)
VALUES
  (
    :tstamp, :source, :action, :username,
    :text, :func, :browser
  )

INSERT INTO
                tl_log
                    (tstamp, source, action, username, text, func, browser)
                VALUES
                    ('1776051353', 'FE', 'CRON', 'anon.', 'Purged the shared cache', 'Contao\\Automator::purgePageCache', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36')
        ;

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=19 AND tl_image_size_item.invisible='' ORDER BY sorting ASC;

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

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

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

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

SELECT
  *
FROM
  tl_style_sheet

SELECT * FROM tl_style_sheet;

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

SELECT tl_page.* FROM tl_page WHERE tl_page.pid=90 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<=1776051300) AND (tl_page.stop='' OR tl_page.stop>1776051300) ORDER BY tl_page.sorting LIMIT 0,1;

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

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

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

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

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

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

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(
    184, 185, 186, 165, 175, 179, 172, 160
  )
  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 <= 1776051300
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1776051300
  )
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '184,185,186,165,175,179,172,160'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(184,185,186,165,175,179,172,160) 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<=1776051300) AND (tl_page.stop='' OR tl_page.stop>1776051300) ORDER BY FIND_IN_SET(`tl_page`.`id`, '184,185,186,165,175,179,172,160');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(
    170, 169, 326, 328, 330, 331, 332, 181,
    333
  )
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '170,169,326,328,330,331,332,181,333'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(170,169,326,328,330,331,332,181,333) ORDER BY FIND_IN_SET(`tl_page`.`id`, '170,169,326,328,330,331,332,181,333');

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(
    184, 216, 217, 218, 185, 219, 186, 261,
    220, 222
  )
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '184,216,217,218,185,219,186,261,220,222'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(184,216,217,218,185,219,186,261,220,222) ORDER BY FIND_IN_SET(`tl_page`.`id`, '184,216,217,218,185,219,186,261,220,222');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(
    174, 315, 316, 317, 318, 319, 320, 321,
    322, 323, 324, 325
  )
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '174,315,316,317,318,319,320,321,322,323,324,325'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(174,315,316,317,318,319,320,321,322,323,324,325) ORDER BY FIND_IN_SET(`tl_page`.`id`, '174,315,316,317,318,319,320,321,322,323,324,325');

SELECT
  id,
  pid
FROM
  tl_page
WHERE
  pid IN(
    129, 130, 133, 138, 147, 113, 114, 115,
    116, 125, 126, 127, 128, 149, 120, 121,
    122, 124, 174, 315, 316, 317, 318, 319,
    320, 321, 322, 323, 324, 325, 223, 224,
    236, 237, 238, 239, 240, 241, 242, 243,
    244, 245, 252, 253, 254, 255, 256, 257,
    258, 259, 225, 229, 230, 231, 232, 233,
    234, 235, 246, 247, 248, 249, 250, 251,
    271, 272, 273, 274, 275, 276, 277, 278,
    279, 262, 263, 264, 265, 266, 267, 268,
    269, 270, 327, 329, 335, 338
  )

SELECT id, pid FROM tl_page WHERE pid IN(129,130,133,138,147,113,114,115,116,125,126,127,128,149,120,121,122,124,174,315,316,317,318,319,320,321,322,323,324,325,223,224,236,237,238,239,240,241,242,243,244,245,252,253,254,255,256,257,258,259,225,229,230,231,232,233,234,235,246,247,248,249,250,251,271,272,273,274,275,276,277,278,279,262,263,264,265,266,267,268,269,270,327,329,335,338);

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(
    236, 237, 238, 239, 240, 241, 242, 243,
    244, 245
  )
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '236,237,238,239,240,241,242,243,244,245'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(236,237,238,239,240,241,242,243,244,245) ORDER BY FIND_IN_SET(`tl_page`.`id`, '236,237,238,239,240,241,242,243,244,245');

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

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

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(161, 162, 163, 164, 165, 179)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '161,162,163,164,165,179'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(161,162,163,164,165,179) ORDER BY FIND_IN_SET(`tl_page`.`id`, '161,162,163,164,165,179');

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

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

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

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