provider: PrestaShop\Module\FacetedSearch\Product\SearchProviderArray
(
[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:16:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:16:18' <= 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:16:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:16:18' <= 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 (978, 977, 976, 966, 968)))
[1] => ps.id_shop='1'
[2] => ps.visibility IN ('both', 'catalog')
[3] => cg.id_group='1'
[4] => cp.id_category IN (22, 11, 19, 18)
)
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:16:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:16:18' <= 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 (978, 977, 976, 966, 968)))
[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:16:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:16:18' <= 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 (978, 977, 976, 966, 968)))
[1] => ps.id_shop='1'
[2] => ps.visibility IN ('both', 'catalog')
[3] => cg.id_group='1'
)
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:16:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:16:18' <= 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:16:18' >= sp.from) AND
(sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:16:18' <= 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] => cp.id_category IN (22, 11, 19, 18)
)
1
Catalogo prodotti
Visualizzati 1-16 su 35 articoli
35 articoli
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Libro
Ebook
Libro + ebook
Scopri la nostra vasta selezione di libri tecnici progettati specificamente per professionisti. Che tu sia un ingegnere, un architetto, un programmatore o un designer, la nostra categoria di libri offre risorse fondamentali per approfondire le tue competenze e rimanere aggiornato sulle ultime tendenze del settore. Ogni volume è curato nei dettagli, garantendo contenuti di alta qualità e pratiche applicazioni. Esplora le nostre più recenti pubblicazioni e trova gli strumenti perfetti per accrescere la tua carriera e i tuoi progetti. Approfitta delle nostre offerte speciali e acquista oggi stesso i tuoi libri tecnici!
Prodotto aggiunto ai preferiti
![[2022] Attestato di Classificazione Sismica. Class 2022](https://dev2024.grafill.it/1523-home_default/-2022-attestato-di-classificazione-sismica-class-2022.jpg)
![[ebook] Stima dei beni produttivi secondo gli standard IVS](https://dev2024.grafill.it/1551-home_default/-ebook-stima-dei-beni-produttivi-secondo-gli-standard-ivs.jpg)
![[ebook] Stima dei beni residenziali secondo gli standard IVS](https://dev2024.grafill.it/1533-home_default/-ebook-stima-dei-beni-residenziali-secondo-gli-standard-ivs.jpg)
![[ebook] Gestione completa del Condominio con il software iCube](https://dev2024.grafill.it/1531-home_default/-ebook-gestione-completa-del-condominio-con-il-software-icube.jpg)
![[2022] Sismabonus: dalla progettazione alla asseverazione degli interventi](https://dev2024.grafill.it/1515-home_default/-2022-sismabonus-dalla-progettazione-alla-asseverazione-degli-interventi.jpg)
![[2022] Calcoli pratici per il consolidamento delle strutture in muratura](https://dev2024.grafill.it/1493-home_default/-2022-calcoli-pratici-per-il-consolidamento-delle-strutture-in-muratura.jpg)
![[ebook] La verifica ed il collaudo delle strutture in muratura](https://dev2024.grafill.it/1499-home_default/-ebook-la-verifica-ed-il-collaudo-delle-strutture-in-muratura.jpg)
![[ebook] RTV Uffici. Regole tecniche verticali edifici adibiti ad uffici: Prevenzione Incendi](https://dev2024.grafill.it/1609-home_default/-ebook-rtv-uffici-regole-tecniche-verticali-edifici-adibiti-ad-uffici-prevenzione-incendi.jpg)
