PrestaShop Sphinx Search: Faster Catalog Search on Large Stores

Native catalog search is fine on small shops. On large catalogs it can lag on every keystroke and every reindex. PrestaShop Sphinx search moves full-text matching to a dedicated engine so product lookups stay fast while PrestaShop still renders the product cards.

Sphinx is a full-text search server. You index product fields from MySQL, run a search daemon, then override PrestaShop’s Search::find so storefront queries hit that engine instead of the built-in index. Two lines of the technology matter in practice: Sphinx (still developed; current Sphinx 3 builds differ from the classic open-source 2.x packages) and Manticore Search (an open-source fork of Sphinx 2.x). The install paths and config samples below follow classic Sphinx 2-style packages such as Debian/Ubuntu sphinxsearch. On Manticore or Sphinx 3, expect different package names, config directories, and listen ports – keep the same idea (index product IDs, query them from PHP).

Before you commit to a daemon and an override, try the native tools first – aliases, fuzzy matching, and weights often fix “bad results” without new infrastructure. Walk through those in our PrestaShop search configuration guide. Official option labels for current shops are in the PrestaShop 9 search parameters docs.

Contents hide

1 When PrestaShop Sphinx search is worth the setup

2 Install Sphinx on the server

3 Configure the Sphinx source and index

4 Build the index and start the search daemon

5 Wire PrestaShop Sphinx search with a Search override

6 Clear cache and verify storefront search

6.1 Share:

When PrestaShop Sphinx search is worth the setup

Sphinx pays off when:

Product search or index rebuilds feel slow under real traffic.
You need morphology / stemming beyond what Shop Parameters → Search gives you.
You are comfortable running a small service on the same host (or a nearby one) and keeping an index cron healthy.

Skip it when the catalog is modest and the pain is relevance only – fix indexing, aliases, and weights first. Also take a full PrestaShop backup before any class override; a bad Search.php can blank the storefront search page.

Install Sphinx on the server

Package names differ by distro. On Debian/Ubuntu, if the classic package is available:

sudo apt-get update
sudo apt-get install sphinxsearch

That package is still present on several Debian releases, but it is the older Sphinx 2 line – not Sphinx 3. If sphinxsearch is missing from your repos, or you want a maintained open-source build, install Manticore from its current Debian/Ubuntu instructions instead. Avoid pinning ancient .deb filenames copied from old tutorials (for example Wheezy-era Sphinx 2.2 packages) – grab whatever your distro or vendor documents for today.

Paths below assume a classic layout under /etc/sphinxsearch/. Manticore often uses /etc/manticoresearch/. Note the SQL listen port from your install docs before you point PrestaShop Sphinx search at the daemon (classic Sphinx often used 9306; other builds differ).

Configure the Sphinx source and index

Edit the config (often /etc/sphinxsearch/sphinx.conf):

sudo nano /etc/sphinxsearch/sphinx.conf

Define a MySQL source that pulls the fields you want searchable. Replace credentials and table prefix with your shop’s values (ps_ is the default PrestaShop prefix):

source PrestaSite
{
    type = mysql
    sql_host = localhost
    sql_user = DBUSER
    sql_pass = DBPASSWORD
    sql_db = DBNAME
    sql_port = 3306
    sql_query_pre = SET NAMES utf8mb4

    sql_query = \
        SELECT id_product, name, description, description_short \
        FROM ps_product_lang
}

index PrestaSite
{
    source = PrestaSite
    path = /var/lib/sphinxsearch/data/prestasite
    morphology = stem_en
    min_word_len = 1
}

The first column of sql_query becomes the document ID Sphinx returns – here that is id_product. The query is intentionally minimal. Multilingual or multistore shops usually filter by id_lang / shop, or build one index per language. Leave the indexer and search-daemon blocks at sane defaults unless you know you need custom ports or log paths. On Sphinx 3 or Manticore, the config syntax may look different; map the same pieces (DB credentials, SELECT of product fields, index path).

Build the index and start the search daemon

