[ DB ] CONNECT:[ UseTime:0.002974s ] mysql:host=127.0.0.1;port=3306;dbname=www_gbpxfww_cn;charset=utf8
[ SQL ] SHOW COLUMNS FROM `archives__schools` [ RunTime:0.046453s ]
[ SQL ] SELECT `archives__schools`.`id` FROM `archives__schools` WHERE ( `archives__schools`.`pinyin` = 'cqkjxy' ) AND `archives__schools`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000985s ]
[ SQL ] SHOW COLUMNS FROM `archives__school_images` [ RunTime:0.051071s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `archives__school_images` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_images`.`image_id` WHERE ( `archives__school_images`.`type` = '2' AND `archives__school_images`.`school_id` = 198 AND `archives__school_images`.`verify` = 1 ) AND `archives__school_images`.`delete_time` = 0 [ RunTime:0.001491s ]
[ SQL ] SELECT `archives__school_images`.`id`,`archives__school_images`.`title`,`archives__school_images`.`image_id`,f1.path icon_path,`archives__school_images`.`create_time`,`archives__school_images`.`update_time` FROM `archives__school_images` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__school_images`.`image_id` WHERE ( `archives__school_images`.`type` = '2' AND `archives__school_images`.`school_id` = 198 AND `archives__school_images`.`verify` = 1 ) AND `archives__school_images`.`delete_time` = 0 LIMIT 0,20 [ RunTime:0.001206s ]
[ SQL ] SELECT `archives__schools`.*,f1.path icon_path,f2.path logo_path FROM `archives__schools` LEFT JOIN `system__files` `f1` ON `f1`.`id`=`archives__schools`.`icon_id` LEFT JOIN `system__files` `f2` ON `f2`.`id`=`archives__schools`.`logo_id` WHERE ( `archives__schools`.`id` = 198 AND `archives__schools`.`is_show` = 0 ) AND `archives__schools`.`delete_time` = 0 LIMIT 1 [ RunTime:0.001455s ]
[ SQL ] SHOW COLUMNS FROM `system__code_values` [ RunTime:0.041619s ]
[ SQL ] SELECT `value`,`name` FROM `system__code_values` WHERE ( `code` = 'BB' ) AND `system__code_values`.`delete_time` = 0 [ RunTime:0.001100s ]