SHOW FULL COLUMNS FROM `dise_category` [ RunTime:0.067365s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 816 ORDER BY `cat_sort` ASC [ RunTime:0.067073s ]
SELECT `cat_id`,`cat_name` FROM `dise_category` WHERE `cat_pid` = 815 ORDER BY `cat_sort` ASC [ RunTime:0.067228s ]
SHOW FULL COLUMNS FROM `dise_goods` [ RunTime:0.067477s ]
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.119540s ]
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,18 [ RunTime:0.094142s ]
SHOW FULL COLUMNS FROM `dise_scard` [ RunTime:0.081347s ]
SELECT COUNT(*) AS think_count FROM `dise_scard` `s` INNER JOIN `dise_company` `c` ON `c`.`uid`=`s`.`uid` WHERE `s`.`is_show` = '1' AND `s`.`status` = '1' LIMIT 1 [ RunTime:0.085630s ]
SELECT `s`.`id`,`s`.`company`,`s`.`litpic`,`s`.`title`,`s`.`yam`,`s`.`ingredient`,`s`.`is_obs` FROM `dise_scard` `s` INNER JOIN `dise_company` `c` ON `c`.`uid`=`s`.`uid` WHERE `s`.`is_show` = '1' AND `s`.`status` = '1' ORDER BY `s`.`sort` ASC,`s`.`retime` DESC LIMIT 0,18 [ RunTime:0.078187s ]