Queries total time: 0.39409 s.
Query Time Actions
1
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_redirect_to_regional_storefront() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • Tygh\Storefront\Repository::findByUrl() /home/stock2cart/public_html/app/functions/fn.init.php:1451
  • Tygh\Storefront\Repository::find() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:126
  • fn_set_hook() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:313
  • fn_mve_storefront_repository_find_pre() /home/stock2cart/public_html/app/functions/fn.control.php:104
  • fn_allowed_for() /home/stock2cart/public_html/app/functions/fn.multivendor.php:2078
  • fn_get_storage_data() /home/stock2cart/public_html/app/functions/fn.control.php:985
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00028 Re-run Backtrace
2
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'stock2cart.com' OR storefronts.url = 'www.stock2cart.com' OR storefronts.url LIKE 'www_.stock2cart.com' OR storefronts.url LIKE 'stock2cart.com/%' OR storefronts.url LIKE 'www.stock2cart.com/%' OR storefronts.url LIKE 'www_.stock2cart.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'stock2cart.com' DESC, storefronts.url = 'www.stock2cart.com' DESC, storefronts.url LIKE 'www_.stock2cart.com' DESC, storefronts.url LIKE 'stock2cart.com/%' DESC, storefronts.url LIKE 'www.stock2cart.com/%' DESC, storefronts.url LIKE 'www_.stock2cart.com/%' desc 

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_redirect_to_regional_storefront() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • Tygh\Storefront\Repository::findByUrl() /home/stock2cart/public_html/app/functions/fn.init.php:1451
  • Tygh\Storefront\Repository::find() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:126
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:370
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00047 Re-run Backtrace
3
SET time_zone = '+03:00'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_settings() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_init_time_zone() /home/stock2cart/public_html/app/functions/fn.init.php:1057
  • db_query() /home/stock2cart/public_html/app/functions/fn.init.php:1078
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/functions/fn.database.php:138
0.00017 Re-run Backtrace
4
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_addons() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_load_addon() /home/stock2cart/public_html/app/functions/fn.init.php:1134
  • Tygh\Addons\AXmlScheme::loadAddon() /home/stock2cart/public_html/app/functions/fn.addons.php:1627
  • require_once() /home/stock2cart/public_html/app/Tygh/Addons/AXmlScheme.php:859
  • require_once() /home/stock2cart/public_html/app/addons/ab__stickers/func.php:28
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/ab__stickers/functions/fn.ab__s.demodata.php:29
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Storefront\Repository::findById() /home/stock2cart/public_html/app/Tygh/Providers/StorefrontProvider.php:186
  • Tygh\Storefront\Repository::find() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:164
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00029 Re-run Backtrace
5
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_addons() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_load_addon() /home/stock2cart/public_html/app/functions/fn.init.php:1134
  • Tygh\Addons\AXmlScheme::loadAddon() /home/stock2cart/public_html/app/functions/fn.addons.php:1627
  • require_once() /home/stock2cart/public_html/app/Tygh/Addons/AXmlScheme.php:859
  • require_once() /home/stock2cart/public_html/app/addons/ab__stickers/func.php:28
  • fn_get_default_company_id() /home/stock2cart/public_html/app/addons/ab__stickers/functions/fn.ab__s.demodata.php:30
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.companies.php:1653
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00025 Re-run Backtrace
6
SELECT type FROM cscart_seo_names WHERE name = 'surface-socket-outlet-with-protection' 

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_get_route() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:836
  • fn_seo_get_route() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/stock2cart/public_html/app/addons/seo/func.php:662
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00039 Re-run Backtrace
7
SELECT * FROM cscart_seo_names WHERE name = 'surface-socket-outlet-with-protection'  

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_get_route() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:836
  • fn_seo_get_route() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_array() /home/stock2cart/public_html/app/addons/seo/func.php:669
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00030 Re-run Backtrace
8
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_get_route() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:836
  • fn_seo_get_route() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_seo_validate_object() /home/stock2cart/public_html/app/addons/seo/func.php:705
  • Tygh\Languages\Languages::getSimpleLanguages() /home/stock2cart/public_html/app/addons/seo/func.php:1091
  • db_get_hash_single_array() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00039 Re-run Backtrace
9
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_get_route() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:836
  • fn_seo_get_route() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_get_corrected_seo_lang_code() /home/stock2cart/public_html/app/addons/seo/func.php:729
  • fn_seo_get_default_storefront_lang_code() /home/stock2cart/public_html/app/addons/seo/func.php:437
  • Tygh\Storefront\Repository::findDefault() /home/stock2cart/public_html/app/addons/seo/func.php:456
  • Tygh\Storefront\Repository::find() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:188
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00026 Re-run Backtrace
10
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 4927 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_get_route() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:836
  • fn_seo_get_route() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_url() /home/stock2cart/public_html/app/addons/seo/func.php:820
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.common.php:3948
  • fn_seo_url_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_seo_get_name() /home/stock2cart/public_html/app/addons/seo/func.php:1607
  • db_get_row() /home/stock2cart/public_html/app/addons/seo/func.php:1337
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00033 Re-run Backtrace
11
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_layout() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • Tygh\BlockManager\Layout::getDefault() /home/stock2cart/public_html/app/functions/fn.init.php:673
  • db_get_row() /home/stock2cart/public_html/app/Tygh/BlockManager/Layout.php:100
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00040 Re-run Backtrace
12
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_login_user() /home/stock2cart/public_html/app/functions/fn.init.php:744
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.users.php:3509
  • fn_is_expired_storage_data() /home/stock2cart/public_html/app/functions/fn.init.php:776
  • fn_get_storage_data() /home/stock2cart/public_html/app/functions/fn.control.php:1085
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00024 Re-run Backtrace
13
DELETE FROM cscart_access_restriction_block WHERE expires < 1734786847

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_login_user() /home/stock2cart/public_html/app/functions/fn.init.php:744
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.users.php:3509
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_query() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:218
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/functions/fn.database.php:138
0.00026 Re-run Backtrace
14
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1734786847

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_login_user() /home/stock2cart/public_html/app/functions/fn.init.php:744
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.users.php:3509
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_query() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:219
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/functions/fn.database.php:138
0.00033 Re-run Backtrace
15
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE (ip_from <= '038fd656' AND ip_to >= '038fd656') AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_login_user() /home/stock2cart/public_html/app/functions/fn.init.php:744
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.users.php:3509
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_row() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:231
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00034 Re-run Backtrace
16
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_login_user() /home/stock2cart/public_html/app/functions/fn.init.php:744
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.users.php:3509
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:244
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00015 Re-run Backtrace
17
DELETE FROM cscart_access_restriction_block WHERE expires < 1734786847

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_query() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:218
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/functions/fn.database.php:138
0.00014 Re-run Backtrace
18
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1734786847

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_query() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:219
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/functions/fn.database.php:138
0.00014 Re-run Backtrace
19
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE (ip_from <= '038fd656' AND ip_to >= '038fd656') AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_row() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:231
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00027 Re-run Backtrace
20
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_user() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.init.php:823
  • fn_access_restrictions_user_init() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/stock2cart/public_html/app/addons/access_restrictions/func.php:244
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00015 Re-run Backtrace
21
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /home/stock2cart/public_html/index.php:18
  • fn_init() /home/stock2cart/public_html/init.php:195
  • fn_init_templater() /home/stock2cart/public_html/app/functions/fn.init.php:1227
  • Tygh\Development::isEnabled() /home/stock2cart/public_html/app/functions/fn.init.php:124
  • Tygh\Development::read() /home/stock2cart/public_html/app/Tygh/Development.php:28
  • fn_get_storage_data() /home/stock2cart/public_html/app/Tygh/Development.php:81
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00022 Re-run Backtrace
22
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' AND storefront_id = 1

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:439
  • fn_abt__unitheme2_dispatch_assign_template() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_get_abt__ut2_settings() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:24
  • db_get_array() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:132
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00073 Re-run Backtrace
23
SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'unitheme_new.less'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:439
  • fn_abt__unitheme2_dispatch_assign_template() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_get_abt__ut2_settings() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:25
  • db_get_array() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:130
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00030 Re-run Backtrace
24
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 8

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::instance() /home/stock2cart/public_html/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /home/stock2cart/public_html/app/Tygh/BlockManager/Location.php:476
  • db_get_row() /home/stock2cart/public_html/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00022 Re-run Backtrace
