[ DB ] CONNECT:[ UseTime:0.000679s ] mysql:host=127.0.0.1;dbname=www_crgk8_com;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fa_course_mnst` [ RunTime:0.002030s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_mnst` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000310s ]
[ SQL ] SHOW COLUMNS FROM `fa_course_lnzt` [ RunTime:0.001776s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_lnzt` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000340s ]
[ SQL ] SHOW COLUMNS FROM `fa_course_fxzl` [ RunTime:0.001607s ]
[ SQL ] SELECT `id`,`seo`,`publishtime`,`views`,`url`,`urls` FROM `fa_course_fxzl` WHERE `switch` = 1 ORDER BY `publishtime` DESC LIMIT 8 [ RunTime:0.000280s ]
[ SQL ] SHOW COLUMNS FROM `fa_adszone_zone` [ RunTime:0.001658s ]
[ SQL ] SELECT `id`,`name`,`mark`,`type`,`width`,`height`,`code` FROM `fa_adszone_zone` WHERE `id` = 6 LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SHOW COLUMNS FROM `fa_adszone_ads` [ RunTime:0.001731s ]
[ SQL ] SELECT `id`,`title`,`imageurl`,`linkurl`,`target`,`expiretime`,`weigh` FROM `fa_adszone_ads` WHERE `zone_id` = 6 AND `effectime` <= 1789017366 AND `expiretime` >= 1789017366 ORDER BY `weigh` DESC,`id` DESC [ RunTime:0.000433s ]
[ SQL ] SHOW COLUMNS FROM `fa_school` [ RunTime:0.001480s ]
[ 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` = 'zgdzdx' LIMIT 1 [ RunTime:0.002997s ]
[ SQL ] UPDATE `fa_school` SET `views`=`views`+1 WHERE `id` = 50 [ RunTime:0.001792s ]
[ SQL ] SHOW COLUMNS FROM `fa_school_news` [ RunTime:0.002094s ]
[ 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` = 50 AND `n`.`switch` = 1 ORDER BY `n`.`weigh` DESC LIMIT 5 [ RunTime:0.000540s ]
[ SQL ] SELECT `id`,`diy`,`name`,`seo`,`image`,`description`,`tuition` FROM `fa_school` WHERE `switch` = 1 ORDER BY `weigh` DESC LIMIT 100 [ RunTime:0.000550s ]
[ SQL ] SHOW COLUMNS FROM `fa_school_major` [ RunTime:0.001503s ]
[ 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.002167s ]
[ 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` = 50 AND `m`.`switch` = 1 ORDER BY `m`.`weigh` DESC LIMIT 500 [ RunTime:0.002669s ]