Queries list
Queries count !
Queries parse


SELECT data FROM jmj_storage_data WHERE data_key = 'store_mode'
SELECT storefronts.* FROM jmj_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev.jmjxplore.com' OR storefronts.url = 'www.dev.jmjxplore.com' OR storefronts.url LIKE 'www_.dev.jmjxplore.com' OR storefronts.url LIKE 'dev.jmjxplore.com/%' OR storefronts.url LIKE 'www.dev.jmjxplore.com/%' OR storefronts.url LIKE 'www_.dev.jmjxplore.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev.jmjxplore.com' DESC, storefronts.url = 'www.dev.jmjxplore.com' DESC, storefronts.url LIKE 'www_.dev.jmjxplore.com' DESC, storefronts.url LIKE 'dev.jmjxplore.com/%' DESC, storefronts.url LIKE 'www.dev.jmjxplore.com/%' DESC, storefronts.url LIKE 'www_.dev.jmjxplore.com/%' desc 
SET time_zone = '+05:30'
SELECT storefronts.* FROM jmj_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT jmj_bm_layouts.* FROM jmj_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1
SELECT data FROM jmj_storage_data WHERE data_key = 'cart_products_next_check'
SELECT data FROM jmj_storage_data WHERE data_key = 'dev_mode'
SELECT * FROM jmj_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 46
SELECT * FROM jmj_bm_locations as l LEFT JOIN jmj_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 46  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(87, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
SELECT data FROM jmj_storage_data WHERE data_key = 'cache_id'
SELECT category_id FROM jmj_categories WHERE category_id = 87  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H')
SELECT default_view, selected_views FROM jmj_categories WHERE category_id = 87
SELECT default_view_desktop FROM jmj_categories WHERE category_id=87 AND selected_views !="" 
SELECT id_path FROM jmj_categories WHERE category_id = 87
SELECT jmj_ab__category_banners.*, jmj_ab__category_banner_images_and_descr.category_banner, jmj_ab__category_banner_images_and_descr.url, jmj_ab__category_banner_images_and_descr.category_banner_image_id FROM jmj_ab__category_banners
INNER JOIN jmj_ab__category_banner_images_and_descr ON jmj_ab__category_banner_images_and_descr.category_banner_id = jmj_ab__category_banners.category_banner_id AND jmj_ab__category_banner_images_and_descr.lang_code = 'en'
 LEFT JOIN jmj_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = jmj_ab__category_banners.category_banner_id  LEFT JOIN jmj_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = jmj_ab__category_banners.category_banner_id INNER JOIN jmj_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = jmj_ab__category_banner_images_and_descr.category_banner_image_id AND il.pair_id IS NOT NULL AND il.type = 'M'
WHERE 1  AND jmj_ab__category_banners.status = 'A'  AND jmj_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL  AND (IF(jmj_ab__category_banners.from_date, jmj_ab__category_banners.from_date <= 1765697951, 1) AND IF(jmj_ab__category_banners.to_date, jmj_ab__category_banners.to_date >= 1765697951, 1)) AND (ab__category_banner_categories.category_id = 87 OR (ab__category_banner_categories1.category_id IN (2, 87) AND jmj_ab__category_banners.include_subcategories = 'Y'))  ORDER BY jmj_ab__category_banner_images_and_descr.category_banner asc 
SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category_banner' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id IS NULL ORDER BY jmj_images_links.position, jmj_images_links.pair_id
SELECT usergroup_ids FROM jmj_categories WHERE category_id = 87
SELECT category_id FROM jmj_categories WHERE category_id = 87  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1)
SELECT category_id FROM jmj_categories WHERE category_type = 'D'
SELECT id_path FROM jmj_categories WHERE category_id = 87
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control,jmj_categories.ab__fn_category_status,jmj_categories.ab__fn_label_color,jmj_categories.ab__fn_label_background,jmj_categories.ab__fn_use_origin_image,jmj_category_descriptions.ab__fn_label_text,jmj_category_descriptions.ab__fn_label_show FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE 1=1  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.parent_id IN (87) AND jmj_categories.id_path LIKE '2/87/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1)   ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc 
SELECT * FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_category_descriptions.category_id = jmj_categories.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE jmj_categories.category_id = 87 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids))
SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id
SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_allowed_not_allowed' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_allowed_not_allowed' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id
SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_guideline_image' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_guideline_image' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id
SELECT search_phrases FROM jmj_ab__search_motivation WHERE category_id = 87 AND lang_code = 'en'
SELECT a.category_id
                 FROM jmj_categories as a
                 LEFT JOIN jmj_categories as b
                 ON b.category_id IN (87)
                 WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
