SHOW FULL COLUMNS FROM `mc_config` [ RunTime:0.018218s ]
SELECT * FROM `mc_config` WHERE `key` IN ('footer_about_title','footer_about_desc','footer_copyright','footer_icp') [ RunTime:0.001068s ]
SHOW FULL COLUMNS FROM `mc_footer_link` [ RunTime:0.002106s ]
SELECT * FROM `mc_footer_link` WHERE `group` = 'quick_links' ORDER BY `sort_order` ASC [ RunTime:0.000695s ]
SELECT * FROM `mc_footer_link` WHERE `group` = 'support' ORDER BY `sort_order` ASC [ RunTime:0.000658s ]
SHOW FULL COLUMNS FROM `mc_social_link` [ RunTime:0.002079s ]
SELECT * FROM `mc_social_link` ORDER BY `sort_order` ASC [ RunTime:0.000681s ]
SHOW FULL COLUMNS FROM `mc_product_category` [ RunTime:0.002332s ]
SELECT * FROM `mc_product_category` WHERE `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.001015s ]
SHOW FULL COLUMNS FROM `mc_product` [ RunTime:0.003416s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` IN (10,11,12,1) [ RunTime:0.000975s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` IN (20,21,100,101,2) [ RunTime:0.000827s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` = 3 [ RunTime:0.000658s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` = 4 [ RunTime:0.000570s ]
SELECT `p`.*,`p`.`intro_zh`,`p`.`intro_en`,`p`.`intro_ru`,c.name_zh as cat_name_zh,c.name_en as cat_name_en,c.name_ru as cat_name_ru FROM `mc_product` `p` LEFT JOIN `mc_product_category` `c` ON `p`.`category_id`=`c`.`id` WHERE `p`.`status` = '1' ORDER BY `p`.`sort_order` ASC,`p`.`id` DESC [ RunTime:0.000866s ]
