Query execution was interrupted, maximum statement execution time exceeded (3024)
SELECT cscart_product_filters.filter_id, cscart_product_features_values.variant_id FROM cscart_product_features_values LEFT JOIN cscart_products as products ON products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_features_values.feature_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_product_features_values as var_val_53 ON var_val_53.product_id = products.product_id AND var_val_53.lang_code = 'uk' AND var_val_53.feature_id = 53 LEFT JOIN cscart_product_features_values as var_val_66 ON var_val_66.product_id = products.product_id AND var_val_66.lang_code = 'uk' AND var_val_66.feature_id = 66 WHERE cscart_product_filters.filter_id IN (38, 11, 22, 23, 24, 25, 26, 27, 28, 33, 29, 30, 31, 32, 34, 35, 36, 12, 14, 13, 16, 15, 17, 18, 19, 20, 21) AND cscart_product_features_values.feature_id IN (85, 53, 56, 57, 55, 58, 59, 60, 62, 68, 64, 63, 67, 61, 69, 65, 71, 72, 73, 50, 66, 52, 54, 49, 48, 70) AND cscart_product_features_values.lang_code = 'uk' AND cscart_categories.category_id IN (264) AND cscart_categories.company_id = 1 AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((var_val_53.variant_id IN (196) AND var_val_66.variant_id IN (211) AND cscart_product_features_values.feature_id NOT IN (53, 66)) OR (var_val_66.variant_id IN (211) AND cscart_product_features_values.feature_id = 53) OR (var_val_53.variant_id IN (196) AND cscart_product_features_values.feature_id = 66)) AND cscart_product_features.feature_type IN ('S', 'M', 'E') GROUP BY cscart_product_features_values.variant_id
app/Tygh/Database/Connection.php, line: 1136
| File: | app/Tygh/Database/Connection.php |
| Line: | 500 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 384 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 107 |
| Function: | getSingleHash |
| File: | app/functions/fn.catalog.php |
| Line: | 10964 |
| Function: | db_get_hash_single_array |
| File: | app/functions/fn.catalog.php |
| Line: | 10522 |
| Function: | fn_get_current_filters |
| File: | app/Tygh/BlockManager/Block.php |
| Line: | 809 |
| Function: | fn_get_filters_products_count |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 778 |
| Function: | getItems |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 644 |
| Function: | getValue |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 475 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 397 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 357 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 222 |
| Function: | renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 353 |
| Function: | renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 222 |
| Function: | renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 192 |
| Function: | renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 156 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 48 |
| Function: | render |
| File: | var/cache/templates/energot/2bbe16fd246fa2adfdf2f29370f0c50e1b6e1908.tygh.index.tpl.php |
| Line: | 202 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_68b6a6f7463424_89428492 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 76 |
| Function: | fetch |
| File: | app/functions/fn.control.php |
| Line: | 585 |
| Function: | fetch |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |