Symfony Profiler

Query Metrics

481 Database Queries

36 Different statements

286.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

206.14 ms
(71.99%)

377

SELECT a0_.id AS id_0 FROM access_group a0_ INNER JOIN user_access_group u2_ ON a0_.id = u2_.access_group_id INNER JOIN "user" u1_ ON u1_.id = u2_.user_id WHERE u1_.id = ?

Parameters:

[
  684
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0
FROM
  access_group a0_
  INNER JOIN user_access_group u2_ ON a0_.id = u2_.access_group_id
  INNER JOIN "user" u1_ ON u1_.id = u2_.user_id
WHERE
  u1_.id = ?

SELECT a0_.id AS id_0 FROM access_group a0_ INNER JOIN user_access_group u2_ ON a0_.id = u2_.access_group_id INNER JOIN "user" u1_ ON u1_.id = u2_.user_id WHERE u1_.id = 684;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 87)
7	App\Service\AccessService->getUserFolderRights (line 139)
8	App\Service\AccessService->checkRightsForUserAndFolder (line 38)
9	App\Service\AccessService->userFolderAccessWalkLite (line 1132)
10	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
11	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
12	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

14.89 ms
(5.20%)

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

Parameters:

[
  72642
]

View formatted query View runnable query Explain query View query backtrace

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 (72642);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
13	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 120)
22	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
23	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

9.93 ms
(3.47%)

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

Parameters:

[
  70804
]

View formatted query View runnable query Explain query View query backtrace

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 (70804);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 68)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 270)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
13	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
14	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
15	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
16	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
18	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 120)
27	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
28	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

8.88 ms
(3.10%)

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 = ?

Parameters:

[
  72642
]

View formatted query View runnable query Explain query View query backtrace

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 = 72642;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
10	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
11	Doctrine\ORM\AbstractQuery->execute (line 901)
12	Doctrine\ORM\AbstractQuery->getResult (line 120)
13	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
14	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

6.45 ms
(2.25%)

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

Parameters:

[
  72642
]

View formatted query View runnable query Explain query View query backtrace

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 (72642);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
13	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 120)
22	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
23	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

4.32 ms
(1.51%)

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

Parameters:

[
  72642
]

View formatted query View runnable query Explain query View query backtrace

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 (72642);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
13	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 120)
22	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
23	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

3.35 ms
(1.17%)

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:

[
  16796907
]

View formatted query View runnable query Explain query View query backtrace

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 (16796907);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
23	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
24	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
26	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
27	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
28	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
29	Doctrine\ORM\UnitOfWork->createEntity (line 272)
30	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
31	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
32	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
33	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
34	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
35	Doctrine\ORM\AbstractQuery->execute (line 901)
36	Doctrine\ORM\AbstractQuery->getResult (line 1128)
37	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
38	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
39	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

3.17 ms
(1.11%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (9, 16796890, 45, 46, 16796891, 7, 16796892, 16796893, 16796894, 16796895, 16796896, 16796897, 16777224, 16777225, 16777226, 16777227, 16777228, 16777232, 16777234, 16796930, 16796931, 16777239, 16777240, 16777241, 16777242, 16777243, 16777244, 16777245, 16777246, 16777247, 16777248, 16777249, 16777250, 16777251, 16777252, 16777253, 16777259, 16777260, 16777261, 16777262, 16777264, 16777265, 16777266, 16777267, 16777268, 16777269, 16796900, 16777272, 16777273, 16777274, 16777275, 16796901, 16777277, 16777278, 16777280, 16777281, 16796902, 16796903, 16796904, 16796908, 16796909, 16796911, 16796913, 16796914, 16796915, 16796916, 16796917, 16796918, 16796932, 16796933, 16796934, 16796938, 16796939, 16796940, 16796941, 16796942, 16796912, 16796935, 16777258, 16777263, 16796943, 16796944, 16796947, 16796948, 16796952, 16796953, 16796962, 16796965, 16796966, 16796967, 16796968, 16796969, 16796970, 16796972, 16796973, 16796974, 16796975, 16796976, 16796977, 16796986);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 1128)
22	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
23	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
24	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.36 ms
(0.82%)

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:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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 (1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
9	Doctrine\ORM\UnitOfWork->createEntity (line 272)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 1128)
17	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
18	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
19	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

