Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 37518
[include_child_variations] => 1
[group_child_variations] =>
[runtime_company_id] => 13
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 0
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 37518 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 37518
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => products
[value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
)
)
)
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (37518)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 37518
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[condition_element] => 62
[operator] => nin
[condition] => feature
[value] => 49321,40971,38308
[value_name] =>
)
)
)
[include_child_variations] => 1
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (37518)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array
(
[37518] => Array
(
[product_id] => 37518
[product] => The 6 Peptide Skin Booster Serum | 150ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[1991] => Array
(
[video_id] => 1991
[video_type] => A
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1745410748
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/skincare-heroes-this-summer
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1991_Skincare heroes_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1991_Skincare heroes.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Skincare heroes this summer!
[description] => Grab these amazing skincare heroes this summer—they'll hydrate, repair, and strengthen your skin for a healthy glow.
[short_description] =>
[privacy] => 1
[like_count] => 4
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 58656,10451,53920
[category_id] => 34
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1926] => Array
(
[video_id] => 1926
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1727680607
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/its-glow-times-besties
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1926_664C65B35B7C60D2D14F297EE03E4989_video_dashinit_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1926_664C65B35B7C60D2D14F297EE03E4989_video_dashinit.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => It’s glow times, besties??✨
[description] => Save 35% on the @cosrx 6 Peptide Skin Booster Serum - the holy grail for all your skincare needs!☺️
?BOOSTS HYDRATION: +162.5% moisture for that plump, dewy glow
?SOOTHES SENSITIVITY: Calms and nourishes sensitive skin, reduces redness
⬆️ MAXIMIZES EFFICACY: Makes your other skincare products work even better
Shop now from @kindlife.in and get your glass skin glow on!?️✨
Use the code - COSRXLUV for an extra 15% on your COSRX faves?
[short_description] =>
[privacy] => 1
[like_count] => 8
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 50
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1390] => Array
(
[video_id] => 1390
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1723016423
[status] => A
[user_id] => 231804
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/1-product-6-peptides-multiple-skincare-solutions
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1390_1C48AA8B2D272EDE2B13AE864619FCB1_video_dashinit_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1390_1C48AA8B2D272EDE2B13AE864619FCB1_video_dashinit.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => 1 Product, 6 Peptides, Multiple Skincare Solutions
[description] => Packed with the goodness of 6 powerful peptides to smooth, firm, and hydrate your skin, the COSRX Skin Booster Serum is your new skincare BFF!
- Increases hydration levels by 162.5%
- Improves skin texture
- Soothes sensitive skin
- Boosts natural collagen
Shop now and get that glass-glow skin!
[short_description] =>
[privacy] => 1
[like_count] => 10
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1387] => Array
(
[video_id] => 1387
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1722948435
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/hot-girl-skincare-routine-revealed
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1387_SaveInsta.App - 3408645724371113611_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1387_SaveInsta.App - 3408645724371113611.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Hot Girl Skincare Routine Revealed
[description] =>
Hot girls don't gatekeep, so we're spilling all the tea on how to achieve that dewy glass skin glow with our COSRX faves! Start with the 6 Peptide Booster Serum for a youthful radiance boost, then deeply hydrate with Hyaluronic Acid 3 for a plump, bouncy feel. Finish with the Advance Snail 92 All-In-One Cream to lock in moisture and rejuvenate your skin for a smooth, glowing complexion.
[short_description] =>
[privacy] => 1
[like_count] => 4
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 10451
[category_id] => 50
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1373] => Array
(
[video_id] => 1373
[video_type] => A
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720722600
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/glass-skin-glow-essentials-ft.-cosrx-faves
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1373_SaveInsta.App - 3409661547101428508_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1373_SaveInsta.App - 3409661547101428508.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Glass skin glow essentials ft. COSRX faves!
[description] => SKIN PREP with 6 Peptides Skin Booster Serum -
Improves overall skin texture and improves efficacy of your other skincare products
HYDRATE & NOURISH with Hyaluronic Acid 3 Serum -
Infused with ceramides, restores the skin's natural moisture balance
MOISTURISE with Advanced Snail 92 All In One Cream -
Repairs and hydrates your skin along with soothing irritated skin, reducing scarring, and promoting a healthy glow :)
[short_description] =>
[privacy] => 1
[like_count] => 6
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => COSRX
)
)
Array
(
[37518] => Array
(
[product_id] => 37518
[product] => The 6 Peptide Skin Booster Serum | 150ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 698
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[video_as_images] => Array
(
)
[videos] => Array
(
[1991] => Array
(
[video_id] => 1991
[video_type] => A
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1745410748
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/skincare-heroes-this-summer
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1991_Skincare heroes_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1991_Skincare heroes.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Skincare heroes this summer!
[description] => Grab these amazing skincare heroes this summer—they'll hydrate, repair, and strengthen your skin for a healthy glow.
[short_description] =>
[privacy] => 1
[like_count] => 4
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 58656,10451,53920
[category_id] => 34
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1926] => Array
(
[video_id] => 1926
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1727680607
[status] => A
[user_id] => 21551
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/its-glow-times-besties
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1926_664C65B35B7C60D2D14F297EE03E4989_video_dashinit_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1926_664C65B35B7C60D2D14F297EE03E4989_video_dashinit.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => It’s glow times, besties??✨
[description] => Save 35% on the @cosrx 6 Peptide Skin Booster Serum - the holy grail for all your skincare needs!☺️
?BOOSTS HYDRATION: +162.5% moisture for that plump, dewy glow
?SOOTHES SENSITIVITY: Calms and nourishes sensitive skin, reduces redness
⬆️ MAXIMIZES EFFICACY: Makes your other skincare products work even better
Shop now from @kindlife.in and get your glass skin glow on!?️✨
Use the code - COSRXLUV for an extra 15% on your COSRX faves?
[short_description] =>
[privacy] => 1
[like_count] => 8
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 50
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1390] => Array
(
[video_id] => 1390
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1723016423
[status] => A
[user_id] => 231804
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/1-product-6-peptides-multiple-skincare-solutions
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1390_1C48AA8B2D272EDE2B13AE864619FCB1_video_dashinit_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1390_1C48AA8B2D272EDE2B13AE864619FCB1_video_dashinit.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => 1 Product, 6 Peptides, Multiple Skincare Solutions
[description] => Packed with the goodness of 6 powerful peptides to smooth, firm, and hydrate your skin, the COSRX Skin Booster Serum is your new skincare BFF!
- Increases hydration levels by 162.5%
- Improves skin texture
- Soothes sensitive skin
- Boosts natural collagen
Shop now and get that glass-glow skin!
[short_description] =>
[privacy] => 1
[like_count] => 10
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1387] => Array
(
[video_id] => 1387
[video_type] => S
[company_id] => 0
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1722948435
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/hot-girl-skincare-routine-revealed
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1387_SaveInsta.App - 3408645724371113611_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1387_SaveInsta.App - 3408645724371113611.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Hot Girl Skincare Routine Revealed
[description] =>
Hot girls don't gatekeep, so we're spilling all the tea on how to achieve that dewy glass skin glow with our COSRX faves! Start with the 6 Peptide Booster Serum for a youthful radiance boost, then deeply hydrate with Hyaluronic Acid 3 for a plump, bouncy feel. Finish with the Advance Snail 92 All-In-One Cream to lock in moisture and rejuvenate your skin for a smooth, glowing complexion.
[short_description] =>
[privacy] => 1
[like_count] => 4
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] => 10451
[category_id] => 50
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
[1373] => Array
(
[video_id] => 1373
[video_type] => A
[company_id] => 13
[usergroup_ids] => 0
[position] => 0
[timestamp] => 1720722600
[status] => A
[user_id] => 151514
[extra_params] =>
[community_video_id] => 0
[community_url] => https://www.kindlife.in/glass-skin-glow-essentials-ft.-cosrx-faves
[community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1373_SaveInsta.App - 3409661547101428508_preview.jpg
[community_video_url] => https://cdn02.kindlife.in/images/video_library/1373_SaveInsta.App - 3409661547101428508.mp4
[community_last_sync_timestamp] => 0
[lang_code] => en
[youtube_id] =>
[video] => Glass skin glow essentials ft. COSRX faves!
[description] => SKIN PREP with 6 Peptides Skin Booster Serum -
Improves overall skin texture and improves efficacy of your other skincare products
HYDRATE & NOURISH with Hyaluronic Acid 3 Serum -
Infused with ceramides, restores the skin's natural moisture balance
MOISTURISE with Advanced Snail 92 All In One Cream -
Repairs and hydrates your skin along with soothing irritated skin, reducing scarring, and promoting a healthy glow :)
[short_description] =>
[privacy] => 1
[like_count] => 6
[dislike_count] => 0
[comment_count] => 0
[meta_keywords] =>
[meta_description] =>
[page_title] =>
[tagged_brands] =>
[category_id] => 7
[link_type] => M
[preview] => Array
(
[default_icon] => 1
)
)
)
[cp_has_video] => 1
[brand_name] => COSRX
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 37518
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => categories
[value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
)
)
)
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (37518)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( )
Array ( )
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[pid] => 37518
[limit] => 1
[total] => 1
[custom_extend] => Array
(
[0] => product_name
[1] => categories
)
[load_products_extra_data] =>
[force_virtual] => 1
[runtime_company_id] => 13
[vr_company_id] => 0
[is_virtual] => Y
[virtual_conditions] => Array
(
[set] => all
[set_value] => 1
[conditions] => Array
(
[1] => Array
(
[operator] => in
[condition] => categories
[value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
)
)
)
)
Array
(
[area] => C
[use_caching] => 1
[extend] => Array
(
[0] => product_name
[1] => prices
[2] => categories
)
[custom_extend] => Array
(
)
[pname] =>
[pshort] =>
[pfull] =>
[pkeywords] =>
[feature] => Array
(
)
[type] => simple
[page] => 1
[action] =>
[filter_variants] => Array
(
)
[features_hash] =>
[limit] => 0
[bid] => 0
[match] =>
[tracking] => Array
(
)
[get_frontend_urls] =>
[items_per_page] => 1
[apply_disabled_filters] =>
[load_products_extra_data] => 1
[storefront] =>
[company_ids] =>
[product_id] =>
)
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (37518)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( )
Array ( )
end of fxn
Cache: can not connect to the Redis server
app/Tygh/Backend/Cache/Redis.php, line: 220
| File: | app/Tygh/Backend/Cache/Redis.php |
| Line: | 217 |
| Function: | query |
| File: | app/Tygh/Backend/Cache/Redis.php |
| Line: | 97 |
| Function: | query |
| File: | app/Tygh/Registry.php |
| Line: | 456 |
| Function: | set |
| File: | app/Tygh/Registry.php |
| Line: | 95 |
| Function: | _saveCache |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 728 |
| Function: | set |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 493 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 415 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 373 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 230 |
| Function: | renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 200 |
| Function: | renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 164 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 52 |
| Function: | render |
| File: | var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php |
| Line: | 191 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_689464c1dbc0b1_26812820 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 81 |
| Function: | fetch |
| File: | app/functions/fn.control.php |
| Line: | 636 |
| Function: | fetch |
| File: | index.php |
| Line: | 39 |
| Function: | fn_dispatch |