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

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_init_redirect_to_regional_storefront() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • Tygh\Storefront\Repository::findByUrl() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1424
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:134
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:321
  • fn_mve_storefront_repository_find_pre() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:105
  • fn_allowed_for() /home/vishalecarter/public_html/april_setup/app/functions/fn.multivendor.php:2077
  • fn_get_storage_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:992
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00027 Re-run Backtrace
2
SELECT storefronts.* FROM cscart_aprilstorefronts 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/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_init_redirect_to_regional_storefront() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • Tygh\Storefront\Repository::findByUrl() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1424
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:134
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:378
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00023 Re-run Backtrace
3
SET time_zone = '+05:30'

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_init_settings() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_init_time_zone() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1030
  • db_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1051
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:138
0.00018 Re-run Backtrace
4
SELECT type FROM cscart_aprilseo_names WHERE name = 'electronics' 

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:843
  • fn_seo_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:689
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00058 Re-run Backtrace
5
SELECT * FROM cscart_aprilseo_names WHERE name = 'electronics'  

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:843
  • fn_seo_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • db_get_array() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:693
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:333
0.00016 Re-run Backtrace
6
SELECT cscart_aprillanguages.lang_code, cscart_aprillanguages.name FROM cscart_aprillanguages  WHERE 1 AND cscart_aprillanguages.status = 'A'   

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:843
  • fn_seo_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • fn_seo_validate_object() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:732
  • Tygh\Languages\Languages::getSimpleLanguages() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:1129
  • db_get_hash_single_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:572