2.33 ms
(0.81%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (9, 16796890, 45, 46, 16796891, 7, 16796892, 16796893, 16796894, 16796895, 16796896, 16796897, 16777224, 16777225, 16777226, 16777227, 16777228, 16777232, 16777234, 16796930, 16796931, 16777239, 16777240, 16777241, 16777242, 16777243, 16777244, 16777245, 16777246, 16777247, 16777248, 16777249, 16777250, 16777251, 16777252, 16777253, 16777259, 16777260, 16777261, 16777262, 16777264, 16777265, 16777266, 16777267, 16777268, 16777269, 16796900, 16777272, 16777273, 16777274, 16777275, 16796901, 16777277, 16777278, 16777280, 16777281, 16796902, 16796903, 16796904, 16796908, 16796909, 16796911, 16796913, 16796914, 16796915, 16796916, 16796917, 16796918, 16796932, 16796933, 16796934, 16796938, 16796939, 16796940, 16796941, 16796942, 16796912, 16796935, 16777258, 16777263, 16796943, 16796944, 16796947, 16796948, 16796952, 16796953, 16796962, 16796965, 16796966, 16796967, 16796968, 16796969, 16796970, 16796972, 16796973, 16796974, 16796975, 16796976, 16796977, 16796986);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 1128)
22	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
23	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
24	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.79 ms
(0.62%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (125622, 90481, 116952, 121745, 109586, 130492, 96681, 127213, 108189, 72642, 101153, 109769);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 120)
7	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
8	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.55 ms
(0.54%)

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

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

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);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
8	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
9	Doctrine\ORM\UnitOfWork->createEntity (line 272)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 120)
17	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
18	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.50 ms
(0.52%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797140, 16797215);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
23	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
24	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
26	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
27	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
28	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
29	Doctrine\ORM\UnitOfWork->createEntity (line 272)
30	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
31	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
32	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
33	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
34	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
35	Doctrine\ORM\AbstractQuery->execute (line 901)
36	Doctrine\ORM\AbstractQuery->getResult (line 1128)
37	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
38	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
39	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

1.41 ms
(0.49%)

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 = ?

Parameters:

[
  684
]

View formatted query View runnable query Explain query View query backtrace

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 = 684;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\User->__get (line 155)
8	App\Entity\User->getRoles (line 31)
9	Symfony\Component\Security\Http\Authenticator\AbstractAuthenticator->createToken (line 68)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 198)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 66)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
17	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.32 ms
(0.46%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797140, 16797215);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
23	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
24	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
26	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
27	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
28	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
29	Doctrine\ORM\UnitOfWork->createEntity (line 272)
30	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
31	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
32	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
33	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
34	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
35	Doctrine\ORM\AbstractQuery->execute (line 901)
36	Doctrine\ORM\AbstractQuery->getResult (line 1128)
37	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
38	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
39	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
42	Symfony\Component\HttpKernel\Kernel->handle (line 35)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
44	require_once (line 5)

1.27 ms
(0.44%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797168, 16797170, 16797171, 16797173, 16797175, 16797178, 16797179, 16797180, 16797181, 16797182, 16797183, 16797185, 16797187, 16797188, 16797189, 16797190, 16797191, 16797192, 16797193, 16797196, 16797208, 16797209, 16797211, 16797217, 16797221, 16797222, 16797223, 16797224, 16797225, 16797226, 16797227, 16797228, 16797229, 16797230, 16797231, 16797234, 16797236, 16797240, 16797241, 16797242, 16797244, 16797246, 16797247, 16797248, 16797249, 16797250, 16797251, 16797252, 16797253, 16797256, 16797257, 16797259, 16797260, 16797261, 16797262, 16797263, 16797264, 16797265, 16797266, 16797267, 16797268);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 1128)
22	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
23	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
24	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.21 ms
(0.42%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797194, 16797195, 16797212, 16797218, 16797220, 16797232, 16797235);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 1128)
27	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
28	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
29	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

