[ DB ] CONNECT:[ UseTime:0.082010s ] mysql:host=127.0.0.1;port=3306;dbname=chjie_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.004916s ]
[ 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.003981s ]
[ 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.009760s ]
[ 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.006117s ]
[ 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.003790s ]
[ 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.004422s ]
[ 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.002139s ]
[ 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.003500s ]
[ 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.002439s ]
[ 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.002919s ]
[ 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.003266s ]
[ 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.002210s ]
[ 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.002702s ]
[ 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.001925s ]
[ 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.002687s ]
[ 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.002451s ]
[ 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.002584s ]
[ 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.004629s ]
[ 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.001502s ]
[ 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.003567s ]
[ 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.000926s ]
[ 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.003343s ]
[ 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.001175s ]
[ 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.001132s ]
[ 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.000632s ]
[ 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.000669s ]
[ 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.000640s ]
[ 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.001232s ]
[ 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.001038s ]
[ 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.002748s ]
[ 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.001108s ]
[ 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.000988s ]
[ 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.001039s ]
[ 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.001291s ]
[ 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.002109s ]
[ 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.001306s ]
[ 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.001132s ]
[ 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.001439s ]
[ 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.001300s ]
[ 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.002116s ]
[ 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.003161s ]
[ 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.001796s ]
[ 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.001588s ]
[ 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.001178s ]
[ 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.001246s ]
[ 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.000908s ]
[ 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.000960s ]
[ 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.000885s ]
[ 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.000811s ]
[ 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.001376s ]
[ 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.001387s ]
[ 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.002541s ]
[ 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.001186s ]
[ 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.001072s ]
[ 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.001090s ]
[ 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.001423s ]
[ 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.001274s ]
[ 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.000534s ]
[ 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.000825s ]
[ 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.000624s ]
[ 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.001672s ]
[ 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.000581s ]
[ 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.004368s ]
[ 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.000535s ]
[ 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.001019s ]
[ 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.001818s ]
[ 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.001102s ]
[ 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.001415s ]
