Symfony Profiler

PRAGMA foreign_keys = ON;

PRAGMA foreign_keys = ON;;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.template AS template_5,
  t0.map_engine_code AS map_engine_code_6,
  t0.persistent_view AS persistent_view_7,
  t0.splashscreen AS splashscreen_8,
  t0.screenshot AS screenshot_9,
  t0.extra_assets AS extra_assets_10,
  t0.updated AS updated_11,
  t0.custom_css AS custom_css_12
FROM
  mb_core_application t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.template AS template_5, t0.map_engine_code AS map_engine_code_6, t0.persistent_view AS persistent_view_7, t0.splashscreen AS splashscreen_8, t0.screenshot AS screenshot_9, t0.extra_assets AS extra_assets_10, t0.updated AS updated_11, t0.custom_css AS custom_css_12 FROM mb_core_application t0 WHERE t0.slug = 'mapbender_user_basic_yml' LIMIT 1;

SELECT
  f0_.id AS id_0,
  f0_.subject_domain AS subject_domain_1,
  f0_.subject AS subject_2,
  f0_.resource_domain AS resource_domain_3,
  f0_.resource_ref AS resource_ref_4,
  f0_.action AS action_5,
  f0_.user_id AS user_id_6,
  f0_.group_id AS group_id_7,
  f0_.element_id AS element_id_8,
  f0_.application_id AS application_id_9
FROM
  fom_permission f0_
WHERE
  f0_.subject_domain = 'public'

SELECT f0_.id AS id_0, f0_.subject_domain AS subject_domain_1, f0_.subject AS subject_2, f0_.resource_domain AS resource_domain_3, f0_.resource_ref AS resource_ref_4, f0_.action AS action_5, f0_.user_id AS user_id_6, f0_.group_id AS group_id_7, f0_.element_id AS element_id_8, f0_.application_id AS application_id_9 FROM fom_permission f0_ WHERE f0_.subject_domain = 'public';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.class AS class_3,
  t0.configuration AS configuration_4,
  t0.region AS region_5,
  t0.enabled AS enabled_6,
  t0.weight AS weight_7,
  t0.screenType AS screenType_8,
  t0.application_id AS application_id_9
FROM
  mb_core_element t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.class AS class_3, t0.configuration AS configuration_4, t0.region AS region_5, t0.enabled AS enabled_6, t0.weight AS weight_7, t0.screenType AS screenType_8, t0.application_id AS application_id_9 FROM mb_core_element t0 WHERE t0.application_id = 3 ORDER BY t0.weight ASC;

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 58 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 73 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 92 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 59 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 74 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 93 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 60 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 75 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 94 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 61 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 76 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 95 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 62 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 77 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 96 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 63 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 78 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 97 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 64 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 79 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 98 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 65 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 80 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 99 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 66 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 81 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 100 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 67 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 82 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 101 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 68 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 83 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 69 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 84 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 70 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 85 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 71 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 86 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 72 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 87 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 88 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 89 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 90 AND f0_.resource_domain = 'element');

SELECT
  COUNT(f0_.id) AS sclr_0
FROM
  fom_permission f0_
WHERE
  (
    f0_.element_id = ?
    AND f0_.resource_domain = 'element'
  )

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = 91 AND f0_.resource_domain = 'element');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.definition AS definition_4
FROM
  mb_core_srs t0
