GET https://junior.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/fr/media/908-quiz-calendrier

Query Metrics

14 Database Queries
11 Different statements
123.74 ms Query time
0 Invalid entities
140 Managed entities

Queries

Group similar statements

# Time Info
1 10.29 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:
[
  908
]
2 20.22 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:
[
  908
]
3 2.49 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:
[
  908
]
4 14.54 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:
[
  140
]
5 14.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 <= 33 AND n0_.rgt >= 34 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
6 1.28 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:
[
  140
]
7 0.84 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:
[
  405
]
8 12.76 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 <= 12 AND n0_.rgt >= 13 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
9 1.07 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:
[
  405
]
10 1.13 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:
[
  907
  805
  768
  716
  764
  201
]
11 5.91 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:
[
  907
  805
  768
  716
  764
  201
]
12 27.08 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:
[
  6802
  "App\Entity\MediaTranslation:fr"
]
13 1.45 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 <= 33 AND n0_.rgt >= 34 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
14 10.36 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:
[
  111
]

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 56
App\Entity\NodeMedia 32
App\Entity\Media 31
App\Entity\NodeTranslation 9
App\Entity\Node 6
App\Entity\Tag 6

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.