Queries total time: 0.09110 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.00025 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.00050 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.00016 Re-run Backtrace
4
SELECT type FROM cscart_seo_names WHERE name = 'mailboxe' 

    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.00844 Re-run Backtrace
5
SELECT * FROM cscart_seo_names WHERE name = 'mailboxe'  

    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.00045 Re-run Backtrace
6
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.00029 Re-run Backtrace
7
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('home-and-garden', 'decor') AND type = 'c' 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_seo_validate_object() /var/www/webmarco/app/addons/seo/func.php:705
  • fn_seo_validate_parents() /var/www/webmarco/app/addons/seo/func.php:1111
  • db_get_hash_single_array() /var/www/webmarco/app/addons/seo/func.php:1148
  • 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.00037 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.00041 Re-run Backtrace
9
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9595 AND `type` = 'c' AND `dispatch` = '' 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:1607
  • 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.00082 Re-run Backtrace
10
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2910 AND `type` = 'c' AND `dispatch` = '' 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_parent_items_path() /var/www/webmarco/app/addons/seo/func.php:1617
  • fn_seo_get_name() /var/www/webmarco/app/addons/seo/func.php:1197
  • 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.00025 Re-run Backtrace
11
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2916 AND `type` = 'c' AND `dispatch` = '' 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_parent_items_path() /var/www/webmarco/app/addons/seo/func.php:1617
  • fn_seo_get_name() /var/www/webmarco/app/addons/seo/func.php:1197
  • 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.00023 Re-run Backtrace
12
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.00016 Re-run Backtrace
13
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.00034 Re-run Backtrace
14
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.00038 Re-run Backtrace
15
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
16
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.00063 Re-run Backtrace
17
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.00057 Re-run Backtrace
18
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 ('categories.view') AND (FIND_IN_SET(9595, l.object_ids) OR l.object_ids = '')  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.05310 Re-run Backtrace
19
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.00038 Re-run Backtrace
20
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.00056 Re-run Backtrace
21
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.00111 Re-run Backtrace
22
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.00052 Re-run Backtrace
23
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.00122 Re-run Backtrace
24
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.00063 Re-run Backtrace
25
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.00039 Re-run Backtrace
26
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.00052 Re-run Backtrace
27
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.00032 Re-run Backtrace
28
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.00021 Re-run Backtrace
29
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 9595

    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_field() /var/www/webmarco/app/controllers/frontend/categories.php:38
  • 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.00025 Re-run Backtrace
30
SELECT category_id FROM cscart_categories WHERE category_id = 9595  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 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
  • db_get_field() /var/www/webmarco/app/controllers/frontend/categories.php:58
  • 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.00027 Re-run Backtrace
31
SELECT id_path FROM cscart_categories WHERE category_id = 9595

    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_subcategories() /var/www/webmarco/app/controllers/frontend/categories.php:74
  • fn_get_categories() /var/www/webmarco/app/functions/fn.categories.php:60
  • db_get_field() /var/www/webmarco/app/functions/fn.categories.php:350
  • 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
32
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (9595) AND cscart_categories.id_path LIKE '2910/2916/9595/%' AND cscart_categories.storefront_id IN (0, 1)   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

    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_subcategories() /var/www/webmarco/app/controllers/frontend/categories.php:74
  • fn_get_categories() /var/www/webmarco/app/functions/fn.categories.php:60
  • db_get_hash_array() /var/www/webmarco/app/functions/fn.categories.php:440
  • 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.00061 Re-run Backtrace
33
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 9595  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE cscart_categories.category_id = 9595 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))

    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_category_data() /var/www/webmarco/app/controllers/frontend/categories.php:77
  • db_get_row() /var/www/webmarco/app/functions/fn.categories.php:807
  • 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.00051 Re-run Backtrace
34
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '9595' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '9595' ORDER BY cscart_images_links.position, cscart_images_links.pair_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_category_data() /var/www/webmarco/app/controllers/frontend/categories.php:77
  • fn_get_image_pairs() /var/www/webmarco/app/functions/fn.categories.php:824
  • db_multi_query() /var/www/webmarco/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /var/www/webmarco/app/functions/fn.database.php:168
0.00062 Re-run Backtrace
35
SELECT * FROM  cscart_csc_product_code_generator WHERE 1  AND cscart_csc_product_code_generator.company_id=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_get_category_data() /var/www/webmarco/app/controllers/frontend/categories.php:77
  • fn_set_hook() /var/www/webmarco/app/functions/fn.categories.php:873
  • fn_csc_product_code_generator_get_category_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_cpcg_get_option_values() /var/www/webmarco/app/addons/csc_product_code_generator/func.php:192
  • db_get_hash_single_array() /var/www/webmarco/app/addons/csc_product_code_generator/func.php:46
  • 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.00801 Re-run Backtrace
36
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (9595)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    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_products() /var/www/webmarco/app/controllers/frontend/categories.php:115
  • db_get_fields() /var/www/webmarco/app/functions/fn.products.php:1919
  • 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.00266 Re-run Backtrace
37
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 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
  • fn_get_products() /var/www/webmarco/app/controllers/frontend/categories.php:115
  • Tygh\Storefront\Storefront::__call() /var/www/webmarco/app/functions/fn.products.php:1996
  • Tygh\Storefront\Storefront::getRelationValue() /var/www/webmarco/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /var/www/webmarco/app/Tygh/Storefront/Storefront.php:273
  • Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/webmarco/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /var/www/webmarco/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:479
0.00061 Re-run Backtrace
38
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, companies.ec_rfq_whatsapp_number, companies.ec_rfq_bht, companies.ec_rfq_phone_number, companies.ec_rfq_bhf, products.product_type, products.parent_product_id, cscart_ec_table_booking_system.booking_type as booking_type FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_ec_table_booking_system ON cscart_ec_table_booking_system.product_id = products.product_id  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (9595) AND companies.status IN ('A') AND products.company_id IN (1, 25, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 108, 109, 110, 111, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 200, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 263, 264, 266, 268, 269, 271, 272, 273, 276, 277, 278, 279, 280, 281, 282, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 387, 388, 389, 391, 392, 393, 394, 395, 396, 397, 398, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 439, 440, 443, 445, 447, 448, 449, 450, 451, 452, 454, 455, 457, 458, 459, 460, 461, 462, 463, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 476, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 501, 503, 504, 505, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 518, 519, 520, 522, 524, 525, 526, 527, 528, 531, 532, 533, 535, 537, 539, 540, 541, 542, 543, 545, 546, 547, 548, 549, 550, 551, 553, 554, 556, 557, 558, 559, 560, 561, 562, 563, 564, 566, 567, 568, 569, 575, 576, 577, 579, 580, 582, 583, 585, 586, 587, 588, 590, 591, 592, 593, 594, 595, 596, 597, 598, 600, 602, 603, 604, 606, 607, 609, 610, 611, 613, 618, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 639, 641, 642, 643, 644, 646, 647, 649, 655, 660, 661, 662, 663, 665, 668, 669, 670, 671, 672, 673, 674, 675, 676, 678, 679, 680, 681, 682, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 707, 719, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 GROUP BY products.product_id   ORDER BY popularity.total desc, products.product_id ASC  LIMIT 0, 100

    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_products() /var/www/webmarco/app/controllers/frontend/categories.php:115
  • {closure}() /var/www/webmarco/app/functions/fn.products.php:2430
  • db_get_array() /var/www/webmarco/app/functions/fn.products.php:2354
  • 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.00205 Re-run Backtrace
39
SELECT FOUND_ROWS()

    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_products() /var/www/webmarco/app/controllers/frontend/categories.php:115
  • {closure}() /var/www/webmarco/app/functions/fn.products.php:2430
  • db_get_found_rows() /var/www/webmarco/app/functions/fn.products.php:2357
  • Tygh\Database\Connection::getField() /var/www/webmarco/app/functions/fn.database.php:332
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:447
0.00012 Re-run Backtrace
40
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 9595

    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_products_layout() /var/www/webmarco/app/controllers/frontend/categories.php:137
  • db_get_row() /var/www/webmarco/app/functions/fn.products.php:2847
  • 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.00023 Re-run Backtrace
41
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (2910, 2916) AND lang_code = 'en'

    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_category_name() /var/www/webmarco/app/controllers/frontend/categories.php:153
  • db_get_hash_single_array() /var/www/webmarco/app/functions/fn.categories.php:904
  • 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.00028 Re-run Backtrace
42
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.00019 Re-run Backtrace
43
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.00072 Re-run Backtrace
44
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.00022 Re-run Backtrace
45
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.00018 Re-run Backtrace
Queries max count: 1
Query Count Min time Max time Average time
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00025 0.00025 0.00025
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '9595' ORDER BY cscart_images_links.position, cscart_images_links.pair_id;SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '9595' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00062 0.00062 0.00062
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.00052 0.00052 0.00052
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0
1 0.00032 0.00032 0.00032
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
1 0.00021 0.00021 0.00021
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 9595
1 0.00025 0.00025 0.00025
SELECT category_id FROM cscart_categories WHERE category_id = 9595  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)
1 0.00027 0.00027 0.00027
SELECT id_path FROM cscart_categories WHERE category_id = 9595
1 0.00017 0.00017 0.00017
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (9595) AND cscart_categories.id_path LIKE '2910/2916/9595/%' AND cscart_categories.storefront_id IN (0, 1)   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00061 0.00061 0.00061
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'en'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 9595  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE cscart_categories.category_id = 9595 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))
1 0.00051 0.00051 0.00051
SELECT * FROM  cscart_csc_product_code_generator WHERE 1  AND cscart_csc_product_code_generator.company_id=0
1 0.00801 0.00801 0.00801
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.00063 0.00063 0.00063
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (9595)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
1 0.00266 0.00266 0.00266
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00061 0.00061 0.00061
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, companies.ec_rfq_whatsapp_number, companies.ec_rfq_bht, companies.ec_rfq_phone_number, companies.ec_rfq_bhf, products.product_type, products.parent_product_id, cscart_ec_table_booking_system.booking_type as booking_type FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN cscart_ec_table_booking_system ON cscart_ec_table_booking_system.product_id = products.product_id  LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (9595) AND companies.status IN ('A') AND products.company_id IN (1, 25, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 108, 109, 110, 111, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 200, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 263, 264, 266, 268, 269, 271, 272, 273, 276, 277, 278, 279, 280, 281, 282, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 387, 388, 389, 391, 392, 393, 394, 395, 396, 397, 398, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 439, 440, 443, 445, 447, 448, 449, 450, 451, 452, 454, 455, 457, 458, 459, 460, 461, 462, 463, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 476, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 501, 503, 504, 505, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 518, 519, 520, 522, 524, 525, 526, 527, 528, 531, 532, 533, 535, 537, 539, 540, 541, 542, 543, 545, 546, 547, 548, 549, 550, 551, 553, 554, 556, 557, 558, 559, 560, 561, 562, 563, 564, 566, 567, 568, 569, 575, 576, 577, 579, 580, 582, 583, 585, 586, 587, 588, 590, 591, 592, 593, 594, 595, 596, 597, 598, 600, 602, 603, 604, 606, 607, 609, 610, 611, 613, 618, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 639, 641, 642, 643, 644, 646, 647, 649, 655, 660, 661, 662, 663, 665, 668, 669, 670, 671, 672, 673, 674, 675, 676, 678, 679, 680, 681, 682, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 707, 719, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 GROUP BY products.product_id   ORDER BY popularity.total desc, products.product_id ASC  LIMIT 0, 100
1 0.00205 0.00205 0.00205
SELECT FOUND_ROWS()
1 0.00012 0.00012 0.00012
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 9595
1 0.00023 0.00023 0.00023
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (2910, 2916) AND lang_code = 'en'
1 0.00028 0.00028 0.00028
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00019 0.00019 0.00019
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.00072 0.00072 0.00072
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
1 0.00022 0.00022 0.00022
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.00039 0.00039 0.00039
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.00122 0.00122 0.00122
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.00050 0.00050 0.00050
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2916 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00023 0.00023 0.00023
SET time_zone = '+02:00'
1 0.00016 0.00016 0.00016
SELECT type FROM cscart_seo_names WHERE name = 'mailboxe' 
1 0.00844 0.00844 0.00844
SELECT * FROM cscart_seo_names WHERE name = 'mailboxe'  
1 0.00045 0.00045 0.00045
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00029 0.00029 0.00029
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('home-and-garden', 'decor') AND type = 'c' AND lang_code = 'en' 
1 0.00037 0.00037 0.00037
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.00041 0.00041 0.00041
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 9595 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00082 0.00082 0.00082
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2910 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00025 0.00025 0.00025
SELECT default_langsf FROM cscart_storefronts  WHERE storefront_id = 1
1 0.00016 0.00016 0.00016
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.00052 0.00052 0.00052
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
1 0.00034 0.00034 0.00034
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00038 0.00038 0.00038
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00021 0.00021 0.00021
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' 
1 0.00063 0.00063 0.00063
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1928
1 0.00057 0.00057 0.00057
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 ('categories.view') AND (FIND_IN_SET(9595, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.05310 0.05310 0.05310
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00038 0.00038 0.00038
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00056 0.00056 0.00056
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.00111 0.00111 0.00111
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00018 0.00018 0.00018