| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 |
SELECT `GameGroup`.`description`, `Game`.`id`, `Game`.`category_id`, `Game`.`key`, `Game`.`name`, `Game`.`type`, `Game`.`platform`, `Game`.`min_units`, `Game`.`max_units`, `Game`.`unit_multiplier`, `Game`.`plugin`, `Game`.`controller`, `Game`.`release_date`, `Product`.`id`, `Product`.`name`, `Product`.`product_key`, `Product`.`preorder`, `Product`.`product_type`, `Product`.`location_id`, format_money(`Product`.setup_charge, "EUR") as setup_charge, `Location`.`id`, `Location`.`city`, `Location`.`country_code`, `Location`.`country`, `Location`.`location_key`, `Gamecloud`.`min_units`, `Gamecloud`.`max_units`, `Gamecloud`.`name`, `CloudUnitType`.`name`, `CloudUnitType`.`multiplier`, `CloudUnitType`.`loco_key`, format_money(`ProductPrice`.final_price / `ProductPrice`.units / `Game`.unit_multiplier / `CloudUnitType`.multiplier, `ProductPrice`.currency) as minimum_price, `ProductPrice`.`duration_days` FROM `webinterface_gp_2`.`games_groups` AS `GameGroup` INNER JOIN `webinterface_gp_2`.`games_to_groups` AS `GameToGroup` ON (`GameToGroup`.`group_id` = `GameGroup`.`id`) INNER JOIN `webinterface_gp_2`.`games_games` AS `Game` ON (`Game`.`id` = `GameToGroup`.`game_id`) INNER JOIN `webinterface_gp_2`.`product_datas` AS `Product` ON (`Product`.`id` = `GameToGroup`.`product_id` AND `Product`.`active` = '1') JOIN `webinterface_gp_2`.`infrastructure_locations` AS `Location` ON (`Location`.`id` = `Product`.`location_id`) INNER JOIN `webinterface_gp_2`.`gamecloud_clouds` AS `Gamecloud` ON (`Gamecloud`.`id` = `Product`.`product_type_id`) INNER JOIN `webinterface_gp_2`.`cloud_unit_types` AS `CloudUnitType` ON (`CloudUnitType`.`id` = `Gamecloud`.`unit_type_id`) INNER JOIN `webinterface_gp_2`.`product_price_caches` AS `ProductPrice` ON (`ProductPrice`.`product_id` = `GameToGroup`.`product_id` AND `ProductPrice`.`duration_days` = (SELECT MIN(duration) FROM product_contract_durations WHERE product_id = `GameToGroup`.`product_id`) AND `ProductPrice`.`units` = `Game`.`min_units`) WHERE `GameGroup`.`description` = 'rust' GROUP BY `Location`.`id` ORDER BY `Location`.`frontend_order` ASC, `Location`.`id` ASC
Plugin/GameMgmt/Model/GameGroup.php:37- GameGroup->getProductLocationRows() src/GPortal/Lib/Order/OrderProduct.php:135- GameGroup->getProductInfoByKey() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() 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() |
2 | 2 | 3 | |
| 2 |
SELECT `Category`.`id`, is_hardware_category_available(`Category`.id) as available FROM `webinterface_gp_2`.`hardware_categories` AS `Category` WHERE `Category`.`id` IN (54, 811)
Plugin/GameMgmt/Model/GameGroup.php:41- GameGroup->addAvailabilityToProductLocationRows() src/GPortal/Lib/Order/OrderProduct.php:135- GameGroup->getProductInfoByKey() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() 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() |
2 | 2 | 4 | |
| 3 |
SELECT `ProductDetail`.`id`, `ProductDetail`.`min`, `ProductDetail`.`max`, `ProductDetail`.`step`, `ProductDetail`.`default` FROM `webinterface_gp_2`.`product_details` AS `ProductDetail` WHERE `ProductDetail`.`product_id` = 33 ORDER BY `ProductDetail`.`min` ASC
Plugin/GameMgmt/Model/GameGroup.php:109- Product->getProductDetailRows() src/GPortal/Lib/Order/OrderProduct.php:135- GameGroup->getProductInfoByKey() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() 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 | |
| 4 |
SELECT `ContractDuration`.`id`, `ContractDuration`.`duration`, `ContractDuration`.`duration_type`, `ContractDuration`.`discount` FROM `webinterface_gp_2`.`product_contract_durations` AS `ContractDuration` WHERE `ContractDuration`.`product_id` = 33 ORDER BY `ContractDuration`.`duration` ASC
Plugin/GameMgmt/Model/GameGroup.php:119- Product->getProductDurationRows() src/GPortal/Lib/Order/OrderProduct.php:135- GameGroup->getProductInfoByKey() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() 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() |
5 | 5 | 1 | |
| 5 |
SELECT `ContractDuration`.`id`, `ContractDuration`.`duration`, `ContractDuration`.`duration_type`, `ContractDuration`.`discount` FROM `webinterface_gp_2`.`product_contract_durations` AS `ContractDuration` WHERE `ContractDuration`.`product_id` = 171 ORDER BY `ContractDuration`.`duration` ASC
Plugin/GameMgmt/Model/GameGroup.php:119- Product->getProductDurationRows() src/GPortal/Lib/Order/OrderProduct.php:135- GameGroup->getProductInfoByKey() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() 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() |
5 | 5 | 1 | |
| 6 |
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:128- Product->getProductExtensionRows() src/GPortal/Lib/Order/OrderProduct.php:135- GameGroup->getProductInfoByKey() src/GPortal/Lib/Order/OrderProduct.php:84- GPortal\Lib\Order\OrderProduct->getOrderProductFromThisRegion() src/GPortal/Lib/Order/OrderProduct.php:63- GPortal\Lib\Order\OrderProduct->getOrderProductByType() Plugin/Order/Controller/OrderProcessController.php:558- GPortal\Lib\Order\OrderProduct->getOrderProduct() 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 | |
| 7 |
SELECT format_money(`ProductPriceCache`.final_price, `ProductPriceCache`.currency) as formatted_amount FROM `webinterface_gp_2`.`product_price_caches` AS `ProductPriceCache` WHERE `ProductPriceCache`.`product_id` = 33 AND `ProductPriceCache`.`duration_days` = 30 AND `ProductPriceCache`.`units` = 20 LIMIT 1
src/GPortal/Lib/Order/Struct/ProductStruct.php:272- ProductPriceCache->getPrice() src/GPortal/Lib/Order/OrderPrice.php:90- GPortal\Lib\Order\Struct\ProductStruct->getPrice() src/GPortal/Lib/Order/OrderPrice.php:44- GPortal\Lib\Order\OrderPrice->getOrderPriceFromThisRegion() 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() |
1 | 1 | 1 | |
| 8 |
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 | |
| 9 |
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 | |
| 10 |
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` = 'fr' 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 | 23 |