[ DB ] CONNECT:[ UseTime:0.004867s ] mysql:host=127.0.0.1;port=3306;dbname=www_gbpxfww_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `archives__school_articles` [ RunTime:0.052664s ]
[ SQL ] SELECT COUNT(*) AS tp_count 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`.`verify` = 1 AND `archives__school_articles`.`type` = 2 AND `archives__schools`.`area_id` = '610000' AND `archives__schools`.`is_show` = 0 ) AND `archives__school_articles`.`delete_time` = 0 [ RunTime:0.001042s ]
[ SQL ] SELECT `archives__school_articles`.`id`,`archives__school_articles`.`title`,`archives__school_articles`.`image_id`,`archives__school_articles`.`create_time`,`archives__school_articles`.`update_time`,`archives__school_articles`.`abstract`,`archives__school_articles`.`alias_name`,`archives__schools`.`name`,`archives__school_articles`.`source`,`archives__school_articles`.`browse_times`,`archives__school_articles`.`school_id`,`archives__school_articles`.`show_time`,f1.path icon_path,`archives__schools`.`pinyin` 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`.`verify` = 1 AND `archives__school_articles`.`type` = 2 AND `archives__schools`.`area_id` = '610000' AND `archives__schools`.`is_show` = 0 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`weight` DESC LIMIT 54,27 [ RunTime:0.053565s ]
[ SQL ] SHOW COLUMNS FROM `system__areas` [ RunTime:0.051089s ]
[ SQL ] SELECT `id`,`name`,`lng`,`lat`,`short`,`pinyin` FROM `system__areas` WHERE `pid` = 0 AND `is_show` <> 1 [ RunTime:0.001146s ]
[ SQL ] SELECT * FROM `system__areas` WHERE `id` = 610000 LIMIT 1 [ RunTime:0.001003s ]
[ 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`.`classify` = 1 AND `archives__schools`.`is_show` = 0 AND `archives__school_articles`.`verify` = 1 ) AND `archives__school_articles`.`delete_time` = 0 ORDER BY `archives__school_articles`.`show_time` LIMIT 10 [ RunTime:0.001755s ]