provider: PrestaShop\Module\FacetedSearch\Product\SearchProvider
query: PrestaShop\PrestaShop\Core\Product\Search\ProductSearchQuery
products: PrestaShop\Module\FacetedSearch\Filters\Products
adapter: PrestaShop\Module\FacetedSearch\Adapter\MySQL
where 1
Array
(
)
1
where 2
Array
(
)
1
where 3
Array
(
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => sp.reduction>0
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => sp.reduction>0
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
    [1] => cg.id_group='1'
    [2] => c.level_depth<=2
    [3] => c.nleft>2
    [4] => c.nright<169
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
    [1] => cg.id_group='1'
    [2] => c.level_depth<=2
    [3] => c.nleft>2
    [4] => c.nright<169
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => sp.reduction>0
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (978, 977, 976, 975, 974, 972, 971, 970, 969)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => sp.reduction>0
)
1
where 1
Array
(
    [0] => ((fp.id_feature=7))
)
1
where 2
Array
(
    [0] => ((fp.id_feature=7))
)
1
where 3
Array
(
    [0] => ((fp.id_feature=7))
)
1
where 1
Array
(
)
1
where 2
Array
(
    [0] => ps.id_shop='1'
    [1] => ps.visibility IN ('both', 'catalog')
    [2] => cg.id_group='1'
    [3] => sp.reduction>0
)
1
where 3
Array
(
    [0] => ps.id_shop='1'
    [1] => ps.visibility IN ('both', 'catalog')
    [2] => cg.id_group='1'
    [3] => sp.reduction>0
)
1
Offerte (10)

Offerte

Prodotto aggiunto ai preferiti