Index once, then start the daemon. Classic Sphinx uses indexer / searchd; some packages wrap the same steps in systemctl:

sudo indexer --all
sudo searchd

Refresh on a schedule so new and edited products appear in results. Hourly is a common starting point. In /etc/crontab (system crontab, which includes a username column):

15 * * * * root indexer --all

If you use a user crontab (crontab -e), drop the root column and call the full path to indexer. Confirm the daemon is listening on the port your config declares. If it fails to start, check permissions on the index path and that nothing else already binds that port. PrestaShop Sphinx search only works once this listener answers MATCH queries.

Wire PrestaShop Sphinx search with a Search override

PrestaShop still owns product loading, stock, images, and templates. Sphinx only returns matching product IDs. You override Search::find so those IDs come from Sphinx, then run a normal product SQL for the current language and shop.

On current PrestaShop releases (1.7 through 9), Search::find still takes a similar argument list, but the method body, fuzzy-search handling, and product SQL have changed a lot since 1.6. Do not drop an old override file onto a modern shop. Open your shop’s classes/Search.php, copy find into /override/classes/Search.php, then replace only the part that resolves matching product IDs with a Sphinx/Manticore query – keep the rest of the core logic. The PHP below is a simplified illustration of that ID swap (SphinxSQL on port 9306, index name PrestaSite), not a paste-ready override for PrestaShop 9.

<?php
// Illustration only - adapt against your shop's classes/Search.php

protected static function getSphinxResults($search_query, $offset, $page_size)
{
    $results = array();
    $total = 0;

    if (!$search_query) {
        return null;
    }

    // Port and index name must match your Sphinx/Manticore config
    $link = @mysqli_connect('127.0.0.1', '', '', '', 9306);
    if (!$link) {
        return array('results' => $results, 'total' => $total);
    }

    $query = 'SELECT id FROM `PrestaSite` WHERE MATCH(\''.pSQL($search_query).'\') LIMIT '.(int)$offset.', '.(int)$page_size;
    if ($result = $link->query($query)) {
        while ($row = $result->fetch_assoc()) {
            if (isset($row['id'])) {
                $results[] = (int) $row['id'];
            }
        }
        $result->close();
    }

    $query_total = 'SELECT count(*) AS c FROM `PrestaSite` WHERE MATCH(\''.pSQL($search_query).'\')';
    if ($result = $link->query($query_total)) {
        $total = (int) $result->fetch_assoc()['c'];
        if ($total > 1000) {
            $total = 1000;
        }
        $result->close();
    }

    mysqli_close($link);

    return array('results' => $results, 'total' => $total);
}

In your override of find, call that helper, then restrict the core product query with WHERE p.id_product IN (...) using the returned IDs (cast to integers). That is the whole PrestaShop Sphinx search hook: IDs from the daemon, everything else from PrestaShop. Harden for production: escape carefully, prefer prepared statements where the client allows them, and fall back to native search if the daemon is down. After saving the override, clear caches so PrestaShop reloads the class.

Clear cache and verify storefront search

Clear cache from Advanced Parameters → Performance (and remove a legacy /cache/class_index.php if your install still uses that path).
Confirm the override file is readable and named exactly Search.php under /override/classes/.
Search for a known product name in a private window.
If you get a blank page after the override, treat it like any fatal PHP error – see our white screen of death checklist, then restore the backup if needed.

PrestaShop Sphinx search is infrastructure, not a Back Office toggle. Keep the indexer cron honest, watch disk for the index path, and revisit native search settings whenever relevance – not speed – is the real complaint.

16 thoughts on “PrestaShop Sphinx Search: Faster Catalog Search on Large Stores”

Guido says:
20.05.2017 at 13:09
I work with Sphinx in Prestashop 1.5.6.3, works fine but plan to upgrade to 1.7.
Anyone has experience with Sphinx in Prestashop1.7. Will the 1.6 code work, or not?
Reply
1. polosat says:
  22.05.2017 at 19:27
  This part of code in PrestaShop 1.7 is almost the same as in PS 1.6 , so 1.6 code should work fine.
  Reply
  1. Guido Corbesier says:
    25.09.2017 at 16:37
    Reply
