SHOW FULL COLUMNS FROM `pmp_nav` [ RunTime:0.004140s ]
SELECT `id` FROM `pmp_nav` WHERE `name` = 'NAV_WEBSITE' AND `status` = 1 LIMIT 1 [ RunTime:0.003781s ]
SHOW FULL COLUMNS FROM `pmp_slide_info` [ RunTime:0.003854s ]
SELECT `s`.`id`,`s`.`title`,`s`.`src`,`f`.`filepath` FROM `pmp_slide_info` `s` LEFT JOIN `pmp_file` `f` ON `s`.`img`=`f`.`id` LEFT JOIN `pmp_slide` `sl` ON `s`.`slide_id`=`sl`.`id` WHERE `s`.`status` = '1' AND `sl`.`name` = 'INNER_SLIDE' [ RunTime:0.003686s ]
SELECT `s`.`id`,`s`.`title`,`s`.`src`,`f`.`filepath` FROM `pmp_slide_info` `s` LEFT JOIN `pmp_file` `f` ON `s`.`img`=`f`.`id` LEFT JOIN `pmp_slide` `sl` ON `s`.`slide_id`=`sl`.`id` WHERE `s`.`status` = '1' AND `sl`.`name` = 'INDEX_SLIDE' [ RunTime:0.003643s ]
SELECT `s`.`id`,`s`.`title`,`s`.`src`,`f`.`filepath` FROM `pmp_slide_info` `s` LEFT JOIN `pmp_file` `f` ON `s`.`img`=`f`.`id` LEFT JOIN `pmp_slide` `sl` ON `s`.`slide_id`=`sl`.`id` WHERE `s`.`status` = '1' AND `sl`.`name` = 'INDEX_HF' [ RunTime:0.003595s ]
SHOW FULL COLUMNS FROM `pmp_article_cate` [ RunTime:0.003734s ]
SELECT * FROM `pmp_article_cate` [ RunTime:0.003471s ]
SHOW FULL COLUMNS FROM `pmp_links` [ RunTime:0.003675s ]
SELECT * FROM `pmp_links` ORDER BY `sort` DESC [ RunTime:0.003626s ]
SHOW FULL COLUMNS FROM `pmp_article` [ RunTime:0.003767s ]
SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`article_cate_id`,`a`.`desc`,`f`.`filepath` FROM `pmp_article` `a` LEFT JOIN `pmp_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND `a`.`type` = '1' ORDER BY `a`.`id` DESC LIMIT 10 [ RunTime:0.003669s ]
SELECT `id`,`title`,`article_cate_id` FROM `pmp_article` WHERE `status` = 1 AND `is_home` = 1 ORDER BY `id` DESC LIMIT 20 [ RunTime:0.003554s ]
SHOW FULL COLUMNS FROM `pmp_video` [ RunTime:0.003796s ]
SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`create_time`,`a`.`article_cate_id`,`a`.`desc`,`f`.`filepath` FROM `pmp_video` `a` LEFT JOIN `pmp_file` `f` ON `a`.`thumb`=`f`.`id` WHERE `a`.`status` = '1' AND `a`.`is_home` = '1' ORDER BY `a`.`id` DESC LIMIT 20 [ RunTime:0.003659s ]
SHOW FULL COLUMNS FROM `pmp_teacher` [ RunTime:0.003734s ]
SELECT `a`.`id`,`a`.`title`,`a`.`thumb`,`a`.`small_thumb`,`a`.`create_time`,`a`.`desc`,`f`.`filepath`,sf.filepath sf_filepath FROM `pmp_teacher` `a` LEFT JOIN `pmp_file` `f` ON `a`.`thumb`=`f`.`id` LEFT JOIN `pmp_file` `sf` ON `a`.`small_thumb`=`sf`.`id` WHERE `a`.`status` = '1' AND `a`.`is_home` = '1' ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 20 [ RunTime:0.003729s ]
SHOW FULL COLUMNS FROM `pmp_keywords` [ RunTime:0.003672s ]
SHOW FULL COLUMNS FROM `pmp_search_keywords` [ RunTime:0.003706s ]
SELECT * FROM `pmp_search_keywords` ORDER BY `times` DESC LIMIT 10 [ RunTime:0.003644s ]
SHOW FULL COLUMNS FROM `pmp_user_log` [ RunTime:0.003956s ]