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 (911, 14, 15, 18, 25, 27, 410, 415, 416, 554, 729, 752, 900, 901, 916, 951, 953, 1573, 1634, 1653, 1654, 1657, 1661, 1676, 1677, 1678, 1679, 1681, 1682, 1686, 1690, 1693, 1699, 1700, 1701, 1703, 1704, 1705, 1706, 1708, 1709, 1710, 1711, 1712, 1714, 1716, 1720, 1721, 1722, 1723, 1724, 1726, 1727, 1728, 1729, 1730, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1750, 1751, 1752, 1754, 1755, 1756, 1758, 1760, 1763, 1764, 1868, 1872, 1873, 1874, 1875, 1876, 1877, 1879, 1880, 1882, 1941, 1942, 1969, 1989)) ORDER BY FIELD(e.entity_id,911,14,15,18,25,27,410,415,416,554,729,752,900,901,916,951,953,1573,1634,1653,1654,1657,1661,1676,1677,1678,1679,1681,1682,1686,1690,1693,1699,1700,1701,1703,1704,1705,1706,1708,1709,1710,1711,1712,1714,1716,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1750,1751,1752,1754,1755,1756,1758,1760,1763,1764,1868,1872,1873,1874,1875,1876,1877,1879,1880,1882,1941,1942,1969,1989)
Position | ID | SKU | Stock Status |
---|---|---|---|
1 | 911 | 286297875467 | 0 |
2 | 14 | 254107820000 | 1 |
3 | 15 | 254107820020 | 1 |
4 | 18 | 254107820017 | 1 |
5 | 25 | 254007820010 | 1 |
6 | 27 | 254107820028 | 1 |
7 | 410 | 276793574596 | 0 |
8 | 415 | 276793633196 | 0 |
9 | 416 | 286234217652 | 1 |
10 | 554 | 286254844708 | 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 (911, 14, 15, 18, 25, 27, 410, 415, 416, 554, 729, 752, 900, 901, 916, 951, 953, 1573, 1634, 1653, 1654, 1657, 1661, 1676, 1677, 1678, 1679, 1681, 1682, 1686, 1690, 1693, 1699, 1700, 1701, 1703, 1704, 1705, 1706, 1708, 1709, 1710, 1711, 1712, 1714, 1716, 1720, 1721, 1722, 1723, 1724, 1726, 1727, 1728, 1729, 1730, 1731, 1732, 1733, 1734, 1735, 1736, 1737, 1738, 1739, 1740, 1741, 1742, 1743, 1744, 1750, 1751, 1752, 1754, 1755, 1756, 1758, 1760, 1763, 1764, 1868, 1872, 1873, 1874, 1875, 1876, 1877, 1879, 1880, 1882, 1941, 1942, 1969, 1989)) ORDER BY FIELD(e.entity_id,911,14,15,18,25,27,410,415,416,554,729,752,900,901,916,951,953,1573,1634,1653,1654,1657,1661,1676,1677,1678,1679,1681,1682,1686,1690,1693,1699,1700,1701,1703,1704,1705,1706,1708,1709,1710,1711,1712,1714,1716,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1750,1751,1752,1754,1755,1756,1758,1760,1763,1764,1868,1872,1873,1874,1875,1876,1877,1879,1880,1882,1941,1942,1969,1989)
ORDER BY Clauses:
Total ORDER BY clauses: 1 Order #1: FIELD(e.entity_id,911,14,15,18,25,27,410,415,416,554,729,752,900,901,916,951,953,1573,1634,1653,1654,1657,1661,1676,1677,1678,1679,1681,1682,1686,1690,1693,1699,1700,1701,1703,1704,1705,1706,1708,1709,1710,1711,1712,1714,1716,1720,1721,1722,1723,1724,1726,1727,1728,1729,1730,1731,1732,1733,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743,1744,1750,1751,1752,1754,1755,1756,1758,1760,1763,1764,1868,1872,1873,1874,1875,1876,1877,1879,1880,1882,1941,1942,1969,1989)
Stock Distribution (Total: 94 products):
Stock Status "0": 68 products
Stock Status "1": 26 products
Product Samples:
Pos | ID | SKU | Name | Stock |
---|---|---|---|---|
1 | 911 | 286297875467 | Wireless Meat Thermometer Meater Plus Di | 0 (OUT OF STOCK) |
2 | 14 | 254107820000 | Wall Shelf Bracket Decorative Cast Iron | 1 (IN STOCK) |
3 | 15 | 254107820020 | Wall Shelf Bracket Brace With Plant Hang | 1 (IN STOCK) |
4 | 18 | 254107820017 | Decorative Cast Iron Wall Shelf Bracket | 1 (IN STOCK) |
5 | 25 | 254007820010 | Wall Shelf Bracket Cast Iron Brace Fleur | 1 (IN STOCK) |
6 | 27 | 254107820028 | Wall Shelf Bracket Distressed Brown Orna | 1 (IN STOCK) |
7 | 410 | 276793574596 | Women's Marsha Ankle Boots Zip Up Pointe | 0 (OUT OF STOCK) |
8 | 415 | 276793633196 | Women's Chunky Heel Boots - Dolly Black | 0 (OUT OF STOCK) |
9 | 416 | 286234217652 | Women's Boots with Memory Foam Insole - | 1 (IN STOCK) |
10 | 554 | 286254844708 | Dr. Scholl's Laurel Womens Ankle Bootie | 1 (IN STOCK) |
11 | 729 | 276821288981 | Women's Pippa Stretch Ankle Boots Taupe | 0 (OUT OF STOCK) |
12 | 752 | 276822613745 | Joybees Men's Chance Clogs Gray Sz 7 Sli | 0 (OUT OF STOCK) |
13 | 900 | 286295192457 | Bearpaw Retro Super Shorty Size 4 Youth | 1 (IN STOCK) |
14 | 901 | 286294130286 | Traeger Timberline Outdoor Kitchen Trim | 1 (IN STOCK) |
15 | 916 | 276841802932 | Otterbox Elevation 20 Tumbler Thermal Li | 0 (OUT OF STOCK) |
16 | 951 | 273407820004 | Decorative Trivet Square Cast Iron Hot P | 1 (IN STOCK) |
17 | 953 | 257407650009 | Real Sand Castle Figurine 118 4" Tall Co | 0 (OUT OF STOCK) |
18 | 1573 | 276833228749 | Journee Collection Womens Livvy Back Hee | 0 (OUT OF STOCK) |
19 | 1634 | 276860115393 | Women's Diana Buckle Mule Heels Black SZ | 0 (OUT OF STOCK) |
20 | 1653 | 276884002210 | JBL Tune 230NC TWS Earbuds Blue Bluetoot | 0 (OUT OF STOCK) |
21 | 1654 | 276889348003 | dearfoams Kids' Good Vibes Slide Slipper | 0 (OUT OF STOCK) |
22 | 1657 | 276912425839 | Apple EarPods with 3.5mm Plug – Wired | 0 (OUT OF STOCK) |
23 | 1661 | 276912562408 | OtterBox Shaker Lid For Elevation 20 1.5 | 0 (OUT OF STOCK) |
24 | 1676 | 276920455864 | Women's Alexa Flare Heel Pumps Black SZ | 0 (OUT OF STOCK) |
25 | 1677 | 820107820015 | Ornate Garden Hose Holder - Heavy Duty M | 0 (OUT OF STOCK) |
26 | 1678 | 930907820002 | Rustic Cast Iron Welcome Bell Vintage Wa | 0 (OUT OF STOCK) |
27 | 1679 | 276928818201 | Allegra K Women's T Strap Open Toe Platf | 0 (OUT OF STOCK) |
28 | 1681 | 276928972258 | Fitbit Versa 4 Fitness Smartwatch FB523B | 1 (IN STOCK) |
29 | 1682 | 276931109905 | Women's Mel Rhinestone Mesh Ballet Flats | 0 (OUT OF STOCK) |
30 | 1686 | 276939078249 | Victrola Re-Spin Suitcase Vinyl Record P | 0 (OUT OF STOCK) |
31 | 1690 | 254107820030 | Wall Shelf Bracket Ornate Scroll White C | 0 (OUT OF STOCK) |
32 | 1693 | 276955627052 | Women's Marcia Lace up Heels with Memory | 0 (OUT OF STOCK) |
33 | 1699 | 276966958927 | Heyday Silicone Phone Case for iPhone 12 | 0 (OUT OF STOCK) |
34 | 1700 | 276967399530 | Funko Mini Moments: Marvel - Jennifer & | 0 (OUT OF STOCK) |
35 | 1701 | 276969248621 | UNOS BY SZ Adult Sneakers - Gray 8-9 | 0 (OUT OF STOCK) |
36 | 1703 | 273107820002-1 | Nautical Ship Anchor Cast Iron Shelf Bra | 0 (OUT OF STOCK) |
37 | 1704 | 273107820002 | Nautical Ship Anchor Cast Iron Shelf Bra | 0 (OUT OF STOCK) |
38 | 1705 | 254107820003-1 | Wall Shelf Bracket Cast Iron Brace Vine | 0 (OUT OF STOCK) |
39 | 1706 | 272607820008 | S-Hook Plant Hanger Flower Basket Decor | 0 (OUT OF STOCK) |
40 | 1708 | 276981428196 | WWE Elite Collection Undertaker Figure - | 0 (OUT OF STOCK) |
41 | 1709 | 276983831741 | Rocketfish 8k Ultra High Speed 15ft HDMI | 0 (OUT OF STOCK) |
42 | 1710 | 276983911682 | Rocketfish - 12' 4K UltraHD/HDR In-Wall | 0 (OUT OF STOCK) |
43 | 1711 | 276983927536 | Sanus BSA-IWP1-W1 In-Wall Cable Conceale | 0 (OUT OF STOCK) |
44 | 1712 | 276983994123 | Sanus - On-Wall Cable Concealer High Cap | 0 (OUT OF STOCK) |
45 | 1714 | 276987123754 | Helios In-Wall Power Outlet Relocation K | 0 (OUT OF STOCK) |
46 | 1716 | 276987506055 | Women's Shannon Heels with Memory Foam I | 0 (OUT OF STOCK) |
47 | 1720 | 254107820007 | Ornate Cast Iron Shelf Bracket Decorativ | 0 (OUT OF STOCK) |
48 | 1721 | 276992410457 | Mcfarlane Batman DC Retro 66 Classics TV | 0 (OUT OF STOCK) |
49 | 1722 | 276992464944 | McFarlane DC Retro 66 Classic TV Series | 0 (OUT OF STOCK) |
50 | 1723 | 276992467087 | Hasbro Star Wars George Lucas Stormtroop | 0 (OUT OF STOCK) |
51 | 1724 | 246407820001 | 13" Brown Cast Iron Turtle Stepping Ston | 0 (OUT OF STOCK) |
52 | 1726 | 272907820017 | Unicorn Garden Flag Rainbow Yard Banner | 0 (OUT OF STOCK) |
53 | 1727 | 019700410046 | Cast Iron Wall Hook Rack Fish Bone Skele | 0 (OUT OF STOCK) |
54 | 1728 | 274007820000 | Slow Down Garden Flag Caution Children A | 1 (IN STOCK) |
55 | 1729 | 261207820000 | Funny Aluminum Sign No Poop Heads Allowe | 0 (OUT OF STOCK) |
56 | 1730 | 273207820013 | Don't Be A Poop Head Emoji Clean Up Afte | 0 (OUT OF STOCK) |
57 | 1731 | 000007830114 | NASCAR Kasey Kahne Wall Appliques Decal | 0 (OUT OF STOCK) |
58 | 1732 | 000000410068 | Disney Princess Self Stick Removable App | 0 (OUT OF STOCK) |
59 | 1733 | 272907820015 | Thankful Grateful Blessed Fall Leaves Ga | 0 (OUT OF STOCK) |
60 | 1734 | 163807820003 | Aluminum Sign Firemans Cross White Firef | 0 (OUT OF STOCK) |
61 | 1735 | 273807820002 | Welcome American Garden Flag Emotes Doub | 0 (OUT OF STOCK) |
62 | 1736 | 322207820000 | Fish Pocket Beer Bottle Opener Handheld | 0 (OUT OF STOCK) |
63 | 1737 | 273707820003 | Happy Easter Spring Flowers Birds Garden | 0 (OUT OF STOCK) |
64 | 1738 | 273007820003 | Cast Iron Pedestal Bird Feeder Bath 8" W | 0 (OUT OF STOCK) |
65 | 1739 | 930907820000 | Cast Iron Horse Dinner Bell – Rustic B | 0 (OUT OF STOCK) |
66 | 1740 | 142307820000 | Aluminum Sign Coffee Cappuccino Mocha Es | 0 (OUT OF STOCK) |
67 | 1741 | 277012444440 | New Brielle Home Cotton Jersey Knit (T-S | 0 (OUT OF STOCK) |
68 | 1742 | 277015134596 | CyberPower 1000VA UPS Battery Backup Sur | 0 (OUT OF STOCK) |
69 | 1743 | 322207820002 | Wall Mounted Skull Beer Bottle Opener Ca | 0 (OUT OF STOCK) |
70 | 1744 | 261207820002 | Funny Aluminum Sign No Poop Heads Allowe | 0 (OUT OF STOCK) |
71 | 1750 | 277025938599 | Yardbird Fire Table Cover CVFTRERB Recta | 0 (OUT OF STOCK) |
72 | 1751 | 277029661358 | Barbie Toy Wall Stickers Girls Bedroom D | 0 (OUT OF STOCK) |
73 | 1752 | 277032581994 | CyberPower 1500VA Battery Back-Up System | 0 (OUT OF STOCK) |
74 | 1754 | 277036995257 | Sanus BSA-IWP701-W1 In-Wall Power Kit AV | 0 (OUT OF STOCK) |
75 | 1755 | 277037180702 | SaharaCase - Office Mouse Pad with Wirel | 0 (OUT OF STOCK) |
76 | 1756 | 277037812053 | Genuine Amazon Alexa Voice Remote (3rd G | 0 (OUT OF STOCK) |
77 | 1758 | 277039604836 | Nick JR Dora The Explorer Wall Sticker D | 0 (OUT OF STOCK) |
78 | 1760 | 277040873020 | Computer Chair Floor Mat 30 x 48 inches | 0 (OUT OF STOCK) |
79 | 1763 | 277046740996 | Simpli Home Grafton Round Pouf 20" x 20" | 0 (OUT OF STOCK) |
80 | 1764 | 277047254859 | 10" Twin Intex Standard Dura-Beam Airbed | 0 (OUT OF STOCK) |
81 | 1868 | 198507820002 | Flamingo Welcome Plaque Brown Cast Iron | 1 (IN STOCK) |
82 | 1872 | 272207820000 | Large Rolling Plant Caddy Fleur De Lis | 1 (IN STOCK) |
83 | 1873 | 273607820000 | Decorative Cast Iron Rooster Trivet Kitc | 1 (IN STOCK) |
84 | 1874 | 197107820000 | Turtle Hide A Key Box Distressed Brown C | 1 (IN STOCK) |
85 | 1875 | 284109859464 | Disney’s Baby Mickey Mouse Wall Border | 1 (IN STOCK) |
86 | 1876 | 229207820004 | Cast Iron Plaque Sign - Beware Of The Do | 1 (IN STOCK) |
87 | 1877 | 284292040564 | Baby Einstein Four Fundamentals 5 Develo | 1 (IN STOCK) |
88 | 1879 | 284965973493 | vintage Cracker Jack prize charm Seagram | 1 (IN STOCK) |
89 | 1880 | 285024495455 | Please Close The Gate Cast Iron Plaque S | 1 (IN STOCK) |
90 | 1882 | TGLSPG0001 | Electric Salt & Pepper Grinder Set - Adj | 1 (IN STOCK) |
91 | 1941 | 286287688602 | Allegra K Women's Back to College Faux S | 1 (IN STOCK) |
92 | 1942 | 286287784729 | Women's Devin Two Band Footbed Sandals B | 1 (IN STOCK) |
93 | 1969 | 286290556641 | Dr. Scholl's Women's Janette Slip Resist | 1 (IN STOCK) |
94 | 1989 | 286292297452 | Men's Joshua Slide Sandals Tan 8 Unworn | 1 (IN STOCK) |