[
"sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.slug AS slug_3, t0_.base_price AS base_price_4, t0_.compare_price AS compare_price_5, t0_.cost_price AS cost_price_6, t0_.is_available AS is_available_7, t0_.display_order AS display_order_8, t0_.preparation_time_minutes AS preparation_time_minutes_9, t0_.min_qty_per_order AS min_qty_per_order_10, t0_.max_qty_per_order AS max_qty_per_order_11, t0_.is_active AS is_active_12, t0_.product_image_name AS product_image_name_13, t0_.product_image_size AS product_image_size_14, t0_.product_image_mime_type AS product_image_mime_type_15, t0_.updated_at AS updated_at_16, t0_.imported_image_link AS imported_image_link_17, t0_.image_url800 AS image_url800_18, t0_.image_key AS image_key_19, t0_.image_cache_buster AS image_cache_buster_20, t1_.id AS id_21, t1_.code AS code_22, t1_.name AS name_23, t1_.display_name AS display_name_24, t1_.color AS color_25, t1_.icon AS icon_26, t1_.is_active AS is_active_27, t1_.display_order AS display_order_28, t2_.id AS id_29, t2_.code AS code_30, t2_.name AS name_31, t2_.description AS description_32, t2_.display_order AS display_order_33, t2_.is_active AS is_active_34, t2_.filter_operation AS filter_operation_35, t2_.icon AS icon_36, t2_.color AS color_37, t3_.id AS id_38, t3_.name AS name_39, t3_.display_order AS display_order_40, t0_.tenant_id AS tenant_id_41, t0_.tenant_product_category_id AS tenant_product_category_id_42, t1_.category_id AS category_id_43, t3_.master_category_id AS master_category_id_44, t3_.tenant_id AS tenant_id_45 FROM tenant_product t0_ LEFT JOIN tenant_product_tag t4_ ON t0_.id = t4_.tenant_product_id LEFT JOIN tag t1_ ON t1_.id = t4_.tag_id LEFT JOIN tag_category t2_ ON t1_.category_id = t2_.id LEFT JOIN tenant_product_category t3_ ON t0_.tenant_product_category_id = t3_.id WHERE t0_.tenant_id = ? AND t0_.is_active = 1 AND t0_.is_available = 1 ORDER BY t3_.display_order ASC, t0_.display_order ASC, t2_.display_order ASC, t1_.display_order ASC"
"params" => [
1 => 2
]
"types" => [
1 => Doctrine\DBAL\ParameterType {#664
+name: "INTEGER"
}
]
]