SELECT company_id FROM jmj_storefronts_companies WHERE storefront_id = 1
SELECT location FROM jmj_users WHERE user_id = 0
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, products.net_price as net_price, products.integer_in_full_description, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM jmj_products as products  LEFT JOIN jmj_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN jmj_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN jmj_companies AS companies ON companies.company_id = products.company_id  INNER JOIN jmj_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN jmj_categories ON jmj_categories.category_id = products_categories.category_id  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1)  LEFT JOIN jmj_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  WHERE 1  AND jmj_categories.category_id IN (87) AND (companies.status IN ('A') OR products.company_id = 0) 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 12
SELECT FOUND_ROWS()
SELECT COUNT(DISTINCT storefronts.storefront_id) FROM jmj_storefronts AS storefronts  WHERE 1 = 1
SELECT category_id, category FROM jmj_category_descriptions WHERE category_id IN (2) AND lang_code = 'en'
SELECT privilege FROM jmj_usergroup_privileges WHERE usergroup_id IN (0, 1)
SELECT c.* FROM jmj_bm_containers as c  WHERE 1  AND c.location_id = 1259 AND c.company_id = 0
SELECT layout_id FROM jmj_bm_locations WHERE location_id = 1259
SELECT c.*, IF (c.location_id != 1259, 0, 1) as `default` FROM jmj_bm_containers as c  INNER JOIN jmj_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 46 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
SELECT * FROM jmj_bm_containers as c LEFT JOIN jmj_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (5021, 5022, 5035, 5024) ORDER BY g.order, g.parent_id, g.grid_id ASC
SELECT jmj_bm_snapping.grid_id as grid_id,jmj_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,jmj_bm_block_statuses.object_ids as object_ids,jmj_bm_snapping.*,jmj_bm_blocks.*,jmj_bm_blocks_descriptions.* FROM jmj_bm_snapping LEFT JOIN jmj_bm_blocks ON jmj_bm_blocks.block_id = jmj_bm_snapping.block_id LEFT JOIN jmj_bm_block_statuses ON jmj_bm_snapping.snapping_id = jmj_bm_block_statuses.snapping_id AND jmj_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN jmj_bm_blocks_descriptions ON jmj_bm_blocks.block_id = jmj_bm_blocks_descriptions.block_id  LEFT JOIN jmj_bm_blocks_content AS default_content ON jmj_bm_blocks.block_id = default_content.block_id AND jmj_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 jmj_bm_blocks_content AS dynamic_object_content ON jmj_bm_blocks.block_id = dynamic_object_content.block_id AND jmj_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 87 AND dynamic_object_content.object_type like 'categories' WHERE jmj_bm_snapping.grid_id IN (6192, 6193, 6194, 6195, 6197, 6196, 6198, 6201, 6202, 6207, 6847, 6206, 6204, 6208, 6203, 6205, 6846, 6236, 6237, 6238, 6239, 6240, 6241, 6242)  AND jmj_bm_blocks_descriptions.lang_code='en'  ORDER BY jmj_bm_snapping.order, jmj_bm_snapping.block_id 
SELECT status FROM jmj_menus WHERE menu_id = 1
SELECT sd.param_id, sd.param, jmj_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, jmj_static_data_descriptions.ab__fn_label_show, jmj_static_data_descriptions.ab__fn_label_text, sd.ab__fn_label_color, sd.ab__fn_menu_status, sd.ab__fn_label_background, sd.ab__fn_use_origin_image, sd.abt__ut2_mwi__status, jmj_static_data_descriptions.abt__ut2_mwi__label, sd.abt__ut2_mwi__label_color, sd.abt__ut2_mwi__label_background, jmj_static_data_descriptions.abt__ut2_mwi__desc, jmj_static_data_descriptions.abt__ut2_mwi__text, sd.abt__ut2_mwi__text_position, sd.abt__ut2_mwi__dropdown FROM jmj_static_data AS sd LEFT JOIN jmj_static_data_descriptions ON sd.param_id = jmj_static_data_descriptions.param_id AND jmj_static_data_descriptions.lang_code = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '1' ORDER BY sd.position
SELECT status FROM jmj_menus WHERE menu_id = 2
SELECT sd.param_id, sd.param, jmj_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, jmj_static_data_descriptions.ab__fn_label_show, jmj_static_data_descriptions.ab__fn_label_text, sd.ab__fn_label_color, sd.ab__fn_menu_status, sd.ab__fn_label_background, sd.ab__fn_use_origin_image, sd.abt__ut2_mwi__status, jmj_static_data_descriptions.abt__ut2_mwi__label, sd.abt__ut2_mwi__label_color, sd.abt__ut2_mwi__label_background, jmj_static_data_descriptions.abt__ut2_mwi__desc, jmj_static_data_descriptions.abt__ut2_mwi__text, sd.abt__ut2_mwi__text_position, sd.abt__ut2_mwi__dropdown FROM jmj_static_data AS sd LEFT JOIN jmj_static_data_descriptions ON sd.param_id = jmj_static_data_descriptions.param_id AND jmj_static_data_descriptions.lang_code = 'en' WHERE sd.section = 'A'  AND sd.status = 'A' AND sd.param_5 = '2' ORDER BY sd.position
SELECT COUNT(*) FROM jmj_categories WHERE category_id = 2  AND storefront_id IN (0, 1)
SELECT id_path FROM jmj_categories WHERE category_id = 2
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE 1=1  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '2/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1)   ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc 
SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(36, 60, 31, 47, 32, 48, 45, 61, 46, 62, 33, 49, 87, 34, 63, 51, 35, 50, 64, 65, 37, 52, 53, 38, 66, 54, 39, 41, 57, 59, 40, 43, 55, 42, 56, 58, 44)  AND category_id != 1
SELECT category FROM jmj_category_descriptions WHERE category_id = 2 AND lang_code = 'en'
SELECT COUNT(*) FROM jmj_categories WHERE category_id = 3  AND storefront_id IN (0, 1)
SELECT id_path FROM jmj_categories WHERE category_id = 3
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE 1=1  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '3/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1)   ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc 
SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(20, 26, 9, 8, 19, 10, 21, 30, 25, 11, 22, 27, 28, 23, 12, 29, 13, 24, 14, 15, 16, 18, 17)  AND category_id != 1
SELECT category FROM jmj_category_descriptions WHERE category_id = 3 AND lang_code = 'en'
SELECT COUNT(*) FROM jmj_categories WHERE category_id = 4  AND storefront_id IN (0, 1)
SELECT id_path FROM jmj_categories WHERE category_id = 4
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE 1=1  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '4/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1)   ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc 
SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(83, 104, 106, 69, 67, 68, 105, 70, 84, 82, 107, 85, 71, 108, 72, 86, 73, 74, 75, 76, 77)  AND category_id != 1
SELECT category FROM jmj_category_descriptions WHERE category_id = 4 AND lang_code = 'en'
SELECT COUNT(*) FROM jmj_categories WHERE category_id = 78  AND storefront_id IN (0, 1)
SELECT id_path FROM jmj_categories WHERE category_id = 78
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE 1=1  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '78/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1)   ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc 
SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(109, 116, 88, 79, 80, 117, 110, 111, 81, 118, 119, 112, 120, 113, 114, 121, 115, 122)  AND category_id != 1
SELECT category FROM jmj_category_descriptions WHERE category_id = 78 AND lang_code = 'en'
SELECT COUNT(*) FROM jmj_categories WHERE category_id = 5  AND storefront_id IN (0, 1)
SELECT id_path FROM jmj_categories WHERE category_id = 5
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en'  WHERE 1=1  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '5/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1)   ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc 
SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(100, 89, 92, 97, 93, 98, 90, 101, 91, 94, 99, 102, 103, 95, 96)  AND category_id != 1
SELECT category FROM jmj_category_descriptions WHERE category_id = 5 AND lang_code = 'en'
SELECT * FROM jmj_product_feature_variants WHERE variant_id IN ('')
SELECT location FROM jmj_users WHERE user_id = 0
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, products.net_price as net_price, products.integer_in_full_description, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM jmj_products as products  LEFT JOIN jmj_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN jmj_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN jmj_companies AS companies ON companies.company_id = products.company_id  INNER JOIN jmj_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN jmj_categories ON jmj_categories.category_id = products_categories.category_id  AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1)  LEFT JOIN jmj_master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1  WHERE 1  AND jmj_categories.category_id IN (87) AND (companies.status IN ('A') OR products.company_id = 0) 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id   ORDER BY products.timestamp desc, products.product_id ASC  LIMIT 0, 10
SELECT company_id FROM jmj_companies WHERE 1  AND company = 'JMJ Xplore'
SELECT * FROM jmj_logos WHERE layout_id IN (46, 0) AND style_id IN ('jmj_xplore', '') AND storefront_id IN (1, 0)  AND company_id = 0
SELECT jmj_images.*, jmj_images_links.*, jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'logos' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id IN (10, 341, 342, 343, 344) ORDER BY jmj_images_links.position, jmj_images_links.pair_id
SELECT country FROM jmj_country_descriptions WHERE code = 'IN' AND lang_code = 'en'
SELECT jmj_state_descriptions.state FROM jmj_states LEFT JOIN jmj_state_descriptions ON jmj_state_descriptions.state_id = jmj_states.state_id AND jmj_state_descriptions.lang_code = 'en' WHERE jmj_states.country_code = 'IN' AND jmj_states.code = 'DL'
SELECT jmj_abt__ut2_microdata.id, jmj_abt__ut2_microdata.field, jmj_abt__ut2_microdata_description.value
FROM jmj_abt__ut2_microdata
INNER JOIN jmj_abt__ut2_microdata_description ON jmj_abt__ut2_microdata_description.id = jmj_abt__ut2_microdata.id AND jmj_abt__ut2_microdata_description.lang_code = 'en'
WHERE jmj_abt__ut2_microdata.company_id = 0
ORDER BY jmj_abt__ut2_microdata.id ASC
SELECT data FROM jmj_storage_data WHERE data_key = 'restrictions'

