[ DB ] CONNECT:[ UseTime:0.029868s ] mysql:host=127.0.0.1;port=3306;dbname=7hhdc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.002854s ]
[ 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.004990s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004133s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001770s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 5 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002937s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 13 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001129s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 258 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003041s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 259 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.006364s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 262 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.009590s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 263 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001950s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 274 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000993s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 276 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003999s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 300 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002359s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 15 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001208s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 16 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001875s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 23 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001048s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 31 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001787s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 38 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004660s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 39 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001282s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 44 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002322s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 45 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003117s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 50 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001468s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 55 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001631s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 60 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002020s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 68 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004739s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 71 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002689s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 80 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.028744s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 87 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.006502s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 89 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003722s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 93 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.008283s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 303 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.013926s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 304 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002386s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 328 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002404s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 331 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001216s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 344 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001007s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 347 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001572s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 352 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001198s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 99 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002099s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 100 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001518s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 103 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002545s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 115 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002046s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 119 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003313s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 122 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003045s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 125 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003812s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 129 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004323s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 131 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004857s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 139 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004483s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 147 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001940s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 168 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.004015s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 172 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000987s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 180 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001734s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 184 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003633s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 187 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003539s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 198 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003442s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 363 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.001655s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 364 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.007669s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 368 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003001s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 379 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.002381s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 384 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.003349s ]
[ 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 3632,16 [ RunTime:0.499142s ]
[ 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.270334s ]
