GET https://junior.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/en/media/825-video-history-of-transportation

Query Metrics

19 Database Queries
12 Different statements
177.54 ms Query time
0 Invalid entities
156 Managed entities

Queries

Group similar statements

# Time Info
1 4.42 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:
[
  825
]
2 9.43 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:
[
  825
]
3 1.94 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:
[
  825
]
4 2.05 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.02 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.12 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
]
7 1.30 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
]
8 1.38 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
]
9 1.80 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:
[
  133
]
10 1.78 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 <= 31 AND n0_.rgt >= 32 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
11 1.17 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:
[
  133
]
12 1.49 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:
[
  24
]
13 1.50 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 <= 31 AND n0_.rgt >= 32 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
14 2.22 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:
[
  354
  826
  811
  80
  13
  42
]
15 9.81 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:
[
  354
  826
  811
  80
  13
  42
]
16 125.26 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:
[
  6444
  "App\Entity\MediaTranslation:en"
]
17 2.11 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
]
18 3.49 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
]
19 3.27 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 53
App\Entity\NodeMedia 41
App\Entity\Media 35
App\Entity\Node 10
App\Entity\NodeTranslation 9
App\Entity\Tag 8

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.