Symfony Profiler

Query Metrics

57 Database Queries

35 Different statements

42.41 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT t0_.id AS id_0, t0_.tstamp AS tstamp_1, t0_.alias AS alias_2, t0_.name AS name_3, t0_.target AS target_4, t0_.published AS published_5, t0_.dateAdded AS dateAdded_6 FROM tl_terminal42_shortlink t0_ WHERE (LOWER(t0_.alias) = ? OR (t0_.alias = '' AND t0_.id = ?)) AND t0_.published = '1'
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,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION
SELECT TABLE_NAME,        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? ORDER BY SEQ_IN_INDEX
SELECT DISTINCT k.TABLE_NAME,            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' */ ORDER BY 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 DATABASE()
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit
   FROM	tl_page AS p
   JOIN	tl_page AS rt ON rt.id = p.hofff_root_page_id
  WHERE	p.id = ?
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
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(1,0,1,0,1,0,1,0,0,1,0,1,0) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,1,0,1,0,1,0,0,1,0,1,0')
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<=1786889580) AND (tl_content.stop='' OR tl_content.stop>1786889580) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1786889580) AND (tl_article.stop='' OR tl_article.stop>1786889580) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting
SELECT * FROM tl_hofff_content WHERE pid=? AND ptable=? ORDER BY sorting
(SELECT
    ? AS hofff_content_index,
    article.*
FROM
    tl_article
    AS article
WHERE
    article.pid = ?
AND article.inColumn = ?
) ORDER BY hofff_content_index, 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<=1786889580) AND (tl_content.stop='' OR tl_content.stop>1786889580) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM `tl_files` WHERE uuid=?
SELECT * FROM tl_files WHERE tl_files.`path`=? 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_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<=1786889640) AND (tl_content.stop='' OR tl_content.stop>1786889640) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT DATABASE()
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_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' */ ORDER BY k.ORDINAL_POSITION
SELECT       c.COLUMN_NAME        AS field,
           IF(
        c.COLUMN_TYPE = 'longtext'
        AND EXISTS(
            SELECT * from information_schema.CHECK_CONSTRAINTS i_c
            WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de'
            AND i_c.TABLE_NAME = c.TABLE_NAME
            AND i_c.CHECK_CLAUSE = CONCAT(
                'json_valid(`',
                    c.COLUMN_NAME,
                '`)'
            )
        ),
        'json',
        c.COLUMN_TYPE
    )       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
SELECT DATABASE()
SELECT        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 = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
SELECT `id`, `pid`, `protected`, `groups` FROM tl_page WHERE id IN (?)
SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND (pid IN (?)) AND (hide != 1) AND ((start = '' OR start < ?) AND (stop = '' OR stop > ?) AND published = 1) AND (type NOT IN (?, ?, ?)) ORDER BY sorting ASC
SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND (pid IN (?, ?, ?, ?, ?, ?)) AND (hide != 1) AND ((start = '' OR start < ?) AND (stop = '' OR stop > ?) AND published = 1) AND (type NOT IN (?, ?, ?)) ORDER BY sorting ASC
SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND (pid IN (?, ?, ?, ?)) AND (hide != 1) AND ((start = '' OR start < ?) AND (stop = '' OR stop > ?) AND published = 1) AND (type NOT IN (?, ?, ?)) ORDER BY sorting ASC
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT * FROM tl_page WHERE (type=?) AND (pid=?) ORDER BY sorting ASC LIMIT 1
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	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT	p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot
   FROM	tl_page AS p1
   JOIN	tl_page AS p2 ON p2.id = p1.pid
  WHERE	p1.id = ?
    AND p2.type != 'root'
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<=1786889640) AND (tl_article.stop='' OR tl_article.stop>1786889640) ORDER BY tl_article.sorting
SELECT * FROM tl_hofff_content WHERE pid=? AND ptable=? ORDER BY sorting
(SELECT
    ? AS hofff_content_index,
    article.*
FROM
    tl_article
    AS article
WHERE
    article.pid = ?
AND article.inColumn = ?
) ORDER BY hofff_content_index, sorting

