[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.001030s ]
[ 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.000605s ]
[ 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.000687s ]
[ 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.000536s ]
[ 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.000503s ]
[ 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.000529s ]
[ 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.000581s ]
[ 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.000548s ]
[ 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.000532s ]
[ 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.000573s ]
[ 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.000578s ]
[ 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.000639s ]
[ 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.000611s ]
[ 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.000596s ]
[ 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.000578s ]
[ 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.000441s ]
[ 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.000550s ]
[ 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.000595s ]
[ 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.000570s ]
[ 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.001225s ]
[ 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.000621s ]
[ 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.000618s ]
[ 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.000615s ]
[ 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.000561s ]
[ 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.000470s ]
[ 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.000448s ]
[ 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.000609s ]
[ 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.000481s ]
[ 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.000400s ]
[ 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.000417s ]
[ 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.000533s ]
[ 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.000704s ]
[ 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.000475s ]
[ 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.000347s ]
[ 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.000408s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2201 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000390s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2202 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000386s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2203 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000398s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2204 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000452s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2205 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000393s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2206 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000428s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2017 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000351s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2018 AND `status` = 1 AND `merchant_id` = 2 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000392s ]
[ SQL ] SELECT `id`,`thumbnail`,`post_title`,`price`,`sales` FROM `cmf_goods` WHERE ( `cate_id` = 2025 AND `id` <> 24247 AND `recommended` = 1 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 6 [ RunTime:0.009058s ]
[ SQL ] SELECT `id`,`thumbnail`,`post_title`,`price`,`market_price`,`sales` FROM `cmf_goods` WHERE ( `cate_id` = 2025 AND `id` <> 24247 ) AND `cmf_goods`.`delete_time` = '0' ORDER BY `sales` DESC LIMIT 3 [ RunTime:0.009167s ]