0.00023 Re-run Backtrace
7
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:843
  • fn_seo_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • fn_get_corrected_seo_lang_code() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:756
  • fn_seo_get_default_storefront_lang_code() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:449
  • Tygh\Storefront\Repository::findDefault() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:468
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:196
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:381
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00015 Re-run Backtrace
8
SELECT name, path FROM cscart_aprilseo_names WHERE `object_id` = 166 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:843
  • fn_seo_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • fn_url() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:847
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:3984
  • fn_seo_url_post() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • fn_seo_get_name() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:1645
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:1375
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00025 Re-run Backtrace
9
SELECT redirect_id, src, type, object_id, dest, lang_code FROM cscart_aprilseo_redirects WHERE src = '/electronics' 

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:843
  • fn_seo_get_route() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/addons/seo/func.php:877
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00009 Re-run Backtrace
10
SELECT cscart_aprilbm_layouts.* FROM cscart_aprilbm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_init_layout() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • Tygh\BlockManager\Layout::getDefault() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:646
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00019 Re-run Backtrace
11
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_init_user() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • fn_login_user() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:717
  • fn_init_user() /home/vishalecarter/public_html/april_setup/app/functions/fn.users.php:3584
  • fn_is_expired_storage_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:749
  • fn_get_storage_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:1102
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00018 Re-run Backtrace
12
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /home/vishalecarter/public_html/april_setup/index.php:18
  • fn_init() /home/vishalecarter/public_html/april_setup/init.php:195
  • fn_init_templater() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:1200
  • Tygh\Development::isEnabled() /home/vishalecarter/public_html/april_setup/app/functions/fn.init.php:87
  • Tygh\Development::read() /home/vishalecarter/public_html/april_setup/app/Tygh/Development.php:28
  • fn_get_storage_data() /home/vishalecarter/public_html/april_setup/app/Tygh/Development.php:81
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00034 Re-run Backtrace
13
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_aprilstorefronts AS storefronts  WHERE 1 = 1

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

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

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::instance() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Location.php:483
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00050 Re-run Backtrace
27
SELECT * FROM cscart_aprilbm_locations as l LEFT JOIN cscart_aprilbm_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 ('categories.view') AND (FIND_IN_SET(166, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

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

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_storage_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/init.php:146
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00040 Re-run Backtrace
29
SELECT * FROM cscart_aprilsettings_sections WHERE name = 'pwa' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_sections.edition_type))

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /home/vishalecarter/public_html/april_setup/app/addons/pwa/controllers/frontend/init.post.php:18
  • Tygh\Settings::getValues() /home/vishalecarter/public_html/april_setup/app/addons/pwa/func.php:179
  • Tygh\Settings::getSectionByName() /home/vishalecarter/public_html/april_setup/app/Tygh/Settings.php:790
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/Tygh/Settings.php:406
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00020 Re-run Backtrace
30
SELECT cscart_aprilsettings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects  LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND section_id = 19 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.type <> 'H' ORDER BY cscart_aprilsettings_objects.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /home/vishalecarter/public_html/april_setup/app/addons/pwa/controllers/frontend/init.post.php:18
  • Tygh\Settings::getValues() /home/vishalecarter/public_html/april_setup/app/addons/pwa/func.php:179
  • Tygh\Settings::getPlainList() /home/vishalecarter/public_html/april_setup/app/Tygh/Settings.php:805
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/april_setup/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:333
0.00029 Re-run Backtrace
31
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'manifest_icon' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /home/vishalecarter/public_html/april_setup/app/addons/pwa/controllers/frontend/init.post.php:18
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/addons/pwa/func.php:205
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00029 Re-run Backtrace
32
SELECT * FROM cscart_aprilhybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_hybrid_auth_get_providers_list() /home/vishalecarter/public_html/april_setup/app/addons/hybrid_auth/controllers/frontend/init.post.php:17
  • Tygh\Registry::getOrSetCache() /home/vishalecarter/public_html/april_setup/app/addons/hybrid_auth/func.php:234
  • {closure}() /home/vishalecarter/public_html/april_setup/app/Tygh/Registry.php:800
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00027 Re-run Backtrace
33
SELECT usergroup_ids FROM cscart_aprilcategories WHERE category_id = 166

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:38
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00018 Re-run Backtrace
34
SELECT category_id FROM cscart_aprilcategories WHERE category_id = 166  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_aprilcategories.storefront_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:58
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00014 Re-run Backtrace
35
SELECT category_id FROM cscart_aprilcategories WHERE category_type = 'D'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_subcategories() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:61
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:243
  • fn_vendor_debt_payout_get_categories_pre() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • fn_vendor_debt_payout_get_payout_category() /home/vishalecarter/public_html/april_setup/app/addons/vendor_debt_payout/func.php:368
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/addons/vendor_debt_payout/func.php:227
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00013 Re-run Backtrace
36
SELECT id_path FROM cscart_aprilcategories WHERE category_id = 166

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_subcategories() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:61
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:351
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00008 Re-run Backtrace
37
SELECT cscart_aprilcategories.category_id,cscart_aprilcategories.parent_id,cscart_aprilcategories.id_path,cscart_aprilcategory_descriptions.category,cscart_aprilcategories.position,cscart_aprilcategories.status,cscart_aprilcategories.company_id,cscart_aprilcategories.storefront_id,cscart_aprilseo_names.name as seo_name,cscart_aprilseo_names.path as seo_path FROM cscart_aprilcategories LEFT JOIN cscart_aprilcategory_descriptions ON cscart_aprilcategories.category_id = cscart_aprilcategory_descriptions.category_id AND cscart_aprilcategory_descriptions.lang_code = 'en'  LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = cscart_aprilcategories.category_id  AND cscart_aprilseo_names.type = 'c'  AND cscart_aprilseo_names.dispatch = '' AND cscart_aprilseo_names.lang_code = 'en'  WHERE 1=1  AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids)) AND cscart_aprilcategories.status IN ('A') AND cscart_aprilcategories.parent_id IN (166) AND cscart_aprilcategories.id_path LIKE '166/%' AND cscart_aprilcategories.category_id != 264 AND cscart_aprilcategories.parent_id != 264 AND cscart_aprilcategories.storefront_id IN (0, 1)   ORDER BY cscart_aprilcategories.is_trash asc, cscart_aprilcategories.position asc, cscart_aprilcategory_descriptions.category asc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_subcategories() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:61
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:441
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00058 Re-run Backtrace
38
SELECT category_id, parent_id FROM cscart_aprilcategories WHERE parent_id IN(175, 174, 234, 177, 196, 254)  AND category_id != 264

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_subcategories() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:61
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:484
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00036 Re-run Backtrace
39
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (175, 174, 234, 177, 196, 254) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (175, 174, 234, 177, 196, 254) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_subcategories() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:74
  • fn_get_categories() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:61
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:547
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00087 Re-run Backtrace
40
SELECT *, cscart_aprilseo_names.name as seo_name, cscart_aprilseo_names.path as seo_path FROM cscart_aprilcategories LEFT JOIN cscart_aprilcategory_descriptions ON cscart_aprilcategory_descriptions.category_id = cscart_aprilcategories.category_id AND cscart_aprilcategory_descriptions.lang_code = 'en'  LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = 166  AND cscart_aprilseo_names.type = 'c'  AND cscart_aprilseo_names.dispatch = '' AND cscart_aprilseo_names.lang_code = 'en'  WHERE cscart_aprilcategories.category_id = 166 AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids))

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_category_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:77
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:801
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00037 Re-run Backtrace
41
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '166' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '166' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_category_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:77
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/functions/fn.categories.php:818
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00040 Re-run Backtrace
42
SELECT a.category_id
                 FROM cscart_aprilcategories as a
                 LEFT JOIN cscart_aprilcategories as b
                 ON b.category_id IN (166)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • db_get_fields() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:1944
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:480
0.00055 Re-run Backtrace
43
SELECT company_id FROM cscart_aprilstorefronts_companies WHERE storefront_id = 1

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • Tygh\Storefront\Storefront::__call() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2021
  • Tygh\Storefront\Storefront::getRelationValue() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Storefront.php:273
  • Tygh\Storefront\RelationsManager::getRelatedValues() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:480
0.00010 Re-run Backtrace
44
SELECT cscart_aprilproducts.* FROM cscart_aprilproducts  WHERE cscart_aprilproducts.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2483
  • fn_load_extra_data_by_entity_ids() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2678
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:8945
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00068 Re-run Backtrace
45
SELECT cscart_aprilproduct_prices.product_id, MIN(IF(cscart_aprilproduct_prices.percentage_discount = 0,cscart_aprilproduct_prices.price,cscart_aprilproduct_prices.price - (cscart_aprilproduct_prices.price * cscart_aprilproduct_prices.percentage_discount)/100)) AS price FROM cscart_aprilproduct_prices  WHERE cscart_aprilproduct_prices.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilproduct_prices.lower_limit = 1 AND cscart_aprilproduct_prices.usergroup_id IN (0, 1)  GROUP BY cscart_aprilproduct_prices.product_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2483
  • fn_load_extra_data_by_entity_ids() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2678
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:8945
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00094 Re-run Backtrace
46
SELECT cscart_aprilproduct_descriptions.product_id, cscart_aprilproduct_descriptions.short_description, IF(cscart_aprilproduct_descriptions.short_description = '' OR cscart_aprilproduct_descriptions.short_description IS NULL, cscart_aprilproduct_descriptions.full_description, '') AS full_description, cscart_aprilproduct_descriptions.unit_name FROM cscart_aprilproduct_descriptions  WHERE cscart_aprilproduct_descriptions.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilproduct_descriptions.lang_code = 'en' 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2483
  • fn_load_extra_data_by_entity_ids() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2678
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:8945
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00085 Re-run Backtrace
47
SELECT cscart_aprilproducts_categories.product_id, GROUP_CONCAT(IF(cscart_aprilproducts_categories.link_type = "M", CONCAT(cscart_aprilproducts_categories.category_id, "M"), cscart_aprilproducts_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_aprilproducts_categories  INNER JOIN cscart_aprilcategories ON cscart_aprilcategories.category_id = cscart_aprilproducts_categories.category_id AND cscart_aprilcategories.storefront_id IN (0, 1) AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids)) AND cscart_aprilcategories.status IN ('A', 'H')  LEFT JOIN cscart_aprilproducts_categories AS product_position_source ON cscart_aprilproducts_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 166 WHERE cscart_aprilproducts_categories.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)   GROUP BY cscart_aprilproducts_categories.product_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2483
  • fn_load_extra_data_by_entity_ids() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2678
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:8945
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00095 Re-run Backtrace
48
SELECT cscart_aprilseo_names.object_id AS product_id, cscart_aprilseo_names.name AS seo_name, cscart_aprilseo_names.path AS seo_path FROM cscart_aprilseo_names  WHERE cscart_aprilseo_names.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilseo_names.type = "p" AND cscart_aprilseo_names.dispatch = "" AND cscart_aprilseo_names.lang_code = 'en'  

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2483
  • fn_load_extra_data_by_entity_ids() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2678
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:8945
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00180 Re-run Backtrace
49
SELECT cscart_aprilproduct_review_prepared_data.product_id AS product_id, cscart_aprilproduct_review_prepared_data.average_rating AS average_rating, cscart_aprilproduct_review_prepared_data.reviews_count AS reviews_count FROM cscart_aprilproduct_review_prepared_data  WHERE cscart_aprilproduct_review_prepared_data.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilproduct_review_prepared_data.storefront_id = 0 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:115
  • fn_load_products_extra_data() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2483
  • fn_load_extra_data_by_entity_ids() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2678
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:8945
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00025 Re-run Backtrace
50
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:636
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00407 Re-run Backtrace
51
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'A' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'A' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:640
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00546 Re-run Backtrace
52
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_aprilproduct_options as a  LEFT JOIN cscart_aprilproduct_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) AND a.status = 'A' ORDER BY a.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:649
  • db_get_hash_multi_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:241
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:526
0.00067 Re-run Backtrace
53
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_aprilproduct_options as a LEFT JOIN cscart_aprilproduct_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_aprilproduct_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:649
  • db_get_hash_multi_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:251
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:526
0.00043 Re-run Backtrace
54
SELECT b.variant_name, a.* FROM cscart_aprilproduct_option_variants AS a  LEFT JOIN cscart_aprilproduct_option_variants_descriptions AS b ON b.variant_id = a.variant_id AND b.lang_code = 'en' WHERE 1  AND a.option_id IN (20, 25) AND a.status='A' ORDER BY  a.position, a.variant_id 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:649
  • fn_get_product_option_variants() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:296
  • db_get_hash_multi_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:526
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:526
0.00022 Re-run Backtrace
55
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'variant_image' AND cscart_aprilimages_links.type = 'V' AND cscart_aprilimages_links.object_id IN (152, 153, 154, 180, 179) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'variant_image' AND cscart_aprilimages_links.type = 'V' AND cscart_aprilimages_links.object_id IN (152, 153, 154, 180, 179) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:649
  • fn_get_product_option_variants() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:296
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:542
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00053 Re-run Backtrace
56
SELECT option_id, option_type FROM cscart_aprilproduct_options WHERE option_id IN (25, 20)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_product_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:649
  • fn_get_product_option_variants() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:296
  • db_get_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:553
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:333
0.00012 Re-run Backtrace
57
SELECT cscart_aprillanguages.* FROM cscart_aprillanguages  WHERE 1    

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:669
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()
  • Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:166
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:69
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/vishalecarter/public_html/april_setup/app/Tygh/Providers/CommonProvider.php:40
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:134
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00020 Re-run Backtrace
58
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts LEFT JOIN cscart_aprilstorefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:669
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()
  • Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:166
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:69
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/vishalecarter/public_html/april_setup/app/Tygh/Providers/CommonProvider.php:40
  • Tygh\Languages\Languages::afterFind() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:135
  • Tygh\Languages\Languages::attachStorefrontIds() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1681
  • array_walk() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1745
  • Tygh\Languages\Languages::Tygh\Languages\{closure}()
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1742
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:381
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00042 Re-run Backtrace
59
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts LEFT JOIN cscart_aprilstorefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:669
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()
  • Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:166
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:69
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/vishalecarter/public_html/april_setup/app/Tygh/Providers/CommonProvider.php:40
  • Tygh\Languages\Languages::afterFind() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:135
  • Tygh\Languages\Languages::attachStorefrontIds() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1681
  • array_walk() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1745
  • Tygh\Languages\Languages::Tygh\Languages\{closure}()
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1742
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:381
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00016 Re-run Backtrace
60
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts LEFT JOIN cscart_aprilstorefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('3') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:669
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()
  • Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:166
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/ServiceProvider.php:69
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Languages\Languages::getAll() /home/vishalecarter/public_html/april_setup/app/Tygh/Providers/CommonProvider.php:40
  • Tygh\Languages\Languages::afterFind() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:135
  • Tygh\Languages\Languages::attachStorefrontIds() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1681
  • array_walk() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1745
  • Tygh\Languages\Languages::Tygh\Languages\{closure}()
  • Tygh\Storefront\Repository::find() /home/vishalecarter/public_html/april_setup/app/Tygh/Languages/Languages.php:1742
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/Tygh/Storefront/Repository.php:381
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00015 Re-run Backtrace
61
SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_aprilproduct_variation_group_features AS f INNER JOIN cscart_aprilproduct_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_aprilproduct_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:669
  • Tygh\Addons\Loader::Tygh\Addons\{closure}() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • call_user_func_array() /home/vishalecarter/public_html/april_setup/app/Tygh/Addons/Loader.php:144
  • Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()
  • Tygh\Addons\ProductVariations\Product\Repository::loadProductsGroupInfo() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:316
  • Tygh\Addons\ProductVariations\Product\Group\Repository::findGroupInfoByProductIds() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/Product/Repository.php:448
  • Tygh\Addons\ProductVariations\Tools\Query::select() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/Product/Group/Repository.php:355
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/april_setup/app/addons/product_variations/src/Tools/Query.php:310
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:333
0.00030 Re-run Backtrace
62
SELECT cscart_aprilpromotions.*, cscart_aprilpromotion_descriptions.name, cscart_aprilpromotion_descriptions.detailed_description, cscart_aprilpromotion_descriptions.short_description FROM cscart_aprilpromotions  LEFT JOIN cscart_aprilpromotion_descriptions ON cscart_aprilpromotion_descriptions.promotion_id = cscart_aprilpromotions.promotion_id AND cscart_aprilpromotion_descriptions.lang_code = 'en' LEFT JOIN cscart_aprilstorefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_aprilpromotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1777130434, 1) AND IF(to_date, to_date >= 1777130434, 1) AND status IN ('A', 'H') AND cscart_aprilpromotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY cscart_aprilpromotions.stop_other_rules desc, cscart_aprilpromotions.priority asc 

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_promotion_apply() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:810
  • fn_get_promotions() /home/vishalecarter/public_html/april_setup/app/functions/fn.promotions.php:277
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.promotions.php:193
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00030 Re-run Backtrace
63
SELECT product_id FROM cscart_aprilproducts WHERE product_type = 'D'

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_promotion_apply() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:810
  • fn_set_hook() /home/vishalecarter/public_html/april_setup/app/functions/fn.promotions.php:298
  • fn_vendor_debt_payout_promotion_apply_pre() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:124
  • fn_vendor_debt_payout_get_payout_product() /home/vishalecarter/public_html/april_setup/app/addons/vendor_debt_payout/func.php:826
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/addons/vendor_debt_payout/func.php:249
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00023 Re-run Backtrace
64
SELECT * FROM cscart_aprilproduct_options_exceptions WHERE product_id = 248 ORDER BY exception_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_apply_options_rules() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:745
  • fn_get_default_product_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:1888
  • fn_get_product_exceptions() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:882
  • db_get_array() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:1075
  • Tygh\Database\Connection::getArray() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:333
0.00009 Re-run Backtrace
65
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product_option' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1267114885' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product_option' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1267114885' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_get_image_pairs() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:750
  • db_multi_query() /home/vishalecarter/public_html/april_setup/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:168
0.00035 Re-run Backtrace
66
SELECT option_type as type, option_id FROM cscart_aprilproduct_options WHERE option_id IN (20, 25)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_apply_options_modifiers() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:771
  • fn_get_option_modifiers_by_selected_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:759
  • Tygh\Database\Connection::getSingleHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:2471
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:572
0.00013 Re-run Backtrace
67
SELECT a.modifier, a.modifier_type, a.variant_id FROM cscart_aprilproduct_option_variants a  WHERE 1 AND a.variant_id IN (180, 152)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_gather_additional_products_data() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:122
  • fn_apply_options_modifiers() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:771
  • fn_get_option_modifiers_by_selected_options() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:759
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.options.php:2507
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00011 Re-run Backtrace
68
SELECT default_view, selected_views FROM cscart_aprilcategories WHERE category_id = 166

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_run_controller() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:460
  • include() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:729
  • fn_get_products_layout() /home/vishalecarter/public_html/april_setup/app/controllers/frontend/categories.php:137
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.products.php:2876
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:414
0.00011 Re-run Backtrace
69
SELECT privilege FROM cscart_aprilusergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • fn_check_permissions() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:519
  • fn_check_admin_permissions() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:2574
  • db_get_fields() /home/vishalecarter/public_html/april_setup/app/functions/fn.common.php:2756
  • Tygh\Database\Connection::getColumn() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:480
0.00031 Re-run Backtrace
70
SELECT c.* FROM cscart_aprilbm_containers as c  WHERE 1  AND c.location_id = 6 AND c.company_id = 0

    Backtrace

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

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69e9bb79a7fff5_99641477() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/april_setup/var/cache/templates/nova_theme/7af8c5e97194a9ad8c5f3bcaa63157c92af3617d_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:128
  • Tygh\BlockManager\Container::getList() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:448
0.00010 Re-run Backtrace
72
SELECT c.*, IF (c.location_id != 6, 0, 1) as `default` FROM cscart_aprilbm_containers as c  INNER JOIN cscart_aprilbm_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/april_setup/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69e9bb79a7fff5_99641477() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/april_setup/var/cache/templates/nova_theme/7af8c5e97194a9ad8c5f3bcaa63157c92af3617d_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:128
  • Tygh\BlockManager\Container::getList() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00021 Re-run Backtrace
