GET https://dev.slice.postlab.fr/alignment/2677983-240301-110522000-txt-2677983-240301-110522000-mp4-rc9m79t6

Query Metrics

9 Database Queries
9 Different statements
3.26 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.15 ms
SELECT t0.id AS id_1, t0.text_start AS text_start_2, t0.text_length AS text_length_3, t0.video_start AS video_start_4, t0.video_duration AS video_duration_5, t0.informator AS informator_6, t0.text_content AS text_content_7, t0.is_validated AS is_validated_8, t0.slug AS slug_9, t0.text_id AS text_id_10, t0.video_id AS video_id_11, t0.creator_id AS creator_id_12 FROM alignment t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "2677983-240301-110522000-txt-2677983-240301-110522000-mp4-rc9m79t6"
]
2 0.36 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.description AS description_5, t0.content AS content_6, t0.language AS language_7, t0.domain AS domain_8, t0.creator_id AS creator_id_9, t0.project_id AS project_id_10 FROM text t0 WHERE t0.id = ?
Parameters:
[
  403
]
3 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.acronym AS acronym_4, t0.website AS website_5, t0.logo AS logo_6 FROM organism t0 INNER JOIN text_organism ON t0.id = text_organism.organism_id WHERE text_organism.text_id = ?
Parameters:
[
  403
]
4 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.type AS type_4, t0.url AS url_5, t0.path AS path_6, t0.size AS size_7, t0.organism_id AS organism_id_8 FROM media t0 WHERE t0.organism_id = ?
Parameters:
[
  2
]
5 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.slug AS slug_9, t0.activation_token AS activation_token_10, t0.full_name AS full_name_11 FROM user t0 WHERE t0.id = ?
Parameters:
[
  12
]
6 0.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.slug AS slug_9, t0.activation_token AS activation_token_10, t0.full_name AS full_name_11 FROM user t0 INNER JOIN alignment_editors ON t0.id = alignment_editors.user_id WHERE alignment_editors.alignment_id = ?
Parameters:
[
  730
]
7 0.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.created_at AS created_at_8, t0.slug AS slug_9, t0.activation_token AS activation_token_10, t0.full_name AS full_name_11 FROM user t0 INNER JOIN alignment_moderators ON t0.id = alignment_moderators.user_id WHERE alignment_moderators.alignment_id = ?
Parameters:
[
  730
]
8 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.path AS path_4, t0.description AS description_5, t0.handedness AS handedness_6, t0.gender AS gender_7, t0.front_image AS front_image_8, t0.language AS language_9, t0.domain AS domain_10, t0.creator_id AS creator_id_11, t0.project_id AS project_id_12 FROM video t0 WHERE t0.id = ?
Parameters:
[
  403
]
9 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.website AS website_4, t0.slug AS slug_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Alignment No errors.
App\Entity\Text No errors.
App\Entity\Video No errors.
App\Entity\User No errors.
App\Entity\Project No errors.
App\Entity\Organism No errors.
App\Entity\Media No errors.
App\Entity\Page No errors.