GET https://www.preprod-yousg3q-etbsswybjvlic.fr-3.platformsh.site/es/media/525-craneos-y-dentaduras

Query Metrics

19 Database Queries
13 Different statements
124.19 ms Query time
0 Invalid entities
179 Managed entities

Queries

Group similar statements

# Time Info
1 4.04 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:
[
  525
]
2 8.11 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:
[
  525
]
3 2.06 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:
[
  525
]
4 2.16 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:
[
  45
]
5 2.51 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 <= 157 AND n0_.rgt >= 158 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
6 1.62 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:
[
  45
]
7 2.16 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:
[
  48
]
8 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 <= 168 AND n0_.rgt >= 169 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
9 1.56 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:
[
  48
]
10 1.31 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:
[
  122
]
11 1.96 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 <= 65 AND n0_.rgt >= 66 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  106
]
12 1.29 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:
[
  397
]
13 2.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 <= 181 AND n0_.rgt >= 182 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
14 1.41 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:
[
  397
]
15 2.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:
[
  58
  319
  53
  136
  562
  925
]
16 8.77 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:
[
  58
  319
  53
  136
  562
  925
]
17 69.50 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:
[
  3918
  "App\Entity\MediaTranslation:es"
]
18 2.62 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 <= 157 AND n0_.rgt >= 158 AND n0_.root = ? ORDER BY n0_.lft ASC
Parameters:
[
  105
]
19 6.62 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:
[
  30
]

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 58
App\Entity\NodeMedia 49
App\Entity\Media 40
App\Entity\Tag 12
App\Entity\Node 11
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.