17.25 ms (26.53%)
|
24 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.imported AS imported_3, t0.value_text AS value_text_4, t0.value_datetime AS value_datetime_5, t0.value_integer AS value_integer_6, t0.value_boolean AS value_boolean_7, t0.document_id AS document_id_8, t9.id AS id_10, t9.source_count AS source_count_11, t9.result_count AS result_count_12, t9.name AS name_13, t9.ocr_text AS ocr_text_14, t9.json_text AS json_text_15, t9.acception_date AS acception_date_16, t9.ml_processing_id AS ml_processing_id_17, t9.files_metadata AS files_metadata_18, t9.xml_text AS xml_text_19, t9.pages_processed AS pages_processed_20, t9.pages_total AS pages_total_21, t9.is_sended_to_bpium AS is_sended_to_bpium_22, t9.new_source AS new_source_23, t9.external_key AS external_key_24, t9.is_imported AS is_imported_25, t9.source_checksum AS source_checksum_26, t9.name_search AS name_search_27, t9.save_in_progress AS save_in_progress_28, t9.signature_checksum AS signature_checksum_29, t9.search AS search_30, t9.is_indexed AS is_indexed_31, t9.creation_date AS creation_date_32, t9.edition_date AS edition_date_33, t9.locked AS locked_34, t9.lock_date AS lock_date_35, t9.bpium_integration_id AS bpium_integration_id_36, t9.acceptor_id AS acceptor_id_37, t9.type_id AS type_id_38, t9.state_id AS state_id_39, t9.creator_id AS creator_id_40, t9.editor_id AS editor_id_41, t9.locker_id AS locker_id_42, t0.attribute_id AS attribute_id_43, t44.id AS id_45, t44.name AS name_46, t44.slug AS slug_47, t44.input_type AS input_type_48, t44.multiple_value AS multiple_value_49, t44.is_manual AS is_manual_50, t44.create_folder AS create_folder_51, t44.show_in_list AS show_in_list_52, t44.sort AS sort_53, t44.is_active AS is_active_54, t44.dictionary_id AS dictionary_id_55, t44.folder_id AS folder_id_56 FROM document_attribute t0 INNER JOIN "document" t9 ON t0.document_id = t9.id INNER JOIN attribute t44 ON t0.attribute_id = t44.id WHERE t0.document_id IN (?)
SELECT
t0.id AS id_1,
t0.value AS value_2,
t0.imported AS imported_3,
t0.value_text AS value_text_4,
t0.value_datetime AS value_datetime_5,
t0.value_integer AS value_integer_6,
t0.value_boolean AS value_boolean_7,
t0.document_id AS document_id_8,
t9.id AS id_10,
t9.source_count AS source_count_11,
t9.result_count AS result_count_12,
t9.name AS name_13,
t9.ocr_text AS ocr_text_14,
t9.json_text AS json_text_15,
t9.acception_date AS acception_date_16,
t9.ml_processing_id AS ml_processing_id_17,
t9.files_metadata AS files_metadata_18,
t9.xml_text AS xml_text_19,
t9.pages_processed AS pages_processed_20,
t9.pages_total AS pages_total_21,
t9.is_sended_to_bpium AS is_sended_to_bpium_22,
t9.new_source AS new_source_23,
t9.external_key AS external_key_24,
t9.is_imported AS is_imported_25,
t9.source_checksum AS source_checksum_26,
t9.name_search AS name_search_27,
t9.save_in_progress AS save_in_progress_28,
t9.signature_checksum AS signature_checksum_29,
t9.search AS search_30,
t9.is_indexed AS is_indexed_31,
t9.creation_date AS creation_date_32,
t9.edition_date AS edition_date_33,
t9.locked AS locked_34,
t9.lock_date AS lock_date_35,
t9.bpium_integration_id AS bpium_integration_id_36,
t9.acceptor_id AS acceptor_id_37,
t9.type_id AS type_id_38,
t9.state_id AS state_id_39,
t9.creator_id AS creator_id_40,
t9.editor_id AS editor_id_41,
t9.locker_id AS locker_id_42,
t0.attribute_id AS attribute_id_43,
t44.id AS id_45,
t44.name AS name_46,
t44.slug AS slug_47,
t44.input_type AS input_type_48,
t44.multiple_value AS multiple_value_49,
t44.is_manual AS is_manual_50,
t44.create_folder AS create_folder_51,
t44.show_in_list AS show_in_list_52,
t44.sort AS sort_53,
t44.is_active AS is_active_54,
t44.dictionary_id AS dictionary_id_55,
t44.folder_id AS folder_id_56
FROM
document_attribute t0
INNER JOIN "document" t9 ON t0.document_id = t9.id
INNER JOIN attribute t44 ON t0.attribute_id = t44.id
WHERE
t0.document_id IN (?)
SELECT t0.id AS id_1, t0.value AS value_2, t0.imported AS imported_3, t0.value_text AS value_text_4, t0.value_datetime AS value_datetime_5, t0.value_integer AS value_integer_6, t0.value_boolean AS value_boolean_7, t0.document_id AS document_id_8, t9.id AS id_10, t9.source_count AS source_count_11, t9.result_count AS result_count_12, t9.name AS name_13, t9.ocr_text AS ocr_text_14, t9.json_text AS json_text_15, t9.acception_date AS acception_date_16, t9.ml_processing_id AS ml_processing_id_17, t9.files_metadata AS files_metadata_18, t9.xml_text AS xml_text_19, t9.pages_processed AS pages_processed_20, t9.pages_total AS pages_total_21, t9.is_sended_to_bpium AS is_sended_to_bpium_22, t9.new_source AS new_source_23, t9.external_key AS external_key_24, t9.is_imported AS is_imported_25, t9.source_checksum AS source_checksum_26, t9.name_search AS name_search_27, t9.save_in_progress AS save_in_progress_28, t9.signature_checksum AS signature_checksum_29, t9.search AS search_30, t9.is_indexed AS is_indexed_31, t9.creation_date AS creation_date_32, t9.edition_date AS edition_date_33, t9.locked AS locked_34, t9.lock_date AS lock_date_35, t9.bpium_integration_id AS bpium_integration_id_36, t9.acceptor_id AS acceptor_id_37, t9.type_id AS type_id_38, t9.state_id AS state_id_39, t9.creator_id AS creator_id_40, t9.editor_id AS editor_id_41, t9.locker_id AS locker_id_42, t0.attribute_id AS attribute_id_43, t44.id AS id_45, t44.name AS name_46, t44.slug AS slug_47, t44.input_type AS input_type_48, t44.multiple_value AS multiple_value_49, t44.is_manual AS is_manual_50, t44.create_folder AS create_folder_51, t44.show_in_list AS show_in_list_52, t44.sort AS sort_53, t44.is_active AS is_active_54, t44.dictionary_id AS dictionary_id_55, t44.folder_id AS folder_id_56 FROM document_attribute t0 INNER JOIN "document" t9 ON t0.document_id = t9.id INNER JOIN attribute t44 ON t0.attribute_id = t44.id WHERE t0.document_id IN (65901);
|
11.66 ms (17.94%)
|
24 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.tag_style AS tag_style_3, t0.is_sended_to_bpium AS is_sended_to_bpium_4, t0.b_box AS b_box_5, t0.sort AS sort_6, t0.bpium_integration_id AS bpium_integration_id_7, t0.document_version_id AS document_version_id_8, t0.parameter_id AS parameter_id_9, t10.id AS id_11, t10.name AS name_12, t10.slug AS slug_13, t10.content_type AS content_type_14, t10.bpium_integration_id AS bpium_integration_id_15, t10.is_deleted AS is_deleted_16, t0.tag_id AS tag_id_17, t18.id AS id_19, t18.name AS name_20, t18.bpium_integration_id AS bpium_integration_id_21, t18.is_deleted AS is_deleted_22, t0.parent_id AS parent_id_23, t24.id AS id_25, t24.value AS value_26, t24.tag_style AS tag_style_27, t24.is_sended_to_bpium AS is_sended_to_bpium_28, t24.b_box AS b_box_29, t24.sort AS sort_30, t24.bpium_integration_id AS bpium_integration_id_31, t24.document_version_id AS document_version_id_32, t24.parameter_id AS parameter_id_33, t24.tag_id AS tag_id_34, t24.parent_id AS parent_id_35 FROM document_structure t0 LEFT JOIN "parameter" t10 ON t0.parameter_id = t10.id LEFT JOIN "tag" t18 ON t0.tag_id = t18.id LEFT JOIN document_structure t24 ON t0.parent_id = t24.id WHERE t0.document_version_id IN (?)
SELECT t0.id AS id_1, t0.value AS value_2, t0.tag_style AS tag_style_3, t0.is_sended_to_bpium AS is_sended_to_bpium_4, t0.b_box AS b_box_5, t0.sort AS sort_6, t0.bpium_integration_id AS bpium_integration_id_7, t0.document_version_id AS document_version_id_8, t0.parameter_id AS parameter_id_9, t10.id AS id_11, t10.name AS name_12, t10.slug AS slug_13, t10.content_type AS content_type_14, t10.bpium_integration_id AS bpium_integration_id_15, t10.is_deleted AS is_deleted_16, t0.tag_id AS tag_id_17, t18.id AS id_19, t18.name AS name_20, t18.bpium_integration_id AS bpium_integration_id_21, t18.is_deleted AS is_deleted_22, t0.parent_id AS parent_id_23, t24.id AS id_25, t24.value AS value_26, t24.tag_style AS tag_style_27, t24.is_sended_to_bpium AS is_sended_to_bpium_28, t24.b_box AS b_box_29, t24.sort AS sort_30, t24.bpium_integration_id AS bpium_integration_id_31, t24.document_version_id AS document_version_id_32, t24.parameter_id AS parameter_id_33, t24.tag_id AS tag_id_34, t24.parent_id AS parent_id_35 FROM document_structure t0 LEFT JOIN "parameter" t10 ON t0.parameter_id = t10.id LEFT JOIN "tag" t18 ON t0.tag_id = t18.id LEFT JOIN document_structure t24 ON t0.parent_id = t24.id WHERE t0.document_version_id IN (64063);
|
11.53 ms (17.73%)
|
24 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id INNER JOIN document_folder ON t0.id = document_folder.folder_id WHERE document_folder.document_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id INNER JOIN document_folder ON t0.id = document_folder.folder_id WHERE document_folder.document_id = 65901;
|
8.55 ms (13.15%)
|
24 |
SELECT t0.id AS id_1, t0.document_id AS document_id_2, t3.id AS id_4, t3.source_count AS source_count_5, t3.result_count AS result_count_6, t3.name AS name_7, t3.ocr_text AS ocr_text_8, t3.json_text AS json_text_9, t3.acception_date AS acception_date_10, t3.ml_processing_id AS ml_processing_id_11, t3.files_metadata AS files_metadata_12, t3.xml_text AS xml_text_13, t3.pages_processed AS pages_processed_14, t3.pages_total AS pages_total_15, t3.is_sended_to_bpium AS is_sended_to_bpium_16, t3.new_source AS new_source_17, t3.external_key AS external_key_18, t3.is_imported AS is_imported_19, t3.source_checksum AS source_checksum_20, t3.name_search AS name_search_21, t3.save_in_progress AS save_in_progress_22, t3.signature_checksum AS signature_checksum_23, t3.search AS search_24, t3.is_indexed AS is_indexed_25, t3.creation_date AS creation_date_26, t3.edition_date AS edition_date_27, t3.locked AS locked_28, t3.lock_date AS lock_date_29, t3.bpium_integration_id AS bpium_integration_id_30, t3.acceptor_id AS acceptor_id_31, t3.type_id AS type_id_32, t3.state_id AS state_id_33, t3.creator_id AS creator_id_34, t3.editor_id AS editor_id_35, t3.locker_id AS locker_id_36, t0.person_id AS person_id_37, t0.folder_id AS folder_id_38 FROM favorite t0 INNER JOIN "document" t3 ON t0.document_id = t3.id WHERE t0.document_id IN (?)
SELECT t0.id AS id_1, t0.document_id AS document_id_2, t3.id AS id_4, t3.source_count AS source_count_5, t3.result_count AS result_count_6, t3.name AS name_7, t3.ocr_text AS ocr_text_8, t3.json_text AS json_text_9, t3.acception_date AS acception_date_10, t3.ml_processing_id AS ml_processing_id_11, t3.files_metadata AS files_metadata_12, t3.xml_text AS xml_text_13, t3.pages_processed AS pages_processed_14, t3.pages_total AS pages_total_15, t3.is_sended_to_bpium AS is_sended_to_bpium_16, t3.new_source AS new_source_17, t3.external_key AS external_key_18, t3.is_imported AS is_imported_19, t3.source_checksum AS source_checksum_20, t3.name_search AS name_search_21, t3.save_in_progress AS save_in_progress_22, t3.signature_checksum AS signature_checksum_23, t3.search AS search_24, t3.is_indexed AS is_indexed_25, t3.creation_date AS creation_date_26, t3.edition_date AS edition_date_27, t3.locked AS locked_28, t3.lock_date AS lock_date_29, t3.bpium_integration_id AS bpium_integration_id_30, t3.acceptor_id AS acceptor_id_31, t3.type_id AS type_id_32, t3.state_id AS state_id_33, t3.creator_id AS creator_id_34, t3.editor_id AS editor_id_35, t3.locker_id AS locker_id_36, t0.person_id AS person_id_37, t0.folder_id AS folder_id_38 FROM favorite t0 INNER JOIN "document" t3 ON t0.document_id = t3.id WHERE t0.document_id IN (65901);
|
5.08 ms (7.82%)
|
24 |
SELECT t0.id AS id_1, t0.version AS version_2, t0.creation_date AS creation_date_3, t0.source_files AS source_files_4, t0.document_id AS document_id_5, t0.creator_id AS creator_id_6, t0.version_status_id AS version_status_id_7 FROM document_version t0 WHERE t0.document_id IN (?)
SELECT t0.id AS id_1, t0.version AS version_2, t0.creation_date AS creation_date_3, t0.source_files AS source_files_4, t0.document_id AS document_id_5, t0.creator_id AS creator_id_6, t0.version_status_id AS version_status_id_7 FROM document_version t0 WHERE t0.document_id IN (65901);
|
1.45 ms (2.23%)
|
2 |
SELECT t0.id AS id_1, t0.manage_document AS manage_document_2, t0.manage_folder AS manage_folder_3, t0.view_source AS view_source_4, t0.download_source AS download_source_5, t0.view_structure AS view_structure_6, t0.view_xml AS view_xml_7, t0.view_result AS view_result_8, t0.export_result AS export_result_9, t0.download_archive AS download_archive_10, t0.process AS process_11, t0.view_attributes AS view_attributes_12, t0.edit_attributes AS edit_attributes_13, t0.edit_source_pdf AS edit_source_pdf_14, t0.edit_source_xml AS edit_source_xml_15, t0.edit_content AS edit_content_16, t0.access_group_id AS access_group_id_17, t18.id AS id_19, t18.name AS name_20, t18.capacity AS capacity_21, t0.folder_id AS folder_id_22, t23.id AS id_24, t23.name AS name_25, t23.is_system AS is_system_26, t23.created_by_attribute AS created_by_attribute_27, t23.is_imported AS is_imported_28, t23.parent_id AS parent_id_29 FROM group_folder t0 LEFT JOIN access_group t18 ON t0.access_group_id = t18.id LEFT JOIN folder t23 ON t0.folder_id = t23.id WHERE t0.folder_id IN (?)
SELECT t0.id AS id_1, t0.manage_document AS manage_document_2, t0.manage_folder AS manage_folder_3, t0.view_source AS view_source_4, t0.download_source AS download_source_5, t0.view_structure AS view_structure_6, t0.view_xml AS view_xml_7, t0.view_result AS view_result_8, t0.export_result AS export_result_9, t0.download_archive AS download_archive_10, t0.process AS process_11, t0.view_attributes AS view_attributes_12, t0.edit_attributes AS edit_attributes_13, t0.edit_source_pdf AS edit_source_pdf_14, t0.edit_source_xml AS edit_source_xml_15, t0.edit_content AS edit_content_16, t0.access_group_id AS access_group_id_17, t18.id AS id_19, t18.name AS name_20, t18.capacity AS capacity_21, t0.folder_id AS folder_id_22, t23.id AS id_24, t23.name AS name_25, t23.is_system AS is_system_26, t23.created_by_attribute AS created_by_attribute_27, t23.is_imported AS is_imported_28, t23.parent_id AS parent_id_29 FROM group_folder t0 LEFT JOIN access_group t18 ON t0.access_group_id = t18.id LEFT JOIN folder t23 ON t0.folder_id = t23.id WHERE t0.folder_id IN (16777217);
|
1.10 ms (1.69%)
|
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.keycloak_id AS keycloak_id_3, t0.email AS email_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.name AS name_8, t0.ip_auth_enabled AS ip_auth_enabled_9, t0.notify_on_own_documents AS notify_on_own_documents_10, t0.notify_on_favorite_documents AS notify_on_favorite_documents_11, t0.notify_on_imported_documents AS notify_on_imported_documents_12, t0.notify_attributes AS notify_attributes_13, t0.creation_date AS creation_date_14, t0.edition_date AS edition_date_15, t0.bpium_integration_id AS bpium_integration_id_16, t0.is_deleted AS is_deleted_17, t0.creator_id AS creator_id_18, t19.id AS id_20, t19.username AS username_21, t19.keycloak_id AS keycloak_id_22, t19.email AS email_23, t19.phone AS phone_24, t19.roles AS roles_25, t19.password AS password_26, t19.name AS name_27, t19.ip_auth_enabled AS ip_auth_enabled_28, t19.notify_on_own_documents AS notify_on_own_documents_29, t19.notify_on_favorite_documents AS notify_on_favorite_documents_30, t19.notify_on_imported_documents AS notify_on_imported_documents_31, t19.notify_attributes AS notify_attributes_32, t19.creation_date AS creation_date_33, t19.edition_date AS edition_date_34, t19.bpium_integration_id AS bpium_integration_id_35, t19.is_deleted AS is_deleted_36, t19.creator_id AS creator_id_37, t19.editor_id AS editor_id_38, t0.editor_id AS editor_id_39, t40.id AS id_41, t40.username AS username_42, t40.keycloak_id AS keycloak_id_43, t40.email AS email_44, t40.phone AS phone_45, t40.roles AS roles_46, t40.password AS password_47, t40.name AS name_48, t40.ip_auth_enabled AS ip_auth_enabled_49, t40.notify_on_own_documents AS notify_on_own_documents_50, t40.notify_on_favorite_documents AS notify_on_favorite_documents_51, t40.notify_on_imported_documents AS notify_on_imported_documents_52, t40.notify_attributes AS notify_attributes_53, t40.creation_date AS creation_date_54, t40.edition_date AS edition_date_55, t40.bpium_integration_id AS bpium_integration_id_56, t40.is_deleted AS is_deleted_57, t40.creator_id AS creator_id_58, t40.editor_id AS editor_id_59 FROM "user" t0 LEFT JOIN "user" t19 ON t0.creator_id = t19.id LEFT JOIN "user" t40 ON t0.editor_id = t40.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.username AS username_2,
t0.keycloak_id AS keycloak_id_3,
t0.email AS email_4,
t0.phone AS phone_5,
t0.roles AS roles_6,
t0.password AS password_7,
t0.name AS name_8,
t0.ip_auth_enabled AS ip_auth_enabled_9,
t0.notify_on_own_documents AS notify_on_own_documents_10,
t0.notify_on_favorite_documents AS notify_on_favorite_documents_11,
t0.notify_on_imported_documents AS notify_on_imported_documents_12,
t0.notify_attributes AS notify_attributes_13,
t0.creation_date AS creation_date_14,
t0.edition_date AS edition_date_15,
t0.bpium_integration_id AS bpium_integration_id_16,
t0.is_deleted AS is_deleted_17,
t0.creator_id AS creator_id_18,
t19.id AS id_20,
t19.username AS username_21,
t19.keycloak_id AS keycloak_id_22,
t19.email AS email_23,
t19.phone AS phone_24,
t19.roles AS roles_25,
t19.password AS password_26,
t19.name AS name_27,
t19.ip_auth_enabled AS ip_auth_enabled_28,
t19.notify_on_own_documents AS notify_on_own_documents_29,
t19.notify_on_favorite_documents AS notify_on_favorite_documents_30,
t19.notify_on_imported_documents AS notify_on_imported_documents_31,
t19.notify_attributes AS notify_attributes_32,
t19.creation_date AS creation_date_33,
t19.edition_date AS edition_date_34,
t19.bpium_integration_id AS bpium_integration_id_35,
t19.is_deleted AS is_deleted_36,
t19.creator_id AS creator_id_37,
t19.editor_id AS editor_id_38,
t0.editor_id AS editor_id_39,
t40.id AS id_41,
t40.username AS username_42,
t40.keycloak_id AS keycloak_id_43,
t40.email AS email_44,
t40.phone AS phone_45,
t40.roles AS roles_46,
t40.password AS password_47,
t40.name AS name_48,
t40.ip_auth_enabled AS ip_auth_enabled_49,
t40.notify_on_own_documents AS notify_on_own_documents_50,
t40.notify_on_favorite_documents AS notify_on_favorite_documents_51,
t40.notify_on_imported_documents AS notify_on_imported_documents_52,
t40.notify_attributes AS notify_attributes_53,
t40.creation_date AS creation_date_54,
t40.edition_date AS edition_date_55,
t40.bpium_integration_id AS bpium_integration_id_56,
t40.is_deleted AS is_deleted_57,
t40.creator_id AS creator_id_58,
t40.editor_id AS editor_id_59
FROM
"user" t0
LEFT JOIN "user" t19 ON t0.creator_id = t19.id
LEFT JOIN "user" t40 ON t0.editor_id = t40.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.keycloak_id AS keycloak_id_3, t0.email AS email_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.name AS name_8, t0.ip_auth_enabled AS ip_auth_enabled_9, t0.notify_on_own_documents AS notify_on_own_documents_10, t0.notify_on_favorite_documents AS notify_on_favorite_documents_11, t0.notify_on_imported_documents AS notify_on_imported_documents_12, t0.notify_attributes AS notify_attributes_13, t0.creation_date AS creation_date_14, t0.edition_date AS edition_date_15, t0.bpium_integration_id AS bpium_integration_id_16, t0.is_deleted AS is_deleted_17, t0.creator_id AS creator_id_18, t19.id AS id_20, t19.username AS username_21, t19.keycloak_id AS keycloak_id_22, t19.email AS email_23, t19.phone AS phone_24, t19.roles AS roles_25, t19.password AS password_26, t19.name AS name_27, t19.ip_auth_enabled AS ip_auth_enabled_28, t19.notify_on_own_documents AS notify_on_own_documents_29, t19.notify_on_favorite_documents AS notify_on_favorite_documents_30, t19.notify_on_imported_documents AS notify_on_imported_documents_31, t19.notify_attributes AS notify_attributes_32, t19.creation_date AS creation_date_33, t19.edition_date AS edition_date_34, t19.bpium_integration_id AS bpium_integration_id_35, t19.is_deleted AS is_deleted_36, t19.creator_id AS creator_id_37, t19.editor_id AS editor_id_38, t0.editor_id AS editor_id_39, t40.id AS id_41, t40.username AS username_42, t40.keycloak_id AS keycloak_id_43, t40.email AS email_44, t40.phone AS phone_45, t40.roles AS roles_46, t40.password AS password_47, t40.name AS name_48, t40.ip_auth_enabled AS ip_auth_enabled_49, t40.notify_on_own_documents AS notify_on_own_documents_50, t40.notify_on_favorite_documents AS notify_on_favorite_documents_51, t40.notify_on_imported_documents AS notify_on_imported_documents_52, t40.notify_attributes AS notify_attributes_53, t40.creation_date AS creation_date_54, t40.edition_date AS edition_date_55, t40.bpium_integration_id AS bpium_integration_id_56, t40.is_deleted AS is_deleted_57, t40.creator_id AS creator_id_58, t40.editor_id AS editor_id_59 FROM "user" t0 LEFT JOIN "user" t19 ON t0.creator_id = t19.id LEFT JOIN "user" t40 ON t0.editor_id = t40.id WHERE t0.id = 574;
|
1.08 ms (1.66%)
|
1 |
SELECT d0_.id AS id_0, d0_.source_count AS source_count_1, d0_.result_count AS result_count_2, d0_.name AS name_3, d0_.ocr_text AS ocr_text_4, d0_.json_text AS json_text_5, d0_.acception_date AS acception_date_6, d0_.ml_processing_id AS ml_processing_id_7, d0_.files_metadata AS files_metadata_8, d0_.xml_text AS xml_text_9, d0_.pages_processed AS pages_processed_10, d0_.pages_total AS pages_total_11, d0_.is_sended_to_bpium AS is_sended_to_bpium_12, d0_.new_source AS new_source_13, d0_.external_key AS external_key_14, d0_.is_imported AS is_imported_15, d0_.source_checksum AS source_checksum_16, d0_.name_search AS name_search_17, d0_.save_in_progress AS save_in_progress_18, d0_.signature_checksum AS signature_checksum_19, d0_.search AS search_20, d0_.is_indexed AS is_indexed_21, d0_.creation_date AS creation_date_22, d0_.edition_date AS edition_date_23, d0_.locked AS locked_24, d0_.lock_date AS lock_date_25, d0_.bpium_integration_id AS bpium_integration_id_26, d0_.acceptor_id AS acceptor_id_27, d0_.type_id AS type_id_28, d0_.state_id AS state_id_29, d0_.creator_id AS creator_id_30, d0_.editor_id AS editor_id_31, d0_.locker_id AS locker_id_32 FROM "document" d0_ WHERE d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
102167
113450
115584
69485
83652
125102
101419
100531
121215
123443
66028
117887
103661
88627
82038
84478
88157
65901
121374
117291
102137
72124
127792
109802
]
SELECT
d0_.id AS id_0,
d0_.source_count AS source_count_1,
d0_.result_count AS result_count_2,
d0_.name AS name_3,
d0_.ocr_text AS ocr_text_4,
d0_.json_text AS json_text_5,
d0_.acception_date AS acception_date_6,
d0_.ml_processing_id AS ml_processing_id_7,
d0_.files_metadata AS files_metadata_8,
d0_.xml_text AS xml_text_9,
d0_.pages_processed AS pages_processed_10,
d0_.pages_total AS pages_total_11,
d0_.is_sended_to_bpium AS is_sended_to_bpium_12,
d0_.new_source AS new_source_13,
d0_.external_key AS external_key_14,
d0_.is_imported AS is_imported_15,
d0_.source_checksum AS source_checksum_16,
d0_.name_search AS name_search_17,
d0_.save_in_progress AS save_in_progress_18,
d0_.signature_checksum AS signature_checksum_19,
d0_.search AS search_20,
d0_.is_indexed AS is_indexed_21,
d0_.creation_date AS creation_date_22,
d0_.edition_date AS edition_date_23,
d0_.locked AS locked_24,
d0_.lock_date AS lock_date_25,
d0_.bpium_integration_id AS bpium_integration_id_26,
d0_.acceptor_id AS acceptor_id_27,
d0_.type_id AS type_id_28,
d0_.state_id AS state_id_29,
d0_.creator_id AS creator_id_30,
d0_.editor_id AS editor_id_31,
d0_.locker_id AS locker_id_32
FROM
"document" d0_
WHERE
d0_.id IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?
)
SELECT d0_.id AS id_0, d0_.source_count AS source_count_1, d0_.result_count AS result_count_2, d0_.name AS name_3, d0_.ocr_text AS ocr_text_4, d0_.json_text AS json_text_5, d0_.acception_date AS acception_date_6, d0_.ml_processing_id AS ml_processing_id_7, d0_.files_metadata AS files_metadata_8, d0_.xml_text AS xml_text_9, d0_.pages_processed AS pages_processed_10, d0_.pages_total AS pages_total_11, d0_.is_sended_to_bpium AS is_sended_to_bpium_12, d0_.new_source AS new_source_13, d0_.external_key AS external_key_14, d0_.is_imported AS is_imported_15, d0_.source_checksum AS source_checksum_16, d0_.name_search AS name_search_17, d0_.save_in_progress AS save_in_progress_18, d0_.signature_checksum AS signature_checksum_19, d0_.search AS search_20, d0_.is_indexed AS is_indexed_21, d0_.creation_date AS creation_date_22, d0_.edition_date AS edition_date_23, d0_.locked AS locked_24, d0_.lock_date AS lock_date_25, d0_.bpium_integration_id AS bpium_integration_id_26, d0_.acceptor_id AS acceptor_id_27, d0_.type_id AS type_id_28, d0_.state_id AS state_id_29, d0_.creator_id AS creator_id_30, d0_.editor_id AS editor_id_31, d0_.locker_id AS locker_id_32 FROM "document" d0_ WHERE d0_.id IN (102167, 113450, 115584, 69485, 83652, 125102, 101419, 100531, 121215, 123443, 66028, 117887, 103661, 88627, 82038, 84478, 88157, 65901, 121374, 117291, 102137, 72124, 127792, 109802);
|
0.67 ms (1.03%)
|
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_system AS is_system_4, t0.is_active AS is_active_5 FROM dictionary_type t0 WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_system AS is_system_4, t0.is_active AS is_active_5 FROM dictionary_type t0 WHERE t0.id IN (1);
|
0.66 ms (1.02%)
|
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.person_id AS person_id_3 FROM "access_token" t0 WHERE t0.id = ?
Parameters: [
"01a1f2b0-12f5-73bd-81a8-203e38ee9fe9"
]
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.person_id AS person_id_3 FROM "access_token" t0 WHERE t0.id = '01a1f2b0-12f5-73bd-81a8-203e38ee9fe9';
|
0.64 ms (0.98%)
|
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.parent_id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.parent_id IN (16777216);
|
0.63 ms (0.96%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.bpium_integration_id AS bpium_integration_id_3, t0.is_deleted AS is_deleted_4, t0.style_group_id AS style_group_id_5, t6.id AS id_7, t6.name AS name_8, t6.css_file_name AS css_file_name_9, t6.xsl_file_name AS xsl_file_name_10, t6.xsl_fo_file_name AS xsl_fo_file_name_11, t6.has_css_file AS has_css_file_12, t6.has_xsl_file AS has_xsl_file_13, t6.has_xsl_fo_file AS has_xsl_fo_file_14, t6.updated_at AS updated_at_15, t0.template_file_id AS template_file_id_16, t17.id AS id_18, t17.file_name AS file_name_19, t17.updated_at AS updated_at_20, t17.original_file_name AS original_file_name_21, t17.trained_data_settings_id AS trained_data_settings_id_22, t17.correction_dictionaries_settings_id AS correction_dictionaries_settings_id_23, t17.ontological_templates_settings_id AS ontological_templates_settings_id_24, t17.requirement_rules_settings_id AS requirement_rules_settings_id_25 FROM document_type t0 LEFT JOIN style t6 ON t0.style_group_id = t6.id LEFT JOIN settings_item t17 ON t0.template_file_id = t17.id WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.bpium_integration_id AS bpium_integration_id_3, t0.is_deleted AS is_deleted_4, t0.style_group_id AS style_group_id_5, t6.id AS id_7, t6.name AS name_8, t6.css_file_name AS css_file_name_9, t6.xsl_file_name AS xsl_file_name_10, t6.xsl_fo_file_name AS xsl_fo_file_name_11, t6.has_css_file AS has_css_file_12, t6.has_xsl_file AS has_xsl_file_13, t6.has_xsl_fo_file AS has_xsl_fo_file_14, t6.updated_at AS updated_at_15, t0.template_file_id AS template_file_id_16, t17.id AS id_18, t17.file_name AS file_name_19, t17.updated_at AS updated_at_20, t17.original_file_name AS original_file_name_21, t17.trained_data_settings_id AS trained_data_settings_id_22, t17.correction_dictionaries_settings_id AS correction_dictionaries_settings_id_23, t17.ontological_templates_settings_id AS ontological_templates_settings_id_24, t17.requirement_rules_settings_id AS requirement_rules_settings_id_25 FROM document_type t0 LEFT JOIN style t6 ON t0.style_group_id = t6.id LEFT JOIN settings_item t17 ON t0.template_file_id = t17.id WHERE t0.id IN (6);
|
0.56 ms (0.86%)
|
1 |
SELECT t0.id AS id_1, t0.manage_document AS manage_document_2, t0.manage_folder AS manage_folder_3, t0.view_source AS view_source_4, t0.download_source AS download_source_5, t0.view_structure AS view_structure_6, t0.view_xml AS view_xml_7, t0.view_result AS view_result_8, t0.export_result AS export_result_9, t0.download_archive AS download_archive_10, t0.process AS process_11, t0.view_attributes AS view_attributes_12, t0.edit_attributes AS edit_attributes_13, t0.edit_source_pdf AS edit_source_pdf_14, t0.edit_source_xml AS edit_source_xml_15, t0.edit_content AS edit_content_16, t0.access_group_id AS access_group_id_17, t18.id AS id_19, t18.name AS name_20, t18.capacity AS capacity_21, t0.folder_id AS folder_id_22, t23.id AS id_24, t23.name AS name_25, t23.is_system AS is_system_26, t23.created_by_attribute AS created_by_attribute_27, t23.is_imported AS is_imported_28, t23.parent_id AS parent_id_29 FROM group_folder t0 LEFT JOIN access_group t18 ON t0.access_group_id = t18.id LEFT JOIN folder t23 ON t0.folder_id = t23.id WHERE t0.folder_id IN (?, ?, ?, ?, ?, ?)
Parameters: [
16796995
16796996
16796997
16796998
16796999
16797000
]
SELECT t0.id AS id_1, t0.manage_document AS manage_document_2, t0.manage_folder AS manage_folder_3, t0.view_source AS view_source_4, t0.download_source AS download_source_5, t0.view_structure AS view_structure_6, t0.view_xml AS view_xml_7, t0.view_result AS view_result_8, t0.export_result AS export_result_9, t0.download_archive AS download_archive_10, t0.process AS process_11, t0.view_attributes AS view_attributes_12, t0.edit_attributes AS edit_attributes_13, t0.edit_source_pdf AS edit_source_pdf_14, t0.edit_source_xml AS edit_source_xml_15, t0.edit_content AS edit_content_16, t0.access_group_id AS access_group_id_17, t18.id AS id_19, t18.name AS name_20, t18.capacity AS capacity_21, t0.folder_id AS folder_id_22, t23.id AS id_24, t23.name AS name_25, t23.is_system AS is_system_26, t23.created_by_attribute AS created_by_attribute_27, t23.is_imported AS is_imported_28, t23.parent_id AS parent_id_29 FROM group_folder t0 LEFT JOIN access_group t18 ON t0.access_group_id = t18.id LEFT JOIN folder t23 ON t0.folder_id = t23.id WHERE t0.folder_id IN (16796995, 16796996, 16796997, 16796998, 16796999, 16797000);
|
0.53 ms (0.82%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.capacity AS capacity_3 FROM access_group t0 INNER JOIN user_access_group ON t0.id = user_access_group.access_group_id WHERE user_access_group.user_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.capacity AS capacity_3 FROM access_group t0 INNER JOIN user_access_group ON t0.id = user_access_group.access_group_id WHERE user_access_group.user_id = 574;
|
0.53 ms (0.81%)
|
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.keycloak_id AS keycloak_id_3, t0.email AS email_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.name AS name_8, t0.ip_auth_enabled AS ip_auth_enabled_9, t0.notify_on_own_documents AS notify_on_own_documents_10, t0.notify_on_favorite_documents AS notify_on_favorite_documents_11, t0.notify_on_imported_documents AS notify_on_imported_documents_12, t0.notify_attributes AS notify_attributes_13, t0.creation_date AS creation_date_14, t0.edition_date AS edition_date_15, t0.bpium_integration_id AS bpium_integration_id_16, t0.is_deleted AS is_deleted_17, t0.creator_id AS creator_id_18, t19.id AS id_20, t19.username AS username_21, t19.keycloak_id AS keycloak_id_22, t19.email AS email_23, t19.phone AS phone_24, t19.roles AS roles_25, t19.password AS password_26, t19.name AS name_27, t19.ip_auth_enabled AS ip_auth_enabled_28, t19.notify_on_own_documents AS notify_on_own_documents_29, t19.notify_on_favorite_documents AS notify_on_favorite_documents_30, t19.notify_on_imported_documents AS notify_on_imported_documents_31, t19.notify_attributes AS notify_attributes_32, t19.creation_date AS creation_date_33, t19.edition_date AS edition_date_34, t19.bpium_integration_id AS bpium_integration_id_35, t19.is_deleted AS is_deleted_36, t19.creator_id AS creator_id_37, t19.editor_id AS editor_id_38, t0.editor_id AS editor_id_39, t40.id AS id_41, t40.username AS username_42, t40.keycloak_id AS keycloak_id_43, t40.email AS email_44, t40.phone AS phone_45, t40.roles AS roles_46, t40.password AS password_47, t40.name AS name_48, t40.ip_auth_enabled AS ip_auth_enabled_49, t40.notify_on_own_documents AS notify_on_own_documents_50, t40.notify_on_favorite_documents AS notify_on_favorite_documents_51, t40.notify_on_imported_documents AS notify_on_imported_documents_52, t40.notify_attributes AS notify_attributes_53, t40.creation_date AS creation_date_54, t40.edition_date AS edition_date_55, t40.bpium_integration_id AS bpium_integration_id_56, t40.is_deleted AS is_deleted_57, t40.creator_id AS creator_id_58, t40.editor_id AS editor_id_59 FROM "user" t0 LEFT JOIN "user" t19 ON t0.creator_id = t19.id LEFT JOIN "user" t40 ON t0.editor_id = t40.id WHERE t0.id IN (?, ?)
SELECT
t0.id AS id_1,
t0.username AS username_2,
t0.keycloak_id AS keycloak_id_3,
t0.email AS email_4,
t0.phone AS phone_5,
t0.roles AS roles_6,
t0.password AS password_7,
t0.name AS name_8,
t0.ip_auth_enabled AS ip_auth_enabled_9,
t0.notify_on_own_documents AS notify_on_own_documents_10,
t0.notify_on_favorite_documents AS notify_on_favorite_documents_11,
t0.notify_on_imported_documents AS notify_on_imported_documents_12,
t0.notify_attributes AS notify_attributes_13,
t0.creation_date AS creation_date_14,
t0.edition_date AS edition_date_15,
t0.bpium_integration_id AS bpium_integration_id_16,
t0.is_deleted AS is_deleted_17,
t0.creator_id AS creator_id_18,
t19.id AS id_20,
t19.username AS username_21,
t19.keycloak_id AS keycloak_id_22,
t19.email AS email_23,
t19.phone AS phone_24,
t19.roles AS roles_25,
t19.password AS password_26,
t19.name AS name_27,
t19.ip_auth_enabled AS ip_auth_enabled_28,
t19.notify_on_own_documents AS notify_on_own_documents_29,
t19.notify_on_favorite_documents AS notify_on_favorite_documents_30,
t19.notify_on_imported_documents AS notify_on_imported_documents_31,
t19.notify_attributes AS notify_attributes_32,
t19.creation_date AS creation_date_33,
t19.edition_date AS edition_date_34,
t19.bpium_integration_id AS bpium_integration_id_35,
t19.is_deleted AS is_deleted_36,
t19.creator_id AS creator_id_37,
t19.editor_id AS editor_id_38,
t0.editor_id AS editor_id_39,
t40.id AS id_41,
t40.username AS username_42,
t40.keycloak_id AS keycloak_id_43,
t40.email AS email_44,
t40.phone AS phone_45,
t40.roles AS roles_46,
t40.password AS password_47,
t40.name AS name_48,
t40.ip_auth_enabled AS ip_auth_enabled_49,
t40.notify_on_own_documents AS notify_on_own_documents_50,
t40.notify_on_favorite_documents AS notify_on_favorite_documents_51,
t40.notify_on_imported_documents AS notify_on_imported_documents_52,
t40.notify_attributes AS notify_attributes_53,
t40.creation_date AS creation_date_54,
t40.edition_date AS edition_date_55,
t40.bpium_integration_id AS bpium_integration_id_56,
t40.is_deleted AS is_deleted_57,
t40.creator_id AS creator_id_58,
t40.editor_id AS editor_id_59
FROM
"user" t0
LEFT JOIN "user" t19 ON t0.creator_id = t19.id
LEFT JOIN "user" t40 ON t0.editor_id = t40.id
WHERE
t0.id IN (?, ?)
SELECT t0.id AS id_1, t0.username AS username_2, t0.keycloak_id AS keycloak_id_3, t0.email AS email_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.name AS name_8, t0.ip_auth_enabled AS ip_auth_enabled_9, t0.notify_on_own_documents AS notify_on_own_documents_10, t0.notify_on_favorite_documents AS notify_on_favorite_documents_11, t0.notify_on_imported_documents AS notify_on_imported_documents_12, t0.notify_attributes AS notify_attributes_13, t0.creation_date AS creation_date_14, t0.edition_date AS edition_date_15, t0.bpium_integration_id AS bpium_integration_id_16, t0.is_deleted AS is_deleted_17, t0.creator_id AS creator_id_18, t19.id AS id_20, t19.username AS username_21, t19.keycloak_id AS keycloak_id_22, t19.email AS email_23, t19.phone AS phone_24, t19.roles AS roles_25, t19.password AS password_26, t19.name AS name_27, t19.ip_auth_enabled AS ip_auth_enabled_28, t19.notify_on_own_documents AS notify_on_own_documents_29, t19.notify_on_favorite_documents AS notify_on_favorite_documents_30, t19.notify_on_imported_documents AS notify_on_imported_documents_31, t19.notify_attributes AS notify_attributes_32, t19.creation_date AS creation_date_33, t19.edition_date AS edition_date_34, t19.bpium_integration_id AS bpium_integration_id_35, t19.is_deleted AS is_deleted_36, t19.creator_id AS creator_id_37, t19.editor_id AS editor_id_38, t0.editor_id AS editor_id_39, t40.id AS id_41, t40.username AS username_42, t40.keycloak_id AS keycloak_id_43, t40.email AS email_44, t40.phone AS phone_45, t40.roles AS roles_46, t40.password AS password_47, t40.name AS name_48, t40.ip_auth_enabled AS ip_auth_enabled_49, t40.notify_on_own_documents AS notify_on_own_documents_50, t40.notify_on_favorite_documents AS notify_on_favorite_documents_51, t40.notify_on_imported_documents AS notify_on_imported_documents_52, t40.notify_attributes AS notify_attributes_53, t40.creation_date AS creation_date_54, t40.edition_date AS edition_date_55, t40.bpium_integration_id AS bpium_integration_id_56, t40.is_deleted AS is_deleted_57, t40.creator_id AS creator_id_58, t40.editor_id AS editor_id_59 FROM "user" t0 LEFT JOIN "user" t19 ON t0.creator_id = t19.id LEFT JOIN "user" t40 ON t0.editor_id = t40.id WHERE t0.id IN (670, 1);
|
0.51 ms (0.78%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.parent_id IN (?, ?)
Parameters: [
16796994
16796993
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.parent_id IN (16796994, 16796993);
|
0.49 ms (0.75%)
|
1 |
SELECT COUNT(a0_.id) AS sclr_0 FROM access_group a0_ INNER JOIN nss_subscription n1_ ON a0_.id = n1_.access_group_id WHERE a0_.id IN (?) AND n1_.allow_all_documents = true AND (n1_.valid_until IS NULL OR n1_.valid_until >= ?)
Parameters: [
139
"2026-11-19 00:00:00"
]
SELECT COUNT(a0_.id) AS sclr_0 FROM access_group a0_ INNER JOIN nss_subscription n1_ ON a0_.id = n1_.access_group_id WHERE a0_.id IN (139) AND n1_.allow_all_documents = true AND (n1_.valid_until IS NULL OR n1_.valid_until >= '2026-11-19 00:00:00');
|
0.41 ms (0.63%)
|
1 |
SELECT t0.id AS id_1, t0.manage_document AS manage_document_2, t0.manage_folder AS manage_folder_3, t0.view_source AS view_source_4, t0.download_source AS download_source_5, t0.view_structure AS view_structure_6, t0.view_xml AS view_xml_7, t0.view_result AS view_result_8, t0.export_result AS export_result_9, t0.download_archive AS download_archive_10, t0.process AS process_11, t0.view_attributes AS view_attributes_12, t0.edit_attributes AS edit_attributes_13, t0.edit_source_pdf AS edit_source_pdf_14, t0.edit_source_xml AS edit_source_xml_15, t0.edit_content AS edit_content_16, t0.access_group_id AS access_group_id_17, t18.id AS id_19, t18.name AS name_20, t18.capacity AS capacity_21, t0.folder_id AS folder_id_22, t23.id AS id_24, t23.name AS name_25, t23.is_system AS is_system_26, t23.created_by_attribute AS created_by_attribute_27, t23.is_imported AS is_imported_28, t23.parent_id AS parent_id_29 FROM group_folder t0 LEFT JOIN access_group t18 ON t0.access_group_id = t18.id LEFT JOIN folder t23 ON t0.folder_id = t23.id WHERE t0.folder_id IN (?, ?)
Parameters: [
16796994
16796993
]
SELECT t0.id AS id_1, t0.manage_document AS manage_document_2, t0.manage_folder AS manage_folder_3, t0.view_source AS view_source_4, t0.download_source AS download_source_5, t0.view_structure AS view_structure_6, t0.view_xml AS view_xml_7, t0.view_result AS view_result_8, t0.export_result AS export_result_9, t0.download_archive AS download_archive_10, t0.process AS process_11, t0.view_attributes AS view_attributes_12, t0.edit_attributes AS edit_attributes_13, t0.edit_source_pdf AS edit_source_pdf_14, t0.edit_source_xml AS edit_source_xml_15, t0.edit_content AS edit_content_16, t0.access_group_id AS access_group_id_17, t18.id AS id_19, t18.name AS name_20, t18.capacity AS capacity_21, t0.folder_id AS folder_id_22, t23.id AS id_24, t23.name AS name_25, t23.is_system AS is_system_26, t23.created_by_attribute AS created_by_attribute_27, t23.is_imported AS is_imported_28, t23.parent_id AS parent_id_29 FROM group_folder t0 LEFT JOIN access_group t18 ON t0.access_group_id = t18.id LEFT JOIN folder t23 ON t0.folder_id = t23.id WHERE t0.folder_id IN (16796994, 16796993);
|
0.39 ms (0.60%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.input_type AS input_type_4, t0.multiple_value AS multiple_value_5, t0.is_manual AS is_manual_6, t0.create_folder AS create_folder_7, t0.show_in_list AS show_in_list_8, t0.sort AS sort_9, t0.is_active AS is_active_10, t0.dictionary_id AS dictionary_id_11, t12.id AS id_13, t12.name AS name_14, t12.slug AS slug_15, t12.is_system AS is_system_16, t12.is_active AS is_active_17, t0.folder_id AS folder_id_18 FROM attribute t0 LEFT JOIN dictionary_type t12 ON t0.dictionary_id = t12.id WHERE t0.folder_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.input_type AS input_type_4, t0.multiple_value AS multiple_value_5, t0.is_manual AS is_manual_6, t0.create_folder AS create_folder_7, t0.show_in_list AS show_in_list_8, t0.sort AS sort_9, t0.is_active AS is_active_10, t0.dictionary_id AS dictionary_id_11, t12.id AS id_13, t12.name AS name_14, t12.slug AS slug_15, t12.is_system AS is_system_16, t12.is_active AS is_active_17, t0.folder_id AS folder_id_18 FROM attribute t0 LEFT JOIN dictionary_type t12 ON t0.dictionary_id = t12.id WHERE t0.folder_id = 16796993;
|
0.37 ms (0.57%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.id IN (16777216);
|
0.36 ms (0.56%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?)
Parameters: [
16796995
16796996
16796997
16796998
16796999
16797000
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_system AS is_system_3, t0.created_by_attribute AS created_by_attribute_4, t0.is_imported AS is_imported_5, t0.parent_id AS parent_id_6, t7.id AS id_8, t7.name AS name_9, t7.is_system AS is_system_10, t7.created_by_attribute AS created_by_attribute_11, t7.is_imported AS is_imported_12, t7.parent_id AS parent_id_13, t14.id AS id_15, t14.name AS name_16, t14.slug AS slug_17, t14.input_type AS input_type_18, t14.multiple_value AS multiple_value_19, t14.is_manual AS is_manual_20, t14.create_folder AS create_folder_21, t14.show_in_list AS show_in_list_22, t14.sort AS sort_23, t14.is_active AS is_active_24, t14.dictionary_id AS dictionary_id_25, t14.folder_id AS folder_id_26 FROM folder t0 LEFT JOIN folder t7 ON t0.parent_id = t7.id LEFT JOIN attribute t14 ON t14.folder_id = t0.id WHERE t0.parent_id IN (16796995, 16796996, 16796997, 16796998, 16796999, 16797000);
|
0.31 ms (0.47%)
|
1 |
SELECT f0_.id AS id_0 FROM folder f0_ WHERE f0_.is_imported = true
SELECT f0_.id AS id_0 FROM folder f0_ WHERE f0_.is_imported = true;
|
0.25 ms (0.39%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.bpium_integration_id AS bpium_integration_id_4 FROM state t0 WHERE t0.id IN (?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.bpium_integration_id AS bpium_integration_id_4 FROM state t0 WHERE t0.id IN (201);
|