73
SELECT * FROM cscart_aprilbm_containers as c LEFT JOIN cscart_aprilbm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 23, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69e9bb79a7fff5_99641477() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/april_setup/var/cache/templates/nova_theme/7af8c5e97194a9ad8c5f3bcaa63157c92af3617d_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Grid::getList() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:134
  • db_get_hash_multi_array() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/Grid.php:63
  • Tygh\Database\Connection::getMultiHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:526
0.00035 Re-run Backtrace
74
SELECT cscart_aprilbm_snapping.grid_id as grid_id,cscart_aprilbm_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_aprilbm_block_statuses.object_ids as object_ids,cscart_aprilbm_snapping.*,cscart_aprilbm_blocks.*,cscart_aprilbm_blocks_descriptions.* FROM cscart_aprilbm_snapping LEFT JOIN cscart_aprilbm_blocks ON cscart_aprilbm_blocks.block_id = cscart_aprilbm_snapping.block_id LEFT JOIN cscart_aprilbm_block_statuses ON cscart_aprilbm_snapping.snapping_id = cscart_aprilbm_block_statuses.snapping_id AND cscart_aprilbm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_aprilbm_blocks_descriptions ON cscart_aprilbm_blocks.block_id = cscart_aprilbm_blocks_descriptions.block_id  LEFT JOIN cscart_aprilbm_blocks_content AS default_content ON cscart_aprilbm_blocks.block_id = default_content.block_id AND cscart_aprilbm_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_aprilbm_blocks_content AS dynamic_object_content ON cscart_aprilbm_blocks.block_id = dynamic_object_content.block_id AND cscart_aprilbm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 166 AND dynamic_object_content.object_type like 'categories' WHERE cscart_aprilbm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 42, 43, 44)  AND cscart_aprilbm_blocks_descriptions.lang_code='en'  ORDER BY cscart_aprilbm_snapping.order, cscart_aprilbm_snapping.block_id 

    Backtrace

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

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69e9bb79a7fff5_99641477() /home/vishalecarter/public_html/april_setup/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /home/vishalecarter/public_html/april_setup/var/cache/templates/nova_theme/7af8c5e97194a9ad8c5f3bcaa63157c92af3617d_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /home/vishalecarter/public_html/april_setup/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\BlockManager\RenderManager::getValue() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /home/vishalecarter/public_html/april_setup/app/Tygh/BlockManager/RenderManager.php:837
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /home/vishalecarter/public_html/april_setup/app/addons/hybrid_auth/func.php:255
  • Tygh\Registry::getOrSetCache() /home/vishalecarter/public_html/april_setup/app/addons/hybrid_auth/func.php:234
  • {closure}() /home/vishalecarter/public_html/april_setup/app/Tygh/Registry.php:800
  • db_get_hash_array() /home/vishalecarter/public_html/april_setup/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/app/Tygh/Database/Connection.php:371
0.00036 Re-run Backtrace
76
SELECT name, path FROM cscart_aprilseo_names WHERE `object_id` = 15 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

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

    Backtrace

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

    Backtrace

  • fn_dispatch() /home/vishalecarter/public_html/april_setup/index.php:19
  • Tygh\Application::offsetGet() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:655
  • Pimple\Container::offsetGet() /home/vishalecarter/public_html/april_setup/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/vishalecarter/public_html/april_setup/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • fn_get_storage_data() /home/vishalecarter/public_html/april_setup/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /home/vishalecarter/public_html/april_setup/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /home/vishalecarter/public_html/april_setup/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/vishalecarter/public_html/april_setup/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_aprilhybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position