alice says:
23.11.2016 at 21:23
source ab1 { type = mysql sql_host = localhost sql_user = abc sql_pass =123 sql_db = abc_d sql_port = 3306 # optional, default is 3306 sql_query = SELECT id_product, name, description, description_short FROM ps_product_lang sql_query_pre = SET NAMES utf8 } index lang1 { source = ab1 path = /var/lib/sphinx/lang1 # morphology preprocessors morphology = stem_en # minimal word length for indexation min_word_len = 1 } index b1rt { type = rt rt_mem_limit = 512M path = /var/lib/sphinx/b1rt rt_field = title rt_field = content rt_attr_uint = gid } indexer { mem_limit = 512M } searchd { listen = 9312 listen = 9306:mysql41 log = /var/log/sphinx/searchd.log query_log = /var/log/sphinx/query.log read_timeout = 5 max_children = 30 pid_file = /var/run/sphinx/searchd.pid seamless_rotate = 1 preopen_indexes = 1 unlink_old = 1 workers = threads # for RT to work binlog_path = /var/lib/sphinx/ }
Reply
alice says:
19.11.2016 at 00:35
i checked almost everyday,=^_^=,it worked,cool,but have some bugs like:
1).Can’t search “A. B” for “A B”;
2).Just serach by ‘@name’ not include ‘description_short’ and ‘description’
3).Named “A B 3” can’t be serched whit “A B 3” but can be searched by “A B”
Thanks a million and happy everyday.=^_^=
Reply
1. polosat says:
  23.11.2016 at 19:03
  Well, are you sure that you’re using default Sphinx settings? 🙂
  Yes, I know about @name, but I just thought it can help for preventing from searching wrong products. You can try adding @description_short and @description, maybe it will work better.
  I not sure what else can be changed… Please send me your sphinx.conf, maybe I’ll find something.
  Reply

Hi,
Would you write “Search.php” for 1.4.2.5,MANY MANY MANY MANY MANY MANY THANKS FOR YOUR TIME.
Regards,

Hi,
Try this code, it should work fine:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139

