[ DB ] CONNECT:[ UseTime:0.000575s ] mysql:host=127.0.0.1;port=3306;dbname=ytdnc;charset=utf8
[ SQL ] SHOW COLUMNS FROM `cmf_goods_category` [ RunTime:0.007509s ]
[ SQL ] SELECT `id`,`parent_id`,`name`,`thumb` FROM `cmf_goods_category` WHERE ( `parent_id` = 0 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` LIMIT 9 [ RunTime:0.000723s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 2 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000686s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 55 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000459s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 56 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000443s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 57 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000461s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 58 AND `status` = 1 ) 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` = 59 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000446s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 60 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000449s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 61 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000432s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 62 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000462s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 63 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000465s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 3 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000543s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 87 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000525s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 88 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000453s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 89 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000450s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 4 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000446s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 105 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000446s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 5 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000437s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 114 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000462s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 115 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000477s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 116 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000502s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 117 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000527s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 118 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000506s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 119 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000454s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 120 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000469s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 6 AND `status` = 1 ) 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` = 161 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000504s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 162 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000454s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 7 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000433s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 169 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000435s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 170 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000508s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 1 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000522s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 11 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000474s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 8 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000440s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 9 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000483s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 10 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000468s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 12 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000479s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 13 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000453s ]
[ SQL ] SELECT `id`,`parent_id`,`name` FROM `cmf_goods_category` WHERE ( `parent_id` = 14 AND `status` = 1 ) AND `cmf_goods_category`.`delete_time` = '0' ORDER BY `list_order` [ RunTime:0.000496s ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.005317s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('161','162','163','164','165','166','167','168') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.031255s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('169','170','171','172','173','174','175','176','177','178','179','180','181','182') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.000705s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.010894s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.012286s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.005519s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`thumbnail`,`a`.`price`,`b`.`category_id` FROM `cmf_goods` `a` INNER JOIN `cmf_goods_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`price` <> '0' AND `a`.`post_status` = '1' AND `b`.`category_id` IN ('114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160') ORDER BY `a`.`list_order` DESC,`a`.`create_time` DESC LIMIT 8 [ RunTime:0.011445s ]