Query Metrics
17
Database Queries
3
Different statements
10.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.28 ms (57.67%) |
15 |
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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"user10@42b.it"
]
|
|
2.57 ms (23.58%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.username AS username_3, t0.password AS password_4, t0.token AS token_5, t0.created_at AS created_at_6, t0.tipo AS tipo_7, t0.name AS name_8, t0.iv AS iv_9, t0.tag AS tag_10, t0.apikey AS apikey_11, t0.apisecret AS apisecret_12, t0.user_id AS user_id_13 FROM users_ambienti t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"https://fad.cafoscarichallengeschool.it"
]
|
|
2.04 ms (18.75%) |
1 |
SELECT q0_.id AS id_0, q0_.titolo AS titolo_1, q0_.descrizione AS descrizione_2, q0_.created_at AS created_at_3, q0_.corso_id AS corso_id_4, q0_.corso_title AS corso_title_5, q0_.token AS token_6, q0_.anonimo AS anonimo_7, q0_.user_id AS user_id_8, q0_.ambiente_id AS ambiente_id_9, q0_.questionario_id AS questionario_id_10 FROM questionari q0_ WHERE q0_.ambiente_id = ? AND q0_.corso_id IS NOT NULL ORDER BY q0_.id ASC
Parameters:
[
11
]
|
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\UsersAmbienti | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\Questionari | No errors. |
| App\Entity\QuestionariIniziati | No errors. |
| App\Entity\Estrazioni | No errors. |
| App\Entity\Domande | No errors. |
| App\Entity\Risposte | No errors. |