// If an exception occurs when attempting to run a query, we'll format the error
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
catch (Exception $e) {
throw new QueryException(
$query, $this->prepareBindings($bindings), $e
);
}
}
// Here we will run this query. If an exception occurs we'll determine if it was
// caused by a connection that has been lost. If that is the cause, we'll try
// to re-establish connection and re-run the query with a fresh connection.
try {
$result = $this->runQueryCallback($query, $bindings, $callback);
} catch (QueryException $e) {
$result = $this->handleQueryException(
$e, $query, $bindings, $callback
);
}
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
return $statement->fetchAll();
});
}
/**
* Run a select statement against the database and returns a generator.
*
* @return array
*/
protected function runSelect()
{
return $this->connection->select(
$this->toSql(), $this->getBindings(), ! $this->useWritePdo
);
}
/**
* Paginate the given query into a simple paginator.
* @return \Illuminate\Support\Collection
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
if (is_null($original)) {
$this->columns = $columns;
}
$result = $callback();
$this->columns = $original;
return $result;
}
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
*
* @return \Illuminate\Database\Eloquent\Model[]|static[]
*/
public function getModels($columns = ['*'])
{
return $this->model->hydrate(
$this->query->get($columns)->all()
)->all();
}
/**
* Eager load the relationships for the models.
$builder = $this->applyScopes();
// If we actually found models we will also eager load any relationships that
// have been specified as needing to be eager loaded, which will solve the
// 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);
}
return $builder->getModel()->newCollection($models);
}
if (!empty($posts)) {
return $posts;
}
$posts = $query->get();
Cache::put($cache_key, $posts, $cacheTime);
return $posts;
}
* @param array $parameters
* @return mixed
*/
public function callNamedScope($scope, array $parameters = [])
{
return $this->{'scope'.ucfirst($scope)}(...$parameters);
}
/**
* Convert the model instance to an array.
*
* @return mixed
*/
protected function callNamedScope($scope, array $parameters = [])
{
return $this->callScope(function (...$parameters) use ($scope) {
return $this->model->callNamedScope($scope, $parameters);
}, $parameters);
}
/**
* Nest where conditions by slicing them at the given where count.
// scope so that we can properly group the added scope constraints in the
// query as their own isolated nested where statement and avoid issues.
$originalWhereCount = is_null($query->wheres)
? 0 : count($query->wheres);
$result = $scope(...array_values($parameters)) ?? $this;
if (count((array) $query->wheres) > $originalWhereCount) {
$this->addNewWheresWithinGroup($query, $originalWhereCount);
}
* @param array $parameters
* @return mixed
*/
protected function callNamedScope($scope, array $parameters = [])
{
return $this->callScope(function (...$parameters) use ($scope) {
return $this->model->callNamedScope($scope, $parameters);
}, $parameters);
}
/**
return $callable(...$parameters);
}
if ($this->hasNamedScope($method)) {
return $this->callNamedScope($method, $parameters);
}
if (in_array($method, $this->passthru)) {
return $this->toBase()->{$method}(...$parameters);
}
->getStats('seven_days_stats', 'DESC', 7)
->byCategories($allIds)
->byPublished()
->byLanguage()
->byApproved()
->getCached('cat_trending_' . $category->id, now()->addMinutes(5));
if ($request->ajax() && $request->query('page')) {
return view('pages.catpostloadpage', compact('posts'));
}
* @param array $parameters
* @return \Symfony\Component\HttpFoundation\Response
*/
public function callAction($method, $parameters)
{
return $this->{$method}(...array_values($parameters));
}
/**
* Handle calls to missing methods on the controller.
*
$parameters = $this->resolveClassMethodDependencies(
$route->parametersWithoutNulls(), $controller, $method
);
if (method_exists($controller, 'callAction')) {
return $controller->callAction($method, $parameters);
}
return $controller->{$method}(...array_values($parameters));
}
* @throws \Symfony\Component\HttpKernel\Exception\NotFoundHttpException
*/
protected function runController()
{
return $this->controllerDispatcher()->dispatch(
$this, $this->getController(), $this->getControllerMethod()
);
}
/**
* Get the controller instance for the route.
{
$this->container = $this->container ?: new Container;
try {
if ($this->isControllerAction()) {
return $this->runController();
}
return $this->runCallable();
} catch (HttpResponseException $e) {
return $e->getResponse();
return (new Pipeline($this->container))
->send($request)
->through($middleware)
->then(function ($request) use ($route) {
return $this->prepareResponse(
$request, $route->run()
);
});
}
/**
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
} else {
abort(503);
}
}
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
throw $exception;
}
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->isReading($request) ||
$this->runningUnitTests() ||
$this->inExceptArray($request) ||
$this->tokensMatch($request)
) {
return tap($next($request), function ($response) use ($request) {
if ($this->shouldAddXsrfTokenCookie()) {
$this->addCookieToResponse($request, $response);
}
});
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
// Putting the errors in the view for every view allows the developer to just
// assume that some errors are always available, which is convenient since
// they don't have to continually run checks for the presence of errors.
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->startSession($request, $session)
);
$this->collectGarbage($session);
$response = $next($request);
$this->storeCurrentUrl($request, $session);
$this->addCookieToResponse($response, $session);
if ($this->manager->shouldBlock() ||
($request->route() instanceof Route && $request->route()->locksFor())) {
return $this->handleRequestWhileBlocking($request, $session, $next);
}
return $this->handleStatefulRequest($request, $session, $next);
}
/**
* Handle the given request within session state.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$response = $next($request);
foreach ($this->cookies->getQueuedCookies() as $cookie) {
$response->headers->setCookie($cookie);
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
* @param \Closure $next
* @return \Symfony\Component\HttpFoundation\Response
*/
public function handle($request, Closure $next)
{
return $this->encrypt($next($this->decrypt($request)));
}
/**
* Decrypt the cookies on the request.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
->through($middleware)
->then(function ($request) use ($route) {
return $this->prepareResponse(
$request, $route->run()
);
});
}
/**
* Gather the middleware for the given route with resolved class names.
*
});
$this->events->dispatch(new RouteMatched($route, $request));
return $this->prepareResponse($request,
$this->runRouteWithinStack($route, $request)
);
}
/**
* Run the given route within a Stack "onion" instance.
* @param \Illuminate\Http\Request $request
* @return \Symfony\Component\HttpFoundation\Response
*/
public function dispatchToRoute(Request $request)
{
return $this->runRoute($request, $this->findRoute($request));
}
/**
* Find the route matching a given request.
*
*/
public function dispatch(Request $request)
{
$this->currentRequest = $request;
return $this->dispatchToRoute($request);
}
/**
* Dispatch the request to a route and return the response.
*
protected function dispatchToRouter()
{
return function ($request) {
$this->app->instance('request', $request);
return $this->router->dispatch($request);
};
}
/**
* Call the terminate method on any terminable middleware.
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
$locale = get_buzzy_locale();
app()->setLocale($locale);
Carbon::setLocale($locale);
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
if ($max > 0 && $request->server('CONTENT_LENGTH') > $max) {
throw new PostTooLargeException;
}
return $next($request);
}
/**
* Determine the server 'post_max_size' as bytes.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
null,
$this->getHeaders($data)
);
}
return $next($request);
}
/**
* Determine if the incoming request has a maintenance mode bypass cookie.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
// Check if we're dealing with CORS and if we should handle it
if (! $this->shouldRun($request)) {
return $next($request);
}
// For Preflight, return the Preflight response
if ($this->cors->isPreflightRequest($request)) {
$response = $this->cors->handlePreflightRequest($request);
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
public function handle(Request $request, Closure $next)
{
$request::setTrustedProxies([], $this->getTrustedHeaderNames()); // Reset trusted proxies between requests
$this->setTrustedProxyIpAddresses($request);
return $next($request);
}
/**
* Sets the trusted proxies on the request to the value of trustedproxy.proxies
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
$this->bootstrap();
return (new Pipeline($this->app))
->send($request)
->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
->then($this->dispatchToRouter());
}
/**
* Bootstrap the application for HTTP requests.
*
public function handle($request)
{
try {
$request->enableHttpMethodParameterOverride();
$response = $this->sendRequestThroughRouter($request);
} catch (Throwable $e) {
$this->reportException($e);
$response = $this->renderException($request, $e);
}
*/
$kernel = $app->make(Illuminate\Contracts\Http\Kernel::class);
$response = $kernel->handle(
$request = Illuminate\Http\Request::capture()
);
$response->send();
$kernel->terminate($request, $response);
// For select statements, we'll simply execute the query and return an array
// of the database result set. Each element in the array will be a single
// row from the database table, and will either be an array or objects.
$statement = $this->prepared(
$this->getPdoForSelect($useReadPdo)->prepare($query)
);
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
// For select statements, we'll simply execute the query and return an array
// of the database result set. Each element in the array will be a single
// row from the database table, and will either be an array or objects.
$statement = $this->prepared(
$this->getPdoForSelect($useReadPdo)->prepare($query)
);
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
{
// To execute the statement, we'll simply call the callback, which will actually
// run the SQL against the PDO connection. Then we can calculate the time it
// took to execute and log the query SQL, bindings and time in our memory.
try {
return $callback($query, $bindings);
}
// If an exception occurs when attempting to run a query, we'll format the error
// message to include the bindings with SQL, which will make this exception a
// lot more helpful to the developer instead of just the database's errors.
// Here we will run this query. If an exception occurs we'll determine if it was
// caused by a connection that has been lost. If that is the cause, we'll try
// to re-establish connection and re-run the query with a fresh connection.
try {
$result = $this->runQueryCallback($query, $bindings, $callback);
} catch (QueryException $e) {
$result = $this->handleQueryException(
$e, $query, $bindings, $callback
);
}
$this->bindValues($statement, $this->prepareBindings($bindings));
$statement->execute();
return $statement->fetchAll();
});
}
/**
* Run a select statement against the database and returns a generator.
*
* @return array
*/
protected function runSelect()
{
return $this->connection->select(
$this->toSql(), $this->getBindings(), ! $this->useWritePdo
);
}
/**
* Paginate the given query into a simple paginator.
* @return \Illuminate\Support\Collection
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
if (is_null($original)) {
$this->columns = $columns;
}
$result = $callback();
$this->columns = $original;
return $result;
}
*/
public function get($columns = ['*'])
{
return collect($this->onceWithColumns(Arr::wrap($columns), function () {
return $this->processor->processSelect($this, $this->runSelect());
}));
}
/**
* Run the query as a "select" statement against the connection.
*
* @return \Illuminate\Database\Eloquent\Model[]|static[]
*/
public function getModels($columns = ['*'])
{
return $this->model->hydrate(
$this->query->get($columns)->all()
)->all();
}
/**
* Eager load the relationships for the models.
$builder = $this->applyScopes();
// If we actually found models we will also eager load any relationships that
// have been specified as needing to be eager loaded, which will solve the
// 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);
}
return $builder->getModel()->newCollection($models);
}
if (!empty($posts)) {
return $posts;
}
$posts = $query->get();
Cache::put($cache_key, $posts, $cacheTime);
return $posts;
}
* @param array $parameters
* @return mixed
*/
public function callNamedScope($scope, array $parameters = [])
{
return $this->{'scope'.ucfirst($scope)}(...$parameters);
}
/**
* Convert the model instance to an array.
*
* @return mixed
*/
protected function callNamedScope($scope, array $parameters = [])
{
return $this->callScope(function (...$parameters) use ($scope) {
return $this->model->callNamedScope($scope, $parameters);
}, $parameters);
}
/**
* Nest where conditions by slicing them at the given where count.
// scope so that we can properly group the added scope constraints in the
// query as their own isolated nested where statement and avoid issues.
$originalWhereCount = is_null($query->wheres)
? 0 : count($query->wheres);
$result = $scope(...array_values($parameters)) ?? $this;
if (count((array) $query->wheres) > $originalWhereCount) {
$this->addNewWheresWithinGroup($query, $originalWhereCount);
}
* @param array $parameters
* @return mixed
*/
protected function callNamedScope($scope, array $parameters = [])
{
return $this->callScope(function (...$parameters) use ($scope) {
return $this->model->callNamedScope($scope, $parameters);
}, $parameters);
}
/**
return $callable(...$parameters);
}
if ($this->hasNamedScope($method)) {
return $this->callNamedScope($method, $parameters);
}
if (in_array($method, $this->passthru)) {
return $this->toBase()->{$method}(...$parameters);
}
->getStats('seven_days_stats', 'DESC', 7)
->byCategories($allIds)
->byPublished()
->byLanguage()
->byApproved()
->getCached('cat_trending_' . $category->id, now()->addMinutes(5));
if ($request->ajax() && $request->query('page')) {
return view('pages.catpostloadpage', compact('posts'));
}
* @param array $parameters
* @return \Symfony\Component\HttpFoundation\Response
*/
public function callAction($method, $parameters)
{
return $this->{$method}(...array_values($parameters));
}
/**
* Handle calls to missing methods on the controller.
*
$parameters = $this->resolveClassMethodDependencies(
$route->parametersWithoutNulls(), $controller, $method
);
if (method_exists($controller, 'callAction')) {
return $controller->callAction($method, $parameters);
}
return $controller->{$method}(...array_values($parameters));
}
* @throws \Symfony\Component\HttpKernel\Exception\NotFoundHttpException
*/
protected function runController()
{
return $this->controllerDispatcher()->dispatch(
$this, $this->getController(), $this->getControllerMethod()
);
}
/**
* Get the controller instance for the route.
{
$this->container = $this->container ?: new Container;
try {
if ($this->isControllerAction()) {
return $this->runController();
}
return $this->runCallable();
} catch (HttpResponseException $e) {
return $e->getResponse();
return (new Pipeline($this->container))
->send($request)
->through($middleware)
->then(function ($request) use ($route) {
return $this->prepareResponse(
$request, $route->run()
);
});
}
/**
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
} else {
abort(503);
}
}
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
throw $exception;
}
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->isReading($request) ||
$this->runningUnitTests() ||
$this->inExceptArray($request) ||
$this->tokensMatch($request)
) {
return tap($next($request), function ($response) use ($request) {
if ($this->shouldAddXsrfTokenCookie()) {
$this->addCookieToResponse($request, $response);
}
});
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
// Putting the errors in the view for every view allows the developer to just
// assume that some errors are always available, which is convenient since
// they don't have to continually run checks for the presence of errors.
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
$this->startSession($request, $session)
);
$this->collectGarbage($session);
$response = $next($request);
$this->storeCurrentUrl($request, $session);
$this->addCookieToResponse($response, $session);
if ($this->manager->shouldBlock() ||
($request->route() instanceof Route && $request->route()->locksFor())) {
return $this->handleRequestWhileBlocking($request, $session, $next);
}
return $this->handleStatefulRequest($request, $session, $next);
}
/**
* Handle the given request within session state.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$response = $next($request);
foreach ($this->cookies->getQueuedCookies() as $cookie) {
$response->headers->setCookie($cookie);
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
* @param \Closure $next
* @return \Symfony\Component\HttpFoundation\Response
*/
public function handle($request, Closure $next)
{
return $this->encrypt($next($this->decrypt($request)));
}
/**
* Decrypt the cookies on the request.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
->through($middleware)
->then(function ($request) use ($route) {
return $this->prepareResponse(
$request, $route->run()
);
});
}
/**
* Gather the middleware for the given route with resolved class names.
*
});
$this->events->dispatch(new RouteMatched($route, $request));
return $this->prepareResponse($request,
$this->runRouteWithinStack($route, $request)
);
}
/**
* Run the given route within a Stack "onion" instance.
* @param \Illuminate\Http\Request $request
* @return \Symfony\Component\HttpFoundation\Response
*/
public function dispatchToRoute(Request $request)
{
return $this->runRoute($request, $this->findRoute($request));
}
/**
* Find the route matching a given request.
*
*/
public function dispatch(Request $request)
{
$this->currentRequest = $request;
return $this->dispatchToRoute($request);
}
/**
* Dispatch the request to a route and return the response.
*
protected function dispatchToRouter()
{
return function ($request) {
$this->app->instance('request', $request);
return $this->router->dispatch($request);
};
}
/**
* Call the terminate method on any terminable middleware.
*/
protected function prepareDestination(Closure $destination)
{
return function ($passable) use ($destination) {
try {
return $destination($passable);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
}
};
}
$locale = get_buzzy_locale();
app()->setLocale($locale);
Carbon::setLocale($locale);
return $next($request);
}
}
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
$this->clean($request);
return $next($request);
}
/**
* Clean the request's data.
*
if ($callback($request)) {
return $next($request);
}
}
return parent::handle($request, $next);
}
/**
* Transform the given value.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
if ($max > 0 && $request->server('CONTENT_LENGTH') > $max) {
throw new PostTooLargeException;
}
return $next($request);
}
/**
* Determine the server 'post_max_size' as bytes.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
null,
$this->getHeaders($data)
);
}
return $next($request);
}
/**
* Determine if the incoming request has a maintenance mode bypass cookie.
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
*/
public function handle($request, Closure $next)
{
// Check if we're dealing with CORS and if we should handle it
if (! $this->shouldRun($request)) {
return $next($request);
}
// For Preflight, return the Preflight response
if ($this->cors->isPreflightRequest($request)) {
$response = $this->cors->handlePreflightRequest($request);
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
public function handle(Request $request, Closure $next)
{
$request::setTrustedProxies([], $this->getTrustedHeaderNames()); // Reset trusted proxies between requests
$this->setTrustedProxyIpAddresses($request);
return $next($request);
}
/**
* Sets the trusted proxies on the request to the value of trustedproxy.proxies
*
// since the object we're given was already a fully instantiated object.
$parameters = [$passable, $stack];
}
$carry = method_exists($pipe, $this->method)
? $pipe->{$this->method}(...$parameters)
: $pipe(...$parameters);
return $this->handleCarry($carry);
} catch (Throwable $e) {
return $this->handleException($passable, $e);
{
$pipeline = array_reduce(
array_reverse($this->pipes()), $this->carry(), $this->prepareDestination($destination)
);
return $pipeline($this->passable);
}
/**
* Run the pipeline and return the result.
*
$this->bootstrap();
return (new Pipeline($this->app))
->send($request)
->through($this->app->shouldSkipMiddleware() ? [] : $this->middleware)
->then($this->dispatchToRouter());
}
/**
* Bootstrap the application for HTTP requests.
*
public function handle($request)
{
try {
$request->enableHttpMethodParameterOverride();
$response = $this->sendRequestThroughRouter($request);
} catch (Throwable $e) {
$this->reportException($e);
$response = $this->renderException($request, $e);
}
*/
$kernel = $app->make(Illuminate\Contracts\Http\Kernel::class);
$response = $kernel->handle(
$request = Illuminate\Http\Request::capture()
);
$response->send();
$kernel->terminate($request, $response);
[2/2]
QueryException
|
---|
Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'seven_days_stats' in where clause is ambiguous (SQL: select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != 0 and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= 2024-03-19 20:45:35 and `language` = en and `approve` = yes and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7) at /home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:712 at Illuminate\Database\Connection->runQueryCallback('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes'), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:672) at Illuminate\Database\Connection->run('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes'), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:376) at Illuminate\Database\Connection->select('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes'), true) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2385) at Illuminate\Database\Query\Builder->runSelect() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2373) at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2907) at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2374) at Illuminate\Database\Query\Builder->get(array('*')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:625) at Illuminate\Database\Eloquent\Builder->getModels(array('*')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:609) at Illuminate\Database\Eloquent\Builder->get() (/home/u387252580/domains/davaonews.com/public_html/app/Post.php:167) at App\Post->scopeGetCached(object(Builder), 'cat_trending_22', object(Carbon)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1475) at Illuminate\Database\Eloquent\Model->callNamedScope('getCached', array(object(Builder), 'cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1218) at Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}(object(Builder), 'cat_trending_22', object(Carbon)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1199) at Illuminate\Database\Eloquent\Builder->callScope(object(Closure), array(object(Builder), 'cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1217) at Illuminate\Database\Eloquent\Builder->callNamedScope('getCached', array('cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1653) at Illuminate\Database\Eloquent\Builder->__call('getCached', array('cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/app/Http/Controllers/CategoryController.php:51) at App\Http\Controllers\CategoryController->__invoke(object(Request), 'news') (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54) at Illuminate\Routing\Controller->callAction('__invoke', array(object(Request), 'catname' => 'news')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45) at Illuminate\Routing\ControllerDispatcher->dispatch(object(Route), object(CategoryController), '__invoke') (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:262) at Illuminate\Routing\Route->runController() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205) at Illuminate\Routing\Route->run() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:721) at Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/app/Http/Middleware/MaintenanceMode.php:48) at App\Http\Middleware\MaintenanceMode->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50) at Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78) at Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49) at Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121) at Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Request), object(Store), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64) at Illuminate\Session\Middleware\StartSession->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37) at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67) at Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:723) at Illuminate\Routing\Router->runRouteWithinStack(object(Route), object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:698) at Illuminate\Routing\Router->runRoute(object(Request), object(Route)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:662) at Illuminate\Routing\Router->dispatchToRoute(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:651) at Illuminate\Routing\Router->dispatch(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:167) at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/app/Http/Middleware/SetLocale.php:24) at App\Http\Middleware\SetLocale->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31) at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40) at Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27) at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:86) at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/fruitcake/laravel-cors/src/HandleCors.php:38) at Fruitcake\Cors\HandleCors->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/fideloper/proxy/src/TrustProxies.php:57) at Fideloper\Proxy\TrustProxies->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:142) at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:111) at Illuminate\Foundation\Http\Kernel->handle(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/public/index.php:59) |
[1/2]
PDOException
|
---|
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'seven_days_stats' in where clause is ambiguous at /home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368 at PDO->prepare('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7') (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:368) at Illuminate\Database\Connection->Illuminate\Database\{closure}('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:705) at Illuminate\Database\Connection->runQueryCallback('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes'), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:672) at Illuminate\Database\Connection->run('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes'), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:376) at Illuminate\Database\Connection->select('select `posts`.* from `posts` left join `popularity_stats` on `popularity_stats`.`trackable_id` = `posts`.`id` where `seven_days_stats` != ? and exists (select * from `categories` inner join `post_categories` on `categories`.`id` = `post_categories`.`category_id` where `posts`.`id` = `post_categories`.`post_id` and `categories`.`id` in (22, 3, 4, 9, 40, 13, 1, 2, 19, 5, 50, 49, 48, 29)) and `published_at` is not null and `published_at` <= ? and `language` = ? and `approve` = ? and `posts`.`deleted_at` is null order by `seven_days_stats` desc, `published_at` desc limit 7', array(0, '2024-03-19 20:45:35', 'en', 'yes'), true) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2385) at Illuminate\Database\Query\Builder->runSelect() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2373) at Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2907) at Illuminate\Database\Query\Builder->onceWithColumns(array('*'), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2374) at Illuminate\Database\Query\Builder->get(array('*')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:625) at Illuminate\Database\Eloquent\Builder->getModels(array('*')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:609) at Illuminate\Database\Eloquent\Builder->get() (/home/u387252580/domains/davaonews.com/public_html/app/Post.php:167) at App\Post->scopeGetCached(object(Builder), 'cat_trending_22', object(Carbon)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:1475) at Illuminate\Database\Eloquent\Model->callNamedScope('getCached', array(object(Builder), 'cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1218) at Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}(object(Builder), 'cat_trending_22', object(Carbon)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1199) at Illuminate\Database\Eloquent\Builder->callScope(object(Closure), array(object(Builder), 'cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1217) at Illuminate\Database\Eloquent\Builder->callNamedScope('getCached', array('cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1653) at Illuminate\Database\Eloquent\Builder->__call('getCached', array('cat_trending_22', object(Carbon))) (/home/u387252580/domains/davaonews.com/public_html/app/Http/Controllers/CategoryController.php:51) at App\Http\Controllers\CategoryController->__invoke(object(Request), 'news') (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54) at Illuminate\Routing\Controller->callAction('__invoke', array(object(Request), 'catname' => 'news')) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45) at Illuminate\Routing\ControllerDispatcher->dispatch(object(Route), object(CategoryController), '__invoke') (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:262) at Illuminate\Routing\Route->runController() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205) at Illuminate\Routing\Route->run() (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:721) at Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/app/Http/Middleware/MaintenanceMode.php:48) at App\Http\Middleware\MaintenanceMode->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php:50) at Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:78) at Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49) at Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:121) at Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Request), object(Store), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:64) at Illuminate\Session\Middleware\StartSession->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37) at Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:67) at Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:723) at Illuminate\Routing\Router->runRouteWithinStack(object(Route), object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:698) at Illuminate\Routing\Router->runRoute(object(Request), object(Route)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:662) at Illuminate\Routing\Router->dispatchToRoute(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Routing/Router.php:651) at Illuminate\Routing\Router->dispatch(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:167) at Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:128) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/app/Http/Middleware/SetLocale.php:24) at App\Http\Middleware\SetLocale->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php:31) at Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:21) at Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php:40) at Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php:27) at Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php:86) at Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/fruitcake/laravel-cors/src/HandleCors.php:38) at Fruitcake\Cors\HandleCors->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/fideloper/proxy/src/TrustProxies.php:57) at Fideloper\Proxy\TrustProxies->handle(object(Request), object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:167) at Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:103) at Illuminate\Pipeline\Pipeline->then(object(Closure)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:142) at Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:111) at Illuminate\Foundation\Http\Kernel->handle(object(Request)) (/home/u387252580/domains/davaonews.com/public_html/public/index.php:59) |