[ DB ] CONNECT:[ UseTime:0.010696s ] mysql_host=127.0.0.1;port=3306;dbname=www_yxhart_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `xiju_portal_video_category` [ RunTime:0.091013s ]
[ 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.000486s ]
[ 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.000371s ]
[ 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.000392s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_category` [ RunTime:0.087779s ]
[ SQL ] SELECT * FROM `xiju_portal_category` WHERE `parent_id` = 9 AND `delete_time` = 0 AND `status` = 1 [ RunTime:0.000568s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_works_category` [ RunTime:0.023649s ]
[ SQL ] SELECT `id`,`name` FROM `xiju_portal_works_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 14 [ RunTime:0.000544s ]
[ SQL ] SHOW COLUMNS FROM `xiju_nav_menu` [ RunTime:0.073740s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 0 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000430s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 1 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000535s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 2 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000464s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 127 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000413s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 129 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000324s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 128 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000274s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 134 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000356s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 133 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000377s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 3 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000362s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 124 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000338s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 131 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000306s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 120 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000302s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 4 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000249s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 7 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000244s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 108 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000366s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 5 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000297s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 132 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000308s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 135 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000275s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 6 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000395s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 8 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000364s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 121 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000328s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 100 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000276s ]
[ SQL ] SELECT * FROM `xiju_nav_menu` WHERE `nav_id` = 1 AND `parent_id` = 9 AND `status` = 1 ORDER BY list_order asc,id asc [ RunTime:0.000306s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_post` [ RunTime:0.057834s ]
[ 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` = 1719 LIMIT 1 [ RunTime:0.000671s ]
[ SQL ] SHOW COLUMNS FROM `xiju_user_favorite` [ RunTime:0.040014s ]
[ SQL ] SELECT * FROM `xiju_user_favorite` WHERE `user_id` = 0 AND `table_name` = ‘portal_post’ AND `object_id` = 1719 LIMIT 1 [ RunTime:0.000488s ]
[ SQL ] SHOW COLUMNS FROM `xiju_user_like` [ RunTime:0.020165s ]
[ SQL ] SELECT * FROM `xiju_user_like` WHERE `user_id` = 0 AND `table_name` = ‘portal_post’ AND `object_id` = 1719 LIMIT 1 [ RunTime:0.000565s ]
[ SQL ] SHOW COLUMNS FROM `xiju_comment` [ RunTime:0.071479s ]
[ SQL ] SELECT `id`,`content`,`user_id`,`create_time` FROM `xiju_comment` WHERE `table_name` = ‘portal_post’ AND `object_id` = 1719 ORDER BY create_time desc LIMIT 0,7 [ RunTime:0.000467s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `xiju_comment` WHERE `table_name` = ‘portal_post’ AND `object_id` = 1719 LIMIT 1 [ RunTime:0.000356s ]
[ SQL ] SHOW COLUMNS FROM `xiju_option` [ RunTime:0.081688s ]
[ SQL ] SELECT `option_value` FROM `xiju_option` WHERE `option_name` = ‘storage’ LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] UPDATE `xiju_portal_post` SET `post_hits`=`post_hits`+1 WHERE `id` = 1719 [ RunTime:0.008285s ]
[ 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.000607s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_video_post` [ RunTime:0.065496s ]
[ 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.000693s ]
[ SQL ] SHOW COLUMNS FROM `xiju_user` [ RunTime:0.025804s ]
[ SQL ] SELECT `id`,`user_nickname`,`avatar`,`signature` FROM `xiju_user` WHERE `id` IN (1780,1782,1766,1778) [ RunTime:0.000352s ]
[ 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.000304s ]
[ SQL ] SELECT `id`,`user_nickname`,`avatar`,`signature` FROM `xiju_user` WHERE `id` IN (1780,1777,1771,1766) [ RunTime:0.000338s ]
[ 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.000654s ]
[ SQL ] SHOW COLUMNS FROM `xiju_portal_tag` [ RunTime:0.058200s ]
[ SQL ] SELECT * FROM `xiju_portal_tag` WHERE `recommended` = 1 [ RunTime:0.000397s ]
[ 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` > ‘1719’ ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001011s ]
[ SQL ] SHOW COLUMNS FROM `xiju_theme_file` [ RunTime:0.059064s ]
[ SQL ] SELECT * FROM `xiju_theme_file` WHERE `theme` = ‘latest’ AND `file` = ‘latest/index’ LIMIT 1 [ RunTime:0.000601s ]
[ SQL ] UPDATE `xiju_theme_file` SET `theme`=’latest’,`action`=’latest/Index/index’,`file`=’latest/index’,`name`=’首页’,`more`='{“vars””:{“”desc1″”:{“”title””:””线下实训学院【描述信息】″”
来源：””type””:””text””
声明：本站部分文章及图片转载于互联网，内容版权归原作者所有，如本站任何资料有侵权请您尽早请联系jinwei@zod.com.cn进行处理,非常感谢！