POST https://vsigner.cloudelpinar.com/docstatus/38052bb2-5eb6-4be2-ad91-6e1be5057750

Query Metrics

20 Database Queries
10 Different statements
61.40 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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