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

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_redirect_to_regional_storefront() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • Tygh\Storefront\Repository::findByUrl() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1420
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:126
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:313
  • fn_mve_storefront_repository_find_pre() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:105
  • fn_allowed_for() /home/vishalecarter/public_html/multi_dec/app/functions/fn.multivendor.php:2077
  • fn_get_storage_data() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:992
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:1085
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00025 Re-run Backtrace
2
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'vishal.ecarter.co' OR storefronts.url = 'www.vishal.ecarter.co' OR storefronts.url LIKE 'www_.vishal.ecarter.co' OR storefronts.url LIKE 'vishal.ecarter.co/%' OR storefronts.url LIKE 'www.vishal.ecarter.co/%' OR storefronts.url LIKE 'www_.vishal.ecarter.co/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'vishal.ecarter.co' DESC, storefronts.url = 'www.vishal.ecarter.co' DESC, storefronts.url LIKE 'www_.vishal.ecarter.co' DESC, storefronts.url LIKE 'vishal.ecarter.co/%' DESC, storefronts.url LIKE 'www.vishal.ecarter.co/%' DESC, storefronts.url LIKE 'www_.vishal.ecarter.co/%' desc 

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_redirect_to_regional_storefront() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • Tygh\Storefront\Repository::findByUrl() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1420
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:126
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:370
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00023 Re-run Backtrace
3
SET time_zone = '+08:00'

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_settings() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • fn_init_time_zone() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1026
  • db_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1047
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:138
0.00007 Re-run Backtrace
4
SELECT storefronts.* FROM cscart_multi_decstorefronts 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/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_layout() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:614
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Storefront\Repository::findById() /home/vishalecarter/public_html/multi_dec/app/Tygh/Providers/StorefrontProvider.php:187
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:164
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00046 Re-run Backtrace
5
SELECT cscart_multi_decbm_layouts.* FROM cscart_multi_decbm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_layout() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • Tygh\BlockManager\Layout::getDefault() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:642
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00023 Re-run Backtrace
6
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_user() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • fn_login_user() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:713
  • fn_init_user() /home/vishalecarter/public_html/multi_dec/app/functions/fn.users.php:3564
  • fn_is_expired_storage_data() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:745
  • fn_get_storage_data() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:1103
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:1085
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00028 Re-run Backtrace
7
SELECT ec_timezone FROM cscart_multi_decstorefronts WHERE storefront_id = 1

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_templater() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:60
  • fn_ec_multi_store_timezone_init_templater() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • db_get_field() /home/vishalecarter/public_html/multi_dec/app/addons/ec_multi_store_timezone/func.php:31
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00034 Re-run Backtrace
8
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /home/vishalecarter/public_html/multi_dec/index.php:18
  • fn_init() /home/vishalecarter/public_html/multi_dec/init.php:194
  • fn_init_templater() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:1196
  • Tygh\Development::isEnabled() /home/vishalecarter/public_html/multi_dec/app/functions/fn.init.php:86
  • Tygh\Development::read() /home/vishalecarter/public_html/multi_dec/app/Tygh/Development.php:28
  • fn_get_storage_data() /home/vishalecarter/public_html/multi_dec/app/Tygh/Development.php:81
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:1085
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00047 Re-run Backtrace
9
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Settings::instance() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Settings::normalizeInstanceParameters() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:163
  • Tygh\Storefront\Repository::getCount() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:243
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:435
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00039 Re-run Backtrace
10
SELECT cscart_multi_decsettings_sections.name, cscart_multi_decsettings_sections.section_id, cscart_multi_decsettings_sections.position, cscart_multi_decsettings_sections.type , cscart_multi_decsettings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_multi_decsettings_sections.name) as href  FROM cscart_multi_decsettings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_sections.edition_type)) ORDER BY cscart_multi_decsettings_sections.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Settings::instance() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Settings::reloadSections() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:172
  • Tygh\Settings::getSections() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:141
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:487
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00041 Re-run Backtrace
11
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'color_schema'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:117
  • Tygh\Settings::getId() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:871
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:968
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00021 Re-run Backtrace
12
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5961 ORDER BY cscart_multi_decsettings_objects.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:117
  • Tygh\Settings::getPlainList() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:874
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00020 Re-run Backtrace
13
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'sidebar_color'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::getColorSchemas() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:118
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:426
  • Tygh\Settings::getId() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:871
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:968
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00014 Re-run Backtrace
14
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5962 ORDER BY cscart_multi_decsettings_objects.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::getColorSchemas() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:118
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:426
  • Tygh\Settings::getPlainList() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:874
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00016 Re-run Backtrace
15
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'element_color'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::getColorSchemas() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:118
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:427
  • Tygh\Settings::getId() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:871
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:968
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00014 Re-run Backtrace
16
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5963 ORDER BY cscart_multi_decsettings_objects.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::getColorSchemas() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:118
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:427
  • Tygh\Settings::getPlainList() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:874
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00014 Re-run Backtrace
17
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'sidebar_background_image'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:126
  • Tygh\Settings::getId() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:871
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:968
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00014 Re-run Backtrace
18
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5964 ORDER BY cscart_multi_decsettings_objects.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • Tygh\Settings::getValue() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:126
  • Tygh\Settings::getPlainList() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:874
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00014 Re-run Backtrace
19
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '0' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '0' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:141
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00040 Re-run Backtrace
20
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '1' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '1' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:146
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00028 Re-run Backtrace
21
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '2' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '2' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:441
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorPanelConfigurator\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::getSettingsService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/HookHandlers/DispatchHookHandler.php:36
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:80
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorPanelConfigurator\ServiceProvider::Tygh\Addons\VendorPanelConfigurator\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorPanelConfigurator\SettingsService::__construct() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/ServiceProvider.php:70
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_panel_configurator/src/SettingsService.php:151
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00028 Re-run Backtrace
22
SELECT * FROM cscart_multi_decbm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::instance() /home/vishalecarter/public_html/multi_dec/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:483
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00037 Re-run Backtrace
23
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.dispatch IN ('call_requests.request')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::get() /home/vishalecarter/public_html/multi_dec/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:166
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00028 Re-run Backtrace
24
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.dispatch IN ('call_requests')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::get() /home/vishalecarter/public_html/multi_dec/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:166
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00018 Re-run Backtrace
25
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.is_default = 1  ORDER BY l.is_default desc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::get() /home/vishalecarter/public_html/multi_dec/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getDefault() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:184
  • Tygh\BlockManager\Location::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:225
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00019 Re-run Backtrace
26
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_storage_data() /home/vishalecarter/public_html/multi_dec/app/controllers/frontend/init.php:146
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:1085
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00015 Re-run Backtrace
27
SELECT * FROM cscart_multi_dechybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_hybrid_auth_get_providers_list() /home/vishalecarter/public_html/multi_dec/app/addons/hybrid_auth/controllers/frontend/init.post.php:17
  • Tygh\Registry::getOrSetCache() /home/vishalecarter/public_html/multi_dec/app/addons/hybrid_auth/func.php:234
  • {closure}() /home/vishalecarter/public_html/multi_dec/app/Tygh/Registry.php:800
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00012 Re-run Backtrace
28
SELECT category_id FROM cscart_multi_decproducts_categories WHERE product_id = 220 AND link_type = 'M'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:260
  • fn_bestsellers_get_product_data() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • db_get_field() /home/vishalecarter/public_html/multi_dec/app/addons/bestsellers/func.php:255
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00019 Re-run Backtrace
29
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:260
  • fn_seo_get_product_data() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • fn_get_corrected_seo_lang_code() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:2349
  • fn_seo_get_default_storefront_lang_code() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:449
  • Tygh\Storefront\Repository::findDefault() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:468
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:188
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00015 Re-run Backtrace
30
SELECT cscart_multi_decproducts.*, cscart_multi_decproduct_descriptions.*, MIN(IF(cscart_multi_decproduct_prices.percentage_discount = 0, cscart_multi_decproduct_prices.price, cscart_multi_decproduct_prices.price - (cscart_multi_decproduct_prices.price * cscart_multi_decproduct_prices.percentage_discount)/100)) as price, GROUP_CONCAT( CASE   WHEN (cscart_multi_decproducts_categories.link_type = 'M') THEN CONCAT(cscart_multi_decproducts_categories.category_id, 'M')   ELSE cscart_multi_decproducts_categories.category_id END ORDER BY cscart_multi_deccategories.storefront_id IN (0, 1) DESC, (cscart_multi_decproducts_categories.link_type = 'M') DESC, cscart_multi_decproducts_categories.category_position ASC, cscart_multi_decproducts_categories.category_id ASC) as category_ids, popularity.total as popularity, companies.company as company_name, cscart_multi_decproducts.is_returnable, cscart_multi_decproducts.return_period, cscart_multi_decproduct_sales.amount as sales_amount, cscart_multi_decseo_names.name as seo_name, cscart_multi_decseo_names.path as seo_path, MIN(point_prices.point_price) as point_price, cscart_multi_decdiscussion.type as discussion_type, cscart_multi_decproduct_review_prepared_data.average_rating average_rating, cscart_multi_decproduct_review_prepared_data.reviews_count product_reviews_count FROM cscart_multi_decproducts LEFT JOIN cscart_multi_decproduct_prices ON cscart_multi_decproduct_prices.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_prices.lower_limit = 1  AND cscart_multi_decproduct_prices.usergroup_id IN (0, 0, 1)  LEFT JOIN cscart_multi_decproduct_descriptions ON cscart_multi_decproduct_descriptions.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_descriptions.lang_code = 'en' LEFT JOIN cscart_multi_deccompanies as companies ON companies.company_id = cscart_multi_decproducts.company_id INNER JOIN cscart_multi_decproducts_categories ON cscart_multi_decproducts_categories.product_id = cscart_multi_decproducts.product_id INNER JOIN cscart_multi_deccategories ON cscart_multi_deccategories.category_id = cscart_multi_decproducts_categories.category_id  AND cscart_multi_deccategories.storefront_id IN (0, 1) AND (cscart_multi_deccategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_deccategories.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_deccategories.usergroup_ids)) AND (cscart_multi_decproducts.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_decproducts.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_decproducts.usergroup_ids)) AND cscart_multi_deccategories.status IN ('A', 'H') AND cscart_multi_decproducts.status IN ('A', 'H') LEFT JOIN cscart_multi_decproduct_popularity as popularity ON popularity.product_id = cscart_multi_decproducts.product_id LEFT JOIN cscart_multi_decproduct_sales ON cscart_multi_decproduct_sales.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_sales.category_id = 169 LEFT JOIN cscart_multi_decseo_names ON cscart_multi_decseo_names.object_id = 220 AND cscart_multi_decseo_names.type = 'p' AND cscart_multi_decseo_names.dispatch = '' AND cscart_multi_decseo_names.lang_code = 'en'  LEFT JOIN cscart_multi_decproduct_point_prices as point_prices ON point_prices.product_id = cscart_multi_decproducts.product_id AND point_prices.lower_limit = 1 AND point_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_multi_decdiscussion ON cscart_multi_decdiscussion.object_id = cscart_multi_decproducts.product_id AND cscart_multi_decdiscussion.object_type = 'P' LEFT JOIN cscart_multi_decproduct_review_prepared_data ON cscart_multi_decproduct_review_prepared_data.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_review_prepared_data.storefront_id = 0 WHERE cscart_multi_decproducts.product_id = 220  AND (companies.status IN ('A') OR cscart_multi_decproducts.company_id = 0) GROUP BY cscart_multi_decproducts.product_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:263
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00112 Re-run Backtrace
31
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'A' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'A' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:338
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00056 Re-run Backtrace
32
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:343
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00034 Re-run Backtrace
33
SELECT id_path FROM cscart_multi_deccategories WHERE category_id IN (169)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_category_ids_with_parent() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:360
  • db_get_fields() /home/vishalecarter/public_html/multi_dec/app/functions/fn.categories.php:2182
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:480
0.00013 Re-run Backtrace
34
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_multi_decproduct_features_descriptions.description, cscart_multi_decproduct_features_descriptions.internal_name, cscart_multi_decproduct_features_descriptions.lang_code, cscart_multi_decproduct_features_descriptions.prefix, cscart_multi_decproduct_features_descriptions.suffix, pf.categories_path, cscart_multi_decproduct_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_groups.position AS group_position, cscart_multi_decproduct_features_values.value, cscart_multi_decproduct_features_values.variant_id, cscart_multi_decproduct_features_values.value_int FROM cscart_multi_decproduct_features AS pf  LEFT JOIN cscart_multi_decproduct_features AS pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN cscart_multi_decproduct_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_features_descriptions ON cscart_multi_decproduct_features_descriptions.feature_id = pf.feature_id AND cscart_multi_decproduct_features_descriptions.lang_code = 'en' INNER JOIN cscart_multi_decproduct_features_values ON cscart_multi_decproduct_features_values.feature_id = pf.feature_id AND cscart_multi_decproduct_features_values.product_id = 220 AND cscart_multi_decproduct_features_values.lang_code = 'en' WHERE 1=1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.company_id IN (0, 1) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(167, pf.categories_path) OR FIND_IN_SET(169, pf.categories_path) )  GROUP BY pf.feature_id  ORDER BY group_position asc, pf_groups_description.description asc, pf_groups.feature_id asc, pf.position asc, cscart_multi_decproduct_features_descriptions.description asc, pf.feature_id asc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:373
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:541
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00074 Re-run Backtrace
35
SELECT cscart_multi_decproduct_feature_variant_descriptions.variant, cscart_multi_decproduct_feature_variants.variant_id, cscart_multi_decproduct_feature_variants.feature_id, cscart_multi_decproduct_features_values.variant_id as selected, cscart_multi_decproduct_features.feature_type, cscart_multi_decseo_names.name as seo_name, cscart_multi_decseo_names.path as seo_path FROM cscart_multi_decproduct_feature_variants  LEFT JOIN cscart_multi_decproduct_feature_variant_descriptions ON cscart_multi_decproduct_feature_variant_descriptions.variant_id = cscart_multi_decproduct_feature_variants.variant_id AND cscart_multi_decproduct_feature_variant_descriptions.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_features_values ON cscart_multi_decproduct_features_values.variant_id = cscart_multi_decproduct_feature_variants.variant_id AND cscart_multi_decproduct_features_values.lang_code = 'en' AND cscart_multi_decproduct_features_values.product_id = 220 AND cscart_multi_decproduct_features_values.feature_id = cscart_multi_decproduct_feature_variants.feature_id LEFT JOIN cscart_multi_decproduct_features ON cscart_multi_decproduct_features.feature_id = cscart_multi_decproduct_feature_variants.feature_id LEFT JOIN cscart_multi_decseo_names ON cscart_multi_decseo_names.object_id = cscart_multi_decproduct_feature_variants.variant_id AND cscart_multi_decseo_names.type = 'e' AND cscart_multi_decseo_names.dispatch = '' AND cscart_multi_decseo_names.lang_code = 'en'  WHERE 1  AND cscart_multi_decproduct_feature_variants.feature_id IN (15, 16, 17)  GROUP BY cscart_multi_decproduct_feature_variants.variant_id ORDER BY cscart_multi_decproduct_feature_variants.position, cscart_multi_decproduct_feature_variant_descriptions.variant 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:373
  • fn_get_product_feature_variants() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:625
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:1249
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00070 Re-run Backtrace
36
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (63, 61, 59, 45, 47, 77, 51, 64, 79, 41, 81, 83, 80, 65, 71, 50, 54, 67, 68, 74, 70, 75, 48, 82, 60, 56, 62, 53, 72, 44, 84, 55, 66, 52, 58, 73, 76, 78, 49, 46, 69, 39) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (63, 61, 59, 45, 47, 77, 51, 64, 79, 41, 81, 83, 80, 65, 71, 50, 54, 67, 68, 74, 70, 75, 48, 82, 60, 56, 62, 53, 72, 44, 84, 55, 66, 52, 58, 73, 76, 78, 49, 46, 69, 39) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:373
  • fn_get_product_feature_variants() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:625
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:1253
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00127 Re-run Backtrace
37
SELECT feature_id FROM cscart_multi_decproduct_features WHERE feature_id IN (15, 16, 17) AND feature_type = 'E'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:373
  • fn_get_product_feature_variants() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:625
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:1268
  • fn_seo_get_product_feature_variants_post() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • db_get_fields() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:2959
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:480
0.00018 Re-run Backtrace
38
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_multi_decproduct_features_descriptions.description, cscart_multi_decproduct_features_descriptions.internal_name, cscart_multi_decproduct_features_descriptions.lang_code, cscart_multi_decproduct_features_descriptions.prefix, cscart_multi_decproduct_features_descriptions.suffix, pf.categories_path, cscart_multi_decproduct_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp FROM cscart_multi_decproduct_features AS pf LEFT JOIN cscart_multi_decproduct_features_descriptions ON cscart_multi_decproduct_features_descriptions.feature_id = pf.feature_id AND cscart_multi_decproduct_features_descriptions.lang_code = 'en' WHERE pf.feature_type = 'G' AND (pf.feature_id IN (14) OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_multi_decproduct_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(167, pf.categories_path) OR FIND_IN_SET(169, pf.categories_path) ) ORDER BY pf.position, cscart_multi_decproduct_features_descriptions.description

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:373
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:656
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00044 Re-run Backtrace
39
SELECT v.feature_id,
        v.value,
        v.value_int,
        v.variant_id,
        f.feature_type,
        fd.internal_name,
        fd.description,
        fd.prefix,
        fd.suffix,
        vd.variant,
        f.parent_id,
        f.position,
        gf.position as gposition,
        f.display_on_header,
        f.display_on_catalog,
        f.display_on_product,
        f.feature_code,
        f.purpose FROM cscart_multi_decproduct_features as f LEFT JOIN cscart_multi_decproduct_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_multi_decproduct_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_multi_decproduct_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G'  WHERE f.status IN ('A') AND v.product_id = 220  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(167, f.categories_path) OR FIND_IN_SET(169, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_multi_decproduct_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.internal_name, fv.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features_list() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:376
  • db_get_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:955
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00041 Re-run Backtrace
40
SELECT filter_id, feature_id FROM cscart_multi_decproduct_filters WHERE status = 'A'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features_list() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:376
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:970
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00010 Re-run Backtrace
41
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (89) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (89) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_get_product_features_list() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:376
  • fn_get_image_pairs() /home/vishalecarter/public_html/multi_dec/app/functions/fn.features.php:1005
  • db_multi_query() /home/vishalecarter/public_html/multi_dec/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:168