Queries total time: 0.07514 s.
№	Query	Time	Actions
1	`SELECT data FROM jmj_storage_data WHERE data_key = 'store_mode'` Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_redirect_to_regional_storefront()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `Tygh\Storefront\Repository::findByUrl()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1458 `Tygh\Storefront\Repository::find()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:126 `fn_set_hook()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:313 `fn_mve_storefront_repository_find_pre()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:104 `fn_allowed_for()` /home/dstestmohitrai/public_html/app/functions/fn.multivendor.php:2078 `fn_get_storage_data()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:991 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:1073 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00058	Re-run Backtrace
2	SELECT storefronts.* FROM jmj_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev.jmjxplore.com' OR storefronts.url = 'www.dev.jmjxplore.com' OR storefronts.url LIKE 'www_.dev.jmjxplore.com' OR storefronts.url LIKE 'dev.jmjxplore.com/%' OR storefronts.url LIKE 'www.dev.jmjxplore.com/%' OR storefronts.url LIKE 'www_.dev.jmjxplore.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev.jmjxplore.com' DESC, storefronts.url = 'www.dev.jmjxplore.com' DESC, storefronts.url LIKE 'www_.dev.jmjxplore.com' DESC, storefronts.url LIKE 'dev.jmjxplore.com/%' DESC, storefronts.url LIKE 'www.dev.jmjxplore.com/%' DESC, storefronts.url LIKE 'www_.dev.jmjxplore.com/%' desc Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_redirect_to_regional_storefront()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `Tygh\Storefront\Repository::findByUrl()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1458 `Tygh\Storefront\Repository::find()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:370 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00055	Re-run Backtrace
3	`SET time_zone = '+05:30'` Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_settings()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `fn_init_time_zone()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1064 `db_query()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1085 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:138	0.00050	Re-run Backtrace
4	`SELECT storefronts.* FROM jmj_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_layout()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `Tygh\Application::offsetGet()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:652 `Pimple\Container::offsetGet()` /home/dstestmohitrai/public_html/app/Tygh/Application.php:135 `Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}()` /home/dstestmohitrai/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Storefront\Repository::findById()` /home/dstestmohitrai/public_html/app/Tygh/Providers/StorefrontProvider.php:186 `Tygh\Storefront\Repository::find()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:164 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:373 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00072	Re-run Backtrace
5	`SELECT jmj_bm_layouts.* FROM jmj_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1` Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_layout()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `Tygh\BlockManager\Layout::getDefault()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:680 `db_get_row()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Layout.php:95 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00060	Re-run Backtrace
6	`SELECT data FROM jmj_storage_data WHERE data_key = 'cart_products_next_check'` Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_user()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `fn_login_user()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:751 `fn_init_user()` /home/dstestmohitrai/public_html/app/functions/fn.users.php:3528 `fn_is_expired_storage_data()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:783 `fn_get_storage_data()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:1091 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:1073 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00061	Re-run Backtrace
7	`SELECT data FROM jmj_storage_data WHERE data_key = 'dev_mode'` Backtrace `require()` /home/dstestmohitrai/public_html/index.php:20 `fn_init()` /home/dstestmohitrai/public_html/init.php:196 `fn_init_templater()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:1234 `Tygh\Development::isEnabled()` /home/dstestmohitrai/public_html/app/functions/fn.init.php:124 `Tygh\Development::read()` /home/dstestmohitrai/public_html/app/Tygh/Development.php:28 `fn_get_storage_data()` /home/dstestmohitrai/public_html/app/Tygh/Development.php:81 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:1073 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00075	Re-run Backtrace
8	`SELECT * FROM jmj_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 46` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `Tygh\BlockManager\Location::instance()` /home/dstestmohitrai/public_html/app/controllers/frontend/init.php:142 `Tygh\BlockManager\Layout::get()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Location.php:483 `db_get_row()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Layout.php:61 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00290	Re-run Backtrace
9	`SELECT * FROM jmj_bm_locations as l LEFT JOIN jmj_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 46 AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(87, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `Tygh\BlockManager\Location::get()` /home/dstestmohitrai/public_html/app/controllers/frontend/init.php:142 `Tygh\BlockManager\Location::getList()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Location.php:166 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Location.php:105 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00092	Re-run Backtrace
10	`SELECT data FROM jmj_storage_data WHERE data_key = 'cache_id'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_storage_data()` /home/dstestmohitrai/public_html/app/controllers/frontend/init.php:146 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:1073 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00306	Re-run Backtrace
11	`SELECT category_id FROM jmj_categories WHERE category_id = 87 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H')` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `db_get_field()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:32 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00171	Re-run Backtrace
12	`SELECT default_view, selected_views FROM jmj_categories WHERE category_id = 87` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products_layout()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:34 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2858 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00254	Re-run Backtrace
13	`SELECT default_view_desktop FROM jmj_categories WHERE category_id=87 AND selected_views !=""` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products_layout()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:34 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2889 `fn_abt__unitheme2_get_products_layout_post()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `db_get_field()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/func.php:710 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00384	Re-run Backtrace
14	`SELECT id_path FROM jmj_categories WHERE category_id = 87` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_ab__cb_pick_banner_by_cid()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35 `fn_ab__get_category_banners()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/func.php:218 `db_get_field()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/func.php:128 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00064	Re-run Backtrace
15	SELECT jmj_ab__category_banners.*, jmj_ab__category_banner_images_and_descr.category_banner, jmj_ab__category_banner_images_and_descr.url, jmj_ab__category_banner_images_and_descr.category_banner_image_id FROM jmj_ab__category_banners INNER JOIN jmj_ab__category_banner_images_and_descr ON jmj_ab__category_banner_images_and_descr.category_banner_id = jmj_ab__category_banners.category_banner_id AND jmj_ab__category_banner_images_and_descr.lang_code = 'en' LEFT JOIN jmj_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = jmj_ab__category_banners.category_banner_id LEFT JOIN jmj_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = jmj_ab__category_banners.category_banner_id INNER JOIN jmj_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = jmj_ab__category_banner_images_and_descr.category_banner_image_id AND il.pair_id IS NOT NULL AND il.type = 'M' WHERE 1 AND jmj_ab__category_banners.status = 'A' AND jmj_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL AND (IF(jmj_ab__category_banners.from_date, jmj_ab__category_banners.from_date <= 1765697951, 1) AND IF(jmj_ab__category_banners.to_date, jmj_ab__category_banners.to_date >= 1765697951, 1)) AND (ab__category_banner_categories.category_id = 87 OR (ab__category_banner_categories1.category_id IN (2, 87) AND jmj_ab__category_banners.include_subcategories = 'Y')) ORDER BY jmj_ab__category_banner_images_and_descr.category_banner asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_ab__cb_pick_banner_by_cid()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35 `fn_ab__get_category_banners()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/func.php:218 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/func.php:165 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00098	Re-run Backtrace
16	SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category_banner' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id IS NULL ORDER BY jmj_images_links.position, jmj_images_links.pair_id Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_ab__cb_pick_banner_by_cid()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35 `fn_ab__get_category_banners()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/func.php:218 `fn_get_image_pairs()` /home/dstestmohitrai/public_html/app/addons/ab__category_banners/func.php:177 `db_multi_query()` /home/dstestmohitrai/public_html/app/functions/fn.images.php:349 `Tygh\Database\Connection::multiQuery()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:168	0.00121	Re-run Backtrace
17	`SELECT usergroup_ids FROM jmj_categories WHERE category_id = 87` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `db_get_field()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:38 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00105	Re-run Backtrace
18	`SELECT category_id FROM jmj_categories WHERE category_id = 87 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `db_get_field()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:60 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00058	Re-run Backtrace
19	`SELECT category_id FROM jmj_categories WHERE category_type = 'D'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_subcategories()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:60 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:242 `fn_vendor_debt_payout_get_categories_pre()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `fn_vendor_debt_payout_get_payout_category()` /home/dstestmohitrai/public_html/app/addons/vendor_debt_payout/func.php:367 `db_get_field()` /home/dstestmohitrai/public_html/app/addons/vendor_debt_payout/func.php:226 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00054	Re-run Backtrace
20	`SELECT id_path FROM jmj_categories WHERE category_id = 87` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_subcategories()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:60 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:350 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00049	Re-run Backtrace
21	SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control,jmj_categories.ab__fn_category_status,jmj_categories.ab__fn_label_color,jmj_categories.ab__fn_label_background,jmj_categories.ab__fn_use_origin_image,jmj_category_descriptions.ab__fn_label_text,jmj_category_descriptions.ab__fn_label_show FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.parent_id IN (87) AND jmj_categories.id_path LIKE '2/87/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_subcategories()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:60 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:451 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00110	Re-run Backtrace
22	`SELECT * FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_category_descriptions.category_id = jmj_categories.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE jmj_categories.category_id = 87 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids))` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_category_data()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:77 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:812 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00080	Re-run Backtrace
23	SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_category_data()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:77 `fn_get_image_pairs()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:824 `db_multi_query()` /home/dstestmohitrai/public_html/app/functions/fn.images.php:349 `Tygh\Database\Connection::multiQuery()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:168	0.00119	Re-run Backtrace
24	SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_allowed_not_allowed' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_allowed_not_allowed' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_category_data()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:77 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:873 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/Addons/Loader.php:144 `Tygh\Addons\JMJDigital\HookHandlers\CategoryHookHandler::getCategoryDataPost()` `fn_get_image_pairs()` /home/dstestmohitrai/public_html/app/addons/jmj_digital/src/HookHandlers/CategoryHookHandler.php:25 `db_multi_query()` /home/dstestmohitrai/public_html/app/functions/fn.images.php:349 `Tygh\Database\Connection::multiQuery()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:168	0.00061	Re-run Backtrace
25	SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_guideline_image' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_guideline_image' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_category_data()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:77 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:873 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/Addons/Loader.php:144 `Tygh\Addons\JMJDigital\HookHandlers\CategoryHookHandler::getCategoryDataPost()` `fn_get_image_pairs()` /home/dstestmohitrai/public_html/app/addons/jmj_digital/src/HookHandlers/CategoryHookHandler.php:28 `db_multi_query()` /home/dstestmohitrai/public_html/app/functions/fn.images.php:349 `Tygh\Database\Connection::multiQuery()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:168	0.00093	Re-run Backtrace
26	`SELECT search_phrases FROM jmj_ab__search_motivation WHERE category_id = 87 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_category_data()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:77 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:873 `fn_ab__search_motivation_get_category_data_post()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `db_get_field()` /home/dstestmohitrai/public_html/app/addons/ab__search_motivation/func.php:31 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00163	Re-run Backtrace
27	`SELECT a.category_id FROM jmj_categories as a LEFT JOIN jmj_categories as b ON b.category_id IN (87) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:115 `db_get_fields()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:1931 `Tygh\Database\Connection::getColumn()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:85 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:480	0.00157	Re-run Backtrace
28	`SELECT company_id FROM jmj_storefronts_companies WHERE storefront_id = 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:115 `Tygh\Storefront\Storefront::__call()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2003 `Tygh\Storefront\Storefront::getRelationValue()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Storefront.php:235 `Tygh\Storefront\RelationsManager::getRelationValue()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Storefront.php:273 `Tygh\Storefront\RelationsManager::getRelatedValues()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/RelationsManager.php:80 `Tygh\Database\Connection::getColumn()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/RelationsManager.php:116 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:480	0.00063	Re-run Backtrace
29	`SELECT location FROM jmj_users WHERE user_id = 0` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:115 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2293 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/Addons/Loader.php:144 `Tygh\Addons\JMJDigital\HookHandlers\ProductHookHandler::getProducts()` `db_get_field()` /home/dstestmohitrai/public_html/app/addons/jmj_digital/src/HookHandlers/ProductHookHandler.php:59 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00065	Re-run Backtrace
30	SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, products.net_price as net_price, products.integer_in_full_description, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM jmj_products as products LEFT JOIN jmj_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN jmj_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN jmj_companies AS companies ON companies.company_id = products.company_id INNER JOIN jmj_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN jmj_categories ON jmj_categories.category_id = products_categories.category_id AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1) LEFT JOIN jmj_master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 WHERE 1 AND jmj_categories.category_id IN (87) AND (companies.status IN ('A') OR products.company_id = 0) 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id ORDER BY product asc, products.product_id ASC LIMIT 0, 12 Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:115 `{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2441 `db_get_array()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2365 `Tygh\Database\Connection::getArray()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:333	0.00309	Re-run Backtrace
31	`SELECT FOUND_ROWS()` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:115 `{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2441 `db_get_found_rows()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2368 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:332 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00050	Re-run Backtrace
32	`SELECT COUNT(DISTINCT storefronts.storefront_id) FROM jmj_storefronts AS storefronts WHERE 1 = 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_products()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:115 `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2478 `fn_master_products_get_products_post()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `fn_master_products_filter_master_products_quantities_for_current_storefront()` /home/dstestmohitrai/public_html/app/addons/master_products/func.php:418 `Tygh\Storefront\Repository::getCount()` /home/dstestmohitrai/public_html/app/addons/master_products/func.php:2657 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/Tygh/Storefront/Repository.php:435 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00055	Re-run Backtrace
33	`SELECT category_id, category FROM jmj_category_descriptions WHERE category_id IN (2) AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_run_controller()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:459 `include()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:728 `fn_get_category_name()` /home/dstestmohitrai/public_html/app/controllers/frontend/categories.php:153 `db_get_hash_single_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:904 `Tygh\Database\Connection::getSingleHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:572	0.00059	Re-run Backtrace
34	`SELECT privilege FROM jmj_usergroup_privileges WHERE usergroup_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `fn_check_permissions()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:518 `fn_check_admin_permissions()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2548 `db_get_fields()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2730 `Tygh\Database\Connection::getColumn()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:85 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:480	0.00079	Re-run Backtrace
35	`SELECT c.* FROM jmj_bm_containers as c WHERE 1 AND c.location_id = 1259 AND c.company_id = 0` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::__construct()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:127 `Tygh\BlockManager\Container::getList()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Container.php:111 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Container.php:72 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00118	Re-run Backtrace
36	`SELECT layout_id FROM jmj_bm_locations WHERE location_id = 1259` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::__construct()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:127 `Tygh\BlockManager\Container::getList()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Container.php:112 `db_get_field()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Container.php:60 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00058	Re-run Backtrace
37	SELECT c.*, IF (c.location_id != 1259, 0, 1) as `default` FROM jmj_bm_containers as c INNER JOIN jmj_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 46 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0 Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::__construct()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:127 `Tygh\BlockManager\Container::getList()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Container.php:112 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Container.php:72 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00179	Re-run Backtrace
38	`SELECT * FROM jmj_bm_containers as c LEFT JOIN jmj_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (5021, 5022, 5035, 5024) ORDER BY g.order, g.parent_id, g.grid_id ASC` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::__construct()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Grid::getList()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:133 `db_get_hash_multi_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Grid.php:63 `Tygh\Database\Connection::getMultiHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:526	0.00094	Re-run Backtrace
39	SELECT jmj_bm_snapping.grid_id as grid_id,jmj_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,jmj_bm_block_statuses.object_ids as object_ids,jmj_bm_snapping.,jmj_bm_blocks.,jmj_bm_blocks_descriptions.* FROM jmj_bm_snapping LEFT JOIN jmj_bm_blocks ON jmj_bm_blocks.block_id = jmj_bm_snapping.block_id LEFT JOIN jmj_bm_block_statuses ON jmj_bm_snapping.snapping_id = jmj_bm_block_statuses.snapping_id AND jmj_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN jmj_bm_blocks_descriptions ON jmj_bm_blocks.block_id = jmj_bm_blocks_descriptions.block_id LEFT JOIN jmj_bm_blocks_content AS default_content ON jmj_bm_blocks.block_id = default_content.block_id AND jmj_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 jmj_bm_blocks_content AS dynamic_object_content ON jmj_bm_blocks.block_id = dynamic_object_content.block_id AND jmj_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 87 AND dynamic_object_content.object_type like 'categories' WHERE jmj_bm_snapping.grid_id IN (6192, 6193, 6194, 6195, 6197, 6196, 6198, 6201, 6202, 6207, 6847, 6206, 6204, 6208, 6203, 6205, 6846, 6236, 6237, 6238, 6239, 6240, 6241, 6242) AND jmj_bm_blocks_descriptions.lang_code='en' ORDER BY jmj_bm_snapping.order, jmj_bm_snapping.block_id Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::__construct()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Block::getList()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:137 `db_get_hash_multi_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Block.php:252 `Tygh\Database\Connection::getMultiHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:526	0.00228	Re-run Backtrace
40	`SELECT status FROM jmj_menus WHERE menu_id = 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `Tygh\Menu::getStatus()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1185 `db_get_field()` /home/dstestmohitrai/public_html/app/Tygh/Menu.php:208 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00048	Re-run Backtrace
41	SELECT sd.param_id, sd.param, jmj_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, jmj_static_data_descriptions.ab__fn_label_show, jmj_static_data_descriptions.ab__fn_label_text, sd.ab__fn_label_color, sd.ab__fn_menu_status, sd.ab__fn_label_background, sd.ab__fn_use_origin_image, sd.abt__ut2_mwi__status, jmj_static_data_descriptions.abt__ut2_mwi__label, sd.abt__ut2_mwi__label_color, sd.abt__ut2_mwi__label_background, jmj_static_data_descriptions.abt__ut2_mwi__desc, jmj_static_data_descriptions.abt__ut2_mwi__text, sd.abt__ut2_mwi__text_position, sd.abt__ut2_mwi__dropdown FROM jmj_static_data AS sd LEFT JOIN jmj_static_data_descriptions ON sd.param_id = jmj_static_data_descriptions.param_id AND jmj_static_data_descriptions.lang_code = 'en' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '1' ORDER BY sd.position Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_get_static_data()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:1340 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00079	Re-run Backtrace
42	`SELECT status FROM jmj_menus WHERE menu_id = 2` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `Tygh\Menu::getStatus()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1185 `db_get_field()` /home/dstestmohitrai/public_html/app/Tygh/Menu.php:208 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00061	Re-run Backtrace
43	SELECT sd.param_id, sd.param, jmj_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, jmj_static_data_descriptions.ab__fn_label_show, jmj_static_data_descriptions.ab__fn_label_text, sd.ab__fn_label_color, sd.ab__fn_menu_status, sd.ab__fn_label_background, sd.ab__fn_use_origin_image, sd.abt__ut2_mwi__status, jmj_static_data_descriptions.abt__ut2_mwi__label, sd.abt__ut2_mwi__label_color, sd.abt__ut2_mwi__label_background, jmj_static_data_descriptions.abt__ut2_mwi__desc, jmj_static_data_descriptions.abt__ut2_mwi__text, sd.abt__ut2_mwi__text_position, sd.abt__ut2_mwi__dropdown FROM jmj_static_data AS sd LEFT JOIN jmj_static_data_descriptions ON sd.param_id = jmj_static_data_descriptions.param_id AND jmj_static_data_descriptions.lang_code = 'en' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '2' ORDER BY sd.position Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_get_static_data()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:1340 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00126	Re-run Backtrace
44	`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 2 AND storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_category_exists()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1246 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:1129 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00065	Re-run Backtrace
45	`SELECT id_path FROM jmj_categories WHERE category_id = 2` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:350 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00050	Re-run Backtrace
46	SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '2/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:451 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00104	Re-run Backtrace
47	`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(36, 60, 31, 47, 32, 48, 45, 61, 46, 62, 33, 49, 87, 34, 63, 51, 35, 50, 64, 65, 37, 52, 53, 38, 66, 54, 39, 41, 57, 59, 40, 43, 55, 42, 56, 58, 44) AND category_id != 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:483 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00067	Re-run Backtrace
48	`SELECT category FROM jmj_category_descriptions WHERE category_id = 2 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_category_name()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1255 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:906 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00053	Re-run Backtrace
49	`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 3 AND storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_category_exists()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1246 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:1129 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00056	Re-run Backtrace
50	`SELECT id_path FROM jmj_categories WHERE category_id = 3` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:350 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00053	Re-run Backtrace
51	SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '3/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:451 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00100	Re-run Backtrace
52	`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(20, 26, 9, 8, 19, 10, 21, 30, 25, 11, 22, 27, 28, 23, 12, 29, 13, 24, 14, 15, 16, 18, 17) AND category_id != 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:483 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00058	Re-run Backtrace
53	`SELECT category FROM jmj_category_descriptions WHERE category_id = 3 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_category_name()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1255 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:906 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00065	Re-run Backtrace
54	`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 4 AND storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_category_exists()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1246 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:1129 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00051	Re-run Backtrace
55	`SELECT id_path FROM jmj_categories WHERE category_id = 4` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:350 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00060	Re-run Backtrace
56	SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '4/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:451 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00093	Re-run Backtrace
57	`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(83, 104, 106, 69, 67, 68, 105, 70, 84, 82, 107, 85, 71, 108, 72, 86, 73, 74, 75, 76, 77) AND category_id != 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:483 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00074	Re-run Backtrace
58	`SELECT category FROM jmj_category_descriptions WHERE category_id = 4 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_category_name()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1255 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:906 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00046	Re-run Backtrace
59	`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 78 AND storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_category_exists()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1246 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:1129 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00067	Re-run Backtrace
60	`SELECT id_path FROM jmj_categories WHERE category_id = 78` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:350 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00046	Re-run Backtrace
61	SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '78/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:451 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00101	Re-run Backtrace
62	`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(109, 116, 88, 79, 80, 117, 110, 111, 81, 118, 119, 112, 120, 113, 114, 121, 115, 122) AND category_id != 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:483 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00059	Re-run Backtrace
63	`SELECT category FROM jmj_category_descriptions WHERE category_id = 78 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_category_name()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1255 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:906 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00058	Re-run Backtrace
64	`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 5 AND storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_category_exists()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1246 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:1129 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00047	Re-run Backtrace
65	`SELECT id_path FROM jmj_categories WHERE category_id = 5` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:350 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00045	Re-run Backtrace
66	SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '5/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:451 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00099	Re-run Backtrace
67	`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(100, 89, 92, 97, 93, 98, 90, 101, 91, 94, 99, 102, 103, 95, 96) AND category_id != 1` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_categories_tree()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1251 `fn_get_categories()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:99 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:483 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00075	Re-run Backtrace
68	`SELECT category FROM jmj_category_descriptions WHERE category_id = 5 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:820 `fn_get_menu_items()` `fn_top_menu_form()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1201 `fn_get_category_name()` /home/dstestmohitrai/public_html/app/functions/fn.cms.php:1255 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.categories.php:906 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00047	Re-run Backtrace
69	`SELECT * FROM jmj_product_feature_variants WHERE variant_id IN ('')` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `Tygh\BlockManager\Block::getItems()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:810 `call_user_func()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Block.php:974 `fn_product_filters_get_filters_products_count()` `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.filters.php:1450 `fn_abt__unitheme2_get_filters_products_count_post()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_products_features.php:246 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00066	Re-run Backtrace
70	`SELECT location FROM jmj_users WHERE user_id = 0` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `Tygh\BlockManager\Block::getItems()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:810 `call_user_func()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Block.php:974 `fn_get_products()` `fn_set_hook()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2293 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:123 `call_user_func_array()` /home/dstestmohitrai/public_html/app/Tygh/Addons/Loader.php:144 `Tygh\Addons\JMJDigital\HookHandlers\ProductHookHandler::getProducts()` `db_get_field()` /home/dstestmohitrai/public_html/app/addons/jmj_digital/src/HookHandlers/ProductHookHandler.php:59 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00064	Re-run Backtrace
71	SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, products.net_price as net_price, products.integer_in_full_description, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM jmj_products as products LEFT JOIN jmj_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN jmj_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN jmj_companies AS companies ON companies.company_id = products.company_id INNER JOIN jmj_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN jmj_categories ON jmj_categories.category_id = products_categories.category_id AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1) LEFT JOIN jmj_master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 WHERE 1 AND jmj_categories.category_id IN (87) AND (companies.status IN ('A') OR products.company_id = 0) 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id ORDER BY products.timestamp desc, products.product_id ASC LIMIT 0, 10 Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_function_render_location()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:454 `Tygh\BlockManager\RenderManager::render()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:666 `Tygh\BlockManager\Block::getItems()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/RenderManager.php:810 `call_user_func()` /home/dstestmohitrai/public_html/app/Tygh/BlockManager/Block.php:974 `fn_get_products()` `{closure}()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2448 `db_get_array()` /home/dstestmohitrai/public_html/app/functions/fn.products.php:2365 `Tygh\Database\Connection::getArray()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:333	0.00148	Re-run Backtrace
72	`SELECT company_id FROM jmj_companies WHERE 1 AND company = 'JMJ Xplore'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_hook()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:468 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/block.hook.php:136 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7a6f596a64_35392343()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `fn_abt__ut2_get_microdata()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/b1c6fb08f879c2b3148daf135efdf3d95a1f40f8_2.tygh.footer.post.tpl.php:45 `fn_get_schema()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29 `include()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2475 `fn_get_company_id_by_name()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:23 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.companies.php:719 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00080	Re-run Backtrace
73	`SELECT * FROM jmj_logos WHERE layout_id IN (46, 0) AND style_id IN ('jmj_xplore', '') AND storefront_id IN (1, 0) AND company_id = 0` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_hook()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:468 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/block.hook.php:136 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7a6f596a64_35392343()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `fn_abt__ut2_get_microdata()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/b1c6fb08f879c2b3148daf135efdf3d95a1f40f8_2.tygh.footer.post.tpl.php:45 `fn_get_schema()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29 `include()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2475 `fn_get_logos()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:25 `db_get_hash_array()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:5686 `Tygh\Database\Connection::getHash()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:371	0.00067	Re-run Backtrace
74	SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'logos' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id IN (10, 341, 342, 343, 344) ORDER BY jmj_images_links.position, jmj_images_links.pair_id Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_hook()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:468 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/block.hook.php:136 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7a6f596a64_35392343()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `fn_abt__ut2_get_microdata()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/b1c6fb08f879c2b3148daf135efdf3d95a1f40f8_2.tygh.footer.post.tpl.php:45 `fn_get_schema()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29 `include()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2475 `fn_get_logos()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:25 `fn_get_image_pairs()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:5694 `db_multi_query()` /home/dstestmohitrai/public_html/app/functions/fn.images.php:349 `Tygh\Database\Connection::multiQuery()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:168	0.00136	Re-run Backtrace
75	`SELECT country FROM jmj_country_descriptions WHERE code = 'IN' AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_hook()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:468 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/block.hook.php:136 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7a6f596a64_35392343()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `fn_abt__ut2_get_microdata()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/b1c6fb08f879c2b3148daf135efdf3d95a1f40f8_2.tygh.footer.post.tpl.php:45 `fn_get_schema()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29 `include()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2475 `fn_get_country_name()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:60 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.locations.php:324 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00112	Re-run Backtrace
76	`SELECT jmj_state_descriptions.state FROM jmj_states LEFT JOIN jmj_state_descriptions ON jmj_state_descriptions.state_id = jmj_states.state_id AND jmj_state_descriptions.lang_code = 'en' WHERE jmj_states.country_code = 'IN' AND jmj_states.code = 'DL'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_hook()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:468 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/block.hook.php:136 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7a6f596a64_35392343()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `fn_abt__ut2_get_microdata()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/b1c6fb08f879c2b3148daf135efdf3d95a1f40f8_2.tygh.footer.post.tpl.php:45 `fn_get_schema()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:29 `include()` /home/dstestmohitrai/public_html/app/functions/fn.common.php:2475 `fn_get_state_name()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/schemas/abt__ut2_microdata/items.php:60 `db_get_field()` /home/dstestmohitrai/public_html/app/functions/fn.locations.php:313 `Tygh\Database\Connection::getField()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:448	0.00049	Re-run Backtrace
77	`SELECT jmj_abt__ut2_microdata.id, jmj_abt__ut2_microdata.field, jmj_abt__ut2_microdata_description.value FROM jmj_abt__ut2_microdata INNER JOIN jmj_abt__ut2_microdata_description ON jmj_abt__ut2_microdata_description.id = jmj_abt__ut2_microdata.id AND jmj_abt__ut2_microdata_description.lang_code = 'en' WHERE jmj_abt__ut2_microdata.company_id = 0 ORDER BY jmj_abt__ut2_microdata.id ASC` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\SmartyEngine\Core::fetch()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:638 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/Tygh/SmartyEngine/Core.php:81 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7652c2d887_26753511()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `smarty_block_hook()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/f96277c2e51f396e8e5cf1d4234102734d818ccd_2.tygh.index.tpl.php:468 `Smarty_Internal_TemplateBase::fetch()` /home/dstestmohitrai/public_html/app/functions/smarty_plugins/block.hook.php:136 `Smarty_Internal_TemplateBase::_execute()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 `Smarty_Internal_Template::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 `Smarty_Template_Compiled::render()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 `Smarty_Template_Resource_Base::getRenderedTemplateCode()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 `content_693a7a6f596a64_35392343()` /home/dstestmohitrai/public_html/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 `fn_abt__ut2_get_microdata()` /home/dstestmohitrai/public_html/var/cache/templates/abt__unitheme2/b1c6fb08f879c2b3148daf135efdf3d95a1f40f8_2.tygh.footer.post.tpl.php:45 `Tygh\ABTUT2::fn_get_microdata()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/functions/fn.abt__ut2_microdata.php:31 `db_get_array()` /home/dstestmohitrai/public_html/app/addons/abt__unitheme2/Tygh/ABTUT2.php:64 `Tygh\Database\Connection::getArray()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:333	0.00057	Re-run Backtrace
78	`SELECT data FROM jmj_storage_data WHERE data_key = 'restrictions'` Backtrace `fn_dispatch()` /home/dstestmohitrai/public_html/index.php:21 `Tygh\Application::offsetGet()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:654 `Pimple\Container::offsetGet()` /home/dstestmohitrai/public_html/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/dstestmohitrai/public_html/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `fn_get_storage_data()` /home/dstestmohitrai/public_html/app/Tygh/Providers/CommonProvider.php:77 `db_get_row()` /home/dstestmohitrai/public_html/app/functions/fn.control.php:1073 `Tygh\Database\Connection::getRow()` /home/dstestmohitrai/public_html/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/dstestmohitrai/public_html/app/Tygh/Database/Connection.php:414	0.00167	Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 2
Query	Count	Min time	Max time	Average time
`SELECT id_path FROM jmj_categories WHERE category_id = 87`	2	0.00049	0.00064	0.00057
`SELECT location FROM jmj_users WHERE user_id = 0`	2	0.00064	0.00065	0.00064
`SELECT data FROM jmj_storage_data WHERE data_key = 'store_mode'`	1	0.00058	0.00058	0.00058
SELECT storefronts.* FROM jmj_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev.jmjxplore.com' OR storefronts.url = 'www.dev.jmjxplore.com' OR storefronts.url LIKE 'www_.dev.jmjxplore.com' OR storefronts.url LIKE 'dev.jmjxplore.com/%' OR storefronts.url LIKE 'www.dev.jmjxplore.com/%' OR storefronts.url LIKE 'www_.dev.jmjxplore.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev.jmjxplore.com' DESC, storefronts.url = 'www.dev.jmjxplore.com' DESC, storefronts.url LIKE 'www_.dev.jmjxplore.com' DESC, storefronts.url LIKE 'dev.jmjxplore.com/%' DESC, storefronts.url LIKE 'www.dev.jmjxplore.com/%' DESC, storefronts.url LIKE 'www_.dev.jmjxplore.com/%' desc	1	0.00055	0.00055	0.00055
`SET time_zone = '+05:30'`	1	0.00050	0.00050	0.00050
`SELECT storefronts.* FROM jmj_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc`	1	0.00072	0.00072	0.00072
`SELECT jmj_bm_layouts.* FROM jmj_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1`	1	0.00060	0.00060	0.00060
`SELECT data FROM jmj_storage_data WHERE data_key = 'cart_products_next_check'`	1	0.00061	0.00061	0.00061
`SELECT data FROM jmj_storage_data WHERE data_key = 'dev_mode'`	1	0.00075	0.00075	0.00075
`SELECT * FROM jmj_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 46`	1	0.00290	0.00290	0.00290
`SELECT * FROM jmj_bm_locations as l LEFT JOIN jmj_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 46 AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(87, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1`	1	0.00092	0.00092	0.00092
`SELECT data FROM jmj_storage_data WHERE data_key = 'cache_id'`	1	0.00306	0.00306	0.00306
`SELECT category_id FROM jmj_categories WHERE category_id = 87 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H')`	1	0.00171	0.00171	0.00171
`SELECT default_view, selected_views FROM jmj_categories WHERE category_id = 87`	1	0.00254	0.00254	0.00254
`SELECT default_view_desktop FROM jmj_categories WHERE category_id=87 AND selected_views !=""`	1	0.00384	0.00384	0.00384
SELECT jmj_ab__category_banners.*, jmj_ab__category_banner_images_and_descr.category_banner, jmj_ab__category_banner_images_and_descr.url, jmj_ab__category_banner_images_and_descr.category_banner_image_id FROM jmj_ab__category_banners INNER JOIN jmj_ab__category_banner_images_and_descr ON jmj_ab__category_banner_images_and_descr.category_banner_id = jmj_ab__category_banners.category_banner_id AND jmj_ab__category_banner_images_and_descr.lang_code = 'en' LEFT JOIN jmj_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = jmj_ab__category_banners.category_banner_id LEFT JOIN jmj_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = jmj_ab__category_banners.category_banner_id INNER JOIN jmj_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = jmj_ab__category_banner_images_and_descr.category_banner_image_id AND il.pair_id IS NOT NULL AND il.type = 'M' WHERE 1 AND jmj_ab__category_banners.status = 'A' AND jmj_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL AND (IF(jmj_ab__category_banners.from_date, jmj_ab__category_banners.from_date <= 1765697951, 1) AND IF(jmj_ab__category_banners.to_date, jmj_ab__category_banners.to_date >= 1765697951, 1)) AND (ab__category_banner_categories.category_id = 87 OR (ab__category_banner_categories1.category_id IN (2, 87) AND jmj_ab__category_banners.include_subcategories = 'Y')) ORDER BY jmj_ab__category_banner_images_and_descr.category_banner asc	1	0.00098	0.00098	0.00098
SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category_banner' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id IS NULL ORDER BY jmj_images_links.position, jmj_images_links.pair_id	1	0.00121	0.00121	0.00121
`SELECT usergroup_ids FROM jmj_categories WHERE category_id = 87`	1	0.00105	0.00105	0.00105
`SELECT category_id FROM jmj_categories WHERE category_id = 87 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1)`	1	0.00058	0.00058	0.00058
`SELECT category_id FROM jmj_categories WHERE category_type = 'D'`	1	0.00054	0.00054	0.00054
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control,jmj_categories.ab__fn_category_status,jmj_categories.ab__fn_label_color,jmj_categories.ab__fn_label_background,jmj_categories.ab__fn_use_origin_image,jmj_category_descriptions.ab__fn_label_text,jmj_category_descriptions.ab__fn_label_show FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.parent_id IN (87) AND jmj_categories.id_path LIKE '2/87/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc	1	0.00110	0.00110	0.00110
`SELECT * FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_category_descriptions.category_id = jmj_categories.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE jmj_categories.category_id = 87 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids))`	1	0.00080	0.00080	0.00080
SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'category' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id	1	0.00119	0.00119	0.00119
SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_allowed_not_allowed' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_allowed_not_allowed' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id	1	0.00061	0.00061	0.00061
SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_guideline_image' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id;SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.detailed_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'cat_guideline_image' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id = '87' ORDER BY jmj_images_links.position, jmj_images_links.pair_id	1	0.00093	0.00093	0.00093
`SELECT search_phrases FROM jmj_ab__search_motivation WHERE category_id = 87 AND lang_code = 'en'`	1	0.00163	0.00163	0.00163
`SELECT a.category_id FROM jmj_categories as a LEFT JOIN jmj_categories as b ON b.category_id IN (87) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')`	1	0.00157	0.00157	0.00157
`SELECT company_id FROM jmj_storefronts_companies WHERE storefront_id = 1`	1	0.00063	0.00063	0.00063
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, products.net_price as net_price, products.integer_in_full_description, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM jmj_products as products LEFT JOIN jmj_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN jmj_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN jmj_companies AS companies ON companies.company_id = products.company_id INNER JOIN jmj_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN jmj_categories ON jmj_categories.category_id = products_categories.category_id AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1) LEFT JOIN jmj_master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 WHERE 1 AND jmj_categories.category_id IN (87) AND (companies.status IN ('A') OR products.company_id = 0) 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id ORDER BY product asc, products.product_id ASC LIMIT 0, 12	1	0.00309	0.00309	0.00309
`SELECT FOUND_ROWS()`	1	0.00050	0.00050	0.00050
`SELECT COUNT(DISTINCT storefronts.storefront_id) FROM jmj_storefronts AS storefronts WHERE 1 = 1`	1	0.00055	0.00055	0.00055
`SELECT category_id, category FROM jmj_category_descriptions WHERE category_id IN (2) AND lang_code = 'en'`	1	0.00059	0.00059	0.00059
`SELECT privilege FROM jmj_usergroup_privileges WHERE usergroup_id IN (0, 1)`	1	0.00079	0.00079	0.00079
`SELECT c.* FROM jmj_bm_containers as c WHERE 1 AND c.location_id = 1259 AND c.company_id = 0`	1	0.00118	0.00118	0.00118
`SELECT layout_id FROM jmj_bm_locations WHERE location_id = 1259`	1	0.00058	0.00058	0.00058
SELECT c.*, IF (c.location_id != 1259, 0, 1) as `default` FROM jmj_bm_containers as c INNER JOIN jmj_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 46 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0	1	0.00179	0.00179	0.00179
`SELECT * FROM jmj_bm_containers as c LEFT JOIN jmj_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (5021, 5022, 5035, 5024) ORDER BY g.order, g.parent_id, g.grid_id ASC`	1	0.00094	0.00094	0.00094
SELECT jmj_bm_snapping.grid_id as grid_id,jmj_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,jmj_bm_block_statuses.object_ids as object_ids,jmj_bm_snapping.,jmj_bm_blocks.,jmj_bm_blocks_descriptions.* FROM jmj_bm_snapping LEFT JOIN jmj_bm_blocks ON jmj_bm_blocks.block_id = jmj_bm_snapping.block_id LEFT JOIN jmj_bm_block_statuses ON jmj_bm_snapping.snapping_id = jmj_bm_block_statuses.snapping_id AND jmj_bm_block_statuses.object_type LIKE 'categories' LEFT JOIN jmj_bm_blocks_descriptions ON jmj_bm_blocks.block_id = jmj_bm_blocks_descriptions.block_id LEFT JOIN jmj_bm_blocks_content AS default_content ON jmj_bm_blocks.block_id = default_content.block_id AND jmj_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 jmj_bm_blocks_content AS dynamic_object_content ON jmj_bm_blocks.block_id = dynamic_object_content.block_id AND jmj_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 87 AND dynamic_object_content.object_type like 'categories' WHERE jmj_bm_snapping.grid_id IN (6192, 6193, 6194, 6195, 6197, 6196, 6198, 6201, 6202, 6207, 6847, 6206, 6204, 6208, 6203, 6205, 6846, 6236, 6237, 6238, 6239, 6240, 6241, 6242) AND jmj_bm_blocks_descriptions.lang_code='en' ORDER BY jmj_bm_snapping.order, jmj_bm_snapping.block_id	1	0.00228	0.00228	0.00228
`SELECT status FROM jmj_menus WHERE menu_id = 1`	1	0.00048	0.00048	0.00048
SELECT sd.param_id, sd.param, jmj_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, jmj_static_data_descriptions.ab__fn_label_show, jmj_static_data_descriptions.ab__fn_label_text, sd.ab__fn_label_color, sd.ab__fn_menu_status, sd.ab__fn_label_background, sd.ab__fn_use_origin_image, sd.abt__ut2_mwi__status, jmj_static_data_descriptions.abt__ut2_mwi__label, sd.abt__ut2_mwi__label_color, sd.abt__ut2_mwi__label_background, jmj_static_data_descriptions.abt__ut2_mwi__desc, jmj_static_data_descriptions.abt__ut2_mwi__text, sd.abt__ut2_mwi__text_position, sd.abt__ut2_mwi__dropdown FROM jmj_static_data AS sd LEFT JOIN jmj_static_data_descriptions ON sd.param_id = jmj_static_data_descriptions.param_id AND jmj_static_data_descriptions.lang_code = 'en' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '1' ORDER BY sd.position	1	0.00079	0.00079	0.00079
`SELECT status FROM jmj_menus WHERE menu_id = 2`	1	0.00061	0.00061	0.00061
SELECT sd.param_id, sd.param, jmj_static_data_descriptions.descr, sd.param_2, sd.param_3, sd.param_4, sd.param_5, sd.param_6, sd.status, sd.position, sd.parent_id, sd.id_path, sd.class, jmj_static_data_descriptions.ab__fn_label_show, jmj_static_data_descriptions.ab__fn_label_text, sd.ab__fn_label_color, sd.ab__fn_menu_status, sd.ab__fn_label_background, sd.ab__fn_use_origin_image, sd.abt__ut2_mwi__status, jmj_static_data_descriptions.abt__ut2_mwi__label, sd.abt__ut2_mwi__label_color, sd.abt__ut2_mwi__label_background, jmj_static_data_descriptions.abt__ut2_mwi__desc, jmj_static_data_descriptions.abt__ut2_mwi__text, sd.abt__ut2_mwi__text_position, sd.abt__ut2_mwi__dropdown FROM jmj_static_data AS sd LEFT JOIN jmj_static_data_descriptions ON sd.param_id = jmj_static_data_descriptions.param_id AND jmj_static_data_descriptions.lang_code = 'en' WHERE sd.section = 'A' AND sd.status = 'A' AND sd.param_5 = '2' ORDER BY sd.position	1	0.00126	0.00126	0.00126
`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 2 AND storefront_id IN (0, 1)`	1	0.00065	0.00065	0.00065
`SELECT id_path FROM jmj_categories WHERE category_id = 2`	1	0.00050	0.00050	0.00050
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '2/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc	1	0.00104	0.00104	0.00104
`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(36, 60, 31, 47, 32, 48, 45, 61, 46, 62, 33, 49, 87, 34, 63, 51, 35, 50, 64, 65, 37, 52, 53, 38, 66, 54, 39, 41, 57, 59, 40, 43, 55, 42, 56, 58, 44) AND category_id != 1`	1	0.00067	0.00067	0.00067
`SELECT category FROM jmj_category_descriptions WHERE category_id = 2 AND lang_code = 'en'`	1	0.00053	0.00053	0.00053
`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 3 AND storefront_id IN (0, 1)`	1	0.00056	0.00056	0.00056
`SELECT id_path FROM jmj_categories WHERE category_id = 3`	1	0.00053	0.00053	0.00053
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '3/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc	1	0.00100	0.00100	0.00100
`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(20, 26, 9, 8, 19, 10, 21, 30, 25, 11, 22, 27, 28, 23, 12, 29, 13, 24, 14, 15, 16, 18, 17) AND category_id != 1`	1	0.00058	0.00058	0.00058
`SELECT category FROM jmj_category_descriptions WHERE category_id = 3 AND lang_code = 'en'`	1	0.00065	0.00065	0.00065
`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 4 AND storefront_id IN (0, 1)`	1	0.00051	0.00051	0.00051
`SELECT id_path FROM jmj_categories WHERE category_id = 4`	1	0.00060	0.00060	0.00060
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '4/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc	1	0.00093	0.00093	0.00093
`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(83, 104, 106, 69, 67, 68, 105, 70, 84, 82, 107, 85, 71, 108, 72, 86, 73, 74, 75, 76, 77) AND category_id != 1`	1	0.00074	0.00074	0.00074
`SELECT category FROM jmj_category_descriptions WHERE category_id = 4 AND lang_code = 'en'`	1	0.00046	0.00046	0.00046
`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 78 AND storefront_id IN (0, 1)`	1	0.00067	0.00067	0.00067
`SELECT id_path FROM jmj_categories WHERE category_id = 78`	1	0.00046	0.00046	0.00046
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '78/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc	1	0.00101	0.00101	0.00101
`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(109, 116, 88, 79, 80, 117, 110, 111, 81, 118, 119, 112, 120, 113, 114, 121, 115, 122) AND category_id != 1`	1	0.00059	0.00059	0.00059
`SELECT category FROM jmj_category_descriptions WHERE category_id = 78 AND lang_code = 'en'`	1	0.00058	0.00058	0.00058
`SELECT COUNT(*) FROM jmj_categories WHERE category_id = 5 AND storefront_id IN (0, 1)`	1	0.00047	0.00047	0.00047
`SELECT id_path FROM jmj_categories WHERE category_id = 5`	1	0.00045	0.00045	0.00045
SELECT jmj_categories.category_id,jmj_categories.parent_id,jmj_categories.id_path,jmj_category_descriptions.category,jmj_categories.position,jmj_categories.status,jmj_categories.company_id,jmj_categories.storefront_id,jmj_categories.ab__lc_catalog_image_control FROM jmj_categories LEFT JOIN jmj_category_descriptions ON jmj_categories.category_id = jmj_category_descriptions.category_id AND jmj_category_descriptions.lang_code = 'en' WHERE 1=1 AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A') AND jmj_categories.id_path LIKE '5/%' AND jmj_categories.category_id != 1 AND jmj_categories.parent_id != 1 AND jmj_categories.storefront_id IN (0, 1) ORDER BY jmj_categories.is_trash asc, jmj_categories.position asc, jmj_category_descriptions.category asc	1	0.00099	0.00099	0.00099
`SELECT category_id, parent_id FROM jmj_categories WHERE parent_id IN(100, 89, 92, 97, 93, 98, 90, 101, 91, 94, 99, 102, 103, 95, 96) AND category_id != 1`	1	0.00075	0.00075	0.00075
`SELECT category FROM jmj_category_descriptions WHERE category_id = 5 AND lang_code = 'en'`	1	0.00047	0.00047	0.00047
`SELECT * FROM jmj_product_feature_variants WHERE variant_id IN ('')`	1	0.00066	0.00066	0.00066
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, products.net_price as net_price, products.integer_in_full_description, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM jmj_products as products LEFT JOIN jmj_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN jmj_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN jmj_companies AS companies ON companies.company_id = products.company_id INNER JOIN jmj_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN jmj_categories ON jmj_categories.category_id = products_categories.category_id AND (jmj_categories.usergroup_ids = '' OR FIND_IN_SET(0, jmj_categories.usergroup_ids) OR FIND_IN_SET(1, jmj_categories.usergroup_ids)) AND jmj_categories.status IN ('A', 'H') AND jmj_categories.storefront_id IN (0, 1) LEFT JOIN jmj_master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 WHERE 1 AND jmj_categories.category_id IN (87) AND (companies.status IN ('A') OR products.company_id = 0) 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.master_product_status IN ('A', 'H') AND products.master_product_id = 0 AND (products.company_id > 0 OR (master_products_storefront_offers_count.count > 0 )) AND products.product_type != 'D' GROUP BY product_id ORDER BY products.timestamp desc, products.product_id ASC LIMIT 0, 10	1	0.00148	0.00148	0.00148
`SELECT company_id FROM jmj_companies WHERE 1 AND company = 'JMJ Xplore'`	1	0.00080	0.00080	0.00080
`SELECT * FROM jmj_logos WHERE layout_id IN (46, 0) AND style_id IN ('jmj_xplore', '') AND storefront_id IN (1, 0) AND company_id = 0`	1	0.00067	0.00067	0.00067
SELECT jmj_images., jmj_images_links., jmj_common_descriptions.description AS alt, jmj_images.image_id AS images_image_id FROM jmj_images_links LEFT JOIN jmj_images ON jmj_images_links.image_id = jmj_images.image_id LEFT JOIN jmj_common_descriptions ON jmj_common_descriptions.object_id = jmj_images.image_id AND jmj_common_descriptions.object_holder = 'images' AND jmj_common_descriptions.lang_code = 'en' WHERE jmj_images_links.object_type = 'logos' AND jmj_images_links.type = 'M' AND jmj_images_links.object_id IN (10, 341, 342, 343, 344) ORDER BY jmj_images_links.position, jmj_images_links.pair_id	1	0.00136	0.00136	0.00136
`SELECT country FROM jmj_country_descriptions WHERE code = 'IN' AND lang_code = 'en'`	1	0.00112	0.00112	0.00112
`SELECT jmj_state_descriptions.state FROM jmj_states LEFT JOIN jmj_state_descriptions ON jmj_state_descriptions.state_id = jmj_states.state_id AND jmj_state_descriptions.lang_code = 'en' WHERE jmj_states.country_code = 'IN' AND jmj_states.code = 'DL'`	1	0.00049	0.00049	0.00049
`SELECT jmj_abt__ut2_microdata.id, jmj_abt__ut2_microdata.field, jmj_abt__ut2_microdata_description.value FROM jmj_abt__ut2_microdata INNER JOIN jmj_abt__ut2_microdata_description ON jmj_abt__ut2_microdata_description.id = jmj_abt__ut2_microdata.id AND jmj_abt__ut2_microdata_description.lang_code = 'en' WHERE jmj_abt__ut2_microdata.company_id = 0 ORDER BY jmj_abt__ut2_microdata.id ASC`	1	0.00057	0.00057	0.00057
`SELECT data FROM jmj_storage_data WHERE data_key = 'restrictions'`	1	0.00167	0.00167	0.00167


	Sandbox

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace