Query Metrics
17
Database Queries
3
Different statements
11.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.80 ms |
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 | 1.18 ms |
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
]
|
| 3 | 1.15 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"user10@42b.it"
]
|
| 4 | 0.54 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"picerni.antonio@gmail.com"
]
|
| 5 | 0.54 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"tutor01@cafoscarichallengeschool.it"
]
|
| 6 | 0.52 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"tutor08@cafoscarichallengeschool.it"
]
|
| 7 | 0.53 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"olimpia.demari@unive.it"
]
|
| 8 | 0.48 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"lorenzo.paolini@unive.it"
]
|
| 9 | 0.46 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"carlotta.barina@unive.it"
]
|
| 10 | 0.48 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"irene.fontolan@unive.it"
]
|
| 11 | 0.46 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"francesca.mariotto@unive.it"
]
|
| 12 | 0.48 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"elizageorgiana.oanca@unive.it"
]
|
| 13 | 0.66 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"silvia.rancan@unive.it"
]
|
| 14 | 0.87 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"manuela.torri@unive.it"
]
|
| 15 | 0.71 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"user11@42b.it"
]
|
| 16 | 0.70 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"tutor02@cafoscarichallengeschool.it"
]
|
| 17 | 0.84 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.corsi_moodle AS corsi_moodle_6 FROM users t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"tutor09@cafoscarichallengeschool.it"
]
|
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. |