Query Metrics
70
Database Queries
13
Different statements
38.42 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 2.85 ms |
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
Parameters:
[
"3p_v2"
]
|
2 | 1.01 ms |
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'
Parameters:
[] |
3 | 1.79 ms |
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
Parameters:
[
37
]
|
4 | 0.71 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1147
]
|
5 | 0.53 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1146
]
|
6 | 0.42 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1145
]
|
7 | 0.40 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1148
]
|
8 | 0.39 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1152
]
|
9 | 0.39 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1151
]
|
10 | 0.40 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1149
]
|
11 | 0.38 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1150
]
|
12 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1154
]
|
13 | 0.35 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1153
]
|
14 | 0.34 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1155
]
|
15 | 0.34 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1156
]
|
16 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1157
]
|
17 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1160
]
|
18 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1159
]
|
19 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1158
]
|
20 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1163
]
|
21 | 0.43 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1164
]
|
22 | 0.41 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1161
]
|
23 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1162
]
|
24 | 0.39 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1166
]
|
25 | 0.34 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1165
]
|
26 | 0.34 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1167
]
|
27 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1168
]
|
28 | 0.33 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1171
]
|
29 | 0.37 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1169
]
|
30 | 0.36 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1172
]
|
31 | 0.34 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1170
]
|
32 | 0.35 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1173
]
|
33 | 0.24 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1175
]
|
34 | 0.24 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1174
]
|
35 | 0.25 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1176
]
|
36 | 0.34 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1177
]
|
37 | 0.31 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1178
]
|
38 | 0.65 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM fom_permission f0_ WHERE (f0_.element_id = ? AND f0_.resource_domain = 'element')
Parameters:
[
1179
]
|
39 | 1.58 ms |
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 (?, ?, ?, ?, ?, ?)
Parameters:
[ "EPSG:3857" "EPSG:25832" "EPSG:25833" "EPSG:31466" "EPSG:31467" "EPSG:4326" ] |
40 | 1.19 ms |
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
Parameters:
[
37
]
|
41 | 2.64 ms |
SELECT t0.weight AS weight_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.title AS title_6, t0.basesource AS basesource_7, t0.layerset AS layerset_8, t0.discr, t1.srs AS srs_9, t1.format AS format_10, t1.infoformat AS infoformat_11, t1.exceptionformat AS exceptionformat_12, t1.transparency AS transparency_13, t1.opacity AS opacity_14, t1.proxy AS proxy_15, t1.tiled AS tiled_16, t1.dimensions AS dimensions_17, t1.vendorspecifics AS vendorspecifics_18, t1.buffer AS buffer_19, t1.ratio AS ratio_20, t1.layerOrder AS layerorder_21, t1.wmssource AS wmssource_22, t2.opacity AS opacity_23, t2.proxy AS proxy_24, t2.wmtssource AS wmtssource_25 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 WHERE t0.layerset = ? ORDER BY t0.weight ASC
Parameters:
[
153
]
|
42 | 0.77 ms |
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
Parameters:
[
153
]
|
43 | 1.44 ms |
SELECT t0.weight AS weight_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.title AS title_6, t0.basesource AS basesource_7, t0.layerset AS layerset_8, t0.discr, t1.srs AS srs_9, t1.format AS format_10, t1.infoformat AS infoformat_11, t1.exceptionformat AS exceptionformat_12, t1.transparency AS transparency_13, t1.opacity AS opacity_14, t1.proxy AS proxy_15, t1.tiled AS tiled_16, t1.dimensions AS dimensions_17, t1.vendorspecifics AS vendorspecifics_18, t1.buffer AS buffer_19, t1.ratio AS ratio_20, t1.layerOrder AS layerorder_21, t1.wmssource AS wmssource_22, t2.opacity AS opacity_23, t2.proxy AS proxy_24, t2.wmtssource AS wmtssource_25 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 WHERE t0.layerset = ? ORDER BY t0.weight ASC
Parameters:
[
154
]
|
44 | 0.46 ms |
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
Parameters:
[
154
]
|
45 | 1.94 ms |
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 = ?
Parameters:
[
46
]
|
46 | 0.85 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.wmsinstance = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
327
]
|
47 | 0.42 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1620
]
|
48 | 0.32 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1621
]
|
49 | 0.30 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1622
]
|
50 | 0.29 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1623
]
|
51 | 0.28 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1624
]
|
52 | 0.28 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1625
]
|
53 | 0.28 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1626
]
|
54 | 0.88 ms |
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 = ?
Parameters:
[
348
]
|
55 | 0.53 ms |
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.wmssource = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
46
]
|
56 | 0.51 ms |
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 = ?
Parameters:
[
45
]
|
57 | 0.37 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.wmsinstance = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
328
]
|
58 | 0.32 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1627
]
|
59 | 0.30 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1628
]
|
60 | 0.25 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1629
]
|
61 | 0.28 ms |
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 = ?
Parameters:
[
345
]
|
62 | 0.33 ms |
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.wmssource = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
45
]
|
63 | 0.68 ms |
SELECT t0.weight AS weight_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.title AS title_6, t0.basesource AS basesource_7, t0.layerset AS layerset_8, t0.discr, t1.srs AS srs_9, t1.format AS format_10, t1.infoformat AS infoformat_11, t1.exceptionformat AS exceptionformat_12, t1.transparency AS transparency_13, t1.opacity AS opacity_14, t1.proxy AS proxy_15, t1.tiled AS tiled_16, t1.dimensions AS dimensions_17, t1.vendorspecifics AS vendorspecifics_18, t1.buffer AS buffer_19, t1.ratio AS ratio_20, t1.layerOrder AS layerorder_21, t1.wmssource AS wmssource_22, t2.opacity AS opacity_23, t2.proxy AS proxy_24, t2.wmtssource AS wmtssource_25 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 WHERE t0.layerset = ? ORDER BY t0.weight ASC
Parameters:
[
155
]
|
64 | 0.27 ms |
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
Parameters:
[
155
]
|
65 | 0.28 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.wmsinstance = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
333
]
|
66 | 0.27 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1677
]
|
67 | 0.25 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1678
]
|
68 | 0.27 ms |
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.wmsinstance AS wmsinstance_14, t0.wmslayersource AS wmslayersource_15, t0.parent AS parent_16 FROM mb_wms_wmsinstancelayer t0 WHERE t0.parent = ? ORDER BY t0.priority ASC, t0.id ASC
Parameters:
[
1679
]
|
69 | 0.65 ms |
SELECT t0.weight AS weight_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.title AS title_6, t0.basesource AS basesource_7, t0.layerset AS layerset_8, t0.discr, t1.srs AS srs_9, t1.format AS format_10, t1.infoformat AS infoformat_11, t1.exceptionformat AS exceptionformat_12, t1.transparency AS transparency_13, t1.opacity AS opacity_14, t1.proxy AS proxy_15, t1.tiled AS tiled_16, t1.dimensions AS dimensions_17, t1.vendorspecifics AS vendorspecifics_18, t1.buffer AS buffer_19, t1.ratio AS ratio_20, t1.layerOrder AS layerorder_21, t1.wmssource AS wmssource_22, t2.opacity AS opacity_23, t2.proxy AS proxy_24, t2.wmtssource AS wmtssource_25 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 WHERE t0.layerset = ? ORDER BY t0.weight ASC
Parameters:
[
156
]
|
70 | 0.26 ms |
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
Parameters:
[
156
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
geodata_db | doctrine.dbal.geodata_db_connection |
ne2 | doctrine.dbal.ne2_connection |
alkis | doctrine.dbal.alkis_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.