Queries total time: 0.01819 s.
Query Time Actions
1
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev1-ecom.kindlife.in' OR storefronts.url = 'www.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev1-ecom.kindlife.in' DESC, storefronts.url = 'www.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%' desc 

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_redirect_to_regional_storefront() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • Tygh\Storefront\Repository::findByUrl() /home/alpha/live/multivendor/app/functions/fn.init.php:1426
  • Tygh\Storefront\Repository::find() /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:126
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:360
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00033 Re-run Backtrace
2
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_http_params_by_storefront() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_allowed_for() /home/alpha/live/multivendor/app/functions/fn.init.php:1582
  • fn_get_storage_data() /home/alpha/live/multivendor/app/functions/fn.control.php:980
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1055
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00017 Re-run Backtrace
3
SET time_zone = '+05:30'

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_settings() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_init_time_zone() /home/alpha/live/multivendor/app/functions/fn.init.php:1038
  • db_query() /home/alpha/live/multivendor/app/functions/fn.init.php:1059
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/functions/fn.database.php:138
0.00008 Re-run Backtrace
4
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_layout() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • Tygh\Application::offsetGet() /home/alpha/live/multivendor/app/functions/fn.init.php:634
  • Pimple\Container::offsetGet() /home/alpha/live/multivendor/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118
  • Tygh\Storefront\Repository::findById() /home/alpha/live/multivendor/app/Tygh/Providers/StorefrontProvider.php:186
  • Tygh\Storefront\Repository::find() /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:164
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:363
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00023 Re-run Backtrace
5
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'new_2bk' AND storefront_id = 1

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_layout() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • Tygh\BlockManager\Layout::getDefault() /home/alpha/live/multivendor/app/functions/fn.init.php:662
  • db_get_row() /home/alpha/live/multivendor/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00023 Re-run Backtrace
6
SELECT brand_id FROM cscart_users WHERE user_id = 0 

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_user() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_login_user() /home/alpha/live/multivendor/app/functions/fn.init.php:733
  • fn_fill_auth() /home/alpha/live/multivendor/app/functions/fn.users.php:3421
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.users.php:1381
  • fn_kl_vendro_dashboard_fill_auth() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_get_variantId_by_userId() /home/alpha/live/multivendor/app/addons/kl_vendro_dashboard/func.php:77
  • db_get_field() /home/alpha/live/multivendor/app/addons/kl_vendro_dashboard/func.php:32
  • Tygh\Database\Connection::getField() /home/alpha/live/multivendor/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422
0.00019 Re-run Backtrace
7
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_user() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_login_user() /home/alpha/live/multivendor/app/functions/fn.init.php:733
  • fn_init_user() /home/alpha/live/multivendor/app/functions/fn.users.php:3426
  • fn_is_expired_storage_data() /home/alpha/live/multivendor/app/functions/fn.init.php:765
  • fn_get_storage_data() /home/alpha/live/multivendor/app/functions/fn.control.php:1073
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1055
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00017 Re-run Backtrace
8
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_init_templater() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • Tygh\Development::isEnabled() /home/alpha/live/multivendor/app/functions/fn.init.php:116
  • Tygh\Development::read() /home/alpha/live/multivendor/app/Tygh/Development.php:28
  • fn_get_storage_data() /home/alpha/live/multivendor/app/Tygh/Development.php:81
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1055
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00017 Re-run Backtrace
9
SELECT * FROM cscart_languages WHERE status = 'A'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:442
  • fn_searchanise_dispatch_assign_template() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_se_check_import_is_done() /home/alpha/live/multivendor/app/addons/searchanise/func.php:80
  • fn_se_get_engines_data() /home/alpha/live/multivendor/app/addons/searchanise/func.php:1886
  • db_get_array() /home/alpha/live/multivendor/app/addons/searchanise/func.php:560
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00015 Re-run Backtrace
10
SELECT * FROM cscart_se_settings

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:442
  • fn_searchanise_dispatch_assign_template() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_se_check_import_is_done() /home/alpha/live/multivendor/app/addons/searchanise/func.php:80
  • fn_se_get_engines_data() /home/alpha/live/multivendor/app/addons/searchanise/func.php:1886
  • fn_se_get_api_key() /home/alpha/live/multivendor/app/addons/searchanise/func.php:613
  • fn_se_get_setting() /home/alpha/live/multivendor/app/addons/searchanise/func.php:237
  • fn_se_get_all_settings() /home/alpha/live/multivendor/app/addons/searchanise/func.php:167
  • db_get_array() /home/alpha/live/multivendor/app/addons/searchanise/func.php:152
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00017 Re-run Backtrace
11
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 10

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::instance() /home/alpha/live/multivendor/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:474
  • db_get_row() /home/alpha/live/multivendor/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00020 Re-run Backtrace
