Database SQL: "SELECT status,audit_status,id,title,logo as images,city_name as city,area_name as area,town_name as town,price,price_unit FROM t_house WHERE and status = 2 and audit_status = 1 ORDER BY refresh_date desc LIMIT 10", ErrorInfo: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and status = 2 and audit_status = 1 ORDER BY refresh_date desc LIMIT 10' at line 1
- /app/sub/app/lib/speed.php on line 332
327.
}
328.
}
329.
330.
if($sth->execute())return $readonly ? $sth->fetchAll(PDO::FETCH_ASSOC) : $sth->rowCount();
331.
$err = $sth->errorInfo();
332.
333.
err('Database SQL: "' . $sql. '", ErrorInfo: '. $err[2], 1);
}
334.
335.
public function dbInstance($db_config, $db_config_key, $force_replace = false){
336.
if($force_replace || empty($GLOBALS['mysql_instances'][$db_config_key])){
337.
try {
- /app/sub/app/lib/speed.php on line 304
299.
}
300.
}
301.
return $this->page;
302.
}
303.
304.
305.
public function query($sql, $params = array()){return $this->execute($sql, $params, true);}
public function execute($sql, $params = array(), $readonly = false){
306.
$this->sql[] = $sql;
307.
308.
if($readonly && !empty($GLOBALS['mysql']['MYSQL_SLAVE'])){
309.
$slave_key = array_rand($GLOBALS['mysql']['MYSQL_SLAVE']);
- /app/sub/app/lib/speed.php on line 220
215.
$limit = $this->pager($limit[0], $limit[1], $limit[2], $total[0]['M_COUNTER']);
216.
$limit = empty($limit) ? '' : ' LIMIT '.$limit['offset'].','.$limit['limit'];
217.
}else{
218.
$limit = !empty($limit) ? ' LIMIT '.$limit : '';
219.
}
220.
221.
return $this->query('SELECT '. $fields . $sql . $sort . $limit, $conditions["_bindParams"]);
}
222.
223.
public function find($conditions = array(), $sort = null, $fields = '*'){
224.
$res = $this->findAll($conditions, $sort, $fields, 1);
225.
return !empty($res) ? array_pop($res) : false;
- /app/sub/app/model/Factory.php on line 192
187.
if($v['short_name'] == str_replace("市","",$where['city'])){
188.
$newWhere .= " city=".$v['code'];
189.
}
190.
}
191.
}
192.
193.
$ret = $Thouse->findAll(array("$newWhere and status = 2 and audit_status = 1 "),"refresh_date desc","status,audit_status,id,title,logo as images,city_name as city,area_name as area,town_name as town,price,price_unit",10);
if(!empty($ret)){
194.
foreach ($ret as $k=>$v){
195.
if($v['status'] == 2 && $v['audit_status'] == 1 && count($houseList) < 5){
196.
$houseList[] = $v;
197.
}
- /app/sub/app/controller/InvestmentController.php on line 48
43.
$db = new Factory();
44.
$ret = $db->listPage($where,$p);
45.
$this->list = $ret['list'];
46.
$this->page = $ret['page'];
47.
//热门厂房
48.
49.
$hotFactory = $db->hotFactory($this->site);
$this->hot = $hotFactory['list'];
50.
$this->hotUrl = $hotFactory['url'];
51.
//热门城市厂房
52.
$city = new City();
53.
$this->hotCityFac = $city->HotFactory();
- /app/sub/app/lib/speed.php on line 80
75.
if(!is_available_classname($__controller))_err_router("Err: Controller '$controller_name' is not correct!");
76.
if(!class_exists($controller_name, true))_err_router("Err: Controller '$controller_name' is not exists!");
77.
if(!method_exists($controller_name, $action_name))_err_router("Err: Method '$action_name' of '$controller_name' is not exists!");
78.
79.
$controller_obj = new $controller_name();
80.
81.
$controller_obj->$action_name();
82.
if($controller_obj->_auto_display){
83.
$auto_tpl_name = (empty($__module) ? '' : $__module.DS).$__controller.'_'.$__action.'.html';
84.
if(file_exists(APP_CORE.DS.'view'.DS.$auto_tpl_name))$controller_obj->display($auto_tpl_name);
85.
}
- /app/sub/index.php on line 16
11.
12.
require_once INC_PATH . '/functions.php';
13.
require_once INCS_PATH . '/function.php';
14.
require_once INCS_PATH . '/ApiJava.php';
15.
16.
require_once APP_CORE . '/lib/speed.php';