Query Metrics
6
Database Queries
6
Different statements
4.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.95 ms (19.51%) |
1 |
SELECT t0.id AS id_1, t0.domanda AS domanda_2, t0.tipo_risposta AS tipo_risposta_3, t0.opzioni_risposta AS opzioni_risposta_4, t0.multipla AS multipla_5, t0.posizione AS posizione_6, t0.mostra_posizione AS mostra_posizione_7, t0.created_at AS created_at_8, t0.placeholder AS placeholder_9, t0.obbligatoria AS obbligatoria_10, t0.questionario_id AS questionario_id_11, t0.dipende_da_id AS dipende_da_id_12 FROM domande t0 WHERE t0.questionario_id = ? ORDER BY t0.posizione ASC
Parameters:
[
424
]
|
|
0.92 ms (18.85%) |
1 |
SELECT t0.id AS id_1, t0.tipo_risposta AS tipo_risposta_2, t0.opzioni_risposta AS opzioni_risposta_3, t0.multipla AS multipla_4, t0.posizione AS posizione_5, t0.risposta AS risposta_6, t0.obbligatoria AS obbligatoria_7, t0.created_at AS created_at_8, t0.modified_at AS modified_at_9, t0.questionario_id AS questionario_id_10, t0.questionario_iniziato_id AS questionario_iniziato_id_11, t0.domanda_id AS domanda_id_12 FROM risposte t0 WHERE t0.questionario_iniziato_id = ? ORDER BY t0.posizione ASC
Parameters:
[
2147
]
|
|
0.90 ms (18.35%) |
1 |
SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.descrizione AS descrizione_3, t0.created_at AS created_at_4, t0.corso_id AS corso_id_5, t0.corso_title AS corso_title_6, t0.token AS token_7, t0.user_id AS user_id_8, t0.ambiente_id AS ambiente_id_9, t0.questionario_id AS questionario_id_10 FROM questionari t0 WHERE t0.id = ?
Parameters:
[
392
]
|
|
0.87 ms (17.85%) |
1 |
SELECT t0.id AS id_1, t0.titolo AS titolo_2, t0.descrizione AS descrizione_3, t0.created_at AS created_at_4, t0.corso_id AS corso_id_5, t0.corso_title AS corso_title_6, t0.token AS token_7, t0.user_id AS user_id_8, t0.ambiente_id AS ambiente_id_9, t0.questionario_id AS questionario_id_10 FROM questionari t0 WHERE t0.id = ? AND t0.token = ? LIMIT 1
Parameters:
[ "424" "8b542542cb5232cc42bba7be4d654fc01f086bfb9661a6741a57aba2d4933edc" ] |
|
0.64 ms (13.03%) |
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.id = ?
Parameters:
[
12
]
|
|
0.61 ms (12.41%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.user_email_hash AS user_email_hash_3, t0.user_email AS user_email_4, t0.status AS status_5, t0.last_question AS last_question_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.returnurl AS returnurl_9, t0.questionario_id AS questionario_id_10, t0.ambiente_id AS ambiente_id_11 FROM questionari_iniziati t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"2147"
]
|
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\Questionari | No errors. |
| App\Entity\Users | No errors. |
| App\Entity\UsersAmbienti | No errors. |
| App\Entity\Domande | No errors. |
| App\Entity\QuestionariIniziati | No errors. |
| App\Entity\Risposte | No errors. |
| App\Entity\Estrazioni | No errors. |