Research Report

ASIA BLOCKCHAIN GAMING ALLIANCE A Web3 Gaming alliance,co-sponsored by leading institutions in the gaming industry. We are optimistic about Web3 Games, NFTs and Metaverse, and we are taking the initiative to support lizi-related activities and investments.

基本文件流程错误 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/ReportController.php ( 1.77 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/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/d2a1a83d8f603f6df3ffa8f4794f5cfb.php ( 19.69 KB )
/www/wwwroot/abga/app/admin/model/RouteModel.php ( 6.45 KB )
/www/wwwroot/abga/app/portal/url.php ( 1.55 KB )
/www/wwwroot/abga/app/user/url.php ( 0.98 KB )
/www/wwwroot/abga/simplewind/extend/think/facade/Url.php ( 0.73 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Url.php ( 12.72 KB )
/www/wwwroot/abga/app/portal/service/ApiService.php ( 16.44 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/db/Expression.php ( 1.11 KB )
/www/wwwroot/abga/simplewind/cmf/paginator/Bootstrap.php ( 7.40 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/Paginator.php ( 9.75 KB )
/www/wwwroot/abga/simplewind/thinkphp/library/think/model/Collection.php ( 2.27 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.000400s ] mysql:host=localhost;port=3306;dbname=abga;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `en_portal_category` [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000534s ]
[ 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' => 80, 'filtered' => 1.25, '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.000335s ]
[ 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' => 80, 'filtered' => 1.25, '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.000325s ]
[ 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' => 80, 'filtered' => 1.25, '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.000312s ]
[ 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' => 80, 'filtered' => 1.25, '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.000289s ]
[ 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' => 80, 'filtered' => 1.25, '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.000316s ]
[ 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' => 80, 'filtered' => 1.25, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `id` = 4 AND `status` = 1 LIMIT 1 [ RunTime:0.000261s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000214s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'en_portal_category', 'partitions' => NULL, 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '8', 'ref' => 'const', 'rows' => 1, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000202s ]
[ 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 ] SHOW COLUMNS FROM `en_theme_file` [ RunTime:0.000841s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa' LIMIT 1 [ RunTime:0.000286s ]
[ 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.002160s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa_detail' LIMIT 1 [ RunTime:0.000241s ]
[ 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.001979s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000218s ]
[ 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.000785s ]
[ 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.001975s ]
[ SQL ] SELECT `more` FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/report' ) [ RunTime:0.000186s ]
[ 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_portal_post` [ RunTime:0.000967s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `en_portal_post` `post` INNER JOIN `en_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 ( `category_post`.`category_id` = '4' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714534657 ) GROUP BY `post`.`id` ) `_group_count_` LIMIT 1 [ RunTime:0.000576s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'PRIMARY', 'table' => '<derived2>', 'partitions' => NULL, 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 2, 'filtered' => 100.0, 'extra' => NULL, ) ]
[ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `en_portal_post` `post` INNER JOIN `en_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 ( `category_post`.`category_id` = '4' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714534657 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 0,8 [ RunTime:0.002922s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'category_post', 'partitions' => NULL, 'type' => 'ref', 'possible_keys' => 'term_taxonomy_id', 'key' => 'term_taxonomy_id', 'key_len' => '8', 'ref' => 'const', 'rows' => 38, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `en_option` [ RunTime:0.000707s ]
[ SQL ] SELECT `option_value` FROM `en_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000223s ]
[ 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', ) ]

0.074192s