Queries list
Queries count !
Queries parse


SELECT storefronts.* FROM vi_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev.vipiris.com' OR storefronts.url = 'www.dev.vipiris.com' OR storefronts.url LIKE 'www_.dev.vipiris.com' OR storefronts.url LIKE 'dev.vipiris.com/%' OR storefronts.url LIKE 'www.dev.vipiris.com/%' OR storefronts.url LIKE 'www_.dev.vipiris.com/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev.vipiris.com' DESC, storefronts.url = 'www.dev.vipiris.com' DESC, storefronts.url LIKE 'www_.dev.vipiris.com' DESC, storefronts.url LIKE 'dev.vipiris.com/%' DESC, storefronts.url LIKE 'www.dev.vipiris.com/%' DESC, storefronts.url LIKE 'www_.dev.vipiris.com/%' desc 
SELECT data FROM vi_storage_data WHERE data_key = 'store_mode'
SELECT company_id FROM vi_storefronts_companies WHERE storefront_id = 1
SELECT entry_page FROM vi_companies WHERE company_id = 1 AND redirect_customer != 'Y'
SELECT COUNT(*) FROM vi_companies
SET time_zone = '-07:00'
SELECT company_id, storefront, secure_storefront FROM vi_companies WHERE company_id = 1
SELECT type FROM vi_seo_names WHERE name = 'tv-and-video'  AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)
SELECT * FROM vi_seo_names WHERE name = 'tv-and-video'  AND vi_seo_names.company_id IN (0, 1) 
SELECT storefronts.* FROM vi_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT company_id FROM vi_storefronts_companies WHERE storefront_id = 1
SELECT vi_languages.lang_code, vi_languages.name FROM vi_languages  LEFT JOIN vi_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = vi_languages.lang_id WHERE 1 AND vi_languages.status = 'A' AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)   
SELECT object_id, name FROM vi_seo_names WHERE name IN ('electronics') AND type = 'c' AND lang_code = 'en'  AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT name, path FROM vi_seo_names WHERE `object_id` = 174 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND vi_seo_names.company_id IN (0, 1)
SELECT name, path FROM vi_seo_names WHERE `object_id` = 166 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en'  AND vi_seo_names.company_id IN (0, 1)
SELECT redirect_id, src, type, object_id, dest, lang_code FROM vi_seo_redirects WHERE src = '/electronics/tv-and-video'  AND ( vi_seo_redirects.company_id = 1 OR vi_seo_redirects.company_id = 0)
SELECT companies.*, AVG(vi_discussion_rating.rating_value) AS average_rating, CONCAT(companies.company_id, '_', IF ( vi_discussion_rating.thread_id, vi_discussion_rating.thread_id, '0')) AS company_thread_ids FROM vi_companies AS companies  LEFT JOIN vi_discussion ON vi_discussion.object_id = companies.company_id AND vi_discussion.object_type = 'M' LEFT JOIN vi_discussion_posts ON vi_discussion_posts.thread_id = vi_discussion.thread_id AND vi_discussion_posts.status = 'A' LEFT JOIN vi_discussion_rating ON vi_discussion.thread_id = vi_discussion_rating.thread_id AND vi_discussion_rating.post_id = vi_discussion_posts.post_id WHERE companies.company_id = 1 
SELECT a.object_id, COUNT(b.post_id) as total_items FROM vi_discussion as a LEFT JOIN vi_discussion_posts as b ON a.thread_id=b.thread_id WHERE a.object_type = 'M' AND b.status = 'A' GROUP BY a.object_id
SELECT vi_bm_layouts.* FROM vi_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1
SELECT data FROM vi_storage_data WHERE data_key = 'cart_products_next_check'
SELECT data FROM vi_storage_data WHERE data_key = 'dev_mode'
SELECT vi_payments.*, vi_payment_descriptions.*, IF (ISNULL(vi_addons.status), "A", vi_addons.status) AS processor_status, vi_payment_processors.type AS processor_type, vi_payment_processors.processor_script AS processor_script FROM vi_payments LEFT JOIN vi_payment_descriptions ON vi_payment_descriptions.payment_id = vi_payments.payment_id AND vi_payment_descriptions.lang_code = 'en' LEFT JOIN vi_payment_processors ON vi_payment_processors.processor_id = vi_payments.processor_id LEFT JOIN vi_addons ON vi_payment_processors.addon = vi_addons.addon  LEFT JOIN vi_storefronts_payments AS storefronts_payments ON storefronts_payments.payment_id = vi_payments.payment_id WHERE vi_payments.status = 'A' AND (storefronts_payments.storefront_id = 1 OR storefronts_payments.storefront_id IS NULL) AND vi_payment_processors.processor_script IN ('stripe.php') HAVING processor_status = 'A' ORDER BY vi_payments.position
SELECT * FROM vi_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 2
SELECT * FROM vi_bm_locations as l LEFT JOIN vi_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 2  AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(174, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
SELECT data FROM vi_storage_data WHERE data_key = 'cache_id'
SELECT * FROM vi_hybrid_auth_providers WHERE 1  AND company_id = 1 AND status = 'A' ORDER BY position
SELECT category_id FROM vi_categories WHERE category_id = 174  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND vi_categories.company_id = 1
SELECT default_view, selected_views FROM vi_categories WHERE category_id = 174
SELECT default_view_desktop FROM vi_categories WHERE category_id=174 AND selected_views !="" 
SELECT id_path FROM vi_categories WHERE category_id = 174
SELECT vi_ab__category_banners.*, vi_ab__category_banner_images_and_descr.category_banner, vi_ab__category_banner_images_and_descr.url, vi_ab__category_banner_images_and_descr.category_banner_image_id, layout_data.* FROM vi_ab__category_banners INNER JOIN vi_ab__category_banner_images_and_descr ON vi_ab__category_banner_images_and_descr.category_banner_id = vi_ab__category_banners.category_banner_id AND vi_ab__category_banner_images_and_descr.lang_code = 'en'  LEFT JOIN vi_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = vi_ab__category_banners.category_banner_id  LEFT JOIN vi_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = vi_ab__category_banners.category_banner_id LEFT JOIN vi_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = vi_ab__category_banner_images_and_descr.category_banner_image_id AND il.type = 'M' LEFT JOIN vi_ab__category_banners_layout_data AS layout_data ON layout_data.category_banner_id = vi_ab__category_banners.category_banner_id WHERE 1  AND vi_ab__category_banners.status = 'A'  AND vi_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL  AND vi_ab__category_banners.company_id = 1 AND (IF(vi_ab__category_banners.from_date, vi_ab__category_banners.from_date <= 1776432263, 1) AND IF(vi_ab__category_banners.to_date, vi_ab__category_banners.to_date >= 1776432263, 1)) AND (ab__category_banner_categories.category_id = 174 OR (ab__category_banner_categories1.category_id IN (166, 174) AND vi_ab__category_banners.include_subcategories = 'Y')) AND IF(layout_data.products_multicolumns_type = 'B', layout_data.products_multicolumns_block_id > 0,il.pair_id IS NOT NULL) = 1  ORDER BY vi_ab__category_banner_images_and_descr.category_banner asc 
SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category_banner' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (1, 9) ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT usergroup_ids FROM vi_categories WHERE category_id = 174
SELECT category_id FROM vi_categories WHERE category_id = 174  AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND vi_categories.storefront_id IN (0, 1)
SELECT id_path FROM vi_categories WHERE category_id = 174
SELECT vi_categories.category_id,vi_categories.parent_id,vi_categories.id_path,vi_category_descriptions.category,vi_categories.position,vi_categories.status,vi_categories.company_id,vi_categories.storefront_id,vi_categories.company_id,vi_seo_names.name as seo_name,vi_seo_names.path as seo_path,vi_categories.ab__lc_catalog_image_control,vi_categories.ab__fn_category_status,vi_categories.ab__fn_label_color,vi_categories.ab__fn_label_background,vi_categories.ab__fn_use_origin_image,vi_category_descriptions.ab__fn_label_text,vi_category_descriptions.ab__fn_label_show FROM vi_categories LEFT JOIN vi_category_descriptions ON vi_categories.category_id = vi_category_descriptions.category_id AND vi_category_descriptions.lang_code = 'en'  LEFT JOIN vi_seo_names ON vi_seo_names.object_id = vi_categories.category_id  AND vi_seo_names.type = 'c'  AND vi_seo_names.dispatch = '' AND vi_seo_names.lang_code = 'en'  AND vi_seo_names.company_id = vi_categories.company_id  WHERE 1=1  AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A') AND vi_categories.parent_id IN (174) AND vi_categories.id_path LIKE '166/174/%' AND vi_categories.storefront_id IN (0, 1) AND vi_categories.company_id = 1   ORDER BY vi_categories.is_trash asc, vi_categories.position asc, vi_category_descriptions.category asc 
SELECT category_id, parent_id FROM vi_categories WHERE parent_id IN(190, 191, 193, 194, 195) 
SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (190, 191, 193, 194, 195) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (190, 191, 193, 194, 195) ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT *, vi_seo_names.name as seo_name, vi_seo_names.path as seo_path FROM vi_categories LEFT JOIN vi_category_descriptions ON vi_category_descriptions.category_id = vi_categories.category_id AND vi_category_descriptions.lang_code = 'en'  LEFT JOIN vi_seo_names ON vi_seo_names.object_id = 174  AND vi_seo_names.type = 'c'  AND vi_seo_names.dispatch = '' AND vi_seo_names.lang_code = 'en'  AND vi_seo_names.company_id = vi_categories.company_id  WHERE vi_categories.category_id = 174 AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.company_id = 1
SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id = '174' ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id = '174' ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT search_phrases FROM vi_ab__search_motivation WHERE category_id = 174 AND lang_code = 'en'
SELECT a.category_id                  FROM vi_categories as a                  LEFT JOIN vi_categories as b                  ON b.category_id IN (174)                  WHERE a.id_path LIKE CONCAT(b.id_path, '/%')
SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id FROM vi_products as products  LEFT JOIN vi_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN vi_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN vi_companies AS companies ON companies.company_id = products.company_id  INNER JOIN vi_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN vi_categories ON vi_categories.category_id = products_categories.category_id  AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A', 'H') AND vi_categories.storefront_id IN (0, 1)  LEFT JOIN vi_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id  AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' WHERE 1  AND vi_categories.category_id IN (174, 190, 191, 194, 193, 195) AND companies.status IN ('A') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC  LIMIT 0, 18
SELECT FOUND_ROWS()
SELECT vi_products.* FROM vi_products  WHERE vi_products.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)  
SELECT vi_product_prices.product_id, MIN(IF(vi_product_prices.percentage_discount = 0,vi_product_prices.price,vi_product_prices.price - (vi_product_prices.price * vi_product_prices.percentage_discount)/100)) AS price FROM vi_product_prices  WHERE vi_product_prices.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)  AND vi_product_prices.lower_limit = 1 AND vi_product_prices.usergroup_id IN (0, 1)  GROUP BY vi_product_prices.product_id
SELECT vi_product_descriptions.product_id, vi_product_descriptions.short_description, IF(vi_product_descriptions.short_description = '' OR vi_product_descriptions.short_description IS NULL, vi_product_descriptions.full_description, '') AS full_description, vi_product_descriptions.meta_keywords, vi_product_descriptions.meta_description, vi_product_descriptions.search_words, vi_product_descriptions.promo_text, vi_product_descriptions.unit_name FROM vi_product_descriptions  WHERE vi_product_descriptions.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)  AND vi_product_descriptions.lang_code = 'en' 
SELECT vi_products_categories.product_id, GROUP_CONCAT(IF(vi_products_categories.link_type = "M", CONCAT(vi_products_categories.category_id, "M"), vi_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM vi_products_categories  INNER JOIN vi_categories ON vi_categories.category_id = vi_products_categories.category_id AND vi_categories.storefront_id IN (0, 1) AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A', 'H')  LEFT JOIN vi_products_categories AS product_position_source ON vi_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 174 WHERE vi_products_categories.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)   GROUP BY vi_products_categories.product_id
SELECT vi_ult_product_descriptions.product_id, vi_ult_product_descriptions.short_description, IF(vi_ult_product_descriptions.short_description = "", vi_ult_product_descriptions.full_description, "") AS full_description, vi_ult_product_descriptions.meta_keywords, vi_ult_product_descriptions.meta_description, vi_ult_product_descriptions.search_words, vi_ult_product_descriptions.promo_text FROM vi_ult_product_descriptions  WHERE vi_ult_product_descriptions.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_ult_product_descriptions.company_id = 1 AND vi_ult_product_descriptions.lang_code = 'en' 
SELECT vi_seo_names.object_id AS product_id, vi_seo_names.name AS seo_name, vi_seo_names.path AS seo_path FROM vi_seo_names  WHERE vi_seo_names.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)  AND vi_seo_names.type = "p" AND vi_seo_names.dispatch = "" AND vi_seo_names.lang_code = 'en'  AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0) 
SELECT vi_product_review_prepared_data.product_id AS product_id, vi_product_review_prepared_data.average_rating AS average_rating, vi_product_review_prepared_data.reviews_count AS reviews_count FROM vi_product_review_prepared_data  WHERE vi_product_review_prepared_data.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)  AND vi_product_review_prepared_data.storefront_id = 0 
SELECT vi_ult_product_prices.product_id, MIN(IF(vi_ult_product_prices.percentage_discount = 0,vi_ult_product_prices.price,vi_ult_product_prices.price - (vi_ult_product_prices.price * vi_ult_product_prices.percentage_discount)/100)) AS price FROM vi_ult_product_prices  WHERE vi_ult_product_prices.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)  AND vi_ult_product_prices.lower_limit = 1 AND vi_ult_product_prices.company_id = 1 AND vi_ult_product_prices.usergroup_id IN (0, 0, 1)  GROUP BY vi_ult_product_prices.product_id
SELECT video_id, product_id FROM vi_ab__video_gallery WHERE product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND status = 'A' AND storefront_id IN (1, 0)
SELECT p.product_id,ifnull(count(dp.post_id),0) as discussion_amount_posts FROM vi_discussion INNER JOIN vi_products as p ON (vi_discussion.object_id=p.product_id) INNER JOIN vi_discussion_posts as dp ON (vi_discussion.thread_id=dp.thread_id AND vi_discussion.object_type='P'  AND vi_discussion.company_id = 1) WHERE dp.status='A' and p.product_id in (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) GROUP BY p.product_id
SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'A' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'A' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM vi_product_options as a  LEFT JOIN vi_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = a.option_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_options') WHERE a.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND a.status = 'A' ORDER BY a.position
SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM vi_product_options as a LEFT JOIN vi_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN vi_product_global_option_links as c ON c.option_id = a.option_id INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = a.option_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_options') WHERE c.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position
SELECT vi_languages.* FROM vi_languages  LEFT JOIN vi_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = vi_languages.lang_id WHERE 1 AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)   
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('3') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('4') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('5') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('6') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('7') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('8') ) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM vi_product_variation_group_features AS f INNER JOIN vi_product_variation_groups AS g ON f.group_id = g.id INNER JOIN vi_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)
SELECT p.promotion_id, p.from_date, p.to_date, active.from_date AS active_from_date, active.to_date AS active_to_date, expired.from_date AS expired_from_date, expired.to_date AS expired_to_date FROM vi_promotions AS p INNER JOIN vi_ab__dotd AS ab__dotd ON p.promotion_id=ab__dotd.promotion_id AND ab__dotd.use_schedule='Y' LEFT JOIN (SELECT promotion_id,MIN(from_date) AS from_date,MIN(to_date) AS to_date FROM vi_ab__dotd_periods WHERE to_date >= 1776432263 GROUP BY promotion_id) AS active ON active.promotion_id=p.promotion_id LEFT JOIN (SELECT promotion_id,MAX(from_date) AS from_date,MAX(to_date) AS to_date FROM vi_ab__dotd_periods WHERE to_date < 1776432263 GROUP BY promotion_id) AS expired ON expired.promotion_id=p.promotion_id WHERE p.status IN ('A', 'H')
SELECT vi_promotions.*, vi_promotion_descriptions.name, vi_promotion_descriptions.detailed_description, vi_promotion_descriptions.short_description FROM vi_promotions  LEFT JOIN vi_promotion_descriptions ON vi_promotion_descriptions.promotion_id = vi_promotions.promotion_id AND vi_promotion_descriptions.lang_code = 'en' LEFT JOIN vi_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = vi_promotions.promotion_id WHERE 1  AND IF(from_date, from_date <= 1776432263, 1) AND IF(to_date, to_date >= 1776432263, 1) AND status IN ('A', 'H') AND vi_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL)   ORDER BY vi_promotions.stop_other_rules desc, vi_promotions.priority asc 
SELECT vi_ab__stickers.*, descriptions.*, images.image_id, vi_ab__stickers.sticker_id as sticker_id FROM vi_ab__stickers LEFT JOIN vi_ab__sticker_descriptions as descriptions ON vi_ab__stickers.sticker_id = descriptions.sticker_id AND descriptions.lang_code = 'en' LEFT JOIN vi_ab__sticker_images AS images ON vi_ab__stickers.sticker_id = images.sticker_id AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND vi_ab__stickers.status = 'A' AND ((vi_ab__stickers.from_date <= 1776409200 OR vi_ab__stickers.from_date = 0) AND (vi_ab__stickers.to_date >= 1776409200 OR vi_ab__stickers.to_date = 0)) AND vi_ab__stickers.sticker_id IN (0) AND REPLACE(REPLACE(vi_ab__stickers.display_place, "/", ""), "\\", "") NOT LIKE '%"blocksproductsproducts_multicolumns.tpl":"not_display"%' AND (vi_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, vi_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, vi_ab__stickers.usergroup_ids))  ORDER BY vi_ab__stickers.position asc 
SELECT vi_ab__stickers.*, descriptions.*, images.image_id, vi_ab__stickers.sticker_id as sticker_id FROM vi_ab__stickers LEFT JOIN vi_ab__sticker_descriptions as descriptions ON vi_ab__stickers.sticker_id = descriptions.sticker_id AND descriptions.lang_code = 'en' LEFT JOIN vi_ab__sticker_images AS images ON vi_ab__stickers.sticker_id = images.sticker_id AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND vi_ab__stickers.status = 'A' AND ((vi_ab__stickers.from_date <= 1776409200 OR vi_ab__stickers.from_date = 0) AND (vi_ab__stickers.to_date >= 1776409200 OR vi_ab__stickers.to_date = 0)) AND ((0) OR vi_ab__stickers.type = 'D') AND REPLACE(REPLACE(vi_ab__stickers.display_place, "/", ""), "\\", "") NOT LIKE '%"blocksproductsproducts_multicolumns.tpl":"not_display"%' AND (vi_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, vi_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, vi_ab__stickers.usergroup_ids))  ORDER BY vi_ab__stickers.position asc 
SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'ab__stickers' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (193) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images.*, vi_images_links.*, vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'ab__stickers' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (193) ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT object_id, thread_id, type, object_type, company_id FROM vi_discussion  WHERE 1  AND object_id = 18 AND object_type = 'P'  AND vi_discussion.company_id = 1  
SELECT object_id, thread_id, type, object_type, company_id FROM vi_discussion  WHERE 1  AND object_id = 16 AND object_type = 'P'  AND vi_discussion.company_id = 1  
SELECT thread_id, type, object_type, object_id FROM vi_discussion WHERE thread_id = 4  AND vi_discussion.company_id = 1
SELECT COUNT(*) FROM vi_discussion_posts  LEFT JOIN vi_discussion_messages ON vi_discussion_messages.post_id = vi_discussion_posts.post_id  LEFT JOIN vi_discussion_rating ON vi_discussion_rating.post_id = vi_discussion_posts.post_id  WHERE vi_discussion_posts.thread_id = 4 AND vi_discussion_posts.status = 'A'
SELECT vi_discussion_rating.rating_value, COUNT(vi_discussion_rating.post_id) as qty FROM vi_discussion_posts  LEFT JOIN vi_discussion_messages ON vi_discussion_messages.post_id = vi_discussion_posts.post_id  LEFT JOIN vi_discussion_rating ON vi_discussion_rating.post_id = vi_discussion_posts.post_id  WHERE vi_discussion_posts.thread_id = 4 AND vi_discussion_posts.status = 'A' GROUP BY vi_discussion_rating.rating_value
SELECT vi_discussion_posts.* , vi_discussion_messages.message, vi_discussion_rating.rating_value FROM vi_discussion_posts  LEFT JOIN vi_discussion_messages ON vi_discussion_messages.post_id = vi_discussion_posts.post_id  LEFT JOIN vi_discussion_rating ON vi_discussion_rating.post_id = vi_discussion_posts.post_id  WHERE vi_discussion_posts.thread_id = 4 AND vi_discussion_posts.status = 'A' ORDER BY vi_discussion_posts.timestamp DESC  LIMIT 0, 10
SELECT AVG (dr.rating_value) FROM vi_discussion_rating AS dr LEFT JOIN vi_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN vi_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 16 AND d.object_type = 'P' AND type IN ( 'B', 'R' )  AND d.company_id = 1 AND dp.status = 'A' AND dr.rating_value > 0

