Query Metrics
80
Database Queries
46
Different statements
85.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
15.81 ms (18.39%) |
15 |
SELECT id FROM tl_catalog WHERE tablename = ? LIMIT 0,1
Parameters:
[
"tl_cms_settings"
]
|
|
6.38 ms (7.42%) |
6 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`type`=?
Parameters:
[
"root"
]
|
|
5.92 ms (6.89%) |
5 |
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='' AND p2.published='1' AND (p2.start='' OR p2.start<=1769982000) AND (p2.stop='' OR p2.stop>1769982000)) 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='' AND p1.published='1' AND (p1.start='' OR p1.start<=1769982000) AND (p1.stop='' OR p1.stop>1769982000) ORDER BY p1.sorting
Parameters:
[
1
]
|
|
3.37 ms (3.93%) |
2 |
SELECT tl_content.* FROM tl_content WHERE tl_content.pid=? AND (tl_content.ptable=? OR tl_content.ptable='') AND tl_content.invisible='' AND (tl_content.start='' OR tl_content.start<=1769982000) AND (tl_content.stop='' OR tl_content.stop>1769982000) AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[ 20 "tl_article" ] |
|
3.28 ms (3.82%) |
3 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id=? LIMIT 0,1
Parameters:
[
"64"
]
|
|
3.12 ms (3.63%) |
2 |
SELECT tl_module.* FROM tl_module WHERE tl_module.`id`=? LIMIT 0,1
Parameters:
[
76
]
|
|
2.72 ms (3.17%) |
2 |
SELECT tl_page.* FROM tl_page WHERE BINARY tl_page.alias=? AND tl_page.published='1' AND (tl_page.start='' OR tl_page.start<=1769982000) AND (tl_page.stop='' OR tl_page.stop>1769982000)
Parameters:
[
"standorte/standort-details"
]
|
|
2.46 ms (2.87%) |
1 |
SELECT *, (SELECT tstamp FROM tl_theme WHERE tl_theme.id=tl_style_sheet.pid) AS tstamp3, (SELECT MAX(tstamp) FROM tl_style WHERE tl_style.pid=tl_style_sheet.id) AS tstamp2, (SELECT COUNT(*) FROM tl_style WHERE tl_style.selector='@font-face' AND tl_style.invisible='' AND tl_style.pid=tl_style_sheet.id) AS hasFontFace FROM tl_style_sheet WHERE id IN (5,2,3,7,8,9,11,13,14,15,17,16,18,19,20,21) ORDER BY FIND_IN_SET(`id`, '5,2,3,7,8,9,11,13,14,15,17,16,18,19,20,21')
Parameters:
[] |
|
2.16 ms (2.51%) |
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')
Parameters:
[] |
|
2.11 ms (2.45%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"c3_dls"
]
|
|
1.90 ms (2.21%) |
2 |
SELECT tl_page.* FROM tl_page WHERE tl_page.`id`=? LIMIT 0,1
Parameters:
[
76
]
|
|
1.87 ms (2.17%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
1.83 ms (2.13%) |
2 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias IN (?,?,?)
Parameters:
[ "standorte/standort-details/dls-hennef" "standorte/standort-details" "standorte" ] |
|
1.62 ms (1.89%) |
1 |
SELECT tl_content.* FROM tl_content WHERE tl_content.type in ('cms_overlay') AND tl_content.ptable=? AND tl_content.invisible=? AND tl_content.cms_pages_scope!=? AND tl_content.cms_pages_scope!=?
Parameters:
[ "tl_cms_conversion_item" "" "" "none" ] |
|
1.55 ms (1.80%) |
2 |
SELECT * FROM tl_catalog WHERE `tablename` = ? LIMIT 0,1
Parameters:
[ "tl_page" "1" ] |
|
1.50 ms (1.75%) |
2 |
SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('9e7d6fd8a4ca11e6ac25001c42000273'),UNHEX('e4696c8e908911e68044001c42000273'),UNHEX('55bc4b40bbce11e6b371001c42000273'),UNHEX('b363117e8ad311e68044001c42000273'),UNHEX('1021d5ac8ecc11e68044001c42000273'),UNHEX('3804a3d74f4811e69e21001c42000273'),UNHEX('3804a3a94f4811e69e21001c42000273'),UNHEX('1cfb5efe5e8511e886060cc47a76f45e'),UNHEX('f31522343f7b11efa0078ada7f861d63'),UNHEX('60e9e37968d211ee881f8ada7f861d63'),UNHEX('60e9e36568d211ee881f8ada7f861d63'),UNHEX('60e9e35a68d211ee881f8ada7f861d63'),UNHEX('d5434da968d411ee881f8ada7f861d63'),UNHEX('60e9e33b68d211ee881f8ada7f861d63'),UNHEX('60f1e4f368d211ee881f8ada7f861d63'),UNHEX('3b6e2b21555a11ef88ab8ada7f861d63'),UNHEX('30b1f1605bcc11ef88ab8ada7f861d63')) ORDER BY tl_files.uuid!=UNHEX('9e7d6fd8a4ca11e6ac25001c42000273'), tl_files.uuid!=UNHEX('e4696c8e908911e68044001c42000273'), tl_files.uuid!=UNHEX('55bc4b40bbce11e6b371001c42000273'), tl_files.uuid!=UNHEX('b363117e8ad311e68044001c42000273'), tl_files.uuid!=UNHEX('1021d5ac8ecc11e68044001c42000273'), tl_files.uuid!=UNHEX('3804a3d74f4811e69e21001c42000273'), tl_files.uuid!=UNHEX('3804a3a94f4811e69e21001c42000273'), tl_files.uuid!=UNHEX('1cfb5efe5e8511e886060cc47a76f45e'), tl_files.uuid!=UNHEX('f31522343f7b11efa0078ada7f861d63'), tl_files.uuid!=UNHEX('60e9e37968d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e36568d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e35a68d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('d5434da968d411ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60e9e33b68d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('60f1e4f368d211ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('3b6e2b21555a11ef88ab8ada7f861d63'), tl_files.uuid!=UNHEX('30b1f1605bcc11ef88ab8ada7f861d63')
Parameters:
[
null
]
|
|
1.35 ms (1.58%) |
1 |
SELECT templates FROM tl_theme WHERE templates != ''
Parameters:
[] |
|
1.30 ms (1.51%) |
1 |
SELECT id FROM tl_catalog WHERE tablename = ?
Parameters:
[
"tl_page"
]
|
|
1.29 ms (1.51%) |
1 |
SELECT tl_linkingyou_redirecter_redirects.*, j1.`id` AS destination_page__id, j1.`pid` AS destination_page__pid, j1.`sorting` AS destination_page__sorting, j1.`tstamp` AS destination_page__tstamp, j1.`title` AS destination_page__title, j1.`type` AS destination_page__type, j1.`alias` AS destination_page__alias, j1.`requireItem` AS destination_page__requireItem, j1.`routePriority` AS destination_page__routePriority, j1.`pageTitle` AS destination_page__pageTitle, j1.`language` AS destination_page__language, j1.`robots` AS destination_page__robots, j1.`description` AS destination_page__description, j1.`redirect` AS destination_page__redirect, j1.`alwaysForward` AS destination_page__alwaysForward, j1.`jumpTo` AS destination_page__jumpTo, j1.`redirectBack` AS destination_page__redirectBack, j1.`url` AS destination_page__url, j1.`target` AS destination_page__target, j1.`dns` AS destination_page__dns, j1.`staticFiles` AS destination_page__staticFiles, j1.`staticPlugins` AS destination_page__staticPlugins, j1.`fallback` AS destination_page__fallback, j1.`disableLanguageRedirect` AS destination_page__disableLanguageRedirect, j1.`favicon` AS destination_page__favicon, j1.`robotsTxt` AS destination_page__robotsTxt, j1.`maintenanceMode` AS destination_page__maintenanceMode, j1.`mailerTransport` AS destination_page__mailerTransport, j1.`enableCanonical` AS destination_page__enableCanonical, j1.`canonicalLink` AS destination_page__canonicalLink, j1.`canonicalKeepParams` AS destination_page__canonicalKeepParams, j1.`adminEmail` AS destination_page__adminEmail, j1.`dateFormat` AS destination_page__dateFormat, j1.`timeFormat` AS destination_page__timeFormat, j1.`datimFormat` AS destination_page__datimFormat, j1.`validAliasCharacters` AS destination_page__validAliasCharacters, j1.`useFolderUrl` AS destination_page__useFolderUrl, j1.`urlPrefix` AS destination_page__urlPrefix, j1.`urlSuffix` AS destination_page__urlSuffix, j1.`useSSL` AS destination_page__useSSL, j1.`autoforward` AS destination_page__autoforward, j1.`protected` AS destination_page__protected, j1.`groups` AS destination_page__groups, j1.`includeLayout` AS destination_page__includeLayout, j1.`layout` AS destination_page__layout, j1.`subpageLayout` AS destination_page__subpageLayout, j1.`includeCache` AS destination_page__includeCache, j1.`cache` AS destination_page__cache, j1.`alwaysLoadFromCache` AS destination_page__alwaysLoadFromCache, j1.`clientCache` AS destination_page__clientCache, j1.`includeChmod` AS destination_page__includeChmod, j1.`cuser` AS destination_page__cuser, j1.`cgroup` AS destination_page__cgroup, j1.`chmod` AS destination_page__chmod, j1.`noSearch` AS destination_page__noSearch, j1.`cssClass` AS destination_page__cssClass, j1.`sitemap` AS destination_page__sitemap, j1.`hide` AS destination_page__hide, j1.`guests` AS destination_page__guests, j1.`tabindex` AS destination_page__tabindex, j1.`accesskey` AS destination_page__accesskey, j1.`published` AS destination_page__published, j1.`start` AS destination_page__start, j1.`stop` AS destination_page__stop, j1.`enforceTwoFactor` AS destination_page__enforceTwoFactor, j1.`twoFactorJumpTo` AS destination_page__twoFactorJumpTo, j1.`mobileLayout` AS destination_page__mobileLayout, j1.`dlh_googlemaps_apikey` AS destination_page__dlh_googlemaps_apikey, j1.`catalogUseMaster` AS destination_page__catalogUseMaster, j1.`catalogShowInBreadcrumb` AS destination_page__catalogShowInBreadcrumb, j1.`catalogUseChangeLanguage` AS destination_page__catalogUseChangeLanguage, j1.`catalogUseRouting` AS destination_page__catalogUseRouting, j1.`catalogRoutingParameter` AS destination_page__catalogRoutingParameter, j1.`catalogSetAutoItem` AS destination_page__catalogSetAutoItem, j1.`catalogRouting` AS destination_page__catalogRouting, j1.`catalogChangeLanguageTable` AS destination_page__catalogChangeLanguageTable, j1.`catalogMasterTable` AS destination_page__catalogMasterTable, j1.`catalogRoutingTable` AS destination_page__catalogRoutingTable, j1.`canonicalType` AS destination_page__canonicalType, j1.`canonicalJumpTo` AS destination_page__canonicalJumpTo, j1.`canonicalWebsite` AS destination_page__canonicalWebsite, j1.`cms_root_license` AS destination_page__cms_root_license, j1.`cms_exclude_health_check` AS destination_page__cms_exclude_health_check, j1.`cms_root_key` AS destination_page__cms_root_key, j1.`cms_root_data` AS destination_page__cms_root_data, j1.`cms_root_sign` AS destination_page__cms_root_sign, j1.`cms_mi_views` AS destination_page__cms_mi_views, j1.`cms_mi_reset` AS destination_page__cms_mi_reset, j1.`iso_config` AS destination_page__iso_config, j1.`iso_store_id` AS destination_page__iso_store_id, j1.`iso_readerMode` AS destination_page__iso_readerMode, j1.`iso_readerJumpTo` AS destination_page__iso_readerJumpTo, j1.`iso_sitemapVariants` AS destination_page__iso_sitemapVariants, j1.`dls_categories` AS destination_page__dls_categories FROM tl_linkingyou_redirecter_redirects LEFT JOIN tl_page j1 ON tl_linkingyou_redirecter_redirects.`destination_page`=j1.id WHERE tl_linkingyou_redirecter_redirects.source_url = ? AND tl_linkingyou_redirecter_redirects.published = ? LIMIT 0,1
Parameters:
[ "/standorte/standort-details/dls-hennef.html" 1 ] |
|
1.19 ms (1.39%) |
2 |
SELECT tl_files.* FROM tl_files WHERE tl_files.uuid IN(UNHEX('b78cff8069d311ee881f8ada7f861d63'),UNHEX('3085492b845e11ee8ea48ada7f861d63'),UNHEX('256667a4845e11ee8ea48ada7f861d63'),UNHEX('79ebb7f5e1e111eebd598ada7f861d63'),UNHEX('c51f4d7342ab11ef88ab8ada7f861d63')) ORDER BY tl_files.uuid!=UNHEX('b78cff8069d311ee881f8ada7f861d63'), tl_files.uuid!=UNHEX('3085492b845e11ee8ea48ada7f861d63'), tl_files.uuid!=UNHEX('256667a4845e11ee8ea48ada7f861d63'), tl_files.uuid!=UNHEX('79ebb7f5e1e111eebd598ada7f861d63'), tl_files.uuid!=UNHEX('c51f4d7342ab11ef88ab8ada7f861d63')
Parameters:
[
null
]
|
|
1.18 ms (1.37%) |
1 |
SHOW FULL COLUMNS FROM ctlg_category
Parameters:
[] |
|
1.06 ms (1.24%) |
1 |
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" "" ] |
|
1.04 ms (1.21%) |
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<=1769982000) AND (tl_article.stop='' OR tl_article.stop>1769982000) ORDER BY tl_article.sorting
Parameters:
[ 21 "main" ] |
|
1.03 ms (1.20%) |
1 |
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:
[] |
|
1.00 ms (1.17%) |
1 |
SELECT tl_form_field.* FROM tl_form_field WHERE tl_form_field.pid=? AND tl_form_field.invisible='' AND tl_form_field.tstamp!=0 ORDER BY tl_form_field.sorting
Parameters:
[
2
]
|
|
0.99 ms (1.15%) |
1 |
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"
]
|
|
0.99 ms (1.15%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(69,70) ORDER BY FIND_IN_SET(`tl_page`.`id`, '69,70')
Parameters:
[] |
|
0.94 ms (1.09%) |
1 |
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:
[] |
|
0.93 ms (1.08%) |
1 |
SELECT * FROM tl_catalog ORDER BY `pTable` DESC, `tablename` ASC
Parameters:
[] |
|
0.92 ms (1.07%) |
1 |
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
9
]
|
|
0.92 ms (1.07%) |
1 |
SELECT tl_files.* FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
"ae71790569d311ee881f8ada7f861d63"
]
|
|
0.89 ms (1.04%) |
1 |
SELECT tl_image_size_item.* FROM tl_image_size_item WHERE tl_image_size_item.pid=? AND tl_image_size_item.invisible='' AND tl_image_size_item.tstamp > 0 ORDER BY sorting ASC
Parameters:
[
19
]
|
|
0.89 ms (1.04%) |
1 |
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:
[] |
|
0.89 ms (1.04%) |
1 |
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:
[] |
|
0.88 ms (1.02%) |
1 |
SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1
Parameters:
[
"219"
]
|
|
0.85 ms (0.99%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=?
Parameters:
[
"standorte/standort-details"
]
|
|
0.85 ms (0.99%) |
1 |
SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns=? OR tl_page.dns=''))
Parameters:
[
"dls.c5.bargon.net"
]
|
|
0.84 ms (0.98%) |
1 |
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
1
]
|
|
0.82 ms (0.95%) |
1 |
SELECT tl_form.* FROM tl_form WHERE tl_form.id=? LIMIT 0,1
Parameters:
[
"2"
]
|
|
0.79 ms (0.92%) |
1 |
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[ "index" "/" ] |
|
0.79 ms (0.92%) |
1 |
SELECT tl_storelocator_stores.* FROM tl_storelocator_stores WHERE BINARY tl_storelocator_stores.alias=? LIMIT 0,1
Parameters:
[
"dls-hennef"
]
|
|
0.78 ms (0.91%) |
1 |
SELECT * FROM tl_catalog WHERE id = ? LIMIT 0,1
Parameters:
[
1
]
|
|
0.75 ms (0.87%) |
1 |
SELECT tl_image_size.* FROM tl_image_size WHERE tl_image_size.`id`=? LIMIT 0,1
Parameters:
[
"19"
]
|
|
0.74 ms (0.86%) |
1 |
SHOW INDEXES FROM `ctlg_category`
Parameters:
[] |
|
0.71 ms (0.83%) |
1 |
SELECT * FROM ctlg_category ORDER BY title DESC
Parameters:
[] |
|
0.70 ms (0.82%) |
1 |
SELECT * FROM tl_catalog WHERE tablename = ? LIMIT 1
Parameters:
[
"ctlg_category"
]
|
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.
Entities Mapping
No loaded entities.