-
轉換前:select count(*) as counts from product where find_in_set(:class_id, class_id) and deleted=0 ;
上翻沐浴凳 GB-3012
POST TIME:2019-06-21
沐浴凳（掛式） GB-3011
POST TIME:2019-06-21
轉角防滑扶手 GB-3010
POST TIME:2019-06-21
落地小便斗扶手 GB-3009
POST TIME:2019-06-21
多功能扶手 GB-3008
POST TIME:2019-06-21
”—“字型扶手 GB-3007
POST TIME:2019-06-21
”—“字型扶手 GB-3006
POST TIME:2019-06-21
135°扶手（左/右） GB-3005
POST TIME:2019-06-21
L型扶手（左/右） GB-3004
POST TIME:2019-06-21
轉換后:select count(*) as counts from product where find_in_set(63, class_id) and deleted=0 ;
轉換前:select id,rid,class_id,path,title as title,images,images_s,orders,addtime from product where find_in_set(:class_id, class_id) and deleted=0 order by orders desc,id DESC , mdtime desc limit 9;
轉換后:select id,rid,class_id,path,title as title,images,images_s,orders,addtime from product where find_in_set(63, class_id) and deleted=0 order by orders desc,id DESC , mdtime desc limit 9;
轉換前:select id,product_id,images,images_s,images_name from product_photo where product_id in (1051,1052,1053,1054,1055,1056,1057,1058,1059) and deleted=0 order by orders,id;
轉換后:select id,product_id,images,images_s,images_name from product_photo where product_id in (1051,1052,1053,1054,1055,1056,1057,1058,1059) and deleted=0 order by orders,id;
粵公網安備 44010602007535號