WHERE
  t0.name IN (?, ?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.definition AS definition_4 FROM mb_core_srs t0 WHERE t0.name IN ('EPSG:3857', 'EPSG:25832', 'EPSG:25833', 'EPSG:31466', 'EPSG:31467', 'EPSG:4326');

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.definition AS definition_4
FROM
  mb_core_srs t0
WHERE
  t0.name IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.definition AS definition_4 FROM mb_core_srs t0 WHERE t0.name IN ('EPSG:31466', 'EPSG:31467', 'EPSG:25832', 'EPSG:25833', 'EPSG:4326');

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.selected AS selected_2,
  m0_.application_id AS application_id_3
FROM
  mb_core_layerset m0_
WHERE
  m0_.application_id = ?

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.selected AS selected_2, m0_.application_id AS application_id_3 FROM mb_core_layerset m0_ WHERE m0_.application_id = 3;

SELECT
  m0_.weight AS weight_0,
  m0_.enabled AS enabled_1,
  m0_.id AS id_2,
  m0_.title AS title_3,
  m0_.basesource AS basesource_4,
  m1_.srs AS srs_5,
  m1_.format AS format_6,
  m1_.infoformat AS infoformat_7,
  m1_.exceptionformat AS exceptionformat_8,
  m1_.transparency AS transparency_9,
  m1_.opacity AS opacity_10,
  m1_.proxy AS proxy_11,
  m1_.tiled AS tiled_12,
  m1_.dimensions AS dimensions_13,
  m1_.vendorspecifics AS vendorspecifics_14,
  m1_.buffer AS buffer_15,
  m1_.ratio AS ratio_16,
  m1_.refresh_interval AS refresh_interval_17,
  m1_.layerOrder AS layerOrder_18,
  m2_.opacity AS opacity_19,
  m2_.proxy AS proxy_20,
  m3_.min_scale AS min_scale_21,
  m3_.max_scale AS max_scale_22,
  m3_.selected AS selected_23,
  m3_.allow_selected AS allow_selected_24,
  m3_.feature_info AS feature_info_25,
  m3_.feature_info_allow_toggle AS feature_info_allow_toggle_26,
  m3_.feature_info_title AS feature_info_title_27,
  m3_.hide_if_no_title AS hide_if_no_title_28,
  m3_.feature_info_property_map AS feature_info_property_map_29,
  m3_.opacity AS opacity_30,
  m3_.print_scale_correction AS print_scale_correction_31,
  m3_.legend_enabled AS legend_enabled_32,
  m3_.legend_property_map AS legend_property_map_33,
  m0_.discr AS discr_34,
  m0_.layerset AS layerset_35,
  m1_.wmssource AS wmssource_36,
  m2_.wmtssource AS wmtssource_37,
  m3_.source AS source_38
FROM
  mb_core_sourceinstance m0_
  LEFT JOIN mb_wms_wmsinstance m1_ ON m0_.id = m1_.id
  LEFT JOIN mb_wmts_wmtsinstance m2_ ON m0_.id = m2_.id
  LEFT JOIN mb_vectortiles_instance m3_ ON m0_.id = m3_.id
WHERE
  m0_.layerset IN (?, ?, ?, ?, ?)

SELECT m0_.weight AS weight_0, m0_.enabled AS enabled_1, m0_.id AS id_2, m0_.title AS title_3, m0_.basesource AS basesource_4, m1_.srs AS srs_5, m1_.format AS format_6, m1_.infoformat AS infoformat_7, m1_.exceptionformat AS exceptionformat_8, m1_.transparency AS transparency_9, m1_.opacity AS opacity_10, m1_.proxy AS proxy_11, m1_.tiled AS tiled_12, m1_.dimensions AS dimensions_13, m1_.vendorspecifics AS vendorspecifics_14, m1_.buffer AS buffer_15, m1_.ratio AS ratio_16, m1_.refresh_interval AS refresh_interval_17, m1_.layerOrder AS layerOrder_18, m2_.opacity AS opacity_19, m2_.proxy AS proxy_20, m3_.min_scale AS min_scale_21, m3_.max_scale AS max_scale_22, m3_.selected AS selected_23, m3_.allow_selected AS allow_selected_24, m3_.feature_info AS feature_info_25, m3_.feature_info_allow_toggle AS feature_info_allow_toggle_26, m3_.feature_info_title AS feature_info_title_27, m3_.hide_if_no_title AS hide_if_no_title_28, m3_.feature_info_property_map AS feature_info_property_map_29, m3_.opacity AS opacity_30, m3_.print_scale_correction AS print_scale_correction_31, m3_.legend_enabled AS legend_enabled_32, m3_.legend_property_map AS legend_property_map_33, m0_.discr AS discr_34, m0_.layerset AS layerset_35, m1_.wmssource AS wmssource_36, m2_.wmtssource AS wmtssource_37, m3_.source AS source_38 FROM mb_core_sourceinstance m0_ LEFT JOIN mb_wms_wmsinstance m1_ ON m0_.id = m1_.id LEFT JOIN mb_wmts_wmtsinstance m2_ ON m0_.id = m2_.id LEFT JOIN mb_vectortiles_instance m3_ ON m0_.id = m3_.id WHERE m0_.layerset IN (7, 8, 9, 10, 11);

SELECT
  m0_.weight AS weight_0,
  m0_.enabled AS enabled_1,
  m0_.id AS id_2,
  m0_.title AS title_3,
  m0_.basesource AS basesource_4,
  m1_.srs AS srs_5,
  m1_.format AS format_6,
  m1_.infoformat AS infoformat_7,
  m1_.exceptionformat AS exceptionformat_8,
  m1_.transparency AS transparency_9,
  m1_.opacity AS opacity_10,
  m1_.proxy AS proxy_11,
  m1_.tiled AS tiled_12,
  m1_.dimensions AS dimensions_13,
  m1_.vendorspecifics AS vendorspecifics_14,
  m1_.buffer AS buffer_15,
  m1_.ratio AS ratio_16,
  m1_.refresh_interval AS refresh_interval_17,
  m1_.layerOrder AS layerOrder_18,
  m2_.opacity AS opacity_19,
  m2_.proxy AS proxy_20,
  m3_.min_scale AS min_scale_21,
  m3_.max_scale AS max_scale_22,
  m3_.selected AS selected_23,
  m3_.allow_selected AS allow_selected_24,
  m3_.feature_info AS feature_info_25,
  m3_.feature_info_allow_toggle AS feature_info_allow_toggle_26,
  m3_.feature_info_title AS feature_info_title_27,
  m3_.hide_if_no_title AS hide_if_no_title_28,
  m3_.feature_info_property_map AS feature_info_property_map_29,
  m3_.opacity AS opacity_30,
  m3_.print_scale_correction AS print_scale_correction_31,
  m3_.legend_enabled AS legend_enabled_32,
  m3_.legend_property_map AS legend_property_map_33,
  m0_.discr AS discr_34,
  m0_.layerset AS layerset_35,
  m1_.wmssource AS wmssource_36,
  m2_.wmtssource AS wmtssource_37,
  m3_.source AS source_38
FROM
  mb_core_layersets_sourceinstances m4_
  INNER JOIN (
    mb_core_sourceinstance m0_
    LEFT JOIN mb_wms_wmsinstance m1_ ON m0_.id = m1_.id
    LEFT JOIN mb_wmts_wmtsinstance m2_ ON m0_.id = m2_.id
    LEFT JOIN mb_vectortiles_instance m3_ ON m0_.id = m3_.id
  ) ON (m0_.id = m4_.instance_id)
WHERE
  m4_.layerset_id IN (?, ?, ?, ?, ?)

SELECT m0_.weight AS weight_0, m0_.enabled AS enabled_1, m0_.id AS id_2, m0_.title AS title_3, m0_.basesource AS basesource_4, m1_.srs AS srs_5, m1_.format AS format_6, m1_.infoformat AS infoformat_7, m1_.exceptionformat AS exceptionformat_8, m1_.transparency AS transparency_9, m1_.opacity AS opacity_10, m1_.proxy AS proxy_11, m1_.tiled AS tiled_12, m1_.dimensions AS dimensions_13, m1_.vendorspecifics AS vendorspecifics_14, m1_.buffer AS buffer_15, m1_.ratio AS ratio_16, m1_.refresh_interval AS refresh_interval_17, m1_.layerOrder AS layerOrder_18, m2_.opacity AS opacity_19, m2_.proxy AS proxy_20, m3_.min_scale AS min_scale_21, m3_.max_scale AS max_scale_22, m3_.selected AS selected_23, m3_.allow_selected AS allow_selected_24, m3_.feature_info AS feature_info_25, m3_.feature_info_allow_toggle AS feature_info_allow_toggle_26, m3_.feature_info_title AS feature_info_title_27, m3_.hide_if_no_title AS hide_if_no_title_28, m3_.feature_info_property_map AS feature_info_property_map_29, m3_.opacity AS opacity_30, m3_.print_scale_correction AS print_scale_correction_31, m3_.legend_enabled AS legend_enabled_32, m3_.legend_property_map AS legend_property_map_33, m0_.discr AS discr_34, m0_.layerset AS layerset_35, m1_.wmssource AS wmssource_36, m2_.wmtssource AS wmtssource_37, m3_.source AS source_38 FROM mb_core_layersets_sourceinstances m4_ INNER JOIN (mb_core_sourceinstance m0_ LEFT JOIN mb_wms_wmsinstance m1_ ON m0_.id = m1_.id LEFT JOIN mb_wmts_wmtsinstance m2_ ON m0_.id = m2_.id LEFT JOIN mb_vectortiles_instance m3_ ON m0_.id = m3_.id) ON (m0_.id = m4_.instance_id) WHERE m4_.layerset_id IN (7, 8, 9, 10, 11);

SELECT
  t1.id AS id_2,
  t1.title AS title_3,
  t1.alias AS alias_4,
  t1.description AS description_5,
  t1.type AS type_6,
  t0.originUrl AS originUrl_7,
  t0.username AS username_8,
  t0.password AS password_9,
  t0.name AS name_10,
  t0.version AS version_11,
  t0.onlineResource AS onlineResource_12,
  t0.fees AS fees_13,
  t0.accessConstraints AS accessConstraints_14,
  t0.layerLimit AS layerLimit_15,
  t0.maxWidth AS maxWidth_16,
  t0.maxHeight AS maxHeight_17,
  t0.exceptionFormats AS exceptionFormats_18,
  t0.supportSld AS supportSld_19,
  t0.userLayer AS userLayer_20,
  t0.userStyle AS userStyle_21,
  t0.remoteWfs AS remoteWfs_22,
  t0.inlineFeature AS inlineFeature_23,
  t0.remoteWcs AS remoteWcs_24,
  t0.getCapabilities AS getCapabilities_25,
  t0.getMap AS getMap_26,
  t0.getFeatureInfo AS getFeatureInfo_27,
  t0.describeLayer AS describeLayer_28,
  t0.getLegendGraphic AS getLegendGraphic_29,
  t0.getStyles AS getStyles_30,
  t0.putStyles AS putStyles_31,
  t0.contact_id AS contact_id_32,
  t1.discr
FROM
  mb_wms_wmssource t0
  INNER JOIN mb_core_source t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.title AS title_3, t1.alias AS alias_4, t1.description AS description_5, t1.type AS type_6, t0.originUrl AS originUrl_7, t0.username AS username_8, t0.password AS password_9, t0.name AS name_10, t0.version AS version_11, t0.onlineResource AS onlineResource_12, t0.fees AS fees_13, t0.accessConstraints AS accessConstraints_14, t0.layerLimit AS layerLimit_15, t0.maxWidth AS maxWidth_16, t0.maxHeight AS maxHeight_17, t0.exceptionFormats AS exceptionFormats_18, t0.supportSld AS supportSld_19, t0.userLayer AS userLayer_20, t0.userStyle AS userStyle_21, t0.remoteWfs AS remoteWfs_22, t0.inlineFeature AS inlineFeature_23, t0.remoteWcs AS remoteWcs_24, t0.getCapabilities AS getCapabilities_25, t0.getMap AS getMap_26, t0.getFeatureInfo AS getFeatureInfo_27, t0.describeLayer AS describeLayer_28, t0.getLegendGraphic AS getLegendGraphic_29, t0.getStyles AS getStyles_30, t0.putStyles AS putStyles_31, t0.contact_id AS contact_id_32, t1.discr FROM mb_wms_wmssource t0 INNER JOIN mb_core_source t1 ON t0.id = t1.id WHERE t1.id = 5;