GET https://testing.vincenziana.it/utente/domande-di-ammissione/lista

Query Metrics

13 Database Queries
7 Different statements
7.78 ms Query time
0 Invalid entities
21 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.52 ms
(58.09%)
7
SELECT v0_.id AS id_0, v0_.check_in_date AS check_in_date_1, v0_.check_out_date AS check_out_date_2, v0_.diploma_school AS diploma_school_3, v0_.diploma_year AS diploma_year_4, v0_.diploma_grade AS diploma_grade_5, v0_.academic_year AS academic_year_6, v0_.university AS university_7, v0_.faculty AS faculty_8, v0_.degree_course AS degree_course_9, v0_.upload_dir AS upload_dir_10, v0_.is_readmission AS is_readmission_11, v0_.privacy_accepted AS privacy_accepted_12, v0_.datetime_creation AS datetime_creation_13, v0_.property_id AS property_id_14, v0_.candidate_id AS candidate_id_15, v0_.stay_type_id AS stay_type_id_16, v0_.student_type_id AS student_type_id_17, v0_.status_id AS status_id_18 FROM v_accommodation_request v0_ LEFT JOIN v_property v1_ ON v0_.property_id = v1_.id LEFT JOIN v_candidate v2_ ON v0_.candidate_id = v2_.id LEFT JOIN v_stay_type v3_ ON v0_.stay_type_id = v3_.id LEFT JOIN v_student_type v4_ ON v0_.student_type_id = v4_.id LEFT JOIN v_accommodation_request_status v5_ ON v0_.status_id = v5_.id WHERE 1 = 1 AND v0_.academic_year LIKE ? AND v5_.id = ? AND v1_.id IN (?, ?, ?, ?) ORDER BY v0_.check_in_date DESC
Parameters:
[
  "%2025/2026%"
  "1"
  "1"
  "2"
  "3"
  "4"
]
0.98 ms
(12.60%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.is_active AS is_active_5, t0.is_admin_active AS is_admin_active_6, t0.is_anonimized AS is_anonimized_7, t0.is_ignore_permission AS is_ignore_permission_8, t0.is_credentials_sent AS is_credentials_sent_9, t0.one_time_code AS one_time_code_10, t0.directory_path AS directory_path_11, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_12, t13.id AS id_14, t13.fiscal_code AS fiscal_code_15, t13.surname AS surname_16, t13.name AS name_17, t13.birth_place AS birth_place_18, t13.birth_province AS birth_province_19, t13.birth_country AS birth_country_20, t13.birth_date AS birth_date_21, t13.address AS address_22, t13.zip AS zip_23, t13.city AS city_24, t13.province AS province_25, t13.country AS country_26, t13.phone AS phone_27, t13.image_path AS image_path_28, t13.job AS job_29, t13.gender AS gender_30, t13.emergency1 AS emergency1_31, t13.emergency2 AS emergency2_32, t13.user_id AS user_id_33 FROM v_user t0 LEFT JOIN v_profile t13 ON t13.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  "1"
]
0.92 ms
(11.85%)
1
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.location AS location_2, v0_.code AS code_3, v0_.img_path AS img_path_4, v0_.auto_response_active AS auto_response_active_5, v0_.auto_response_text AS auto_response_text_6, v0_.notification_emails AS notification_emails_7 FROM v_property v0_ INNER JOIN v_jt_user_property v2_ ON v0_.id = v2_.property_id INNER JOIN v_user v1_ ON v1_.id = v2_.user_id WHERE v1_.id = ?
Parameters:
[
  "1"
]
0.46 ms
(5.90%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM v_accommodation_request_status t0
Parameters:
[]
0.45 ms
(5.84%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.location AS location_3, t0.code AS code_4, t0.img_path AS img_path_5, t0.auto_response_active AS auto_response_active_6, t0.auto_response_text AS auto_response_text_7, t0.notification_emails AS notification_emails_8 FROM v_property t0 INNER JOIN v_jt_user_property ON t0.id = v_jt_user_property.property_id WHERE v_jt_user_property.user_id = ?
Parameters:
[
  "1"
]
0.23 ms
(2.90%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM v_stay_type t0
Parameters:
[]
0.22 ms
(2.83%)
1
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM v_student_type t0
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\AccommodationRequestStatus 7
App\Entity\StudentType 5
App\Entity\Property 4
App\Entity\StayType 3
App\Entity\User 1
App\Entity\Profile 1