Skip to content

Missing filtering by store_idin catalog search #8689

@SKovbel

Description

@SKovbel

Preconditions

Magento 2.1.4

Steps to reproduce

Category Search /as result - Layer Navigation/ works very slow.
For DB with 2 millions products and 8 stores works about 1 min.

Actual result

During investigation found place in code where table catalog_category_product_index using without filtering by field store_id.

Expected result

p.s. If add filtering by store_id, query works 3 seconds.

See screenshots
screenshot_20170227_143335

file Magento\CatalogSearch\Model\Search\TableMapper with commented modification

screenshot_20170227_143354

Metadata

Metadata

Assignees

No one assigned

    Labels

    Fixed in 2.1.xThe issue has been fixed in 2.1 release lineIssue: Clear DescriptionGate 2 Passed. Manual verification of the issue description passedIssue: ConfirmedGate 3 Passed. Manual verification of the issue completed. Issue is confirmedIssue: Format is validGate 1 Passed. Automatic verification of issue format passed

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions