Query Metrics
22
Database Queries
7
Different statements
5.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.32 ms (23.77%) |
6 |
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:
[
415
]
|
|
1.30 ms (23.32%) |
6 |
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:
[
415
]
|
|
1.21 ms (21.80%) |
6 |
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:
[
415
]
|
|
0.69 ms (12.46%) |
1 |
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"
]
|
|
0.50 ms (9.07%) |
1 |
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:
[] |
|
0.29 ms (5.13%) |
1 |
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
]
|
|
0.25 ms (4.45%) |
1 |
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:
[] |
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. |