Queries total time: 0.07122 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.00034 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.00059 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.00013 Re-run Backtrace
4
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

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

    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.01051 Re-run Backtrace
6
SELECT * FROM cscart_seo_names WHERE name = 'records-and-lps'  

    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.00035 Re-run Backtrace
7
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_get_route() /var/www/webmarco/app/functions/fn.init.php:1227
  • fn_set_hook() /var/www/webmarco/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_seo_validate_object() /var/www/webmarco/app/addons/seo/func.php:705
  • Tygh\Languages\Languages::getSimpleLanguages() /var/www/webmarco/app/addons/seo/func.php:1091
  • db_get_hash_single_array() /var/www/webmarco/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /var/www/webmarco/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:571
0.00021 Re-run Backtrace
8
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('media', 'music-and-sound-recordings') 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.00045 Re-run Backtrace
9
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.00033 Re-run Backtrace
10
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5700 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.00026 Re-run Backtrace
11
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5368 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.00024 Re-run Backtrace
12
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5598 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.00028 Re-run Backtrace
13
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.00019 Re-run Backtrace
14
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1

    Backtrace

  • require() /var/www/webmarco/index.php:18
  • fn_init() /var/www/webmarco/init.php:195
  • fn_init_layout() /var/www/webmarco/app/functions/fn.init.php:1227
  • Tygh\BlockManager\Layout::getDefault() /var/www/webmarco/app/functions/fn.init.php:673
  • db_get_row() /var/www/webmarco/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00027 Re-run Backtrace
15
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.00039 Re-run Backtrace
16
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.00018 Re-run Backtrace
17
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.00041 Re-run Backtrace
18
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.00022 Re-run Backtrace
19
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(5700, 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.03833 Re-run Backtrace
20
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.00027 Re-run Backtrace
21
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.00036 Re-run Backtrace
22
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.00067 Re-run Backtrace
23
SELECT * FROM cscart_settings_sections WHERE name = 'cp_power_blog' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type))

    Backtrace

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

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • fn_run_controller() /var/www/webmarco/app/functions/fn.control.php:458
  • include() /var/www/webmarco/app/functions/fn.control.php:722
  • fn_wk_order_delivery_confirmation_request() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/controllers/frontend/init.post.php:6
  • fn_wk_order_delivery_confirmation_get_setting_data() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:23
  • Tygh\Settings::getValue() /var/www/webmarco/app/addons/wk_order_delivery_confirmation/func.php:11
  • Tygh\Settings::getPlainList() /var/www/webmarco/app/Tygh/Settings.php:874
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/Tygh/Settings.php:1788
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00031 Re-run Backtrace
28
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.00024 Re-run Backtrace
29
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.00013 Re-run Backtrace
30
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 5700

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

    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.00013 Re-run Backtrace
33
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 (5700) AND cscart_categories.id_path LIKE '5368/5598/5700/%' 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.00047 Re-run Backtrace
34
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 = 5700  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE cscart_categories.category_id = 5700 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.00053 Re-run Backtrace
35
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 = '5700' 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 = '5700' 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.00048 Re-run Backtrace
36
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.00517 Re-run Backtrace
37
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (5700)
                 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.00224 Re-run Backtrace
38
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.00055 Re-run Backtrace
39
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 (5700) 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.00172 Re-run Backtrace
40
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.00008 Re-run Backtrace
41
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 5700

    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.00016 Re-run Backtrace
42
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (5368, 5598) 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
43
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
44
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.00074 Re-run Backtrace
45
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.00023 Re-run Backtrace
46
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

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
2 0.00021 0.00044 0.00032
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00034 0.00034 0.00034
SELECT * FROM  cscart_csc_product_code_generator WHERE 1  AND cscart_csc_product_code_generator.company_id=0
1 0.00517 0.00517 0.00517
SELECT order_id FROM cscart_orders WHERE order_confirmation =0 AND status='E' AND order_status_update_timestamp>0
1 0.00024 0.00024 0.00024
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
1 0.00013 0.00013 0.00013
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 5700
1 0.00018 0.00018 0.00018
SELECT category_id FROM cscart_categories WHERE category_id = 5700  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.00018 0.00018 0.00018
SELECT id_path FROM cscart_categories WHERE category_id = 5700
1 0.00013 0.00013 0.00013
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 (5700) AND cscart_categories.id_path LIKE '5368/5598/5700/%' 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.00047 0.00047 0.00047
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 = 5700  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  WHERE cscart_categories.category_id = 5700 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.00053 0.00053 0.00053
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 = '5700' 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 = '5700' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00048 0.00048 0.00048
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (5700)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
1 0.00224 0.00224 0.00224
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.00023 0.00023 0.00023
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00055 0.00055 0.00055
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 (5700) 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.00172 0.00172 0.00172
SELECT FOUND_ROWS()
1 0.00008 0.00008 0.00008
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 5700
1 0.00016 0.00016 0.00016
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (5368, 5598) 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.00074 0.00074 0.00074
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
1 0.00023 0.00023 0.00023
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, cscart_settings_objects.name as description, (CASE WHEN storefront_values.object_id IS NOT NULL THEN storefront_values.value ELSE cscart_settings_objects.value END) AS value FROM cscart_settings_objects  LEFT JOIN cscart_settings_vendor_values AS storefront_values ON storefront_values.object_id = cscart_settings_objects.object_id AND storefront_values.storefront_id = 1 AND storefront_values.company_id = 0 WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.object_id = 6508 ORDER BY cscart_settings_objects.position
1 0.00031 0.00031 0.00031
SELECT 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.00071 0.00071 0.00071
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.00044 0.00044 0.00044
SELECT default_langsf FROM cscart_storefronts  WHERE storefront_id = 1
1 0.00019 0.00019 0.00019
SET time_zone = '+02:00'
1 0.00013 0.00013 0.00013
SELECT type FROM cscart_seo_names WHERE name = 'records-and-lps' 
1 0.01051 0.01051 0.01051
SELECT * FROM cscart_seo_names WHERE name = 'records-and-lps'  
1 0.00035 0.00035 0.00035
SELECT object_id, name FROM cscart_seo_names WHERE name IN ('media', 'music-and-sound-recordings') AND type = 'c' AND lang_code = 'en' 
1 0.00045 0.00045 0.00045
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.00033 0.00033 0.00033
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5700 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00026 0.00026 0.00026
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5368 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00024 0.00024 0.00024
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 5598 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00028 0.00028 0.00028
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
1 0.00027 0.00027 0.00027
SELECT 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.00059 0.00059 0.00059
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00039 0.00039 0.00039
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00018 0.00018 0.00018
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' 
1 0.00041 0.00041 0.00041
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1928
1 0.00022 0.00022 0.00022
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(5700, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.03833 0.03833 0.03833
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00027 0.00027 0.00027
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00036 0.00036 0.00036
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.00067 0.00067 0.00067
SELECT * FROM cscart_settings_sections WHERE name = 'cp_power_blog' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('MVE:ROOT', cscart_settings_sections.edition_type))
1 0.00031 0.00031 0.00031
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00018 0.00018 0.00018