Query Metrics

29 Database Queries
24 Different statements
41.40 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.61 ms
SELECT * FROM tl_user WHERE `username`=? LIMIT 0,1
Parameters:
[
  "admin"
]
2 0.21 ms
SELECT DATABASE()
Parameters:
[]
3 17.55 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 = 'vq8p3p_app_contao'
            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:
[
  "vq8p3p_app_contao"
  "vq8p3p_app_contao"
]
4 1.24 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:
[
  "vq8p3p_app_contao"
]
5 0.97 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 = 'vq8p3p_app_contao' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "vq8p3p_app_contao"
]
6 11.42 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:
[
  "vq8p3p_app_contao"
]
7 0.18 ms
SELECT DATABASE()
Parameters:
[]
8 0.26 ms
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[]
9 0.49 ms
SELECT * FROM tl_content WHERE id IN (?)
Parameters:
[
  14
]
10 0.82 ms
SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=?
Parameters:
[
  13
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
]
11 0.28 ms
SELECT id, type FROM tl_page WHERE id=(SELECT pid FROM tl_article WHERE id=?)
Parameters:
[
  2
]
12 0.76 ms
SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=?
Parameters:
[
  13
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
]
13 0.68 ms
SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=? UNION SELECT id, @pid:=pid AS pid, ptable FROM tl_content WHERE id=@pid AND ptable=?
Parameters:
[
  13
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
  "tl_content"
]
14 0.35 ms
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
  "14"
]
15 0.18 ms
SELECT type FROM tl_content WHERE id=?
Parameters:
[
  13
]
16 0.35 ms
SELECT cteAlias, TRUE FROM tl_content WHERE type='alias' GROUP BY cteAlias
Parameters:
[]
17 0.38 ms
SELECT * FROM tl_content WHERE id IN (?)
Parameters:
[
  13
]
18 0.28 ms
SELECT * FROM tl_article WHERE id IN (?)
Parameters:
[
  2
]
19 0.99 ms
SHOW FULL COLUMNS FROM tl_content
Parameters:
[]
20 0.30 ms
SHOW INDEXES FROM `tl_content`
Parameters:
[]
21 0.24 ms
SELECT pid, sorting FROM tl_content WHERE id=? LIMIT 0,1
Parameters:
[
  "14"
]
22 0.25 ms
SELECT MIN(sorting) AS sorting FROM tl_content WHERE pid=? AND sorting>?
Parameters:
[
  13
  128
]
23 0.64 ms
INSERT INTO tl_content (`type`, `addImage`, `showPreview`, `inline`, `overwriteMeta`, `fullsize`, `thead`, `tfoot`, `tleft`, `sortable`, `closeSections`, `target`, `overwriteLink`, `useImage`, `useHomeDir`, `metaIgnore`, `splashImage`, `sliderContinuous`, `protected`, `invisible`, `com_moderate`, `com_bbcode`, `com_disableCaptcha`, `com_requireLogin`, `pid`, `ptable`, `sorting`, `tstamp`, `headline`, `sectionHeadline`, `text`, `singleSRC`, `alt`, `imageTitle`, `size`, `imageUrl`, `caption`, `floating`, `html`, `unfilteredHtml`, `listtype`, `listitems`, `tableitems`, `summary`, `sortIndex`, `sortOrder`, `mooHeadline`, `mooStyle`, `mooClasses`, `highlight`, `markdownSource`, `code`, `url`, `titleText`, `linkTitle`, `embed`, `rel`, `multiSRC`, `perRow`, `perPage`, `numberOfItems`, `sortBy`, `galleryTpl`, `customTpl`, `playerSRC`, `youtube`, `vimeo`, `posterSRC`, `playerSize`, `playerOptions`, `playerStart`, `playerStop`, `playerCaption`, `playerAspect`, `playerPreload`, `playerColor`, `youtubeOptions`, `vimeoOptions`, `sliderDelay`, `sliderSpeed`, `sliderStartSlide`, `data`, `cteAlias`, `articleAlias`, `article`, `form`, `module`, `groups`, `cssID`, `start`, `stop`, `com_order`, `com_perPage`, `com_template`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "text"
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  13
  "tl_content"
  256
  0
  "a:2:{s:4:"unit";s:2:"h3";s:5:"value";s:22:"Michel TERCIER (copie)";}"
  "a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}"
  """
    <p>Président d&#39;Honneur</p>\n
    <p><small>Nommé en 2013</small></p>
    """
  null
  ""
  ""
  ""
  null
  ""
  "above"
  null
  null
  ""
  null
  null
  ""
  0
  "ascending"
  ""
  ""
  ""
  ""
  "sourceText"
  null
  null
  ""
  ""
  ""
  ""
  null
  4
  0
  0
  ""
  ""
  "content_element/text/text_card_comite"
  null
  ""
  ""
  null
  ""
  null
  ""
  ""
  ""
  ""
  ""
  ""
  null
  null
  0
  300
  0
  null
  0
  0
  0
  0
  0
  null
  "a:2:{i:0;s:0:"";i:1;s:0:"";}"
  ""
  ""
  "ascending"
  0
  ""
]
24 0.49 ms
SELECT * FROM tl_content WHERE pid=? AND ptable=? ORDER BY sorting, id
Parameters:
[
  "14"
  "tl_content"
]
25 0.23 ms
SELECT pid, ptable FROM tl_content WHERE id=? LIMIT 0,1
Parameters:
[
  "15"
]
26 0.19 ms
SELECT pid, ptable FROM tl_content WHERE id=? LIMIT 0,1
Parameters:
[
  13
]
27 0.17 ms
SELECT pid FROM tl_article WHERE id=? LIMIT 0,1
Parameters:
[
  2
]
28 0.34 ms
INSERT INTO tl_log (tstamp, text, source, action, username, func, browser, uri, page) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "1761079366"
  "A new entry &quot;tl_content.id=15&quot; has been created by duplicating record &quot;tl_content.id=14&quot; (parent records: tl_content.id=13, tl_article.id=2, tl_page.id=3)"
  "BE"
  "GENERAL"
  "admin"
  "Contao\DC_Table::copy"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36"
  "https://afvts.ch/contao?act=copy&amp;do=article&amp;id=14&amp;mode=1&amp;pid=14&amp;ptable=tl_content&amp;ref=ogPEk7vN&amp;rt=297d4b2.BjmifxSvZiWEFnQFT2on7yFbqDqn_CnsBH3inX-HtzM.bUz2HlP3BWnTVSZOBV8UuW4o_VLrslHeUTa6pRvs5mxCAPUsbcENcNIkNQ&amp;table=tl_content"
  0
]
29 0.54 ms
UPDATE tl_user SET session = ? WHERE id = ?
Parameters:
[
  "a:7:{s:15:"fieldset_states";a:5:{s:7:"tl_user";a:3:{s:14:"backend_legend";i:1;s:12:"theme_legend";i:1;s:15:"password_legend";i:1;}s:9:"tl_layout";a:2:{s:13:"static_legend";i:1;s:13:"expert_legend";i:1;}s:10:"tl_content";a:5:{s:13:"expert_legend";i:1;s:16:"protected_legend";i:1;s:15:"template_legend";i:1;s:16:"invisible_legend";i:1;s:15:"sortable_legend";i:1;}s:13:"tl_user_group";a:1:{s:12:"alexf_legend";i:1;}s:9:"tl_module";a:2:{s:13:"expert_legend";i:0;s:15:"template_legend";i:1;}}s:11:"new_records";a:1:{s:10:"tl_content";a:1:{i:0;s:2:"15";}}s:12:"tl_page_tree";a:2:{i:1;i:1;i:2;i:0;}s:12:"tl_page_node";s:1:"0";s:23:"tl_article_tl_page_tree";a:5:{i:2;i:0;i:1;i:1;i:3;i:0;i:4;i:0;i:5;i:0;}s:8:"filetree";a:9:{s:8:"13c901bc";i:1;s:8:"c07d040f";i:1;s:8:"1217e95d";i:1;s:8:"003af690";i:1;s:8:"04f3e71f";i:1;s:8:"2e8de4e7";i:1;s:8:"323b7277";i:1;s:8:"875f3d1c";i:1;s:8:"3da2eb2c";i:1;}s:15:"checkbox_groups";a:43:{s:25:"cbc_modules_présentation";i:1;s:19:"cbc_modules_comptes";i:1;s:20:"cbc_modules_système";i:1;s:31:"cbc_frontendModules_utilisateur";i:1;s:32:"cbc_frontendModules_applications";i:1;s:26:"cbc_frontendModules_divers";i:1;s:23:"cbc_frontendModules_faq";i:1;s:24:"cbc_frontendModules_news";i:1;s:43:"cbc_frontendModules_calendrier-événements";i:1;s:30:"cbc_frontendModules_newsletter";i:1;s:28:"cbc_elements_legacy-elements";i:1;s:30:"cbc_elements_éléments-inclus";i:1;s:19:"cbc_elements_divers";i:1;s:36:"cbc_elements_éléments-multimédias";i:1;s:28:"cbc_elements_éléments-lien";i:1;s:31:"cbc_elements_éléments-fichier";i:1;s:23:"cbc_alexf_tl_user_group";i:0;s:17:"cbc_alexf_tl_user";i:0;s:18:"cbc_alexf_tl_theme";i:0;s:25:"cbc_alexf_tl_preview_link";i:0;s:17:"cbc_alexf_tl_page";i:0;s:34:"cbc_alexf_tl_newsletter_recipients";i:0;s:31:"cbc_alexf_tl_newsletter_channel";i:0;s:23:"cbc_alexf_tl_newsletter";i:0;s:25:"cbc_alexf_tl_news_archive";i:0;s:17:"cbc_alexf_tl_news";i:0;s:19:"cbc_alexf_tl_module";i:0;s:25:"cbc_alexf_tl_member_group";i:0;s:19:"cbc_alexf_tl_member";i:0;s:19:"cbc_alexf_tl_layout";i:0;s:28:"cbc_alexf_tl_image_size_item";i:0;s:23:"cbc_alexf_tl_image_size";i:0;s:23:"cbc_alexf_tl_form_field";i:0;s:17:"cbc_alexf_tl_form";i:0;s:18:"cbc_alexf_tl_files";i:0;s:25:"cbc_alexf_tl_faq_category";i:0;s:16:"cbc_alexf_tl_faq";i:0;s:20:"cbc_alexf_tl_content";i:0;s:21:"cbc_alexf_tl_comments";i:0;s:26:"cbc_alexf_tl_calendar_feed";i:0;s:28:"cbc_alexf_tl_calendar_events";i:0;s:21:"cbc_alexf_tl_calendar";i:0;s:20:"cbc_alexf_tl_article";i: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.