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 ='49952'
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=49952
SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 49952
SELECT target_id FROM kl_likes WHERE user_id = 49952 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 (2168, 2167, 2166, 2164, 2165) 
            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 (2168, 2167, 2166, 2164, 2165) 
            GROUP BY ctl.object_id
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
                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 = 2168
SELECT firstname, lastname FROM cscart_users WHERE user_id = 4246
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 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 = 26037 
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 = '26037' ORDER BY cscart_images_links.position, cscart_images_links.pair_id
SELECT count(*) as count from cscart_product_reviews WHERE product_id='26037'
SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26037)
SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26037)
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26037 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en' 
SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26037
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 COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 49952 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=49952' 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 = 49952 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 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=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 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 user_id, helpdesk_user_id, user_login, company_id, firstname, lastname, email, user_type, password_change_timestamp, phone FROM cscart_users  WHERE  user_id = 49952 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 = 49952 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 = 49952 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.08452 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.00036	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.00024	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.00009	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.00025	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.00025	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.00013	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.00015	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.00019	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.00015	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.00012	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.00278	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.00013	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.00016	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.00015	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.00220	Re-run Backtrace
16	`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='49952'` 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.00019	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=49952` 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.00028	Re-run Backtrace
18	`SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 49952` 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.00015	Re-run Backtrace
19	`SELECT target_id FROM kl_likes WHERE user_id = 49952 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.00022	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.00206	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.02179	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 (2168, 2167, 2166, 2164, 2165) 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.00022	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 (2168, 2167, 2166, 2164, 2165) 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.00022	Re-run Backtrace
24	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.00106	Re-run Backtrace
25	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.00050	Re-run Backtrace
26	`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.00088	Re-run Backtrace
27	`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.00026	Re-run Backtrace
28	`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.00034	Re-run Backtrace
29	`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.00090	Re-run Backtrace
30	`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.00162	Re-run Backtrace
31	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.00150	Re-run Backtrace
32	`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.00511	Re-run Backtrace
33	`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 = 2168` 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.00160	Re-run Backtrace
34	`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.00017	Re-run Backtrace
35	`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.00098	Re-run Backtrace
36	`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.00054	Re-run Backtrace
37	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.00069	Re-run Backtrace
38	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.00123	Re-run Backtrace
39	`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.00037	Re-run Backtrace
40	`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.00065	Re-run Backtrace
41	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 = 26037 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.00065	Re-run Backtrace
42	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 = '26037' 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.00099	Re-run Backtrace
43	`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26037'` 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.00041	Re-run Backtrace
44	`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26037)` 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.00029	Re-run Backtrace
45	`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26037)` 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.00021	Re-run Backtrace
46	SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26037 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.00051	Re-run Backtrace
47	`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26037` 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.00025	Re-run Backtrace
48	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.00152	Re-run Backtrace
49	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.00059	Re-run Backtrace
50	`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.00031	Re-run Backtrace
51	`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.00021	Re-run Backtrace
52	`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.00014	Re-run Backtrace
53	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.00026	Re-run Backtrace
54	`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.00010	Re-run Backtrace
55	`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.00170	Re-run Backtrace
56	`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.00054	Re-run Backtrace
57	`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.00054	Re-run Backtrace
58	`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.00014	Re-run Backtrace
59	`SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 49952 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.00106	Re-run Backtrace
60	`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.00044	Re-run Backtrace
61	`SELECT object_id FROM cscart_seo_redirects where src = '/publicprofile/?user_id=49952' 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:270 `db_get_field()` /home/alpha/live/multivendor/app/addons/kl_easyinsights/func.php:736 `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.00035	Re-run Backtrace
62	`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:272 `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.00023	Re-run Backtrace
63	`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_6972128e925349_42909905()` /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_6972128ea645c0_89706983()` /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.00016	Re-run Backtrace
64	`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_6972128e925349_42909905()` /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.00026	Re-run Backtrace
65	`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_6972128e925349_42909905()` /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
66	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_6972128e925349_42909905()` /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.00293	Re-run Backtrace
67	`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_6972128e925349_42909905()` /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.00129	Re-run Backtrace
68	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_6972128e925349_42909905()` /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.00324	Re-run Backtrace
69	`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_6972128e925349_42909905()` /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.00048	Re-run Backtrace
70	`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_6972128e925349_42909905()` /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.00049	Re-run Backtrace
71	`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_6972128e925349_42909905()` /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.00248	Re-run Backtrace
72	`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_6972128e925349_42909905()` /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.00042	Re-run Backtrace
73	`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 = 49952 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_6972128e925349_42909905()` /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_6972136a7cdf54_56973186()` /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.00021	Re-run Backtrace
74	`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_6972128e925349_42909905()` /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_6972136a7cdf54_56973186()` /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_697212b98b7c00_08924043()` /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.00142	Re-run Backtrace
75	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_6972128e925349_42909905()` /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_6972136a7cdf54_56973186()` /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_697212b98b7c00_08924043()` /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.00037	Re-run Backtrace
76	`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_6972128e925349_42909905()` /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_6972136a7cdf54_56973186()` /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_697212b98b7c00_08924043()` /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.00034	Re-run Backtrace
77	`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_6972128e925349_42909905()` /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_6972136a7cdf54_56973186()` /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_697212b98b7c00_08924043()` /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.00022	Re-run Backtrace
78	`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_6972128e925349_42909905()` /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_6972136a7cdf54_56973186()` /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_697212b98b7c00_08924043()` /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.00062	Re-run Backtrace
79	`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 = 49952 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_6972128e925349_42909905()` /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.00167	Re-run Backtrace
80	`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_6972128e925349_42909905()` /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.00017	Re-run Backtrace
81	`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 = 49952 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_6972128e925349_42909905()` /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.00043	Re-run Backtrace
82	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 = 49952 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_6972128e925349_42909905()` /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.00050	Re-run Backtrace
83	`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.00432	Re-run Backtrace

Warning Some queries are being executed multiple times

Queries max count: 2
Query	Count	Min time	Max time	Average time
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	2	0.00069	0.00106	0.00087
`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 = 49952 AND status = 'A'`	2	0.00021	0.00167	0.00094
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	2	0.00050	0.00123	0.00087
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26036'`	2	0.00037	0.00088	0.00062
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26036`	2	0.00065	0.00511	0.00288
`SELECT firstname, lastname FROM cscart_users WHERE user_id = 51`	2	0.00014	0.00054	0.00034
`SELECT * FROM cscart_profile_fields WHERE section="K"`	2	0.00049	0.00248	0.00149
`SELECT * FROM cscart_profile_fields WHERE section="K" \|\| field_id IN (6, 7)`	2	0.00042	0.00048	0.00045
`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`	2	0.00034	0.00142	0.00088
`SELECT firstname, lastname FROM cscart_users WHERE user_id = 4246`	2	0.00017	0.00054	0.00036
`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.00022	0.00062	0.00042
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26038'`	1	0.00031	0.00031	0.00031
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.00059	0.00059	0.00059
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26038)`	1	0.00021	0.00021	0.00021
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26038)`	1	0.00014	0.00014	0.00014
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26038 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00026	0.00026	0.00026
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26038`	1	0.00010	0.00010	0.00010
`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.00170	0.00170	0.00170
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.00152	0.00152	0.00152
`SELECT prod.amount FROM cscart_products AS prod WHERE prod.product_id = 26037`	1	0.00025	0.00025	0.00025
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.00036	0.00036	0.00036
`SELECT privilege FROM cscart_usergroup_privileges WHERE usergroup_id IN (0, 1)`	1	0.00044	0.00044	0.00044
`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.00054	0.00054	0.00054
`SELECT COUNT(DISTINCT video_id) as video_count FROM cscart_cp_videos WHERE user_id = 49952 and status= 'A'`	1	0.00106	0.00106	0.00106
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26037)`	1	0.00021	0.00021	0.00021
`SELECT object_id FROM cscart_seo_redirects where src = '/publicprofile/?user_id=49952' AND type = 'p'`	1	0.00035	0.00035	0.00035
`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.00023	0.00023	0.00023
`SELECT data FROM cscart_storage_data WHERE data_key = 'cache_id'`	1	0.00016	0.00016	0.00016
`SELECT c.* FROM cscart_bm_containers as c WHERE 1 AND c.location_id = 420 AND c.company_id = 0`	1	0.00026	0.00026	0.00026
`SELECT layout_id FROM cscart_bm_locations WHERE location_id = 420`	1	0.00017	0.00017	0.00017
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.00293	0.00293	0.00293
`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.00129	0.00129	0.00129
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.00324	0.00324	0.00324
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 36368 AND `type` = 'e' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00037	0.00037	0.00037
`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='62827'`	1	0.00017	0.00017	0.00017
`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 = 49952 AND cv.status='A'`	1	0.00043	0.00043	0.00043
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 = 49952 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.00050	0.00050	0.00050
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26037 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00051	0.00051	0.00051
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 = '26037' ORDER BY cscart_images_links.position, cscart_images_links.pair_id	1	0.00099	0.00099	0.00099
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26037)`	1	0.00029	0.00029	0.00029
`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=49952`	1	0.00028	0.00028	0.00028
`SET time_zone = '+05:30'`	1	0.00009	0.00009	0.00009
`SELECT type FROM cscart_seo_names WHERE name = 'publicprofile'`	1	0.00025	0.00025	0.00025
`SELECT * FROM cscart_seo_names WHERE name = 'publicprofile' AND lang_code = 'en'`	1	0.00025	0.00025	0.00025
`SELECT cscart_languages.lang_code, cscart_languages.name FROM cscart_languages WHERE 1 AND cscart_languages.status = 'A'`	1	0.00013	0.00013	0.00013
`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.00015	0.00015	0.00015
`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.00019	0.00019	0.00019
`SELECT brand_id FROM cscart_users WHERE user_id = 0`	1	0.00015	0.00015	0.00015
`SELECT data FROM cscart_storage_data WHERE data_key = 'cart_products_next_check'`	1	0.00012	0.00012	0.00012
`SELECT data FROM cscart_storage_data WHERE data_key = 'dev_mode'`	1	0.00278	0.00278	0.00278
`SELECT * FROM cscart_languages WHERE status = 'A'`	1	0.00013	0.00013	0.00013
`SELECT * FROM cscart_se_settings`	1	0.00016	0.00016	0.00016
`SELECT * FROM cscart_bm_layouts WHERE 1 AND storefront_id = 1 AND layout_id = 10`	1	0.00015	0.00015	0.00015
`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.00220	0.00220	0.00220
`SELECT avatar as user_profile_pic,user_id FROM kl_user_pref_master WHERE user_id ='49952'`	1	0.00019	0.00019	0.00019
`SELECT expertDomains FROM kl_user_pref_master WHERE user_id = 49952`	1	0.00015	0.00015	0.00015
`SELECT count(*) as count from cscart_product_reviews WHERE product_id='26037'`	1	0.00041	0.00041	0.00041
`SELECT target_id FROM kl_likes WHERE user_id = 49952 and type= 'Video_Video'`	1	0.00022	0.00022	0.00022
`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.00206	0.00206	0.00206
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.02179	0.02179	0.02179
`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 (2168, 2167, 2166, 2164, 2165) GROUP BY video_id`	1	0.00022	0.00022	0.00022
`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 (2168, 2167, 2166, 2164, 2165) GROUP BY ctl.object_id`	1	0.00022	0.00022	0.00022
`SELECT cscart_languages.* FROM cscart_languages WHERE 1`	1	0.00026	0.00026	0.00026
`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.00034	0.00034	0.00034
`SELECT product_id, master_product_id, company_id FROM cscart_products WHERE product_id IN (26036)`	1	0.00090	0.00090	0.00090
`SELECT product_id, parent_product_id FROM cscart_product_variation_group_products WHERE product_id IN (26036)`	1	0.00162	0.00162	0.00162
SELECT name, path FROM cscart_seo_names WHERE `object_id` = 26036 AND `type` = 'p' AND `dispatch` = '' AND `lang_code` = 'en'	1	0.00150	0.00150	0.00150
`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 = 2168`	1	0.00160	0.00160	0.00160
`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.00098	0.00098	0.00098
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 = 26037	1	0.00065	0.00065	0.00065
`SELECT data FROM cscart_storage_data WHERE data_key = 'store_mode'`	1	0.00024	0.00024	0.00024
`SELECT data FROM cscart_storage_data WHERE data_key = 'restrictions'`	1	0.00432	0.00432	0.00432


	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