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

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_redirect_to_regional_storefront() /var/www/webmarco/app/functions/fn.init.php:1227
  • Tygh\Storefront\Repository::findByUrl() /var/www/webmarco/app/functions/fn.init.php:1451
  • Tygh\Storefront\Repository::find() /var/www/webmarco/app/Tygh/Storefront/Repository.php:126
  • fn_set_hook() /var/www/webmarco/app/Tygh/Storefront/Repository.php:313
  • fn_mve_storefront_repository_find_pre() /var/www/webmarco/app/functions/fn.control.php:104
  • fn_allowed_for() /var/www/webmarco/app/functions/fn.multivendor.php:2078
  • fn_get_storage_data() /var/www/webmarco/app/functions/fn.control.php:985
  • db_get_row() /var/www/webmarco/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00029 Re-run Backtrace
2
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev-webmarco.com' OR storefronts.url = 'www.dev-webmarco.com' OR storefronts.url LIKE 'www_.dev-webmarco.com' OR storefronts.url LIKE 'dev-webmarco.com/%' OR storefronts.url LIKE 'www.dev-webmarco.com/%' OR storefronts.url LIKE 'www_.dev-webmarco.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev-webmarco.com' DESC, storefronts.url = 'www.dev-webmarco.com' DESC, storefronts.url LIKE 'www_.dev-webmarco.com' DESC, storefronts.url LIKE 'dev-webmarco.com/%' DESC, storefronts.url LIKE 'www.dev-webmarco.com/%' DESC, storefronts.url LIKE 'www_.dev-webmarco.com/%' desc 

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_redirect_to_regional_storefront() /var/www/webmarco/app/functions/fn.init.php:1227
  • Tygh\Storefront\Repository::findByUrl() /var/www/webmarco/app/functions/fn.init.php:1451
  • Tygh\Storefront\Repository::find() /var/www/webmarco/app/Tygh/Storefront/Repository.php:126
  • Tygh\Database\Connection::getHash() /var/www/webmarco/app/Tygh/Storefront/Repository.php:370
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:370
0.00047 Re-run Backtrace
3
SET time_zone = '+02:00'

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_settings() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_init_time_zone() /var/www/webmarco/app/functions/fn.init.php:1057
  • db_query() /var/www/webmarco/app/functions/fn.init.php:1078
  • Tygh\Database\Connection::query() /var/www/webmarco/app/functions/fn.database.php:138
0.00010 Re-run Backtrace
4
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • Tygh\Languages\Languages::getSimpleLanguages() /var/www/webmarco/app/addons/seo/func.php:564
  • db_get_hash_single_array() /var/www/webmarco/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /var/www/webmarco/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:571
0.00046 Re-run Backtrace
5
SELECT type FROM cscart_seo_names WHERE name = 'wishlist-view' 

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • db_get_field() /var/www/webmarco/app/addons/seo/func.php:662
  • Tygh\Database\Connection::getField() /var/www/webmarco/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:447
0.00073 Re-run Backtrace
6
SELECT * FROM cscart_seo_names WHERE name = 'wishlist-view'  

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • db_get_array() /var/www/webmarco/app/addons/seo/func.php:666
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00027 Re-run Backtrace
7
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_seo_validate_object() /var/www/webmarco/app/addons/seo/func.php:705
  • Tygh\Languages\Languages::getSimpleLanguages() /var/www/webmarco/app/addons/seo/func.php:1091
  • db_get_hash_single_array() /var/www/webmarco/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /var/www/webmarco/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:571
0.00022 Re-run Backtrace
8
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_get_corrected_seo_lang_code() /var/www/webmarco/app/addons/seo/func.php:729
  • fn_seo_get_default_storefront_lang_code() /var/www/webmarco/app/addons/seo/func.php:437
  • Tygh\Storefront\Repository::findDefault() /var/www/webmarco/app/addons/seo/func.php:456
  • Tygh\Storefront\Repository::find() /var/www/webmarco/app/Tygh/Storefront/Repository.php:188
  • Tygh\Database\Connection::getHash() /var/www/webmarco/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:370
0.00037 Re-run Backtrace
9
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 0 AND `type` = 's' AND `dispatch` = 'wishlist.view' AND `lang_code` = 'en' 

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_url() /var/www/webmarco/app/addons/seo/func.php:820
  • fn_set_hook() /var/www/webmarco/app/functions/fn.common.php:3948
  • fn_seo_url_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/webmarco/app/addons/seo/func.php:1609
  • db_get_row() /var/www/webmarco/app/addons/seo/func.php:1337
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00091 Re-run Backtrace
10
SELECT default_langsf FROM cscart_storefronts  WHERE storefront_id = 1

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_language() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.init.php:280
  • fn_default_language_init_language_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_default_language_get_default_languagest() /var/www/webmarco/app/addons/default_language/func.php:21
  • db_get_field() /var/www/webmarco/app/addons/default_language/func.php:8
  • Tygh\Database\Connection::getField() /var/www/webmarco/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:447
0.00017 Re-run Backtrace
11
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_layout() /var/www/webmarco/app/functions/fn.init.php:1227
  • Tygh\BlockManager\Layout::getDefault() /var/www/webmarco/app/functions/fn.init.php:673
  • db_get_row() /var/www/webmarco/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00027 Re-run Backtrace
12
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_user() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_login_user() /var/www/webmarco/app/functions/fn.init.php:744
  • fn_init_user() /var/www/webmarco/app/functions/fn.users.php:3509
  • fn_is_expired_storage_data() /var/www/webmarco/app/functions/fn.init.php:776
  • fn_get_storage_data() /var/www/webmarco/app/functions/fn.control.php:1085
  • db_get_row() /var/www/webmarco/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00035 Re-run Backtrace
13
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_templater() /var/www/webmarco/app/functions/fn.init.php:1227
  • Tygh\Development::isEnabled() /var/www/webmarco/app/functions/fn.init.php:124
  • Tygh\Development::read() /var/www/webmarco/app/Tygh/Development.php:28
  • fn_get_storage_data() /var/www/webmarco/app/Tygh/Development.php:81
  • db_get_row() /var/www/webmarco/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00021 Re-run Backtrace
14
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' 

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:439
  • fn_abt__unitheme2_dispatch_assign_template() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_get_abt__ut2_settings() /var/www/webmarco/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:24
  • db_get_array() /var/www/webmarco/app/addons/abt__unitheme2/functions/fn.abt__ut2_settings.php:124
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00053 Re-run Backtrace
15
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1928

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::instance() /var/www/webmarco/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /var/www/webmarco/app/Tygh/BlockManager/Location.php:476
  • db_get_row() /var/www/webmarco/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00024 Re-run Backtrace
16
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 = 1928  AND l.dispatch IN ('wishlist.view')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /var/www/webmarco/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /var/www/webmarco/app/Tygh/BlockManager/Location.php:166
  • db_get_hash_array() /var/www/webmarco/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /var/www/webmarco/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:370
0.04501 Re-run Backtrace
17
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • fn_get_storage_data() /var/www/webmarco/app/controllers/frontend/init.php:146
  • db_get_row() /var/www/webmarco/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00032 Re-run Backtrace
18
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • Tygh\Settings::instance() /var/www/webmarco/app/addons/cp_power_blog/controllers/frontend/init.post.php:29
  • Tygh\Settings::normalizeInstanceParameters() /var/www/webmarco/app/Tygh/Settings.php:163
  • Tygh\Storefront\Repository::getCount() /var/www/webmarco/app/Tygh/Settings.php:243
  • Tygh\Database\Connection::getField() /var/www/webmarco/app/Tygh/Storefront/Repository.php:435
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:447
0.00035 Re-run Backtrace
19
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • Tygh\Settings::instance() /var/www/webmarco/app/addons/cp_power_blog/controllers/frontend/init.post.php:29
  • Tygh\Settings::reloadSections() /var/www/webmarco/app/Tygh/Settings.php:172
  • Tygh\Settings::getSections() /var/www/webmarco/app/Tygh/Settings.php:141
  • Tygh\Database\Connection::getHash() /var/www/webmarco/app/Tygh/Settings.php:487
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:370
0.00079 Re-run Backtrace
20
SELECT * FROM cscart_settings_sections WHERE name = 'cp_power_blog' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type))

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • Tygh\Settings::getValues() /var/www/webmarco/app/addons/cp_power_blog/controllers/frontend/init.post.php:29
  • Tygh\Settings::getSectionByName() /var/www/webmarco/app/Tygh/Settings.php:790
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/Tygh/Settings.php:406
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00031 Re-run Backtrace
21
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND section_id = 558 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • Tygh\Settings::getValues() /var/www/webmarco/app/addons/cp_power_blog/controllers/frontend/init.post.php:29
  • Tygh\Settings::getPlainList() /var/www/webmarco/app/Tygh/Settings.php:805
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00070 Re-run Backtrace
22
SELECT a.usergroup_id, a.status, a.type, b.usergroup, a.use_as_user_type, a.need_activate_user, a.notice_email, a.position FROM cscart_usergroups as a LEFT JOIN cscart_usergroup_descriptions as b ON b.usergroup_id = a.usergroup_id AND b.lang_code = 'en'  WHERE 1  AND a.status = 'A' AND a.type IN ('A', 'C', 'V') AND a.use_as_user_type = 'Y'  ORDER BY position 

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • fn_get_usergroups() /var/www/webmarco/app/addons/ecl_legal_users/controllers/frontend/init.post.php:16
  • db_get_hash_array() /var/www/webmarco/app/functions/fn.users.php:512
  • Tygh\Database\Connection::getHash() /var/www/webmarco/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:370
0.00037 Re-run Backtrace
23
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'wk_order_confirm_data_tpl_data' 

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • fn_wk_order_delivery_confirmation_request() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/controllers/frontend/init.post.php:6
  • fn_wk_order_delivery_confirmation_get_setting_data() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:23
  • Tygh\Settings::getValue() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:11
  • Tygh\Settings::getId() /var/www/webmarco/app/Tygh/Settings.php:871
  • Tygh\Database\Connection::getField() /var/www/webmarco/app/Tygh/Settings.php:968
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:447
0.00022 Re-run Backtrace
24
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 6508 ORDER BY cscart_settings_objects.position

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • fn_wk_order_delivery_confirmation_request() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/controllers/frontend/init.post.php:6
  • fn_wk_order_delivery_confirmation_get_setting_data() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:23
  • Tygh\Settings::getValue() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:11
  • Tygh\Settings::getPlainList() /var/www/webmarco/app/Tygh/Settings.php:874
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00031 Re-run Backtrace
25
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • fn_wk_order_delivery_confirmation_request() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/controllers/frontend/init.post.php:6
  • db_get_array() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:34
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00028 Re-run Backtrace
26
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • db_get_array() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/controllers/frontend/init.post.php:8
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00016 Re-run Backtrace
27
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_check_permissions() /var/www/webmarco/app/functions/fn.control.php:517
  • fn_check_admin_permissions() /var/www/webmarco/app/functions/fn.common.php:2546
  • db_get_fields() /var/www/webmarco/app/functions/fn.common.php:2728
  • Tygh\Database\Connection::getColumn() /var/www/webmarco/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:479
0.00033 Re-run Backtrace
28
SELECT cscart_profile_field_values.value_id, cscart_profile_field_descriptions.description FROM cscart_profile_field_values LEFT JOIN cscart_profile_field_descriptions ON cscart_profile_field_values.value_id = cscart_profile_field_descriptions.object_id WHERE cscart_profile_field_descriptions.lang_code = 'en' AND cscart_profile_field_descriptions.	object_type  = 'V' AND cscart_profile_field_values.field_id = 62

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/webmarco/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/webmarco/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c85ee57d36_78182531() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /var/www/webmarco/var/cache/templates/vivashop/62ef1b660e00ee757ff29c728d8df0587b71adfb_2.tygh.index.tpl.php:235
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c85ff01569_38375419() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /var/www/webmarco/var/cache/templates/vivashop/a9ab09f4f954287320deadb13894fa5d3d888cbe_2.tygh.scripts.tpl.php:654
  • Smarty_Internal_TemplateBase::fetch() /var/www/webmarco/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c86032ffc3_15948802() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_ec_category_filter_get_mapped_category_info() /var/www/webmarco/var/cache/templates/vivashop/cdc5493b1dbab86dd5ddd410da9e2608222f8bd8_2.tygh.scripts.post.tpl.php:76
  • db_get_hash_single_array() /var/www/webmarco/app/addons/ec_vendor_filter/func.php:167
  • Tygh\Database\Connection::getSingleHash() /var/www/webmarco/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:571
0.00071 Re-run Backtrace
29
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/webmarco/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/webmarco/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c85ee57d36_78182531() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /var/www/webmarco/var/cache/templates/vivashop/62ef1b660e00ee757ff29c728d8df0587b71adfb_2.tygh.index.tpl.php:235
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c85ff01569_38375419() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /var/www/webmarco/var/cache/templates/vivashop/a9ab09f4f954287320deadb13894fa5d3d888cbe_2.tygh.scripts.tpl.php:654
  • Smarty_Internal_TemplateBase::fetch() /var/www/webmarco/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c86032ffc3_15948802() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_ec_category_filter_get_mapped_category_info() /var/www/webmarco/var/cache/templates/vivashop/cdc5493b1dbab86dd5ddd410da9e2608222f8bd8_2.tygh.scripts.post.tpl.php:76
  • db_get_hash_single_array() /var/www/webmarco/app/addons/ec_vendor_filter/func.php:169
  • Tygh\Database\Connection::getSingleHash() /var/www/webmarco/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:571
0.00015 Re-run Backtrace
30
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • Tygh\Application::offsetGet() /var/www/webmarco/app/functions/fn.control.php:648
  • Pimple\Container::offsetGet() /var/www/webmarco/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /var/www/webmarco/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • fn_get_storage_data() /var/www/webmarco/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /var/www/webmarco/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00026 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
2 0.00022 0.00046 0.00034
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00029 0.00029 0.00029
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00035 0.00035 0.00035
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
1 0.00015 0.00015 0.00015
SELECT cscart_profile_field_values.value_id, cscart_profile_field_descriptions.description FROM cscart_profile_field_values LEFT JOIN cscart_profile_field_descriptions ON cscart_profile_field_values.value_id = cscart_profile_field_descriptions.object_id WHERE cscart_profile_field_descriptions.lang_code = 'en' AND cscart_profile_field_descriptions.	object_type  = 'V' AND cscart_profile_field_values.field_id = 62
1 0.00071 0.00071 0.00071
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00033 0.00033 0.00033
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
1 0.00016 0.00016 0.00016
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0
1 0.00028 0.00028 0.00028
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 6508 ORDER BY cscart_settings_objects.position
1 0.00031 0.00031 0.00031
SELECT object_id FROM cscart_settings_objects LEFT JOIN cscart_settings_sections ON cscart_settings_objects.section_id = cscart_settings_sections.section_id WHERE cscart_settings_objects.name = 'wk_order_confirm_data_tpl_data' 
1 0.00022 0.00022 0.00022
SELECT a.usergroup_id, a.status, a.type, b.usergroup, a.use_as_user_type, a.need_activate_user, a.notice_email, a.position FROM cscart_usergroups as a LEFT JOIN cscart_usergroup_descriptions as b ON b.usergroup_id = a.usergroup_id AND b.lang_code = 'en'  WHERE 1  AND a.status = 'A' AND a.type IN ('A', 'C', 'V') AND a.use_as_user_type = 'Y'  ORDER BY position 
1 0.00037 0.00037 0.00037
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND section_id = 558 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
1 0.00070 0.00070 0.00070
SELECT * FROM cscart_settings_sections WHERE name = 'cp_power_blog' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type))
1 0.00031 0.00031 0.00031
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
1 0.00079 0.00079 0.00079
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 = 1928  AND l.dispatch IN ('wishlist.view')  ORDER BY l.object_ids desc  LIMIT 1
1 0.04501 0.04501 0.04501
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00032 0.00032 0.00032
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev-webmarco.com' OR storefronts.url = 'www.dev-webmarco.com' OR storefronts.url LIKE 'www_.dev-webmarco.com' OR storefronts.url LIKE 'dev-webmarco.com/%' OR storefronts.url LIKE 'www.dev-webmarco.com/%' OR storefronts.url LIKE 'www_.dev-webmarco.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev-webmarco.com' DESC, storefronts.url = 'www.dev-webmarco.com' DESC, storefronts.url LIKE 'www_.dev-webmarco.com' DESC, storefronts.url LIKE 'dev-webmarco.com/%' DESC, storefronts.url LIKE 'www.dev-webmarco.com/%' DESC, storefronts.url LIKE 'www_.dev-webmarco.com/%' desc 
1 0.00047 0.00047 0.00047
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1928
1 0.00024 0.00024 0.00024
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' 
1 0.00053 0.00053 0.00053
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00021 0.00021 0.00021
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00035 0.00035 0.00035
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
1 0.00027 0.00027 0.00027
SELECT default_langsf FROM cscart_storefronts  WHERE storefront_id = 1
1 0.00017 0.00017 0.00017
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 0 AND `type` = 's' AND `dispatch` = 'wishlist.view' AND `lang_code` = 'en' 
1 0.00091 0.00091 0.00091
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.is_default IN ('Y') GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00037 0.00037 0.00037
SELECT * FROM cscart_seo_names WHERE name = 'wishlist-view'  
1 0.00027 0.00027 0.00027
SELECT type FROM cscart_seo_names WHERE name = 'wishlist-view' 
1 0.00073 0.00073 0.00073
SET time_zone = '+02:00'
1 0.00010 0.00010 0.00010
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00026 0.00026 0.00026