25
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 8  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(4927, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /home/stock2cart/public_html/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /home/stock2cart/public_html/app/Tygh/BlockManager/Location.php:172
  • db_get_hash_array() /home/stock2cart/public_html/app/Tygh/BlockManager/Location.php:112
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00350 Re-run Backtrace
26
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_storage_data() /home/stock2cart/public_html/app/controllers/frontend/init.php:146
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00019 Re-run Backtrace
27
SELECT category_id FROM cscart_categories WHERE category_id = 4927  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H')

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • db_get_field() /home/stock2cart/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:32
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00039 Re-run Backtrace
28
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 4927

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products_layout() /home/stock2cart/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:34
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.products.php:2847
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00019 Re-run Backtrace
29
SELECT id_path FROM cscart_categories WHERE category_id = 4927

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_ab__cb_pick_banner_by_cid() /home/stock2cart/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35
  • fn_ab__get_category_banners() /home/stock2cart/public_html/app/addons/ab__category_banners/func.php:218
  • db_get_field() /home/stock2cart/public_html/app/addons/ab__category_banners/func.php:128
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00015 Re-run Backtrace
30
SELECT cscart_ab__category_banners.*, cscart_ab__category_banner_images_and_descr.category_banner, cscart_ab__category_banner_images_and_descr.url, cscart_ab__category_banner_images_and_descr.category_banner_image_id FROM cscart_ab__category_banners
INNER JOIN cscart_ab__category_banner_images_and_descr ON cscart_ab__category_banner_images_and_descr.category_banner_id = cscart_ab__category_banners.category_banner_id AND cscart_ab__category_banner_images_and_descr.lang_code = 'en'
 LEFT JOIN cscart_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = cscart_ab__category_banners.category_banner_id  LEFT JOIN cscart_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = cscart_ab__category_banners.category_banner_id INNER JOIN cscart_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = cscart_ab__category_banner_images_and_descr.category_banner_image_id AND il.pair_id IS NOT NULL AND il.type = 'M'
WHERE 1  AND cscart_ab__category_banners.status = 'A'  AND cscart_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL  AND (IF(cscart_ab__category_banners.from_date, cscart_ab__category_banners.from_date <= 1734786847, 1) AND IF(cscart_ab__category_banners.to_date, cscart_ab__category_banners.to_date >= 1734786847, 1)) AND (ab__category_banner_categories.category_id = 4927 OR (ab__category_banner_categories1.category_id IN (4927) AND cscart_ab__category_banners.include_subcategories = 'Y'))  ORDER BY cscart_ab__category_banner_images_and_descr.category_banner asc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_ab__cb_pick_banner_by_cid() /home/stock2cart/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35
  • fn_ab__get_category_banners() /home/stock2cart/public_html/app/addons/ab__category_banners/func.php:218
  • db_get_hash_array() /home/stock2cart/public_html/app/addons/ab__category_banners/func.php:165
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00108 Re-run Backtrace
31
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category_banner' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IS NULL ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_ab__cb_pick_banner_by_cid() /home/stock2cart/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35
  • fn_ab__get_category_banners() /home/stock2cart/public_html/app/addons/ab__category_banners/func.php:218
  • fn_get_image_pairs() /home/stock2cart/public_html/app/addons/ab__category_banners/func.php:177
  • db_multi_query() /home/stock2cart/public_html/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/stock2cart/public_html/app/functions/fn.database.php:168
0.00030 Re-run Backtrace
32
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 4927

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • db_get_field() /home/stock2cart/public_html/app/controllers/frontend/categories.php:38
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00022 Re-run Backtrace
33
SELECT category_id FROM cscart_categories WHERE category_id = 4927  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • db_get_field() /home/stock2cart/public_html/app/controllers/frontend/categories.php:60
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00020 Re-run Backtrace
34
SELECT category_id FROM cscart_categories WHERE category_type = 'D'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_subcategories() /home/stock2cart/public_html/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/stock2cart/public_html/app/functions/fn.categories.php:60
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.categories.php:242
  • fn_vendor_debt_payout_get_categories_pre() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_vendor_debt_payout_get_payout_category() /home/stock2cart/public_html/app/addons/vendor_debt_payout/func.php:346
  • db_get_field() /home/stock2cart/public_html/app/addons/vendor_debt_payout/func.php:225
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00682 Re-run Backtrace
35
SELECT id_path FROM cscart_categories WHERE category_id = 4927

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_subcategories() /home/stock2cart/public_html/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/stock2cart/public_html/app/functions/fn.categories.php:60
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.categories.php:350
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00017 Re-run Backtrace
36
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path,cscart_categories.ab__lc_catalog_image_control,cscart_categories.ab__fn_category_status,cscart_categories.ab__fn_label_color,cscart_categories.ab__fn_label_background,cscart_categories.ab__fn_use_origin_image,cscart_category_descriptions.ab__fn_label_text,cscart_category_descriptions.ab__fn_label_show,cscart_categories.age_verification,cscart_categories.age_limit,cscart_category_descriptions.age_warning_message,cscart_category_descriptions.ab__custom_category_h1 FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE 1=1  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') AND cscart_categories.parent_id IN (4927) AND cscart_categories.id_path LIKE '4927/%' AND cscart_categories.category_id != 414 AND cscart_categories.parent_id != 414 AND cscart_categories.storefront_id IN (0, 1)   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_subcategories() /home/stock2cart/public_html/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/stock2cart/public_html/app/functions/fn.categories.php:60
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.categories.php:451
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00084 Re-run Backtrace
37
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, IFNULL(ab__emd_cp.category_pattern_id, 0) as ab__emd__category_pattern_id, IFNULL(ab__emd_cp.products_pattern_id, 0) as ab__emd__products_pattern_id FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 4927  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  LEFT JOIN cscart_ab__emd_categories_patterns AS ab__emd_cp ON ab__emd_cp.category_id = cscart_categories.category_id WHERE cscart_categories.category_id = 4927 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_category_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:77
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.categories.php:812
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00078 Re-run Backtrace
38
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '4927' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '4927' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_category_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:77
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.categories.php:824
  • db_multi_query() /home/stock2cart/public_html/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/stock2cart/public_html/app/functions/fn.database.php:168
0.00040 Re-run Backtrace
39
SELECT search_phrases FROM cscart_ab__search_motivation WHERE category_id = 4927 AND lang_code = 'en'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_category_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:77
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.categories.php:873
  • fn_ab__search_motivation_get_category_data_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/stock2cart/public_html/app/addons/ab__search_motivation/func.php:29
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00037 Re-run Backtrace
40
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (4927)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • db_get_fields() /home/stock2cart/public_html/app/functions/fn.products.php:1924
  • Tygh\Database\Connection::getColumn() /home/stock2cart/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:479
0.00721 Re-run Backtrace
41
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • Tygh\Storefront\Storefront::__call() /home/stock2cart/public_html/app/functions/fn.products.php:1996
  • Tygh\Storefront\Storefront::getRelationValue() /home/stock2cart/public_html/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /home/stock2cart/public_html/app/Tygh/Storefront/Storefront.php:274
  • Tygh\Storefront\RelationsManager::getRelatedValues() /home/stock2cart/public_html/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /home/stock2cart/public_html/app/Tygh/Storefront/RelationsManager.php:120
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:479
0.00034 Re-run Backtrace
42
SELECT MIN(prices.price) as ab__min_price, MAX(prices.price) as ab__max_price FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_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') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  LEFT JOIN cscart_master_products_storefront_min_price ON cscart_master_products_storefront_min_price.product_id = prices.product_id AND cscart_master_products_storefront_min_price.storefront_id = 1 WHERE prices.price > 0  AND cscart_categories.category_id IN (4927) AND (companies.status IN ('A', 'S') OR products.company_id = 0) AND products.company_id IN (137, 138, 146, 0) 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 prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 ))

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2282
  • fn_ab__extended_metadata_get_products() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_row() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:193
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00172 Re-run Backtrace
43
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, COALESCE(cscart_master_products_storefront_min_price.price, MIN(IF(prices.percentage_discount = 0,prices.price,prices.price - (prices.price * prices.percentage_discount)/100))) as price, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id, IF(products.age_verification = 'Y', 'Y', IF(cscart_categories.age_verification = 'Y', 'Y', cscart_categories.parent_age_verification)) as need_age_verification, IF(products.age_limit > cscart_categories.age_limit, IF(products.age_limit > cscart_categories.parent_age_limit, products.age_limit, cscart_categories.parent_age_limit), IF(cscart_categories.age_limit > cscart_categories.parent_age_limit, cscart_categories.age_limit, cscart_categories.parent_age_limit)) as age_limit FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_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') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  LEFT JOIN cscart_master_products_storefront_min_price ON cscart_master_products_storefront_min_price.product_id = prices.product_id AND cscart_master_products_storefront_min_price.storefront_id = 1 WHERE 1  AND cscart_categories.category_id IN (4927) AND (companies.status IN ('A', 'S') OR products.company_id = 0) AND products.company_id IN (137, 138, 146, 0) 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 prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id   ORDER BY price asc, products.product_id ASC  LIMIT 0, 20

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • {closure}() /home/stock2cart/public_html/app/functions/fn.products.php:2430
  • db_get_array() /home/stock2cart/public_html/app/functions/fn.products.php:2354
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00122 Re-run Backtrace
44
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • {closure}() /home/stock2cart/public_html/app/functions/fn.products.php:2430
  • db_get_found_rows() /home/stock2cart/public_html/app/functions/fn.products.php:2357
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:332
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00013 Re-run Backtrace
45
SELECT cscart_languages.* FROM cscart_languages  WHERE 1    

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2500
  • fn_master_products_load_products_extra_data_pre() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap() /home/stock2cart/public_html/app/addons/master_products/func.php:995
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:97
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductRepository() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:63
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:89
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:43
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/stock2cart/public_html/app/Tygh/Providers/CommonProvider.php:40
  • db_get_hash_array() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:134
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00026 Re-run Backtrace
46
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2500
  • fn_master_products_load_products_extra_data_pre() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap() /home/stock2cart/public_html/app/addons/master_products/func.php:995
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:97
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductRepository() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:63
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:89
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:43
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/stock2cart/public_html/app/Tygh/Providers/CommonProvider.php:40
  • Tygh\Languages\Languages::afterFind() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:135
  • Tygh\Languages\Languages::attachStorefrontIds() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:1681
  • array_walk() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:1745
  • Tygh\Languages\Languages::Tygh\Languages\{closure}()
  • Tygh\Storefront\Repository::find() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:1742
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00077 Re-run Backtrace
47
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2500
  • fn_master_products_load_products_extra_data_pre() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap() /home/stock2cart/public_html/app/addons/master_products/func.php:995
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:97
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductRepository() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:63
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:89
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:43
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/stock2cart/public_html/app/Tygh/Providers/CommonProvider.php:40
  • Tygh\Languages\Languages::afterFind() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:135
  • Tygh\Languages\Languages::attachStorefrontIds() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:1681
  • array_walk() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:1745
  • Tygh\Languages\Languages::Tygh\Languages\{closure}()
  • Tygh\Storefront\Repository::find() /home/stock2cart/public_html/app/Tygh/Languages/Languages.php:1742
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00057 Re-run Backtrace
48
SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (276352)  

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_load_extra_data_by_entity_ids() /home/stock2cart/public_html/app/functions/fn.products.php:2649
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:8832
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00027 Re-run Backtrace
49
SELECT cscart_product_prices.product_id, COALESCE(cscart_master_products_storefront_min_price.price, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) AS price FROM cscart_product_prices  LEFT JOIN cscart_master_products_storefront_min_price ON cscart_master_products_storefront_min_price.product_id = cscart_product_prices.product_id AND cscart_master_products_storefront_min_price.storefront_id = 1 WHERE cscart_product_prices.product_id IN (276352)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_load_extra_data_by_entity_ids() /home/stock2cart/public_html/app/functions/fn.products.php:2649
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:8832
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00032 Re-run Backtrace
50
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.short_description, IF(cscart_product_descriptions.short_description = '' OR cscart_product_descriptions.short_description IS NULL, cscart_product_descriptions.full_description, '') AS full_description FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (276352)  AND cscart_product_descriptions.lang_code = 'en' 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_load_extra_data_by_entity_ids() /home/stock2cart/public_html/app/functions/fn.products.php:2649
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:8832
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00021 Re-run Backtrace
51
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.storefront_id IN (0, 1) 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_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 4927 WHERE cscart_products_categories.product_id IN (276352)   GROUP BY cscart_products_categories.product_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_load_extra_data_by_entity_ids() /home/stock2cart/public_html/app/functions/fn.products.php:2649
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:8832
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00074 Re-run Backtrace
52
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (276352)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'en'  

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_load_extra_data_by_entity_ids() /home/stock2cart/public_html/app/functions/fn.products.php:2649
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:8832
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00030 Re-run Backtrace
53
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion  LEFT JOIN cscart_discussion_posts   ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating   ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id   AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id   AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (276352)  AND cscart_discussion.object_type = "P" GROUP BY cscart_discussion.object_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_load_extra_data_by_entity_ids() /home/stock2cart/public_html/app/functions/fn.products.php:2649
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:8832
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00074 Re-run Backtrace
54
SELECT product_id, amount FROM cscart_warehouses_sum_products_amount WHERE 1 AND product_id IN (276352)

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/stock2cart/public_html/app/functions/fn.products.php:2454
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2673
  • fn_warehouses_load_products_extra_data_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_hash_single_array() /home/stock2cart/public_html/app/addons/warehouses/func.php:1972
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00019 Re-run Backtrace
55
SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE  a.country_code = 'IN' ORDER BY b.state

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_warehouses_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/addons/warehouses/func.php:825
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\LocationProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/Tygh/Providers/LocationProvider.php:40
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\LocationProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Location\Location::__construct() /home/stock2cart/public_html/app/Tygh/Providers/LocationProvider.php:68
  • Tygh\Location\Location::setState() /home/stock2cart/public_html/app/Tygh/Location/Location.php:69
  • Tygh\Location\Location::isIsoCode() /home/stock2cart/public_html/app/Tygh/Location/Location.php:143
  • Tygh\Location\Location::getCountryStates() /home/stock2cart/public_html/app/Tygh/Location/Location.php:243
  • fn_get_country_states() /home/stock2cart/public_html/app/Tygh/Location/Location.php:262
  • db_get_hash_single_array() /home/stock2cart/public_html/app/functions/fn.locations.php:290
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00068 Re-run Backtrace
56
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_warehouses_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/func.php:826
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00018 Re-run Backtrace
57
SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE  a.country_code = 'IN' AND a.status = 'A' ORDER BY b.state

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_warehouses_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/func.php:826
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_country_states() /home/stock2cart/public_html/app/functions/fn.locations.php:497
  • db_get_hash_single_array() /home/stock2cart/public_html/app/functions/fn.locations.php:290
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00049 Re-run Backtrace
58
SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_warehouses_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/func.php:826
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • db_get_array() /home/stock2cart/public_html/app/functions/fn.locations.php:513
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00063 Re-run Backtrace
59
SELECT warehouse_id, amount, store_type, position, main_destination_id,  pickup_destinations_ids, shipping_destinations_ids, status FROM cscart_store_locations AS sl INNER JOIN cscart_warehouses_products_amount AS wpa ON wpa.warehouse_id = sl.store_location_id WHERE wpa.product_id = 276352 ORDER BY sl.position ASC

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_warehouses_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Addons\Warehouses\Manager::getProductWarehousesStock() /home/stock2cart/public_html/app/addons/warehouses/func.php:835
  • Tygh\Addons\Warehouses\Manager::getProductWarehousesData() /home/stock2cart/public_html/app/addons/warehouses/Tygh/Addons/Warehouses/Manager.php:76
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/addons/warehouses/Tygh/Addons/Warehouses/Manager.php:424
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00043 Re-run Backtrace
60
SELECT is_stock_split_by_warehouses FROM cscart_products WHERE product_id = 276352

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_warehouses_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Addons\Warehouses\Manager::getProductWarehousesStock() /home/stock2cart/public_html/app/addons/warehouses/func.php:835
  • Tygh\Addons\Warehouses\Manager::isProductStockSplitByWarehouses() /home/stock2cart/public_html/app/addons/warehouses/Tygh/Addons/Warehouses/Manager.php:77
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/addons/warehouses/Tygh/Addons/Warehouses/Manager.php:436
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00018 Re-run Backtrace
61
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_master_products_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_master_products_filter_master_products_quantities_for_current_storefront() /home/stock2cart/public_html/app/addons/master_products/func.php:348
  • Tygh\Storefront\Repository::getCount() /home/stock2cart/public_html/app/addons/master_products/func.php:2583
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/Tygh/Storefront/Repository.php:435
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00017 Re-run Backtrace
62
SELECT product_id, feature_short_desc FROM cscart_ab__short_desc_from_features_values
WHERE product_id IN (276352) AND lang_code = 'en' AND storefront_id = 1 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_ab__short_desc_from_features_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_ab__sdff_get_descriptions() /home/stock2cart/public_html/app/addons/ab__short_desc_from_features/func.php:94
  • db_get_hash_single_array() /home/stock2cart/public_html/app/addons/ab__short_desc_from_features/func.php:135
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00044 Re-run Backtrace
63
SELECT video_id, product_id FROM cscart_ab__video_gallery WHERE product_id IN (276352) AND status = "A"

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_ab__video_gallery_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_hash_array() /home/stock2cart/public_html/app/addons/ab__video_gallery/func.php:213
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00042 Re-run Backtrace
64
SELECT p.product_id,ifnull(count(dp.post_id),0) as discussion_amount_posts
FROM cscart_discussion
INNER JOIN cscart_products as p ON (cscart_discussion.object_id=p.product_id)
INNER JOIN cscart_discussion_posts as dp ON (cscart_discussion.thread_id=dp.thread_id AND cscart_discussion.object_type='P' )
WHERE dp.status='A' and p.product_id in (276352)
GROUP BY p.product_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_get_products() /home/stock2cart/public_html/app/controllers/frontend/categories.php:115
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:2467
  • fn_abt__unitheme2_get_products_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • db_get_hash_single_array() /home/stock2cart/public_html/app/addons/abt__unitheme2/func.php:283
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00030 Re-run Backtrace
65
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.products.php:629
  • db_multi_query() /home/stock2cart/public_html/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/stock2cart/public_html/app/functions/fn.database.php:168
0.00040 Re-run Backtrace
66
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.products.php:629
  • fn_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.images.php:397
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.images.php:70
  • fn_watermarks_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/stock2cart/public_html/app/addons/watermarks/func.php:410
  • fn_is_watermarks_enabled() /home/stock2cart/public_html/app/addons/watermarks/func.php:189
  • fn_get_watermark_settings() /home/stock2cart/public_html/app/addons/watermarks/func.php:268
  • Tygh\Settings::instance() /home/stock2cart/public_html/app/addons/watermarks/func.php:47
  • Tygh\Settings::reloadSections() /home/stock2cart/public_html/app/Tygh/Settings.php:172
  • Tygh\Settings::getSections() /home/stock2cart/public_html/app/Tygh/Settings.php:141
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/Tygh/Settings.php:494
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00122 Re-run Backtrace
67
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'watermark' 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.products.php:629
  • fn_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.images.php:397
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.images.php:70
  • fn_watermarks_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/stock2cart/public_html/app/addons/watermarks/func.php:410
  • fn_is_watermarks_enabled() /home/stock2cart/public_html/app/addons/watermarks/func.php:189
  • fn_get_watermark_settings() /home/stock2cart/public_html/app/addons/watermarks/func.php:268
  • Tygh\Settings::getValue() /home/stock2cart/public_html/app/addons/watermarks/func.php:47
  • Tygh\Settings::getId() /home/stock2cart/public_html/app/Tygh/Settings.php:871
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/Tygh/Settings.php:972
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00037 Re-run Backtrace
68
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 5890 ORDER BY cscart_settings_objects.position

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.products.php:629
  • fn_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.images.php:397
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.images.php:70
  • fn_watermarks_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/stock2cart/public_html/app/addons/watermarks/func.php:410
  • fn_is_watermarks_enabled() /home/stock2cart/public_html/app/addons/watermarks/func.php:189
  • fn_get_watermark_settings() /home/stock2cart/public_html/app/addons/watermarks/func.php:268
  • Tygh\Settings::getValue() /home/stock2cart/public_html/app/addons/watermarks/func.php:47
  • Tygh\Settings::getPlainList() /home/stock2cart/public_html/app/Tygh/Settings.php:882
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00038 Re-run Backtrace
69
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.products.php:633
  • db_multi_query() /home/stock2cart/public_html/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/stock2cart/public_html/app/functions/fn.database.php:168
0.00039 Re-run Backtrace
70
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (276352) AND a.status = 'A' ORDER BY a.position

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/stock2cart/public_html/app/functions/fn.products.php:642
  • db_get_hash_multi_array() /home/stock2cart/public_html/app/functions/fn.options.php:247
  • Tygh\Database\Connection::getMultiHash() /home/stock2cart/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:525
0.00075 Re-run Backtrace
71
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (276352) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/stock2cart/public_html/app/functions/fn.products.php:642
  • db_get_hash_multi_array() /home/stock2cart/public_html/app/functions/fn.options.php:258
  • Tygh\Database\Connection::getMultiHash() /home/stock2cart/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:525
0.00040 Re-run Backtrace
72
SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_product_variation_group_features AS f INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (276352)

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:662
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/Addons/Loader.php:147
  • Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()
  • Tygh\Addons\ProductVariations\Product\Repository::loadProductsGroupInfo() /home/stock2cart/public_html/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:310
  • Tygh\Addons\ProductVariations\Product\Group\Repository::findGroupInfoByProductIds() /home/stock2cart/public_html/app/addons/product_variations/src/Product/Repository.php:453
  • Tygh\Addons\ProductVariations\Tools\Query::select() /home/stock2cart/public_html/app/addons/product_variations/src/Product/Group/Repository.php:355
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/addons/product_variations/src/Tools/Query.php:310
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00054 Re-run Backtrace
73
SELECT
p.promotion_id,
p.from_date,
p.to_date,
active.from_date AS active_from_date,
active.to_date AS active_to_date,
expired.from_date AS expired_from_date,
expired.to_date AS expired_to_date
FROM cscart_promotions AS p
INNER JOIN cscart_ab__dotd AS ab__dotd ON p.promotion_id=ab__dotd.promotion_id AND ab__dotd.use_schedule='Y'
LEFT JOIN (SELECT promotion_id,MIN(from_date) AS from_date,MIN(to_date) AS to_date FROM cscart_ab__dotd_periods WHERE to_date >= 1734786847 GROUP BY promotion_id) AS active ON active.promotion_id=p.promotion_id
LEFT JOIN (SELECT promotion_id,MAX(from_date) AS from_date,MAX(to_date) AS to_date FROM cscart_ab__dotd_periods WHERE to_date < 1734786847 GROUP BY promotion_id) AS expired ON expired.promotion_id=p.promotion_id
WHERE p.status IN ('A', 'H')

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_promotion_apply() /home/stock2cart/public_html/app/functions/fn.products.php:799
  • fn_get_promotions() /home/stock2cart/public_html/app/functions/fn.promotions.php:277
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.promotions.php:166
  • fn_ab__deal_of_the_day_get_promotions() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_ab__dotd_rebuild_promotions_periods() /home/stock2cart/public_html/app/addons/ab__deal_of_the_day/func.php:91
  • db_get_array() /home/stock2cart/public_html/app/addons/ab__deal_of_the_day/func.php:383
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00095 Re-run Backtrace
74
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1734786847, 1) AND IF(to_date, to_date >= 1734786847, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL) AND (cscart_promotions.company_id IN (137, 138, 146) OR cscart_promotions.company_id=0)   ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_promotion_apply() /home/stock2cart/public_html/app/functions/fn.products.php:799
  • fn_get_promotions() /home/stock2cart/public_html/app/functions/fn.promotions.php:277
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.promotions.php:200
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00058 Re-run Backtrace
75
SELECT product_id FROM cscart_products WHERE product_type = 'D'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_promotion_apply() /home/stock2cart/public_html/app/functions/fn.products.php:799
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.promotions.php:298
  • fn_vendor_debt_payout_promotion_apply_pre() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_vendor_debt_payout_get_payout_product() /home/stock2cart/public_html/app/addons/vendor_debt_payout/func.php:804
  • db_get_field() /home/stock2cart/public_html/app/addons/vendor_debt_payout/func.php:245
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.33434 Re-run Backtrace
76
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (12, 10, 13) AND status = 'A' ORDER BY priority

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_get_set_taxes() /home/stock2cart/public_html/app/functions/fn.cart.php:7279
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.cart.php:3776
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00048 Re-run Backtrace
77
SELECT COUNT(*) FROM cscart_countries WHERE code = 'IN' AND status = 'A'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_calculate_tax_rates() /home/stock2cart/public_html/app/functions/fn.cart.php:7281
  • fn_get_customer_location() /home/stock2cart/public_html/app/functions/fn.cart.php:6938
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.cart.php:5021
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00020 Re-run Backtrace
78
SELECT COUNT(*) FROM cscart_states WHERE country_code = 'IN' AND code = '32' AND status = 'A'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_calculate_tax_rates() /home/stock2cart/public_html/app/functions/fn.cart.php:7281
  • fn_get_customer_location() /home/stock2cart/public_html/app/functions/fn.cart.php:6938
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.cart.php:5027
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00009 Re-run Backtrace
79
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_calculate_tax_rates() /home/stock2cart/public_html/app/functions/fn.cart.php:7281
  • fn_get_available_destination() /home/stock2cart/public_html/app/functions/fn.cart.php:6939
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00007 Re-run Backtrace
80
SELECT COUNT(*) FROM cscart_countries WHERE code = 'IN' AND status = 'A'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_calculate_tax_rates() /home/stock2cart/public_html/app/functions/fn.cart.php:7281
  • fn_get_customer_location() /home/stock2cart/public_html/app/functions/fn.cart.php:6942
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.cart.php:5021
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00006 Re-run Backtrace
81
SELECT COUNT(*) FROM cscart_states WHERE country_code = 'IN' AND code = '32' AND status = 'A'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_calculate_tax_rates() /home/stock2cart/public_html/app/functions/fn.cart.php:7281
  • fn_get_customer_location() /home/stock2cart/public_html/app/functions/fn.cart.php:6942
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.cart.php:5027
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00006 Re-run Backtrace
82
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_get_taxed_and_clean_prices() /home/stock2cart/public_html/app/functions/fn.products.php:839
  • fn_calculate_tax_rates() /home/stock2cart/public_html/app/functions/fn.cart.php:7281
  • fn_get_available_destination() /home/stock2cart/public_html/app/functions/fn.cart.php:6943
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00005 Re-run Backtrace
83
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:882
  • fn_warehouses_gather_additional_products_data_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_warehouses_get_destination_id_by_product_params() /home/stock2cart/public_html/app/addons/warehouses/func.php:1300
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/func.php:1691
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00007 Re-run Backtrace
84
SELECT cscart_ab__stickers.*, descriptions.*, images.image_id, cscart_ab__stickers.sticker_id as sticker_id FROM cscart_ab__stickers LEFT JOIN cscart_ab__sticker_descriptions as descriptions
ON cscart_ab__stickers.sticker_id = descriptions.sticker_id
AND descriptions.lang_code = 'en'
LEFT JOIN cscart_ab__sticker_images AS images
ON cscart_ab__stickers.sticker_id = images.sticker_id
AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND cscart_ab__stickers.status = 'A' AND ((cscart_ab__stickers.from_date <= 1734728400 OR cscart_ab__stickers.from_date = 0) AND (cscart_ab__stickers.to_date >= 1734728400 OR cscart_ab__stickers.to_date = 0)) AND cscart_ab__stickers.sticker_id IN (0) AND cscart_ab__stickers.display_on_lists NOT LIKE '%"blocks/products/products_multicolumns.tpl";s:11:"not_display"%' AND (cscart_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, cscart_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, cscart_ab__stickers.usergroup_ids))  ORDER BY cscart_ab__stickers.position asc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:882
  • fn_ab__stickers_gather_additional_products_data_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Ab_stickers\StickersRepository::find() /home/stock2cart/public_html/app/addons/ab__stickers/functions/fn.ab__s.hooks.php:122
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/addons/ab__stickers/Ab_stickers/StickersRepository.php:269
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00044 Re-run Backtrace
85
SELECT cscart_ab__stickers.*, descriptions.*, images.image_id, cscart_ab__stickers.sticker_id as sticker_id FROM cscart_ab__stickers LEFT JOIN cscart_ab__sticker_descriptions as descriptions
ON cscart_ab__stickers.sticker_id = descriptions.sticker_id
AND descriptions.lang_code = 'en'
LEFT JOIN cscart_ab__sticker_images AS images
ON cscart_ab__stickers.sticker_id = images.sticker_id
AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND cscart_ab__stickers.status = 'A' AND ((cscart_ab__stickers.from_date <= 1734728400 OR cscart_ab__stickers.from_date = 0) AND (cscart_ab__stickers.to_date >= 1734728400 OR cscart_ab__stickers.to_date = 0)) AND ((0) OR cscart_ab__stickers.type = 'D') AND cscart_ab__stickers.display_on_lists NOT LIKE '%"blocks/products/products_multicolumns.tpl";s:11:"not_display"%' AND (cscart_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, cscart_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, cscart_ab__stickers.usergroup_ids))  ORDER BY cscart_ab__stickers.position asc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_gather_additional_products_data() /home/stock2cart/public_html/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.products.php:882
  • fn_ab__stickers_gather_additional_products_data_post() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Ab_stickers\StickersRepository::find() /home/stock2cart/public_html/app/addons/ab__stickers/functions/fn.ab__s.hooks.php:130
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/addons/ab__stickers/Ab_stickers/StickersRepository.php:269
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00024 Re-run Backtrace
86
SELECT mdi.mdi_id,mdi.tag,mdi.is_faq,mdi.is_open,mdi.status,mdi.position,mdi.item_type,mdi.filling_type,mdi.filling_data,mdi.position_on_page,mdid.lang_code,mdid.title,mdid.description FROM cscart_ab__md_items as mdi  LEFT JOIN cscart_ab__md_item_settings item_settings ON mdi.mdi_id=item_settings.item_id AND item_settings.object_type='category' LEFT JOIN cscart_ab__md_items_links global_links_include
ON global_links_include.item_id=mdi.mdi_id AND global_links_include.object_type='category' AND
(global_links_include.object_id=4927 AND global_links_include.link_type='I') LEFT JOIN cscart_ab__md_items_links global_links_exclude
ON global_links_exclude.item_id=mdi.mdi_id AND global_links_exclude.object_type='category' AND
(global_links_exclude.object_id=4927 AND global_links_exclude.link_type='E') INNER JOIN cscart_ab__md_item_descriptions AS mdid ON (mdi.mdi_id=mdid.mdi_id AND mdid.lang_code='en' AND IF(mdi.item_type='elements',TRIM(mdid.description) != '',TRIM(mdid.title) != ''))  WHERE 1  AND item_settings.status='A' AND (item_settings.is_global='Y' OR global_links_include.object_id is not null) and global_links_exclude.object_id is null AND mdi.status='A'   ORDER BY mdi.status asc, mdi.position asc, mdid.title asc 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_ab__mcd_get_items() /home/stock2cart/public_html/app/addons/ab__multiple_cat_descriptions/controllers/frontend/categories.post.php:31
  • db_get_hash_array() /home/stock2cart/public_html/app/addons/ab__multiple_cat_descriptions/func.php:310
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00111 Re-run Backtrace
87
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 4927

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_age_verification_category_check() /home/stock2cart/public_html/app/addons/age_verification/controllers/frontend/categories.post.php:20
  • db_get_row() /home/stock2cart/public_html/app/addons/age_verification/func.php:86
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00020 Re-run Backtrace
88
SELECT n.sf_id,n.category_id,n.features_hash,nd.name_in_subcategory_block
FROM cscart_ab__sf_names as n
INNER JOIN cscart_ab__sf_name_descriptions as nd ON (nd.sf_id=n.sf_id AND nd.lang_code='en')
WHERE n.category_id=4927
AND n.fixed in ('F', 'U')
AND n.show_in_subcategory_block='Y'
ORDER BY n.position_in_subcategory_block ASC,nd.name_in_subcategory_block ASC

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_run_controller() /home/stock2cart/public_html/app/functions/fn.control.php:458
  • include() /home/stock2cart/public_html/app/functions/fn.control.php:722
  • fn_ab__sf_pages_as_subcategories() /home/stock2cart/public_html/app/addons/ab__seo_filters/controllers/frontend/categories.post.php:38
  • db_get_hash_array() /home/stock2cart/public_html/app/addons/ab__seo_filters/func.php:377
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00030 Re-run Backtrace
89
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_check_permissions() /home/stock2cart/public_html/app/functions/fn.control.php:517
  • fn_check_admin_permissions() /home/stock2cart/public_html/app/functions/fn.common.php:2546
  • db_get_fields() /home/stock2cart/public_html/app/functions/fn.common.php:2728
  • Tygh\Database\Connection::getColumn() /home/stock2cart/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:479