2 0.00027 0.00036 0.00031
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'store_mode'
1 0.00027 0.00027 0.00027
SELECT storefronts.* FROM cscart_aprilstorefronts 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 = '+05:30'
1 0.00018 0.00018 0.00018
SELECT type FROM cscart_aprilseo_names WHERE name = 'electronics' 
1 0.00058 0.00058 0.00058
SELECT * FROM cscart_aprilseo_names WHERE name = 'electronics'  
1 0.00016 0.00016 0.00016
SELECT cscart_aprillanguages.lang_code, cscart_aprillanguages.name FROM cscart_aprillanguages  WHERE 1 AND cscart_aprillanguages.status = 'A'   
1 0.00023 0.00023 0.00023
SELECT storefronts.* FROM cscart_aprilstorefronts 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 name, path FROM cscart_aprilseo_names WHERE `object_id` = 166 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00025 0.00025 0.00025
SELECT redirect_id, src, type, object_id, dest, lang_code FROM cscart_aprilseo_redirects WHERE src = '/electronics' 
1 0.00009 0.00009 0.00009
SELECT cscart_aprilbm_layouts.* FROM cscart_aprilbm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1
1 0.00019 0.00019 0.00019
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'cart_products_next_check'
1 0.00018 0.00018 0.00018
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'dev_mode'
1 0.00034 0.00034 0.00034
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_aprilstorefronts AS storefronts  WHERE 1 = 1
1 0.00038 0.00038 0.00038
SELECT cscart_aprilsettings_sections.name, cscart_aprilsettings_sections.section_id, cscart_aprilsettings_sections.position, cscart_aprilsettings_sections.type , cscart_aprilsettings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_aprilsettings_sections.name) as href  FROM cscart_aprilsettings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_sections.edition_type)) ORDER BY cscart_aprilsettings_sections.position
1 0.00032 0.00032 0.00032
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'color_schema'  AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
1 0.00020 0.00020 0.00020
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects  LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5963 ORDER BY cscart_aprilsettings_objects.position
1 0.00019 0.00019 0.00019
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'sidebar_color'  AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
1 0.00014 0.00014 0.00014
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects  LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5964 ORDER BY cscart_aprilsettings_objects.position
1 0.00014 0.00014 0.00014
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'element_color'  AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
1 0.00013 0.00013 0.00013
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects  LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5965 ORDER BY cscart_aprilsettings_objects.position
1 0.00013 0.00013 0.00013
SELECT object_id FROM cscart_aprilsettings_objects LEFT JOIN cscart_aprilsettings_sections ON cscart_aprilsettings_objects.section_id = cscart_aprilsettings_sections.section_id WHERE cscart_aprilsettings_objects.name = 'sidebar_background_image'  AND cscart_aprilsettings_sections.name = 'vendor_panel_configurator'
1 0.00013 0.00013 0.00013
SELECT cscart_aprilsettings_objects.object_id as object_id, cscart_aprilsettings_objects.type as object_type, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects  LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.object_id = 5966 ORDER BY cscart_aprilsettings_objects.position
1 0.00013 0.00013 0.00013
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '0' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '0' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00032 0.00032 0.00032
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00027 0.00027 0.00027
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '2' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'vendor_panel' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '2' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00027 0.00027 0.00027
SELECT * FROM cscart_aprilbm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1
1 0.00050 0.00050 0.00050
SELECT * FROM cscart_aprilbm_locations as l LEFT JOIN cscart_aprilbm_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 ('categories.view') AND (FIND_IN_SET(166, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00033 0.00033 0.00033
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'cache_id'
1 0.00040 0.00040 0.00040
SELECT * FROM cscart_aprilsettings_sections WHERE name = 'pwa' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_sections.edition_type))
1 0.00020 0.00020 0.00020
SELECT cscart_aprilsettings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_aprilsettings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_aprilsettings_objects.value END) AS value FROM cscart_aprilsettings_objects  LEFT JOIN cscart_aprilsettings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_aprilsettings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND section_id = 19 AND (FIND_IN_SET('STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_aprilsettings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_aprilsettings_objects.edition_type)) AND cscart_aprilsettings_objects.type <> 'H' ORDER BY cscart_aprilsettings_objects.position
1 0.00029 0.00029 0.00029
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'manifest_icon' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00029 0.00029 0.00029
SELECT usergroup_ids FROM cscart_aprilcategories WHERE category_id = 166
1 0.00018 0.00018 0.00018
SELECT category_id FROM cscart_aprilcategories WHERE category_id = 166  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_aprilcategories.storefront_id IN (0, 1)
1 0.00014 0.00014 0.00014
SELECT category_id FROM cscart_aprilcategories WHERE category_type = 'D'
1 0.00013 0.00013 0.00013
SELECT id_path FROM cscart_aprilcategories WHERE category_id = 166
1 0.00008 0.00008 0.00008
SELECT cscart_aprilcategories.category_id,cscart_aprilcategories.parent_id,cscart_aprilcategories.id_path,cscart_aprilcategory_descriptions.category,cscart_aprilcategories.position,cscart_aprilcategories.status,cscart_aprilcategories.company_id,cscart_aprilcategories.storefront_id,cscart_aprilseo_names.name as seo_name,cscart_aprilseo_names.path as seo_path FROM cscart_aprilcategories LEFT JOIN cscart_aprilcategory_descriptions ON cscart_aprilcategories.category_id = cscart_aprilcategory_descriptions.category_id AND cscart_aprilcategory_descriptions.lang_code = 'en'  LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = cscart_aprilcategories.category_id  AND cscart_aprilseo_names.type = 'c'  AND cscart_aprilseo_names.dispatch = '' AND cscart_aprilseo_names.lang_code = 'en'  WHERE 1=1  AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids)) AND cscart_aprilcategories.status IN ('A') AND cscart_aprilcategories.parent_id IN (166) AND cscart_aprilcategories.id_path LIKE '166/%' AND cscart_aprilcategories.category_id != 264 AND cscart_aprilcategories.parent_id != 264 AND cscart_aprilcategories.storefront_id IN (0, 1)   ORDER BY cscart_aprilcategories.is_trash asc, cscart_aprilcategories.position asc, cscart_aprilcategory_descriptions.category asc 
1 0.00058 0.00058 0.00058
SELECT category_id, parent_id FROM cscart_aprilcategories WHERE parent_id IN(175, 174, 234, 177, 196, 254)  AND category_id != 264
1 0.00036 0.00036 0.00036
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (175, 174, 234, 177, 196, 254) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (175, 174, 234, 177, 196, 254) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00087 0.00087 0.00087
SELECT *, cscart_aprilseo_names.name as seo_name, cscart_aprilseo_names.path as seo_path FROM cscart_aprilcategories LEFT JOIN cscart_aprilcategory_descriptions ON cscart_aprilcategory_descriptions.category_id = cscart_aprilcategories.category_id AND cscart_aprilcategory_descriptions.lang_code = 'en'  LEFT JOIN cscart_aprilseo_names ON cscart_aprilseo_names.object_id = 166  AND cscart_aprilseo_names.type = 'c'  AND cscart_aprilseo_names.dispatch = '' AND cscart_aprilseo_names.lang_code = 'en'  WHERE cscart_aprilcategories.category_id = 166 AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids))
1 0.00037 0.00037 0.00037
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '166' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'category' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '166' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00040 0.00040 0.00040
SELECT a.category_id
                 FROM cscart_aprilcategories as a
                 LEFT JOIN cscart_aprilcategories as b
                 ON b.category_id IN (166)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
