SHOW FULL COLUMNS FROM `hysp_hook` [ RunTime:0.002798s ]
SELECT `hook`,`id` FROM `hysp_hook` WHERE ( ( `app` = '' OR `app` = 'cmf' ) AND `type` = 3 ) OR `type` = 1 [ RunTime:0.001701s ]
SHOW FULL COLUMNS FROM `hysp_hook_plugin` [ RunTime:0.002634s ]
SELECT `hook`,`plugin` FROM `hysp_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.001654s ]
SHOW FULL COLUMNS FROM `hysp_portal_category` [ RunTime:0.002454s ]
SELECT * FROM `hysp_portal_category` WHERE `id` = '2' AND `status` = 1 LIMIT 1 [ RunTime:0.001915s ]
SHOW FULL COLUMNS FROM `hysp_theme_file` [ RunTime:0.003147s ]
SELECT * FROM `hysp_theme_file` WHERE `theme` = 'hysp' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.002252s ]
SELECT * FROM `hysp_theme_file` WHERE `theme` = 'hysp' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.001106s ]
UPDATE `hysp_theme_file` SET `theme` = 'hysp' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首页' , `more` = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":1,\"public_widget_id\":\"top_nav\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"company_name\":\"\\u83f2\\u65af\\u7279\",\"nav_id\":\"1\",\"nav_id_text_\":\"\\u4e3b\\u5bfc\\u822a\"},\"css\":{\"margin-top\":\"0\",\"margin-bottom\":\"15px\",\"margin-left\":\"0\",\"margin-right\":\"0\"}}}},\"body\":{\"title\":\"\\u4e3b\\u4f53\",\"widgets\":{\"home_slider_202206300003\":{\"title\":\"\\u9996\\u9875\\u5e7b\\u706f\\u7247\",\"name\":\"slider\",\"display\":1,\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"slide_id\":\"1\",\"fullscreen\":\"1\",\"slide_id_text_\":\"\\u9996\\u9875\\u8f6e\\u64ad\\u56fe\"},\"css\":{\"margin-top\":\"0\",\"margin-bottom\":\"15px\",\"margin-left\":\"0\",\"margin-right\":\"0\"}},\"bodyfeatures6764cf12b3735\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"name\":\"features\",\"display\":1,\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"sub_title\":\"about us\",\"features\":[{\"title\":\"about us\",\"icon\":\"bars\",\"content\":\"<p>We are 13 years of canned food factory, mainly for canned vegetable: tomato paste, corn, mushroom, bean etc, canned fruit: peach, mixed, canned meat: sardine fish in oil, mackerel in sauce, tuna, beef etc, already been sending to Europe, middles east, africa etc with more than 200 countries.<\\/p>\\r\\n<p>We specialize in canned food, with 21 production lines for various items. Our capacity is 20,000 metric tons per month. We also offer quality control, design services, after-sales support, and more through our team of professionals. Welcome to visit us at your convenience.<\\/p>\"}]},\"css\":{\"margin-top\":\"0\",\"margin-bottom\":\"15px\",\"margin-left\":\"0\",\"margin-right\":\"0\"}},\"bodyproducts689c708e49d56\":{\"title\":\"\\u4ea7\\u54c1\\u5206\\u7c7b\",\"name\":\"products\",\"display\":1,\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"11\",\"last_news_category_id_text_\":\"Tomato Item\"},\"css\":{\"margin-top\":\"0\",\"margin-bottom\":\"15px\",\"margin-left\":\"0\",\"margin-right\":\"0\"}},\"bodyproducts2689c8472d40a0\":{\"title\":\"\\u4ea7\\u54c1\",\"name\":\"products2\",\"display\":1,\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"last_news_category_id\":\"13\",\"last_news_category_id_text_\":\"Canned Fish\"},\"css\":{\"margin-top\":\"0\",\"margin-bottom\":\"15px\",\"margin-left\":\"0\",\"margin-right\":\"0\"}},\"bodyfeatures_pro689dca5688d5c\":{\"title\":\"\\u5de5\\u5382\\u5c55\\u793a\",\"name\":\"features_pro\",\"display\":\"1\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":{\"sub_title\":\"Quickly understand the ThinkCMF\",\"features\":[{\"title\":\"\\u4ea7\\u54c1\\u63a8\\u8350\",\"icon\":\"bars\",\"content\":\"\\u4f7f\\u7528MVC\\u5e94\\u7528\\u7a0b\\u5e8f\\u88ab\\u5206\\u6210\\u4e09\\u4e2a\\u6838\\u5fc3\\u90e8\\u4ef6\\uff1a\\u6a21\\u578b\\uff08M\\uff09\\u3001\\u89c6\\u56fe\\uff08V\\uff09\\u3001\\u63a7\\u5236\\u5668\\uff08C\\uff09\\uff0c\\u4ed6\\u4e0d\\u662f\\u4e00\\u4e2a\\u65b0\\u7684\\u6982\\u5ff5\\uff0c\\u53ea\\u662fThinkCMF\\u5c06\\u5176\\u53d1\\u6325\\u5230\\u4e86\\u6781\\u81f4\\u3002\"}]}}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"home_footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":1,\"public_widget_id\":\"footer\",\"version\":\"1.0.0\",\"action\":\"\",\"vars\":[],\"css\":{\"margin-top\":\"0\",\"margin-bottom\":\"15px\",\"margin-left\":\"0\",\"margin-right\":\"0\"}}}}},\"edited_by_designer\":1}' , `config_more` = '{\"widgets_blocks\":{\"top\":{\"title\":\"\\u9876\\u90e8\",\"widgets\":{\"top_nav_202206300003\":{\"title\":\"\\u9876\\u90e8\\u5bfc\\u822a\",\"name\":\"nav\",\"display\":\"1\",\"public_widget_id\":\"top_nav\"}}},\"body\":{\"title\":\"\\u4e3b\\u4f53\",\"widgets\":{\"home_slider_202206300003\":{\"title\":\"\\u9996\\u9875\\u5e7b\\u706f\\u7247\",\"name\":\"slider\",\"display\":\"1\"},\"home_features_202206300003\":{\"title\":\"\\u4ea7\\u54c1\\u7279\\u6027\",\"name\":\"features\",\"display\":\"1\"},\"home_last_news_202206300003\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"},\"home_last_news_202206300004\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"name\":\"last_news\",\"display\":\"1\"}}},\"footer\":{\"title\":\"\\u5e95\\u90e8\",\"widgets\":{\"home_footer_202206300003\":{\"title\":\"\\u5e95\\u90e8\",\"name\":\"footer\",\"display\":\"1\",\"public_widget_id\":\"footer\"}}}}}' , `description` = '首页模板文件' , `is_public` = 0 , `list_order` = '5' WHERE `theme` = 'hysp' AND `file` = 'portal/index' [ RunTime:0.008802s ]
SELECT * FROM `hysp_theme_file` WHERE `theme` = 'hysp' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.002063s ]
SELECT `more`,`file`,`id`,`is_public` FROM `hysp_theme_file` WHERE `theme` = 'hysp' AND ( `is_public` = 1 OR `file` = 'portal/list' ) ORDER BY `is_public` DESC [ RunTime:0.000759s ]
SHOW FULL COLUMNS FROM `hysp_nav_menu` [ RunTime:0.001285s ]
SELECT * FROM `hysp_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000663s ]
SHOW FULL COLUMNS FROM `hysp_portal_post` [ RunTime:0.002179s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `hysp_portal_post` `post` INNER JOIN `hysp_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '2' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1755926179' ) GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.001573s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `hysp_portal_post` `post` INNER JOIN `hysp_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' AND ( `post`.`create_time` >= '0' ) AND ( `category_post`.`category_id` = '2' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1755926179' ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 0,10 [ RunTime:0.001489s ]
