Queries total time: 0.17586 s.
Query Time Actions
1
SELECT data FROM agm_storage_data WHERE data_key = 'store_mode'

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_redirect_to_regional_storefront() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • Tygh\Storefront\Repository::findByUrl() /var/www/agmarq.com/app/functions/fn.init.php:1452
  • Tygh\Storefront\Repository::find() /var/www/agmarq.com/app/Tygh/Storefront/Repository.php:126
  • fn_set_hook() /var/www/agmarq.com/app/Tygh/Storefront/Repository.php:313
  • fn_mve_storefront_repository_find_pre() /var/www/agmarq.com/app/functions/fn.control.php:104
  • fn_allowed_for() /var/www/agmarq.com/app/functions/fn.multivendor.php:2060
  • fn_get_storage_data() /var/www/agmarq.com/app/functions/fn.control.php:985
  • db_get_row() /var/www/agmarq.com/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00022 Re-run Backtrace
2
SELECT storefronts.* FROM agm_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'agmarq.com' OR storefronts.url = 'www.agmarq.com' OR storefronts.url LIKE 'www_.agmarq.com' OR storefronts.url LIKE 'agmarq.com/%' OR storefronts.url LIKE 'www.agmarq.com/%' OR storefronts.url LIKE 'www_.agmarq.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'agmarq.com' DESC, storefronts.url = 'www.agmarq.com' DESC, storefronts.url LIKE 'www_.agmarq.com' DESC, storefronts.url LIKE 'agmarq.com/%' DESC, storefronts.url LIKE 'www.agmarq.com/%' DESC, storefronts.url LIKE 'www_.agmarq.com/%' desc 

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_redirect_to_regional_storefront() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • Tygh\Storefront\Repository::findByUrl() /var/www/agmarq.com/app/functions/fn.init.php:1452
  • Tygh\Storefront\Repository::find() /var/www/agmarq.com/app/Tygh/Storefront/Repository.php:126
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/Tygh/Storefront/Repository.php:370
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00018 Re-run Backtrace
3
SET time_zone = '+05:00'

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_settings() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_init_time_zone() /var/www/agmarq.com/app/functions/fn.init.php:1058
  • db_query() /var/www/agmarq.com/app/functions/fn.init.php:1079
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/functions/fn.database.php:138
0.00008 Re-run Backtrace
4
SELECT data FROM agm_storage_data WHERE data_key = 'ms_time_check_ms_smart_description'

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_addons() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_load_addon() /var/www/agmarq.com/app/functions/fn.init.php:1135
  • Tygh\Addons\AXmlScheme::loadAddon() /var/www/agmarq.com/app/functions/fn.addons.php:1627
  • require_once() /var/www/agmarq.com/app/Tygh/Addons/AXmlScheme.php:862
  • require_once() /var/www/agmarq.com/app/addons/ms_smart_description/config.php:6
  • fn_get_storage_data() /var/www/agmarq.com/app/addons/ms_smart_description/license.php:1
  • db_get_row() /var/www/agmarq.com/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00071 Re-run Backtrace
5
SELECT type FROM agm_seo_names WHERE name = 'biscuits-manufacturing-consultancy' 

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_get_route() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/agmarq.com/app/functions/fn.control.php:123
  • db_get_field() /var/www/agmarq.com/app/addons/seo/func.php:662
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00035 Re-run Backtrace
6
SELECT * FROM agm_seo_names WHERE name = 'biscuits-manufacturing-consultancy'  AND lang_code = 'ar'

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_get_route() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/agmarq.com/app/functions/fn.control.php:123
  • db_get_array() /var/www/agmarq.com/app/addons/seo/func.php:666
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00027 Re-run Backtrace
7
SELECT agm_languages.lang_code, agm_languages.name FROM agm_languages  WHERE 1 AND agm_languages.status = 'A'   

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_get_route() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_seo_validate_object() /var/www/agmarq.com/app/addons/seo/func.php:705
  • Tygh\Languages\Languages::getSimpleLanguages() /var/www/agmarq.com/app/addons/seo/func.php:1071
  • db_get_hash_single_array() /var/www/agmarq.com/app/Tygh/Languages/Languages.php:515
  • Tygh\Database\Connection::getSingleHash() /var/www/agmarq.com/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:571
0.00011 Re-run Backtrace
8
SELECT storefronts.* FROM agm_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (4) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_get_route() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_url() /var/www/agmarq.com/app/addons/seo/func.php:800
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.common.php:3946
  • fn_seo_url_post() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_get_seo_settings() /var/www/agmarq.com/app/addons/seo/func.php:1474
  • Tygh\Application::offsetGet() /var/www/agmarq.com/app/addons/seo/func.php:2196
  • Pimple\Container::offsetGet() /var/www/agmarq.com/app/Tygh/Application.php:135
  • Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}() /var/www/agmarq.com/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Storefront\Repository::findById() /var/www/agmarq.com/app/Tygh/Providers/StorefrontProvider.php:186
  • Tygh\Storefront\Repository::find() /var/www/agmarq.com/app/Tygh/Storefront/Repository.php:164
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/Tygh/Storefront/Repository.php:373
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00017 Re-run Backtrace
9
SELECT name, path FROM agm_seo_names WHERE `object_id` = 14396 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_get_route() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:836
  • fn_seo_get_route() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_url() /var/www/agmarq.com/app/addons/seo/func.php:800
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.common.php:3946
  • fn_seo_url_post() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/agmarq.com/app/addons/seo/func.php:1587
  • db_get_row() /var/www/agmarq.com/app/addons/seo/func.php:1317
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00023 Re-run Backtrace
10
SELECT agm_bm_layouts.* FROM agm_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'bright_theme' AND storefront_id = 4

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_layout() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • Tygh\BlockManager\Layout::getDefault() /var/www/agmarq.com/app/functions/fn.init.php:673
  • db_get_row() /var/www/agmarq.com/app/Tygh/BlockManager/Layout.php:95
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00021 Re-run Backtrace
11
SELECT data FROM agm_storage_data WHERE data_key = 'cart_products_next_check'

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_user() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • fn_login_user() /var/www/agmarq.com/app/functions/fn.init.php:744
  • fn_init_user() /var/www/agmarq.com/app/functions/fn.users.php:3507
  • fn_is_expired_storage_data() /var/www/agmarq.com/app/functions/fn.init.php:776
  • fn_get_storage_data() /var/www/agmarq.com/app/functions/fn.control.php:1085
  • db_get_row() /var/www/agmarq.com/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00018 Re-run Backtrace
12
SELECT data FROM agm_storage_data WHERE data_key = 'dev_mode'

    Backtrace

  • require() /var/www/agmarq.com/index.php:18
  • fn_init() /var/www/agmarq.com/init.php:195
  • fn_init_templater() /var/www/agmarq.com/app/functions/fn.init.php:1228
  • Tygh\Development::isEnabled() /var/www/agmarq.com/app/functions/fn.init.php:124
  • Tygh\Development::read() /var/www/agmarq.com/app/Tygh/Development.php:28
  • fn_get_storage_data() /var/www/agmarq.com/app/Tygh/Development.php:81
  • db_get_row() /var/www/agmarq.com/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00026 Re-run Backtrace
