[ DB ] CONNECT:[ UseTime:0.001375s ] mysql_host=127.0.0.1;port=3306;dbname=www_yxhart_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `xiju_portal_video_category` [ RunTime:0.022410s ]
[ SQL ] SELECT `id`,`name` FROM `xiju_portal_video_category` WHERE `parent_id` IN (1,24) AND `status` = 1 AND `delete_time` = 0 ORDER BY list_order asc LIMIT 8 [ RunTime:0.000509s ]
[ SQL ] SELECT `id`,`name` FROM `xiju_portal_video_category` WHERE `parent_id` = 8 AND `status` = 1 AND `delete_time` = 0 ORDER BY list_order asc LIMIT 8 [ RunTime:0.000276s ]
[ SQL ] SELECT `id`,`name` FROM `xiju_portal_video_category` WHERE `parent_id` IN (1,24) AND `is_class` = 1 AND `status` = 1 AND `delete_time` = 0 OR `id` IN (59,60) ORDER BY list_order asc LIMIT 20 [ RunTime:0.000238s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_category` [ RunTime:0.021968s ]
[ SQL ] SELECT * FROM `xiju_portal_category` WHERE `parent_id` = 9 AND `delete_time` = 0 AND `status` = 1 [ RunTime:0.000535s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_works_category` [ RunTime:0.020302s ]
[ SQL ] SELECT `id`,`name` FROM `xiju_portal_works_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 14 [ RunTime:0.000373s ]
[ SQL ] SHOW COLUMNS FROM `xiju_nav_menu` [ RunTime:0.018834s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000417s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_post` [ RunTime:0.021878s ]
[ SQL ] SELECT `a`.`id`,`post_title`,`post_hits`,`post_keywords`,`post_excerpt`,`post_like`,`post_content`,`more`,`author`,`published_time`,`b`.`category_id` FROM `xiju_portal_post` `a` INNER JOIN `xiju_portal_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`id` = 261 LIMIT 1 [ RunTime:0.000887s ]
[ SQL ] SHOW COLUMNS FROM `xiju_user_favorite` [ RunTime:0.020485s ]
[ SQL ] SELECT * FROM `xiju_user_favorite` WHERE `user_id` = 0 AND `table_name` = ‘portal_post’ AND `object_id` = 261 LIMIT 1 [ RunTime:0.000371s ]
[ SQL ] SHOW COLUMNS FROM `xiju_user_like` [ RunTime:0.020683s ]
[ SQL ] SELECT * FROM `xiju_user_like` WHERE `user_id` = 0 AND `table_name` = ‘portal_post’ AND `object_id` = 261 LIMIT 1 [ RunTime:0.000380s ]
[ SQL ] SHOW COLUMNS FROM `xiju_comment` [ RunTime:0.019763s ]
[ SQL ] SELECT `id`,`content`,`user_id`,`create_time` FROM `xiju_comment` WHERE `table_name` = ‘portal_post’ AND `object_id` = 261 ORDER BY create_time desc LIMIT 0,7 [ RunTime:0.000417s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `xiju_comment` WHERE `table_name` = ‘portal_post’ AND `object_id` = 261 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SHOW COLUMNS FROM `xiju_option` [ RunTime:0.012703s ]
[ SQL ] SELECT `option_value` FROM `xiju_option` WHERE `option_name` = ‘storage’ LIMIT 1 [ RunTime:0.000272s ]
[ SQL ] UPDATE `xiju_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 261 [ RunTime:0.004573s ]
[ SQL ] SELECT `id`,`name`,`lecturer`,`more` FROM `xiju_portal_video_category` WHERE `parent_id` = 24 AND `status` = 1 AND `delete_time` = 0 ORDER BY list_order asc LIMIT 6 [ RunTime:0.000367s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_video_post` [ RunTime:0.020972s ]
[ SQL ] SELECT `a`.`id`,`a`.`post_title`,`a`.`post_excerpt`,`a`.`more`,`a`.`price`,`a`.`user_id`,`a`.`post_hits`,`b`.`category_id` FROM `xiju_portal_video_post` `a` LEFT JOIN `xiju_portal_video_category_post` `b` ON `a`.`id`=`b`.`post_id` WHERE `a`.`recommended` = 1 AND `post_type` = 1 AND `post_status` = 1 AND `delete_time` = 0 AND `is_class_video` = 0 GROUP BY `a`.`id` ORDER BY a.is_top desc,a.recommended desc,b.list_order asc,a.published_time desc LIMIT 0,7 [ RunTime:0.000511s ]
[ SQL ] SHOW COLUMNS FROM `xiju_user` [ RunTime:0.019693s ]
[ SQL ] SELECT `id`,`user_nickname`,`avatar`,`signature` FROM `xiju_user` WHERE `id` IN (1780,1782,1766,1778) [ RunTime:0.000428s ]
[ SQL ] SELECT `id`,`user_id`,`post_title`,`more` FROM `xiju_portal_video_post` WHERE `post_type` = 1 AND `post_status` = 1 AND `delete_time` = 0 AND `is_class_video` = 0 ORDER BY recommended desc LIMIT 5 [ RunTime:0.000516s ]
[ SQL ] SELECT `id`,`user_nickname`,`avatar`,`signature` FROM `xiju_user` WHERE `id` IN (1780,1777,1771,1766) [ RunTime:0.000206s ]
[ SQL ] SELECT `id`,`post_title` FROM `xiju_portal_post` WHERE `post_type` = 1 AND `post_status` = 1 AND `delete_time` = 0 ORDER BY recommended desc LIMIT 10 [ RunTime:0.000514s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_tag` [ RunTime:0.020022s ]
[ SQL ] SELECT * FROM `xiju_portal_tag` WHERE `recommended` = 1 [ RunTime:0.000493s ]
[ SQL ] SELECT `post`.* FROM `xiju_portal_post` `post` WHERE `post`.`post_type` = 1 AND ( `post`.`published_time` ‘0’ ) AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id`
[ SQL ] SELECT `post`.* FROM `xiju_portal_post` `post` WHERE `post`.`post_type` = 1 AND ( `post`.`published_time` ‘0’ ) AND `post`.`post_status` = 1 AND `post`.`delete_time` = 0 AND `post`.`id` > ‘261’ ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000683s ]
[ SQL ] SHOW COLUMNS FROM `xiju_theme_file` [ RunTime:0.012074s ]
[ SQL ] SELECT * FROM `xiju_theme_file` WHERE `theme` = ‘latest’ AND `file` = ‘latest/index’ LIMIT 1 [ RunTime:0.000381s ]
[ SQL ] UPDATE `xiju_theme_file` SET `theme`=’latest’,`action`=’latest/Index/index’,`file`=’latest/index’,`name`=’首页’,`more`='{“vars””:{“”desc1″”:{“”title””:””线下实训学院【描述信息】″”
声明：本站部分文章及图片源自用户投稿，如本站任何资料有侵权请您尽早请联系jinwei@zod.com.cn进行处理,非常感谢！