Not Loaded Yet
Plugin Debug - afterGetLoadedProductCollection - Collection Data:
Collection loaded: NO
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` 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 ORDER BY `stock`.`stock_status` DESC, FIELD(e.entity_id, ...) DESC
| Position | ID | SKU | Stock Status |
|---|---|---|---|
| 1 | 16 | 254007820004 | 1 |
| 2 | 17 | 254007820007 | 1 |
| 3 | 24 | 254107820001 | 1 |
| 4 | 759 | 286251193844 | 1 |
| 5 | 760 | 286251207844 | 1 |
| 6 | 762 | 286251265340 | 1 |
| 7 | 764 | 276816918998 | 0 |
| 8 | 770 | 276821346666 | 0 |
| 9 | 773 | 273407820003 | 1 |
| 10 | 774 | 273907820001 | 0 |
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 (16, 17, 24, 759, 760, 762, 764, 770, 773, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 787, 788, 792, 793, 794)) ORDER BY FIELD(e.entity_id,16,17,24,759,760,762,764,770,773,774,775,776,777,778,779,780,781,782,783,784,785,787,788,792,793,794)
ORDER BY Clauses:
Total ORDER BY clauses: 1 Order #1: FIELD(e.entity_id,16,17,24,759,760,762,764,770,773,774,775,776,777,778,779,780,781,782,783,784,785,787,788,792,793,794)
Stock Distribution (Total: 26 products):
Stock Status "1": 16 products
Stock Status "0": 10 products
Product Samples:
| Pos | ID | SKU | Name | Stock |
|---|---|---|---|---|
| 1 | 16 | 254007820004 | Wall Shelf Bracket Brace Fleur De Lis Ve | 1 (IN STOCK) |
| 2 | 17 | 254007820007 | Fleur De Lis Wall Shelf Bracket Cast Iro | 1 (IN STOCK) |
| 3 | 24 | 254107820001 | Decorative Angle Bracket Cast Iron Shelf | 1 (IN STOCK) |
| 4 | 759 | 286251193844 | Isotoner Genuine Suede Women's Moccasin | 1 (IN STOCK) |
| 5 | 760 | 286251207844 | Dearfoams Women's Shearling Scuff Slippe | 1 (IN STOCK) |
| 6 | 762 | 286251265340 | Dearfoams Women's Pumpkin Slide Slippers | 1 (IN STOCK) |
| 7 | 764 | 276816918998 | Dearfoams Men's Shearling Side Stitch Mo | 0 (OUT OF STOCK) |
| 8 | 770 | 276821346666 | Dearfoams Women's Pumpkin Slide Slippers | 0 (OUT OF STOCK) |
| 9 | 773 | 273407820003 | Heart Shaped Trivet Ornate Decorative Ca | 1 (IN STOCK) |
| 10 | 774 | 273907820001 | Decorative Cast Iron Trivet Owl Hot Pad | 0 (OUT OF STOCK) |
| 11 | 775 | 273407820005 | Square Trivet Black Cast Iron Decorative | 1 (IN STOCK) |
| 12 | 776 | 273407820001 | Decorative Cast Iron Trivet Ornate Heart | 0 (OUT OF STOCK) |
| 13 | 777 | 273407820002 | Cast Iron Trivet Round Ornate Heart Scro | 0 (OUT OF STOCK) |
| 14 | 778 | 203707820002 | Decorative Cast Iron Fish Trivet Kitchen | 1 (IN STOCK) |
| 15 | 779 | 203707820001 | Tea Kettle Trivet Ornate Decorative Cast | 1 (IN STOCK) |
| 16 | 780 | 203707820000 | Decorative Cast Iron Trivet Chilli Peppe | 0 (OUT OF STOCK) |
| 17 | 781 | 274207820000 | Cast Iron Nautical Anchor Trivet Hot Pla | 1 (IN STOCK) |
| 18 | 782 | 229207820000 | Decorative Sitting Green Frog Stepping S | 1 (IN STOCK) |
| 19 | 783 | 237107820001 | Decorative Welcome Stepping Stone Plaque | 1 (IN STOCK) |
| 20 | 784 | 266107820000 | Welcome To My Garden Hummingbird Steppin | 1 (IN STOCK) |
| 21 | 785 | 272507820003 | Heart & Foot Prints Welcome Plaque Cast | 0 (OUT OF STOCK) |
| 22 | 787 | 229207820002 | Decorative Cast Iron Yard & Garden Stepp | 1 (IN STOCK) |
| 23 | 788 | 246407820002 | LARGE Turtle Stepping Stone Paver Decora | 0 (OUT OF STOCK) |
| 24 | 792 | 246407820003 | Decorative Baby Turtles Stepping Stone R | 1 (IN STOCK) |
| 25 | 793 | 269907820001 | Butterfly Stepping Stone Verdigris Cast | 0 (OUT OF STOCK) |
| 26 | 794 | IWSTS0018 | Cast Iron Footprint Stepping Stones - Ga | 0 (OUT OF STOCK) |