1.17 ms
(0.41%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797194, 16797195, 16797212, 16797218, 16797220, 16797232, 16797235);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 1128)
27	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
28	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
29	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

1.14 ms
(0.40%)

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 = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
10	Doctrine\ORM\AbstractQuery->execute (line 901)
11	Doctrine\ORM\AbstractQuery->getResult (line 1128)
12	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
13	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
14	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.97 ms
(0.34%)

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

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

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 (10);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
7	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
8	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
9	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
10	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
11	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
13	Doctrine\ORM\UnitOfWork->createEntity (line 272)
14	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
17	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
18	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
19	Doctrine\ORM\AbstractQuery->execute (line 901)
20	Doctrine\ORM\AbstractQuery->getResult (line 1128)
21	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
22	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
23	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.88 ms
(0.31%)

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:

[
  159
  "2026-10-05 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

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 >= ?
  )

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 (159) AND n1_.allow_all_documents = true AND (n1_.valid_until IS NULL OR n1_.valid_until >= '2026-10-05 00:00:00');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 991)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1020)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 140)
8	App\Service\NssAccessService->hasActiveAllDocumentsSubscription (line 118)
9	App\Service\NssAccessService->hasAllDocumentsAccess (line 153)
10	App\Service\Manticore\ManticoreSearchService->resolveNssAccess (line 63)
11	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
12	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.86 ms
(0.30%)

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

Parameters:

View formatted query View runnable query Explain query View query backtrace

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);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
8	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
9	Doctrine\ORM\UnitOfWork->createEntity (line 272)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 120)
17	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
18	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.84 ms
(0.29%)

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:

[
  "01a0adf6-fafa-7dfe-8367-ee9f66ee2aa9"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '01a0adf6-fafa-7dfe-8367-ee9f66ee2aa9';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 29)
