| 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` = 'arma-3-epoch' 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() |
1 | 1 | 4 | |
| 2 |
SELECT `Category`.`id`, is_hardware_category_available(`Category`.id) as available FROM `webinterface_gp_2`.`hardware_categories` AS `Category` WHERE `Category`.`id` = (45)
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() |
1 | 1 | 7 | |
| 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 `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 | |
| 6 |
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` = 4 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 | |
| 7 |
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 | |
| 8 |
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 |