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
caller:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 101
            [function] => computeWhereConditions
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [id_product_attribute] => Array
                                (
                                    [tableName] => product_attribute
                                    [tableAlias] => pa
                                    [joinCondition] => (p.id_product = pa.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_attribute] => Array
                                (
                                    [tableName] => product_attribute_combination
                                    [tableAlias] => pac
                                    [joinCondition] => (pa.id_product_attribute = pac.id_product_attribute)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_product_attribute
                                )

                            [id_attribute_group] => Array
                                (
                                    [tableName] => attribute
                                    [tableAlias] => a
                                    [joinCondition] => (a.id_attribute = pac.id_attribute)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_attribute
                                )

                            [id_feature] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [id_shop] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [visibility] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [id_feature_value] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_category] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [position] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [manufacturer_name] => Array
                                (
                                    [tableName] => manufacturer
                                    [tableAlias] => m
                                    [fieldName] => name
                                    [joinCondition] => (p.id_manufacturer = m.id_manufacturer)
                                    [joinType] => LEFT JOIN
                                )

                            [name] => Array
                                (
                                    [tableName] => product_lang
                                    [tableAlias] => pl
                                    [joinCondition] => (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1)
                                    [joinType] => INNER JOIN
                                )

                            [nleft] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [nright] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [level_depth] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [out_of_stock] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                )

                            [quantity] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                    [aggregateFunction] => SUM
                                    [aggregateFieldName] => quantity
                                )

                            [price_min] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [price_max] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_start] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_end] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [id_group] => Array
                                (
                                    [tableName] => category_group
                                    [tableAlias] => cg
                                    [joinCondition] => (cg.id_category = c.id_category)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => nleft
                                )

                            [sales] => Array
                                (
                                    [tableName] => product_sale
                                    [tableAlias] => psales
                                    [fieldName] => quantity
                                    [fieldAlias] => sales
                                    [joinCondition] => (psales.id_product = p.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [reduction] => Array
                                (
                                    [tableName] => specific_price
                                    [tableAlias] => sp
                                    [joinCondition] => (
                    sp.id_product = p.id_product AND 
                    sp.id_shop IN (0, 1) AND 
                    sp.id_currency IN (0, 1) AND 
                    sp.id_country IN (0, 10) AND 
                    sp.id_group IN (0, 1) AND 
                    sp.from_quantity = 1 AND
                    sp.reduction > 0 AND
                    sp.id_customer = 0 AND
                    sp.id_cart = 0 AND 
                    (sp.from = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' >= sp.from) AND 
                    (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' <= sp.to) 
                )
                                    [joinType] => LEFT JOIN
                                )

                        )

                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 85
            [function] => getQuery
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                )

        )

)
1
Array
(
)
1
caller:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 101
            [function] => computeWhereConditions
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [id_product_attribute] => Array
                                (
                                    [tableName] => product_attribute
                                    [tableAlias] => pa
                                    [joinCondition] => (p.id_product = pa.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_attribute] => Array
                                (
                                    [tableName] => product_attribute_combination
                                    [tableAlias] => pac
                                    [joinCondition] => (pa.id_product_attribute = pac.id_product_attribute)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_product_attribute
                                )

                            [id_attribute_group] => Array
                                (
                                    [tableName] => attribute
                                    [tableAlias] => a
                                    [joinCondition] => (a.id_attribute = pac.id_attribute)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_attribute
                                )

                            [id_feature] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [id_shop] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [visibility] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [id_feature_value] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_category] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [position] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [manufacturer_name] => Array
                                (
                                    [tableName] => manufacturer
                                    [tableAlias] => m
                                    [fieldName] => name
                                    [joinCondition] => (p.id_manufacturer = m.id_manufacturer)
                                    [joinType] => LEFT JOIN
                                )

                            [name] => Array
                                (
                                    [tableName] => product_lang
                                    [tableAlias] => pl
                                    [joinCondition] => (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1)
                                    [joinType] => INNER JOIN
                                )

                            [nleft] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [nright] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [level_depth] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [out_of_stock] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                )

                            [quantity] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                    [aggregateFunction] => SUM
                                    [aggregateFieldName] => quantity
                                )

                            [price_min] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [price_max] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_start] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_end] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [id_group] => Array
                                (
                                    [tableName] => category_group
                                    [tableAlias] => cg
                                    [joinCondition] => (cg.id_category = c.id_category)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => nleft
                                )

                            [sales] => Array
                                (
                                    [tableName] => product_sale
                                    [tableAlias] => psales
                                    [fieldName] => quantity
                                    [fieldAlias] => sales
                                    [joinCondition] => (psales.id_product = p.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [reduction] => Array
                                (
                                    [tableName] => specific_price
                                    [tableAlias] => sp
                                    [joinCondition] => (
                    sp.id_product = p.id_product AND 
                    sp.id_shop IN (0, 1) AND 
                    sp.id_currency IN (0, 1) AND 
                    sp.id_country IN (0, 10) AND 
                    sp.id_group IN (0, 1) AND 
                    sp.from_quantity = 1 AND
                    sp.reduction > 0 AND
                    sp.id_customer = 0 AND
                    sp.id_cart = 0 AND 
                    (sp.from = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' >= sp.from) AND 
                    (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' <= sp.to) 
                )
                                    [joinType] => LEFT JOIN
                                )

                        )

                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 111
            [function] => getQuery
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                )

        )

)
1
Array
(
    [0] => ((fp.id_feature_value IN (981, 978, 976, 971, 970, 968, 964)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => c.nleft>=3
    [5] => c.nright<=150
)
1
caller:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 101
            [function] => computeWhereConditions
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [id_product_attribute] => Array
                                (
                                    [tableName] => product_attribute
                                    [tableAlias] => pa
                                    [joinCondition] => (p.id_product = pa.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_attribute] => Array
                                (
                                    [tableName] => product_attribute_combination
                                    [tableAlias] => pac
                                    [joinCondition] => (pa.id_product_attribute = pac.id_product_attribute)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_product_attribute
                                )

                            [id_attribute_group] => Array
                                (
                                    [tableName] => attribute
                                    [tableAlias] => a
                                    [joinCondition] => (a.id_attribute = pac.id_attribute)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_attribute
                                )

                            [id_feature] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [id_shop] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [visibility] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [id_feature_value] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_category] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [position] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [manufacturer_name] => Array
                                (
                                    [tableName] => manufacturer
                                    [tableAlias] => m
                                    [fieldName] => name
                                    [joinCondition] => (p.id_manufacturer = m.id_manufacturer)
                                    [joinType] => LEFT JOIN
                                )

                            [name] => Array
                                (
                                    [tableName] => product_lang
                                    [tableAlias] => pl
                                    [joinCondition] => (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1)
                                    [joinType] => INNER JOIN
                                )

                            [nleft] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [nright] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [level_depth] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [out_of_stock] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                )

                            [quantity] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                    [aggregateFunction] => SUM
                                    [aggregateFieldName] => quantity
                                )

                            [price_min] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [price_max] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_start] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_end] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [id_group] => Array
                                (
                                    [tableName] => category_group
                                    [tableAlias] => cg
                                    [joinCondition] => (cg.id_category = c.id_category)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => nleft
                                )

                            [sales] => Array
                                (
                                    [tableName] => product_sale
                                    [tableAlias] => psales
                                    [fieldName] => quantity
                                    [fieldAlias] => sales
                                    [joinCondition] => (psales.id_product = p.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [reduction] => Array
                                (
                                    [tableName] => specific_price
                                    [tableAlias] => sp
                                    [joinCondition] => (
                    sp.id_product = p.id_product AND 
                    sp.id_shop IN (0, 1) AND 
                    sp.id_currency IN (0, 1) AND 
                    sp.id_country IN (0, 10) AND 
                    sp.id_group IN (0, 1) AND 
                    sp.from_quantity = 1 AND
                    sp.reduction > 0 AND
                    sp.id_customer = 0 AND
                    sp.id_cart = 0 AND 
                    (sp.from = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' >= sp.from) AND 
                    (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' <= sp.to) 
                )
                                    [joinType] => LEFT JOIN
                                )

                        )

                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 85
            [function] => getQuery
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                )

        )

)
1
Array
(
    [0] => ((fp.id_feature_value IN (981, 978, 976, 971, 970, 968, 964)))
    [1] => cg.id_group='1'
    [2] => c.level_depth<=3
    [3] => c.nleft>3
    [4] => c.nright<150
)
1
caller:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 101
            [function] => computeWhereConditions
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [id_product_attribute] => Array
                                (
                                    [tableName] => product_attribute
                                    [tableAlias] => pa
                                    [joinCondition] => (p.id_product = pa.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_attribute] => Array
                                (
                                    [tableName] => product_attribute_combination
                                    [tableAlias] => pac
                                    [joinCondition] => (pa.id_product_attribute = pac.id_product_attribute)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_product_attribute
                                )

                            [id_attribute_group] => Array
                                (
                                    [tableName] => attribute
                                    [tableAlias] => a
                                    [joinCondition] => (a.id_attribute = pac.id_attribute)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_attribute
                                )

                            [id_feature] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [id_shop] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [visibility] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [id_feature_value] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_category] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [position] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [manufacturer_name] => Array
                                (
                                    [tableName] => manufacturer
                                    [tableAlias] => m
                                    [fieldName] => name
                                    [joinCondition] => (p.id_manufacturer = m.id_manufacturer)
                                    [joinType] => LEFT JOIN
                                )

                            [name] => Array
                                (
                                    [tableName] => product_lang
                                    [tableAlias] => pl
                                    [joinCondition] => (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1)
                                    [joinType] => INNER JOIN
                                )

                            [nleft] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [nright] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [level_depth] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [out_of_stock] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                )

                            [quantity] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                    [aggregateFunction] => SUM
                                    [aggregateFieldName] => quantity
                                )

                            [price_min] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [price_max] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_start] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_end] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [id_group] => Array
                                (
                                    [tableName] => category_group
                                    [tableAlias] => cg
                                    [joinCondition] => (cg.id_category = c.id_category)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => nleft
                                )

                            [sales] => Array
                                (
                                    [tableName] => product_sale
                                    [tableAlias] => psales
                                    [fieldName] => quantity
                                    [fieldAlias] => sales
                                    [joinCondition] => (psales.id_product = p.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [reduction] => Array
                                (
                                    [tableName] => specific_price
                                    [tableAlias] => sp
                                    [joinCondition] => (
                    sp.id_product = p.id_product AND 
                    sp.id_shop IN (0, 1) AND 
                    sp.id_currency IN (0, 1) AND 
                    sp.id_country IN (0, 10) AND 
                    sp.id_group IN (0, 1) AND 
                    sp.from_quantity = 1 AND
                    sp.reduction > 0 AND
                    sp.id_customer = 0 AND
                    sp.id_cart = 0 AND 
                    (sp.from = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' >= sp.from) AND 
                    (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' <= sp.to) 
                )
                                    [joinType] => LEFT JOIN
                                )

                        )

                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 111
            [function] => getQuery
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                )

        )

)
1
Array
(
    [0] => ((fp.id_feature_value IN (981, 978, 976, 971, 970, 968, 964)))
    [1] => ps.id_shop='1'
    [2] => ps.visibility IN ('both', 'catalog')
    [3] => cg.id_group='1'
    [4] => c.nleft>=3
    [5] => c.nright<=150
)
1
caller:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 101
            [function] => computeWhereConditions
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [id_product_attribute] => Array
                                (
                                    [tableName] => product_attribute
                                    [tableAlias] => pa
                                    [joinCondition] => (p.id_product = pa.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_attribute] => Array
                                (
                                    [tableName] => product_attribute_combination
                                    [tableAlias] => pac
                                    [joinCondition] => (pa.id_product_attribute = pac.id_product_attribute)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_product_attribute
                                )

                            [id_attribute_group] => Array
                                (
                                    [tableName] => attribute
                                    [tableAlias] => a
                                    [joinCondition] => (a.id_attribute = pac.id_attribute)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_attribute
                                )

                            [id_feature] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [id_shop] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [visibility] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [id_feature_value] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_category] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [position] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [manufacturer_name] => Array
                                (
                                    [tableName] => manufacturer
                                    [tableAlias] => m
                                    [fieldName] => name
                                    [joinCondition] => (p.id_manufacturer = m.id_manufacturer)
                                    [joinType] => LEFT JOIN
                                )

                            [name] => Array
                                (
                                    [tableName] => product_lang
                                    [tableAlias] => pl
                                    [joinCondition] => (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1)
                                    [joinType] => INNER JOIN
                                )

                            [nleft] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [nright] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [level_depth] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [out_of_stock] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                )

                            [quantity] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                    [aggregateFunction] => SUM
                                    [aggregateFieldName] => quantity
                                )

                            [price_min] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [price_max] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_start] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_end] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [id_group] => Array
                                (
                                    [tableName] => category_group
                                    [tableAlias] => cg
                                    [joinCondition] => (cg.id_category = c.id_category)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => nleft
                                )

                            [sales] => Array
                                (
                                    [tableName] => product_sale
                                    [tableAlias] => psales
                                    [fieldName] => quantity
                                    [fieldAlias] => sales
                                    [joinCondition] => (psales.id_product = p.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [reduction] => Array
                                (
                                    [tableName] => specific_price
                                    [tableAlias] => sp
                                    [joinCondition] => (
                    sp.id_product = p.id_product AND 
                    sp.id_shop IN (0, 1) AND 
                    sp.id_currency IN (0, 1) AND 
                    sp.id_country IN (0, 10) AND 
                    sp.id_group IN (0, 1) AND 
                    sp.from_quantity = 1 AND
                    sp.reduction > 0 AND
                    sp.id_customer = 0 AND
                    sp.id_cart = 0 AND 
                    (sp.from = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' >= sp.from) AND 
                    (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' <= sp.to) 
                )
                                    [joinType] => LEFT JOIN
                                )

                        )

                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 85
            [function] => getQuery
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                )

        )

)
1
Array
(
    [0] => ((fp.id_feature=7))
)
1
caller:
Array
(
    [0] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 101
            [function] => computeWhereConditions
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                    [0] => Array
                        (
                            [id_product_attribute] => Array
                                (
                                    [tableName] => product_attribute
                                    [tableAlias] => pa
                                    [joinCondition] => (p.id_product = pa.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_attribute] => Array
                                (
                                    [tableName] => product_attribute_combination
                                    [tableAlias] => pac
                                    [joinCondition] => (pa.id_product_attribute = pac.id_product_attribute)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_product_attribute
                                )

                            [id_attribute_group] => Array
                                (
                                    [tableName] => attribute
                                    [tableAlias] => a
                                    [joinCondition] => (a.id_attribute = pac.id_attribute)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_attribute
                                )

                            [id_feature] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [id_shop] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [visibility] => Array
                                (
                                    [tableName] => product_shop
                                    [tableAlias] => ps
                                    [joinCondition] => (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)
                                    [joinType] => INNER JOIN
                                )

                            [id_feature_value] => Array
                                (
                                    [tableName] => feature_product
                                    [tableAlias] => fp
                                    [joinCondition] => (p.id_product = fp.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [id_category] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [position] => Array
                                (
                                    [tableName] => category_product
                                    [tableAlias] => cp
                                    [joinCondition] => (p.id_product = cp.id_product)
                                    [joinType] => INNER JOIN
                                )

                            [manufacturer_name] => Array
                                (
                                    [tableName] => manufacturer
                                    [tableAlias] => m
                                    [fieldName] => name
                                    [joinCondition] => (p.id_manufacturer = m.id_manufacturer)
                                    [joinType] => LEFT JOIN
                                )

                            [name] => Array
                                (
                                    [tableName] => product_lang
                                    [tableAlias] => pl
                                    [joinCondition] => (p.id_product = pl.id_product AND pl.id_shop = 1 AND pl.id_lang = 1)
                                    [joinType] => INNER JOIN
                                )

                            [nleft] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [nright] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [level_depth] => Array
                                (
                                    [tableName] => category
                                    [tableAlias] => c
                                    [joinCondition] => (cp.id_category = c.id_category AND c.active=1)
                                    [joinType] => INNER JOIN
                                    [dependencyField] => id_category
                                )

                            [out_of_stock] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                )

                            [quantity] => Array
                                (
                                    [tableName] => stock_available
                                    [tableAlias] => sa
                                    [joinCondition] => (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 )
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => id_attribute
                                    [aggregateFunction] => SUM
                                    [aggregateFieldName] => quantity
                                )

                            [price_min] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [price_max] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_start] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [range_end] => Array
                                (
                                    [tableName] => layered_price_index
                                    [tableAlias] => psi
                                    [joinCondition] => (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 10)
                                    [joinType] => INNER JOIN
                                )

                            [id_group] => Array
                                (
                                    [tableName] => category_group
                                    [tableAlias] => cg
                                    [joinCondition] => (cg.id_category = c.id_category)
                                    [joinType] => LEFT JOIN
                                    [dependencyField] => nleft
                                )

                            [sales] => Array
                                (
                                    [tableName] => product_sale
                                    [tableAlias] => psales
                                    [fieldName] => quantity
                                    [fieldAlias] => sales
                                    [joinCondition] => (psales.id_product = p.id_product)
                                    [joinType] => LEFT JOIN
                                )

                            [reduction] => Array
                                (
                                    [tableName] => specific_price
                                    [tableAlias] => sp
                                    [joinCondition] => (
                    sp.id_product = p.id_product AND 
                    sp.id_shop IN (0, 1) AND 
                    sp.id_currency IN (0, 1) AND 
                    sp.id_country IN (0, 10) AND 
                    sp.id_group IN (0, 1) AND 
                    sp.from_quantity = 1 AND
                    sp.reduction > 0 AND
                    sp.id_customer = 0 AND
                    sp.id_cart = 0 AND 
                    (sp.from = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' >= sp.from) AND 
                    (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:38' <= sp.to) 
                )
                                    [joinType] => LEFT JOIN
                                )

                        )

                )

        )

    [1] => Array
        (
            [file] => /var/www/vhosts/dev2024.grafill.it/httpdocs/modules/ps_facetedsearch/src/Adapter/MySQL.php
            [line] => 111
            [function] => getQuery
            [class] => PrestaShop\Module\FacetedSearch\Adapter\MySQL
            [type] => ->
            [args] => Array
                (
                )

        )

)
1
Array
(
    [0] => ps.id_shop='1'
    [1] => ps.visibility IN ('both', 'catalog')
    [2] => cg.id_group='1'
    [3] => c.nleft>=3
    [4] => c.nright<=150
)
1
Catalogo prodotti (6)
Prodotto aggiunto ai preferiti