Tag: magento

Not the actual answer but you can identify some ways.

Add two plugins one is for GetLoadedProductCollection and second is for what ElasticSearch returning ids.

File: di.xml

<type name="MagentoCatalogBlockProductListProduct">
        <plugin name="VendorModule::logListProductQuery" type="VendorModulePluginCatalogProductPluginListProduct"/>
</type>

File : PluginListProduct.php

namespace VendorModulePluginCatalogProduct;
    
use PsrLogLoggerInterface;

class PluginListProduct
{
     
    public function __construct(
        LoggerInterface $logger
    )
    {
        $this->logger = $logger;

    }

     
    public function afterGetLoadedProductCollection(MageListProduct $subject, $result)
    {
        $writer = new ZendLogWriterStream(BP . '/var/log/PluginListProductQuery.log');
        $logger = new ZendLogLogger();
        $logger->addWriter($writer);
        
        $logger->info($result->getSelect()->__toString());      

        return $result;
    }
}

Also, add a custom plugin it will help you to identify which ids ElasticSearch returning.
This will only useful if ElasticSearch is using as Catalog Search engine.

File: di.xml

<type name="MagentoElasticsearchSearchAdapterResponseFactory">
        <plugin name="Vendor_Module::responseCheckFromElasticSearch"
                type="VendorModulePluginResponseCheck"
                disabled="false"/>
    </type>

File: ResponseCheck.php

<?php
namespace VendorModulePlugin;

use PsrLogLoggerInterface;


class ResponseCheck
{   
    protected $logger;
 
    public function __construct(
        LoggerInterface $logger
    )
    {
        $this->logger = $logger;

    }


    public function beforeCreate(MagentoElasticsearchSearchAdapterResponseFactory $subject, $result)
    {
        $docRaw = $docRawScore = array();
        $writer = new ZendLogWriterStream(BP . '/var/log/ElasticResponseCheck.log');
        $logger = new ZendLogLogger();
        $logger->addWriter($writer);
        if (!is_array($result) || empty($result)) return false;
        foreach ($result('documents') as $rawDocument) {
            $docRaw() = $rawDocument('_id');
            $docRawScore() = $rawDocument('_score');
            
        }

        $logger->info('ID: ' . implode(',', $docRaw));
        $logger->info('SCORE: ' . implode(',', $docRawScore));
        $logger->info('*************************************** END *********************************************');

    }


}

Probably you will get following order by in PluginListProductQuery.log and compare these ids with what is returning in ElasticResponseCheck.log

• With ElasticSearch as a search engine
  possible order by for Elastic search would be – ORDER BY FIELD(e.entity_id,103,102,101)

• With MySQL as a search engine
  possible order by – ORDER BY cat_index.position asc, e.entity_id DESC LIMIT 4

Hope this helps.