Recent Activities

ABGA Weekly Talk 2022/06/02

ABGA Weekly Talk

Topic：StepN Is At Stake！Gamefi In Bear Market: Dormant Or Step Forward?

June 2nd 14:00 (UTC +8)

KOL & Gamefi Projects’ sharpest view

AI Blockchain Global Alliance — a broader platform connecting builders, capital, communities, and ecosystem partners across AI, Web3, RWA, and emerging digital infrastructure.

基本文件流程错误 SQL 调试

/www/wwwroot/abga/public/index.php ( 0.82 KB )
/www/wwwroot/abga/simplewind/thinkphp/base.php ( 2.60 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Loader.php ( 21.07 KB )
/www/wwwroot/abga/simplewind/vendor/composer/autoload_static.php ( 5.33 KB )
/www/wwwroot/abga/simplewind/vendor/topthink/think-helper/src/helper.php ( 2.88 KB )
/www/wwwroot/abga/simplewind/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php ( 0.10 KB )
/www/wwwroot/abga/simplewind/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Route.php ( 60.23 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Config.php ( 6.38 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Validate.php ( 41.63 KB )
/www/wwwroot/abga/simplewind/vendor/topthink/think-queue/src/common.php ( 1.19 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Console.php ( 23.13 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Error.php ( 3.75 KB )
/www/wwwroot/abga/simplewind/thinkphp/convention.php ( 10.37 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/App.php ( 21.54 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Request.php ( 49.78 KB )
/www/wwwroot/abga/app/config.php ( 9.68 KB )
/www/wwwroot/abga/data/conf/config.php ( 0.11 KB )
/www/wwwroot/abga/app/database.php ( 0.74 KB )
/www/wwwroot/abga/data/conf/database.php ( 0.50 KB )
/www/wwwroot/abga/app/debug.php ( 0.69 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Hook.php ( 4.71 KB )
/www/wwwroot/abga/app/tags.php ( 1.33 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Env.php ( 1.21 KB )
/www/wwwroot/abga/simplewind/cmf/common.php ( 58.12 KB )
/www/wwwroot/abga/simplewind/thinkphp/helper.php ( 17.30 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Debug.php ( 7.13 KB )
/www/wwwroot/abga/simplewind/cmf/behavior/InitHookBehavior.php ( 2.58 KB )
/www/wwwroot/abga/simplewind/extend/think/facade/Route.php ( 0.74 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Cache.php ( 6.10 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Log.php ( 6.05 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/cache/driver/File.php ( 7.27 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Collection.php ( 10.91 KB )
/www/wwwroot/abga/simplewind/extend/think/facade/Hook.php ( 1.46 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Lang.php ( 7.23 KB )
/www/wwwroot/abga/simplewind/thinkphp/lang/zh-cn.php ( 11.81 KB )
/www/wwwroot/abga/app/route.php ( 0.76 KB )
/www/wwwroot/abga/data/conf/route.php ( 0.06 KB )
/www/wwwroot/abga/simplewind/cmf/behavior/LangBehavior.php ( 1.20 KB )
/www/wwwroot/abga/simplewind/extend/think/facade/Lang.php ( 0.73 KB )
/www/wwwroot/abga/simplewind/cmf/lang/zh-cn.php ( 3.08 KB )
/www/wwwroot/abga/app/admin/lang/zh-cn/common.php ( 0.60 KB )
/www/wwwroot/abga/app/portal/lang/zh-cn/common.php ( 0.76 KB )
/www/wwwroot/abga/app/portal/lang/zh-cn.php ( 0.93 KB )
/www/wwwroot/abga/simplewind/cmf/behavior/InitAppHookBehavior.php ( 2.03 KB )
/www/wwwroot/abga/app/portal/controller/ArticleController.php ( 4.17 KB )
/www/wwwroot/abga/simplewind/cmf/controller/HomeBaseController.php ( 9.70 KB )
/www/wwwroot/abga/simplewind/cmf/controller/BaseController.php ( 2.50 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Controller.php ( 6.07 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Cookie.php ( 7.54 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/View.php ( 6.77 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Template.php ( 44.90 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/www/wwwroot/abga/app/portal/model/PortalPostModel.php ( 11.49 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Model.php ( 69.14 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Db.php ( 6.67 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/db/Connection.php ( 29.97 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/db/Query.php ( 93.74 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/db/builder/Mysql.php ( 4.53 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/db/Builder.php ( 31.55 KB )
/www/wwwroot/abga/simplewind/cmf/behavior/HomeLangBehavior.php ( 1.09 KB )
/www/wwwroot/abga/app/portal/lang/zh-cn/home.php ( 0.62 KB )
/www/wwwroot/abga/app/portal/model/PortalCategoryModel.php ( 8.95 KB )
/www/wwwroot/abga/app/portal/service/PostService.php ( 9.06 KB )
/www/wwwroot/abga/app/portal/service/PostServices.php ( 9.06 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/model/relation/BelongsToMany.php ( 19.27 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/model/Relation.php ( 3.61 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/model/Pivot.php ( 1.17 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/model/Collection.php ( 2.27 KB )
/www/wwwroot/abga/app/admin/model/ThemeModel.php ( 8.12 KB )
/www/wwwroot/abga/app/portal/taglib/Portal.php ( 9.40 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/template/TagLib.php ( 12.30 KB )
/www/wwwroot/abga/simplewind/cmf/lib/taglib/Cmf.php ( 11.62 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/template/taglib/Cx.php ( 23.82 KB )
/www/wwwroot/abga/data/runtime/temp/16d4c4f12ba919f14e9b8448fc56c2b5.php ( 22.03 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery.php ( 41.76 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/DOMEvent.php ( 2.25 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/DOMDocumentWrapper.php ( 22.46 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/phpQueryEvents.php ( 4.85 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/Callback.php ( 4.02 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/phpQueryObject.php ( 87.75 KB )
/www/wwwroot/abga/simplewind/vendor/electrolinux/phpquery/phpQuery/phpQuery/compat/mbstring.php ( 1.51 KB )
/www/wwwroot/abga/simplewind/cmf/lib/Storage.php ( 3.89 KB )
/www/wwwroot/abga/simplewind/cmf/lib/storage/Local.php ( 2.86 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Response.php ( 8.28 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/debug/Html.php ( 4.17 KB )

[ DB ] CONNECT:[ UseTime:0.160589s ] mysql:host=localhost;port=3306;dbname=abga;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `en_portal_category` [ RunTime:0.001938s ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000784s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `parent_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000684s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `parent_id` = 114 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000680s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `parent_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000620s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `parent_id` = 3 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.012559s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `parent_id` = 4 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000730s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `parent_id` = 43 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.017244s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 89, 'filtered' => 1.1235954761505127, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `en_portal_post` [ RunTime:0.068461s ]
[ SQL ] SELECT `post`.* FROM `en_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` = '291' AND ( `post`.`published_time` < '1781094861' and `post`.`published_time` > '0' ) LIMIT 1 [ RunTime:0.113819s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY,type_status_date', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `id` = 0 AND `status` = 1 LIMIT 1 [ RunTime:0.081104s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000461s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]
[ SQL ] SELECT `post`.* FROM `en_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` < '291' AND ( `post`.`published_time` < '1781094861' and `post`.`published_time` > '0' ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.068839s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,type_status_date', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 276, 'filtered' => 0.9640425443649292, 'extra' => 'Using where; Backward index scan', ) ]
[ SQL ] SELECT `post`.* FROM `en_portal_post` `post` WHERE `post`.`post_type` = 1 AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` > '291' AND ( `post`.`published_time` < '1781094862' and `post`.`published_time` > '0' ) ORDER BY `id` ASC LIMIT 1 [ RunTime:0.032958s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'post', 'partitions' => NULL, 'type' => 'range', 'possible_keys' => 'PRIMARY,type_status_date', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => NULL, 'rows' => 669, 'filtered' => 0.9640425443649292, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `en_portal_category_post` [ RunTime:0.084035s ]
[ SQL ] SELECT `en_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 `en_portal_category` INNER JOIN `en_portal_category_post` `pivot` ON `pivot`.`category_id`=`en_portal_category`.`id` WHERE `pivot`.`post_id` = 291 [ RunTime:0.001350s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'pivot', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => 'term_taxonomy_id', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1039, 'filtered' => 10.0, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `en_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 291 [ RunTime:0.054965s ]
[ SQL ] SHOW COLUMNS FROM `en_theme_file` [ RunTime:0.269720s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa' LIMIT 1 [ RunTime:0.000837s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `en_theme_file` SET `theme`='simpleboot3',`action`='portal/List/index',`file`='portal/aaa',`name`='默认列表模板',`more`='[]',`config_more`='[]',`description`='aaa',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa' [ RunTime:0.003646s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa_detail' LIMIT 1 [ RunTime:0.000740s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] UPDATE `en_theme_file` SET `theme`='simpleboot3',`action`='portal/Article/index',`file`='portal/aaa_detail',`name`='默认详情模板',`more`='[]',`config_more`='[]',`description`='aaa_detail',`is_public`=0,`list_order`=10 WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa_detail' [ RunTime:0.035484s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000697s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `en_theme` [ RunTime:0.002057s ]
[ SQL ] UPDATE `en_theme` SET `name`='simpleboot3',`version`='1.0.2',`demo_url`='http://demo.thinkcmf.com',`author`='ThinkCMF',`lang`='zh-cn',`author_url`='http://www.thinkcmf.com',`keywords`='ThinkCMF模板',`description`='ThinkCMF默认模板' WHERE `theme` = 'simpleboot3' [ RunTime:0.041683s ]
[ SQL ] SELECT `more` FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/article' ) [ RunTime:0.000723s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_theme_file', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 50.0, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `en_option` [ RunTime:0.546312s ]
[ SQL ] SELECT `option_value` FROM `en_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000377s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => NULL, 'partitions' => NULL, 'type' => NULL, 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => NULL, 'filtered' => NULL, 'extra' => 'no matching row in const table', ) ]

3.384717s