[ DB ] CONNECT:[ UseTime:0.007823s ] mysql:host=127.0.0.1;port=3306;dbname=www_gbpxfww_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `archives__links` [ RunTime:0.044480s ]
[ SQL ] SELECT * FROM `archives__links` WHERE ( `aid` = 150000 AND `type` = 2 ) AND `archives__links`.`delete_time` = 0 ORDER BY `weight` DESC [ RunTime:0.001296s ]
[ SQL ] SHOW COLUMNS FROM `archives__school_articles` [ RunTime:0.042482s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( ( (archives__school_articles.flag&(1<<0))>0 ) AND `archives__school_articles`.`type` = 3 AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`create_time` DESC LIMIT 3 [ RunTime:0.001487s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`classify` = 1 AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`create_time` DESC LIMIT 8 [ RunTime:0.001229s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`classify` = 2 AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`create_time` DESC LIMIT 8 [ RunTime:0.001237s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 3 AND `archives__school_articles`.`classify` = 3 AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`create_time` DESC LIMIT 8 [ RunTime:0.001271s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 4 AND `archives__school_articles`.`area_id` = 150000 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`create_time` DESC LIMIT 8 [ RunTime:0.001075s ]
[ SQL ] SHOW COLUMNS FROM `archives__schools` [ RunTime:0.041047s ]
[ SQL ] SELECT `archives__schools`.`id`,`archives__schools`.`name`,`archives__schools`.`icon_id`,f1.path icon_path,`archives__schools`.`panoramic_image_id`,`archives__schools`.`address`,`archives__schools`.`weight`,`archives__schools`.`logo_id`,`archives__schools`.`status`,`archives__schools`.`flag`,`archives__schools`.`abstract`,`archives__schools`.`pinyin`,system__areas.name city FROM `archives__schools` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` LEFT JOIN `system__areas` ON `system__areas`.`id`=`archives__schools`.`area_id` WHERE ( `archives__schools`.`type` IN ('1','2') AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = '0' AND ( (archives__schools.tags&(1<<0))>0 ) ) AND `archives__schools`.`delete_time` = 0 ORDER BY `weight` DESC LIMIT 6 [ RunTime:0.001540s ]
[ SQL ] SELECT `archives__schools`.`id`,`archives__schools`.`name`,`archives__schools`.`icon_id`,f1.path icon_path,`archives__schools`.`panoramic_image_id`,`archives__schools`.`address`,`archives__schools`.`weight`,`archives__schools`.`logo_id`,`archives__schools`.`status`,`archives__schools`.`flag`,`archives__schools`.`abstract`,`archives__schools`.`pinyin`,system__areas.name city FROM `archives__schools` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` LEFT JOIN `system__areas` ON `system__areas`.`id`=`archives__schools`.`area_id` WHERE ( `archives__schools`.`type` = 3 AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = '0' ) AND `archives__schools`.`delete_time` = 0 ORDER BY `weight` DESC LIMIT 8 [ RunTime:0.001257s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__schools`.`name`,`archives__school_articles`.`title`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`abstract`,`archives__school_articles`.`create_time`,`archives__school_articles`.`source`,`archives__school_articles`.`alias_name`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin`,`archives__school_articles`.`image_id` FROM `archives__school_articles` LEFT JOIN `archives__schools` ON `archives__schools`.`id`=`archives__school_articles`.`school_id` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_articles`.`image_id` WHERE ( `archives__school_articles`.`type` = 2 AND `archives__schools`.`area_id` = 150000 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY RAND(),`archives__school_articles`.`show_time` LIMIT 6 [ RunTime:0.015874s ]