[ DB ] CONNECT:[ UseTime:0.000968s ] mysql:host=127.0.0.1;dbname=www_crgk8_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fa_course_mnst` [ RunTime:0.002783s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_mnst` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000583s ]
[ SQL ] SHOW COLUMNS FROM `fa_course_lnzt` [ RunTime:0.002139s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_lnzt` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000351s ]
[ SQL ] SHOW COLUMNS FROM `fa_course_fxzl` [ RunTime:0.002080s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_fxzl` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000300s ]
[ SQL ] SHOW COLUMNS FROM `fa_adszone_zone` [ RunTime:0.002461s ]
[ SQL ] SELECT `id`,`name`,`mark`,`type`,`width`,`height`,`code` FROM `fa_adszone_zone` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SHOW COLUMNS FROM `fa_adszone_ads` [ RunTime:0.002420s ]
[ SQL ] SELECT `id`,`title`,`imageurl`,`linkurl`,`target`,`expiretime`,`weigh` FROM `fa_adszone_ads` WHERE `zone_id` = 6 AND `effectime` <= 1790644962 AND `expiretime` >= 1790644962 ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000635s ]
[ SQL ] SHOW COLUMNS FROM `fa_school` [ RunTime:0.001865s ]
[ SQL ] SELECT `s`.*,`x`.`intro`,`z`.`enroll` FROM `fa_school` `s` INNER JOIN `fa_school_xyjj` `x` ON `x`.`id`=`s`.`id` INNER JOIN `fa_school_zsjj` `z` ON `z`.`id`=`s`.`id` WHERE `s`.`diy` = 'jzlgzyxy' LIMIT 1 [ RunTime:0.002916s ]
[ SQL ] UPDATE `fa_school` SET `views`=`views`+1 WHERE `id` = 39 [ RunTime:0.002207s ]
[ SQL ] SHOW COLUMNS FROM `fa_school_news` [ RunTime:0.003865s ]
[ SQL ] SELECT `s`.`diy`,`n`.`id`,`n`.`seo`,`n`.`description`,`n`.`publishtime` FROM `fa_school_news` `n` INNER JOIN `fa_school` `s` ON `s`.`id`=`n`.`school_id` WHERE `n`.`school_id` = 39 AND `n`.`switch` = 1 ORDER BY `n`.`weigh` DESC LIMIT 5 [ RunTime:0.000707s ]
[ SQL ] SELECT `id`,`diy`,`name`,`seo`,`image`,`description`,`tuition` FROM `fa_school` WHERE `switch` = 1 ORDER BY `weigh` DESC LIMIT 100 [ RunTime:0.000699s ]
[ SQL ] SHOW COLUMNS FROM `fa_school_major` [ RunTime:0.001882s ]
[ SQL ] SELECT `m`.`name`,`m`.`id`,`s`.`diy`,`m`.`image`,s.name as schoolname FROM `fa_school_major` `m` INNER JOIN `fa_school` `s` ON `m`.`school_id`=`s`.`id` WHERE `m`.`switch` = 1 ORDER BY `m`.`weigh` DESC LIMIT 9 [ RunTime:0.002550s ]
[ SQL ] SELECT `m`.`id`,`m`.`name`,`m`.`type`,`m`.`greet`,`m`.`form`,`m`.`bytime`,`s`.`diy`,`m`.`image`,`m`.`seo`,`m`.`description`,`p`.`tuition`,`p`.`Installment`,`p`.`entryfee` FROM `fa_school_major` `m` INNER JOIN `fa_school` `s` ON `s`.`id`=`m`.`school_id` INNER JOIN `fa_school_price` `p` ON `p`.`school_id`=s.id and p.type =m.form and p.level =m.type WHERE `m`.`school_id` = 39 AND `m`.`switch` = 1 ORDER BY `m`.`weigh` DESC LIMIT 500 [ RunTime:0.006561s ]