1. 2609

  2. Array
(
    [0] => 2800
    [1] => 2841
)


  3. inside consumer HERE

  1. 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND ?:categories.category_id IN (2800) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 5

  1. 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)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count  ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND ?:categories.category_id IN (2841) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 5

  1. 0
Before init
Memory Files Queries Time
403,560 34 0 0
Cache: before redis connect
Memory Files Queries Time
96,288 (499,848) 50 (84) 0 (0) 0.0004 (0.0004)
Cache: after redis connect
Memory Files Queries Time
1,120 (500,968) 0 (84) 0 (0) 0.0001 (0.0005)
Before database connect
Memory Files Queries Time
126,960 (627,928) 21 (105) 0 (0) 0.0008 (0.0013)
After database connect
Memory Files Queries Time
44,080 (672,008) 0 (105) 0 (0) 0.0003 (0.0016)
After init
Memory Files Queries Time
1,878,616 (2,550,624) 319 (424) 19 (19) 0.0228 (0.0244)
Before TPL
Memory Files Queries Time
2,930,176 (5,480,800) 124 (548) 231 (250) 0.7416 (0.7660)
Start render location
Memory Files Queries Time
567,856 (6,048,656) 66 (614) 2 (252) 0.0101 (0.7761)
[Block] [CSS Custom Temporary ] Render begin
Memory Files Queries Time
1,122,576 (7,171,232) 57 (671) 41 (293) 0.0131 (0.7892)
[Block] [CSS Custom Temporary ] Render end
Memory Files Queries Time
83,248 (7,254,480) 6 (677) 0 (293) 0.0007 (0.7899)
[Block] [temps kiki ai css] Render begin
Memory Files Queries Time
2,544 (7,257,024) 0 (677) 0 (293) 0.0000 (0.7899)
[Block] [temps kiki ai css] Render end
Memory Files Queries Time
14,576 (7,271,600) 1 (678) 0 (293) 0.0002 (0.7901)
[Block] [top header icons temp css] Render begin
Memory Files Queries Time
2,168 (7,273,768) 0 (678) 0 (293) 0.0000 (0.7901)
[Block] [top header icons temp css] Render end
Memory Files Queries Time
62,648 (7,336,416) 1 (679) 0 (293) 0.0002 (0.7903)
[Block] [faded effect css for all buttons/links] Render begin
Memory Files Queries Time
2,184 (7,338,600) 0 (679) 0 (293) 0.0000 (0.7903)
[Block] [faded effect css for all buttons/links] Render end
Memory Files Queries Time
23,944 (7,362,544) 1 (680) 0 (293) 0.0001 (0.7904)
[Block] [Currencies] Render begin
Memory Files Queries Time
11,928 (7,374,472) 0 (680) 0 (293) 0.0001 (0.7905)
[Block] [Currencies] Render end
Memory Files Queries Time
72,816 (7,447,288) 4 (684) 1 (294) 0.0012 (0.7917)
[Block] [Top Coupon code strip] Render begin
Memory Files Queries Time
2,168 (7,449,456) 0 (684) 0 (294) 0.0000 (0.7918)
[Block] [Top Coupon code strip] Render end
Memory Files Queries Time
108,376 (7,557,832) 1 (685) 0 (294) 0.0004 (0.7921)
[Block] [open_hamburger] Render begin
Memory Files Queries Time
19,576 (7,577,408) 0 (685) 0 (294) 0.0001 (0.7923)
[Block] [open_hamburger] Render end
Memory Files Queries Time
145,688 (7,723,096) 3 (688) 5 (299) 0.0019 (0.7942)
[Block] [back-button] Render begin
Memory Files Queries Time
2,152 (7,725,248) 0 (688) 0 (299) 0.0000 (0.7942)
[Block] [back-button] Render end
Memory Files Queries Time
19,608 (7,744,856) 1 (689) 0 (299) 0.0002 (0.7944)
[Block] [Logo_2BK] Render begin
Memory Files Queries Time
8,584 (7,753,440) 0 (689) 0 (299) 0.0001 (0.7946)
[Block] [Logo_2BK] Render end
Memory Files Queries Time
22,120 (7,775,560) 2 (691) 0 (299) 0.0003 (0.7949)
[Block] [Search] Render begin
Memory Files Queries Time
2,840 (7,778,400) 0 (691) 0 (299) 0.0000 (0.7949)
[Block] [Search] Render end
Memory Files Queries Time
74,800 (7,853,200) 3 (694) 1 (300) 0.0007 (0.7957)
[Block] [sign in desktop] Render begin
Memory Files Queries Time
2,152 (7,855,352) 0 (694) 0 (300) 0.0000 (0.7957)
[Block] [sign in desktop] Render end
Memory Files Queries Time
83,128 (7,938,480) 1 (695) 0 (300) 0.0004 (0.7961)
[Block] [Cart] Render begin
Memory Files Queries Time
11,864 (7,950,344) 0 (695) 0 (300) 0.0001 (0.7962)
[Block] [Cart] Render end
Memory Files Queries Time
25,696 (7,976,040) 0 (695) 0 (300) 0.0002 (0.7964)
[Block] [Desktop My Account Navigation] Render begin
Memory Files Queries Time
2,168 (7,978,208) 0 (695) 0 (300) 0.0000 (0.7964)
[Block] [Desktop My Account Navigation] Render end
Memory Files Queries Time
32,840 (8,011,048) 1 (696) 0 (300) 0.0006 (0.7970)
[Block] [wishlist_2bk] Render begin
Memory Files Queries Time
2,152 (8,013,200) 0 (696) 0 (300) 0.0000 (0.7970)
[Block] [wishlist_2bk] Render end
Memory Files Queries Time
30,360 (8,043,560) 1 (697) 0 (300) 0.0003 (0.7973)
[Block] [search_bt] Render begin
Memory Files Queries Time
2,152 (8,045,712) 0 (697) 0 (300) 0.0000 (0.7973)
[Block] [search_bt] Render end
Memory Files Queries Time
25,128 (8,070,840) 0 (697) 0 (300) 0.0002 (0.7975)
[Block] [Community Page Button] Render begin
Memory Files Queries Time
2,168 (8,073,008) 0 (697) 0 (300) 0.0000 (0.7975)
[Block] [Community Page Button] Render end
Memory Files Queries Time
50,664 (8,123,672) 1 (698) 0 (300) 0.0002 (0.7978)
[Block] [main menu desktop] Render begin
Memory Files Queries Time
68,920 (8,192,592) 1 (699) 0 (300) 0.0003 (0.7981)
[Block] [main menu desktop] Render end
Memory Files Queries Time
5,954,552 (14,147,144) 31 (730) 302 (602) 0.0987 (0.8968)
[Block] [Search_Category] Render begin
Memory Files Queries Time
200,736 (14,347,880) 0 (730) 0 (602) 0.0004 (0.8972)
[Block] [Search_Category] Render end
Memory Files Queries Time
10,136 (14,358,016) 1 (731) 0 (602) 0.0005 (0.8977)
[Block] [coupon code strip for all pids] Render begin
Memory Files Queries Time
-88,952 (14,269,064) 1 (732) 0 (602) 0.0009 (0.8986)
[Block] [coupon code strip for all pids] Render end
Memory Files Queries Time
84,856 (14,353,920) 1 (733) 2 (604) 0.0010 (0.8996)
[Block] [Owl Carousel JS] Render begin
Memory Files Queries Time
2,528 (14,356,448) 0 (733) 0 (604) 0.0001 (0.8996)
[Block] [Owl Carousel JS] Render end
Memory Files Queries Time
65,304 (14,421,752) 1 (734) 4 (608) 0.0072 (0.9069)
[Block] [temporary css fixing] Render begin
Memory Files Queries Time
2,168 (14,423,920) 0 (734) 0 (608) 0.0000 (0.9069)
[Block] [temporary css fixing] Render end
Memory Files Queries Time
33,048 (14,456,968) 1 (735) 0 (608) 0.0003 (0.9073)
[Block] [Main Content] Render begin
Memory Files Queries Time
30,560 (14,487,528) 0 (735) 0 (608) 0.0002 (0.9074)
[Block] [Main Content] Render end
Memory Files Queries Time
61,577,176 (76,064,704) 114 (849) 2519 (3127) 2.2600 (3.1674)
[Block] [PDP AI Suggestions Block] Render begin
Memory Files Queries Time
10,736 (76,075,440) 0 (849) 0 (3127) 0.0025 (3.1699)
[Block] [PDP AI Suggestions Block] Render end
Memory Files Queries Time
47,056 (76,122,496) 1 (850) 1 (3128) 0.0013 (3.1712)
[Block] [Compare with similar items] Render begin
Memory Files Queries Time
14,664 (76,137,160) 0 (850) 0 (3128) 0.0019 (3.1731)
[Block] [Compare with similar items] Render end
Memory Files Queries Time
41,888 (76,179,048) 3 (853) 0 (3128) 0.0004 (3.1736)
[Block] [Similar Products] Render begin
Memory Files Queries Time
23,296 (76,202,344) 0 (853) 0 (3128) 0.0038 (3.1773)
[Block] [Similar Products] Render end
Memory Files Queries Time
7,874,256 (84,076,600) 4 (857) 388 (3516) 2.3555 (5.5328)
[Block] [recently viewed product by user] Render begin
Memory Files Queries Time
9,064 (84,085,664) 0 (857) 0 (3516) 0.0023 (5.5351)
[Block] [recently viewed product by user] Render end
Memory Files Queries Time
109,008 (84,194,672) 1 (858) 1 (3517) 0.0008 (5.5359)
[Block] [cp video css] Render begin
Memory Files Queries Time
2,152 (84,196,824) 0 (858) 0 (3517) 0.0000 (5.5359)
[Block] [cp video css] Render end
Memory Files Queries Time
85,336 (84,282,160) 1 (859) 0 (3517) 0.0002 (5.5362)
End render location
Memory Files Queries Time
-193,776 (84,088,384) 0 (859) 0 (3517) 0.0011 (5.5373)
After TPL
Memory Files Queries Time
691,544 (84,779,928) 19 (878) 6 (3523) 0.0210 (5.5583)