#▲	Time	Info
1	0.41 ms	SELECT t0_.id AS id_0, t0_.tstamp AS tstamp_1, t0_.alias AS alias_2, t0_.name AS name_3, t0_.target AS target_4, t0_.published AS published_5, t0_.dateAdded AS dateAdded_6 FROM tl_terminal42_shortlink t0_ WHERE (LOWER(t0_.alias) = ? OR (t0_.alias = '' AND t0_.id = ?)) AND t0_.published = '1' Parameters: [`"leistungen/krankheits-lexikon.html" 0`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.tstamp AS tstamp_1, t0_.alias AS alias_2, t0_.name AS name_3, t0_.target AS target_4, t0_.published AS published_5, t0_.dateAdded AS dateAdded_6 FROM tl_terminal42_shortlink t0_ WHERE ( LOWER(t0_.alias) = ? OR ( t0_.alias = '' AND t0_.id = ? ) ) AND t0_.published = '1' SELECT t0_.id AS id_0, t0_.tstamp AS tstamp_1, t0_.alias AS alias_2, t0_.name AS name_3, t0_.target AS target_4, t0_.published AS published_5, t0_.dateAdded AS dateAdded_6 FROM tl_terminal42_shortlink t0_ WHERE (LOWER(t0_.alias) = 'leistungen/krankheits-lexikon.html' OR (t0_.alias = '' AND t0_.id = 0)) AND t0_.published = '1';
2	0.48 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';
3	0.59 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?) Parameters: [`"leistungen/krankheits-lexikon" "leistungen"`] 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 ('leistungen/krankheits-lexikon','leistungen');
4	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
5	20.03 ms	SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION Parameters: [`"db_physbabe_de" "db_physbabe_de"`] View formatted query View runnable query Explain query SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION SELECT c.TABLE_NAME, c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'db_physbabe_de' AND t.TABLE_SCHEMA = 'db_physbabe_de' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;
6	0.98 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 SEQ_IN_INDEX Parameters: [`"db_physbabe_de"`] 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 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 = 'db_physbabe_de' ORDER BY SEQ_IN_INDEX;
7	0.66 ms	SELECT DISTINCT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' / ORDER BY k.ORDINAL_POSITION Parameters: [`"db_physbabe_de"`] View formatted query View runnable query Explain query SELECT DISTINCT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.TABLE_NAME, k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'db_physbabe_de' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' / ORDER BY k.ORDINAL_POSITION;
8	2.74 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: [`"db_physbabe_de"`] 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 = 'db_physbabe_de' AND t.TABLE_TYPE = 'BASE TABLE';
9	0.30 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
10	0.51 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;
11	0.30 ms	SELECT rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit FROM tl_page AS p JOIN tl_page AS rt ON rt.id = p.hofff_root_page_id WHERE p.id = ? Parameters: [`24`] View formatted query View runnable query Explain query SELECT rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit FROM tl_page AS p JOIN tl_page AS rt ON rt.id = p.hofff_root_page_id WHERE p.id = ? SELECT rt.id, rt.type, rt.alias, rt.bbit_turl_rootInherit FROM tl_page AS p JOIN tl_page AS rt ON rt.id = p.hofff_root_page_id WHERE p.id = 24;
12	0.26 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`24`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 24 AND p2.type != 'root';
13	0.28 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`27`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 27 AND p2.type != 'root';
14	0.30 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 != '';
15	0.46 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;
16	0.34 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;
17	0.41 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(1,0,1,0,1,0,1,0,0,1,0,1,0) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,1,0,1,0,1,0,0,1,0,1,0') Parameters: [] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(1, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 1, 0) ORDER BY FIND_IN_SET( `tl_module`.`id`, '1,0,1,0,1,0,1,0,0,1,0,1,0' ) SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(1,0,1,0,1,0,1,0,0,1,0,1,0) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,1,0,1,0,1,0,0,1,0,1,0');
18	0.46 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<=1786889580) AND (tl_content.stop='' OR tl_content.stop>1786889580) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1786889580) AND (tl_article.stop='' OR tl_article.stop>1786889580) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting Parameters: [`"module" "tl_article" 27 "header" "mainteaser" "left" "right" "main" "subfooter" "footer"`] 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 <= 1786889580 ) AND ( tl_content.stop = '' OR tl_content.stop > 1786889580 ) AND tl_article.published = 1 AND ( tl_article.start = '' OR tl_article.start <= 1786889580 ) AND ( tl_article.stop = '' OR tl_article.stop > 1786889580 ) 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=27 AND tl_article.inColumn IN ('header', 'mainteaser', 'left', 'right', 'main', 'subfooter', 'footer') AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1786889580) AND (tl_content.stop='' OR tl_content.stop>1786889580) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1786889580) AND (tl_article.stop='' OR tl_article.stop>1786889580) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting;
19	0.23 ms	SELECT * FROM tl_hofff_content WHERE pid=? AND ptable=? ORDER BY sorting Parameters: [`1 "tl_module"`] View formatted query View runnable query Explain query SELECT * FROM tl_hofff_content WHERE pid = ? AND ptable = ? ORDER BY sorting SELECT * FROM tl_hofff_content WHERE pid=1 AND ptable='tl_module' ORDER BY sorting;
20	0.26 ms	(SELECT ? AS hofff_content_index, article.* FROM tl_article AS article WHERE article.pid = ? AND article.inColumn = ? ) ORDER BY hofff_content_index, sorting Parameters: [`0 15 "header"`] View formatted query View runnable query Explain query ( SELECT ? AS hofff_content_index, article.* FROM tl_article AS article WHERE article.pid = ? AND article.inColumn = ? ) ORDER BY hofff_content_index, sorting (SELECT 0 AS hofff_content_index, article.* FROM tl_article AS article WHERE article.pid = 15 AND article.inColumn = 'header' ) ORDER BY hofff_content_index, sorting;
21	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<=1786889580) AND (tl_content.stop='' OR tl_content.stop>1786889580) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`14 "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 <= 1786889580 ) AND ( tl_content.stop = '' OR tl_content.stop > 1786889580 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=14 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1786889580) AND (tl_content.stop='' OR tl_content.stop>1786889580) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
22	0.24 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"àx\x15Œ“\x7F\x11é¾Q\x00PVœÁÂ"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0xE078158C937F11E9BE510050569CC1C2;
23	0.25 ms	SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/userdata/physiotherapie-babelsberg.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/userdata/physiotherapie-babelsberg.svg' LIMIT 0,1;
24	0.25 ms	SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1 Parameters: [`"15"`] 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`='15' LIMIT 0,1;
25	0.22 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: [`15`] 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=15 AND tl_image_size_item.invisible=0 AND tl_image_size_item.tstamp>0 ORDER BY sorting ASC;
26	0.53 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<=1786889640) AND (tl_content.stop='' OR tl_content.stop>1786889640) 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 <= 1786889640 ) AND ( tl_content.stop = '' OR tl_content.stop > 1786889640 ) 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<=1786889640) AND (tl_content.stop='' OR tl_content.stop>1786889640) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
27	0.31 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`2`] 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`=2 LIMIT 0,1;
28	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
29	0.44 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_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"db_physbabe_de" "tl_page"`] 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_NAME = ? 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 = 'db_physbabe_de' AND t.TABLE_NAME = 'tl_page' AND t.TABLE_TYPE = 'BASE TABLE';
30	0.10 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
31	0.60 ms	SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' / ORDER BY k.ORDINAL_POSITION Parameters: [`"db_physbabe_de" "tl_page"`] View formatted query View runnable query Explain query SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' / ORDER BY k.ORDINAL_POSITION SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /!50116, c.UPDATE_RULE, c.DELETE_RULE / FROM information_schema.key_column_usage k /!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME / WHERE k.TABLE_SCHEMA = 'db_physbabe_de' AND k.TABLE_NAME = 'tl_page' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'db_physbabe_de' / ORDER BY k.ORDINAL_POSITION;
32	2.62 ms	SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION Parameters: [`"db_physbabe_de" "db_physbabe_de" "tl_page"`] View formatted query View runnable query Explain query SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION SELECT c.COLUMN_NAME AS field, IF( c.COLUMN_TYPE = 'longtext' AND EXISTS( SELECT * from information_schema.CHECK_CONSTRAINTS i_c WHERE i_c.CONSTRAINT_SCHEMA = 'db_physbabe_de' AND i_c.TABLE_NAME = c.TABLE_NAME AND i_c.CHECK_CLAUSE = CONCAT( 'json_valid(`', c.COLUMN_NAME, '`)' ) ), 'json', c.COLUMN_TYPE ) AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = 'db_physbabe_de' AND t.TABLE_SCHEMA = 'db_physbabe_de' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'tl_page' ORDER BY ORDINAL_POSITION;
33	0.22 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
34	0.22 ms	SELECT 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 = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX Parameters: [`"db_physbabe_de" "tl_page"`] View formatted query View runnable query Explain query SELECT 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 = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX SELECT 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 = 'db_physbabe_de' AND TABLE_NAME = 'tl_page' ORDER BY SEQ_IN_INDEX;
35	0.23 ms	SELECT `id`, `pid`, `protected`, `groups` FROM tl_page WHERE id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT `id`, `pid`, `protected`, `groups` FROM tl_page WHERE id IN (?) SELECT `id`, `pid`, `protected`, `groups` FROM tl_page WHERE id IN (1);
36	0.41 ms	SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND (pid IN (?)) AND (hide != 1) AND ((start = '' OR start < ?) AND (stop = '' OR stop > ?) AND published = 1) AND (type NOT IN (?, ?, ?)) ORDER BY sorting ASC Parameters: [`"root" 1 1786889640 1786889640 "error_401" "error_403" "error_404"`] View formatted query View runnable query Explain query SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND ( pid IN (?) ) AND (hide != 1) AND ( ( start = '' OR start < ? ) AND ( stop = '' OR stop > ? ) AND published = 1 ) AND ( type NOT IN (?, ?, ?) ) ORDER BY sorting ASC SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != 'root') AND (pid IN (1)) AND (hide != 1) AND ((start = '' OR start < 1786889640) AND (stop = '' OR stop > 1786889640) AND published = 1) AND (type NOT IN ('error_401', 'error_403', 'error_404')) ORDER BY sorting ASC;
37	0.40 ms	SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND (pid IN (?, ?, ?, ?, ?, ?)) AND (hide != 1) AND ((start = '' OR start < ?) AND (stop = '' OR stop > ?) AND published = 1) AND (type NOT IN (?, ?, ?)) ORDER BY sorting ASC Parameters: [`"root" 2 3 28 4 24 6 1786889640 1786889640 "error_401" "error_403" "error_404"`] View formatted query View runnable query Explain query SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND ( pid IN (?, ?, ?, ?, ?, ?) ) AND (hide != 1) AND ( ( start = '' OR start < ? ) AND ( stop = '' OR stop > ? ) AND published = 1 ) AND ( type NOT IN (?, ?, ?) ) ORDER BY sorting ASC SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != 'root') AND (pid IN (2, 3, 28, 4, 24, 6)) AND (hide != 1) AND ((start = '' OR start < 1786889640) AND (stop = '' OR stop > 1786889640) AND published = 1) AND (type NOT IN ('error_401', 'error_403', 'error_404')) ORDER BY sorting ASC;
38	0.33 ms	SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND (pid IN (?, ?, ?, ?)) AND (hide != 1) AND ((start = '' OR start < ?) AND (stop = '' OR stop > ?) AND published = 1) AND (type NOT IN (?, ?, ?)) ORDER BY sorting ASC Parameters: [`"root" 9 45 10 27 1786889640 1786889640 "error_401" "error_403" "error_404"`] View formatted query View runnable query Explain query SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != ?) AND ( pid IN (?, ?, ?, ?) ) AND (hide != 1) AND ( ( start = '' OR start < ? ) AND ( stop = '' OR stop > ? ) AND published = 1 ) AND ( type NOT IN (?, ?, ?) ) ORDER BY sorting ASC SELECT `id`, `pid`, `sorting`, `tstamp`, `type`, `alias`, `title`, `protected`, `groups`, `jumpTo`, `pageTitle`, `target`, `description`, `url`, `robots`, `cssClass`, `accesskey` FROM tl_page WHERE (type != 'root') AND (pid IN (9, 45, 10, 27)) AND (hide != 1) AND ((start = '' OR start < 1786889640) AND (stop = '' OR stop > 1786889640) AND published = 1) AND (type NOT IN ('error_401', 'error_403', 'error_404')) ORDER BY sorting ASC;
39	0.27 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`2`] 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`=2 LIMIT 0,1;
40	0.22 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`2`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 2 AND p2.type != 'root';
41	0.25 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`3`] 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`=3 LIMIT 0,1;
42	0.19 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`3`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 3 AND p2.type != 'root';
43	0.24 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`28`] 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`=28 LIMIT 0,1;
44	0.23 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`28`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 28 AND p2.type != 'root';
45	0.33 ms	SELECT * FROM tl_page WHERE (type=?) AND (pid=?) ORDER BY sorting ASC LIMIT 1 Parameters: [`"regular" 4`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE (type = ?) AND (pid = ?) ORDER BY sorting ASC LIMIT 1 SELECT * FROM tl_page WHERE (type='regular') AND (pid=4) ORDER BY sorting ASC LIMIT 1;
46	0.23 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`9`] 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`=9 LIMIT 0,1;
47	0.22 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`4`] 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`=4 LIMIT 0,1;
48	0.20 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`9`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 9 AND p2.type != 'root';
49	0.23 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`6`] 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`=6 LIMIT 0,1;
50	0.19 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`6`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 6 AND p2.type != 'root';
51	0.24 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`45`] 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`=45 LIMIT 0,1;
52	0.20 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`45`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 45 AND p2.type != 'root';
53	0.23 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`10`] 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`=10 LIMIT 0,1;
54	0.19 ms	SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' Parameters: [`10`] View formatted query View runnable query Explain query SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = ? AND p2.type != 'root' SELECT p2.id, p2.alias, p2.bbit_turl_transparent, p2.bbit_turl_ignoreRoot FROM tl_page AS p1 JOIN tl_page AS p2 ON p2.id = p1.pid WHERE p1.id = 10 AND p2.type != 'root';
55	0.30 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<=1786889640) AND (tl_article.stop='' OR tl_article.stop>1786889640) ORDER BY tl_article.sorting Parameters: [`27 "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 <= 1786889640 ) AND ( tl_article.stop = '' OR tl_article.stop > 1786889640 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=27 AND tl_article.inColumn='header' AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1786889640) AND (tl_article.stop='' OR tl_article.stop>1786889640) ORDER BY tl_article.sorting;
56	0.24 ms	SELECT * FROM tl_hofff_content WHERE pid=? AND ptable=? ORDER BY sorting Parameters: [`1 "tl_module"`] View formatted query View runnable query Explain query SELECT * FROM tl_hofff_content WHERE pid = ? AND ptable = ? ORDER BY sorting SELECT * FROM tl_hofff_content WHERE pid=1 AND ptable='tl_module' ORDER BY sorting;
57	0.26 ms	(SELECT ? AS hofff_content_index, article.* FROM tl_article AS article WHERE article.pid = ? AND article.inColumn = ? ) ORDER BY hofff_content_index, sorting Parameters: [`0 15 "mainteaser"`] View formatted query View runnable query Explain query ( SELECT ? AS hofff_content_index, article.* FROM tl_article AS article WHERE article.pid = ? AND article.inColumn = ? ) ORDER BY hofff_content_index, sorting (SELECT 0 AS hofff_content_index, article.* FROM tl_article AS article WHERE article.pid = 15 AND article.inColumn = 'mainteaser' ) ORDER BY hofff_content_index, sorting;

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
Terminal42\ShortlinkBundle\Entity\Shortlink	No errors.
Terminal42\ShortlinkBundle\Entity\ShortlinkLog	No errors.

Symfony Profiler

GET https://staging.physiotherapiebabelsberg.de/leistungen/krankheits-lexikon.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping