GET https://forestknowledge.eu/guidelines/measuring-reporting-and-verification-of-forest-restoration

Query Metrics

18 Database Queries
11 Different statements
7.16 ms Query time
1 Invalid entities
158 Managed entities

Queries

Group similar statements

# Time Info
1 0.88 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:
[
  "measuring-reporting-and-verification-of-forest-restoration"
]
2 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.id = ?
Parameters:
[
  67
]
3 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:
[
  67
]
4 0.86 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:
[
  68
  73
  79
]
5 0.27 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
]
6 0.40 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
]
7 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:
[
  1
]
8 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:
[
  2
]
9 0.18 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
]
10 0.17 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
]
11 0.13 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
]
12 0.14 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
]
13 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:
[
  3884
]
14 0.42 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"
]
15 0.38 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
  66
]
16 0.88 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
  12
  13
  16
  17
  18
  19
  20
  21
  108
  110
  115
  120
]
17 0.56 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
  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
  109
  111
  112
  113
  114
  116
  117
  118
  119
]
18 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:
[
  5
]

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.