^ DbQuery {#494
  #query: array:9 [
    "type" => "SELECT"
    "select" => array:2 [
      0 => "sa.quantity AS qty"
      1 => """
        \n
                            sa.id_product_attribute AS id_comb,\n
                            pac.id_attribute AS id_att,\n
                            sa.id_product,\n
                            a.id_attribute_group AS id_group\n
                        
        """
    ]
    "from" => array:1 [
      0 => "`ps_stock_available` sa"
    ]
    "join" => array:4 [
      0 => """
        INNER JOIN `ps_product_shop` `ps` ON ps.id_product = sa.id_product\n
                            AND ps.active = 1 AND ps.visibility <> 'none' AND ps.id_shop = 1
        """
      1 => """
        LEFT JOIN `ps_product_attribute_shop` `pas` ON pas.id_product_attribute = sa.id_product_attribute\n
                            AND pas.id_shop = ps.id_shop
        """
      2 => "LEFT JOIN `ps_product_attribute_combination` `pac` ON pac.id_product_attribute = pas.id_product_attribute"
      3 => "LEFT JOIN `ps_attribute` `a` ON a.id_attribute = pac.id_attribute"
    ]
    "where" => array:1 [
      0 => "sa.id_shop = 1 AND (sa.quantity > 0)"
    ]
    "group" => []
    "having" => []
    "order" => array:2 [
      0 => "sa.quantity > 0 DESC"
      1 => "pas.default_on DESC, pas.price, pac.id_attribute, pac.id_product_attribute"
    ]
    "limit" => array:2 [
      "offset" => 0
      "limit" => 0
    ]
  ]
}