Queries list
Queries count !
Queries parse


SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND (storefronts.url = 'dev1-ecom.kindlife.in' OR storefronts.url = 'www.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%') GROUP BY storefronts.storefront_id   ORDER BY storefronts.url = 'dev1-ecom.kindlife.in' DESC, storefronts.url = 'www.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%' desc 
SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'
SET time_zone = '+05:30'
SELECT type FROM cscart_seo_names WHERE name = 'publicprofile' 
SELECT * FROM cscart_seo_names WHERE name = 'publicprofile'  AND lang_code = 'en'
SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages  WHERE 1 AND cscart_languages.status = 'A'   
SELECT storefronts.* FROM cscart_storefronts AS storefronts  WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id   ORDER BY storefronts.is_default desc 
SELECT cscart_bm_layouts.* FROM cscart_bm_layouts  WHERE 1  AND is_default = 1 AND theme_name = 'new_2bk' AND storefront_id = 1
SELECT brand_id FROM cscart_users WHERE user_id = 0 
SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'
SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'
SELECT * FROM cscart_languages WHERE status = 'A'
SELECT * FROM cscart_se_settings
SELECT * FROM cscart_bm_layouts WHERE 1  AND storefront_id = 1 AND layout_id = 10
SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10  AND l.dispatch IN ('publicprofile.profiles')  ORDER BY l.object_ids desc  LIMIT 1
SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='16738'
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=16738
SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 16738
SELECT target_id FROM kl_likes WHERE user_id = 16738 and type= 'Video_Video'
SELECT COUNT(DISTINCT cv.video_id) FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' WHERE 1  AND cv.status='A'
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cvd.youtube_id, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != '' THEN CONCAT('https://cdn.kindlife.in/', MAX(mum.avatar)) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id WHERE 1  AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC  LIMIT 0, 5
SELECT video_id, GROUP_CONCAT(DISTINCT product_id ORDER BY product_id ASC SEPARATOR ', ') as products 
            FROM cscart_cp_video_product_links 
            WHERE video_id IN (2166, 2164, 2165, 2163, 2162) 
            GROUP BY video_id
SELECT ctl.object_id as video_id, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags 
            FROM cscart_tag_links ctl 
            LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id 
            WHERE ctl.object_id IN (2166, 2164, 2165, 2163, 2162) 
            GROUP BY ctl.object_id
SELECT
                t.tag_id as id,
                tl.object_id as target_id,
            CASE
                WHEN tl.object_type = 'V' THEN 'Video_Video'
                ELSE tl.object_type
            END as type,
            t.tag
            FROM
                cscart_tag_links tl
            INNER JOIN
                cscart_tags t ON tl.tag_id = t.tag_id
            WHERE
                tl.object_id = 2166
SELECT firstname, lastname FROM cscart_users WHERE user_id = 4246
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id  = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc  on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 26036 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '26036' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='26036'
SELECT cscart_languages.* FROM cscart_languages  WHERE 1    
SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_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 product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26036)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26036)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26036 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26036
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id  = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc  on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 26038 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '26038' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='26038'
SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26038)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26038)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26038 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26038
SELECT
                t.tag_id as id,
                tl.object_id as target_id,
            CASE
                WHEN tl.object_type = 'V' THEN 'Video_Video'
                ELSE tl.object_type
            END as type,
            t.tag
            FROM
                cscart_tag_links tl
            INNER JOIN
                cscart_tags t ON tl.tag_id = t.tag_id
            WHERE
                tl.object_id = 2164
SELECT firstname, lastname FROM cscart_users WHERE user_id = 51
SELECT
                t.tag_id as id,
                tl.object_id as target_id,
            CASE
                WHEN tl.object_type = 'V' THEN 'Video_Video'
                ELSE tl.object_type
            END as type,
            t.tag
            FROM
                cscart_tag_links tl
            INNER JOIN
                cscart_tags t ON tl.tag_id = t.tag_id
            WHERE
                tl.object_id = 2165
SELECT firstname, lastname FROM cscart_users WHERE user_id = 51
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id  = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc  on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 66853 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '66853' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='66853'
SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (66853)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (66853)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 66853 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 66853
SELECT
                t.tag_id as id,
                tl.object_id as target_id,
            CASE
                WHEN tl.object_type = 'V' THEN 'Video_Video'
                ELSE tl.object_type
            END as type,
            t.tag
            FROM
                cscart_tag_links tl
            INNER JOIN
                cscart_tags t ON tl.tag_id = t.tag_id
            WHERE
                tl.object_id = 2163
SELECT firstname, lastname FROM cscart_users WHERE user_id = 21551
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id  = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc  on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68893 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68893' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='68893'
SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68893)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68893)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68893 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68893
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id  = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc  on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68917 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68917' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='68917'
SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68917)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68917)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68917 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68917
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id  = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc  on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68941 
SELECT cscart_images.*, cscart_images_links.*, cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68941' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='68941'
SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68941)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68941)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68941 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68941
SELECT
                t.tag_id as id,
                tl.object_id as target_id,
            CASE
                WHEN tl.object_type = 'V' THEN 'Video_Video'
                ELSE tl.object_type
            END as type,
            t.tag
            FROM
                cscart_tag_links tl
            INNER JOIN
                cscart_tags t ON tl.tag_id = t.tag_id
            WHERE
                tl.object_id = 2162
SELECT firstname, lastname FROM cscart_users WHERE user_id = 21551
SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 16738 and status= 'A'
SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)
SELECT object_id FROM cscart_seo_redirects where src = '/publicprofile/?user_id=16738' AND type = 'p'
SELECT vd.variant FROM cscart_product_feature_variant_descriptions vd INNER JOIN cscart_product_features_values pfv ON pfv.variant_id = vd.variant_id WHERE pfv.feature_id = 62 AND pfv.product_id = 0 AND vd.lang_code = 'en'
SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'
SELECT c.* FROM cscart_bm_containers as c  WHERE 1  AND c.location_id = 420 AND c.company_id = 0
SELECT layout_id FROM cscart_bm_locations WHERE location_id = 420
SELECT c.*, IF (c.location_id != 420, 0, 1) as `default` FROM cscart_bm_containers as c  INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1  AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0
SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1  AND g.container_id IN (1447, 1446, 1680, 1449) ORDER BY g.order, g.parent_id, g.grid_id ASC
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.*,cscart_bm_blocks.*,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id  LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (2167, 2168, 2169, 2176, 2178, 2179, 2173, 2170, 2172, 2171, 2177, 2175, 2174, 2180, 2183, 2188, 2192, 2189, 2648, 2190, 2187, 2191, 2193, 2194, 2195, 2196, 2791, 2792, 2793)  AND cscart_bm_blocks_descriptions.lang_code='en'  ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id 
SELECT * FROM cscart_profile_fields WHERE section="K" || field_id IN (6, 7)
SELECT * FROM cscart_profile_fields WHERE section="K" 
SELECT * FROM cscart_profile_fields WHERE section="K" 
SELECT * FROM cscart_profile_fields WHERE section="K" || field_id IN (6, 7)
SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users  WHERE  user_id = 16738 AND status = 'A' 
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=4246
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=51
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 36368 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=51
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=21551
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 48466 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref
        left join cscart_users us on pref.user_id = us.user_id 
         WHERE pref.user_id=21551
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 61552 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users  WHERE  user_id = 16738 AND status = 'A' 
SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='62827'
SELECT COUNT(DISTINCT cv.video_id) FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' WHERE 1  AND cv.user_id = 16738 AND cv.status='A'
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cvd.youtube_id, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != '' THEN CONCAT('https://cdn.kindlife.in/', MAX(mum.avatar)) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar FROM cscart_cp_videos cv  LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id WHERE 1  AND cv.user_id = 16738 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC  LIMIT 0, 10
SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'

