[ SQL ] SELECT `post`.* FROM `demo_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` < '45' AND ( `post`.`published_time` < '1715872450' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000749s ]
[ SQL ] SELECT `post`.* FROM `demo_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` > '45' AND ( `post`.`published_time` < '1715872450' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000539s ]
[ SQL ] SHOW COLUMNS FROM `demo_portal_category_post` [ RunTime:0.001622s ]
[ SQL ] SHOW COLUMNS FROM `demo_portal_category` [ RunTime:0.001434s ]
[ SQL ] SELECT `demo_portal_category`.*,pivot.id AS pivot__id,pivot.post_id AS pivot__post_id,pivot.category_id AS pivot__category_id,pivot.list_order AS pivot__list_order,pivot.status AS pivot__status FROM `demo_portal_category` INNER JOIN `demo_portal_category_post` `pivot` ON `pivot`.`category_id`=`demo_portal_category`.`id` WHERE `pivot`.`post_id` = 45 [ RunTime:0.000790s ]
[ SQL ] UPDATE `demo_theme_file` SET `theme`='chenrong',`action`='portal/Index/index',`file`='portal/index',`name`='首页',`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`='首页模板文件',`is_public`=0,`list_order`=5 WHERE `theme` = 'chenrong' AND `file` = 'portal/index' [ RunTime:0.051734s ]
[ SQL ] SELECT * FROM `demo_theme_file` WHERE `theme` = 'chenrong' AND `file` = 'portal/job' LIMIT 1 [ RunTime:0.000551s ]
