SHOW FULL COLUMNS FROM `self_product` [ RunTime:0.006870s ]
SELECT COUNT(*) AS think_count FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 [ RunTime:0.006390s ]
SELECT * FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 ORDER BY `sort_order` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.015133s ]
SELECT DISTINCT `brand` FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 [ RunTime:0.006635s ]
SELECT DISTINCT `aroma` FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 AND `aroma` IS NOT NULL AND `aroma` <> '' [ RunTime:0.006707s ]
SELECT DISTINCT `origin` FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 AND `origin` IS NOT NULL AND `origin` <> '' [ RunTime:0.006694s ]
SELECT COUNT(*) AS think_count FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 ORDER BY `sort_order` DESC,`id` DESC [ RunTime:0.006484s ]
SELECT * FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 AND `old_liquor_recommend` = 1 ORDER BY `sort_order` DESC LIMIT 6 [ RunTime:0.007009s ]
SELECT * FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 AND `old_liquor_recommend` = 0 ORDER BY `sort_order` DESC LIMIT 6 [ RunTime:0.009748s ]