<?php
class Search extends SearchCore
{
public static function find(
$id_lang,
$expr,
$pageNumber = 1,
$pageSize = 1,
$orderBy = 'position',
$orderWay = 'desc',
$ajax = false,
$useCookie = true
) {
global $cookie;
$db = Db::getInstance(_PS_USE_SQL_SLAVE_);

// Only use cookie if id_customer is not present
if ($useCookie) {
$id_customer = $cookie->id_customer;
} else {
$id_customer = 0;
}

// TODO : smart page management
if ($pageNumber < 1) {
$pageNumber = 1;
}
if ($pageSize < 1) {
$pageSize = 1;
}

if (!Validate::isOrderBy($orderBy) OR !Validate::isOrderWay($orderWay)) {
return false;
}

// Sphinx search, get ids of found products
$sphinx_results = self::getSphinxResults($expr, $pageNumber, $pageSize);

$eligibleProducts = $sphinx_results['results'];

$score = '';
$productPool = '';
foreach ($eligibleProducts AS $id_product) {
if ($id_product) {
$productPool .= (int)$id_product . ',';
}
}
if (empty($productPool)) {
return ($ajax ? array() : array('total' => 0, 'result' => array()));
}
$productPool = ((strpos($productPool,
',') === false) ? (' = ' . (int)$productPool . ' ') : (' IN (' . rtrim($productPool, ',') . ') '));

if ($ajax) {
return $db->ExecuteS('
SELECT DISTINCT p.id_product, pl.name pname, cl.name cname,
cl.link_rewrite crewrite, pl.link_rewrite prewrite ' . $score . '
FROM ' . _DB_PREFIX_ . 'product p
INNER JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = ' . (int)$id_lang . ')
INNER JOIN `' . _DB_PREFIX_ . 'category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = ' . (int)$id_lang . ')
WHERE p.`id_product` ' . $productPool . '
ORDER BY position DESC LIMIT 10');
}

$queryResults = '
SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,
tax.`rate`, i.`id_image`, il.`legend`, m.`name` manufacturer_name ' . $score . ', DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL ' . (Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20) . ' DAY)) > 0 new
FROM ' . _DB_PREFIX_ . 'product p
INNER JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = ' . (int)$id_lang . ')
LEFT JOIN `' . _DB_PREFIX_ . 'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = ' . (int)Country::getDefaultCountryId() . '
AND tr.`id_state` = 0)
LEFT JOIN `' . _DB_PREFIX_ . 'tax` tax ON (tax.`id_tax` = tr.`id_tax`)
LEFT JOIN `' . _DB_PREFIX_ . 'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `' . _DB_PREFIX_ . 'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `' . _DB_PREFIX_ . 'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = ' . (int)$id_lang . ')
WHERE p.`id_product` ' . $productPool . '
' . ($orderBy ? 'ORDER BY ' . $orderBy : '') . ($orderWay ? ' ' . $orderWay : '') . '
LIMIT ' . (int)(($pageNumber - 1) * $pageSize) . ',' . (int)$pageSize;

$result = $db->ExecuteS($queryResults);
$total = $db->getValue('SELECT COUNT(*)
FROM ' . _DB_PREFIX_ . 'product p
INNER JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = ' . (int)$id_lang . ')
LEFT JOIN `' . _DB_PREFIX_ . 'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = ' . (int)Country::getDefaultCountryId() . '
AND tr.`id_state` = 0)
LEFT JOIN `' . _DB_PREFIX_ . 'tax` tax ON (tax.`id_tax` = tr.`id_tax`)
LEFT JOIN `' . _DB_PREFIX_ . 'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `' . _DB_PREFIX_ . 'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `' . _DB_PREFIX_ . 'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = ' . (int)$id_lang . ')
WHERE p.`id_product` ' . $productPool);

if (!$result) {
$resultProperties = false;
} else {
$resultProperties = Product::getProductsProperties($id_lang, $result);
}

return array('total' => $total, 'result' => $resultProperties);
}

protected static function getSphinxResults($search_query, $page_number, $page_size)
{
$results = array();
$total = 0;

if (!$search_query) {
return null;
}

// connect to Sphinx database
$link = mysqli_connect('127.0.0.1', '', '', '', '9306');
if ($link) {
$query = 'SELECT * FROM `PrestaSite` WHERE MATCH(\'' . pSQL($search_query) . '\') LIMIT ' . pSQL($page_number) . ', ' . pSQL($page_size) . ';';
if ($result = $link->query($query)) {
while ($query_results = $result->fetch_array()) {
$results = array_merge($results, $query_results);
}

/* clear result */
$result->close();
}

// get count of results
$query_total = 'SELECT count(*) FROM `PrestaSite` WHERE MATCH(\'' . pSQL($search_query) . '\');';
if ($result = $link->query($query_total)) {
$total = (int)$result->fetch_array()[0];
if ($total > 1000) {
$total = 1000;
}
}

mysqli_close($link);
}

return array('results' => $results, 'total' => $total);
}
}

OMG,Thanks a million for your kind help and your time.
1.Deleted “[0]” at line 128 and worked;
2.Search “iPod shuffle” but get “iPod Nano”,search “iPod shuff” get “No results…”,tried item’s “name, description, description_short” but result not correct;
3.I’m using a module called “jbx_menu” and need to disable the “Quick Search block”,could your write it for “jbx_menu”,i will send the “”jbx_menu”” to your email.
THANKS A MILLION MILLION MILLION MILLION FOR YOUR TIME,YOU’RE THE SUPERMAN!!!

1) Well, actually it shouldn’t work without [0] 🙂 Try to var_dump the $result->fetch_array() at that line and see what you should use.
2) I not sure what could cause such a problem. Maybe it’s because of some Sphinx settings. Try to re-index your database again.
3) You mean you want to disable your default search block? You can disable blocksearch module in Back Office or just add this to your global.css:
#search_block_top {
display: none;
}

Thanks a million.
1.Try:
$total = (int)var_dump($result->fetch_array());
echo like:
array(2) { [0]=> string(1) “1” [“count(*)”]=> string(1) “1” }
array(2) { [0]=> string(1) “0” [“count(*)”]=> string(1) “0” }
array(2) { [0]=> string(1) “5” [“count(*)”]=> string(1) “5” }
2.Try:
$total = (int)$result->fetch_array()[0];
echo:
Parse error: syntax error, unexpected ‘[‘ in ~/override/classes/Search.php on line 128
3.For 3),i mean that the “jbx_menu” module include search function,the same like on your site when i type “cur” and then the search bar echo:
Modules>Multi Currency PRO
Modules>Multi Currency
And i wanna Sphinx enable for “jbx_menu”.=^_^=

Ok, try to replace that line with the following code:

1
2
3
4
5

$total = $result->fetch_array();
if (is_array($total) && isset($total[0]))
$total = (int)$total[0];
else
$total = 0;

Well, as I see jbx_menu uses default PrestaShop search engine, so it should use Sphynx search automatically since you override Search class. Does it work correctly without overriding Search class?

Many thanks,now it’s get no error,but:
1.The search result is still not correct,i have checked the Sphinx query_log like below:
[Tue Nov 1 21:11:05.683 2016] 0.000 sec 0.000 sec [ext2/0/ext 1 (0,20)] [0t01] ipod
[Tue Nov 1 21:11:07.742 2016] 0.000 sec 0.000 sec [ext2/0/ext 1 (1,10)] [0t01] AB
So I wanna try to do like below:
setMatchMode(SPH_MATCH_PHRASE);
but don’t know how to do…
2.The “jbx_menu” can be searched but you need to type the whole word like your site “Multi Currency”,but actually you just need type “cur” and then the search bar will echo suggest:
Modules>Multi Currency PRO
Modules>Multi Currency
I tried to modify the jbx_menu.php at line 208 and 224 (“ENGINE=InnoBD”) and replaced “InnoBD” on “MyISAM”,but no change.
So sorry for my skill and SOOOOO Sorry to disturb you again.Thanks for your time.
Regards,

Ok, I see…
Well, I’ll try to find something that can help.
No need to edit jbx_menu.php, it won’t change search settings.
Sorry for the delay and don’t worry about disturbing me, no problem 🙂

WoW…Thanks a million for your generous help.=^_^=

Hi Alice,
Hope you’re still interested…
I’ve made some changes to the previous code, please try it.

<?php
class Search extends SearchCore
{
public static function find(
$id_lang,
$expr,
$pageNumber = 1,
$pageSize = 1,
$orderBy = 'position',
$orderWay = 'desc',
$ajax = false,
$useCookie = true
) {
global $cookie;
$db = Db::getInstance(_PS_USE_SQL_SLAVE_);

// Only use cookie if id_customer is not present
if ($useCookie) {
$id_customer = $cookie->id_customer;
} else {
$id_customer = 0;
}

// TODO : smart page management
if ($pageNumber < 1) {
$pageNumber = 1;
}
if ($pageSize < 1) {
$pageSize = 1;
}

if (!Validate::isOrderBy($orderBy) OR !Validate::isOrderWay($orderWay)) {
return false;
}

// Sphinx search, get ids of found products
$sphinx_results = self::getSphinxResults($expr, $pageNumber, $pageSize);

$eligibleProducts = $sphinx_results['results'];

$score = '';
$productPool = '';
foreach ($eligibleProducts AS $id_product) {
if ($id_product) {
$productPool .= (int)$id_product . ',';
}
}
if (empty($productPool)) {
return ($ajax ? array() : array('total' => 0, 'result' => array()));
}
$productPool = ((strpos($productPool,
',') === false) ? (' = ' . (int)$productPool . ' ') : (' IN (' . rtrim($productPool, ',') . ') '));

if ($ajax) {
return $db->ExecuteS('
SELECT DISTINCT p.id_product, pl.name pname, cl.name cname,
cl.link_rewrite crewrite, pl.link_rewrite prewrite ' . $score . '
FROM ' . _DB_PREFIX_ . 'product p
INNER JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = ' . (int)$id_lang . ')
INNER JOIN `' . _DB_PREFIX_ . 'category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND cl.`id_lang` = ' . (int)$id_lang . ')
WHERE p.`id_product` ' . $productPool . '
ORDER BY p.`id_product` DESC LIMIT 10');
}