0.00035 Re-run Backtrace
42
SELECT cscart_multi_decstatuses.*, cscart_multi_decstatus_descriptions.* FROM cscart_multi_decstatuses  LEFT JOIN cscart_multi_decstatus_descriptions ON cscart_multi_decstatus_descriptions.status_id = cscart_multi_decstatuses.status_id AND cscart_multi_decstatus_descriptions.lang_code = 'en' WHERE 1 = 1  AND cscart_multi_decstatuses.type = 'O'  ORDER BY cscart_multi_decstatuses.position asc

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorRating\HookHandlers\ProductsHookHandler::afterGetProduct()
  • Tygh\Addons\VendorRating\ServiceProvider::getVendorService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/HookHandlers/ProductsHookHandler.php:118
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:61
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getCriteriaSchema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:143
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:196
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getActiveVariables() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:96
  • fn_get_schema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:206
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:2500
  • fn_get_statuses() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/schemas/vendor_rating/criteria.php:20
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:4463
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00023 Re-run Backtrace
43
SELECT status_id, status FROM cscart_multi_decstatuses WHERE type = 'O'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorRating\HookHandlers\ProductsHookHandler::afterGetProduct()
  • Tygh\Addons\VendorRating\ServiceProvider::getVendorService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/HookHandlers/ProductsHookHandler.php:118
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:61
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getCriteriaSchema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:143
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:196
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getActiveVariables() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:96
  • fn_get_schema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:206
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:2500
  • fn_get_statuses() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/schemas/vendor_rating/criteria.php:20
  • fn_get_statuses_by_type() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:4475
  • db_get_hash_single_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:8068
  • Tygh\Database\Connection::getSingleHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:572
0.00010 Re-run Backtrace
44
SELECT status_id, param, value FROM cscart_multi_decstatus_data WHERE status_id IN (1, 2, 3, 4, 5, 6, 7, 19)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorRating\HookHandlers\ProductsHookHandler::afterGetProduct()
  • Tygh\Addons\VendorRating\ServiceProvider::getVendorService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/HookHandlers/ProductsHookHandler.php:118
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:61
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getCriteriaSchema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:143
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:196
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getActiveVariables() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:96
  • fn_get_schema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:206
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:2500
  • fn_get_statuses() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/schemas/vendor_rating/criteria.php:20
  • db_get_hash_multi_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:4475
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:526
0.00023 Re-run Backtrace
45
SELECT cscart_multi_decstatuses.status FROM cscart_multi_decstatuses INNER JOIN cscart_multi_decstatus_data ON cscart_multi_decstatus_data.status_id = cscart_multi_decstatuses.status_id WHERE type = 'O' AND (param, value) IN (('payment_received', 'Y'))

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorRating\HookHandlers\ProductsHookHandler::afterGetProduct()
  • Tygh\Addons\VendorRating\ServiceProvider::getVendorService() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/HookHandlers/ProductsHookHandler.php:118
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:61
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getCriteriaSchema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:143
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:196
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/multi_dec/app/Tygh/Application.php:135
  • Tygh\Addons\VendorRating\ServiceProvider::Tygh\Addons\VendorRating\{closure}() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Addons\VendorRating\ServiceProvider::getActiveVariables() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:96
  • fn_get_schema() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/ServiceProvider.php:206
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:2500
  • fn_get_settled_order_statuses() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/schemas/vendor_rating/criteria.php:21
  • fn_get_status_by_type_and_param() /home/vishalecarter/public_html/multi_dec/app/functions/fn.cart.php:11740
  • db_get_fields() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:9123
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:480
0.00016 Re-run Backtrace
46
SELECT rating FROM cscart_multi_decabsolute_rating WHERE `object_id` = 1 AND `object_type` = 'company'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorRating\HookHandlers\ProductsHookHandler::afterGetProduct()
  • Tygh\Addons\VendorRating\Service\VendorService::getRelativeRating() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/HookHandlers/ProductsHookHandler.php:119
  • Tygh\Addons\VendorRating\Service\VendorService::getAbsouluteRating() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/Service/VendorService.php:166
  • Tygh\Addons\VendorRating\Rating\Storage::getAbsoluteRating() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/Service/VendorService.php:141
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/Rating/Storage.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00008 Re-run Backtrace
47
SELECT MAX(rating) FROM cscart_multi_decabsolute_rating WHERE `object_type` = 'company'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\VendorRating\HookHandlers\ProductsHookHandler::afterGetProduct()
  • Tygh\Addons\VendorRating\Service\VendorService::getRelativeRating() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/HookHandlers/ProductsHookHandler.php:119
  • Tygh\Addons\VendorRating\Service\VendorService::getMaxAbsoluteRating() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/Service/VendorService.php:167
  • Tygh\Addons\VendorRating\Rating\Storage::getMaxAbsoluteRating() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/Service/VendorService.php:262
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/addons/vendor_rating/src/Rating/Storage.php:128
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00009 Re-run Backtrace
48
SELECT company_id FROM cscart_multi_decstorefronts_companies WHERE storefront_id = 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • fn_required_products_get_product_data_post() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • fn_get_products() /home/vishalecarter/public_html/multi_dec/app/addons/required_products/func.php:36
  • Tygh\Storefront\Storefront::__call() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:2021
  • Tygh\Storefront\Storefront::getRelationValue() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/Storefront.php:273
  • Tygh\Storefront\RelationsManager::getRelatedValues() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/multi_dec/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:480
