Queries total time: 0.03403 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.00036 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:983
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1058
  • 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
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.00011 Re-run Backtrace
4
SELECT type FROM cscart_seo_names WHERE name = 'publicprofile' 

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_get_route() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:839
  • fn_seo_get_route() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • db_get_field() /home/alpha/live/multivendor/app/addons/seo/func.php:652
  • 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.00026 Re-run Backtrace
5
SELECT * FROM cscart_seo_names WHERE name = 'publicprofile'  

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_get_route() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:839
  • fn_seo_get_route() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • db_get_array() /home/alpha/live/multivendor/app/addons/seo/func.php:656
  • 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.00024 Re-run Backtrace
6
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

  • require() /home/alpha/live/multivendor/index.php:24
  • fn_init() /home/alpha/live/multivendor/init.php:179
  • fn_get_route() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:839
  • fn_seo_get_route() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_seo_validate_object() /home/alpha/live/multivendor/app/addons/seo/func.php:695
  • Tygh\Languages\Languages::getSimpleLanguages() /home/alpha/live/multivendor/app/addons/seo/func.php:1049
  • db_get_hash_single_array() /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:519
  • Tygh\Database\Connection::getSingleHash() /home/alpha/live/multivendor/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546
0.00017 Re-run Backtrace
7
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_get_route() /home/alpha/live/multivendor/app/functions/fn.init.php:1201
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.control.php:839
  • fn_seo_get_route() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_url() /home/alpha/live/multivendor/app/addons/seo/func.php:781
  • fn_set_hook() /home/alpha/live/multivendor/app/functions/fn.common.php:3914
  • fn_seo_url_post() /home/alpha/live/multivendor/app/functions/fn.control.php:123
  • fn_get_seo_settings() /home/alpha/live/multivendor/app/addons/seo/func.php:1452
  • Tygh\Application::offsetGet() /home/alpha/live/multivendor/app/addons/seo/func.php:2167
  • 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.00020 Re-run Backtrace
8
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.00021 Re-run Backtrace
9
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
10
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:1076
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.control.php:1058
  • 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.00016 Re-run Backtrace
11
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:1058
  • 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.00016 Re-run Backtrace
12
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:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • 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.00018 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 ('publicprofile.profiles')  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:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • 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.00129 Re-run Backtrace
14
SELECT loader FROM cscart_preloader_setting WHERE loader

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:7
  • 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.00017 Re-run Backtrace
15
SELECT size_loader FROM cscart_preloader_setting WHERE size_loader

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:10
  • 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.00015 Re-run Backtrace
16
SELECT on_preloader FROM cscart_preloader_setting WHERE on_preloader

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:12
  • 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.00015 Re-run Backtrace
17
SELECT speed_preloader FROM cscart_preloader_setting WHERE speed_preloader

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:14
  • 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.00015 Re-run Backtrace
18
SELECT location_preloader FROM cscart_preloader_setting

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:17
  • 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.00013 Re-run Backtrace
19
SELECT on_click FROM cscart_preloader_setting WHERE on_click

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:20
  • 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.00014 Re-run Backtrace
20
SELECT choose_preloader FROM cscart_preloader_setting WHERE choose_preloader

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:22
  • 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.00013 Re-run Backtrace
21
SELECT choose_bg FROM cscart_preloader_setting WHERE choose_bg

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:24
  • 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.00013 Re-run Backtrace
22
SELECT color FROM cscart_preloader_setting

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:26
  • 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.00013 Re-run Backtrace
23
SELECT progress_bar FROM cscart_preloader_setting WHERE progress_bar

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/Preloader/controllers/frontend/init.post.php:28
  • 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.00014 Re-run Backtrace
24
SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='99'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • get_user_profile_pic() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:14
  • db_get_array() /home/alpha/live/multivendor/app/addons/my_changes/func.php:776
  • 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.00018 Re-run Backtrace
25
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=99

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • fn_get_user_image() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:18
  • db_get_array() /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:441
  • 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.00023 Re-run Backtrace
26
SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 99

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • fn_kl_perfect_match_quiz_get_user_expertise() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:20
  • db_get_field() /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:530
  • 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.00024 Re-run Backtrace
27
SELECT target_id FROM kl_likes WHERE user_id = 99 and type= 'Video_Video'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_fields() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:37
  • 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.00046 Re-run Backtrace
28
SELECT COUNT(DISTINCT(cv.video_id)) FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.video_id IN (194, 196, 494, 468, 514) AND cv.status='A'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • fn_cp_videos_get_cscart_videos_data() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41
  • db_get_field() /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1915
  • 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.00506 Re-run Backtrace
29
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE
       WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != ''
       THEN CONCAT('https://cdn.kindlife.in/',  MAX(mum.avatar))
       ELSE 'https://cdn.kindlife.in/images/ui_icon/female-default-icon.svg'
       END AS userAvatar, GROUP_CONCAT(DISTINCT cvpl.product_id ORDER BY cvpl.product_id ASC SEPARATOR ', ') as products, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.video_id IN (194, 196, 494, 468, 514) AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC  LIMIT 0, 5

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • fn_cp_videos_get_cscart_videos_data() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41
  • db_get_hash_array() /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1920
  • 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.00543 Re-run Backtrace
