(default) 3 queries took 4 ms
Nr Query Error Affected Num. rows Took (ms)
1 SELECT `LandingPage`.*, JSON_EXTRACT(Page.content, "$.title") AS title, JSON_EXTRACT(Page.content, "$.name") AS name FROM `webinterface_gp_2`.`content_landing_pages` AS `LandingPage` INNER JOIN `webinterface_gp_2`.`content_pages` AS `Page` ON (`LandingPage`.`locale` = `Page`.`locale` AND `LandingPage`.`page_key` = `Page`.`key`) WHERE `LandingPage`.`locale` = 'de' AND FIND_IN_SET(4, `LandingPage`.`groups`) > 0 ORDER BY `name` ASC LIMIT 4

src/GPortal/Lib/HeadlessCMS/LandingPages.php:248- LandingPage->search()
Vendor/cakephp/cakephp/lib/Cake/Cache/Cache.php:576- GPortal\Lib\HeadlessCMS\LandingPages->GPortal\Lib\HeadlessCMS\{closure}()
src/GPortal/Lib/HeadlessCMS/LandingPages.php:250- Cache::remember()
Plugin/Dashboard/Controller/DashboardsController.php:66- GPortal\Lib\HeadlessCMS\LandingPages->search()
?:?- DashboardsController->index()
Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction()
Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke()
webroot/index.php:33- AppDispatcher->dispatch()
4 4 1
2 SELECT `News`.`id`, `News`.`wp_id`, `News`.`key`, `News`.`locale`, `News`.`slug`, `News`.`content`, `News`.`update_required`, `News`.`published`, `News`.`created`, `News`.`modified` FROM `webinterface_gp_2`.`content_news` AS `News` WHERE `News`.`published` < now() AND `News`.`locale` = 'de' ORDER BY `News`.`published` DESC LIMIT 7

src/GPortal/Lib/HeadlessCMS/News.php:89- News->getAllNews()
src/GPortal/Lib/HeadlessCMS/News.php:25- GPortal\Lib\HeadlessCMS\News->_getAll()
Plugin/Dashboard/Controller/DashboardsController.php:74- GPortal\Lib\HeadlessCMS\News->get()
?:?- DashboardsController->index()
Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction()
Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke()
webroot/index.php:33- AppDispatcher->dispatch()
7 7 2
3 SELECT `LandingPage`.*, JSON_EXTRACT(Page.content, "$.title") AS title, JSON_EXTRACT(Page.content, "$.name") AS name FROM `webinterface_gp_2`.`content_landing_pages` AS `LandingPage` INNER JOIN `webinterface_gp_2`.`content_pages` AS `Page` ON (`LandingPage`.`locale` = `Page`.`locale` AND `LandingPage`.`page_key` = `Page`.`key`) WHERE `LandingPage`.`locale` = 'de' AND FIND_IN_SET(2, `LandingPage`.`groups`) > 0 ORDER BY `name` ASC

src/GPortal/Lib/HeadlessCMS/LandingPages.php:248- LandingPage->search()
Vendor/cakephp/cakephp/lib/Cake/Cache/Cache.php:576- GPortal\Lib\HeadlessCMS\LandingPages->GPortal\Lib\HeadlessCMS\{closure}()
src/GPortal/Lib/HeadlessCMS/LandingPages.php:250- Cache::remember()
Plugin/Dashboard/Controller/DashboardsController.php:82- GPortal\Lib\HeadlessCMS\LandingPages->search()
?:?- DashboardsController->index()
Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:193- WebinterfaceControllerAbstract->invokeAction()
Vendor/cakephp/cakephp/lib/Cake/Routing/Dispatcher.php:167- AppDispatcher->_invoke()
webroot/index.php:33- AppDispatcher->dispatch()
8 8 1