Query Metrics

28 Database Queries
16 Different statements
44.69 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.60 ms
SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns=? OR tl_page.dns=''))
Parameters:
[
  "schaible.c5.bargon.net"
]
2 1.13 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[
  "index"
  "/"
]
3 1.77 ms
SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns=? OR tl_page.dns=''))
Parameters:
[
  "schaible.c5.bargon.net"
]
4 1.10 ms
SELECT tl_page.* FROM tl_page WHERE tl_page.alias=? OR tl_page.alias=?
Parameters:
[
  "index"
  "/"
]
5 0.90 ms
SELECT templates FROM tl_theme
Parameters:
[]
6 1.64 ms
SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`=? LIMIT 0,1
Parameters:
[
  "13"
]
7 1.24 ms
SELECT * FROM tl_theme WHERE tl_theme.`id`=? LIMIT 0,1
Parameters:
[
  "7"
]
8 1.89 ms
SELECT tl_module.* FROM tl_module WHERE tl_module.id IN(234,233,0,0,0,232) ORDER BY FIND_IN_SET(`tl_module`.`id`, '234,233,0,0,0,232')
Parameters:
[]
9 1.71 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<='1769163360') AND (tl_article.stop='' OR tl_article.stop>'1769163360') ORDER BY tl_article.sorting
Parameters:
[
  "139"
  "header"
]
10 1.23 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<='1769163360') AND (tl_article.stop='' OR tl_article.stop>'1769163360') ORDER BY tl_article.sorting
Parameters:
[
  "139"
  "main"
]
11 1.67 ms
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<='1769163360') AND (tl_content.stop='' OR tl_content.stop>'1769163360') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  "471"
  "tl_article"
]
12 1.42 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "2d09a7f0276b11ebb018408d5c841eaa"
]
13 1.43 ms
SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX(?) LIMIT 0,1
Parameters:
[
  "8ab0262980ca11eab4d63085a996614b"
]
14 1.67 ms
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<='1769163360') AND (tl_content.stop='' OR tl_content.stop>'1769163360') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  "485"
  "tl_article"
]
15 1.84 ms
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
  "2338"
]
16 1.66 ms
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
  "2342"
]
17 1.43 ms
SELECT tl_content.* FROM tl_content WHERE tl_content.`id`=? LIMIT 0,1
Parameters:
[
  "3615"
]
18 1.95 ms
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<='1769163360') AND (tl_content.stop='' OR tl_content.stop>'1769163360') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  "487"
  "tl_article"
]
19 1.75 ms
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<='1769163360') AND (tl_content.stop='' OR tl_content.stop>'1769163360') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  "497"
  "tl_article"
]
20 1.10 ms
SELECT tl_article.* FROM tl_article WHERE tl_article.id=? LIMIT 0,1
Parameters:
[
  "493"
]
21 2.03 ms
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<='1769163360') AND (tl_content.stop='' OR tl_content.stop>'1769163360') AND tl_content.tstamp!=0 ORDER BY tl_content.sorting
Parameters:
[
  "493"
  "tl_article"
]
22 2.40 ms
SELECT tl_c4g_maps.*, j1.`id` AS profile__id, j1.`tstamp` AS profile__tstamp, j1.`name` AS profile__name, j1.`is_default` AS profile__is_default, j1.`theme` AS profile__theme, j1.`is_backend_editor_default` AS profile__is_backend_editor_default, j1.`is_backend_geopicker_default` AS profile__is_backend_geopicker_default, j1.`baselayers` AS profile__baselayers, j1.`default_baselayer` AS profile__default_baselayer, j1.`locstyles` AS profile__locstyles, j1.`zoom_panel` AS profile__zoom_panel, j1.`zoom_panel_button` AS profile__zoom_panel_button, j1.`zoom_panel_slider` AS profile__zoom_panel_slider, j1.`mouse_nav` AS profile__mouse_nav, j1.`mouse_nav_wheel` AS profile__mouse_nav_wheel, j1.`mouse_nav_doubleclick_zoom` AS profile__mouse_nav_doubleclick_zoom, j1.`mouse_nav_zoombox` AS profile__mouse_nav_zoombox, j1.`mouse_nav_kinetic` AS profile__mouse_nav_kinetic, j1.`mouse_nav_dragmode` AS profile__mouse_nav_dragmode, j1.`keyboard_nav` AS profile__keyboard_nav, j1.`touch_nav` AS profile__touch_nav, j1.`nav_history` AS profile__nav_history, j1.`fullscreen` AS profile__fullscreen, j1.`starboard` AS profile__starboard, j1.`starboard_open` AS profile__starboard_open, j1.`starboard_label` AS profile__starboard_label, j1.`starboard_div` AS profile__starboard_div, j1.`starboard_filter` AS profile__starboard_filter, j1.`starboard_button` AS profile__starboard_button, j1.`cluster_all` AS profile__cluster_all, j1.`cluster_distance` AS profile__cluster_distance, j1.`cluster_fillcolor` AS profile__cluster_fillcolor, j1.`cluster_fontcolor` AS profile__cluster_fontcolor, j1.`cluster_zoom` AS profile__cluster_zoom, j1.`baselayerswitcher` AS profile__baselayerswitcher, j1.`baselayerswitcher_label` AS profile__baselayerswitcher_label, j1.`layerswitcher` AS profile__layerswitcher, j1.`layerswitcher_label` AS profile__layerswitcher_label, j1.`measuretool` AS profile__measuretool, j1.`graticule` AS profile__graticule, j1.`editor` AS profile__editor, j1.`attribution` AS profile__attribution, j1.`collapsed_attribution` AS profile__collapsed_attribution, j1.`cfg_logo_attribution` AS profile__cfg_logo_attribution, j1.`div_attribution` AS profile__div_attribution, j1.`add_attribution` AS profile__add_attribution, j1.`overviewmap` AS profile__overviewmap, j1.`scaleline` AS profile__scaleline, j1.`mouseposition` AS profile__mouseposition, j1.`permalink` AS profile__permalink, j1.`permalink_get_param` AS profile__permalink_get_param, j1.`zoomlevel` AS profile__zoomlevel, j1.`geosearch` AS profile__geosearch, j1.`geosearch_engine` AS profile__geosearch_engine, j1.`geosearch_show` AS profile__geosearch_show, j1.`geosearch_results` AS profile__geosearch_results, j1.`geosearch_customengine_url` AS profile__geosearch_customengine_url, j1.`geosearch_customengine_attribution` AS profile__geosearch_customengine_attribution, j1.`geosearch_key` AS profile__geosearch_key, j1.`geosearch_div` AS profile__geosearch_div, j1.`geosearch_zoomto` AS profile__geosearch_zoomto, j1.`geosearch_zoombounds` AS profile__geosearch_zoombounds, j1.`geosearch_animate` AS profile__geosearch_animate, j1.`geosearch_markresult` AS profile__geosearch_markresult, j1.`geosearch_popup` AS profile__geosearch_popup, j1.`geosearch_attribution` AS profile__geosearch_attribution, j1.`geosearch_collapsed` AS profile__geosearch_collapsed, j1.`geopicker` AS profile__geopicker, j1.`geopicker_fieldx` AS profile__geopicker_fieldx, j1.`geopicker_fieldy` AS profile__geopicker_fieldy, j1.`geopicker_searchdiv` AS profile__geopicker_searchdiv, j1.`geopicker_attribution` AS profile__geopicker_attribution, j1.`geopicker_disabled` AS profile__geopicker_disabled, j1.`geopicker_anonymous` AS profile__geopicker_anonymous, j1.`router` AS profile__router, j1.`router_viaroute_url` AS profile__router_viaroute_url, j1.`router_attribution` AS profile__router_attribution, j1.`libsource` AS profile__libsource, j1.`overpass_url` AS profile__overpass_url, j1.`custom_div` AS profile__custom_div, j1.`infopage` AS profile__infopage, j1.`link_newwindow` AS profile__link_newwindow, j1.`link_open_on` AS profile__link_open_on, j1.`hover_popups` AS profile__hover_popups, j1.`hover_popups_stay` AS profile__hover_popups_stay, j1.`editor_styles_point` AS profile__editor_styles_point, j1.`editor_styles_line` AS profile__editor_styles_line, j1.`editor_styles_polygon` AS profile__editor_styles_polygon, j1.`editor_styles_circle` AS profile__editor_styles_circle, j1.`editor_styles_freehand` AS profile__editor_styles_freehand, j1.`editor_vars` AS profile__editor_vars, j1.`editor_show_items` AS profile__editor_show_items, j1.`editor_helpurl` AS profile__editor_helpurl, j1.`be_optimize_checkboxes_limit` AS profile__be_optimize_checkboxes_limit, j1.`router_api_selection` AS profile__router_api_selection, j1.`router_alternative` AS profile__router_alternative, j1.`router_from_locstyle` AS profile__router_from_locstyle, j1.`router_to_locstyle` AS profile__router_to_locstyle, j1.`router_point_locstyle` AS profile__router_point_locstyle, j1.`router_interim_locstyle` AS profile__router_interim_locstyle, j1.`cesium` AS profile__cesium, j1.`cesium_always` AS profile__cesium_always FROM tl_c4g_maps LEFT JOIN tl_c4g_map_profiles j1 ON tl_c4g_maps.`profile`=j1.id WHERE tl_c4g_maps.`id`=? LIMIT 0,1
Parameters:
[
  "6"
]
23 1.45 ms
SELECT * FROM tl_c4g_map_baselayers WHERE tl_c4g_map_baselayers.`id`=?
Parameters:
[
  "2"
]
24 1.08 ms
SELECT * FROM tl_c4g_map_themes WHERE tl_c4g_map_themes.`id`=? LIMIT 0,1
Parameters:
[
  ""
]
25 1.65 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<='1769163360') AND (tl_article.stop='' OR tl_article.stop>'1769163360') ORDER BY tl_article.sorting
Parameters:
[
  "139"
  "footer"
]
26 2.36 ms
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 (11) ORDER BY FIND_IN_SET(`id`, '11')
Parameters:
[]
27 1.55 ms
SELECT * FROM tl_files WHERE tl_files.uuid IN(UNHEX('f758bc2cf79611f0b731a35f5e16bfa4'),UNHEX('f758bbb4f79611f08bd8a35f5e16bfa4'),UNHEX('f758bad8f79611f087d9a35f5e16bfa4'),UNHEX('f758bb0af79611f096b7a35f5e16bfa4'),UNHEX('f758ba92f79611f0ba16a35f5e16bfa4'),UNHEX('f758bb82f79611f09931a35f5e16bfa4'),UNHEX('f758bbf0f79611f08ba6a35f5e16bfa4')) ORDER BY tl_files.uuid!=UNHEX('f758bc2cf79611f0b731a35f5e16bfa4'), tl_files.uuid!=UNHEX('f758bbb4f79611f08bd8a35f5e16bfa4'), tl_files.uuid!=UNHEX('f758bad8f79611f087d9a35f5e16bfa4'), tl_files.uuid!=UNHEX('f758bb0af79611f096b7a35f5e16bfa4'), tl_files.uuid!=UNHEX('f758ba92f79611f0ba16a35f5e16bfa4'), tl_files.uuid!=UNHEX('f758bb82f79611f09931a35f5e16bfa4'), tl_files.uuid!=UNHEX('f758bbf0f79611f08ba6a35f5e16bfa4')
Parameters:
[
  null
]
28 1.05 ms
SELECT templates FROM tl_theme
Parameters:
[]

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

Class Mapping errors
Contao\CoreBundle\Entity\RememberMe No errors.