0.00018 Re-run Backtrace
90
SELECT var, value FROM cscart_ab__so_noindex_tech_pages WHERE object_id = 4927 AND object_type = 'category' AND company_id = 0

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:623
  • fn_seo_dispatch_before_display() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_ab__so_ntp_get_canonical_base_url() /home/stock2cart/public_html/app/addons/seo/func.php:3031
  • fn_ab__so_ntp_get_index_data() /home/stock2cart/public_html/app/addons/ab__so_noindex_tech_pages/func.php:139
  • db_get_hash_single_array() /home/stock2cart/public_html/app/addons/ab__so_noindex_tech_pages/func.php:27
  • Tygh\Database\Connection::getSingleHash() /home/stock2cart/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:571
0.00018 Re-run Backtrace
91
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'en' AND lang.name = 'ab__emd.placeholders.storefront'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:623
  • fn_ab__extended_metadata_dispatch_before_display() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_get_schema() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:35
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • __() /home/stock2cart/public_html/app/addons/ab__deal_of_the_day/schemas/ab__extended_metadata/placeholders.post.php:70
  • Tygh\Languages\Values::getLangVar() /home/stock2cart/public_html/app/functions/fn.common.php:6089
  • db_get_field() /home/stock2cart/public_html/app/Tygh/Languages/Values.php:184
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00018 Re-run Backtrace
92
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:623
  • fn_ab__extended_metadata_dispatch_before_display() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_get_schema() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:35
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • __() /home/stock2cart/public_html/app/addons/ab__deal_of_the_day/schemas/ab__extended_metadata/placeholders.post.php:70
  • Tygh\Languages\Values::getLangVar() /home/stock2cart/public_html/app/functions/fn.common.php:6089
  • db_get_found_rows() /home/stock2cart/public_html/app/Tygh/Languages/Values.php:186
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:332
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00006 Re-run Backtrace
93
SELECT `dispatch`, `value` FROM cscart_ab__emd_settings WHERE company_id = 1 AND lang_code = 'en'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:623
  • fn_ab__extended_metadata_dispatch_before_display() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_ab__emd_get_settings() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:38
  • db_get_array() /home/stock2cart/public_html/app/addons/ab__extended_metadata/ab__functions/fn.settings.php:25
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00016 Re-run Backtrace
94
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'en' AND lang.name = 'ab__emd.placeholders.storefront'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:623
  • fn_ab__extended_metadata_dispatch_before_display() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_ab__emd_replace_placeholders() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:47
  • fn_get_schema() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:58
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • __() /home/stock2cart/public_html/app/addons/ab__deal_of_the_day/schemas/ab__extended_metadata/placeholders.post.php:70
  • Tygh\Languages\Values::getLangVar() /home/stock2cart/public_html/app/functions/fn.common.php:6089
  • db_get_field() /home/stock2cart/public_html/app/Tygh/Languages/Values.php:184
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00008 Re-run Backtrace
95
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.control.php:623
  • fn_ab__extended_metadata_dispatch_before_display() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • fn_ab__emd_replace_placeholders() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:47
  • fn_get_schema() /home/stock2cart/public_html/app/addons/ab__extended_metadata/func.php:58
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • __() /home/stock2cart/public_html/app/addons/ab__deal_of_the_day/schemas/ab__extended_metadata/placeholders.post.php:70
  • Tygh\Languages\Values::getLangVar() /home/stock2cart/public_html/app/functions/fn.common.php:6089
  • db_get_found_rows() /home/stock2cart/public_html/app/Tygh/Languages/Values.php:186
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:332
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00004 Re-run Backtrace
96
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 166 AND c.company_id = 0

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /home/stock2cart/public_html/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /home/stock2cart/public_html/app/Tygh/BlockManager/Container.php:75
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00024 Re-run Backtrace
97
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 166

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /home/stock2cart/public_html/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /home/stock2cart/public_html/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00016 Re-run Backtrace
98
SELECT c.*, IF (c.location_id != 166, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 8 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /home/stock2cart/public_html/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /home/stock2cart/public_html/app/Tygh/BlockManager/Container.php:75
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00151 Re-run Backtrace
99
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (649, 650, 663, 652) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Grid::getList() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:133
  • db_get_hash_multi_array() /home/stock2cart/public_html/app/Tygh/BlockManager/Grid.php:68
  • Tygh\Database\Connection::getMultiHash() /home/stock2cart/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:525
0.00039 Re-run Backtrace
100
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 4927 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 860, 859, 856, 861, 857, 858, 1252, 1251, 887, 888, 889, 890, 891, 892)  AND cscart_bm_blocks_descriptions.lang_code='en'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Block::getList() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:142
  • db_get_hash_multi_array() /home/stock2cart/public_html/app/Tygh/BlockManager/Block.php:283
  • Tygh\Database\Connection::getMultiHash() /home/stock2cart/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:525
