SHOW FULL COLUMNS FROM `dise_category` [ RunTime:0.068872s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 816 ORDER BY `cat_sort` ASC [ RunTime:0.068648s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 815 ORDER BY `cat_sort` ASC [ RunTime:0.068800s ]
SHOW FULL COLUMNS FROM `dise_yarn_material` [ RunTime:0.077772s ]
SELECT `id`,`zh_first_pinyin`,`en_abbreviation`,`zh`,`en` FROM `dise_yarn_material` ORDER BY `zh_first_pinyin` ASC,`sort` ASC [ RunTime:0.069665s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 816 ORDER BY `cat_sort` ASC [ RunTime:0.068609s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 815 ORDER BY `cat_sort` ASC [ RunTime:0.068765s ]
SHOW FULL COLUMNS FROM `dise_goods` [ RunTime:0.070049s ]
SELECT COUNT(*) AS think_count FROM `dise_goods` `g` INNER JOIN `dise_goods_yarnraw` `y` ON `y`.`gid`=`g`.`id` INNER JOIN `dise_company` `c` ON `c`.`uid`=`g`.`uid` WHERE `g`.`sign` = 'yarnraw' AND `g`.`is_show` = '1' AND `g`.`status` = '1' LIMIT 1 [ RunTime:0.119911s ]
SELECT `g`.`id`,`g`.`company`,`g`.`litpic`,`g`.`title`,`y`.`standard`,`y`.`blending`,`g`.`is_obs` FROM `dise_goods` `g` INNER JOIN `dise_goods_yarnraw` `y` ON `y`.`gid`=`g`.`id` INNER JOIN `dise_company` `c` ON `c`.`uid`=`g`.`uid` WHERE `g`.`sign` = 'yarnraw' AND `g`.`is_show` = '1' AND `g`.`status` = '1' ORDER BY `g`.`sort` ASC,`g`.`retime` DESC LIMIT 0,20 [ RunTime:0.106066s ]