6	App\Service\Entity\AccessTokenService->findValidToken (line 63)
7	App\Security\ApiTokenAuthenticator->App\Security\{closure} (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
9	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
10	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
17	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
18	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 66)
19	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
20	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
21	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
22	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
23	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.84 ms
(0.29%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797097, 16797006, 16797022, 16797053, 16797028, 16797058, 16797075, 16797076, 16797070, 16797056, 16797167, 16797177, 16797213, 16797219, 16797184, 16797197, 16797198, 16797199, 16797200, 16797201, 16797202, 16797203, 16797204, 16797205, 16797206, 16797207, 16797108, 16797142, 16797146, 16797153, 16797138, 16797141, 16797128, 16797130, 16797131, 16797132, 16797137, 16797152, 16797174, 16797172, 16797216, 16797258);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 1128)
27	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
28	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
29	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.82 ms
(0.29%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797168, 16797170, 16797171, 16797173, 16797175, 16797178, 16797179, 16797180, 16797181, 16797182, 16797183, 16797185, 16797187, 16797188, 16797189, 16797190, 16797191, 16797192, 16797193, 16797196, 16797208, 16797209, 16797211, 16797217, 16797221, 16797222, 16797223, 16797224, 16797225, 16797226, 16797227, 16797228, 16797229, 16797230, 16797231, 16797234, 16797236, 16797240, 16797241, 16797242, 16797244, 16797246, 16797247, 16797248, 16797249, 16797250, 16797251, 16797252, 16797253, 16797256, 16797257, 16797259, 16797260, 16797261, 16797262, 16797263, 16797264, 16797265, 16797266, 16797267, 16797268);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
13	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
14	Doctrine\ORM\UnitOfWork->createEntity (line 272)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
16	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
17	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
18	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
19	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
20	Doctrine\ORM\AbstractQuery->execute (line 901)
21	Doctrine\ORM\AbstractQuery->getResult (line 1128)
22	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
23	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
24	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.80 ms
(0.28%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797186, 16797245, 16797254, 16777256, 16797100, 16777282, 16777283, 16777284, 16777285, 16796946, 16796964, 16796905, 16797090, 16797091, 16796950, 16796951, 16797233, 16796936, 16797067, 16796955, 16796956, 16796957, 16796958, 16796959, 16796960, 16797210, 16797007, 16796987, 16796988, 16797083, 16797086, 16797087);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 1128)
27	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
28	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
29	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.79 ms
(0.28%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797186, 16797245, 16797254, 16777256, 16797100, 16777282, 16777283, 16777284, 16777285, 16796946, 16796964, 16796905, 16797090, 16797091, 16796950, 16796951, 16797233, 16796936, 16797067, 16796955, 16796956, 16796957, 16796958, 16796959, 16796960, 16797210, 16797007, 16796987, 16796988, 16797083, 16797086, 16797087);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 1128)
27	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
28	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
29	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.72 ms
(0.25%)

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.is_system AS is_system_2, f0_.created_by_attribute AS created_by_attribute_3, f0_.is_imported AS is_imported_4, f0_.parent_id AS parent_id_5 FROM folder f0_ WHERE f0_.parent_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.is_system AS is_system_2,
  f0_.created_by_attribute AS created_by_attribute_3,
  f0_.is_imported AS is_imported_4,
  f0_.parent_id AS parent_id_5
FROM
  folder f0_
WHERE
  f0_.parent_id IS NULL

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.is_system AS is_system_2, f0_.created_by_attribute AS created_by_attribute_3, f0_.is_imported AS is_imported_4, f0_.parent_id AS parent_id_5 FROM folder f0_ WHERE f0_.parent_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 1128)
7	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
8	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
9	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.70 ms
(0.25%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797097, 16797006, 16797022, 16797053, 16797028, 16797058, 16797075, 16797076, 16797070, 16797056, 16797167, 16797177, 16797213, 16797219, 16797184, 16797197, 16797198, 16797199, 16797200, 16797201, 16797202, 16797203, 16797204, 16797205, 16797206, 16797207, 16797108, 16797142, 16797146, 16797153, 16797138, 16797141, 16797128, 16797130, 16797131, 16797132, 16797137, 16797152, 16797174, 16797172, 16797216, 16797258);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
18	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
19	Doctrine\ORM\UnitOfWork->createEntity (line 272)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
21	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
22	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
23	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
24	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
25	Doctrine\ORM\AbstractQuery->execute (line 901)
26	Doctrine\ORM\AbstractQuery->getResult (line 1128)
27	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
28	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
29	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.70 ms
(0.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 WHERE t0.parent_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

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 (16796881, 16796882, 16796883, 16796884, 16796885, 16796886, 16796887, 16796888, 16796906, 16796989, 16796990, 16796991, 16796992, 16797084, 16797085, 16797088, 16797089);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
23	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
24	Doctrine\ORM\UnitOfWork->createEntity (line 272)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
26	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
27	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
28	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
29	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
30	Doctrine\ORM\AbstractQuery->execute (line 901)
31	Doctrine\ORM\AbstractQuery->getResult (line 1128)
32	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
33	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
34	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.67 ms
(0.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 WHERE t0.parent_id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

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 (16797029, 16797129, 16797139, 16797214);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
23	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
24	Doctrine\ORM\UnitOfWork->createEntity (line 272)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
26	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
27	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
28	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
29	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
30	Doctrine\ORM\AbstractQuery->execute (line 901)
31	Doctrine\ORM\AbstractQuery->getResult (line 1128)
32	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
33	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
34	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.66 ms
(0.23%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16796881, 16796882, 16796883, 16796884, 16796885, 16796886, 16796887, 16796888, 16796906, 16796989, 16796990, 16796991, 16796992, 16797084, 16797085, 16797088, 16797089);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
23	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
24	Doctrine\ORM\UnitOfWork->createEntity (line 272)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
26	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
27	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
28	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
29	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
30	Doctrine\ORM\AbstractQuery->execute (line 901)
31	Doctrine\ORM\AbstractQuery->getResult (line 1128)
32	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
33	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
34	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.65 ms
(0.23%)

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:

View formatted query View runnable query Explain query View query backtrace

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 (16797029, 16797129, 16797139, 16797214);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
8	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
9	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
11	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
12	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
13	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
14	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
15	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
16	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
17	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3182)
18	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 3156)
19	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
20	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
21	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 779)
22	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 843)
23	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2966)
24	Doctrine\ORM\UnitOfWork->createEntity (line 272)
25	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
26	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
27	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
28	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
29	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
30	Doctrine\ORM\AbstractQuery->execute (line 901)
31	Doctrine\ORM\AbstractQuery->getResult (line 1128)
32	App\Service\Manticore\ManticoreSearchService->getAccessibleFolderIds (line 59)
33	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
34	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 5)

