Symfony Profiler

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.use_local_storage_forms AS use_local_storage_forms_23,
  t0.local_path_forms AS local_path_forms_24,
  t0.use_share_point_forms AS use_share_point_forms_25,
  t0.sharepoint_destination_url_forms AS sharepoint_destination_url_forms_26,
  t0.created_by_id AS created_by_id_27,
  t0.last_modified_by_id AS last_modified_by_id_28,
  t29.id AS id_30,
  t29.created_at AS created_at_31,
  t29.updated_at AS updated_at_32,
  t29.enabled AS enabled_33,
  t29.frequency AS frequency_34,
  t29.interval_hours AS interval_hours_35,
  t29.hour_of_day AS hour_of_day_36,
  t29.minute_of_hour AS minute_of_hour_37,
  t29.day_of_week AS day_of_week_38,
  t29.day_of_month AS day_of_month_39,
  t29.restrict_time_window AS restrict_time_window_40,
  t29.window_start_hour AS window_start_hour_41,
  t29.window_end_hour AS window_end_hour_42,
  t29.lookback_days AS lookback_days_43,
  t29.max_retries AS max_retries_44,
  t29.last_sync_at AS last_sync_at_45,
  t29.next_sync_at AS next_sync_at_46,
  t29.is_running AS is_running_47,
  t29.subscription_id AS subscription_id_48,
  t29.created_by_id AS created_by_id_49,
  t29.last_modified_by_id AS last_modified_by_id_50
FROM
  subscriptions t0
  LEFT JOIN sync_configurations t29 ON t29.subscription_id = t0.id
WHERE
  t0.vidsigner_username = ?
LIMIT
  1

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.use_local_storage_forms AS use_local_storage_forms_23, t0.local_path_forms AS local_path_forms_24, t0.use_share_point_forms AS use_share_point_forms_25, t0.sharepoint_destination_url_forms AS sharepoint_destination_url_forms_26, t0.created_by_id AS created_by_id_27, t0.last_modified_by_id AS last_modified_by_id_28, t29.id AS id_30, t29.created_at AS created_at_31, t29.updated_at AS updated_at_32, t29.enabled AS enabled_33, t29.frequency AS frequency_34, t29.interval_hours AS interval_hours_35, t29.hour_of_day AS hour_of_day_36, t29.minute_of_hour AS minute_of_hour_37, t29.day_of_week AS day_of_week_38, t29.day_of_month AS day_of_month_39, t29.restrict_time_window AS restrict_time_window_40, t29.window_start_hour AS window_start_hour_41, t29.window_end_hour AS window_end_hour_42, t29.lookback_days AS lookback_days_43, t29.max_retries AS max_retries_44, t29.last_sync_at AS last_sync_at_45, t29.next_sync_at AS next_sync_at_46, t29.is_running AS is_running_47, t29.subscription_id AS subscription_id_48, t29.created_by_id AS created_by_id_49, t29.last_modified_by_id AS last_modified_by_id_50 FROM subscriptions t0 LEFT JOIN sync_configurations t29 ON t29.subscription_id = t0.id WHERE t0.vidsigner_username = 'ElPinarPlantaFSuiteSubs' LIMIT 1;

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.use_local_storage_forms AS use_local_storage_forms_23,
  t0.local_path_forms AS local_path_forms_24,
  t0.use_share_point_forms AS use_share_point_forms_25,
  t0.sharepoint_destination_url_forms AS sharepoint_destination_url_forms_26,
  t0.created_by_id AS created_by_id_27,
  t0.last_modified_by_id AS last_modified_by_id_28,
  t29.id AS id_30,
  t29.created_at AS created_at_31,
  t29.updated_at AS updated_at_32,
  t29.enabled AS enabled_33,
  t29.frequency AS frequency_34,
  t29.interval_hours AS interval_hours_35,
  t29.hour_of_day AS hour_of_day_36,
  t29.minute_of_hour AS minute_of_hour_37,
  t29.day_of_week AS day_of_week_38,
  t29.day_of_month AS day_of_month_39,
  t29.restrict_time_window AS restrict_time_window_40,
  t29.window_start_hour AS window_start_hour_41,
  t29.window_end_hour AS window_end_hour_42,
  t29.lookback_days AS lookback_days_43,
  t29.max_retries AS max_retries_44,
  t29.last_sync_at AS last_sync_at_45,
  t29.next_sync_at AS next_sync_at_46,
  t29.is_running AS is_running_47,
  t29.subscription_id AS subscription_id_48,
  t29.created_by_id AS created_by_id_49,
  t29.last_modified_by_id AS last_modified_by_id_50
FROM
  subscriptions t0
  LEFT JOIN sync_configurations t29 ON t29.subscription_id = t0.id
WHERE
  t0.name = ?