Queries total time: 0.02835 s.
№	Query	Time	Actions
1	SELECT storefronts.* FROM vi_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev.vipiris.com' OR storefronts.url = 'www.dev.vipiris.com' OR storefronts.url LIKE 'www_.dev.vipiris.com' OR storefronts.url LIKE 'dev.vipiris.com/%' OR storefronts.url LIKE 'www.dev.vipiris.com/%' OR storefronts.url LIKE 'www_.dev.vipiris.com/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev.vipiris.com' DESC, storefronts.url = 'www.dev.vipiris.com' DESC, storefronts.url LIKE 'www_.dev.vipiris.com' DESC, storefronts.url LIKE 'dev.vipiris.com/%' DESC, storefronts.url LIKE 'www.dev.vipiris.com/%' DESC, storefronts.url LIKE 'www_.dev.vipiris.com/%' desc Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_redirect_to_regional_storefront()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `Tygh\Storefront\Repository::findByUrl()` /home/devvipiriscom/www/app/functions/fn.init.php:1424 `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:133 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:378 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00026	Re-run Backtrace
2	`SELECT data FROM vi_storage_data WHERE data_key = 'store_mode'` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_http_params_by_storefront()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_allowed_for()` /home/devvipiriscom/www/app/functions/fn.init.php:1580 `fn_get_storage_data()` /home/devvipiriscom/www/app/functions/fn.control.php:992 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.control.php:1084 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00009	Re-run Backtrace
3	`SELECT company_id FROM vi_storefronts_companies WHERE storefront_id = 1` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_http_params_by_storefront()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `Tygh\Storefront\Storefront::__call()` /home/devvipiriscom/www/app/functions/fn.init.php:1581 `Tygh\Storefront\Storefront::getRelationValue()` /home/devvipiriscom/www/app/Tygh/Storefront/Storefront.php:235 `Tygh\Storefront\RelationsManager::getRelationValue()` /home/devvipiriscom/www/app/Tygh/Storefront/Storefront.php:272 `Tygh\Storefront\RelationsManager::getRelatedValues()` /home/devvipiriscom/www/app/Tygh/Storefront/RelationsManager.php:80 `Tygh\Database\Connection::getColumn()` /home/devvipiriscom/www/app/Tygh/Storefront/RelationsManager.php:115 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:480	0.00005	Re-run Backtrace
4	`SELECT entry_page FROM vi_companies WHERE company_id = 1 AND redirect_customer != 'Y'` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_company_id()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.init.php:405 `fn_ult_init_company_id()` /home/devvipiriscom/www/app/functions/fn.control.php:105 `db_get_field()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:585 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00006	Re-run Backtrace
5	`SELECT COUNT(*) FROM vi_companies` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_company_id()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.init.php:405 `fn_ult_init_company_id()` /home/devvipiriscom/www/app/functions/fn.control.php:105 `db_get_field()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:604 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00004	Re-run Backtrace
6	`SET time_zone = '-07:00'` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_settings()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_init_time_zone()` /home/devvipiriscom/www/app/functions/fn.init.php:1030 `db_query()` /home/devvipiriscom/www/app/functions/fn.init.php:1051 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/functions/fn.database.php:138	0.00004	Re-run Backtrace
7	`SELECT company_id, storefront, secure_storefront FROM vi_companies WHERE company_id = 1` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_get_request_uri()` /home/devvipiriscom/www/app/functions/fn.control.php:832 `fn_get_storefront_urls()` /home/devvipiriscom/www/app/functions/fn.control.php:1173 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:3649 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00008	Re-run Backtrace
8	`SELECT type FROM vi_seo_names WHERE name = 'tv-and-video' AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_field()` /home/devvipiriscom/www/app/addons/seo/func.php:686 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00018	Re-run Backtrace
9	`SELECT * FROM vi_seo_names WHERE name = 'tv-and-video' AND vi_seo_names.company_id IN (0, 1)` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_array()` /home/devvipiriscom/www/app/addons/seo/func.php:692 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00016	Re-run Backtrace
10	`SELECT storefronts.* FROM vi_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/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_seo_validate_object()` /home/devvipiriscom/www/app/addons/seo/func.php:732 `Tygh\Languages\Languages::getSimpleLanguages()` /home/devvipiriscom/www/app/addons/seo/func.php:1129 `Tygh\Providers\StorefrontProvider::getStorefront()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:488 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/Tygh/Providers/StorefrontProvider.php:63 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Storefront\Repository::findById()` /home/devvipiriscom/www/app/Tygh/Providers/StorefrontProvider.php:190 `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:172 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00010	Re-run Backtrace
11	`SELECT company_id FROM vi_storefronts_companies WHERE storefront_id = 1` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_seo_validate_object()` /home/devvipiriscom/www/app/addons/seo/func.php:732 `Tygh\Languages\Languages::getSimpleLanguages()` /home/devvipiriscom/www/app/addons/seo/func.php:1129 `Tygh\Providers\StorefrontProvider::getStorefront()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:488 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/Tygh/Providers/StorefrontProvider.php:63 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Storefront\Storefront::__call()` /home/devvipiriscom/www/app/Tygh/Providers/StorefrontProvider.php:195 `Tygh\Storefront\Storefront::getRelationValue()` /home/devvipiriscom/www/app/Tygh/Storefront/Storefront.php:235 `Tygh\Storefront\RelationsManager::getRelationValue()` /home/devvipiriscom/www/app/Tygh/Storefront/Storefront.php:272 `Tygh\Storefront\RelationsManager::getRelatedValues()` /home/devvipiriscom/www/app/Tygh/Storefront/RelationsManager.php:80 `Tygh\Database\Connection::getColumn()` /home/devvipiriscom/www/app/Tygh/Storefront/RelationsManager.php:115 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:480	0.00007	Re-run Backtrace
12	`SELECT vi_languages.lang_code, vi_languages.name FROM vi_languages LEFT JOIN vi_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = vi_languages.lang_id WHERE 1 AND vi_languages.status = 'A' AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_seo_validate_object()` /home/devvipiriscom/www/app/addons/seo/func.php:732 `Tygh\Languages\Languages::getSimpleLanguages()` /home/devvipiriscom/www/app/addons/seo/func.php:1129 `db_get_hash_single_array()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:515 `Tygh\Database\Connection::getSingleHash()` /home/devvipiriscom/www/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:572	0.00013	Re-run Backtrace
13	`SELECT object_id, name FROM vi_seo_names WHERE name IN ('electronics') AND type = 'c' AND lang_code = 'en' AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_seo_validate_object()` /home/devvipiriscom/www/app/addons/seo/func.php:732 `fn_seo_validate_parents()` /home/devvipiriscom/www/app/addons/seo/func.php:1149 `db_get_hash_single_array()` /home/devvipiriscom/www/app/addons/seo/func.php:1184 `Tygh\Database\Connection::getSingleHash()` /home/devvipiriscom/www/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:572	0.00020	Re-run Backtrace
14	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_companies AS companies ON storefronts.storefront_id = companies.storefront_id WHERE 1 = 1 AND (companies.company_id IN ('1') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_url()` /home/devvipiriscom/www/app/addons/seo/func.php:847 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.common.php:3869 `fn_ult_url_before_get_storefront_location()` /home/devvipiriscom/www/app/functions/fn.control.php:105 `fn_ult_bootstrap_company_storefront()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:1617 `Tygh\Storefront\Repository::findByCompanyId()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:4189 `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:224 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00010	Re-run Backtrace
15	SELECT name, path FROM vi_seo_names WHERE `object_id` = 174 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' AND vi_seo_names.company_id IN (0, 1) Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_url()` /home/devvipiriscom/www/app/addons/seo/func.php:847 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.common.php:3984 `fn_seo_url_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_seo_get_name()` /home/devvipiriscom/www/app/addons/seo/func.php:1645 `db_get_row()` /home/devvipiriscom/www/app/addons/seo/func.php:1375 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00013	Re-run Backtrace
16	SELECT name, path FROM vi_seo_names WHERE `object_id` = 166 AND `type` = 'c' AND `dispatch` = '' AND `lang_code` = 'en' AND vi_seo_names.company_id IN (0, 1) Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_url()` /home/devvipiriscom/www/app/addons/seo/func.php:847 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.common.php:3984 `fn_seo_url_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_seo_get_parent_items_path()` /home/devvipiriscom/www/app/addons/seo/func.php:1655 `fn_seo_get_name()` /home/devvipiriscom/www/app/addons/seo/func.php:1235 `db_get_row()` /home/devvipiriscom/www/app/addons/seo/func.php:1375 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00011	Re-run Backtrace
17	`SELECT redirect_id, src, type, object_id, dest, lang_code FROM vi_seo_redirects WHERE src = '/electronics/tv-and-video' AND ( vi_seo_redirects.company_id = 1 OR vi_seo_redirects.company_id = 0)` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_get_route()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:843 `fn_seo_get_route()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_row()` /home/devvipiriscom/www/app/addons/seo/func.php:876 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00012	Re-run Backtrace
18	SELECT companies.*, AVG(vi_discussion_rating.rating_value) AS average_rating, CONCAT(companies.company_id, '_', IF ( vi_discussion_rating.thread_id, vi_discussion_rating.thread_id, '0')) AS company_thread_ids FROM vi_companies AS companies LEFT JOIN vi_discussion ON vi_discussion.object_id = companies.company_id AND vi_discussion.object_type = 'M' LEFT JOIN vi_discussion_posts ON vi_discussion_posts.thread_id = vi_discussion.thread_id AND vi_discussion_posts.status = 'A' LEFT JOIN vi_discussion_rating ON vi_discussion.thread_id = vi_discussion_rating.thread_id AND vi_discussion_rating.post_id = vi_discussion_posts.post_id WHERE companies.company_id = 1 Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_company_data()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_get_company_data()` /home/devvipiriscom/www/app/functions/fn.init.php:296 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.companies.php:616 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00023	Re-run Backtrace
19	`SELECT a.object_id, COUNT(b.post_id) as total_items FROM vi_discussion as a LEFT JOIN vi_discussion_posts as b ON a.thread_id=b.thread_id WHERE a.object_type = 'M' AND b.status = 'A' GROUP BY a.object_id` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_company_data()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_get_company_data()` /home/devvipiriscom/www/app/functions/fn.init.php:296 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.companies.php:648 `fn_discussion_get_company_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_array()` /home/devvipiriscom/www/app/addons/discussion/func.php:1504 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00016	Re-run Backtrace
20	`SELECT vi_bm_layouts.* FROM vi_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'abt__unitheme2' AND storefront_id = 1` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_layout()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `Tygh\BlockManager\Layout::getDefault()` /home/devvipiriscom/www/app/functions/fn.init.php:646 `db_get_row()` /home/devvipiriscom/www/app/Tygh/BlockManager/Layout.php:94 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00012	Re-run Backtrace
21	`SELECT data FROM vi_storage_data WHERE data_key = 'cart_products_next_check'` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_user()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `fn_login_user()` /home/devvipiriscom/www/app/functions/fn.init.php:717 `fn_init_user()` /home/devvipiriscom/www/app/functions/fn.users.php:3584 `fn_is_expired_storage_data()` /home/devvipiriscom/www/app/functions/fn.init.php:749 `fn_get_storage_data()` /home/devvipiriscom/www/app/functions/fn.control.php:1102 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.control.php:1084 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00009	Re-run Backtrace
22	`SELECT data FROM vi_storage_data WHERE data_key = 'dev_mode'` Backtrace `require()` /home/devvipiriscom/www/index.php:18 `fn_init()` /home/devvipiriscom/www/init.php:195 `fn_init_templater()` /home/devvipiriscom/www/app/functions/fn.init.php:1200 `Tygh\Development::isEnabled()` /home/devvipiriscom/www/app/functions/fn.init.php:87 `Tygh\Development::read()` /home/devvipiriscom/www/app/Tygh/Development.php:28 `fn_get_storage_data()` /home/devvipiriscom/www/app/Tygh/Development.php:81 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.control.php:1084 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00007	Re-run Backtrace
23	SELECT vi_payments., vi_payment_descriptions., IF (ISNULL(vi_addons.status), "A", vi_addons.status) AS processor_status, vi_payment_processors.type AS processor_type, vi_payment_processors.processor_script AS processor_script FROM vi_payments LEFT JOIN vi_payment_descriptions ON vi_payment_descriptions.payment_id = vi_payments.payment_id AND vi_payment_descriptions.lang_code = 'en' LEFT JOIN vi_payment_processors ON vi_payment_processors.processor_id = vi_payments.processor_id LEFT JOIN vi_addons ON vi_payment_processors.addon = vi_addons.addon LEFT JOIN vi_storefronts_payments AS storefronts_payments ON storefronts_payments.payment_id = vi_payments.payment_id WHERE vi_payments.status = 'A' AND (storefronts_payments.storefront_id = 1 OR storefronts_payments.storefront_id IS NULL) AND vi_payment_processors.processor_script IN ('stripe.php') HAVING processor_status = 'A' ORDER BY vi_payments.position Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.control.php:441 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\Stripe\HookHandlers\DispatchHookHandler::onDispatchAssignTemplate()` `Tygh\Addons\Stripe\ServiceProvider::getPaymentMethodIcons()` /home/devvipiriscom/www/app/addons/stripe/src/HookHandlers/DispatchHookHandler.php:46 `Tygh\Addons\Stripe\ServiceProvider::getPaymentButtons()` /home/devvipiriscom/www/app/addons/stripe/src/ServiceProvider.php:120 `call_user_func()` /home/devvipiriscom/www/app/addons/stripe/src/ServiceProvider.php:108 `Tygh\Addons\Stripe\ServiceProvider::Tygh\Addons\Stripe\{closure}()` `Tygh\Addons\Stripe\PaymentButton\DataLoader::getSupportedPayments()` /home/devvipiriscom/www/app/addons/stripe/src/ServiceProvider.php:76 `fn_get_payments()` /home/devvipiriscom/www/app/addons/stripe/src/PaymentButton/DataLoader.php:63 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.cart.php:648 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00044	Re-run Backtrace
24	`SELECT * FROM vi_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 2` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `Tygh\BlockManager\Location::instance()` /home/devvipiriscom/www/app/controllers/frontend/init.php:142 `Tygh\BlockManager\Layout::get()` /home/devvipiriscom/www/app/Tygh/BlockManager/Location.php:483 `db_get_row()` /home/devvipiriscom/www/app/Tygh/BlockManager/Layout.php:61 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00009	Re-run Backtrace
25	`SELECT * FROM vi_bm_locations as l LEFT JOIN vi_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 2 AND l.dispatch IN ('categories.view') AND (FIND_IN_SET(174, l.object_ids) OR l.object_ids = '') ORDER BY l.object_ids desc LIMIT 1` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `Tygh\BlockManager\Location::get()` /home/devvipiriscom/www/app/controllers/frontend/init.php:142 `Tygh\BlockManager\Location::getList()` /home/devvipiriscom/www/app/Tygh/BlockManager/Location.php:164 `db_get_hash_array()` /home/devvipiriscom/www/app/Tygh/BlockManager/Location.php:104 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00018	Re-run Backtrace
26	`SELECT data FROM vi_storage_data WHERE data_key = 'cache_id'` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_storage_data()` /home/devvipiriscom/www/app/controllers/frontend/init.php:146 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.control.php:1084 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00008	Re-run Backtrace
27	`SELECT * FROM vi_hybrid_auth_providers WHERE 1 AND company_id = 1 AND status = 'A' ORDER BY position` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_hybrid_auth_get_providers_list()` /home/devvipiriscom/www/app/addons/hybrid_auth/controllers/frontend/init.post.php:17 `Tygh\Registry::getOrSetCache()` /home/devvipiriscom/www/app/addons/hybrid_auth/func.php:181 `{closure}()` /home/devvipiriscom/www/app/Tygh/Registry.php:800 `db_get_hash_array()` /home/devvipiriscom/www/app/addons/hybrid_auth/func.php:196 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00009	Re-run Backtrace
28	`SELECT category_id FROM vi_categories WHERE category_id = 174 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND vi_categories.company_id = 1` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `db_get_field()` /home/devvipiriscom/www/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:32 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00014	Re-run Backtrace
29	`SELECT default_view, selected_views FROM vi_categories WHERE category_id = 174` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products_layout()` /home/devvipiriscom/www/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:34 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.products.php:2874 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00010	Re-run Backtrace
30	`SELECT default_view_desktop FROM vi_categories WHERE category_id=174 AND selected_views !=""` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products_layout()` /home/devvipiriscom/www/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:34 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:2907 `fn_abt__unitheme2_get_products_layout_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_field()` /home/devvipiriscom/www/app/addons/abt__unitheme2/func.php:721 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00007	Re-run Backtrace
31	`SELECT id_path FROM vi_categories WHERE category_id = 174` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_ab__cb_pick_banner_by_cid()` /home/devvipiriscom/www/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35 `fn_ab__get_category_banners()` /home/devvipiriscom/www/app/addons/ab__category_banners/func.php:247 `db_get_field()` /home/devvipiriscom/www/app/addons/ab__category_banners/func.php:142 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00007	Re-run Backtrace
32	SELECT vi_ab__category_banners., vi_ab__category_banner_images_and_descr.category_banner, vi_ab__category_banner_images_and_descr.url, vi_ab__category_banner_images_and_descr.category_banner_image_id, layout_data. FROM vi_ab__category_banners INNER JOIN vi_ab__category_banner_images_and_descr ON vi_ab__category_banner_images_and_descr.category_banner_id = vi_ab__category_banners.category_banner_id AND vi_ab__category_banner_images_and_descr.lang_code = 'en' LEFT JOIN vi_ab__category_banner_categories AS ab__category_banner_categories ON ab__category_banner_categories.category_banner_id = vi_ab__category_banners.category_banner_id LEFT JOIN vi_ab__category_banner_categories AS ab__category_banner_categories1 ON ab__category_banner_categories1.category_banner_id = vi_ab__category_banners.category_banner_id LEFT JOIN vi_images_links AS il ON il.object_type = 'category_banner' AND il.object_id = vi_ab__category_banner_images_and_descr.category_banner_image_id AND il.type = 'M' LEFT JOIN vi_ab__category_banners_layout_data AS layout_data ON layout_data.category_banner_id = vi_ab__category_banners.category_banner_id WHERE 1 AND vi_ab__category_banners.status = 'A' AND vi_ab__category_banner_images_and_descr.category_banner_image_id IS NOT NULL AND vi_ab__category_banners.company_id = 1 AND (IF(vi_ab__category_banners.from_date, vi_ab__category_banners.from_date <= 1776432263, 1) AND IF(vi_ab__category_banners.to_date, vi_ab__category_banners.to_date >= 1776432263, 1)) AND (ab__category_banner_categories.category_id = 174 OR (ab__category_banner_categories1.category_id IN (166, 174) AND vi_ab__category_banners.include_subcategories = 'Y')) AND IF(layout_data.products_multicolumns_type = 'B', layout_data.products_multicolumns_block_id > 0,il.pair_id IS NOT NULL) = 1 ORDER BY vi_ab__category_banner_images_and_descr.category_banner asc Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_ab__cb_pick_banner_by_cid()` /home/devvipiriscom/www/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35 `fn_ab__get_category_banners()` /home/devvipiriscom/www/app/addons/ab__category_banners/func.php:247 `db_get_hash_array()` /home/devvipiriscom/www/app/addons/ab__category_banners/func.php:184 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00057	Re-run Backtrace
33	SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category_banner' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (1, 9) ORDER BY vi_images_links.position, vi_images_links.pair_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_ab__cb_pick_banner_by_cid()` /home/devvipiriscom/www/app/addons/ab__category_banners/controllers/frontend/categories.pre.php:35 `fn_ab__get_category_banners()` /home/devvipiriscom/www/app/addons/ab__category_banners/func.php:247 `fn_get_image_pairs()` /home/devvipiriscom/www/app/addons/ab__category_banners/func.php:199 `db_multi_query()` /home/devvipiriscom/www/app/functions/fn.images.php:350 `Tygh\Database\Connection::multiQuery()` /home/devvipiriscom/www/app/functions/fn.database.php:168	0.00027	Re-run Backtrace
34	`SELECT usergroup_ids FROM vi_categories WHERE category_id = 174` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `db_get_field()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:38 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00009	Re-run Backtrace
35	`SELECT category_id FROM vi_categories WHERE category_id = 174 AND (usergroup_ids = '' OR FIND_IN_SET(0, usergroup_ids) OR FIND_IN_SET(1, usergroup_ids)) AND status IN ('A', 'H') AND vi_categories.storefront_id IN (0, 1)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `db_get_field()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:57 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00010	Re-run Backtrace
36	`SELECT id_path FROM vi_categories WHERE category_id = 174` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_subcategories()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/devvipiriscom/www/app/functions/fn.categories.php:61 `db_get_field()` /home/devvipiriscom/www/app/functions/fn.categories.php:351 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00007	Re-run Backtrace
37	SELECT vi_categories.category_id,vi_categories.parent_id,vi_categories.id_path,vi_category_descriptions.category,vi_categories.position,vi_categories.status,vi_categories.company_id,vi_categories.storefront_id,vi_categories.company_id,vi_seo_names.name as seo_name,vi_seo_names.path as seo_path,vi_categories.ab__lc_catalog_image_control,vi_categories.ab__fn_category_status,vi_categories.ab__fn_label_color,vi_categories.ab__fn_label_background,vi_categories.ab__fn_use_origin_image,vi_category_descriptions.ab__fn_label_text,vi_category_descriptions.ab__fn_label_show FROM vi_categories LEFT JOIN vi_category_descriptions ON vi_categories.category_id = vi_category_descriptions.category_id AND vi_category_descriptions.lang_code = 'en' LEFT JOIN vi_seo_names ON vi_seo_names.object_id = vi_categories.category_id AND vi_seo_names.type = 'c' AND vi_seo_names.dispatch = '' AND vi_seo_names.lang_code = 'en' AND vi_seo_names.company_id = vi_categories.company_id WHERE 1=1 AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A') AND vi_categories.parent_id IN (174) AND vi_categories.id_path LIKE '166/174/%' AND vi_categories.storefront_id IN (0, 1) AND vi_categories.company_id = 1 ORDER BY vi_categories.is_trash asc, vi_categories.position asc, vi_category_descriptions.category asc Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_subcategories()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/devvipiriscom/www/app/functions/fn.categories.php:61 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.categories.php:440 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00037	Re-run Backtrace
38	`SELECT category_id, parent_id FROM vi_categories WHERE parent_id IN(190, 191, 193, 194, 195)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_subcategories()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/devvipiriscom/www/app/functions/fn.categories.php:61 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.categories.php:484 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00008	Re-run Backtrace
39	SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (190, 191, 193, 194, 195) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (190, 191, 193, 194, 195) ORDER BY vi_images_links.position, vi_images_links.pair_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_subcategories()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:74 `fn_get_categories()` /home/devvipiriscom/www/app/functions/fn.categories.php:61 `fn_get_image_pairs()` /home/devvipiriscom/www/app/functions/fn.categories.php:547 `db_multi_query()` /home/devvipiriscom/www/app/functions/fn.images.php:350 `Tygh\Database\Connection::multiQuery()` /home/devvipiriscom/www/app/functions/fn.database.php:168	0.00019	Re-run Backtrace
40	SELECT *, vi_seo_names.name as seo_name, vi_seo_names.path as seo_path FROM vi_categories LEFT JOIN vi_category_descriptions ON vi_category_descriptions.category_id = vi_categories.category_id AND vi_category_descriptions.lang_code = 'en' LEFT JOIN vi_seo_names ON vi_seo_names.object_id = 174 AND vi_seo_names.type = 'c' AND vi_seo_names.dispatch = '' AND vi_seo_names.lang_code = 'en' AND vi_seo_names.company_id = vi_categories.company_id WHERE vi_categories.category_id = 174 AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.company_id = 1 Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_category_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:77 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.categories.php:800 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00018	Re-run Backtrace
41	SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id = '174' ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'category' AND vi_images_links.type = 'M' AND vi_images_links.object_id = '174' ORDER BY vi_images_links.position, vi_images_links.pair_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_category_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:77 `fn_get_image_pairs()` /home/devvipiriscom/www/app/functions/fn.categories.php:818 `db_multi_query()` /home/devvipiriscom/www/app/functions/fn.images.php:350 `Tygh\Database\Connection::multiQuery()` /home/devvipiriscom/www/app/functions/fn.database.php:168	0.00027	Re-run Backtrace
42	`SELECT search_phrases FROM vi_ab__search_motivation WHERE category_id = 174 AND lang_code = 'en'` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_category_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:77 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.categories.php:856 `fn_ab__search_motivation_get_category_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_field()` /home/devvipiriscom/www/app/addons/ab__search_motivation/func.php:31 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00008	Re-run Backtrace
43	`SELECT a.category_id FROM vi_categories as a LEFT JOIN vi_categories as b ON b.category_id IN (174) WHERE a.id_path LIKE CONCAT(b.id_path, '/%')` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `db_get_fields()` /home/devvipiriscom/www/app/functions/fn.products.php:1943 `Tygh\Database\Connection::getColumn()` /home/devvipiriscom/www/app/functions/fn.database.php:85 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:480	0.00013	Re-run Backtrace
44	SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id FROM vi_products as products LEFT JOIN vi_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN vi_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN vi_companies AS companies ON companies.company_id = products.company_id INNER JOIN vi_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN vi_categories ON vi_categories.category_id = products_categories.category_id AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A', 'H') AND vi_categories.storefront_id IN (0, 1) LEFT JOIN vi_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = 'en' WHERE 1 AND vi_categories.category_id IN (174, 190, 191, 194, 193, 195) AND companies.status IN ('A') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.parent_product_id = 0 GROUP BY products.product_id ORDER BY product asc, products.product_id ASC LIMIT 0, 18 Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `{closure}()` /home/devvipiriscom/www/app/functions/fn.products.php:2459 `db_get_array()` /home/devvipiriscom/www/app/functions/fn.products.php:2383 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00061	Re-run Backtrace
45	`SELECT FOUND_ROWS()` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `{closure}()` /home/devvipiriscom/www/app/functions/fn.products.php:2459 `db_get_found_rows()` /home/devvipiriscom/www/app/functions/fn.products.php:2386 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:332 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00005	Re-run Backtrace
46	`SELECT vi_products.* FROM vi_products WHERE vi_products.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00022	Re-run Backtrace
47	`SELECT vi_product_prices.product_id, MIN(IF(vi_product_prices.percentage_discount = 0,vi_product_prices.price,vi_product_prices.price - (vi_product_prices.price * vi_product_prices.percentage_discount)/100)) AS price FROM vi_product_prices WHERE vi_product_prices.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_product_prices.lower_limit = 1 AND vi_product_prices.usergroup_id IN (0, 1) GROUP BY vi_product_prices.product_id` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00034	Re-run Backtrace
48	SELECT vi_product_descriptions.product_id, vi_product_descriptions.short_description, IF(vi_product_descriptions.short_description = '' OR vi_product_descriptions.short_description IS NULL, vi_product_descriptions.full_description, '') AS full_description, vi_product_descriptions.meta_keywords, vi_product_descriptions.meta_description, vi_product_descriptions.search_words, vi_product_descriptions.promo_text, vi_product_descriptions.unit_name FROM vi_product_descriptions WHERE vi_product_descriptions.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_product_descriptions.lang_code = 'en' Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00017	Re-run Backtrace
49	SELECT vi_products_categories.product_id, GROUP_CONCAT(IF(vi_products_categories.link_type = "M", CONCAT(vi_products_categories.category_id, "M"), vi_products_categories.category_id)) AS category_ids, product_position_source.position AS position FROM vi_products_categories INNER JOIN vi_categories ON vi_categories.category_id = vi_products_categories.category_id AND vi_categories.storefront_id IN (0, 1) AND (vi_categories.usergroup_ids = '' OR FIND_IN_SET(0, vi_categories.usergroup_ids) OR FIND_IN_SET(1, vi_categories.usergroup_ids)) AND vi_categories.status IN ('A', 'H') LEFT JOIN vi_products_categories AS product_position_source ON vi_products_categories.product_id = product_position_source.product_id AND product_position_source.category_id = 174 WHERE vi_products_categories.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) GROUP BY vi_products_categories.product_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00024	Re-run Backtrace
50	SELECT vi_ult_product_descriptions.product_id, vi_ult_product_descriptions.short_description, IF(vi_ult_product_descriptions.short_description = "", vi_ult_product_descriptions.full_description, "") AS full_description, vi_ult_product_descriptions.meta_keywords, vi_ult_product_descriptions.meta_description, vi_ult_product_descriptions.search_words, vi_ult_product_descriptions.promo_text FROM vi_ult_product_descriptions WHERE vi_ult_product_descriptions.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_ult_product_descriptions.company_id = 1 AND vi_ult_product_descriptions.lang_code = 'en' Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00009	Re-run Backtrace
51	`SELECT vi_seo_names.object_id AS product_id, vi_seo_names.name AS seo_name, vi_seo_names.path AS seo_path FROM vi_seo_names WHERE vi_seo_names.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_seo_names.type = "p" AND vi_seo_names.dispatch = "" AND vi_seo_names.lang_code = 'en' AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00017	Re-run Backtrace
52	`SELECT vi_product_review_prepared_data.product_id AS product_id, vi_product_review_prepared_data.average_rating AS average_rating, vi_product_review_prepared_data.reviews_count AS reviews_count FROM vi_product_review_prepared_data WHERE vi_product_review_prepared_data.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_product_review_prepared_data.storefront_id = 0` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.products.php:2678 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00008	Re-run Backtrace
53	SELECT vi_ult_product_prices.product_id, MIN(IF(vi_ult_product_prices.percentage_discount = 0,vi_ult_product_prices.price,vi_ult_product_prices.price - (vi_ult_product_prices.price * vi_ult_product_prices.percentage_discount)/100)) AS price FROM vi_ult_product_prices WHERE vi_ult_product_prices.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND vi_ult_product_prices.lower_limit = 1 AND vi_ult_product_prices.company_id = 1 AND vi_ult_product_prices.usergroup_id IN (0, 0, 1) GROUP BY vi_ult_product_prices.product_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_load_products_extra_data()` /home/devvipiriscom/www/app/functions/fn.products.php:2483 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:2702 `fn_ult_load_products_extra_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:105 `fn_load_extra_data_by_entity_ids()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:349 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.common.php:8944 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00009	Re-run Backtrace
54	`SELECT video_id, product_id FROM vi_ab__video_gallery WHERE product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND status = 'A' AND storefront_id IN (1, 0)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:2496 `fn_ab__video_gallery_get_products_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_hash_array()` /home/devvipiriscom/www/app/addons/ab__video_gallery/func.php:248 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00006	Re-run Backtrace
55	`SELECT p.product_id,ifnull(count(dp.post_id),0) as discussion_amount_posts FROM vi_discussion INNER JOIN vi_products as p ON (vi_discussion.object_id=p.product_id) INNER JOIN vi_discussion_posts as dp ON (vi_discussion.thread_id=dp.thread_id AND vi_discussion.object_type='P' AND vi_discussion.company_id = 1) WHERE dp.status='A' and p.product_id in (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) GROUP BY p.product_id` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_get_products()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:115 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:2496 `fn_abt__unitheme2_get_products_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_hash_single_array()` /home/devvipiriscom/www/app/addons/abt__unitheme2/func.php:376 `Tygh\Database\Connection::getSingleHash()` /home/devvipiriscom/www/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:572	0.00017	Re-run Backtrace
56	SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_get_image_pairs()` /home/devvipiriscom/www/app/functions/fn.products.php:636 `db_multi_query()` /home/devvipiriscom/www/app/functions/fn.images.php:350 `Tygh\Database\Connection::multiQuery()` /home/devvipiriscom/www/app/functions/fn.database.php:168	0.00069	Re-run Backtrace
57	SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'A' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'product' AND vi_images_links.type = 'A' AND vi_images_links.object_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) ORDER BY vi_images_links.position, vi_images_links.pair_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_get_image_pairs()` /home/devvipiriscom/www/app/functions/fn.products.php:640 `db_multi_query()` /home/devvipiriscom/www/app/functions/fn.images.php:350 `Tygh\Database\Connection::multiQuery()` /home/devvipiriscom/www/app/functions/fn.database.php:168	0.00032	Re-run Backtrace
58	SELECT a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM vi_product_options as a LEFT JOIN vi_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = a.option_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_options') WHERE a.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND a.status = 'A' ORDER BY a.position Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_get_product_options()` /home/devvipiriscom/www/app/functions/fn.products.php:644 `db_get_hash_multi_array()` /home/devvipiriscom/www/app/functions/fn.options.php:240 `Tygh\Database\Connection::getMultiHash()` /home/devvipiriscom/www/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:526	0.00020	Re-run Backtrace
59	SELECT c.product_id AS cur_product_id, a.*, b.option_name, b.internal_option_name, b.option_text, b.description, b.inner_hint, b.incorrect_message, b.comment FROM vi_product_options as a LEFT JOIN vi_product_options_descriptions as b ON a.option_id = b.option_id AND b.lang_code = 'en' LEFT JOIN vi_product_global_option_links as c ON c.option_id = a.option_id INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = a.option_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_options') WHERE c.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21) AND a.product_id = 0 AND a.status = 'A' ORDER BY a.position Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_get_product_options()` /home/devvipiriscom/www/app/functions/fn.products.php:644 `db_get_hash_multi_array()` /home/devvipiriscom/www/app/functions/fn.options.php:250 `Tygh\Database\Connection::getMultiHash()` /home/devvipiriscom/www/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:526	0.00022	Re-run Backtrace
60	`SELECT vi_languages.* FROM vi_languages LEFT JOIN vi_storefronts_languages AS storefronts_languages ON storefronts_languages.language_id = vi_languages.lang_id WHERE 1 AND (storefronts_languages.storefront_id = 1 OR storefronts_languages.storefront_id IS NULL)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `db_get_hash_array()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:134 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00011	Re-run Backtrace
61	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('1') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00010	Re-run Backtrace
62	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('2') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00008	Re-run Backtrace
63	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('3') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00007	Re-run Backtrace
64	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('4') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00008	Re-run Backtrace
65	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('5') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00007	Re-run Backtrace
66	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('6') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00008	Re-run Backtrace
67	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('7') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00006	Re-run Backtrace
68	`SELECT storefronts.* FROM vi_storefronts AS storefronts LEFT JOIN vi_storefronts_languages AS languages ON storefronts.storefront_id = languages.storefront_id WHERE 1 = 1 AND (languages.language_id IN ('8') ) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\ServiceProvider::getProductRepository()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:313 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:166 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Addons\ProductVariations\ServiceProvider::Tygh\Addons\ProductVariations\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/addons/product_variations/src/ServiceProvider.php:69 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `Tygh\Languages\Languages::getAll()` /home/devvipiriscom/www/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:135 `Tygh\Languages\Languages::attachStorefrontIds()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1681 `array_walk()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1737 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/devvipiriscom/www/app/Tygh/Languages/Languages.php:1742 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/Tygh/Storefront/Repository.php:381 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00006	Re-run Backtrace
69	`SELECT f.feature_id, f.purpose, p.product_id, p.parent_product_id, g.id, g.code FROM vi_product_variation_group_features AS f INNER JOIN vi_product_variation_groups AS g ON f.group_id = g.id INNER JOIN vi_product_variation_group_products AS p ON f.group_id = p.group_id WHERE p.product_id IN (18, 16, 4, 5, 23, 24, 1, 22, 25, 6, 8, 14, 9, 10, 19, 21)` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:669 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `call_user_func_array()` /home/devvipiriscom/www/app/Tygh/Addons/Loader.php:142 `Tygh\Addons\ProductVariations\HookHandlers\ProductsHookHandler::onGatherAdditionalProductsDataParams()` `Tygh\Addons\ProductVariations\Product\Repository::loadProductsGroupInfo()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/ProductsHookHandler.php:316 `Tygh\Addons\ProductVariations\Product\Group\Repository::findGroupInfoByProductIds()` /home/devvipiriscom/www/app/addons/product_variations/src/Product/Repository.php:448 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/devvipiriscom/www/app/addons/product_variations/src/Product/Group/Repository.php:355 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/addons/product_variations/src/Tools/Query.php:308 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00014	Re-run Backtrace
70	SELECT p.promotion_id, p.from_date, p.to_date, active.from_date AS active_from_date, active.to_date AS active_to_date, expired.from_date AS expired_from_date, expired.to_date AS expired_to_date FROM vi_promotions AS p INNER JOIN vi_ab__dotd AS ab__dotd ON p.promotion_id=ab__dotd.promotion_id AND ab__dotd.use_schedule='Y' LEFT JOIN (SELECT promotion_id,MIN(from_date) AS from_date,MIN(to_date) AS to_date FROM vi_ab__dotd_periods WHERE to_date >= 1776432263 GROUP BY promotion_id) AS active ON active.promotion_id=p.promotion_id LEFT JOIN (SELECT promotion_id,MAX(from_date) AS from_date,MAX(to_date) AS to_date FROM vi_ab__dotd_periods WHERE to_date < 1776432263 GROUP BY promotion_id) AS expired ON expired.promotion_id=p.promotion_id WHERE p.status IN ('A', 'H') Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_promotion_apply()` /home/devvipiriscom/www/app/functions/fn.products.php:810 `fn_get_promotions()` /home/devvipiriscom/www/app/functions/fn.promotions.php:277 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.promotions.php:166 `fn_ab__deal_of_the_day_get_promotions()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__dotd_rebuild_promotions_periods()` /home/devvipiriscom/www/app/addons/ab__deal_of_the_day/func.php:91 `db_get_array()` /home/devvipiriscom/www/app/addons/ab__deal_of_the_day/func.php:374 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00016	Re-run Backtrace
71	SELECT vi_promotions.*, vi_promotion_descriptions.name, vi_promotion_descriptions.detailed_description, vi_promotion_descriptions.short_description FROM vi_promotions LEFT JOIN vi_promotion_descriptions ON vi_promotion_descriptions.promotion_id = vi_promotions.promotion_id AND vi_promotion_descriptions.lang_code = 'en' LEFT JOIN vi_storefronts_promotions AS storefronts_promotions ON storefronts_promotions.promotion_id = vi_promotions.promotion_id WHERE 1 AND IF(from_date, from_date <= 1776432263, 1) AND IF(to_date, to_date >= 1776432263, 1) AND status IN ('A', 'H') AND vi_promotions.zone = 'catalog' AND (storefronts_promotions.storefront_id = 1 OR storefronts_promotions.storefront_id IS NULL) ORDER BY vi_promotions.stop_other_rules desc, vi_promotions.priority asc Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_promotion_apply()` /home/devvipiriscom/www/app/functions/fn.products.php:810 `fn_get_promotions()` /home/devvipiriscom/www/app/functions/fn.promotions.php:277 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.promotions.php:193 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00026	Re-run Backtrace
72	SELECT vi_ab__stickers., descriptions., images.image_id, vi_ab__stickers.sticker_id as sticker_id FROM vi_ab__stickers LEFT JOIN vi_ab__sticker_descriptions as descriptions ON vi_ab__stickers.sticker_id = descriptions.sticker_id AND descriptions.lang_code = 'en' LEFT JOIN vi_ab__sticker_images AS images ON vi_ab__stickers.sticker_id = images.sticker_id AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND vi_ab__stickers.status = 'A' AND ((vi_ab__stickers.from_date <= 1776409200 OR vi_ab__stickers.from_date = 0) AND (vi_ab__stickers.to_date >= 1776409200 OR vi_ab__stickers.to_date = 0)) AND vi_ab__stickers.sticker_id IN (0) AND REPLACE(REPLACE(vi_ab__stickers.display_place, "/", ""), "\\", "") NOT LIKE '%"blocksproductsproducts_multicolumns.tpl":"not_display"%' AND (vi_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, vi_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, vi_ab__stickers.usergroup_ids)) ORDER BY vi_ab__stickers.position asc Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `Tygh\Addons\Ab_stickers\StickersRepository::find()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:109 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/addons/ab__stickers/Tygh/Addons/Ab_stickers/StickersRepository.php:260 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00019	Re-run Backtrace
73	SELECT vi_ab__stickers., descriptions., images.image_id, vi_ab__stickers.sticker_id as sticker_id FROM vi_ab__stickers LEFT JOIN vi_ab__sticker_descriptions as descriptions ON vi_ab__stickers.sticker_id = descriptions.sticker_id AND descriptions.lang_code = 'en' LEFT JOIN vi_ab__sticker_images AS images ON vi_ab__stickers.sticker_id = images.sticker_id AND images.lang_code = 'en' WHERE FIND_IN_SET (1, storefront_ids) AND vi_ab__stickers.status = 'A' AND ((vi_ab__stickers.from_date <= 1776409200 OR vi_ab__stickers.from_date = 0) AND (vi_ab__stickers.to_date >= 1776409200 OR vi_ab__stickers.to_date = 0)) AND ((0) OR vi_ab__stickers.type = 'D') AND REPLACE(REPLACE(vi_ab__stickers.display_place, "/", ""), "\\", "") NOT LIKE '%"blocksproductsproducts_multicolumns.tpl":"not_display"%' AND (vi_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, vi_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, vi_ab__stickers.usergroup_ids)) ORDER BY vi_ab__stickers.position asc Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `Tygh\Addons\Ab_stickers\StickersRepository::find()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:116 `Tygh\Database\Connection::getHash()` /home/devvipiriscom/www/app/addons/ab__stickers/Tygh/Addons/Ab_stickers/StickersRepository.php:260 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:371	0.00033	Re-run Backtrace
74	SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.image_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'ab__stickers' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (193) ORDER BY vi_images_links.position, vi_images_links.pair_id;SELECT vi_images., vi_images_links., vi_common_descriptions.description AS alt, vi_images.image_id AS images_image_id FROM vi_images_links LEFT JOIN vi_images ON vi_images_links.detailed_id = vi_images.image_id LEFT JOIN vi_common_descriptions ON vi_common_descriptions.object_id = vi_images.image_id AND vi_common_descriptions.object_holder = 'images' AND vi_common_descriptions.lang_code = 'en' WHERE vi_images_links.object_type = 'ab__stickers' AND vi_images_links.type = 'M' AND vi_images_links.object_id IN (193) ORDER BY vi_images_links.position, vi_images_links.pair_id Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `Tygh\Addons\Ab_stickers\StickersRepository::find()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:116 `fn_get_image_pairs()` /home/devvipiriscom/www/app/addons/ab__stickers/Tygh/Addons/Ab_stickers/StickersRepository.php:273 `db_multi_query()` /home/devvipiriscom/www/app/functions/fn.images.php:350 `Tygh\Database\Connection::multiQuery()` /home/devvipiriscom/www/app/functions/fn.database.php:168	0.00024	Re-run Backtrace
75	`SELECT object_id, thread_id, type, object_type, company_id FROM vi_discussion WHERE 1 AND object_id = 18 AND object_type = 'P' AND vi_discussion.company_id = 1` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `db_get_row()` /home/devvipiriscom/www/app/addons/discussion/func.php:248 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00008	Re-run Backtrace
76	`SELECT object_id, thread_id, type, object_type, company_id FROM vi_discussion WHERE 1 AND object_id = 16 AND object_type = 'P' AND vi_discussion.company_id = 1` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `db_get_row()` /home/devvipiriscom/www/app/addons/discussion/func.php:248 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00007	Re-run Backtrace
77	`SELECT thread_id, type, object_type, object_id FROM vi_discussion WHERE thread_id = 4 AND vi_discussion.company_id = 1` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `fn_get_discussion_posts()` /home/devvipiriscom/www/app/addons/discussion/func.php:298 `db_get_row()` /home/devvipiriscom/www/app/addons/discussion/func.php:351 `Tygh\Database\Connection::getRow()` /home/devvipiriscom/www/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:414	0.00005	Re-run Backtrace
78	`SELECT COUNT(*) FROM vi_discussion_posts LEFT JOIN vi_discussion_messages ON vi_discussion_messages.post_id = vi_discussion_posts.post_id LEFT JOIN vi_discussion_rating ON vi_discussion_rating.post_id = vi_discussion_posts.post_id WHERE vi_discussion_posts.thread_id = 4 AND vi_discussion_posts.status = 'A'` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `fn_get_discussion_posts()` /home/devvipiriscom/www/app/addons/discussion/func.php:298 `db_get_field()` /home/devvipiriscom/www/app/addons/discussion/func.php:392 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:448	0.00009	Re-run Backtrace
79	`SELECT vi_discussion_rating.rating_value, COUNT(vi_discussion_rating.post_id) as qty FROM vi_discussion_posts LEFT JOIN vi_discussion_messages ON vi_discussion_messages.post_id = vi_discussion_posts.post_id LEFT JOIN vi_discussion_rating ON vi_discussion_rating.post_id = vi_discussion_posts.post_id WHERE vi_discussion_posts.thread_id = 4 AND vi_discussion_posts.status = 'A' GROUP BY vi_discussion_rating.rating_value` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `fn_get_discussion_posts()` /home/devvipiriscom/www/app/addons/discussion/func.php:298 `fn_set_hook()` /home/devvipiriscom/www/app/addons/discussion/func.php:411 `fn_abt__unitheme2_get_discussion_posts()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_array()` /home/devvipiriscom/www/app/addons/abt__unitheme2/functions/fn.abt__ut2_discussion.php:25 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00010	Re-run Backtrace
80	`SELECT vi_discussion_posts.* , vi_discussion_messages.message, vi_discussion_rating.rating_value FROM vi_discussion_posts LEFT JOIN vi_discussion_messages ON vi_discussion_messages.post_id = vi_discussion_posts.post_id LEFT JOIN vi_discussion_rating ON vi_discussion_rating.post_id = vi_discussion_posts.post_id WHERE vi_discussion_posts.thread_id = 4 AND vi_discussion_posts.status = 'A' ORDER BY vi_discussion_posts.timestamp DESC LIMIT 0, 10` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `fn_get_discussion_posts()` /home/devvipiriscom/www/app/addons/discussion/func.php:298 `db_get_array()` /home/devvipiriscom/www/app/addons/discussion/func.php:413 `Tygh\Database\Connection::getArray()` /home/devvipiriscom/www/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:333	0.00010	Re-run Backtrace
81	`SELECT AVG (dr.rating_value) FROM vi_discussion_rating AS dr LEFT JOIN vi_discussion_posts AS dp ON dp.post_id = dr.post_id LEFT JOIN vi_discussion AS d ON d.thread_id = dp.thread_id WHERE d.object_id = 16 AND d.object_type = 'P' AND type IN ( 'B', 'R' ) AND d.company_id = 1 AND dp.status = 'A' AND dr.rating_value > 0` Backtrace `fn_dispatch()` /home/devvipiriscom/www/index.php:19 `fn_run_controller()` /home/devvipiriscom/www/app/functions/fn.control.php:460 `include()` /home/devvipiriscom/www/app/functions/fn.control.php:729 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/controllers/frontend/categories.php:121 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:893 `fn_ab__stickers_gather_additional_products_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_ab__stickers_validate_dynamic_sticker()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.hooks.php:152 `fn_ab__stickers_validate_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:39 `fn_ab__stickers_get_product_rating()` /home/devvipiriscom/www/app/addons/ab__stickers/functions/fn.dynamic_validation.php:125 `fn_get_discussion()` /home/devvipiriscom/www/app/addons/ab__stickers/func.php:520 `fn_discussion_get_average_object_rating()` /home/devvipiriscom/www/app/addons/discussion/func.php:300 `db_get_field()` /home/devvipiriscom/www/app/addons/discussion/func.php:965 `Tygh\Database\Connection::getField()` /home/devvipiriscom/www/app/functions/fn.database.php:73

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

Backtrace

Backtrace