0.00129 Re-run Backtrace
101
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:820
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:222
  • {closure}() /home/stock2cart/public_html/app/Tygh/Registry.php:800
  • db_get_hash_array() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00021 Re-run Backtrace
102
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 1

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:820
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:222
  • {closure}() /home/stock2cart/public_html/app/Tygh/Registry.php:800
  • fn_hybrid_auth_get_storefront_ids() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:202
  • db_get_fields() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:233
  • Tygh\Database\Connection::getColumn() /home/stock2cart/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:479
0.00016 Re-run Backtrace
103
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 2

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:820
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:222
  • {closure}() /home/stock2cart/public_html/app/Tygh/Registry.php:800
  • fn_hybrid_auth_get_storefront_ids() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:202
  • db_get_fields() /home/stock2cart/public_html/app/addons/hybrid_auth/func.php:233
  • Tygh\Database\Connection::getColumn() /home/stock2cart/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:479
0.00006 Re-run Backtrace
104
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /home/stock2cart/public_html/app/Tygh/BlockManager/Block.php:974
  • fn_product_filters_get_filters_products_count()
  • fn_set_hook() /home/stock2cart/public_html/app/functions/fn.filters.php:1293
  • fn_warehouses_get_filters_products_count_pre() /home/stock2cart/public_html/app/functions/fn.control.php:123
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/func.php:1947
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00010 Re-run Backtrace
105
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:932
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00010 Re-run Backtrace
106
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:932
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00010 Re-run Backtrace
107
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /home/stock2cart/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:932
  • call_user_func_array() /home/stock2cart/public_html/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /home/stock2cart/public_html/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /home/stock2cart/public_html/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /home/stock2cart/public_html/app/functions/fn.locations.php:494
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:618
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00008 Re-run Backtrace
108
SELECT company_id FROM cscart_companies WHERE 1  AND company = 'Stock2cart.com'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:175
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d78015bc7_46355180() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_abt__ut2_get_microdata() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/1211c409b6b175ffdd9ccc586d678208f034d18d_2.tygh.footer.post.tpl.php:45
  • fn_get_schema() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • fn_get_company_id_by_name() /home/stock2cart/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:23
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.companies.php:718
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00021 Re-run Backtrace
109
SELECT * FROM cscart_logos WHERE layout_id IN (8, 0) AND style_id IN ('unitheme_new', '') AND storefront_id IN (1, 0)  AND company_id = 0

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:175
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d78015bc7_46355180() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_abt__ut2_get_microdata() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/1211c409b6b175ffdd9ccc586d678208f034d18d_2.tygh.footer.post.tpl.php:45
  • fn_get_schema() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • fn_get_logos() /home/stock2cart/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:25
  • db_get_hash_array() /home/stock2cart/public_html/app/functions/fn.common.php:5641
  • Tygh\Database\Connection::getHash() /home/stock2cart/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:370
0.00179 Re-run Backtrace
110
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (15, 340, 341, 342, 457) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:175
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d78015bc7_46355180() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_abt__ut2_get_microdata() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/1211c409b6b175ffdd9ccc586d678208f034d18d_2.tygh.footer.post.tpl.php:45
  • fn_get_schema() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • fn_get_logos() /home/stock2cart/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:25
  • fn_get_image_pairs() /home/stock2cart/public_html/app/functions/fn.common.php:5649
  • db_multi_query() /home/stock2cart/public_html/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/stock2cart/public_html/app/functions/fn.database.php:168
0.00047 Re-run Backtrace
111
SELECT country FROM cscart_country_descriptions WHERE code = 'IN' AND lang_code = 'en'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:175
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d78015bc7_46355180() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_abt__ut2_get_microdata() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/1211c409b6b175ffdd9ccc586d678208f034d18d_2.tygh.footer.post.tpl.php:45
  • fn_get_schema() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • fn_get_country_name() /home/stock2cart/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:60
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:324
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00021 Re-run Backtrace
112
SELECT cscart_state_descriptions.state FROM cscart_states LEFT JOIN cscart_state_descriptions ON cscart_state_descriptions.state_id = cscart_states.state_id AND cscart_state_descriptions.lang_code = 'en' WHERE cscart_states.country_code = 'IN' AND cscart_states.code = 'TN'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:175
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d78015bc7_46355180() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_abt__ut2_get_microdata() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/1211c409b6b175ffdd9ccc586d678208f034d18d_2.tygh.footer.post.tpl.php:45
  • fn_get_schema() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29
  • include() /home/stock2cart/public_html/app/functions/fn.common.php:2473
  • fn_get_state_name() /home/stock2cart/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:60
  • db_get_field() /home/stock2cart/public_html/app/functions/fn.locations.php:313
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00019 Re-run Backtrace
113
SELECT cscart_abt__ut2_microdata.id, cscart_abt__ut2_microdata.field, cscart_abt__ut2_microdata_description.value
FROM cscart_abt__ut2_microdata
INNER JOIN cscart_abt__ut2_microdata_description ON cscart_abt__ut2_microdata_description.id = cscart_abt__ut2_microdata.id AND cscart_abt__ut2_microdata_description.lang_code = 'en'
WHERE cscart_abt__ut2_microdata.company_id = 0
ORDER BY cscart_abt__ut2_microdata.id ASC

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:175
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d78015bc7_46355180() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_abt__ut2_get_microdata() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/1211c409b6b175ffdd9ccc586d678208f034d18d_2.tygh.footer.post.tpl.php:45
  • Tygh\ABTUT2::fn_get_microdata() /home/stock2cart/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:31
  • db_get_array() /home/stock2cart/public_html/app/addons/abt__unitheme2/Tygh/ABTUT2.php:68
  • Tygh\Database\Connection::getArray() /home/stock2cart/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:332
