GET https://forestknowledge.eu/resources/growing-non-native-trees-in-european-forests

Response
200 OK
IP
216.73.216.217
Profiled on
Token
931276

Query Metrics

24 Database Queries
15 Different statements
8.15 ms Query time
1 Invalid entities
169 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.74 ms
(21.42%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
1.43 ms
(17.52%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.76 ms
(9.28%) 		1 
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 WHERE t0.slug = ? AND t0.status = ? LIMIT 1
Parameters: 
[
  "growing-non-native-trees-in-european-forests"
  "PUBLISHED"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.72 ms
(8.84%) 		3 
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: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
0.60 ms
(7.34%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.55 ms
(6.80%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.40 ms
(4.87%) 		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"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.33 ms
(4.08%) 		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
]
View formatted query    View runnable query    Explain query    View query backtrace
0.27 ms
(3.28%) 		1 
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 INNER JOIN frg_resource_purposes ON t0.id = frg_resource_purposes.frg_resource_taxonomies_id WHERE frg_resource_purposes.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(2.97%) 		1 
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 INNER JOIN frg_resource_biografhic_regions ON t0.id = frg_resource_biografhic_regions.frg_resource_taxonomies_id WHERE frg_resource_biografhic_regions.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(2.91%) 		1 
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 INNER JOIN frg_resource_profiles ON t0.id = frg_resource_profiles.frg_resource_taxonomies_id WHERE frg_resource_profiles.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
0.24 ms
(2.91%) 		1 
SELECT t0.id AS id_1, t0.code_iso2 AS code_iso2_2, t0.code_iso3 AS code_iso3_3, t0.code_iso4 AS code_iso4_4, t0.name AS name_5, t0.flag_icon AS flag_icon_6 FROM frg_country t0 INNER JOIN frg_resource_countries ON t0.id = frg_resource_countries.frg_country_id WHERE frg_resource_countries.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
0.22 ms
(2.69%) 		1 
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.filename AS filename_3, t0.title AS title_4, t0.documents_cta AS documents_cta_5, t0.target_resource AS target_resource_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.frg_resource_id AS frg_resource_id_9, t0.created_by_id AS created_by_id_10, t0.modified_by_id AS modified_by_id_11 FROM frg_document t0 WHERE t0.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(2.58%) 		1 
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.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(2.51%) 		1 
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 INNER JOIN frg_resource_topics ON t0.id = frg_resource_topics.frg_resource_taxonomies_id WHERE frg_resource_topics.frg_resource_id = ?
Parameters: 
[
  89
]
View formatted query    View runnable query    Explain query    View query backtrace

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 13
App\Entity\FrgResourceTaxonomies 10
App\Entity\FrgMenu 9
App\Entity\FrgResource 1

Entities Mapping

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