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

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_init_redirect_to_regional_storefront() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • Tygh\Storefront\Repository::findByUrl() /var/www/source/chusvn/app/functions/fn.init.php:1421
  • Tygh\Storefront\Repository::find() /var/www/source/chusvn/app/Tygh/Storefront/Repository.php:126
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/Tygh/Storefront/Repository.php:360
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00056 Re-run Backtrace
2
SET time_zone = '+07:00'

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_init_settings() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_init_time_zone() /var/www/source/chusvn/app/functions/fn.init.php:1035
  • db_query() /var/www/source/chusvn/app/functions/fn.init.php:1056
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/functions/fn.database.php:138
0.00016 Re-run Backtrace
3
SELECT type FROM cscart_seo_names WHERE name = 'phu-kien-dien-thoai-vi' 

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_get_route() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/source/chusvn/app/functions/fn.control.php:123
  • db_get_field() /var/www/source/chusvn/app/addons/seo/func.php:616
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00074 Re-run Backtrace
4
SELECT * FROM cscart_seo_names WHERE name = 'phu-kien-dien-thoai-vi'  AND lang_code = 'vi'

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_get_route() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/source/chusvn/app/functions/fn.control.php:123
  • db_get_array() /var/www/source/chusvn/app/addons/seo/func.php:620
  • Tygh\Database\Connection::getArray() /var/www/source/chusvn/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:333
0.00040 Re-run Backtrace
5
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_get_route() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_seo_validate_object() /var/www/source/chusvn/app/addons/seo/func.php:659
  • Tygh\Languages\Languages::getSimpleLanguages() /var/www/source/chusvn/app/addons/seo/func.php:1013
  • db_get_hash_single_array() /var/www/source/chusvn/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /var/www/source/chusvn/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:572
0.00027 Re-run Backtrace
6
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/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_get_route() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_url() /var/www/source/chusvn/app/addons/seo/func.php:745
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.common.php:3924
  • fn_seo_url_post() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_get_seo_settings() /var/www/source/chusvn/app/addons/seo/func.php:1416
  • Tygh\Application::offsetGet() /var/www/source/chusvn/app/addons/seo/func.php:2134
  • Pimple\Container::offsetGet() /var/www/source/chusvn/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/source/chusvn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118
  • Tygh\Storefront\Repository::findById() /var/www/source/chusvn/app/Tygh/Providers/StorefrontProvider.php:186
  • Tygh\Storefront\Repository::find() /var/www/source/chusvn/app/Tygh/Storefront/Repository.php:164
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/Tygh/Storefront/Repository.php:363
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00039 Re-run Backtrace
7
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 152 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'vi' 

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_get_route() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_url() /var/www/source/chusvn/app/addons/seo/func.php:745
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.common.php:3924
  • fn_seo_url_post() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/source/chusvn/app/addons/seo/func.php:1525
  • db_get_row() /var/www/source/chusvn/app/addons/seo/func.php:1259
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00048 Re-run Backtrace
8
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'chus' AND storefront_id = 1

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_init_layout() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • Tygh\BlockManager\Layout::getDefault() /var/www/source/chusvn/app/functions/fn.init.php:659
  • db_get_row() /var/www/source/chusvn/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00035 Re-run Backtrace
9
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_init_user() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • fn_login_user() /var/www/source/chusvn/app/functions/fn.init.php:730
  • fn_init_user() /var/www/source/chusvn/app/functions/fn.users.php:3493
  • fn_is_expired_storage_data() /var/www/source/chusvn/app/functions/fn.init.php:762
  • fn_get_storage_data() /var/www/source/chusvn/app/functions/fn.control.php:1080
  • db_get_row() /var/www/source/chusvn/app/functions/fn.control.php:1062
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00024 Re-run Backtrace
10
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /var/www/source/chusvn/index.php:26
  • fn_init() /var/www/source/chusvn/init.php:179
  • fn_init_templater() /var/www/source/chusvn/app/functions/fn.init.php:1198
  • Tygh\Development::isEnabled() /var/www/source/chusvn/app/functions/fn.init.php:116
  • Tygh\Development::read() /var/www/source/chusvn/app/Tygh/Development.php:28
  • fn_get_storage_data() /var/www/source/chusvn/app/Tygh/Development.php:81
  • db_get_row() /var/www/source/chusvn/app/functions/fn.control.php:1062
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00026 Re-run Backtrace
11
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 3

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::instance() /var/www/source/chusvn/app/controllers/frontend/init.php:143
  • Tygh\BlockManager\Layout::get() /var/www/source/chusvn/app/Tygh/BlockManager/Location.php:476
  • db_get_row() /var/www/source/chusvn/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00045 Re-run Backtrace
12
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'vi' WHERE l.layout_id = 3  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(152, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /var/www/source/chusvn/app/controllers/frontend/init.php:143
  • Tygh\BlockManager\Location::getList() /var/www/source/chusvn/app/Tygh/BlockManager/Location.php:166
  • db_get_hash_array() /var/www/source/chusvn/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00058 Re-run Backtrace
13
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 152

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • db_get_field() /var/www/source/chusvn/app/controllers/frontend/categories.php:40
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00028 Re-run Backtrace
14
SELECT category_id FROM cscart_categories WHERE category_id = 152  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • db_get_field() /var/www/source/chusvn/app/controllers/frontend/categories.php:60
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00031 Re-run Backtrace
15
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 152  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_categories.category_id = 152 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_category_data() /var/www/source/chusvn/app/controllers/frontend/categories.php:74
  • db_get_row() /var/www/source/chusvn/app/functions/fn.categories.php:812
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00076 Re-run Backtrace
16
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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '152' 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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '152' ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_category_data() /var/www/source/chusvn/app/controllers/frontend/categories.php:74
  • fn_get_image_pairs() /var/www/source/chusvn/app/functions/fn.categories.php:829
  • db_multi_query() /var/www/source/chusvn/app/functions/fn.images.php:344
  • Tygh\Database\Connection::multiQuery() /var/www/source/chusvn/app/functions/fn.database.php:168
0.00093 Re-run Backtrace
17
SELECT id_path FROM cscart_categories WHERE category_id = 152

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/source/chusvn/app/controllers/frontend/categories.php:76
  • fn_get_categories() /var/www/source/chusvn/app/functions/fn.categories.php:60
  • db_get_field() /var/www/source/chusvn/app/functions/fn.categories.php:351
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00032 Re-run Backtrace
18
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_categories.svg_icon,cscart_categories.product_spin_ids,cscart_categories.banner_url,cscart_categories.banner_url_eng,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (152) AND cscart_categories.id_path LIKE '99/152/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.category_type in ('C')   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/source/chusvn/app/controllers/frontend/categories.php:76
  • fn_get_categories() /var/www/source/chusvn/app/functions/fn.categories.php:60
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.categories.php:444
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00140 Re-run Backtrace
19
SELECT cscart_product_filters.*, cscart_product_features.feature_type FROM cscart_product_filters LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filters.feature_id WHERE cscart_product_filters.filter_id IN (1) AND cscart_product_filters.status = 'A'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products() /var/www/source/chusvn/app/controllers/frontend/categories.php:174
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.products.php:1886
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00038 Re-run Backtrace
20
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (152)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products() /var/www/source/chusvn/app/controllers/frontend/categories.php:174
  • db_get_fields() /var/www/source/chusvn/app/functions/fn.products.php:1936
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00068 Re-run Backtrace
21
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products() /var/www/source/chusvn/app/controllers/frontend/categories.php:174
  • Tygh\Storefront\Storefront::__call() /var/www/source/chusvn/app/functions/fn.products.php:2013
  • Tygh\Storefront\Storefront::getRelationValue() /var/www/source/chusvn/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /var/www/source/chusvn/app/Tygh/Storefront/Storefront.php:273
  • Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/source/chusvn/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00022 Re-run Backtrace
22
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, cscart_product_review_prepared_data.average_rating average_rating, cscart_product_review_prepared_data.reviews_count product_reviews_count FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'vi'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = products.product_id AND cscart_product_review_prepared_data.storefront_id = 0 LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (152) AND products.product_id NOT IN (0) AND companies.status IN ('A') AND prices.price >= 500000.00 AND prices.price <= 1000000.00 AND (products.amount > 0 OR products.tracking = 'D') 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 prices_2.price IS NULL GROUP BY product_id   ORDER BY popularity.total desc, products.product_id ASC  LIMIT 0, 32

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products() /var/www/source/chusvn/app/controllers/frontend/categories.php:174
  • {closure}() /var/www/source/chusvn/app/functions/fn.products.php:2456
  • db_get_array() /var/www/source/chusvn/app/functions/fn.products.php:2373
  • Tygh\Database\Connection::getArray() /var/www/source/chusvn/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:333
0.02210 Re-run Backtrace
23
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products() /var/www/source/chusvn/app/controllers/frontend/categories.php:174
  • {closure}() /var/www/source/chusvn/app/functions/fn.products.php:2456
  • db_get_found_rows() /var/www/source/chusvn/app/functions/fn.products.php:2376
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:311
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00021 Re-run Backtrace
24
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'vi' AND lang.name = 'products_multicolumns'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products_layout() /var/www/source/chusvn/app/controllers/frontend/categories.php:205
  • fn_get_products_views() /var/www/source/chusvn/app/functions/fn.products.php:2858
  • __() /var/www/source/chusvn/app/functions/fn.products.php:2813
  • Tygh\Languages\Values::getLangVar() /var/www/source/chusvn/app/functions/fn.common.php:6054
  • db_get_field() /var/www/source/chusvn/app/Tygh/Languages/Values.php:171
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00040 Re-run Backtrace
25
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products_layout() /var/www/source/chusvn/app/controllers/frontend/categories.php:205
  • fn_get_products_views() /var/www/source/chusvn/app/functions/fn.products.php:2858
  • __() /var/www/source/chusvn/app/functions/fn.products.php:2813
  • Tygh\Languages\Values::getLangVar() /var/www/source/chusvn/app/functions/fn.common.php:6054
  • db_get_found_rows() /var/www/source/chusvn/app/Tygh/Languages/Values.php:173
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:311
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00016 Re-run Backtrace
26
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 152

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_products_layout() /var/www/source/chusvn/app/controllers/frontend/categories.php:205
  • db_get_row() /var/www/source/chusvn/app/functions/fn.products.php:2864
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00027 Re-run Backtrace
27
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (99) AND lang_code = 'vi'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_category_name() /var/www/source/chusvn/app/controllers/frontend/categories.php:222
  • db_get_hash_single_array() /var/www/source/chusvn/app/functions/fn.categories.php:909
  • Tygh\Database\Connection::getSingleHash() /var/www/source/chusvn/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:572
0.00031 Re-run Backtrace
28
SELECT feature_id, feature_type FROM cscart_product_features WHERE feature_id IN (23212)

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_get_feature_type_map() /var/www/source/chusvn/app/functions/fn.filters.php:1675
  • db_get_array() /var/www/source/chusvn/app/functions/fn.filters.php:1056
  • Tygh\Database\Connection::getArray() /var/www/source/chusvn/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:333
0.00031 Re-run Backtrace
29
SELECT cscart_product_filters.*, cscart_product_features.feature_type FROM cscart_product_filters LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filters.feature_id WHERE cscart_product_filters.filter_id IN (1) AND cscart_product_filters.status = 'A'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_get_products_conditions() /var/www/source/chusvn/app/functions/fn.filters.php:1690
  • fn_get_products() /var/www/source/chusvn/app/functions/fn.filters.php:1092
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.products.php:1886
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00038 Re-run Backtrace
30
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (152)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_get_products_conditions() /var/www/source/chusvn/app/functions/fn.filters.php:1690
  • fn_get_products() /var/www/source/chusvn/app/functions/fn.filters.php:1092
  • db_get_fields() /var/www/source/chusvn/app/functions/fn.products.php:1936
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00058 Re-run Backtrace
31
CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND prices.price >= 500000.00 AND prices.price <= 1000000.00 AND (products.amount > 0 OR products.tracking = 'D') 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 prices_2.price IS NULL ORDER BY NULL

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_get_products_conditions() /var/www/source/chusvn/app/functions/fn.filters.php:1690
  • fn_product_filters_create_temporary_products_table() /var/www/source/chusvn/app/functions/fn.filters.php:1098
  • db_query() /var/www/source/chusvn/app/functions/fn.filters.php:1150
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/functions/fn.database.php:138
0.01621 Re-run Backtrace
32
SELECT cscart_product_features_values.feature_id, cscart_product_features_values.variant_id FROM cscart_product_features_values INNER JOIN _product_filters_products_1 AS products ON products.product_id = cscart_product_features_values.product_id   WHERE cscart_product_features_values.feature_id IN (23212) AND cscart_product_features_values.lang_code = 'vi'   GROUP BY cscart_product_features_values.variant_id ORDER BY NULL

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • db_get_hash_single_array() /var/www/source/chusvn/app/functions/fn.filters.php:1705
  • Tygh\Database\Connection::getSingleHash() /var/www/source/chusvn/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:572
0.00084 Re-run Backtrace
33
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (152)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_get_products_conditions() /var/www/source/chusvn/app/functions/fn.filters.php:1855
  • fn_get_products() /var/www/source/chusvn/app/functions/fn.filters.php:1092
  • db_get_fields() /var/www/source/chusvn/app/functions/fn.products.php:1936
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00057 Re-run Backtrace
34
CREATE TEMPORARY TABLE _product_filters_products_2 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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') ORDER BY NULL

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_get_products_conditions() /var/www/source/chusvn/app/functions/fn.filters.php:1855
  • fn_product_filters_create_temporary_products_table() /var/www/source/chusvn/app/functions/fn.filters.php:1098
  • db_query() /var/www/source/chusvn/app/functions/fn.filters.php:1150
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/functions/fn.database.php:138
0.01532 Re-run Backtrace
35
SELECT cscart_products_categories.category_id as variant_id, cd.category as variant FROM cscart_products_categories   LEFT JOIN cscart_products as products ON products.product_id = cscart_products_categories.product_id
                LEFT JOIN cscart_category_descriptions cd ON cscart_products_categories.category_id = cd.category_id AND lang_code = 'vi'  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1   AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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') GROUP BY cscart_products_categories.category_id ORDER BY cd.category ASC

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.filters.php:1947
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.01763 Re-run Backtrace
36
SELECT cscart_product_reviews.rating_value as variant_id, cscart_product_review_start.rating_title as variant FROM cscart_product_reviews   LEFT JOIN cscart_products as products ON products.product_id = cscart_product_reviews.product_id 
                INNER JOIN cscart_product_review_start ON cscart_product_review_start.rating_value = cscart_product_reviews.rating_value AND lang_code = 'vi'  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1   AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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') GROUP BY cscart_product_reviews.rating_value ORDER BY cscart_product_review_start.rating_title DESC

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.filters.php:1947
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.08096 Re-run Backtrace
37
SELECT MIN(cscart_product_prices.price) as min, MAX(cscart_product_prices.price) as max FROM cscart_product_prices   LEFT JOIN cscart_products as products ON products.product_id = cscart_product_prices.product_id
                    LEFT JOIN cscart_product_prices as prices_2 ON cscart_product_prices.product_id = prices_2.product_id AND cscart_product_prices.price > prices_2.price AND prices_2.lower_limit = 1 AND prices_2.usergroup_id IN (0, 0, 1) INNER JOIN _product_filters_products_2 ON products.product_id = _product_filters_products_2.product_id  WHERE products.status IN ('A') 
                    AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • db_get_row() /var/www/source/chusvn/app/functions/fn.filters.php:1929
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00288 Re-run Backtrace
38
DROP TEMPORARY TABLE _product_filters_products_1

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_drop_temporary_products_tables() /var/www/source/chusvn/app/functions/fn.filters.php:1977
  • db_query() /var/www/source/chusvn/app/functions/fn.filters.php:1183
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/functions/fn.database.php:138
0.00024 Re-run Backtrace
39
DROP TEMPORARY TABLE _product_filters_products_2

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_product_filters_get_filters_products_count() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:22
  • fn_product_filters_get_current_filters() /var/www/source/chusvn/app/functions/fn.filters.php:1340
  • fn_product_filters_drop_temporary_products_tables() /var/www/source/chusvn/app/functions/fn.filters.php:1977
  • db_query() /var/www/source/chusvn/app/functions/fn.filters.php:1183
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/functions/fn.database.php:138
0.00014 Re-run Backtrace
40
SELECT id_path FROM cscart_categories WHERE category_id = 99

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:35
  • fn_get_categories() /var/www/source/chusvn/app/functions/fn.categories.php:60
  • db_get_field() /var/www/source/chusvn/app/functions/fn.categories.php:351
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00028 Re-run Backtrace
41
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_categories.svg_icon,cscart_categories.product_spin_ids,cscart_categories.banner_url,cscart_categories.banner_url_eng,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (99) AND cscart_categories.id_path LIKE '99/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.category_type in ('C')   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:35
  • fn_get_categories() /var/www/source/chusvn/app/functions/fn.categories.php:60
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.categories.php:444
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00208 Re-run Backtrace
42
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(141, 142, 143, 144, 145, 146, 149, 153, 150, 152, 151) 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:35
  • fn_get_categories() /var/www/source/chusvn/app/functions/fn.categories.php:60
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.categories.php:487
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00034 Re-run Backtrace
43
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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (141, 142, 143, 144, 145, 146, 149, 153, 150, 152, 151) 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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (141, 142, 143, 144, 145, 146, 149, 153, 150, 152, 151) ORDER BY cscart_images_links.position, cscart_images_links.pair_id

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_run_controller() /var/www/source/chusvn/app/functions/fn.control.php:458
  • include() /var/www/source/chusvn/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/source/chusvn/app/addons/dosiin/controllers/frontend/categories.post.php:35
  • fn_get_categories() /var/www/source/chusvn/app/functions/fn.categories.php:60
  • fn_get_image_pairs() /var/www/source/chusvn/app/functions/fn.categories.php:550
  • db_multi_query() /var/www/source/chusvn/app/functions/fn.images.php:344
  • Tygh\Database\Connection::multiQuery() /var/www/source/chusvn/app/functions/fn.database.php:168
0.00125 Re-run Backtrace
44
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_check_permissions() /var/www/source/chusvn/app/functions/fn.control.php:517
  • fn_check_admin_permissions() /var/www/source/chusvn/app/functions/fn.common.php:2524
  • db_get_fields() /var/www/source/chusvn/app/functions/fn.common.php:2706
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00038 Re-run Backtrace
45
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 152 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.control.php:623
  • fn_seo_dispatch_before_display() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_url() /var/www/source/chusvn/app/addons/seo/func.php:3017
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.common.php:3924
  • fn_seo_url_post() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/source/chusvn/app/addons/seo/func.php:1525
  • db_get_row() /var/www/source/chusvn/app/addons/seo/func.php:1259
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00049 Re-run Backtrace
46
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • Smarty_Internal_Template::getSubTemplate() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:152
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_684251261f3386_41010353() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_styles() /var/www/source/chusvn/var/cache/templates/chus/8a1907a5c75af69ea3ecd408ba38d293316d1ba7.tygh.styles.tpl.php:153
  • fn_get_storage_data() /var/www/source/chusvn/app/functions/smarty_plugins/block.styles.php:133
  • db_get_row() /var/www/source/chusvn/app/functions/fn.control.php:1062
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00050 Re-run Backtrace
47
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 47 AND c.company_id = 0

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::__construct() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /var/www/source/chusvn/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /var/www/source/chusvn/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00057 Re-run Backtrace
48
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 47

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::__construct() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /var/www/source/chusvn/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /var/www/source/chusvn/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00024 Re-run Backtrace
49
SELECT c.*, IF (c.location_id != 47, 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') AND c.company_id = 0

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::__construct() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /var/www/source/chusvn/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /var/www/source/chusvn/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00226 Re-run Backtrace
50
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 (173, 174, 187, 176) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::__construct() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Grid::getList() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:133
  • db_get_hash_multi_array() /var/www/source/chusvn/app/Tygh/BlockManager/Grid.php:63
  • Tygh\Database\Connection::getMultiHash() /var/www/source/chusvn/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:526
0.00086 Re-run Backtrace
51
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 'categories' 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 = 152 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (195, 196, 198, 225, 227, 623, 625, 626, 624, 627, 294, 295, 296, 297, 293, 292)  AND cscart_bm_blocks_descriptions.lang_code='vi'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::__construct() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Block::getList() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:137
  • db_get_hash_multi_array() /var/www/source/chusvn/app/Tygh/BlockManager/Block.php:249
  • Tygh\Database\Connection::getMultiHash() /var/www/source/chusvn/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:526
0.00294 Re-run Backtrace
52
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:222
  • {closure}() /var/www/source/chusvn/app/Tygh/Registry.php:792
  • db_get_hash_array() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00054 Re-run Backtrace
53
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 1

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:222
  • {closure}() /var/www/source/chusvn/app/Tygh/Registry.php:792
  • fn_hybrid_auth_get_storefront_ids() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:202
  • db_get_fields() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:233
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00026 Re-run Backtrace
54
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 2

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:222
  • {closure}() /var/www/source/chusvn/app/Tygh/Registry.php:792
  • fn_hybrid_auth_get_storefront_ids() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:202
  • db_get_fields() /var/www/source/chusvn/app/addons/hybrid_auth/func.php:233
  • Tygh\Database\Connection::getColumn() /var/www/source/chusvn/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:480
0.00023 Re-run Backtrace
55
SELECT * from cscart_user_profiles WHERE user_id = 0 AND is_default = 'Y'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842512781ac77_25547201() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_user_info() /var/www/source/chusvn/var/cache/templates/chus/7706b8f1c0342a093e8188296ab6772c57e30dfa.tygh.togglemenu_mb.tpl.php:288
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.users.php:60
  • fn_dosiin_get_user_info_pre() /var/www/source/chusvn/app/functions/fn.control.php:123
  • db_get_row() /var/www/source/chusvn/app/addons/dosiin/func.php:1009
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00051 Re-run Backtrace
56
SELECT profile_id FROM cscart_user_profiles WHERE user_id = 0 ORDER BY profile_id ASC LIMIT 1

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842512781ac77_25547201() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_user_info() /var/www/source/chusvn/var/cache/templates/chus/7706b8f1c0342a093e8188296ab6772c57e30dfa.tygh.togglemenu_mb.tpl.php:288
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.users.php:60
  • fn_dosiin_get_user_info_pre() /var/www/source/chusvn/app/functions/fn.control.php:123
  • db_get_row() /var/www/source/chusvn/app/addons/dosiin/func.php:1017
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00029 Re-run Backtrace
57
UPDATE cscart_user_profiles SET is_default = 'Y' WHERE user_id = 0 AND profile_id = '' 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842512781ac77_25547201() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_user_info() /var/www/source/chusvn/var/cache/templates/chus/7706b8f1c0342a093e8188296ab6772c57e30dfa.tygh.togglemenu_mb.tpl.php:288
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.users.php:60
  • fn_dosiin_get_user_info_pre() /var/www/source/chusvn/app/functions/fn.control.php:123
  • db_query() /var/www/source/chusvn/app/addons/dosiin/func.php:1018
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/functions/fn.database.php:138
0.00022 Re-run Backtrace
58
SELECT cscart_users.* FROM cscart_users  WHERE user_id = 0 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842512781ac77_25547201() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_user_info() /var/www/source/chusvn/var/cache/templates/chus/7706b8f1c0342a093e8188296ab6772c57e30dfa.tygh.togglemenu_mb.tpl.php:288
  • db_get_row() /var/www/source/chusvn/app/functions/fn.users.php:86
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00027 Re-run Backtrace
59
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_categories.svg_icon,cscart_categories.product_spin_ids,cscart_categories.banner_url,cscart_categories.banner_url_eng,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.category_type in ('C', 'T')   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842512781ac77_25547201() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_categories() /var/www/source/chusvn/var/cache/templates/chus/7706b8f1c0342a093e8188296ab6772c57e30dfa.tygh.togglemenu_mb.tpl.php:491
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.categories.php:444
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00814 Re-run Backtrace
60
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(191, 319, 403, 340, 120, 196, 172, 181, 111, 192, 141, 415, 316, 320, 201, 154, 341, 173, 183, 193, 112, 121, 416, 197, 202, 317, 155, 142, 163, 194, 143, 412, 318, 409, 114, 174, 184, 215, 156, 95, 165, 126, 144, 115, 180, 122, 175, 195, 157, 313, 96, 158, 123, 101, 176, 145, 182, 214, 166, 124, 178, 190, 146, 169, 105, 159, 116, 160, 117, 168, 99, 118, 171, 100, 161, 119, 149, 102, 153, 418, 514, 417, 103, 150, 106, 152, 107, 151, 98, 104, 109, 444, 515, 419, 442, 463, 445, 464, 420, 461, 550, 446, 517, 465, 421, 483, 551, 466, 447, 518, 422, 490, 423, 519, 467, 448, 553, 491, 449, 424, 468, 554, 492, 450, 425, 469, 494, 493, 470, 451, 426, 495, 513, 427, 462, 471, 452, 496, 453, 472, 497, 473, 429, 498, 430, 474, 512, 499, 475, 431, 500, 432, 476, 501, 477, 460, 433, 502, 478, 434, 503, 479, 504, 436, 480, 481, 437, 506, 438, 482, 507, 439, 508, 440, 441, 510, 511) 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:682
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842512781ac77_25547201() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_categories() /var/www/source/chusvn/var/cache/templates/chus/7706b8f1c0342a093e8188296ab6772c57e30dfa.tygh.togglemenu_mb.tpl.php:491
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.categories.php:487
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00134 Re-run Backtrace
61
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'vi' AND lang.name = 'products_multicolumns'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:640
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:787
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842514246ab23_13283959() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_products_views() /var/www/source/chusvn/var/cache/templates/chus/941b29e683c2bc37ce11b416e2e56c087e52cf60.tygh.view.tpl.php:190
  • __() /var/www/source/chusvn/app/functions/fn.products.php:2813
  • Tygh\Languages\Values::getLangVar() /var/www/source/chusvn/app/functions/fn.common.php:6054
  • db_get_field() /var/www/source/chusvn/app/Tygh/Languages/Values.php:171
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00048 Re-run Backtrace
62
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:640
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:787
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842514246ab23_13283959() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_products_views() /var/www/source/chusvn/var/cache/templates/chus/941b29e683c2bc37ce11b416e2e56c087e52cf60.tygh.view.tpl.php:190
  • __() /var/www/source/chusvn/app/functions/fn.products.php:2813
  • Tygh\Languages\Values::getLangVar() /var/www/source/chusvn/app/functions/fn.common.php:6054
  • db_get_found_rows() /var/www/source/chusvn/app/Tygh/Languages/Values.php:173
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:311
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00012 Re-run Backtrace
63
SELECT object_id, thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 152 AND object_type = 'C'   

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:640
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:787
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842514246ab23_13283959() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_hook() /var/www/source/chusvn/var/cache/templates/chus/941b29e683c2bc37ce11b416e2e56c087e52cf60.tygh.view.tpl.php:309
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/functions/smarty_plugins/block.hook.php:136
  • content_6842514382a442_66376574() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • Smarty_Internal_Template::getSubTemplate() /var/www/source/chusvn/var/cache/templates/chus/bfa787aa9122211a2ab4c712bf0002506ecb5103.tygh.view.post.tpl.php:51
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_684251438b0548_87022896() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_discussion() /var/www/source/chusvn/var/cache/templates/chus/ec9ba2179e7c57f30dfce6179991a149b148286f.tygh.block_view.tpl.php:136
  • db_get_row() /var/www/source/chusvn/app/addons/discussion/func.php:248
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00040 Re-run Backtrace
64
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 6948 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:640
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:787
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842514246ab23_13283959() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_hook() /var/www/source/chusvn/var/cache/templates/chus/941b29e683c2bc37ce11b416e2e56c087e52cf60.tygh.view.tpl.php:309
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/functions/smarty_plugins/block.hook.php:136
  • content_6842514382a442_66376574() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • Smarty_Internal_Template::getSubTemplate() /var/www/source/chusvn/var/cache/templates/chus/bfa787aa9122211a2ab4c712bf0002506ecb5103.tygh.view.post.tpl.php:51
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_684251438b0548_87022896() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_discussion() /var/www/source/chusvn/var/cache/templates/chus/ec9ba2179e7c57f30dfce6179991a149b148286f.tygh.block_view.tpl.php:136
  • fn_get_discussion_posts() /var/www/source/chusvn/app/addons/discussion/func.php:298
  • db_get_row() /var/www/source/chusvn/app/addons/discussion/func.php:353
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00023 Re-run Backtrace
65
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 = 152 AND d.object_type = 'C' AND type IN ( 'B', 'R' )  AND dp.status = 'A' AND dr.rating_value > 0

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:640
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:787
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_6842514246ab23_13283959() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_block_hook() /var/www/source/chusvn/var/cache/templates/chus/941b29e683c2bc37ce11b416e2e56c087e52cf60.tygh.view.tpl.php:309
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/functions/smarty_plugins/block.hook.php:136
  • content_6842514382a442_66376574() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • Smarty_Internal_Template::getSubTemplate() /var/www/source/chusvn/var/cache/templates/chus/bfa787aa9122211a2ab4c712bf0002506ecb5103.tygh.view.post.tpl.php:51
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304
  • content_684251438b0548_87022896() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • fn_get_discussion() /var/www/source/chusvn/var/cache/templates/chus/ec9ba2179e7c57f30dfce6179991a149b148286f.tygh.block_view.tpl.php:136
  • fn_discussion_get_average_object_rating() /var/www/source/chusvn/app/addons/discussion/func.php:300
  • db_get_field() /var/www/source/chusvn/app/addons/discussion/func.php:976
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00029 Re-run Backtrace
66
SELECT status FROM cscart_menus WHERE menu_id = 3

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • Tygh\Menu::getStatus() /var/www/source/chusvn/app/functions/fn.cms.php:1172
  • db_get_field() /var/www/source/chusvn/app/Tygh/Menu.php:208
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00025 Re-run Backtrace
67
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'vi' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_get_static_data() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.common.php:1330
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00047 Re-run Backtrace
68
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 49 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • db_get_row() /var/www/source/chusvn/app/functions/fn.cms.php:935
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00053 Re-run Backtrace
69
SELECT id_path FROM cscart_pages WHERE page_id = 49

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_field() /var/www/source/chusvn/app/functions/fn.cms.php:205
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00018 Re-run Backtrace
70
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '49/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.cms.php:335
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00119 Re-run Backtrace
71
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 50 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • db_get_row() /var/www/source/chusvn/app/functions/fn.cms.php:935
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00045 Re-run Backtrace
72
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 51 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • db_get_row() /var/www/source/chusvn/app/functions/fn.cms.php:935
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00035 Re-run Backtrace
73
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 55 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • db_get_row() /var/www/source/chusvn/app/functions/fn.cms.php:935
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00049 Re-run Backtrace
74
SELECT id_path FROM cscart_pages WHERE page_id = 55

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_field() /var/www/source/chusvn/app/functions/fn.cms.php:205
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00022 Re-run Backtrace
75
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '55/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.cms.php:335
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00101 Re-run Backtrace
76
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 60 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • db_get_row() /var/www/source/chusvn/app/functions/fn.cms.php:935
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00051 Re-run Backtrace
77
SELECT f.*, d.description FROM cscart_form_options as f LEFT JOIN cscart_form_descriptions as d ON d.object_id=f.element_id AND d.lang_code = 'vi' WHERE f.page_id = 60  AND f.status = 'A' ORDER BY f.position

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • fn_set_hook() /var/www/source/chusvn/app/functions/fn.cms.php:951
  • fn_form_builder_get_page_data() /var/www/source/chusvn/app/functions/fn.control.php:123
  • fn_get_form_elements() /var/www/source/chusvn/app/addons/form_builder/func.php:159
  • db_get_hash_array() /var/www/source/chusvn/app/addons/form_builder/func.php:171
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00038 Re-run Backtrace
78
SELECT id_path FROM cscart_pages WHERE page_id = 60

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_field() /var/www/source/chusvn/app/functions/fn.cms.php:205
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00018 Re-run Backtrace
79
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '60/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.cms.php:335
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00086 Re-run Backtrace
80
SELECT status FROM cscart_menus WHERE menu_id = 7

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • Tygh\Menu::getStatus() /var/www/source/chusvn/app/functions/fn.cms.php:1172
  • db_get_field() /var/www/source/chusvn/app/Tygh/Menu.php:208
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00020 Re-run Backtrace
81
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'vi' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '7' ORDER BY sd.position

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_get_static_data() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.common.php:1330
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00049 Re-run Backtrace
82
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 47 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_page_data() /var/www/source/chusvn/app/functions/fn.cms.php:1253
  • db_get_row() /var/www/source/chusvn/app/functions/fn.cms.php:935
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00047 Re-run Backtrace
83
SELECT id_path FROM cscart_pages WHERE page_id = 47

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_field() /var/www/source/chusvn/app/functions/fn.cms.php:205
  • Tygh\Database\Connection::getField() /var/www/source/chusvn/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:448
0.00021 Re-run Backtrace
84
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '47/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_menu_items()
  • fn_top_menu_form() /var/www/source/chusvn/app/functions/fn.cms.php:1188
  • fn_get_pages() /var/www/source/chusvn/app/functions/fn.cms.php:1266
  • db_get_hash_array() /var/www/source/chusvn/app/functions/fn.cms.php:335
  • Tygh\Database\Connection::getHash() /var/www/source/chusvn/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:371
0.00090 Re-run Backtrace
85
SELECT cscart_shippings.shipping_id, cscart_shipping_descriptions.shipping FROM cscart_shippings INNER JOIN cscart_images_links ON cscart_shippings.shipping_id = cscart_images_links.object_id AND cscart_images_links.object_type = 'shipping' LEFT JOIN cscart_shipping_descriptions ON cscart_shippings.shipping_id = cscart_shipping_descriptions.shipping_id AND cscart_shipping_descriptions.lang_code = 'vi' WHERE cscart_shippings.status = 'A' ORDER BY cscart_shippings.position, cscart_shipping_descriptions.shipping

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\SmartyEngine\Core::fetch() /var/www/source/chusvn/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/source/chusvn/app/Tygh/SmartyEngine/Core.php:81
  • content_684251260bc785_14533440() /var/www/source/chusvn/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188
  • smarty_function_render_location() /var/www/source/chusvn/var/cache/templates/chus/0fd4c70cf941bf0025f8a7482c203045b2dee19c.tygh.index.tpl.php:219
  • Tygh\BlockManager\RenderManager::render() /var/www/source/chusvn/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:369
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:667
  • call_user_func_array() /var/www/source/chusvn/app/Tygh/BlockManager/RenderManager.php:821
  • fn_get_shipping_images()
  • db_get_array() /var/www/source/chusvn/app/functions/fn.common.php:2941
  • Tygh\Database\Connection::getArray() /var/www/source/chusvn/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:333
0.00052 Re-run Backtrace
86
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

    Backtrace

  • fn_dispatch() /var/www/source/chusvn/index.php:27
  • Tygh\Application::offsetGet() /var/www/source/chusvn/app/functions/fn.control.php:648
  • Pimple\Container::offsetGet() /var/www/source/chusvn/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /var/www/source/chusvn/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118
  • fn_get_storage_data() /var/www/source/chusvn/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /var/www/source/chusvn/app/functions/fn.control.php:1062
  • Tygh\Database\Connection::getRow() /var/www/source/chusvn/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/source/chusvn/app/Tygh/Database/Connection.php:414
0.00045 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 3
Query Count Min time Max time Average time
SELECT a.category_id
                 FROM cscart_categories as a
                 LEFT JOIN cscart_categories as b
                 ON b.category_id IN (152)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
3 0.00057 0.00068 0.00061
SELECT FOUND_ROWS()
3 0.00012 0.00021 0.00016
SELECT cscart_product_filters.*, cscart_product_features.feature_type FROM cscart_product_filters LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filters.feature_id WHERE cscart_product_filters.filter_id IN (1) AND cscart_product_filters.status = 'A'
2 0.00038 0.00038 0.00038
SELECT lang.value FROM cscart_language_values lang WHERE lang.lang_code = 'vi' AND lang.name = 'products_multicolumns'
2 0.00040 0.00048 0.00044
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'beta.chus.vn' OR storefronts.url = 'www.beta.chus.vn' OR storefronts.url LIKE 'www_.beta.chus.vn' OR storefronts.url LIKE 'beta.chus.vn/%' OR storefronts.url LIKE 'www.beta.chus.vn/%' OR storefronts.url LIKE 'www_.beta.chus.vn/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'beta.chus.vn' DESC, storefronts.url = 'www.beta.chus.vn' DESC, storefronts.url LIKE 'www_.beta.chus.vn' DESC, storefronts.url LIKE 'beta.chus.vn/%' DESC, storefronts.url LIKE 'www.beta.chus.vn/%' DESC, storefronts.url LIKE 'www_.beta.chus.vn/%' desc 
1 0.00056 0.00056 0.00056
SET time_zone = '+07:00'
1 0.00016 0.00016 0.00016
SELECT type FROM cscart_seo_names WHERE name = 'phu-kien-dien-thoai-vi' 
1 0.00074 0.00074 0.00074
SELECT * FROM cscart_seo_names WHERE name = 'phu-kien-dien-thoai-vi'  AND lang_code = 'vi'
1 0.00040 0.00040 0.00040
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
1 0.00027 0.00027 0.00027
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.00039 0.00039 0.00039
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 152 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'vi' 
1 0.00048 0.00048 0.00048
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'chus' AND storefront_id = 1
1 0.00035 0.00035 0.00035
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00024 0.00024 0.00024
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
1 0.00026 0.00026 0.00026
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 3
1 0.00045 0.00045 0.00045
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'vi' WHERE l.layout_id = 3  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(152, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00058 0.00058 0.00058
SELECT usergroup_ids FROM cscart_categories WHERE category_id = 152
1 0.00028 0.00028 0.00028
SELECT category_id FROM cscart_categories WHERE category_id = 152  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)
1 0.00031 0.00031 0.00031
SELECT *, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_category_descriptions.category_id = cscart_categories.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = 152  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_categories.category_id = 152 AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))
1 0.00076 0.00076 0.00076
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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '152' 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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '152' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00093 0.00093 0.00093
SELECT id_path FROM cscart_categories WHERE category_id = 152
1 0.00032 0.00032 0.00032
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_categories.svg_icon,cscart_categories.product_spin_ids,cscart_categories.banner_url,cscart_categories.banner_url_eng,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (152) AND cscart_categories.id_path LIKE '99/152/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.category_type in ('C')   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00140 0.00140 0.00140
SELECT company_id FROM cscart_storefronts_companies WHERE storefront_id = 1
1 0.00022 0.00022 0.00022
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, MIN(IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100)) as price, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, cscart_product_review_prepared_data.average_rating average_rating, cscart_product_review_prepared_data.reviews_count product_reviews_count FROM cscart_products as products  LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'vi'  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = products.product_id AND cscart_product_review_prepared_data.storefront_id = 0 LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1  AND cscart_categories.category_id IN (152) AND products.product_id NOT IN (0) AND companies.status IN ('A') AND prices.price >= 500000.00 AND prices.price <= 1000000.00 AND (products.amount > 0 OR products.tracking = 'D') 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 prices_2.price IS NULL GROUP BY product_id   ORDER BY popularity.total desc, products.product_id ASC  LIMIT 0, 32
1 0.02210 0.02210 0.02210
SELECT default_view, selected_views FROM cscart_categories WHERE category_id = 152
1 0.00027 0.00027 0.00027
SELECT category_id, category FROM cscart_category_descriptions WHERE category_id IN (99) AND lang_code = 'vi'
1 0.00031 0.00031 0.00031
SELECT feature_id, feature_type FROM cscart_product_features WHERE feature_id IN (23212)
1 0.00031 0.00031 0.00031
CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price  AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND prices.price >= 500000.00 AND prices.price <= 1000000.00 AND (products.amount > 0 OR products.tracking = 'D') 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 prices_2.price IS NULL ORDER BY NULL
1 0.01621 0.01621 0.01621
SELECT cscart_product_features_values.feature_id, cscart_product_features_values.variant_id FROM cscart_product_features_values INNER JOIN _product_filters_products_1 AS products ON products.product_id = cscart_product_features_values.product_id   WHERE cscart_product_features_values.feature_id IN (23212) AND cscart_product_features_values.lang_code = 'vi'   GROUP BY cscart_product_features_values.variant_id ORDER BY NULL
1 0.00084 0.00084 0.00084
CREATE TEMPORARY TABLE _product_filters_products_2 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM cscart_products AS products  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1  AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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') ORDER BY NULL
1 0.01532 0.01532 0.01532
SELECT cscart_products_categories.category_id as variant_id, cd.category as variant FROM cscart_products_categories   LEFT JOIN cscart_products as products ON products.product_id = cscart_products_categories.product_id
                LEFT JOIN cscart_category_descriptions cd ON cscart_products_categories.category_id = cd.category_id AND lang_code = 'vi'  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1   AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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') GROUP BY cscart_products_categories.category_id ORDER BY cd.category ASC
