^ Doctrine\Common\Collections\ArrayCollection {#3238 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3240 -elements: array:1 [ "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3214 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3223 -elements: array:4 [ "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3204 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3210 -elements: array:5 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "sa_1_stock_available" => array:1 [ "sa_1" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa_1.id_product AND IFNULL(pac.id_product_attribute, 0) = sa_1.id_product_attribute AND sa_1.id_shop_group = 1 AND sa_1.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3199 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3213 -elements: array:4 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3197 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3207 -elements: array:4 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3195 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3212 -elements: array:1 [ "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3201 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3215 -elements: array:1 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3202 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3209 -elements: array:2 [ "sp_specific_price" => array:1 [ "sp" => array:3 [ "tableName" => "specific_price" "joinCondition" => """ (\n sp.id_product = p.id_product AND \n sp.id_shop IN (0, 1) AND \n sp.id_currency IN (0, 1) AND \n sp.id_country IN (0, 86) AND \n sp.id_group IN (0, 1) AND \n sp.from_quantity = 1 AND\n sp.reduction > 0 AND\n sp.id_customer = 0 AND\n sp.id_cart = 0 AND \n (sp.from = '0000-00-00 00:00:00' OR '2025-07-27 11:30:23' >= sp.from) AND \n (sp.to = '0000-00-00 00:00:00' OR '2025-07-27 11:30:23' <= sp.to) \n ) """ "joinType" => "LEFT JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3208 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3219 -elements: array:1 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3221 -elements: array:5 [ "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3224 -elements: array:6 [ "psi_layered_price_index" => array:1 [ "psi" => array:3 [ "tableName" => "layered_price_index" "joinCondition" => "(psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 86)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3211 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3217 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3207 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3224 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3205 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3218 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3214 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3223 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3209 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3217 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3206 -elements: array:8 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3224 -elements: array:1 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3208 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3218 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3213 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3223 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3211 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3217 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3207 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3224 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3193 -elements: array:9 [ "pa_product_attribute" => array:1 [ "pa" => array:3 [ "tableName" => "product_attribute" "joinCondition" => "(p.id_product = pa.id_product)" "joinType" => "LEFT JOIN" ] ] "pac_product_attribute_combination" => array:1 [ "pac" => array:3 [ "tableName" => "product_attribute_combination" "joinCondition" => "(pa.id_product_attribute = pac.id_product_attribute)" "joinType" => "LEFT JOIN" ] ] "sa_stock_available" => array:1 [ "sa" => array:3 [ "tableName" => "stock_available" "joinCondition" => "(p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop_group = 1 AND sa.id_shop = 0 )" "joinType" => "LEFT JOIN" ] ] "psales_product_sale" => array:1 [ "psales" => array:3 [ "tableName" => "product_sale" "joinCondition" => "(psales.id_product = p.id_product)" "joinType" => "LEFT JOIN" ] ] "cp_category_product" => array:1 [ "cp" => array:3 [ "tableName" => "category_product" "joinCondition" => "(p.id_product = cp.id_product)" "joinType" => "INNER JOIN" ] ] "ps_product_shop" => array:1 [ "ps" => array:3 [ "tableName" => "product_shop" "joinCondition" => "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)" "joinType" => "INNER JOIN" ] ] "c_category" => array:1 [ "c" => array:3 [ "tableName" => "category" "joinCondition" => "(cp.id_category = c.id_category AND c.active=1)" "joinType" => "INNER JOIN" ] ] "cg_category_group" => array:1 [ "cg" => array:3 [ "tableName" => "category_group" "joinCondition" => "(cg.id_category = c.id_category)" "joinType" => "LEFT JOIN" ] ] "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
^ Doctrine\Common\Collections\ArrayCollection {#3218 -elements: array:2 [ "fp_feature_product" => array:1 [ "fp" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp.id_product)" "joinType" => "INNER JOIN" ] ] "fp_1_feature_product" => array:1 [ "fp_1" => array:3 [ "tableName" => "feature_product" "joinCondition" => "(p.id_product = fp_1.id_product)" "joinType" => "LEFT JOIN" ] ] ] }
Parimad jalgrattad, tõuksid ja muu kiire tarnega!
Parimad jalgrattad, tõuksid ja muu kiire tarnega!
2 products