13
SELECT * FROM agm_languages WHERE status = 'A'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:439
  • fn_searchanise_dispatch_assign_template() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_se_check_import_is_done() /var/www/agmarq.com/app/addons/searchanise/func.php:81
  • fn_se_get_engines_data() /var/www/agmarq.com/app/addons/searchanise/func.php:1892
  • db_get_array() /var/www/agmarq.com/app/addons/searchanise/func.php:574
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00034 Re-run Backtrace
14
SELECT * FROM agm_se_settings

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:439
  • fn_searchanise_dispatch_assign_template() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_se_check_import_is_done() /var/www/agmarq.com/app/addons/searchanise/func.php:81
  • fn_se_get_engines_data() /var/www/agmarq.com/app/addons/searchanise/func.php:1892
  • fn_se_get_api_key() /var/www/agmarq.com/app/addons/searchanise/func.php:621
  • fn_se_get_setting() /var/www/agmarq.com/app/addons/searchanise/func.php:238
  • fn_se_get_all_settings() /var/www/agmarq.com/app/addons/searchanise/func.php:168
  • db_get_array() /var/www/agmarq.com/app/addons/searchanise/func.php:153
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00020 Re-run Backtrace
15
SELECT * FROM agm_bm_layouts WHERE 1  AND storefront_id = 4 AND layout_id = 7

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::instance() /var/www/agmarq.com/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Layout::get() /var/www/agmarq.com/app/Tygh/BlockManager/Location.php:476
  • db_get_row() /var/www/agmarq.com/app/Tygh/BlockManager/Layout.php:61
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00014 Re-run Backtrace
16
SELECT * FROM agm_bm_locations as l LEFT JOIN agm_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ar' WHERE l.layout_id = 7  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(14396, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • Tygh\BlockManager\Location::get() /var/www/agmarq.com/app/controllers/frontend/init.php:142
  • Tygh\BlockManager\Location::getList() /var/www/agmarq.com/app/Tygh/BlockManager/Location.php:166
  • db_get_hash_array() /var/www/agmarq.com/app/Tygh/BlockManager/Location.php:105
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00038 Re-run Backtrace
17
SELECT data FROM agm_storage_data WHERE data_key = 'cache_id'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_storage_data() /var/www/agmarq.com/app/controllers/frontend/init.php:146
  • db_get_row() /var/www/agmarq.com/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00010 Re-run Backtrace
18
SELECT * FROM agm_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_hybrid_auth_get_providers_list() /var/www/agmarq.com/app/addons/hybrid_auth/controllers/frontend/init.post.php:17
  • Tygh\Registry::getOrSetCache() /var/www/agmarq.com/app/addons/hybrid_auth/func.php:222
  • {closure}() /var/www/agmarq.com/app/Tygh/Registry.php:800
  • db_get_hash_array() /var/www/agmarq.com/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00026 Re-run Backtrace
19
SELECT usergroup_ids FROM agm_categories WHERE category_id = 14396

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • db_get_field() /var/www/agmarq.com/app/controllers/frontend/categories.php:40
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00014 Re-run Backtrace
20
SELECT category_id FROM agm_categories WHERE category_id = 14396  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • db_get_field() /var/www/agmarq.com/app/controllers/frontend/categories.php:60
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00015 Re-run Backtrace
21
SELECT category_id FROM agm_categories WHERE category_type = 'D'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/agmarq.com/app/controllers/frontend/categories.php:76
  • fn_get_categories() /var/www/agmarq.com/app/functions/fn.categories.php:60
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.categories.php:242
  • fn_vendor_debt_payout_get_categories_pre() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_vendor_debt_payout_get_payout_category() /var/www/agmarq.com/app/addons/vendor_debt_payout/func.php:346
  • db_get_field() /var/www/agmarq.com/app/addons/vendor_debt_payout/func.php:225
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.03548 Re-run Backtrace
22
SELECT id_path FROM agm_categories WHERE category_id = 14396

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/agmarq.com/app/controllers/frontend/categories.php:76
  • fn_get_categories() /var/www/agmarq.com/app/functions/fn.categories.php:60
  • db_get_field() /var/www/agmarq.com/app/functions/fn.categories.php:350
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00020 Re-run Backtrace
23
SELECT agm_categories.category_id,agm_categories.parent_id,agm_categories.id_path,agm_category_descriptions.category,agm_categories.position,agm_categories.status,agm_categories.company_id,agm_categories.storefront_id,agm_seo_names.name as seo_name,agm_seo_names.path as seo_path FROM agm_categories LEFT JOIN agm_category_descriptions ON agm_categories.category_id = agm_category_descriptions.category_id AND agm_category_descriptions.lang_code = 'ar'  LEFT JOIN agm_seo_names ON agm_seo_names.object_id = agm_categories.category_id  AND agm_seo_names.type = 'c'  AND agm_seo_names.dispatch = '' AND agm_seo_names.lang_code = 'ar'  WHERE 1=1  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A') AND agm_categories.parent_id IN (14396) AND agm_categories.id_path LIKE '1086/1087/1088/14396/%' AND agm_categories.category_id != 264 AND agm_categories.parent_id != 264 AND agm_categories.storefront_id IN (0, 4)   ORDER BY agm_categories.is_trash asc, agm_categories.position asc, agm_category_descriptions.category asc 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_subcategories() /var/www/agmarq.com/app/controllers/frontend/categories.php:76
  • fn_get_categories() /var/www/agmarq.com/app/functions/fn.categories.php:60
  • db_get_hash_array() /var/www/agmarq.com/app/functions/fn.categories.php:440
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00054 Re-run Backtrace
24
SELECT *, agm_seo_names.name as seo_name, agm_seo_names.path as seo_path FROM agm_categories LEFT JOIN agm_category_descriptions ON agm_category_descriptions.category_id = agm_categories.category_id AND agm_category_descriptions.lang_code = 'ar'  LEFT JOIN agm_seo_names ON agm_seo_names.object_id = 14396  AND agm_seo_names.type = 'c'  AND agm_seo_names.dispatch = '' AND agm_seo_names.lang_code = 'ar'  WHERE agm_categories.category_id = 14396 AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids))

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_category_data() /var/www/agmarq.com/app/controllers/frontend/categories.php:79
  • db_get_row() /var/www/agmarq.com/app/functions/fn.categories.php:807
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00033 Re-run Backtrace
25
SELECT agm_images.*, agm_images_links.*, agm_common_descriptions.description AS alt, agm_images.image_id AS images_image_id FROM agm_images_links LEFT JOIN agm_images ON agm_images_links.image_id = agm_images.image_id LEFT JOIN agm_common_descriptions ON agm_common_descriptions.object_id = agm_images.image_id AND agm_common_descriptions.object_holder = 'images' AND agm_common_descriptions.lang_code = 'ar' WHERE agm_images_links.object_type = 'category' AND agm_images_links.type = 'M' AND agm_images_links.object_id = '14396' ORDER BY agm_images_links.position, agm_images_links.pair_id;SELECT agm_images.*, agm_images_links.*, agm_common_descriptions.description AS alt, agm_images.image_id AS images_image_id FROM agm_images_links LEFT JOIN agm_images ON agm_images_links.detailed_id = agm_images.image_id LEFT JOIN agm_common_descriptions ON agm_common_descriptions.object_id = agm_images.image_id AND agm_common_descriptions.object_holder = 'images' AND agm_common_descriptions.lang_code = 'ar' WHERE agm_images_links.object_type = 'category' AND agm_images_links.type = 'M' AND agm_images_links.object_id = '14396' ORDER BY agm_images_links.position, agm_images_links.pair_id

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_category_data() /var/www/agmarq.com/app/controllers/frontend/categories.php:79
  • fn_get_image_pairs() /var/www/agmarq.com/app/functions/fn.categories.php:824
  • db_multi_query() /var/www/agmarq.com/app/functions/fn.images.php:349
  • Tygh\Database\Connection::multiQuery() /var/www/agmarq.com/app/functions/fn.database.php:168
0.00025 Re-run Backtrace
26
SELECT a.category_id
                 FROM agm_categories as a
                 LEFT JOIN agm_categories as b
                 ON b.category_id IN (14396)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_products() /var/www/agmarq.com/app/controllers/frontend/categories.php:117
  • db_get_fields() /var/www/agmarq.com/app/functions/fn.products.php:1919
  • Tygh\Database\Connection::getColumn() /var/www/agmarq.com/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:479
