Symfony Profiler

Query Metrics

84 Database Queries

46 Different statements

158.43 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<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775303400) AND (tl_article.stop='' OR tl_article.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(5,38,6,77,3) ORDER BY FIND_IN_SET(`tl_page`.`id`, '5,38,6,77,76,3')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(68,48,49,50,18,60,101) ORDER BY FIND_IN_SET(`tl_page`.`id`, '68,48,49,50,18,60,101')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(45,46,75,47,61,71) ORDER BY FIND_IN_SET(`tl_page`.`id`, '45,46,75,47,61,71')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(14,15,16,17,43,44) ORDER BY FIND_IN_SET(`tl_page`.`id`, '14,15,16,17,43,44')
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(69,70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70')
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? 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=0 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_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<=1775303400) AND (tl_article.stop='' OR tl_article.stop>1775303400) ORDER BY tl_article.sorting
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_storelocator_stores.* FROM tl_storelocator_stores WHERE CAST(tl_storelocator_stores.alias AS BINARY)=? LIMIT 0,1
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM tl_page WHERE id=? LIMIT 1
SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM `tl_files` WHERE uuid=?
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
SELECT * FROM `tl_files` WHERE uuid=?
SELECT * FROM `tl_files` WHERE uuid=?
SELECT * FROM `tl_files` WHERE uuid=?
SELECT * FROM `tl_files` WHERE uuid=?
SELECT * FROM `tl_files` WHERE uuid=?
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? 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.04 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	0.66 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	2.58 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	1.45 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.12 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	0.87 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.16 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.15 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	1.63 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	0.75 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.38 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.22 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	0.96 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	0.75 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.72 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	0.98 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.63 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	48.98 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	2.87 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	2.56 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	16.52 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	0.85 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
23	0.99 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.06 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?) Parameters: [`"standorte/standort-details/store/öko-markt-köln-neusser-platz" "standorte/standort-details/store" "standorte/standort-details" "standorte"`] 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 ('standorte/standort-details/store/öko-markt-köln-neusser-platz','standorte/standort-details/store','standorte/standort-details','standorte');
25	0.91 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`76`] 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`=76 LIMIT 0,1;
26	0.94 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.05 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.93 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.09 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?,?) Parameters: [`"standorte/standort-details/store/öko-markt-köln-neusser-platz" "standorte/standort-details/store" "standorte/standort-details" "standorte"`] 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 ('standorte/standort-details/store/öko-markt-köln-neusser-platz','standorte/standort-details/store','standorte/standort-details','standorte');
30	0.92 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	0.93 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.92 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	0.89 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.26 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.00 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.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';
37	0.85 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	0.77 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	0.98 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	2.04 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.70 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<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775303400) AND (tl_article.stop='' OR tl_article.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting Parameters: [`"module" "tl_article" 21 "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 <= 1775303400 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775303400 ) AND tl_article.published = 1 AND ( tl_article.start = '' OR tl_article.start <= 1775303400 ) AND ( tl_article.stop = '' OR tl_article.stop > 1775303400 ) 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=21 AND tl_article.inColumn IN ('main') AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775303400) AND (tl_article.stop='' OR tl_article.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting;
42	1.78 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`"91"`] 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`='91' LIMIT 0,1;
43	1.91 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting Parameters: [`1`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = 0 AND p2.published = 1 AND ( p2.start = '' OR p2.start <= 1775303400 ) AND ( p2.stop = '' OR p2.stop > 1775303400 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = 0 AND p1.published = 1 AND ( p1.start = '' OR p1.start <= 1775303400 ) AND ( p1.stop = '' OR p1.stop > 1775303400 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=1 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting;
44	1.13 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(5,38,6,77,3) ORDER BY FIND_IN_SET(`tl_page`.`id`, '5,38,6,77,76,3') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(5, 38, 6, 77, 3) ORDER BY FIND_IN_SET( `tl_page`.`id`, '5,38,6,77,76,3' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(5,38,6,77,3) ORDER BY FIND_IN_SET(`tl_page`.`id`, '5,38,6,77,76,3');
45	1.49 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting Parameters: [`5`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = 0 AND p2.published = 1 AND ( p2.start = '' OR p2.start <= 1775303400 ) AND ( p2.stop = '' OR p2.stop > 1775303400 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = 0 AND p1.published = 1 AND ( p1.start = '' OR p1.start <= 1775303400 ) AND ( p1.stop = '' OR p1.stop > 1775303400 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=5 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting;
46	1.02 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(68,48,49,50,18,60,101) ORDER BY FIND_IN_SET(`tl_page`.`id`, '68,48,49,50,18,60,101') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(68, 48, 49, 50, 18, 60, 101) ORDER BY FIND_IN_SET( `tl_page`.`id`, '68,48,49,50,18,60,101' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(68,48,49,50,18,60,101) ORDER BY FIND_IN_SET(`tl_page`.`id`, '68,48,49,50,18,60,101');
47	1.61 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting Parameters: [`38`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = 0 AND p2.published = 1 AND ( p2.start = '' OR p2.start <= 1775303400 ) AND ( p2.stop = '' OR p2.stop > 1775303400 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = 0 AND p1.published = 1 AND ( p1.start = '' OR p1.start <= 1775303400 ) AND ( p1.stop = '' OR p1.stop > 1775303400 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=38 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting;
48	1.00 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(45,46,75,47,61,71) ORDER BY FIND_IN_SET(`tl_page`.`id`, '45,46,75,47,61,71') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(45, 46, 75, 47, 61, 71) ORDER BY FIND_IN_SET( `tl_page`.`id`, '45,46,75,47,61,71' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(45,46,75,47,61,71) ORDER BY FIND_IN_SET(`tl_page`.`id`, '45,46,75,47,61,71');
49	1.52 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting Parameters: [`6`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = 0 AND p2.published = 1 AND ( p2.start = '' OR p2.start <= 1775303400 ) AND ( p2.stop = '' OR p2.stop > 1775303400 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = 0 AND p1.published = 1 AND ( p1.start = '' OR p1.start <= 1775303400 ) AND ( p1.stop = '' OR p1.stop > 1775303400 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=6 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting;
50	1.06 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(14,15,16,17,43,44) ORDER BY FIND_IN_SET(`tl_page`.`id`, '14,15,16,17,43,44') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(14, 15, 16, 17, 43, 44) ORDER BY FIND_IN_SET( `tl_page`.`id`, '14,15,16,17,43,44' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(14,15,16,17,43,44) ORDER BY FIND_IN_SET(`tl_page`.`id`, '14,15,16,17,43,44');
51	1.36 ms	SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=? AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting Parameters: [`76`] View formatted query View runnable query Explain query SELECT p1.id, EXISTS( SELECT * FROM tl_page p2 WHERE p2.pid = p1.id AND p2.type != 'root' AND p2.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p2.hide = 0 AND p2.published = 1 AND ( p2.start = '' OR p2.start <= 1775303400 ) AND ( p2.stop = '' OR p2.stop > 1775303400 ) ) AS hasSubpages FROM tl_page p1 WHERE p1.pid = ? AND p1.type != 'root' AND p1.type NOT IN ( 'error_401', 'error_403', 'error_404', 'error_503' ) AND p1.hide = 0 AND p1.published = 1 AND ( p1.start = '' OR p1.start <= 1775303400 ) AND ( p1.stop = '' OR p1.stop > 1775303400 ) ORDER BY p1.sorting SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1775303400) AND (p2.stop='' OR p2.stop>1775303400)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=76 AND p1.type!='root' AND p1.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p1.hide=0 AND p1.published=1 AND (p1.start='' OR p1.start<=1775303400) AND (p1.stop='' OR p1.stop>1775303400) ORDER BY p1.sorting;
52	0.94 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(69,70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(69, 70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(69,70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70');
53	0.96 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_form_field"`] 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_form_field' LIMIT 0,1;
54	0.73 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_form"`] 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_form' LIMIT 0,1;
55	0.91 ms	SELECT tl_form.* FROM tl_form WHERE tl_form.id=? LIMIT 0,1 Parameters: [`"2"`] 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='2' LIMIT 0,1;
56	1.21 ms	SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=? AND tl_form_field.invisible=0 AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting Parameters: [`2`] 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 = 0 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=2 AND tl_form_field.invisible=0 AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting;
57	1.24 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`56`] 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`=56 LIMIT 0,1;
58	1.17 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<=1775303400) AND (tl_article.stop='' OR tl_article.stop>1775303400) ORDER BY tl_article.sorting Parameters: [`21 "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 <= 1775303400 ) AND ( tl_article.stop = '' OR tl_article.stop > 1775303400 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=21 AND tl_article.inColumn='main' AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775303400) AND (tl_article.stop='' OR tl_article.stop>1775303400) ORDER BY tl_article.sorting;
59	1.67 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`20 "tl_article"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = 0 AND ( tl_content.start = '' OR tl_content.start <= 1775303400 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775303400 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=20 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
60	1.65 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`76`] 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`=76 LIMIT 0,1;
61	0.90 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_storelocator_stores"`] 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_storelocator_stores' LIMIT 0,1;
62	0.86 ms	SELECT tl_storelocator_stores.* FROM tl_storelocator_stores WHERE CAST(tl_storelocator_stores.alias AS BINARY)=? LIMIT 0,1 Parameters: [`"öko-markt-köln-neusser-platz"`] View formatted query View runnable query Explain query SELECT tl_storelocator_stores.* FROM tl_storelocator_stores WHERE CAST( tl_storelocator_stores.alias AS BINARY )= ? LIMIT 0, 1 SELECT tl_storelocator_stores.* FROM tl_storelocator_stores WHERE CAST(tl_storelocator_stores.alias AS BINARY)='öko-markt-köln-neusser-platz' LIMIT 0,1;
63	1.38 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`10 "tl_storelocator_stores"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = 0 AND ( tl_content.start = '' OR tl_content.start <= 1775303400 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775303400 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=10 AND tl_content.ptable='tl_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
64	1.02 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;
65	1.10 ms	SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1 Parameters: [`"219"`] View formatted query View runnable query Explain query SELECT tl_article.* FROM tl_article WHERE tl_article.id = ? LIMIT 0, 1 SELECT tl_article.* FROM tl_article WHERE tl_article.id='219' LIMIT 0,1;
66	1.41 ms	SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND tl_content.ptable=? AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`219 "tl_article"`] View formatted query View runnable query Explain query SELECT tl_content.* FROM tl_content WHERE tl_content.pid = ? AND tl_content.ptable = ? AND tl_content.invisible = 0 AND ( tl_content.start = '' OR tl_content.start <= 1775303400 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775303400 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=219 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775303400) AND (tl_content.stop='' OR tl_content.stop>1775303400) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
67	1.15 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"®qy\x05iÓ\x11îˆ\x1FŠÚ\x7F†\x1Dc"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0xAE71790569D311EE881F8ADA7F861D63;
68	0.82 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;
69	0.87 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/template/redesign24/img/Logo.svg"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.`path`='files/template/redesign24/img/Logo.svg' LIMIT 0,1;
70	1.28 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1 Parameters: [`"64"`] 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='64' LIMIT 0,1;
71	0.97 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"·Œÿ€iÓ\x11îˆ\x1FŠÚ\x7F†\x1Dc"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0xB78CFF8069D311EE881F8ADA7F861D63;
72	0.77 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"0…I+„^\x11îŽ¤ŠÚ\x7F†\x1Dc"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0x3085492B845E11EE8EA48ADA7F861D63;
73	0.76 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"%fg¤„^\x11îŽ¤ŠÚ\x7F†\x1Dc"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0x256667A4845E11EE8EA48ADA7F861D63;
74	0.72 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"yë·õáá\x11î½YŠÚ\x7F†\x1Dc"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0x79EBB7F5E1E111EEBD598ADA7F861D63;
75	0.75 ms	SELECT * FROM `tl_files` WHERE uuid=? Parameters: [`b"Å\x1FMsB«\x11ïˆ«ŠÚ\x7F†\x1Dc"`] View formatted query View runnable query Explain query SELECT * FROM `tl_files` WHERE uuid = ? SELECT * FROM `tl_files` WHERE uuid=0xC51F4D7342AB11EF88AB8ADA7F861D63;
76	0.85 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/template/redesign24/img/demeter_logo.svg"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.`path`='files/template/redesign24/img/demeter_logo.svg' LIMIT 0,1;
77	0.78 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/template/redesign24/img/Logo_OG.png"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.`path`='files/template/redesign24/img/Logo_OG.png' LIMIT 0,1;
78	0.74 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/template/redesign24/img/bio_eu.png"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.`path`='files/template/redesign24/img/bio_eu.png' LIMIT 0,1;
79	0.74 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/template/redesign24/img/fairbio.png"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.`path`='files/template/redesign24/img/fairbio.png' LIMIT 0,1;
80	0.76 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1 Parameters: [`"files/content/content_bilder/ueber_uns/zertifizierungen/sfd-unterstuetzer-2024-logo-rahmen-160px.jpg"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.`path` = ? LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.`path`='files/content/content_bilder/ueber_uns/zertifizierungen/sfd-unterstuetzer-2024-logo-rahmen-160px.jpg' LIMIT 0,1;
81	0.98 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;
82	0.75 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;
83	0.76 ms	SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1 Parameters: [`"19"`] 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`='19' LIMIT 0,1;
84	0.90 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: [`19`] 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=19 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/standorte/standort-details/store/%C3%B6ko-markt-k%C3%B6ln-neusser-platz

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping