Symfony Profiler

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

SELECT tl_content.* FROM tl_content WHERE tl_content.pid='471' AND (tl_content.ptable='tl_article' 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;

SELECT
  *
FROM
  tl_files
WHERE
  tl_files.uuid = UNHEX(?)
LIMIT
  0, 1

SELECT * FROM tl_files WHERE tl_files.uuid=UNHEX('2d09a7f0276b11ebb018408d5c841eaa') LIMIT 0,1;

SELECT
  tl_article.*
FROM
  tl_article
WHERE
  tl_article.id = ?
LIMIT
  0, 1

SELECT tl_article.* FROM tl_article WHERE tl_article.id='493' LIMIT 0,1;

SELECT
  tl_content.*
FROM
  tl_content
WHERE
  tl_content.`id` = ?
LIMIT
  0, 1

SELECT tl_content.* FROM tl_content WHERE tl_content.`id`='2338' LIMIT 0,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 <= '1769163360'
  )
  AND (
    tl_article.stop = ''
    OR tl_article.stop > '1769163360'
  )
ORDER BY
  tl_article.sorting

SELECT tl_article.* FROM tl_article WHERE tl_article.pid='139' AND tl_article.inColumn='header' 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;

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  (
    tl_page.type = 'root'
    AND (
      tl_page.dns = ?
      OR tl_page.dns = ''
    )
  )

SELECT tl_page.* FROM tl_page WHERE (tl_page.type='root' AND (tl_page.dns='schaible.c5.bargon.net' OR tl_page.dns=''));

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 <= '1769163360'
      )
      AND (
        p2.stop = ''
        OR p2.stop > '1769163360'
      )
  ) 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 <= '1769163360'
  )
  AND (
    p1.stop = ''
    OR p1.stop > '1769163360'
  )
ORDER BY
  p1.sorting

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<='1769163360') AND (p2.stop='' OR p2.stop>'1769163360')) AS hasSubpages FROM tl_page p1 WHERE p1.pid='138' 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<='1769163360') AND (p1.stop='' OR p1.stop>'1769163360') ORDER BY p1.sorting;

SELECT
  templates
FROM
  tl_theme

SELECT templates FROM tl_theme;

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

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`='6' LIMIT 0,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 (11)
ORDER BY
  FIND_IN_SET(`id`, '11')

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');

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.alias = ?
  OR tl_page.alias = ?

SELECT tl_page.* FROM tl_page WHERE tl_page.alias='index' OR tl_page.alias='/';

SELECT
  tl_page.*
FROM
  tl_page
WHERE
  tl_page.id IN(147, 140, 141, 142, 144)
ORDER BY
  FIND_IN_SET(
    `tl_page`.`id`, '139,147,140,141,142,144'
  )

SELECT tl_page.* FROM tl_page WHERE tl_page.id IN(147,140,141,142,144) ORDER BY FIND_IN_SET(`tl_page`.`id`, '139,147,140,141,142,144');

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'
  )

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');

SELECT
  tl_layout.*
FROM
  tl_layout
WHERE
  tl_layout.`id` = ?
LIMIT
  0, 1

SELECT tl_layout.* FROM tl_layout WHERE tl_layout.`id`='13' LIMIT 0,1;

SELECT
  tl_module.*
FROM
  tl_module
WHERE
  tl_module.`id` = ?
LIMIT
  0, 1

SELECT tl_module.* FROM tl_module WHERE tl_module.`id`='243' LIMIT 0,1;

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'
  )

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');

SELECT
  *
FROM
  tl_c4g_map_baselayers
WHERE
  tl_c4g_map_baselayers.`id` = ?

SELECT * FROM tl_c4g_map_baselayers WHERE tl_c4g_map_baselayers.`id`='2';

SELECT
  *
FROM
  tl_theme
WHERE
  tl_theme.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_theme WHERE tl_theme.`id`='7' LIMIT 0,1;

SELECT
  *
FROM
  tl_c4g_map_themes
WHERE
  tl_c4g_map_themes.`id` = ?
LIMIT
  0, 1

SELECT * FROM tl_c4g_map_themes WHERE tl_c4g_map_themes.`id`='' LIMIT 0,1;