GET http://jury.ecotrophelia.org/results

Query Metrics

17 Database Queries
5 Different statements
4.32 ms Query time
0 Invalid entities
96 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.coefficient AS coefficient_3, t0.is_annex AS is_annex_4 FROM criterion t0
Parameters:
[]
2 0.33 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.room_id AS room_id_5 FROM voter t0 WHERE t0.id = ?
Parameters:
[
  15
]
3 0.30 ms
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.voter_id AS voter_id_5, t0.project_id AS project_id_6 FROM vote t0 WHERE t0.voter_id = ?
Parameters:
[
  15
]
4 0.25 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  83
]
5 0.26 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  106
]
6 0.27 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  135
]
7 0.29 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  168
]
8 0.27 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  193
]
9 0.24 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  222
]
10 0.21 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.vote_id AS vote_id_3, t0.criterion_id AS criterion_id_4 FROM vote_score t0 WHERE t0.vote_id = ?
Parameters:
[
  247
]
11 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  18
]
12 0.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  16
]
13 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  20
]
14 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  19
]
15 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  14
]
16 0.20 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  17
]
17 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.short_description AS short_description_3, t0.establishment AS establishment_4, t0.room_id AS room_id_5 FROM project t0 WHERE t0.id = ?
Parameters:
[
  15
]

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\VoteScore 70
App\Entity\Criterion 10
App\Entity\Vote 7
App\Entity\Project 7
App\Entity\Voter 1
App\Entity\Room 1

Entities Mapping

Class Mapping errors
App\Entity\Criterion No errors.
App\Entity\VoteScore No errors.
App\Entity\Voter No errors.
App\Entity\Room No errors.
App\Entity\Vote No errors.
App\Entity\Project No errors.