0.03562 Re-run Backtrace
27
SELECT company_id FROM agm_storefronts_companies WHERE storefront_id = 4

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_products() /var/www/agmarq.com/app/controllers/frontend/categories.php:117
  • Tygh\Storefront\Storefront::__call() /var/www/agmarq.com/app/functions/fn.products.php:1996
  • Tygh\Storefront\Storefront::getRelationValue() /var/www/agmarq.com/app/Tygh/Storefront/Storefront.php:235
  • Tygh\Storefront\RelationsManager::getRelationValue() /var/www/agmarq.com/app/Tygh/Storefront/Storefront.php:273
  • Tygh\Storefront\RelationsManager::getRelatedValues() /var/www/agmarq.com/app/Tygh/Storefront/RelationsManager.php:80
  • Tygh\Database\Connection::getColumn() /var/www/agmarq.com/app/Tygh/Storefront/RelationsManager.php:116
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:479
0.00021 Re-run Backtrace
28
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, agm_supplier_links.supplier_id, products.product_type, products.parent_product_id FROM agm_products as products  LEFT JOIN agm_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ar'  LEFT JOIN agm_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1  AND agm_categories.category_id IN (14396) AND companies.status IN ('A') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.product_type != 'D' GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 12

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_products() /var/www/agmarq.com/app/controllers/frontend/categories.php:117
  • {closure}() /var/www/agmarq.com/app/functions/fn.products.php:2430
  • db_get_array() /var/www/agmarq.com/app/functions/fn.products.php:2354
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00074 Re-run Backtrace
29
SELECT FOUND_ROWS()

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_products() /var/www/agmarq.com/app/controllers/frontend/categories.php:117
  • {closure}() /var/www/agmarq.com/app/functions/fn.products.php:2430
  • db_get_found_rows() /var/www/agmarq.com/app/functions/fn.products.php:2357
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:332
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00012 Re-run Backtrace
30
SELECT default_view, selected_views FROM agm_categories WHERE category_id = 14396

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_products_layout() /var/www/agmarq.com/app/controllers/frontend/categories.php:139
  • db_get_row() /var/www/agmarq.com/app/functions/fn.products.php:2847
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00025 Re-run Backtrace
31
SELECT category_id, category FROM agm_category_descriptions WHERE category_id IN (1086, 1087, 1088) AND lang_code = 'ar'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_run_controller() /var/www/agmarq.com/app/functions/fn.control.php:458
  • include() /var/www/agmarq.com/app/functions/fn.control.php:722
  • fn_get_category_name() /var/www/agmarq.com/app/controllers/frontend/categories.php:155
  • db_get_hash_single_array() /var/www/agmarq.com/app/functions/fn.categories.php:904
  • Tygh\Database\Connection::getSingleHash() /var/www/agmarq.com/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:571
0.00029 Re-run Backtrace
32
SELECT privilege FROM agm_usergroup_privileges WHERE usergroup_id IN (0, 1)

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_check_permissions() /var/www/agmarq.com/app/functions/fn.control.php:517
  • fn_check_admin_permissions() /var/www/agmarq.com/app/functions/fn.common.php:2544
  • db_get_fields() /var/www/agmarq.com/app/functions/fn.common.php:2726
  • Tygh\Database\Connection::getColumn() /var/www/agmarq.com/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:479
0.00022 Re-run Backtrace
33
SELECT name, path FROM agm_seo_names WHERE `object_id` = 14396 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.control.php:623
  • fn_seo_dispatch_before_display() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_url() /var/www/agmarq.com/app/addons/seo/func.php:3073
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.common.php:3946
  • fn_seo_url_post() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/agmarq.com/app/addons/seo/func.php:1587
  • db_get_row() /var/www/agmarq.com/app/addons/seo/func.php:1317
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00046 Re-run Backtrace
34
SELECT c.* FROM agm_bm_containers as c  WHERE 1  AND c.location_id = 121 AND c.company_id = 0

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /var/www/agmarq.com/app/Tygh/BlockManager/Container.php:111
  • db_get_hash_array() /var/www/agmarq.com/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00075 Re-run Backtrace
35
SELECT layout_id FROM agm_bm_locations WHERE location_id = 121

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /var/www/agmarq.com/app/Tygh/BlockManager/Container.php:112
  • db_get_field() /var/www/agmarq.com/app/Tygh/BlockManager/Container.php:60
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00018 Re-run Backtrace
36
SELECT c.*, IF (c.location_id != 121, 0, 1) as `default` FROM agm_bm_containers as c  INNER JOIN agm_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 7 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Container::getListByArea() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:127
  • Tygh\BlockManager\Container::getList() /var/www/agmarq.com/app/Tygh/BlockManager/Container.php:112
  • db_get_hash_array() /var/www/agmarq.com/app/Tygh/BlockManager/Container.php:72
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00118 Re-run Backtrace
37
SELECT * FROM agm_bm_containers as c LEFT JOIN agm_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (469, 470, 483, 472) ORDER BY g.order, g.parent_id, g.grid_id ASC

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Grid::getList() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:133
  • db_get_hash_multi_array() /var/www/agmarq.com/app/Tygh/BlockManager/Grid.php:63
  • Tygh\Database\Connection::getMultiHash() /var/www/agmarq.com/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:525
0.00061 Re-run Backtrace
38
SELECT agm_bm_snapping.grid_id as grid_id,agm_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,agm_bm_block_statuses.object_ids as object_ids,agm_bm_snapping.*,agm_bm_blocks.*,agm_bm_blocks_descriptions.* FROM agm_bm_snapping LEFT JOIN agm_bm_blocks ON agm_bm_blocks.block_id = agm_bm_snapping.block_id LEFT JOIN agm_bm_block_statuses ON agm_bm_snapping.snapping_id = agm_bm_block_statuses.snapping_id AND agm_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN agm_bm_blocks_descriptions ON agm_bm_blocks.block_id = agm_bm_blocks_descriptions.block_id  LEFT JOIN agm_bm_blocks_content AS default_content ON agm_bm_blocks.block_id = default_content.block_id AND agm_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 agm_bm_blocks_content AS dynamic_object_content ON agm_bm_blocks.block_id = dynamic_object_content.block_id AND agm_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 14396 AND dynamic_object_content.object_type like 'categories' WHERE agm_bm_snapping.grid_id IN (552, 553, 554, 555, 558, 559, 556, 557, 560, 563, 566, 571, 564, 565, 567, 568, 569, 570, 572, 573, 588, 589, 590)  AND agm_bm_blocks_descriptions.lang_code='ar'  ORDER BY agm_bm_snapping.order, agm_bm_snapping.block_id 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::__construct() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:50
  • Tygh\BlockManager\Block::getList() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:137
  • db_get_hash_multi_array() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:252
  • Tygh\Database\Connection::getMultiHash() /var/www/agmarq.com/app/functions/fn.database.php:98
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:525
0.00100 Re-run Backtrace
39
SELECT a.code, b.state FROM agm_states as a LEFT JOIN agm_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'ar' WHERE  a.country_code = 'US' ORDER BY b.state

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:820
  • fn_geo_maps_get_customer_stored_geolocation()
  • Tygh\Application::offsetGet() /var/www/agmarq.com/app/addons/geo_maps/func.php:30
  • Pimple\Container::offsetGet() /var/www/agmarq.com/app/Tygh/Application.php:135
  • Tygh\Providers\LocationProvider::Tygh\Providers\{closure}() /var/www/agmarq.com/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Application::offsetGet() /var/www/agmarq.com/app/Tygh/Providers/LocationProvider.php:40
  • Pimple\Container::offsetGet() /var/www/agmarq.com/app/Tygh/Application.php:135
  • Tygh\Providers\LocationProvider::Tygh\Providers\{closure}() /var/www/agmarq.com/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • Tygh\Location\Location::__construct() /var/www/agmarq.com/app/Tygh/Providers/LocationProvider.php:68
  • Tygh\Location\Location::setState() /var/www/agmarq.com/app/Tygh/Location/Location.php:69
  • Tygh\Location\Location::isIsoCode() /var/www/agmarq.com/app/Tygh/Location/Location.php:143
  • Tygh\Location\Location::getCountryStates() /var/www/agmarq.com/app/Tygh/Location/Location.php:243
  • fn_get_country_states() /var/www/agmarq.com/app/Tygh/Location/Location.php:262
  • db_get_hash_single_array() /var/www/agmarq.com/app/functions/fn.locations.php:290
  • Tygh\Database\Connection::getSingleHash() /var/www/agmarq.com/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:571
