//引入Loader类(自动加载类)@H_404_1@require_once("Zend/Loader.PHP");@H_404_1@//使用Loader类引入一个Db类@H_404_1@Zend_Loader::loadClass("Zend_Db");@H_404_1@//引入Zend_Db的状态器@H_404_1@Zend_Loader::loadClass("Zend_Db_Statement_Pdo");@H_404_1@//配置数据库连接信息@H_404_1@$Config = array('host' => '127.0.0.1',@H_404_1@'username' => 'root',@H_404_1@'password' => '111',@H_404_1@'dbname' => 'test',@H_404_1@'profiler' => "true"@H_404_1@);@H_404_1@//告诉Zend_Db类所操作的数据库和数据库配置信息@H_404_1@$Db = Zend_Db::factory('PDO_MysqL',$Config); @H_404_1@//执行编码语句 @H_404_1@$Db -> query("set names utf8");@H_404_1@//-----------------------------------------------------@H_404_1@$sql = "select * from gongsi";@H_404_1@$Db -> query($sql);@H_404_1@//调用追踪器的方法@H_404_1@$Profiler = $Db -> getProfiler();@H_404_1@//获取提交语句的条数@H_404_1@echo "提交的个数：" . $Profiler -> getTotalNumQueries() . "
";@H_404_1@//获取sql语句执行的信息@H_404_1@$Result = $Profiler -> getQueryProfiles();@H_404_1@foreach ($Result as $key => $value) @H_404_1@{@H_404_1@//输出运行过的语句@H_404_1@echo "文本内容为:" . $value->getQuery() . "
";@H_404_1@//输出运行语句所花费的时间@H_404_1@echo "花费时间为:" . $value->getElapsedSecs() . "
";@H_404_1@}@H_404_1@//输出所有语句花费的总时间@H_404_1@echo "花费的总时间为:" . $Profiler -> getTotalElapsedSecs();@H_404_1@?>@H_404_1@