SQLSTATE[42S22]: Column not found: 1054 Unknown column 'imoveis.empreendimento' in 'where clause' (Connection: mysql, Host: 127.0.0.1, Port: 3306, Database: yoosit83_minhaimobiliaria, SQL: select count(*) as aggregate from `imoveis` where `imoveis`.`status` = ativo and `imoveis`.`finalidade` = venda and json_contains(`imoveis`.`empreendimento`, "pe_na_areia"))
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->select(string, array, boolean)Illuminate\Database\Query\Builder->runSelect()Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}()Illuminate\Database\Query\Builder->onceWithColumns(array, object(Closure))Illuminate\Database\Query\Builder->get(array)Illuminate\Database\Query\Builder->aggregate(string, array)Illuminate\Database\Query\Builder->count()Illuminate\Database\Eloquent\Builder->__call(string, array)216217 $caracs = [];218 foreach (Catalogo::CARACS as $slug => $c) {219 $q = self::query($intencao, $f, ['carac']);220 self::aplicarCarac($q, $slug);221 $caracs[] = ['slug' => $slug, 'label' => $c['label'], 'total' => $q->count()];222 }223224 return [225 'tipos' => $tipos,226 'modulos' => $modulos->filter(fn ($m) => $m['total'] > 0 || in_array($m['id'], $f['modulo'] ?? []))->values(),227 'dorm' => $dorm,228 'caracs' => $caracs,229 ];230 }231232 /** Vocabulário da busca com sugestões (JSON embutido na página). */233App\Services\Listagem::contagens(string, array)60 public static function busca(string $intencao, array $filtros = []): array61 {62 return [63 'intencao' => $intencao,64 'filtros' => $filtros,65 'opcoes' => Listagem::contagens($intencao, $filtros),66 'vocab' => Cache::remember('tpl.vocab', 600, fn () => Listagem::vocabulario()),67 ];68 }6970 public function quemSomos()71 {72 return view(app(TemplateManager::class)->view('quem-somos'), ['numeros' => self::numeros()]);73 }7475 public function proprietarios()76 {77App\Http\Controllers\Site\SiteController::busca(string)49 return view(app(TemplateManager::class)->view('home'), [50 'destaque' => $destaque,51 'cards' => $cards,52 'vitrines' => $vitrines,53 'numeros' => self::numeros(),54 'busca' => $this->busca('comprar'),55 'banners' => Banner::query()->where('ativo', true)->latest('id')->limit(5)->get(),56 ]);57 }5859 /** Dados da barra de busca (contagens + vocabulário de sugestões). */60 public static function busca(string $intencao, array $filtros = []): array61 {62 return [63 'intencao' => $intencao,64 'filtros' => $filtros,65 'opcoes' => Listagem::contagens($intencao, $filtros),66App\Http\Controllers\Site\SiteController->home()Illuminate\Routing\ControllerDispatcher->dispatch(object(Illuminate\Routing\Route), object(App\Http\Controllers\Site\SiteController), string)Illuminate\Routing\Route->runController()Illuminate\Routing\Route->run()Illuminate\Routing\Router->Illuminate\Routing\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Routing\Middleware\SubstituteBindings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\View\Middleware\ShareErrorsFromSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Session\Middleware\StartSession->handleStatefulRequest(object(Illuminate\Http\Request), object(Illuminate\Session\Store), object(Closure))Illuminate\Session\Middleware\StartSession->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Cookie\Middleware\EncryptCookies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Routing\Router->runRouteWithinStack(object(Illuminate\Routing\Route), object(Illuminate\Http\Request))Illuminate\Routing\Router->runRoute(object(Illuminate\Http\Request), object(Illuminate\Routing\Route))Illuminate\Routing\Router->dispatchToRoute(object(Illuminate\Http\Request))Illuminate\Routing\Router->dispatch(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Foundation\Http\Middleware\TrimStrings->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePostSize->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\HandleCors->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\TrustProxies->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Middleware\InvokeDeferredCallbacks->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Http\Middleware\ValidatePathEncoding->handle(object(Illuminate\Http\Request), object(Closure))Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(object(Illuminate\Http\Request))Illuminate\Pipeline\Pipeline->then(object(Closure))Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(object(Illuminate\Http\Request))Illuminate\Foundation\Http\Kernel->handle(object(Illuminate\Http\Request))Illuminate\Foundation\Application->handleRequest(object(Illuminate\Http\Request))1516// Bootstrap Laravel and handle the request...17/** @var Application $app */18$app = require_once __DIR__.'/bootstrap/app.php';1920$app->handleRequest(Request::capture());21select * from `sessions` where `id` = '8WEV89DFhaGguNljgbvFOZsfFWhvZZpp9iIye24A' limit 1select * from `imoveis` where `imoveis`.`status` = 'ativo' and `destaque` = 1 order by `id` desc limit 1select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (20) order by `id` ascselect `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (3)select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (5)select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`id` != 20 order by `imoveis`.`destaque` desc, `imoveis`.`id` desc limit 8select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (4, 21, 22) order by `id` ascselect `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (1, 2)select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1)select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and exists (select * from `imovel_imagens` where `imoveis`.`id` = `imovel_imagens`.`imovel_id`) order by `imoveis`.`id` desc limit 1select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (21) order by `id` ascselect `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (2)select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1)select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'aluguel' and exists (select * from `imovel_imagens` where `imoveis`.`id` = `imovel_imagens`.`imovel_id`) order by `imoveis`.`id` desc limit 1select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (20) order by `id` ascselect `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (3)select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (5)select * from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'temporada' and exists (select * from `imovel_imagens` where `imoveis`.`id` = `imovel_imagens`.`imovel_id`) order by `imoveis`.`id` desc limit 1select * from `imovel_imagens` where `imovel_imagens`.`imovel_id` in (22) order by `id` ascselect `id`, `nome`, `cidade_id`, `numero`, `zona` from `bairros` where `bairros`.`id` in (2)select `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1)select * from `configuracoes` where `chave` = 'site_template_ativo' limit 1select * from `cache` where `key` in ('laravel-cache-tpl.numeros')delete from `cache` where `key` in ('laravel-cache-tpl.numeros', 'laravel-cache-illuminate:cache:flexible:created:tpl.numeros') and `expiration` <= 1795133533select count(*) as aggregate from `imoveis` where `status` = 'ativo'select count(*) as aggregate from `imoveis` where `status` = 'ativo' and `finalidade` in ('aluguel', 'temporada')select count(distinct `bairro_id`) as aggregate from `imoveis` where `status` = 'ativo' and `bairro_id` is not nullselect * from `bairros` order by numero IS NULL, numero, `nome` ascselect `id`, `nome`, `uf` from `cidades` where `cidades`.`id` in (1, 5)insert into `cache` (`expiration`, `key`, `value`) values (1795133833, 'laravel-cache-tpl.numeros', 'a:4:{s:5:"total";i:4;s:7:"locacao";i:2;s:7:"bairros";i:3;s:13:"bairros_total";i:6;}') on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`)select `imoveis`.`tipo`, count(*) as total from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' group by `imoveis`.`tipo`select `imoveis`.`bairro_id`, count(*) as total from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' group by `imoveis`.`bairro_id`select `imoveis`.`dormitorios`, count(*) as total from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' group by `imoveis`.`dormitorios`select distinct `tipo` from `imoveis` where `status` = 'ativo' and `tipo` is not null and `tipo` != '' order by `tipo` ascselect count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"vista_mar"')select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"mobiliado"')select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"piscina_privativa"')select count(*) as aggregate from `imoveis` where `imoveis`.`status` = 'ativo' and `imoveis`.`finalidade` = 'venda' and json_contains(`imoveis`.`caracteristicas`, '"frente_ao_golfe"')