Symfony Profiler

Query Metrics

82 Database Queries

46 Different statements

164.88 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 * 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775297760) AND (tl_article.stop='' OR tl_article.stop>1775297760) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(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<=1775297760) AND (tl_article.stop='' OR tl_article.stop>1775297760) 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT * FROM tl_page WHERE id=? LIMIT 1
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT
                *
            FROM tl_storelocator_stores
            WHERE
                published='1'
                AND pid IN(1)
                AND country = 'de' 
                
            ORDER BY highlight DESC
            LIMIT 25
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT
                id,
                alias,
                map_pin
            FROM tl_storelocator_categories
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT * FROM `tl_files` WHERE uuid=?
SELECT tl_files.* FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1

#▲	Time	Info
1	1.16 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	0.73 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	2.01 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	1.94 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.94 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.07 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	0.96 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.49 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.90 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.49 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.36 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.81 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.92 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.80 ms	SELECT * FROM ctlg_category ORDER BY title DESC Parameters: [] View formatted query View runnable query Explain query SELECT * FROM ctlg_category ORDER BY title DESC SELECT * FROM ctlg_category ORDER BY title DESC;
16	1.05 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.68 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
18	51.17 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.51 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.27 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.32 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.94 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
23	1.05 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.03 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?) Parameters: [`"dls-vor-ort/standorte-dls-läden-märkte" "dls-vor-ort"`] 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 ('dls-vor-ort/standorte-dls-läden-märkte','dls-vor-ort');
25	0.96 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;
26	0.99 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;
27	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;
28	0.95 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?) Parameters: [`"dls-vor-ort/standorte-dls-läden-märkte" "dls-vor-ort"`] 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 ('dls-vor-ort/standorte-dls-läden-märkte','dls-vor-ort');
29	1.02 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 != '';
30	1.41 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;
31	1.11 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;
32	1.38 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;
33	1.57 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';
34	1.34 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	0.92 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	0.84 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;
37	0.86 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;
38	1.02 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;
39	1.98 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');
40	1.42 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775297760) AND (tl_article.stop='' OR tl_article.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting Parameters: [`"module" "tl_article" 69 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_article.published = 1 AND ( tl_article.start = '' OR tl_article.start <= 1775297760 ) AND ( tl_article.stop = '' OR tl_article.stop > 1775297760 ) 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=69 AND tl_article.inColumn IN ('main') AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775297760) AND (tl_article.stop='' OR tl_article.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting;
41	2.00 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;
42	1.63 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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 <= 1775297760 ) AND ( p2.stop = '' OR p2.stop > 1775297760 ) ) 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 <= 1775297760 ) AND ( p1.stop = '' OR p1.stop > 1775297760 ) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) ORDER BY p1.sorting;
43	1.06 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');
44	1.48 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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 <= 1775297760 ) AND ( p2.stop = '' OR p2.stop > 1775297760 ) ) 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 <= 1775297760 ) AND ( p1.stop = '' OR p1.stop > 1775297760 ) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) ORDER BY p1.sorting;
45	1.13 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');
46	1.76 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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 <= 1775297760 ) AND ( p2.stop = '' OR p2.stop > 1775297760 ) ) 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 <= 1775297760 ) AND ( p1.stop = '' OR p1.stop > 1775297760 ) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) ORDER BY p1.sorting;
47	1.06 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');
48	1.20 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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 <= 1775297760 ) AND ( p2.stop = '' OR p2.stop > 1775297760 ) ) 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 <= 1775297760 ) AND ( p1.stop = '' OR p1.stop > 1775297760 ) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) ORDER BY p1.sorting;
49	0.96 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');
50	1.13 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) 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 <= 1775297760 ) AND ( p2.stop = '' OR p2.stop > 1775297760 ) ) 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 <= 1775297760 ) AND ( p1.stop = '' OR p1.stop > 1775297760 ) 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<=1775297760) AND (p2.stop='' OR p2.stop>1775297760)) 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<=1775297760) AND (p1.stop='' OR p1.stop>1775297760) ORDER BY p1.sorting;
51	0.85 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(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(70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70');
52	1.01 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;
53	0.75 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;
54	0.89 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;
55	1.08 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;
56	1.33 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;
57	1.12 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<=1775297760) AND (tl_article.stop='' OR tl_article.stop>1775297760) ORDER BY tl_article.sorting Parameters: [`69 "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 <= 1775297760 ) AND ( tl_article.stop = '' OR tl_article.stop > 1775297760 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=69 AND tl_article.inColumn='main' AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1775297760) AND (tl_article.stop='' OR tl_article.stop>1775297760) ORDER BY tl_article.sorting;
58	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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`131 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=131 AND tl_content.ptable='tl_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
59	1.92 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`81`] 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`=81 LIMIT 0,1;
60	1.20 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;
61	1.89 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`78`] 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`=78 LIMIT 0,1;
62	1.63 ms	SELECT * FROM tl_storelocator_stores WHERE published='1' AND pid IN(1) AND country = 'de' ORDER BY highlight DESC LIMIT 25 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_storelocator_stores WHERE published = '1' AND pid IN(1) AND country = 'de' ORDER BY highlight DESC LIMIT 25 SELECT * FROM tl_storelocator_stores WHERE published='1' AND pid IN(1) AND country = 'de' ORDER BY highlight DESC LIMIT 25;
63	1.05 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;
64	0.95 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`21`] 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`=21 LIMIT 0,1;
65	1.23 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`2 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) 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_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
66	0.87 ms	INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`"1775297773" "Error parsing geocords (,) for store ID 5" "FE" "ERROR" "N/A" "numero2\StoreLocator\StoreLocator::parseStoreData" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "https://dls.c5.bargon.net/dls-vor-ort/standorte-dls-l%C3%A4den-m%C3%A4rkte" 69`] View formatted query View runnable query Explain query INSERT INTO tl_log ( tstamp, text, source, action, username, func, browser, uri, page ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES ('1775297773', 'Error parsing geocords (,) for store ID 5', 'FE', 'ERROR', 'N/A', 'numero2\\StoreLocator\\StoreLocator::parseStoreData', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'https://dls.c5.bargon.net/dls-vor-ort/standorte-dls-l%C3%A4den-m%C3%A4rkte', 69);
67	1.19 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`5 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) 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_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
68	1.23 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`6 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=6 AND tl_content.ptable='tl_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
69	1.07 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`7 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=7 AND tl_content.ptable='tl_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
70	1.15 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`8 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=8 AND tl_content.ptable='tl_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
71	1.82 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) 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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
72	1.60 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`149 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=149 AND tl_content.ptable='tl_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
73	1.52 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`160 "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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) AND tl_content.tstamp != 0 ORDER BY tl_content.sorting SELECT tl_content.* FROM tl_content WHERE tl_content.pid=160 AND tl_content.ptable='tl_storelocator_stores' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
74	1.01 ms	SELECT id, alias, map_pin FROM tl_storelocator_categories Parameters: [] View formatted query View runnable query Explain query SELECT id, alias, map_pin FROM tl_storelocator_categories SELECT id, alias, map_pin FROM tl_storelocator_categories;
75	0.90 ms	SELECT id FROM tl_catalog WHERE tablename=? LIMIT 0,1 Parameters: [`"tl_storelocator_categories"`] 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_categories' LIMIT 0,1;
76	0.89 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;
77	0.80 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"44af955351a811e69e21001c42000273"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX('44af955351a811e69e21001c42000273') LIMIT 0,1;
78	0.77 ms	SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"8ac7dec5c08411e6b371001c42000273"`] View formatted query View runnable query Explain query SELECT tl_files.* FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX('8ac7dec5c08411e6b371001c42000273') LIMIT 0,1;
79	0.99 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;
80	1.54 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) 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 <= 1775297760 ) AND ( tl_content.stop = '' OR tl_content.stop > 1775297760 ) 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<=1775297760) AND (tl_content.stop='' OR tl_content.stop>1775297760) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
81	0.97 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;
82	1.09 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;

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/dls-vor-ort/standorte-dls-l%C3%A4den-m%C3%A4rkte

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping