Symfony Profiler

Query Metrics

23 Database Queries

18 Different statements

36.62 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT * FROM tl_user WHERE `username`=? LIMIT 0,1
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 = 'vq8p3p_app_contao'
            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 = 'vq8p3p_app_contao' */ 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT templates FROM tl_theme WHERE templates != ''
SELECT * FROM tl_content WHERE id IN (?)
SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=?
SELECT id, type FROM tl_page WHERE id=(SELECT pid FROM tl_article WHERE id=?)
SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=?
SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=?
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
SELECT type FROM tl_content WHERE id=?
SELECT cteAlias, TRUE FROM tl_content WHERE type='alias' GROUP BY cteAlias
SELECT DATABASE()
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
SELECT * FROM tl_content WHERE id=?
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('053c2876a9ec11f085298c8474ef5a1c')) ORDER BY tl_files.uuid!=UNHEX('053c2876a9ec11f085298c8474ef5a1c')
UPDATE tl_user SET session = ? WHERE id = ?

#▲	Time	Info
1	0.58 ms	SELECT * FROM tl_user WHERE `username`=? LIMIT 0,1 Parameters: [`"admin"`] View formatted query View runnable query Explain query SELECT * FROM tl_user WHERE `username` = ? LIMIT 0, 1 SELECT * FROM tl_user WHERE `username`='admin' LIMIT 0,1;
2	0.19 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	16.85 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 = 'vq8p3p_app_contao' 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: [`"vq8p3p_app_contao" "vq8p3p_app_contao"`] 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 = 'vq8p3p_app_contao' 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 = 'vq8p3p_app_contao' 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 = 'vq8p3p_app_contao' AND t.TABLE_SCHEMA = 'vq8p3p_app_contao' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;
4	1.21 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: [`"vq8p3p_app_contao"`] 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 = 'vq8p3p_app_contao' ORDER BY SEQ_IN_INDEX;
5	0.86 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 = 'vq8p3p_app_contao' / ORDER BY k.ORDINAL_POSITION Parameters: [`"vq8p3p_app_contao"`] 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 = 'vq8p3p_app_contao' / 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 = 'vq8p3p_app_contao' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'vq8p3p_app_contao' / ORDER BY k.ORDINAL_POSITION;
6	10.72 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"vq8p3p_app_contao"`] 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.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.FULL_COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'vq8p3p_app_contao' AND t.TABLE_TYPE = 'BASE TABLE';
7	0.17 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
8	0.29 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 != '';
9	0.46 ms	SELECT * FROM tl_content WHERE id IN (?) Parameters: [`"10"`] View formatted query View runnable query Explain query SELECT * FROM tl_content WHERE id IN (?) SELECT * FROM tl_content WHERE id IN ('10');
10	0.78 ms	SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? Parameters: [`8 "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content"`] View formatted query View runnable query Explain query SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=8 UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content';
11	0.25 ms	SELECT id, type FROM tl_page WHERE id=(SELECT pid FROM tl_article WHERE id=?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT id, type FROM tl_page WHERE id =( SELECT pid FROM tl_article WHERE id = ? ) SELECT id, type FROM tl_page WHERE id=(SELECT pid FROM tl_article WHERE id=1);
12	0.67 ms	SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? Parameters: [`8 "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content"`] View formatted query View runnable query Explain query SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=8 UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content';
13	0.64 ms	SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? Parameters: [`8 "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content" "tl_content"`] View formatted query View runnable query Explain query SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? UNION SELECT id, @pid := pid AS pid, ptable FROM tl_content WHERE id = @pid AND ptable = ? SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=8 UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content' UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable='tl_content';
14	0.34 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1 Parameters: [`"10"`] 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`='10' LIMIT 0,1;
15	0.17 ms	SELECT type FROM tl_content WHERE id=? Parameters: [`8`] View formatted query View runnable query Explain query SELECT type FROM tl_content WHERE id = ? SELECT type FROM tl_content WHERE id=8;
16	0.31 ms	SELECT cteAlias, TRUE FROM tl_content WHERE type='alias' GROUP BY cteAlias Parameters: [] View formatted query View runnable query Explain query SELECT cteAlias, TRUE FROM tl_content WHERE type = 'alias' GROUP BY cteAlias SELECT cteAlias, TRUE FROM tl_content WHERE type='alias' GROUP BY cteAlias;
17	0.14 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	0.09 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
19	0.71 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"vq8p3p_app_contao"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'vq8p3p_app_contao' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
20	0.33 ms	SELECT * FROM tl_content WHERE id=? Parameters: [`"10"`] View formatted query View runnable query Explain query SELECT * FROM tl_content WHERE id = ? SELECT * FROM tl_content WHERE id='10';
21	0.27 ms	SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/code/hero2.JPG"`] 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/code/hero2.JPG' LIMIT 0,1;
22	0.24 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('053c2876a9ec11f085298c8474ef5a1c')) ORDER BY tl_files.uuid!=UNHEX('053c2876a9ec11f085298c8474ef5a1c') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '053c2876a9ec11f085298c8474ef5a1c' ) ) ORDER BY tl_files.uuid != UNHEX( '053c2876a9ec11f085298c8474ef5a1c' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('053c2876a9ec11f085298c8474ef5a1c')) ORDER BY tl_files.uuid!=UNHEX('053c2876a9ec11f085298c8474ef5a1c');
23	0.34 ms	UPDATE tl_user SET session = ? WHERE id = ? Parameters: ["a:7:{s:15:"fieldset_states";a:5:{s:7:"tl_user";a:3:{s:14:"backend_legend";i:1;s:12:"theme_legend";i:1;s:15:"password_legend";i:1;}s:9:"tl_layout";a:2:{s:13:"static_legend";i:1;s:13:"expert_legend";i:1;}s:10:"tl_content";a:4:{s:13:"expert_legend";i:1;s:16:"protected_legend";i:1;s:15:"template_legend";i:1;s:16:"invisible_legend";i:1;}s:13:"tl_user_group";a:1:{s:12:"alexf_legend";i:1;}s:9:"tl_module";a:2:{s:13:"expert_legend";i:0;s:15:"template_legend";i:1;}}s:11:"new_records";a:1:{s:10:"tl_content";a:1:{i:0;s:2:"10";}}s:12:"tl_page_tree";a:2:{i:1;i:1;i:2;i:0;}s:12:"tl_page_node";s:1:"2";s:23:"tl_article_tl_page_tree";a:5:{i:2;i:0;i:1;i:1;i:3;i:0;i:4;i:0;i:5;i:0;}s:8:"filetree";a:8:{s:8:"13c901bc";i:1;s:8:"c07d040f";i:1;s:8:"1217e95d";i:1;s:8:"003af690";i:1;s:8:"04f3e71f";i:1;s:8:"2e8de4e7";i:1;s:8:"323b7277";i:1;s:8:"875f3d1c";i:1;}s:15:"checkbox_groups";a:43:{s:25:"cbc_modules_présentation";i:1;s:19:"cbc_modules_comptes";i:1;s:20:"cbc_modules_système";i:1;s:31:"cbc_frontendModules_utilisateur";i:1;s:32:"cbc_frontendModules_applications";i:1;s:26:"cbc_frontendModules_divers";i:1;s:23:"cbc_frontendModules_faq";i:1;s:24:"cbc_frontendModules_news";i:1;s:43:"cbc_frontendModules_calendrier-événements";i:1;s:30:"cbc_frontendModules_newsletter";i:1;s:28:"cbc_elements_legacy-elements";i:1;s:30:"cbc_elements_éléments-inclus";i:1;s:19:"cbc_elements_divers";i:1;s:36:"cbc_elements_éléments-multimédias";i:1;s:28:"cbc_elements_éléments-lien";i:1;s:31:"cbc_elements_éléments-fichier";i:1;s:23:"cbc_alexf_tl_user_group";i:0;s:17:"cbc_alexf_tl_user";i:0;s:18:"cbc_alexf_tl_theme";i:0;s:25:"cbc_alexf_tl_preview_link";i:0;s:17:"cbc_alexf_tl_page";i:0;s:34:"cbc_alexf_tl_newsletter_recipients";i:0;s:31:"cbc_alexf_tl_newsletter_channel";i:0;s:23:"cbc_alexf_tl_newsletter";i:0;s:25:"cbc_alexf_tl_news_archive";i:0;s:17:"cbc_alexf_tl_news";i:0;s:19:"cbc_alexf_tl_module";i:0;s:25:"cbc_alexf_tl_member_group";i:0;s:19:"cbc_alexf_tl_member";i:0;s:19:"cbc_alexf_tl_layout";i:0;s:28:"cbc_alexf_tl_image_size_item";i:0;s:23:"cbc_alexf_tl_image_size";i:0;s:23:"cbc_alexf_tl_form_field";i:0;s:17:"cbc_alexf_tl_form";i:0;s:18:"cbc_alexf_tl_files";i:0;s:25:"cbc_alexf_tl_faq_category";i:0;s:16:"cbc_alexf_tl_faq";i:0;s:20:"cbc_alexf_tl_content";i:0;s:21:"cbc_alexf_tl_comments";i:0;s:26:"cbc_alexf_tl_calendar_feed";i:0;s:28:"cbc_alexf_tl_calendar_events";i:0;s:21:"cbc_alexf_tl_calendar";i:0;s:20:"cbc_alexf_tl_article";i:0;}}" 1] View formatted query View runnable query Explain query UPDATE tl_user SET session = ? WHERE id = ? UPDATE tl_user SET session = 'a:7:{s:15:\"fieldset_states\";a:5:{s:7:\"tl_user\";a:3:{s:14:\"backend_legend\";i:1;s:12:\"theme_legend\";i:1;s:15:\"password_legend\";i:1;}s:9:\"tl_layout\";a:2:{s:13:\"static_legend\";i:1;s:13:\"expert_legend\";i:1;}s:10:\"tl_content\";a:4:{s:13:\"expert_legend\";i:1;s:16:\"protected_legend\";i:1;s:15:\"template_legend\";i:1;s:16:\"invisible_legend\";i:1;}s:13:\"tl_user_group\";a:1:{s:12:\"alexf_legend\";i:1;}s:9:\"tl_module\";a:2:{s:13:\"expert_legend\";i:0;s:15:\"template_legend\";i:1;}}s:11:\"new_records\";a:1:{s:10:\"tl_content\";a:1:{i:0;s:2:\"10\";}}s:12:\"tl_page_tree\";a:2:{i:1;i:1;i:2;i:0;}s:12:\"tl_page_node\";s:1:\"2\";s:23:\"tl_article_tl_page_tree\";a:5:{i:2;i:0;i:1;i:1;i:3;i:0;i:4;i:0;i:5;i:0;}s:8:\"filetree\";a:8:{s:8:\"13c901bc\";i:1;s:8:\"c07d040f\";i:1;s:8:\"1217e95d\";i:1;s:8:\"003af690\";i:1;s:8:\"04f3e71f\";i:1;s:8:\"2e8de4e7\";i:1;s:8:\"323b7277\";i:1;s:8:\"875f3d1c\";i:1;}s:15:\"checkbox_groups\";a:43:{s:25:\"cbc_modules_présentation\";i:1;s:19:\"cbc_modules_comptes\";i:1;s:20:\"cbc_modules_système\";i:1;s:31:\"cbc_frontendModules_utilisateur\";i:1;s:32:\"cbc_frontendModules_applications\";i:1;s:26:\"cbc_frontendModules_divers\";i:1;s:23:\"cbc_frontendModules_faq\";i:1;s:24:\"cbc_frontendModules_news\";i:1;s:43:\"cbc_frontendModules_calendrier-événements\";i:1;s:30:\"cbc_frontendModules_newsletter\";i:1;s:28:\"cbc_elements_legacy-elements\";i:1;s:30:\"cbc_elements_éléments-inclus\";i:1;s:19:\"cbc_elements_divers\";i:1;s:36:\"cbc_elements_éléments-multimédias\";i:1;s:28:\"cbc_elements_éléments-lien\";i:1;s:31:\"cbc_elements_éléments-fichier\";i:1;s:23:\"cbc_alexf_tl_user_group\";i:0;s:17:\"cbc_alexf_tl_user\";i:0;s:18:\"cbc_alexf_tl_theme\";i:0;s:25:\"cbc_alexf_tl_preview_link\";i:0;s:17:\"cbc_alexf_tl_page\";i:0;s:34:\"cbc_alexf_tl_newsletter_recipients\";i:0;s:31:\"cbc_alexf_tl_newsletter_channel\";i:0;s:23:\"cbc_alexf_tl_newsletter\";i:0;s:25:\"cbc_alexf_tl_news_archive\";i:0;s:17:\"cbc_alexf_tl_news\";i:0;s:19:\"cbc_alexf_tl_module\";i:0;s:25:\"cbc_alexf_tl_member_group\";i:0;s:19:\"cbc_alexf_tl_member\";i:0;s:19:\"cbc_alexf_tl_layout\";i:0;s:28:\"cbc_alexf_tl_image_size_item\";i:0;s:23:\"cbc_alexf_tl_image_size\";i:0;s:23:\"cbc_alexf_tl_form_field\";i:0;s:17:\"cbc_alexf_tl_form\";i:0;s:18:\"cbc_alexf_tl_files\";i:0;s:25:\"cbc_alexf_tl_faq_category\";i:0;s:16:\"cbc_alexf_tl_faq\";i:0;s:20:\"cbc_alexf_tl_content\";i:0;s:21:\"cbc_alexf_tl_comments\";i:0;s:26:\"cbc_alexf_tl_calendar_feed\";i:0;s:28:\"cbc_alexf_tl_calendar_events\";i:0;s:21:\"cbc_alexf_tl_calendar\";i:0;s:20:\"cbc_alexf_tl_article\";i:0;}}' WHERE id = 1;

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

No loaded entities.

Symfony Profiler

POST https://afvts.ch/contao?act=edit&do=article&id=10&ptable=tl_content&ref=8FhkuVis&rt=cc5d47945b1095.Dez64PKFP3gN2UkAItP3dfmUXZbIjtkwMK11g3uRWN4.ZpmugbXdXDRamhtLa…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping