SHOW FULL COLUMNS FROM `dise_category` [ RunTime:0.000522s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 816 [ RunTime:0.000566s ]
SHOW FULL COLUMNS FROM `dise_goods` [ RunTime:0.000699s ]
SELECT COUNT(*) AS think_count FROM `dise_goods` `g` INNER JOIN `dise_company` `c` ON `c`.`uid`=`g`.`uid` INNER JOIN `dise_goods_yarnraw` `y` ON `y`.`gid`=`g`.`id` WHERE `g`.`sign` = 'yarnraw' AND `g`.`is_show` = '1' AND `g`.`status` = '1' LIMIT 1 [ RunTime:0.080968s ]
SELECT `g`.`id`,`g`.`company`,`g`.`litpic`,`g`.`title`,`g`.`retime`,`c`.`domain`,`c`.`uid`,`y`.`blending`,`y`.`standard`,`g`.`is_obs` FROM `dise_goods` `g` INNER JOIN `dise_company` `c` ON `c`.`uid`=`g`.`uid` INNER JOIN `dise_goods_yarnraw` `y` ON `y`.`gid`=`g`.`id` WHERE `g`.`sign` = 'yarnraw' AND `g`.`is_show` = '1' AND `g`.`status` = '1' ORDER BY `g`.`sort` ASC,`g`.`retime` DESC LIMIT 0,30 [ RunTime:0.033558s ]