基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請(qǐng)求信息 : 2026-02-06 12:06:14 HTTP/1.1 GET : http://www.e306.cn/portal/index/search/cate_id/2001.html
- 運(yùn)行時(shí)間 : 0.159446s [ 吞吐率：6.27req/s ] 內(nèi)存消耗：5,481.28kb 文件加載：136
- 查詢信息 : 92 queries 1 writes
- 緩存信息 : 4 reads,0 writes
- 會(huì)話信息 : SESSION_ID=828bc3c573884dc6ab912ce1eba7af9d
- [ LANG ] /www/wwwroot/chjie.cn/vendor/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
)
- [ HEADER ] array (
'host' => 'www.e306.cn',
'user-agent' => 'Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko',
'referer' => 'http://www.baidu.com',
'cookie' => 't=92d7540e476b153862b4ea2356ede7b3; r=8148',
'accept-language' => 'zh-CN,zh',
'accept-encoding' => 'gzip, deflate',
'accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'content-type' => 'application/x-www-form-urlencoded; Charset=UTF-8',
'connection' => 'Keep-Alive',
'content-length' => '',
)
- [ PARAM ] array (
'cate_id' => '2001',
)
- [ LANG ] /www/wwwroot/chjie.cn/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /www/wwwroot/chjie.cn/vendor/thinkcmf/cmf-app/src/mjyx/lang/zh-cn.php
- [ LANG ] /www/wwwroot/chjie.cn/vendor/thinkcmf/cmf-app/src/mjyx/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/chjie.cn/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ DB ] INIT mysql
- [ VIEW ] /www/wwwroot/chjie.cn/public/themes/default/portal/search-goods.html [ array (
0 => 'search_log',
1 => 'shop',
2 => 'nav',
3 => 'footer_nav',
4 => 'cate',
5 => 'list',
6 => 'shai_list',
7 => 'data',
8 => 'total',
9 => 'page',
10 => 'dsort',
11 => 'sort',
12 => 'p_order',
13 => 'spage',
14 => 'keywords',
15 => 'stock',
16 => 'brand_id',
17 => 'brand_list',
18 => 'name',
19 => 'theme_vars',
20 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.003893s ] mysql:host=127.0.0.1;port=3306;dbname=chjie_cn;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.002271s ]
- [ SQL ] SELECT `id`,`parent_id`,`name`,`thumb` FROM `cmf_goods_category` WHERE ( `parent_id` = 0 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` LIMIT 9 [ RunTime:0.001187s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1953 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000655s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1954 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000480s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2438 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000462s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2435 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000592s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2431 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000527s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2419 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000493s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2416 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000494s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2193 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000508s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1982 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000471s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1977 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000461s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1974 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000503s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1972 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000474s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1970 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000484s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1964 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000498s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1959 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000484s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1955 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000459s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2441 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000722s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1996 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000459s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1997 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000462s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1999 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000481s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2004 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000501s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2010 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000455s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2013 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000737s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2021 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000499s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2022 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000454s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2023 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000487s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2194 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000483s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2488 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000484s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1948 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000496s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1949 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000495s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2338 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000454s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2339 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000458s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2346 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000471s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2354 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000510s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2595 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000662s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2596 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000483s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2600 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000482s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2607 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000503s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2621 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000469s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2633 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000462s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2637 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000474s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2643 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000506s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2361 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000479s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2362 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000504s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2406 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000475s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2404 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000450s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2397 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000493s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2388 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000540s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2385 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000494s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2377 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000466s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2372 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000450s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2367 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000467s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2410 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000465s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1937 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000625s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1938 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000501s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1940 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000449s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1941 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000453s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2195 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000475s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2196 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000464s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2197 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000444s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2198 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000500s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2199 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000464s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2200 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000455s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2510 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000490s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 566,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_byte_options` [ RunTime:0.001891s ]
- [ SQL ] SELECT `config` FROM `cmf_byte_options` WHERE `merchant_id` = 2 AND `name` = 'shop' LIMIT 1 [ RunTime:0.000215s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_byte_options',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 20,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_shop_nav` [ RunTime:0.001522s ]
- [ SQL ] SELECT * FROM `cmf_shop_nav` WHERE `status` = 1 ORDER BY `list_order` [ RunTime:0.000203s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_shop_nav',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 2,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_footer_nav` [ RunTime:0.001484s ]
- [ SQL ] SELECT * FROM `cmf_footer_nav` ORDER BY `list_order` [ RunTime:0.000167s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 6,
'extra' => 'Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_footer_nav_list` [ RunTime:0.001526s ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 4 ORDER BY `list_order` [ RunTime:0.000206s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav_list',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 1 ORDER BY `list_order` [ RunTime:0.000181s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav_list',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 5 ORDER BY `list_order` [ RunTime:0.000163s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav_list',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 2 ORDER BY `list_order` [ RunTime:0.000215s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav_list',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 7 ORDER BY `list_order` [ RunTime:0.000160s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav_list',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 8 ORDER BY `list_order` [ RunTime:0.000159s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_footer_nav_list',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 17,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_search_log` [ RunTime:0.001480s ]
- [ SQL ] SELECT * FROM `cmf_search_log` ORDER BY `search_num` DESC LIMIT 5 [ RunTime:0.000240s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_search_log',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.001781s ]
- [ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_goods` WHERE ( `stock` > 0 AND `post_status` = 1 ) AND `cmf_goods`.`delete_time` = '0' [ RunTime:0.001013s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods',
'type' => 'ref',
'possible_keys' => 'type_status_date,post_status',
'key' => 'type_status_date',
'key_len' => '1',
'ref' => 'const',
'rows' => 580,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`thumbnail`,`post_title`,`price`,`sales` FROM `cmf_goods` WHERE ( `stock` > 0 AND `post_status` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 0,16 [ RunTime:0.001148s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods',
'type' => 'ref',
'possible_keys' => 'type_status_date,post_status',
'key' => 'type_status_date',
'key_len' => '1',
'ref' => 'const',
'rows' => 580,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `attr_id` FROM `cmf_goods` WHERE ( `stock` > 0 AND `post_status` = 1 ) AND `cmf_goods`.`delete_time` = '0' [ RunTime:0.000928s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods',
'type' => 'ref',
'possible_keys' => 'type_status_date,post_status',
'key' => 'type_status_date',
'key_len' => '1',
'ref' => 'const',
'rows' => 580,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_attribute_value` [ RunTime:0.001527s ]
- [ SQL ] SELECT * FROM `cmf_attribute_value` WHERE `attr_id` IN (0) AND `type` <> 1 [ RunTime:0.000205s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_attribute_value',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 18,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`thumbnail`,`post_title`,`price`,`sales` FROM `cmf_goods` WHERE ( `stock` > 0 AND `post_status` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 4 [ RunTime:0.001081s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods',
'type' => 'ref',
'possible_keys' => 'type_status_date,post_status',
'key' => 'type_status_date',
'key_len' => '1',
'ref' => 'const',
'rows' => 580,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001841s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' [ RunTime:0.000241s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme` [ RunTime:0.001596s ]
- [ SQL ] UPDATE `cmf_theme` SET `name` = 'default' , `version` = '1.0.0' , `demo_url` = 'http://demo.thinkcmf.com' , `author` = 'ThinkCMF' , `lang` = 'zh-cn' , `author_url` = 'http://www.thinkcmf.com' , `keywords` = 'ThinkCMF默認(rèn)模板' , `description` = 'ThinkCMF默認(rèn)模板' WHERE `theme` = 'default' [ RunTime:0.000243s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/search-goods' ) [ RunTime:0.000246s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_theme_file',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where',
) ]
