Symfony Profiler

PRAGMA foreign_keys = ON;

PRAGMA foreign_keys = ON;;

SELECT
  t0.weight AS weight_4,
  t0.enabled AS enabled_5,
  t0.id AS id_6,
  t0.title AS title_7,
  t0.basesource AS basesource_8,
  t0.layerset AS layerset_9,
  t0.discr,
  t1.srs AS srs_10,
  t1.format AS format_11,
  t1.infoformat AS infoformat_12,
  t1.exceptionformat AS exceptionformat_13,
  t1.transparency AS transparency_14,
  t1.opacity AS opacity_15,
  t1.proxy AS proxy_16,
  t1.tiled AS tiled_17,
  t1.dimensions AS dimensions_18,
  t1.vendorspecifics AS vendorspecifics_19,
  t1.buffer AS buffer_20,
  t1.ratio AS ratio_21,
  t1.refresh_interval AS refresh_interval_22,
  t1.layerOrder AS layerOrder_23,
  t1.wmssource AS wmssource_24,
  t2.opacity AS opacity_25,
  t2.proxy AS proxy_26,
  t2.wmtssource AS wmtssource_27,
  t3.min_scale AS min_scale_28,
  t3.max_scale AS max_scale_29,
  t3.selected AS selected_30,
  t3.allow_selected AS allow_selected_31,
  t3.feature_info AS feature_info_32,
  t3.feature_info_allow_toggle AS feature_info_allow_toggle_33,
  t3.feature_info_title AS feature_info_title_34,
  t3.hide_if_no_title AS hide_if_no_title_35,
  t3.feature_info_property_map AS feature_info_property_map_36,
  t3.opacity AS opacity_37,
  t3.print_scale_correction AS print_scale_correction_38,
  t3.legend_enabled AS legend_enabled_39,
  t3.legend_property_map AS legend_property_map_40,
  t3.source AS source_41
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
WHERE
  t0.id = ?

SELECT t0.weight AS weight_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.title AS title_7, t0.basesource AS basesource_8, t0.layerset AS layerset_9, t0.discr, t1.srs AS srs_10, t1.format AS format_11, t1.infoformat AS infoformat_12, t1.exceptionformat AS exceptionformat_13, t1.transparency AS transparency_14, t1.opacity AS opacity_15, t1.proxy AS proxy_16, t1.tiled AS tiled_17, t1.dimensions AS dimensions_18, t1.vendorspecifics AS vendorspecifics_19, t1.buffer AS buffer_20, t1.ratio AS ratio_21, t1.refresh_interval AS refresh_interval_22, t1.layerOrder AS layerOrder_23, t1.wmssource AS wmssource_24, t2.opacity AS opacity_25, t2.proxy AS proxy_26, t2.wmtssource AS wmtssource_27, t3.min_scale AS min_scale_28, t3.max_scale AS max_scale_29, t3.selected AS selected_30, t3.allow_selected AS allow_selected_31, t3.feature_info AS feature_info_32, t3.feature_info_allow_toggle AS feature_info_allow_toggle_33, t3.feature_info_title AS feature_info_title_34, t3.hide_if_no_title AS hide_if_no_title_35, t3.feature_info_property_map AS feature_info_property_map_36, t3.opacity AS opacity_37, t3.print_scale_correction AS print_scale_correction_38, t3.legend_enabled AS legend_enabled_39, t3.legend_property_map AS legend_property_map_40, t3.source AS source_41 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 WHERE t0.id = '40';

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.id = ?

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.id = 16;

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.id = ?

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.id = 6;

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.active AS active_3,
  t0.allowselected AS allowselected_4,
  t0.selected AS selected_5,
  t0.info AS info_6,
  t0.allowinfo AS allowinfo_7,
  t0.toggle AS toggle_8,
  t0.allowtoggle AS allowtoggle_9,
  t0.minScale AS minScale_10,
  t0.maxScale AS maxScale_11,
  t0.style AS style_12,
  t0.priority AS priority_13,
  t0.legend AS legend_14,
  t0.wmsinstance AS wmsinstance_15,
  t0.wmslayersource AS wmslayersource_16,
  t0.parent AS parent_17
FROM
  mb_wms_wmsinstancelayer t0
WHERE
  (
    t0.id = ?
    AND t0.wmsinstance = ?
  )
ORDER BY
  t0.priority ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.allowselected AS allowselected_4, t0.selected AS selected_5, t0.info AS info_6, t0.allowinfo AS allowinfo_7, t0.toggle AS toggle_8, t0.allowtoggle AS allowtoggle_9, t0.minScale AS minScale_10, t0.maxScale AS maxScale_11, t0.style AS style_12, t0.priority AS priority_13, t0.legend AS legend_14, t0.wmsinstance AS wmsinstance_15, t0.wmslayersource AS wmslayersource_16, t0.parent AS parent_17 FROM mb_wms_wmsinstancelayer t0 WHERE (t0.id = 75 AND t0.wmsinstance = 40) ORDER BY t0.priority ASC, t0.id ASC;

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 = 11;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.name AS name_3,
  t0.abstract AS abstract_4,
  t0.queryable AS queryable_5,
  t0.cascaded AS cascaded_6,
  t0.opaque AS opaque_7,
  t0.noSubset AS noSubset_8,
  t0.fixedWidth AS fixedWidth_9,
  t0.fixedHeight AS fixedHeight_10,
  t0.latlonBounds AS latlonBounds_11,
  t0.boundingBoxes AS boundingBoxes_12,
  t0.srs AS srs_13,
  t0.styles AS styles_14,
  t0.scale AS scale_15,
  t0.attribution AS attribution_16,
  t0.identifier AS identifier_17,
  t0.authority AS authority_18,
  t0.metadataUrl AS metadataUrl_19,
  t0.dimension AS dimension_20,
  t0.dataUrl AS dataUrl_21,
  t0.featureListUrl AS featureListUrl_22,
  t0.priority AS priority_23,
  t0.wmssource AS wmssource_24,
  t0.parent_id AS parent_id_25
FROM
  mb_wms_wmslayersource t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.abstract AS abstract_4, t0.queryable AS queryable_5, t0.cascaded AS cascaded_6, t0.opaque AS opaque_7, t0.noSubset AS noSubset_8, t0.fixedWidth AS fixedWidth_9, t0.fixedHeight AS fixedHeight_10, t0.latlonBounds AS latlonBounds_11, t0.boundingBoxes AS boundingBoxes_12, t0.srs AS srs_13, t0.styles AS styles_14, t0.scale AS scale_15, t0.attribution AS attribution_16, t0.identifier AS identifier_17, t0.authority AS authority_18, t0.metadataUrl AS metadataUrl_19, t0.dimension AS dimension_20, t0.dataUrl AS dataUrl_21, t0.featureListUrl AS featureListUrl_22, t0.priority AS priority_23, t0.wmssource AS wmssource_24, t0.parent_id AS parent_id_25 FROM mb_wms_wmslayersource t0 WHERE t0.id = 13;