Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117 Stack trace: #0 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(117): PDOStatement->execute() #1 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(103): Doctrine\DBAL\Query\QueryBuilder->execute() #4 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(82): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->extracted() #5 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(158): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->generatePartialFacet() #6 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(91): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->createFacets() #7 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Plugins/Community/Frontend/IntediaDoofinder/Search/DoofinderProductNumberSearch.php(179): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search() #8 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundle/ProductSearch.php(59): ShopwarePlugins\IntediaDoofinder\Search\DoofinderProductNumberSearch->search() #9 /var/www/vhosts/carfeature.de/httpdocs/custom/plugins/SwagFuzzy/Bundle/SearchBundle/FuzzyProductSearch.php(46): Shopware\Bundle\SearchBundle\ProductSearch->search() #10 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): SwagFuzzy\Bundle\SearchBundle\FuzzyProductSearch->search() #11 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Controllers/Frontend/Search.php(74): Shopware\Bundle\SearchBundle\VariantSearch->search() #12 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Search->defaultSearchAction() #13 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch() #14 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch() #15 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #16 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle() #17 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #18 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #19 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward() #20 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #21 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #22 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup() #23 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #24 /var/www/vhosts/carfeature.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #25 {main} Next Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18 Stack trace: #0 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(119): Doctrine\DBAL\Driver\PDO\Exception::new() #1 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1304): Doctrine\DBAL\Driver\PDOStatement->execute() #2 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery() #3 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(103): Doctrine\DBAL\Query\QueryBuilder->execute() #4 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(82): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->extracted() #5 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(158): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->generatePartialFacet() #6 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(91): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->createFacets() #7 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Plugins/Community/Frontend/IntediaDoofinder/Search/DoofinderProductNumberSearch.php(179): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search() #8 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundle/ProductSearch.php(59): ShopwarePlugins\IntediaDoofinder\Search\DoofinderProductNumberSearch->search() #9 /var/www/vhosts/carfeature.de/httpdocs/custom/plugins/SwagFuzzy/Bundle/SearchBundle/FuzzyProductSearch.php(46): Shopware\Bundle\SearchBundle\ProductSearch->search() #10 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): SwagFuzzy\Bundle\SearchBundle\FuzzyProductSearch->search() #11 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Controllers/Frontend/Search.php(74): Shopware\Bundle\SearchBundle\VariantSearch->search() #12 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Search->defaultSearchAction() #13 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch() #14 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch() #15 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #16 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle() #17 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #18 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #19 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward() #20 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #21 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #22 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup() #23 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #24 /var/www/vhosts/carfeature.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #25 {main} Next Doctrine\DBAL\Exception\ConnectionLost: An exception occurred while executing 'SELECT listing_price.cheapest_price FROM s_articles product INNER JOIN s_articles_details variant ON variant.id = product.main_detail_id AND variant.active = 1 AND product.active = 1 LEFT JOIN s_articles_avoid_customergroups avoidCustomerGroup ON avoidCustomerGroup.articleID = product.id AND avoidCustomerGroup.customerGroupId IN (?) INNER JOIN (SELECT a.id as product_id, (sr.relevance + IF(a.topseller = 1, 1000, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 30 DAY), 500, 0)) as ranking FROM (SELECT srd.articleID, SUM(srd.relevance) as relevance, COUNT(DISTINCT term) as termCount FROM ( SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 1 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st2.articleID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 2 INNER JOIN s_articles_categories st2 ON si.elementID = st2.categoryID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st3.id as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 3 INNER JOIN s_articles st3 ON si.elementID = st3.supplierID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st4.articleID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 4 INNER JOIN s_articles_details st4 ON si.elementID = st4.id GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 5 GROUP BY articleID, sm.term, sf.id) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID AND a.active = 1 WHERE (sr.relevance + IF(a.topseller = 1, 1000, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 30 DAY), 500, 0)) > (SELECT MAX(sr.relevance + IF(a.topseller = 1, 1000, 0) + IF(a.datum >= DATE_SUB(NOW(),INTERVAL 30 DAY), 500, 0)) / 100 * 20 FROM (SELECT srd.articleID, SUM(srd.relevance) as relevance, COUNT(DISTINCT term) as termCount FROM ( SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 1 GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st2.articleID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 2 INNER JOIN s_articles_categories st2 ON si.elementID = st2.categoryID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st3.id as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 3 INNER JOIN s_articles st3 ON si.elementID = st3.supplierID GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, st4.articleID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 4 INNER JOIN s_articles_details st4 ON si.elementID = st4.id GROUP BY articleID, sm.term, sf.id UNION ALL SELECT MAX(sf.relevance * sm.relevance) as relevance, sm.keywordID, term, si.elementID as articleID FROM (SELECT 400 as relevance, 'rew' as term, 39436135 as keywordID UNION ALL SELECT 400 as relevance, 'rew' as term, 567967897 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 18783 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 971327 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 74099173 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97636719 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97710544 as keywordID UNION ALL SELECT 200 as relevance, 'rew' as term, 97729180 as keywordID) sm INNER JOIN s_search_index si ON sm.keywordID = si.keywordID INNER JOIN s_search_fields sf ON si.fieldID = sf.id AND sf.relevance != 0 AND sf.tableID = 5 GROUP BY articleID, sm.term, sf.id) srd GROUP BY srd.articleID ORDER BY relevance DESC LIMIT 5000) sr INNER JOIN s_articles a ON a.id = sr.articleID AND a.active = 1)) searchTable ON searchTable.product_id = product.id INNER JOIN s_articles_categories_ro productCategory ON productCategory.articleID = product.id AND productCategory.categoryID IN (?) INNER JOIN (SELECT prices.*, MIN(ROUND(prices.price * ((100 - IFNULL(priceGroup.discount, 0)) / 100) * (( (CASE tax.id WHEN 1 THEN 19 WHEN 4 THEN 7 WHEN 10 THEN 19 WHEN 15 THEN 19 WHEN 16 THEN 19 END) + 100) / 100) * 1, 2)) as cheapest_price FROM s_articles product INNER JOIN s_core_tax tax ON tax.id = product.taxID INNER JOIN (SELECT IFNULL(customerPrice.`id`, defaultPrice.`id`) as `id`,IFNULL(customerPrice.`pricegroup`, defaultPrice.`pricegroup`) as `pricegroup`,IFNULL(customerPrice.`from`, defaultPrice.`from`) as `from`,IFNULL(customerPrice.`to`, defaultPrice.`to`) as `to`,IFNULL(customerPrice.`articleID`, defaultPrice.`articleID`) as `articleID`,IFNULL(customerPrice.`articledetailsID`, defaultPrice.`articledetailsID`) as `articledetailsID`,IFNULL(customerPrice.`price`, defaultPrice.`price`) as `price`,IFNULL(customerPrice.`pseudoprice`, defaultPrice.`pseudoprice`) as `pseudoprice`,IFNULL(customerPrice.`percent`, defaultPrice.`percent`) as `percent`,defaultPrice.articleID as product_id,defaultPrice.articledetailsID as variant_id FROM s_articles_prices defaultPrice LEFT JOIN s_articles_prices customerPrice ON customerPrice.articledetailsID = defaultPrice.articledetailsID AND customerPrice.articleID = defaultPrice.articleID AND customerPrice.pricegroup = ? WHERE defaultPrice.pricegroup = ?) prices ON product.id = prices.articleID INNER JOIN s_articles_details availableVariant ON availableVariant.articleID = product.id AND availableVariant.active = 1 LEFT JOIN s_core_pricegroups_discounts priceGroup ON priceGroup.groupID = product.pricegroupID AND priceGroup.discountstart = 1 AND priceGroup.customergroupID = ? AND product.pricegroupActive = 1 WHERE (prices.articledetailsID = availableVariant.id) AND (prices.from = 1) GROUP BY product.id) listing_price ON listing_price.articleID = product.id INNER JOIN s_articles_attributes productAttribute ON productAttribute.articledetailsID = variant.id WHERE avoidCustomerGroup.articleID IS NULL GROUP BY product.id ORDER BY listing_price.cheapest_price DESC LIMIT 1' with params [11, 3, "SK", "EK", 11]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115 Stack trace: #0 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() #1 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException() #2 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2226): Doctrine\DBAL\DBALException::driverExceptionDuringQuery() #3 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1313): Doctrine\DBAL\Connection->handleExceptionDuringQuery() #4 /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery() #5 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(103): Doctrine\DBAL\Query\QueryBuilder->execute() #6 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/FacetHandler/PriceFacetHandler.php(82): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->extracted() #7 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(158): Shopware\Bundle\SearchBundleDBAL\FacetHandler\PriceFacetHandler->generatePartialFacet() #8 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundleDBAL/ProductNumberSearch.php(91): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->createFacets() #9 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Plugins/Community/Frontend/IntediaDoofinder/Search/DoofinderProductNumberSearch.php(179): Shopware\Bundle\SearchBundleDBAL\ProductNumberSearch->search() #10 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundle/ProductSearch.php(59): ShopwarePlugins\IntediaDoofinder\Search\DoofinderProductNumberSearch->search() #11 /var/www/vhosts/carfeature.de/httpdocs/custom/plugins/SwagFuzzy/Bundle/SearchBundle/FuzzyProductSearch.php(46): Shopware\Bundle\SearchBundle\ProductSearch->search() #12 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Bundle/SearchBundle/VariantSearch.php(66): SwagFuzzy\Bundle\SearchBundle\FuzzyProductSearch->search() #13 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Controllers/Frontend/Search.php(74): Shopware\Bundle\SearchBundle\VariantSearch->search() #14 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Action.php(188): Shopware_Controllers_Frontend_Search->defaultSearchAction() #15 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(467): Enlight_Controller_Action->dispatch() #16 /var/www/vhosts/carfeature.de/httpdocs/engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch() #17 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Kernel.php(195): Enlight_Controller_Front->dispatch() #18 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle() #19 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #20 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(270): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #21 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(452): Shopware\Components\HttpCache\AppCache->forward() #22 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(346): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch() #23 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(196): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup() #24 /var/www/vhosts/carfeature.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(224): Shopware\Components\HttpCache\AppCache->lookup() #25 /var/www/vhosts/carfeature.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #26 /var/www/vhosts/carfeature.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #27 {main} thrown in /var/www/vhosts/carfeature.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 115