0.00024 Re-run Backtrace
114
SELECT c.parent_id, sm.search_phrases
FROM cscart_categories AS c
LEFT JOIN cscart_ab__search_motivation AS sm ON sm.category_id = c.category_id AND sm.lang_code = 'en'
WHERE c.category_id = 4927

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:180
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d780b3e25_02755334() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/c57c2a8d1afc8dfc09951b742458d3ca5bf2f49a_2.tygh.scripts.tpl.php:599
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d782393e9_13507260() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_ab__search_motivation_get_phrases() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/6de8dea46c2f5105c9201cda590e41c2f36b5549_2.tygh.scripts.post.tpl.php:73
  • fn_ab__search_motivation_get_phrases_by_cid() /home/stock2cart/public_html/app/addons/ab__search_motivation/func.php:76
  • db_get_row() /home/stock2cart/public_html/app/addons/ab__search_motivation/func.php:41
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00021 Re-run Backtrace
115
SELECT search_phrases FROM cscart_ab__search_motivation WHERE category_id = 0 AND company_id = 0 AND lang_code = 'en' AND TRIM(search_phrases) > ""

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/stock2cart/public_html/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d752d0623_27387053() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/11ae0be02b4357c2aa24348defffa8d625c8d807_2.tygh.index.tpl.php:180
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d780b3e25_02755334() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/c57c2a8d1afc8dfc09951b742458d3ca5bf2f49a_2.tygh.scripts.tpl.php:599
  • Smarty_Internal_TemplateBase::fetch() /home/stock2cart/public_html/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67513d782393e9_13507260() /home/stock2cart/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_ab__search_motivation_get_phrases() /home/stock2cart/public_html/var/cache/templates/abt__unitheme2/6de8dea46c2f5105c9201cda590e41c2f36b5549_2.tygh.scripts.post.tpl.php:73
  • fn_ab__search_motivation_get_default_phrases() /home/stock2cart/public_html/app/addons/ab__search_motivation/func.php:86
  • db_get_field() /home/stock2cart/public_html/app/addons/ab__search_motivation/func.php:61
  • Tygh\Database\Connection::getField() /home/stock2cart/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:447
0.00010 Re-run Backtrace
116
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

    Backtrace

  • fn_dispatch() /home/stock2cart/public_html/index.php:19
  • Tygh\Application::offsetGet() /home/stock2cart/public_html/app/functions/fn.control.php:648
  • Pimple\Container::offsetGet() /home/stock2cart/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/stock2cart/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • fn_get_storage_data() /home/stock2cart/public_html/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /home/stock2cart/public_html/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /home/stock2cart/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/stock2cart/public_html/app/Tygh/Database/Connection.php:413
