基本
文件
流程(chéng)
错误
SQL
调试
- 请求信息 : 2025-11-15 01:31:45 HTTP/1.1 GET : http://yongliangroup.com/product.html
- 运行时间 : 0.448015s [ 吞吐率:2.23req/s ] 内存消耗:10,211.38kb 文件加载:113
- 查询(xún)信息 : 228 queries 14 writes
- 缓存信息 : 6 reads,0 writes
- [ LANG ] /www/wwwroot/ingmar.top/vendor/thinkphp/lang/zh-cn.php
- [ LANG ] /www/wwwroot/ingmar.top/app/portal//lang/zh-cn.php
- [ ROUTE ] array (
'rule' => 'product',
'route' => 'portal/List/index?id=1',
'option' =>
array (
'merge_rule_regex' => false,
),
'var' =>
array (
),
)
- [ HEADER ] array (
'referer' => 'yongliangroup.com',
'accept' => '*/*',
'host' => 'yongliangroup.com',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'id' => '1',
)
- [ LANG ] /www/wwwroot/ingmar.top/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /www/wwwroot/ingmar.top/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn.php
- [ LANG ] /www/wwwroot/ingmar.top/vendor/thinkcmf/cmf-app/src/admin/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/ingmar.top/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ LANG ] /www/wwwroot/ingmar.top/app/portal/lang/zh-cn/common.php
- [ DB ] INIT mysql
- [ LANG ] /www/wwwroot/ingmar.top/app/portal/lang/zh-cn/home.php
- [ VIEW ] /www/wwwroot/ingmar.top/public/themes/hzbs/portal/product-list.html [ array (
0 => 'site_info',
1 => 'category',
2 => 'theme_vars',
3 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000755s ] mysql:host=127.0.0.1;port=3306;dbname=ingmar_db;charset=utf8mb4
- [ SQL ] SHOW COLUMNS FROM `bs_option` [ RunTime:0.001848s ]
- [ SQL ] SELECT `option_value` FROM `bs_option` WHERE `option_name` = 'cdn_settings' LIMIT 1 [ RunTime:0.000503s ]
- [ 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 `bs_portal_category` [ RunTime:0.001643s ]
- [ SQL ] SELECT * FROM `bs_portal_category` WHERE `id` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000641s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_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 `bs_theme_file` [ RunTime:0.001493s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/article' LIMIT 1 [ RunTime:0.000606s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Article/index' , `file` = 'portal/article' , `name` = '文章页' , `more` = '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `config_more` = '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `description` = '文章页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/article' [ RunTime:0.001284s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/contact' LIMIT 1 [ RunTime:0.000521s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Page/index' , `file` = 'portal/contact' , `name` = '联系我(wǒ)们页' , `more` = '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"\\u5c71\\u4e1c\\u82f1\\u683c\\u739b\\u73af\\u4fdd\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u5c71\\u4e1c \\u83cf\\u6cfd\\u7261\\u4e39\\u533a\\u7261\\u4e39\\u533a\\u9ad8\\u65b0\\u533a\\u9a6c\\u5cad\\u5c97\\u5de5\\u4e1a\\u56ed<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_locations\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"115.39155,35.219361\",\"type\":\"locations\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"117.54,36.96\"},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u5c71\\u4e1c\\u83cf\\u6cfd\\u7261\\u4e39\\u533a\\u7261\\u4e39\\u533a\\u9ad8\\u65b0\\u533a\\u9a6c\\u5cad\\u5c97\\u5de5\\u4e1a\\u56ed\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"Malinggang Industrial Park, Heze high tech Zone, Shandong Province, China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"251289731@qq.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phones_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"15908042339\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phones_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+86 15908042339\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"251289731\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"baidu_map_info_window_text\":{\"title\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57\",\"name\":\"baidu_map_info_window_text\",\"value\":\"ThinkCMF<br\\/><span class=\'\'>\\u5730\\u5740\\uff1a\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def2601\\u53f7<\\/span>\",\"type\":\"text\",\"tip\":\"\\u767e\\u5ea6\\u5730\\u56fe\\u6807\\u6ce8\\u6587\\u5b57,\\u652f\\u6301\\u7b80\\u5355html\\u4ee3\\u7801\",\"rule\":[]},\"company_locations\":{\"title\":\"\\u516c\\u53f8\\u5750\\u6807\",\"value\":\"\",\"type\":\"locations\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_cn\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"value\":\"\\u4e0a\\u6d77\\u5e02\\u5f90\\u6c47\\u533a\\u659c\\u571f\\u8def0001\\u53f7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"address_en\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"NO.0001 Xie Tu Road, Shanghai China\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"value\":\"catman@thinkcmf.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phones_cn\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"value\":\"021 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"phones_en\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\\uff08\\u82f1\\u6587\\uff09\",\"value\":\"+8621 1000 0001\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":true}},\"qq\":{\"title\":\"\\u8054\\u7cfbQQ\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\\u591a\\u4e2a QQ\\u4ee5\\u82f1\\u6587\\u9017\\u53f7\\u9694\\u5f00\",\"rule\":{\"require\":true}}}}' , `description` = '联系我们(men)页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/contact' [ RunTime:0.001170s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/index' LIMIT 1 [ RunTime:0.000397s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Index/index' , `file` = 'portal/index' , `name` = '首(shǒu)页' , `more` = '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"1\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true},\"valueText\":\"\\u4e3b\\u9875\\u8f6e\\u64ad\\u5927\\u56fe\"}},\"widgets\":{\"ldproduct\":{\"title\":\"\\u4ea7\\u54c1\\u63a8\\u8350\",\"display\":0,\"vars\":{\"ldproduct_category_id\":{\"title\":\"\\u4ea7\\u54c1\\u5206\\u7c7bID\",\"value\":\"1,2,3,4,5,6,7,8,9,10\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u4ea7\\u54c1\\u5c55\\u793a,\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u5355\\u76f8\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u4e09\\u76f8\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u9502\\u7535\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u4e2d\\u538b\\u96c6\\u5c18\\u5668,\\u771f\\u7a7a\\u4e2d\\u592e\\u6e05\\u626b\\u7cfb\\u7edf,\\u5168\\u5957\\u914d\\u4ef6,\\u65b0\\u95fb\\u4e2d\\u5fc3,\\u516c\\u53f8\\u52a8\\u6001\"}}},\"producttj\":{\"title\":\"\\u4ea7\\u54c1\\u5c55\\u793a\",\"display\":1,\"vars\":{\"product_category_id\":{\"title\":\"\\u4ea7\\u54c1\\u5206\\u7c7bID\",\"value\":\"2,3,4,5,6,7\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true},\"valueText\":\"\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u5355\\u76f8\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u4e09\\u76f8\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u9502\\u7535\\u5de5\\u4e1a\\u5438\\u5c18\\u5668,\\u4e2d\\u538b\\u96c6\\u5c18\\u5668,\\u771f\\u7a7a\\u4e2d\\u592e\\u6e05\\u626b\\u7cfb\\u7edf\"}}}}}' , `config_more` = '{\"vars\":{\"top_slide\":{\"title\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"admin\\/Slide\\/index\",\"multi\":false},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"tip\":\"\\u9876\\u90e8\\u5e7b\\u706f\\u7247\",\"rule\":{\"require\":true}}},\"widgets\":{\"ldproduct\":{\"title\":\"\\u4ea7\\u54c1\\u63a8\\u8350\",\"display\":\"1\",\"vars\":{\"ldproduct_category_id\":{\"title\":\"\\u4ea7\\u54c1\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"producttj\":{\"title\":\"\\u4ea7\\u54c1\\u5c55\\u793a\",\"display\":\"1\",\"vars\":{\"product_category_id\":{\"title\":\"\\u4ea7\\u54c1\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/Category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '首页(yè)模板文件' , `is_public` = 0 , `list_order` = 5 WHERE `theme` = 'hzbs' AND `file` = 'portal/index' [ RunTime:0.001131s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/list' LIMIT 1 [ RunTime:0.000374s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/List/index' , `file` = 'portal/list' , `name` = '文章列表(biǎo)页' , `more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"vars\":[],\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '文章列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/list' [ RunTime:0.001170s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/news-article' LIMIT 1 [ RunTime:0.000465s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Article/index' , `file` = 'portal/news-article' , `name` = '文章页' , `more` = '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `config_more` = '{\"vars\":{\"hot_articles_category_id\":{\"title\":\"Hot Articles\\u5206\\u7c7bID\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `description` = '文章(zhāng)页模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/news-article' [ RunTime:0.000983s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/page' LIMIT 1 [ RunTime:0.000385s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Page/index' , `file` = 'portal/page' , `name` = '单页面' , `more` = '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `config_more` = '{\"widgets\":{\"hottest_articles\":{\"title\":\"\\u70ed\\u95e8\\u6587\\u7ae0\",\"display\":\"1\",\"vars\":{\"hottest_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}},\"last_articles\":{\"title\":\"\\u6700\\u65b0\\u53d1\\u5e03\",\"display\":\"1\",\"vars\":{\"last_articles_category_id\":{\"title\":\"\\u6587\\u7ae0\\u5206\\u7c7bID\",\"value\":\"\",\"type\":\"text\",\"dataSource\":{\"api\":\"portal\\/category\\/index\",\"multi\":true},\"placeholder\":\"\\u8bf7\\u9009\\u62e9\\u5206\\u7c7b\",\"tip\":\"\",\"rule\":{\"require\":true}}}}}}' , `description` = '单页面(miàn)模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/page' [ RunTime:0.001020s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/pageabout' LIMIT 1 [ RunTime:0.000406s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Page/index' , `file` = 'portal/pageabout' , `name` = '关(guān)于我(wǒ)们' , `more` = '{\"widgets\":[]}' , `config_more` = '{\"widgets\":[]}' , `description` = '单页面模板文件(jiàn)' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/pageabout' [ RunTime:0.001021s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/product-list' LIMIT 1 [ RunTime:0.000399s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/List/index' , `file` = 'portal/product-list' , `name` = '产品列表页' , `more` = '{\"vars\":[],\"widgets\":[]}' , `config_more` = '{\"vars\":[],\"widgets\":[]}' , `description` = '文(wén)章列表模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/product-list' [ RunTime:0.000955s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/search' LIMIT 1 [ RunTime:0.000372s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/search/index' , `file` = 'portal/search' , `name` = '搜索页面' , `more` = '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"varName1\":{\"title\":\"\\u70ed\\u95e8\\u641c\\u7d22\",\"value\":\"1\",\"type\":\"text\",\"tip\":\"\\u8fd9\\u662f\\u4e00\\u4e2atext\",\"rule\":{\"require\":true}}}}' , `description` = '搜索模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/search' [ RunTime:0.000925s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'portal/service' LIMIT 1 [ RunTime:0.000395s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'portal/Page/index' , `file` = 'portal/service' , `name` = '服务(wù)与支持(chí)' , `more` = '{\"widgets\":[]}' , `config_more` = '{\"widgets\":[]}' , `description` = '单(dān)页面模板文件' , `is_public` = 0 , `list_order` = 10 WHERE `theme` = 'hzbs' AND `file` = 'portal/service' [ RunTime:0.000976s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'public/config' LIMIT 1 [ RunTime:0.000387s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'public/Config' , `file` = 'public/config' , `name` = '模(mó)板全局配置' , `more` = '{\"vars\":[]}' , `config_more` = '{\"vars\":[]}' , `description` = '模板全局配置文件' , `is_public` = 1 , `list_order` = 0 WHERE `theme` = 'hzbs' AND `file` = 'public/config' [ RunTime:0.001411s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'public/footer' LIMIT 1 [ RunTime:0.000498s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'public/footer' , `file` = 'public/footer' , `name` = '脚部页面' , `more` = '{\"vars\":{\"company_add\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"name\":\"company_add\",\"value\":\"\\u5c71\\u4e1c\\u7701\\u83cf\\u6cfd\\u5e02\\u9ad8\\u65b0\\u533a\\u9a6c\\u5cad\\u5c97\\u5de5\\u4e1a\\u56ed220\\u56fd\\u9053\\u9a6c\\u5cad\\u5c97\\u9547\\u6587\\u5316\\u5927\\u9662\\u5bf9\\u8fc7\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"company_tel\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"name\":\"company_tel\",\"value\":\"15908042339\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"company_email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"name\":\"company_email\",\"value\":\"251289731@qq.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"company_int\":{\"title\":\"\\u516c\\u53f8\\u5b98\\u7f51\",\"name\":\"company_int\",\"value\":\"http:\\/\\/yongliangroup.com\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"leftimg\":{\"title\":\"\\u811a\\u90e8logo\",\"value\":\"default\\/20191212\\/e418db79209dc06839b6f6731b87113c.png\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u4e0a\\u4f20\\u811a\\u90e8logo\",\"rule\":{\"require\":false}},\"rightimg\":{\"title\":\"\\u811a\\u90e8\\u4e8c\\u7ef4\\u7801\",\"value\":\"default\\/20191212\\/e418db79209dc06839b6f6731b87113c.png\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u4e0a\\u4f20\\u811a\\u90e8\\u4e8c\\u7ef4\\u7801\",\"rule\":{\"require\":true}}}}' , `config_more` = '{\"vars\":{\"company_add\":{\"title\":\"\\u516c\\u53f8\\u5730\\u5740\",\"name\":\"company_add\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"company_tel\":{\"title\":\"\\u516c\\u53f8\\u7535\\u8bdd\",\"name\":\"company_tel\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"company_email\":{\"title\":\"\\u516c\\u53f8\\u90ae\\u7bb1\",\"name\":\"company_email\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"company_int\":{\"title\":\"\\u516c\\u53f8\\u5b98\\u7f51\",\"name\":\"company_int\",\"value\":\"\",\"type\":\"text\",\"tip\":\"\",\"rule\":{\"require\":false}},\"leftimg\":{\"title\":\"\\u811a\\u90e8logo\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u4e0a\\u4f20\\u811a\\u90e8logo\",\"rule\":{\"require\":false}},\"rightimg\":{\"title\":\"\\u811a\\u90e8\\u4e8c\\u7ef4\\u7801\",\"value\":\"\",\"type\":\"image\",\"tip\":\"\\u8bf7\\u4e0a\\u4f20\\u811a\\u90e8\\u4e8c\\u7ef4\\u7801\",\"rule\":{\"require\":true}}}}' , `description` = '脚部模板(bǎn)文(wén)件' , `is_public` = 1 , `list_order` = 1 WHERE `theme` = 'hzbs' AND `file` = 'public/footer' [ RunTime:0.001229s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND `file` = 'public/nav' LIMIT 1 [ RunTime:0.000456s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] UPDATE `bs_theme_file` SET `theme` = 'hzbs' , `action` = 'public/Nav' , `file` = 'public/nav' , `name` = '导航条' , `more` = '{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"\\u5c71\\u4e1c\\u82f1\\u683c\\u739b\\u9632\\u7206\\u73af\\u4fdd\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `config_more` = '{\"vars\":{\"company_name\":{\"title\":\"\\u516c\\u53f8\\u540d\\u79f0\",\"name\":\"company_name\",\"value\":\"\\u5c71\\u4e1c\\u82f1\\u683c\\u739b\\u9632\\u7206\\u73af\\u4fdd\\u79d1\\u6280\\u6709\\u9650\\u516c\\u53f8\",\"type\":\"text\",\"tip\":\"\",\"rule\":[]}}}' , `description` = '导航条模板文(wén)件' , `is_public` = 1 , `list_order` = 1 WHERE `theme` = 'hzbs' AND `file` = 'public/nav' [ RunTime:0.000955s ]
- [ SQL ] SELECT * FROM `bs_theme_file` WHERE `theme` = 'hzbs' [ RunTime:0.000465s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 10.000000953674316,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `bs_theme` [ RunTime:0.001539s ]
- [ SQL ] UPDATE `bs_theme` SET `name` = 'hzbs' , `version` = '1.0.0' , `demo_url` = '' , `author` = '凯维网(wǎng)络' , `lang` = 'zh-cn' , `author_url` = 'http://www.ingmar.cc/' , `keywords` = '英格玛' , `description` = '山(shān)东英格玛防爆环保科技有限公司' WHERE `theme` = 'hzbs' [ RunTime:0.001068s ]
- [ SQL ] SELECT `more` FROM `bs_theme_file` WHERE `theme` = 'hzbs' AND ( `is_public` = 1 OR `file` = 'portal/product-list' ) [ RunTime:0.000430s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_theme_file',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 21,
'filtered' => 4.761904716491699,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `bs_nav` [ RunTime:0.001318s ]
- [ SQL ] SELECT `id` FROM `bs_nav` WHERE `is_main` = 1 LIMIT 1 [ RunTime:0.000452s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_nav',
'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 `bs_nav_menu` [ RunTime:0.001320s ]
- [ SQL ] SELECT * FROM `bs_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000609s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'filtered' => 8.333333969116211,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `bs_portal_category` WHERE `delete_time` = 0 AND `path` LIKE '0-1-%' ORDER BY `list_order` ASC [ RunTime:0.000662s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 31,
'filtered' => 3.22580623626709,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `bs_portal_category` WHERE `delete_time` = 0 AND `path` LIKE '0-9-%' ORDER BY `list_order` ASC [ RunTime:0.000496s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 31,
'filtered' => 3.22580623626709,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `path` FROM `bs_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000392s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_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 `bs_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-1-%' ORDER BY `list_order` ASC [ RunTime:0.000570s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 31,
'filtered' => 3.22580623626709,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `path` FROM `bs_portal_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000343s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_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 `bs_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `path` LIKE '0-1-%' ORDER BY `list_order` ASC [ RunTime:0.000565s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 31,
'filtered' => 3.22580623626709,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `bs_portal_post` [ RunTime:0.001709s ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '43' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.014423s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'post',
'partitions' => NULL,
'type' => 'ref',
'possible_keys' => 'PRIMARY,type_status_date',
'key' => 'type_status_date',
'key_len' => '2',
'ref' => 'const,const',
'rows' => 115,
'filtered' => 1.110888957977295,
'extra' => 'Using where; Using temporary; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `bs_portal_category_post` [ RunTime:0.001506s ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 144 [ RunTime:0.000685s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `option_value` FROM `bs_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000386s ]
- [ 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 `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 143 [ RunTime:0.000658s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 142 [ RunTime:0.000681s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 141 [ RunTime:0.000679s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 140 [ RunTime:0.000623s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 139 [ RunTime:0.000634s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 138 [ RunTime:0.000759s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 137 [ RunTime:0.000721s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 136 [ RunTime:0.000649s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 135 [ RunTime:0.000643s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 134 [ RunTime:0.000694s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 133 [ RunTime:0.000624s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 132 [ RunTime:0.000632s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 131 [ RunTime:0.000748s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 130 [ RunTime:0.000722s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 129 [ RunTime:0.000690s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 128 [ RunTime:0.000660s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 127 [ RunTime:0.000690s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 126 [ RunTime:0.000759s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 125 [ RunTime:0.000636s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 124 [ RunTime:0.000664s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 123 [ RunTime:0.000756s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 122 [ RunTime:0.000723s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 121 [ RunTime:0.000672s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 120 [ RunTime:0.000704s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 119 [ RunTime:0.000745s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 118 [ RunTime:0.000698s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 117 [ RunTime:0.000681s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 116 [ RunTime:0.000745s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 115 [ RunTime:0.000669s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 114 [ RunTime:0.000673s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 113 [ RunTime:0.000729s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 112 [ RunTime:0.000688s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 111 [ RunTime:0.000766s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 110 [ RunTime:0.000642s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 109 [ RunTime:0.000691s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 108 [ RunTime:0.000803s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '47' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000656s ]
- [ 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 temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 151 [ RunTime:0.000643s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '29' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001431s ]
- [ 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' => 9,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 130 [ RunTime:0.000660s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 129 [ RunTime:0.000698s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 69 [ RunTime:0.000653s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 70 [ RunTime:0.000657s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 71 [ RunTime:0.000636s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 72 [ RunTime:0.000686s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 73 [ RunTime:0.000640s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 74 [ RunTime:0.000671s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 75 [ RunTime:0.000722s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 76 [ RunTime:0.000749s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '48' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000921s ]
- [ 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' => 5,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 155 [ RunTime:0.000686s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 154 [ RunTime:0.000683s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 153 [ RunTime:0.000659s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 152 [ RunTime:0.000740s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '45' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000735s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 125 [ RunTime:0.000682s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '26' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001483s ]
- [ 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 temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 122 [ RunTime:0.000673s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 121 [ RunTime:0.000699s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 38 [ RunTime:0.000652s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 39 [ RunTime:0.000648s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 40 [ RunTime:0.000749s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 41 [ RunTime:0.000723s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 42 [ RunTime:0.000690s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 43 [ RunTime:0.000677s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 44 [ RunTime:0.000654s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 45 [ RunTime:0.000747s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 46 [ RunTime:0.000695s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 47 [ RunTime:0.000613s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 48 [ RunTime:0.000653s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 49 [ RunTime:0.000648s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '25' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.003299s ]
- [ 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 temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 144 [ RunTime:0.000726s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 143 [ RunTime:0.000646s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 142 [ RunTime:0.000632s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 138 [ RunTime:0.000767s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 137 [ RunTime:0.000703s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 136 [ RunTime:0.000629s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 134 [ RunTime:0.000626s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 131 [ RunTime:0.000623s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 126 [ RunTime:0.000655s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 120 [ RunTime:0.000752s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 119 [ RunTime:0.000735s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 118 [ RunTime:0.000668s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 117 [ RunTime:0.000757s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 116 [ RunTime:0.000733s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 115 [ RunTime:0.000754s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 114 [ RunTime:0.000670s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 113 [ RunTime:0.000745s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 112 [ RunTime:0.000662s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 111 [ RunTime:0.000751s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 22 [ RunTime:0.000710s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 23 [ RunTime:0.000665s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 24 [ RunTime:0.000620s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 25 [ RunTime:0.000649s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 26 [ RunTime:0.000650s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 27 [ RunTime:0.000641s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 28 [ RunTime:0.000748s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 29 [ RunTime:0.000743s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 30 [ RunTime:0.000668s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 31 [ RunTime:0.000623s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 32 [ RunTime:0.000643s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 33 [ RunTime:0.000752s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 34 [ RunTime:0.000731s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 35 [ RunTime:0.000667s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 36 [ RunTime:0.000620s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 37 [ RunTime:0.000648s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 21 [ RunTime:0.000616s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '27' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001304s ]
- [ 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' => 11,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 124 [ RunTime:0.000722s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 123 [ RunTime:0.000663s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 50 [ RunTime:0.000661s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 51 [ RunTime:0.000737s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 52 [ RunTime:0.000667s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 53 [ RunTime:0.000712s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 54 [ RunTime:0.000654s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 55 [ RunTime:0.000741s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 56 [ RunTime:0.000741s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 57 [ RunTime:0.000666s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 58 [ RunTime:0.000624s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 59 [ RunTime:0.000655s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 60 [ RunTime:0.000624s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001466s ]
- [ 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' => 11,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 135 [ RunTime:0.000643s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 110 [ RunTime:0.000659s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 109 [ RunTime:0.000680s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 108 [ RunTime:0.000715s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 12 [ RunTime:0.000668s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 13 [ RunTime:0.000707s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 14 [ RunTime:0.000657s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 15 [ RunTime:0.000741s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 16 [ RunTime:0.000731s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 17 [ RunTime:0.000659s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 18 [ RunTime:0.000622s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 19 [ RunTime:0.000645s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 20 [ RunTime:0.000621s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '33' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000647s ]
- [ 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 temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 84 [ RunTime:0.000750s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 85 [ RunTime:0.000724s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000679s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 83 [ RunTime:0.000675s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '31' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001015s ]
- [ 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' => 5,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 133 [ RunTime:0.000657s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 132 [ RunTime:0.000752s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 81 [ RunTime:0.000633s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 82 [ RunTime:0.000649s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '30' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001069s ]
- [ 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' => 7,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 128 [ RunTime:0.000691s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 127 [ RunTime:0.000729s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 77 [ RunTime:0.000659s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 78 [ RunTime:0.000623s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 79 [ RunTime:0.000658s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 80 [ RunTime:0.000741s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '37' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000943s ]
- [ 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 temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 104 [ RunTime:0.000694s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 105 [ RunTime:0.000699s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 106 [ RunTime:0.000624s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 103 [ RunTime:0.000646s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '36' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000801s ]
- [ 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' => 2,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 101 [ RunTime:0.000681s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 102 [ RunTime:0.000653s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '35' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001242s ]
- [ 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' => 9,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 90 [ RunTime:0.000693s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 91 [ RunTime:0.000751s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 92 [ RunTime:0.000723s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 93 [ RunTime:0.000655s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 94 [ RunTime:0.000633s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 95 [ RunTime:0.000645s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 96 [ RunTime:0.000749s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 97 [ RunTime:0.000711s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 98 [ RunTime:0.000664s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 99 [ RunTime:0.000625s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 100 [ RunTime:0.000618s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` = '34' ) AND ( `post`.`published_time` > 0 and `post`.`published_time` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.000858s ]
- [ 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 temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 86 [ RunTime:0.000722s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 87 [ RunTime:0.000710s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 88 [ RunTime:0.000674s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 89 [ RunTime:0.000747s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT post.*,min(category_post.category_id) as category_id FROM `bs_portal_post` `post` INNER JOIN `bs_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` < 1763141505 ) GROUP BY `post`.`id` ORDER BY `post`.`published_time` DESC LIMIT 999 [ RunTime:0.001453s ]
- [ 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' => 10,
'filtered' => 100.0,
'extra' => 'Using temporary; Using filesort',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 141 [ RunTime:0.000656s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 140 [ RunTime:0.000630s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 139 [ RunTime:0.000766s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 61 [ RunTime:0.000716s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 62 [ RunTime:0.000659s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 63 [ RunTime:0.000667s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 64 [ RunTime:0.000662s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 65 [ RunTime:0.000795s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 66 [ RunTime:0.000694s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 67 [ RunTime:0.000788s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `bs_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 `bs_portal_category` INNER JOIN `bs_portal_category_post` `pivot` ON `pivot`.`category_id`=`bs_portal_category`.`id` WHERE `pivot`.`post_id` = 68 [ RunTime:0.000724s ]
- [ 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' => 190,
'filtered' => 10.0,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `bs_portal_category` WHERE `delete_time` = 0 AND `path` LIKE '0-1-%' ORDER BY `list_order` ASC [ RunTime:0.000557s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_portal_category',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 31,
'filtered' => 3.22580623626709,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `bs_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000467s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'bs_nav_menu',
'partitions' => NULL,
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'filtered' => 8.333333969116211,
'extra' => 'Using where; Using filesort',
) ]