How to understand which queries to create indexes in the "Index Analysis"?

Question

1C-Bitrix

Hello.

In Bitrix, on the Settings -> Performance -> Indexes -> Index Analysis page, about 25 non-indexed queries are displayed.
In the documentation, I managed to find information only that it makes no sense to index all these queries, it is necessary to determine whether there is a need for its indexing. How to understand whether to index a query or not, I did not find the answer.

Two questions:
1. How to understand where the request from this list is called? Information about the place of execution of the code making the request is available only on the "SQL Queries" page.
2. What queries should be indexed?

Answer 1

Here the question is not about Bitrix, but about the database and indexing. Read in general about indexes, what it is and why you need it. And then, based on queries, think whether they need to make indexes (and which ones) or not.
Reading: https://ruhighload.com/post/Working+with+indexes+in+MySQL