Plugin Debug - SortInStock Observer - 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
| Position | ID | SKU | Stock Status |
|---|---|---|---|
| 1 | 166 | 273007820002 | 1 |
| 2 | 167 | 273007820005 | 1 |
| 3 | 174 | 254107820031 | 1 |
| 4 | 178 | 254107820025 | 1 |
| 5 | 179 | 197100410004 | 1 |
| 6 | 183 | 254107820019 | 1 |
| 7 | 186 | 019700410031 | 1 |
| 8 | 188 | 019707820012 | 1 |
| 9 | 190 | 019707820005 | 1 |
| 10 | 191 | 019707820010 | 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 (166, 167, 174, 178, 179, 183, 186, 188, 190, 191, 198, 200, 201, 203, 204, 205, 2063, 184, 170, 176, 169, 172, 193, 192, 182, 181)) ORDER BY FIELD(e.entity_id,166,167,174,178,179,183,186,188,190,191,198,200,201,203,204,205,2063,184,170,176,169,172,193,192,182,181)
ORDER BY Clauses:
Total ORDER BY clauses: 1 Order #1: FIELD(e.entity_id,166,167,174,178,179,183,186,188,190,191,198,200,201,203,204,205,2063,184,170,176,169,172,193,192,182,181)
Stock Distribution (Total: 26 products):
Stock Status "1": 16 products
Stock Status "0": 10 products
Product Samples:
| Pos | ID | SKU | Name | Stock |
|---|---|---|---|---|
| 1 | 166 | 273007820002 | Seed Feeder Bird Bath Cast Iron Wall Mou | 1 (IN STOCK) |
| 2 | 167 | 273007820005 | Hanging Heart Shaped Love Bird Feeder Or | 1 (IN STOCK) |
| 3 | 174 | 254107820031 | Wall Shelf Bracket Ornate Vine Distresse | 1 (IN STOCK) |
| 4 | 178 | 254107820025 | Decorative Wall Shelf Bracket Simple Vin | 1 (IN STOCK) |
| 5 | 179 | 197100410004 | Wall Shelf Bracket - Ornate Pattern - Bl | 1 (IN STOCK) |
| 6 | 183 | 254107820019 | Shelf Bracket Brace For Custom Shelving | 1 (IN STOCK) |
| 7 | 186 | 019700410031 | Cast Iron Wall Hook Verdigris Seahorse 5 | 1 (IN STOCK) |
| 8 | 188 | 019707820012 | Decorative Coat Hook Victorian Ornate Do | 1 (IN STOCK) |
| 9 | 190 | 019707820005 | Wall Hook Coat Rack Victorian Skeleton K | 1 (IN STOCK) |
| 10 | 191 | 019707820010 | Decorative Triple Wall Hook Cast Iron Co | 1 (IN STOCK) |
| 11 | 198 | 930907820006 | Cast Iron Dinner Bell Love Birds Distres | 1 (IN STOCK) |
| 12 | 200 | 930907820001 | Cast Iron Dinner Bell Moose Welcome Sign | 1 (IN STOCK) |
| 13 | 201 | 930907820007 | Cast Iron Dinner Bell Ornate Vine Doorbe | 1 (IN STOCK) |
| 14 | 203 | 930907820005 | Cast Iron Dinner Bell Butterfly Floral V | 1 (IN STOCK) |
| 15 | 204 | 930907820004 | Cast Iron Dinner Bell Green Farm Tractor | 1 (IN STOCK) |
| 16 | 205 | 930907820008 | Cast Iron Dinner Bell Rooster & Flowers | 0 (OUT OF STOCK) |
| 17 | 2063 | 286391557901 | Fitbit Sense 2 Health and Fitness Smartw | 1 (IN STOCK) |
| 18 | 184 | 254107820026 | Cast Iron Wall Shelf Bracket Brace Colum | 0 (OUT OF STOCK) |
| 19 | 170 | 012600410004 | Wall Shelf Bracket Leaf Vine Pattern Cas | 0 (OUT OF STOCK) |
| 20 | 176 | 254107820004 | Cast Iron Wall Shelf Bracket Brace Vine | 0 (OUT OF STOCK) |
| 21 | 169 | 254007820000 | Wall Shelf Bracket Decorative Cast Iron | 0 (OUT OF STOCK) |
| 22 | 172 | 254107820029 | Wall Shelf Bracket Brace Ornate Vine Bro | 0 (OUT OF STOCK) |
| 23 | 193 | 019707820013 | Double Wall Hook Decorative Antique Styl | 0 (OUT OF STOCK) |
| 24 | 192 | 019707820021 | Cast Iron Wall Hook Rack Tropical Fish & | 0 (OUT OF STOCK) |
| 25 | 182 | 254107820018 | Decorative Shelf Bracket - Hexagon Latti | 0 (OUT OF STOCK) |
| 26 | 181 | 254107820016 | Decorative Shelf Bracket - Ornate Lattic | 0 (OUT OF STOCK) |
Its too late afterGetLoadedProductCollection