0.00009 Re-run Backtrace
49
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_id FROM cscart_multi_decproducts as products  LEFT JOIN cscart_multi_decproduct_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_multi_decproduct_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_multi_deccompanies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_multi_decproducts_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_multi_deccategories ON cscart_multi_deccategories.category_id = products_categories.category_id  AND (cscart_multi_deccategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_deccategories.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_deccategories.usergroup_ids)) AND cscart_multi_deccategories.status IN ('A', 'H') AND cscart_multi_deccategories.storefront_id IN (0, 1)  LEFT JOIN cscart_multi_decproduct_required_products ON products.product_id = cscart_multi_decproduct_required_products.required_id WHERE 1  AND companies.status IN ('A') 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 cscart_multi_decproduct_required_products.product_id = 220 AND products.product_type != 'D' GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:729
  • fn_get_product_data() /home/vishalecarter/public_html/multi_dec/app/addons/call_requests/controllers/frontend/call_requests.php:52
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:397
  • fn_required_products_get_product_data_post() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • fn_get_products() /home/vishalecarter/public_html/multi_dec/app/addons/required_products/func.php:36
  • {closure}() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:2466
  • db_get_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.products.php:2383
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00040 Re-run Backtrace
50
SELECT privilege FROM cscart_multi_decusergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • fn_check_permissions() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:519
  • fn_check_admin_permissions() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:2573
  • db_get_fields() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:2755
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:480
0.00011 Re-run Backtrace
51
SELECT c.* FROM cscart_multi_decbm_containers as c  WHERE 1  AND c.location_id = 1 AND c.company_id = 0

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:130
  • Tygh\BlockManager\Container::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00048 Re-run Backtrace
52
SELECT layout_id FROM cscart_multi_decbm_locations WHERE location_id = 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:130
  • Tygh\BlockManager\Container::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:448
0.00015 Re-run Backtrace
53
SELECT c.*, IF (c.location_id != 1, 0, 1) as `default` FROM cscart_multi_decbm_containers as c  INNER JOIN cscart_multi_decbm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:130
  • Tygh\BlockManager\Container::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00026 Re-run Backtrace
54
SELECT * FROM cscart_multi_decbm_containers as c LEFT JOIN cscart_multi_decbm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 3, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Grid::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:134
  • db_get_hash_multi_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Grid.php:63
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:526
0.00042 Re-run Backtrace
55
SELECT cscart_multi_decbm_snapping.grid_id as grid_id,cscart_multi_decbm_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_multi_decbm_block_statuses.object_ids as object_ids,cscart_multi_decbm_snapping.*,cscart_multi_decbm_blocks.*,cscart_multi_decbm_blocks_descriptions.* FROM cscart_multi_decbm_snapping LEFT JOIN cscart_multi_decbm_blocks ON cscart_multi_decbm_blocks.block_id = cscart_multi_decbm_snapping.block_id LEFT JOIN cscart_multi_decbm_block_statuses ON cscart_multi_decbm_snapping.snapping_id = cscart_multi_decbm_block_statuses.snapping_id AND cscart_multi_decbm_block_statuses.object_type LIKE '' LEFT JOIN cscart_multi_decbm_blocks_descriptions ON cscart_multi_decbm_blocks.block_id = cscart_multi_decbm_blocks_descriptions.block_id  LEFT JOIN cscart_multi_decbm_blocks_content AS default_content ON cscart_multi_decbm_blocks.block_id = default_content.block_id AND cscart_multi_decbm_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_multi_decbm_blocks_content AS dynamic_object_content ON cscart_multi_decbm_blocks.block_id = dynamic_object_content.block_id AND cscart_multi_decbm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_multi_decbm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22)  AND cscart_multi_decbm_blocks_descriptions.lang_code='en'  ORDER BY cscart_multi_decbm_snapping.order, cscart_multi_decbm_snapping.block_id 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Block::getList() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:138
  • db_get_hash_multi_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/Block.php:271
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:526
0.00163 Re-run Backtrace
56
SELECT * FROM cscart_multi_dechybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\BlockManager\RenderManager::getValue() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:837
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /home/vishalecarter/public_html/multi_dec/app/addons/hybrid_auth/func.php:255
  • Tygh\Registry::getOrSetCache() /home/vishalecarter/public_html/multi_dec/app/addons/hybrid_auth/func.php:234
  • {closure}() /home/vishalecarter/public_html/multi_dec/app/Tygh/Registry.php:800
  • db_get_hash_array() /home/vishalecarter/public_html/multi_dec/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:371
