CCTP is a non-governmental, non-profit, and voluntary platform, focusing on policy and technological innovations, summarizing and disseminating national and global practices for a net-zero transportation sector.
基本文件流程错误SQL调试
请求信息 : 2024-09-19 09:00:25 HTTP/1.1 GET : ctp.dowv.cn/InternationalPolicy.html?category=value4&orderway=desc&year=value13
[ BEHAVIOR ] Run \addons\cms\Cms @view_filter [ RunTime:0.000247s ]
[ DB ] CONNECT:[ UseTime:0.003099s ] mysql:host=127.0.0.1;dbname=cctp1_dowv_cn;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `fa_city` [ RunTime:0.001208s ]
[ SQL ] SELECT * FROM `fa_city` ORDER BY `rid`,`weight` DESC [ RunTime:0.000305s ]
[ SQL ] SHOW COLUMNS FROM `fa_cms_fields` [ RunTime:0.000933s ]
[ SQL ] UPDATE `fa_cms_fields` SET `content`='value37|新西兰\r\nvalue36|印尼\r\nvalue35|泰国\r\nvalue34|斯里兰卡\r\nvalue33|巴基斯坦\r\nvalue32|印度\r\nvalue8|澳大利亚\r\nvalue4|日本\r\nvalue7|新加坡\r\nvalue1|韩国\r\nvalue45|意大利\r\nvalue44|捷克共和国\r\nvalue43|拉脱维亚\r\nvalue42|西班牙\r\nvalue41|荷兰\r\nvalue40|芬兰\r\nvalue39|瑞典\r\nvalue38|挪威\r\nvalue31|奥地利\r\nvalue30|波兰\r\nvalue29|土耳其\r\nvalue28|比利时\r\nvalue27|爱尔兰\r\nvalue26|希腊\r\nvalue25|捷克\r\nvalue24|斯洛文尼亚\r\nvalue23|丹麦\r\nvalue22|葡萄牙\r\nvalue21|卢森堡\r\nvalue20|法国\r\nvalue19|欧盟\r\nvalue5|欧盟\r\nvalue6|英国\r\nvalue9|德国\r\nvalue12|肯尼亚\r\nvalue11|南非\r\nvalue10|卢旺达\r\nvalue14|加拿大\r\nvalue13|美国\r\nvalue17|智利\r\nvalue16|巴西\r\nvalue15|阿根廷\r\nvalue18|沙特阿拉伯\r\n',`filterlist`='value37|新西兰\r\nvalue36|印尼\r\nvalue35|泰国\r\nvalue34|斯里兰卡\r\nvalue33|巴基斯坦\r\nvalue32|印度\r\nvalue8|澳大利亚\r\nvalue4|日本\r\nvalue7|新加坡\r\nvalue1|韩国\r\nvalue45|意大利\r\nvalue44|捷克共和国\r\nvalue43|拉脱维亚\r\nvalue42|西班牙\r\nvalue41|荷兰\r\nvalue40|芬兰\r\nvalue39|瑞典\r\nvalue38|挪威\r\nvalue31|奥地利\r\nvalue30|波兰\r\nvalue29|土耳其\r\nvalue28|比利时\r\nvalue27|爱尔兰\r\nvalue26|希腊\r\nvalue25|捷克\r\nvalue24|斯洛文尼亚\r\nvalue23|丹麦\r\nvalue22|葡萄牙\r\nvalue21|卢森堡\r\nvalue20|法国\r\nvalue19|欧盟\r\nvalue5|欧盟\r\nvalue6|英国\r\nvalue9|德国\r\nvalue12|肯尼亚\r\nvalue11|南非\r\nvalue10|卢旺达\r\nvalue14|加拿大\r\nvalue13|美国\r\nvalue17|智利\r\nvalue16|巴西\r\nvalue15|阿根廷\r\nvalue18|沙特阿拉伯\r\n' WHERE `source` = 'model' AND `source_id` = 11 AND `name` = 'country' [ RunTime:0.002165s ]
[ SQL ] UPDATE `fa_cms_fields` SET `content`='value37|New Zealand\r\nvalue36|Indonesia\r\nvalue35|Thailand\r\nvalue34|Sri Lanka\r\nvalue33|Pakistan\r\nvalue32|India\r\nvalue8|Australia\r\nvalue4|Japan\r\nvalue7|Singapore\r\nvalue1|Korea\r\nvalue45|Italy\r\nvalue44|Czech Republic\r\nvalue43|Latvia\r\nvalue42|Spain\r\nvalue41|Netherlands\r\nvalue40|Finland\r\nvalue39|Sweden\r\nvalue38|Norway\r\nvalue31|Austria\r\nvalue30|Poland\r\nvalue29|Turkey\r\nvalue28|Belgium\r\nvalue27|Ireland\r\nvalue26|Greece\r\nvalue25|Chech\r\nvalue24|Slovenia\r\nvalue23|Danmark\r\nvalue22|Portugal\r\nvalue21|Luxembourg\r\nvalue20|France\r\nvalue19|EU\r\nvalue5|european union\r\nvalue6|UK\r\nvalue9|Germany\r\nvalue12|Kenya\r\nvalue11|South Africa\r\nvalue10|Rwanda\r\nvalue14|Canada\r\nvalue13|America\r\nvalue17|Chile\r\nvalue16|Brazil\r\nvalue15|Argentina\r\nvalue18|Saudi Arabia\r\n',`filterlist`='value37|New Zealand\r\nvalue36|Indonesia\r\nvalue35|Thailand\r\nvalue34|Sri Lanka\r\nvalue33|Pakistan\r\nvalue32|India\r\nvalue8|Australia\r\nvalue4|Japan\r\nvalue7|Singapore\r\nvalue1|Korea\r\nvalue45|Italy\r\nvalue44|Czech Republic\r\nvalue43|Latvia\r\nvalue42|Spain\r\nvalue41|Netherlands\r\nvalue40|Finland\r\nvalue39|Sweden\r\nvalue38|Norway\r\nvalue31|Austria\r\nvalue30|Poland\r\nvalue29|Turkey\r\nvalue28|Belgium\r\nvalue27|Ireland\r\nvalue26|Greece\r\nvalue25|Chech\r\nvalue24|Slovenia\r\nvalue23|Danmark\r\nvalue22|Portugal\r\nvalue21|Luxembourg\r\nvalue20|France\r\nvalue19|EU\r\nvalue5|european union\r\nvalue6|UK\r\nvalue9|Germany\r\nvalue12|Kenya\r\nvalue11|South Africa\r\nvalue10|Rwanda\r\nvalue14|Canada\r\nvalue13|America\r\nvalue17|Chile\r\nvalue16|Brazil\r\nvalue15|Argentina\r\nvalue18|Saudi Arabia\r\n' WHERE `source` = 'model' AND `source_id` = 13 AND `name` = 'country' [ RunTime:0.001935s ]
[ SQL ] SHOW COLUMNS FROM `fa_cms_channel` [ RunTime:0.001066s ]
[ SQL ] SELECT * FROM `fa_cms_channel` WHERE `diyname` = 'InternationalPolicy' LIMIT 1 [ RunTime:0.000405s ]
[ SQL ] SHOW COLUMNS FROM `fa_cms_model` [ RunTime:0.000829s ]
[ SQL ] SELECT * FROM `fa_cms_model` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `information_schema`.`columns` WHERE TABLE_SCHEMA = 'cctp1_dowv_cn' AND TABLE_NAME = 'fa_cms_archives' ORDER BY ORDINAL_POSITION [ RunTime:0.001359s ]
[ SQL ] SELECT * FROM `fa_cms_model` WHERE `id` = 13 LIMIT 1 [ RunTime:0.000400s ]
[ SQL ] SHOW COLUMNS FROM `fa_cms_addonguojiying` [ RunTime:0.001267s ]
[ SQL ] SHOW COLUMNS FROM `fa_cms_archives` [ RunTime:0.001854s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_cms_archives` `a` LEFT JOIN `fa_cms_addonguojiying` `n` ON `a`.`id`=`n`.`id` WHERE ( `a`.`status` = 'normal' AND `a`.`deletetime` IS NULL AND ( ( ( FIND_IN_SET('value4', `category`) ) ) AND ( `year` = 'value13' ) ) AND ( ( `channel_id` = 62 ) OR ( (`channel_ids`!='' AND FIND_IN_SET('62', `channel_ids`)) ) ) AND `model_id` = 13 ) AND `a`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001135s ]
[ SQL ] SELECT `a`.*,`n`.`country`,`n`.`year`,`n`.`category`,`n`.`link`,`n`.`zt`,`n`.`zhou` FROM `fa_cms_archives` `a` LEFT JOIN `fa_cms_addonguojiying` `n` ON `a`.`id`=`n`.`id` WHERE ( `a`.`status` = 'normal' AND `a`.`deletetime` IS NULL AND ( ( ( FIND_IN_SET('value4', `category`) ) ) AND ( `year` = 'value13' ) ) AND ( ( `channel_id` = 62 ) OR ( (`channel_ids`!='' AND FIND_IN_SET('62', `channel_ids`)) ) ) AND `model_id` = 13 ) AND `a`.`deletetime` IS NULL ORDER BY `weigh` DESC,`publishtime` DESC LIMIT 0,1000 [ RunTime:0.001798s ]
[ SQL ] SELECT * FROM `fa_cms_channel` WHERE `id` IN (62) [ RunTime:0.000366s ]
[ SQL ] SHOW COLUMNS FROM `fa_user` [ RunTime:0.000981s ]
[ SQL ] SELECT * FROM `fa_user` WHERE `id` IN (0) [ RunTime:0.000337s ]
[ SQL ] SHOW COLUMNS FROM `fa_region` [ RunTime:0.000890s ]
[ SQL ] SELECT * FROM `fa_region` ORDER BY `weight` DESC [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `fa_city` ORDER BY `weight` DESC [ RunTime:0.000280s ]
[ SQL ] SELECT `outlink`,`parent_id` FROM `fa_cms_channel` WHERE `type` = 'link' AND `status` = 'normal' [ RunTime:0.000465s ]
