SHOW FULL COLUMNS FROM `pj_slide_info` [ RunTime:0.000477s ]
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` = '4' ORDER BY `s`.`sort` DESC,`s`.`id` DESC LIMIT 1 [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `pj_goods_cate` [ RunTime:0.000444s ]
SELECT * FROM `pj_goods_cate` WHERE `delete_time` = 0 AND `pid` = 4 ORDER BY `sort` ASC [ RunTime:0.000366s ]
SELECT * FROM `pj_goods_cate` WHERE `delete_time` = 0 AND `id` = 4 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `pj_goods` [ RunTime:0.000512s ]
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 ('18','19','20') AND `delete_time` = 0 GROUP BY `g`.`id` ORDER BY `g`.`sort` DESC [ RunTime:0.001278s ]
SHOW FULL COLUMNS FROM `pj_file` [ RunTime:0.000531s ]
SELECT * FROM `pj_file` WHERE `id` = 168 LIMIT 1 [ RunTime:0.000284s ]
SELECT * FROM `pj_file` WHERE `id` = 166 LIMIT 1 [ RunTime:0.000281s ]
SELECT * FROM `pj_file` WHERE `id` = 169 LIMIT 1 [ RunTime:0.000225s ]
SELECT * FROM `pj_file` WHERE `id` = 196 LIMIT 1 [ RunTime:0.000259s ]
SELECT * FROM `pj_file` WHERE `id` = 197 LIMIT 1 [ RunTime:0.000309s ]
SELECT * FROM `pj_file` WHERE `id` = 198 LIMIT 1 [ RunTime:0.000262s ]
