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}