select node.id as node_id, node.version as node_version, prop.qname_id as qname_id, prop.locale_id as locale_id, prop.list_index as list_index, prop.actual_type_n as actual_type_n, prop.persisted_type_n as persisted_type_n, prop.boolean_value as boolean_value, prop.long_value as long_value, prop.float_value as float_value, prop.double_value as double_value, prop.string_value as string_value, prop.serializable_value as serializable_value from alf_node node join alf_node_properties prop on (prop.node_id = node.id) WHERE node_id in ( $1, ..., $256 )
Why is it doing so many queries like that? It is possible that it is reindexing all the documents? What can I do to understand what is it doing?
With that I mean that this type of query is usually only done when some code / component is doing a query using the SearchService.query() operation, which most of the time involves a SOLR (or Lucene) query.
By default Alfresco should not do any intensive queries during startup on its own, so this might be triggered by some kind of custom code or 3rd party addon.