Symfony Profiler

Query Metrics

87 Database Queries

49 Different statements

40.99 ms Query time

0 Invalid entities

0 Managed entities

Queries


SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root'
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?)
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 = 'x85sfw_addictic'
            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 = 'x85sfw_addictic' */ 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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE'
SELECT DATABASE()
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT templates FROM tl_theme WHERE templates != ''
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(38,0,37,35,36) ORDER BY FIND_IN_SET(`tl_module`.`id`, '38,0,37,35,36')
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<=1767199860) AND (tl_content.stop='' OR tl_content.stop>1767199860) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1767199860) AND (tl_article.stop='' OR tl_article.stop>1767199860) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.published = "1" AND alias=? LIMIT 0,1
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT p1.id, EXISTS(SELECT * FROM tl_page p2 WHERE p2.pid=p1.id AND p2.type!='root' AND p2.type NOT IN ('error_401', 'error_403', 'error_404', 'error_503') AND p2.hide=0 AND p2.published=1 AND (p2.start='' OR p2.start<=1767199860) AND (p2.stop='' OR p2.stop>1767199860)) 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<=1767199860) AND (p1.stop='' OR p1.stop>1767199860) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(4,10,34) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,10,3,34')
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<=1767199860) AND (p2.stop='' OR p2.stop>1767199860)) 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<=1767199860) AND (p1.stop='' OR p1.stop>1767199860) ORDER BY p1.sorting
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(101,102,103,104) ORDER BY FIND_IN_SET(`tl_page`.`id`, '101,102,103,104')
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
SELECT * FROM tl_expertise WHERE tl_expertise.`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<=1767199860) AND (tl_article.stop='' OR tl_article.stop>1767199860) 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<=1767199860) AND (tl_content.stop='' OR tl_content.stop>1767199860) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
SELECT COUNT(*) AS count FROM tl_realisation WHERE tl_realisation.published='1'
SELECT * FROM tl_realisation WHERE tl_realisation.published='1' ORDER BY sorting LIMIT 24,12
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT * FROM tl_expertise WHERE tl_expertise.id IN(1) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '2,1')
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_expertise WHERE tl_expertise.id IN(4) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '3,1,2,4,7')
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
SELECT * FROM tl_realisation_sector ORDER BY sorting
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '1'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '2'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '3'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '4'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '5'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '6'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '7'
SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '8'
SELECT * FROM tl_realisation WHERE published = 1
SELECT * FROM tl_expertise WHERE tl_expertise.id IN(6) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '6')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(3,4) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(1) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4,1')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(5) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '5,4')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,7')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(2) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '1,2,3')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4,7')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '6')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,1,4,7')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,1,2,4,7')
SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '1,2,6,3')
SELECT tl_add_glossary.* FROM tl_add_glossary WHERE published=?
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1

#▲	Time	Info
1	0.35 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';
2	0.38 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?) Parameters: [`"realisations"`] 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 ('realisations');
3	0.24 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
4	22.36 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 = 'x85sfw_addictic' 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: [`"x85sfw_addictic" "x85sfw_addictic"`] 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 = 'x85sfw_addictic' 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 = 'x85sfw_addictic' 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 = 'x85sfw_addictic' AND t.TABLE_SCHEMA = 'x85sfw_addictic' AND t.TABLE_TYPE = 'BASE TABLE' ORDER BY ORDINAL_POSITION;
5	1.32 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: [`"x85sfw_addictic"`] 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 = 'x85sfw_addictic' ORDER BY SEQ_IN_INDEX;
6	0.82 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 = 'x85sfw_addictic' / ORDER BY k.ORDINAL_POSITION Parameters: [`"x85sfw_addictic"`] 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 = 'x85sfw_addictic' / 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 = 'x85sfw_addictic' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /!50116 AND c.CONSTRAINT_SCHEMA = 'x85sfw_addictic' / ORDER BY k.ORDINAL_POSITION;
7	2.90 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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' Parameters: [`"x85sfw_addictic"`] 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.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.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = 'x85sfw_addictic' AND t.TABLE_TYPE = 'BASE TABLE';
8	0.28 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
9	0.19 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`99`] 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`=99 LIMIT 0,1;
10	0.10 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=1 LIMIT 0,1;
11	0.20 ms	SELECT templates FROM tl_theme WHERE templates != '' Parameters: [] View formatted query View runnable query Explain query SELECT templates FROM tl_theme WHERE templates != '' SELECT templates FROM tl_theme WHERE templates != '';
12	0.32 ms	SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1 Parameters: [`10`] 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`=10 LIMIT 0,1;
13	0.22 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;
14	0.17 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(38,0,37,35,36) ORDER BY FIND_IN_SET(`tl_module`.`id`, '38,0,37,35,36') Parameters: [] View formatted query View runnable query Explain query SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(38, 0, 37, 35, 36) ORDER BY FIND_IN_SET( `tl_module`.`id`, '38,0,37,35,36' ) SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(38,0,37,35,36) ORDER BY FIND_IN_SET(`tl_module`.`id`, '38,0,37,35,36');
15	0.14 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<=1767199860) AND (tl_content.stop='' OR tl_content.stop>1767199860) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1767199860) AND (tl_article.stop='' OR tl_article.stop>1767199860) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting Parameters: [`"module" "tl_article" 3 "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 <= 1767199860 ) AND ( tl_content.stop = '' OR tl_content.stop > 1767199860 ) AND tl_article.published = 1 AND ( tl_article.start = '' OR tl_article.start <= 1767199860 ) AND ( tl_article.stop = '' OR tl_article.stop > 1767199860 ) 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=3 AND tl_article.inColumn IN ('main') AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1767199860) AND (tl_content.stop='' OR tl_content.stop>1767199860) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1767199860) AND (tl_article.stop='' OR tl_article.stop>1767199860) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting;
16	0.25 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`7`] 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`=7 LIMIT 0,1;
17	0.16 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"69ac7e9a2a4311eb84861ed4e914873c"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('69ac7e9a2a4311eb84861ed4e914873c') LIMIT 0,1;
18	0.12 ms	SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1 Parameters: [`b""" ÁR¢\n ä¤\x11ð¬¦»(\x08¿Ã """`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.`uuid` = ? LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.`uuid`=0xC152A20AE4A411F0ACA6BB2808BF90C3 LIMIT 0,1;
19	0.10 ms	SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1 Parameters: [`b"ÁR¡Øä¤\x11ð[»(\x08¿Ã"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.`uuid` = ? LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.`uuid`=0xC152A1D8E4A411F09D5BBB2808BF90C3 LIMIT 0,1;
20	0.12 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.published = "1" AND alias=? LIMIT 0,1 Parameters: [`"index"`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.published = "1" AND alias = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.published = "1" AND alias='index' LIMIT 0,1;
21	0.14 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`39`] 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`=39 LIMIT 0,1;
22	0.19 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<=1767199860) AND (p2.stop='' OR p2.stop>1767199860)) 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<=1767199860) AND (p1.stop='' OR p1.stop>1767199860) ORDER BY p1.sorting Parameters: [`99`] 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 <= 1767199860 ) AND ( p2.stop = '' OR p2.stop > 1767199860 ) ) 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 <= 1767199860 ) AND ( p1.stop = '' OR p1.stop > 1767199860 ) 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<=1767199860) AND (p2.stop='' OR p2.stop>1767199860)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=99 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<=1767199860) AND (p1.stop='' OR p1.stop>1767199860) ORDER BY p1.sorting;
23	0.14 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(4,10,34) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,10,3,34') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(4, 10, 34) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,10,3,34') SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(4,10,34) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,10,3,34');
24	0.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<=1767199860) AND (p2.stop='' OR p2.stop>1767199860)) 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<=1767199860) AND (p1.stop='' OR p1.stop>1767199860) ORDER BY p1.sorting Parameters: [`4`] 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 <= 1767199860 ) AND ( p2.stop = '' OR p2.stop > 1767199860 ) ) 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 <= 1767199860 ) AND ( p1.stop = '' OR p1.stop > 1767199860 ) 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<=1767199860) AND (p2.stop='' OR p2.stop>1767199860)) AS hasSubpages FROM tl_page p1 WHERE p1.pid=4 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<=1767199860) AND (p1.stop='' OR p1.stop>1767199860) ORDER BY p1.sorting;
25	0.12 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(101,102,103,104) ORDER BY FIND_IN_SET(`tl_page`.`id`, '101,102,103,104') Parameters: [] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(101, 102, 103, 104) ORDER BY FIND_IN_SET( `tl_page`.`id`, '101,102,103,104' ) SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(101,102,103,104) ORDER BY FIND_IN_SET(`tl_page`.`id`, '101,102,103,104');
26	0.15 ms	SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1 Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.`id` = ? LIMIT 0, 1 SELECT * FROM tl_expertise WHERE tl_expertise.`id`='3' LIMIT 0,1;
27	0.13 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`13`] 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`=13 LIMIT 0,1;
28	0.12 ms	SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1 Parameters: [`"5"`] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.`id` = ? LIMIT 0, 1 SELECT * FROM tl_expertise WHERE tl_expertise.`id`='5' LIMIT 0,1;
29	0.10 ms	SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1 Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.`id` = ? LIMIT 0, 1 SELECT * FROM tl_expertise WHERE tl_expertise.`id`='2' LIMIT 0,1;
30	0.09 ms	SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1 Parameters: [`"7"`] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.`id` = ? LIMIT 0, 1 SELECT * FROM tl_expertise WHERE tl_expertise.`id`='7' LIMIT 0,1;
31	0.31 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<=1767199860) AND (tl_article.stop='' OR tl_article.stop>1767199860) ORDER BY tl_article.sorting Parameters: [`3 "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 <= 1767199860 ) AND ( tl_article.stop = '' OR tl_article.stop > 1767199860 ) ORDER BY tl_article.sorting SELECT tl_article.* FROM tl_article WHERE tl_article.pid=3 AND tl_article.inColumn='main' AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1767199860) AND (tl_article.stop='' OR tl_article.stop>1767199860) ORDER BY tl_article.sorting;
32	0.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<=1767199860) AND (tl_content.stop='' OR tl_content.stop>1767199860) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting Parameters: [`2 "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 <= 1767199860 ) AND ( tl_content.stop = '' OR tl_content.stop > 1767199860 ) 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_article' AND tl_content.invisible=0 AND (tl_content.start='' OR tl_content.start<=1767199860) AND (tl_content.stop='' OR tl_content.stop>1767199860) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting;
33	0.19 ms	SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1 Parameters: [`40`] 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`=40 LIMIT 0,1;
34	0.13 ms	SELECT COUNT() AS count FROM tl_realisation WHERE tl_realisation.published='1' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE tl_realisation.published = '1' SELECT COUNT(*) AS count FROM tl_realisation WHERE tl_realisation.published='1';
35	0.61 ms	SELECT * FROM tl_realisation WHERE tl_realisation.published='1' ORDER BY sorting LIMIT 24,12 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation WHERE tl_realisation.published = '1' ORDER BY sorting LIMIT 24, 12 SELECT * FROM tl_realisation WHERE tl_realisation.published='1' ORDER BY sorting LIMIT 24,12;
36	0.35 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"2241d6f59df411eb85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2241d6f59df411eb85942aa699125b76') LIMIT 0,1;
37	0.16 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
38	0.16 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`12`] View formatted query View runnable query Explain query SELECT tl_page.* FROM tl_page WHERE tl_page.`id` = ? LIMIT 0, 1 SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=12 LIMIT 0,1;
39	0.24 ms	SELECT * FROM tl_expertise WHERE tl_expertise.id IN(1) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '2,1') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.id IN(1) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '2,1') SELECT * FROM tl_expertise WHERE tl_expertise.id IN(1) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '2,1');
40	0.45 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"6eb28c4cdf7411ed89c22aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('6eb28c4cdf7411ed89c22aa699125b76') LIMIT 0,1;
41	0.11 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
42	0.25 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"be68754ad46011ed89c22aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('be68754ad46011ed89c22aa699125b76') LIMIT 0,1;
43	0.12 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
44	0.20 ms	SELECT * FROM tl_expertise WHERE tl_expertise.id IN(4) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '3,1,2,4,7') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.id IN(4) ORDER BY FIND_IN_SET( `tl_expertise`.`id`, '3,1,2,4,7' ) SELECT * FROM tl_expertise WHERE tl_expertise.id IN(4) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '3,1,2,4,7');
45	0.19 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"092fdd5a9df911eb85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('092fdd5a9df911eb85942aa699125b76') LIMIT 0,1;
46	0.10 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
47	0.12 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"43b190192e6511eb84861ed4e914873c"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('43b190192e6511eb84861ed4e914873c') LIMIT 0,1;
48	0.10 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
49	0.12 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"cf7804ae5cc311eb85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('cf7804ae5cc311eb85942aa699125b76') LIMIT 0,1;
50	0.09 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
51	0.11 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"63b287040bc011ec85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('63b287040bc011ec85942aa699125b76') LIMIT 0,1;
52	0.10 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
53	0.11 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"79b1eb53463011ec85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('79b1eb53463011ec85942aa699125b76') LIMIT 0,1;
54	0.09 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
55	0.29 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"89cbf166a51a11f088d92aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('89cbf166a51a11f088d92aa699125b76') LIMIT 0,1;
56	0.11 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
57	0.22 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"6fec61ed76ce11ed81651ed4e914873c"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('6fec61ed76ce11ed81651ed4e914873c') LIMIT 0,1;
58	0.10 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
59	0.20 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"d8828bf181c911eb85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('d8828bf181c911eb85942aa699125b76') LIMIT 0,1;
60	0.10 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
61	0.19 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`"5b954a9df08111eb85942aa699125b76"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('5b954a9df08111eb85942aa699125b76') LIMIT 0,1;
62	0.10 ms	SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1 Parameters: [`""`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.uuid = UNHEX(?) LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('') LIMIT 0,1;
63	0.12 ms	SELECT * FROM tl_realisation_sector ORDER BY sorting Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_sector ORDER BY sorting SELECT * FROM tl_realisation_sector ORDER BY sorting;
64	0.09 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '1' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '1' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '1';
65	0.08 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '2' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '2' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '2';
66	0.07 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '3' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '3' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '3';
67	0.07 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '4' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '4' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '4';
68	0.06 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '5' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '5' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '5';
69	0.06 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '6' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '6' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '6';
70	0.06 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '7' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '7' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '7';
71	0.06 ms	SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '8' Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS count FROM tl_realisation WHERE published = '1' AND sector = '8' SELECT COUNT(*) AS count FROM tl_realisation WHERE published = '1' AND sector = '8';
72	0.38 ms	SELECT * FROM tl_realisation WHERE published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation WHERE published = 1 SELECT * FROM tl_realisation WHERE published = 1;
73	0.12 ms	SELECT * FROM tl_expertise WHERE tl_expertise.id IN(6) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '6') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_expertise WHERE tl_expertise.id IN(6) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '6') SELECT * FROM tl_expertise WHERE tl_expertise.id IN(6) ORDER BY FIND_IN_SET(`tl_expertise`.`id`, '6');
74	0.11 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(3,4) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(3, 4) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '3,4' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(3,4) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4');
75	0.08 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(1) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4,1') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(1) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '3,4,1' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(1) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4,1');
76	0.08 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(5) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '5,4') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(5) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '5,4' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(5) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '5,4');
77	0.07 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,7') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '3,7' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,7');
78	0.07 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(2) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '1,2,3') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(2) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '1,2,3' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(2) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '1,2,3');
79	0.06 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4,7') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '3,4,7' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,4,7');
80	0.06 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '6') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '6' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '6');
81	0.07 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,1,4,7') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '3,1,4,7' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,1,4,7');
82	0.06 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,1,2,4,7') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '3,1,2,4,7' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(7) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '3,1,2,4,7');
83	0.06 ms	SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '1,2,6,3') Parameters: [] View formatted query View runnable query Explain query SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET( `tl_realisation_category`.`id`, '1,2,6,3' ) SELECT * FROM tl_realisation_category WHERE tl_realisation_category.id IN(6) ORDER BY FIND_IN_SET(`tl_realisation_category`.`id`, '1,2,6,3');
84	0.24 ms	SELECT tl_add_glossary.* FROM tl_add_glossary WHERE published=? Parameters: [`"1"`] View formatted query View runnable query Explain query SELECT tl_add_glossary.* FROM tl_add_glossary WHERE published = ? SELECT tl_add_glossary.* FROM tl_add_glossary WHERE published='1';
85	0.21 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`17`] 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`=17 LIMIT 0,1;
86	0.24 ms	SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1 Parameters: [`100`] 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`=100 LIMIT 0,1;
87	0.42 ms	SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1 Parameters: [`b"ºu³eä¤\x11ð§Èú\x16>Ã6ä"`] View formatted query View runnable query Explain query SELECT * FROM tl_files WHERE tl_files.`uuid` = ? LIMIT 0, 1 SELECT * FROM tl_files WHERE tl_files.`uuid`=0xBA75B365E4A411F0A7C8FA163EC336E4 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://addictic.ci-com.fr/realisations?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping