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 = 'grace_accelerator_db'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  *
FROM
  tl_pct_customelement
WHERE
  alias != ''
  AND tstamp > 0
ORDER BY
  title

SELECT * FROM tl_pct_customelement WHERE alias!='' AND tstamp > 0 ORDER BY title;

SELECT
  *
FROM
  tl_pct_customelement_group
WHERE
  tstamp > 0
  AND pid IN(
    90, 80, 119, 53, 28, 19, 71, 9, 107, 67,
    140, 116, 137, 99, 82, 141, 78, 5, 113,
    112, 111, 44, 47, 46, 15, 13, 52, 51, 64,
    61, 65, 66, 4, 108, 134, 88, 77, 109, 45,
    127, 126, 125, 27, 29, 33, 94, 54, 144,
    100, 7, 106, 105, 32, 83, 70, 93, 6, 23,
    86, 121, 98, 97, 39, 38, 40, 2, 11, 3, 95,
    49, 151, 68, 43, 21, 117, 42, 136, 20,
    145, 146, 142, 114, 148, 147, 41, 124,
    122, 123
  )

SELECT * FROM tl_pct_customelement_group WHERE tstamp > 0 AND pid IN(90,80,119,53,28,19,71,9,107,67,140,116,137,99,82,141,78,5,113,112,111,44,47,46,15,13,52,51,64,61,65,66,4,108,134,88,77,109,45,127,126,125,27,29,33,94,54,144,100,7,106,105,32,83,70,93,6,23,86,121,98,97,39,38,40,2,11,3,95,49,151,68,43,21,117,42,136,20,145,146,142,114,148,147,41,124,122,123);

SELECT
  *
FROM
  tl_pct_customelement_attribute
WHERE
  tstamp > 0
  AND pid IN(
    2,
    4,
    5,
    6,
    7,
    8,
    9,
    10,
    17,
    18,
    19,
    20,
    21,
    24,
    27,
    28,
    29,
    30,
    31,
    32,
    33,
    37,
    38,
    39,
    40,
    44,
    45,
    46,
    52,
    53,
    56,
    66,
    67,
    68,
    69,
    70,
    71,
    73,
    76,
    77,
    78,
    79,
    81,
    82,
    83,
    84,
    85,
    86,
    88,
    89,
    97,
    100,
    101,
    102,
    103,
    104,
    106,
    107,
    125,
    126,
    127,
    128,
    130,
    131,
    134,
    135,
    137,
    138,
    139,
    142,
    143,
    144,
    149,
    154,
    155,
    156,
    157,
    158,
    159,
    160,
    161,
    162,
    168,
    169,
    170,
    171,
    172,
    173,
    179,
    180,
    181,
    182,
    189,
    190,
    191,
    231,
    235,
    236,
    237,
    238,
    245,
    247,
    252,
    256,
    257,
    258,
    259,
    262,
    267,
    268,
    273,
    274,
    275,
    292,
    293,
    294,
    295,
    297,
    300,
    301,
    303,
    308,
    310,
    312,
    313,
    316,
    317,
    321,
    322,
    324,
    325,
    326,
    327,
    328,
    329,
    330,
    332,
    333,
    334,
    335,
    336,
    337,
    338,
    339,
    340,
    341,
    342,
    343,
    344,
    345,
    346,
    347,
    348,
    349,
    350,
    351,
    352,
    353,
    354,
    355,
    356,
    357,
    358,
    359,
    360,
    361,
    362,
    363,
    364,
    365,
    366,
    367,
    368,
    369,
    370,
    371,
    372,
    373,
    374,
    375,
    376,
    377,
    378,
    379,
    380,
    381,
    382,
    383,
    384,
    385,
    386,
    387,
    388,
    389,
    390,
    391,
    392,
    393,
    394,
    395,
    396,
    397,
    398,
    399,
    400,
    401,
    402,
    403,
    404,
    405,
    406,
    407,
    408,
    409,
    410,
    411,
    412,
    413,
    426,
    427,
    428,
    429,
    430,
    431
  )

SELECT * FROM tl_pct_customelement_attribute WHERE tstamp > 0 AND pid IN(2,4,5,6,7,8,9,10,17,18,19,20,21,24,27,28,29,30,31,32,33,37,38,39,40,44,45,46,52,53,56,66,67,68,69,70,71,73,76,77,78,79,81,82,83,84,85,86,88,89,97,100,101,102,103,104,106,107,125,126,127,128,130,131,134,135,137,138,139,142,143,144,149,154,155,156,157,158,159,160,161,162,168,169,170,171,172,173,179,180,181,182,189,190,191,231,235,236,237,238,245,247,252,256,257,258,259,262,267,268,273,274,275,292,293,294,295,297,300,301,303,308,310,312,313,316,317,321,322,324,325,326,327,328,329,330,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,426,427,428,429,430,431);

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

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('en/home','en','home');

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

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=2604 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`=2709 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 ('en/home','en','home');

SELECT
  templates
FROM
  tl_theme
WHERE
  templates != ''

SELECT templates FROM tl_theme WHERE templates != '';

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

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

SELECT
  *
FROM
  tl_pct_themedesigner
WHERE
  tl_pct_themedesigner.active = ?
  AND tl_pct_themedesigner.theme = ?

SELECT * FROM tl_pct_themedesigner WHERE tl_pct_themedesigner.active=1 AND tl_pct_themedesigner.theme='eclipse_default';

SELECT
  *
FROM
  tl_pct_themedesigner
WHERE
  tl_pct_themedesigner.active = ?
  AND tl_pct_themedesigner.theme = ?

SELECT * FROM tl_pct_themedesigner WHERE tl_pct_themedesigner.active=1 AND tl_pct_themedesigner.theme='eclipse_default';

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

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

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.id IN(
    32, 120, 642, 239, 155, 450, 214, 0, 29,
    495, 262, 611, 160, 261, 0, 216, 156,
    148, 133, 575, 0, 610, 133, 148, 159,
    222, 154, 147
  )
ORDER BY
  FIND_IN_SET(
    `tl_module`.`id`, '32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147'
  )

SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147) ORDER BY FIND_IN_SET(`tl_module`.`id`, '32,120,642,239,155,450,214,0,29,495,262,611,160,261,0,216,156,148,133,575,0,610,133,148,159,222,154,147');

SHOW FULL COLUMNS
FROM
  tl_user

SHOW FULL COLUMNS FROM tl_user;

SHOW INDEXES
FROM
  `tl_user`

SHOW INDEXES FROM `tl_user`;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.type = 'root'
  AND (
    tl_page.dns = ?
    OR tl_page.dns IN (
      SELECT
        dns
      FROM
        tl_page
      WHERE
        type = 'root'
        AND fallback = '1'
        AND id = (
          SELECT
            languageRoot
          FROM
            tl_page
          WHERE
            type = 'root'
            AND fallback = '1'
            AND dns = ?
          LIMIT
            1
        )
    ) OR tl_page.dns IN (
      SELECT
        dns
      FROM
        tl_page
      WHERE
        type = 'root'
        AND fallback = '1'
        AND languageRoot = (
          SELECT
            id
          FROM
            tl_page
          WHERE
            type = 'root'
            AND fallback = '1'
            AND dns = ?
          LIMIT
            1
        )
    ) OR tl_page.dns IN (
      SELECT
        dns
      FROM
        tl_page
      WHERE
        type = 'root'
        AND fallback = '1'
        AND languageRoot != 0
        AND languageRoot = (
          SELECT
            languageRoot
          FROM
            tl_page
          WHERE
            type = 'root'
            AND fallback = '1'
            AND dns = ?
          LIMIT
            1
        )
    )
  )
ORDER BY
  sorting

SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND (
                tl_page.dns=''
                OR tl_page.dns IN (
                    SELECT dns
                    FROM tl_page
                    WHERE type='root' AND fallback='1' AND id = (
                        SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns='' LIMIT 1
                    )
                )
                OR tl_page.dns IN (
                    SELECT dns
                    FROM tl_page
                    WHERE type='root' AND fallback='1' AND languageRoot = (
                        SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns='' LIMIT 1
                    )
                )
                OR tl_page.dns IN (
                    SELECT dns
                    FROM tl_page
                    WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = (
                        SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns='' LIMIT 1
                    )
                )
            ) ORDER BY sorting;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.id = ?
    OR tl_page.languageMain = ?
  )
  AND tl_page.published = '1'
  AND (
    tl_page.start = ''
    OR tl_page.start < 1766072580
  )
  AND (
    tl_page.stop = ''
    OR tl_page.stop > 1766072640
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.id=2605 OR tl_page.languageMain=2605) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1766072580) AND (tl_page.stop='' OR tl_page.stop>1766072640);

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=217 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 <= 1766072580
      )
      AND (
        p2.stop = ''
        OR p2.stop > 1766072580
      )
  ) 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 <= 1766072580
  )
  AND (
    p1.stop = ''
    OR p1.stop > 1766072580
  )
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<=1766072580) AND (p2.stop='' OR p2.stop>1766072580)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=217 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<=1766072580) AND (p1.stop='' OR p1.stop>1766072580) ORDER BY p1.sorting;

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

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

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

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

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

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

SELECT tl_page.* FROM tl_page WHERE tl_page.id=233 AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1766072580) AND (tl_page.stop='' OR tl_page.stop>1766072580) 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`=6 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 <= 1766072580
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > 1766072580
  )
