static function getCities($regionId, $countryId = "IN") { $cities = Cities::where('country', '=', $countryId)->where('region', '=', $regionId)->lists('name', 'ID'); $queries = DB::getQueryLog(); /* print_R($queries); dd($cities); */ return $cities; }
/** * 返回所有文章 */ function GetAllPost(Request $request) { DB::connection()->enableQueryLog(); $postSrv = new Post(); $res = $postSrv->GetAllPost($request->all()); $res['success'] = $res['data'] ? true : false; $res['sql'] = DB::getQueryLog(); return json_encode($res, JSON_UNESCAPED_UNICODE); }
/** * @param CachingRepositoryInterface $repository */ function check_caching_repository_caching(CachingRepositoryInterface $repository) { DB::enableQueryLog(); $this->assertCount(8, $repository->inProgress()->get()); $this->assertCount(10, $repository->completed()->get()); $this->assertCount(2, DB::getQueryLog()); $this->assertCount(8, $repository->inProgress()->get()); $this->assertCount(10, $repository->completed()->get()); $this->assertCount(2, DB::getQueryLog()); $this->assertCount(18, $repository->all()); $this->assertCount(3, DB::getQueryLog()); $this->assertCount(18, $repository->all()); $this->assertCount(3, DB::getQueryLog()); DB::disableQueryLog(); \Cache::flush(); }
private function buildTree($parent_id, &$container, $level, $max_level, $include_children_count, $include_products_count) { if ($level > $max_level) { return; } $select = array('c.id', 'c.parent_id', 'cd.name'); $query = $this->buildQuery($include_children_count, $include_products_count); $query->where('c.parent_id', $parent_id); $items = $query->get(); $queries = DB::getQueryLog(); $last_query = end($queries)['query']; foreach ($items as $item) { $item->level = $level; $children = array(); $this->buildTree($item->id, $children, $level + 1, $max_level, $include_children_count, $include_products_count); $item->children = $children; $container[] = $item; } }
/** * Prints output * * @return null */ private function output($raw = false) { $sColumns = array_merge_recursive($this->columns, $this->sColumns); $output = array("sEcho" => intval(Input::get('sEcho')), "iTotalRecords" => $this->count_all, "iTotalDisplayRecords" => $this->display_all, "aaData" => $this->result_array_r, "sColumns" => $sColumns); if (Config::get('app.debug', false)) { $output['aQueries'] = DB::getQueryLog(); } if ($raw) { return $output; } else { return Response::json($output); } }
public function query_log() { return DB::getQueryLog(); }
/** * Prints output * * @param bool $raw If raw will output array data, otherwise json * * @return array|json */ protected function output($raw = false) { if (Arr::get($this->input, 'version') == '1.10') { $output = array("draw" => intval($this->input['draw']), "recordsTotal" => $this->count_all, "recordsFiltered" => $this->display_all, "data" => $this->result_array_return); } else { $sColumns = array_merge_recursive($this->columns, $this->sColumns); $output = array("sEcho" => intval($this->input['draw']), "iTotalRecords" => $this->count_all, "iTotalDisplayRecords" => $this->display_all, "aaData" => $this->result_array_return, "sColumns" => $sColumns); } if (Config::get('app.debug', false)) { $output['aQueries'] = DB::getQueryLog(); } if ($raw) { return $output; } else { return Response::json($output); } }
/** * Added the raw information from the game server. Used for debugging only. * * @return $this */ private function verbose() { $serverinfo = $this->serverinfo; $this->data['_raw']['playerlist'] = $this->client->adminGetPlayerlist(); for ($i = 0; $i < count($serverinfo); $i++) { $key = 'K' . $i; $this->data['_raw']['serverinfo'][$key] = $serverinfo[$i]; if (is_numeric($this->data['_raw']['serverinfo'][$key])) { $this->data['_raw']['serverinfo'][$key] = intval($this->data['_raw']['serverinfo'][$key]); } else { if ($this->data['_raw']['serverinfo'][$key] == 'true' || $this->data['_raw']['serverinfo'][$key] == 'false') { $this->data['_raw']['serverinfo'][$key] = $this->data['_raw']['serverinfo'][$key] == 'true' ? true : false; } } } $this->data['_raw']['sql_time'] = 0; $this->data['_raw']['sql'] = DB::getQueryLog(); foreach ($this->data['_raw']['sql'] as $sql) { $this->data['_raw']['sql_time'] = $this->data['_raw']['sql_time'] + $sql['time']; } return $this; }
/** * Log all executed queries into the log file. */ protected function logSqlQueries() { if (!$this->isDebug()) { return; } $queries = DB::getQueryLog(); foreach ($queries as $query) { $this->getLogger()->addInfo(json_encode($query)); } }
/** * Inspect a route. * * @param Client $client * @param string $route */ protected function inspect(Client $client, $route) { try { $this->info('Inspecting ' . $route); $client->request('GET', $route); } catch (Exception $exception) { $this->error('Error inspecting ' . $route); } // Format and sort queries $routeQueries = DB::getQueryLog(); $routeQueries = array_pluck($routeQueries, 'query'); sort($routeQueries); // Cancel if no queries on this page if (empty($routeQueries)) { return; } // Store and flush $this->queries[$route]['response'] = $client->getResponse()->getContent(); $this->queries[$route]['queries'] = $routeQueries; DB::flushQueryLog(); }
/** * Collecting statistics. * * */ public function statistics() { $this->statistics['queries'] = count(\Illuminate\Support\Facades\DB::getQueryLog()); $this->statistics['loading'] = round(microtime(true) - LARAVEL_START, 4); $this->statistics['memory'] = number_format(memory_get_usage()); $this->statistics['version'] = self::VEERVERSION; return $this->statistics; }