Symfony Profiler

Query Metrics

81 Database Queries

28 Different statements

33.81 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT urlPrefix, urlSuffix FROM tl_page WHERE type = 'root'
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?)
SELECT DATABASE()
SELECT
       c.TABLE_NAME,
       c.COLUMN_NAME        AS field,
       c.DATA_TYPE                   AS type,
       c.COLUMN_TYPE,
       c.CHARACTER_MAXIMUM_LENGTH,
       c.CHARACTER_OCTET_LENGTH,
       c.NUMERIC_PRECISION,
       c.NUMERIC_SCALE,
       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 c.TABLE_NAME,
         c.ORDINAL_POSITION
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 TABLE_NAME,
         SEQ_IN_INDEX
SELECT
            k.TABLE_NAME,
            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION,
            c.UPDATE_RULE,
            c.DELETE_RULE
FROM information_schema.key_column_usage k
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 c.CONSTRAINT_SCHEMA = ?
AND k.REFERENCED_COLUMN_NAME IS NOT NULL
ORDER BY k.TABLE_NAME,
         k.CONSTRAINT_NAME,
         k.ORDINAL_POSITION
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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0,1
SELECT templates FROM tl_theme WHERE templates != ''
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id` = ? LIMIT 0,1
SELECT * FROM tl_theme WHERE tl_theme.`id` = ? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(2,0,0,5,3) ORDER BY FIND_IN_SET(`tl_module`.`id`, '2,0,0,5,3')
SELECT tl_content.id, tl_module.type, tl_article.inColumn as `column` FROM tl_content, tl_module, tl_article WHERE tl_content.pid=tl_article.id AND tl_content.module=tl_module.id AND tl_content.type=? AND tl_content.ptable=? AND tl_article.pid=? AND tl_article.inColumn IN (?, ?) AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting
SELECT tl_content.* FROM tl_content WHERE tl_content.`id` = ? LIMIT 0,1
SELECT * FROM `tl_files` WHERE uuid = ?
SELECT * FROM tl_files WHERE tl_files.`path` = ? LIMIT 0,1
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=? AND tl_article.inColumn=? AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) ORDER BY tl_article.sorting
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<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id` = ? LIMIT 0,1
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible=0 AND tl_image_size_item.tstamp>0 ORDER BY sorting ASC
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
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` = ? ORDER BY tl_article.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
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` = ? ORDER BY tl_article.sorting
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1
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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
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` = ? ORDER BY tl_article.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,8,10,11,12) 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<=1772726880) AND (tl_page.stop='' OR tl_page.stop>1772726880) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12')
SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? 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=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1772726880) AND (p2.stop='' OR p2.stop>1772726880)) 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<=1772726880) AND (p1.stop='' OR p1.stop>1772726880) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(13,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,13,5,6')
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,8,10,11,12) 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<=1772726880) AND (tl_page.stop='' OR tl_page.stop>1772726880) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12')

#▲	Time	Info
1	0.31 ms	SELECT urlPrefix, urlSuffix FROM tl_page WHERE type = 'root' Parameters: [] View formatted query View runnable query Explain query SELECT urlPrefix, urlSuffix FROM tl_page WHERE type = 'root' SELECT urlPrefix, urlSuffix FROM tl_page WHERE type = 'root';
2	0.31 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?) Parameters: [`"lighting"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?) SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN ('lighting');
3	0.18 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4	8.54 ms	SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, c.DATA_TYPE AS type, c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, 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 c.TABLE_NAME, c.ORDINAL_POSITION Parameters: [`"hood_marbach-2019" "hood_marbach-2019"`] View formatted query View runnable query Explain query SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, c.DATA_TYPE AS type, c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, 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 c.TABLE_NAME, c.ORDINAL_POSITION SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, c.DATA_TYPE AS type, c.COLUMN_TYPE, c.CHARACTER_MAXIMUM_LENGTH, c.CHARACTER_OCTET_LENGTH, c.NUMERIC_PRECISION, c.NUMERIC_SCALE, 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 = 'hood_marbach-2019' AND t.TABLE_SCHEMA = 'hood_marbach-2019' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY c.TABLE_NAME, c.ORDINAL_POSITION;
5	2.24 ms	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 TABLE_NAME, SEQ_IN_INDEX Parameters: [`"hood_marbach-2019"`] View formatted query View runnable query Explain query 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 TABLE_NAME, 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 = 'hood_marbach-2019' ORDER BY TABLE_NAME, SEQ_IN_INDEX;
6	0.76 ms	SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION, c.UPDATE_RULE, c.DELETE_RULE FROM information_schema.key_column_usage k 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 c.CONSTRAINT_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION Parameters: [`"hood_marbach-2019" "hood_marbach-2019"`] View formatted query View runnable query Explain query SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION, c.UPDATE_RULE, c.DELETE_RULE FROM information_schema.key_column_usage k 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 c.CONSTRAINT_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION SELECT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION, c.UPDATE_RULE, c.DELETE_RULE FROM information_schema.key_column_usage k 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 = 'hood_marbach-2019' AND c.CONSTRAINT_SCHEMA = 'hood_marbach-2019' AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.TABLE_NAME, k.CONSTRAINT_NAME, k.ORDINAL_POSITION;
7	1.09 ms	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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"hood_marbach-2019"`] View formatted query View runnable query Explain query 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.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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'hood_marbach-2019' AND t.TABLE_TYPE = 'BASE TABLE';
8	0.25 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query 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;
9	0.22 ms	SELECT templates FROM tl_theme WHERE templates != '' Parameters: [] View formatted query View runnable query Explain query SELECT templates FROM tl_theme WHERE templates != '' SELECT templates FROM tl_theme WHERE templates != '';
10	0.26 ms	SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id` = ? LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query 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;
11	0.20 ms	SELECT * FROM tl_theme WHERE tl_theme.`id` = ? LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM tl_theme WHERE tl_theme.`id` = ? LIMIT 0, 1 SELECT * FROM tl_theme WHERE tl_theme.`id` = 1 LIMIT 0,1;
12	0.32 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(2,0,0,5,3) ORDER BY FIND_IN_SET(`tl_module`.`id`, '2,0,0,5,3') Parameters: [] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(2, 0, 0, 5, 3) ORDER BY FIND_IN_SET(`tl_module`.`id`, '2,0,0,5,3') SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(2,0,0,5,3) ORDER BY FIND_IN_SET(`tl_module`.`id`, '2,0,0,5,3');
13	0.37 ms	SELECT tl_content.id, tl_module.type, tl_article.inColumn as `column` FROM tl_content, tl_module, tl_article WHERE tl_content.pid=tl_article.id AND tl_content.module=tl_module.id AND tl_content.type=? AND tl_content.ptable=? AND tl_article.pid=? AND tl_article.inColumn IN (?, ?) AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting Parameters: [`"module" "tl_article" 4 "header" "main"`] View formatted query View runnable query Explain query SELECT tl_content.id, tl_module.type, tl_article.inColumn as `column` FROM tl_content, tl_module, tl_article WHERE tl_content.pid = tl_article.id AND tl_content.module = tl_module.id AND tl_content.type = ? AND tl_content.ptable = ? AND tl_article.pid = ? AND tl_article.inColumn IN (?, ?) AND tl_content.invisible = 0 AND ( tl_content.start = '' OR tl_content.start <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_article.published = 1 AND ( tl_article.start = '' OR tl_article.start <= 1772726880 ) AND ( tl_article.stop = '' OR tl_article.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.pid, tl_content.sorting SELECT tl_content.id, tl_module.type, tl_article.inColumn as `column` FROM tl_content, tl_module, tl_article WHERE tl_content.pid=tl_article.id AND tl_content.module=tl_module.id AND tl_content.type='module' AND tl_content.ptable='tl_article' AND tl_article.pid=4 AND tl_article.inColumn IN ('header', 'main') AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting;
14	0.25 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.`id` = ? LIMIT 0,1 Parameters: [`"29"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.`id` = ? LIMIT 0, 1 SELECT tl_content.* FROM tl_content WHERE tl_content.`id` = '29' LIMIT 0,1;
15	0.20 ms	SELECT * FROM `tl_files` WHERE uuid = ? Parameters: [`b"A8"IR\x0E\x11é´Ê˜ò³ìÝ‚"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid = 0x41382249520E11E9B4CA98F2B3ECDD82;
16	0.26 ms	SELECT * FROM tl_files WHERE tl_files.`path` = ? LIMIT 0,1 Parameters: [`"files/theme_2019/images/logos/logo_marbach.svg"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.`path` = 'files/theme_2019/images/logos/logo_marbach.svg' LIMIT 0,1;
17	0.32 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
18	0.26 ms	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<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) ORDER BY tl_article.sorting Parameters: [`4 "header"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_article.stop = '' OR tl_article.stop > 1772726880 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=4 AND tl_article.inColumn='header' AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) ORDER BY tl_article.sorting;
19	0.28 ms	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<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) ORDER BY tl_article.sorting Parameters: [`4 "main"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_article.stop = '' OR tl_article.stop > 1772726880 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=4 AND tl_article.inColumn='main' AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1772726880) AND (tl_article.stop='' OR tl_article.stop>1772726880) ORDER BY tl_article.sorting;
20	0.37 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`5 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=5 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
21	0.20 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"f6c1f9cd521111e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('f6c1f9cd521111e9b4ca98f2b3ecdd82') LIMIT 0,1;
22	0.22 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
23	0.33 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`16 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=16 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
24	0.23 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
25	0.37 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`17 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=17 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
26	0.29 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
27	0.24 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"dfe861f9145d11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('dfe861f9145d11eb928e525465c2d5d5') LIMIT 0,1;
28	0.29 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
29	0.23 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"a54c44d165a211e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a54c44d165a211e9b4ca98f2b3ecdd82') LIMIT 0,1;
30	0.25 ms	SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id` = ? LIMIT 0,1 Parameters: [`"7"`] View formatted query View runnable query Explain query SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id` = ? LIMIT 0, 1 SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id` = '7' LIMIT 0,1;
31	0.27 ms	SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible=0 AND tl_image_size_item.tstamp>0 ORDER BY sorting ASC Parameters: [`7`] View formatted query View runnable query Explain query SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid = ? AND tl_image_size_item.invisible = 0 AND tl_image_size_item.tstamp > 0 ORDER BY sorting ASC SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=7 AND tl_image_size_item.invisible=0 AND tl_image_size_item.tstamp>0 ORDER BY sorting ASC;
32	0.29 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
33	0.45 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`18 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=18 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
34	0.28 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
35	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"ef343e3b65a411e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('ef343e3b65a411e9b4ca98f2b3ecdd82') LIMIT 0,1;
36	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"a8035854addd11e9af2298f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a8035854addd11e9af2298f2b3ecdd82') LIMIT 0,1;
37	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
38	0.21 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"e3b07f42145e11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('e3b07f42145e11eb928e525465c2d5d5') LIMIT 0,1;
39	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"7eef4cd9145e11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('7eef4cd9145e11eb928e525465c2d5d5') LIMIT 0,1;
40	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
41	0.42 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`19 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=19 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
42	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
43	0.21 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"a59bcc1e65a211e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a59bcc1e65a211e9b4ca98f2b3ecdd82') LIMIT 0,1;
44	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"a05d8b39addd11e9af2298f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a05d8b39addd11e9af2298f2b3ecdd82') LIMIT 0,1;
45	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
46	0.42 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`20 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=20 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
47	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
48	0.21 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"5dc8a096145f11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('5dc8a096145f11eb928e525465c2d5d5') LIMIT 0,1;
49	0.23 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"7cde0967145e11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('7cde0967145e11eb928e525465c2d5d5') LIMIT 0,1;
50	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
51	0.21 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"5fabe5d8145f11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('5fabe5d8145f11eb928e525465c2d5d5') LIMIT 0,1;
52	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"7b6ad63c145e11eb928e525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('7b6ad63c145e11eb928e525465c2d5d5') LIMIT 0,1;
53	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
54	0.38 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`27 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=27 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
55	0.23 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1 Parameters: [`"21"`] View formatted query View runnable query Explain query SELECT tl_article.* FROM tl_article WHERE tl_article.id = ? LIMIT 0, 1 SELECT tl_article.* FROM tl_article WHERE tl_article.id='21' LIMIT 0,1;
56	0.40 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`21 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=21 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
57	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
58	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
59	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"b442a555e40611ed9770525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('b442a555e40611ed9770525465c2d5d5') LIMIT 0,1;
60	0.26 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
61	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
62	0.38 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`26 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=26 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
63	0.21 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1 Parameters: [`"23"`] View formatted query View runnable query Explain query SELECT tl_article.* FROM tl_article WHERE tl_article.id = ? LIMIT 0, 1 SELECT tl_article.* FROM tl_article WHERE tl_article.id='23' LIMIT 0,1;
64	0.39 ms	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<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`23 "tl_article"`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( tl_content.stop = '' OR tl_content.stop > 1772726880 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=23 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1772726880) AND (tl_content.stop='' OR tl_content.stop>1772726880) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
65	0.28 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
66	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
67	0.25 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? LIMIT 0,1 Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.id = '8' LIMIT 0,1;
68	0.21 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0,1 Parameters: [`7`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = 7 LIMIT 0,1;
69	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
70	0.25 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
71	0.26 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0,1 Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0, 1 SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = '4' LIMIT 0,1;
72	0.40 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,8,10,11,12) 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<=1772726880) AND (tl_page.stop='' OR tl_page.stop>1772726880) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9, 8, 10, 11, 12) 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 <= 1772726880 ) AND ( tl_page.stop = '' OR tl_page.stop > 1772726880 ) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,8,10,11,12) 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<=1772726880) AND (tl_page.stop='' OR tl_page.stop>1772726880) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12');
73	0.26 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0,1 Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0, 1 SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = '1' LIMIT 0,1;
74	0.45 ms	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<=1772726880) AND (p2.stop='' OR p2.stop>1772726880)) 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<=1772726880) AND (p1.stop='' OR p1.stop>1772726880) ORDER BY p1.sorting Parameters: [`1`] View formatted query View runnable query Explain query 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 <= 1772726880 ) AND ( p2.stop = '' OR p2.stop > 1772726880 ) ) 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 <= 1772726880 ) AND ( p1.stop = '' OR p1.stop > 1772726880 ) 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<=1772726880) AND (p2.stop='' OR p2.stop>1772726880)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=1 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<=1772726880) AND (p1.stop='' OR p1.stop>1772726880) ORDER BY p1.sorting;
75	0.32 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(13,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,13,5,6') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(13, 5, 6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,13,5,6') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(13,5,6) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,13,5,6');
76	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"c5142aac763111ed9770525465c2d5d5"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('c5142aac763111ed9770525465c2d5d5') LIMIT 0,1;
77	0.23 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"3da50a5751fa11e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('3da50a5751fa11e9b4ca98f2b3ecdd82') LIMIT 0,1;
78	0.21 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"cc50768456dd11e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('cc50768456dd11e9b4ca98f2b3ecdd82') LIMIT 0,1;
79	0.21 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"3cd40e5951fa11e9b4ca98f2b3ecdd82"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('3cd40e5951fa11e9b4ca98f2b3ecdd82') LIMIT 0,1;
80	0.27 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.`pid` = ? ORDER BY tl_article.sorting Parameters: [`4`] View formatted query View runnable query Explain query 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` = 4 ORDER BY tl_article.sorting;
81	0.37 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,8,10,11,12) 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<=1772726880) AND (tl_page.stop='' OR tl_page.stop>1772726880) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9, 8, 10, 11, 12) 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 <= 1772726880 ) AND ( tl_page.stop = '' OR tl_page.stop > 1772726880 ) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,8,10,11,12) 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<=1772726880) AND (tl_page.stop='' OR tl_page.stop>1772726880) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,8,10,11,12');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

Class	Mapping errors
Contao\CoreBundle\Entity\TrustedDevice	No errors.
Contao\CoreBundle\Entity\WebauthnCredential	No errors.
Contao\CoreBundle\Entity\CronJob	No errors.
Contao\CoreBundle\Entity\Altcha	No errors.
Contao\CoreBundle\Entity\CrawlQueue	No errors.
Webauthn\PublicKeyCredentialEntity	No errors.
Webauthn\PublicKeyCredentialUserEntity	No errors.
Webauthn\PublicKeyCredentialSource	No errors.

Symfony Profiler

GET https://marbach-2019.preview.schittigs.dev/lighting.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping