Carrello
Non ci sono più articoli nel tuo carrello
Strutture
Categorie
Anno
13 articoli
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:31' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:31' <= 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 ( ) 1caller:
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:31' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:31' <= 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 (975, 973, 967))) [1] => ps.id_shop='1' [2] => ps.visibility IN ('both', 'catalog') [3] => cg.id_group='1' [4] => cp.id_category IN (58, 74, 75, 76) ) 1caller:
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:31' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:31' <= 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 (975, 973, 967))) [1] => cg.id_group='1' [2] => c.level_depth<=4 [3] => c.nleft>126 [4] => c.nright<141 ) 1caller:
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:31' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:31' <= 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 (975, 973, 967))) [1] => ps.id_shop='1' [2] => ps.visibility IN ('both', 'catalog') [3] => cg.id_group='1' ) 1caller:
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:31' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:31' <= 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)) ) 1caller:
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:31' >= sp.from) AND (sp.to = '0000-00-00 00:00:00' OR '2025-05-16 19:17:31' <= 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 (58, 74, 75, 76) ) 1