[ DB ] CONNECT:[ UseTime:0.019548s ] mysql:host=bdm64396451.my3w.com;port=3306;dbname=bdm64396451_db;charset=utf8
[ SQL ] SHOW COLUMNS FROM `yx_column` [ RunTime:0.010099s ]
[ SQL ] SELECT * FROM `yx_column` WHERE `column_pid` = 82 AND `column_show` = 1 [ RunTime:0.009168s ]
[ SQL ] SHOW COLUMNS FROM `yx_nmenu` [ RunTime:0.009201s ]
[ SQL ] SELECT * FROM `yx_nmenu` WHERE `wcolumn_id` = 83 [ RunTime:0.008891s ]
[ SQL ] SHOW COLUMNS FROM `yx_web` [ RunTime:0.009194s ]
[ SQL ] SELECT `web_name`,`web_title` FROM `yx_web` WHERE `web_coumn_id` = 83 [ RunTime:0.009011s ]
[ SQL ] SELECT `dataw`.`web_name`,`datap`.`photo_big` FROM yx_web dataw LEFT JOIN `yx_photo` `datap` ON `dataw`.`web_photo`=`datap`.`photo_id` WHERE `web_coumn_id` = 83 [ RunTime:0.009124s ]
[ SQL ] SHOW COLUMNS FROM `yx_tag_link` [ RunTime:0.009200s ]
[ SQL ] SELECT `tag_name`,`tag_link` FROM `yx_tag_link` [ RunTime:0.008857s ]
[ SQL ] SHOW COLUMNS FROM `yx_course` [ RunTime:0.009356s ]
[ SQL ] SELECT * FROM `yx_course` WHERE `course_id` = 188 LIMIT 1 [ RunTime:0.009036s ]
[ SQL ] SHOW COLUMNS FROM `yx_tags` [ RunTime:0.009293s ]
[ SQL ] SELECT * FROM `yx_tags` WHERE `tags_id` IN (0) [ RunTime:0.008899s ]
[ SQL ] SHOW COLUMNS FROM `yx_coursecat` [ RunTime:0.009234s ]
[ SQL ] SELECT * FROM `yx_coursecat` WHERE `ccat_id` = 5 LIMIT 1 [ RunTime:0.008934s ]
[ SQL ] SELECT * FROM yx_coursecat ddcat RIGHT JOIN `yx_course` `ddc` ON `ddcat`.`ccat_id`=`ddc`.`course_cat` WHERE `ddcat`.`ccat_column` = '83' AND `ddcat`.`ccat_name_cn` = 'news' ORDER BY `ddc`.`course_sort` ASC,`ddc`.`course_hot` DESC LIMIT 5 [ RunTime:0.030502s ]
[ SQL ] SHOW COLUMNS FROM `yx_lunbo` [ RunTime:0.009350s ]
[ SQL ] SELECT `datap`.`photo_big`,`dataco`.`course_id`,`dataco`.`course_alt`,`dataco`.`course_fabu`,`dataco`.`course_js`,`datacat`.`ccat_mb`,`datacat`.`ccat_models` FROM yx_lunbo datal LEFT JOIN `yx_photo` `datap` ON `datal`.`lunbo_photo_id`=`datap`.`photo_id` LEFT JOIN `yx_course` `dataco` ON `datal`.`lunbo_course`=`dataco`.`course_id` LEFT JOIN `yx_coursecat` `datacat` ON `dataco`.`course_cat`=`datacat`.`ccat_id` WHERE `datal`.`lunbo_catid` = 6 AND `datacat`.`ccat_column` = '83' AND `dataco`.`course_fabu` < 1711664743 LIMIT 1 [ RunTime:0.009303s ]
[ SQL ] UPDATE `yx_course` SET `course_hot`=`course_hot`+1 WHERE `course_id` = 188 [ RunTime:0.018992s ]
[ SQL ] SELECT `web_name`,`web_title` FROM `yx_web` WHERE `web_coumn_id` = 0 [ RunTime:0.008790s ]
[ SQL ] SELECT `datac`.`course_title`,`datac`.`course_key`,`dataca`.`ccat_name`,`datacol`.`column_name` FROM yx_course datac LEFT JOIN `yx_coursecat` `dataca` ON `datac`.`course_cat`=`dataca`.`ccat_id` LEFT JOIN `yx_column` `datacol` ON `dataca`.`ccat_column`=`datacol`.`column_id` WHERE `datac`.`course_id` = '188' LIMIT 1 [ RunTime:0.008814s ]
[ SQL ] SELECT * FROM `yx_nmenu` WHERE `wcolumn_id` = 83 [ RunTime:0.008684s ]
[ SQL ] SELECT `web_name`,`web_title` FROM `yx_web` WHERE `web_coumn_id` = 83 [ RunTime:0.008743s ]
[ SQL ] SELECT `datac`.`course_title`,`dataca`.`ccat_name`,`datacol`.`column_name`,`dataca`.`ccat_id`,`dataca`.`ccat_mb` FROM yx_course datac LEFT JOIN `yx_coursecat` `dataca` ON `datac`.`course_cat`=`dataca`.`ccat_id` LEFT JOIN `yx_column` `datacol` ON `dataca`.`ccat_column`=`datacol`.`column_id` WHERE `datac`.`course_id` = '188' LIMIT 1 [ RunTime:0.008881s ]
[ SQL ] SELECT * FROM yx_course datac LEFT JOIN `yx_tags` `datat` ON `datac`.`course_tag`=`datat`.`tags_id` LEFT JOIN `yx_photo` `datap` ON `datac`.`course_photo_id`=`datap`.`photo_id` WHERE `datac`.`course_cat` = 15 LIMIT 4 [ RunTime:0.009235s ]
[ SQL ] SELECT `web_name`,`web_title` FROM `yx_web` WHERE `web_coumn_id` = 83 [ RunTime:0.008784s ]
[ SQL ] SELECT `dataw`.`web_name`,`datap`.`photo_big` FROM yx_web dataw LEFT JOIN `yx_photo` `datap` ON `dataw`.`web_photo`=`datap`.`photo_id` WHERE `web_coumn_id` = 83 [ RunTime:0.008738s ]
[ SQL ] SELECT * FROM yx_coursecat dataca WHERE `ccat_column` = 83 AND `ccat_models` = 1 LIMIT 5 [ RunTime:0.008864s ]
[ SQL ] SELECT * FROM yx_coursecat dataca WHERE `dataca`.`ccat_column` = '83' AND ( `dataca`.`ccat_mb` = 'news' or `dataca`.`ccat_mb` = 'works' or `dataca`.`ccat_mb` = 'students' ) LIMIT 5 [ RunTime:0.008853s ]
[ SQL ] SELECT * FROM yx_coursecat dataca LEFT JOIN `yx_course` `datac` ON `dataca`.`ccat_id`=`datac`.`course_cat` WHERE `dataca`.`ccat_column` = '83' AND `dataca`.`ccat_name` = '关于我们' LIMIT 5 [ RunTime:0.018141s ]
[ SQL ] SELECT * FROM yx_coursecat dataca WHERE `dataca`.`ccat_column` = '83' AND ( `dataca`.`ccat_mb` = 'teachers' ) LIMIT 1 [ RunTime:0.008837s ]
[ SQL ] SELECT * FROM yx_coursecat dataca WHERE `dataca`.`ccat_column` = '83' AND ( `dataca`.`ccat_name` = '模特赛事' or `dataca`.`ccat_name` = '联系我们' or `dataca`.`ccat_name` = '媒体报道' ) ORDER BY `dataca`.`ccat_id` DESC LIMIT 5 [ RunTime:0.008889s ]
[ SQL ] SELECT * FROM `yx_coursecat` WHERE `ccat_column` = 83 AND `ccat_name` = '帮助中心' LIMIT 1 [ RunTime:0.008874s ]
[ SQL ] SELECT `dataca`.*,`dataco`.`course_js`,`dataco`.`course_id`,`datamodel`.`models_name` FROM yx_coursecat dataca LEFT JOIN `yx_models` `datamodel` ON `dataca`.`ccat_models`=`datamodel`.`models_id` LEFT JOIN `yx_course` `dataco` ON `dataca`.`ccat_id`=`dataco`.`course_cat` WHERE `dataca`.`ccat_pid` = '38' GROUP BY `dataca`.`ccat_id` ORDER BY `dataca`.`ccat_id` [ RunTime:0.010760s ]
[ SQL ] SELECT * FROM yx_course datac LEFT JOIN `yx_coursecat` `datacc` ON `datac`.`course_cat`=`datacc`.`ccat_id` ORDER BY `datac`.`course_hot` DESC LIMIT 4 [ RunTime:0.027122s ]