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 (975, 966, 972, 971, 970, 969, 967, 965)))
)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => cp.id_category IN (58, 74, 75)
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => cp.id_category IN (58, 74, 75)
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
    [1] => cg.id_group='1'
    [2] => c.level_depth<=4
    [3] => c.nleft>126
    [4] => c.nright<141
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
    [1] => cg.id_group='1'
    [2] => c.level_depth<=4
    [3] => c.nleft>126
    [4] => c.nright<141
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 972, 971, 970, 969, 967, 965)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
)
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] => cp.id_category IN (58, 74, 75)
)
1
where 3
Array
(
    [0] => ps.id_shop='1'
    [1] => ps.visibility IN ('both', 'catalog')
    [2] => cg.id_group='1'
    [3] => cp.id_category IN (58, 74, 75)
)
1
Strutture
Mostra più prodotti
Prodotto aggiunto ai preferiti