12
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch IN ('tags.view')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /home/alpha/live/multivendor/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:169
  • db_get_hash_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00171 Re-run Backtrace
13
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch IN ('tags')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /home/alpha/live/multivendor/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:169
  • db_get_hash_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00168 Re-run Backtrace
14
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.is_default = 1  ORDER BY l.is_default desc 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /home/alpha/live/multivendor/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getDefault() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:182
  • Tygh\BlockManager\Location::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:223
  • db_get_hash_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00168 Re-run Backtrace
15
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • fn_get_products() /home/alpha/live/multivendor/app/addons/tags/controllers/frontend/tags.php:41
  • Tygh\Storefront\Storefront::__call() /home/alpha/live/multivendor/app/functions/fn.products.php:1933
  • Tygh\Storefront\Storefront::getRelationValue() /home/alpha/live/multivendor/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /home/alpha/live/multivendor/app/Tygh/Storefront/Storefront.php:273
  • Tygh\Storefront\RelationsManager::getRelatedValues() /home/alpha/live/multivendor/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /home/alpha/live/multivendor/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:454
0.00019 Re-run Backtrace
16
SELECT COUNT(*) FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P'  INNER JOIN cscart_tag_links ON cscart_tag_links.object_id = products.product_id AND cscart_tag_links.object_type = 'P' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A' AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0)

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • fn_get_products() /home/alpha/live/multivendor/app/addons/tags/controllers/frontend/tags.php:41
  • Tygh\Database\Connection::getField() /home/alpha/live/multivendor/app/functions/fn.products.php:2367
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422
0.00087 Re-run Backtrace
17
SELECT products.product_id, descr1.product as product, companies.company as company_name, cscart_supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P'  INNER JOIN cscart_tag_links ON cscart_tag_links.object_id = products.product_id AND cscart_tag_links.object_type = 'P' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A' AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY cscart_product_sales.amount desc, products.product_id ASC  LIMIT 0, 24

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • fn_get_products() /home/alpha/live/multivendor/app/addons/tags/controllers/frontend/tags.php:41
  • {closure}() /home/alpha/live/multivendor/app/functions/fn.products.php:2367
  • db_get_array() /home/alpha/live/multivendor/app/functions/fn.products.php:2282
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00101 Re-run Backtrace
18
SELECT cscart_pages.*, cscart_page_descriptions.page, cscart_tag_links.*, cscart_tags.tag, cscart_tags.tag_id, cscart_tags.timestamp, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' INNER JOIN cscart_tag_links ON cscart_pages.page_id = cscart_tag_links.object_id AND cscart_tag_links.object_type = 'A' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE 1 AND cscart_pages.status IN ('A') AND cscart_pages.company_id IN (0, 13) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'P', 'G') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1768263979 AND (cscart_pages.avail_till_timestamp >= 1768263979 OR cscart_pages.avail_till_timestamp = 0))) AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A'   ORDER BY cscart_pages.position asc, cscart_page_descriptions.page asc 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • fn_get_pages() /home/alpha/live/multivendor/app/addons/tags/controllers/frontend/tags.php:62
  • db_get_hash_array() /home/alpha/live/multivendor/app/functions/fn.cms.php:334
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00057 Re-run Backtrace
19
SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.*, cscart_cp_video_category_links.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en'LEFT JOIN cscart_cp_video_category_links ON cscart_cp_videos.video_id = cscart_cp_video_category_links.video_id INNER JOIN cscart_tag_links ON cscart_tag_links.object_id = cscart_cp_videos.video_id AND cscart_tag_links.object_type = 'V' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  WHERE 1  AND cscart_cp_videos.status = 'A' AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A'  ORDER BY cscart_cp_videos.timestamp desc 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:461
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:722
  • fn_cp_get_videos() /home/alpha/live/multivendor/app/addons/cp_video_gallery/controllers/frontend/tags.post.php:27
  • db_get_hash_array() /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:958
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00042 Re-run Backtrace
20
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_check_permissions() /home/alpha/live/multivendor/app/functions/fn.control.php:518
  • fn_check_admin_permissions() /home/alpha/live/multivendor/app/functions/fn.common.php:2511
  • db_get_fields() /home/alpha/live/multivendor/app/functions/fn.common.php:2690
  • Tygh\Database\Connection::getColumn() /home/alpha/live/multivendor/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:454
