Queries total time: 0.03334 s.
Query Time Actions
1
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'lvshop.lv' OR storefronts.url = 'www.lvshop.lv' OR storefronts.url LIKE 'www_.lvshop.lv' OR storefronts.url LIKE 'lvshop.lv/%' OR storefronts.url LIKE 'www.lvshop.lv/%' OR storefronts.url LIKE 'www_.lvshop.lv/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'lvshop.lv' DESC, storefronts.url = 'www.lvshop.lv' DESC, storefronts.url LIKE 'www_.lvshop.lv' DESC, storefronts.url LIKE 'lvshop.lv/%' DESC, storefronts.url LIKE 'www.lvshop.lv/%' DESC, storefronts.url LIKE 'www_.lvshop.lv/%' desc 

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_redirect_to_regional_storefront() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\Storefront\Repository::findByUrl() /var/www/lvshop.lv/web/app/functions/fn.init.php:1424
  • Tygh\Storefront\Repository::find() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:133
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:378
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00020 Re-run Backtrace
2
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_http_params_by_storefront() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_allowed_for() /var/www/lvshop.lv/web/app/functions/fn.init.php:1580
  • fn_get_storage_data() /var/www/lvshop.lv/web/app/functions/fn.control.php:992
  • db_get_row() /var/www/lvshop.lv/web/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00020 Re-run Backtrace
3
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_http_params_by_storefront() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\Storefront\Storefront::__call() /var/www/lvshop.lv/web/app/functions/fn.init.php:1581
  • Tygh\Storefront\Storefront::getRelationValue() /var/www/lvshop.lv/web/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /var/www/lvshop.lv/web/app/Tygh/Storefront/Storefront.php:272
  • Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/lvshop.lv/web/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /var/www/lvshop.lv/web/app/Tygh/Storefront/RelationsManager.php:115
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:480
0.00016 Re-run Backtrace
4
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_company_id() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_set_hook() /var/www/lvshop.lv/web/app/functions/fn.init.php:405
  • fn_ult_init_company_id() /var/www/lvshop.lv/web/app/functions/fn.control.php:105
  • db_get_field() /var/www/lvshop.lv/web/app/functions/fn.ultimate.php:585
  • Tygh\Database\Connection::getField() /var/www/lvshop.lv/web/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:448
0.00011 Re-run Backtrace
5
SELECT COUNT(*) FROM cscart_companies

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_company_id() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_set_hook() /var/www/lvshop.lv/web/app/functions/fn.init.php:405
  • fn_ult_init_company_id() /var/www/lvshop.lv/web/app/functions/fn.control.php:105
  • db_get_field() /var/www/lvshop.lv/web/app/functions/fn.ultimate.php:604
  • Tygh\Database\Connection::getField() /var/www/lvshop.lv/web/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:448
0.00012 Re-run Backtrace
6
SET time_zone = '-07:00'

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_settings() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_init_time_zone() /var/www/lvshop.lv/web/app/functions/fn.init.php:1030
  • db_query() /var/www/lvshop.lv/web/app/functions/fn.init.php:1051
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/functions/fn.database.php:138
0.00025 Re-run Backtrace
7
SELECT companies.*, 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 FROM cscart_companies AS companies  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 = 1 

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_company_data() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_get_company_data() /var/www/lvshop.lv/web/app/functions/fn.init.php:296
  • db_get_row() /var/www/lvshop.lv/web/app/functions/fn.companies.php:616
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00037 Re-run Backtrace
8
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

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_company_data() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_get_company_data() /var/www/lvshop.lv/web/app/functions/fn.init.php:296
  • fn_set_hook() /var/www/lvshop.lv/web/app/functions/fn.companies.php:648
  • fn_discussion_get_company_data_post() /var/www/lvshop.lv/web/app/functions/fn.control.php:124
  • db_get_array() /var/www/lvshop.lv/web/app/addons/discussion/func.php:1504
  • Tygh\Database\Connection::getArray() /var/www/lvshop.lv/web/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:333
