Query Metrics
3
Database Queries
3
Different statements
2.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.18 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.62 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.33 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:
[
"ca653d1d-b0db-48ef-8c34-e7a29fae5c26"
]
|
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. |