GET https://junior.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/es/media/334-la-bicicleta

Query Metrics

15 Database Queries
11 Different statements
140.83 ms Query time
0 Invalid entities
126 Managed entities

Queries

Group similar statements

# Time Info
1 4.75 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:
[
  334
]
2 9.68 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:
[
  334
]
3 2.82 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:
[
  334
]
4 2.17 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
]
5 4.06 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
]
6 1.78 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
]
7 1.88 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:
[
  65
]
8 17.54 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 <= 118 AND n0_.rgt >= 119 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
9 8.86 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
]
10 4.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
]
11 1.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:
[
  522
  132
  341
  42
  809
  576
]
12 2.22 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:
[
  522
  132
  341
  42
  809
  576
]
13 67.47 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:
[
  2170
  "App\Entity\MediaTranslation:es"
]
14 2.68 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
]
15 9.19 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 55
App\Entity\NodeMedia 23
App\Entity\Media 21
App\Entity\Node 9
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.