GET https://www.castellazzodestampi.org/api/segnalazioni

Query Metrics

5 Database Queries
3 Different statements
2.53 ms Query time
0 Invalid entities
10 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.surname AS surname_5, t0.one_time_code AS one_time_code_6, t0.expiration_one_time_code AS expiration_one_time_code_7, t0.is_active AS is_active_8, t0.is_admin_active AS is_admin_active_9, t0.role AS role_10, t0.is_ignore_permission AS is_ignore_permission_11, t0.credentials_sent AS credentials_sent_12, t0.api_token AS api_token_13 FROM cas_user t0 WHERE t0.api_token = ? LIMIT 1
Parameters:
[
  "cf2ea7d208e29ed249610bdae5bda9c30e0251a59f6a5f60757cc71426e4c6e2"
]
2 0.87 ms
SELECT c0_.id AS id_0, c0_.datetime AS datetime_1, c0_.latitude AS latitude_2, c0_.longitude AS longitude_3, c0_.address AS address_4, c0_.priority AS priority_5, c0_.details AS details_6, c0_.status AS status_7, c0_.admin_notes AS admin_notes_8, c0_.is_merged AS is_merged_9, c0_.merged_group_id AS merged_group_id_10, c0_.user_id AS user_id_11, c0_.type_id AS type_id_12 FROM cas_report c0_ WHERE c0_.user_id = ? ORDER BY c0_.datetime DESC, c0_.id DESC
Parameters:
[
  1
]
3 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_file AS icon_file_5, t0.priority AS priority_6, t0.is_active AS is_active_7 FROM cas_report_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
4 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_file AS icon_file_5, t0.priority AS priority_6, t0.is_active AS is_active_7 FROM cas_report_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
5 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.icon AS icon_4, t0.icon_file AS icon_file_5, t0.priority AS priority_6, t0.is_active AS is_active_7 FROM cas_report_type t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Report 6
App\Entity\ReportType 3
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\JTUserPermission No errors.
App\Entity\Report No errors.
App\Entity\ReportType No errors.