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
Doctrine\Common\Collections\ArrayCollection Object
(
    [elements:Doctrine\Common\Collections\ArrayCollection:private] => Array
        (
        )

)
1
where 2
Array
(
)
1
where 3
Array
(
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 973, 972, 971, 970, 969, 967)))
)
1
Doctrine\Common\Collections\ArrayCollection Object
(
    [elements:Doctrine\Common\Collections\ArrayCollection:private] => Array
        (
            [id_shop] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [visibility] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => both
                                    [1] => catalog
                                )

                        )

                )

            [id_group] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [reduction] => Array
                (
                    [>] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 0
                                )

                        )

                )

        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 973, 972, 971, 970, 969, 967)))
    [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 (975, 966, 973, 972, 971, 970, 969, 967)))
    [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 (975, 966, 973, 972, 971, 970, 969, 967)))
)
1
Doctrine\Common\Collections\ArrayCollection Object
(
    [elements:Doctrine\Common\Collections\ArrayCollection:private] => Array
        (
            [id_group] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [level_depth] => Array
                (
                    [<=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 2
                                )

                        )

                )

            [nleft] => Array
                (
                    [>] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 2
                                )

                        )

                )

            [nright] => Array
                (
                    [<] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 169
                                )

                        )

                )

        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 973, 972, 971, 970, 969, 967)))
    [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 (975, 966, 973, 972, 971, 970, 969, 967)))
    [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 (975, 966, 973, 972, 971, 970, 969, 967)))
)
1
Doctrine\Common\Collections\ArrayCollection Object
(
    [elements:Doctrine\Common\Collections\ArrayCollection:private] => Array
        (
            [id_shop] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [visibility] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => both
                                    [1] => catalog
                                )

                        )

                )

            [id_group] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [reduction] => Array
                (
                    [>] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 0
                                )

                        )

                )

        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 966, 973, 972, 971, 970, 969, 967)))
    [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 (975, 966, 973, 972, 971, 970, 969, 967)))
    [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
Doctrine\Common\Collections\ArrayCollection Object
(
    [elements:Doctrine\Common\Collections\ArrayCollection:private] => Array
        (
        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature=7))
)
1
where 3
Array
(
    [0] => ((fp.id_feature=7))
)
1
where 1
Array
(
)
1
Doctrine\Common\Collections\ArrayCollection Object
(
    [elements:Doctrine\Common\Collections\ArrayCollection:private] => Array
        (
            [id_shop] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [visibility] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => both
                                    [1] => catalog
                                )

                        )

                )

            [id_group] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 1
                                )

                        )

                )

            [reduction] => Array
                (
                    [>] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 0
                                )

                        )

                )

        )

)
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 (6)

Offerte

Mostra più prodotti
Prodotto aggiunto ai preferiti