| 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` = 451 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:334- GPortal\Lib\Order\Struct\ProductStruct->getExtensions() Plugin/Order/Controller/OrderProcessController.php:595- GPortal\Lib\Order\Struct\ProductStruct->getMandatoryExtensions() 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() |
0 | 0 | 1 | |
| 2 |
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` = 451 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() |
0 | 0 | 1 | |
| 3 |
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` = 451 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() |
1 | 1 | 1 | |
| 4 |
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` = 451 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/ProductResponseStruct.php:91- GPortal\Lib\Order\Struct\ProductStruct->getExtensions() src/GPortal/Lib/Order/OrderProduct.php:43- GPortal\Lib\Order\Struct\ProductResponseStruct::createFromProduct() Plugin/Order/Controller/OrderProcessController.php:260- GPortal\Lib\Order\OrderProduct->getOrderProductResponse() ?:?- 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() |
0 | 0 | 1 |