SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'bacpvdev2.tabo.vn' OR storefronts.url = 'www.bacpvdev2.tabo.vn' OR storefronts.url LIKE 'www_.bacpvdev2.tabo.vn' OR storefronts.url LIKE 'bacpvdev2.tabo.vn/%' OR storefronts.url LIKE 'www.bacpvdev2.tabo.vn/%' OR storefronts.url LIKE 'www_.bacpvdev2.tabo.vn/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'bacpvdev2.tabo.vn' DESC, storefronts.url = 'www.bacpvdev2.tabo.vn' DESC, storefronts.url LIKE 'www_.bacpvdev2.tabo.vn' DESC, storefronts.url LIKE 'bacpvdev2.tabo.vn/%' DESC, storefronts.url LIKE 'www.bacpvdev2.tabo.vn/%' DESC, storefronts.url LIKE 'www_.bacpvdev2.tabo.vn/%' desc 

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_redirect_to_regional_storefront() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• Tygh\Storefront\Repository::findByUrl() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1458
• Tygh\Storefront\Repository::find() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Repository.php:126
• Tygh\Database\Connection::getHash() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Repository.php:370
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:371

SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_http_params_by_storefront() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• Tygh\Storefront\Storefront::__call() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1615
• Tygh\Storefront\Storefront::getRelationValue() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Storefront.php:235
• Tygh\Storefront\RelationsManager::getRelationValue() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Storefront.php:273
• Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/RelationsManager.php:80
• Tygh\Database\Connection::getColumn() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/RelationsManager.php:116
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:480

SELECT entry_page FROM cscart_companies WHERE company_id = 1 AND redirect_customer != 'Y'

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_company_id() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:439
• fn_ult_init_company_id() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:104
• db_get_field() /var/www/bacpvdev.tabo.vn/app/functions/fn.ultimate.php:584
• Tygh\Database\Connection::getField() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:73
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:448

SET time_zone = '+07:00'

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_settings() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_init_time_zone() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1064
• db_query() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1085
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:138

SHOW TABLES LIKE 'cscart_erp_settings'

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• fn_erp_init() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:46
• Tygh\Database\Connection::getField() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/functions/fn.erp_init.php:37
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:448

SHOW TABLES LIKE 'cscart_erp_settings_company'

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• fn_erp_init() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:46
• Tygh\Database\Connection::getField() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/functions/fn.erp_init.php:56
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:448

SELECT * FROM cscart_erp_settings_company

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• fn_erp_init() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:46
• Tygh\Registry::getOrSetCache() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/functions/fn.erp_init.php:69
• {closure}() /var/www/bacpvdev.tabo.vn/app/Tygh/Registry.php:800
• db_get_array() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/functions/fn.erp_init.php:63
• Tygh\Database\Connection::getArray() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:35
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:333

SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• Tygh\Application::offsetGet() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:50
• Pimple\Container::offsetGet() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:135
• Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
• Tygh\Storefront\Repository::findById() /var/www/bacpvdev.tabo.vn/app/Tygh/Providers/StorefrontProvider.php:186
• Tygh\Storefront\Repository::find() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Repository.php:164
• Tygh\Database\Connection::getHash() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Repository.php:373
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:371

SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• Tygh\Application::offsetGet() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:50
• Pimple\Container::offsetGet() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:135
• Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
• Tygh\Storefront\Storefront::__call() /var/www/bacpvdev.tabo.vn/app/Tygh/Providers/StorefrontProvider.php:191
• Tygh\Storefront\Storefront::getRelationValue() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Storefront.php:235
• Tygh\Storefront\RelationsManager::getRelationValue() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Storefront.php:273
• Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/RelationsManager.php:80
• Tygh\Database\Connection::getColumn() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/RelationsManager.php:116
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:480

SELECT * FROM cscart_erp_warehouse WHERE company_id=1

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• Models\WarehouseModel::getWarehousesByCompany() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:55
• db_get_hash_array() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/Models/WarehouseModel.php:270
• Tygh\Database\Connection::getHash() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:48
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:371

SELECT warehouse_id FROM cscart_erp_warehouse WHERE company_id=1 AND is_main='Y'

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_addons() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_load_addon() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1141
• Tygh\Addons\XmlScheme4::loadAddon() /var/www/bacpvdev.tabo.vn/app/functions/fn.addons.php:1682
• Tygh\Addons\Loader::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/XmlScheme4.php:34
• Tygh\Application::bootstrap() /var/www/bacpvdev.tabo.vn/app/Tygh/Addons/Loader.php:59
• Tygh\Addons\ErpSystem\Bootstrap::boot() /var/www/bacpvdev.tabo.vn/app/Tygh/Application.php:98
• Pimple\Container::register() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/Bootstrap.php:68
• Tygh\Addons\ErpSystem\ServiceProvider::register() /var/www/bacpvdev.tabo.vn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:297
• Models\WarehouseModel::geWarehouseIdMain() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/src/ServiceProvider.php:82
• db_get_field() /var/www/bacpvdev.tabo.vn/app/addons/tabo_erp_system/Models/WarehouseModel.php:154
• Tygh\Database\Connection::getField() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:73
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:448

