GET https://addictic.ci-com.fr/article/les-rebrandings-marquants-de-2024-un-vent-de-renouveau

Query Metrics

66 Database Queries
29 Different statements
44.85 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.36 ms
SELECT urlPrefix, urlSuffix FROM tl_page WHERE type='root'
Parameters:
[]
2 0.76 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?)
Parameters:
[
  "article/les-rebrandings-marquants-de-2024-un-vent-de-renouveau"
  "article"
]
3 0.16 ms
SELECT DATABASE()
Parameters:
[]
4 23.11 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"
]
5 1.27 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"
]
6 0.91 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"
]
7 3.00 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"
]
8 0.28 ms
SELECT DATABASE()
Parameters:
[]
9 0.16 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  34
]
10 0.10 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  99
]
11 0.09 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  1
]
12 0.19 ms
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
13 0.21 ms
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
  11
]
14 0.18 ms
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
  1
]
15 0.13 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:
[]
16 0.77 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<=1767202320) AND (tl_content.stop='' OR tl_content.stop>1767202320) AND tl_article.published=1 AND (tl_article.start='' OR tl_article.start<=1767202320) AND (tl_article.stop='' OR tl_article.stop>1767202320) AND tl_content.tstamp!=0 ORDER BY tl_content.pid, tl_content.sorting
Parameters:
[
  "module"
  "tl_article"
  14
  "main"
]
17 0.21 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  7
]
18 0.16 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "69ac7e9a2a4311eb84861ed4e914873c"
]
19 0.10 ms
SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1
Parameters:
[
  b"""
    ÁR¢\n
    ä¤\x11𬦻(\x08¿Ã
    """
]
20 0.07 ms
SELECT * FROM tl_files WHERE tl_files.`uuid`=? LIMIT 0,1
Parameters:
[
  b"ÁR¡Øä¤\x11ð[»(\x08¿Ã"
]
21 0.11 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.published = "1" AND alias=? LIMIT 0,1
Parameters:
[
  "index"
]
22 0.16 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  39
]
23 0.77 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<=1767202320) AND (p2.stop='' OR p2.stop>1767202320)) 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<=1767202320) AND (p1.stop='' OR p1.stop>1767202320) ORDER BY p1.sorting
Parameters:
[
  99
]
24 0.12 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(4,10,3) ORDER BY FIND_IN_SET(`tl_page`.`id`, '4,10,3,34')
Parameters:
[]
25 0.45 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<=1767202320) AND (p2.stop='' OR p2.stop>1767202320)) 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<=1767202320) AND (p1.stop='' OR p1.stop>1767202320) ORDER BY p1.sorting
Parameters:
[
  4
]
26 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:
[]
27 0.10 ms
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
Parameters:
[
  "3"
]
28 0.11 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
  13
]
29 0.08 ms
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
Parameters:
[
  "5"
]
30 0.07 ms
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
Parameters:
[
  "2"
]
31 0.06 ms
SELECT * FROM tl_expertise WHERE tl_expertise.`id`=? LIMIT 0,1
Parameters:
[
  "7"
]
32 0.62 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<=1767202320) AND (tl_article.stop='' OR tl_article.stop>1767202320) ORDER BY tl_article.sorting
Parameters:
[
  14
  "main"
]
33 0.58 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<=1767202320) AND (tl_content.stop='' OR tl_content.stop>1767202320) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  17
  "tl_article"
]
34 0.18 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  23
]
35 0.19 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
  10
]
36 0.37 ms
SELECT tl_news.* FROM tl_news WHERE tl_news.`alias`=? LIMIT 0,1
Parameters:
[
  "les-rebrandings-marquants-de-2024-un-vent-de-renouveau"
]
37 0.32 ms
SELECT * FROM tl_news_category WHERE tl_news_category.id IN(1,2,6) ORDER BY FIND_IN_SET(`tl_news_category`.`id`, '1,2,6')
Parameters:
[]
38 0.72 ms
SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(2) AND tl_news.id NOT IN(404) AND tl_news.published='1' AND (tl_news.start='' OR tl_news.start<=1767202320) AND (tl_news.stop='' OR tl_news.stop>1767202320) AND (tl_news.categories LIKE '%s:1:"1";%' OR tl_news.categories LIKE '%s:1:"2";%' OR tl_news.categories LIKE '%s:1:"6";%' ) ORDER BY tl_news.date DESC LIMIT 0,3
Parameters:
[]
39 0.11 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "6c863bb0d3e711ef9c7d2aa699125b76"
]
40 0.86 ms
SELECT tl_content.* FROM tl_content WHERE tl_content.ptable = 'tl_news' AND pid=? ORDER BY sorting
Parameters:
[
  404
]
41 0.41 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"Æž—\x02É\x1A\x11ïœ}*¦™\x12[v"
]
42 0.24 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-cdiscount-2024.webp"
]
43 0.36 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"Æò€ÖÉ\x1A\x11ïœ}*¦™\x12[v"
]
44 0.24 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-cdiscount-2024-2-02.webp"
]
45 0.29 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"×4fÓÉ\x1A\x11ïœ}*¦™\x12[v"
]
46 0.20 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-tupperware-2024.webp"
]
47 0.23 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"×yŸ\x14É\x1A\x11ïœ}*¦™\x12[v"
]
48 0.24 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-tupperware-2024-02.webp"
]
49 0.38 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"Î!U>É\x1A\x11ïœ}*¦™\x12[v"
]
50 0.23 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-deezer-2024-02.webp"
]
51 0.27 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"Í슕É\x1A\x11ïœ}*¦™\x12[v"
]
52 0.23 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-deezer-2024.webp"
]
53 0.29 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"ÒŒ…%É\x1A\x11ïœ}*¦™\x12[v"
]
54 0.19 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-kleenex-2024-07.webp"
]
55 0.20 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"ÒTÍŽÉ\x1A\x11ïœ}*¦™\x12[v"
]
56 0.18 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-kleenex-2024-02-08.webp"
]
57 0.25 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"ÐyùlÉ\x1A\x11ïœ}*¦™\x12[v"
]
58 0.18 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-jaguar-2024.webp"
]
59 0.24 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"ÐÆH_É\x1A\x11ïœ}*¦™\x12[v"
]
60 0.19 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-jaguar-2024-02.webp"
]
61 0.25 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"ÔbfvÉ\x1A\x11ïœ}*¦™\x12[v"
]
62 0.19 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-ligue1-2024-11.webp"
]
63 0.35 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"Ì\x16PÏÉ\x1A\x11ïœ}*¦™\x12[v"
]
64 0.24 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-decathlon-2024-2-14.webp"
]
65 0.25 ms
SELECT * FROM `tl_files` WHERE uuid=?
Parameters:
[
  b"ËĶdÉ\x1A\x11ïœ}*¦™\x12[v"
]
66 0.20 ms
SELECT * FROM tl_files WHERE tl_files.`path`=? LIMIT 0,1
Parameters:
[
  "files/Images/Actualités/2025/7-rebranding-2024/refonte-graphique-decathlon-2024-13.webp"
]

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.