SHOW FULL COLUMNS FROM `pj_slide_info` [ RunTime:0.000490s ]
SELECT `s`.*,`f`.`filepath` FROM `pj_slide_info` `s` LEFT JOIN `pj_file` `f` ON `s`.`img`=`f`.`id` LEFT JOIN `pj_slide` `slide` ON `slide`.`id`=`s`.`slide_id` WHERE `s`.`status` = '1' AND `slide`.`name` = 'goods_list' AND `s`.`desc` = '3' ORDER BY `s`.`sort` DESC,`s`.`id` DESC LIMIT 1 [ RunTime:0.000894s ]
SHOW FULL COLUMNS FROM `pj_goods_cate` [ RunTime:0.001795s ]
SELECT * FROM `pj_goods_cate` WHERE `delete_time` = 0 AND `pid` = 3 ORDER BY `sort` ASC [ RunTime:0.000486s ]
SELECT * FROM `pj_goods_cate` WHERE `delete_time` = 0 AND `id` = 3 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000331s ]
SHOW FULL COLUMNS FROM `pj_goods` [ RunTime:0.000662s ]
SELECT `g`.*,group_concat(k.title) as keywords FROM `pj_goods` `g` LEFT JOIN `pj_goods_keywords` `gk` ON `gk`.`aid`=g.id and gk.status =1 LEFT JOIN `pj_keywords` `k` ON `gk`.`keywords_id`=k.id and k.status =1 WHERE `g`.`cate_id` IN ('13','14','15') AND `delete_time` = 0 GROUP BY `g`.`id` ORDER BY `g`.`sort` DESC [ RunTime:0.010427s ]
