SHOW FULL COLUMNS FROM `pj_slide_info` [ RunTime:0.000801s ]
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` = '2' ORDER BY `s`.`sort` DESC,`s`.`id` DESC LIMIT 1 [ RunTime:0.000420s ]
SHOW FULL COLUMNS FROM `pj_goods_cate` [ RunTime:0.000555s ]
SELECT * FROM `pj_goods_cate` WHERE `delete_time` = 0 AND `pid` = 2 ORDER BY `sort` ASC [ RunTime:0.000589s ]
SELECT * FROM `pj_goods_cate` WHERE `delete_time` = 0 AND `id` = 2 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000426s ]
SHOW FULL COLUMNS FROM `pj_goods` [ RunTime:0.000681s ]
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 ('10','11','12') AND `delete_time` = 0 GROUP BY `g`.`id` ORDER BY `g`.`sort` DESC [ RunTime:0.011468s ]
SHOW FULL COLUMNS FROM `pj_file` [ RunTime:0.000648s ]
SELECT * FROM `pj_file` WHERE `id` = 121 LIMIT 1 [ RunTime:0.000319s ]
SELECT * FROM `pj_file` WHERE `id` = 122 LIMIT 1 [ RunTime:0.000272s ]
SELECT * FROM `pj_file` WHERE `id` = 123 LIMIT 1 [ RunTime:0.000273s ]
SELECT * FROM `pj_file` WHERE `id` = 186 LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `pj_file` WHERE `id` = 187 LIMIT 1 [ RunTime:0.000262s ]
SELECT * FROM `pj_file` WHERE `id` = 188 LIMIT 1 [ RunTime:0.000457s ]
SELECT * FROM `pj_file` WHERE `id` = 189 LIMIT 1 [ RunTime:0.000240s ]
SELECT * FROM `pj_file` WHERE `id` = 190 LIMIT 1 [ RunTime:0.000226s ]
SELECT * FROM `pj_file` WHERE `id` = 191 LIMIT 1 [ RunTime:0.000235s ]
SELECT * FROM `pj_file` WHERE `id` = 192 LIMIT 1 [ RunTime:0.000251s ]
SELECT * FROM `pj_file` WHERE `id` = 193 LIMIT 1 [ RunTime:0.000267s ]
SELECT * FROM `pj_file` WHERE `id` = 194 LIMIT 1 [ RunTime:0.000229s ]
SELECT * FROM `pj_file` WHERE `id` = 195 LIMIT 1 [ RunTime:0.000219s ]