SHOW FULL COLUMNS FROM `mc_config` [ RunTime:0.002640s ]
SELECT * FROM `mc_config` WHERE `key` IN ('footer_about_title','footer_about_desc','footer_copyright','footer_icp') [ RunTime:0.004929s ]
SHOW FULL COLUMNS FROM `mc_footer_link` [ RunTime:0.002341s ]
SELECT * FROM `mc_footer_link` WHERE `group` = 'quick_links' ORDER BY `sort_order` ASC [ RunTime:0.000652s ]
SELECT * FROM `mc_footer_link` WHERE `group` = 'support' ORDER BY `sort_order` ASC [ RunTime:0.000552s ]
SHOW FULL COLUMNS FROM `mc_social_link` [ RunTime:0.001685s ]
SELECT * FROM `mc_social_link` ORDER BY `sort_order` ASC [ RunTime:0.000642s ]
SHOW FULL COLUMNS FROM `mc_product_category` [ RunTime:0.002026s ]
SELECT * FROM `mc_product_category` WHERE `status` = 1 ORDER BY `sort_order` ASC [ RunTime:0.000830s ]
SHOW FULL COLUMNS FROM `mc_product` [ RunTime:0.001632s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` IN (10,11,12,1) [ RunTime:0.000858s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` IN (20,21,100,101,2) [ RunTime:0.000480s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` = 3 [ RunTime:0.000390s ]
SELECT COUNT(*) AS think_count FROM `mc_product` WHERE `status` = 1 AND `category_id` = 4 [ RunTime:0.000516s ]
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.000650s ]
