SHOW FULL COLUMNS FROM `cmf_hook` [ RunTime:0.000915s ]
SELECT `hook`,`id` FROM `cmf_hook` WHERE ( ( `app` = '' OR `app` = 'cmf' ) AND `type` = 3 ) OR `type` = 1 [ RunTime:0.000356s ]
SHOW FULL COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000718s ]
SELECT `hook`,`plugin` FROM `cmf_hook_plugin` WHERE `status` = 1 AND `hook` IN ('app_begin','module_init','action_begin','view_filter','app_end','log_write','response_end','admin_init','home_init','send_mobile_verification_code','body_start','before_head_end','footer_start','before_footer','before_footer_end','before_body_end','left_sidebar_start','before_left_sidebar_end','right_sidebar_start','before_right_sidebar_end','comment','guestbook','switch_theme','after_content','before_content','log_write_done','switch_admin_theme','captcha_image','user_login_start') ORDER BY `list_order` ASC [ RunTime:0.000452s ]
SHOW FULL COLUMNS FROM `cmf_languages` [ RunTime:0.001039s ]
SELECT `code`,`domain`,`is_default` FROM `cmf_languages` WHERE `status` = 1 [ RunTime:0.000412s ]
SELECT `code`,`name`,`domain`,`icon` FROM `cmf_languages` WHERE `status` = 1 [ RunTime:0.000230s ]
SHOW FULL COLUMNS FROM `cmf_content_config` [ RunTime:0.000635s ]
SELECT `cc`.`id`,`cc`.`code`,`cl`.`content` FROM `cmf_content_config` `cc` INNER JOIN `cmf_content_config_value` `cl` ON `cc`.`id`=`cl`.`config_id` WHERE `cc`.`code` = 'COMPANY_NAME' AND `cl`.`lang_code` = 'zh-cn' LIMIT 1 [ RunTime:0.000582s ]
SELECT `cc`.`id`,`cc`.`code`,`cl`.`content` FROM `cmf_content_config` `cc` INNER JOIN `cmf_content_config_value` `cl` ON `cc`.`id`=`cl`.`config_id` WHERE `cc`.`code` = 'MOBILE' AND `cl`.`lang_code` = 'zh-cn' LIMIT 1 [ RunTime:0.000227s ]
SELECT `cc`.`id`,`cc`.`code`,`cl`.`content` FROM `cmf_content_config` `cc` INNER JOIN `cmf_content_config_value` `cl` ON `cc`.`id`=`cl`.`config_id` WHERE `cc`.`code` = 'EMAIL' AND `cl`.`lang_code` = 'zh-cn' LIMIT 1 [ RunTime:0.000295s ]
SELECT `cc`.`id`,`cc`.`code`,`cl`.`content` FROM `cmf_content_config` `cc` INNER JOIN `cmf_content_config_value` `cl` ON `cc`.`id`=`cl`.`config_id` WHERE `cc`.`code` = 'ADDRESS' AND `cl`.`lang_code` = 'zh-cn' LIMIT 1 [ RunTime:0.000203s ]
SELECT `cc`.`id`,`cc`.`code`,`cl`.`content` FROM `cmf_content_config` `cc` INNER JOIN `cmf_content_config_value` `cl` ON `cc`.`id`=`cl`.`config_id` WHERE `cc`.`code` = 'ABOUT' AND `cl`.`lang_code` = 'zh-cn' LIMIT 1 [ RunTime:0.000175s ]
SHOW FULL COLUMNS FROM `cmf_categories` [ RunTime:0.000541s ]
SELECT `c`.`id`,cl.name as category_name,`cl`.`image_url` FROM `cmf_categories` `c` INNER JOIN `cmf_category_langs` `cl` ON `c`.`id`=`cl`.`category_id` WHERE `c`.`parent_id` = '0' AND `cl`.`lang_code` = 'zh-cn' AND `c`.`status` = '1' ORDER BY `c`.`list_order` ASC [ RunTime:0.000280s ]
SHOW FULL COLUMNS FROM `cmf_products` [ RunTime:0.000597s ]
SELECT `p`.`id`,pl.name as product_name,pl.cover_image as cover_image FROM `cmf_products` `p` INNER JOIN `cmf_product_langs` `pl` ON `p`.`id`=`pl`.`product_id` WHERE `p`.`category_id` = '9' ORDER BY `p`.`sort` ASC LIMIT 10 [ RunTime:0.000341s ]
SELECT `p`.`id`,pl.name as product_name,pl.cover_image as cover_image FROM `cmf_products` `p` INNER JOIN `cmf_product_langs` `pl` ON `p`.`id`=`pl`.`product_id` WHERE `p`.`category_id` = '10' ORDER BY `p`.`sort` ASC LIMIT 10 [ RunTime:0.000228s ]
SELECT `p`.`id`,pl.name as product_name,pl.cover_image as cover_image FROM `cmf_products` `p` INNER JOIN `cmf_product_langs` `pl` ON `p`.`id`=`pl`.`product_id` WHERE `p`.`category_id` = '11' ORDER BY `p`.`sort` ASC LIMIT 10 [ RunTime:0.000469s ]
SELECT `p`.`id`,pl.name as product_name,pl.cover_image as cover_image FROM `cmf_products` `p` INNER JOIN `cmf_product_langs` `pl` ON `p`.`id`=`pl`.`product_id` WHERE `p`.`category_id` = '12' ORDER BY `p`.`sort` ASC LIMIT 10 [ RunTime:0.000153s ]
SELECT `p`.`id`,pl.name as product_name,pl.cover_image as cover_image FROM `cmf_products` `p` INNER JOIN `cmf_product_langs` `pl` ON `p`.`id`=`pl`.`product_id` WHERE `p`.`category_id` = '13' ORDER BY `p`.`sort` ASC LIMIT 10 [ RunTime:0.000110s ]
SHOW FULL COLUMNS FROM `cmf_article_category_langs` [ RunTime:0.000449s ]
SELECT acl.category_id as id,`acl`.`name`,`acl`.`description` FROM `cmf_article_category_langs` `acl` INNER JOIN `cmf_article_categories` `ac` ON `acl`.`category_id`=`ac`.`id` WHERE `acl`.`lang_code` = 'zh-cn' AND `ac`.`status` = '1' ORDER BY `ac`.`list_order` ASC [ RunTime:0.000279s ]
SHOW FULL COLUMNS FROM `cmf_articles` [ RunTime:0.000484s ]
SELECT COUNT(*) AS think_count FROM `cmf_articles` `a` INNER JOIN `cmf_article_category_langs` `b` ON `a`.`category_id`=`b`.`category_id` INNER JOIN `cmf_article_langs` `c` ON `a`.`id`=`c`.`article_id` WHERE `c`.`lang_code` = 'zh-cn' LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `cmf_articles` `a` INNER JOIN `cmf_article_category_langs` `b` ON `a`.`category_id`=`b`.`category_id` INNER JOIN `cmf_article_langs` `c` ON `a`.`id`=`c`.`article_id` WHERE `c`.`lang_code` = 'zh-cn' LIMIT 0,10 [ RunTime:0.000447s ]
SELECT * FROM `cmf_article_category_langs` WHERE `lang_code` = 'zh-cn' [ RunTime:0.000169s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.000854s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' AND `file` = 'demo/index' LIMIT 1 [ RunTime:0.000373s ]
SELECT `more`,`file`,`id` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/index/news' ) ORDER BY `is_public` DESC [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.000762s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `cmf_url_aliases` [ RunTime:0.000549s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 113 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000243s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 1 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000211s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 2 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000191s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 34 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.001015s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 36 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000197s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 40 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000120s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 43 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000114s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 3 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000155s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 46 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000114s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 48 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000100s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 63 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000148s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 66 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000104s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 69 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000144s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 73 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000133s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 51 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000119s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 54 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000146s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 57 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000137s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 76 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000102s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 79 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000157s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 82 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000131s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 85 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000100s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 88 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000270s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 91 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000157s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 94 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000198s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 97 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000144s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 100 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000114s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 103 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000115s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 106 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000137s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 109 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000104s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 113 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000114s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 1 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000155s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 2 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000141s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 34 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000111s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 36 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000219s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 40 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000329s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 43 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.001341s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 3 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000304s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 46 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000189s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 48 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000182s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 63 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000243s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 66 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000132s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 69 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000452s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 73 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000175s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 51 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000204s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 54 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000213s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 57 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000239s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 76 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000146s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 79 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000560s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 82 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000212s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 85 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000152s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 88 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000175s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 91 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000161s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 94 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000178s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 97 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000172s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 100 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000126s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 103 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000170s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 106 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000120s ]
SELECT `alias` FROM `cmf_url_aliases` WHERE `content_type` = 'product' AND `content_id` = 109 AND `lang_code` = 'zh-cn' AND `status` = 1 AND `is_primary` = 1 LIMIT 1 [ RunTime:0.000153s ]