0.00018 Re-run Backtrace
21
SELECT object_id FROM cscart_seo_redirects where src = '/index.php?dispatch=tags.view&tag=%23General+Wellness' AND type = 'p'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:623
  • fn_kl_easyinsights_dispatch_before_display() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_kl_easyinsights_get_product_id_by_seo() /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:252
  • db_get_field() /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:693
  • Tygh\Database\Connection::getField() /home/alpha/live/multivendor/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422
0.00021 Re-run Backtrace
22
SELECT vd.variant FROM cscart_product_feature_variant_descriptions vd INNER JOIN cscart_product_features_values pfv ON pfv.variant_id = vd.variant_id WHERE pfv.feature_id = 62 AND pfv.product_id = 0 AND vd.lang_code = 'en'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:623
  • fn_kl_easyinsights_dispatch_before_display() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_get_product_brand_name() /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:254
  • db_get_field() /home/alpha/live/multivendor/app/addons/my_changes/func.php:65
  • Tygh\Database\Connection::getField() /home/alpha/live/multivendor/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422
0.00030 Re-run Backtrace
23
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • Smarty_Internal_Template::getSubTemplate() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:132
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_6964e9100276c3_23449422() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_styles() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ce3d9e5f9c0c489c7e73be52d8048d88dc732574.tygh.styles.tpl.php:127
  • fn_get_storage_data() /home/alpha/live/multivendor/app/functions/smarty_plugins/block.styles.php:132
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1055
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00020 Re-run Backtrace
24
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 362 AND c.company_id = 0

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::__construct() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:129
  • Tygh\BlockManager\Container::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00032 Re-run Backtrace
25
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 362

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::__construct() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:129
  • Tygh\BlockManager\Container::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /home/alpha/live/multivendor/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422
0.00018 Re-run Backtrace
26
SELECT c.*, IF (c.location_id != 362, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::__construct() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:129
  • Tygh\BlockManager\Container::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/alpha/live/multivendor/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345
0.00201 Re-run Backtrace
27
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1446, 1447, 1448, 1449) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::__construct() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Grid::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:133
  • db_get_hash_multi_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Grid.php:63
  • Tygh\Database\Connection::getMultiHash() /home/alpha/live/multivendor/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:500
0.00056 Re-run Backtrace
28
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (2167, 2168, 2169, 2176, 2178, 2179, 2173, 2170, 2172, 2171, 2177, 2175, 2174, 2180, 2181, 2182, 2183, 2188, 2192, 2189, 2648, 2190, 2187, 2191, 2193, 2194, 2195, 2196)  AND cscart_bm_blocks_descriptions.lang_code='en'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::__construct() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Block::getList() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:137
  • db_get_hash_multi_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/Block.php:249
  • Tygh\Database\Connection::getMultiHash() /home/alpha/live/multivendor/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:500
0.00233 Re-run Backtrace
29
SELECT * FROM cscart_profile_fields WHERE section="K" || field_id IN (6, 7)

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::render() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410
  • Tygh\BlockManager\SchemesManager::getBlockScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461
  • Tygh\BlockManager\SchemesManager::_getScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136
  • fn_get_schema() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404
  • include() /home/alpha/live/multivendor/app/functions/fn.common.php:2436
  • fn_kl_personal_page_get_profile_field_variables() /home/alpha/live/multivendor/app/addons/kl_chat/schemas/block_manager/blocks.post.php:23
  • db_get_array() /home/alpha/live/multivendor/app/addons/kl_personal_page/func.php:23
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00039 Re-run Backtrace
30
SELECT * FROM cscart_profile_fields WHERE section="K" 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::render() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410
  • Tygh\BlockManager\SchemesManager::getBlockScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461
  • Tygh\BlockManager\SchemesManager::_getScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136
  • fn_get_schema() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404
  • include() /home/alpha/live/multivendor/app/functions/fn.common.php:2436
  • fn_kl_tips_get_block_active_profile_fileds() /home/alpha/live/multivendor/app/addons/kl_tips/schemas/block_manager/blocks.post.php:24
  • db_get_array() /home/alpha/live/multivendor/app/addons/kl_tips/func.php:62
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00035 Re-run Backtrace
31
SELECT * FROM cscart_profile_fields WHERE section="K" 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::render() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410
  • Tygh\BlockManager\SchemesManager::getBlockScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461
  • Tygh\BlockManager\SchemesManager::_getScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136
  • fn_get_schema() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404
  • include() /home/alpha/live/multivendor/app/functions/fn.common.php:2436
  • fn_kl_tips_get_block_active_profile_fileds() /home/alpha/live/multivendor/app/addons/kl_tips/schemas/block_manager/blocks.post.php:32
  • db_get_array() /home/alpha/live/multivendor/app/addons/kl_tips/func.php:62
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00036 Re-run Backtrace
32
SELECT * FROM cscart_profile_fields WHERE section="K" || field_id IN (6, 7)

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_6964e90fe32458_93311778() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193
  • Tygh\BlockManager\RenderManager::render() /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410
  • Tygh\BlockManager\SchemesManager::getBlockScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461
  • Tygh\BlockManager\SchemesManager::_getScheme() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136
  • fn_get_schema() /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404
  • include() /home/alpha/live/multivendor/app/functions/fn.common.php:2436
  • fn_kl_personal_page_get_profile_field_variables() /home/alpha/live/multivendor/app/addons/kl_personal_page/schemas/block_manager/blocks.post.php:439
  • db_get_array() /home/alpha/live/multivendor/app/addons/kl_personal_page/func.php:23
  • Tygh\Database\Connection::getArray() /home/alpha/live/multivendor/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307
0.00037 Re-run Backtrace
33
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\Application::offsetGet() /home/alpha/live/multivendor/app/functions/fn.control.php:648
  • Pimple\Container::offsetGet() /home/alpha/live/multivendor/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118
  • fn_get_storage_data() /home/alpha/live/multivendor/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1055
  • Tygh\Database\Connection::getRow() /home/alpha/live/multivendor/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388
