{"id":1061,"date":"2021-10-22T15:18:50","date_gmt":"2021-10-22T12:18:50","guid":{"rendered":"https:\/\/presta.site\/blog\/korzystanie-z-wyszukiwarki-sphinx-w-prestashop\/"},"modified":"2026-06-30T09:12:24","modified_gmt":"2026-06-30T06:12:24","slug":"korzystanie-z-wyszukiwarki-sphinx-w-prestashop","status":"publish","type":"post","link":"https:\/\/presta.site\/blog\/pl\/korzystanie-z-wyszukiwarki-sphinx-w-prestashop\/","title":{"rendered":"Korzystanie z wyszukiwarki Sphinx w PrestaShop"},"content":{"rendered":"

PrestaShop posiada ca\u0142kiem dobre narz\u0119dzie wyszukiwania, ale czasami nie spe\u0142nia ono wszystkich Twoich potrzeb. Nie jest te\u017c zbyt szybkie, a w du\u017cych sklepach wyszukiwanie i indeksacja mog\u0105 by\u0107 bardzo powolne.<\/p>\n

Je\u015bli potrzebujesz czego\u015b lepszego, mo\u017cesz u\u017cy\u0107 \u015bwietnego zamiennika – Sphinx.<\/p>\n


\nZ Wikipedii:<\/p>\n

Sphinx to darmowy silnik wyszukiwania pe\u0142notekstowego o otwartym kodzie \u017ar\u00f3d\u0142owym, zaprojektowany w celu zapewnienia funkcjonalno\u015bci wyszukiwania pe\u0142notekstowego dla aplikacji klienckich.<\/p><\/blockquote>\n

Strona internetowa Sphinx – http:\/\/sphinxsearch.com\/<\/a><\/p>\n

Instalacja Sphinx<\/h2>\n

U\u017cy\u0142em Debiana 8.1. W innych dystrybucjach Linuksa (a zw\u0142aszcza w Windowsie) instalacja mo\u017ce si\u0119 nieznacznie r\u00f3\u017cni\u0107.
\nJe\u015bli Sphinx jest dost\u0119pny w repozytoriach, po prostu go zainstaluj:<\/p>\n

1
2
3
<\/div><\/td>
su<\/span>
\napt-get update<\/span>
\napt-get install<\/span> sphinxsearch<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Je\u015bli Sphinx nie jest dost\u0119pny w repozytoriach, mo\u017cesz pobra\u0107 instalator z oficjalnej strony i zainstalowa\u0107 zale\u017cno\u015bci:<\/p>\n

1
2
3
<\/div><\/td>
apt-get install<\/span> mysql-client unixodbc libpq5
\nwget<\/span> http:\/\/<\/span>sphinxsearch.com\/<\/span>files\/<\/span>sphinxsearch_2.2.9-release-1<\/span>~wheezy_i386.deb
\ndpkg<\/span> -i<\/span> sphinxsearch_2.2.9-release-1<\/span>~wheezy_i386.deb<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Musisz zast\u0105pi\u0107 nazw\u0119 i adres URL instalatora aktualnymi wersjami. Wszystkie s\u0105 dost\u0119pne na oficjalnej stronie internetowej.<\/p>\n

Konfiguracja Sphinx<\/h2>\n

Otw\u00f3rz konfiguracj\u0119 Sphinx i edytuj j\u0105:<\/p>\n

1
<\/div><\/td>
nano<\/span> \/<\/span>etc\/<\/span>sphinxsearch\/<\/span>sphinx.conf<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Musisz edytowa\u0107 istniej\u0105cy domy\u015blny blok “source src1” (lub doda\u0107 nowy blok). Wynik powinien wygl\u0105da\u0107 tak:<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<\/div><\/td>
source PrestaSite
\n{<\/span>
\ntype<\/span> =<\/span> mysql<\/span>
\nsql_host<\/span> =<\/span> localhost<\/span>
\n# Nazwa u\u017cytkownika bazy danych PrestaShop
\nsql_user<\/span> =<\/span> DBUSER<\/span>
\n# Has\u0142o bazy danych PrestaShop
\nsql_pass<\/span> =<\/span> DBPASSWORD<\/span>
\n# Nazwa bazy danych PrestaShop
\nsql_db<\/span> =<\/span> DBNAME<\/span>
\nsql_port<\/span> =<\/span> 3306 # opcjonalnie, domy\u015blnie 3306<\/span>
\nsql_query_pre<\/span> =<\/span> SET NAMES utf8<\/span>
\n
\n# Zapytanie MySQL z list\u0105 p\u00f3l do indeksacji
\nsql_query<\/span> =<\/span>
\nSELECT id_product, name, description, description_short
\nFROM ps_product_lang
\n}<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Najpierw widzisz ustawienia po\u0142\u0105czenia z baz\u0105 danych (nie zapomnij zmieni\u0107 ich na w\u0142a\u015bciwe<\/span>). Parametr sql_query<\/span> zawiera zapytanie z polami do indeksacji.<\/p>\n

To s\u0105 wszystkie ustawienia z mojej konfiguracji. Zasadniczo plik konfiguracyjny jest dobrze udokumentowany i wszystkie opcje s\u0105 w nim opisane, wi\u0119c mo\u017cesz \u0142atwo dostosowa\u0107 swoj\u0105 konfiguracj\u0119.<\/p>\n

Nast\u0119pnie, w bloku “index definition” musisz skonfigurowa\u0107 indeks:<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<\/div><\/td>
index PrestaSite
\n{<\/span>
\n# \u017ar\u00f3d\u0142o danych do indeksacji
\nsource<\/span> =<\/span> PrestaSite<\/span>
\n
\n# lokalizacja danych indeksu
\npath<\/span> =<\/span> \/var\/lib\/sphinxsearch\/data\/prestasite<\/span>
\n
\n# preprocesory morfologiczne
\nmorphology<\/span> =<\/span> stem_en<\/span>
\n
\n# minimalna d\u0142ugo\u015b\u0107 s\u0142owa do indeksacji
\nmin_word_len<\/span> =<\/span> 1<\/span>
\n}<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Nast\u0119pnie widzisz bloki “indexer settings” i “searchd settings”. Zazwyczaj s\u0105 one w porz\u0105dku, mo\u017cesz je po prostu pomin\u0105\u0107.<\/p>\n

Wi\u0119c skonfigurowali\u015bmy \u017ar\u00f3d\u0142o danych (source PrestaSite) i indeks (index PrestaSite).<\/span><\/p>\n

Indeksacja<\/h2>\n

Uruchom indeksator, aby zaindeksowa\u0107 swoj\u0105 baz\u0119 danych:<\/p>\n

1
<\/div><\/td>
indexer --all<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Uruchomienie Sphinx<\/h2>\n

Nie zapomnij uruchomi\u0107\/zrestartowa\u0107 searchd:<\/p>\n

1
<\/div><\/td>
searchd<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

I dodaj indeksator do crontab:<\/p>\n

1
<\/div><\/td>
15<\/span> *<\/span> *<\/span> *<\/span> *<\/span> root indexer --all<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Indeksacja b\u0119dzie uruchamiana co godzin\u0119.<\/p>\n

Konfiguracja PrestaShop<\/h2>\n

Poni\u017cej znajduje si\u0119 kod dla PrestaShop 1.6. W innych wersjach PrestaShop mo\u017ce si\u0119 on nieznacznie r\u00f3\u017cni\u0107.<\/p>\n

Utw\u00f3rz (lub edytuj) nadpisanie klasy Search:
\n\/override\/classes\/Search.php<\/p>\n

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
<\/div><\/td>
<?php<\/span>
\nclass<\/span> Search extends<\/span> SearchCore {<\/span>
\n    public<\/span> static function<\/span> find(<\/span>$id_lang<\/span>,<\/span> $expr<\/span>,<\/span> $page_number<\/span> =<\/span> 1<\/span>,<\/span> $page_size<\/span> =<\/span> 1<\/span>,<\/span> $order_by<\/span> =<\/span> 'position'<\/span>,<\/span>
\n        $order_way<\/span> =<\/span> 'desc'<\/span>,<\/span> $ajax<\/span> =<\/span> false<\/span>,<\/span> $use_cookie<\/span> =<\/span> true<\/span>,<\/span> Context $context<\/span> =<\/span> null<\/span>)<\/span>
\n    {<\/span>
\n        if<\/span> (<\/span>!<\/span>$context<\/span>)<\/span> {<\/span>
\n            $context<\/span> =<\/span> Context::<\/span>getContext<\/span>(<\/span>)<\/span>;<\/span>
\n        }<\/span>
\n        $db<\/span> =<\/span> Db::<\/span>getInstance<\/span>(<\/span>_PS_USE_SQL_SLAVE_)<\/span>;<\/span>
\n
\n        \/\/ TODO : smart page management<\/span>
\n        if<\/span> (<\/span>$page_number<\/span> <<\/span> 1<\/span>)<\/span> $page_number<\/span> =<\/span> 1<\/span>;<\/span>
\n        if<\/span> (<\/span>$page_size<\/span> <<\/span> 1<\/span>)<\/span> $page_size<\/span> =<\/span> 1<\/span>;<\/span>
\n
\n        if<\/span> (<\/span>!<\/span>Validate::<\/span>isOrderBy<\/span>(<\/span>$order_by<\/span>)<\/span> ||<\/span> !<\/span>Validate::<\/span>isOrderWay<\/span>(<\/span>$order_way<\/span>)<\/span>)<\/span>
\n            return<\/span> false<\/span>;<\/span>
\n
\n        if<\/span> (<\/span>!<\/span>Validate::<\/span>isOrderBy<\/span>(<\/span>$order_by<\/span>)<\/span> ||<\/span> !<\/span>Validate::<\/span>isOrderWay<\/span>(<\/span>$order_way<\/span>)<\/span>)<\/span> {<\/span>
\n            return<\/span> false<\/span>;<\/span>
\n        }<\/span>
\n
\n        $start<\/span> =<\/span> (<\/span>$page_number<\/span> -<\/span> 1<\/span>)<\/span> *<\/span> $page_size<\/span>;<\/span>
\n
\n        \/\/ Sphinx search, get ids of found products<\/span>
\n        $sphinx_results<\/span> =<\/span> self<\/span>::<\/span>getSphinxResults<\/span>(<\/span>$expr<\/span>,<\/span> $start<\/span>,<\/span> $page_size<\/span>)<\/span>;<\/span>
\n
\n        $result<\/span> =<\/span> null<\/span>;<\/span>
\n        $total<\/span> =<\/span> 0<\/span>;<\/span>
\n        \/\/ get products by id if something found<\/span>
\n        if<\/span> (<\/span>is_array<\/span><\/a>(<\/span>$sphinx_results<\/span>)<\/span> AND sizeof<\/span><\/a>(<\/span>$sphinx_results<\/span>)<\/span> AND isset<\/span><\/a>(<\/span>$sphinx_results<\/span>[<\/span>'total'<\/span>]<\/span>)<\/span> AND $sphinx_results<\/span>[<\/span>'total'<\/span>]<\/span> ><\/span> 0<\/span>)<\/span> {<\/span>
\n            $sql<\/span> =<\/span> 'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
\n                    pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,
\n                    MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, MAX(product_attribute_shop.`id_product_attribute`) id_product_attribute,
\n                    DATEDIFF(
\n                        p.`date_add`,
\n                        DATE_SUB(
\n                            NOW(),
\n                            INTERVAL '<\/span>.<\/span>(<\/span>Validate::<\/span>isUnsignedInt<\/span>(<\/span>Configuration::<\/span>get<\/span>(<\/span>'PS_NB_DAYS_NEW_PRODUCT'<\/span>)<\/span>)<\/span> ? Configuration::<\/span>get<\/span>(<\/span>'PS_NB_DAYS_NEW_PRODUCT'<\/span>)<\/span> :<\/span> 20<\/span>)<\/span>.<\/span>' DAY
\n                        )
\n                    ) > 0 new
\n                    FROM '<\/span>.<\/span>_DB_PREFIX_.<\/span>'product p
\n                    '<\/span>.<\/span>Shop::<\/span>addSqlAssociation<\/span>(<\/span>'product'<\/span>,<\/span> 'p'<\/span>)<\/span>.<\/span>'
\n                    INNER JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'product_lang` pl ON (
\n                        p.`id_product` = pl.`id_product`
\n                        AND pl.`id_lang` = '<\/span>.<\/span>(<\/span>int)<\/span>$id_lang<\/span>.<\/span>Shop::<\/span>addSqlRestrictionOnLang<\/span>(<\/span>'pl'<\/span>)<\/span>.<\/span>'
\n                    )
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'product_attribute` pa ON (p.`id_product` = pa.`id_product`)
\n                    '<\/span>.<\/span>Shop::<\/span>addSqlAssociation<\/span>(<\/span>'product_attribute'<\/span>,<\/span> 'pa'<\/span>,<\/span> false<\/span>,<\/span> 'product_attribute_shop.`default_on` = 1'<\/span>)<\/span>.<\/span>'
\n                    '<\/span>.<\/span>Product::<\/span>sqlStock<\/span>(<\/span>'p'<\/span>,<\/span> 'product_attribute_shop'<\/span>,<\/span> false<\/span>,<\/span> $context<\/span>-><\/span>shop<\/span>)<\/span>.<\/span>'
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'image` i ON (i.`id_product` = p.`id_product`)'<\/span>.<\/span>
\n                Shop::<\/span>addSqlAssociation<\/span>(<\/span>'image'<\/span>,<\/span> 'i'<\/span>,<\/span> false<\/span>,<\/span> 'image_shop.cover=1'<\/span>)<\/span>.<\/span>'
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '<\/span>.<\/span>(<\/span>int)<\/span>$id_lang<\/span>.<\/span>')
\n                    WHERE p.`id_product` IN('<\/span>.<\/span>implode<\/span><\/a>(<\/span>','<\/span>,<\/span> $sphinx_results<\/span>[<\/span>'results'<\/span>]<\/span>)<\/span>.<\/span>')
\n                    GROUP BY product_shop.id_product'<\/span>;<\/span>
\n            $result<\/span> =<\/span> $db<\/span>-><\/span>executeS<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span>
\n
\n            \/\/ results count<\/span>
\n            $total<\/span> =<\/span> $sphinx_results<\/span>[<\/span>'total'<\/span>]<\/span>;<\/span>
\n        }<\/span>
\n
\n        if<\/span> (<\/span>!<\/span>$result<\/span>)<\/span> {<\/span>
\n            $result_properties<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span>
\n        }<\/span> else<\/span> {<\/span>
\n            $result_properties<\/span> =<\/span> Product::<\/span>getProductsProperties<\/span>(<\/span>(<\/span>int)<\/span>$id_lang<\/span>,<\/span> $result<\/span>)<\/span>;<\/span>
\n        }<\/span>
\n
\n        return<\/span> array<\/span><\/a>(<\/span>'total'<\/span> =><\/span> $total<\/span>,<\/span> 'result'<\/span> =><\/span> $result_properties<\/span>)<\/span>;<\/span>
\n    }<\/span>
\n
\n    protected<\/span> static function<\/span> getSphinxResults(<\/span>$search_query<\/span>,<\/span> $page_number<\/span>,<\/span> $page_size<\/span>)<\/span>
\n    {<\/span>
\n        $results<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span>
\n        $total<\/span> =<\/span> 0<\/span>;<\/span>
\n
\n        if<\/span>(<\/span>!<\/span>$search_query<\/span>)<\/span>
\n            return<\/span> null<\/span>;<\/span>
\n
\n        \/\/ connect to Sphinx database<\/span>
\n        $link<\/span> =<\/span> mysqli_connect<\/span><\/a>(<\/span>'127.0.0.1'<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> '9306'<\/span>)<\/span>;<\/span>
\n        if<\/span>(<\/span>$link<\/span>)<\/span>
\n        {<\/span>
\n            $query<\/span> =<\/span> 'SELECT * FROM `PrestaSite` WHERE MATCH('<\/span>'.pSQL($search_query).'<\/span>') limit '<\/span>.<\/span>(<\/span>int)<\/span>$page_number<\/span>.<\/span>', '<\/span>.<\/span>(<\/span>int)<\/span>$page_size<\/span>.<\/span>';'<\/span>;<\/span>
\n            if<\/span> (<\/span>$result<\/span> =<\/span> $link<\/span>-><\/span>query<\/span>(<\/span>$query<\/span>)<\/span>)<\/span>
\n            {<\/span>
\n                while<\/span>(<\/span>$query_results<\/span> =<\/span> $result<\/span>-><\/span>fetch_array<\/span>(<\/span>)<\/span>)<\/span>
\n                {<\/span>
\n                    $results<\/span> =<\/span> array_merge<\/span><\/a>(<\/span>$results<\/span>,<\/span> $query_results<\/span>)<\/span>;<\/span>
\n                }<\/span>
\n
\n                \/* clear result *\/<\/span>
\n                $result<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n            }<\/span>
\n
\n            \/\/ get count of results<\/span>
\n            $query_total<\/span> =<\/span> 'SELECT count(*) FROM `PrestaSite` WHERE MATCH('<\/span>'.pSQL($search_query).'<\/span>');'<\/span>;<\/span>
\n            if<\/span> (<\/span>$result<\/span> =<\/span> $link<\/span>-><\/span>query<\/span>(<\/span>$query_total<\/span>)<\/span>)<\/span>
\n            {<\/span>
\n                $total<\/span> =<\/span> (<\/span>int)<\/span>$result<\/span>-><\/span>fetch_array<\/span>(<\/span>)<\/span>[<\/span>0<\/span>]<\/span>;<\/span>
\n                if<\/span>(<\/span>$total<\/span> ><\/span> 1000<\/span>)<\/span>
\n                    $total<\/span> =<\/span> 1000<\/span>;<\/span>
\n            }<\/span>
\n
\n            mysqli_close<\/span><\/a>(<\/span>$link<\/span>)<\/span>;<\/span>
\n        }<\/span>
\n
\n        return<\/span> array<\/span><\/a>(<\/span>'results'<\/span> =><\/span> $results<\/span>,<\/span> 'total'<\/span> =><\/span> $total<\/span>)<\/span>;<\/span>
\n    }<\/span>
\n}<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Zasadniczo kod jest do\u015b\u0107 prosty. Nadpisujemy funkcj\u0119 “find”, w kt\u00f3rej zast\u0119pujemy wyszukiwanie PrestaShop wyszukiwaniem Sphinx. Sphinx zwraca identyfikatory produkt\u00f3w, a za pomoc\u0105 tych identyfikator\u00f3w pobieramy dane produkt\u00f3w. Druga funkcja (getSphinxResults) bezpo\u015brednio wykonuje wyszukiwanie.<\/p>\n

Na koniec musisz wyczy\u015bci\u0107 pami\u0119\u0107 podr\u0119czn\u0105 i usun\u0105\u0107 pami\u0119\u0107 podr\u0119czn\u0105 klas (\/cache\/class_index.php). Gotowe!<\/p>\n","protected":false},"excerpt":{"rendered":"

PrestaShop posiada ca\u0142kiem dobre narz\u0119dzie wyszukiwania, ale czasami nie spe\u0142nia ono wszystkich Twoich potrzeb. Nie jest te\u017c zbyt szybkie, a w du\u017cych sklepach wyszukiwanie i indeksacja mog\u0105 by\u0107 bardzo powolne. Je\u015bli potrzebujesz czego\u015b lepszego, mo\u017cesz u\u017cy\u0107 \u015bwietnego zamiennika – Sphinx.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[149],"tags":[],"class_list":["post-1061","post","type-post","status-publish","format-standard","hentry","category-rozwoj"],"_links":{"self":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1061","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/comments?post=1061"}],"version-history":[{"count":0,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1061\/revisions"}],"wp:attachment":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media?parent=1061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/categories?post=1061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/tags?post=1061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}