0.48 ms
(0.17%)

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 = ?

Parameters:

[
  684
]

View formatted query View runnable query Explain query View query backtrace

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 = 684;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 257)
7	Doctrine\Common\Collections\AbstractLazyCollection->map (line 113)
8	App\Service\NssAccessService->hasAllDocumentsAccess (line 153)
9	App\Service\Manticore\ManticoreSearchService->resolveNssAccess (line 63)
10	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
11	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.40 ms
(0.14%)

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

Parameters:

[
  201
]

View formatted query View runnable query Explain query View query backtrace

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);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3146)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1001)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1011)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3228)
8	Doctrine\ORM\UnitOfWork->loadCollection (line 3110)
9	Doctrine\ORM\UnitOfWork->createEntity (line 272)
10	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
11	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 120)
17	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
18	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.38 ms
(0.13%)

SELECT f0_.id AS id_0 FROM folder f0_ WHERE f0_.is_imported = true

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 29)
7	App\Service\NssAccessService->getNssFolderIds (line 155)
8	App\Service\Manticore\ManticoreSearchService->resolveNssAccess (line 63)
9	App\Service\Manticore\ManticoreSearchService->searchDocuments (line 51)
10	App\Controller\API\V1\ManticoreSearchController->documentsFindV2 (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

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\AccessToken	No errors.
App\Entity\User	No errors.
App\Entity\EventLog	No errors.
App\Entity\AccessGroup	No errors.
App\Entity\Favorite	No errors.
App\Entity\FavoriteFolder	No errors.
App\Entity\DocumentVersion	No errors.
App\Entity\Notification	No errors.
App\Entity\BackendSettings	No errors.
App\Entity\Folder	No errors.
App\Entity\GroupFolder	No errors.
App\Entity\Document	No errors.
App\Entity\Attribute	No errors.
App\Entity\DictionaryType	No errors.
App\Entity\NssSubscription	No errors.
App\Entity\DocumentAttribute	No errors.
App\Entity\Dictionary	No errors.
App\Entity\DocumentType	No errors.
App\Entity\State	No errors.
App\Entity\Style	No errors.
App\Entity\SettingsItem	No errors.
App\Entity\Settings	No errors.
App\Entity\StyleDetail	No errors.
App\Entity\Term	No errors.
App\Entity\VersionStatus	No errors.
App\Entity\DocumentStructure	No errors.
App\Entity\Parameter	No errors.
App\Entity\Tag	No errors.

Symfony Profiler

POST https://ml-backend.gostinfo.ru/api/v1/documents/findv2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping