Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

94 Database Queries

36 Different statements

21.65 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT DATABASE()
SELECT DATABASE()
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
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 tl_page.* FROM tl_page WHERE tl_page.alias IN (?)
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,2) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,2')
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<=1765329720) AND (tl_article.stop='' OR tl_article.stop>1765329720) ORDER BY tl_article.sorting
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=?
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=?
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=?
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1
SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive
SELECT tl_module.* FROM tl_module WHERE tl_module.jumpTo!=? AND foundation_item_template!=?
SELECT tl_memo_portfolio.* FROM tl_memo_portfolio WHERE tl_memo_portfolio.pid IN(1) AND tl_memo_portfolio.published='1' AND (tl_memo_portfolio.start='' OR tl_memo_portfolio.start<1765329770) AND (tl_memo_portfolio.stop='' OR tl_memo_portfolio.stop>1765329770) ORDER BY tl_memo_portfolio.sorting
SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND (
                tl_page.dns=?
                OR tl_page.dns IN (
                    SELECT dns
                    FROM tl_page
                    WHERE type='root' AND fallback='1' AND id = (
                        SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1
                    )
                )
                OR tl_page.dns IN (
                    SELECT dns
                    FROM tl_page
                    WHERE type='root' AND fallback='1' AND languageRoot = (
                        SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1
                    )
                )
                OR tl_page.dns IN (
                    SELECT dns
                    FROM tl_page
                    WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = (
                        SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1
                    )
                )
            ) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329780) ORDER BY sorting
SELECT tl_page.* FROM tl_page WHERE (tl_page.id=? OR tl_page.languageMain=?) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329780)
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=?
SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1
SELECT * FROM tl_memo_category
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f74c44007c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('f74c44007c1d11eb8734702b851dfea4')
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f74c44007c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('f74c44007c1d11eb8734702b851dfea4')
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')
SELECT tl_node.* FROM tl_node WHERE id=? AND type=? LIMIT 0,1
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1765329720) AND (p2.stop='' OR p2.stop>1765329720)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1765329720) AND (p1.stop='' OR p1.stop>1765329720) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(20,8) ORDER BY FIND_IN_SET(`tl_page`.`id`, '20,22,8')
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1765329720) AND (p2.stop='' OR p2.stop>1765329720)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1765329720) AND (p1.stop='' OR p1.stop>1765329720) ORDER BY p1.sorting
SELECT * FROM tl_dk_mmenu_config WHERE tl_dk_mmenu_config.`id`=? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_form.* FROM tl_form WHERE tl_form.`id`=? LIMIT 0,1
SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=? AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.pid=? AND tl_page.type!='root' AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY tl_page.sorting LIMIT 0,1
SELECT tl_node.* FROM tl_node WHERE id=? AND type=? LIMIT 0,1
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT * FROM tl_inserttags WHERE tag=?
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT id, name AS value FROM tl_layout WHERE id IN (1)
SELECT id, name AS value FROM tl_user WHERE id IN (1)
SELECT id, name AS value FROM tl_user_group WHERE id IN (1)
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,10,12) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12')
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,10,12) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12')
SELECT tl_node.* FROM tl_node WHERE id=? AND type=? LIMIT 0,1
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7c4e79312aef11ea9c220242ac170002'),UNHEX('7c4e790c2aef11ea9c220242ac170002'),UNHEX('7c4e78fb2aef11ea9c220242ac170002')) ORDER BY tl_files.uuid!=UNHEX('7c4e79312aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e790c2aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e78fb2aef11ea9c220242ac170002')
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7c4e79312aef11ea9c220242ac170002'),UNHEX('7c4e790c2aef11ea9c220242ac170002'),UNHEX('7c4e78fb2aef11ea9c220242ac170002')) ORDER BY tl_files.uuid!=UNHEX('7c4e79312aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e790c2aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e78fb2aef11ea9c220242ac170002')

