GET https://forestknowledge.eu/

Query Metrics

32 Database Queries
15 Different statements
27.23 ms Query time
1 Invalid entities
345 Managed entities

Grouped Statements

Show all queries

Time Count Info
7.74 ms
(28.41%)
1
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
  12
  13
  16
  17
  18
  19
  20
  21
  108
  110
  115
  120
  68
  73
  79
]
5.41 ms
(19.88%)
1
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  10
  11
  12
  13
  108
  14
  15
  16
  17
  126
  18
  19
  20
  21
  110
  22
  23
  24
  25
  107
  114
]
2.97 ms
(10.92%)
1
SELECT f0_.id AS id_0, f0_.highlight_disclaimer AS highlight_disclaimer_1, f0_.resources_main_cta AS resources_main_cta_2, f0_.resources_main_cta_text AS resources_main_cta_text_3, f0_.subtitle AS subtitle_4, f0_.resource_date AS resource_date_5, f0_.brief_description AS brief_description_6, f0_.embedded_video AS embedded_video_7, f0_.embedded_video_text AS embedded_video_text_8, f0_.full_description AS full_description_9, f0_.secondary_external_links AS secondary_external_links_10, f0_.autor_source AS autor_source_11, f0_.publication_date AS publication_date_12, f0_.original_publication_year AS original_publication_year_13, f0_.publication_type AS publication_type_14, f0_.spatial_scale AS spatial_scale_15, f0_.type_of_tool AS type_of_tool_16, f0_.license AS license_17, f0_.license_extra AS license_extra_18, f0_.project_id AS project_id_19, f0_.website AS website_20, f0_.degradation_driver AS degradation_driver_21, f0_.context AS context_22, f0_.problem_description AS problem_description_23, f0_.implementation_steps AS implementation_steps_24, f0_.stakeholder_engagement AS stakeholder_engagement_25, f0_.knowledge_types AS knowledge_types_26, f0_.scale_area AS scale_area_27, f0_.replicability AS replicability_28, f0_.replicability_details AS replicability_details_29, f0_.key_success_factors AS key_success_factors_30, f0_.common_constraints AS common_constraints_31, f0_.lessons_learnt AS lessons_learnt_32, f0_.positive_impact_explanation AS positive_impact_explanation_33, f0_.negative_impact_explanation AS negative_impact_explanation_34, f0_.created_at AS created_at_35, f0_.updated_at AS updated_at_36, f0_.title AS title_37, f0_.slug AS slug_38, f0_.language AS language_39, f0_.original_language AS original_language_40, f0_.status AS status_41, f0_.locked_at AS locked_at_42, f0_.frg_resource_content_type_id AS frg_resource_content_type_id_43, f0_.image_id AS image_id_44, f0_.resources_Main_cta_internal_id AS resources_Main_cta_internal_id_45, f0_.created_by_id AS created_by_id_46, f0_.modified_by_id AS modified_by_id_47, f0_.locked_by_id AS locked_by_id_48 FROM frg_resource f0_ WHERE f0_.status = ? AND f0_.resource_date <= ? ORDER BY f0_.resource_date DESC LIMIT 3
Parameters:
[
  "PUBLISHED"
  "2025-10-02 00:00:00"
]
1.66 ms
(6.09%)
8
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
]
1.36 ms
(5.00%)
1
SELECT f0_.id AS id_0, f0_.original_id AS original_id_1, f0_.short_description AS short_description_2, f0_.description AS description_3, f0_.quotation AS quotation_4, f0_.introduction AS introduction_5, f0_.created_at AS created_at_6, f0_.updated_at AS updated_at_7, f0_.title AS title_8, f0_.slug AS slug_9, f0_.language AS language_10, f0_.original_language AS original_language_11, f0_.position AS position_12, f0_.menu_level AS menu_level_13, f0_.menu_index AS menu_index_14, f0_.menu_active AS menu_active_15, f0_.status AS status_16, f0_.parent_id AS parent_id_17, f0_.image_id AS image_id_18, f0_.created_by_id AS created_by_id_19, f0_.modified_by_id AS modified_by_id_20 FROM frg_userjourney f0_ WHERE f0_.parent_id IS NULL AND f0_.status = ? ORDER BY f0_.menu_index ASC LIMIT 4
Parameters:
[
  "PUBLISHED"
]
1.34 ms
(4.92%)
7
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:
[
  245
]
1.14 ms
(4.17%)
1
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.parent_id IN (?, ?, ?, ?)
Parameters:
[
  1
  4
  3
  2
]
1.04 ms
(3.83%)
1
SELECT t0.id AS id_1, t0.short_description AS short_description_2, t0.description AS description_3, t0.first_header AS first_header_4, t0.first_text AS first_text_5, t0.second_header AS second_header_6, t0.second_text AS second_text_7, t0.third_header AS third_header_8, t0.third_text AS third_text_9, t0.fourth_header AS fourth_header_10, t0.fourth_text AS fourth_text_11, t0.fifth_header AS fifth_header_12, t0.fifth_text AS fifth_text_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.title AS title_16, t0.slug AS slug_17, t0.language AS language_18, t0.original_language AS original_language_19, t0.status AS status_20, t0.created_by_id AS created_by_id_21, t0.modified_by_id AS modified_by_id_22 FROM frg_page t0 WHERE t0.slug = ? AND t0.status = ? LIMIT 1
Parameters:
[
  "app_index"
  "PUBLISHED"
]
1.01 ms
(3.70%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.quotation AS quotation_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.image_id AS image_id_6, t0.frg_userjourney_id AS frg_userjourney_id_7, t0.created_by_id AS created_by_id_8, t0.modified_by_id AS modified_by_id_9 FROM frg_testimonial t0 WHERE t0.frg_userjourney_id = ?
Parameters:
[
  1
]
0.83 ms
(3.04%)
1
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"
]
0.66 ms
(2.41%)
1
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
]
0.63 ms
(2.31%)
1
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
  66
  67
]
0.53 ms
(1.96%)
1
SELECT t0.id AS id_1, t0.original_id AS original_id_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.quotation AS quotation_5, t0.introduction AS introduction_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.position AS position_13, t0.menu_level AS menu_level_14, t0.menu_index AS menu_index_15, t0.menu_active AS menu_active_16, t0.status AS status_17, t0.parent_id AS parent_id_18, t0.image_id AS image_id_19, t0.created_by_id AS created_by_id_20, t0.modified_by_id AS modified_by_id_21 FROM frg_userjourney t0 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  89
  93
  96
  29
  30
  31
  32
  33
  34
  35
  36
  37
  122
  123
  124
  125
  115
  116
  117
  118
  151
  119
  120
  121
  132
  133
  134
  135
  136
  137
  138
  139
  153
  154
  97
  98
  99
  105
  111
  112
  113
  145
  100
  101
  102
  103
  127
  143
  144
  104
  128
  129
  130
  131
  106
  146
  147
  148
  149
  150
  152
  109
  140
  141
  142
]
0.51 ms
(1.89%)
1
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
  50
  51
  52
  53
  54
  55
  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
  69
  70
  71
  72
  74
  75
  76
  77
  78
  80
  81
  82
  109
  111
  112
  113
  114
  116
  117
  118
  119
]
0.40 ms
(1.47%)
2
SELECT t0.id AS id_1, t0.resource_count AS resource_count_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.position AS position_5, t0.menu_level AS menu_level_6, t0.menu_index AS menu_index_7, t0.menu_active AS menu_active_8, t0.title AS title_9, t0.slug AS slug_10, t0.language AS language_11, t0.original_language AS original_language_12, t0.parent_id AS parent_id_13, t0.created_by_id AS created_by_id_14, t0.modified_by_id AS modified_by_id_15 FROM frg_resource_taxonomies t0 WHERE t0.id = ?
Parameters:
[
  53
]

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\FrgImage 119
App\Entity\FrgGuidelines 93
App\Entity\FrgUserjourney 90
App\Entity\FrgUser 16
App\Entity\FrgMenu 9
App\Entity\FrgTestimonial 8
App\Entity\FrgResource 3
App\Entity\FrgResourceTaxonomies 3
App\Entity\FrgDocument 3
App\Entity\FrgPage 1

Entities Mapping

Class Mapping errors
App\Entity\FrgPage No errors.
App\Entity\FrgUser No errors.
App\Entity\FrgImage No errors.
App\Entity\FrgUserjourney 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\FrgTestimonial No errors.
App\Entity\FrgResourceTaxonomies No errors.
App\Entity\FrgDocument No errors.
App\Entity\FrgGuidelines No errors.
App\Entity\FrgCountry No errors.
App\Entity\FrgMenu No errors.