https://questionari.42b.it/webservice/sustain Return to referer URL

Query Metrics

6 Database Queries
6 Different statements
4.89 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.