Query Metrics
20
Database Queries
10
Different statements
61.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.95 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.vidsigner_username AS vidsigner_username_5, t0.vidsigner_password AS vidsigner_password_6, t0.use_local_storage_signed AS use_local_storage_signed_7, t0.local_path_signed AS local_path_signed_8, t0.use_local_storage_unsigned AS use_local_storage_unsigned_9, t0.local_path_unsigned AS local_path_unsigned_10, t0.use_local_storage_rejected AS use_local_storage_rejected_11, t0.local_path_rejected AS local_path_rejected_12, t0.use_share_point_signed AS use_share_point_signed_13, t0.sharepoint_tenant_id AS sharepoint_tenant_id_14, t0.sharepoint_client_id AS sharepoint_client_id_15, t0.sharepoint_client_secret AS sharepoint_client_secret_16, t0.sharepoint_destination_url_signed AS sharepoint_destination_url_signed_17, t0.use_share_point_unsigned AS use_share_point_unsigned_18, t0.sharepoint_destination_url_unsigned AS sharepoint_destination_url_unsigned_19, t0.use_share_point_rejected AS use_share_point_rejected_20, t0.sharepoint_destination_url_rejected AS sharepoint_destination_url_rejected_21, t0.report_language AS report_language_22, t0.created_by_id AS created_by_id_23, t0.last_modified_by_id AS last_modified_by_id_24, t25.id AS id_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.enabled AS enabled_29, t25.frequency AS frequency_30, t25.interval_hours AS interval_hours_31, t25.hour_of_day AS hour_of_day_32, t25.minute_of_hour AS minute_of_hour_33, t25.day_of_week AS day_of_week_34, t25.day_of_month AS day_of_month_35, t25.restrict_time_window AS restrict_time_window_36, t25.window_start_hour AS window_start_hour_37, t25.window_end_hour AS window_end_hour_38, t25.lookback_days AS lookback_days_39, t25.max_retries AS max_retries_40, t25.last_sync_at AS last_sync_at_41, t25.next_sync_at AS next_sync_at_42, t25.is_running AS is_running_43, t25.subscription_id AS subscription_id_44, t25.created_by_id AS created_by_id_45, t25.last_modified_by_id AS last_modified_by_id_46 FROM subscriptions t0 LEFT JOIN sync_configurations t25 ON t25.subscription_id = t0.id WHERE t0.vidsigner_username = ? LIMIT 1
Parameters:
[
"ElPinarRHFSuiteSubs"
]
|
| 2 | 0.58 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.vidsigner_username AS vidsigner_username_5, t0.vidsigner_password AS vidsigner_password_6, t0.use_local_storage_signed AS use_local_storage_signed_7, t0.local_path_signed AS local_path_signed_8, t0.use_local_storage_unsigned AS use_local_storage_unsigned_9, t0.local_path_unsigned AS local_path_unsigned_10, t0.use_local_storage_rejected AS use_local_storage_rejected_11, t0.local_path_rejected AS local_path_rejected_12, t0.use_share_point_signed AS use_share_point_signed_13, t0.sharepoint_tenant_id AS sharepoint_tenant_id_14, t0.sharepoint_client_id AS sharepoint_client_id_15, t0.sharepoint_client_secret AS sharepoint_client_secret_16, t0.sharepoint_destination_url_signed AS sharepoint_destination_url_signed_17, t0.use_share_point_unsigned AS use_share_point_unsigned_18, t0.sharepoint_destination_url_unsigned AS sharepoint_destination_url_unsigned_19, t0.use_share_point_rejected AS use_share_point_rejected_20, t0.sharepoint_destination_url_rejected AS sharepoint_destination_url_rejected_21, t0.report_language AS report_language_22, t0.created_by_id AS created_by_id_23, t0.last_modified_by_id AS last_modified_by_id_24, t25.id AS id_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.enabled AS enabled_29, t25.frequency AS frequency_30, t25.interval_hours AS interval_hours_31, t25.hour_of_day AS hour_of_day_32, t25.minute_of_hour AS minute_of_hour_33, t25.day_of_week AS day_of_week_34, t25.day_of_month AS day_of_month_35, t25.restrict_time_window AS restrict_time_window_36, t25.window_start_hour AS window_start_hour_37, t25.window_end_hour AS window_end_hour_38, t25.lookback_days AS lookback_days_39, t25.max_retries AS max_retries_40, t25.last_sync_at AS last_sync_at_41, t25.next_sync_at AS next_sync_at_42, t25.is_running AS is_running_43, t25.subscription_id AS subscription_id_44, t25.created_by_id AS created_by_id_45, t25.last_modified_by_id AS last_modified_by_id_46 FROM subscriptions t0 LEFT JOIN sync_configurations t25 ON t25.subscription_id = t0.id WHERE t0.name = ? LIMIT 1
Parameters:
[
"ElPinarRHFSuiteSubs"
]
|
| 3 | 0.38 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.guid AS guid_4, t0.status AS status_5, t0.file_name AS file_name_6, t0.subscription_name AS subscription_name_7, t0.downloaded AS downloaded_8, t0.downloaded_at AS downloaded_at_9 FROM documents t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
"38052bb2-5eb6-4be2-ad91-6e1be5057750"
]
|
| 4 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.47 ms |
UPDATE documents SET status = ?, updated_at = ? WHERE id = ?
Parameters:
[ "Signed" "2026-04-20 08:12:59" 5519 ] |
| 6 | 12.04 ms |
"COMMIT"
Parameters:
[] |
| 7 | 0.26 ms |
"START TRANSACTION"
Parameters:
[] |
| 8 | 0.48 ms |
INSERT INTO document_history (created_at, updated_at, old_status, new_status, changed_at, subscription_name, action, details, document_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-04-20 08:12:59" "2026-04-20 08:12:59" "Unsigned" "Signed" "2026-04-20 08:12:59" "ElPinarRHFSuiteSubs" "status_changed" "Estado cambiado de Unsigned a Signed" 5519 ] |
| 9 | 0.48 ms |
INSERT INTO sharepoint_activity (created_at, updated_at, subscription_name, status, message, file_name, document_guid, error_details, destination_url, site_id, drive_id, share_point_path, item_id, web_url, file_size, upload_method, graph_response, document_state, is_report) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-04-20 08:13:02" "2026-04-20 08:13:02" "ElPinarRHFSuiteSubs" "UPLOAD_SUCCESS" "File uploaded successfully: SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf" "SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf" "38052bb2-5eb6-4be2-ad91-6e1be5057750" null "https://elpinarberries.sharepoint.com/sites/LaboralPrivado/Contratos/tablets" "elpinarberries.sharepoint.com,0794639c-fee5-476e-9587-6212e99bd214,d39775c3-7388-47d6-9703-281f1062555a" "b!nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya" "tablets/SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf" "0147YNXG6YX3LPH6H3P5EJBAM74UHCOLAZ" "https://elpinarberries.sharepoint.com/sites/LaboralPrivado/Contratos/TABLETS/SIMANCA%20GAMARRA,%20ANDRES%20FEL_Z3171917S_20.04.2026_PRL.pdf" 929270 "direct" """ {\n "@odata.context": "https:\/\/graph.microsoft.com\/v1.0\/$metadata#drives('b%21nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya')\/root\/$entity",\n "@microsoft.graph.downloadUrl": "https:\/\/elpinarberries.sharepoint.com\/sites\/LaboralPrivado\/_layouts\/15\/download.aspx?UniqueId=f3d6bed8-fbf8-487f-9081-9fe50e272c19&Translate=false&tempauth=v1.eyJzaXRlaWQiOiIwNzk0NjM5Yy1mZWU1LTQ3NmUtOTU4Ny02MjEyZTk5YmQyMTQiLCJhcHBfZGlzcGxheW5hbWUiOiJWaWRTaWduZXIiLCJuYW1laWQiOiI0NjYxMDFjMC0xNGQ1LTQyMTgtODBjOS01NWI4Y2FkYmU1MDhANzQwOTk2ZWYtZjIyNy00MGU3LWIwNGUtYjE3YjE4ZjJjNzJkIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2VscGluYXJiZXJyaWVzLnNoYXJlcG9pbnQuY29tQDc0MDk5NmVmLWYyMjctNDBlNy1iMDRlLWIxN2IxOGYyYzcyZCIsImV4cCI6IjE3NzY2NzYzODIifQ.CkAKDGVudHJhX2NsYWltcxIwQ09DOWw4OEdFQUFhRmxwNmNGVjBhazQyVkRCRFMzTnRTRUppV2xGSlFVRXFBQT09CjIKCmFjdG9yYXBwaWQSJDAwMDAwMDAzLTAwMDAtMDAwMC1jMDAwLTAwMDAwMDAwMDAwMAoKCgRzbmlkEgI2NBILCKrJ3M3Vr48_EAUaDTIwLjE5MC4xNzcuODgqLHFsM3BIdUI5UXpiK2h0K2QwZGMvU1dGRDlReDZDcHhmY3Z2SWR4OURRdk09MJIBOAFCEKILwgDqsAAA2T1miZdkpGBKEGhhc2hlZHByb29mdG9rZW56ATG6AQ1zZWxlY3RlZHNpdGVzyAEB.z1Rof2iA6pJ-ZfHroIxFxW_5eb4T4VjWXx-7no_KAI8&ApiVersion=2.0",\n "createdDateTime": "2026-04-20T08:13:02Z",\n "eTag": "\"{F3D6BED8-FBF8-487F-9081-9FE50E272C19},1\"",\n "id": "0147YNXG6YX3LPH6H3P5EJBAM74UHCOLAZ",\n "lastModifiedDateTime": "2026-04-20T08:13:02Z",\n "name": "SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf",\n "webUrl": "https:\/\/elpinarberries.sharepoint.com\/sites\/LaboralPrivado\/Contratos\/TABLETS\/SIMANCA%20GAMARRA,%20ANDRES%20FEL_Z3171917S_20.04.2026_PRL.pdf",\n "cTag": "\"c:{F3D6BED8-FBF8-487F-9081-9FE50E272C19},1\"",\n "isAuthoritative": false,\n "size": 929270,\n "createdBy": {\n "application": {\n "id": "466101c0-14d5-4218-80c9-55b8cadbe508",\n "displayName": "VidSigner"\n },\n "user": {\n "displayName": "Aplicaci\u00f3n de SharePoint"\n }\n },\n "lastModifiedBy": {\n "application": {\n "id": "466101c0-14d5-4218-80c9-55b8cadbe508",\n "displayName": "VidSigner"\n },\n "user": {\n "displayName": "Aplicaci\u00f3n de SharePoint"\n }\n },\n "parentReference": {\n "driveType": "documentLibrary",\n "driveId": "b!nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya",\n "id": "0147YNXG44L25OBSYFNZDLLIP6SN72XUH6",\n "name": "TABLETS",\n "path": "\/drives\/b!nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya\/root:\/TABLETS",\n "siteId": "0794639c-fee5-476e-9587-6212e99bd214"\n },\n "file": {\n "mimeType": "application\/pdf",\n "hashes": {\n "quickXorHash": "DGDJjTUv\/N5arPapvNMVrKDK3mI="\n }\n },\n "fileSystemInfo": {\n "createdDateTime": "2026-04-20T08:13:02Z",\n "lastModifiedDateTime": "2026-04-20T08:13:02Z"\n },\n "shared": {\n "scope": "users"\n }\n } """ "signed" 0 ] |
| 10 | 10.87 ms |
"COMMIT"
Parameters:
[] |
| 11 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
| 12 | 0.66 ms |
INSERT INTO sharepoint_activity (created_at, updated_at, subscription_name, status, message, file_name, document_guid, error_details, destination_url, site_id, drive_id, share_point_path, item_id, web_url, file_size, upload_method, graph_response, document_state, is_report) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-04-20 08:13:05" "2026-04-20 08:13:05" "ElPinarRHFSuiteSubs" "UPLOAD_SUCCESS" "File uploaded successfully: report_SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf" "report_SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf" "38052bb2-5eb6-4be2-ad91-6e1be5057750" null "https://elpinarberries.sharepoint.com/sites/LaboralPrivado/Contratos/tablets" "elpinarberries.sharepoint.com,0794639c-fee5-476e-9587-6212e99bd214,d39775c3-7388-47d6-9703-281f1062555a" "b!nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya" "tablets/report_SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf" "0147YNXGY4SZ2YU6VFWBGZH2ECLAOSOKMF" "https://elpinarberries.sharepoint.com/sites/LaboralPrivado/Contratos/TABLETS/report_SIMANCA%20GAMARRA,%20ANDRES%20FEL_Z3171917S_20.04.2026_PRL.pdf" 385352 "direct" """ {\n "@odata.context": "https:\/\/graph.microsoft.com\/v1.0\/$metadata#drives('b%21nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya')\/root\/$entity",\n "@microsoft.graph.downloadUrl": "https:\/\/elpinarberries.sharepoint.com\/sites\/LaboralPrivado\/_layouts\/15\/download.aspx?UniqueId=8a75961c-a57a-4db0-93e8-82581d272985&Translate=false&tempauth=v1.eyJzaXRlaWQiOiIwNzk0NjM5Yy1mZWU1LTQ3NmUtOTU4Ny02MjEyZTk5YmQyMTQiLCJhcHBfZGlzcGxheW5hbWUiOiJWaWRTaWduZXIiLCJuYW1laWQiOiI0NjYxMDFjMC0xNGQ1LTQyMTgtODBjOS01NWI4Y2FkYmU1MDhANzQwOTk2ZWYtZjIyNy00MGU3LWIwNGUtYjE3YjE4ZjJjNzJkIiwiYXVkIjoiMDAwMDAwMDMtMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwL2VscGluYXJiZXJyaWVzLnNoYXJlcG9pbnQuY29tQDc0MDk5NmVmLWYyMjctNDBlNy1iMDRlLWIxN2IxOGYyYzcyZCIsImV4cCI6IjE3NzY2NzYzODQifQ.CkAKDGVudHJhX2NsYWltcxIwQ09POWw4OEdFQUFhRmpKaVdrVkZZMWRYTlVVdFUxUnFhRTFvU1RCS1FVRXFBQT09CjIKCmFjdG9yYXBwaWQSJDAwMDAwMDAzLTAwMDAtMDAwMC1jMDAwLTAwMDAwMDAwMDAwMAoKCgRzbmlkEgI2NBILCO7UyeTVr48_EAUaDDQwLjEyNi40OS4yNCosSHdNdEJ3UnhCcWxmVWpVazdWSDhKZjdCV3UydUIzZU0yZkVDbmZ0V1ZSWT0wkgE4AUIQogvCAYtAAADZPWhsAJYECkoQaGFzaGVkcHJvb2Z0b2tlbnoBMboBDXNlbGVjdGVkc2l0ZXPIAQE.97ehC6cEaQNifH_MvysikAsUbr5R66ZCCpd7sJ2t89Q&ApiVersion=2.0",\n "createdDateTime": "2026-04-20T08:13:05Z",\n "eTag": "\"{8A75961C-A57A-4DB0-93E8-82581D272985},1\"",\n "id": "0147YNXGY4SZ2YU6VFWBGZH2ECLAOSOKMF",\n "lastModifiedDateTime": "2026-04-20T08:13:05Z",\n "name": "report_SIMANCA GAMARRA, ANDRES FEL_Z3171917S_20.04.2026_PRL.pdf",\n "webUrl": "https:\/\/elpinarberries.sharepoint.com\/sites\/LaboralPrivado\/Contratos\/TABLETS\/report_SIMANCA%20GAMARRA,%20ANDRES%20FEL_Z3171917S_20.04.2026_PRL.pdf",\n "cTag": "\"c:{8A75961C-A57A-4DB0-93E8-82581D272985},1\"",\n "isAuthoritative": false,\n "size": 385352,\n "createdBy": {\n "application": {\n "id": "466101c0-14d5-4218-80c9-55b8cadbe508",\n "displayName": "VidSigner"\n },\n "user": {\n "displayName": "Aplicaci\u00f3n de SharePoint"\n }\n },\n "lastModifiedBy": {\n "application": {\n "id": "466101c0-14d5-4218-80c9-55b8cadbe508",\n "displayName": "VidSigner"\n },\n "user": {\n "displayName": "Aplicaci\u00f3n de SharePoint"\n }\n },\n "parentReference": {\n "driveType": "documentLibrary",\n "driveId": "b!nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya",\n "id": "0147YNXG44L25OBSYFNZDLLIP6SN72XUH6",\n "name": "TABLETS",\n "path": "\/drives\/b!nGOUB-X-bkeVh2IS6ZvSFMN1l9OIc9ZHlwMoHxBiVVp6GvLYYqCrR6nv0DHMl0ya\/root:\/TABLETS",\n "siteId": "0794639c-fee5-476e-9587-6212e99bd214"\n },\n "file": {\n "mimeType": "application\/pdf",\n "hashes": {\n "quickXorHash": "olh1n\/BERhEKqKADhOCrbnw\/zAk="\n }\n },\n "fileSystemInfo": {\n "createdDateTime": "2026-04-20T08:13:05Z",\n "lastModifiedDateTime": "2026-04-20T08:13:05Z"\n },\n "shared": {\n "scope": "users"\n }\n } """ "signed" 1 ] |
| 13 | 11.08 ms |
"COMMIT"
Parameters:
[] |
| 14 | 0.47 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.guid AS guid_4, t0.status AS status_5, t0.file_name AS file_name_6, t0.subscription_name AS subscription_name_7, t0.downloaded AS downloaded_8, t0.downloaded_at AS downloaded_at_9 FROM documents t0 WHERE t0.guid = ? LIMIT 1
Parameters:
[
"38052bb2-5eb6-4be2-ad91-6e1be5057750"
]
|
| 15 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 16 | 0.51 ms |
UPDATE documents SET downloaded = ?, downloaded_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ 1 "2026-04-20 08:13:05" "2026-04-20 08:13:05" 5519 ] |
| 17 | 10.04 ms |
"COMMIT"
Parameters:
[] |
| 18 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 19 | 0.52 ms |
INSERT INTO apiactivity (created_at, updated_at, method, host, end_point, authorization, content_type, request_context, request_id, traceparent, content_length, expect, connection, php_auth_user, php_auth_password, x_phpob_level, status, body, doc_guid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-04-20 08:13:05" "2026-04-20 08:13:05" "POST" "vsigner.cloudelpinar.com" "api_multi_update_docstatus" "Basic ***" "application/json; charset=utf-8" "appId=cid-v1:bd03cabf-85f9-408c-9819-a0ddad58db22" "|bd2e381a408e004c8fb4cbc00aeb98f2.f215a8f96f81af50." "00-bd2e381a408e004c8fb4cbc00aeb98f2-f215a8f96f81af50-00" "452" "100-continue" null "E******************" "***" "1" "200" """ {"documentGUID":"38052bb2-5eb6-4be2-ad91-6e1be5057750","documentFileName":"SIM**********************************************PRL.pdf","downloadedDate":"20-04-2026 08:13:05","state":"signed","docStatus":"Signed","subscription":"ElPinarRHFSuiteSubs","local_storage":"disabled","sharepoint_storage":"success"}\n \n {"Signers":[{"UserNoticesInfo":null,"FormInfo":null,"SignerGUI":"f1b8bff0-1d03-4c1d-8118-b421a07497a1","SignerName":"A***** F** S****** G******","SignatureStatus":"Signed","RejectionReason":null,"TypeOfID":"NIE","NumberID":"******17S","OperationTime":"2026-04-20 08:12:49"}],"FileName":"SIM**********************************************PRL.pdf","DocGUI":"38052bb2-5eb6-4be2-ad91-6e1be5057750","DocStatus":"Signed","Downloaded":true,"AdditionalData":""} """ "38052bb2-5eb6-4be2-ad91-6e1be5057750" ] |
| 20 | 10.88 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\AbstractEntity | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SyncConfiguration | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\DocumentHistory | No errors. |
| App\Entity\SharePointActivity | No errors. |
| App\Entity\APIActivity | No errors. |