0.00019 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_profile_fields WHERE section="K" 
2 0.00035 0.00036 0.00036
SELECT * FROM cscart_profile_fields WHERE section="K" || field_id IN (6, 7)
2 0.00037 0.00039 0.00038
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev1-ecom.kindlife.in' OR storefronts.url = 'www.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev1-ecom.kindlife.in' DESC, storefronts.url = 'www.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%' desc 
1 0.00033 0.00033 0.00033
SELECT products.product_id, descr1.product as product, companies.company as company_name, cscart_supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P'  INNER JOIN cscart_tag_links ON cscart_tag_links.object_id = products.product_id AND cscart_tag_links.object_type = 'P' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A' AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY cscart_product_sales.amount desc, products.product_id ASC  LIMIT 0, 24
1 0.00101 0.00101 0.00101
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (2167, 2168, 2169, 2176, 2178, 2179, 2173, 2170, 2172, 2171, 2177, 2175, 2174, 2180, 2181, 2182, 2183, 2188, 2192, 2189, 2648, 2190, 2187, 2191, 2193, 2194, 2195, 2196)  AND cscart_bm_blocks_descriptions.lang_code='en'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00233 0.00233 0.00233
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1446, 1447, 1448, 1449) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00056 0.00056 0.00056
SELECT c.*, IF (c.location_id != 362, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
1 0.00201 0.00201 0.00201
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 362
1 0.00018 0.00018 0.00018
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 362 AND c.company_id = 0
1 0.00032 0.00032 0.00032
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00020 0.00020 0.00020
SELECT vd.variant FROM cscart_product_feature_variant_descriptions vd INNER JOIN cscart_product_features_values pfv ON pfv.variant_id = vd.variant_id WHERE pfv.feature_id = 62 AND pfv.product_id = 0 AND vd.lang_code = 'en'
1 0.00030 0.00030 0.00030
SELECT object_id FROM cscart_seo_redirects where src = '/index.php?dispatch=tags.view&tag=%23General+Wellness' AND type = 'p'
1 0.00021 0.00021 0.00021
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00018 0.00018 0.00018
SELECT SQL_CALC_FOUND_ROWS cscart_cp_videos.*, cscart_cp_video_descriptions.*, cscart_cp_video_category_links.* FROM cscart_cp_videos LEFT JOIN cscart_cp_video_descriptions ON cscart_cp_videos.video_id = cscart_cp_video_descriptions.video_id AND cscart_cp_video_descriptions.lang_code = 'en'LEFT JOIN cscart_cp_video_category_links ON cscart_cp_videos.video_id = cscart_cp_video_category_links.video_id INNER JOIN cscart_tag_links ON cscart_tag_links.object_id = cscart_cp_videos.video_id AND cscart_tag_links.object_type = 'V' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  WHERE 1  AND cscart_cp_videos.status = 'A' AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A'  ORDER BY cscart_cp_videos.timestamp desc 
1 0.00042 0.00042 0.00042
SELECT cscart_pages.*, cscart_page_descriptions.page, cscart_tag_links.*, cscart_tags.tag, cscart_tags.tag_id, cscart_tags.timestamp, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'en' INNER JOIN cscart_tag_links ON cscart_pages.page_id = cscart_tag_links.object_id AND cscart_tag_links.object_type = 'A' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE 1 AND cscart_pages.status IN ('A') AND cscart_pages.company_id IN (0, 13) AND cscart_pages.page_type IN ('T', 'L', 'B', 'F', 'P', 'G') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1768263979 AND (cscart_pages.avail_till_timestamp >= 1768263979 OR cscart_pages.avail_till_timestamp = 0))) AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A'   ORDER BY cscart_pages.position asc, cscart_page_descriptions.page asc 
1 0.00057 0.00057 0.00057
SELECT COUNT(*) FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_supplier_links ON cscart_supplier_links.object_id = products.product_id AND cscart_supplier_links.object_type = 'P'  INNER JOIN cscart_tag_links ON cscart_tag_links.object_id = products.product_id AND cscart_tag_links.object_type = 'P' INNER JOIN cscart_tags ON cscart_tag_links.tag_id = cscart_tags.tag_id  LEFT JOIN cscart_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND (cscart_tags.tag = '#General Wellness') AND cscart_tags.status = 'A' AND products.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0)
1 0.00087 0.00087 0.00087
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00017 0.00017 0.00017
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00019 0.00019 0.00019
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.is_default = 1  ORDER BY l.is_default desc 
1 0.00168 0.00168 0.00168
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch IN ('tags')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00168 0.00168 0.00168
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch IN ('tags.view')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00171 0.00171 0.00171
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 10
1 0.00020 0.00020 0.00020
SELECT * FROM cscart_se_settings
1 0.00017 0.00017 0.00017
SELECT * FROM cscart_languages WHERE status = 'A'
1 0.00015 0.00015 0.00015
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00017 0.00017 0.00017
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00017 0.00017 0.00017
SELECT brand_id FROM cscart_users WHERE user_id = 0 
1 0.00019 0.00019 0.00019
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'new_2bk' AND storefront_id = 1
1 0.00023 0.00023 0.00023
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00023 0.00023 0.00023
SET time_zone = '+05:30'
1 0.00008 0.00008 0.00008
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00019 0.00019 0.00019