Home & Garden

Not Loaded Yet

Plugin Debug - Collection Data:

Collection loaded: YES

SQL:

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock`.`stock_status`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 LEFT JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id AND stock.website_id = 0
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (270, 268, 272, 273, 269, 271, 274)) ORDER BY FIELD(e.entity_id,270,268,272,273,269,271,274)

Position	ID	SKU	Stock Status
1	270	255707820019	0
2	268	255707820011	1
3	272	272607820002	1
4	273	255707820014	1
5	269	255707820009	0
6	271	272607820009	0
7	274	272607820006	1

InstockProductsFirst Debug
        SQL Query:
        SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock`.`stock_status`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
 LEFT JOIN `cataloginventory_stock_status` AS `stock` ON e.entity_id = stock.product_id AND stock.website_id = 0
 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN (270, 268, 272, 273, 269, 271, 274)) ORDER BY FIELD(e.entity_id,270,268,272,273,269,271,274)

    

        ORDER BY Clauses:
        Total ORDER BY clauses: 1

Order #1: FIELD(e.entity_id,270,268,272,273,269,271,274)

    
Stock Distribution (Total: 7 products):Stock Status "0": 3 products
Stock Status "1": 4 products

        Product Samples:
        
            
                Pos
                ID
                SKU
                Name
                Stock
            

                1
                270
                255707820019
                Cast Iron Plant Hanger Hook Butterflies 
                
                    0 (OUT OF STOCK)                
            

                2
                268
                255707820011
                Butterfly Plant Hanger Bracket Flower Po
                
                    1 (IN STOCK)                
            

                3
                272
                272607820002
                Plant Hanger Hanging Pot Flower Basket H
                
                    1 (IN STOCK)                
            

                4
                273
                255707820014
                Chickadee Bird S Style Plant Hook Cast I
                
                    1 (IN STOCK)                
            

                5
                269
                255707820009
                Cast Iron S Style Plant Hook Colorful Bi
                
                    0 (OUT OF STOCK)                
            

                6
                271
                272607820009
                Decorative Plant Hanger Curly Vine Brown
                
                    0 (OUT OF STOCK)                
            

                7
                274
                272607820006
                Rose Flower Bloom S Style Plant Hook Cas
                
                    1 (IN STOCK)                
            

    

Pos	ID	SKU	Name	Stock
1	270	255707820019	Cast Iron Plant Hanger Hook Butterflies	0 (OUT OF STOCK)
2	268	255707820011	Butterfly Plant Hanger Bracket Flower Po	1 (IN STOCK)
3	272	272607820002	Plant Hanger Hanging Pot Flower Basket H	1 (IN STOCK)
4	273	255707820014	Chickadee Bird S Style Plant Hook Cast I	1 (IN STOCK)
5	269	255707820009	Cast Iron S Style Plant Hook Colorful Bi	0 (OUT OF STOCK)
6	271	272607820009	Decorative Plant Hanger Curly Vine Brown	0 (OUT OF STOCK)
7	274	272607820006	Rose Flower Bloom S Style Plant Hook Cas	1 (IN STOCK)