ORDER BY
  tl_article.sorting

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

SELECT
  *
FROM
  tl_theme
ORDER BY
  name

SELECT * FROM tl_theme ORDER BY name;

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

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

SHOW FULL COLUMNS
FROM
  tl_content

SHOW FULL COLUMNS FROM tl_content;

SHOW INDEXES
FROM
  `tl_content`

SHOW INDEXES FROM `tl_content`;

SELECT
  pct_customelement
FROM
  tl_content
WHERE
  id = ?
LIMIT
  0, 1

SELECT pct_customelement FROM tl_content WHERE id=117841 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
  tl_form.*,
  j1.`ribbon` AS leadOptInTarget__ribbon,
  j1.`addImage` AS leadOptInTarget__addImage,
  j1.`singleSRC` AS leadOptInTarget__singleSRC,
  j1.`style_css` AS leadOptInTarget__style_css,
  j1.`height_css` AS leadOptInTarget__height_css,
  j1.`imgHeadline` AS leadOptInTarget__imgHeadline,
  j1.`imgSubheadline` AS leadOptInTarget__imgSubheadline,
  j1.`addArticle` AS leadOptInTarget__addArticle,
  j1.`article` AS leadOptInTarget__article,
  j1.`visibility_css` AS leadOptInTarget__visibility_css,
  j1.`analytics_google` AS leadOptInTarget__analytics_google,
  j1.`analytics_matomo` AS leadOptInTarget__analytics_matomo,
  j1.`google_maps` AS leadOptInTarget__google_maps,
  j1.`id` AS leadOptInTarget__id,
  j1.`pid` AS leadOptInTarget__pid,
  j1.`sorting` AS leadOptInTarget__sorting,
  j1.`tstamp` AS leadOptInTarget__tstamp,
  j1.`title` AS leadOptInTarget__title,
  j1.`type` AS leadOptInTarget__type,
  j1.`alias` AS leadOptInTarget__alias,
  j1.`requireItem` AS leadOptInTarget__requireItem,
  j1.`routePriority` AS leadOptInTarget__routePriority,
  j1.`pageTitle` AS leadOptInTarget__pageTitle,
  j1.`language` AS leadOptInTarget__language,
  j1.`robots` AS leadOptInTarget__robots,
  j1.`description` AS leadOptInTarget__description,
  j1.`redirect` AS leadOptInTarget__redirect,
  j1.`jumpTo` AS leadOptInTarget__jumpTo,
  j1.`redirectBack` AS leadOptInTarget__redirectBack,
  j1.`url` AS leadOptInTarget__url,
  j1.`target` AS leadOptInTarget__target,
  j1.`dns` AS leadOptInTarget__dns,
  j1.`staticFiles` AS leadOptInTarget__staticFiles,
  j1.`staticPlugins` AS leadOptInTarget__staticPlugins,
  j1.`fallback` AS leadOptInTarget__fallback,
  j1.`disableLanguageRedirect` AS leadOptInTarget__disableLanguageRedirect,
  j1.`favicon` AS leadOptInTarget__favicon,
  j1.`robotsTxt` AS leadOptInTarget__robotsTxt,
  j1.`maintenanceMode` AS leadOptInTarget__maintenanceMode,
  j1.`mailerTransport` AS leadOptInTarget__mailerTransport,
  j1.`enableCanonical` AS leadOptInTarget__enableCanonical,
  j1.`canonicalLink` AS leadOptInTarget__canonicalLink,
  j1.`canonicalKeepParams` AS leadOptInTarget__canonicalKeepParams,
  j1.`adminEmail` AS leadOptInTarget__adminEmail,
  j1.`dateFormat` AS leadOptInTarget__dateFormat,
  j1.`timeFormat` AS leadOptInTarget__timeFormat,
  j1.`datimFormat` AS leadOptInTarget__datimFormat,
  j1.`validAliasCharacters` AS leadOptInTarget__validAliasCharacters,
  j1.`useFolderUrl` AS leadOptInTarget__useFolderUrl,
  j1.`urlPrefix` AS leadOptInTarget__urlPrefix,
  j1.`urlSuffix` AS leadOptInTarget__urlSuffix,
  j1.`useSSL` AS leadOptInTarget__useSSL,
  j1.`autoforward` AS leadOptInTarget__autoforward,
  j1.`protected` AS leadOptInTarget__protected,
  j1.`groups` AS leadOptInTarget__groups,
  j1.`includeLayout` AS leadOptInTarget__includeLayout,
  j1.`layout` AS leadOptInTarget__layout,
  j1.`subpageLayout` AS leadOptInTarget__subpageLayout,
  j1.`includeCache` AS leadOptInTarget__includeCache,
  j1.`cache` AS leadOptInTarget__cache,
  j1.`alwaysLoadFromCache` AS leadOptInTarget__alwaysLoadFromCache,
  j1.`clientCache` AS leadOptInTarget__clientCache,
  j1.`includeChmod` AS leadOptInTarget__includeChmod,
  j1.`cuser` AS leadOptInTarget__cuser,
  j1.`cgroup` AS leadOptInTarget__cgroup,
  j1.`chmod` AS leadOptInTarget__chmod,
  j1.`noSearch` AS leadOptInTarget__noSearch,
  j1.`cssClass` AS leadOptInTarget__cssClass,
  j1.`sitemap` AS leadOptInTarget__sitemap,
  j1.`hide` AS leadOptInTarget__hide,
  j1.`guests` AS leadOptInTarget__guests,
  j1.`tabindex` AS leadOptInTarget__tabindex,
  j1.`accesskey` AS leadOptInTarget__accesskey,
  j1.`published` AS leadOptInTarget__published,
  j1.`start` AS leadOptInTarget__start,
  j1.`stop` AS leadOptInTarget__stop,
  j1.`enforceTwoFactor` AS leadOptInTarget__enforceTwoFactor,
  j1.`twoFactorJumpTo` AS leadOptInTarget__twoFactorJumpTo,
  j1.`pct_structured_data` AS leadOptInTarget__pct_structured_data,
  j1.`pdftemplate` AS leadOptInTarget__pdftemplate,
  j1.`pdfTplSRC` AS leadOptInTarget__pdfTplSRC,
  j1.`pdfMargin` AS leadOptInTarget__pdfMargin,
  j1.`pdfIgnoreCSS` AS leadOptInTarget__pdfIgnoreCSS,
  j1.`pct_theme` AS leadOptInTarget__pct_theme,
  j1.`pct_theme_import` AS leadOptInTarget__pct_theme_import,
  j1.`pct_theme_cto` AS leadOptInTarget__pct_theme_cto,
  j1.`languageMain` AS leadOptInTarget__languageMain,
  j1.`languageRoot` AS leadOptInTarget__languageRoot,
  j1.`languageQuery` AS leadOptInTarget__languageQuery,
  j1.`addFontIcon` AS leadOptInTarget__addFontIcon,
  j1.`fontIcon` AS leadOptInTarget__fontIcon
