Symfony Profiler

SELECT
  t0.weight AS weight_5,
  t0.enabled AS enabled_6,
  t0.id AS id_7,
  t0.title AS title_8,
  t0.basesource AS basesource_9,
  t0.layerset AS layerset_10,
  t0.discr,
  t1.srs AS srs_11,
  t1.format AS format_12,
  t1.infoformat AS infoformat_13,
  t1.exceptionformat AS exceptionformat_14,
  t1.transparency AS transparency_15,
  t1.opacity AS opacity_16,
  t1.proxy AS proxy_17,
  t1.tiled AS tiled_18,
  t1.dimensions AS dimensions_19,
  t1.vendorspecifics AS vendorspecifics_20,
  t1.buffer AS buffer_21,
  t1.ratio AS ratio_22,
  t1.refresh_interval AS refresh_interval_23,
  t1.layerOrder AS layerorder_24,
  t1.wmssource AS wmssource_25,
  t2.opacity AS opacity_26,
  t2.proxy AS proxy_27,
  t2.wmtssource AS wmtssource_28,
  t3.min_scale AS min_scale_29,
  t3.max_scale AS max_scale_30,
  t3.selected AS selected_31,
  t3.allow_selected AS allow_selected_32,
  t3.feature_info AS feature_info_33,
  t3.feature_info_allow_toggle AS feature_info_allow_toggle_34,
  t3.feature_info_title AS feature_info_title_35,
  t3.hide_if_no_title AS hide_if_no_title_36,
  t3.feature_info_property_map AS feature_info_property_map_37,
  t3.opacity AS opacity_38,
  t3.print_scale_correction AS print_scale_correction_39,
  t3.legend_enabled AS legend_enabled_40,
  t3.legend_property_map AS legend_property_map_41,
  t3.source AS source_42,
  t4.opacity AS opacity_43,
  t4.minScale AS minscale_44,
  t4.maxScale AS maxscale_45,
  t4.featureLimit AS featurelimit_46,
  t4.allowSelected AS allowselected_47,
  t4.selected AS selected_48,
  t4.allowToggle AS allowtoggle_49,
  t4.toggle AS toggle_50,
  t4.source AS source_51
FROM
  mb_core_sourceinstance t0
  LEFT JOIN mb_wms_wmsinstance t1 ON t0.id = t1.id
  LEFT JOIN mb_wmts_wmtsinstance t2 ON t0.id = t2.id
  LEFT JOIN mb_vectortiles_instance t3 ON t0.id = t3.id
  LEFT JOIN mb_ogc_api_features_instance t4 ON t0.id = t4.id
WHERE
  t0.layerset = ?
ORDER BY
  t0.weight ASC

SELECT t0.weight AS weight_5, t0.enabled AS enabled_6, t0.id AS id_7, t0.title AS title_8, t0.basesource AS basesource_9, t0.layerset AS layerset_10, t0.discr, t1.srs AS srs_11, t1.format AS format_12, t1.infoformat AS infoformat_13, t1.exceptionformat AS exceptionformat_14, t1.transparency AS transparency_15, t1.opacity AS opacity_16, t1.proxy AS proxy_17, t1.tiled AS tiled_18, t1.dimensions AS dimensions_19, t1.vendorspecifics AS vendorspecifics_20, t1.buffer AS buffer_21, t1.ratio AS ratio_22, t1.refresh_interval AS refresh_interval_23, t1.layerOrder AS layerorder_24, t1.wmssource AS wmssource_25, t2.opacity AS opacity_26, t2.proxy AS proxy_27, t2.wmtssource AS wmtssource_28, t3.min_scale AS min_scale_29, t3.max_scale AS max_scale_30, t3.selected AS selected_31, t3.allow_selected AS allow_selected_32, t3.feature_info AS feature_info_33, t3.feature_info_allow_toggle AS feature_info_allow_toggle_34, t3.feature_info_title AS feature_info_title_35, t3.hide_if_no_title AS hide_if_no_title_36, t3.feature_info_property_map AS feature_info_property_map_37, t3.opacity AS opacity_38, t3.print_scale_correction AS print_scale_correction_39, t3.legend_enabled AS legend_enabled_40, t3.legend_property_map AS legend_property_map_41, t3.source AS source_42, t4.opacity AS opacity_43, t4.minScale AS minscale_44, t4.maxScale AS maxscale_45, t4.featureLimit AS featurelimit_46, t4.allowSelected AS allowselected_47, t4.selected AS selected_48, t4.allowToggle AS allowtoggle_49, t4.toggle AS toggle_50, t4.source AS source_51 FROM mb_core_sourceinstance t0 LEFT JOIN mb_wms_wmsinstance t1 ON t0.id = t1.id LEFT JOIN mb_wmts_wmtsinstance t2 ON t0.id = t2.id LEFT JOIN mb_vectortiles_instance t3 ON t0.id = t3.id LEFT JOIN mb_ogc_api_features_instance t4 ON t0.id = t4.id WHERE t0.layerset = 118 ORDER BY t0.weight ASC;

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 = 'qgis2mapbender_template' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.selected AS selected_3,
  t0.application_id AS application_id_4
FROM
  mb_core_layerset t0
WHERE
  t0.application_id = ?
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.selected AS selected_3, t0.application_id AS application_id_4 FROM mb_core_layerset t0 WHERE t0.application_id = 33 ORDER BY t0.title ASC;

SELECT
  t0.id AS id_1,
  t0.weight AS weight_2,
  t0.enabled AS enabled_3,
  t0.instance_id AS instance_id_4,
  t0.layerset_id AS layerset_id_5
FROM
  mb_core_layersets_sourceinstances t0
WHERE
  t0.layerset_id = ?
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.weight AS weight_2, t0.enabled AS enabled_3, t0.instance_id AS instance_id_4, t0.layerset_id AS layerset_id_5 FROM mb_core_layersets_sourceinstances t0 WHERE t0.layerset_id = 118 ORDER BY t0.weight ASC;

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,
  f0_.source_instance_id AS source_instance_id_10,
  f0_.shared_instance_assignment_id AS shared_instance_assignment_id_11
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, f0_.source_instance_id AS source_instance_id_10, f0_.shared_instance_assignment_id AS shared_instance_assignment_id_11 FROM fom_permission f0_ WHERE f0_.subject_domain = 'public';

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

SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.source_instance_id = 1467 AND f0_.resource_domain = 'source_instance');