第一步sql优化长度达到1000以上会被截断

[l306287405]

[Note] 第1步: 对SQL解析优化之后得到的SQL:select product_orgz.product_id AS product_id,products.code AS product_code,products.name AS product_name,products.product_base_code AS product_base_code,products.min_spec_unit AS sales_unit,min_spec.name AS unit_name,products.order_spec_unit AS order_spec_unit,products.order_spec_num AS spec_num,order_spec.name AS spec_unit,products.weight_type AS weight_type,products.c_code AS c_code from (((test.product_orgz join test.products on((products.id = product_orgz.product_id))) join test.product_units min_spec on((min_spec.id = products.min_spec_unit))) join test.product_units order_spec on((order_spec.id = products.order_spec_unit))) where ((product_orgz.hq_code = '000001') and (products.code <> 123) and (product_orgz.orgz_id = 12) and (product_orgz.is_manager = 1) and (product_orgz.is_require = 0) and (product_orgz.status = 1) and ((

[l306287405]

sqladvisor -f sql.conf -q "select product_orgz.product_id, products.code as product_code, products.name as product_name, products.product_base_code, products.min_spec_unit as sales_unit, min_spec.name as unit_name, products.order_spec_unit, products.order_spec_num as spec_num, order_spec.name as spec_unit, products.weight_type, products.c_code from product_orgz inner join products on products.id = product_orgz.product_id inner join product_units as min_spec on min_spec.id = products.min_spec_unit inner join product_units as order_spec on order_spec.id = products.order_spec_unit where product_orgz.hq_code = '000001' and products.code != 123 and product_orgz.orgz_id = 12 and product_orgz.is_manager = 1 and product_orgz.is_require = 0 and product_orgz.status = 1 and (products.name like '菜' or products.code = 12 or products.product_base_code = 12 or products.mnemonic_pinyin like '%C%' or products.mnemonic_wubi like '%C%' or products.id in (select product_id as id from product_bar_plu where plu_code = '12' or product_bar_code = '1' group by product_id)) group by product_orgz.product_id limit 5 offset 0" -v 1

[gundamff]

同样的问题

[linmoyu]

请问这个问题解决了吗

[DJxiaoqian]

这个问题有人有解决方案吗