^ DbQuery {#673
#query: array:9 [
"type" => "SELECT"
"select" => array:1 [
0 => "ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`, pal.`available_now`, pal.`available_later`"
]
"from" => array:1 [
0 => "`ps_product_attribute` pa"
]
"join" => array:9 [
0 => """
INNER JOIN ps_product_attribute_shop product_attribute_shop\n
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
"""
1 => """
LEFT JOIN ps_stock_available stock\n
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
"""
2 => "LEFT JOIN `ps_product_attribute_lang` `pal` ON pa.id_product_attribute = pal.id_product_attribute AND pal.id_lang = 1"
3 => "LEFT JOIN `ps_product_attribute_combination` `pac` ON pac.id_product_attribute = pa.id_product_attribute"
4 => "LEFT JOIN `ps_attribute` `a` ON a.id_attribute = pac.id_attribute"
5 => "LEFT JOIN `ps_attribute_group` `ag` ON ag.id_attribute_group = a.id_attribute_group"
6 => "LEFT JOIN `ps_attribute_lang` `al` ON a.id_attribute = al.id_attribute"
7 => "LEFT JOIN `ps_attribute_group_lang` `agl` ON ag.id_attribute_group = agl.id_attribute_group"
8 => """
INNER JOIN ps_attribute_shop attribute_shop\n
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
"""
]
"where" => array:4 [
0 => "pa.id_product = 4804"
1 => "al.id_lang = 1"
2 => "agl.id_lang = 1"
3 => "product_attribute_shop.id_product_attribute = 2113"
]
"group" => []
"having" => []
"order" => array:1 [
0 => "ag.position ASC, a.position ASC, agl.name ASC"
]
"limit" => array:2 [
"offset" => 0
"limit" => 0
]
]
}
END