#▲	Time	Info
1	0.47 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	0.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	0.97 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"memolabs_schnuppernlio"`] 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 = 'memolabs_schnuppernlio' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
4	0.62 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?) Parameters: [`"referenzen"`] 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 ('referenzen');
5	0.17 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;
6	0.27 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?) Parameters: [`"referenzen"`] 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 ('referenzen');
7	0.20 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 != '';
8	0.30 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;
9	0.20 ms	SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1 Parameters: [`2`] 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`=2 LIMIT 0,1;
10	0.31 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(1,0,2) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,2') Parameters: [] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(1, 0, 2) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,2') SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(1,0,2) ORDER BY FIND_IN_SET(`tl_module`.`id`, '1,0,2');
11	0.76 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<=1765329720) AND (tl_article.stop='' OR tl_article.stop>1765329720) ORDER BY tl_article.sorting Parameters: [`22 "main"`] View formatted query View runnable query Explain query SELECT tl_article.* FROM tl_article WHERE tl_article.pid = ? AND tl_article.inColumn = ? AND tl_article.published = '1' AND ( tl_article.start = '' OR tl_article.start <= 1765329720 ) AND ( tl_article.stop = '' OR tl_article.stop > 1765329720 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=22 AND tl_article.inColumn='main' AND tl_article.published='1' AND (tl_article.start='' OR tl_article.start<=1765329720) AND (tl_article.stop='' OR tl_article.stop>1765329720) ORDER BY tl_article.sorting;
12	0.84 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) 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 = ? OR tl_content.ptable = '' ) AND tl_content.invisible = '' AND ( tl_content.start = '' OR tl_content.start <= 1765329720 ) AND ( tl_content.stop = '' OR tl_content.stop > 1765329720 ) 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' OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
13	0.60 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`12`] 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`=12 LIMIT 0,1;
14	0.26 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? Parameters: [`"root" ""`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='';
15	0.18 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1 Parameters: [`"root" "" 1`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? AND fallback = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='' AND fallback=1 LIMIT 0,1;
16	0.25 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? Parameters: [`"root" ""`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='';
17	0.18 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1 Parameters: [`"root" "" 1`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? AND fallback = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='' AND fallback=1 LIMIT 0,1;
18	0.24 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? Parameters: [`"root" ""`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='';
19	0.16 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1 Parameters: [`"root" "" 1`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? AND fallback = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='' AND fallback=1 LIMIT 0,1;
20	0.43 ms	SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive Parameters: [] View formatted query View runnable query Explain query SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive;
21	0.52 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.jumpTo!=? AND foundation_item_template!=? Parameters: [`"" ""`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.jumpTo != ? AND foundation_item_template != ? SELECT tl_module.* FROM tl_module WHERE tl_module.jumpTo!='' AND foundation_item_template!='';
22	0.39 ms	SELECT tl_memo_portfolio.* FROM tl_memo_portfolio WHERE tl_memo_portfolio.pid IN(1) AND tl_memo_portfolio.published='1' AND (tl_memo_portfolio.start='' OR tl_memo_portfolio.start<1765329770) AND (tl_memo_portfolio.stop='' OR tl_memo_portfolio.stop>1765329770) ORDER BY tl_memo_portfolio.sorting Parameters: [] View formatted query View runnable query Explain query SELECT tl_memo_portfolio.* FROM tl_memo_portfolio WHERE tl_memo_portfolio.pid IN(1) AND tl_memo_portfolio.published = '1' AND ( tl_memo_portfolio.start = '' OR tl_memo_portfolio.start < 1765329770 ) AND ( tl_memo_portfolio.stop = '' OR tl_memo_portfolio.stop > 1765329770 ) ORDER BY tl_memo_portfolio.sorting SELECT tl_memo_portfolio.* FROM tl_memo_portfolio WHERE tl_memo_portfolio.pid IN(1) AND tl_memo_portfolio.published='1' AND (tl_memo_portfolio.start='' OR tl_memo_portfolio.start<1765329770) AND (tl_memo_portfolio.stop='' OR tl_memo_portfolio.stop>1765329770) ORDER BY tl_memo_portfolio.sorting;
23	0.13 ms	SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive Parameters: [] View formatted query View runnable query Explain query SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive SELECT tl_memo_portfolio_archive.* FROM tl_memo_portfolio_archive;
24	0.39 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`23`] 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`=23 LIMIT 0,1;
25	0.79 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND ( tl_page.dns=? OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND id = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot = ( SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns=? LIMIT 1 ) ) ) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329780) ORDER BY sorting Parameters: [`"" "" "" ""`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.type = 'root' AND ( tl_page.dns = ? OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type = 'root' AND fallback = '1' AND id = ( SELECT languageRoot FROM tl_page WHERE type = 'root' AND fallback = '1' AND dns = ? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type = 'root' AND fallback = '1' AND languageRoot = ( SELECT id FROM tl_page WHERE type = 'root' AND fallback = '1' AND dns = ? LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type = 'root' AND fallback = '1' AND languageRoot != 0 AND languageRoot = ( SELECT languageRoot FROM tl_page WHERE type = 'root' AND fallback = '1' AND dns = ? LIMIT 1 ) ) ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start < 1765329720 ) AND ( tl_page.stop = '' OR tl_page.stop > 1765329780 ) ORDER BY sorting SELECT tl_page.* FROM tl_page WHERE tl_page.type='root' AND ( tl_page.dns='' OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND id = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns='' LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot = ( SELECT id FROM tl_page WHERE type='root' AND fallback='1' AND dns='' LIMIT 1 ) ) OR tl_page.dns IN ( SELECT dns FROM tl_page WHERE type='root' AND fallback='1' AND languageRoot != 0 AND languageRoot = ( SELECT languageRoot FROM tl_page WHERE type='root' AND fallback='1' AND dns='' LIMIT 1 ) ) ) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329780) ORDER BY sorting;
26	0.80 ms	SELECT tl_page.* FROM tl_page WHERE (tl_page.id=? OR tl_page.languageMain=?) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329780) Parameters: [`23 23`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE ( tl_page.id = ? OR tl_page.languageMain = ? ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start < 1765329720 ) AND ( tl_page.stop = '' OR tl_page.stop > 1765329780 ) SELECT tl_page.* FROM tl_page WHERE (tl_page.id=23 OR tl_page.languageMain=23) AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329780);
27	0.17 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? Parameters: [`"root" ""`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='';
28	0.12 ms	SELECT tl_page.* FROM tl_page WHERE type=? AND language!=? AND fallback=? LIMIT 0,1 Parameters: [`"root" "" 1`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE type = ? AND language != ? AND fallback = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE type='root' AND language!='' AND fallback=1 LIMIT 0,1;
29	0.13 ms	SELECT * FROM tl_memo_category Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_memo_category SELECT * FROM tl_memo_category;
30	0.34 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"7f47cfed2af311ea9c220242ac170002"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('7f47cfed2af311ea9c220242ac170002') LIMIT 0,1;
31	0.17 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"project"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='project';
32	0.17 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
33	0.11 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
34	0.10 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
35	0.23 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f74c44007c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('f74c44007c1d11eb8734702b851dfea4') Parameters: [`null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( 'f74c44007c1d11eb8734702b851dfea4' ) ) ORDER BY tl_files.uuid != UNHEX( 'f74c44007c1d11eb8734702b851dfea4' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f74c44007c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('f74c44007c1d11eb8734702b851dfea4');
36	0.16 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f74c44007c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('f74c44007c1d11eb8734702b851dfea4') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( 'f74c44007c1d11eb8734702b851dfea4' ) ) ORDER BY tl_files.uuid != UNHEX( 'f74c44007c1d11eb8734702b851dfea4' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f74c44007c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('f74c44007c1d11eb8734702b851dfea4');
37	0.03 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4') Parameters: [`null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( 'ed7d9a8c7c1d11eb8734702b851dfea4' ) ) ORDER BY tl_files.uuid != UNHEX( 'ed7d9a8c7c1d11eb8734702b851dfea4' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4');
38	0.13 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( 'ed7d9a8c7c1d11eb8734702b851dfea4' ) ) ORDER BY tl_files.uuid != UNHEX( 'ed7d9a8c7c1d11eb8734702b851dfea4' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4')) ORDER BY tl_files.uuid!=UNHEX('ed7d9a8c7c1d11eb8734702b851dfea4');
39	0.20 ms	SELECT tl_node.* FROM tl_node WHERE id=? AND type=? LIMIT 0,1 Parameters: [`2 "content"`] View formatted query View runnable query Explain query SELECT tl_node.* FROM tl_node WHERE id = ? AND type = ? LIMIT 0, 1 SELECT tl_node.* FROM tl_node WHERE id=2 AND type='content' LIMIT 0,1;
40	0.20 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`2 "tl_node"`] 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 = '' AND ( tl_content.start = '' OR tl_content.start <= 1765329720 ) AND ( tl_content.stop = '' OR tl_content.stop > 1765329720 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=2 AND tl_content.ptable='tl_node' AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
41	0.11 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"a3ac2b1e2aed11ea9c220242ac170002"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('a3ac2b1e2aed11ea9c220242ac170002') LIMIT 0,1;
42	0.18 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"company"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='company';
43	0.17 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
44	0.12 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
45	0.11 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
46	0.25 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"6"`] 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`='6' LIMIT 0,1;
47	0.15 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1765329720) AND (p2.stop='' OR p2.stop>1765329720)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1765329720) AND (p1.stop='' OR p1.stop>1765329720) ORDER BY p1.sorting Parameters: [`1`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= 1765329720 ) AND ( p2.stop = '' OR p2.stop > 1765329720 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= 1765329720 ) AND ( p1.stop = '' OR p1.stop > 1765329720 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1765329720) AND (p2.stop='' OR p2.stop>1765329720)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=1 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1765329720) AND (p1.stop='' OR p1.stop>1765329720) ORDER BY p1.sorting;
48	0.62 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(20,8) ORDER BY FIND_IN_SET(`tl_page`.`id`, '20,22,8') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(20, 8) ORDER BY FIND_IN_SET(`tl_page`.`id`, '20,22,8') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(20,8) ORDER BY FIND_IN_SET(`tl_page`.`id`, '20,22,8');
49	0.20 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"5"`] 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`='5' LIMIT 0,1;
50	0.14 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1765329720) AND (p2.stop='' OR p2.stop>1765329720)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1765329720) AND (p1.stop='' OR p1.stop>1765329720) ORDER BY p1.sorting Parameters: [`1`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = '' AND p2.published = '1' AND ( p2.start = '' OR p2.start <= 1765329720 ) AND ( p2.stop = '' OR p2.stop > 1765329720 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = '' AND p1.published = '1' AND ( p1.start = '' OR p1.start <= 1765329720 ) AND ( p1.stop = '' OR p1.stop > 1765329720 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide='' AND p2.published='1' AND (p2.start='' OR p2.start<=1765329720) AND (p2.stop='' OR p2.stop>1765329720)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=1 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide='' AND p1.published='1' AND (p1.start='' OR p1.start<=1765329720) AND (p1.stop='' OR p1.stop>1765329720) ORDER BY p1.sorting;
51	0.20 ms	SELECT * FROM tl_dk_mmenu_config WHERE tl_dk_mmenu_config.`id`=? LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM tl_dk_mmenu_config WHERE tl_dk_mmenu_config.`id` = ? LIMIT 0, 1 SELECT * FROM tl_dk_mmenu_config WHERE tl_dk_mmenu_config.`id`=1 LIMIT 0,1;
52	0.17 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.`id` = ? LIMIT 0, 1 SELECT tl_module.* FROM tl_module WHERE tl_module.`id`='4' LIMIT 0,1;
53	0.17 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"7"`] 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`='7' LIMIT 0,1;
54	0.16 ms	SELECT tl_form.* FROM tl_form WHERE tl_form.`id`=? LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT tl_form.* FROM tl_form WHERE tl_form.`id` = ? LIMIT 0, 1 SELECT tl_form.* FROM tl_form WHERE tl_form.`id`=1 LIMIT 0,1;
55	0.15 ms	SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=? AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting Parameters: [`1`] View formatted query View runnable query Explain query SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid = ? AND tl_form_field.invisible = '' AND tl_form_field.tstamp != 0 ORDER BY tl_form_field.sorting SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=1 AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting;
56	0.17 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`12`] 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`=12 LIMIT 0,1;
57	0.13 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`24`] 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`=24 LIMIT 0,1;
58	0.19 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"3"`] 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`='3' LIMIT 0,1;
59	0.19 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.pid=? AND tl_page.type!='root' AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY tl_page.sorting LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.pid = ? AND tl_page.type != 'root' AND tl_page.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= 1765329720 ) AND ( tl_page.stop = '' OR tl_page.stop > 1765329720 ) ORDER BY tl_page.sorting LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.pid=1 AND tl_page.type!='root' AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY tl_page.sorting LIMIT 0,1;
60	0.16 ms	SELECT tl_node.* FROM tl_node WHERE id=? AND type=? LIMIT 0,1 Parameters: [`4 "content"`] View formatted query View runnable query Explain query SELECT tl_node.* FROM tl_node WHERE id = ? AND type = ? LIMIT 0, 1 SELECT tl_node.* FROM tl_node WHERE id=4 AND type='content' LIMIT 0,1;
61	0.21 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`4 "tl_node"`] 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 = '' AND ( tl_content.start = '' OR tl_content.start <= 1765329720 ) AND ( tl_content.stop = '' OR tl_content.stop > 1765329720 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=4 AND tl_content.ptable='tl_node' AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
62	0.18 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
63	0.15 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
64	0.11 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
65	0.17 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"street"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='street';
66	0.16 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
67	0.11 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
68	0.10 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
69	0.15 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"city_plz"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='city_plz';
70	0.14 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
71	0.11 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
72	0.10 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
73	0.17 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"phone_link"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='phone_link';
74	0.15 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
75	0.12 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
76	0.11 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
77	0.15 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"phone"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='phone';
78	0.15 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
79	0.11 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
80	0.11 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
81	0.16 ms	SELECT * FROM tl_inserttags WHERE tag=? Parameters: [`"email"`] View formatted query View runnable query Explain query SELECT * FROM tl_inserttags WHERE tag = ? SELECT * FROM tl_inserttags WHERE tag='email';
82	0.15 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
83	0.13 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
84	0.13 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
85	0.18 ms	SELECT id, name AS value FROM tl_layout WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_layout WHERE id IN (1) SELECT id, name AS value FROM tl_layout WHERE id IN (1);
86	0.16 ms	SELECT id, name AS value FROM tl_user WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user WHERE id IN (1) SELECT id, name AS value FROM tl_user WHERE id IN (1);
87	0.11 ms	SELECT id, name AS value FROM tl_user_group WHERE id IN (1) Parameters: [] View formatted query View runnable query Explain query SELECT id, name AS value FROM tl_user_group WHERE id IN (1) SELECT id, name AS value FROM tl_user_group WHERE id IN (1);
88	0.31 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"8"`] 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`='8' LIMIT 0,1;
89	0.07 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,10,12) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12') Parameters: [`null`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9, 10, 12) AND tl_page.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= 1765329720 ) AND ( tl_page.stop = '' OR tl_page.stop > 1765329720 ) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,10,12) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12');
90	0.25 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,10,12) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9, 10, 12) AND tl_page.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND tl_page.published = '1' AND ( tl_page.start = '' OR tl_page.start <= 1765329720 ) AND ( tl_page.stop = '' OR tl_page.stop > 1765329720 ) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(9,10,12) AND tl_page.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1765329720) AND (tl_page.stop='' OR tl_page.stop>1765329720) ORDER BY FIND_IN_SET(`tl_page`.`id`, '9,10,12');
91	0.20 ms	SELECT tl_node.* FROM tl_node WHERE id=? AND type=? LIMIT 0,1 Parameters: [`5 "content"`] View formatted query View runnable query Explain query SELECT tl_node.* FROM tl_node WHERE id = ? AND type = ? LIMIT 0, 1 SELECT tl_node.* FROM tl_node WHERE id=5 AND type='content' LIMIT 0,1;
92	0.22 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`5 "tl_node"`] 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 = '' AND ( tl_content.start = '' OR tl_content.start <= 1765329720 ) AND ( tl_content.stop = '' OR tl_content.stop > 1765329720 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=5 AND tl_content.ptable='tl_node' AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1765329720) AND (tl_content.stop='' OR tl_content.stop>1765329720) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
93	0.05 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7c4e79312aef11ea9c220242ac170002'),UNHEX('7c4e790c2aef11ea9c220242ac170002'),UNHEX('7c4e78fb2aef11ea9c220242ac170002')) ORDER BY tl_files.uuid!=UNHEX('7c4e79312aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e790c2aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e78fb2aef11ea9c220242ac170002') Parameters: [`null`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '7c4e79312aef11ea9c220242ac170002' ), UNHEX( '7c4e790c2aef11ea9c220242ac170002' ), UNHEX( '7c4e78fb2aef11ea9c220242ac170002' ) ) ORDER BY tl_files.uuid != UNHEX( '7c4e79312aef11ea9c220242ac170002' ), tl_files.uuid != UNHEX( '7c4e790c2aef11ea9c220242ac170002' ), tl_files.uuid != UNHEX( '7c4e78fb2aef11ea9c220242ac170002' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7c4e79312aef11ea9c220242ac170002'),UNHEX('7c4e790c2aef11ea9c220242ac170002'),UNHEX('7c4e78fb2aef11ea9c220242ac170002')) ORDER BY tl_files.uuid!=UNHEX('7c4e79312aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e790c2aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e78fb2aef11ea9c220242ac170002');
94	0.19 ms	SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7c4e79312aef11ea9c220242ac170002'),UNHEX('7c4e790c2aef11ea9c220242ac170002'),UNHEX('7c4e78fb2aef11ea9c220242ac170002')) ORDER BY tl_files.uuid!=UNHEX('7c4e79312aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e790c2aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e78fb2aef11ea9c220242ac170002') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid IN( UNHEX( '7c4e79312aef11ea9c220242ac170002' ), UNHEX( '7c4e790c2aef11ea9c220242ac170002' ), UNHEX( '7c4e78fb2aef11ea9c220242ac170002' ) ) ORDER BY tl_files.uuid != UNHEX( '7c4e79312aef11ea9c220242ac170002' ), tl_files.uuid != UNHEX( '7c4e790c2aef11ea9c220242ac170002' ), tl_files.uuid != UNHEX( '7c4e78fb2aef11ea9c220242ac170002' ) SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('7c4e79312aef11ea9c220242ac170002'),UNHEX('7c4e790c2aef11ea9c220242ac170002'),UNHEX('7c4e78fb2aef11ea9c220242ac170002')) ORDER BY tl_files.uuid!=UNHEX('7c4e79312aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e790c2aef11ea9c220242ac170002'), tl_files.uuid!=UNHEX('7c4e78fb2aef11ea9c220242ac170002');

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.

Entities Mapping

No loaded entities.

Symfony Profiler

http://www.schnuppern-lio.memo-labs.ch/referenzen.html

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping