SHOW FULL COLUMNS FROM `cmf_hook` [ RunTime:0.001823s ]
SELECT `hook`,`id` FROM `cmf_hook` WHERE ( ( `app` = '' OR `app` = 'cmf' ) AND `type` = 3 ) OR `type` = 1 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `cmf_hook_plugin` [ RunTime:0.000688s ]
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.000433s ]
SHOW FULL COLUMNS FROM `cmf_languages` [ RunTime:0.001380s ]
SELECT `code`,`domain`,`is_default` FROM `cmf_languages` WHERE `status` = 1 [ RunTime:0.000286s ]
SELECT `code`,`name`,`domain`,`icon` FROM `cmf_languages` WHERE `status` = 1 [ RunTime:0.000257s ]
SHOW FULL COLUMNS FROM `cmf_content_config` [ RunTime:0.000743s ]
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.000657s ]
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.000268s ]
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.000327s ]
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.000189s ]
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.000198s ]
SHOW FULL COLUMNS FROM `cmf_categories` [ RunTime:0.000537s ]
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.000368s ]
SHOW FULL COLUMNS FROM `cmf_products` [ RunTime:0.000504s ]
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.000296s ]
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.000170s ]
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.000148s ]
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.000170s ]
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.000178s ]
SHOW FULL COLUMNS FROM `cmf_article_category_langs` [ RunTime:0.000389s ]
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.000501s ]
SHOW FULL COLUMNS FROM `cmf_photo` [ RunTime:0.000791s ]
SELECT * FROM `cmf_photo` WHERE `album_id` = 1 [ RunTime:0.000406s ]
SELECT `code`,`name`,`domain`,`icon` FROM `cmf_languages` WHERE `status` = 1 [ RunTime:0.000330s ]
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.000534s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.000593s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' AND `file` = 'demo/index' LIMIT 1 [ RunTime:0.000199s ]
SELECT `more`,`file`,`id` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/index/about' ) ORDER BY `is_public` DESC [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.000717s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `cmf_url_aliases` [ RunTime:0.000548s ]
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.000213s ]
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.000527s ]
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.000255s ]
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.000304s ]
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.000194s ]
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.000271s ]
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.000180s ]
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.000165s ]
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.000132s ]
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.000251s ]
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.000233s ]
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.000177s ]
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.000202s ]
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.000171s ]
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.000148s ]
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.000155s ]
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.000176s ]
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.000147s ]
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.000128s ]
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.000357s ]
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.000236s ]
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.000194s ]
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.000189s ]
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.000181s ]
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.000176s ]
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.000269s ]
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.000125s ]
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.000150s ]
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.000113s ]
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.000202s ]
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.000125s ]
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.000116s ]
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.000101s ]
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.000121s ]
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.000181s ]
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.000138s ]
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.000120s ]
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.000108s ]
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.000108s ]
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.000141s ]
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.000122s ]
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.000149s ]
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.000128s ]
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.000190s ]
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.000105s ]
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.000125s ]
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.000161s ]
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.000163s ]
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.000170s ]
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.000161s ]
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.000112s ]
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.000119s ]
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.000106s ]
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.000098s ]
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.000105s ]
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.000105s ]
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.000097s ]
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.000119s ]