Does where the page is located on the site affect its position?

Question

Search Engine Optimization

Let's say the page is perfectly optimized, the keywords are perfectly matched. But it is located in a section of the site that has a completely different theme. Do the keywords of the "parent" pages affect the indexing of the current page?

For example, breadcrumbs of a similar page of a similar site:
Women's clothing -> Underwear -> Underwear -> Overview of the match "Spartak - Zenit"

Answer 1

But it is located in a section of the site that has a completely different theme. Do the keywords of the "parent" pages affect the indexing of the current page?

Does not affect indexing. You are confusing warm with soft.

For example, breadcrumbs of a similar page of a similar site:
Women's clothing -> Underwear -> Underwear -> Overview of the match "Spartak - Zenit"

This will affect positions.

Answer 2

no, it affects what is on the page and not on others

Answer 3

This is morphology. In php and mysql, in general, the primitive is the most. From LIKE% request% there is not much to squeeze out. Yes, you can probably find a press plugin for accurate searches, but in any case, morphology will require a lot of product indexing and good search performance.
On good for this you need a separate server.
habrahabr.ru/post/117025

Answer 4

Google here -> Sphinx, Elasticsearch, Apache Solr