0.00040 Re-run Backtrace
57
SELECT a.code, b.country FROM cscart_multi_deccountries as a LEFT JOIN cscart_multi_deccountry_descriptions as b ON b.code = a.code AND b.lang_code = 'en' WHERE 1 AND a.status = 'A' ORDER BY b.country

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\BlockManager\RenderManager::_renderMainContent() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:640
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:803
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_6943d1cd856970_66202142() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Smarty\Template::renderSubTemplate() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/f65cdf74c1fb2e04376edd0f300c1c3a084938c5_2.tygh_request.tpl.php:60
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:287
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_6943d1cd8ac558_69563041() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Smarty\Template::renderSubTemplate() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c957adc95f10df453807a561f54960d88311d754_2.tygh_call_requests_content.tpl.php:195
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:287
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_6943aa326fd279_16162103() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Smarty\Extension\CallbackWrapper::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/56d97245806fd8c2ccb281d6bd94d4e05db866a9_2.tygh_phone.tpl.php:230
  • fn_get_simple_phone_country_codes() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Extension/CallbackWrapper.php:29
  • db_get_array() /home/vishalecarter/public_html/multi_dec/app/functions/fn.locations.php:165
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:333
0.00129 Re-run Backtrace
58
SELECT name, path FROM cscart_multi_decseo_names WHERE `object_id` = 15 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:370
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439ac01b2e77_43365790() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\SafeEvalString::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/6a8aef2d57e65b7da36f453b4d4e1eee074aa71f_2.tygh_safe_smarty_block.tpl.php:46
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/SafeEvalString.php:41
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439ac0216754_58255486() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Smarty\Extension\CallbackWrapper::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/f91e61c8f98f5fefd384d0105bad6dc682344720_2.string_.php:27
  • fn_url() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Extension/CallbackWrapper.php:29
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:3983
  • fn_seo_url_post() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • fn_seo_get_name() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:1645
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:1375
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00054 Re-run Backtrace
59
SELECT name, path FROM cscart_multi_decseo_names WHERE `object_id` = 20 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/multi_dec/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439abddd9740_52357401() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/c017644d9348255f84933f1a385f1a490bdeaeac_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:370
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439ac01b2e77_43365790() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\SafeEvalString::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/6a8aef2d57e65b7da36f453b4d4e1eee074aa71f_2.tygh_safe_smarty_block.tpl.php:46
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Functions/SafeEvalString.php:41
  • Smarty\Template::fetch() /home/vishalecarter/public_html/multi_dec/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69439ac026d377_24512071() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Smarty\Extension\CallbackWrapper::handle() /home/vishalecarter/public_html/multi_dec/var/cache/templates/nova_theme/9791d6ef2177b7f8d8d0e526b47a7981e406a0e3_2.string_.php:39
  • fn_url() /home/vishalecarter/public_html/multi_dec/app/lib/vendor/smarty/smarty/src/Extension/CallbackWrapper.php:29
  • fn_set_hook() /home/vishalecarter/public_html/multi_dec/app/functions/fn.common.php:3983
  • fn_seo_url_post() /home/vishalecarter/public_html/multi_dec/app/functions/fn.control.php:124
  • fn_seo_get_name() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:1645
  • db_get_row() /home/vishalecarter/public_html/multi_dec/app/addons/seo/func.php:1375
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/multi_dec/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/multi_dec/app/Tygh/Database/Connection.php:414
0.00034 Re-run Backtrace
60
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'restrictions'

    Backtrace

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

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
SELECT * FROM cscart_multi_dechybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position
2 0.00012 0.00040 0.00026
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'store_mode'
1 0.00025 0.00025 0.00025
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'vishal.ecarter.co' OR storefronts.url = 'www.vishal.ecarter.co' OR storefronts.url LIKE 'www_.vishal.ecarter.co' OR storefronts.url LIKE 'vishal.ecarter.co/%' OR storefronts.url LIKE 'www.vishal.ecarter.co/%' OR storefronts.url LIKE 'www_.vishal.ecarter.co/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'vishal.ecarter.co' DESC, storefronts.url = 'www.vishal.ecarter.co' DESC, storefronts.url LIKE 'www_.vishal.ecarter.co' DESC, storefronts.url LIKE 'vishal.ecarter.co/%' DESC, storefronts.url LIKE 'www.vishal.ecarter.co/%' DESC, storefronts.url LIKE 'www_.vishal.ecarter.co/%' desc 
1 0.00023 0.00023 0.00023
SET time_zone = '+08:00'
1 0.00007 0.00007 0.00007
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00046 0.00046 0.00046
SELECT cscart_multi_decbm_layouts.* FROM cscart_multi_decbm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1
1 0.00023 0.00023 0.00023
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'cart_products_next_check'
1 0.00028 0.00028 0.00028
SELECT ec_timezone FROM cscart_multi_decstorefronts WHERE storefront_id = 1
1 0.00034 0.00034 0.00034
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'dev_mode'
1 0.00047 0.00047 0.00047
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1
1 0.00039 0.00039 0.00039
SELECT cscart_multi_decsettings_sections.name, cscart_multi_decsettings_sections.section_id, cscart_multi_decsettings_sections.position, cscart_multi_decsettings_sections.type , cscart_multi_decsettings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_multi_decsettings_sections.name) as href  FROM cscart_multi_decsettings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_sections.edition_type)) ORDER BY cscart_multi_decsettings_sections.position
1 0.00041 0.00041 0.00041
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'color_schema'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
1 0.00021 0.00021 0.00021
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5961 ORDER BY cscart_multi_decsettings_objects.position
1 0.00020 0.00020 0.00020
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'sidebar_color'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
1 0.00014 0.00014 0.00014
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5962 ORDER BY cscart_multi_decsettings_objects.position
1 0.00016 0.00016 0.00016
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'element_color'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
1 0.00014 0.00014 0.00014
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5963 ORDER BY cscart_multi_decsettings_objects.position
1 0.00014 0.00014 0.00014
SELECT object_id FROM cscart_multi_decsettings_objects LEFT JOIN cscart_multi_decsettings_sections ON cscart_multi_decsettings_objects.section_id = cscart_multi_decsettings_sections.section_id WHERE cscart_multi_decsettings_objects.name = 'sidebar_background_image'  AND cscart_multi_decsettings_sections.name = 'vendor_panel_configurator'
1 0.00014 0.00014 0.00014
SELECT cscart_multi_decsettings_objects.object_id as object_id, cscart_multi_decsettings_objects.type as object_type, cscart_multi_decsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_multi_decsettings_objects.value END) AS value FROM cscart_multi_decsettings_objects  LEFT JOIN cscart_multi_decsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_multi_decsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_multi_decsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_multi_decsettings_objects.edition_type)) AND cscart_multi_decsettings_objects.object_id = 5964 ORDER BY cscart_multi_decsettings_objects.position
1 0.00014 0.00014 0.00014
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '0' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '0' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00040 0.00040 0.00040
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '1' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '1' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00028 0.00028 0.00028
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '2' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'vendor_panel' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '2' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00028 0.00028 0.00028
SELECT * FROM cscart_multi_decbm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1
1 0.00037 0.00037 0.00037
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.dispatch IN ('call_requests.request')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00028 0.00028 0.00028
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.dispatch IN ('call_requests')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00018 0.00018 0.00018
SELECT * FROM cscart_multi_decbm_locations as l LEFT JOIN cscart_multi_decbm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.is_default = 1  ORDER BY l.is_default desc 
1 0.00019 0.00019 0.00019
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'cache_id'
1 0.00015 0.00015 0.00015
SELECT category_id FROM cscart_multi_decproducts_categories WHERE product_id = 220 AND link_type = 'M'
1 0.00019 0.00019 0.00019
SELECT storefronts.* FROM cscart_multi_decstorefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00015 0.00015 0.00015
SELECT cscart_multi_decproducts.*, cscart_multi_decproduct_descriptions.*, MIN(IF(cscart_multi_decproduct_prices.percentage_discount = 0, cscart_multi_decproduct_prices.price, cscart_multi_decproduct_prices.price - (cscart_multi_decproduct_prices.price * cscart_multi_decproduct_prices.percentage_discount)/100)) as price, GROUP_CONCAT( CASE   WHEN (cscart_multi_decproducts_categories.link_type = 'M') THEN CONCAT(cscart_multi_decproducts_categories.category_id, 'M')   ELSE cscart_multi_decproducts_categories.category_id END ORDER BY cscart_multi_deccategories.storefront_id IN (0, 1) DESC, (cscart_multi_decproducts_categories.link_type = 'M') DESC, cscart_multi_decproducts_categories.category_position ASC, cscart_multi_decproducts_categories.category_id ASC) as category_ids, popularity.total as popularity, companies.company as company_name, cscart_multi_decproducts.is_returnable, cscart_multi_decproducts.return_period, cscart_multi_decproduct_sales.amount as sales_amount, cscart_multi_decseo_names.name as seo_name, cscart_multi_decseo_names.path as seo_path, MIN(point_prices.point_price) as point_price, cscart_multi_decdiscussion.type as discussion_type, cscart_multi_decproduct_review_prepared_data.average_rating average_rating, cscart_multi_decproduct_review_prepared_data.reviews_count product_reviews_count FROM cscart_multi_decproducts LEFT JOIN cscart_multi_decproduct_prices ON cscart_multi_decproduct_prices.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_prices.lower_limit = 1  AND cscart_multi_decproduct_prices.usergroup_id IN (0, 0, 1)  LEFT JOIN cscart_multi_decproduct_descriptions ON cscart_multi_decproduct_descriptions.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_descriptions.lang_code = 'en' LEFT JOIN cscart_multi_deccompanies as companies ON companies.company_id = cscart_multi_decproducts.company_id INNER JOIN cscart_multi_decproducts_categories ON cscart_multi_decproducts_categories.product_id = cscart_multi_decproducts.product_id INNER JOIN cscart_multi_deccategories ON cscart_multi_deccategories.category_id = cscart_multi_decproducts_categories.category_id  AND cscart_multi_deccategories.storefront_id IN (0, 1) AND (cscart_multi_deccategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_deccategories.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_deccategories.usergroup_ids)) AND (cscart_multi_decproducts.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_decproducts.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_decproducts.usergroup_ids)) AND cscart_multi_deccategories.status IN ('A', 'H') AND cscart_multi_decproducts.status IN ('A', 'H') LEFT JOIN cscart_multi_decproduct_popularity as popularity ON popularity.product_id = cscart_multi_decproducts.product_id LEFT JOIN cscart_multi_decproduct_sales ON cscart_multi_decproduct_sales.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_sales.category_id = 169 LEFT JOIN cscart_multi_decseo_names ON cscart_multi_decseo_names.object_id = 220 AND cscart_multi_decseo_names.type = 'p' AND cscart_multi_decseo_names.dispatch = '' AND cscart_multi_decseo_names.lang_code = 'en'  LEFT JOIN cscart_multi_decproduct_point_prices as point_prices ON point_prices.product_id = cscart_multi_decproducts.product_id AND point_prices.lower_limit = 1 AND point_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_multi_decdiscussion ON cscart_multi_decdiscussion.object_id = cscart_multi_decproducts.product_id AND cscart_multi_decdiscussion.object_type = 'P' LEFT JOIN cscart_multi_decproduct_review_prepared_data ON cscart_multi_decproduct_review_prepared_data.product_id = cscart_multi_decproducts.product_id AND cscart_multi_decproduct_review_prepared_data.storefront_id = 0 WHERE cscart_multi_decproducts.product_id = 220  AND (companies.status IN ('A') OR cscart_multi_decproducts.company_id = 0) GROUP BY cscart_multi_decproducts.product_id
1 0.00112 0.00112 0.00112
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'A' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'A' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00056 0.00056 0.00056
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'product' AND cscart_multi_decimages_links.type = 'M' AND cscart_multi_decimages_links.object_id = '220' ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00034 0.00034 0.00034
SELECT id_path FROM cscart_multi_deccategories WHERE category_id IN (169)
1 0.00013 0.00013 0.00013
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_multi_decproduct_features_descriptions.description, cscart_multi_decproduct_features_descriptions.internal_name, cscart_multi_decproduct_features_descriptions.lang_code, cscart_multi_decproduct_features_descriptions.prefix, cscart_multi_decproduct_features_descriptions.suffix, pf.categories_path, cscart_multi_decproduct_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_groups.position AS group_position, cscart_multi_decproduct_features_values.value, cscart_multi_decproduct_features_values.variant_id, cscart_multi_decproduct_features_values.value_int FROM cscart_multi_decproduct_features AS pf  LEFT JOIN cscart_multi_decproduct_features AS pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN cscart_multi_decproduct_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_features_descriptions ON cscart_multi_decproduct_features_descriptions.feature_id = pf.feature_id AND cscart_multi_decproduct_features_descriptions.lang_code = 'en' INNER JOIN cscart_multi_decproduct_features_values ON cscart_multi_decproduct_features_values.feature_id = pf.feature_id AND cscart_multi_decproduct_features_values.product_id = 220 AND cscart_multi_decproduct_features_values.lang_code = 'en' WHERE 1=1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.company_id IN (0, 1) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(167, pf.categories_path) OR FIND_IN_SET(169, pf.categories_path) )  GROUP BY pf.feature_id  ORDER BY group_position asc, pf_groups_description.description asc, pf_groups.feature_id asc, pf.position asc, cscart_multi_decproduct_features_descriptions.description asc, pf.feature_id asc 
1 0.00074 0.00074 0.00074
SELECT cscart_multi_decproduct_feature_variant_descriptions.variant, cscart_multi_decproduct_feature_variants.variant_id, cscart_multi_decproduct_feature_variants.feature_id, cscart_multi_decproduct_features_values.variant_id as selected, cscart_multi_decproduct_features.feature_type, cscart_multi_decseo_names.name as seo_name, cscart_multi_decseo_names.path as seo_path FROM cscart_multi_decproduct_feature_variants  LEFT JOIN cscart_multi_decproduct_feature_variant_descriptions ON cscart_multi_decproduct_feature_variant_descriptions.variant_id = cscart_multi_decproduct_feature_variants.variant_id AND cscart_multi_decproduct_feature_variant_descriptions.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_features_values ON cscart_multi_decproduct_features_values.variant_id = cscart_multi_decproduct_feature_variants.variant_id AND cscart_multi_decproduct_features_values.lang_code = 'en' AND cscart_multi_decproduct_features_values.product_id = 220 AND cscart_multi_decproduct_features_values.feature_id = cscart_multi_decproduct_feature_variants.feature_id LEFT JOIN cscart_multi_decproduct_features ON cscart_multi_decproduct_features.feature_id = cscart_multi_decproduct_feature_variants.feature_id LEFT JOIN cscart_multi_decseo_names ON cscart_multi_decseo_names.object_id = cscart_multi_decproduct_feature_variants.variant_id AND cscart_multi_decseo_names.type = 'e' AND cscart_multi_decseo_names.dispatch = '' AND cscart_multi_decseo_names.lang_code = 'en'  WHERE 1  AND cscart_multi_decproduct_feature_variants.feature_id IN (15, 16, 17)  GROUP BY cscart_multi_decproduct_feature_variants.variant_id ORDER BY cscart_multi_decproduct_feature_variants.position, cscart_multi_decproduct_feature_variant_descriptions.variant 
1 0.00070 0.00070 0.00070
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (63, 61, 59, 45, 47, 77, 51, 64, 79, 41, 81, 83, 80, 65, 71, 50, 54, 67, 68, 74, 70, 75, 48, 82, 60, 56, 62, 53, 72, 44, 84, 55, 66, 52, 58, 73, 76, 78, 49, 46, 69, 39) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (63, 61, 59, 45, 47, 77, 51, 64, 79, 41, 81, 83, 80, 65, 71, 50, 54, 67, 68, 74, 70, 75, 48, 82, 60, 56, 62, 53, 72, 44, 84, 55, 66, 52, 58, 73, 76, 78, 49, 46, 69, 39) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00127 0.00127 0.00127
SELECT feature_id FROM cscart_multi_decproduct_features WHERE feature_id IN (15, 16, 17) AND feature_type = 'E'
1 0.00018 0.00018 0.00018
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_multi_decproduct_features_descriptions.description, cscart_multi_decproduct_features_descriptions.internal_name, cscart_multi_decproduct_features_descriptions.lang_code, cscart_multi_decproduct_features_descriptions.prefix, cscart_multi_decproduct_features_descriptions.suffix, pf.categories_path, cscart_multi_decproduct_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp FROM cscart_multi_decproduct_features AS pf LEFT JOIN cscart_multi_decproduct_features_descriptions ON cscart_multi_decproduct_features_descriptions.feature_id = pf.feature_id AND cscart_multi_decproduct_features_descriptions.lang_code = 'en' WHERE pf.feature_type = 'G' AND (pf.feature_id IN (14) OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_multi_decproduct_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(167, pf.categories_path) OR FIND_IN_SET(169, pf.categories_path) ) ORDER BY pf.position, cscart_multi_decproduct_features_descriptions.description
1 0.00044 0.00044 0.00044
SELECT v.feature_id,
        v.value,
        v.value_int,
        v.variant_id,
        f.feature_type,
        fd.internal_name,
        fd.description,
        fd.prefix,
        fd.suffix,
        vd.variant,
        f.parent_id,
        f.position,
        gf.position as gposition,
        f.display_on_header,
        f.display_on_catalog,
        f.display_on_product,
        f.feature_code,
        f.purpose FROM cscart_multi_decproduct_features as f LEFT JOIN cscart_multi_decproduct_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_multi_decproduct_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_multi_decproduct_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN cscart_multi_decproduct_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G'  WHERE f.status IN ('A') AND v.product_id = 220  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(167, f.categories_path) OR FIND_IN_SET(169, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_multi_decproduct_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.internal_name, fv.position
