object(Doctrine\Common\Collections\ArrayCollection)#1070 (1) {
  ["elements":"Doctrine\Common\Collections\ArrayCollection":private]=>
  array(8) {
    ["pa_product_attribute"]=>
    array(1) {
      ["pa"]=>
      array(3) {
        ["tableName"]=>
        string(17) "product_attribute"
        ["joinCondition"]=>
        string(30) "(p.id_product = pa.id_product)"
        ["joinType"]=>
        string(9) "LEFT JOIN"
      }
    }
    ["pac_product_attribute_combination"]=>
    array(1) {
      ["pac"]=>
      array(3) {
        ["tableName"]=>
        string(29) "product_attribute_combination"
        ["joinCondition"]=>
        string(52) "(pa.id_product_attribute = pac.id_product_attribute)"
        ["joinType"]=>
        string(9) "LEFT JOIN"
      }
    }
    ["sa_stock_available"]=>
    array(1) {
      ["sa"]=>
      array(3) {
        ["tableName"]=>
        string(15) "stock_available"
        ["joinCondition"]=>
        string(142) "(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"]=>
        string(9) "LEFT JOIN"
      }
    }
    ["psales_product_sale"]=>
    array(1) {
      ["psales"]=>
      array(3) {
        ["tableName"]=>
        string(12) "product_sale"
        ["joinCondition"]=>
        string(34) "(psales.id_product = p.id_product)"
        ["joinType"]=>
        string(9) "LEFT JOIN"
      }
    }
    ["ps_product_shop"]=>
    array(1) {
      ["ps"]=>
      array(3) {
        ["tableName"]=>
        string(12) "product_shop"
        ["joinCondition"]=>
        string(70) "(p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE)"
        ["joinType"]=>
        string(10) "INNER JOIN"
      }
    }
    ["cp_category_product"]=>
    array(1) {
      ["cp"]=>
      array(3) {
        ["tableName"]=>
        string(16) "category_product"
        ["joinCondition"]=>
        string(30) "(p.id_product = cp.id_product)"
        ["joinType"]=>
        string(10) "INNER JOIN"
      }
    }
    ["c_category"]=>
    array(1) {
      ["c"]=>
      array(3) {
        ["tableName"]=>
        string(8) "category"
        ["joinCondition"]=>
        string(47) "(cp.id_category = c.id_category AND c.active=1)"
        ["joinType"]=>
        string(10) "INNER JOIN"
      }
    }
    ["cg_category_group"]=>
    array(1) {
      ["cg"]=>
      array(3) {
        ["tableName"]=>
        string(14) "category_group"
        ["joinCondition"]=>
        string(32) "(cg.id_category = c.id_category)"
        ["joinType"]=>
        string(9) "LEFT JOIN"
      }
    }
  }
}
array(6) {
  [0]=>
  string(14) "ps.id_shop='1'"
  [1]=>
  string(35) "p.visibility IN ('both', 'catalog')"
  [2]=>
  string(15) "cg.id_group='1'"
  [3]=>
  string(30) "p.id_manufacturer IN (68, 257)"
  [4]=>
  string(13) "c.nleft>=1141"
  [5]=>
  string(14) "c.nright<=1142"
}
array(1) {
  [0]=>
  string(12) "p.id_product"
}