Queries total time: 0.79431 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.00031 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.00054 Re-run Backtrace
3
SET time_zone = '+02:00'

    Backtrace

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

    Backtrace

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

    Backtrace

  • require() /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
  • Tygh\Application::offsetGet() /var/www/webmarco/app/addons/default_language/func.php:18
  • Pimple\Container::offsetGet() /var/www/webmarco/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/webmarco/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Storefront\Repository::findById() /var/www/webmarco/app/Tygh/Providers/StorefrontProvider.php:186
  • Tygh\Storefront\Repository::find() /var/www/webmarco/app/Tygh/Storefront/Repository.php:164
  • 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.00026 Re-run Backtrace
6
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.00018 Re-run Backtrace
7
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.00048 Re-run Backtrace
8
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.00045 Re-run Backtrace
9
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.00019 Re-run Backtrace
10
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.00045 Re-run Backtrace
11
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.00026 Re-run Backtrace
12
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 ('companies.contact')  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.03827 Re-run Backtrace
13
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.00028 Re-run Backtrace
14
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.00034 Re-run Backtrace
15
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.00072 Re-run Backtrace
16
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.00030 Re-run Backtrace
17
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.00073 Re-run Backtrace
18
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.00055 Re-run Backtrace
19
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.00024 Re-run Backtrace
20
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.00038 Re-run Backtrace
21
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
22
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
23
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

  • 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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:613
  • fn_seo_get_company_data() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_get_seo_join_condition() /var/www/webmarco/app/addons/seo/func.php:2716
  • fn_get_corrected_seo_lang_code() /var/www/webmarco/app/addons/seo/func.php:66
  • 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.00036 Re-run Backtrace
24
SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, AVG(cscart_discussion_rating.rating_value) AS average_rating, CONCAT(companies.company_id, '_', IF ( cscart_discussion_rating.thread_id, cscart_discussion_rating.thread_id, '0')) AS company_thread_ids, company_descriptions.page_title, company_descriptions.meta_description, company_descriptions.meta_keywords FROM cscart_companies AS companies  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'en' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 707  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = companies.company_id AND cscart_discussion.object_type = 'M' LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = 'A' LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id WHERE companies.company_id = 707 

    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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • db_get_row() /var/www/webmarco/app/functions/fn.companies.php:616
  • 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.00093 Re-run Backtrace
25
SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 707 AND object_type = 'S' 

    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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_mve_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:104
  • fn_get_profile_fields_data() /var/www/webmarco/app/functions/fn.multivendor.php:1627
  • db_get_hash_array() /var/www/webmarco/app/functions/fn.users.php:5044
  • 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.00032 Re-run Backtrace
26
SELECT a.object_id, COUNT(b.post_id) as total_items FROM cscart_discussion as a LEFT JOIN cscart_discussion_posts as b ON a.thread_id=b.thread_id WHERE a.object_type = 'M' AND b.status = 'A' GROUP BY a.object_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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_discussion_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • db_get_array() /var/www/webmarco/app/addons/discussion/func.php:1510
  • Tygh\Database\Connection::getArray() /var/www/webmarco/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:332
0.00028 Re-run Backtrace
27
SELECT field_id FROM cscart_profile_fields WHERE profile_type = 'S' AND profile_show = 'Y' AND ec_multiple = 'Y' 

    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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_ec_vendor_filter_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • db_get_fields() /var/www/webmarco/app/addons/ec_vendor_filter/func.php:156
  • 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.00022 Re-run Backtrace
28
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 = 'vendor_store_banner' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '707' 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 = 'vendor_store_banner' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '707' 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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_vendor_store_banner_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_get_image_pairs() /var/www/webmarco/app/addons/vendor_store_banner/func.php:28
  • 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.00077 Re-run Backtrace
29
SELECT cscart_et_mv_ved.type, cscart_et_mv_ved.description FROM  cscart_et_mv_ved WHERE company_id = 707

    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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_et_vivashop_mv_functionality_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_et_vivashop_mv_functionality_get_ved() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • db_get_hash_array() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • 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.00028 Re-run Backtrace
30
SELECT cscart_et_mv_pp_content.type, cscart_et_mv_pp_content.description FROM  cscart_et_mv_pp_content WHERE company_id = 707 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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_et_vivashop_mv_functionality_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_et_vivashop_mv_functionality_pp_block_get() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • db_get_hash_array() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • 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.00020 Re-run Backtrace
31
SELECT * FROM cscart_et_mv_vendor_settings WHERE company_id = 707

    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_company_data() /var/www/webmarco/app/addons/wm_vendor_domain_redirect/controllers/frontend/companies.pre.php:9
  • fn_set_hook() /var/www/webmarco/app/functions/fn.companies.php:647
  • fn_et_vivashop_mv_functionality_get_company_data_post() /var/www/webmarco/app/functions/fn.control.php:123
  • fn_et_mv_get_vs() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • db_get_row() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • Tygh\Database\Connection::getRow() /var/www/webmarco/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:413
0.00021 Re-run Backtrace
32
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/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:27
  • 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.00068 Re-run Backtrace
33
SELECT products.product_id 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 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.company_id = 707  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.company_id = 707  AND products.parent_product_id = 0 GROUP BY products.product_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
  • db_get_fields() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:27
  • 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.49752 Re-run Backtrace
34
SELECT * FROM cscart_logos WHERE layout_id IN (1928, 0) AND style_id IN ('New WebMarco Homepage', '') AND storefront_id IN (1, 0)  AND company_id = 707

    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_logos() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:30
  • db_get_hash_array() /var/www/webmarco/app/functions/fn.common.php:5638
  • 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.23632 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 = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (550756, 550757) 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_logos() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:30
  • fn_get_image_pairs() /var/www/webmarco/app/functions/fn.common.php:5649
  • 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.00444 Re-run Backtrace
36
SELECT cscart_et_mv_ved.type, cscart_et_mv_ved.description FROM  cscart_et_mv_ved WHERE company_id = 707

    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_et_vivashop_mv_functionality_get_ved() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:44
  • db_get_hash_array() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • 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.00028 Re-run Backtrace
37
SELECT cscart_et_mv_vsb.vsb_id, cscart_et_mv_vsb.company_id, cscart_et_mv_vsb.status, cscart_et_mv_vsb.position, cscart_et_mv_vsb.data as settings, cscart_et_mv_vsb_data.data as q_data, cscart_et_mv_vsb.data as settings, cscart_et_mv_vsb_data.data, cscart_et_mv_vsb_data.text FROM cscart_et_mv_vsb LEFT JOIN cscart_et_mv_vsb_data 
    ON cscart_et_mv_vsb_data.vsb_id = cscart_et_mv_vsb.vsb_id
    AND cscart_et_mv_vsb_data.lang_code = 'en' WHERE 1  AND cscart_et_mv_vsb.status = 'A' AND cscart_et_mv_vsb.company_id = '707'   ORDER BY cscart_et_mv_vsb.position 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_et_mv_get_vsb() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:45
  • db_get_hash_array() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/func.php:13
  • 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.00379 Re-run Backtrace
38
SELECT * FROM cscart_profile_fields WHERE profile_type = 'S'

    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_filter_company_data_by_profile_fields() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:48
  • db_get_hash_array() /var/www/webmarco/app/functions/fn.companies.php:2012
  • 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.00035 Re-run Backtrace
39
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 707 AND `type` = 'm' AND `dispatch` = '' 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_url() /var/www/webmarco/app/addons/et_vivashop_mv_functionality/controllers/frontend/companies.post.php:55
  • 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.00029 Re-run Backtrace
40
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.00022 Re-run Backtrace
41
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.00075 Re-run Backtrace
42
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map

    Backtrace

  • fn_dispatch() /var/www/webmarco/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/webmarco/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/webmarco/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c85ee57d36_78182531() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /var/www/webmarco/var/cache/templates/vivashop/62ef1b660e00ee757ff29c728d8df0587b71adfb_2.tygh.index.tpl.php:235
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c85ff01569_38375419() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /var/www/webmarco/var/cache/templates/vivashop/a9ab09f4f954287320deadb13894fa5d3d888cbe_2.tygh.scripts.tpl.php:654
  • Smarty_Internal_TemplateBase::fetch() /var/www/webmarco/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_66d9c86032ffc3_15948802() /var/www/webmarco/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_ec_category_filter_get_mapped_category_info() /var/www/webmarco/var/cache/templates/vivashop/cdc5493b1dbab86dd5ddd410da9e2608222f8bd8_2.tygh.scripts.post.tpl.php:76
  • db_get_hash_single_array() /var/www/webmarco/app/addons/ec_vendor_filter/func.php:169
  • Tygh\Database\Connection::getSingleHash() /var/www/webmarco/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/webmarco/app/Tygh/Database/Connection.php:571
0.00015 Re-run Backtrace
43
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.00019 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_et_mv_ved.type, cscart_et_mv_ved.description FROM  cscart_et_mv_ved WHERE company_id = 707
2 0.00028 0.00028 0.00028
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00031 0.00031 0.00031
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00068 0.00068 0.00068
SELECT profile_fields_data.field_id, profile_fields_data.value, profile_fields.field_type FROM cscart_profile_fields_data AS profile_fields_data LEFT JOIN cscart_profile_fields AS profile_fields ON profile_fields_data.field_id = profile_fields.field_id WHERE object_id = 707 AND object_type = 'S' 
1 0.00032 0.00032 0.00032
SELECT a.object_id, COUNT(b.post_id) as total_items FROM cscart_discussion as a LEFT JOIN cscart_discussion_posts as b ON a.thread_id=b.thread_id WHERE a.object_type = 'M' AND b.status = 'A' GROUP BY a.object_id
1 0.00028 0.00028 0.00028
SELECT field_id FROM cscart_profile_fields WHERE profile_type = 'S' AND profile_show = 'Y' AND ec_multiple = 'Y' 
1 0.00022 0.00022 0.00022
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 = 'vendor_store_banner' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '707' 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 = 'vendor_store_banner' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '707' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00077 0.00077 0.00077
SELECT cscart_et_mv_pp_content.type, cscart_et_mv_pp_content.description FROM  cscart_et_mv_pp_content WHERE company_id = 707 AND lang_code = 'en'
1 0.00020 0.00020 0.00020
SELECT * FROM cscart_et_mv_vendor_settings WHERE company_id = 707
1 0.00021 0.00021 0.00021
SELECT products.product_id 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 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.company_id = 707  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.company_id = 707  AND products.parent_product_id = 0 GROUP BY products.product_id
1 0.49752 0.49752 0.49752
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.00036 0.00036 0.00036
SELECT * FROM cscart_logos WHERE layout_id IN (1928, 0) AND style_id IN ('New WebMarco Homepage', '') AND storefront_id IN (1, 0)  AND company_id = 707
1 0.23632 0.23632 0.23632
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 = 'logos' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (550756, 550757) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00444 0.00444 0.00444
SELECT cscart_et_mv_vsb.vsb_id, cscart_et_mv_vsb.company_id, cscart_et_mv_vsb.status, cscart_et_mv_vsb.position, cscart_et_mv_vsb.data as settings, cscart_et_mv_vsb_data.data as q_data, cscart_et_mv_vsb.data as settings, cscart_et_mv_vsb_data.data, cscart_et_mv_vsb_data.text FROM cscart_et_mv_vsb LEFT JOIN cscart_et_mv_vsb_data 
    ON cscart_et_mv_vsb_data.vsb_id = cscart_et_mv_vsb.vsb_id
    AND cscart_et_mv_vsb_data.lang_code = 'en' WHERE 1  AND cscart_et_mv_vsb.status = 'A' AND cscart_et_mv_vsb.company_id = '707'   ORDER BY cscart_et_mv_vsb.position asc
1 0.00379 0.00379 0.00379
SELECT * FROM cscart_profile_fields WHERE profile_type = 'S'
1 0.00035 0.00035 0.00035
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 707 AND `type` = 'm' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00029 0.00029 0.00029
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00022 0.00022 0.00022
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.00075 0.00075 0.00075
SELECT product_variant, category_variants FROM cscart_ec_vendor_filter_map
1 0.00015 0.00015 0.00015
SELECT company_descriptions.*, companies.*, cscart_vendor_plan_descriptions.plan, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, AVG(cscart_discussion_rating.rating_value) AS average_rating, CONCAT(companies.company_id, '_', IF ( cscart_discussion_rating.thread_id, cscart_discussion_rating.thread_id, '0')) AS company_thread_ids, company_descriptions.page_title, company_descriptions.meta_description, company_descriptions.meta_keywords FROM cscart_companies AS companies  LEFT JOIN cscart_company_descriptions AS company_descriptions ON company_descriptions.company_id = companies.company_id AND company_descriptions.lang_code = 'en' LEFT JOIN cscart_vendor_plan_descriptions ON companies.plan_id = cscart_vendor_plan_descriptions.plan_id AND cscart_vendor_plan_descriptions.lang_code = 'en' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 707  AND cscart_seo_names.type = 'm'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en'  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = companies.company_id AND cscart_discussion.object_type = 'M' LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = 'A' LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id WHERE companies.company_id = 707 
1 0.00093 0.00093 0.00093
SELECT order_id ,send_time FROM cscart_order_delivery_confirmation_request_data
1 0.00012 0.00012 0.00012
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.00054 0.00054 0.00054
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1928
1 0.00026 0.00026 0.00026
SET time_zone = '+02:00'
1 0.00010 0.00010 0.00010
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00041 0.00041 0.00041
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00026 0.00026 0.00026
SELECT default_langsf FROM cscart_storefronts  WHERE storefront_id = 1
1 0.00018 0.00018 0.00018
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'vivashop' AND storefront_id = 1
1 0.00048 0.00048 0.00048
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00045 0.00045 0.00045
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00019 0.00019 0.00019
SELECT * FROM cscart_abt__ut2_settings WHERE lang_code = 'en' 
1 0.00045 0.00045 0.00045
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 ('companies.contact')  ORDER BY l.object_ids desc  LIMIT 1
1 0.03827 0.03827 0.03827
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 data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00028 0.00028 0.00028
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00034 0.00034 0.00034
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.00072 0.00072 0.00072
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.00030 0.00030 0.00030
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.00073 0.00073 0.00073
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.00055 0.00055 0.00055
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.00024 0.00024 0.00024
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.00038 0.00038 0.00038
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00019 0.00019 0.00019