SHOW FULL COLUMNS FROM `dise_goods` [ RunTime:0.000830s ]
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.074291s ]
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.033101s ]
SHOW FULL COLUMNS FROM `dise_scard` [ RunTime:0.000900s ]
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.025352s ]
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.015591s ]