LIMIT
  1

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.use_local_storage_forms AS use_local_storage_forms_23, t0.local_path_forms AS local_path_forms_24, t0.use_share_point_forms AS use_share_point_forms_25, t0.sharepoint_destination_url_forms AS sharepoint_destination_url_forms_26, t0.created_by_id AS created_by_id_27, t0.last_modified_by_id AS last_modified_by_id_28, t29.id AS id_30, t29.created_at AS created_at_31, t29.updated_at AS updated_at_32, t29.enabled AS enabled_33, t29.frequency AS frequency_34, t29.interval_hours AS interval_hours_35, t29.hour_of_day AS hour_of_day_36, t29.minute_of_hour AS minute_of_hour_37, t29.day_of_week AS day_of_week_38, t29.day_of_month AS day_of_month_39, t29.restrict_time_window AS restrict_time_window_40, t29.window_start_hour AS window_start_hour_41, t29.window_end_hour AS window_end_hour_42, t29.lookback_days AS lookback_days_43, t29.max_retries AS max_retries_44, t29.last_sync_at AS last_sync_at_45, t29.next_sync_at AS next_sync_at_46, t29.is_running AS is_running_47, t29.subscription_id AS subscription_id_48, t29.created_by_id AS created_by_id_49, t29.last_modified_by_id AS last_modified_by_id_50 FROM subscriptions t0 LEFT JOIN sync_configurations t29 ON t29.subscription_id = t0.id WHERE t0.name = 'ElPinarPlantaFSuiteSubs' LIMIT 1;

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,
  t0.storage_status AS storage_status_10
FROM
  documents t0
WHERE
  t0.guid = ?
LIMIT
  1

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, t0.storage_status AS storage_status_10 FROM documents t0 WHERE t0.guid = 'b4fec53d-0cca-4887-a109-3a20b808d00b' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO documents (
  created_at, updated_at, guid, status,
  file_name, subscription_name, downloaded,
  downloaded_at, storage_status
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO documents (created_at, updated_at, guid, status, file_name, subscription_name, downloaded, downloaded_at, storage_status) VALUES ('2026-10-13 06:28:35', '2026-10-13 06:28:35', 'b4fec53d-0cca-4887-a109-3a20b808d00b', 'Unsigned', 'FGAS_PEG_EPM26_000691_____COSTANZO_ALFONSO.pdf', 'ElPinarPlantaFSuiteSubs', 0, NULL, 'pending');

"COMMIT"

"COMMIT";

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,
  t0.storage_status AS storage_status_10
FROM
  documents t0
WHERE
  t0.guid = ?
LIMIT
  1

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, t0.storage_status AS storage_status_10 FROM documents t0 WHERE t0.guid = 'b4fec53d-0cca-4887-a109-3a20b808d00b' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO document_history (
  created_at, updated_at, old_status,
  new_status, changed_at, subscription_name,
  action, details, document_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO document_history (created_at, updated_at, old_status, new_status, changed_at, subscription_name, action, details, document_id) VALUES ('2026-10-13 06:28:35', '2026-10-13 06:28:35', NULL, 'Unsigned', '2026-10-13 06:28:35', 'ElPinarPlantaFSuiteSubs', 'created', 'Documento creado con estado: Unsigned', 18117);

UPDATE
  documents
SET
  storage_status = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE documents SET storage_status = 'na', updated_at = '2026-10-13 06:28:35' WHERE id = 18117;

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

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
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

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 ('2026-10-13 06:28:35', '2026-10-13 06:28:35', 'POST', 'vsigner.cloudelpinar.com', 'api_multi_update_createddocstatus', 'Basic ***', 'application/json; charset=utf-8', 'appId=cid-v1:bd03cabf-85f9-408c-9819-a0ddad58db22', '|0e921a2fd5f0774ab81c5d50ad15f0e5.31fdfb4eb08e11c2.', '00-0e921a2fd5f0774ab81c5d50ad15f0e5-31fdfb4eb08e11c2-00', '1084', '100-continue', NULL, 'E**********************', '***', '1', '200', 'No storage configured for state: unsigned

{\"UploadTime\":\"2026-10-13 06:28:29\",\"OrderedSignatures\":false,\"Tag\":\"ITALIA\",\"IssuerName\":\"EL PINAR MEDIOAMBIENTE, SLU \\/ COSTANZO ALFONSO\",\"ExpirationTime\":\"2026-10-30 22:59:59\",\"NotificationURL\":null,\"Signers\":[{\"FormInfo\":null,\"SignatureNumber\":1,\"SignatureType\":\"emailandsms\",\"DeviceName\":\"\",\"CertificateGUI\":\"\",\"Email\":\"c**************@virgilio.it\",\"PhoneNumber\":null,\"Language\":\"es\",\"SendSignedDoc\":true,\"SkipSignatureEmail\":false,\"Evidences\":[{\"Ip\":null,\"Location\":null,\"Destination\":\"costanzoalfonso@virgilio.it\",\"From\":null,\"ExtendedProperties\":null,\"ExtraDataSerialized\":null,\"EvidenceType\":\"EMAIL_SENT\",\"EvidenceDate\":\"2026-10-13 06:28:32\"}],\"SignatureReason\":null,\"Approvers\":null,\"ExtendedProperties\":null,\"SignerGUI\":\"98843867-0040-407a-abbc-12c38e007f95\",\"SignerName\":\"\",\"SignatureStatus\":\"Unsigned\",\"RejectionReason\":null,\"TypeOfID\":\"\",\"NumberID\":\"\",\"OperationTime\":null}],\"ExtendedProperties\":null,\"FileName\":\"FGA************************************NSO.pdf\",\"DocGUI\":\"b4fec53d-0cca-4887-a109-3a20b808d00b\",\"DocStatus\":\"Unsigned\",\"Downloaded\":false,\"AdditionalData\":\"\"}', 'b4fec53d-0cca-4887-a109-3a20b808d00b');

"COMMIT"

"COMMIT";