GET https://forestknowledge.eu/guidelines/2-6-grazing-for-maintaining-open-spaces

Query Metrics

25 Database Queries
14 Different statements
9.83 ms Query time
1 Invalid entities
158 Managed entities

Queries

Group similar statements

# Time Info
1 0.96 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.entity_id AS entity_id_5, t0.entity_class AS entity_class_6 FROM frg_slug_record t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "2-6-grazing-for-maintaining-open-spaces"
]
2 0.36 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.id = ?
Parameters:
[
  55
]
3 0.36 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?)
Parameters:
[
  55
]
4 0.28 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.id = ?
Parameters:
[
  12
]
5 0.34 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?)
Parameters:
[
  12
]
6 0.26 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?)
Parameters:
[
  50
  51
  52
  53
  54
]
7 0.21 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.id = ?
Parameters:
[
  7
]
8 0.25 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?)
Parameters:
[
  7
]
9 0.69 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  8
  10
  11
  13
  16
  17
  18
  19
  20
  21
]
10 0.46 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  9
  14
  15
  56
  57
  58
  59
  60
  61
  62
  63
  64
  65
  48
  49
  44
  45
  46
  47
  37
  38
  39
  40
  41
  42
  43
  123
  124
  35
  36
  26
  27
  28
  29
  30
  31
  32
  33
  34
  22
  23
  24
  25
  121
  122
]
11 0.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id IS NULL AND t0.menu_active = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
12 0.36 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
13 0.31 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  2
]
14 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
15 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  3883
]
16 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  3886
]
17 0.23 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  3885
]
18 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  3884
]
19 0.45 ms
SELECT f0_.id AS id_0, f0_.original_id AS original_id_1, f0_.short_description AS short_description_2, f0_.introduction AS introduction_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.title AS title_6, f0_.slug AS slug_7, f0_.language AS language_8, f0_.original_language AS original_language_9, f0_.position AS position_10, f0_.menu_level AS menu_level_11, f0_.menu_index AS menu_index_12, f0_.menu_active AS menu_active_13, f0_.status AS status_14, f0_.parent_id AS parent_id_15, f0_.image_id AS image_id_16, f0_.created_by_id AS created_by_id_17, f0_.modified_by_id AS modified_by_id_18 FROM frg_guidelines f0_ WHERE f0_.parent_id IS NULL AND f0_.status IN (?) ORDER BY f0_.menu_index ASC
Parameters:
[
  "PUBLISHED"
]
20 0.37 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?)
Parameters:
[
  66
  67
]
21 0.96 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  108
  110
  115
  120
  68
  73
  79
]
22 0.43 ms
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.introduction AS introduction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.slug AS slug_8, t0.language AS language_9, t0.original_language AS original_language_10, t0.position AS position_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.status AS status_15, t0.parent_id AS parent_id_16, t0.image_id AS image_id_17, t0.created_by_id AS created_by_id_18, t0.modified_by_id AS modified_by_id_19 FROM frg_guidelines t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  69
  70
  71
  72
  74
  75
  76
  77
  78
  80
  81
  82
  109
  111
  112
  113
  114
  116
  117
  118
  119
]
23 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.language AS language_3, t0.original_language AS original_language_4, t0.original_menu_id AS original_menu_id_5, t0.route AS route_6, t0.link AS link_7, t0.icon AS icon_8, t0.position AS position_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.menu_level AS menu_level_12, t0.menu_index AS menu_index_13, t0.menu_active AS menu_active_14, t0.parent_id AS parent_id_15, t0.created_by_id AS created_by_id_16, t0.modified_by_id AS modified_by_id_17 FROM frg_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  5
]
24 0.33 ms
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.filename AS filename_3, t0.title AS title_4, t0.description AS description_5, t0.main_image AS main_image_6, t0.target_resource AS target_resource_7, t0.has_variants AS has_variants_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.frg_resource_id AS frg_resource_id_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13 FROM frg_image t0 WHERE t0.id = ?
Parameters:
[
  370
]
25 0.54 ms
SELECT t0.id AS id_1, t0.highlight_disclaimer AS highlight_disclaimer_2, t0.resources_main_cta AS resources_main_cta_3, t0.resources_main_cta_text AS resources_main_cta_text_4, t0.subtitle AS subtitle_5, t0.resource_date AS resource_date_6, t0.brief_description AS brief_description_7, t0.embedded_video AS embedded_video_8, t0.embedded_video_text AS embedded_video_text_9, t0.full_description AS full_description_10, t0.secondary_external_links AS secondary_external_links_11, t0.autor_source AS autor_source_12, t0.publication_date AS publication_date_13, t0.original_publication_year AS original_publication_year_14, t0.publication_type AS publication_type_15, t0.spatial_scale AS spatial_scale_16, t0.type_of_tool AS type_of_tool_17, t0.license AS license_18, t0.license_extra AS license_extra_19, t0.project_id AS project_id_20, t0.website AS website_21, t0.degradation_driver AS degradation_driver_22, t0.context AS context_23, t0.problem_description AS problem_description_24, t0.implementation_steps AS implementation_steps_25, t0.stakeholder_engagement AS stakeholder_engagement_26, t0.knowledge_types AS knowledge_types_27, t0.scale_area AS scale_area_28, t0.replicability AS replicability_29, t0.replicability_details AS replicability_details_30, t0.key_success_factors AS key_success_factors_31, t0.common_constraints AS common_constraints_32, t0.lessons_learnt AS lessons_learnt_33, t0.positive_impact_explanation AS positive_impact_explanation_34, t0.negative_impact_explanation AS negative_impact_explanation_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.title AS title_38, t0.slug AS slug_39, t0.language AS language_40, t0.original_language AS original_language_41, t0.status AS status_42, t0.locked_at AS locked_at_43, t0.frg_resource_content_type_id AS frg_resource_content_type_id_44, t0.image_id AS image_id_45, t0.resources_Main_cta_internal_id AS resources_Main_cta_internal_id_46, t0.created_by_id AS created_by_id_47, t0.modified_by_id AS modified_by_id_48, t0.locked_by_id AS locked_by_id_49 FROM frg_resource t0 INNER JOIN frg_guidelines_frg_resource ON t0.id = frg_guidelines_frg_resource.frg_resource_id WHERE frg_guidelines_frg_resource.frg_guidelines_id = ?
Parameters:
[
  55
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FrgGuidelines 93
App\Entity\FrgImage 43
App\Entity\FrgUser 12
App\Entity\FrgMenu 9
App\Entity\FrgSlugRecord 1

Entities Mapping

Class Mapping errors
App\Entity\FrgSlugRecord No errors.
App\Entity\FrgGuidelines No errors.
App\Entity\FrgImage No errors.
App\Entity\FrgUser No errors.
App\Entity\FrgResource
  • If association App\Entity\FrgResource#positiveImpact is many-to-many, then the inversed side App\Entity\FrgResourceTaxonomies#positiveImpactResources has to be many-to-many as well.
  • If association App\Entity\FrgResource#negativeImpact is many-to-many, then the inversed side App\Entity\FrgResourceTaxonomies#negativeImpactResources has to be many-to-many as well.
App\Entity\FrgMenu No errors.
App\Entity\FrgPage No errors.
App\Entity\FrgTestimonial No errors.
App\Entity\FrgResourceTaxonomies No errors.
App\Entity\FrgDocument No errors.