1 0.00055 0.00055 0.00055
SELECT company_id FROM cscart_aprilstorefronts_companies WHERE storefront_id = 1
1 0.00010 0.00010 0.00010
SELECT cscart_aprilproducts.* FROM cscart_aprilproducts  WHERE cscart_aprilproducts.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  
1 0.00068 0.00068 0.00068
SELECT cscart_aprilproduct_prices.product_id, MIN(IF(cscart_aprilproduct_prices.percentage_discount = 0,cscart_aprilproduct_prices.price,cscart_aprilproduct_prices.price - (cscart_aprilproduct_prices.price * cscart_aprilproduct_prices.percentage_discount)/100)) AS price FROM cscart_aprilproduct_prices  WHERE cscart_aprilproduct_prices.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilproduct_prices.lower_limit = 1 AND cscart_aprilproduct_prices.usergroup_id IN (0, 1)  GROUP BY cscart_aprilproduct_prices.product_id
1 0.00094 0.00094 0.00094
SELECT cscart_aprilproduct_descriptions.product_id, cscart_aprilproduct_descriptions.short_description, IF(cscart_aprilproduct_descriptions.short_description = '' OR cscart_aprilproduct_descriptions.short_description IS NULL, cscart_aprilproduct_descriptions.full_description, '') AS full_description, cscart_aprilproduct_descriptions.unit_name FROM cscart_aprilproduct_descriptions  WHERE cscart_aprilproduct_descriptions.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilproduct_descriptions.lang_code = 'en' 
1 0.00085 0.00085 0.00085
SELECT cscart_aprilproducts_categories.product_id, GROUP_CONCAT(IF(cscart_aprilproducts_categories.link_type = "M", CONCAT(cscart_aprilproducts_categories.category_id, "M"), cscart_aprilproducts_categories.category_id)) AS category_ids, product_position_source.position AS position FROM cscart_aprilproducts_categories  INNER JOIN cscart_aprilcategories ON cscart_aprilcategories.category_id = cscart_aprilproducts_categories.category_id AND cscart_aprilcategories.storefront_id IN (0, 1) AND (cscart_aprilcategories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_aprilcategories.usergroup_ids) OR FIND_IN_SET(1, cscart_aprilcategories.usergroup_ids)) AND cscart_aprilcategories.status IN ('A', 'H')  LEFT JOIN cscart_aprilproducts_categories AS product_position_source ON cscart_aprilproducts_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 166 WHERE cscart_aprilproducts_categories.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)   GROUP BY cscart_aprilproducts_categories.product_id
1 0.00095 0.00095 0.00095
SELECT cscart_aprilseo_names.object_id AS product_id, cscart_aprilseo_names.name AS seo_name, cscart_aprilseo_names.path AS seo_path FROM cscart_aprilseo_names  WHERE cscart_aprilseo_names.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilseo_names.type = "p" AND cscart_aprilseo_names.dispatch = "" AND cscart_aprilseo_names.lang_code = 'en'  
1 0.00180 0.00180 0.00180
SELECT cscart_aprilproduct_review_prepared_data.product_id AS product_id, cscart_aprilproduct_review_prepared_data.average_rating AS average_rating, cscart_aprilproduct_review_prepared_data.reviews_count AS reviews_count FROM cscart_aprilproduct_review_prepared_data  WHERE cscart_aprilproduct_review_prepared_data.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)  AND cscart_aprilproduct_review_prepared_data.storefront_id = 0 
1 0.00025 0.00025 0.00025
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00407 0.00407 0.00407
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'A' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product' AND cscart_aprilimages_links.type = 'A' AND cscart_aprilimages_links.object_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00546 0.00546 0.00546
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_aprilproduct_options as a  LEFT JOIN cscart_aprilproduct_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) AND a.status = 'A' ORDER BY a.position
1 0.00067 0.00067 0.00067
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_aprilproduct_options as a LEFT JOIN cscart_aprilproduct_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_aprilproduct_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position
1 0.00043 0.00043 0.00043
SELECT b.variant_name, a.* FROM cscart_aprilproduct_option_variants AS a  LEFT JOIN cscart_aprilproduct_option_variants_descriptions AS b ON b.variant_id = a.variant_id AND b.lang_code = 'en' WHERE 1  AND a.option_id IN (20, 25) AND a.status='A' ORDER BY  a.position, a.variant_id 
1 0.00022 0.00022 0.00022
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'variant_image' AND cscart_aprilimages_links.type = 'V' AND cscart_aprilimages_links.object_id IN (152, 153, 154, 180, 179) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'variant_image' AND cscart_aprilimages_links.type = 'V' AND cscart_aprilimages_links.object_id IN (152, 153, 154, 180, 179) ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00053 0.00053 0.00053
SELECT option_id, option_type FROM cscart_aprilproduct_options WHERE option_id IN (25, 20)
1 0.00012 0.00012 0.00012
SELECT cscart_aprillanguages.* FROM cscart_aprillanguages  WHERE 1    
1 0.00020 0.00020 0.00020
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts LEFT JOIN cscart_aprilstorefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00042 0.00042 0.00042
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts LEFT JOIN cscart_aprilstorefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00016 0.00016 0.00016
SELECT storefronts.* FROM cscart_aprilstorefronts AS storefronts LEFT JOIN cscart_aprilstorefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('3') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00015 0.00015 0.00015
SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM cscart_aprilproduct_variation_group_features AS f INNER JOIN cscart_aprilproduct_variation_groups AS g ON f.group_id = g.id INNER JOIN cscart_aprilproduct_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (148, 180, 18, 16, 4, 5, 23, 24, 1, 22, 149, 190, 189, 245, 238, 239, 242, 243, 59, 58, 60, 172, 134, 135, 168, 167, 169, 42, 39, 40, 37, 74, 73, 71, 75, 72, 70, 156, 175, 43, 76, 56, 57, 30, 246, 173, 67, 25, 154, 53, 52, 161, 165, 166, 86, 106, 105, 101, 33, 32, 163, 155, 55, 69, 184, 183, 133, 132, 125, 120, 146, 147, 145, 117, 113, 157, 68, 29, 6, 8, 14, 9, 10, 19, 21, 50, 51, 49, 48, 54, 153, 164, 248, 65, 64, 63)
1 0.00030 0.00030 0.00030
SELECT cscart_aprilpromotions.*, cscart_aprilpromotion_descriptions.name, cscart_aprilpromotion_descriptions.detailed_description, cscart_aprilpromotion_descriptions.short_description FROM cscart_aprilpromotions  LEFT JOIN cscart_aprilpromotion_descriptions ON cscart_aprilpromotion_descriptions.promotion_id = cscart_aprilpromotions.promotion_id AND cscart_aprilpromotion_descriptions.lang_code = 'en' LEFT JOIN cscart_aprilstorefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_aprilpromotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1777130434, 1) AND IF(to_date, to_date >= 1777130434, 1) AND status IN ('A', 'H') AND cscart_aprilpromotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY cscart_aprilpromotions.stop_other_rules desc, cscart_aprilpromotions.priority asc 
1 0.00030 0.00030 0.00030
SELECT product_id FROM cscart_aprilproducts WHERE product_type = 'D'
1 0.00023 0.00023 0.00023
SELECT * FROM cscart_aprilproduct_options_exceptions WHERE product_id = 248 ORDER BY exception_id
1 0.00009 0.00009 0.00009
SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.image_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product_option' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1267114885' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id;SELECT cscart_aprilimages.*, cscart_aprilimages_links.*, cscart_aprilcommon_descriptions.description AS alt, cscart_aprilimages.image_id AS images_image_id FROM cscart_aprilimages_links LEFT JOIN cscart_aprilimages ON cscart_aprilimages_links.detailed_id = cscart_aprilimages.image_id LEFT JOIN cscart_aprilcommon_descriptions ON cscart_aprilcommon_descriptions.object_id = cscart_aprilimages.image_id AND cscart_aprilcommon_descriptions.object_holder = 'images' AND cscart_aprilcommon_descriptions.lang_code = 'en' WHERE cscart_aprilimages_links.object_type = 'product_option' AND cscart_aprilimages_links.type = 'M' AND cscart_aprilimages_links.object_id = '1267114885' ORDER BY cscart_aprilimages_links.position, cscart_aprilimages_links.pair_id
1 0.00035 0.00035 0.00035
SELECT option_type as type, option_id FROM cscart_aprilproduct_options WHERE option_id IN (20, 25)
1 0.00013 0.00013 0.00013
SELECT a.modifier, a.modifier_type, a.variant_id FROM cscart_aprilproduct_option_variants a  WHERE 1 AND a.variant_id IN (180, 152)
1 0.00011 0.00011 0.00011
SELECT default_view, selected_views FROM cscart_aprilcategories WHERE category_id = 166
1 0.00011 0.00011 0.00011
SELECT privilege FROM cscart_aprilusergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00031 0.00031 0.00031
SELECT c.* FROM cscart_aprilbm_containers as c  WHERE 1  AND c.location_id = 6 AND c.company_id = 0
1 0.00046 0.00046 0.00046
SELECT layout_id FROM cscart_aprilbm_locations WHERE location_id = 6
1 0.00010 0.00010 0.00010
SELECT c.*, IF (c.location_id != 6, 0, 1) as `default` FROM cscart_aprilbm_containers as c  INNER JOIN cscart_aprilbm_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.00021 0.00021 0.00021
SELECT * FROM cscart_aprilbm_containers as c LEFT JOIN cscart_aprilbm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 23, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00035 0.00035 0.00035
SELECT cscart_aprilbm_snapping.grid_id as grid_id,cscart_aprilbm_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_aprilbm_block_statuses.object_ids as object_ids,cscart_aprilbm_snapping.*,cscart_aprilbm_blocks.*,cscart_aprilbm_blocks_descriptions.* FROM cscart_aprilbm_snapping LEFT JOIN cscart_aprilbm_blocks ON cscart_aprilbm_blocks.block_id = cscart_aprilbm_snapping.block_id LEFT JOIN cscart_aprilbm_block_statuses ON cscart_aprilbm_snapping.snapping_id = cscart_aprilbm_block_statuses.snapping_id AND cscart_aprilbm_block_statuses.object_type LIKE 'categories' LEFT JOIN cscart_aprilbm_blocks_descriptions ON cscart_aprilbm_blocks.block_id = cscart_aprilbm_blocks_descriptions.block_id  LEFT JOIN cscart_aprilbm_blocks_content AS default_content ON cscart_aprilbm_blocks.block_id = default_content.block_id AND cscart_aprilbm_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_aprilbm_blocks_content AS dynamic_object_content ON cscart_aprilbm_blocks.block_id = dynamic_object_content.block_id AND cscart_aprilbm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 166 AND dynamic_object_content.object_type like 'categories' WHERE cscart_aprilbm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 42, 43, 44)  AND cscart_aprilbm_blocks_descriptions.lang_code='en'  ORDER BY cscart_aprilbm_snapping.order, cscart_aprilbm_snapping.block_id 
1 0.00108 0.00108 0.00108
SELECT name, path FROM cscart_aprilseo_names WHERE `object_id` = 15 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00048 0.00048 0.00048
SELECT name, path FROM cscart_aprilseo_names WHERE `object_id` = 20 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00021 0.00021 0.00021
SELECT data FROM cscart_aprilstorage_data WHERE data_key = 'restrictions'
1 0.00035 0.00035 0.00035