Query Metrics
29
Database Queries
24
Different statements
41.40 ms
Query time
0
Invalid entities
0
Managed entities
Queries
#▲ | 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'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 "tl_content.id=15" has been created by duplicating record "tl_content.id=14" (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&do=article&id=14&mode=1&pid=14&ptable=tl_content&ref=ogPEk7vN&rt=297d4b2.BjmifxSvZiWEFnQFT2on7yFbqDqn_CnsBH3inX-HtzM.bUz2HlP3BWnTVSZOBV8UuW4o_VLrslHeUTa6pRvs5mxCAPUsbcENcNIkNQ&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.