Query Metrics
14
Database Queries
9
Different statements
35.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
31.11 ms (88.40%) |
3 |
"COMMIT"
Parameters:
[] |
|
0.79 ms (2.23%) |
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 = ? LIMIT 1
Parameters:
[
"ElPinarRHFSuiteSubs"
]
|
|
0.66 ms (1.86%) |
2 |
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
Parameters:
[
"9bb80daf-7eb2-4a0b-b9e6-956bd36b14cb"
]
|
|
0.58 ms (1.65%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
0.56 ms (1.58%) |
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
Parameters:
[
"ElPinarRHFSuiteSubs"
]
|
|
0.41 ms (1.16%) |
1 |
UPDATE documents SET storage_status = ?, updated_at = ? WHERE id = ?
Parameters:
[ "na" "2026-08-12 13:01:39" 13418 ] |
|
0.41 ms (1.16%) |
1 |
INSERT INTO documents (created_at, updated_at, guid, status, file_name, subscription_name, downloaded, downloaded_at, storage_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-08-12 13:01:39" "2026-08-12 13:01:39" "9bb80daf-7eb2-4a0b-b9e6-956bd36b14cb" "Unsigned" "TRAORE, BREHIMA_Y8463736A_19.08.2026_DOC.CONTRATO.pdf" "ElPinarRHFSuiteSubs" 0 null "pending" ] |
|
0.37 ms (1.05%) |
1 |
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-08-12 13:01:39" "2026-08-12 13:01:39" "POST" "vsigner.cloudelpinar.com" "api_multi_update_createddocstatus" "Basic ***" "application/json; charset=utf-8" "appId=cid-v1:bd03cabf-85f9-408c-9819-a0ddad58db22" "|920bf98928d70949ab0d4012ad9a96dd.23a8c2180676f200." "00-920bf98928d70949ab0d4012ad9a96dd-23a8c2180676f200-00" "426" "100-continue" null "E******************" "***" "1" "200" """ No storage configured for state: unsigned\n \n {"Signers":[{"UserNoticesInfo":null,"FormInfo":null,"SignerGUI":"69691801-bd31-497e-bebc-6451a5a02fee","SignerName":"T****** B******","SignatureStatus":"Unsigned","RejectionReason":null,"TypeOfID":"NIE","NumberID":"******36A","OperationTime":null}],"FileName":"TRA*******************************************ATO.pdf","DocGUI":"9bb80daf-7eb2-4a0b-b9e6-956bd36b14cb","DocStatus":"Unsigned","Downloaded":false,"AdditionalData":""} """ "9bb80daf-7eb2-4a0b-b9e6-956bd36b14cb" ] |
|
0.32 ms (0.92%) |
1 |
INSERT INTO document_history (created_at, updated_at, old_status, new_status, changed_at, subscription_name, action, details, document_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-08-12 13:01:39" "2026-08-12 13:01:39" null "Unsigned" "2026-08-12 13:01:39" "ElPinarRHFSuiteSubs" "created" "Documento creado con estado: Unsigned" 13418 ] |
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\APIActivity | No errors. |