[ DB ] CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;dbname=www_crgk8_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fa_course_mnst` [ RunTime:0.001770s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_mnst` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000263s ]
[ SQL ] SHOW COLUMNS FROM `fa_course_lnzt` [ RunTime:0.001949s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_lnzt` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000252s ]
[ SQL ] SHOW COLUMNS FROM `fa_course_fxzl` [ RunTime:0.001486s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_fxzl` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000248s ]
[ SQL ] SHOW COLUMNS FROM `fa_adszone_zone` [ RunTime:0.001470s ]
[ SQL ] SELECT `id`,`name`,`mark`,`type`,`width`,`height`,`code` FROM `fa_adszone_zone` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SHOW COLUMNS FROM `fa_adszone_ads` [ RunTime:0.001466s ]
[ SQL ] SELECT `id`,`title`,`imageurl`,`linkurl`,`target`,`expiretime`,`weigh` FROM `fa_adszone_ads` WHERE `zone_id` = 6 AND `effectime` <= 1789017419 AND `expiretime` >= 1789017419 ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000372s ]
[ SQL ] SHOW COLUMNS FROM `fa_school` [ RunTime:0.001310s ]
[ 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.002197s ]
[ SQL ] UPDATE `fa_school` SET `views`=`views`+1 WHERE `id` = 39 [ RunTime:0.001876s ]
[ SQL ] SHOW COLUMNS FROM `fa_school_news` [ RunTime:0.001854s ]
[ 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.000586s ]
[ SQL ] SELECT `id`,`diy`,`name`,`seo`,`image`,`description`,`tuition` FROM `fa_school` WHERE `switch` = 1 ORDER BY `weigh` DESC LIMIT 100 [ RunTime:0.000781s ]
[ SQL ] SHOW COLUMNS FROM `fa_school_major` [ RunTime:0.001672s ]
[ 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.002030s ]
[ 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.003364s ]