[ DB ] CONNECT:[ UseTime:0.034927s ] mysql:host=127.0.0.1;port=3306;dbname=7hhdc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.003112s ]
[ 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.002945s ]
[ 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.015647s ]
[ 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.004316s ]
[ 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.006016s ]
[ 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.003510s ]
[ 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.002353s ]
[ 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.006355s ]
[ 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.003358s ]
[ 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.024710s ]
[ 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.005535s ]
[ 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.006113s ]
[ 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.004742s ]
[ 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.002431s ]
[ 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.003305s ]
[ 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.003984s ]
[ 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.009980s ]
[ 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.003581s ]
[ 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.004189s ]
[ 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.002864s ]
[ 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.002232s ]
[ 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.002706s ]
[ 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.013925s ]
[ 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.002654s ]
[ 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.003084s ]
[ 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.003236s ]
[ 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.002883s ]
[ 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.002767s ]
[ 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.002754s ]
[ 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.003497s ]
[ 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.003373s ]
[ 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.004708s ]
[ 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.002533s ]
[ 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.003392s ]
[ 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.017193s ]
[ 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.003375s ]
[ 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.002671s ]
[ 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.002527s ]
[ 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.003154s ]
[ 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.001882s ]
[ 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.003114s ]
[ 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.002071s ]
[ 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.002073s ]
[ 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.002125s ]
[ 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.002444s ]
[ 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.002836s ]
[ 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.003671s ]
[ 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.003987s ]
[ 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.002667s ]
[ 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.006172s ]
[ 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.003742s ]
[ 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.004338s ]
[ 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.002975s ]
[ 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.030408s ]
[ 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.006066s ]
[ 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.002051s ]
[ 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.002206s ]
[ 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.001922s ]
[ 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.002292s ]
[ 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 2352,16 [ RunTime:0.055211s ]
[ 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.117892s ]
