GET https://dev.slice.postlab.fr/alignment/?page=5

Response
200 OK
IP
3.14.249.191
Profiled on
Token
7812b1

Query Metrics

31 Database Queries
7 Different statements
7.42 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.50 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
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.22 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
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 0.65 ms 
SELECT a0_.id AS id_0, a0_.text_start AS text_start_1, a0_.text_length AS text_length_2, a0_.video_start AS video_start_3, a0_.video_duration AS video_duration_4, a0_.informator AS informator_5, a0_.text_content AS text_content_6, a0_.is_validated AS is_validated_7, a0_.slug AS slug_8, a0_.text_id AS text_id_9, a0_.video_id AS video_id_10, a0_.creator_id AS creator_id_11 FROM alignment a0_ WHERE a0_.is_validated = ?
Parameters: 
[
  "1"
]
View formatted query    View runnable query    Explain query
4 0.33 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: 
[
  420
]
View formatted query    View runnable query    Explain query
5 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: 
[
  420
]
View formatted query    View runnable query    Explain query
6 0.23 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
]
View formatted query    View runnable query    Explain query
7 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: 
[
  420
]
View formatted query    View runnable query    Explain query
8 0.23 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: 
[
  421
]
View formatted query    View runnable query    Explain query
9 0.22 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: 
[
  421
]
View formatted query    View runnable query    Explain query
10 0.19 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: 
[
  421
]
View formatted query    View runnable query    Explain query
11 0.18 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: 
[
  423
]
View formatted query    View runnable query    Explain query
12 0.20 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: 
[
  423
]
View formatted query    View runnable query    Explain query
13 0.18 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: 
[
  423
]
View formatted query    View runnable query    Explain query
14 0.21 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: 
[
  424
]
View formatted query    View runnable query    Explain query
15 0.23 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: 
[
  424
]
View formatted query    View runnable query    Explain query
16 0.22 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: 
[
  424
]
View formatted query    View runnable query    Explain query
17 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.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: 
[
  425
]
View formatted query    View runnable query    Explain query
18 0.25 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: 
[
  425
]
View formatted query    View runnable query    Explain query
19 0.22 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: 
[
  425
]
View formatted query    View runnable query    Explain query
20 0.21 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: 
[
  426
]
View formatted query    View runnable query    Explain query
21 0.23 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: 
[
  426
]
View formatted query    View runnable query    Explain query
22 0.18 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: 
[
  426
]
View formatted query    View runnable query    Explain query
23 0.18 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: 
[
  427
]
View formatted query    View runnable query    Explain query
24 0.20 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: 
[
  427
]
View formatted query    View runnable query    Explain query
25 0.23 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: 
[
  427
]
View formatted query    View runnable query    Explain query
26 0.17 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: 
[
  428
]
View formatted query    View runnable query    Explain query
27 0.20 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: 
[
  428
]
View formatted query    View runnable query    Explain query
28 0.21 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: 
[
  428
]
View formatted query    View runnable query    Explain query
29 0.21 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: 
[
  429
]
View formatted query    View runnable query    Explain query
30 0.21 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: 
[
  429
]
View formatted query    View runnable query    Explain query
31 0.18 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: 
[
  429
]
View formatted query    View runnable query    Explain query

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\Organism No errors.
App\Entity\Media No errors.
App\Entity\Text No errors.
App\Entity\Video No errors.
App\Entity\Project No errors.
App\Entity\User No errors.
App\Entity\Alignment No errors.
App\Entity\Page No errors.