0.00018 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 8
Query Count Min time Max time Average time
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'
8 0.00005 0.00018 0.00009
SELECT FOUND_ROWS()
3 0.00004 0.00013 0.00007
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE (ip_from <= '038fd656' AND ip_to >= '038fd656') AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
2 0.00027 0.00034 0.00031
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
2 0.00015 0.00015 0.00015
SELECT COUNT(*) FROM cscart_states WHERE country_code = 'IN' AND code = '32' AND status = 'A'
2 0.00006 0.00009 0.00007
SELECT COUNT(*) FROM cscart_countries WHERE code = 'IN' AND status = 'A'
2 0.00006 0.00020 0.00013
SELECT id_path FROM cscart_categories WHERE category_id = 4927
2 0.00015 0.00017 0.00016
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'en' AND lang.name = 'ab__emd.placeholders.storefront'
2 0.00008 0.00018 0.00013
DELETE FROM cscart_access_restriction_block WHERE expires < 1734786847
2 0.00014 0.00026 0.00020
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1734786847
2 0.00014 0.00033 0.00024
SELECT tax_id, address_type, priority, price_includes_tax, regnumber FROM cscart_taxes WHERE tax_id IN (12, 10, 13) AND status = 'A' ORDER BY priority
1 0.00048 0.00048 0.00048
SELECT product_id FROM cscart_products WHERE product_type = 'D'
1 0.33434 0.33434 0.33434
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1734786847, 1) AND IF(to_date, to_date >= 1734786847, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL) AND (cscart_promotions.company_id IN (137, 138, 146) OR cscart_promotions.company_id=0)   ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc 
1 0.00058 0.00058 0.00058
SELECT
p.promotion_id,
p.from_date,
p.to_date,
active.from_date AS active_from_date,
active.to_date AS active_to_date,
expired.from_date AS expired_from_date,
expired.to_date AS expired_to_date
FROM cscart_promotions AS p
INNER JOIN cscart_ab__dotd AS ab__dotd ON p.promotion_id=ab__dotd.promotion_id AND ab__dotd.use_schedule='Y'
LEFT JOIN (SELECT promotion_id,MIN(from_date) AS from_date,MIN(to_date) AS to_date FROM cscart_ab__dotd_periods WHERE to_date >= 1734786847 GROUP BY promotion_id) AS active ON active.promotion_id=p.promotion_id
LEFT JOIN (SELECT promotion_id,MAX(from_date) AS from_date,MAX(to_date) AS to_date FROM cscart_ab__dotd_periods WHERE to_date < 1734786847 GROUP BY promotion_id) AS expired ON expired.promotion_id=p.promotion_id
WHERE p.status IN ('A', 'H')
1 0.00095 0.00095 0.00095
SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_product_variation_group_features AS f INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (276352)
1 0.00054 0.00054 0.00054
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00028 0.00028 0.00028
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (276352) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position
1 0.00040 0.00040 0.00040
SELECT cscart_ab__stickers.*, descriptions.*, images.image_id, cscart_ab__stickers.sticker_id as sticker_id FROM cscart_ab__stickers LEFT JOIN cscart_ab__sticker_descriptions as descriptions
ON cscart_ab__stickers.sticker_id = descriptions.sticker_id
AND descriptions.lang_code = 'en'
LEFT JOIN cscart_ab__sticker_images AS images
ON cscart_ab__stickers.sticker_id = images.sticker_id
AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND cscart_ab__stickers.status = 'A' AND ((cscart_ab__stickers.from_date <= 1734728400 OR cscart_ab__stickers.from_date = 0) AND (cscart_ab__stickers.to_date >= 1734728400 OR cscart_ab__stickers.to_date = 0)) AND ((0) OR cscart_ab__stickers.type = 'D') AND cscart_ab__stickers.display_on_lists NOT LIKE '%"blocks/products/products_multicolumns.tpl";s:11:"not_display"%' AND (cscart_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, cscart_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, cscart_ab__stickers.usergroup_ids))  ORDER BY cscart_ab__stickers.position asc 
1 0.00024 0.00024 0.00024
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (276352) AND a.status = 'A' ORDER BY a.position
1 0.00075 0.00075 0.00075
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00039 0.00039 0.00039
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 5890 ORDER BY cscart_settings_objects.position
1 0.00038 0.00038 0.00038
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'watermark' 
1 0.00037 0.00037 0.00037
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
1 0.00122 0.00122 0.00122
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (276352) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00040 0.00040 0.00040
SELECT p.product_id,ifnull(count(dp.post_id),0) as discussion_amount_posts
FROM cscart_discussion
INNER JOIN cscart_products as p ON (cscart_discussion.object_id=p.product_id)
INNER JOIN cscart_discussion_posts as dp ON (cscart_discussion.thread_id=dp.thread_id AND cscart_discussion.object_type='P' )
WHERE dp.status='A' and p.product_id in (276352)
GROUP BY p.product_id
1 0.00030 0.00030 0.00030
SELECT video_id, product_id FROM cscart_ab__video_gallery WHERE product_id IN (276352) AND status = "A"
1 0.00042 0.00042 0.00042
SELECT product_id, feature_short_desc FROM cscart_ab__short_desc_from_features_values
WHERE product_id IN (276352) AND lang_code = 'en' AND storefront_id = 1 
1 0.00044 0.00044 0.00044
SELECT cscart_ab__stickers.*, descriptions.*, images.image_id, cscart_ab__stickers.sticker_id as sticker_id FROM cscart_ab__stickers LEFT JOIN cscart_ab__sticker_descriptions as descriptions
ON cscart_ab__stickers.sticker_id = descriptions.sticker_id
AND descriptions.lang_code = 'en'
LEFT JOIN cscart_ab__sticker_images AS images
ON cscart_ab__stickers.sticker_id = images.sticker_id
AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND cscart_ab__stickers.status = 'A' AND ((cscart_ab__stickers.from_date <= 1734728400 OR cscart_ab__stickers.from_date = 0) AND (cscart_ab__stickers.to_date >= 1734728400 OR cscart_ab__stickers.to_date = 0)) AND cscart_ab__stickers.sticker_id IN (0) AND cscart_ab__stickers.display_on_lists NOT LIKE '%"blocks/products/products_multicolumns.tpl";s:11:"not_display"%' AND (cscart_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, cscart_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, cscart_ab__stickers.usergroup_ids))  ORDER BY cscart_ab__stickers.position asc 
1 0.00044 0.00044 0.00044
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00018 0.00018 0.00018
SELECT mdi.mdi_id,mdi.tag,mdi.is_faq,mdi.is_open,mdi.status,mdi.position,mdi.item_type,mdi.filling_type,mdi.filling_data,mdi.position_on_page,mdid.lang_code,mdid.title,mdid.description FROM cscart_ab__md_items as mdi  LEFT JOIN cscart_ab__md_item_settings item_settings ON mdi.mdi_id=item_settings.item_id AND item_settings.object_type='category' LEFT JOIN cscart_ab__md_items_links global_links_include
ON global_links_include.item_id=mdi.mdi_id AND global_links_include.object_type='category' AND
(global_links_include.object_id=4927 AND global_links_include.link_type='I') LEFT JOIN cscart_ab__md_items_links global_links_exclude
ON global_links_exclude.item_id=mdi.mdi_id AND global_links_exclude.object_type='category' AND
(global_links_exclude.object_id=4927 AND global_links_exclude.link_type='E') INNER JOIN cscart_ab__md_item_descriptions AS mdid ON (mdi.mdi_id=mdid.mdi_id AND mdid.lang_code='en' AND IF(mdi.item_type='elements',TRIM(mdid.description) != '',TRIM(mdid.title) != ''))  WHERE 1  AND item_settings.status='A' AND (item_settings.is_global='Y' OR global_links_include.object_id is not null) and global_links_exclude.object_id is null AND mdi.status='A'   ORDER BY mdi.status asc, mdi.position asc, mdid.title asc 
1 0.00111 0.00111 0.00111
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 1
1 0.00016 0.00016 0.00016
SELECT search_phrases FROM cscart_ab__search_motivation WHERE category_id = 0 AND company_id = 0 AND lang_code = 'en' AND TRIM(search_phrases) > ""
1 0.00010 0.00010 0.00010
SELECT c.parent_id, sm.search_phrases
FROM cscart_categories AS c
LEFT JOIN cscart_ab__search_motivation AS sm ON sm.category_id = c.category_id AND sm.lang_code = 'en'
WHERE c.category_id = 4927
1 0.00021 0.00021 0.00021
SELECT cscart_abt__ut2_microdata.id, cscart_abt__ut2_microdata.field, cscart_abt__ut2_microdata_description.value
FROM cscart_abt__ut2_microdata
INNER JOIN cscart_abt__ut2_microdata_description ON cscart_abt__ut2_microdata_description.id = cscart_abt__ut2_microdata.id AND cscart_abt__ut2_microdata_description.lang_code = 'en'
WHERE cscart_abt__ut2_microdata.company_id = 0
ORDER BY cscart_abt__ut2_microdata.id ASC
1 0.00024 0.00024 0.00024
SELECT cscart_state_descriptions.state FROM cscart_states LEFT JOIN cscart_state_descriptions ON cscart_state_descriptions.state_id = cscart_states.state_id AND cscart_state_descriptions.lang_code = 'en' WHERE cscart_states.country_code = 'IN' AND cscart_states.code = 'TN'
1 0.00019 0.00019 0.00019
SELECT country FROM cscart_country_descriptions WHERE code = 'IN' AND lang_code = 'en'
1 0.00021 0.00021 0.00021
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (15, 340, 341, 342, 457) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00047 0.00047 0.00047
SELECT * FROM cscart_logos WHERE layout_id IN (8, 0) AND style_id IN ('unitheme_new', '') AND storefront_id IN (1, 0)  AND company_id = 0
1 0.00179 0.00179 0.00179
SELECT company_id FROM cscart_companies WHERE 1  AND company = 'Stock2cart.com'
1 0.00021 0.00021 0.00021
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 2
1 0.00006 0.00006 0.00006
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position
1 0.00021 0.00021 0.00021
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 4927
1 0.00020 0.00020 0.00020
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 4927 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 854, 855, 860, 859, 856, 861, 857, 858, 1252, 1251, 887, 888, 889, 890, 891, 892)  AND cscart_bm_blocks_descriptions.lang_code='en'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00129 0.00129 0.00129
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (649, 650, 663, 652) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00039 0.00039 0.00039
SELECT c.*, IF (c.location_id != 166, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 8 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
1 0.00151 0.00151 0.00151
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 166
1 0.00016 0.00016 0.00016
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 166 AND c.company_id = 0
1 0.00024 0.00024 0.00024
SELECT `dispatch`, `value` FROM cscart_ab__emd_settings WHERE company_id = 1 AND lang_code = 'en'
1 0.00016 0.00016 0.00016
SELECT var, value FROM cscart_ab__so_noindex_tech_pages WHERE object_id = 4927 AND object_type = 'category' AND company_id = 0
1 0.00018 0.00018 0.00018
SELECT is_stock_split_by_warehouses FROM cscart_products WHERE product_id = 276352
1 0.00018 0.00018 0.00018
SELECT n.sf_id,n.category_id,n.features_hash,nd.name_in_subcategory_block
FROM cscart_ab__sf_names as n
INNER JOIN cscart_ab__sf_name_descriptions as nd ON (nd.sf_id=n.sf_id AND nd.lang_code='en')
WHERE n.category_id=4927
AND n.fixed in ('F', 'U')
AND n.show_in_subcategory_block='Y'
ORDER BY n.position_in_subcategory_block ASC,nd.name_in_subcategory_block ASC
1 0.00030 0.00030 0.00030
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00017 0.00017 0.00017
SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE  a.country_code = 'IN' ORDER BY b.state
1 0.00068 0.00068 0.00068
SELECT warehouse_id, amount, store_type, position, main_destination_id,  pickup_destinations_ids, shipping_destinations_ids, status FROM cscart_store_locations AS sl INNER JOIN cscart_warehouses_products_amount AS wpa ON wpa.warehouse_id = sl.store_location_id WHERE wpa.product_id = 276352 ORDER BY sl.position ASC
1 0.00043 0.00043 0.00043
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00022 0.00022 0.00022
SELECT cscart_ab__category_banners.*, cscart_ab__category_banner_images_and_descr.category_banner, cscart_ab__category_banner_images_and_descr.url, cscart_ab__category_banner_images_and_descr.category_banner_image_id FROM cscart_ab__category_banners
INNER JOIN cscart_ab__category_banner_images_and_descr ON cscart_ab__category_banner_images_and_descr.category_banner_id = cscart_ab__category_banners.category_banner_id AND cscart_ab__category_banner_images_and_descr.lang_code = 'en'
 LEFT JOIN cscart_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = cscart_ab__category_banners.category_banner_id  LEFT JOIN cscart_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = cscart_ab__category_banners.category_banner_id INNER JOIN cscart_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = cscart_ab__category_banner_images_and_descr.category_banner_image_id AND il.pair_id IS NOT NULL AND il.type = 'M'
WHERE 1  AND cscart_ab__category_banners.status = 'A'  AND cscart_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL  AND (IF(cscart_ab__category_banners.from_date, cscart_ab__category_banners.from_date <= 1734786847, 1) AND IF(cscart_ab__category_banners.to_date, cscart_ab__category_banners.to_date >= 1734786847, 1)) AND (ab__category_banner_categories.category_id = 4927 OR (ab__category_banner_categories1.category_id IN (4927) AND cscart_ab__category_banners.include_subcategories = 'Y'))  ORDER BY cscart_ab__category_banner_images_and_descr.category_banner asc 
1 0.00108 0.00108 0.00108
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 4927
1 0.00019 0.00019 0.00019
SELECT category_id FROM cscart_categories WHERE category_id = 4927  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H')
1 0.00039 0.00039 0.00039
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00019 0.00019 0.00019
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 8  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(4927, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00350 0.00350 0.00350
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 8
1 0.00022 0.00022 0.00022
SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'unitheme_new.less'
1 0.00030 0.00030 0.00030
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' AND storefront_id = 1
1 0.00073 0.00073 0.00073
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00024 0.00024 0.00024
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 4927
1 0.00022 0.00022 0.00022
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1
1 0.00040 0.00040 0.00040
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 4927 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00033 0.00033 0.00033
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00026 0.00026 0.00026
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00039 0.00039 0.00039
SELECT * FROM cscart_seo_names WHERE name = 'surface-socket-outlet-with-protection'  
1 0.00030 0.00030 0.00030
SELECT type FROM cscart_seo_names WHERE name = 'surface-socket-outlet-with-protection' 
1 0.00039 0.00039 0.00039
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
1 0.00025 0.00025 0.00025
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00029 0.00029 0.00029
SET time_zone = '+03:00'
1 0.00017 0.00017 0.00017
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category_banner' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IS NULL ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00030 0.00030 0.00030
SELECT category_id FROM cscart_categories WHERE category_id = 4927  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)
1 0.00020 0.00020 0.00020
SELECT a.* FROM cscart_destination_elements as a LEFT JOIN cscart_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 
1 0.00063 0.00063 0.00063
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00057 0.00057 0.00057
SELECT a.code, b.state FROM cscart_states as a LEFT JOIN cscart_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'en' WHERE  a.country_code = 'IN' AND a.status = 'A' ORDER BY b.state
1 0.00049 0.00049 0.00049
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'stock2cart.com' OR storefronts.url = 'www.stock2cart.com' OR storefronts.url LIKE 'www_.stock2cart.com' OR storefronts.url LIKE 'stock2cart.com/%' OR storefronts.url LIKE 'www.stock2cart.com/%' OR storefronts.url LIKE 'www_.stock2cart.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'stock2cart.com' DESC, storefronts.url = 'www.stock2cart.com' DESC, storefronts.url LIKE 'www_.stock2cart.com' DESC, storefronts.url LIKE 'stock2cart.com/%' DESC, storefronts.url LIKE 'www.stock2cart.com/%' DESC, storefronts.url LIKE 'www_.stock2cart.com/%' desc 
1 0.00047 0.00047 0.00047
SELECT product_id, amount FROM cscart_warehouses_sum_products_amount WHERE 1 AND product_id IN (276352)
1 0.00019 0.00019 0.00019
SELECT cscart_discussion.object_id AS product_id, AVG(cscart_discussion_rating.rating_value) AS average_rating, cscart_discussion.type AS discussion_type, cscart_discussion.thread_id AS discussion_thread_id FROM cscart_discussion  LEFT JOIN cscart_discussion_posts   ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = "A" LEFT JOIN cscart_discussion_rating   ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id   AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id   AND cscart_discussion_rating.rating_value != 0 WHERE cscart_discussion.object_id IN (276352)  AND cscart_discussion.object_type = "P" GROUP BY cscart_discussion.object_id
1 0.00074 0.00074 0.00074
SELECT cscart_seo_names.object_id AS product_id, cscart_seo_names.name AS seo_name, cscart_seo_names.path AS seo_path FROM cscart_seo_names  WHERE cscart_seo_names.object_id IN (276352)  AND cscart_seo_names.type = "p" AND cscart_seo_names.dispatch = "" AND cscart_seo_names.lang_code = 'en'  
1 0.00030 0.00030 0.00030
SELECT cscart_products_categories.product_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = "M", CONCAT(cscart_products_categories.category_id, "M"), cscart_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_products_categories  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND cscart_categories.storefront_id IN (0, 1) 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_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 4927 WHERE cscart_products_categories.product_id IN (276352)   GROUP BY cscart_products_categories.product_id
1 0.00074 0.00074 0.00074
SELECT cscart_product_descriptions.product_id, cscart_product_descriptions.short_description, IF(cscart_product_descriptions.short_description = '' OR cscart_product_descriptions.short_description IS NULL, cscart_product_descriptions.full_description, '') AS full_description FROM cscart_product_descriptions  WHERE cscart_product_descriptions.product_id IN (276352)  AND cscart_product_descriptions.lang_code = 'en' 
1 0.00021 0.00021 0.00021
SELECT cscart_product_prices.product_id, COALESCE(cscart_master_products_storefront_min_price.price, MIN(IF(cscart_product_prices.percentage_discount = 0,cscart_product_prices.price,cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) AS price FROM cscart_product_prices  LEFT JOIN cscart_master_products_storefront_min_price ON cscart_master_products_storefront_min_price.product_id = cscart_product_prices.product_id AND cscart_master_products_storefront_min_price.storefront_id = 1 WHERE cscart_product_prices.product_id IN (276352)  AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 1)  GROUP BY cscart_product_prices.product_id
1 0.00032 0.00032 0.00032
SELECT cscart_products.* FROM cscart_products  WHERE cscart_products.product_id IN (276352)  
1 0.00027 0.00027 0.00027
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00077 0.00077 0.00077
SELECT category_id FROM cscart_categories WHERE category_type = 'D'
1 0.00682 0.00682 0.00682
SELECT cscart_languages.* FROM cscart_languages  WHERE 1    
1 0.00026 0.00026 0.00026
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, COALESCE(cscart_master_products_storefront_min_price.price, MIN(IF(prices.percentage_discount = 0,prices.price,prices.price - (prices.price * prices.percentage_discount)/100))) as price, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id, IF(products.age_verification = 'Y', 'Y', IF(cscart_categories.age_verification = 'Y', 'Y', cscart_categories.parent_age_verification)) as need_age_verification, IF(products.age_limit > cscart_categories.age_limit, IF(products.age_limit > cscart_categories.parent_age_limit, products.age_limit, cscart_categories.parent_age_limit), IF(cscart_categories.age_limit > cscart_categories.parent_age_limit, cscart_categories.age_limit, cscart_categories.parent_age_limit)) as age_limit FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_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') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  LEFT JOIN cscart_master_products_storefront_min_price ON cscart_master_products_storefront_min_price.product_id = prices.product_id AND cscart_master_products_storefront_min_price.storefront_id = 1 WHERE 1  AND cscart_categories.category_id IN (4927) AND (companies.status IN ('A', 'S') OR products.company_id = 0) AND products.company_id IN (137, 138, 146, 0) 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 prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id   ORDER BY price asc, products.product_id ASC  LIMIT 0, 20
1 0.00122 0.00122 0.00122
SELECT MIN(prices.price) as ab__min_price, MAX(prices.price) as ab__max_price FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_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') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  LEFT JOIN cscart_master_products_storefront_min_price ON cscart_master_products_storefront_min_price.product_id = prices.product_id AND cscart_master_products_storefront_min_price.storefront_id = 1 WHERE prices.price > 0  AND cscart_categories.category_id IN (4927) AND (companies.status IN ('A', 'S') OR products.company_id = 0) AND products.company_id IN (137, 138, 146, 0) 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 prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 ))
1 0.00172 0.00172 0.00172
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00034 0.00034 0.00034
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (4927)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
1 0.00721 0.00721 0.00721
SELECT search_phrases FROM cscart_ab__search_motivation WHERE category_id = 4927 AND lang_code = 'en'
1 0.00037 0.00037 0.00037
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '4927' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '4927' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00040 0.00040 0.00040
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, IFNULL(ab__emd_cp.category_pattern_id, 0) as ab__emd__category_pattern_id, IFNULL(ab__emd_cp.products_pattern_id, 0) as ab__emd__products_pattern_id FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 4927  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  LEFT JOIN cscart_ab__emd_categories_patterns AS ab__emd_cp ON ab__emd_cp.category_id = cscart_categories.category_id WHERE cscart_categories.category_id = 4927 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))
1 0.00078 0.00078 0.00078
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path,cscart_categories.ab__lc_catalog_image_control,cscart_categories.ab__fn_category_status,cscart_categories.ab__fn_label_color,cscart_categories.ab__fn_label_background,cscart_categories.ab__fn_use_origin_image,cscart_category_descriptions.ab__fn_label_text,cscart_category_descriptions.ab__fn_label_show,cscart_categories.age_verification,cscart_categories.age_limit,cscart_category_descriptions.age_warning_message,cscart_category_descriptions.ab__custom_category_h1 FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE 1=1  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') AND cscart_categories.parent_id IN (4927) AND cscart_categories.id_path LIKE '4927/%' AND cscart_categories.category_id != 414 AND cscart_categories.parent_id != 414 AND cscart_categories.storefront_id IN (0, 1)   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00084 0.00084 0.00084
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00018 0.00018 0.00018