SHOW FULL COLUMNS FROM `t_goods` [ RunTime:0.001760s ]
SHOW FULL COLUMNS FROM `t_goods_prices` [ RunTime:0.001302s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count 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_name` LIKE '%%' GROUP BY `Goods`.`goods_id` ) `_group_count_` [ RunTime:0.005279s ]
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_name` LIKE '%%' GROUP BY `Goods`.`goods_id` ORDER BY `goods_id` DESC LIMIT 144,24 [ RunTime:0.007133s ]
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` IN (1010,1005,1004,1003,1002,1001,1000,999,998,997,996,995,994,993,992,991,990,989,988,980,978,977,975,974) GROUP BY `goods_id` [ RunTime:0.000912s ]