Queries total time: 0.09657 s.
№	Query	Time	Actions
1	SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev1-ecom.kindlife.in' OR storefronts.url = 'www.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev1-ecom.kindlife.in' DESC, storefronts.url = 'www.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%' desc Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_redirect_to_regional_storefront()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `Tygh\Storefront\Repository::findByUrl()` /home/alpha/live/multivendor/app/functions/fn.init.php:1426 `Tygh\Storefront\Repository::find()` /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:360 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00070	Re-run Backtrace
2	`SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_http_params_by_storefront()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_allowed_for()` /home/alpha/live/multivendor/app/functions/fn.init.php:1582 `fn_get_storage_data()` /home/alpha/live/multivendor/app/functions/fn.control.php:980 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.control.php:1055 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00031	Re-run Backtrace
3	`SET time_zone = '+05:30'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_settings()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_init_time_zone()` /home/alpha/live/multivendor/app/functions/fn.init.php:1038 `db_query()` /home/alpha/live/multivendor/app/functions/fn.init.php:1059 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/functions/fn.database.php:138	0.00119	Re-run Backtrace
4	`SELECT type FROM cscart_seo_names WHERE name = 'publicprofile'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_get_route()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:836 `fn_seo_get_route()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `db_get_field()` /home/alpha/live/multivendor/app/addons/seo/func.php:652 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00050	Re-run Backtrace
5	`SELECT * FROM cscart_seo_names WHERE name = 'publicprofile' AND lang_code = 'en'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_get_route()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:836 `fn_seo_get_route()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `db_get_array()` /home/alpha/live/multivendor/app/addons/seo/func.php:656 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00040	Re-run Backtrace
6	`SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages WHERE 1 AND cscart_languages.status = 'A'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_get_route()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:836 `fn_seo_get_route()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_validate_object()` /home/alpha/live/multivendor/app/addons/seo/func.php:695 `Tygh\Languages\Languages::getSimpleLanguages()` /home/alpha/live/multivendor/app/addons/seo/func.php:1049 `db_get_hash_single_array()` /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:519 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:111 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00028	Re-run Backtrace
7	`SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_get_route()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:836 `fn_seo_get_route()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_url()` /home/alpha/live/multivendor/app/addons/seo/func.php:781 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_get_seo_settings()` /home/alpha/live/multivendor/app/addons/seo/func.php:1452 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/seo/func.php:2167 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Providers\StorefrontProvider::Tygh\Providers\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Storefront\Repository::findById()` /home/alpha/live/multivendor/app/Tygh/Providers/StorefrontProvider.php:186 `Tygh\Storefront\Repository::find()` /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:164 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:363 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00026	Re-run Backtrace
8	`SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'new_2bk' AND storefront_id = 1` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_layout()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `Tygh\BlockManager\Layout::getDefault()` /home/alpha/live/multivendor/app/functions/fn.init.php:662 `db_get_row()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Layout.php:95 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00024	Re-run Backtrace
9	`SELECT brand_id FROM cscart_users WHERE user_id = 0` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_user()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_login_user()` /home/alpha/live/multivendor/app/functions/fn.init.php:733 `fn_fill_auth()` /home/alpha/live/multivendor/app/functions/fn.users.php:3421 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.users.php:1381 `fn_kl_vendro_dashboard_fill_auth()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_get_variantId_by_userId()` /home/alpha/live/multivendor/app/addons/kl_vendro_dashboard/func.php:77 `db_get_field()` /home/alpha/live/multivendor/app/addons/kl_vendro_dashboard/func.php:32 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00023	Re-run Backtrace
10	`SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_user()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `fn_login_user()` /home/alpha/live/multivendor/app/functions/fn.init.php:733 `fn_init_user()` /home/alpha/live/multivendor/app/functions/fn.users.php:3426 `fn_is_expired_storage_data()` /home/alpha/live/multivendor/app/functions/fn.init.php:765 `fn_get_storage_data()` /home/alpha/live/multivendor/app/functions/fn.control.php:1073 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.control.php:1055 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00017	Re-run Backtrace
11	`SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'` Backtrace `require()` /home/alpha/live/multivendor/index.php:24 `fn_init()` /home/alpha/live/multivendor/init.php:179 `fn_init_templater()` /home/alpha/live/multivendor/app/functions/fn.init.php:1201 `Tygh\Development::isEnabled()` /home/alpha/live/multivendor/app/functions/fn.init.php:116 `Tygh\Development::read()` /home/alpha/live/multivendor/app/Tygh/Development.php:28 `fn_get_storage_data()` /home/alpha/live/multivendor/app/Tygh/Development.php:81 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.control.php:1055 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00024	Re-run Backtrace
12	`SELECT * FROM cscart_languages WHERE status = 'A'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:442 `fn_searchanise_dispatch_assign_template()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_se_check_import_is_done()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:80 `fn_se_get_engines_data()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:1886 `db_get_array()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:560 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00035	Re-run Backtrace
13	`SELECT * FROM cscart_se_settings` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:442 `fn_searchanise_dispatch_assign_template()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_se_check_import_is_done()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:80 `fn_se_get_engines_data()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:1886 `fn_se_get_api_key()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:613 `fn_se_get_setting()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:237 `fn_se_get_all_settings()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:167 `db_get_array()` /home/alpha/live/multivendor/app/addons/searchanise/func.php:152 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00027	Re-run Backtrace
14	`SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 10` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `Tygh\BlockManager\Location::instance()` /home/alpha/live/multivendor/app/controllers/frontend/init.php:142 `Tygh\BlockManager\Layout::get()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:474 `db_get_row()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Layout.php:61 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00020	Re-run Backtrace
15	`SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10 AND l.dispatch IN ('publicprofile.profiles') ORDER BY l.object_ids desc LIMIT 1` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `Tygh\BlockManager\Location::get()` /home/alpha/live/multivendor/app/controllers/frontend/init.php:142 `Tygh\BlockManager\Location::getList()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:169 `db_get_hash_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Location.php:105 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00356	Re-run Backtrace
16	`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='16738'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `get_user_profile_pic()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:14 `db_get_array()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:809 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00131	Re-run Backtrace
17	`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=16738` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_get_user_image()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:18 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:673 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00147	Re-run Backtrace
18	`SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 16738` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_kl_perfect_match_quiz_get_user_expertise()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:20 `db_get_field()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:762 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00017	Re-run Backtrace
19	`SELECT target_id FROM kl_likes WHERE user_id = 16738 and type= 'Video_Video'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `db_get_fields()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:37 `Tygh\Database\Connection::getColumn()` /home/alpha/live/multivendor/app/functions/fn.database.php:85 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:454	0.00049	Re-run Backtrace
20	`SELECT COUNT(DISTINCT cv.video_id) FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' WHERE 1 AND cv.status='A'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_field()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1910 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00543	Re-run Backtrace
21	SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cvd.youtube_id, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != '' THEN CONCAT('https://cdn.kindlife.in/', MAX(mum.avatar)) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id WHERE 1 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC LIMIT 0, 5 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_hash_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1920 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.04034	Re-run Backtrace
22	`SELECT video_id, GROUP_CONCAT(DISTINCT product_id ORDER BY product_id ASC SEPARATOR ', ') as products FROM cscart_cp_video_product_links WHERE video_id IN (2166, 2164, 2165, 2163, 2162) GROUP BY video_id` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1928 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00051	Re-run Backtrace
23	`SELECT ctl.object_id as video_id, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags FROM cscart_tag_links ctl LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id WHERE ctl.object_id IN (2166, 2164, 2165, 2163, 2162) GROUP BY ctl.object_id` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1942 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00100	Re-run Backtrace
24	`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2166` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2009 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00038	Re-run Backtrace
25	`SELECT firstname, lastname FROM cscart_users WHERE user_id = 4246` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_user_name()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2015 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:169 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00019	Re-run Backtrace
26	SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 26036 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `db_get_row()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:863 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00099	Re-run Backtrace
27	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '26036' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_image_pairs()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:884 `db_multi_query()` /home/alpha/live/multivendor/app/functions/fn.images.php:351 `Tygh\Database\Connection::multiQuery()` /home/alpha/live/multivendor/app/functions/fn.database.php:168	0.00041	Re-run Backtrace
28	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26036'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_review_count()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:887 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:5471 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00033	Re-run Backtrace
29	`SELECT cscart_languages.* FROM cscart_languages WHERE 1` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:97 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Addons\MasterProducts\ServiceProvider::getProductRepository()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:63 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:89 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:43 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Languages\Languages::getAll()` /home/alpha/live/multivendor/app/Tygh/Providers/CommonProvider.php:40 `db_get_hash_array()` /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:138 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00012	Re-run Backtrace
30	`SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_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/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\ServiceProvider::getProductIdMap()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:97 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Addons\MasterProducts\ServiceProvider::getProductRepository()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:63 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:89 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Addons\MasterProducts\ServiceProvider::Tygh\Addons\MasterProducts\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/ServiceProvider.php:43 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `Tygh\Languages\Languages::getAll()` /home/alpha/live/multivendor/app/Tygh/Providers/CommonProvider.php:40 `Tygh\Languages\Languages::afterFind()` /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:139 `Tygh\Languages\Languages::attachStorefrontIds()` /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:1676 `array_walk()` /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:1764 `Tygh\Languages\Languages::Tygh\Languages\{closure}()` `Tygh\Storefront\Repository::find()` /home/alpha/live/multivendor/app/Tygh/Languages/Languages.php:1761 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/Tygh/Storefront/Repository.php:363 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00031	Re-run Backtrace
31	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26036)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\Product\ProductIdMap::getMasterProductId()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Addons\MasterProducts\Product\ProductIdMap::loadMasterProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:161 `Tygh\Addons\MasterProducts\Product\Repository::findVendorProductsInfo()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:199 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:268 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00016	Re-run Backtrace
32	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26036)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/Addons/Loader.php:148 `Tygh\Addons\ProductVariations\HookHandlers\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/alpha/live/multivendor/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:79 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:260 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/Group/Repository.php:577 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:329 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00037	Re-run Backtrace
33	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26036 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00257	Re-run Backtrace
34	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26036` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_amount()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1988 `db_get_field()` /home/alpha/live/multivendor/app/functions/fn.products.php:3673 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00037	Re-run Backtrace
35	SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 26038 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `db_get_row()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:863 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00163	Re-run Backtrace
36	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '26038' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_image_pairs()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:884 `db_multi_query()` /home/alpha/live/multivendor/app/functions/fn.images.php:351 `Tygh\Database\Connection::multiQuery()` /home/alpha/live/multivendor/app/functions/fn.database.php:168	0.00056	Re-run Backtrace
37	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26038'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_review_count()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:887 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:5471 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00048	Re-run Backtrace
38	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26038)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\Product\ProductIdMap::getMasterProductId()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Addons\MasterProducts\Product\ProductIdMap::loadMasterProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:161 `Tygh\Addons\MasterProducts\Product\Repository::findVendorProductsInfo()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:199 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:268 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00016	Re-run Backtrace
39	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26038)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/Addons/Loader.php:148 `Tygh\Addons\ProductVariations\HookHandlers\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/alpha/live/multivendor/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:79 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:260 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/Group/Repository.php:577 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:329 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00026	Re-run Backtrace
40	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26038 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00029	Re-run Backtrace
41	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26038` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_amount()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1988 `db_get_field()` /home/alpha/live/multivendor/app/functions/fn.products.php:3673 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00015	Re-run Backtrace
42	`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2164` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2009 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00019	Re-run Backtrace
43	`SELECT firstname, lastname FROM cscart_users WHERE user_id = 51` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_user_name()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2015 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:169 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00016	Re-run Backtrace
44	`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2165` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2009 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00019	Re-run Backtrace
45	`SELECT firstname, lastname FROM cscart_users WHERE user_id = 51` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_user_name()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2015 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:169 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00017	Re-run Backtrace
46	SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 66853 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `db_get_row()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:863 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00075	Re-run Backtrace
47	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '66853' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_image_pairs()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:884 `db_multi_query()` /home/alpha/live/multivendor/app/functions/fn.images.php:351 `Tygh\Database\Connection::multiQuery()` /home/alpha/live/multivendor/app/functions/fn.database.php:168	0.00044	Re-run Backtrace
48	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='66853'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_review_count()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:887 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:5471 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00027	Re-run Backtrace
49	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (66853)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\Product\ProductIdMap::getMasterProductId()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Addons\MasterProducts\Product\ProductIdMap::loadMasterProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:161 `Tygh\Addons\MasterProducts\Product\Repository::findVendorProductsInfo()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:199 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:268 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00017	Re-run Backtrace
50	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (66853)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/Addons/Loader.php:148 `Tygh\Addons\ProductVariations\HookHandlers\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/alpha/live/multivendor/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:79 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:260 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/Group/Repository.php:577 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:329 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00015	Re-run Backtrace
51	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 66853 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00029	Re-run Backtrace
52	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 66853` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_amount()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1988 `db_get_field()` /home/alpha/live/multivendor/app/functions/fn.products.php:3673 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00017	Re-run Backtrace
53	`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2163` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2009 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00021	Re-run Backtrace
54	`SELECT firstname, lastname FROM cscart_users WHERE user_id = 21551` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_user_name()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2015 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:169 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00021	Re-run Backtrace
55	SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68893 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `db_get_row()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:863 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00115	Re-run Backtrace
56	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68893' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_image_pairs()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:884 `db_multi_query()` /home/alpha/live/multivendor/app/functions/fn.images.php:351 `Tygh\Database\Connection::multiQuery()` /home/alpha/live/multivendor/app/functions/fn.database.php:168	0.00069	Re-run Backtrace
57	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='68893'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_review_count()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:887 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:5471 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00069	Re-run Backtrace
58	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68893)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\Product\ProductIdMap::getMasterProductId()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Addons\MasterProducts\Product\ProductIdMap::loadMasterProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:161 `Tygh\Addons\MasterProducts\Product\Repository::findVendorProductsInfo()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:199 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:268 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00020	Re-run Backtrace
59	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68893)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/Addons/Loader.php:148 `Tygh\Addons\ProductVariations\HookHandlers\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/alpha/live/multivendor/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:79 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:260 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/Group/Repository.php:577 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:329 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00018	Re-run Backtrace
60	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68893 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00029	Re-run Backtrace
61	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68893` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_amount()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1988 `db_get_field()` /home/alpha/live/multivendor/app/functions/fn.products.php:3673 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00019	Re-run Backtrace
62	SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68917 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `db_get_row()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:863 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00079	Re-run Backtrace
63	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68917' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_image_pairs()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:884 `db_multi_query()` /home/alpha/live/multivendor/app/functions/fn.images.php:351 `Tygh\Database\Connection::multiQuery()` /home/alpha/live/multivendor/app/functions/fn.database.php:168	0.00055	Re-run Backtrace
64	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='68917'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_review_count()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:887 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:5471 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00034	Re-run Backtrace
65	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68917)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\Product\ProductIdMap::getMasterProductId()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Addons\MasterProducts\Product\ProductIdMap::loadMasterProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:161 `Tygh\Addons\MasterProducts\Product\Repository::findVendorProductsInfo()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:199 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:268 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00027	Re-run Backtrace
66	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68917)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/Addons/Loader.php:148 `Tygh\Addons\ProductVariations\HookHandlers\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/alpha/live/multivendor/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:79 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:260 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/Group/Repository.php:577 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:329 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00017	Re-run Backtrace
67	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68917 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00028	Re-run Backtrace
68	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68917` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_amount()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1988 `db_get_field()` /home/alpha/live/multivendor/app/functions/fn.products.php:3673 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00019	Re-run Backtrace
69	SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68941 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `db_get_row()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:863 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00069	Re-run Backtrace
70	SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68941' ORDER BY cscart_images_links.position, cscart_images_links.pair_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_image_pairs()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:884 `db_multi_query()` /home/alpha/live/multivendor/app/functions/fn.images.php:351 `Tygh\Database\Connection::multiQuery()` /home/alpha/live/multivendor/app/functions/fn.database.php:168	0.00039	Re-run Backtrace
71	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='68941'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_data_updated()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1983 `fn_get_review_count()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:887 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:5471 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00070	Re-run Backtrace
72	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68941)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `fn_master_products_url_pre()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `Tygh\Addons\MasterProducts\Product\ProductIdMap::getMasterProductId()` /home/alpha/live/multivendor/app/addons/master_products/func.php:921 `Tygh\Addons\MasterProducts\Product\ProductIdMap::loadMasterProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:161 `Tygh\Addons\MasterProducts\Product\Repository::findVendorProductsInfo()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/ProductIdMap.php:199 `Tygh\Addons\ProductVariations\Tools\Query::select()` /home/alpha/live/multivendor/app/addons/master_products/Tygh/Addons/MasterProducts/Product/Repository.php:126 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:268 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00031	Re-run Backtrace
73	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68941)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3718 `Tygh\Addons\Loader::Tygh\Addons\{closure}()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/Addons/Loader.php:148 `Tygh\Addons\ProductVariations\HookHandlers\SeoHookHandler::onUrlPre()` `Tygh\Addons\ProductVariations\Product\ProductIdMap::getParentProductId()` /home/alpha/live/multivendor/app/addons/product_variations/src/HookHandlers/SeoHookHandler.php:79 `Tygh\Addons\ProductVariations\Product\ProductIdMap::loadParentProductIdMapFromDbById()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:171 `Tygh\Addons\ProductVariations\Product\Group\Repository::getParentProductIdMap()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/ProductIdMap.php:260 `Tygh\Addons\ProductVariations\Tools\Query::column()` /home/alpha/live/multivendor/app/addons/product_variations/src/Product/Group/Repository.php:577 `Tygh\Database\Connection::getSingleHash()` /home/alpha/live/multivendor/app/addons/product_variations/src/Tools/Query.php:329 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:546	0.00020	Re-run Backtrace
74	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68941 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_url()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1987 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00050	Re-run Backtrace
75	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68941` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_product_amount()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1988 `db_get_field()` /home/alpha/live/multivendor/app/functions/fn.products.php:3673 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00015	Re-run Backtrace
76	`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2162` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `db_get_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2009 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00025	Re-run Backtrace
77	`SELECT firstname, lastname FROM cscart_users WHERE user_id = 21551` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:41 `fn_get_user_name()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:2015 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:169 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00016	Re-run Backtrace
78	`SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 16738 and status= 'A'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_run_controller()` /home/alpha/live/multivendor/app/functions/fn.control.php:461 `include()` /home/alpha/live/multivendor/app/functions/fn.control.php:722 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/controllers/frontend/publicprofile.php:45 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00024	Re-run Backtrace
79	`SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_check_permissions()` /home/alpha/live/multivendor/app/functions/fn.control.php:518 `fn_check_admin_permissions()` /home/alpha/live/multivendor/app/functions/fn.common.php:2511 `db_get_fields()` /home/alpha/live/multivendor/app/functions/fn.common.php:2690 `Tygh\Database\Connection::getColumn()` /home/alpha/live/multivendor/app/functions/fn.database.php:85 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:454	0.00029	Re-run Backtrace
80	`SELECT object_id FROM cscart_seo_redirects where src = '/publicprofile/?user_id=16738' AND type = 'p'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:623 `fn_kl_easyinsights_dispatch_before_display()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_kl_easyinsights_get_product_id_by_seo()` /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:252 `db_get_field()` /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:693 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00026	Re-run Backtrace
81	`SELECT vd.variant FROM cscart_product_feature_variant_descriptions vd INNER JOIN cscart_product_features_values pfv ON pfv.variant_id = vd.variant_id WHERE pfv.feature_id = 62 AND pfv.product_id = 0 AND vd.lang_code = 'en'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.control.php:623 `fn_kl_easyinsights_dispatch_before_display()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_get_product_brand_name()` /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:254 `db_get_field()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:65 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00029	Re-run Backtrace
82	`SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:132 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e9100276c3_23449422()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_block_styles()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ce3d9e5f9c0c489c7e73be52d8048d88dc732574.tygh.styles.tpl.php:127 `fn_get_storage_data()` /home/alpha/live/multivendor/app/functions/smarty_plugins/block.styles.php:132 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.control.php:1055 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00017	Re-run Backtrace
83	`SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 420 AND c.company_id = 0` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::__construct()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:129 `Tygh\BlockManager\Container::getList()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:111 `db_get_hash_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:72 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00023	Re-run Backtrace
84	`SELECT layout_id FROM cscart_bm_locations WHERE location_id = 420` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::__construct()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:129 `Tygh\BlockManager\Container::getList()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:112 `db_get_field()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:60 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00017	Re-run Backtrace
85	SELECT c.*, IF (c.location_id != 420, 0, 1) as `default` FROM cscart_bm_containers as c INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::__construct()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Container::getListByArea()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:129 `Tygh\BlockManager\Container::getList()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:112 `db_get_hash_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Container.php:72 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00202	Re-run Backtrace
86	`SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (1447, 1446, 1680, 1449) ORDER BY g.order, g.parent_id, g.grid_id ASC` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::__construct()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Grid::getList()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:133 `db_get_hash_multi_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Grid.php:63 `Tygh\Database\Connection::getMultiHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:500	0.00060	Re-run Backtrace
87	SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.,cscart_bm_blocks.,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (2167, 2168, 2169, 2176, 2178, 2179, 2173, 2170, 2172, 2171, 2177, 2175, 2174, 2180, 2183, 2188, 2192, 2189, 2648, 2190, 2187, 2191, 2193, 2194, 2195, 2196, 2791, 2792, 2793) AND cscart_bm_blocks_descriptions.lang_code='en' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::__construct()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:50 `Tygh\BlockManager\Block::getList()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:137 `db_get_hash_multi_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/Block.php:249 `Tygh\Database\Connection::getMultiHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:98 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:500	0.00344	Re-run Backtrace
88	`SELECT * FROM cscart_profile_fields WHERE section="K" \|\| field_id IN (6, 7)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410 `Tygh\BlockManager\SchemesManager::getBlockScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461 `Tygh\BlockManager\SchemesManager::_getScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136 `fn_get_schema()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404 `include()` /home/alpha/live/multivendor/app/functions/fn.common.php:2436 `fn_kl_personal_page_get_profile_field_variables()` /home/alpha/live/multivendor/app/addons/kl_chat/schemas/block_manager/blocks.post.php:23 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_personal_page/func.php:23 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00080	Re-run Backtrace
89	`SELECT * FROM cscart_profile_fields WHERE section="K"` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410 `Tygh\BlockManager\SchemesManager::getBlockScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461 `Tygh\BlockManager\SchemesManager::_getScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136 `fn_get_schema()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404 `include()` /home/alpha/live/multivendor/app/functions/fn.common.php:2436 `fn_kl_tips_get_block_active_profile_fileds()` /home/alpha/live/multivendor/app/addons/kl_tips/schemas/block_manager/blocks.post.php:24 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_tips/func.php:62 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00034	Re-run Backtrace
90	`SELECT * FROM cscart_profile_fields WHERE section="K"` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410 `Tygh\BlockManager\SchemesManager::getBlockScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461 `Tygh\BlockManager\SchemesManager::_getScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136 `fn_get_schema()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404 `include()` /home/alpha/live/multivendor/app/functions/fn.common.php:2436 `fn_kl_tips_get_block_active_profile_fileds()` /home/alpha/live/multivendor/app/addons/kl_tips/schemas/block_manager/blocks.post.php:32 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_tips/func.php:62 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00036	Re-run Backtrace
91	`SELECT * FROM cscart_profile_fields WHERE section="K" \|\| field_id IN (6, 7)` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::isBlockEligibleForCurrentLocation()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:410 `Tygh\BlockManager\SchemesManager::getBlockScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:461 `Tygh\BlockManager\SchemesManager::_getScheme()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:136 `fn_get_schema()` /home/alpha/live/multivendor/app/Tygh/BlockManager/SchemesManager.php:404 `include()` /home/alpha/live/multivendor/app/functions/fn.common.php:2436 `fn_kl_personal_page_get_profile_field_variables()` /home/alpha/live/multivendor/app/addons/kl_personal_page/schemas/block_manager/blocks.post.php:439 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_personal_page/func.php:23 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00036	Re-run Backtrace
92	`SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users WHERE user_id = 16738 AND status = 'A'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_get_user_short_info()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:726 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:155 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00057	Re-run Backtrace
93	`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=4246` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_get_user_image()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:306 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:673 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00026	Re-run Backtrace
94	`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=51` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_get_user_image()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:306 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:673 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00023	Re-run Backtrace
95	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 36368 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_url()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:353 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00035	Re-run Backtrace
96	`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=51` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_get_user_image()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:306 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:673 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00036	Re-run Backtrace
97	`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=21551` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_get_user_image()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:306 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:673 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00058	Re-run Backtrace
98	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 48466 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_url()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:353 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00030	Re-run Backtrace
99	`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=21551` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_get_user_image()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:306 `db_get_array()` /home/alpha/live/multivendor/app/addons/kl_perfect_match_quiz/func.php:673 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00029	Re-run Backtrace
100	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 61552 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en' Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::_renderMainContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:639 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:785 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e9113a94f2_57610804()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `Smarty_Internal_Template::getSubTemplate()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/686a1d4eae550240450c97544f354e2b072d3c07.tygh.profiles.tpl.php:849 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:304 `content_6964e911411395_24011260()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `fn_url()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/2f1c908571afe4d4313efe4d58178f7290e0cab0.tygh.grid_item_player.tpl.php:353 `fn_set_hook()` /home/alpha/live/multivendor/app/functions/fn.common.php:3921 `fn_seo_url_post()` /home/alpha/live/multivendor/app/functions/fn.control.php:123 `fn_seo_get_name()` /home/alpha/live/multivendor/app/addons/seo/func.php:1561 `db_get_row()` /home/alpha/live/multivendor/app/addons/seo/func.php:1295 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00035	Re-run Backtrace
101	`SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users WHERE user_id = 16738 AND status = 'A'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819 `fn_get_public_wishlist_data()` `fn_get_user_short_info()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:3669 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.users.php:155 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00027	Re-run Backtrace
102	`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='62827'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819 `kl_get_mixed_content()` `get_user_profile_pic()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:371 `db_get_array()` /home/alpha/live/multivendor/app/addons/my_changes/func.php:809 `Tygh\Database\Connection::getArray()` /home/alpha/live/multivendor/app/functions/fn.database.php:35 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:307	0.00019	Re-run Backtrace
103	`SELECT COUNT(DISTINCT cv.video_id) FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' WHERE 1 AND cv.user_id = 16738 AND cv.status='A'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819 `kl_get_mixed_content()` `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:379 `db_get_field()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1910 `Tygh\Database\Connection::getField()` /home/alpha/live/multivendor/app/functions/fn.database.php:73 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:422	0.00036	Re-run Backtrace
104	SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cvd.youtube_id, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != '' THEN CONCAT('https://cdn.kindlife.in/', MAX(mum.avatar)) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id WHERE 1 AND cv.user_id = 16738 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC LIMIT 0, 10 Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\SmartyEngine\Core::fetch()` /home/alpha/live/multivendor/app/functions/fn.control.php:632 `Smarty_Internal_TemplateBase::fetch()` /home/alpha/live/multivendor/app/Tygh/SmartyEngine/Core.php:81 `content_6964e90fe32458_93311778()` /home/alpha/live/multivendor/app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:188 `smarty_function_render_location()` /home/alpha/live/multivendor/var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php:193 `Tygh\BlockManager\RenderManager::render()` /home/alpha/live/multivendor/app/functions/smarty_plugins/function.render_location.php:52 `Tygh\BlockManager\RenderManager::_renderContainer()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:164 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:200 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderGrids()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:369 `Tygh\BlockManager\RenderManager::renderGrid()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:230 `Tygh\BlockManager\RenderManager::renderBlocks()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:373 `Tygh\BlockManager\RenderManager::renderBlock()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:415 `Tygh\BlockManager\RenderManager::renderBlockContent()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:493 `Tygh\BlockManager\RenderManager::getValue()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:666 `call_user_func_array()` /home/alpha/live/multivendor/app/Tygh/BlockManager/RenderManager.php:819 `kl_get_mixed_content()` `fn_cp_videos_get_cscart_videos_data()` /home/alpha/live/multivendor/app/addons/kl_recombee/func.php:379 `db_get_hash_array()` /home/alpha/live/multivendor/app/addons/cp_video_gallery/func.php:1920 `Tygh\Database\Connection::getHash()` /home/alpha/live/multivendor/app/functions/fn.database.php:48 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:345	0.00044	Re-run Backtrace
105	`SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'` Backtrace `fn_dispatch()` /home/alpha/live/multivendor/index.php:38 `Tygh\Application::offsetGet()` /home/alpha/live/multivendor/app/functions/fn.control.php:648 `Pimple\Container::offsetGet()` /home/alpha/live/multivendor/app/Tygh/Application.php:135 `Tygh\Providers\CommonProvider::Tygh\Providers\{closure}()` /home/alpha/live/multivendor/app/lib/vendor/pimple/pimple/src/Pimple/Container.php:118 `fn_get_storage_data()` /home/alpha/live/multivendor/app/Tygh/Providers/CommonProvider.php:77 `db_get_row()` /home/alpha/live/multivendor/app/functions/fn.control.php:1055 `Tygh\Database\Connection::getRow()` /home/alpha/live/multivendor/app/functions/fn.database.php:60 `Tygh\Database\Connection::query()` /home/alpha/live/multivendor/app/Tygh/Database/Connection.php:388	0.00040	Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 2
Query	Count	Min time	Max time	Average time
`SELECT * FROM cscart_profile_fields WHERE section="K" \|\| field_id IN (6, 7)`	2	0.00036	0.00080	0.00058
`SELECT firstname, lastname FROM cscart_users WHERE user_id = 21551`	2	0.00016	0.00021	0.00018
`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=21551`	2	0.00029	0.00058	0.00044
`SELECT firstname, lastname FROM cscart_users WHERE user_id = 51`	2	0.00016	0.00017	0.00017
`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=51`	2	0.00023	0.00036	0.00030
`SELECT user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users WHERE user_id = 16738 AND status = 'A'`	2	0.00027	0.00057	0.00042
`SELECT * FROM cscart_profile_fields WHERE section="K"`	2	0.00034	0.00036	0.00035
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68917' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00055	0.00055	0.00055
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68941' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00039	0.00039	0.00039
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68941	1	0.00069	0.00069	0.00069
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68917`	1	0.00019	0.00019	0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68917 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00028	0.00028	0.00028
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68917)`	1	0.00017	0.00017	0.00017
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68917)`	1	0.00027	0.00027	0.00027
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='68917'`	1	0.00034	0.00034	0.00034
SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND (storefronts.url = 'dev1-ecom.kindlife.in' OR storefronts.url = 'www.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' OR storefronts.url LIKE 'dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' OR storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%') GROUP BY storefronts.storefront_id ORDER BY storefronts.url = 'dev1-ecom.kindlife.in' DESC, storefronts.url = 'www.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in' DESC, storefronts.url LIKE 'dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www.dev1-ecom.kindlife.in/%' DESC, storefronts.url LIKE 'www_.dev1-ecom.kindlife.in/%' desc	1	0.00070	0.00070	0.00070
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68917	1	0.00079	0.00079	0.00079
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68893`	1	0.00019	0.00019	0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68893 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00029	0.00029	0.00029
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68941)`	1	0.00031	0.00031	0.00031
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68893)`	1	0.00018	0.00018	0.00018
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (68893)`	1	0.00020	0.00020	0.00020
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='68893'`	1	0.00069	0.00069	0.00069
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '68893' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00069	0.00069	0.00069
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 68893	1	0.00115	0.00115	0.00115
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='68941'`	1	0.00070	0.00070	0.00070
`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2162`	1	0.00025	0.00025	0.00025
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (68941)`	1	0.00020	0.00020	0.00020
`SELECT * FROM cscart_bm_containers as c LEFT JOIN cscart_bm_grids as g ON g.container_id = c.container_id WHERE 1 AND g.container_id IN (1447, 1446, 1680, 1449) ORDER BY g.order, g.parent_id, g.grid_id ASC`	1	0.00060	0.00060	0.00060
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cvd.youtube_id, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != '' THEN CONCAT('https://cdn.kindlife.in/', MAX(mum.avatar)) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id WHERE 1 AND cv.user_id = 16738 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC LIMIT 0, 10	1	0.00044	0.00044	0.00044
`SELECT COUNT(DISTINCT cv.video_id) FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' WHERE 1 AND cv.user_id = 16738 AND cv.status='A'`	1	0.00036	0.00036	0.00036
`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='62827'`	1	0.00019	0.00019	0.00019
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 61552 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00035	0.00035	0.00035
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 48466 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00030	0.00030	0.00030
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 36368 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00035	0.00035	0.00035
`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=4246`	1	0.00026	0.00026	0.00026
SELECT cscart_bm_snapping.grid_id as grid_id,cscart_bm_snapping.block_id as block_id,IFNULL(dynamic_object_content.content, default_content.content) as content,IFNULL(dynamic_object_content.object_id, default_content.object_id) AS object_id,IFNULL(dynamic_object_content.object_type, default_content.object_type) AS object_type,cscart_bm_block_statuses.object_ids as object_ids,cscart_bm_snapping.,cscart_bm_blocks.,cscart_bm_blocks_descriptions.* FROM cscart_bm_snapping LEFT JOIN cscart_bm_blocks ON cscart_bm_blocks.block_id = cscart_bm_snapping.block_id LEFT JOIN cscart_bm_block_statuses ON cscart_bm_snapping.snapping_id = cscart_bm_block_statuses.snapping_id AND cscart_bm_block_statuses.object_type LIKE '' LEFT JOIN cscart_bm_blocks_descriptions ON cscart_bm_blocks.block_id = cscart_bm_blocks_descriptions.block_id LEFT JOIN cscart_bm_blocks_content AS default_content ON cscart_bm_blocks.block_id = default_content.block_id AND cscart_bm_blocks_descriptions.lang_code = default_content.lang_code AND default_content.snapping_id = 0 AND default_content.object_id = 0 AND default_content.object_type like '' LEFT JOIN cscart_bm_blocks_content AS dynamic_object_content ON cscart_bm_blocks.block_id = dynamic_object_content.block_id AND cscart_bm_blocks_descriptions.lang_code = dynamic_object_content.lang_code AND dynamic_object_content.object_id = 0 AND dynamic_object_content.object_type like '' WHERE cscart_bm_snapping.grid_id IN (2167, 2168, 2169, 2176, 2178, 2179, 2173, 2170, 2172, 2171, 2177, 2175, 2174, 2180, 2183, 2188, 2192, 2189, 2648, 2190, 2187, 2191, 2193, 2194, 2195, 2196, 2791, 2792, 2793) AND cscart_bm_blocks_descriptions.lang_code='en' ORDER BY cscart_bm_snapping.order, cscart_bm_snapping.block_id	1	0.00344	0.00344	0.00344
SELECT c.*, IF (c.location_id != 420, 0, 1) as `default` FROM cscart_bm_containers as c INNER JOIN cscart_bm_locations as l ON c.location_id = l.location_id AND l.is_default = 1 AND l.layout_id = 10 WHERE 1 AND c.position IN ('TOP_PANEL', 'HEADER', 'FOOTER') AND c.company_id = 0	1	0.00202	0.00202	0.00202
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 68941 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00050	0.00050	0.00050
`SELECT layout_id FROM cscart_bm_locations WHERE location_id = 420`	1	0.00017	0.00017	0.00017
`SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 420 AND c.company_id = 0`	1	0.00023	0.00023	0.00023
`SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'`	1	0.00017	0.00017	0.00017
`SELECT vd.variant FROM cscart_product_feature_variant_descriptions vd INNER JOIN cscart_product_features_values pfv ON pfv.variant_id = vd.variant_id WHERE pfv.feature_id = 62 AND pfv.product_id = 0 AND vd.lang_code = 'en'`	1	0.00029	0.00029	0.00029
`SELECT object_id FROM cscart_seo_redirects where src = '/publicprofile/?user_id=16738' AND type = 'p'`	1	0.00026	0.00026	0.00026
`SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)`	1	0.00029	0.00029	0.00029
`SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 16738 and status= 'A'`	1	0.00024	0.00024	0.00024
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 66853`	1	0.00017	0.00017	0.00017
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 68941`	1	0.00015	0.00015	0.00015
`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2163`	1	0.00021	0.00021	0.00021
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 66853 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00029	0.00029	0.00029
`SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'`	1	0.00031	0.00031	0.00031
`SELECT * FROM cscart_se_settings`	1	0.00027	0.00027	0.00027
`SELECT video_id, GROUP_CONCAT(DISTINCT product_id ORDER BY product_id ASC SEPARATOR ', ') as products FROM cscart_cp_video_product_links WHERE video_id IN (2166, 2164, 2165, 2163, 2162) GROUP BY video_id`	1	0.00051	0.00051	0.00051
SELECT cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cvd.youtube_id, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cv.community_url, cu.firstname, CASE WHEN MAX(mum.avatar) IS NOT NULL AND MAX(mum.avatar) != '' THEN CONCAT('https://cdn.kindlife.in/', MAX(mum.avatar)) ELSE 'https://cdn.kindlife.in/images/ui_icon/user-default.svg' END AS userAvatar FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' LEFT JOIN cscart_users cu ON cu.user_id = cv.user_id LEFT JOIN kl_user_pref_master mum ON cv.user_id = mum.user_id WHERE 1 AND cv.status='A' GROUP BY cv.video_id, cvd.video, cvd.description, cvd.short_description, cvd.like_count, cvd.comment_count, cv.status, cv.user_id, cv.community_thumbnail, cv.community_video_url, cu.firstname ORDER BY cv.timestamp DESC LIMIT 0, 5	1	0.04034	0.04034	0.04034
`SELECT COUNT(DISTINCT cv.video_id) FROM cscart_cp_videos cv LEFT JOIN cscart_cp_video_descriptions cvd ON cvd.video_id = cv.video_id AND cvd.lang_code = 'en' WHERE 1 AND cv.status='A'`	1	0.00543	0.00543	0.00543
`SELECT target_id FROM kl_likes WHERE user_id = 16738 and type= 'Video_Video'`	1	0.00049	0.00049	0.00049
`SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 16738`	1	0.00017	0.00017	0.00017
`SELECT us.user_type,us.timestamp,pref.avatar,pref.isExpert,pref.expertDomains,pref.order_success_cnt,pref.prod_review_cnt,JSON_EXTRACT(pref.new_user_preferences, '$.kindcrew') AS kindcrew,pref.user_name,pref.dob,pref.blog_cnt,pref.video_cnt,pref.about,pref.gender from kl_user_pref_master pref left join cscart_users us on pref.user_id = us.user_id WHERE pref.user_id=16738`	1	0.00147	0.00147	0.00147
`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='16738'`	1	0.00131	0.00131	0.00131
`SELECT * FROM cscart_bm_locations as l LEFT JOIN cscart_bm_locations_descriptions as d ON d.location_id = l.location_id AND d.lang_code = 'en' WHERE l.layout_id = 10 AND l.dispatch IN ('publicprofile.profiles') ORDER BY l.object_ids desc LIMIT 1`	1	0.00356	0.00356	0.00356
`SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 10`	1	0.00020	0.00020	0.00020
`SELECT * FROM cscart_languages WHERE status = 'A'`	1	0.00035	0.00035	0.00035
`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2166`	1	0.00038	0.00038	0.00038
`SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'`	1	0.00024	0.00024	0.00024
`SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'`	1	0.00017	0.00017	0.00017
`SELECT brand_id FROM cscart_users WHERE user_id = 0`	1	0.00023	0.00023	0.00023
`SELECT cscart_bm_layouts.* FROM cscart_bm_layouts WHERE 1 AND is_default = 1 AND theme_name = 'new_2bk' AND storefront_id = 1`	1	0.00024	0.00024	0.00024
`SELECT storefronts.* FROM cscart_storefronts AS storefronts WHERE 1 = 1 AND storefronts.storefront_id IN (1) GROUP BY storefronts.storefront_id ORDER BY storefronts.is_default desc`	1	0.00026	0.00026	0.00026
`SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages WHERE 1 AND cscart_languages.status = 'A'`	1	0.00028	0.00028	0.00028
`SELECT * FROM cscart_seo_names WHERE name = 'publicprofile' AND lang_code = 'en'`	1	0.00040	0.00040	0.00040
`SELECT type FROM cscart_seo_names WHERE name = 'publicprofile'`	1	0.00050	0.00050	0.00050
`SET time_zone = '+05:30'`	1	0.00119	0.00119	0.00119
`SELECT ctl.object_id as video_id, GROUP_CONCAT(DISTINCT ct.tag ORDER BY ct.tag ASC SEPARATOR ', ') as tags FROM cscart_tag_links ctl LEFT JOIN cscart_tags ct ON ct.tag_id = ctl.tag_id WHERE ctl.object_id IN (2166, 2164, 2165, 2163, 2162) GROUP BY ctl.object_id`	1	0.00100	0.00100	0.00100
`SELECT firstname, lastname FROM cscart_users WHERE user_id = 4246`	1	0.00019	0.00019	0.00019
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (66853)`	1	0.00015	0.00015	0.00015
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26038)`	1	0.00016	0.00016	0.00016
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (66853)`	1	0.00017	0.00017	0.00017
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='66853'`	1	0.00027	0.00027	0.00027
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '66853' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00044	0.00044	0.00044
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 66853	1	0.00075	0.00075	0.00075
`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2165`	1	0.00019	0.00019	0.00019
`SELECT t.tag_id as id, tl.object_id as target_id, CASE WHEN tl.object_type = 'V' THEN 'Video_Video' ELSE tl.object_type END as type, t.tag FROM cscart_tag_links tl INNER JOIN cscart_tags t ON tl.tag_id = t.tag_id WHERE tl.object_id = 2164`	1	0.00019	0.00019	0.00019
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26038`	1	0.00015	0.00015	0.00015
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26038 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00029	0.00029	0.00029
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26038)`	1	0.00026	0.00026	0.00026
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26038'`	1	0.00048	0.00048	0.00048
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 26036	1	0.00099	0.00099	0.00099
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '26038' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00056	0.00056	0.00056
SELECT cscart_products.product_id,cscart_products.product_code,cscart_products.status,cscart_products.company_id,cscart_products.list_price,cscart_products.shipping_params,cscart_product_review_prepared_data.average_rating, cscart_product_descriptions.product,cscart_product_descriptions.short_description,cscart_product_descriptions.full_description,cscart_product_descriptions.promo_text,IFNULL(avg(opr.rating_value),3) as actual_rating,cd.category,cd.category_id,cc.category_id as main_category,pvd.variant_id,pvd.variant, MIN(IF(cscart_product_prices.percentage_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product_prices.price * cscart_product_prices.percentage_discount)/100)) as price FROM cscart_products LEFT JOIN cscart_product_prices ON cscart_product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit = 1 AND cscart_product_prices.usergroup_id IN (0) LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id LEFT JOIN cscart_product_review_prepared_data ON cscart_product_review_prepared_data.product_id = cscart_products.product_id left join cscart_product_reviews opr on opr.product_id = cscart_products.product_id and opr.status = "A" left join cscart_product_features_values pfv on pfv.product_id = cscart_products.product_id AND pfv.feature_id = 62 left join cscart_product_feature_variant_descriptions pvd on pvd.variant_id = pfv.variant_id inner join cscart_products_categories pc on pc.product_id = cscart_products.product_id inner join cscart_categories cc on cc.category_id = pc.category_id and pc.link_type = "M" inner join cscart_category_descriptions cd on cd.category_id = cc.parent_id AND cscart_product_descriptions.lang_code = 'en' WHERE cscart_products.product_id = 26038	1	0.00163	0.00163	0.00163
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26036`	1	0.00037	0.00037	0.00037
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26036 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00257	0.00257	0.00257
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26036)`	1	0.00037	0.00037	0.00037
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26036)`	1	0.00016	0.00016	0.00016
`SELECT storefronts.* FROM cscart_storefronts AS storefronts LEFT JOIN cscart_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`	1	0.00031	0.00031	0.00031
`SELECT cscart_languages.* FROM cscart_languages WHERE 1`	1	0.00012	0.00012	0.00012
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26036'`	1	0.00033	0.00033	0.00033
SELECT cscart_images., cscart_images_links., cscart_common_descriptions.description AS alt, cscart_images.image_id AS images_image_id FROM cscart_images_links LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id AND cscart_common_descriptions.object_holder = 'images' AND cscart_common_descriptions.lang_code = 'en' WHERE cscart_images_links.object_type = 'product' AND cscart_images_links.type = 'M' AND cscart_images_links.object_id = '26036' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00041	0.00041	0.00041
`SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'`	1	0.00040	0.00040	0.00040


	Sandbox

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace

Backtrace