https://debug.scan2go.it/service/updateFileInfo

Query Metrics

7 Database Queries
6 Different statements
4.31 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 0.76 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.service_key AS service_key_4, t0.sql_idc AS sql_idc_5 FROM service_user t0 WHERE t0.service_key = ? LIMIT 1
Parameters:
[
  "c864011e527fb0c325c7df06bc308962"
]
2 0.28 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.service_key AS service_key_4, t0.sql_idc AS sql_idc_5 FROM service_user t0 WHERE t0.service_key = ? LIMIT 1
Parameters:
[
  "c864011e527fb0c325c7df06bc308962"
]
3 0.43 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.service_key AS service_key_4, t0.sql_idc AS sql_idc_5 FROM service_user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "depretto01"
]
4 0.31 ms
SELECT t0.id AS id_1, t0.google_drive_id AS google_drive_id_2, t0.data_scansione AS data_scansione_3, t0.g_nomefile AS g_nomefile_4, t0.sql_idc AS sql_idc_5, t0.disabled AS disabled_6, t0.web_content_link AS web_content_link_7, t0.web_view_link AS web_view_link_8, t0.thumbnail_link AS thumbnail_link_9, t0.md5 AS md5_10, t0.md5p7m AS md5p7m_11, t0.pages_number AS pages_number_12, t0.size AS size_13, t0.controllo_integro AS controllo_integro_14, t0.data_controllo_integro AS data_controllo_integro_15, t0.file_versions_id AS file_versions_id_16, t0.latest_archive_status_id AS latest_archive_status_id_17 FROM file t0 WHERE t0.id = ?
Parameters:
[
  716068
]
5 0.12 ms
"START TRANSACTION"
Parameters:
[]
6 0.26 ms
UPDATE file SET google_drive_id = ?, data_scansione = ?, g_nomefile = ?, md5 = ?, pages_number = ?, size = ? WHERE id = ?
Parameters:
[
  "10mwQYyWFmvy7Hl_fAZTpK1AbSLeRFt4h"
  "2026-10-21 11:09:09"
  "c7f00000716045u6ad8608c04c63$.pdf"
  "08ea01881966170fe4c6c484544d7f12"
  2
  667482
  716068
]
7 2.16 ms
"COMMIT"
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.

Entities Mapping

Class Mapping errors
App\Entity\ServiceUser No errors.
App\Entity\File No errors.
App\Entity\FileVersions No errors.
App\Entity\SysArchiveStatus No errors.
App\Entity\FileDrivePermission No errors.
App\Entity\ArchivePack No errors.
App\Entity\FileGroup No errors.
App\Entity\OrgUnit No errors.
App\Entity\Owner No errors.