| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 |
SELECT `Product`.`id`, `Product`.`name`, `Product`.`product_key`, `Product`.`product_type`, `Product`.`show_at_order`, `Product`.`optional`, `ProductDetail`.`id`, `ProductDetail`.`price`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`default`, `Addon`.`loco_key`, `CloudUnitType`.`name`, `CloudUnitType`.`multiplier`, `CloudUnitType`.`loco_key` FROM `webinterface_gp_2`.`product_datas` AS `Product` LEFT JOIN `webinterface_gp_2`.`product_details` AS `ProductDetail` ON (`ProductDetail`.`product_id` = `Product`.`id`) LEFT JOIN `webinterface_gp_2`.`games_addons` AS `Addon` ON (`Addon`.`id` = `Product`.`product_type_id`) LEFT JOIN `webinterface_gp_2`.`cloud_unit_types` AS `CloudUnitType` ON (`CloudUnitType`.`id` = `Addon`.`cloud_unit_type_id`) WHERE `Product`.`parent_id` = 33 AND `Product`.`active` = '1' ORDER BY `Product`.`id` ASC, `ProductDetail`.`min` ASC
Plugin/GameMgmt/Model/GameGroup.php:167- Product->getProductExtensionRows() src/GPortal/Lib/Order/Struct/ProductStruct.php:317- GameGroup->getProductExtensionsByProductId() src/GPortal/Lib/Order/Struct/ProductStruct.php:382- GPortal\Lib\Order\Struct\ProductStruct->getExtensions() src/GPortal/Lib/Order/Struct/PriceResponseResponseStruct.php:61- GPortal\Lib\Order\Struct\ProductStruct->getExtensionsWithPrices() src/GPortal/Lib/Order/OrderPrice.php:52- GPortal\Lib\Order\Struct\PriceResponseResponseStruct::createFromGPMoney() src/GPortal/Lib/Order/Struct/LocationStruct.php:147- GPortal\Lib\Order\OrderPrice->getOrderPriceResponse() Plugin/Order/Controller/OrderProcessController.php:614- GPortal\Lib\Order\Struct\LocationStruct->getLocalizedDiscountedOrderPrice() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() 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() |
10 | 10 | 1 | |
| 2 |
SELECT `ProductDetail`.`id`, `ProductDetail`.`product_id`, `ProductDetail`.`default`, `ProductDetail`.`price`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`created`, `ProductDetail`.`modified`, `Product`.`id`, `Product`.`parent_id`, `Product`.`group_id`, `Product`.`location_id`, `Product`.`is_official`, `Product`.`show_at_order`, `Product`.`name`, `Product`.`active`, `Product`.`optional`, `Product`.`setup_charge`, `Product`.`unit_price`, `Product`.`image_mime_type`, `Product`.`product_key`, `Product`.`product_type`, `Product`.`product_type_id`, `Product`.`product_unit_id`, `Product`.`minimum_term`, `Product`.`cancellation_period_id`, `Product`.`hardware_category_id`, `Product`.`hardware_operating_system_id`, `Product`.`preorder`, `Product`.`created`, `Product`.`modified` FROM `webinterface_gp_2`.`product_details` AS `ProductDetail` LEFT JOIN `webinterface_gp_2`.`product_datas` AS `Product` ON (`ProductDetail`.`product_id` = `Product`.`id`) WHERE `ProductDetail`.`product_id` = 33 ORDER BY `ProductDetail`.`product_id` ASC, `ProductDetail`.`min` ASC
Plugin/ProductManagement/Model/ProductDetail.php:79- ProductDetail->getAllByProductId() Plugin/ProductManagement/Model/Product.php:359- ProductDetail->getProductUnit() src/GPortal/Lib/Order/Struct/ProductStruct.php:236- Product->getUnitPrice() Plugin/Order/Controller/OrderProcessController.php:620- GPortal\Lib\Order\Struct\ProductStruct->getUnitPrice() Plugin/Order/Controller/OrderProcessController.php:487- OrderProcessController->createBasket() Plugin/Order/Controller/OrderProcessController.php:247- OrderProcessController->createBasketFromQuery() ?:?- OrderProcessController->stepOne() 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 | 1 | |
| 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` = 'pt' AND FIND_IN_SET(3, `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() View/Helper/VueHelper.php:94- GPortal\Lib\HeadlessCMS\LandingPages->search() View/Helper/VueHelper.php:71- VueHelper->footer() Vendor/twig/twig/src/Template.php:700- VueHelper->configPluginData() tmp/cache/templates/85/85580d12aa68fc33df8aa08d6fb3db28654f69c96f9e4d88c1a60c35f1e3f90d.php:219- Twig\Template->getAttribute() Vendor/twig/twig/src/Template.php:453- __TwigTemplate_c5ce0c44cc77f8d3ce90d6468dc5e1bfb121aa53e43f0b1c7cdfcb80dc89a608->doDisplay() Vendor/twig/twig/src/Template.php:420- Twig\Template->displayWithErrorHandling() tmp/cache/templates/20/20dcbb7f8de428446d349f7511c4fb6676d13862275db7e61fc767ae2c5d9fb4.php:36- Twig\Template->display() Vendor/twig/twig/src/Template.php:453- __TwigTemplate_3f0614e9e0938ce25ded18dc6ef3325484252b6100571ba697fdd3f07be26453->doDisplay() Vendor/twig/twig/src/Template.php:420- Twig\Template->displayWithErrorHandling() Vendor/twig/twig/src/Template.php:432- Twig\Template->display() Plugin/TwigView/View/TwigView.php:228- Twig\Template->render() Vendor/cakephp/cakephp/lib/Cake/View/View.php:546- TwigView->_render() Vendor/cakephp/cakephp/lib/Cake/View/View.php:481- View->renderLayout() Vendor/cakephp/cakephp/lib/Cake/Controller/Controller.php:968- View->render() Controller/Abstracts/VueControllerAbstract.php:22- Controller->render() Plugin/Order/Controller/OrderProcessController.php:290- VueControllerAbstract->render() ?:?- OrderProcessController->stepOne() 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() |
6 | 6 | 1 |