SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.000878s ]
SELECT * FROM `idea_goods` WHERE `id` = 3 AND `is_sale` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `idea_goods` SET `hits` = 229 WHERE ( `id` = 3 ) [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `idea_goods_price` [ RunTime:0.000737s ]
SELECT * FROM `idea_goods_price` WHERE `goods_id` = 3 AND `spec_key` = '' LIMIT 1 [ RunTime:0.000393s ]
SHOW FULL COLUMNS FROM `idea_service` [ RunTime:0.000639s ]
SELECT `id`,`title`,`info` FROM `idea_service` WHERE `id` IN (5,4,2) AND `is_show` = 1 ORDER BY `sequence`,`id` [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `idea_coupon_user` [ RunTime:0.000692s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` = 0 ORDER BY `id` DESC [ RunTime:0.000224s ]
SHOW FULL COLUMNS FROM `idea_coupon` [ RunTime:0.000710s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND `b_date` <= 1772515011 AND `e_date` >= 1772515011 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(3,goods_ids)) ) ORDER BY `cut_price` DESC [ RunTime:0.000463s ]
SHOW FULL COLUMNS FROM `idea_discount` [ RunTime:0.000710s ]
SELECT * FROM `idea_discount` WHERE `b_date` <= 1772515011 AND `e_date` >= 1772515011 AND ( use_type = 0 OR (use_type = 1 AND FIND_IN_SET(3,goods_ids)) ) [ RunTime:0.000348s ]
SHOW FULL COLUMNS FROM `idea_goods_comment` [ RunTime:0.000673s ]
SELECT COUNT(*) AS think_count FROM `idea_goods_comment` WHERE `goods_id` = 3 AND `is_show` = 1 [ RunTime:0.000218s ]
SELECT * FROM `idea_goods_comment` WHERE `goods_id` = 3 AND `is_show` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 1 [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.001210s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000387s ]
select id,title,subtitle,pic,price,market_price,hits,initial_sales,sales from idea_goods where is_delete = 0 and is_sale = 1 and is_hot = 1 order by sequence desc,id desc limit 0,5 [ RunTime:0.000530s ]