Closed dhcmega closed 4 years ago
Hi I'm using dev-master, reference: d75b7d86274eebe67eb2a8d305131bfac8dfba5e
Somehow a whole table select is being triggered which is slowing every request.
What I'm doing is using a relation, and the problem comes up when I call $user->hidden_menu_options which is a meta attribute.
$user->hidden_menu_options
public function children() { $user = null; $account_id = null; if (auth()->check()) { $account_id = auth()->user()->account_id; if (get_guard() == 'api' || get_guard() == 'web') { $user = \App\Models\User::find(auth()->id()); } } return $this->hasMany('App\Models\Menu', 'parent_id') // ->withoutGlobalScope(AccountScope::class) ->when($user, function ($query) use ($user, $account_id) { $query->where('account_id', $account_id); $query->whereNotIn('id', $user->hidden_menu_options ?? []); }) ->with('children') ->where('hide', 0) ->orderBy('parent_id', 'asc') ->orderBy('order', 'asc'); }
I'm firing an exception if 'select * from users_meta' is ran.
users_meta
#0 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(347): App\Providers\AppServiceProvider->App\Providers\{closure}(Object(Illuminate\Database\Events\QueryExecuted)) #1 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(196): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}('Illuminate\\Data...', Array) #2 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(833): Illuminate\Events\Dispatcher->dispatch('Illuminate\\Data...') #3 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(687): Illuminate\Database\Connection->event(Object(Illuminate\Database\Events\QueryExecuted)) #4 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->logQuery('select * from `...', Array, 0.86) #5 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #6 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2132): Illuminate\Database\Connection->select('select * from `...', Array, true) #7 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2120): Illuminate\Database\Query\Builder->runSelect() #8 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2586): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #9 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2121): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #10 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(523): Illuminate\Database\Query\Builder->get(Array) #11 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(507): Illuminate\Database\Eloquent\Builder->getModels(Array) #12 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasMany.php(17): Illuminate\Database\Eloquent\Builder->get() #13 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(429): Illuminate\Database\Eloquent\Relations\HasMany->getResults() #14 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(401): Illuminate\Database\Eloquent\Model->getRelationshipFromMethod('metas') #15 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\Database\Eloquent\Model->getRelationValue('metas') #16 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(321): Illuminate\Database\Eloquent\Model->getAttribute('metas') #17 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1523): App\Models\User->getAttribute('metas') #18 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(362): Illuminate\Database\Eloquent\Model->__get('metas') #19 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(239): App\Models\User->__get('metas') #20 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(359): App\Models\User->getMetaData() #21 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(125): App\Models\User->__get('metaData') #22 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(111): App\Models\User->getMetaString('hidden_menu_opt...', false) #23 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(327): App\Models\User->getMeta('hidden_menu_opt...') #24 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1546): App\Models\User->getAttribute('hidden_menu_opt...') #25 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1591): Illuminate\Database\Eloquent\Model->offsetExists('hidden_menu_opt...') #26 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(434): Illuminate\Database\Eloquent\Model->__isset('hidden_menu_opt...') #27 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Models/Menu.php(397): App\Models\User->__isset('hidden_menu_opt...') #28 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(157): App\Models\Menu->App\Models\{closure}(Object(Illuminate\Database\Eloquent\Builder), Object(App\Models\User)) #29 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php(23): Illuminate\Database\Eloquent\Builder->when(Object(App\Models\User), Object(Closure)) #30 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(385): Illuminate\Database\Eloquent\Relations\Relation->forwardCallTo(Object(Illuminate\Database\Eloquent\Builder), 'when', Array) #31 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Models/Menu.php(398): Illuminate\Database\Eloquent\Relations\Relation->__call('when', Array) #32 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(588): App\Models\Menu->children() #33 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(90): Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}() #34 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(592): Illuminate\Database\Eloquent\Relations\Relation::noConstraints(Object(Closure)) #35 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(560): Illuminate\Database\Eloquent\Builder->getRelation('children') #36 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(540): Illuminate\Database\Eloquent\Builder->eagerLoadRelation(Array, 'children', Object(Closure)) #37 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(508): Illuminate\Database\Eloquent\Builder->eagerLoadRelations(Array) #38 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Models/Menu.php(345): Illuminate\Database\Eloquent\Builder->get() #39 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Models/Menu.php(321): App\Models\Menu::getMenuElement(169, 'api/v3') #40 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Http/Controllers/API/v3/UserNotificationController.php(136): App\Models\Menu::getAppScreen(169, 378) #41 [internal function]: App\Http\Controllers\API\v3\UserNotificationController->fullList(Object(Illuminate\Http\Request)) #42 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array) #43 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('fullList', Array) #44 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Route.php(219): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(App\Http\Controllers\API\v3\UserNotificationController), 'fullList') #45 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Route.php(176): Illuminate\Routing\Route->runController() #46 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Illuminate\Routing\Route->run() #47 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request)) #48 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Http/Middleware/AccountAPI.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #49 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): App\Http\Middleware\AccountAPI->handle(Object(Illuminate\Http\Request), Object(Closure)) #50 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #51 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure)) #52 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Middleware/ThrottleRequests.php(59): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #53 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Routing\Middleware\ThrottleRequests->handle(Object(Illuminate\Http\Request), Object(Closure), 60, '1') #54 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Auth/Middleware/Authenticate.php(43): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #55 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Auth\Middleware\Authenticate->handle(Object(Illuminate\Http\Request), Object(Closure), 'api') #56 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #57 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #58 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request)) #59 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route)) #60 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request)) #61 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request)) #62 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request)) #63 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php(65): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #64 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Barryvdh\Debugbar\Middleware\InjectDebugbar->handle(Object(Illuminate\Http\Request), Object(Closure)) #65 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #66 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #67 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #68 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure)) #69 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #70 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure)) #71 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #72 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure)) #73 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #74 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure)) #75 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request)) #76 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then(Object(Closure)) #77 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request)) #78 /home/vpssigesedev/sigesedev.huayra.com.ar/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request)) #79 {main}#0 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(347): App\Providers\AppServiceProvider->App\Providers\{closure}(Object(Illuminate\Database\Events\QueryExecuted)) #1 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(196): Illuminate\Events\Dispatcher->Illuminate\Events\{closure}('Illuminate\\Data...', Array) #2 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(833): Illuminate\Events\Dispatcher->dispatch('Illuminate\\Data...') #3 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(687): Illuminate\Database\Connection->event(Object(Illuminate\Database\Events\QueryExecuted)) #4 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(640): Illuminate\Database\Connection->logQuery('select * from `...', Array, 0.69) #5 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): Illuminate\Database\Connection->run('select * from `...', Array, Object(Closure)) #6 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2132): Illuminate\Database\Connection->select('select * from `...', Array, true) #7 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2120): Illuminate\Database\Query\Builder->runSelect() #8 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2586): Illuminate\Database\Query\Builder->Illuminate\Database\Query\{closure}() #9 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2121): Illuminate\Database\Query\Builder->onceWithColumns(Array, Object(Closure)) #10 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(523): Illuminate\Database\Query\Builder->get(Array) #11 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(507): Illuminate\Database\Eloquent\Builder->getModels(Array) #12 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasMany.php(17): Illuminate\Database\Eloquent\Builder->get() #13 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(429): Illuminate\Database\Eloquent\Relations\HasMany->getResults() #14 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(401): Illuminate\Database\Eloquent\Model->getRelationshipFromMethod('metas') #15 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php(333): Illuminate\Database\Eloquent\Model->getRelationValue('metas') #16 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(321): Illuminate\Database\Eloquent\Model->getAttribute('metas') #17 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1523): App\Models\User->getAttribute('metas') #18 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(362): Illuminate\Database\Eloquent\Model->__get('metas') #19 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(239): App\Models\User->__get('metas') #20 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(359): App\Models\User->getMetaData() #21 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(125): App\Models\User->__get('metaData') #22 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(111): App\Models\User->getMetaString('hidden_menu_opt...', false) #23 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(327): App\Models\User->getMeta('hidden_menu_opt...') #24 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1546): App\Models\User->getAttribute('hidden_menu_opt...') #25 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(1591): Illuminate\Database\Eloquent\Model->offsetExists('hidden_menu_opt...') #26 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/kodeine/laravel-meta/src/Kodeine/Metable/Metable.php(434): Illuminate\Database\Eloquent\Model->__isset('hidden_menu_opt...') #27 /home/vpssigesedev/sigesedev.huayra.com.ar/app/Models/Menu.php(397): App\Models\User->__isset('hidden_menu_opt...') #28 /home/vpssigesedev/sigesedev.huayra.com.ar/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(157): App\Models\Menu->App\Models\{closure}(Object(Illuminate\Database\Eloquent\Builder), Object(App\Models\User))
Hi I'm using dev-master, reference: d75b7d86274eebe67eb2a8d305131bfac8dfba5e
Somehow a whole table select is being triggered which is slowing every request.
What I'm doing is using a relation, and the problem comes up when I call
$user->hidden_menu_options
which is a meta attribute.I'm firing an exception if 'select * from
users_meta
' is ran.