SHOW FULL COLUMNS FROM `cxxia_fenzhan_domain` [ RunTime:0.001067s ]
SELECT * FROM `cxxia_fenzhan_domain` WHERE `domain` = 'diooc.cn' AND `status` = 1 LIMIT 1 [ RunTime:0.000664s ]
SHOW FULL COLUMNS FROM `cxxia_shop_product` [ RunTime:0.004444s ]
SELECT COUNT(*) AS think_count FROM `cxxia_shop_product` WHERE `status` = 1 AND `isdelete` = 0 [ RunTime:0.009268s ]
SELECT * FROM `cxxia_shop_product` WHERE `status` = 1 AND `isdelete` = 0 ORDER BY `cxxia_shop_product`.`sales` DESC,`cxxia_shop_product`.`sort` DESC,`cxxia_shop_product`.`id` DESC LIMIT 0,40 [ RunTime:0.011129s ]
SHOW FULL COLUMNS FROM `cxxia_shop_product_warehouse` [ RunTime:0.003197s ]
SELECT MIN(total_price),`product_id` FROM `cxxia_shop_product_warehouse` WHERE `product_id` IN (1654,1743,1870,1649,2447,1652,1857,2198,1458,1718,2206,1812,1858,2196,2116,2144,1655,2438,1838,2200,1733,1460,1880,1835,1855,2408,1836,2214,5353,1456,1908,2165,2230,1786,1937,2208,1659,1618,2086,2203) GROUP BY `product_id` [ RunTime:0.002655s ]