0.00019 Re-run Backtrace
9
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/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_layout() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\Application::offsetGet() /var/www/lvshop.lv/web/app/functions/fn.init.php:618
  • Pimple\Container::offsetGet() /var/www/lvshop.lv/web/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/lvshop.lv/web/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Storefront\Repository::findById() /var/www/lvshop.lv/web/app/Tygh/Providers/StorefrontProvider.php:190
  • Tygh\Storefront\Repository::find() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:172
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:381
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00343 Re-run Backtrace
10
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_layout() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\Application::offsetGet() /var/www/lvshop.lv/web/app/functions/fn.init.php:618
  • Pimple\Container::offsetGet() /var/www/lvshop.lv/web/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/lvshop.lv/web/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Storefront\Storefront::__call() /var/www/lvshop.lv/web/app/Tygh/Providers/StorefrontProvider.php:195
  • Tygh\Storefront\Storefront::getRelationValue() /var/www/lvshop.lv/web/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /var/www/lvshop.lv/web/app/Tygh/Storefront/Storefront.php:272
  • Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/lvshop.lv/web/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /var/www/lvshop.lv/web/app/Tygh/Storefront/RelationsManager.php:115
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:480
0.00335 Re-run Backtrace
11
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_layout() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\BlockManager\Layout::getDefault() /var/www/lvshop.lv/web/app/functions/fn.init.php:646
  • db_get_row() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Layout.php:94
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00298 Re-run Backtrace
12
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_layout() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\Themes\Styles::factory() /var/www/lvshop.lv/web/app/functions/fn.init.php:649
  • Tygh\Themes\Styles::__construct() /var/www/lvshop.lv/web/app/Tygh/Themes/Styles.php:850
  • Tygh\Themes\Themes::factory() /var/www/lvshop.lv/web/app/Tygh/Themes/Styles.php:52
  • Tygh\Themes\Themes::__construct() /var/www/lvshop.lv/web/app/Tygh/Themes/Themes.php:513
  • fn_get_theme_path() /var/www/lvshop.lv/web/app/Tygh/Themes/Themes.php:110
  • fn_set_hook() /var/www/lvshop.lv/web/app/functions/fn.common.php:139
  • fn_ult_get_theme_path_pre() /var/www/lvshop.lv/web/app/functions/fn.control.php:105
  • fn_ult_bootstrap_company_storefront() /var/www/lvshop.lv/web/app/functions/fn.ultimate.php:107
  • Tygh\Storefront\Repository::findByCompanyId() /var/www/lvshop.lv/web/app/functions/fn.ultimate.php:4189
  • Tygh\Storefront\Repository::find() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:224
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:381
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00245 Re-run Backtrace
13
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_user() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • fn_login_user() /var/www/lvshop.lv/web/app/functions/fn.init.php:717
  • fn_init_user() /var/www/lvshop.lv/web/app/functions/fn.users.php:3584
  • fn_is_expired_storage_data() /var/www/lvshop.lv/web/app/functions/fn.init.php:749
  • fn_get_storage_data() /var/www/lvshop.lv/web/app/functions/fn.control.php:1102
  • db_get_row() /var/www/lvshop.lv/web/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00335 Re-run Backtrace
14
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /var/www/lvshop.lv/web/index.php:18
  • fn_init() /var/www/lvshop.lv/web/init.php:195
  • fn_init_templater() /var/www/lvshop.lv/web/app/functions/fn.init.php:1200
  • Tygh\Development::isEnabled() /var/www/lvshop.lv/web/app/functions/fn.init.php:87
  • Tygh\Development::read() /var/www/lvshop.lv/web/app/Tygh/Development.php:28
  • fn_get_storage_data() /var/www/lvshop.lv/web/app/Tygh/Development.php:81
  • db_get_row() /var/www/lvshop.lv/web/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00257 Re-run Backtrace
15
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::instance() /var/www/lvshop.lv/web/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Location.php:483
  • db_get_row() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00115 Re-run Backtrace
16
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 1  AND l.dispatch IN ('index.index')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • Tygh\BlockManager\Location::get() /var/www/lvshop.lv/web/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Location.php:164
  • db_get_hash_array() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Location.php:104
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00022 Re-run Backtrace
17
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_get_storage_data() /var/www/lvshop.lv/web/app/controllers/frontend/init.php:146
  • db_get_row() /var/www/lvshop.lv/web/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00016 Re-run Backtrace
18
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /var/www/lvshop.lv/web/app/addons/pwa/controllers/frontend/init.post.php:18
  • Tygh\Settings::instance() /var/www/lvshop.lv/web/app/addons/pwa/func.php:179
  • Tygh\Settings::normalizeInstanceParameters() /var/www/lvshop.lv/web/app/Tygh/Settings.php:163
  • Tygh\Storefront\Repository::getCount() /var/www/lvshop.lv/web/app/Tygh/Settings.php:243
  • Tygh\Database\Connection::getField() /var/www/lvshop.lv/web/app/Tygh/Storefront/Repository.php:443
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:448
0.00016 Re-run Backtrace
19
SELECT cscart_settings_sections.name, cscart_settings_sections.section_id, cscart_settings_sections.position, cscart_settings_sections.type , cscart_settings_sections.name as description, CONCAT('settings.manage?section_id=', cscart_settings_sections.name) as href  FROM cscart_settings_sections  WHERE 1  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /var/www/lvshop.lv/web/app/addons/pwa/controllers/frontend/init.post.php:18
  • Tygh\Settings::instance() /var/www/lvshop.lv/web/app/addons/pwa/func.php:179
  • Tygh\Settings::reloadSections() /var/www/lvshop.lv/web/app/Tygh/Settings.php:172
  • Tygh\Settings::getSections() /var/www/lvshop.lv/web/app/Tygh/Settings.php:141
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/Tygh/Settings.php:486
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00021 Re-run Backtrace
20
SELECT * FROM cscart_settings_sections WHERE name = 'pwa' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type))

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /var/www/lvshop.lv/web/app/addons/pwa/controllers/frontend/init.post.php:18
  • Tygh\Settings::getValues() /var/www/lvshop.lv/web/app/addons/pwa/func.php:179
  • Tygh\Settings::getSectionByName() /var/www/lvshop.lv/web/app/Tygh/Settings.php:790
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/Tygh/Settings.php:401
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00102 Re-run Backtrace
21
SELECT cscart_settings_objects.object_id as object_id, name, section_id, section_tab_id, type, position, is_global, cscart_settings_objects.name as description, (CASE WHEN company_values.object_id IS NOT NULL THEN company_values.value 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 company_values ON company_values.object_id = cscart_settings_objects.object_id AND company_values.company_id = 1 AND company_values.storefront_id = 1  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 = 20 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /var/www/lvshop.lv/web/app/addons/pwa/controllers/frontend/init.post.php:18
  • Tygh\Settings::getValues() /var/www/lvshop.lv/web/app/addons/pwa/func.php:179
  • Tygh\Settings::getPlainList() /var/www/lvshop.lv/web/app/Tygh/Settings.php:803
  • Tygh\Database\Connection::getArray() /var/www/lvshop.lv/web/app/Tygh/Settings.php:1784
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:333
0.00374 Re-run Backtrace
22
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 = 'manifest_icon' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_get_pwa_settings() /var/www/lvshop.lv/web/app/addons/pwa/controllers/frontend/init.post.php:18
  • fn_get_image_pairs() /var/www/lvshop.lv/web/app/addons/pwa/func.php:205
  • db_multi_query() /var/www/lvshop.lv/web/app/functions/fn.images.php:350
  • Tygh\Database\Connection::multiQuery() /var/www/lvshop.lv/web/app/functions/fn.database.php:168
0.00358 Re-run Backtrace
23
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND company_id = 1 AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_run_controller() /var/www/lvshop.lv/web/app/functions/fn.control.php:460
  • include() /var/www/lvshop.lv/web/app/functions/fn.control.php:729
  • fn_hybrid_auth_get_providers_list() /var/www/lvshop.lv/web/app/addons/hybrid_auth/controllers/frontend/init.post.php:17
  • Tygh\Registry::getOrSetCache() /var/www/lvshop.lv/web/app/addons/hybrid_auth/func.php:181
  • {closure}() /var/www/lvshop.lv/web/app/Tygh/Registry.php:800
  • db_get_hash_array() /var/www/lvshop.lv/web/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00082 Re-run Backtrace
24
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • fn_check_permissions() /var/www/lvshop.lv/web/app/functions/fn.control.php:519
  • fn_check_admin_permissions() /var/www/lvshop.lv/web/app/functions/fn.common.php:2574
  • db_get_fields() /var/www/lvshop.lv/web/app/functions/fn.common.php:2756
  • Tygh\Database\Connection::getColumn() /var/www/lvshop.lv/web/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:480
0.00021 Re-run Backtrace
25
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 2

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:130
  • Tygh\BlockManager\Container::getList() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Container.php:71
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00025 Re-run Backtrace
26
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 2

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:130
  • Tygh\BlockManager\Container::getList() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /var/www/lvshop.lv/web/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:448
0.00015 Re-run Backtrace
27
SELECT c.*, IF (c.location_id != 2, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Container::getListByArea() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:130
  • Tygh\BlockManager\Container::getList() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Container.php:71
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00020 Re-run Backtrace
28
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 7, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Grid::getList() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:133
  • db_get_hash_multi_array() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Grid.php:62
  • Tygh\Database\Connection::getMultiHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:526
0.00039 Re-run Backtrace
29
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::__construct() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:75
  • Tygh\BlockManager\Block::getList() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:137
  • db_get_hash_multi_array() /var/www/lvshop.lv/web/app/Tygh/BlockManager/Block.php:270
  • Tygh\Database\Connection::getMultiHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:526
0.00027 Re-run Backtrace
30
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND company_id = 1 AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\BlockManager\RenderManager::getValue() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:837
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /var/www/lvshop.lv/web/app/addons/hybrid_auth/func.php:255
  • Tygh\Registry::getOrSetCache() /var/www/lvshop.lv/web/app/addons/hybrid_auth/func.php:181
  • {closure}() /var/www/lvshop.lv/web/app/Tygh/Registry.php:800
  • db_get_hash_array() /var/www/lvshop.lv/web/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /var/www/lvshop.lv/web/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:371
0.00030 Re-run Backtrace
31
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 20 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/functions/fn.control.php:639
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e770cab80_91200515() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\RenderLocation::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/8cc2275ba9b8a069521d33e357bb83b0eec2bc42_2.tygh_index.tpl.php:226
  • Tygh\BlockManager\RenderManager::render() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/RenderLocation.php:77
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:165
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:201
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:370
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:231
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:374
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:416
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:495
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e7b4c8344_00934677() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Tygh\SmartyEngine\Functions\SafeEvalString::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/7fe9da96e68035bf479f968ab0b657af6ed521ec_2.tygh_safe_smarty_block.tpl.php:46
  • Tygh\SmartyEngine\Core::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Functions/SafeEvalString.php:41
  • Smarty\Template::fetch() /var/www/lvshop.lv/web/app/Tygh/SmartyEngine/Core.php:85
  • Smarty\Template::_execute() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:589
  • Smarty\Template::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:655
  • Smarty\Template\Compiled::render() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template.php:180
  • Smarty\Template\GeneratedPhpFile::getRenderedTemplateCode() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/Compiled.php:110
  • content_69d03e7b874627_23548721() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Template/GeneratedPhpFile.php:111
  • Smarty\Extension\CallbackWrapper::handle() /var/www/lvshop.lv/web/var/cache/templates/nova_theme/9791d6ef2177b7f8d8d0e526b47a7981e406a0e3_2.string_.php:39
  • fn_url() /var/www/lvshop.lv/web/app/lib/vendor/smarty/smarty/src/Extension/CallbackWrapper.php:29
  • fn_set_hook() /var/www/lvshop.lv/web/app/functions/fn.common.php:3984
  • fn_seo_url_post() /var/www/lvshop.lv/web/app/functions/fn.control.php:124
  • fn_seo_get_name() /var/www/lvshop.lv/web/app/addons/seo/func.php:1645
  • db_get_row() /var/www/lvshop.lv/web/app/addons/seo/func.php:1375
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00045 Re-run Backtrace
32
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

    Backtrace

  • fn_dispatch() /var/www/lvshop.lv/web/index.php:19
  • Tygh\Application::offsetGet() /var/www/lvshop.lv/web/app/functions/fn.control.php:655
  • Pimple\Container::offsetGet() /var/www/lvshop.lv/web/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /var/www/lvshop.lv/web/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • fn_get_storage_data() /var/www/lvshop.lv/web/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /var/www/lvshop.lv/web/app/functions/fn.control.php:1084
  • Tygh\Database\Connection::getRow() /var/www/lvshop.lv/web/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/lvshop.lv/web/app/Tygh/Database/Connection.php:414
0.00034 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
2 0.00016 0.00335 0.00175
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND company_id = 1 AND status = 'A' ORDER BY position
2 0.00030 0.00082 0.00056
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'lvshop.lv' OR storefronts.url = 'www.lvshop.lv' OR storefronts.url LIKE 'www_.lvshop.lv' OR storefronts.url LIKE 'lvshop.lv/%' OR storefronts.url LIKE 'www.lvshop.lv/%' OR storefronts.url LIKE 'www_.lvshop.lv/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'lvshop.lv' DESC, storefronts.url = 'www.lvshop.lv' DESC, storefronts.url LIKE 'www_.lvshop.lv' DESC, storefronts.url LIKE 'lvshop.lv/%' DESC, storefronts.url LIKE 'www.lvshop.lv/%' DESC, storefronts.url LIKE 'www_.lvshop.lv/%' desc 
1 0.00020 0.00020 0.00020
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00020 0.00020 0.00020
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
1 0.00011 0.00011 0.00011
SELECT COUNT(*) FROM cscart_companies
1 0.00012 0.00012 0.00012
SET time_zone = '-07:00'
1 0.00025 0.00025 0.00025
SELECT companies.*, 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 FROM cscart_companies AS companies  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 = 1 
1 0.00037 0.00037 0.00037
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.00019 0.00019 0.00019
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.00343 0.00343 0.00343
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'nova_theme' AND storefront_id = 1
1 0.00298 0.00298 0.00298
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00245 0.00245 0.00245
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00335 0.00335 0.00335
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00257 0.00257 0.00257
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 1
1 0.00115 0.00115 0.00115
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 = 1  AND l.dispatch IN ('index.index')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00022 0.00022 0.00022
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00016 0.00016 0.00016
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM cscart_storefronts AS storefronts  WHERE 1 = 1
1 0.00016 0.00016 0.00016
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('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type)) ORDER BY cscart_settings_sections.position
1 0.00021 0.00021 0.00021
SELECT * FROM cscart_settings_sections WHERE name = 'pwa' AND type = 'ADDON'  AND (FIND_IN_SET('STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_sections.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_sections.edition_type))
1 0.00102 0.00102 0.00102
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 company_values.object_id IS NOT NULL THEN company_values.value 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 company_values ON company_values.object_id = cscart_settings_objects.object_id AND company_values.company_id = 1 AND company_values.storefront_id = 1  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 = 20 AND (FIND_IN_SET('STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ROOT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:STOREFRONT', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:VENDOR', cscart_settings_objects.edition_type) OR FIND_IN_SET('ULT:ROOT', cscart_settings_objects.edition_type)) AND cscart_settings_objects.type <> 'H' ORDER BY cscart_settings_objects.position
1 0.00374 0.00374 0.00374
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 = 'manifest_icon' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00358 0.00358 0.00358
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00021 0.00021 0.00021
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 2
1 0.00025 0.00025 0.00025
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 2
1 0.00015 0.00015 0.00015
SELECT c.*, IF (c.location_id != 2, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 1 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
1 0.00020 0.00020 0.00020
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1, 2, 7, 4) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00039 0.00039 0.00039
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 12, 15, 20, 13, 14, 16, 17, 18, 19, 21, 22, 23, 24, 25, 26, 27, 28)  AND cscart_bm_blocks_descriptions.lang_code='en'  AND cscart_bm_blocks.company_id = 1 ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00027 0.00027 0.00027
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 20 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00045 0.00045 0.00045
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00034 0.00034 0.00034