Query:

SELECT p2c.category_id id, pctsh.site_hierarchy_id pid, COUNT(p2c.product_id) pCount,
fpc.category_type 
FROM products_to_categories p2c 
INNER JOIN frm_products_categories fpc ON fpc.id = p2c.category_id 
INNER JOIN products_categories_to_site_hierarchy pctsh ON pctsh.products_categories_id = fpc.id 
LEFT JOIN element_cb AS ecb ON pctsh.site_hierarchy_id = ecb.pageId AND ecb.elementId = 3 
LEFT JOIN site_hierarchy sh ON sh.id = pctsh.site_hierarchy_id 
WHERE p2c.product_id IN (461676, 2067080, 2426534, 2595646, 390926, 613049, 2648183, 2666127) AND (
ecb.valueId = 0 OR ecb.valueId IS NULL ) AND ( fpc.active = 1 OR sh.enabled = 1 ) 
GROUP BY p2c.category_id

Error message

MySQL server has gone away

Trace:

#0 /var/www/vhosts/svetluska.estudio.cz/httpdocs/vendor/dibi/dibi/src/Dibi/Drivers/MySqliDriver.php(151): Dibi\Drivers\MySqliDriver::createException('MySQL server ha...', 2006, 'SELECT p2c....') #1 /var/www/vhosts/svetluska.estudio.cz/httpdocs/vendor/dibi/dibi/src/Dibi/Connection.php(275): Dibi\Drivers\MySqliDriver->query('SELECT p2c....') #2 /var/www/vhosts/svetluska.estudio.cz/httpdocs/vendor/dibi/dibi/src/Dibi/Connection.php(203): Dibi\Connection->nativeQuery('SELECT p2c....') #3 /var/www/vhosts/svetluska.estudio.cz/httpdocs/application/lib/Model/Dibi.php(68): Dibi\Connection->query(Array) #4 /var/www/vhosts/svetluska.estudio.cz/httpdocs/application/lib/Model/Category.php(357): Model_Dibi->query(Array) #5 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/Category.php(444): Model_Category->getCategoryIdsByProductIds(Array) #6 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/Category.php(386): Category::getCategoriesByProductIds(Array) #7 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/Template/AdvancedSearch.php(221): Category::getCategoriesForFilter(Array, 0) #8 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/Template/AdvancedSearch.php(40): Template\AdvancedSearch->getSearchData() #9 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/Template/System.php(42): Template\AdvancedSearch->loadTemplateSmartyData() #10 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/LayoutSmarty.php(30): Template\System->render() #11 /var/www/vhosts/svetluska.estudio.cz/httpdocs/class/Reflex.php(619): LayoutSmarty::render(Object(PageData), 'pt_advanced_sea...') #12 /var/www/vhosts/svetluska.estudio.cz/httpdocs/index.php(88): Reflex::display() #13 {main}