[ SQL ] UPDATE `demo_theme_file` SET `theme`='chenrong',`action`='portal/Index/index',`file`='portal/index',`name`='首頁(yè)',`more`='{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"1\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u9996\\u9875\\u5e7b\\u706f\\u7247\"}},\"widgets\":{\"product_center\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":1,\"vars\":{\"product_center_category_id\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\\u5206\\u7c7bID\",\"value\":\"4\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u4ea7\\u54c1\\u5c55\\u793a\"},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Recommended products and services\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_news\":{\"title\":\"\\u6700\\u65b0\\u8d44\\u8baf\",\"display\":1,\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"6\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u65b0\\u95fb\\u52a8\\u6001\"},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Latest news and information\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"about_me\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"display\":1,\"vars\":{\"about_me_id\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\\u9875\\u9762ID\",\"value\":\"2\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Page\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9875\\u9762\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u5173\\u4e8e\\u6211\\u4eec\"},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"About us and company introduction\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"top_image\":{\"title\":\"\\u9876\\u90e8\\u56fe\\u7247\",\"value\":\"admin\\/20210620\\/2ea6bad3b253a218f5b90a34b79abddf.jpg\",\"type\":\"image\",\"placeholder\":\"\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"customer_stories\":{\"title\":\"\\u670d\\u52a1\\u6848\\u4f8b\",\"display\":1,\"vars\":{\"customer_catid\":{\"title\":\"\\u670d\\u52a1\\u6848\\u4f8b\\u5206\\u7c7bID\",\"value\":\"5,11\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u6848\\u4f8b\\u5c55\\u793a,\\u4e92\\u8054\\u7f51\\u884c\\u4e1a\"},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Success stories and customer shows\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`config_more`='{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"product_center\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\",\"display\":\"1\",\"vars\":{\"product_center_category_id\":{\"title\":\"\\u4ea7\\u54c1\\u4e2d\\u5fc3\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Recommended products and services\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_news\":{\"title\":\"\\u65b0\\u95fb\\u8d44\\u8baf\",\"display\":\"1\",\"vars\":{\"last_news_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Latest news and information\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"about_me\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\",\"display\":\"1\",\"vars\":{\"about_me_id\":{\"title\":\"\\u5173\\u4e8e\\u6211\\u4eec\\u9875\\u9762ID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Page\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9875\\u9762\",\"tip\":\"\",\"rule\":{\"require\":true}},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"About us and company introduction\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}},\"top_image\":{\"title\":\"\\u9876\\u90e8\\u56fe\\u7247\",\"value\":\"\",\"type\":\"image\",\"placeholder\":\"\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"customer_stories\":{\"title\":\"\\u670d\\u52a1\\u6848\\u4f8b\",\"display\":\"1\",\"vars\":{\"customer_catid\":{\"title\":\"\\u670d\\u52a1\\u6848\\u4f8b\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}},\"sub_title\":{\"title\":\"\\u526f\\u6807\\u9898\",\"value\":\"Success stories and customer shows\",\"type\":\"text\",\"placeholder\":\"\\u8bf7\\u8f93\\u5165\\u526f\\u6807\\u9898\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}',`description`='首頁(yè)模闆文(wén)件',`is_public`=0,`list_order`=5 WHERE `theme` = 'chenrong' AND `file` = 'portal/index' [ RunTime:0.004702s ]
[ SQL ] SELECT * FROM `demo_theme_file` WHERE `theme` = 'chenrong' AND `file` = 'portal/job' LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `demo_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000259s ]
[ SQL ] SELECT * FROM `demo_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 4 ORDER BY `list_order` ASC [ RunTime:0.000141s ]
[ SQL ] SHOW COLUMNS FROM `demo_portal_post` [ RunTime:0.000335s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `demo_portal_post` `post` INNER JOIN `demo_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` = '1' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1724891035 ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000284s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `demo_portal_post` `post` INNER JOIN `demo_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` = '1' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1724891035 ) GROUP BY `post`.`id` ORDER BY `is_top` DESC,`post`.`create_time` DESC LIMIT 6,6 [ RunTime:0.000406s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `demo_portal_post` `post` INNER JOIN `demo_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` IN (2,12,13,14,16) ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1724891035 ) GROUP BY `post`.`id` ORDER BY `recommended` DESC,`post`.`create_time` DESC LIMIT 6 [ RunTime:0.001109s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `demo_portal_post` `post` INNER JOIN `demo_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` IN (2,12,13,14,16) ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1724891035 ) GROUP BY `post`.`id` ORDER BY `post_hits` DESC,`post`.`create_time` DESC LIMIT 6 [ RunTime:0.001054s ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `demo_portal_post` `post` INNER JOIN `demo_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` IN (2,12,13,14,16) ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1724891035 ) GROUP BY `post`.`id` ORDER BY `post`.`create_time` DESC LIMIT 4 [ RunTime:0.001025s ]
