1. SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_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 (?:categories.usergroup_ids = '' OR FIND_IN_SET(0, ?:categories.usergroup_ids) OR FIND_IN_SET(1, ?:categories.usergroup_ids)) AND ?:categories.status IN ('A', 'H')   WHERE 1  AND ?:categories.category_id IN (1157, 1028, 1029, 1030, 1032, 1037, 1041, 1635) AND companies.status = 'A' AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.amount != '0' AND products.parent_product_id = 0 AND products.product_type != 'D' GROUP BY products.product_id   ORDER BY products.timestamp desc, products.product_id ASC  LIMIT 0, 21
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
                [3] => categories
                [4] => description
                [5] => companies
            )
    
        [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] => 21
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [dispatch] => categories.view
        [category_id] => 1157
        [save_view_results] => product_id
        [cid] => 1157
        [subcats] => Y
        [sort_by] => timestamp
        [sort_order] => desc
        [include_child_variations] => 
        [group_child_variations] => 
        [parent_product_id] => 0
        [sort_order_rev] => asc
    )
    
    
  1. Array
    (
        [0] => Array
            (
                [product_id] => 79913
                [product] => Nicer Dicer Plus Speedy Chopper
                [company_name] => tpw family
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [1] => Array
            (
                [product_id] => 76565
                [product] => KENWOOD SMOOTHIE - HIGH QUALITY
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [2] => Array
            (
                [product_id] => 76564
                [product] => Kenwood Toaster - High Quality
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [3] => Array
            (
                [product_id] => 76563
                [product] => Kenwood Blender - High Quality
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [4] => Array
            (
                [product_id] => 76562
                [product] => Kenwood Blender - High Quality - 850W
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [5] => Array
            (
                [product_id] => 76561
                [product] => kenwood Blender - 450w - High Quality
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [6] => Array
            (
                [product_id] => 76559
                [product] => Quad Blade Mini Chopper CH250
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [7] => Array
            (
                [product_id] => 76521
                [product] => Kenwood Blender BLP-302
                [company_name] => KENWOOD
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [8] => Array
            (
                [product_id] => 75851
                [product] => Chop Slicer For Vegetables
                [company_name] => tpw family
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [9] => Array
            (
                [product_id] => 75634
                [product] => High Quality Handheld Electric Mini Coffee Beater Mini Electric Egg Beater Whisk Stirrer Milk Coffee Mixer and Hand Blender
                [company_name] => Ameer alam
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [10] => Array
            (
                [product_id] => 75633
                [product] => Hand Pressing Grinder Ginger Garlic Onion Cutting Tool Grinding Machine Onion Chopper Kitchen Accessories 1 Piece
                [company_name] => Ameer alam
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [11] => Array
            (
                [product_id] => 75632
                [product] => Nicer Dicer Plus speedy chopper 12 pieces | Fruit And Vegetable Cutter , Salad Slicer ,Mini Speedy Chopper, quick fruit peeler, graters, kitchen utensils, potato fruit chopper/large container
                [company_name] => Ameer alam
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [12] => Array
            (
                [product_id] => 74363
                [product] => Easy Apple Peeler Plastic Body
                [company_name] => Arham Ali Traders
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [13] => Array
            (
                [product_id] => 74364
                [product] => Stainless Steel Garlic Press Metal Ginger Garlic Chopper Crusher Garlic Cutter Creative Hand Press Garlic Tools Kitchen Gadgets
                [company_name] => Arham Ali Traders
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [14] => Array
            (
                [product_id] => 72694
                [product] => USB Rechargeable Juicer Blender 6 Blades | Juicer Blender Machine | USB Rechargeable Mixer 380ml
                [company_name] => My Tele Shop
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [15] => Array
            (
                [product_id] => 72346
                [product] => Speedy Chopper 3 Blades
                [company_name] => NM Smart Gadgets
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [16] => Array
            (
                [product_id] => 72079
                [product] => Vegetable Slicer Steel ( Pack Of 3)
                [company_name] => NM Smart Gadgets
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [17] => Array
            (
                [product_id] => 72031
                [product] => 5in1 Chopper Nowake
                [company_name] => NM Smart Gadgets
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [18] => Array
            (
                [product_id] => 70841
                [product] => Chopper Nowake 5in1
                [company_name] => MS collection
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [19] => Array
            (
                [product_id] => 70241
                [product] => Mini Food Chopper Manual
                [company_name] => MS collection
                [product_type] => P
                [parent_product_id] => 0
            )
    
        [20] => Array
            (
                [product_id] => 70239
                [product] => Mini Juicer  Rechargeable USB Blender Mixer Portable
                [company_name] => MS collection
                [product_type] => P
                [parent_product_id] => 0
            )
    
    )