基本
文件
流程
錯(cuò)誤
SQL
調(diào)試
- 請(qǐng)求信息 : 2026-01-10 00:47:02 HTTP/1.1 GET : http://m.dcwater.com.cn/
- 運(yùn)行時(shí)間 : 0.383169s [ 吞吐率：2.61req/s ] 內(nèi)存消耗：5,684.33kb 文件加載：138
- 查詢信息 : 140 queries 1 writes
- 緩存信息 : 17 reads,0 writes
- 會(huì)話信息 : SESSION_ID=de8d595cc7533eb34d8b7592e2dca04a
- [ LANG ] /www/wwwroot/shengyuln.com/vendor/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
)
- [ HEADER ] array (
'host' => 'm.dcwater.com.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 (
)
- [ LANG ] /www/wwwroot/shengyuln.com/vendor/thinkcmf/cmf/src/behavior/../lang/zh-cn.php
- [ LANG ] /www/wwwroot/shengyuln.com/vendor/thinkcmf/cmf-app/src/mjyx/lang/zh-cn.php
- [ LANG ] /www/wwwroot/shengyuln.com/vendor/thinkcmf/cmf-app/src/mjyx/lang/zh-cn/common.php
- [ LANG ] /www/wwwroot/shengyuln.com/vendor/thinkcmf/cmf-app/src/user/lang/zh-cn.php
- [ DB ] INIT mysql
- [ VIEW ] /www/wwwroot/shengyuln.com/public/themes/default/portal/index-dsc.html [ array (
0 => 'admdiv',
1 => 'search_log',
2 => 'shop',
3 => 'nav',
4 => 'footer_nav',
5 => 'cate',
6 => 'msg_list',
7 => 'sales_list',
8 => 'hot_list',
9 => 'tuijian_list',
10 => 'new_list',
11 => 'ad_list',
12 => 'tj_category',
13 => 'goods_category',
14 => 'shouye',
15 => 'theme_vars',
16 => 'theme_widgets',
) ]
- [ DB ] CONNECT:[ UseTime:0.000334s ] mysql:host=127.0.0.1;port=3306;dbname=shengyuln_com;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `cmf_admdiv` [ RunTime:0.001290s ]
- [ SQL ] SELECT * FROM `cmf_admdiv` WHERE `parentAdmDivId` = 0 [ RunTime:0.000851s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_admdiv',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 1741,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.001046s ]
- [ 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.000539s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000773s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000565s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2439 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000546s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2436 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000523s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2432 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000531s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2420 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000518s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2417 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000517s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000528s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000555s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000564s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000530s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000551s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000659s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000608s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.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' => 567,
'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.000554s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2442 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000582s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000610s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000556s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000569s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000571s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000546s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000523s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000647s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000517s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000648s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000512s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2489 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000523s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000526s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000548s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000519s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2340 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000523s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2347 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000548s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2355 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000547s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000670s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2597 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000543s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2601 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000546s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2608 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000562s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2622 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000546s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2634 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000561s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2638 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000731s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2644 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000524s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000518s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2363 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000545s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2407 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000537s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2405 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000511s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2398 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000530s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2389 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000546s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2386 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000556s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2378 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000570s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2373 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000553s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2368 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000679s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2411 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000587s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000565s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000534s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000514s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000514s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000603s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000519s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000537s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000558s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000545s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'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.000562s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2511 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' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_byte_options` [ RunTime:0.001070s ]
- [ SQL ] SELECT `config` FROM `cmf_byte_options` WHERE `merchant_id` = 2 AND `name` = 'shop' LIMIT 1 [ RunTime:0.000248s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_byte_options',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 19,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_shop_nav` [ RunTime:0.000935s ]
- [ SQL ] SELECT * FROM `cmf_shop_nav` WHERE `status` = 1 ORDER BY `list_order` [ RunTime:0.000210s ]
- [ 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.000882s ]
- [ SQL ] SELECT * FROM `cmf_footer_nav` ORDER BY `list_order` [ RunTime:0.000395s ]
- [ 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.000908s ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 4 ORDER BY `list_order` [ RunTime:0.000213s ]
- [ 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' => 16,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 1 ORDER BY `list_order` [ RunTime:0.000218s ]
- [ 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' => 16,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 5 ORDER BY `list_order` [ RunTime:0.000208s ]
- [ 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' => 16,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 2 ORDER BY `list_order` [ RunTime:0.000196s ]
- [ 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' => 16,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 7 ORDER BY `list_order` [ RunTime:0.000197s ]
- [ 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' => 16,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_footer_nav_list` WHERE `nav_id` = 8 ORDER BY `list_order` [ RunTime:0.000194s ]
- [ 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' => 16,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_search_log` [ RunTime:0.000981s ]
- [ SQL ] SELECT * FROM `cmf_search_log` ORDER BY `search_num` DESC LIMIT 5 [ RunTime:0.000175s ]
- [ 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_slide` [ RunTime:0.000890s ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_SWIPER' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000199s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_slide_item` [ RunTime:0.000895s ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 1 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000233s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_THR_BANNER' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000224s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 16 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000212s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_RECOMMEND' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000214s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 10 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000394s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_NEW' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000201s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 9 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000210s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'HEADER_ADV' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000191s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 11 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000200s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_MIDDLE_ADV_ONE' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000190s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 14 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000213s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_MIDDLE_ADV_TWO' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000210s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 13 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000217s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE ( `keyword` = 'PC_INDEX_MIDDLE_ADV_THR' AND `status` = 1 ) AND `cmf_slide`.`delete_time` = '0' LIMIT 1 [ RunTime:0.000219s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 15 AND `status` = 1 ORDER BY `list_order` [ RunTime:0.000438s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `floor` <> 0 ORDER BY `floor` [ RunTime:0.000581s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_slide` WHERE `keyword` = 'PC_INDEX_CATEGORY' LIMIT 1 [ RunTime:0.000177s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 12,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_slide_item` WHERE `slide_id` = 12 ORDER BY `list_order` ASC [ RunTime:0.000208s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_slide_item',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 29,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 1937 [ RunTime:0.000306s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (1938,1940,1941) [ RunTime:0.000326s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `parent_id` = 1937 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000345s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.001315s ]
- [ SQL ] SELECT `id`,`post_title`,`thumbnail`,`price`,`cate_id` FROM `cmf_goods` WHERE ( `post_status` = 1 AND `cate_id` IN (1938,1940,1941,1939,1942,1943,1944,1945,1946,1947,2288,2337,2338) ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`create_time` DESC LIMIT 8 [ RunTime:0.021573s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 1953 [ RunTime:0.000305s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (1954,1955,1959,1964,1970,1972,1974,1977,1982,2193,2417,2420,2432,2436,2439,2442) [ RunTime:0.000344s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `parent_id` = 1953 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000404s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`post_title`,`thumbnail`,`price`,`cate_id` FROM `cmf_goods` WHERE ( `post_status` = 1 AND `cate_id` IN (1954,1955,1959,1964,1970,1972,1974,1977,1982,2193,2417,2420,2432,2436,2439,2442,1956,1957,1958,1960,1961,1962,1963,1965,1966,1967,1968,1969,1971,1973,1975,1976,1978,1979,1980,1981,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,2041,2044,2045,2046,2047,2049,2050,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2226,2227,2228,2229,2230,2231,2232,2233,2234,2235,2236,2237,2238,2418,2419,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2433,2434,2435,2437,2438,2440,2441,2443,2444,2445,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2470,2471) ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`create_time` DESC LIMIT 8 [ RunTime:0.021687s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 1948 [ RunTime:0.000345s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (1949) [ RunTime:0.000359s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `parent_id` = 1948 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000347s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`post_title`,`thumbnail`,`price`,`cate_id` FROM `cmf_goods` WHERE ( `post_status` = 1 AND `cate_id` IN (1949,1950,1951,1952,2042) ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`create_time` DESC LIMIT 8 [ RunTime:0.020169s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 2038 [ RunTime:0.000303s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (2039,2207,2208,2209,2210,2211,2212,2213,2214,2559,2568,2572,2581) [ RunTime:0.000351s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `parent_id` = 2038 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000377s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`post_title`,`thumbnail`,`price`,`cate_id` FROM `cmf_goods` WHERE ( `post_status` = 1 AND `cate_id` IN (2039,2207,2208,2209,2210,2211,2212,2213,2214,2559,2568,2572,2581,2040,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2560,2561,2562,2563,2564,2565,2566,2567,2569,2570,2571,2573,2574,2575,2576,2577,2578,2579,2580,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595) ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`create_time` DESC LIMIT 8 [ RunTime:0.020303s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 2021 [ RunTime:0.000314s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (2022,2023,2194,2489) [ RunTime:0.000326s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `parent_id` = 2021 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000358s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`post_title`,`thumbnail`,`price`,`cate_id` FROM `cmf_goods` WHERE ( `post_status` = 1 AND `cate_id` IN (2022,2023,2194,2489,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2043,2241,2242,2243,2490,2491,2492,2493,2494,2495,2496,2497,2498,2499,2500,2501,2502,2503,2504,2505,2506,2507,2508,2509,2510) ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`create_time` DESC LIMIT 8 [ RunTime:0.020541s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` = 1996 [ RunTime:0.000353s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id` FROM `cmf_goods_category` WHERE `parent_id` IN (1997,1999,2004,2010,2013) [ RunTime:0.000309s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE `parent_id` = 1996 ORDER BY `list_order` ASC LIMIT 10 [ RunTime:0.000353s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'ALL',
'possible_keys' => NULL,
'key' => NULL,
'key_len' => NULL,
'ref' => NULL,
'rows' => 567,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`post_title`,`thumbnail`,`price`,`cate_id` FROM `cmf_goods` WHERE ( `post_status` = 1 AND `cate_id` IN (1997,1999,2004,2010,2013,1998,2000,2001,2002,2003,2005,2006,2007,2008,2009,2011,2012,2014,2015,2016,2048,2239,2240,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2483,2484,2485,2486,2487,2488) ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`create_time` DESC LIMIT 8 [ RunTime:0.020163s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT `id`,`name` FROM `cmf_goods_category` WHERE ( `isrecommand` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `id` DESC LIMIT 5 [ RunTime:0.000397s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_goods_category',
'type' => 'index',
'possible_keys' => NULL,
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 5,
'extra' => 'Using where',
) ]
- [ SQL ] SELECT * FROM `cmf_goods` WHERE ( `post_status` = 1 AND `is_hot` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`id` DESC LIMIT 5 [ RunTime:0.018637s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_goods` WHERE ( `post_status` = 1 AND `recommended` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`id` DESC LIMIT 5 [ RunTime:0.018595s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_goods` WHERE ( `post_status` = 1 AND `is_new` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `list_order` DESC,`id` DESC LIMIT 6 [ RunTime:0.018930s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SELECT * FROM `cmf_goods` WHERE ( `post_status` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `sales` DESC,`id` DESC LIMIT 6 [ RunTime:0.020747s ]
- [ 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' => 7021,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_notice` [ RunTime:0.001195s ]
- [ SQL ] SELECT * FROM `cmf_notice` WHERE `delete_time` = 0 ORDER BY `id` DESC LIMIT 7 [ RunTime:0.000221s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'cmf_notice',
'type' => 'index',
'possible_keys' => NULL,
'key' => 'PRIMARY',
'key_len' => '8',
'ref' => NULL,
'rows' => 1,
'extra' => 'Using where',
) ]
- [ SQL ] SHOW COLUMNS FROM `cmf_theme_file` [ RunTime:0.001008s ]
- [ SQL ] SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' [ RunTime:0.000215s ]
- [ 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.000962s ]
- [ 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.000261s ]
- [ SQL ] SELECT `more` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/index-dsc' ) [ RunTime:0.000220s ]
- [ 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',
) ]
