Queries total time: 0.07483 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.00027 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.00052 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 type FROM cscart_seo_names WHERE name = 'ottoman-cushions' 

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

    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.00308 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.00024 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.00049 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.00049 Re-run Backtrace
9
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 3472 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.00034 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.00022 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.00023 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.00035 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.00020 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.00047 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.00023 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(3472, 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.04180 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.00030 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.00038 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.00065 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.00039 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.00080 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.00037 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.00021 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.00030 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.00021 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.00012 Re-run Backtrace
29
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 3472

    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.00018 Re-run Backtrace
30
SELECT category_id FROM cscart_categories WHERE category_id = 3472  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.00019 Re-run Backtrace
31
SELECT id_path FROM cscart_categories WHERE category_id = 3472

    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.00015 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 (3472) AND cscart_categories.id_path LIKE '2910/2916/3472/%' 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.00056 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 = 3472  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE cscart_categories.category_id = 3472 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.00528 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 = '3472' 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 = '3472' 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.00061 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.00670 Re-run Backtrace
36
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (3472)
                 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.00274 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.00072 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 (3472) 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.00213 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 = 3472

    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.00024 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.00023 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.00063 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.00016 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.00024 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.00027 0.00027 0.00027
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 = '3472' 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 = '3472' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00061 0.00061 0.00061
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.00030 0.00030 0.00030
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0
1 0.00021 0.00021 0.00021
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
1 0.00012 0.00012 0.00012
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 3472
1 0.00018 0.00018 0.00018
SELECT category_id FROM cscart_categories WHERE category_id = 3472  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.00019 0.00019 0.00019
SELECT id_path FROM cscart_categories WHERE category_id = 3472
1 0.00015 0.00015 0.00015
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 (3472) AND cscart_categories.id_path LIKE '2910/2916/3472/%' 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.00056 0.00056 0.00056
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 = 3472  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE cscart_categories.category_id = 3472 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.00528 0.00528 0.00528
SELECT * FROM  cscart_csc_product_code_generator WHERE 1  AND cscart_csc_product_code_generator.company_id=0
1 0.00670 0.00670 0.00670
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 a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (3472)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
1 0.00274 0.00274 0.00274
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00072 0.00072 0.00072
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 (3472) 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.00213 0.00213 0.00213
SELECT FOUND_ROWS()
1 0.00012 0.00012 0.00012
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 3472
1 0.00024 0.00024 0.00024
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (2910, 2916) AND lang_code = 'en'
1 0.00023 0.00023 0.00023
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.00063 0.00063 0.00063
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
1 0.00016 0.00016 0.00016
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.00021 0.00021 0.00021
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.00080 0.00080 0.00080
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.00052 0.00052 0.00052
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.00010 0.00010 0.00010
SELECT type FROM cscart_seo_names WHERE name = 'ottoman-cushions' 
1 0.00061 0.00061 0.00061
SELECT * FROM cscart_seo_names WHERE name = 'ottoman-cushions'  
1 0.00308 0.00308 0.00308
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00024 0.00024 0.00024
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('home-and-garden', 'decor') AND type = 'c' AND lang_code = 'en' 
1 0.00049 0.00049 0.00049
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.00049 0.00049 0.00049
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 3472 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00034 0.00034 0.00034
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2910 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00022 0.00022 0.00022
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.00039 0.00039 0.00039
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
1 0.00023 0.00023 0.00023
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00035 0.00035 0.00035
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00020 0.00020 0.00020
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' 
1 0.00047 0.00047 0.00047
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1928
1 0.00023 0.00023 0.00023
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(3472, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.04180 0.04180 0.04180
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00030 0.00030 0.00030
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00038 0.00038 0.00038
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.00065 0.00065 0.00065
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00024 0.00024 0.00024