Blockchain Gaming 2022

What is Blockchain Gaming 2022

Blockchain Gaming 2022 is a gathering of the blockchain and gaming industry’s most established companies and representatives. The Blockchain Gaming 2022 conference fuses the fastest-growing industries in the technology sector under one event and aims to uncover untapped potential outside the world of Gaming, NFTs, and the Metaverse.

4000+

participants

150+

Media reports

50+

Chain tour buiilder partners

Investment Opportunities

Corporate Relationships

Public Curiosity

Networking & Partnerships

Keynote Speakers

Timeline

Hackcthon Demo Day

26th Sep 14:00-18:00(UTC+8)

Hackathon Award Ceremony & Welcome Dinner

26th Sep 19:30-21:30(UTC+8)

Blockchain Gaming Summit 2022

27th Sep 09:30-18:00(UTC+8)

Blockchain Gaming 2022 After Party

26th Sep 14:00-18:00(UTC+8)

Click the image to view

Speakers

Robbie Ferguson

Co-Founder Immutable

Beryl Li

Co-founder YGG

Marvin

Chief Scientist iPolloverse

Kevin Shao

Executive President ABGA

Simon LI

Co-Founder Chain Capital

Simon Jeung

General Partner HG Ventures

Kelly Choo

Founding Partner True Global Ventures

Michael Chen

Co-Founder Lead Capital

Xiao Xiao

Investment Director Hashkey

Calvin Ng

Investor and President Candy Club

Jenny Zheng

BD Lead Bybit NFT

Lawrence Lin

Head of Blockchain Razer

Calvin Ryu

Director of Business Development XLgames

Andy Xiang

CEO Fun Topia

Paul

CEO XPLA / C2X

Freddie

Head of Growth NodeReal

Yoshi Shin

Game partnership lead Klaytn

Wilson

Head of Asia Avalanche

Cora

Head of China Polygon

Alvin

Director of Business Operations BNB Chain

Gagan Palrecha

CEO NFTStar

Mary Ma

Co-founder & CSO MixMarvel

Mark

CFO Monsta Infinite

Sandy Carter

SVP Unstoppable Domains

Arief Widhiyasa

Chief Executive Officer Mythic Protocol

Lester

Founder Degame

Elliot Park

Senior Marketing Manager Marblex

Ade Rinaldi

Chief Growth Officer, Mythic Protocol

Kevin O’Hara

Co-Founder Polemos

BM Rojanarowan

CEO SavannaSurvival

Agenda

13:00-18:00

Hackathon DEMO Day

19:30-20:30

Awards Ceremony

20:30-21:15

Round Table - New Trend in Blockchain Gaming

Alex (Cryptomeria Labs) – Moderator

May (Spark digital capital)

Yoshi (Klaytn)

Prakash (Enjinstarter)

Calvin (Plutus.V.C.)

Gagan (NFTSTAR)

Agenda

9:35-9:55

Chairman's Address - Create A Better Future For Blockchain Game

ABGA Executive President

9:55-10:15

Speech - Sports and Metaverse: Bringing the world of sports fans together with immersive experiences

NFTSTAR

10:15-10:35

Speech - Digital Identity - Unlock the Power of Blockchain Game

Unstoppable Domains

10:35-10:55

Speech - Rendering：From Cloud Computing to Meta Computing

iPolloverse

10:55-11:40

Round Table - What Blockchain Technology Can Bring To Traditi

Bybit NFT (Host)

Razer

XLgames

Fun Topia

XPLA

11:40-12:00

Speech - Contribute-to-Earn, a thesis for sustainable economy

Mythic Protocol

14:00-14:20

Speech - The Opportunities in Blockchain Gaming

Immutable

14:20-14:40

Speech - Gamefi and Economic Model

Monsta Infinite

14:40-15:25

Round Table - The Future Of Blockchain Games - From The Pers

NodeReal (Host)

Klaytn

Avalanche

Polygon

BNB Chain

15:25-15:45

Speech - Why Blockchain Games Need Gaming Guilds

YGG

15:45-16:05

Speech - How To Fight The Bears?

Candy Club

16:05-16:50

Round Table - The Blockchain Gaming Ecosystem in Different Cou

DeGame (Host)

Marblex

Mythic Protocol

Polemos

SavannaSurviv

16:50-17:10

Speech - Web3 MMO Games: the Metaverse Express

MixMarvel

17:10-17:55

Round Table - Investment Strategies In Blockchain Gaming

Chain Capital (Host)

HG Ventures

Lead Capital

True Global Ven

Hashkey

Organizer

Title Sponsor

Sponsored

ABGA Diamond & Platinum Members

The ranking order is based on the first letter of the name

On-Site Media Partners

The ranking order is based on the first letter of the name

Media & Community Partners

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/BlockchainController.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/a7b37c3fd12c55c6f45f72cb1c701fa2.php ( 68.96 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/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.000367s ] mysql:host=localhost;port=3306;dbname=abga;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `en_portal_category` [ RunTime:0.001147s ]
[ SQL ] SELECT * FROM `en_portal_category` WHERE `status` = 1 AND `parent_id` = 0 ORDER BY `list_order` ASC [ RunTime:0.000601s ]
[ 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.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' => 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.000300s ]
[ 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.000305s ]
[ 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.000298s ]
[ 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.000291s ]
[ 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` = 33 AND `status` = 1 LIMIT 1 [ RunTime:0.000266s ]
[ 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` = 33 LIMIT 1 [ RunTime:0.000203s ]
[ 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` = 3 LIMIT 1 [ RunTime:0.000204s ]
[ 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 ] SHOW COLUMNS FROM `en_theme_file` [ RunTime:0.000854s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa' LIMIT 1 [ RunTime:0.000292s ]
[ 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.002078s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/aaa_detail' LIMIT 1 [ RunTime:0.000223s ]
[ 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.002125s ]
[ SQL ] SELECT * FROM `en_theme_file` WHERE `theme` = 'simpleboot3' [ RunTime:0.000215s ]
[ 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.000860s ]
[ 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.002009s ]
[ SQL ] SELECT `more` FROM `en_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/blockchain' ) [ RunTime:0.000216s ]
[ 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.001042s ]
[ 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` = '75' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) 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' => 4, 'filtered' => 100.0, 'extra' => 'Using index condition; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `en_option` [ RunTime:0.000689s ]
[ SQL ] SELECT `option_value` FROM `en_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000222s ]
[ 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` = '77' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000592s ]
[ 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' => 30, '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` = '78' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000382s ]
[ 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` = '79' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000366s ]
[ 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` = '80' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000447s ]
[ 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' => 14, '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` = '81' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000402s ]
[ 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 ] 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` = '82' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000524s ]
[ 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' => 28, '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` = '83' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000712s ]
[ 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' => 41, '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` = '84' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000446s ]
[ 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` = '85' ) AND ( `post`.`published_time` > '0' and `post`.`published_time` < 1714558284 ) GROUP BY `post`.`id` ORDER BY `post`.`post_orders` ASC LIMIT 100 [ RunTime:0.000370s ]
[ 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', ) ]

0.080452s