Symfony Profiler

Query Metrics

58 Database Queries

36 Different statements

181.20 ms Query time

0 Invalid entities

0 Managed entities

Queries


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_catalog ORDER BY `pTable` DESC, `tablename` ASC
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename = ?
SELECT * FROM tl_article WHERE NOT EXISTS( SELECT * FROM tl_page WHERE tl_article.pid = tl_page.id)
SELECT * FROM tl_catalog WHERE `tablename` = ? LIMIT 0,1
SELECT * FROM tl_catalog_fields WHERE `pid` = ( SELECT id FROM tl_catalog WHERE `tablename` = ? LIMIT 1 ) AND invisible != "1" ORDER BY `sorting`
SHOW FULL COLUMNS FROM ctlg_category
SHOW INDEXES FROM `ctlg_category`
SELECT * FROM tl_catalog WHERE tablename = ? LIMIT 1
SELECT * FROM ctlg_category ORDER BY title DESC
SELECT tl_page.* FROM tl_page WHERE tl_page.`type`=?
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 = 'c3_dls'
            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 = 'c3_dls' */ 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 urlPrefix, urlSuffix FROM tl_page WHERE type='root'
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?)
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT * FROM tl_page WHERE id=? LIMIT 1
SELECT tl_page.* FROM tl_page WHERE tl_page.type=? AND (tl_page.dns=? OR tl_page.dns=?) LIMIT 0,1
SELECT * FROM tl_page WHERE id=? LIMIT 1
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?)
SELECT templates FROM tl_theme WHERE templates != ''
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? 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(39,40,86,67,0,94) ORDER BY FIND_IN_SET(`tl_module`.`id`, '39,40,86,67,0,94')
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<=1775314200) AND (tl_content.stop='' OR tl_content.stop>1775314200) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775314200) AND (tl_article.stop='' OR tl_article.stop>1775314200) 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 tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT * FROM tl_page WHERE type=? OR type=?
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(3) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '3')
SELECT tl_news.* FROM tl_news WHERE CAST(tl_news.alias AS BINARY)=? AND tl_news.pid IN(3) AND tl_news.published=1 AND (tl_news.start='' OR tl_news.start<=1775314200) AND (tl_news.stop='' OR tl_news.stop>1775314200) LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_user.* FROM tl_user WHERE tl_user.`id`=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? 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