SELECT company_id, storefront, secure_storefront FROM cscart_companies WHERE company_id = 1

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_get_request_uri() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:830
• fn_get_storefront_urls() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:1161
• db_get_row() /var/www/bacpvdev.tabo.vn/app/functions/fn.ultimate.php:3608
• Tygh\Database\Connection::getRow() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:60
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:414

SELECT type FROM cscart_seo_names WHERE name = 'banh-keo'  AND ( cscart_seo_names.company_id = 1 OR cscart_seo_names.company_id = 0)

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:841
• fn_seo_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:123
• db_get_field() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:662
• Tygh\Database\Connection::getField() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:73
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:448

SELECT * FROM cscart_seo_names WHERE name = 'banh-keo'  AND cscart_seo_names.company_id IN (0, 1) 

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:841
• fn_seo_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:123
• db_get_array() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:666
• Tygh\Database\Connection::getArray() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:35
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:333

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() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:841
• fn_seo_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:123
• fn_seo_validate_object() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:705
• Tygh\Languages\Languages::getSimpleLanguages() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:1091
• db_get_hash_single_array() /var/www/bacpvdev.tabo.vn/app/Tygh/Languages/Languages.php:515
• Tygh\Database\Connection::getSingleHash() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:111
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:572

SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:841
• fn_seo_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:123
• fn_url() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:820
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.common.php:3836
• fn_ult_url_before_get_storefront_location() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:104
• fn_ult_bootstrap_company_storefront() /var/www/bacpvdev.tabo.vn/app/functions/fn.ultimate.php:1575
• Tygh\Storefront\Repository::findByCompanyId() /var/www/bacpvdev.tabo.vn/app/functions/fn.ultimate.php:4148
• Tygh\Storefront\Repository::find() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Repository.php:216
• Tygh\Database\Connection::getHash() /var/www/bacpvdev.tabo.vn/app/Tygh/Storefront/Repository.php:373
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:371

SELECT name, path FROM cscart_seo_names WHERE `object_id` = 10 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND cscart_seo_names.company_id IN (0, 1)

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:841
• fn_seo_get_route() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:123
• fn_url() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:820
• fn_set_hook() /var/www/bacpvdev.tabo.vn/app/functions/fn.common.php:3951
• fn_seo_url_post() /var/www/bacpvdev.tabo.vn/app/functions/fn.control.php:123
• fn_seo_get_name() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:1607
• db_get_row() /var/www/bacpvdev.tabo.vn/app/addons/seo/func.php:1337
• Tygh\Database\Connection::getRow() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:60
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:414

SELECT companies.*, AVG(cscart_discussion_rating.rating_value) AS average_rating, CONCAT(companies.company_id, '_', IF ( cscart_discussion_rating.thread_id, cscart_discussion_rating.thread_id, '0')) AS company_thread_ids FROM cscart_companies AS companies  LEFT JOIN cscart_discussion ON cscart_discussion.object_id = companies.company_id AND cscart_discussion.object_type = 'M' LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.thread_id = cscart_discussion.thread_id AND cscart_discussion_posts.status = 'A' LEFT JOIN cscart_discussion_rating ON cscart_discussion.thread_id = cscart_discussion_rating.thread_id AND cscart_discussion_rating.post_id = cscart_discussion_posts.post_id WHERE companies.company_id = 1 

Backtrace

• require() /var/www/bacpvdev.tabo.vn/index.php:19
• fn_init() /var/www/bacpvdev.tabo.vn/init.php:198
• fn_init_company_data() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:1234
• fn_get_company_data() /var/www/bacpvdev.tabo.vn/app/functions/fn.init.php:330
• db_get_row() /var/www/bacpvdev.tabo.vn/app/functions/fn.companies.php:617
• Tygh\Database\Connection::getRow() /var/www/bacpvdev.tabo.vn/app/functions/fn.database.php:60
• Tygh\Database\Connection::query() /var/www/bacpvdev.tabo.vn/app/Tygh/Database/Connection.php:414

SELECT a.object_id, COUNT(b.post_id) as total_items FROM cscart_discussion as a LEFT JOIN cscart_discussion_posts as b ON a.thread_id=b.thread_id WHERE a.object_type = 'M' AND b.status = 'A' GROUP BY a.object_id