GET https://questionari.42b.it/webservice/allineaambiente/cfcs?token=4afcbfaeed1c42ad3a05f48d80530bd6

Query Metrics

17 Database Queries
3 Different statements
8.73 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.21 ms
(71.20%)
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"
]
1.30 ms
(14.93%)
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"
]
1.21 ms
(13.87%)
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.