SHOW FULL COLUMNS FROM `t_goods` [ RunTime:0.001670s ]
SHOW FULL COLUMNS FROM `t_goods_prices` [ RunTime:0.001338s ]
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.005396s ]
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 72,24 [ RunTime:0.007003s ]
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 (1125,1124,1123,1122,1121,1120,1119,1118,1117,1116,1115,1114,1113,1112,1111,1110,1090,1088,1087,1086,1085,1084,1083,1082) GROUP BY `goods_id` [ RunTime:0.000867s ]