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, 973, 970, 969, 968, 967, 965)))
)
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
                                )

                        )

                )

            [id_category] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 60
                                    [1] => 74
                                    [2] => 76
                                    [3] => 64
                                )

                        )

                )

        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 973, 970, 969, 968, 967, 965)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => cp.id_category IN (60, 74, 76, 64)
)
1
where 3
Array
(
    [0] => ((fp.id_feature_value IN (975, 973, 970, 969, 968, 967, 965)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => cp.id_category IN (60, 74, 76, 64)
)
1
where 1
Array
(
    [0] => ((fp.id_feature_value IN (975, 973, 970, 969, 968, 967, 965)))
)
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] => 4
                                )

                        )

                )

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

                        )

                )

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

                        )

                )

        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 973, 970, 969, 968, 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, 973, 970, 969, 968, 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, 973, 970, 969, 968, 967, 965)))
)
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
                                )

                        )

                )

        )

)
1
where 2
Array
(
    [0] => ((fp.id_feature_value IN (975, 973, 970, 969, 968, 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, 973, 970, 969, 968, 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
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
                                )

                        )

                )

            [id_category] => Array
                (
                    [=] => Array
                        (
                            [0] => Array
                                (
                                    [0] => 60
                                    [1] => 74
                                    [2] => 76
                                    [3] => 64
                                )

                        )

                )

        )

)
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 (60, 74, 76, 64)
)
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 (60, 74, 76, 64)
)
1
Strutture
Mostra più prodotti
Prodotto aggiunto ai preferiti