#▲	Time	Info
1	1.47 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	0.77 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	2.51 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"c3_dls"`] 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 = 'c3_dls' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
4	2.00 ms	SELECT * FROM tl_catalog ORDER BY `pTable` DESC, `tablename` ASC Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_catalog ORDER BY `pTable` DESC, `tablename` ASC SELECT * FROM tl_catalog ORDER BY `pTable` DESC, `tablename` ASC;
5	2.51 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
6	1.37 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_content"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_content' LIMIT 0,1;
7	1.23 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_article"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_article' LIMIT 0,1;
8	1.21 ms	SELECT id FROM tl_catalog WHERE tablename = ? Parameters: [`"tl_page"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? SELECT id FROM tl_catalog WHERE tablename = 'tl_page';
9	2.18 ms	SELECT * FROM tl_article WHERE NOT EXISTS( SELECT * FROM tl_page WHERE tl_article.pid = tl_page.id) Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_article WHERE NOT EXISTS( SELECT * FROM tl_page WHERE tl_article.pid = tl_page.id ) SELECT * FROM tl_article WHERE NOT EXISTS( SELECT * FROM tl_page WHERE tl_article.pid = tl_page.id);
10	1.36 ms	SELECT * FROM tl_catalog WHERE `tablename` = ? LIMIT 0,1 Parameters: [`"tl_page"`] View formatted query View runnable query Explain query SELECT * FROM tl_catalog WHERE `tablename` = ? LIMIT 0, 1 SELECT * FROM tl_catalog WHERE `tablename` = 'tl_page' LIMIT 0,1;
11	1.73 ms	SELECT * FROM tl_catalog_fields WHERE `pid` = ( SELECT id FROM tl_catalog WHERE `tablename` = ? LIMIT 1 ) AND invisible != "1" ORDER BY `sorting` Parameters: [`"tl_page"`] View formatted query View runnable query Explain query SELECT * FROM tl_catalog_fields WHERE `pid` = ( SELECT id FROM tl_catalog WHERE `tablename` = ? LIMIT 1 ) AND invisible != "1" ORDER BY `sorting` SELECT * FROM tl_catalog_fields WHERE `pid` = ( SELECT id FROM tl_catalog WHERE `tablename` = 'tl_page' LIMIT 1 ) AND invisible != "1" ORDER BY `sorting`;
12	1.78 ms	SHOW FULL COLUMNS FROM ctlg_category Parameters: [] View formatted query View runnable query Explain query SHOW FULL COLUMNS FROM ctlg_category SHOW FULL COLUMNS FROM ctlg_category;
13	1.00 ms	SHOW INDEXES FROM `ctlg_category` Parameters: [] View formatted query View runnable query Explain query SHOW INDEXES FROM `ctlg_category` SHOW INDEXES FROM `ctlg_category`;
14	1.00 ms	SELECT * FROM tl_catalog WHERE tablename = ? LIMIT 1 Parameters: [`"ctlg_category"`] View formatted query View runnable query Explain query SELECT * FROM tl_catalog WHERE tablename = ? LIMIT 1 SELECT * FROM tl_catalog WHERE tablename = 'ctlg_category' LIMIT 1;
15	0.97 ms	SELECT * FROM ctlg_category ORDER BY title DESC Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ctlg_category ORDER BY title DESC SELECT * FROM ctlg_category ORDER BY title DESC;
16	1.19 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`type`=? Parameters: [`"root"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`type` = ? SELECT tl_page.* FROM tl_page WHERE tl_page.`type`='root';
17	0.83 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	74.53 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 = 'c3_dls' 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: [`"c3_dls" "c3_dls"`] 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 = 'c3_dls' 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 = 'c3_dls' 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 = 'c3_dls' AND t.TABLE_SCHEMA = 'c3_dls' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;
19	3.91 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: [`"c3_dls"`] 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 = 'c3_dls' ORDER BY SEQ_IN_INDEX;
20	3.69 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 = 'c3_dls' / ORDER BY k.ORDINAL_POSITION Parameters: [`"c3_dls"`] 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 = 'c3_dls' / 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 = 'c3_dls' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'c3_dls' / ORDER BY k.ORDINAL_POSITION;
21	25.97 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: [`"c3_dls"`] 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 = 'c3_dls' AND t.TABLE_TYPE = 'BASE TABLE';
22	1.02 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
23	1.04 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';
24	1.74 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?) Parameters: [`"aktuelles/dls-fuer-zuhause/details/selbstbildnis-der-demeter-baecker" "aktuelles/dls-fuer-zuhause/details" "aktuelles/dls-fuer-zuhause" "aktuelles"`] 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 ('aktuelles/dls-fuer-zuhause/details/selbstbildnis-der-demeter-baecker','aktuelles/dls-fuer-zuhause/details','aktuelles/dls-fuer-zuhause','aktuelles');
25	1.17 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`47`] 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`=47 LIMIT 0,1;
26	0.92 ms	SELECT * FROM tl_page WHERE id=? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE id = ? LIMIT 1 SELECT * FROM tl_page WHERE id=1 LIMIT 1;
27	1.37 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.type=? AND (tl_page.dns=? OR tl_page.dns=?) LIMIT 0,1 Parameters: [`"root" "dls.c5.bargon.net" ""`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.type = ? AND ( tl_page.dns = ? OR tl_page.dns = ? ) LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND (tl_page.dns='dls.c5.bargon.net' OR tl_page.dns='') LIMIT 0,1;
28	0.99 ms	SELECT * FROM tl_page WHERE id=? LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE id = ? LIMIT 1 SELECT * FROM tl_page WHERE id=1 LIMIT 1;
29	1.25 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?) Parameters: [`"aktuelles/dls-fuer-zuhause/details/selbstbildnis-der-demeter-baecker" "aktuelles/dls-fuer-zuhause/details" "aktuelles/dls-fuer-zuhause" "aktuelles"`] 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 ('aktuelles/dls-fuer-zuhause/details/selbstbildnis-der-demeter-baecker','aktuelles/dls-fuer-zuhause/details','aktuelles/dls-fuer-zuhause','aktuelles');
30	1.13 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 != '';
31	1.17 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_layout"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_layout' LIMIT 0,1;
32	0.94 ms	SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1 Parameters: [`9`] 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`=9 LIMIT 0,1;
33	1.65 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_module"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_module' LIMIT 0,1;
34	1.97 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
35	1.48 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
36	1.30 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
37	1.45 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_cms_tag_settings"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_cms_tag_settings' LIMIT 0,1;
38	1.19 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_theme"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_theme' LIMIT 0,1;
39	1.00 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;
40	1.91 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(39,40,86,67,0,94) ORDER BY FIND_IN_SET(`tl_module`.`id`, '39,40,86,67,0,94') Parameters: [] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(39, 40, 86, 67, 0, 94) ORDER BY FIND_IN_SET( `tl_module`.`id`, '39,40,86,67,0,94' ) SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(39,40,86,67,0,94) ORDER BY FIND_IN_SET(`tl_module`.`id`, '39,40,86,67,0,94');
41	1.82 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<=1775314200) AND (tl_content.stop='' OR tl_content.stop>1775314200) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775314200) AND (tl_article.stop='' OR tl_article.stop>1775314200) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting Parameters: [`"module" "tl_article" 67 "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 <= 1775314200 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775314200 ) AND tl_article.published = 1 AND ( tl_article.start = '' OR tl_article.start <= 1775314200 ) AND ( tl_article.stop = '' OR tl_article.stop > 1775314200 ) 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=67 AND tl_article.inColumn IN ('main') AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775314200) AND (tl_content.stop='' OR tl_content.stop>1775314200) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775314200) AND (tl_article.stop='' OR tl_article.stop>1775314200) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting;
42	1.48 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1 Parameters: [`805`] 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`=805 LIMIT 0,1;
43	1.80 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`69`] 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`=69 LIMIT 0,1;
44	1.40 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
45	1.42 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
46	1.03 ms	SELECT * FROM tl_page WHERE type=? OR type=? Parameters: [`"root" "rootfallback"`] View formatted query View runnable query Explain query SELECT * FROM tl_page WHERE type = ? OR type = ? SELECT * FROM tl_page WHERE type='root' OR type='rootfallback';
47	1.05 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_news"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_news' LIMIT 0,1;
48	0.83 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_news_archive"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_news_archive' LIMIT 0,1;
49	0.98 ms	SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(3) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '3') Parameters: [] View formatted query View runnable query Explain query SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(3) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '3') SELECT tl_news_archive.* FROM tl_news_archive WHERE tl_news_archive.id IN(3) ORDER BY FIND_IN_SET(`tl_news_archive`.`id`, '3');
50	1.19 ms	SELECT tl_news.* FROM tl_news WHERE CAST(tl_news.alias AS BINARY)=? AND tl_news.pid IN(3) AND tl_news.published=1 AND (tl_news.start='' OR tl_news.start<=1775314200) AND (tl_news.stop='' OR tl_news.stop>1775314200) LIMIT 0,1 Parameters: [`"selbstbildnis-der-demeter-baecker"`] View formatted query View runnable query Explain query SELECT tl_news.* FROM tl_news WHERE CAST(tl_news.alias AS BINARY)= ? AND tl_news.pid IN(3) AND tl_news.published = 1 AND ( tl_news.start = '' OR tl_news.start <= 1775314200 ) AND ( tl_news.stop = '' OR tl_news.stop > 1775314200 ) LIMIT 0, 1 SELECT tl_news.* FROM tl_news WHERE CAST(tl_news.alias AS BINARY)='selbstbildnis-der-demeter-baecker' AND tl_news.pid IN(3) AND tl_news.published=1 AND (tl_news.start='' OR tl_news.start<=1775314200) AND (tl_news.stop='' OR tl_news.stop>1775314200) LIMIT 0,1;
51	1.70 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_user"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_user' LIMIT 0,1;
52	1.43 ms	SELECT tl_user.* FROM tl_user WHERE tl_user.`id`=? LIMIT 0,1 Parameters: [`3`] View formatted query View runnable query Explain query SELECT tl_user.* FROM tl_user WHERE tl_user.`id` = ? LIMIT 0, 1 SELECT tl_user.* FROM tl_user WHERE tl_user.`id`=3 LIMIT 0,1;
53	1.72 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_files"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_files' LIMIT 0,1;
54	1.19 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"16062f64422911e884e10cc47a76f45e"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX('16062f64422911e884e10cc47a76f45e') LIMIT 0,1;
55	1.17 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_image_size_item"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_image_size_item' LIMIT 0,1;
56	0.96 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_image_size"`] View formatted query View runnable query Explain query SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0, 1 SELECT id FROM tl_catalog WHERE tablename='tl_image_size' LIMIT 0,1;
57	1.04 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;
58	1.09 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;

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

GET https://dls.c5.bargon.net/aktuelles/dls-fuer-zuhause/details/selbstbildnis-der-demeter-baecker

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping