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

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_redirect_to_regional_storefront() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • Tygh\Storefront\Repository::findByUrl() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1419
  • Tygh\Storefront\Repository::find() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:125
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:359
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00049 Re-run Backtrace
2
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_http_params_by_storefront() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_allowed_for() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1575
  • fn_get_storage_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:943
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:1018
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00025 Re-run Backtrace
3
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_http_params_by_storefront() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • Tygh\Storefront\Storefront::__call() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1576
  • Tygh\Storefront\Storefront::getRelationValue() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Storefront.php:227
  • Tygh\Storefront\RelationsManager::getRelationValue() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Storefront.php:265
  • Tygh\Storefront\RelationsManager::getRelatedValues() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00017 Re-run Backtrace
4
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_company_id() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:403
  • fn_ult_init_company_id() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:104
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:553
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00022 Re-run Backtrace
5
SET time_zone = '+03:00'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_settings() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_init_time_zone() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1019
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1040
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
0.00008 Re-run Backtrace
6
SELECT company_id, storefront, secure_storefront FROM cscart_companies WHERE company_id = 1

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_get_request_uri() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:788
  • fn_get_storefront_urls() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:1107
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:3448
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00037 Re-run Backtrace
7
SELECT type FROM cscart_seo_names WHERE name = 'sports-bar-isuzu-ute-d-max-2008-12'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:534
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00040 Re-run Backtrace
8
SELECT * FROM cscart_seo_names WHERE name = 'sports-bar-isuzu-ute-d-max-2008-12'  AND cscart_seo_names.company_id IN (0, 1) AND lang_code = 'en'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_array() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:538
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00023 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() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_validate_object() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:577
  • Tygh\Languages\Languages::getSimpleLanguages() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:918
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Languages/Languages.php:446
  • fn_ult_get_simple_languages() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:104
  • Tygh\Application::offsetGet() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:4182
  • Pimple\Container::offsetGet() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118
  • Tygh\Storefront\Repository::findById() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Providers/StorefrontProvider.php:186
  • Tygh\Storefront\Repository::find() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:163
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:362
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00021 Re-run Backtrace
10
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_validate_object() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:577
  • Tygh\Languages\Languages::getSimpleLanguages() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:918
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Languages/Languages.php:446
  • fn_ult_get_simple_languages() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:104
  • Tygh\Application::offsetGet() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:4182
  • Pimple\Container::offsetGet() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118
  • Tygh\Storefront\Storefront::__call() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Providers/StorefrontProvider.php:191
  • Tygh\Storefront\Storefront::getRelationValue() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Storefront.php:227
  • Tygh\Storefront\RelationsManager::getRelationValue() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Storefront.php:265
  • Tygh\Storefront\RelationsManager::getRelatedValues() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00013 Re-run Backtrace
11
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  LEFT JOIN cscart_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = cscart_languages.lang_id WHERE 1 AND cscart_languages.status = 'A'AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)   

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_validate_object() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:577
  • Tygh\Languages\Languages::getSimpleLanguages() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:918
  • db_get_hash_single_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Languages/Languages.php:448
  • Tygh\Database\Connection::getSingleHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:546
0.00018 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() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_url() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:663
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:3783
  • fn_ult_url_before_get_storefront_location() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:104
  • fn_ult_bootstrap_company_storefront() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:1417
  • Tygh\Storefront\Repository::findByCompanyId() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:3988
  • Tygh\Storefront\Repository::find() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:215
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:362
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00037 Re-run Backtrace
13
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 642 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:799
  • fn_seo_get_route() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_url() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:663
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:3898
  • fn_seo_url_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_get_name() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1428
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1164
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00028 Re-run Backtrace
14
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_id = b.currency_id AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_currency() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_get_currencies_list() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:537
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:6744
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00024 Re-run Backtrace
15
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_currencies AS currencies ON storefronts.storefront_id = currencies.storefront_id WHERE 1 = 1 AND (currencies.currency_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_currency() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_get_currencies_list() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:537
  • array_walk() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:6763
  • {closure}()
  • Tygh\Storefront\Repository::find() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:6761
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:362
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00019 Re-run Backtrace
16
SELECT COUNT(*) FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_currencies AS currencies ON storefronts.storefront_id = currencies.storefront_id WHERE 1 = 1 AND (currencies.currency_id IN ('2') )

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_currency() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_get_currencies_list() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:537
  • array_walk() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:6763
  • {closure}()
  • Tygh\Storefront\Repository::find() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:6761
  • Tygh\Storefront\Repository::getCount() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:371
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:427
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00014 Re-run Backtrace
17
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_company_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_get_company_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:294
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.companies.php:582
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00017 Re-run Backtrace
18
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'responsive' AND storefront_id = 1

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_layout() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • Tygh\BlockManager\Layout::getDefault() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:639
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00020 Re-run Backtrace
19
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_login_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:715
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.users.php:3322
  • fn_is_expired_storage_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:747
  • fn_get_storage_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:1036
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:1018
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00022 Re-run Backtrace
20
DELETE FROM cscart_access_restriction_block WHERE expires < 1638330024

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_login_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:715
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.users.php:3322
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:201
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
0.00012 Re-run Backtrace
21
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1638330024

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_login_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:715
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.users.php:3322
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:202
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
0.00012 Re-run Backtrace
22
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE (ip_from <= 56368180 AND ip_to >= 56368180) AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_login_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:715
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.users.php:3322
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:214
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00015 Re-run Backtrace
23
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_login_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:715
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.users.php:3322
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:223
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00007 Re-run Backtrace
24
DELETE FROM cscart_access_restriction_block WHERE expires < 1638330024

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:201
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
0.00007 Re-run Backtrace
25
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1638330024

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:202
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
0.00007 Re-run Backtrace
26
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE (ip_from <= 56368180 AND ip_to >= 56368180) AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:214
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00011 Re-run Backtrace
27
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_user() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:787
  • fn_access_restrictions_user_init() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/addons/access_restrictions/func.php:223
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00006 Re-run Backtrace
28
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /home/customer/www/sydneyutes.com.au/public_html/index.php:24
  • fn_init() /home/customer/www/sydneyutes.com.au/public_html/init.php:177
  • fn_init_templater() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:1194
  • Tygh\Development::isEnabled() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.init.php:116
  • Tygh\Development::read() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Development.php:28
  • fn_get_storage_data() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Development.php:81
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:1018
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00012 Re-run Backtrace
29
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 3

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • Tygh\BlockManager\Location::instance() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Location.php:456
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00016 Re-run Backtrace
30
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 = 3  AND l.dispatch IN ('products.view') AND (FIND_IN_SET(642, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • Tygh\BlockManager\Location::get() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Location.php:159
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Location.php:95
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00032 Re-run Backtrace
31
SELECT usergroup_ids FROM cscart_products WHERE product_id = 642

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:84
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00018 Re-run Backtrace
32
SELECT category_id FROM cscart_products_categories WHERE product_id = 642 AND link_type = 'M'

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:239
  • fn_bestsellers_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/addons/bestsellers/func.php:243
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00020 Re-run Backtrace
33
SELECT cscart_products.*, cscart_product_descriptions.*, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT( CASE   WHEN (cscart_products_categories.link_type = 'M') THEN CONCAT(cscart_products_categories.category_id, 'M')   ELSE cscart_products_categories.category_id END ORDER BY cscart_categories.company_id = 1 DESC, (cscart_products_categories.link_type = 'M') DESC, cscart_products_categories.category_position ASC, cscart_products_categories.category_id ASC) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) as price, companies.company as company_name, cscart_product_sales.amount as sales_amount, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, cscart_discussion.type as discussion_type FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0, 0, 1)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'en' LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 1 AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id  AND cscart_categories.company_id = 1 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND cscart_product_sales.category_id = 283 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 642 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = 1 LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND cscart_discussion.object_type = 'P' AND cscart_discussion.company_id = 1 WHERE cscart_products.product_id = 642  AND (companies.status IN ('A') OR cscart_products.company_id = 0) GROUP BY cscart_products.product_id

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:242
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00130 Re-run Backtrace
34
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = '642' 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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = '642' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:317
  • db_multi_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:344
  • Tygh\Database\Connection::multiQuery() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:168
0.00041 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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '642' 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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '642' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:322
  • db_multi_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:344
  • Tygh\Database\Connection::multiQuery() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:168
0.00025 Re-run Backtrace
36
SELECT COUNT(*) FROM cscart_storefronts AS storefronts  WHERE 1 = 1

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:322
  • fn_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:392
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:69
  • fn_watermarks_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:408
  • fn_is_watermarks_enabled() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:187
  • fn_get_watermark_settings() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:266
  • Tygh\Settings::instance() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:45
  • Tygh\Settings::normalizeInstanceParameters() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:163
  • Tygh\Storefront\Repository::getCount() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:243
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Storefront/Repository.php:424
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00016 Re-run Backtrace
37
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() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:322
  • fn_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:392
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:69
  • fn_watermarks_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:408
  • fn_is_watermarks_enabled() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:187
  • fn_get_watermark_settings() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:266
  • Tygh\Settings::instance() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:45
  • Tygh\Settings::reloadSections() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:172
  • Tygh\Settings::getSections() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:141
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:487
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00030 Re-run Backtrace
38
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 = 'watermark' 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:322
  • fn_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:392
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:69
  • fn_watermarks_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:408
  • fn_is_watermarks_enabled() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:187
  • fn_get_watermark_settings() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:266
  • Tygh\Settings::getValue() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:45
  • Tygh\Settings::getId() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:867
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:964
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00020 Re-run Backtrace
39
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, 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 (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.object_id = 6073 ORDER BY cscart_settings_objects.position

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:322
  • fn_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:392
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:69
  • fn_watermarks_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:408
  • fn_is_watermarks_enabled() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:187
  • fn_get_watermark_settings() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:266
  • Tygh\Settings::getValue() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:45
  • Tygh\Settings::getPlainList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:870
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Settings.php:1737
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00029 Re-run Backtrace
40
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 = 'watermark' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' 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 = 'watermark' 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() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:322
  • fn_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:392
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:69
  • fn_watermarks_attach_absolute_image_paths() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_is_need_watermark() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:408
  • fn_is_watermarks_enabled() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:187
  • fn_get_watermark_settings() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:266
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/addons/watermarks/func.php:56
  • db_multi_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:344
  • Tygh\Database\Connection::multiQuery() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:168
0.00031 Re-run Backtrace
41
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_product_prices prices WHERE prices.product_id = 642  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_product_prices() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:330
  • db_get_hash_multi_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:3183
  • Tygh\Database\Connection::getMultiHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:500
0.00031 Re-run Backtrace
42
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 642  GROUP BY c.company_id LIMIT 2

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_ult_is_shared_product() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:334
  • db_get_fields() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:1674
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00026 Re-run Backtrace
43
SELECT id_path FROM cscart_categories WHERE category_id IN (283)

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_category_ids_with_parent() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:339
  • db_get_fields() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.categories.php:1972
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00013 Re-run Backtrace
44
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.internal_name, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN cscart_product_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 642 AND cscart_product_features_values.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(267, pf.categories_path) OR FIND_IN_SET(283, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf_groups_description.description, pf_groups.feature_id, pf.position, cscart_product_features_descriptions.description, pf.feature_id 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_product_features() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:352
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.features.php:523
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00042 Re-run Backtrace
45
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.internal_name, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(267, pf.categories_path) OR FIND_IN_SET(283, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_product_features() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:352
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.features.php:630
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00076 Re-run Backtrace
46
SELECT v.feature_id,         v.value,         v.value_int,         v.variant_id,         f.feature_type,         fd.description,         fd.prefix,         fd.suffix,         vd.variant,         f.parent_id,         f.position,         gf.position as gposition,         f.display_on_header,         f.display_on_catalog,         f.display_on_product,         f.feature_code,         f.purpose FROM cscart_product_features as f LEFT JOIN cscart_product_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN cscart_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN cscart_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = f.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 642  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(267, f.categories_path) OR FIND_IN_SET(283, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.description, fv.position

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_get_product_features_list() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:355
  • db_get_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.features.php:927
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00042 Re-run Backtrace
47
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 642 GROUP BY c.company_id

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:372
  • fn_ult_get_product_data_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:104
  • fn_ult_get_shared_product_companies() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:117
  • db_get_fields() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.ultimate.php:1709
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00023 Re-run Backtrace
48
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(products.age_verification = 'Y', 'Y', IF(cscart_categories.age_verification = 'Y', 'Y', cscart_categories.parent_age_verification)) as need_age_verification, IF(products.age_limit > cscart_categories.age_limit, IF(products.age_limit > cscart_categories.parent_age_limit, products.age_limit, cscart_categories.parent_age_limit), IF(cscart_categories.age_limit > cscart_categories.parent_age_limit, cscart_categories.age_limit, cscart_categories.parent_age_limit)) as age_limit 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 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')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id WHERE 1  AND cscart_categories.company_id = 1 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 cscart_product_required_products.product_id = 642 GROUP BY products.product_id   ORDER BY products_categories.position asc, products.product_id ASC 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:103
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:372
  • fn_required_products_get_product_data_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_get_products() /home/customer/www/sydneyutes.com.au/public_html/app/addons/required_products/func.php:35
  • {closure}() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:2323
  • db_get_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:2240
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00043 Re-run Backtrace
49
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (267, 283) AND lang_code = 'en'

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_category_name() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:154
  • db_get_hash_single_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.categories.php:799
  • Tygh\Database\Connection::getSingleHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:546
0.00020 Re-run Backtrace
50
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (642) 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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (642) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_gather_additional_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:166
  • fn_gather_additional_products_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:962
  • fn_get_image_pairs() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:606
  • db_multi_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.images.php:344
  • Tygh\Database\Connection::multiQuery() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:168
0.00033 Re-run Backtrace
51
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (642) AND a.status = 'A' ORDER BY a.position

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_gather_additional_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:166
  • fn_gather_additional_products_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:962
  • fn_get_product_options() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:619
  • db_get_hash_multi_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.options.php:240
  • Tygh\Database\Connection::getMultiHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:500
0.00031 Re-run Backtrace
52
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (642) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_gather_additional_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:166
  • fn_gather_additional_products_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:962
  • fn_get_product_options() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:619
  • db_get_hash_multi_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.options.php:250
  • Tygh\Database\Connection::getMultiHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:500
0.00047 Re-run Backtrace
53
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1638330024, 1) AND IF(to_date, to_date >= 1638330024, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_gather_additional_product_data() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:166
  • fn_gather_additional_products_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:962
  • fn_promotion_apply() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:773
  • fn_get_promotions() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.promotions.php:281
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.promotions.php:197
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00056 Re-run Backtrace
54
SELECT cscart_product_files.*, cscart_product_file_descriptions.file_name, cscart_product_file_descriptions.license, cscart_product_file_descriptions.readme FROM cscart_product_files  LEFT JOIN cscart_product_file_descriptions ON cscart_product_file_descriptions.file_id = cscart_product_files.file_id AND cscart_product_file_descriptions.lang_code = 'en' WHERE 1=1  AND cscart_product_files.product_id = 642 AND preview_path != '' AND cscart_product_files.status = 'A'  ORDER BY cscart_product_files.position asc, cscart_product_file_descriptions.file_name asc

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_product_files() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:178
  • db_get_array() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.product_files.php:609
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00020 Re-run Backtrace
55
SELECT *,cscart_product_tabs.status as status,cscart_product_tabs.block_id as block_id,cscart_product_tabs.company_id as company_id,cscart_product_tabs_descriptions.name as name  FROM cscart_product_tabs LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id  WHERE cscart_product_tabs_descriptions.lang_code = 'en'  AND cscart_product_tabs.company_id = 1  ORDER BY position

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_init_product_tabs() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:185
  • Tygh\BlockManager\ProductTabs::getList() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:3750
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/ProductTabs.php:61
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00034 Re-run Backtrace
56
SELECT cscart_attachments.*, cscart_attachment_descriptions.description FROM cscart_attachments LEFT JOIN cscart_attachment_descriptions ON cscart_attachments.attachment_id = cscart_attachment_descriptions.attachment_id AND lang_code = 'en' WHERE object_type = 'product' AND object_id = 642 AND type = 'M'  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_init_product_tabs() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:185
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:3777
  • fn_attachments_init_product_tabs_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_get_attachments() /home/customer/www/sydneyutes.com.au/public_html/app/addons/attachments/func.php:455
  • db_get_array() /home/customer/www/sydneyutes.com.au/public_html/app/addons/attachments/func.php:46
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00020 Re-run Backtrace
57
SHOW COLUMNS FROM cscart_product_popularity

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_set_product_popularity() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:191
  • fn_update_product_popularity() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:293
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:3875
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
  • Tygh\Database\Connection::process() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:658
  • Tygh\Database\Connection::checkTableFields() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:927
  • Tygh\Database\Connection::getTableFields() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:1078
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:1046
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00036 Re-run Backtrace
58
INSERT INTO cscart_product_popularity (`viewed`, `added`, `deleted`, `bought`, `total`, `product_id`) VALUES (1, 0, 0, 0, 3, 642) ON DUPLICATE KEY UPDATE viewed = viewed + 1, added = added + 0, deleted = deleted + 0, bought = bought + 0, total = total + 3

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_set_product_popularity() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:191
  • fn_update_product_popularity() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:293
  • db_query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.products.php:3875
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:138
0.00021 Re-run Backtrace
59
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 642 AND user_id = 0

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/controllers/frontend/products.php:199
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00010 Re-run Backtrace
60
SELECT product_id, age_verification, age_limit FROM cscart_products WHERE product_id = 642

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/age_verification/controllers/frontend/products.post.php:23
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00013 Re-run Backtrace
61
SELECT * FROM cscart_products_categories WHERE product_id = 642

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • db_get_array() /home/customer/www/sydneyutes.com.au/public_html/app/addons/age_verification/controllers/frontend/products.post.php:40
  • Tygh\Database\Connection::getArray() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:307
0.00010 Re-run Backtrace
62
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 283

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_age_verification_category_check() /home/customer/www/sydneyutes.com.au/public_html/app/addons/age_verification/controllers/frontend/products.post.php:42
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/age_verification/func.php:77
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00009 Re-run Backtrace
63
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 267

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_age_verification_category_check() /home/customer/www/sydneyutes.com.au/public_html/app/addons/age_verification/controllers/frontend/products.post.php:42
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/age_verification/func.php:77
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00006 Re-run Backtrace
64
SELECT object_id, thread_id, type, object_type, company_id FROM cscart_discussion  WHERE 1  AND object_id = 642 AND object_type = 'P'  AND cscart_discussion.company_id = 1  

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_discussion() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/controllers/frontend/products.post.php:25
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/func.php:247
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00010 Re-run Backtrace
65
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 367  AND cscart_discussion.company_id = 1

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_discussion() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/controllers/frontend/products.post.php:25
  • fn_get_discussion_posts() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/func.php:297
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/func.php:352
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00010 Re-run Backtrace
66
SELECT AVG (dr.rating_value) FROM cscart_discussion_rating AS dr LEFT JOIN cscart_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN cscart_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 642 AND d.object_type = 'P' AND type IN ( 'B', 'R' )  AND d.company_id = 1 AND dp.status = 'A' AND dr.rating_value > 0

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_run_controller() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:434
  • include() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:685
  • fn_get_discussion() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/controllers/frontend/products.post.php:25
  • fn_discussion_get_average_object_rating() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/func.php:299
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/addons/discussion/func.php:975
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00018 Re-run Backtrace
67
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • fn_check_permissions() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:487
  • fn_check_admin_permissions() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:2502
  • db_get_fields() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:2681
  • Tygh\Database\Connection::getColumn() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:454
0.00014 Re-run Backtrace
68
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • Smarty_Internal_Template::getSubTemplate() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:132
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_61400c88b1ce40_01886207() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_styles() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/bc6537ad0e66867dce6d677756a8d77b9a6847ef.tygh.styles.tpl.php:127
  • fn_get_storage_data() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/block.styles.php:59
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:1018
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00028 Re-run Backtrace
69
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 63

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::__construct() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00022 Re-run Backtrace
70
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 63

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::__construct() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:422
0.00012 Re-run Backtrace
71
SELECT c.*, IF (c.location_id != 63, 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 = 3 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::__construct() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:345
0.00033 Re-run Backtrace
72
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 (211, 212, 221, 214) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::__construct() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Grid::getList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:133
  • db_get_hash_multi_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Grid.php:63
  • Tygh\Database\Connection::getMultiHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:500
0.00053 Re-run Backtrace
73
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 'products' 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 = 642 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (291, 292, 293, 294, 295, 296, 297, 298, 301, 304, 302, 303, 305, 306, 307, 308, 320, 321)  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() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::__construct() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Block::getList() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:137
  • db_get_hash_multi_array() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/Block.php:249
  • Tygh\Database\Connection::getMultiHash() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:500
0.00093 Re-run Backtrace
74
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::render() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:681
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c8913c924_03469023() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_eval_string() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/de131b07272511c13bd8234f19446c0c6247a876.tygh.smarty_block.tpl.php:59
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.eval_string.php:19
  • content_61734e681a18a3_42847652() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_url() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/48a0152f7027905659f3eb2746d26ec67cea9e72.string.php:23
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:3898
  • fn_seo_url_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_get_name() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1428
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1164
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00050 Re-run Backtrace
75
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::render() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:681
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c8913c924_03469023() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_eval_string() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/de131b07272511c13bd8234f19446c0c6247a876.tygh.smarty_block.tpl.php:59
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.eval_string.php:19
  • content_61734e681a18a3_42847652() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_url() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/48a0152f7027905659f3eb2746d26ec67cea9e72.string.php:25
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:3898
  • fn_seo_url_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_get_name() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1428
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1164
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00018 Re-run Backtrace
76
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 7 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /home/customer/www/sydneyutes.com.au/public_html/index.php:25
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:601
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c88ab9d93_65945710() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/278d498397023b22241bf8a6b45b5e4c0825eb6a.tygh.index.tpl.php:191
  • Tygh\BlockManager\RenderManager::render() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/BlockManager/RenderManager.php:681
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/SmartyEngine/Core.php:81
  • content_61400c8913c924_03469023() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_eval_string() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/de131b07272511c13bd8234f19446c0c6247a876.tygh.smarty_block.tpl.php:59
  • Smarty_Internal_TemplateBase::fetch() /home/customer/www/sydneyutes.com.au/public_html/app/functions/smarty_plugins/function.eval_string.php:19
  • content_61734e681a18a3_42847652() /home/customer/www/sydneyutes.com.au/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_url() /home/customer/www/sydneyutes.com.au/public_html/var/cache/templates/responsive/48a0152f7027905659f3eb2746d26ec67cea9e72.string.php:33
  • fn_set_hook() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.common.php:3898
  • fn_seo_url_post() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.control.php:123
  • fn_seo_get_name() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1428
  • db_get_row() /home/customer/www/sydneyutes.com.au/public_html/app/addons/seo/func.php:1164
  • Tygh\Database\Connection::getRow() /home/customer/www/sydneyutes.com.au/public_html/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /home/customer/www/sydneyutes.com.au/public_html/app/Tygh/Database/Connection.php:388
0.00016 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 2
Query Count Min time Max time Average time
DELETE FROM cscart_access_restriction_block WHERE expires < 1638330024
2 0.00007 0.00012 0.00009
DELETE FROM cscart_access_restriction WHERE (type = 'ipb' OR type = 'aab') AND expires < 1638330024
2 0.00007 0.00012 0.00009
SELECT COUNT(*) FROM cscart_access_restriction WHERE type='d' AND status = 'A'
2 0.00006 0.00007 0.00007
SELECT a.item_id, b.reason FROM cscart_access_restriction as a LEFT JOIN cscart_access_restriction_reason_descriptions as b ON a.item_id = b.item_id AND a.type = b.type AND lang_code = 'en' WHERE (ip_from <= 56368180 AND ip_to >= 56368180) AND a.type IN ('ips', 'ipr', 'ipb') AND status = 'A'
2 0.00011 0.00015 0.00013
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
2 0.00013 0.00017 0.00015
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, IF(products.age_verification = 'Y', 'Y', IF(cscart_categories.age_verification = 'Y', 'Y', cscart_categories.parent_age_verification)) as need_age_verification, IF(products.age_limit > cscart_categories.age_limit, IF(products.age_limit > cscart_categories.parent_age_limit, products.age_limit, cscart_categories.parent_age_limit), IF(cscart_categories.age_limit > cscart_categories.parent_age_limit, cscart_categories.age_limit, cscart_categories.parent_age_limit)) as age_limit 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 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')   LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id WHERE 1  AND cscart_categories.company_id = 1 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 cscart_product_required_products.product_id = 642 GROUP BY products.product_id   ORDER BY products_categories.position asc, products.product_id ASC 
1 0.00043 0.00043 0.00043
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (267, 283) AND lang_code = 'en'
1 0.00020 0.00020 0.00020
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (642) 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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (642) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00033 0.00033 0.00033
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en'  WHERE a.product_id IN (642) AND a.status = 'A' ORDER BY a.position
1 0.00031 0.00031 0.00031
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM cscart_product_options as a LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id WHERE c.product_id IN (642) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position
1 0.00047 0.00047 0.00047
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 642 GROUP BY c.company_id
1 0.00023 0.00023 0.00023
SELECT cscart_product_files.*, cscart_product_file_descriptions.file_name, cscart_product_file_descriptions.license, cscart_product_file_descriptions.readme FROM cscart_product_files  LEFT JOIN cscart_product_file_descriptions ON cscart_product_file_descriptions.file_id = cscart_product_files.file_id AND cscart_product_file_descriptions.lang_code = 'en' WHERE 1=1  AND cscart_product_files.product_id = 642 AND preview_path != '' AND cscart_product_files.status = 'A'  ORDER BY cscart_product_files.position asc, cscart_product_file_descriptions.file_name asc
1 0.00020 0.00020 0.00020
SELECT *,cscart_product_tabs.status as status,cscart_product_tabs.block_id as block_id,cscart_product_tabs.company_id as company_id,cscart_product_tabs_descriptions.name as name  FROM cscart_product_tabs LEFT JOIN cscart_product_tabs_descriptions ON cscart_product_tabs.tab_id = cscart_product_tabs_descriptions.tab_id LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_product_tabs.block_id  WHERE cscart_product_tabs_descriptions.lang_code = 'en'  AND cscart_product_tabs.company_id = 1  ORDER BY position
1 0.00034 0.00034 0.00034
SELECT cscart_attachments.*, cscart_attachment_descriptions.description FROM cscart_attachments LEFT JOIN cscart_attachment_descriptions ON cscart_attachments.attachment_id = cscart_attachment_descriptions.attachment_id AND lang_code = 'en' WHERE object_type = 'product' AND object_id = 642 AND type = 'M'  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status = 'A' ORDER BY position
1 0.00020 0.00020 0.00020
SHOW COLUMNS FROM cscart_product_popularity
1 0.00036 0.00036 0.00036
INSERT INTO cscart_product_popularity (`viewed`, `added`, `deleted`, `bought`, `total`, `product_id`) VALUES (1, 0, 0, 0, 3, 642) ON DUPLICATE KEY UPDATE viewed = viewed + 1, added = added + 0, deleted = deleted + 0, bought = bought + 0, total = total + 3
1 0.00021 0.00021 0.00021
SELECT subscription_id FROM cscart_product_subscriptions WHERE product_id = 642 AND user_id = 0
1 0.00010 0.00010 0.00010
SELECT product_id, age_verification, age_limit FROM cscart_products WHERE product_id = 642
1 0.00013 0.00013 0.00013
SELECT cscart_promotions.*, cscart_promotion_descriptions.name, cscart_promotion_descriptions.detailed_description, cscart_promotion_descriptions.short_description FROM cscart_promotions  LEFT JOIN cscart_promotion_descriptions ON cscart_promotion_descriptions.promotion_id = cscart_promotions.promotion_id AND cscart_promotion_descriptions.lang_code = 'en' LEFT JOIN cscart_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = cscart_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1638330024, 1) AND IF(to_date, to_date >= 1638330024, 1) AND status IN ('A', 'H') AND cscart_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY cscart_promotions.stop_other_rules desc, cscart_promotions.priority asc 
1 0.00056 0.00056 0.00056
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'sydneyutes.com.au' OR storefronts.url = 'www.sydneyutes.com.au' OR storefronts.url LIKE 'www_.sydneyutes.com.au' OR storefronts.url LIKE 'sydneyutes.com.au/%' OR storefronts.url LIKE 'www.sydneyutes.com.au/%' OR storefronts.url LIKE 'www_.sydneyutes.com.au/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'sydneyutes.com.au' DESC, storefronts.url = 'www.sydneyutes.com.au' DESC, storefronts.url LIKE 'www_.sydneyutes.com.au' DESC, storefronts.url LIKE 'sydneyutes.com.au/%' DESC, storefronts.url LIKE 'www.sydneyutes.com.au/%' DESC, storefronts.url LIKE 'www_.sydneyutes.com.au/%' desc 
1 0.00049 0.00049 0.00049
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.internal_name, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp FROM cscart_product_features AS pf LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM cscart_product_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(267, pf.categories_path) OR FIND_IN_SET(283, pf.categories_path) ) ORDER BY pf.position, cscart_product_features_descriptions.description
1 0.00076 0.00076 0.00076
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 63
1 0.00022 0.00022 0.00022
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 30 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00018 0.00018 0.00018
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 2 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00050 0.00050 0.00050
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 'products' 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 = 642 AND dynamic_object_content.object_type like 'products' WHERE cscart_bm_snapping.grid_id IN (291, 292, 293, 294, 295, 296, 297, 298, 301, 304, 302, 303, 305, 306, 307, 308, 320, 321)  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.00093 0.00093 0.00093
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 (211, 212, 221, 214) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00053 0.00053 0.00053
SELECT c.*, IF (c.location_id != 63, 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 = 3 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER')
1 0.00033 0.00033 0.00033
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 63
1 0.00012 0.00012 0.00012
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00028 0.00028 0.00028
SELECT * FROM cscart_products_categories WHERE product_id = 642
1 0.00010 0.00010 0.00010
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00014 0.00014 0.00014
SELECT AVG (dr.rating_value) FROM cscart_discussion_rating AS dr LEFT JOIN cscart_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN cscart_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 642 AND d.object_type = 'P' AND type IN ( 'B', 'R' )  AND d.company_id = 1 AND dp.status = 'A' AND dr.rating_value > 0
1 0.00018 0.00018 0.00018
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 367  AND cscart_discussion.company_id = 1
1 0.00010 0.00010 0.00010
SELECT object_id, thread_id, type, object_type, company_id FROM cscart_discussion  WHERE 1  AND object_id = 642 AND object_type = 'P'  AND cscart_discussion.company_id = 1  
1 0.00010 0.00010 0.00010
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 267
1 0.00006 0.00006 0.00006
SELECT category_id, parent_id, age_verification, age_limit FROM cscart_categories WHERE category_id = 283
1 0.00009 0.00009 0.00009
SELECT v.feature_id,         v.value,         v.value_int,         v.variant_id,         f.feature_type,         fd.description,         fd.prefix,         fd.suffix,         vd.variant,         f.parent_id,         f.position,         gf.position as gposition,         f.display_on_header,         f.display_on_catalog,         f.display_on_product,         f.feature_code,         f.purpose FROM cscart_product_features as f LEFT JOIN cscart_product_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN cscart_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN cscart_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN cscart_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN cscart_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = f.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 642  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(267, f.categories_path) OR FIND_IN_SET(283, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM cscart_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.description, fv.position
1 0.00042 0.00042 0.00042
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM cscart_product_prices prices WHERE prices.product_id = 642  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
1 0.00031 0.00031 0.00031
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.internal_name, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf  LEFT JOIN cscart_product_features AS pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN cscart_product_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' INNER JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 642 AND cscart_product_features_values.lang_code = 'en' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(267, pf.categories_path) OR FIND_IN_SET(283, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf_groups_description.description, pf_groups.feature_id, pf.position, cscart_product_features_descriptions.description, pf.feature_id 
1 0.00042 0.00042 0.00042
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00022 0.00022 0.00022
SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'
1 0.00022 0.00022 0.00022
SET time_zone = '+03:00'
1 0.00008 0.00008 0.00008
SELECT company_id, storefront, secure_storefront FROM cscart_companies WHERE company_id = 1
1 0.00037 0.00037 0.00037
SELECT type FROM cscart_seo_names WHERE name = 'sports-bar-isuzu-ute-d-max-2008-12'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)
1 0.00040 0.00040 0.00040
SELECT * FROM cscart_seo_names WHERE name = 'sports-bar-isuzu-ute-d-max-2008-12'  AND cscart_seo_names.company_id IN (0, 1) AND lang_code = 'en'
1 0.00023 0.00023 0.00023
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.00021 0.00021 0.00021
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  LEFT JOIN cscart_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = cscart_languages.lang_id WHERE 1 AND cscart_languages.status = 'A'AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)   
1 0.00018 0.00018 0.00018
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.00037 0.00037 0.00037
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 642 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)
1 0.00028 0.00028 0.00028
SELECT a.*, b.description FROM cscart_currencies as a LEFT JOIN cscart_currency_descriptions as b ON a.currency_id = b.currency_id AND lang_code = 'en'  WHERE 1  AND a.is_primary = 'Y' ORDER BY a.position
1 0.00024 0.00024 0.00024
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_currencies AS currencies ON storefronts.storefront_id = currencies.storefront_id WHERE 1 = 1 AND (currencies.currency_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00019 0.00019 0.00019
SELECT COUNT(*) FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_currencies AS currencies ON storefronts.storefront_id = currencies.storefront_id WHERE 1 = 1 AND (currencies.currency_id IN ('2') )
1 0.00014 0.00014 0.00014
SELECT companies.* FROM cscart_companies AS companies  WHERE companies.company_id = 1 
1 0.00017 0.00017 0.00017
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'responsive' AND storefront_id = 1
1 0.00020 0.00020 0.00020
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00012 0.00012 0.00012
SELECT id_path FROM cscart_categories WHERE category_id IN (283)
1 0.00013 0.00013 0.00013
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 3
1 0.00016 0.00016 0.00016
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 = 3  AND l.dispatch IN ('products.view') AND (FIND_IN_SET(642, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00032 0.00032 0.00032
SELECT usergroup_ids FROM cscart_products WHERE product_id = 642
1 0.00018 0.00018 0.00018
SELECT category_id FROM cscart_products_categories WHERE product_id = 642 AND link_type = 'M'
1 0.00020 0.00020 0.00020
SELECT cscart_products.*, cscart_product_descriptions.*, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT( CASE   WHEN (cscart_products_categories.link_type = 'M') THEN CONCAT(cscart_products_categories.category_id, 'M')   ELSE cscart_products_categories.category_id END ORDER BY cscart_categories.company_id = 1 DESC, (cscart_products_categories.link_type = 'M') DESC, cscart_products_categories.category_position ASC, cscart_products_categories.category_id ASC) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100))) as price, companies.company as company_name, cscart_product_sales.amount as sales_amount, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, cscart_discussion.type as discussion_type FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0, 0, 1)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'en' LEFT JOIN cscart_ult_product_prices shared_prices ON shared_prices.product_id = cscart_products.product_id AND shared_prices.company_id = 1 AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies as companies ON companies.company_id = cscart_products.company_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id  AND cscart_categories.company_id = 1 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND cscart_product_sales.category_id = 283 LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 642 AND cscart_seo_names.type = 'p' AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'en' AND cscart_seo_names.company_id = 1 LEFT JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND cscart_discussion.object_type = 'P' AND cscart_discussion.company_id = 1 WHERE cscart_products.product_id = 642  AND (companies.status IN ('A') OR cscart_products.company_id = 0) GROUP BY cscart_products.product_id
1 0.00130 0.00130 0.00130
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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = '642' 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 = 'product' AND cscart_images_links.type = 'A' AND cscart_images_links.object_id = '642' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00041 0.00041 0.00041
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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '642' 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 = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '642' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00025 0.00025 0.00025
SELECT COUNT(*) 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.00030 0.00030 0.00030
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 = 'watermark' 
1 0.00020 0.00020 0.00020
SELECT cscart_settings_objects.object_id as object_id, cscart_settings_objects.type as object_type, 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 (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.object_id = 6073 ORDER BY cscart_settings_objects.position
1 0.00029 0.00029 0.00029
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 = 'watermark' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '1' 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 = 'watermark' 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.00031 0.00031 0.00031
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
1 0.00025 0.00025 0.00025
SELECT c.company_id FROM cscart_products_categories pc LEFT JOIN cscart_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 642  GROUP BY c.company_id LIMIT 2
1 0.00026 0.00026 0.00026
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 7 AND `type` = 'a' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00016 0.00016 0.00016