0.00146 Re-run Backtrace
40
SELECT * FROM agm_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:820
  • fn_hybrid_auth_get_providers_list_content()
  • fn_hybrid_auth_get_providers_list() /var/www/agmarq.com/app/addons/hybrid_auth/func.php:243
  • Tygh\Registry::getOrSetCache() /var/www/agmarq.com/app/addons/hybrid_auth/func.php:222
  • {closure}() /var/www/agmarq.com/app/Tygh/Registry.php:800
  • db_get_hash_array() /var/www/agmarq.com/app/addons/hybrid_auth/func.php:196
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00033 Re-run Backtrace
41
SELECT name, path FROM agm_seo_names WHERE `object_id` = 1086 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:681
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c9b12779_86431531() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_url() /var/www/agmarq.com/var/cache/templates/bright_theme/2e9f67a5cf3c100f928346df3ab822406bbc20f0_2.tygh.breadcrumbs.tpl.php:72
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.common.php:3946
  • fn_seo_url_post() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/agmarq.com/app/addons/seo/func.php:1587
  • db_get_row() /var/www/agmarq.com/app/addons/seo/func.php:1317
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00140 Re-run Backtrace
42
SELECT name, path FROM agm_seo_names WHERE `object_id` = 1087 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:681
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c9b12779_86431531() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_url() /var/www/agmarq.com/var/cache/templates/bright_theme/2e9f67a5cf3c100f928346df3ab822406bbc20f0_2.tygh.breadcrumbs.tpl.php:72
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.common.php:3946
  • fn_seo_url_post() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/agmarq.com/app/addons/seo/func.php:1587
  • db_get_row() /var/www/agmarq.com/app/addons/seo/func.php:1317
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00042 Re-run Backtrace
43
SELECT name, path FROM agm_seo_names WHERE `object_id` = 1088 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:681
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c9b12779_86431531() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_url() /var/www/agmarq.com/var/cache/templates/bright_theme/2e9f67a5cf3c100f928346df3ab822406bbc20f0_2.tygh.breadcrumbs.tpl.php:72
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.common.php:3946
  • fn_seo_url_post() /var/www/agmarq.com/app/functions/fn.control.php:123
  • fn_seo_get_name() /var/www/agmarq.com/app/addons/seo/func.php:1587
  • db_get_row() /var/www/agmarq.com/app/addons/seo/func.php:1317
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00072 Re-run Backtrace
44
SELECT state_id FROM agm_states WHERE code = 'MA' AND country_code = 'US'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:930
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /var/www/agmarq.com/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /var/www/agmarq.com/app/Tygh/Location/Manager.php:409
  • fn_get_state_id() /var/www/agmarq.com/app/functions/fn.locations.php:493
  • db_get_field() /var/www/agmarq.com/app/functions/fn.locations.php:612
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00062 Re-run Backtrace
45
SELECT a.code, b.state FROM agm_states as a LEFT JOIN agm_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'ar' WHERE  a.country_code = 'US' AND a.status = 'A' ORDER BY b.state

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:930
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /var/www/agmarq.com/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /var/www/agmarq.com/app/Tygh/Location/Manager.php:409
  • fn_get_country_states() /var/www/agmarq.com/app/functions/fn.locations.php:496
  • db_get_hash_single_array() /var/www/agmarq.com/app/functions/fn.locations.php:290
  • Tygh\Database\Connection::getSingleHash() /var/www/agmarq.com/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:571
0.00097 Re-run Backtrace
46
SELECT a.* FROM agm_destination_elements as a LEFT JOIN agm_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:930
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /var/www/agmarq.com/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /var/www/agmarq.com/app/Tygh/Location/Manager.php:409
  • db_get_array() /var/www/agmarq.com/app/functions/fn.locations.php:508
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00112 Re-run Backtrace
47
SELECT a.* FROM agm_destination_elements as a LEFT JOIN agm_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.filters.php:1293
  • fn_warehouses_get_filters_products_count_pre() /var/www/agmarq.com/app/functions/fn.control.php:123
  • Tygh\Location\Manager::getDestinationId() /var/www/agmarq.com/app/addons/warehouses/func.php:1944
  • fn_get_available_destination() /var/www/agmarq.com/app/Tygh/Location/Manager.php:409
  • db_get_array() /var/www/agmarq.com/app/functions/fn.locations.php:508
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00091 Re-run Backtrace
48
SELECT id_path FROM agm_categories WHERE category_id = 14396

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1310
  • db_get_field() /var/www/agmarq.com/app/functions/fn.filters.php:1546
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00020 Re-run Backtrace
49
SELECT category_id FROM agm_categories WHERE id_path LIKE '1086/1087/1088/14396/%'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1310
  • db_get_fields() /var/www/agmarq.com/app/functions/fn.filters.php:1547
  • Tygh\Database\Connection::getColumn() /var/www/agmarq.com/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:479
0.00019 Re-run Backtrace
50
SELECT agm_product_filters.feature_id, agm_product_filters.filter_id, agm_product_filters.field_type, agm_product_filters.round_to, agm_product_filters.display, agm_product_filters.display_count, agm_product_filter_descriptions.filter, agm_product_features.feature_type, agm_product_features.filter_style, agm_product_features_descriptions.prefix, agm_product_features_descriptions.suffix FROM agm_product_filters  LEFT JOIN agm_product_filter_descriptions ON agm_product_filter_descriptions.filter_id = agm_product_filters.filter_id AND agm_product_filter_descriptions.lang_code = 'ar' LEFT JOIN agm_product_features ON agm_product_features.feature_id = agm_product_filters.feature_id LEFT JOIN agm_product_features_descriptions ON agm_product_features_descriptions.feature_id = agm_product_filters.feature_id AND agm_product_features_descriptions.lang_code = 'ar' WHERE agm_product_filters.status = 'A'  AND (agm_product_filters.categories_path = '' OR FIND_IN_SET(14396, agm_product_filters.categories_path)) ORDER BY agm_product_filters.position, agm_product_filter_descriptions.filter

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1310
  • db_get_hash_array() /var/www/agmarq.com/app/functions/fn.filters.php:1612
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00040 Re-run Backtrace
51
SELECT feature_id, feature_type FROM agm_product_features WHERE feature_id IN (18, 549, 548)

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • fn_product_filters_get_feature_type_map() /var/www/agmarq.com/app/functions/fn.filters.php:1703
  • db_get_array() /var/www/agmarq.com/app/functions/fn.filters.php:1087
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00017 Re-run Backtrace
52
SELECT a.category_id
                 FROM agm_categories as a
                 LEFT JOIN agm_categories as b
                 ON b.category_id IN (14396)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • fn_product_filters_get_products_conditions() /var/www/agmarq.com/app/functions/fn.filters.php:1718
  • fn_get_products() /var/www/agmarq.com/app/functions/fn.filters.php:1123
  • db_get_fields() /var/www/agmarq.com/app/functions/fn.products.php:1919
  • Tygh\Database\Connection::getColumn() /var/www/agmarq.com/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:479
0.04153 Re-run Backtrace
53
CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM agm_products AS products  LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1=1  AND agm_categories.category_id IN (14396) AND companies.status IN ('A') 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 products.product_type != 'D' ORDER BY NULL

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • fn_product_filters_get_products_conditions() /var/www/agmarq.com/app/functions/fn.filters.php:1718
  • fn_product_filters_create_temporary_products_table() /var/www/agmarq.com/app/functions/fn.filters.php:1129
  • db_query() /var/www/agmarq.com/app/functions/fn.filters.php:1181
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/functions/fn.database.php:138
0.00092 Re-run Backtrace
54
SELECT agm_product_features_values.feature_id, agm_product_features_values.variant_id FROM agm_product_features_values INNER JOIN _product_filters_products_1 AS products ON products.product_id = agm_product_features_values.product_id   WHERE agm_product_features_values.feature_id IN (18, 548, 549) AND agm_product_features_values.lang_code = 'ar'   GROUP BY agm_product_features_values.variant_id ORDER BY NULL

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • db_get_hash_single_array() /var/www/agmarq.com/app/functions/fn.filters.php:1733
  • Tygh\Database\Connection::getSingleHash() /var/www/agmarq.com/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:571
0.00037 Re-run Backtrace
55
SELECT a.category_id
                 FROM agm_categories as a
                 LEFT JOIN agm_categories as b
                 ON b.category_id IN (14396)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • fn_product_filters_get_products_conditions() /var/www/agmarq.com/app/functions/fn.filters.php:1883
  • fn_get_products() /var/www/agmarq.com/app/functions/fn.filters.php:1123
  • db_get_fields() /var/www/agmarq.com/app/functions/fn.products.php:1919
  • Tygh\Database\Connection::getColumn() /var/www/agmarq.com/app/functions/fn.database.php:85
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:479
0.02961 Re-run Backtrace
56
SELECT * FROM  agm_csc_filter_by_categories WHERE 1  AND agm_csc_filter_by_categories.company_id=0

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • fn_get_product_filter_fields() /var/www/agmarq.com/app/functions/fn.filters.php:1885
  • fn_set_hook() /var/www/agmarq.com/app/functions/fn.filters.php:979
  • fn_csc_filter_by_categories_get_product_filter_fields() /var/www/agmarq.com/app/functions/fn.control.php:123
  • csc_filter_by_categories::_zxev() /var/www/agmarq.com/app/addons/csc_filter_by_categories/func.php:36
  • eval() /var/www/agmarq.com/app/addons/csc_filter_by_categories/lic.php(1) : eval()'d code(5) : eval()'d code:1
  • fn_cfbc_get_setting_value() /var/www/agmarq.com/app/addons/csc_filter_by_categories/lic.php(1) : eval()'d code(5) : eval()'d code(1) : eval()'d code:2
  • Tygh\CscFilterByCategories::_get_option_values() /var/www/agmarq.com/app/addons/csc_filter_by_categories/func.php:28
  • csc_filter_by_categories::_format_options() /var/www/agmarq.com/app/addons/csc_filter_by_categories/Tygh/CscFilterByCategories.php:66
  • db_get_hash_single_array() /var/www/agmarq.com/app/addons/csc_filter_by_categories/lic.php(1) : eval()'d code(5) : eval()'d code:1
  • Tygh\Database\Connection::getSingleHash() /var/www/agmarq.com/app/functions/fn.database.php:111
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:571
0.00358 Re-run Backtrace
57
SELECT agm_products_categories.category_id as variant_id, IF(ccd2.category IS NOT NULL, CONCAT(ccd2.category, ' > ', ccd.category), ccd.category) as variant FROM agm_products_categories   LEFT JOIN agm_products as products ON products.product_id = agm_products_categories.product_id INNER JOIN agm_category_descriptions as ccd ON agm_products_categories.category_id= ccd.category_id
				AND ccd.lang_code='ar' INNER JOIN agm_categories as cc ON ccd.category_id=cc.category_id 
				LEFT JOIN agm_category_descriptions as ccd2 ON cc.parent_id= ccd2.category_id AND ccd2.lang_code='ar'  LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1=1  AND cc.status='A' AND cc.company_id=0 AND agm_products_categories.link_type='M'  AND agm_categories.category_id IN (14396) AND companies.status IN ('A') 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 products.product_type != 'D' GROUP BY agm_products_categories.category_id ORDER BY IF(ccd2.category IS NOT NULL, CONCAT(ccd2.category, ' > ', ccd.category), ccd.category) ASC

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • db_get_hash_array() /var/www/agmarq.com/app/functions/fn.filters.php:1973
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00081 Re-run Backtrace
58
SELECT products.company_id as variant_id, company_descr.i18n_company as variant FROM agm_products  as products  LEFT JOIN agm_company_descriptions as company_descr ON company_descr.company_id = products.company_id AND company_descr.lang_code = 'ar'  LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1=1   AND agm_categories.category_id IN (14396) AND companies.status IN ('A') 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 products.product_type != 'D' GROUP BY products.company_id ORDER BY company_descr.i18n_company ASC

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • db_get_hash_array() /var/www/agmarq.com/app/functions/fn.filters.php:1973
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00055 Re-run Backtrace
59
SELECT MIN(agm_product_prices.price) as min, MAX(agm_product_prices.price) as max FROM agm_product_prices   LEFT JOIN agm_products as products ON products.product_id = agm_product_prices.product_id
                    LEFT JOIN agm_product_prices as prices_2 ON agm_product_prices.product_id = prices_2.product_id AND agm_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_1 ON products.product_id = _product_filters_products_1.product_id  WHERE products.status IN ('A') 
                    AND agm_product_prices.lower_limit = 1 AND agm_product_prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • db_get_row() /var/www/agmarq.com/app/functions/fn.filters.php:1957
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00029 Re-run Backtrace
60
DROP TEMPORARY TABLE _product_filters_products_1

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_searchanise_get_filters_products_count()
  • fn_product_filters_get_filters_products_count() /var/www/agmarq.com/app/addons/searchanise/func.php:1361
  • fn_product_filters_get_current_filters() /var/www/agmarq.com/app/functions/fn.filters.php:1324
  • fn_product_filters_drop_temporary_products_tables() /var/www/agmarq.com/app/functions/fn.filters.php:2039
  • db_query() /var/www/agmarq.com/app/functions/fn.filters.php:1214
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/functions/fn.database.php:138
0.00023 Re-run Backtrace
61
SELECT a.* FROM agm_destination_elements as a LEFT JOIN agm_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:930
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /var/www/agmarq.com/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /var/www/agmarq.com/app/Tygh/Location/Manager.php:409
  • db_get_array() /var/www/agmarq.com/app/functions/fn.locations.php:508
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00158 Re-run Backtrace
62
SELECT id_path FROM agm_categories WHERE category_id = 14396

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_get_categories()
  • db_get_field() /var/www/agmarq.com/app/functions/fn.categories.php:350
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00030 Re-run Backtrace
63
SELECT agm_categories.category_id,agm_categories.parent_id,agm_categories.id_path,agm_category_descriptions.category,agm_categories.position,agm_categories.status,agm_categories.company_id,agm_categories.storefront_id,agm_seo_names.name as seo_name,agm_seo_names.path as seo_path FROM agm_categories LEFT JOIN agm_category_descriptions ON agm_categories.category_id = agm_category_descriptions.category_id AND agm_category_descriptions.lang_code = 'ar'  LEFT JOIN agm_seo_names ON agm_seo_names.object_id = agm_categories.category_id  AND agm_seo_names.type = 'c'  AND agm_seo_names.dispatch = '' AND agm_seo_names.lang_code = 'ar'  WHERE 1=1  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A') AND agm_categories.id_path LIKE '1086/1087/1088/14396/%' AND agm_categories.category_id != 264 AND agm_categories.parent_id != 264 AND agm_categories.storefront_id IN (0, 4)   ORDER BY agm_categories.is_trash asc, agm_categories.position asc, agm_category_descriptions.category asc 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::getValue() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:666
  • Tygh\BlockManager\Block::getItems() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:810
  • call_user_func() /var/www/agmarq.com/app/Tygh/BlockManager/Block.php:974
  • fn_get_categories()
  • db_get_hash_array() /var/www/agmarq.com/app/functions/fn.categories.php:440
  • Tygh\Database\Connection::getHash() /var/www/agmarq.com/app/functions/fn.database.php:48
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:370
0.00097 Re-run Backtrace
64
SELECT a.* FROM agm_destination_elements as a LEFT JOIN agm_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::registerBlockCacheIfNeeded() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:592
  • Tygh\BlockManager\RenderManager::execCallableHandlers() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:930
  • call_user_func_array() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:1029
  • fn_warehouses_blocks_get_customer_destination_id()
  • Tygh\Location\Manager::getDestinationId() /var/www/agmarq.com/app/addons/warehouses/schemas/block_manager/blocks.functions.php:29
  • fn_get_available_destination() /var/www/agmarq.com/app/Tygh/Location/Manager.php:409
  • db_get_array() /var/www/agmarq.com/app/functions/fn.locations.php:508
  • Tygh\Database\Connection::getArray() /var/www/agmarq.com/app/functions/fn.database.php:35
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:332
0.00118 Re-run Backtrace
65
SELECT object_id, thread_id, type, object_type FROM agm_discussion  WHERE 1  AND object_id = 14396 AND object_type = 'C'   

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:639
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:786
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6dd1dd4_71110985() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /var/www/agmarq.com/var/cache/templates/bright_theme/fc79fb7b24bed3bfe878b59512bf447d0c523d6f_2.tygh.view.tpl.php:148
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6ec9302_58385486() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /var/www/agmarq.com/var/cache/templates/bright_theme/8d8a354bee7a1af918221a0367b3cb4331796bf8_2.tygh.view.post.tpl.php:39
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6ef0776_26584716() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_get_discussion() /var/www/agmarq.com/var/cache/templates/bright_theme/eb582a18793aab56fea41445b3c6977479b1e063_2.tygh.block_view.tpl.php:122
  • db_get_row() /var/www/agmarq.com/app/addons/discussion/func.php:248
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00031 Re-run Backtrace
66
SELECT thread_id, type, object_type, object_id FROM agm_discussion WHERE thread_id = 17929 

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:639
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:786
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6dd1dd4_71110985() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /var/www/agmarq.com/var/cache/templates/bright_theme/fc79fb7b24bed3bfe878b59512bf447d0c523d6f_2.tygh.view.tpl.php:148
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6ec9302_58385486() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /var/www/agmarq.com/var/cache/templates/bright_theme/8d8a354bee7a1af918221a0367b3cb4331796bf8_2.tygh.view.post.tpl.php:39
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6ef0776_26584716() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_get_discussion() /var/www/agmarq.com/var/cache/templates/bright_theme/eb582a18793aab56fea41445b3c6977479b1e063_2.tygh.block_view.tpl.php:122
  • fn_get_discussion_posts() /var/www/agmarq.com/app/addons/discussion/func.php:298
  • db_get_row() /var/www/agmarq.com/app/addons/discussion/func.php:353
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00048 Re-run Backtrace
67
SELECT AVG (dr.rating_value) FROM agm_discussion_rating AS dr LEFT JOIN agm_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN agm_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 14396 AND d.object_type = 'C' AND type IN ( 'B', 'R' )  AND dp.status = 'A' AND dr.rating_value > 0

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/functions/fn.control.php:632
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273c19ccc37_66020938() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_function_render_location() /var/www/agmarq.com/var/cache/templates/bright_theme/17f54f12005acbf063cc11c61dcc210a758d2cb0_2.tygh.index.tpl.php:161
  • Tygh\BlockManager\RenderManager::render() /var/www/agmarq.com/app/functions/smarty_plugins/function.render_location.php:52
  • Tygh\BlockManager\RenderManager::_renderContainer() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:164
  • Tygh\BlockManager\RenderManager::renderGrids() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:200
  • Tygh\BlockManager\RenderManager::renderGrid() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:230
  • Tygh\BlockManager\RenderManager::renderBlocks() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:373
  • Tygh\BlockManager\RenderManager::renderBlock() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:415
  • Tygh\BlockManager\RenderManager::renderBlockContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:493
  • Tygh\BlockManager\RenderManager::_renderMainContent() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:639
  • Tygh\SmartyEngine\Core::fetch() /var/www/agmarq.com/app/Tygh/BlockManager/RenderManager.php:786
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/Tygh/SmartyEngine/Core.php:81
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6dd1dd4_71110985() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • smarty_block_hook() /var/www/agmarq.com/var/cache/templates/bright_theme/fc79fb7b24bed3bfe878b59512bf447d0c523d6f_2.tygh.view.tpl.php:148
  • Smarty_Internal_TemplateBase::fetch() /var/www/agmarq.com/app/functions/smarty_plugins/block.hook.php:136
  • Smarty_Internal_TemplateBase::_execute() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6ec9302_58385486() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • Smarty_Internal_Template::_subTemplateRender() /var/www/agmarq.com/var/cache/templates/bright_theme/8d8a354bee7a1af918221a0367b3cb4331796bf8_2.tygh.view.post.tpl.php:39
  • Smarty_Internal_Template::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:385
  • Smarty_Template_Compiled::render() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:216
  • Smarty_Template_Resource_Base::getRenderedTemplateCode() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114
  • content_67f273f6ef0776_26584716() /var/www/agmarq.com/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123
  • fn_get_discussion() /var/www/agmarq.com/var/cache/templates/bright_theme/eb582a18793aab56fea41445b3c6977479b1e063_2.tygh.block_view.tpl.php:122
  • fn_discussion_get_average_object_rating() /var/www/agmarq.com/app/addons/discussion/func.php:300
  • db_get_field() /var/www/agmarq.com/app/addons/discussion/func.php:976
  • Tygh\Database\Connection::getField() /var/www/agmarq.com/app/functions/fn.database.php:73
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:447
0.00050 Re-run Backtrace
68
SELECT data FROM agm_storage_data WHERE data_key = 'restrictions'

    Backtrace

  • fn_dispatch() /var/www/agmarq.com/index.php:19
  • Tygh\Application::offsetGet() /var/www/agmarq.com/app/functions/fn.control.php:648
  • Pimple\Container::offsetGet() /var/www/agmarq.com/app/Tygh/Application.php:135
  • Tygh\Providers\CommonProvider::Tygh\Providers\{closure}() /var/www/agmarq.com/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122
  • fn_get_storage_data() /var/www/agmarq.com/app/Tygh/Providers/CommonProvider.php:77
  • db_get_row() /var/www/agmarq.com/app/functions/fn.control.php:1067
  • Tygh\Database\Connection::getRow() /var/www/agmarq.com/app/functions/fn.database.php:60
  • Tygh\Database\Connection::query() /var/www/agmarq.com/app/Tygh/Database/Connection.php:413
0.00062 Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 4
Query Count Min time Max time Average time
SELECT a.* FROM agm_destination_elements as a LEFT JOIN agm_destinations as b ON b.destination_id = a.destination_id WHERE b.status = 'A' 
4 0.00091 0.00158 0.00120
SELECT id_path FROM agm_categories WHERE category_id = 14396
3 0.00020 0.00030 0.00023
SELECT a.category_id
                 FROM agm_categories as a
                 LEFT JOIN agm_categories as b
                 ON b.category_id IN (14396)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
3 0.02961 0.04153 0.03559
SELECT * FROM agm_hybrid_auth_providers WHERE 1  AND status = 'A' ORDER BY position
2 0.00026 0.00033 0.00030
SELECT data FROM agm_storage_data WHERE data_key = 'store_mode'
1 0.00022 0.00022 0.00022
SELECT storefronts.* FROM agm_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'agmarq.com' OR storefronts.url = 'www.agmarq.com' OR storefronts.url LIKE 'www_.agmarq.com' OR storefronts.url LIKE 'agmarq.com/%' OR storefronts.url LIKE 'www.agmarq.com/%' OR storefronts.url LIKE 'www_.agmarq.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'agmarq.com' DESC, storefronts.url = 'www.agmarq.com' DESC, storefronts.url LIKE 'www_.agmarq.com' DESC, storefronts.url LIKE 'agmarq.com/%' DESC, storefronts.url LIKE 'www.agmarq.com/%' DESC, storefronts.url LIKE 'www_.agmarq.com/%' desc 
1 0.00018 0.00018 0.00018
SET time_zone = '+05:00'
1 0.00008 0.00008 0.00008
SELECT data FROM agm_storage_data WHERE data_key = 'ms_time_check_ms_smart_description'
1 0.00071 0.00071 0.00071
SELECT type FROM agm_seo_names WHERE name = 'biscuits-manufacturing-consultancy' 
1 0.00035 0.00035 0.00035
SELECT * FROM agm_seo_names WHERE name = 'biscuits-manufacturing-consultancy'  AND lang_code = 'ar'
1 0.00027 0.00027 0.00027
SELECT agm_languages.lang_code, agm_languages.name FROM agm_languages  WHERE 1 AND agm_languages.status = 'A'   
1 0.00011 0.00011 0.00011
SELECT storefronts.* FROM agm_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (4) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
1 0.00017 0.00017 0.00017
SELECT name, path FROM agm_seo_names WHERE `object_id` = 14396 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 
1 0.00023 0.00023 0.00023
SELECT agm_bm_layouts.* FROM agm_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'bright_theme' AND storefront_id = 4
1 0.00021 0.00021 0.00021
SELECT data FROM agm_storage_data WHERE data_key = 'cart_products_next_check'
1 0.00018 0.00018 0.00018
SELECT data FROM agm_storage_data WHERE data_key = 'dev_mode'
1 0.00026 0.00026 0.00026
SELECT * FROM agm_languages WHERE status = 'A'
1 0.00034 0.00034 0.00034
SELECT * FROM agm_se_settings
1 0.00020 0.00020 0.00020
SELECT * FROM agm_bm_layouts WHERE 1  AND storefront_id = 4 AND layout_id = 7
1 0.00014 0.00014 0.00014
SELECT * FROM agm_bm_locations as l LEFT JOIN agm_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'ar' WHERE l.layout_id = 7  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(14396, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
1 0.00038 0.00038 0.00038
SELECT data FROM agm_storage_data WHERE data_key = 'cache_id'
1 0.00010 0.00010 0.00010
SELECT usergroup_ids FROM agm_categories WHERE category_id = 14396
1 0.00014 0.00014 0.00014
SELECT category_id FROM agm_categories WHERE category_id = 14396  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)
1 0.00015 0.00015 0.00015
SELECT category_id FROM agm_categories WHERE category_type = 'D'
1 0.03548 0.03548 0.03548
SELECT agm_categories.category_id,agm_categories.parent_id,agm_categories.id_path,agm_category_descriptions.category,agm_categories.position,agm_categories.status,agm_categories.company_id,agm_categories.storefront_id,agm_seo_names.name as seo_name,agm_seo_names.path as seo_path FROM agm_categories LEFT JOIN agm_category_descriptions ON agm_categories.category_id = agm_category_descriptions.category_id AND agm_category_descriptions.lang_code = 'ar'  LEFT JOIN agm_seo_names ON agm_seo_names.object_id = agm_categories.category_id  AND agm_seo_names.type = 'c'  AND agm_seo_names.dispatch = '' AND agm_seo_names.lang_code = 'ar'  WHERE 1=1  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A') AND agm_categories.parent_id IN (14396) AND agm_categories.id_path LIKE '1086/1087/1088/14396/%' AND agm_categories.category_id != 264 AND agm_categories.parent_id != 264 AND agm_categories.storefront_id IN (0, 4)   ORDER BY agm_categories.is_trash asc, agm_categories.position asc, agm_category_descriptions.category asc 
1 0.00054 0.00054 0.00054
SELECT *, agm_seo_names.name as seo_name, agm_seo_names.path as seo_path FROM agm_categories LEFT JOIN agm_category_descriptions ON agm_category_descriptions.category_id = agm_categories.category_id AND agm_category_descriptions.lang_code = 'ar'  LEFT JOIN agm_seo_names ON agm_seo_names.object_id = 14396  AND agm_seo_names.type = 'c'  AND agm_seo_names.dispatch = '' AND agm_seo_names.lang_code = 'ar'  WHERE agm_categories.category_id = 14396 AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids))
1 0.00033 0.00033 0.00033
SELECT agm_images.*, agm_images_links.*, agm_common_descriptions.description AS alt, agm_images.image_id AS images_image_id FROM agm_images_links LEFT JOIN agm_images ON agm_images_links.image_id = agm_images.image_id LEFT JOIN agm_common_descriptions ON agm_common_descriptions.object_id = agm_images.image_id AND agm_common_descriptions.object_holder = 'images' AND agm_common_descriptions.lang_code = 'ar' WHERE agm_images_links.object_type = 'category' AND agm_images_links.type = 'M' AND agm_images_links.object_id = '14396' ORDER BY agm_images_links.position, agm_images_links.pair_id;SELECT agm_images.*, agm_images_links.*, agm_common_descriptions.description AS alt, agm_images.image_id AS images_image_id FROM agm_images_links LEFT JOIN agm_images ON agm_images_links.detailed_id = agm_images.image_id LEFT JOIN agm_common_descriptions ON agm_common_descriptions.object_id = agm_images.image_id AND agm_common_descriptions.object_holder = 'images' AND agm_common_descriptions.lang_code = 'ar' WHERE agm_images_links.object_type = 'category' AND agm_images_links.type = 'M' AND agm_images_links.object_id = '14396' ORDER BY agm_images_links.position, agm_images_links.pair_id
1 0.00025 0.00025 0.00025
SELECT company_id FROM agm_storefronts_companies WHERE storefront_id = 4
1 0.00021 0.00021 0.00021
SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, agm_supplier_links.supplier_id, products.product_type, products.parent_product_id FROM agm_products as products  LEFT JOIN agm_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'ar'  LEFT JOIN agm_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1  AND agm_categories.category_id IN (14396) AND companies.status IN ('A') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 AND products.product_type != 'D' GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 12
1 0.00074 0.00074 0.00074
SELECT FOUND_ROWS()
1 0.00012 0.00012 0.00012
SELECT default_view, selected_views FROM agm_categories WHERE category_id = 14396
1 0.00025 0.00025 0.00025
SELECT category_id, category FROM agm_category_descriptions WHERE category_id IN (1086, 1087, 1088) AND lang_code = 'ar'
1 0.00029 0.00029 0.00029
SELECT privilege FROM agm_usergroup_privileges WHERE usergroup_id IN (0, 1)
1 0.00022 0.00022 0.00022
SELECT name, path FROM agm_seo_names WHERE `object_id` = 14396 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' 
1 0.00046 0.00046 0.00046
SELECT c.* FROM agm_bm_containers as c  WHERE 1  AND c.location_id = 121 AND c.company_id = 0
1 0.00075 0.00075 0.00075
SELECT layout_id FROM agm_bm_locations WHERE location_id = 121
1 0.00018 0.00018 0.00018
SELECT c.*, IF (c.location_id != 121, 0, 1) as `default` FROM agm_bm_containers as c  INNER JOIN agm_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 7 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
1 0.00118 0.00118 0.00118
SELECT * FROM agm_bm_containers as c LEFT JOIN agm_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (469, 470, 483, 472) ORDER BY g.order, g.parent_id, g.grid_id ASC
1 0.00061 0.00061 0.00061
SELECT agm_bm_snapping.grid_id as grid_id,agm_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,agm_bm_block_statuses.object_ids as object_ids,agm_bm_snapping.*,agm_bm_blocks.*,agm_bm_blocks_descriptions.* FROM agm_bm_snapping LEFT JOIN agm_bm_blocks ON agm_bm_blocks.block_id = agm_bm_snapping.block_id LEFT JOIN agm_bm_block_statuses ON agm_bm_snapping.snapping_id = agm_bm_block_statuses.snapping_id AND agm_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN agm_bm_blocks_descriptions ON agm_bm_blocks.block_id = agm_bm_blocks_descriptions.block_id  LEFT JOIN agm_bm_blocks_content AS default_content ON agm_bm_blocks.block_id = default_content.block_id AND agm_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 agm_bm_blocks_content AS dynamic_object_content ON agm_bm_blocks.block_id = dynamic_object_content.block_id AND agm_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 14396 AND dynamic_object_content.object_type like 'categories' WHERE agm_bm_snapping.grid_id IN (552, 553, 554, 555, 558, 559, 556, 557, 560, 563, 566, 571, 564, 565, 567, 568, 569, 570, 572, 573, 588, 589, 590)  AND agm_bm_blocks_descriptions.lang_code='ar'  ORDER BY agm_bm_snapping.order, agm_bm_snapping.block_id 
1 0.00100 0.00100 0.00100
SELECT a.code, b.state FROM agm_states as a LEFT JOIN agm_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'ar' WHERE  a.country_code = 'US' ORDER BY b.state
1 0.00146 0.00146 0.00146
SELECT name, path FROM agm_seo_names WHERE `object_id` = 1086 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 
1 0.00140 0.00140 0.00140
SELECT name, path FROM agm_seo_names WHERE `object_id` = 1087 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 
1 0.00042 0.00042 0.00042
SELECT name, path FROM agm_seo_names WHERE `object_id` = 1088 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'ar' 
1 0.00072 0.00072 0.00072
SELECT state_id FROM agm_states WHERE code = 'MA' AND country_code = 'US'
1 0.00062 0.00062 0.00062
SELECT a.code, b.state FROM agm_states as a LEFT JOIN agm_state_descriptions as b ON b.state_id = a.state_id AND b.lang_code = 'ar' WHERE  a.country_code = 'US' AND a.status = 'A' ORDER BY b.state
1 0.00097 0.00097 0.00097
SELECT category_id FROM agm_categories WHERE id_path LIKE '1086/1087/1088/14396/%'
1 0.00019 0.00019 0.00019
SELECT agm_product_filters.feature_id, agm_product_filters.filter_id, agm_product_filters.field_type, agm_product_filters.round_to, agm_product_filters.display, agm_product_filters.display_count, agm_product_filter_descriptions.filter, agm_product_features.feature_type, agm_product_features.filter_style, agm_product_features_descriptions.prefix, agm_product_features_descriptions.suffix FROM agm_product_filters  LEFT JOIN agm_product_filter_descriptions ON agm_product_filter_descriptions.filter_id = agm_product_filters.filter_id AND agm_product_filter_descriptions.lang_code = 'ar' LEFT JOIN agm_product_features ON agm_product_features.feature_id = agm_product_filters.feature_id LEFT JOIN agm_product_features_descriptions ON agm_product_features_descriptions.feature_id = agm_product_filters.feature_id AND agm_product_features_descriptions.lang_code = 'ar' WHERE agm_product_filters.status = 'A'  AND (agm_product_filters.categories_path = '' OR FIND_IN_SET(14396, agm_product_filters.categories_path)) ORDER BY agm_product_filters.position, agm_product_filter_descriptions.filter
1 0.00040 0.00040 0.00040
SELECT feature_id, feature_type FROM agm_product_features WHERE feature_id IN (18, 549, 548)
1 0.00017 0.00017 0.00017
CREATE TEMPORARY TABLE _product_filters_products_1 (PRIMARY KEY product_id (product_id)) ENGINE = MEMORY IGNORE SELECT products.product_id FROM agm_products AS products  LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1=1  AND agm_categories.category_id IN (14396) AND companies.status IN ('A') 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 products.product_type != 'D' ORDER BY NULL
1 0.00092 0.00092 0.00092
SELECT agm_product_features_values.feature_id, agm_product_features_values.variant_id FROM agm_product_features_values INNER JOIN _product_filters_products_1 AS products ON products.product_id = agm_product_features_values.product_id   WHERE agm_product_features_values.feature_id IN (18, 548, 549) AND agm_product_features_values.lang_code = 'ar'   GROUP BY agm_product_features_values.variant_id ORDER BY NULL
1 0.00037 0.00037 0.00037
SELECT * FROM  agm_csc_filter_by_categories WHERE 1  AND agm_csc_filter_by_categories.company_id=0
1 0.00358 0.00358 0.00358
SELECT agm_products_categories.category_id as variant_id, IF(ccd2.category IS NOT NULL, CONCAT(ccd2.category, ' > ', ccd.category), ccd.category) as variant FROM agm_products_categories   LEFT JOIN agm_products as products ON products.product_id = agm_products_categories.product_id INNER JOIN agm_category_descriptions as ccd ON agm_products_categories.category_id= ccd.category_id
				AND ccd.lang_code='ar' INNER JOIN agm_categories as cc ON ccd.category_id=cc.category_id 
				LEFT JOIN agm_category_descriptions as ccd2 ON cc.parent_id= ccd2.category_id AND ccd2.lang_code='ar'  LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1=1  AND cc.status='A' AND cc.company_id=0 AND agm_products_categories.link_type='M'  AND agm_categories.category_id IN (14396) AND companies.status IN ('A') 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 products.product_type != 'D' GROUP BY agm_products_categories.category_id ORDER BY IF(ccd2.category IS NOT NULL, CONCAT(ccd2.category, ' > ', ccd.category), ccd.category) ASC
1 0.00081 0.00081 0.00081
SELECT products.company_id as variant_id, company_descr.i18n_company as variant FROM agm_products  as products  LEFT JOIN agm_company_descriptions as company_descr ON company_descr.company_id = products.company_id AND company_descr.lang_code = 'ar'  LEFT JOIN agm_companies AS companies ON companies.company_id = products.company_id  INNER JOIN agm_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN agm_categories ON agm_categories.category_id = products_categories.category_id  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A', 'H') AND agm_categories.storefront_id IN (0, 4)  LEFT JOIN agm_supplier_links ON agm_supplier_links.object_id = products.product_id AND agm_supplier_links.object_type = 'P'  LEFT JOIN agm_warehouses_sum_products_amount as war_sum_amount ON war_sum_amount.product_id = products.product_id WHERE 1=1   AND agm_categories.category_id IN (14396) AND companies.status IN ('A') 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 products.product_type != 'D' GROUP BY products.company_id ORDER BY company_descr.i18n_company ASC
1 0.00055 0.00055 0.00055
SELECT MIN(agm_product_prices.price) as min, MAX(agm_product_prices.price) as max FROM agm_product_prices   LEFT JOIN agm_products as products ON products.product_id = agm_product_prices.product_id
                    LEFT JOIN agm_product_prices as prices_2 ON agm_product_prices.product_id = prices_2.product_id AND agm_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_1 ON products.product_id = _product_filters_products_1.product_id  WHERE products.status IN ('A') 
                    AND agm_product_prices.lower_limit = 1 AND agm_product_prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL 
1 0.00029 0.00029 0.00029
DROP TEMPORARY TABLE _product_filters_products_1
1 0.00023 0.00023 0.00023
SELECT agm_categories.category_id,agm_categories.parent_id,agm_categories.id_path,agm_category_descriptions.category,agm_categories.position,agm_categories.status,agm_categories.company_id,agm_categories.storefront_id,agm_seo_names.name as seo_name,agm_seo_names.path as seo_path FROM agm_categories LEFT JOIN agm_category_descriptions ON agm_categories.category_id = agm_category_descriptions.category_id AND agm_category_descriptions.lang_code = 'ar'  LEFT JOIN agm_seo_names ON agm_seo_names.object_id = agm_categories.category_id  AND agm_seo_names.type = 'c'  AND agm_seo_names.dispatch = '' AND agm_seo_names.lang_code = 'ar'  WHERE 1=1  AND (agm_categories.usergroup_ids = '' OR FIND_IN_SET(0, agm_categories.usergroup_ids) OR FIND_IN_SET(1, agm_categories.usergroup_ids)) AND agm_categories.status IN ('A') AND agm_categories.id_path LIKE '1086/1087/1088/14396/%' AND agm_categories.category_id != 264 AND agm_categories.parent_id != 264 AND agm_categories.storefront_id IN (0, 4)   ORDER BY agm_categories.is_trash asc, agm_categories.position asc, agm_category_descriptions.category asc 
1 0.00097 0.00097 0.00097
SELECT object_id, thread_id, type, object_type FROM agm_discussion  WHERE 1  AND object_id = 14396 AND object_type = 'C'   
1 0.00031 0.00031 0.00031
SELECT thread_id, type, object_type, object_id FROM agm_discussion WHERE thread_id = 17929 
1 0.00048 0.00048 0.00048
SELECT AVG (dr.rating_value) FROM agm_discussion_rating AS dr LEFT JOIN agm_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN agm_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 14396 AND d.object_type = 'C' AND type IN ( 'B', 'R' )  AND dp.status = 'A' AND dr.rating_value > 0
1 0.00050 0.00050 0.00050
SELECT data FROM agm_storage_data WHERE data_key = 'restrictions'
1 0.00062 0.00062 0.00062