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 = 'wildwood-city-classic'  AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)
SELECT * FROM vi_seo_names WHERE name = 'wildwood-city-classic'  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 ('sports-and-outdoors', 'bikes', 'comfort-and-cruisers') AND type = 'c' AND lang_code = 'en'  AND ( vi_seo_names.company_id = 1 OR vi_seo_names.company_id = 0)
SELECT product_id, parent_product_id FROM vi_product_variation_group_products WHERE product_id IN (150)
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` = 150 AND `type` = 'p' 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` = 203 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` = 204 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` = 210 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 = '/sports-and-outdoors/bikes/comfort-and-cruisers/wildwood-city-classic'  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 ('products.view') AND (FIND_IN_SET(150, l.object_ids) OR l.object_ids = '')  ORDER BY l.object_ids desc  LIMIT 1
SELECT product_id, location_id FROM vi_yl_vipiris_product_settings WHERE product_id = 150
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 usergroup_ids FROM vi_products WHERE product_id = 150
SELECT category_id FROM vi_products_categories WHERE product_id = 150 AND link_type = 'M'
SELECT vi_products.*, vi_product_descriptions.*, 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, GROUP_CONCAT( CASE   WHEN (vi_products_categories.link_type = 'M') THEN CONCAT(vi_products_categories.category_id, 'M')   ELSE vi_products_categories.category_id END ORDER BY vi_categories.storefront_id IN (0, 1) DESC, (vi_products_categories.link_type = 'M') DESC, vi_products_categories.category_position ASC, vi_products_categories.category_id ASC) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),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, companies.company as company_name, vi_product_sales.amount as sales_amount, vi_seo_names.name as seo_name, vi_seo_names.path as seo_path, MIN(point_prices.point_price) as point_price, vi_discussion.type as discussion_type, vi_product_review_prepared_data.average_rating average_rating, vi_product_review_prepared_data.reviews_count product_reviews_count FROM vi_products LEFT JOIN vi_product_prices ON vi_product_prices.product_id = vi_products.product_id AND vi_product_prices.lower_limit = 1  AND vi_product_prices.usergroup_id IN (0, 0, 1)  LEFT JOIN vi_product_descriptions ON vi_product_descriptions.product_id = vi_products.product_id AND vi_product_descriptions.lang_code = 'en' LEFT JOIN vi_ult_product_prices shared_prices ON shared_prices.product_id = vi_products.product_id AND shared_prices.company_id = 1 AND shared_prices.lower_limit = 1  AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN vi_companies as companies ON companies.company_id = vi_products.company_id INNER JOIN vi_products_categories ON vi_products_categories.product_id = vi_products.product_id 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_products.usergroup_ids = '' OR FIND_IN_SET(0, vi_products.usergroup_ids) OR FIND_IN_SET(1, vi_products.usergroup_ids)) AND vi_categories.status IN ('A', 'H') AND vi_products.status IN ('A', 'H') LEFT JOIN vi_product_popularity as popularity ON popularity.product_id = vi_products.product_id LEFT JOIN vi_product_sales ON vi_product_sales.product_id = vi_products.product_id AND vi_product_sales.category_id = 210 LEFT JOIN vi_seo_names ON vi_seo_names.object_id = 150 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 LEFT JOIN vi_product_point_prices as point_prices ON point_prices.product_id = vi_products.product_id AND point_prices.lower_limit = 1 AND point_prices.usergroup_id IN (0, 0, 1) LEFT JOIN vi_discussion ON vi_discussion.object_id = vi_products.product_id AND vi_discussion.object_type = 'P' AND vi_discussion.company_id = 1 LEFT JOIN vi_product_review_prepared_data ON vi_product_review_prepared_data.product_id = vi_products.product_id AND vi_product_review_prepared_data.storefront_id = 0 WHERE vi_products.product_id = 150  AND (companies.status IN ('A') OR vi_products.company_id = 0) GROUP BY vi_products.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 = 'A' AND vi_images_links.object_id = '150' 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 = '150' 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 = 'M' AND vi_images_links.object_id = '150' 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 = '150' ORDER BY vi_images_links.position, vi_images_links.pair_id
SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM vi_product_prices prices WHERE prices.product_id = 150  AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit
SELECT c.company_id FROM vi_products_categories pc LEFT JOIN vi_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 150  GROUP BY c.company_id LIMIT 2
SELECT id_path FROM vi_categories WHERE category_id IN (210)
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, vi_product_features_descriptions.description, vi_product_features_descriptions.internal_name, vi_product_features_descriptions.lang_code, vi_product_features_descriptions.prefix, vi_product_features_descriptions.suffix, pf.categories_path, vi_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_groups.position AS group_position, vi_product_features_values.value, vi_product_features_values.variant_id, vi_product_features_values.value_int, abt_filters.filter_id FROM vi_product_features AS pf  LEFT JOIN vi_product_features AS pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN vi_product_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN vi_product_features_descriptions ON vi_product_features_descriptions.feature_id = pf.feature_id AND vi_product_features_descriptions.lang_code = 'en' INNER JOIN vi_product_features_values ON vi_product_features_values.feature_id = pf.feature_id AND vi_product_features_values.product_id = 150 AND vi_product_features_values.lang_code = 'en' LEFT JOIN vi_product_filters AS abt_filters ON abt_filters.feature_id = pf.feature_id AND abt_filters.company_id = pf.company_id INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = pf.feature_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_features') WHERE 1=1  AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(203, pf.categories_path) OR FIND_IN_SET(204, pf.categories_path) OR FIND_IN_SET(210, pf.categories_path) ) GROUP BY pf.feature_id  ORDER BY group_position asc, pf_groups_description.description asc, pf_groups.feature_id asc, pf.position asc, vi_product_features_descriptions.description asc, pf.feature_id asc 
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, vi_product_features_descriptions.description, vi_product_features_descriptions.internal_name, vi_product_features_descriptions.lang_code, vi_product_features_descriptions.prefix, vi_product_features_descriptions.suffix, pf.categories_path, vi_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp FROM vi_product_features AS pf LEFT JOIN vi_product_features_descriptions ON vi_product_features_descriptions.feature_id = pf.feature_id AND vi_product_features_descriptions.lang_code = 'en' INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = pf.feature_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM vi_product_features))  AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(203, pf.categories_path) OR FIND_IN_SET(204, pf.categories_path) OR FIND_IN_SET(210, pf.categories_path) ) ORDER BY pf.position, vi_product_features_descriptions.description
SELECT v.feature_id,         v.value,         v.value_int,         v.variant_id,         f.feature_type,         fd.internal_name,         fd.description,         fd.prefix,         fd.suffix,         vd.variant,         f.parent_id,         f.position,         gf.position as gposition,         f.display_on_header,         f.display_on_catalog,         f.display_on_product,         f.feature_code,         f.purpose,fv.abt__ut2_color_style, fv.abt__ut2_multicolor FROM vi_product_features as f LEFT JOIN vi_product_features_values as v ON v.feature_id = f.feature_id  LEFT JOIN vi_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN vi_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN vi_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN vi_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = f.feature_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 150  AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(203, f.categories_path) OR FIND_IN_SET(204, f.categories_path) OR FIND_IN_SET(210, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM vi_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.internal_name, fv.position
SELECT data FROM vi_storage_data WHERE data_key = 'plan'
SELECT c.company_id FROM vi_products_categories pc LEFT JOIN vi_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 150 GROUP BY c.company_id
SELECT field_id, value FROM vi_yl_vipiris_entity_field_values WHERE entity_type = 'products' AND entity_id = 150 AND lang_code = 'en'
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' LEFT JOIN vi_product_required_products ON products.product_id = vi_product_required_products.required_id WHERE 1  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 vi_product_required_products.product_id = 150 GROUP BY products.product_id   ORDER BY product asc, products.product_id ASC 
SELECT category_id, category FROM vi_category_descriptions WHERE category_id IN (203, 204, 210) AND lang_code = 'en'
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 (150) 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 (150) 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 (150) 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 (150) 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 (150)
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 >= 1776426264 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 < 1776426264 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 <= 1776426264, 1) AND IF(to_date, to_date >= 1776426264, 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 *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 150 AND object_type = 'P' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC LIMIT 1
SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 210 AND object_type = 'C' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC LIMIT 1
SELECT REPLACE(id_path, '210', '') FROM vi_categories WHERE category_id = 210
SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 204 AND object_type = 'C' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC LIMIT 1
SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 203 AND object_type = 'C' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC LIMIT 1
SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 0 AND object_type = 'A' AND company_id = 1 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC LIMIT 1
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 '%"detailed_page":"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 '%"detailed_page":"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 vi_product_files.*, vi_product_file_descriptions.file_name, vi_product_file_descriptions.license, vi_product_file_descriptions.readme FROM vi_product_files  LEFT JOIN vi_product_file_descriptions ON vi_product_file_descriptions.file_id = vi_product_files.file_id AND vi_product_file_descriptions.lang_code = 'en' WHERE 1=1  AND vi_product_files.product_id = 150 AND preview_path != '' AND vi_product_files.status = 'A'  ORDER BY vi_product_files.position asc, vi_product_file_descriptions.file_name asc

Queries total time: 0.03125 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.00022	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.00012	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.00007	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.00010	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.00005	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.00006	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.00006	Re-run Backtrace
8	`SELECT type FROM vi_seo_names WHERE name = 'wildwood-city-classic' 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.00017	Re-run Backtrace
9	`SELECT * FROM vi_seo_names WHERE name = 'wildwood-city-classic' 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.00012	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.00007	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.00005	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.00009	Re-run Backtrace
13	`SELECT object_id, name FROM vi_seo_names WHERE name IN ('sports-and-outdoors', 'bikes', 'comfort-and-cruisers') 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.00018	Re-run Backtrace
14	`SELECT product_id, parent_product_id FROM vi_product_variation_group_products WHERE product_id IN (150)` 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:3788 `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\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/devvipiriscom/www/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:80 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/devvipiriscom/www/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/devvipiriscom/www/app/addons/product_variations/src/Product/ProductIdMap.php:264 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/devvipiriscom/www/app/addons/product_variations/src/Product/Group/Repository.php:609 `Tygh\Database\Connection::getSingleHash()` /home/devvipiriscom/www/app/addons/product_variations/src/Tools/Query.php:326 `Tygh\Database\Connection::query()` /home/devvipiriscom/www/app/Tygh/Database/Connection.php:572	0.00008	Re-run Backtrace
15	`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.00008	Re-run Backtrace
16	SELECT name, path FROM vi_seo_names WHERE `object_id` = 150 AND `type` = 'p' 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.00012	Re-run Backtrace
17	SELECT name, path FROM vi_seo_names WHERE `object_id` = 203 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.00010	Re-run Backtrace
18	SELECT name, path FROM vi_seo_names WHERE `object_id` = 204 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.00007	Re-run Backtrace
19	SELECT name, path FROM vi_seo_names WHERE `object_id` = 210 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.00007	Re-run Backtrace
20	`SELECT redirect_id, src, type, object_id, dest, lang_code FROM vi_seo_redirects WHERE src = '/sports-and-outdoors/bikes/comfort-and-cruisers/wildwood-city-classic' 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.00011	Re-run Backtrace
21	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.00017	Re-run Backtrace
22	`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.00015	Re-run Backtrace
23	`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.00009	Re-run Backtrace
24	`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.00007	Re-run Backtrace
25	`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.00004	Re-run Backtrace
26	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.00032	Re-run Backtrace
27	`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.00007	Re-run Backtrace
28	`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 ('products.view') AND (FIND_IN_SET(150, 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.00015	Re-run Backtrace
29	`SELECT product_id, location_id FROM vi_yl_vipiris_product_settings WHERE product_id = 150` 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 `fn_set_hook()` /home/devvipiriscom/www/app/Tygh/BlockManager/Location.php:195 `fn_yl_vipiris_get_location_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_yl_vipiris_get_product_settings()` /home/devvipiriscom/www/app/addons/yl_vipiris/functions/yl_vi_hooks.php:99 `db_get_row()` /home/devvipiriscom/www/app/addons/yl_vipiris/func.php:215 `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
30	`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.00005	Re-run Backtrace
31	`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.00007	Re-run Backtrace
32	`SELECT usergroup_ids FROM vi_products WHERE product_id = 150` 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/products.php:112 `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.00141	Re-run Backtrace
33	`SELECT category_id FROM vi_products_categories WHERE product_id = 150 AND link_type = 'M'` 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:260 `fn_bestsellers_get_product_data()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `db_get_field()` /home/devvipiriscom/www/app/addons/bestsellers/func.php:255 `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
34	SELECT vi_products., vi_product_descriptions., 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, GROUP_CONCAT( CASE WHEN (vi_products_categories.link_type = 'M') THEN CONCAT(vi_products_categories.category_id, 'M') ELSE vi_products_categories.category_id END ORDER BY vi_categories.storefront_id IN (0, 1) DESC, (vi_products_categories.link_type = 'M') DESC, vi_products_categories.category_position ASC, vi_products_categories.category_id ASC) as category_ids, popularity.total as popularity, IF(shared_prices.product_id IS NOT NULL,MIN(IF(shared_prices.percentage_discount = 0, shared_prices.price, shared_prices.price - (shared_prices.price * shared_prices.percentage_discount)/100)),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, companies.company as company_name, vi_product_sales.amount as sales_amount, vi_seo_names.name as seo_name, vi_seo_names.path as seo_path, MIN(point_prices.point_price) as point_price, vi_discussion.type as discussion_type, vi_product_review_prepared_data.average_rating average_rating, vi_product_review_prepared_data.reviews_count product_reviews_count FROM vi_products LEFT JOIN vi_product_prices ON vi_product_prices.product_id = vi_products.product_id AND vi_product_prices.lower_limit = 1 AND vi_product_prices.usergroup_id IN (0, 0, 1) LEFT JOIN vi_product_descriptions ON vi_product_descriptions.product_id = vi_products.product_id AND vi_product_descriptions.lang_code = 'en' LEFT JOIN vi_ult_product_prices shared_prices ON shared_prices.product_id = vi_products.product_id AND shared_prices.company_id = 1 AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) LEFT JOIN vi_companies as companies ON companies.company_id = vi_products.company_id INNER JOIN vi_products_categories ON vi_products_categories.product_id = vi_products.product_id 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_products.usergroup_ids = '' OR FIND_IN_SET(0, vi_products.usergroup_ids) OR FIND_IN_SET(1, vi_products.usergroup_ids)) AND vi_categories.status IN ('A', 'H') AND vi_products.status IN ('A', 'H') LEFT JOIN vi_product_popularity as popularity ON popularity.product_id = vi_products.product_id LEFT JOIN vi_product_sales ON vi_product_sales.product_id = vi_products.product_id AND vi_product_sales.category_id = 210 LEFT JOIN vi_seo_names ON vi_seo_names.object_id = 150 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 LEFT JOIN vi_product_point_prices as point_prices ON point_prices.product_id = vi_products.product_id AND point_prices.lower_limit = 1 AND point_prices.usergroup_id IN (0, 0, 1) LEFT JOIN vi_discussion ON vi_discussion.object_id = vi_products.product_id AND vi_discussion.object_type = 'P' AND vi_discussion.company_id = 1 LEFT JOIN vi_product_review_prepared_data ON vi_product_review_prepared_data.product_id = vi_products.product_id AND vi_product_review_prepared_data.storefront_id = 0 WHERE vi_products.product_id = 150 AND (companies.status IN ('A') OR vi_products.company_id = 0) GROUP BY vi_products.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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `db_get_row()` /home/devvipiriscom/www/app/functions/fn.products.php:262 `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.00059	Re-run Backtrace
35	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 = '150' 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 = '150' 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_image_pairs()` /home/devvipiriscom/www/app/functions/fn.products.php:338 `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.00022	Re-run Backtrace
36	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 = '150' 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 = '150' 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_image_pairs()` /home/devvipiriscom/www/app/functions/fn.products.php:343 `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.00013	Re-run Backtrace
37	`SELECT prices.product_id, prices.lower_limit, usergroup_id, prices.percentage_discount, IF(prices.percentage_discount = 0, prices.price, prices.price - (prices.price * prices.percentage_discount)/100) as price FROM vi_product_prices prices WHERE prices.product_id = 150 AND lower_limit > 1 AND prices.usergroup_id IN (0, 0, 1) ORDER BY lower_limit` 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_product_prices()` /home/devvipiriscom/www/app/functions/fn.products.php:351 `db_get_hash_multi_array()` /home/devvipiriscom/www/app/functions/fn.products.php:3341 `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.00014	Re-run Backtrace
38	`SELECT c.company_id FROM vi_products_categories pc LEFT JOIN vi_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 150 GROUP BY c.company_id LIMIT 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 `fn_get_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_ult_is_shared_product()` /home/devvipiriscom/www/app/functions/fn.products.php:355 `db_get_fields()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:1855 `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.00009	Re-run Backtrace
39	`SELECT id_path FROM vi_categories WHERE category_id IN (210)` 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_category_ids_with_parent()` /home/devvipiriscom/www/app/functions/fn.products.php:360 `db_get_fields()` /home/devvipiriscom/www/app/functions/fn.categories.php:2150 `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.00005	Re-run Backtrace
40	SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, vi_product_features_descriptions.description, vi_product_features_descriptions.internal_name, vi_product_features_descriptions.lang_code, vi_product_features_descriptions.prefix, vi_product_features_descriptions.suffix, pf.categories_path, vi_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp, pf_groups.position AS group_position, vi_product_features_values.value, vi_product_features_values.variant_id, vi_product_features_values.value_int, abt_filters.filter_id FROM vi_product_features AS pf LEFT JOIN vi_product_features AS pf_groups ON pf.parent_id = pf_groups.feature_id LEFT JOIN vi_product_features_descriptions AS pf_groups_description ON pf_groups_description.feature_id = pf.parent_id AND pf_groups_description.lang_code = 'en' LEFT JOIN vi_product_features_descriptions ON vi_product_features_descriptions.feature_id = pf.feature_id AND vi_product_features_descriptions.lang_code = 'en' INNER JOIN vi_product_features_values ON vi_product_features_values.feature_id = pf.feature_id AND vi_product_features_values.product_id = 150 AND vi_product_features_values.lang_code = 'en' LEFT JOIN vi_product_filters AS abt_filters ON abt_filters.feature_id = pf.feature_id AND abt_filters.company_id = pf.company_id INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = pf.feature_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_features') WHERE 1=1 AND pf.feature_type != 'G' AND pf.status IN ('A') AND (pf_groups.status IN ('A') OR pf_groups.status IS NULL) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(203, pf.categories_path) OR FIND_IN_SET(204, pf.categories_path) OR FIND_IN_SET(210, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position asc, pf_groups_description.description asc, pf_groups.feature_id asc, pf.position asc, vi_product_features_descriptions.description asc, pf.feature_id 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_product_features()` /home/devvipiriscom/www/app/functions/fn.products.php:373 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.features.php:540 `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.00038	Re-run Backtrace
41	SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, vi_product_features_descriptions.description, vi_product_features_descriptions.internal_name, vi_product_features_descriptions.lang_code, vi_product_features_descriptions.prefix, vi_product_features_descriptions.suffix, pf.categories_path, vi_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, pf.purpose, pf.feature_style, pf.filter_style, pf.feature_code, pf.timestamp, pf.updated_timestamp FROM vi_product_features AS pf LEFT JOIN vi_product_features_descriptions ON vi_product_features_descriptions.feature_id = pf.feature_id AND vi_product_features_descriptions.lang_code = 'en' INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = pf.feature_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_features') WHERE pf.feature_type = 'G' AND (pf.feature_id IN ('') OR pf.feature_id NOT IN (SELECT parent_id FROM vi_product_features)) AND pf.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(203, pf.categories_path) OR FIND_IN_SET(204, pf.categories_path) OR FIND_IN_SET(210, pf.categories_path) ) ORDER BY pf.position, vi_product_features_descriptions.description 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_product_features()` /home/devvipiriscom/www/app/functions/fn.products.php:373 `db_get_hash_array()` /home/devvipiriscom/www/app/functions/fn.features.php:656 `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.00214	Re-run Backtrace
42	SELECT v.feature_id, v.value, v.value_int, v.variant_id, f.feature_type, fd.internal_name, fd.description, fd.prefix, fd.suffix, vd.variant, f.parent_id, f.position, gf.position as gposition, f.display_on_header, f.display_on_catalog, f.display_on_product, f.feature_code, f.purpose,fv.abt__ut2_color_style, fv.abt__ut2_multicolor FROM vi_product_features as f LEFT JOIN vi_product_features_values as v ON v.feature_id = f.feature_id LEFT JOIN vi_product_features_descriptions as fd ON fd.feature_id = v.feature_id AND fd.lang_code = 'en' LEFT JOIN vi_product_feature_variants fv ON fv.variant_id = v.variant_id LEFT JOIN vi_product_feature_variant_descriptions as vd ON vd.variant_id = fv.variant_id AND vd.lang_code = 'en' LEFT JOIN vi_product_features as gf ON gf.feature_id = f.parent_id AND gf.feature_type = 'G' INNER JOIN vi_ult_objects_sharing ON (vi_ult_objects_sharing.share_object_id = f.feature_id AND vi_ult_objects_sharing.share_company_id = 1 AND vi_ult_objects_sharing.share_object_type = 'product_features') WHERE f.status IN ('A') AND v.product_id = 150 AND f.display_on_header = 'Y' AND ( f.categories_path = '' OR FIND_IN_SET(203, f.categories_path) OR FIND_IN_SET(204, f.categories_path) OR FIND_IN_SET(210, f.categories_path) ) AND IF(f.parent_id, (SELECT status FROM vi_product_features as df WHERE df.feature_id = f.parent_id), 'A') IN ('A') AND ( v.variant_id != 0 OR (f.feature_type != 'C' AND v.value != '') OR (f.feature_type = 'C') OR v.value_int != '') AND v.lang_code = 'en' ORDER BY fd.internal_name, fv.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_get_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_product_features_list()` /home/devvipiriscom/www/app/functions/fn.products.php:376 `db_get_array()` /home/devvipiriscom/www/app/functions/fn.features.php:954 `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.00026	Re-run Backtrace
43	`SELECT data FROM vi_storage_data WHERE data_key = 'plan'` 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_get_product_videos()` /home/devvipiriscom/www/app/functions/fn.products.php:383 `Tygh\Video\VideoManager::getVideos()` /home/devvipiriscom/www/app/functions/fn.products.php:4451 `fn_is_allowed()` /home/devvipiriscom/www/app/Tygh/Video/VideoManager.php:175 `Tygh\Providers\LicensingProvider::getLicensingService()` /home/devvipiriscom/www/app/functions/fn.control.php:1042 `Tygh\Application::offsetGet()` /home/devvipiriscom/www/app/Tygh/Providers/LicensingProvider.php:61 `Pimple\Container::offsetGet()` /home/devvipiriscom/www/app/Tygh/Application.php:135 `Tygh\Providers\LicensingProvider::Tygh\Providers\{closure}()` /home/devvipiriscom/www/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:122 `fn_get_storage_data()` /home/devvipiriscom/www/app/Tygh/Providers/LicensingProvider.php:39 `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.00005	Re-run Backtrace
44	`SELECT c.company_id FROM vi_products_categories pc LEFT JOIN vi_categories c ON c.category_id = pc.category_id WHERE pc.product_id = 150 GROUP BY c.company_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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:397 `fn_ult_get_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:105 `fn_ult_get_shared_product_companies()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:144 `db_get_fields()` /home/devvipiriscom/www/app/functions/fn.ultimate.php:1889 `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.00009	Re-run Backtrace
45	`SELECT field_id, value FROM vi_yl_vipiris_entity_field_values WHERE entity_type = 'products' AND entity_id = 150 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:397 `fn_yl_vipiris_get_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_yl_vipiris_get_entity_field_values()` /home/devvipiriscom/www/app/addons/yl_vipiris/functions/yl_vi_hooks.php:164 `db_get_hash_single_array()` /home/devvipiriscom/www/app/addons/yl_vipiris/func.php:61 `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.00009	Re-run Backtrace
46	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' LEFT JOIN vi_product_required_products ON products.product_id = vi_product_required_products.required_id WHERE 1 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 vi_product_required_products.product_id = 150 GROUP BY products.product_id ORDER BY product asc, products.product_id 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:126 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:397 `fn_required_products_get_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_get_products()` /home/devvipiriscom/www/app/addons/required_products/func.php:35 `{closure}()` /home/devvipiriscom/www/app/functions/fn.products.php:2466 `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.00015	Re-run Backtrace
47	`SELECT category_id, category FROM vi_category_descriptions WHERE category_id IN (203, 204, 210) 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_name()` /home/devvipiriscom/www/app/controllers/frontend/products.php:190 `db_get_hash_single_array()` /home/devvipiriscom/www/app/functions/fn.categories.php:887 `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.00007	Re-run Backtrace
48	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 (150) 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 (150) 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00012	Re-run Backtrace
49	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 (150) 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00012	Re-run Backtrace
50	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 (150) 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00021	Re-run Backtrace
51	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00007	Re-run Backtrace
52	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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
53	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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
54	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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
55	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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
56	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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
57	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00005	Re-run Backtrace
58	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00005	Re-run Backtrace
59	`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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00005	Re-run Backtrace
60	`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 (150)` 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00010	Re-run Backtrace
61	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 >= 1776426264 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 < 1776426264 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00015	Re-run Backtrace
62	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 <= 1776426264, 1) AND IF(to_date, to_date >= 1776426264, 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00022	Re-run Backtrace
63	`SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 150 AND object_type = 'P' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC 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 `fn_gather_additional_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:880 `fn_reward_points_gather_additional_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_gather_reward_points_data()` /home/devvipiriscom/www/app/addons/reward_points/func.php:661 `fn_get_reward_points()` /home/devvipiriscom/www/app/addons/reward_points/func.php:723 `db_get_row()` /home/devvipiriscom/www/app/addons/reward_points/func.php:56 `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.00006	Re-run Backtrace
64	`SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 210 AND object_type = 'C' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC 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 `fn_gather_additional_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:880 `fn_reward_points_gather_additional_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_gather_reward_points_data()` /home/devvipiriscom/www/app/addons/reward_points/func.php:661 `fn_get_reward_points()` /home/devvipiriscom/www/app/addons/reward_points/func.php:723 `db_get_row()` /home/devvipiriscom/www/app/addons/reward_points/func.php:56 `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.00004	Re-run Backtrace
65	`SELECT REPLACE(id_path, '210', '') FROM vi_categories WHERE category_id = 210` 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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:880 `fn_reward_points_gather_additional_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_gather_reward_points_data()` /home/devvipiriscom/www/app/addons/reward_points/func.php:661 `db_get_field()` /home/devvipiriscom/www/app/addons/reward_points/func.php:756 `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
66	`SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 204 AND object_type = 'C' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC 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 `fn_gather_additional_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:880 `fn_reward_points_gather_additional_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_gather_reward_points_data()` /home/devvipiriscom/www/app/addons/reward_points/func.php:661 `fn_get_reward_points()` /home/devvipiriscom/www/app/addons/reward_points/func.php:761 `db_get_row()` /home/devvipiriscom/www/app/addons/reward_points/func.php:56 `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.00004	Re-run Backtrace
67	`SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 203 AND object_type = 'C' AND company_id = 0 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC 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 `fn_gather_additional_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:880 `fn_reward_points_gather_additional_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_gather_reward_points_data()` /home/devvipiriscom/www/app/addons/reward_points/func.php:661 `fn_get_reward_points()` /home/devvipiriscom/www/app/addons/reward_points/func.php:761 `db_get_row()` /home/devvipiriscom/www/app/addons/reward_points/func.php:56 `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.00003	Re-run Backtrace
68	`SELECT *, amount AS pure_amount FROM vi_reward_points WHERE object_id = 0 AND object_type = 'A' AND company_id = 1 AND amount > 0 AND usergroup_id IN(0, 1) ORDER BY amount_type ASC, amount ASC 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 `fn_gather_additional_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `fn_set_hook()` /home/devvipiriscom/www/app/functions/fn.products.php:880 `fn_reward_points_gather_additional_product_data_post()` /home/devvipiriscom/www/app/functions/fn.control.php:124 `fn_gather_reward_points_data()` /home/devvipiriscom/www/app/addons/reward_points/func.php:661 `fn_get_reward_points()` /home/devvipiriscom/www/app/addons/reward_points/func.php:723 `db_get_row()` /home/devvipiriscom/www/app/addons/reward_points/func.php:56 `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.00003	Re-run Backtrace
69	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 '%"detailed_page":"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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00011	Re-run Backtrace
70	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 '%"detailed_page":"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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00026	Re-run Backtrace
71	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_product_data()` /home/devvipiriscom/www/app/controllers/frontend/products.php:202 `fn_gather_additional_products_data()` /home/devvipiriscom/www/app/functions/fn.products.php:1009 `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.00013	Re-run Backtrace
72	SELECT vi_product_files.*, vi_product_file_descriptions.file_name, vi_product_file_descriptions.license, vi_product_file_descriptions.readme FROM vi_product_files LEFT JOIN vi_product_file_descriptions ON vi_product_file_descriptions.file_id = vi_product_files.file_id AND vi_product_file_descriptions.lang_code = 'en' WHERE 1=1 AND vi_product_files.product_id = 150 AND preview_path != '' AND vi_product_files.status = 'A' ORDER BY vi_product_files.position asc, vi_product_file_descriptions.file_name 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_product_files()` /home/devvipiriscom/www/app/controllers/frontend/products.php:218 <

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