1 0.01763 0.01763 0.01763
SELECT cscart_product_reviews.rating_value as variant_id, cscart_product_review_start.rating_title as variant FROM cscart_product_reviews   LEFT JOIN cscart_products as products ON products.product_id = cscart_product_reviews.product_id 
                INNER JOIN cscart_product_review_start ON cscart_product_review_start.rating_value = cscart_product_reviews.rating_value AND lang_code = 'vi'  LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id  INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1=1   AND cscart_categories.category_id IN (152) AND companies.status IN ('A') AND (products.amount > 0 OR products.tracking = 'D') 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') GROUP BY cscart_product_reviews.rating_value ORDER BY cscart_product_review_start.rating_title DESC
1 0.08096 0.08096 0.08096
SELECT MIN(cscart_product_prices.price) as min, MAX(cscart_product_prices.price) as max FROM cscart_product_prices   LEFT JOIN cscart_products as products ON products.product_id = cscart_product_prices.product_id
                    LEFT JOIN cscart_product_prices as prices_2 ON cscart_product_prices.product_id = prices_2.product_id AND cscart_product_prices.price > prices_2.price AND prices_2.lower_limit = 1 AND prices_2.usergroup_id IN (0, 0, 1) INNER JOIN _product_filters_products_2 ON products.product_id = _product_filters_products_2.product_id  WHERE products.status IN ('A') 
                    AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL 
1 0.00288 0.00288 0.00288
DROP TEMPORARY TABLE _product_filters_products_1
1 0.00024 0.00024 0.00024
DROP TEMPORARY TABLE _product_filters_products_2
1 0.00014 0.00014 0.00014
SELECT id_path FROM cscart_categories WHERE category_id = 99
1 0.00028 0.00028 0.00028
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_categories.svg_icon,cscart_categories.product_spin_ids,cscart_categories.banner_url,cscart_categories.banner_url_eng,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.parent_id IN (99) AND cscart_categories.id_path LIKE '99/%' AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.category_type in ('C')   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00208 0.00208 0.00208
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(141, 142, 143, 144, 145, 146, 149, 153, 150, 152, 151) 
1 0.00034 0.00034 0.00034
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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (141, 142, 143, 144, 145, 146, 149, 153, 150, 152, 151) 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 = 'vi' WHERE cscart_images_links.object_type = 'category' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id IN (141, 142, 143, 144, 145, 146, 149, 153, 150, 152, 151) ORDER BY cscart_images_links.position, cscart_images_links.pair_id
1 0.00125 0.00125 0.00125
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00038 0.00038 0.00038
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 152 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00049 0.00049 0.00049
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
1 0.00050 0.00050 0.00050
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 47 AND c.company_id = 0
1 0.00057 0.00057 0.00057
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 47
1 0.00024 0.00024 0.00024
SELECT c.*, IF (c.location_id != 47, 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') AND c.company_id = 0
1 0.00226 0.00226 0.00226
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 (173, 174, 187, 176) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00086 0.00086 0.00086
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 'categories' 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 = 152 AND dynamic_object_content.object_type like 'categories' WHERE cscart_bm_snapping.grid_id IN (195, 196, 198, 225, 227, 623, 625, 626, 624, 627, 294, 295, 296, 297, 293, 292)  AND cscart_bm_blocks_descriptions.lang_code='vi'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
1 0.00294 0.00294 0.00294
SELECT * FROM cscart_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position
1 0.00054 0.00054 0.00054
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 1
1 0.00026 0.00026 0.00026
SELECT storefront_id FROM cscart_hybrid_auth_storefronts_providers WHERE provider_id = 2
1 0.00023 0.00023 0.00023
SELECT * from cscart_user_profiles WHERE user_id = 0 AND is_default = 'Y'
1 0.00051 0.00051 0.00051
SELECT profile_id FROM cscart_user_profiles WHERE user_id = 0 ORDER BY profile_id ASC LIMIT 1
1 0.00029 0.00029 0.00029
UPDATE cscart_user_profiles SET is_default = 'Y' WHERE user_id = 0 AND profile_id = '' 
1 0.00022 0.00022 0.00022
SELECT cscart_users.* FROM cscart_users  WHERE user_id = 0 
1 0.00027 0.00027 0.00027
SELECT cscart_categories.category_id,cscart_categories.parent_id,cscart_categories.id_path,cscart_category_descriptions.category,cscart_categories.position,cscart_categories.status,cscart_categories.company_id,cscart_categories.storefront_id,cscart_categories.svg_icon,cscart_categories.product_spin_ids,cscart_categories.banner_url,cscart_categories.banner_url_eng,cscart_seo_names.name as seo_name,cscart_seo_names.path as seo_path FROM cscart_categories LEFT JOIN cscart_category_descriptions ON cscart_categories.category_id = cscart_category_descriptions.category_id AND cscart_category_descriptions.lang_code = 'vi'  LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_categories.category_id  AND cscart_seo_names.type = 'c'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1=1  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A') AND cscart_categories.storefront_id IN (0, 1) AND cscart_categories.category_type in ('C', 'T')   ORDER BY cscart_categories.is_trash asc, cscart_categories.position asc, cscart_category_descriptions.category asc 
1 0.00814 0.00814 0.00814
SELECT category_id, parent_id FROM cscart_categories WHERE parent_id IN(191, 319, 403, 340, 120, 196, 172, 181, 111, 192, 141, 415, 316, 320, 201, 154, 341, 173, 183, 193, 112, 121, 416, 197, 202, 317, 155, 142, 163, 194, 143, 412, 318, 409, 114, 174, 184, 215, 156, 95, 165, 126, 144, 115, 180, 122, 175, 195, 157, 313, 96, 158, 123, 101, 176, 145, 182, 214, 166, 124, 178, 190, 146, 169, 105, 159, 116, 160, 117, 168, 99, 118, 171, 100, 161, 119, 149, 102, 153, 418, 514, 417, 103, 150, 106, 152, 107, 151, 98, 104, 109, 444, 515, 419, 442, 463, 445, 464, 420, 461, 550, 446, 517, 465, 421, 483, 551, 466, 447, 518, 422, 490, 423, 519, 467, 448, 553, 491, 449, 424, 468, 554, 492, 450, 425, 469, 494, 493, 470, 451, 426, 495, 513, 427, 462, 471, 452, 496, 453, 472, 497, 473, 429, 498, 430, 474, 512, 499, 475, 431, 500, 432, 476, 501, 477, 460, 433, 502, 478, 434, 503, 479, 504, 436, 480, 481, 437, 506, 438, 482, 507, 439, 508, 440, 441, 510, 511) 
1 0.00134 0.00134 0.00134
SELECT object_id, thread_id, type, object_type FROM cscart_discussion  WHERE 1  AND object_id = 152 AND object_type = 'C'   
1 0.00040 0.00040 0.00040
SELECT thread_id, type, object_type, object_id FROM cscart_discussion WHERE thread_id = 6948 
1 0.00023 0.00023 0.00023
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 = 152 AND d.object_type = 'C' AND type IN ( 'B', 'R' )  AND dp.status = 'A' AND dr.rating_value > 0
1 0.00029 0.00029 0.00029
SELECT status FROM cscart_menus WHERE menu_id = 3
1 0.00025 0.00025 0.00025
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'vi' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '3' ORDER BY sd.position
1 0.00047 0.00047 0.00047
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 49 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')
1 0.00053 0.00053 0.00053
SELECT id_path FROM cscart_pages WHERE page_id = 49
1 0.00018 0.00018 0.00018
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '49/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
1 0.00119 0.00119 0.00119
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 50 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')
1 0.00045 0.00045 0.00045
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 51 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')
1 0.00035 0.00035 0.00035
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 55 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')
1 0.00049 0.00049 0.00049
SELECT id_path FROM cscart_pages WHERE page_id = 55
1 0.00022 0.00022 0.00022
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '55/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
1 0.00101 0.00101 0.00101
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 60 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')
1 0.00051 0.00051 0.00051
SELECT f.*, d.description FROM cscart_form_options as f LEFT JOIN cscart_form_descriptions as d ON d.object_id=f.element_id AND d.lang_code = 'vi' WHERE f.page_id = 60  AND f.status = 'A' ORDER BY f.position
1 0.00038 0.00038 0.00038
SELECT id_path FROM cscart_pages WHERE page_id = 60
1 0.00018 0.00018 0.00018
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '60/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
1 0.00086 0.00086 0.00086
SELECT status FROM cscart_menus WHERE menu_id = 7
1 0.00020 0.00020 0.00020
SELECT sd.param_id, sd.param, cscart_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class FROM cscart_static_data AS sd LEFT JOIN cscart_static_data_descriptions ON sd.param_id = cscart_static_data_descriptions.param_id AND cscart_static_data_descriptions.lang_code = 'vi' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '7' ORDER BY sd.position
1 0.00049 0.00049 0.00049
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages  INNER JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE cscart_pages.page_id = 47 AND cscart_page_descriptions.lang_code = 'vi'  AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND cscart_pages.page_type IN ('T', 'L', 'F')
1 0.00047 0.00047 0.00047
SELECT id_path FROM cscart_pages WHERE page_id = 47
1 0.00021 0.00021 0.00021
SELECT cscart_pages.*, cscart_page_descriptions.*, cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path FROM cscart_pages LEFT JOIN cscart_page_descriptions ON cscart_pages.page_id = cscart_page_descriptions.page_id AND cscart_page_descriptions.lang_code = 'vi' LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = cscart_pages.page_id  AND cscart_seo_names.type = 'a'  AND cscart_seo_names.dispatch = '' AND cscart_seo_names.lang_code = 'vi'  WHERE 1 AND cscart_pages.id_path LIKE '47/%' AND cscart_pages.status IN ('A') AND cscart_pages.page_type IN ('T', 'L', 'F') AND (cscart_pages.usergroup_ids = '' OR FIND_IN_SET(0, cscart_pages.usergroup_ids) OR FIND_IN_SET(1, cscart_pages.usergroup_ids)) AND (cscart_pages.use_avail_period = 'N' OR (cscart_pages.use_avail_period = 'Y' AND cscart_pages.avail_from_timestamp <= 1749222141 AND (cscart_pages.avail_till_timestamp >= 1749222141 OR cscart_pages.avail_till_timestamp = 0)))   ORDER BY cscart_pages.position asc, cscart_pages.parent_id asc, cscart_page_descriptions.page asc 
1 0.00090 0.00090 0.00090
SELECT cscart_shippings.shipping_id, cscart_shipping_descriptions.shipping FROM cscart_shippings INNER JOIN cscart_images_links ON cscart_shippings.shipping_id = cscart_images_links.object_id AND cscart_images_links.object_type = 'shipping' LEFT JOIN cscart_shipping_descriptions ON cscart_shippings.shipping_id = cscart_shipping_descriptions.shipping_id AND cscart_shipping_descriptions.lang_code = 'vi' WHERE cscart_shippings.status = 'A' ORDER BY cscart_shippings.position, cscart_shipping_descriptions.shipping
1 0.00052 0.00052 0.00052
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'
1 0.00045 0.00045 0.00045