SHOW FULL COLUMNS FROM `self_product` [ RunTime:0.006688s ]
SELECT COUNT(*) AS think_count FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 [ RunTime:0.006236s ]
SELECT * FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 ORDER BY `sort_order` DESC,`id` DESC LIMIT 20,20 [ RunTime:0.012375s ]
SELECT DISTINCT `brand` FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 [ RunTime:0.006429s ]
SELECT DISTINCT `aroma` FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 AND `aroma` IS NOT NULL AND `aroma` <> '' [ RunTime:0.006545s ]
SELECT DISTINCT `origin` FROM `self_product` WHERE `status` = 1 AND `is_old_liquor` = 1 AND `origin` IS NOT NULL AND `origin` <> '' [ RunTime:0.006485s ]
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.006192s ]
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.006838s ]
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.008855s ]