ABGA

ABGA is a groundbreaking club centered around Web3 games

supported by prominent institutions in the Web3 industry. By integrating the collective strength of the Asian gaming industry, ABGA is dedicated to shaping a promising future for the global Web3 gaming sector.

Our Vision

Largest Global Blockchain Game Ecology

Unite the gaming

community through blockchain

ABGA members will enthusiastically participate in building blockchain game ecology and grow together with the industry. Combine the Asian power of the industry better to integrate it into the global blockchain game ecology. And work together to promote the vigorous development and future of the global blockchain game industry!

Achievement

Member

110+

Events

20+

Connection

200+

All Channel

Community

30000+

Media

Exposure

300+

Research

Reports

25+

Start-up Members

Honorary Diamond Members

Honorary Platinum Members

Honorary Start-up Members

Strategic Partners

Media & Community Partners

Events Overview

Monthly Showcase

WGS & Web3 Gaming Hackathon Series

WGS 2023 Speech & Panels

Web3 Gaming Grand Party 2023

Web3 Gaming Hackathon Final 2023

Industry Research

November's Web3 Gaming Snapshot

The gaming market is witnessing a renaissance, with a remarkable 34% surge......

2024 Plan

Asia Tour（January-September）

The ABGA Web3 Gaming Asia Tour is a Intercontinental series event aimed at promoting blockchain-based gaming. It is set to take place in various cities including Taibei、Kuala Lumpur、Hong Kong、Dubai、Ho Chi Minh、Kyoto、Seoul、Singapore.

ICC Camp S1（March to September）

Image Creation Combinator Camp (ICC Camp) is a startup camp focused on Web3 gaming entrepreneurship.

Web3 Gaming Summit 2024（September 16-17）

Web3 Gaming Summit 2024 is a premier event that brings together top leaders, investors, and innovators in the gaming and blockchain industries.

Produce More In-Depth and Accurate Research Reports（All Year）

ABGA is a groundbreaking club centered around Web3 games, supported by prominent institutions in the Web3 industry. By integrating the collective strength of the Asian gaming industry, ABGA is dedicated to shaping a promising future for the global Web3 gaming arena.

基本文件流程错误 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/IndexController.php ( 1.06 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/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/9600ebf9f262f38560630406bbad640e.php ( 38.78 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/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.000378s ] mysql:host=localhost;port=3306;dbname=abga;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `en_portal_category` [ RunTime:0.001215s ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000519s ]
[ 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.000355s ]
[ 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` = 97 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000348s ]
[ 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.000355s ]
[ 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.000330s ]
[ 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.000318s ]
[ 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.000477s ]
[ 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_theme_file` [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa' LIMIT 1 [ RunTime:0.000302s ]
[ 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.002533s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa_detail' LIMIT 1 [ RunTime:0.000226s ]
[ 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.001936s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000237s ]
[ 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.000813s ]
[ 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.002087s ]
[ SQL ] SELECT `more` FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/index' ) [ 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_portal_post` [ RunTime:0.000986s ]
[ 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` = '96' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 1 [ RunTime:0.000643s ]
[ 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' => 1, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ 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` = '106' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000479s ]
[ 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' => 8, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `en_option` [ RunTime:0.000681s ]
[ SQL ] SELECT `option_value` FROM `en_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000235s ]
[ 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.*,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` = '22' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000644s ]
[ 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' => 31, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ 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` = '23' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000535s ]
[ 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' => 21, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ 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` = '24' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000931s ]
[ 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' => 76, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ 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` = '28' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000408s ]
[ 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' => 4, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ 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` = '38' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000436s ]
[ 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' => 12, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ 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` = '32' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1728158438 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` DESC LIMIT 3 [ RunTime:0.000485s ]
[ 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' => 18, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]

0.078036s