Exploring how AI technology revolutionizes portfolio optimization and wealth management models, analyzing how data-driven decisions reshape investment strategies for Chinese investors in Malaysia, Singapore, and Thailand, and breakthrough applications of AI in risk management.
基本文件流程错误SQL调试
请求信息 : 2026-09-29 18:15:53 HTTP/1.1 GET : https://www.thaiptt.asia/ai-driven-portfolio-optimization-data-driven-wealth-management-revolution
SHOW FULL COLUMNS FROM `g3ys_config` [ RunTime:0.002394s ]
SELECT `value` FROM `g3ys_config` WHERE `name` = 'timezone' AND `subsite_id` = '43' LIMIT 1 [ RunTime:0.000718s ]
SHOW FULL COLUMNS FROM `g3ys_route` [ RunTime:0.002877s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '43' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000763s ]
SHOW FULL COLUMNS FROM `g3ys_theme` [ RunTime:0.002976s ]
SELECT `paginator` FROM `g3ys_theme` WHERE `module` = 'home' AND `name` = 'stashaway' AND `subsite_id` = '43' LIMIT 1 [ RunTime:0.000789s ]
SHOW FULL COLUMNS FROM `g3ys_lang` [ RunTime:0.002968s ]
SELECT * FROM `g3ys_lang` WHERE `subsite_id` = 43 AND ( ( LOWER(name) = 'en' ) OR `subtag` = 'en' ) AND `status` = 1 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001266s ]
SHOW FULL COLUMNS FROM `g3ys_member` [ RunTime:0.004816s ]
SELECT * FROM `g3ys_member` WHERE `id` = 0 AND `subsite_id` = '43' LIMIT 1 [ RunTime:0.001195s ]
SHOW FULL COLUMNS FROM `g3ys_document` [ RunTime:0.004505s ]
SELECT `id`,`document_type` FROM `g3ys_document` WHERE `subsite_id` = 43 AND `name` = 'ai-driven-portfolio-optimization-data-driven-wealth-management-revolution' AND `status` IN ('1','2') LIMIT 1 [ RunTime:0.003272s ]
SELECT * FROM `g3ys_document` WHERE ( `name` = '7292' OR `id` = '7292' ) AND `subsite_id` = 43 LIMIT 1 [ RunTime:0.010848s ]
SHOW TABLES LIKE 'g3ys_document_article' [ RunTime:0.002785s ]
SHOW FULL COLUMNS FROM `g3ys_document_article` [ RunTime:0.001558s ]
SELECT * FROM `g3ys_document_article` WHERE `document_id` = '7292' LIMIT 1 [ RunTime:0.000742s ]
SHOW FULL COLUMNS FROM `g3ys_total` [ RunTime:0.002057s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '7292' LIMIT 1 [ RunTime:0.000673s ]
SHOW TABLES LIKE 'g3ys_document_article_lang' [ RunTime:0.002219s ]
SHOW FULL COLUMNS FROM `g3ys_document_article_lang` [ RunTime:0.003149s ]
SELECT * FROM `g3ys_document_article_lang` WHERE `subsite_id` = '43' AND `lang` = 'en' AND `document_id` = '7292' [ RunTime:0.008877s ]
SHOW FULL COLUMNS FROM `g3ys_document_article_lang` [ RunTime:0.002279s ]
SHOW TABLES LIKE 'g3ys_category_lang' [ RunTime:0.003098s ]
SHOW FULL COLUMNS FROM `g3ys_category_lang` [ RunTime:0.002072s ]
SELECT * FROM `g3ys_category_lang` WHERE `subsite_id` = '43' AND `category_id` = '1626' AND `lang` = 'en' LIMIT 1 [ RunTime:0.000996s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '7292' LIMIT 1 [ RunTime:0.000692s ]
UPDATE `g3ys_total` SET `view_total` = `view_total` + 1 WHERE `target_id` = '7292' [ RunTime:0.006752s ]
SHOW FULL COLUMNS FROM `g3ys_record` [ RunTime:0.003964s ]
SELECT `id` FROM `g3ys_record` WHERE `subsite_id` = '43' AND `type` = 'article' AND `url` = 'https://www.thaiptt.asia/ai-driven-portfolio-optimization-data-driven-wealth-management-revolution' AND `create_time` >= 1790676893 AND ( `visitor_id` = '9345050370e232d544a9ec27dc8204da' OR `session_id` = 'c8aadbdde00a1c8405032f8faec82d97' ) LIMIT 1 [ RunTime:0.002677s ]
SHOW FULL COLUMNS FROM `g3ys_comment` [ RunTime:0.003370s ]
SELECT COUNT(*) AS think_count FROM `g3ys_comment` WHERE `target_id` = '7292' AND `pid` = '0' [ RunTime:0.001093s ]
SHOW FULL COLUMNS FROM `g3ys_model` [ RunTime:0.004929s ]
SELECT `id`,`name`,`title`,`field_group` FROM `g3ys_model` WHERE `extend` = 0 AND `id` <> 1 AND `subsite_id` IN ('0','43') AND `status` = 1 [ RunTime:0.001619s ]
SHOW TABLES LIKE 'g3ys_paragraph' [ RunTime:0.003114s ]
SHOW TABLES LIKE 'g3ys_paragraph_lang' [ RunTime:0.002198s ]
SHOW TABLES LIKE 'g3ys_gallery' [ RunTime:0.002071s ]
SHOW TABLES LIKE 'g3ys_gallery_lang' [ RunTime:0.002027s ]
SHOW TABLES LIKE 'g3ys_video' [ RunTime:0.002020s ]
SHOW TABLES LIKE 'g3ys_video_lang' [ RunTime:0.002053s ]
SHOW TABLES LIKE 'g3ys_faq' [ RunTime:0.001964s ]
SHOW TABLES LIKE 'g3ys_faq_lang' [ RunTime:0.002037s ]
SHOW TABLES LIKE 'g3ys_blockquote' [ RunTime:0.002698s ]
SHOW TABLES LIKE 'g3ys_blockquote_lang' [ RunTime:0.002099s ]
SHOW TABLES LIKE 'g3ys_cards' [ RunTime:0.002059s ]
SHOW TABLES LIKE 'g3ys_cards_lang' [ RunTime:0.001923s ]
SHOW TABLES LIKE 'g3ys_objects' [ RunTime:0.002015s ]
SHOW TABLES LIKE 'g3ys_objects_lang' [ RunTime:0.001949s ]
SHOW TABLES LIKE 'g3ys_videos' [ RunTime:0.002042s ]
SHOW TABLES LIKE 'g3ys_videos_lang' [ RunTime:0.001952s ]
SHOW TABLES LIKE 'g3ys_audios' [ RunTime:0.002004s ]
SHOW TABLES LIKE 'g3ys_audios_lang' [ RunTime:0.002369s ]
SHOW TABLES LIKE 'g3ys_files' [ RunTime:0.002231s ]
SHOW TABLES LIKE 'g3ys_files_lang' [ RunTime:0.001981s ]
SHOW TABLES LIKE 'g3ys_richmedia' [ RunTime:0.001992s ]
SHOW TABLES LIKE 'g3ys_richmedia_lang' [ RunTime:0.001940s ]
SHOW FULL COLUMNS FROM `g3ys_paragraph` [ RunTime:0.002193s ]
SELECT * FROM `g3ys_paragraph` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000942s ]
SHOW FULL COLUMNS FROM `g3ys_gallery` [ RunTime:0.002002s ]
SELECT * FROM `g3ys_gallery` WHERE `document_id` = 7292 AND `subsite_id` = 43 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000979s ]
SHOW FULL COLUMNS FROM `g3ys_video` [ RunTime:0.001997s ]
SELECT * FROM `g3ys_video` WHERE `document_id` = 7292 AND `subsite_id` = 43 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000808s ]
SHOW FULL COLUMNS FROM `g3ys_faq` [ RunTime:0.002335s ]
SELECT * FROM `g3ys_faq` WHERE `document_id` = 7292 AND `subsite_id` = 43 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001092s ]
SHOW FULL COLUMNS FROM `g3ys_blockquote` [ RunTime:0.002302s ]
SELECT * FROM `g3ys_blockquote` WHERE `document_id` = 7292 AND `subsite_id` = 43 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000914s ]
SHOW FULL COLUMNS FROM `g3ys_cards` [ RunTime:0.002308s ]
SELECT * FROM `g3ys_cards` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000858s ]
SHOW FULL COLUMNS FROM `g3ys_objects` [ RunTime:0.002106s ]
SELECT * FROM `g3ys_objects` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000877s ]
SHOW FULL COLUMNS FROM `g3ys_videos` [ RunTime:0.002124s ]
SELECT * FROM `g3ys_videos` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000861s ]
SHOW FULL COLUMNS FROM `g3ys_audios` [ RunTime:0.002349s ]
SELECT * FROM `g3ys_audios` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000978s ]
SHOW FULL COLUMNS FROM `g3ys_files` [ RunTime:0.003427s ]
SELECT * FROM `g3ys_files` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000992s ]
SHOW FULL COLUMNS FROM `g3ys_richmedia` [ RunTime:0.002445s ]
SELECT * FROM `g3ys_richmedia` WHERE `document_id` = 7292 AND `subsite_id` = '43' AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000959s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 1626 AND `subsite_id` = 43 AND `pid` = '0' AND `status` = '1' AND ( ( sort > 0) or ( sort = 0 and id < 7292) ) ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.001839s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 1626 AND `subsite_id` = 43 AND `pid` = '7235' AND `status` = '1' ORDER BY `sort` ASC,`id` DESC LIMIT 1 [ RunTime:0.001382s ]
SELECT * FROM `g3ys_document_article_lang` WHERE `subsite_id` = '43' AND `lang` = 'en' AND `document_id` = '7235' [ RunTime:0.010287s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 1626 AND `subsite_id` = 43 AND `pid` = '7292' AND `status` = '1' AND `document_type` = 0 ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001753s ]
SELECT * FROM `g3ys_document` WHERE `category_id` = 1626 AND `subsite_id` = 43 AND `pid` = '0' AND `status` = '1' AND `document_type` = 0 AND ( ( sort>0 and sort <= 0 and id!=7292) or ( sort = 0 and id > 7292) ) ORDER BY `sort` DESC,`id` ASC LIMIT 1 [ RunTime:0.001640s ]
SELECT * FROM `g3ys_document_article_lang` WHERE `subsite_id` = '43' AND `lang` = 'en' AND `document_id` = '7314' [ RunTime:0.008770s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '43' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.001253s ]
SHOW FULL COLUMNS FROM `g3ys_file` [ RunTime:0.003544s ]
SELECT * FROM `g3ys_file` WHERE `status` = 1 AND `id` = 6748 LIMIT 1 [ RunTime:0.000972s ]
SELECT * FROM `g3ys_total` WHERE `target_id` = '7292' LIMIT 1 [ RunTime:0.000741s ]
SHOW FULL COLUMNS FROM `g3ys_ad_location` [ RunTime:0.002714s ]
SELECT * FROM `g3ys_ad_location` WHERE `name` = 'ad-detail-full' AND `subsite_id` = '43' AND `status` = 1 LIMIT 1 [ RunTime:0.000830s ]
SHOW FULL COLUMNS FROM `g3ys_ad` [ RunTime:0.002534s ]
SELECT * FROM `g3ys_ad` WHERE `subsite_id` = '43' AND `ad_location_id` = '95' AND `status` = 1 AND `device` IN ('all','pc') AND ( `start_time` = 0 OR `start_time` <= 1790676953 ) AND ( `end_time` = 0 OR `end_time` >= 1790676953 ) ORDER BY `sort` DESC,`id` DESC [ RunTime:0.001063s ]
SHOW FULL COLUMNS FROM `g3ys_ad_lang` [ RunTime:0.001858s ]
SELECT * FROM `g3ys_ad_lang` WHERE `ad_id` = 95 AND `subsite_id` = '43' AND `lang` = 'en' [ RunTime:0.000766s ]
SHOW FULL COLUMNS FROM `g3ys_ad_lang` [ RunTime:0.001809s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '43' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000961s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '43' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000746s ]
SELECT * FROM `g3ys_route` WHERE ( `subsite_id` = '43' OR `subsite_id` = '0' ) AND `module` = 'home' AND `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000864s ]