30
SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 99 and status= 'A'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • fn_run_controller() /home/alpha/live/multivendor/app/functions/fn.control.php:464
  • include() /home/alpha/live/multivendor/app/functions/fn.control.php:725
  • db_get_field() /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:45
  • 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.00048 Re-run Backtrace
31
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:521
  • fn_check_admin_permissions() /home/alpha/live/multivendor/app/functions/fn.common.php:2508
  • db_get_fields() /home/alpha/live/multivendor/app/functions/fn.common.php:2687
  • 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.00021 Re-run Backtrace
32
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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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_682c780cb92621_47923995() /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:1058
  • 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
33
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 420 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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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.00027 Re-run Backtrace
34
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 420

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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.00016 Re-run Backtrace
35
SELECT c.*, IF (c.location_id != 420, 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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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.00129 Re-run Backtrace
36
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, 1680, 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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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.00050 Re-run Backtrace
37
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, 2183, 5882, 2192, 5883, 2188, 5884, 2440, 2189, 5885, 2190, 2648, 2187, 2191, 2193, 2194, 2195, 2196, 2791, 2792, 2793)  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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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.00183 Re-run Backtrace
38
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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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:2435
  • 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.00032 Re-run Backtrace
39
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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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:2435
  • 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.00026 Re-run Backtrace
40
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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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:2435
  • 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.00026 Re-run Backtrace
41
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:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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:2435
  • 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.00029 Re-run Backtrace
42
SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users  WHERE  user_id = 99 AND status = 'A' 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369
  • 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::renderBlock() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c8250456ec5_76759251() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_user_short_info() /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:726
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.users.php:155
  • 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.00022 Re-run Backtrace
43
SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users  WHERE  user_id = 99 AND status = 'A' 

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369
  • 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::renderBlock() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819
  • fn_get_public_wishlist_data()
  • fn_get_user_short_info() /home/alpha/live/multivendor/app/addons/my_changes/func.php:3511
  • db_get_row() /home/alpha/live/multivendor/app/functions/fn.users.php:155
  • 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.00046 Re-run Backtrace
44
SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='62827'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369
  • 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::renderBlock() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819
  • kl_get_mixed_content()
  • get_user_profile_pic() /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:371
  • db_get_array() /home/alpha/live/multivendor/app/addons/my_changes/func.php:776
  • 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.00026 Re-run Backtrace
45
SELECT COUNT(DISTINCT(cv.video_id)) FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.user_id = 99 AND cv.status='A'

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369
  • 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::renderBlock() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819
  • kl_get_mixed_content()
  • fn_cp_videos_get_cscart_videos_data() /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:379
  • db_get_field() /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1915
  • 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.00483 Re-run Backtrace
46
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE
       WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != ''
       THEN CONCAT('https://cdn.kindlife.in/',  MAX(mum.avatar))
       ELSE 'https://cdn.kindlife.in/images/ui_icon/female-default-icon.svg'
       END AS userAvatar, GROUP_CONCAT(DISTINCT cvpl.product_id ORDER BY cvpl.product_id ASC SEPARATOR ', ') as products, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.user_id = 99 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC  LIMIT 0, 15

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:191
  • 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::renderGrids() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369
  • 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::renderBlock() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819
  • kl_get_mixed_content()
  • fn_cp_videos_get_cscart_videos_data() /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:379
  • db_get_hash_array() /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1920
  • 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.00485 Re-run Backtrace
47
SELECT a.code, b.country FROM cscart_countries as a LEFT JOIN cscart_country_descriptions as b ON b.code = a.code AND b.lang_code = 'en' WHERE a.status = 'A' ORDER BY b.country

    Backtrace

  • fn_dispatch() /home/alpha/live/multivendor/index.php:38
  • Tygh\SmartyEngine\Core::fetch() /home/alpha/live/multivendor/app/functions/fn.control.php:635
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81
  • content_682c780ca97d37_66411938() /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:202
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_682c78095c2394_42648407() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_hook() /home/alpha/live/multivendor/var/cache/templates/new_2bk/e6b59d3039938d183580c7b37db810122384b146.tygh.scripts.tpl.php:740
  • Smarty_Internal_TemplateBase::fetch() /home/alpha/live/multivendor/app/functions/smarty_plugins/block.hook.php:136
  • content_682c78096dda56_27151358() /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_cp_otp_get_avail_countries() /home/alpha/live/multivendor/var/cache/templates/new_2bk/aa175c085d15c75152373996d53f9fb4a67fb3e1.tygh.scripts.post.tpl.php:84
  • fn_get_simple_countries() /home/alpha/live/multivendor/app/addons/cp_otp_registration/func.php:642
  • db_get_hash_single_array() /home/alpha/live/multivendor/app/functions/fn.locations.php:132
  • Tygh\Database\Connection::getSingleHash() /home/alpha/live/multivendor/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546
0.00040 Re-run Backtrace
48
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:651
  • 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:1058
  • 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

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users  WHERE  user_id = 99 AND status = 'A' 
2 0.00022 0.00046 0.00034
SELECT * FROM cscart_profile_fields WHERE section="K" 
2 0.00026 0.00026 0.00026
SELECT * FROM cscart_profile_fields WHERE section="K" || field_id IN (6, 7)
2 0.00029 0.00032 0.00031
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.00036 0.00036 0.00036
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 420 AND c.company_id = 0
1 0.00027 0.00027 0.00027
SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 99
1 0.00024 0.00024 0.00024
SELECT target_id FROM kl_likes WHERE user_id = 99 and type= 'Video_Video'
1 0.00046 0.00046 0.00046
SELECT COUNT(DISTINCT(cv.video_id)) FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.video_id IN (194, 196, 494, 468, 514) AND cv.status='A'
1 0.00506 0.00506 0.00506
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE
       WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != ''
       THEN CONCAT('https://cdn.kindlife.in/',  MAX(mum.avatar))
       ELSE 'https://cdn.kindlife.in/images/ui_icon/female-default-icon.svg'
       END AS userAvatar, GROUP_CONCAT(DISTINCT cvpl.product_id ORDER BY cvpl.product_id ASC SEPARATOR ', ') as products, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.video_id IN (194, 196, 494, 468, 514) AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC  LIMIT 0, 5
1 0.00543 0.00543 0.00543
SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 99 and status= 'A'
1 0.00048 0.00048 0.00048
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00021 0.00021 0.00021
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00020 0.00020 0.00020
SELECT c.*, IF (c.location_id != 420, 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.00129 0.00129 0.00129
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 420
1 0.00016 0.00016 0.00016
SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='99'
1 0.00018 0.00018 0.00018
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, 1680, 1449) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00050 0.00050 0.00050
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, 2183, 5882, 2192, 5883, 2188, 5884, 2440, 2189, 5885, 2190, 2648, 2187, 2191, 2193, 2194, 2195, 2196, 2791, 2792, 2793)  AND cscart_bm_blocks_descriptions.lang_code='en'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00183 0.00183 0.00183
SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='62827'
1 0.00026 0.00026 0.00026
SELECT COUNT(DISTINCT(cv.video_id)) FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.user_id = 99 AND cv.status='A'
1 0.00483 0.00483 0.00483
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE
       WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != ''
       THEN CONCAT('https://cdn.kindlife.in/',  MAX(mum.avatar))
       ELSE 'https://cdn.kindlife.in/images/ui_icon/female-default-icon.svg'
       END AS userAvatar, GROUP_CONCAT(DISTINCT cvpl.product_id ORDER BY cvpl.product_id ASC SEPARATOR ', ') as products, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_cp_video_product_links cvpl ON cv.video_id = cvpl.video_id LEFT JOIN cscart_tag_links ctl ON ctl.object_id = cv.video_id LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id WHERE 1  AND cv.user_id = 99 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC  LIMIT 0, 15
1 0.00485 0.00485 0.00485
SELECT a.code, b.country FROM cscart_countries as a LEFT JOIN cscart_country_descriptions as b ON b.code = a.code AND b.lang_code = 'en' WHERE a.status = 'A' ORDER BY b.country
1 0.00040 0.00040 0.00040
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=99
1 0.00023 0.00023 0.00023
SELECT progress_bar FROM cscart_preloader_setting WHERE progress_bar
1 0.00014 0.00014 0.00014
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00020 0.00020 0.00020
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00016 0.00016 0.00016
SET time_zone = '+05:30'
1 0.00011 0.00011 0.00011
SELECT type FROM cscart_seo_names WHERE name = 'publicprofile' 
1 0.00026 0.00026 0.00026
SELECT * FROM cscart_seo_names WHERE name = 'publicprofile'  
1 0.00024 0.00024 0.00024
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00017 0.00017 0.00017
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.00020 0.00020 0.00020
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.00021 0.00021 0.00021
SELECT brand_id FROM cscart_users WHERE user_id = 0 
1 0.00019 0.00019 0.00019
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00016 0.00016 0.00016
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 10
1 0.00018 0.00018 0.00018
SELECT color FROM cscart_preloader_setting
1 0.00013 0.00013 0.00013
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 ('publicprofile.profiles')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00129 0.00129 0.00129
SELECT loader FROM cscart_preloader_setting WHERE loader
1 0.00017 0.00017 0.00017
SELECT size_loader FROM cscart_preloader_setting WHERE size_loader
1 0.00015 0.00015 0.00015
SELECT on_preloader FROM cscart_preloader_setting WHERE on_preloader
1 0.00015 0.00015 0.00015
SELECT speed_preloader FROM cscart_preloader_setting WHERE speed_preloader
1 0.00015 0.00015 0.00015
SELECT location_preloader FROM cscart_preloader_setting
1 0.00013 0.00013 0.00013
SELECT on_click FROM cscart_preloader_setting WHERE on_click
1 0.00014 0.00014 0.00014
SELECT choose_preloader FROM cscart_preloader_setting WHERE choose_preloader
1 0.00013 0.00013 0.00013
SELECT choose_bg FROM cscart_preloader_setting WHERE choose_bg
1 0.00013 0.00013 0.00013
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00017 0.00017 0.00017