FROM
  tl_form
  LEFT JOIN tl_page j1 ON tl_form.`leadOptInTarget` = j1.id
WHERE
  tl_form.`id` = ?
LIMIT
  0, 1

SELECT tl_form.*, j1.`ribbon` AS leadOptInTarget__ribbon, j1.`addImage` AS leadOptInTarget__addImage, j1.`singleSRC` AS leadOptInTarget__singleSRC, j1.`style_css` AS leadOptInTarget__style_css, j1.`height_css` AS leadOptInTarget__height_css, j1.`imgHeadline` AS leadOptInTarget__imgHeadline, j1.`imgSubheadline` AS leadOptInTarget__imgSubheadline, j1.`addArticle` AS leadOptInTarget__addArticle, j1.`article` AS leadOptInTarget__article, j1.`visibility_css` AS leadOptInTarget__visibility_css, j1.`analytics_google` AS leadOptInTarget__analytics_google, j1.`analytics_matomo` AS leadOptInTarget__analytics_matomo, j1.`google_maps` AS leadOptInTarget__google_maps, j1.`id` AS leadOptInTarget__id, j1.`pid` AS leadOptInTarget__pid, j1.`sorting` AS leadOptInTarget__sorting, j1.`tstamp` AS leadOptInTarget__tstamp, j1.`title` AS leadOptInTarget__title, j1.`type` AS leadOptInTarget__type, j1.`alias` AS leadOptInTarget__alias, j1.`requireItem` AS leadOptInTarget__requireItem, j1.`routePriority` AS leadOptInTarget__routePriority, j1.`pageTitle` AS leadOptInTarget__pageTitle, j1.`language` AS leadOptInTarget__language, j1.`robots` AS leadOptInTarget__robots, j1.`description` AS leadOptInTarget__description, j1.`redirect` AS leadOptInTarget__redirect, j1.`jumpTo` AS leadOptInTarget__jumpTo, j1.`redirectBack` AS leadOptInTarget__redirectBack, j1.`url` AS leadOptInTarget__url, j1.`target` AS leadOptInTarget__target, j1.`dns` AS leadOptInTarget__dns, j1.`staticFiles` AS leadOptInTarget__staticFiles, j1.`staticPlugins` AS leadOptInTarget__staticPlugins, j1.`fallback` AS leadOptInTarget__fallback, j1.`disableLanguageRedirect` AS leadOptInTarget__disableLanguageRedirect, j1.`favicon` AS leadOptInTarget__favicon, j1.`robotsTxt` AS leadOptInTarget__robotsTxt, j1.`maintenanceMode` AS leadOptInTarget__maintenanceMode, j1.`mailerTransport` AS leadOptInTarget__mailerTransport, j1.`enableCanonical` AS leadOptInTarget__enableCanonical, j1.`canonicalLink` AS leadOptInTarget__canonicalLink, j1.`canonicalKeepParams` AS leadOptInTarget__canonicalKeepParams, j1.`adminEmail` AS leadOptInTarget__adminEmail, j1.`dateFormat` AS leadOptInTarget__dateFormat, j1.`timeFormat` AS leadOptInTarget__timeFormat, j1.`datimFormat` AS leadOptInTarget__datimFormat, j1.`validAliasCharacters` AS leadOptInTarget__validAliasCharacters, j1.`useFolderUrl` AS leadOptInTarget__useFolderUrl, j1.`urlPrefix` AS leadOptInTarget__urlPrefix, j1.`urlSuffix` AS leadOptInTarget__urlSuffix, j1.`useSSL` AS leadOptInTarget__useSSL, j1.`autoforward` AS leadOptInTarget__autoforward, j1.`protected` AS leadOptInTarget__protected, j1.`groups` AS leadOptInTarget__groups, j1.`includeLayout` AS leadOptInTarget__includeLayout, j1.`layout` AS leadOptInTarget__layout, j1.`subpageLayout` AS leadOptInTarget__subpageLayout, j1.`includeCache` AS leadOptInTarget__includeCache, j1.`cache` AS leadOptInTarget__cache, j1.`alwaysLoadFromCache` AS leadOptInTarget__alwaysLoadFromCache, j1.`clientCache` AS leadOptInTarget__clientCache, j1.`includeChmod` AS leadOptInTarget__includeChmod, j1.`cuser` AS leadOptInTarget__cuser, j1.`cgroup` AS leadOptInTarget__cgroup, j1.`chmod` AS leadOptInTarget__chmod, j1.`noSearch` AS leadOptInTarget__noSearch, j1.`cssClass` AS leadOptInTarget__cssClass, j1.`sitemap` AS leadOptInTarget__sitemap, j1.`hide` AS leadOptInTarget__hide, j1.`guests` AS leadOptInTarget__guests, j1.`tabindex` AS leadOptInTarget__tabindex, j1.`accesskey` AS leadOptInTarget__accesskey, j1.`published` AS leadOptInTarget__published, j1.`start` AS leadOptInTarget__start, j1.`stop` AS leadOptInTarget__stop, j1.`enforceTwoFactor` AS leadOptInTarget__enforceTwoFactor, j1.`twoFactorJumpTo` AS leadOptInTarget__twoFactorJumpTo, j1.`pct_structured_data` AS leadOptInTarget__pct_structured_data, j1.`pdftemplate` AS leadOptInTarget__pdftemplate, j1.`pdfTplSRC` AS leadOptInTarget__pdfTplSRC, j1.`pdfMargin` AS leadOptInTarget__pdfMargin, j1.`pdfIgnoreCSS` AS leadOptInTarget__pdfIgnoreCSS, j1.`pct_theme` AS leadOptInTarget__pct_theme, j1.`pct_theme_import` AS leadOptInTarget__pct_theme_import, j1.`pct_theme_cto` AS leadOptInTarget__pct_theme_cto, j1.`languageMain` AS leadOptInTarget__languageMain, j1.`languageRoot` AS leadOptInTarget__languageRoot, j1.`languageQuery` AS leadOptInTarget__languageQuery, j1.`addFontIcon` AS leadOptInTarget__addFontIcon, j1.`fontIcon` AS leadOptInTarget__fontIcon FROM tl_form LEFT JOIN tl_page j1 ON tl_form.`leadOptInTarget`=j1.id WHERE tl_form.`id`=0 LIMIT 0,1;