SHOW FULL COLUMNS FROM `t_goods` [ RunTime:0.001769s ]
SHOW FULL COLUMNS FROM `t_goods_prices` [ RunTime:0.001433s ]
SELECT `goods`.* FROM `t_goods` `goods` INNER JOIN `t_goods_sales` ON `t_goods_sales`.`goods_id`=`goods`.`goods_id` JOIN `t_goods_prices` ON `t_goods_prices`.`goods_sales_id`=`t_goods_sales`.`goods_sales_id` WHERE `t_goods_prices`.`company_belong` = '1' AND `goods_img` IS NOT NULL AND `goods_state` = 1 AND `Goods`.`goods_id` = '1000' AND `goods_name` LIKE '%%' GROUP BY `Goods`.`goods_id` ORDER BY `goods_id` DESC LIMIT 1 [ RunTime:0.002127s ]
SELECT *,goods_id,sales_normal_price,sales_amount,min(sales_amount) as sales_amount FROM `t_goods_sales` WHERE `goods_sales_state` = 1 AND `goods_id` = 1000 GROUP BY `goods_id` [ RunTime:0.000528s ]
万语千颜
鄂ICP备2022011613号