1 0.00041 0.00041 0.00041
SELECT filter_id, feature_id FROM cscart_multi_decproduct_filters WHERE status = 'A'
1 0.00010 0.00010 0.00010
SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.image_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (89) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id;SELECT cscart_multi_decimages.*, cscart_multi_decimages_links.*, cscart_multi_deccommon_descriptions.description AS alt, cscart_multi_decimages.image_id AS images_image_id FROM cscart_multi_decimages_links LEFT JOIN cscart_multi_decimages ON cscart_multi_decimages_links.detailed_id = cscart_multi_decimages.image_id LEFT JOIN cscart_multi_deccommon_descriptions ON cscart_multi_deccommon_descriptions.object_id = cscart_multi_decimages.image_id AND cscart_multi_deccommon_descriptions.object_holder = 'images' AND cscart_multi_deccommon_descriptions.lang_code = 'en' WHERE cscart_multi_decimages_links.object_type = 'feature_variant' AND cscart_multi_decimages_links.type = 'V' AND cscart_multi_decimages_links.object_id IN (89) ORDER BY cscart_multi_decimages_links.position, cscart_multi_decimages_links.pair_id
1 0.00035 0.00035 0.00035
SELECT cscart_multi_decstatuses.*, cscart_multi_decstatus_descriptions.* FROM cscart_multi_decstatuses  LEFT JOIN cscart_multi_decstatus_descriptions ON cscart_multi_decstatus_descriptions.status_id = cscart_multi_decstatuses.status_id AND cscart_multi_decstatus_descriptions.lang_code = 'en' WHERE 1 = 1  AND cscart_multi_decstatuses.type = 'O'  ORDER BY cscart_multi_decstatuses.position asc
1 0.00023 0.00023 0.00023
SELECT status_id, status FROM cscart_multi_decstatuses WHERE type = 'O'
1 0.00010 0.00010 0.00010
SELECT status_id, param, value FROM cscart_multi_decstatus_data WHERE status_id IN (1, 2, 3, 4, 5, 6, 7, 19)
1 0.00023 0.00023 0.00023
SELECT cscart_multi_decstatuses.status FROM cscart_multi_decstatuses INNER JOIN cscart_multi_decstatus_data ON cscart_multi_decstatus_data.status_id = cscart_multi_decstatuses.status_id WHERE type = 'O' AND (param, value) IN (('payment_received', 'Y'))
1 0.00016 0.00016 0.00016
SELECT rating FROM cscart_multi_decabsolute_rating WHERE `object_id` = 1 AND `object_type` = 'company'
1 0.00008 0.00008 0.00008
SELECT MAX(rating) FROM cscart_multi_decabsolute_rating WHERE `object_type` = 'company'
1 0.00009 0.00009 0.00009
SELECT company_id FROM cscart_multi_decstorefronts_companies WHERE storefront_id = 1
1 0.00009 0.00009 0.00009
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_id FROM cscart_multi_decproducts as products  LEFT JOIN cscart_multi_decproduct_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_multi_decproduct_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_multi_deccompanies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_multi_decproducts_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_multi_deccategories ON cscart_multi_deccategories.category_id = products_categories.category_id  AND (cscart_multi_deccategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_multi_deccategories.usergroup_ids) OR FIND_IN_SET(1, cscart_multi_deccategories.usergroup_ids)) AND cscart_multi_deccategories.status IN ('A', 'H') AND cscart_multi_deccategories.storefront_id IN (0, 1)  LEFT JOIN cscart_multi_decproduct_required_products ON products.product_id = cscart_multi_decproduct_required_products.required_id WHERE 1  AND companies.status IN ('A') 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 cscart_multi_decproduct_required_products.product_id = 220 AND products.product_type != 'D' GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC 
1 0.00040 0.00040 0.00040
SELECT privilege FROM cscart_multi_decusergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00011 0.00011 0.00011
SELECT c.* FROM cscart_multi_decbm_containers as c  WHERE 1  AND c.location_id = 1 AND c.company_id = 0
1 0.00048 0.00048 0.00048
SELECT layout_id FROM cscart_multi_decbm_locations WHERE location_id = 1
1 0.00015 0.00015 0.00015
SELECT c.*, IF (c.location_id != 1, 0, 1) as `default` FROM cscart_multi_decbm_containers as c  INNER JOIN cscart_multi_decbm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
1 0.00026 0.00026 0.00026
SELECT * FROM cscart_multi_decbm_containers as c LEFT JOIN cscart_multi_decbm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 3, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00042 0.00042 0.00042
SELECT cscart_multi_decbm_snapping.grid_id as grid_id,cscart_multi_decbm_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_multi_decbm_block_statuses.object_ids as object_ids,cscart_multi_decbm_snapping.*,cscart_multi_decbm_blocks.*,cscart_multi_decbm_blocks_descriptions.* FROM cscart_multi_decbm_snapping LEFT JOIN cscart_multi_decbm_blocks ON cscart_multi_decbm_blocks.block_id = cscart_multi_decbm_snapping.block_id LEFT JOIN cscart_multi_decbm_block_statuses ON cscart_multi_decbm_snapping.snapping_id = cscart_multi_decbm_block_statuses.snapping_id AND cscart_multi_decbm_block_statuses.object_type LIKE '' LEFT JOIN cscart_multi_decbm_blocks_descriptions ON cscart_multi_decbm_blocks.block_id = cscart_multi_decbm_blocks_descriptions.block_id  LEFT JOIN cscart_multi_decbm_blocks_content AS default_content ON cscart_multi_decbm_blocks.block_id = default_content.block_id AND cscart_multi_decbm_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_multi_decbm_blocks_content AS dynamic_object_content ON cscart_multi_decbm_blocks.block_id = dynamic_object_content.block_id AND cscart_multi_decbm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_multi_decbm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22)  AND cscart_multi_decbm_blocks_descriptions.lang_code='en'  ORDER BY cscart_multi_decbm_snapping.order, cscart_multi_decbm_snapping.block_id 
1 0.00163 0.00163 0.00163
SELECT a.code, b.country FROM cscart_multi_deccountries as a LEFT JOIN cscart_multi_deccountry_descriptions as b ON b.code = a.code AND b.lang_code = 'en' WHERE 1 AND a.status = 'A' ORDER BY b.country
1 0.00129 0.00129 0.00129
SELECT name, path FROM cscart_multi_decseo_names WHERE `object_id` = 15 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00054 0.00054 0.00054
SELECT name, path FROM cscart_multi_decseo_names WHERE `object_id` = 20 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00034 0.00034 0.00034
SELECT data FROM cscart_multi_decstorage_data WHERE data_key = 'restrictions'
1 0.00035 0.00035 0.00035