SHOW FULL COLUMNS FROM `dise_goods` [ RunTime:0.001076s ]
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.096136s ]
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.031237s ]