$queryResults = '
SELECT p.*, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,
tax.`rate`, i.`id_image`, il.`legend`, m.`name` manufacturer_name ' . $score . ', DATEDIFF(p.`date_add`, DATE_SUB(NOW(), INTERVAL ' . (Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20) . ' DAY)) > 0 new
FROM ' . _DB_PREFIX_ . 'product p
INNER JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = ' . (int)$id_lang . ')
LEFT JOIN `' . _DB_PREFIX_ . 'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = ' . (int)Country::getDefaultCountryId() . '
AND tr.`id_state` = 0)
LEFT JOIN `' . _DB_PREFIX_ . 'tax` tax ON (tax.`id_tax` = tr.`id_tax`)
LEFT JOIN `' . _DB_PREFIX_ . 'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `' . _DB_PREFIX_ . 'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `' . _DB_PREFIX_ . 'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = ' . (int)$id_lang . ')
WHERE p.`id_product` ' . $productPool . '
' . ($orderBy ? 'ORDER BY ' . $orderBy : '') . ($orderWay ? ' ' . $orderWay : '') . '
LIMIT ' . (int)(($pageNumber - 1) * $pageSize) . ',' . (int)$pageSize;

$result = $db->ExecuteS($queryResults);
$total = $db->getValue('SELECT COUNT(*)
FROM ' . _DB_PREFIX_ . 'product p
INNER JOIN `' . _DB_PREFIX_ . 'product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = ' . (int)$id_lang . ')
LEFT JOIN `' . _DB_PREFIX_ . 'tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = ' . (int)Country::getDefaultCountryId() . '
AND tr.`id_state` = 0)
LEFT JOIN `' . _DB_PREFIX_ . 'tax` tax ON (tax.`id_tax` = tr.`id_tax`)
LEFT JOIN `' . _DB_PREFIX_ . 'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `' . _DB_PREFIX_ . 'image` i ON (i.`id_product` = p.`id_product` AND i.`cover` = 1)
LEFT JOIN `' . _DB_PREFIX_ . 'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = ' . (int)$id_lang . ')
WHERE p.`id_product` ' . $productPool);

if (!$result) {
$resultProperties = false;
} else {
$resultProperties = Product::getProductsProperties($id_lang, $result);
}

return array('total' => $total, 'result' => $resultProperties);
}

protected static function getSphinxResults($search_query, $page_number, $page_size)
{
$results = array();
$total = 0;

if (!$search_query) {
return null;
}

// connect to Sphinx database
$link = mysqli_connect('127.0.0.1', '', '', '', '9306');
if ($link) {
$query = 'SELECT * FROM `PrestaSite` WHERE MATCH(\'@name ' . pSQL($search_query) . '\') LIMIT ' . pSQL($page_number) . ', ' . pSQL($page_size) . ';';
if ($result = $link->query($query)) {
while ($query_results = $result->fetch_array()) {
$results = array_merge($results, $query_results);
}

/* clear result */
$result->close();
}

// get count of results
$query_total = 'SELECT count(*) FROM `PrestaSite` WHERE MATCH(\'@name ' . pSQL($search_query) . '\');';
if ($result = $link->query($query_total)) {
$total = (int)$result->fetch_array()[0];
if ($total > 1000) {
$total = 1000;
}
}

mysqli_close($link);
}

return array('results' => $results, 'total' => $total);
}
}