Illuminate\Database\QueryException {#775
#sql: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
#bindings: array:8 [
0 => 1
1 => 1
2 => ""
3 => "0000-00-00"
4 => 1
5 => "2026-04-17"
6 => "2026-04-17"
7 => ""5""
]
#message: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 '.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELE' at line 1 (SQL: select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = 1 and `is_visible` = 1 and `date` != and `date` != 0000-00-00 and (`is_always` = 1 or (date(`up_date`) <= 2026-04-17 and date(`down_date`) > 2026-04-17)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, "5") order by `date` desc, `w_rank` asc)"
#code: "42000"
#file: "/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 665
-previous: PDOException {#893
#message: "SQLSTATE[42000]: Syntax error or access violation: 1064 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 '.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELE' at line 1"
#code: "42000"
#file: "/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php"
#line: 327
+errorInfo: array:3 [
0 => "42000"
1 => 1064
2 => "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 '.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELE' at line 1"
]
trace: {
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:327 {
Illuminate\Database\Connection->Illuminate\Database\{closure} …
› $statement = $this->prepared($this->getPdoForSelect($useReadPdo)
› ->prepare($query));
›
arguments: {
$statement: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:658 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› try {
› $result = $callback($query, $bindings);
› }
arguments: {
"select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
array:8 [ …8]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
$bindings: array:8 [ …8]
$callback: Closure($query, $bindings) {#871 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
$bindings: array:8 [ …8]
$callback: Closure($query, $bindings) {#871 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2140 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
$bindings: array:8 [ …8]
$useReadPdo: true
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2128 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns(Arr::wrap($columns), function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2572 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2129 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#777 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521 {
Illuminate\Database\Eloquent\Builder->getModels($columns = […1]) …
› return $this->model->hydrate(
› $this->query->get($columns)->all()
› )->all();
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505 {
Illuminate\Database\Eloquent\Builder->get($columns = […1]) …
› // n+1 query issue for the developers to avoid running a lot of queries.
› if (count($models = $builder->getModels($columns)) > 0) {
› $models = $builder->eagerLoadRelations($models);
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/app/Http/Models/News/News.php:57 {
App\Http\Models\News\News::selectData($cateId) …
› ->formatFiles(['img'])
› ->get();
› }
}
/home/hartford/public_html/app/Http/Controllers/Front/NewsController.php:55 {
App\Http\Controllers\Front\NewsController->index(Request $request) …
› foreach($cate as $key=>$row){
› $news=News::selectData($row['id']);
› $cate[$key]['news']=$news;
arguments: {
$cateId: 5
}
}
App\Http\Controllers\Front\NewsController->index() {}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 {
Illuminate\Routing\Controller->callAction($method, $parameters) …
› {
› return call_user_func_array([$this, $method], $parameters);
› }
arguments: {
$function_name: array:2 [ …2]
$parameters: array:3 [ …3]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 {
Illuminate\Routing\ControllerDispatcher->dispatch(Route $route, $controller, $method) …
› if (method_exists($controller, 'callAction')) {
› return $controller->callAction($method, $parameters);
› }
arguments: {
$method: "index"
$parameters: array:3 [ …3]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 {
Illuminate\Routing\Route->runController() …
› return $this->controllerDispatcher()->dispatch(
› $this, $this->getController(), $this->getControllerMethod()
› );
arguments: {
$route: Illuminate\Routing\Route {#407 …}
$controller: App\Http\Controllers\Front\NewsController {#486 …}
$method: "index"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/RedirectOldMiddleware.php:33 {
App\Http\Middleware\RedirectOldMiddleware->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 {
Illuminate\Routing\Middleware\SubstituteBindings->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76 {
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle($request, Closure $next) …
› ) {
› return tap($next($request), function ($response) use ($request) {
› if ($this->shouldAddXsrfTokenCookie()) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 {
Illuminate\View\Middleware\ShareErrorsFromSession->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 {
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle($request, Closure $next) …
› {
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 {
Illuminate\Cookie\Middleware\EncryptCookies->handle($request, Closure $next) …
› {
› return $this->encrypt($next($this->decrypt($request)));
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#480 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#407 …}
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
$route: Illuminate\Routing\Route {#407 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure} …
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/AddHeaders.php:54 {
App\Http\Middleware\AddHeaders->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62 {
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter($request) …
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure($request) {#418 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
Illuminate\Foundation\Http\Kernel->handle($request) …
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/public/index.php:50 {
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
}
}
+errorInfo: array:3 [
0 => "42000"
1 => 1064
2 => "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 '.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELE' at line 1"
]
trace: {
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:665 {
Illuminate\Database\Connection->runQueryCallback($query, $bindings, Closure $callback) …
› catch (Exception $e) {
› throw new QueryException(
› $query, $this->prepareBindings($bindings), $e
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 {
Illuminate\Database\Connection->run($query, $bindings, Closure $callback) …
› try {
› $result = $this->runQueryCallback($query, $bindings, $callback);
› } catch (QueryException $e) {
arguments: {
$query: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
$bindings: array:8 [ …8]
$callback: Closure($query, $bindings) {#871 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:334 {
Illuminate\Database\Connection->select($query, $bindings = [], $useReadPdo = true) …
› return $statement->fetchAll();
› });
› }
arguments: {
$query: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
$bindings: array:8 [ …8]
$callback: Closure($query, $bindings) {#871 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2140 {
Illuminate\Database\Query\Builder->runSelect() …
› return $this->connection->select(
› $this->toSql(), $this->getBindings(), ! $this->useWritePdo
› );
arguments: {
$query: "select en_news.*, 5E1m0isyx5.real_route AS img_url, 5E1m0isyx5.alt AS img_alt from `en_news` left join (SELECT `real_route`, `alt`, `file_key` FROM basic_fms_file) as `5E1m0isyx5` on `en_news`.`img` = `5E1m0isyx5`.`file_key` where `branch_id` = ? and `is_visible` = ? and `date` != ? and `date` != ? and (`is_always` = ? or (date(`up_date`) <= ? and date(`down_date`) > ?)) and (f_id REGEXP '"2"|"4"|"5"') and json_contains(`f_id`, ?) order by `date` desc, `w_rank` asc"
$bindings: array:8 [ …8]
$useReadPdo: true
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2128 {
Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure} …
› return collect($this->onceWithColumns(Arr::wrap($columns), function () {
› return $this->processor->processSelect($this, $this->runSelect());
› }));
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2572 {
Illuminate\Database\Query\Builder->onceWithColumns($columns, $callback) …
›
› $result = $callback();
›
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2129 {
Illuminate\Database\Query\Builder->get($columns = […1]) …
› return $this->processor->processSelect($this, $this->runSelect());
› }));
› }
arguments: {
$columns: array:1 [ …1]
$callback: Closure() {#777 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:521 {
Illuminate\Database\Eloquent\Builder->getModels($columns = […1]) …
› return $this->model->hydrate(
› $this->query->get($columns)->all()
› )->all();
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:505 {
Illuminate\Database\Eloquent\Builder->get($columns = […1]) …
› // n+1 query issue for the developers to avoid running a lot of queries.
› if (count($models = $builder->getModels($columns)) > 0) {
› $models = $builder->eagerLoadRelations($models);
arguments: {
$columns: array:1 [ …1]
}
}
/home/hartford/public_html/app/Http/Models/News/News.php:57 {
App\Http\Models\News\News::selectData($cateId) …
› ->formatFiles(['img'])
› ->get();
› }
}
/home/hartford/public_html/app/Http/Controllers/Front/NewsController.php:55 {
App\Http\Controllers\Front\NewsController->index(Request $request) …
› foreach($cate as $key=>$row){
› $news=News::selectData($row['id']);
› $cate[$key]['news']=$news;
arguments: {
$cateId: 5
}
}
App\Http\Controllers\Front\NewsController->index() {}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 {
Illuminate\Routing\Controller->callAction($method, $parameters) …
› {
› return call_user_func_array([$this, $method], $parameters);
› }
arguments: {
$function_name: array:2 [ …2]
$parameters: array:3 [ …3]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 {
Illuminate\Routing\ControllerDispatcher->dispatch(Route $route, $controller, $method) …
› if (method_exists($controller, 'callAction')) {
› return $controller->callAction($method, $parameters);
› }
arguments: {
$method: "index"
$parameters: array:3 [ …3]
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 {
Illuminate\Routing\Route->runController() …
› return $this->controllerDispatcher()->dispatch(
› $this, $this->getController(), $this->getControllerMethod()
› );
arguments: {
$route: Illuminate\Routing\Route {#407 …}
$controller: App\Http\Controllers\Front\NewsController {#486 …}
$method: "index"
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 {
Illuminate\Routing\Route->run() …
› if ($this->isControllerAction()) {
› return $this->runController();
› }
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 {
Illuminate\Routing\Router->Illuminate\Routing\{closure} …
› return $this->prepareResponse(
› $request, $route->run()
› );
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/RedirectOldMiddleware.php:33 {
App\Http\Middleware\RedirectOldMiddleware->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:41 {
Illuminate\Routing\Middleware\SubstituteBindings->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:76 {
Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle($request, Closure $next) …
› ) {
› return tap($next($request), function ($response) use ($request) {
› if ($this->shouldAddXsrfTokenCookie()) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 {
Illuminate\View\Middleware\ShareErrorsFromSession->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 {
Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle($request, Closure $next) …
› {
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 {
Illuminate\Cookie\Middleware\EncryptCookies->handle($request, Closure $next) …
› {
› return $this->encrypt($next($this->decrypt($request)));
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 {
Illuminate\Routing\Router->runRouteWithinStack(Route $route, Request $request) …
› );
› });
› }
arguments: {
$destination: Closure($request) {#480 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 {
Illuminate\Routing\Router->runRoute(Request $request, Route $route) …
› return $this->prepareResponse($request,
› $this->runRouteWithinStack($route, $request)
› );
arguments: {
$route: Illuminate\Routing\Route {#407 …}
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 {
Illuminate\Routing\Router->dispatchToRoute(Request $request) …
› {
› return $this->runRoute($request, $this->findRoute($request));
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
$route: Illuminate\Routing\Route {#407 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 {
Illuminate\Routing\Router->dispatch(Request $request) …
›
› return $this->dispatchToRoute($request);
› }
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 {
Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure} …
›
› return $this->router->dispatch($request);
› };
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:130 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› try {
› return $destination($passable);
› } catch (Exception $e) {
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/app/Http/Middleware/AddHeaders.php:54 {
App\Http\Middleware\AddHeaders->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 {
Illuminate\Session\Middleware\StartSession->handle($request, Closure $next) …
›
› $response = $next($request);
›
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21 {
Illuminate\Foundation\Http\Middleware\TransformsRequest->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27 {
Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php:62 {
Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle($request, Closure $next) …
›
› return $next($request);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:171 {
Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure} …
› $carry = method_exists($pipe, $this->method)
› ? $pipe->{$this->method}(...$parameters)
› : $pipe(...$parameters);
arguments: {
$request: Illuminate\Http\Request {#51 …}
$next: Closure($passable) {#467 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:105 {
Illuminate\Pipeline\Pipeline->then(Closure $destination) …
›
› return $pipeline($this->passable);
› }
arguments: {
Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:151 {
Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter($request) …
› ->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
› ->then($this->dispatchToRouter());
› }
arguments: {
$destination: Closure($request) {#418 …}
}
}
/home/hartford/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:116 {
Illuminate\Foundation\Http\Kernel->handle($request) …
›
› $response = $this->sendRequestThroughRouter($request);
› } catch (Exception $e) {
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
/home/hartford/public_html/public/index.php:50 {
› $response = $kernel->handle(\r
› $request = Illuminate\Http\Request::capture()\r
› );\r
arguments: {
$request: Illuminate\Http\Request {#51 …}
}
}
}
}