Queries total time: 0.05447 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.00026 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.00031 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.00013 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.00019 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.00021 Re-run Backtrace
6
SELECT type FROM cscart_seo_names WHERE name = 'spring-clamp-terminal-blocks' 

    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.00048 Re-run Backtrace
7
SELECT * FROM cscart_seo_names WHERE name = 'spring-clamp-terminal-blocks'  

    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.00027 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.00026 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.00019 Re-run Backtrace
10
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5167 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.00028 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.00021 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.00017 Re-run Backtrace
13
DELETE FROM cscart_access_restriction_block WHERE expires < 1734787263

    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.00012 Re-run Backtrace
14
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1734787263

    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.00013 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 <= '12761c87' AND ip_to >= '12761c87') 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.00019 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.00009 Re-run Backtrace
17
DELETE FROM cscart_access_restriction_block WHERE expires < 1734787263

    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.00009 Re-run Backtrace
18
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1734787263

    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.00009 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 <= '12761c87' AND ip_to >= '12761c87') 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.00015 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.00009 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.00013 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.00052 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.00017 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.00017 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(5167, 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.00281 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.00016 Re-run Backtrace
27
SELECT category_id FROM cscart_categories WHERE category_id = 5167  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.00021 Re-run Backtrace
28
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 5167

    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.00014 Re-run Backtrace
29
SELECT id_path FROM cscart_categories WHERE category_id = 5167

    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.00013 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 <= 1734787263, 1) AND IF(cscart_ab__category_banners.to_date, cscart_ab__category_banners.to_date >= 1734787263, 1)) AND (ab__category_banner_categories.category_id = 5167 OR (ab__category_banner_categories1.category_id IN (5167) 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.00101 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.00028 Re-run Backtrace
32
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 5167

    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.00018 Re-run Backtrace
33
SELECT category_id FROM cscart_categories WHERE category_id = 5167  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.00017 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.00552 Re-run Backtrace
35
SELECT id_path FROM cscart_categories WHERE category_id = 5167

    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.00014 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 (5167) AND cscart_categories.id_path LIKE '5167/%' 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.00079 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 = 5167  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 = 5167 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.00068 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 = '5167' 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 = '5167' 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.00034 Re-run Backtrace
39
SELECT search_phrases FROM cscart_ab__search_motivation WHERE category_id = 5167 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.00022 Re-run Backtrace
40
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (5167)
                 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.00571 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.00029 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 (5167) 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.00152 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 (5167) 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.00108 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.00011 Re-run Backtrace
45
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.00067 Re-run Backtrace
46
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.00016 Re-run Backtrace
47
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.00043 Re-run Backtrace
48
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.00058 Re-run Backtrace
49
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_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
  • fn_master_products_is_master_products() /home/stock2cart/public_html/app/addons/warehouses/func.php:833
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap() /home/stock2cart/public_html/app/addons/master_products/func.php:1665
  • 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.00034 Re-run Backtrace
50
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_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
  • fn_master_products_is_master_products() /home/stock2cart/public_html/app/addons/warehouses/func.php:833
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap() /home/stock2cart/public_html/app/addons/master_products/func.php:1665
  • 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.00065 Re-run Backtrace
51
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_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
  • fn_master_products_is_master_products() /home/stock2cart/public_html/app/addons/warehouses/func.php:833
  • Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap() /home/stock2cart/public_html/app/addons/master_products/func.php:1665
  • 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.00042 Re-run Backtrace
52
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.00022 Re-run Backtrace
53
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=5167 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=5167 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.00152 Re-run Backtrace
54
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 5167

    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.00023 Re-run Backtrace
55
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=5167
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.00077 Re-run Backtrace
56
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.00038 Re-run Backtrace
57
SELECT var, value FROM cscart_ab__so_noindex_tech_pages WHERE object_id = 5167 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.00040 Re-run Backtrace
58
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.00035 Re-run Backtrace
59
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.00012 Re-run Backtrace
60
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.00038 Re-run Backtrace
61
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.00022 Re-run Backtrace
62
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.00008 Re-run Backtrace
63
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.00042 Re-run Backtrace
64
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.00032 Re-run Backtrace
65
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.00373 Re-run Backtrace
66
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.00086 Re-run Backtrace
67
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 = 5167 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.00276 Re-run Backtrace
68
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.00044 Re-run Backtrace
69
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.00035 Re-run Backtrace
70
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.00015 Re-run Backtrace
71
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.00020 Re-run Backtrace
72
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.00020 Re-run Backtrace
73
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.00018 Re-run Backtrace
74
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.00017 Re-run Backtrace
75
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.00044 Re-run Backtrace
76
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.00441 Re-run Backtrace
77
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.00104 Re-run Backtrace
78
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
  • 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
  • fn_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.images.php:375
  • 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.00137 Re-run Backtrace
79
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
  • 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
  • fn_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.images.php:375
  • 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.00043 Re-run Backtrace
80
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
  • 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
  • fn_attach_absolute_image_paths() /home/stock2cart/public_html/app/functions/fn.images.php:375
  • 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.00047 Re-run Backtrace
81
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.00037 Re-run Backtrace
82
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.00036 Re-run Backtrace
83
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.00050 Re-run Backtrace
84
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 = 5167

    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.00062 Re-run Backtrace
85
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.00015 Re-run Backtrace
86
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.00020 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 5
Query Count Min time Max time Average time
SELECT state_id FROM cscart_states WHERE code = '32' AND country_code = 'IN'
5 0.00016 0.00020 0.00018
SELECT FOUND_ROWS()
3 0.00008 0.00012 0.00011
SELECT id_path FROM cscart_categories WHERE category_id = 5167
2 0.00013 0.00014 0.00014
DELETE FROM cscart_access_restriction_block WHERE expires < 1734787263
2 0.00009 0.00012 0.00011
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'en' AND lang.name = 'ab__emd.placeholders.storefront'
2 0.00022 0.00035 0.00028
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
2 0.00009 0.00009 0.00009
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 <= '12761c87' AND ip_to >= '12761c87') AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
2 0.00015 0.00019 0.00017
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1734787263
2 0.00009 0.00013 0.00011
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 166 AND c.company_id = 0
1 0.00042 0.00042 0.00042
SELECT `dispatch`, `value` FROM cscart_ab__emd_settings WHERE company_id = 1 AND lang_code = 'en'
1 0.00038 0.00038 0.00038
SELECT var, value FROM cscart_ab__so_noindex_tech_pages WHERE object_id = 5167 AND object_type = 'category' AND company_id = 0
1 0.00040 0.00040 0.00040
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00026 0.00026 0.00026
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 166
1 0.00032 0.00032 0.00032
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=5167
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.00077 0.00077 0.00077
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 5167
1 0.00023 0.00023 0.00023
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=5167 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=5167 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.00152 0.00152 0.00152
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00022 0.00022 0.00022
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.00042 0.00042 0.00042
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.00065 0.00065 0.00065
SELECT cscart_languages.* FROM cscart_languages  WHERE 1    
1 0.00034 0.00034 0.00034
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.00058 0.00058 0.00058
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00038 0.00038 0.00038
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 = 5167 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.00276 0.00276 0.00276
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.00373 0.00373 0.00373
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.00043 0.00043 0.00043
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.00015 0.00015 0.00015
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 = 5167
1 0.00062 0.00062 0.00062
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.00050 0.00050 0.00050
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.00036 0.00036 0.00036
SELECT country FROM cscart_country_descriptions WHERE code = 'IN' AND lang_code = 'en'
1 0.00037 0.00037 0.00037
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.00047 0.00047 0.00047
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.00137 0.00137 0.00137
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.00086 0.00086 0.00086
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.00104 0.00104 0.00104
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.00441 0.00441 0.00441
SELECT company_id FROM cscart_companies WHERE 1  AND company = 'Stock2cart.com'
1 0.00044 0.00044 0.00044
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 2
1 0.00015 0.00015 0.00015
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 1
1 0.00035 0.00035 0.00035
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position
1 0.00044 0.00044 0.00044
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.00043 0.00043 0.00043
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 (5167) 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.00108 0.00108 0.00108
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.00067 0.00067 0.00067
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(5167, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00281 0.00281 0.00281
SET time_zone = '+03:00'
1 0.00013 0.00013 0.00013
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.00019 0.00019 0.00019
SELECT company_id FROM cscart_companies WHERE status = 'A' ORDER BY company_id LIMIT 1
1 0.00021 0.00021 0.00021
SELECT type FROM cscart_seo_names WHERE name = 'spring-clamp-terminal-blocks' 
1 0.00048 0.00048 0.00048
SELECT * FROM cscart_seo_names WHERE name = 'spring-clamp-terminal-blocks'  
1 0.00027 0.00027 0.00027
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00026 0.00026 0.00026
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.00019 0.00019 0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5167 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00028 0.00028 0.00028
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.00021 0.00021 0.00021
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00017 0.00017 0.00017
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00013 0.00013 0.00013
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' AND storefront_id = 1
1 0.00052 0.00052 0.00052
SELECT * FROM cscart_abt__ut2_less_settings WHERE style = 'unitheme_new.less'
1 0.00017 0.00017 0.00017
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 8
1 0.00017 0.00017 0.00017
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00016 0.00016 0.00016
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.00031 0.00031 0.00031
SELECT category_id FROM cscart_categories WHERE category_id = 5167  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H')
1 0.00021 0.00021 0.00021
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 5167
1 0.00014 0.00014 0.00014
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 <= 1734787263, 1) AND IF(cscart_ab__category_banners.to_date, cscart_ab__category_banners.to_date >= 1734787263, 1)) AND (ab__category_banner_categories.category_id = 5167 OR (ab__category_banner_categories1.category_id IN (5167) AND cscart_ab__category_banners.include_subcategories = 'Y'))  ORDER BY cscart_ab__category_banner_images_and_descr.category_banner asc 
1 0.00101 0.00101 0.00101
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.00028 0.00028 0.00028
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 5167
1 0.00018 0.00018 0.00018
SELECT category_id FROM cscart_categories WHERE category_id = 5167  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.00017 0.00017 0.00017
SELECT category_id FROM cscart_categories WHERE category_type = 'D'
1 0.00552 0.00552 0.00552
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 (5167) AND cscart_categories.id_path LIKE '5167/%' 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.00079 0.00079 0.00079
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 = 5167  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 = 5167 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.00068 0.00068 0.00068
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 = '5167' 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 = '5167' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00034 0.00034 0.00034
SELECT search_phrases FROM cscart_ab__search_motivation WHERE category_id = 5167 AND lang_code = 'en'
1 0.00022 0.00022 0.00022
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (5167)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
1 0.00571 0.00571 0.00571
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00029 0.00029 0.00029
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 (5167) 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.00152 0.00152 0.00152
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00020 0.00020 0.00020