SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.001376s ]
SELECT `idea_goods`.*,b.typeid as brand_typeid FROM `idea_goods` LEFT JOIN `idea_brand` `b` ON `idea_goods`.`brand_id`=`b`.`id` WHERE `idea_goods`.`id` = '156' AND `idea_goods`.`is_sale` = '1' AND `idea_goods`.`is_delete` = '0' LIMIT 1 [ RunTime:0.001507s ]
UPDATE `idea_goods` SET `hits` = 152826 WHERE `id` = 156 [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `idea_goods_price` [ RunTime:0.000925s ]
SELECT * FROM `idea_goods_price` WHERE `goods_id` = 156 AND `spec_key` = '黑豹3代加强版10ml(含试用装)' LIMIT 1 [ RunTime:0.000772s ]
SHOW FULL COLUMNS FROM `idea_coupon_user` [ RunTime:0.000953s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001047s ]
SHOW FULL COLUMNS FROM `idea_coupon` [ RunTime:0.000970s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(156,goods_ids)) ) AND `e_date` >= 1793527605 ORDER BY `cut_price` DESC [ RunTime:0.000673s ]
SELECT COUNT(*) AS think_count FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `end_date` >= 1793527605 [ RunTime:0.000812s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `add_date` <= 1793527605 AND `end_date` >= 1793527605 LIMIT 1 [ RunTime:0.001034s ]
SELECT * FROM `idea_goods_price` WHERE `goods_id` = 156 AND `spec_key` = '久滑套装黑豹3代加强版+医用润滑(含试用装)' LIMIT 1 [ RunTime:0.000760s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.000979s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(156,goods_ids)) ) AND `e_date` >= 1793527605 ORDER BY `cut_price` DESC [ RunTime:0.000726s ]
SELECT COUNT(*) AS think_count FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `end_date` >= 1793527605 [ RunTime:0.000867s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `add_date` <= 1793527605 AND `end_date` >= 1793527605 LIMIT 1 [ RunTime:0.001064s ]
SELECT * FROM `idea_goods_price` WHERE `goods_id` = 156 AND `spec_key` = '黑豹4代 温和持久6ml' LIMIT 1 [ RunTime:0.001056s ]
SELECT * FROM `idea_goods_price` WHERE `goods_id` = 156 AND `spec_key` = '黑豹5代 双效持久养护合一8ml' LIMIT 1 [ RunTime:0.001032s ]
SELECT * FROM `idea_goods_price` WHERE `goods_id` = 156 AND `spec_key` = '黑豹延时喷剂3代加强版X2【省100】(含试用装)' LIMIT 1 [ RunTime:0.000818s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001013s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(156,goods_ids)) ) AND `e_date` >= 1793527605 ORDER BY `cut_price` DESC [ RunTime:0.000667s ]
SELECT COUNT(*) AS think_count FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `end_date` >= 1793527605 [ RunTime:0.000922s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `add_date` <= 1793527605 AND `end_date` >= 1793527605 LIMIT 1 [ RunTime:0.001123s ]
SHOW FULL COLUMNS FROM `idea_service` [ RunTime:0.000973s ]
SELECT `id`,`title`,`info` FROM `idea_service` WHERE `id` IN (4,6,3,7,5,2) AND `is_show` = 1 ORDER BY `sequence`,`id` [ RunTime:0.000707s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001118s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(156,goods_ids)) ) AND `e_date` >= 1793527605 ORDER BY `cut_price` DESC [ RunTime:0.000727s ]
SELECT COUNT(*) AS think_count FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `end_date` >= 1793527605 [ RunTime:0.000933s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `add_date` <= 1793527605 AND `end_date` >= 1793527605 LIMIT 1 [ RunTime:0.001150s ]
SHOW FULL COLUMNS FROM `idea_discount` [ RunTime:0.001093s ]
SELECT * FROM `idea_discount` WHERE `b_date` <= 1793527605 AND `e_date` >= 1793527605 AND ( use_type = 0 OR (use_type = 1 AND FIND_IN_SET(156,goods_ids)) ) [ RunTime:0.000623s ]
SHOW FULL COLUMNS FROM `idea_goods_comment` [ RunTime:0.001071s ]
SELECT COUNT(*) AS think_count FROM `idea_goods_comment` WHERE `goods_id` = 156 AND `is_show` = 1 [ RunTime:0.045340s ]
SELECT * FROM `idea_goods_comment` WHERE `goods_id` = 156 AND `is_show` = 1 ORDER BY `is_top` DESC,`id` DESC LIMIT 10 [ RunTime:0.036216s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.000825s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(156,goods_ids)) ) AND `e_date` >= 1793527605 ORDER BY `cut_price` DESC [ RunTime:0.000496s ]
SELECT COUNT(*) AS think_count FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `end_date` >= 1793527605 [ RunTime:0.000704s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL AND `coupon_id` = 31 AND `is_use` = 0 AND `add_date` <= 1793527605 AND `end_date` >= 1793527605 LIMIT 1 [ RunTime:0.000724s ]
SHOW FULL COLUMNS FROM `idea_user` [ RunTime:0.000744s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000484s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000463s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000566s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000444s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000371s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000459s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000465s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000468s ]
SELECT * FROM `idea_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000457s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_parameter` [ RunTime:0.000654s ]
SELECT `content` FROM `idea_weapp_goods_parameter` WHERE `aid` = 156 [ RunTime:0.000451s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_content` [ RunTime:0.000847s ]
SELECT `content` FROM `idea_weapp_goods_content` WHERE `goods_id` = 156 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `idea_weapp_article_relation` [ RunTime:0.000780s ]
SELECT `a_article_id`,`a_title`,`a_description`,`keyword`,`sort` FROM `idea_weapp_article_relation` WHERE `b_article_id` = 156 AND `status` = 1 ORDER BY `sort` DESC LIMIT 10 [ RunTime:0.000631s ]
select * from idea_goods_category where is_show = 1 and parent_id = 0 order by is_top desc,sequence desc,id desc limit 0,6 [ RunTime:0.000630s ]
select * from idea_goods_category where is_show = 1 and is_top = 1 and parent_id != 0 order by sequence desc limit 0,2 [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.000866s ]
SELECT `id`,`title`,`parent_id` FROM `idea_goods_category` WHERE `id` = 66 LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`title`,`parent_id` FROM `idea_goods_category` WHERE `id` = 88 LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`title`,`parent_id` FROM `idea_goods_category` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000411s ]
select * from idea_goods where is_delete = 0 and is_sale = 1 and stock != 0 and id not in(156) and cat_id in(66) order by initial_sales desc limit 0,6 [ RunTime:0.001147s ]
SHOW FULL COLUMNS FROM `idea_addons_statistics_code` [ RunTime:0.000805s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'body' [ RunTime:0.000507s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'head' [ RunTime:0.000466s ]