GET https://junior.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/de/media/976-das-wassereinzugsgebiet

Query Metrics

21 Database Queries
14 Different statements
135.59 ms Query time
0 Invalid entities
174 Managed entities

Queries

Group similar statements

# Time Info
1 4.81 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_wide AS is_wide_3, t0.thumbnail_name AS thumbnail_name_4, t0.thumbnail_background AS thumbnail_background_5, t0.project_id AS project_id_6, t0.is_expert AS is_expert_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM media t0 WHERE t0.id = ?
Parameters:
[
  976
]
2 4.96 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.legends AS legends_4, t0.goals AS goals_5, t0.more AS more_6, t0.scenario AS scenario_7, t0.features AS features_8, t0.published_at AS published_at_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.locale AS locale_13, t0.translatable_id AS translatable_id_14 FROM media_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  976
]
3 2.43 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.node_id AS node_id_3, t0.media_id AS media_id_4 FROM node_media t0 WHERE t0.media_id = ?
Parameters:
[
  976
]
4 2.81 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.id = ?
Parameters:
[
  49
]
5 2.66 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 135 AND n0_.rgt >= 136 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
6 1.56 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.id = ?
Parameters:
[
  128
]
7 2.07 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 47 AND n0_.rgt >= 48 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
8 1.85 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.node_id AS node_id_3, t0.media_id AS media_id_4 FROM node_media t0 WHERE t0.node_id = ? ORDER BY t0.position ASC
Parameters:
[
  128
]
9 3.63 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.id = ?
Parameters:
[
  131
]
10 1.52 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 39 AND n0_.rgt >= 40 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
11 1.05 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.node_id AS node_id_3, t0.media_id AS media_id_4 FROM node_media t0 WHERE t0.node_id = ? ORDER BY t0.position ASC
Parameters:
[
  131
]
12 1.14 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.id = ?
Parameters:
[
  351
]
13 1.15 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 139 AND n0_.rgt >= 140 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
14 1.02 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.root AS root_5, t0.lvl AS lvl_6, t0.lft AS lft_7, t0.rgt AS rgt_8, t0.status AS status_9, t0.parent_id AS parent_id_10 FROM node t0 WHERE t0.id = ?
Parameters:
[
  423
]
15 2.00 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 151 AND n0_.rgt >= 152 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
16 1.89 ms
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.is_wide AS is_wide_2, m0_.thumbnail_name AS thumbnail_name_3, m0_.thumbnail_background AS thumbnail_background_4, m0_.project_id AS project_id_5, m0_.is_expert AS is_expert_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8 FROM media m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  685
  533
  148
  615
  172
  245
]
17 21.08 ms
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.description AS description_2, m0_.legends AS legends_3, m0_.goals AS goals_4, m0_.more AS more_5, m0_.scenario AS scenario_6, m0_.features AS features_7, m0_.published_at AS published_at_8, m0_.status AS status_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.locale AS locale_12, m0_.translatable_id AS translatable_id_13 FROM media_translation m0_ WHERE m0_.translatable_id IN (?, ?, ?, ?, ?, ?)
Parameters:
[
  685
  533
  148
  615
  172
  245
]
18 70.70 ms
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id AND (t1_.resource_id = ? AND t1_.resource_type = ?) ORDER BY t0_.name ASC
Parameters:
[
  7138
  "App\Entity\MediaTranslation:de"
]
19 3.65 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 135 AND n0_.rgt >= 136 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
20 1.63 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.created_at AS created_at_2, n0_.updated_at AS updated_at_3, n0_.root AS root_4, n0_.lvl AS lvl_5, n0_.lft AS lft_6, n0_.rgt AS rgt_7, n0_.status AS status_8, n0_.parent_id AS parent_id_9 FROM node n0_ WHERE n0_.lft <= 47 AND n0_.rgt >= 48 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
21 1.98 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM node_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  110
]

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\MediaTranslation 60
App\Entity\NodeMedia 47
App\Entity\Media 39
App\Entity\Node 10
App\Entity\Tag 9
App\Entity\NodeTranslation 9

Entities Mapping

Class Mapping errors
App\Entity\Media No errors.
App\Entity\MediaTranslation No errors.
App\Entity\NodeMedia No errors.
App\Entity\TranslationJobItem No errors.
App\Entity\Node No errors.
App\Entity\NodeTranslation No errors.
App\Entity\Tag No errors.
App\Entity\Tagging No errors.