MODPATH/database/classes/kohana/database/mysql.php [ 194 ]
189 {
190 // This benchmark is worthless
191 Profiler::delete($benchmark);
192 }
193
194 throw new Database_Exception(':error [ :query ]',
195 array(':error' => mysql_error($this->_connection), ':query' => $sql),
196 mysql_errno($this->_connection));
197 }
198
199 if (isset($benchmark))
-
MODPATH/database/classes/kohana/database/query.php [ 251 ] » Kohana_Database_MySQL->query(arguments)
0
integer 1
1
string(222) "SELECT count(*) as dd FROM `sline_line` a LEFT JOIN `sline_allorderlist` b ON (a.id=b.aid AND b.typeid=1 AND a.webid=b.webid) W …"
2
bool FALSE
3
array(0)
246 return new Database_Result_Cached($result, $sql, $as_object, $object_params); 247 } 248 } 249 250 // Execute the query 251 $result = $db->query($this->_type, $sql, $as_object, $object_params); 252 253 if (isset($cache_key) AND $this->_lifetime > 0) 254 { 255 // Cache the result array 256 Kohana::cache($cache_key, $result->as_array(), $this->_lifetime);
-
APPPATH/classes/model/line.php [ 239 ] » Kohana_Database_Query->execute()
234 //计算总数 235 $totalSql = "SELECT count(*) as dd " . strchr($sql, " FROM"); 236 $totalSql = str_replace(strchr($totalSql, "ORDER BY"), '', $totalSql);//去掉order by 237 238 239 $totalN = DB::query(1, $totalSql)->execute()->as_array(); 240 $totalNum = $totalN[0]['dd'] ? $totalN[0]['dd'] : 0; 241 242 //数据量大时的优化方法,数据量小时不推荐使用此方法 243 //$idWhere = "SELECT id FROM `sline_line` ORDER BY id limit $offset, 1"; 244 //$sql = str_replace("WHERE","WHERE a.id>($idWhere) AND",$sql);
-
APPPATH/classes/controller/line.php [ 84 ] » Model_Line::search_result(arguments)
0
array(9) ( "controller" => string(4) "line" "action" => string(4) "list" "destpy" => string(3) "all" "dayid" => integer 0 "priceid" => integer 6 "sorttype" => integer 0 "displaytype" => integer 0 "startcityid" => integer 0 "attrid" => string(2) "98" )
1
string(0) ""
2
integer 1
3
integer 12
79 'startcityid' => $startcityId, 80 'attrid' => $attrId, 81 ); 82 //$start_time=microtime(true); //获取程序开始执行的时间 83 84 $out = Model_Line::search_result($route_array, $keyword, $p, $pagesize); 85 $pager = Pagination::factory( 86 array( 87 88 'current_page' => array('source' => 'route', 'key' => 'p'), 89 'view' => 'default/pagination/search',
-
{PHP internal call} » Controller_Line->action_list()
-
SYSPATH/classes/kohana/request/client/internal.php [ 116 ] » ReflectionMethod->invoke(arguments)
0
object Controller_Line(7)
{ private typeid => integer 1 private _cache_key => string(59) "http://yun1.easy-tour.cn/lines/all-0-6-0-0-0-98-1/?keyword=" public _data => array(4) ( "cmsurl" => string(1) "/" "webname" => string(18) "易欢游旅行网" "typeid" => integer 1 "channelname" => string(12) "团建活动" ) public params => array(1) ( "" => string(1) "0" ) protected cmsurl => string(1) "/" public request => object Request(20)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool FALSE protected _referrer => NULL protected _route => object Route(5)
public response => object Response(5){ protected _callback => NULL protected _uri => string(108) "lines/(<destpy>)(<sign>)(-<dayid>)(-<priceid>)(-<sorttype>)(-<displaytype>)(-<startcityid>)(-<attrid>)(-<p>)" protected _regex => array(9) ( "destpy" => string(12) "[0-9a-zA-Z]+" "sign" => string(3) "\/?" "dayid" => string(6) "[0-9]+" "priceid" => string(6) "[0-9]+" "sorttype" => string(6) "[0-9]+" "displaytype" => string(4) "[^-]" "startcityid" => string(6) "[0-9]+" "attrid" => string(7) "[0-9_]+" "p" => string(6) "[0-9]+" ) protected _defaults => array(2) ( "controller" => string(4) "line" "action" => string(4) "list" ) protected _route_regex => string(233) "#^lines/(?:(?P<destpy>[0-9a-zA-Z]+))?(?:(?P<sign>\/?))?(?:-(?P<dayid>[0-9]+))?(?:-(?P<priceid>[0-9]+))?(?:-(?P<sorttype>[0-9]+)) …" }
protected _routes => array(0) protected _response => object Response(5){ protected _status => integer 200 protected _header => object HTTP_Header(0)
protected _header => object HTTP_Header(0){ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ }
protected _body => NULL protected _directory => string(0) "" protected _controller => string(4) "line" protected _action => string(4) "list" protected _uri => string(24) "lines/all-0-6-0-0-0-98-1" protected _external => bool FALSE protected _params => array(9) ( "destpy" => string(3) "all" "sign" => string(0) "" "dayid" => string(1) "0" "priceid" => string(1) "6" "sorttype" => string(1) "0" "displaytype" => string(1) "0" "startcityid" => string(1) "0" "attrid" => string(2) "98" "p" => string(1) "1" ) protected _get => array(2) ( "s" => string(25) "lines/all-0-6-0-0-0-98-1/" "keyword" => string(0) "" ) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(2){ protected _previous_environment => NULL protected _cache => NULL }
}{ protected _status => integer 200 protected _header => object HTTP_Header(0)
}{ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }111 throw new HTTP_Exception_404('The requested URL :uri was not found on this server.', 112 array(':uri' => $request->uri())); 113 } 114 115 $method = $class->getMethod('action_'.$action); 116 $method->invoke($controller); 117 118 // Execute the "after action" method 119 $class->getMethod('after')->invoke($controller); 120 } 121 catch (Exception $e)
-
SYSPATH/classes/kohana/request/client.php [ 64 ] » Kohana_Request_Client_Internal->execute_request(arguments)
0
object Request(20)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool FALSE protected _referrer => NULL protected _route => object Route(5)
{ protected _callback => NULL protected _uri => string(108) "lines/(<destpy>)(<sign>)(-<dayid>)(-<priceid>)(-<sorttype>)(-<displaytype>)(-<startcityid>)(-<attrid>)(-<p>)" protected _regex => array(9) ( "destpy" => string(12) "[0-9a-zA-Z]+" "sign" => string(3) "\/?" "dayid" => string(6) "[0-9]+" "priceid" => string(6) "[0-9]+" "sorttype" => string(6) "[0-9]+" "displaytype" => string(4) "[^-]" "startcityid" => string(6) "[0-9]+" "attrid" => string(7) "[0-9_]+" "p" => string(6) "[0-9]+" ) protected _defaults => array(2) ( "controller" => string(4) "line" "action" => string(4) "list" ) protected _route_regex => string(233) "#^lines/(?:(?P<destpy>[0-9a-zA-Z]+))?(?:(?P<sign>\/?))?(?:-(?P<dayid>[0-9]+))?(?:-(?P<priceid>[0-9]+))?(?:-(?P<sorttype>[0-9]+)) …" }
protected _routes => array(0) protected _response => object Response(5){ protected _status => integer 200 protected _header => object HTTP_Header(0)
protected _header => object HTTP_Header(0){ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ }
protected _body => NULL protected _directory => string(0) "" protected _controller => string(4) "line" protected _action => string(4) "list" protected _uri => string(24) "lines/all-0-6-0-0-0-98-1" protected _external => bool FALSE protected _params => array(9) ( "destpy" => string(3) "all" "sign" => string(0) "" "dayid" => string(1) "0" "priceid" => string(1) "6" "sorttype" => string(1) "0" "displaytype" => string(1) "0" "startcityid" => string(1) "0" "attrid" => string(2) "98" "p" => string(1) "1" ) protected _get => array(2) ( "s" => string(25) "lines/all-0-6-0-0-0-98-1/" "keyword" => string(0) "" ) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(2){ protected _previous_environment => NULL protected _cache => NULL }
}59 public function execute(Request $request) 60 { 61 if ($this->_cache instanceof HTTP_Cache) 62 return $this->_cache->execute($this, $request); 63 64 return $this->execute_request($request); 65 } 66 67 /** 68 * Processes the request passed to it and returns the response from 69 * the URI resource identified.
-
SYSPATH/classes/kohana/request.php [ 1160 ] » Kohana_Request_Client->execute(arguments)
0
object Request(20)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.1" protected _secure => bool FALSE protected _referrer => NULL protected _route => object Route(5)
{ protected _callback => NULL protected _uri => string(108) "lines/(<destpy>)(<sign>)(-<dayid>)(-<priceid>)(-<sorttype>)(-<displaytype>)(-<startcityid>)(-<attrid>)(-<p>)" protected _regex => array(9) ( "destpy" => string(12) "[0-9a-zA-Z]+" "sign" => string(3) "\/?" "dayid" => string(6) "[0-9]+" "priceid" => string(6) "[0-9]+" "sorttype" => string(6) "[0-9]+" "displaytype" => string(4) "[^-]" "startcityid" => string(6) "[0-9]+" "attrid" => string(7) "[0-9_]+" "p" => string(6) "[0-9]+" ) protected _defaults => array(2) ( "controller" => string(4) "line" "action" => string(4) "list" ) protected _route_regex => string(233) "#^lines/(?:(?P<destpy>[0-9a-zA-Z]+))?(?:(?P<sign>\/?))?(?:-(?P<dayid>[0-9]+))?(?:-(?P<priceid>[0-9]+))?(?:-(?P<sorttype>[0-9]+)) …" }
protected _routes => array(0) protected _response => object Response(5){ protected _status => integer 200 protected _header => object HTTP_Header(0)
protected _header => object HTTP_Header(0){ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.1" }{ }
protected _body => NULL protected _directory => string(0) "" protected _controller => string(4) "line" protected _action => string(4) "list" protected _uri => string(24) "lines/all-0-6-0-0-0-98-1" protected _external => bool FALSE protected _params => array(9) ( "destpy" => string(3) "all" "sign" => string(0) "" "dayid" => string(1) "0" "priceid" => string(1) "6" "sorttype" => string(1) "0" "displaytype" => string(1) "0" "startcityid" => string(1) "0" "attrid" => string(2) "98" "p" => string(1) "1" ) protected _get => array(2) ( "s" => string(25) "lines/all-0-6-0-0-0-98-1/" "keyword" => string(0) "" ) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(2){ protected _previous_environment => NULL protected _cache => NULL }
}1155 throw new Request_Exception('Unable to execute :uri without a Kohana_Request_Client', array( 1156 ':uri' => $this->_uri, 1157 )); 1158 } 1159 1160 return $this->_client->execute($this); 1161 } 1162 1163 /** 1164 * Returns whether this request is the initial request Kohana received. 1165 * Can be used to test for sub requests.
-
DOCROOT/index.php [ 145 ] » Kohana_Request->execute()
140 /** 141 * Execute the main request. A source of the URI can be passed, eg: $_SERVER['PATH_INFO']. 142 * If no source is specified, the URI will be automatically detected. 143 */ 144 echo Request::factory() 145 ->execute() 146 ->send_headers(TRUE) 147 ->body(); 148 149 }